<div class="row">
    <div class="col-sm-12">
        <p><a href="<?= base_url('admin/dashboard'); ?>"><i class="fa fa-arrow-left" aria-hidden="true"></i> Back to Dashboard</a></p><br>
        <h2>Solution Category Administration</h2>
        <?= $this->session->flashdata('success'); //to display success message ?> 
        <?= $this->session->flashdata('result'); //to display result message ?> 
    </div>
</div>  

<div class="row">
    <div class="col-sm-12">
        <br>
        <p><?= anchor('admin/solution_categories/add', '<i class="fa fa-plus" aria-hidden="true"></i> ADD A NEW CATEGORY'); ?></p> 
    </div>
</div>    

<div class="row">
    <div class="col-sm-12">
       <div class="table-responsive">  
       <table class="table table-striped">
        <thead> 
            <tr>
                <th>Category Name</th> 
                <th>Parent Category</th> 
                <th>Ordering</th>
                <th>Display</th>
                <th>View</th>
                <th>Delete</th>
            </tr>
        </thead>
        <tbody>
            <?php if(count($parent_categories)) : ?> 
                <?php foreach($parent_categories as $category): ?>
                    <tr>
                        <td><?= ucfirst($category->category); ?></td>
                        <td><?php
                            if ($category->parent == NULL) { 
                                echo 'No Parent'; 
                            } else {
                                //get category name from category table
                                $this->db->select('category')->from('solution_categories')->where('id_solution_categories', $category->parent);
                                $category_name = $this->db->get()->row();
                                echo ucfirst($category_name->category); 
                            } ?>    
                        </td>
                        <td><?= $category->priority; ?></td>
                        <td>
                            <?php
                                if ($category->status == 1) {
                                    echo 'Yes';
                                }
                                else {
                                    echo 'No';
                                }      
                            ?>
                        </td>
                        
                        <td><?= bt_edit('admin/solution_categories/edit/' . $category->id_solution_categories); ?></td>
                        <td><?= bt_delete('admin/solution_categories/delete/' . $category->id_solution_categories); ?></td> 
                    </tr>

                    <?php
                        //GET CATEGORY LEVEL 2
                        $this->db->select('id_solution_categories, category, parent, priority, status')->from('solution_categories')->where('parent', $category->id_solution_categories)->order_by('priority', 'ASC');
                        $categories_level2 = $this->db->get()->result();
                    ?>
                    <?php foreach($categories_level2 as $category2): ?>

                        <tr>
                            <td>- <?= ucfirst($category2->category); ?></td>
                            <td><?php
                                //get category name from category table
                                $this->db->select('category')->from('solution_categories')->where('id_solution_categories', $category2->parent);
                                $category_name = $this->db->get()->row();
                                echo ucfirst($category_name->category); 
                                ?>    
                            </td>
                            <td><?= $category2->priority; ?></td>
                            <td>
                            <?php
                                if ($category2->status == 1) {
                                    echo 'Yes';
                                }
                                else {
                                    echo 'No';
                                }      
                            ?>
                            </td>
                            
                            <td><?= bt_edit('admin/solution_categories/edit/' . $category2->id_solution_categories); ?></td>
                            <td><?= bt_delete('admin/solution_categories/delete/' . $category2->id_solution_categories); ?></td>
                        </tr>

                        <?php
                            //GET CATEGORY LEVEL 3
                            $this->db->select('id_solution_categories, category, parent, priority, status')->from('solution_categories')->where('parent', $category2->id_solution_categories)->order_by('priority', 'ASC');
                            $categories_level3 = $this->db->get()->result();
                        ?>
                        <?php foreach($categories_level3 as $category3): ?>

                            <tr>
                                <td>-- <?= ucfirst($category3->category); ?></td>
                                <td><?php
                                    //get category name from category table
                                    $this->db->select('category')->from('solution_categories')->where('id_solution_categories', $category3->parent);
                                    $category_name = $this->db->get()->row();
                                    echo ucfirst($category_name->category); 
                                    ?>    
                                </td>
                                <td><?= $category3->priority; ?></td>
                                <td>
                                <?php
                                    if ($category3->status == 1) {
                                        echo 'Yes';
                                    }
                                    else {
                                        echo 'No';
                                    }      
                                ?>
                                </td>
                                <td><?= bt_edit('admin/solution_categories/edit/' . $category3->id_solution_categories); ?></td>
                                <td><?= bt_delete('admin/solution_categories/delete/' . $category3->id_solution_categories); ?></td>   
                            </tr>

                        <?php endforeach; ?>
                    <?php endforeach; ?>
                <?php endforeach; ?>
            <?php else: ?>
                <tr>
                <td colspan="3">We could not find any category.</td>
                </tr>
            <?php endif; ?>

        </tbody> 
    </table>
    </div><!-- end table class responsive -->
    </div>
</div>     


<div class="row">
    <div class="col-sm-12">
        <?php
        //create pagination...
        echo '<p style="text-align:center;">' . $this->pagination->create_links() . '</p>';
        ?>
    </div>
</div>