<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>Pages Administration</h2>
        <?= $this->session->flashdata('success'); //to display success message ?> 
        <?= $this->session->flashdata('result'); //to display result message ?> 
    </div><!-- end class="col-sm-12" -->
</div> <!-- end row --> 

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

<div class="row">
    <div class="col-sm-12">
       <div class="table-responsive">  
       <table class="table table-striped">
        <thead> 
            <tr>
                <th>Page Title</th> 
                <th>Parent Page</th>
                <th>Ordering</th>
                <th>Display</th>
                <th>Edit</th>
                <th>Delete</th>
            </tr>
        </thead>
        <tbody>
            <?php if(count($parent_pages)) : ?> 
            <?php foreach($parent_pages as $page): ?>
                <tr>
                    <td><?= ucfirst($page->page_title); ?></td>
                    <td><?php

                    if ($page->parent == NULL) { 
                        echo 'No Parent'; 
                    } else {
                        //get page name from pages table
                        $this->db->select('page_title')->from('pages')->where('id_pages', $page->parent);
                        $page_name = $this->db->get()->row();
                        echo ucfirst($page_name->page_title); 
                    } ?>    
                    </td>
                    <td><?= $page->priority; ?></td>
                    <td>
                    <?php
                        if ($page->status == 1) {
                            echo 'Yes';
                        }
                        else {
                            echo 'No';
                        }      
                    ?>
                    </td>
                    
                    <td><?= bt_edit('admin/pages/edit/' . $page->id_pages); ?></td>
                    <td><?= bt_delete('admin/pages/delete/' . $page->id_pages); ?></td>
                </tr>

                <?php
                    //GET page LEVEL 2
                    $this->db->select('id_pages, page_title, parent, priority, status')->from('pages')->where('parent', $page->id_pages)->order_by('priority', 'ASC');
                    $pages_level2 = $this->db->get()->result();
                ?>
                <?php foreach($pages_level2 as $page2): ?>

                    <tr>
                        <td>- <?= ucfirst($page2->page_title); ?></td>
                        <td><?php
                            //get page name from page table
                            $this->db->select('page_title')->from('pages')->where('id_pages', $page2->parent);
                            $page_name = $this->db->get()->row();
                            echo ucfirst($page_name->page_title); 
                            ?>    
                        </td>
                        <td><?= $page2->priority; ?></td>
                        <td>
                        <?php
                            if ($page2->status == 1) {
                                echo 'Yes';
                            }
                            else {
                                echo 'No';
                            }      
                        ?>
                        </td>
                        
                        <td><?= bt_edit('admin/pages/edit/' . $page2->id_pages); ?></td>
                        <td><?= bt_delete('admin/pages/delete/' . $page2->id_pages); ?></td>
                    </tr>

                    <?php
                    //GET page LEVEL 3
                    $this->db->select('id_pages, page_title, parent, priority, status')->from('pages')->where('parent', $page2->id_pages)->order_by('priority', 'ASC');
                    $pages_level3 = $this->db->get()->result();
                    ?>
                    <?php foreach($pages_level3 as $page3): ?>

                        <tr>
                            <td>-- <?= ucfirst($page3->page_title); ?></td>
                            <td><?php
                                //get page name from page table
                                $this->db->select('page_title')->from('pages')->where('id_pages', $page3->parent);
                                $page_name = $this->db->get()->row();
                                echo ucfirst($page_name->page_title); 
                                ?>    
                            </td>
                            <td><?= $page3->priority; ?></td>
                            <td>
                            <?php
                                if ($page3->status == 1) {
                                    echo 'Yes';
                                }
                                else {
                                    echo 'No';
                                }      
                            ?>
                            </td>
                            
                            <td><?= bt_edit('admin/pages/edit/' . $page3->id_pages); ?></td>
                            <td><?= bt_delete('admin/pages/delete/' . $page3->id_pages); ?></td>
                        </tr>

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

        </tbody> 
    </table>
    </div><!-- end table class responsive -->
    </div><!-- end class="col-sm-12" -->
</div> <!-- end row -->    


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