departments.php

<?php
require_once './includes/header.php';
LogInCheck();
require_once './includes/admin_nav.php';
//var_dump($_SESSION);
?>
    <!--exp1-->

    <div class="col-sm-10 col-sm-offset-1">
        <div class="row">
            <!--place for error message flashing-->
            <?php
            //this will display any kind of error message as
            flash();
            ?>
        </div>
        <div class="row">
            <a href="#addnew" data-toggle="modal" class="btn btn-primary"><span class="glyphicon glyphicon-plus"></span> New</a>
            <a href="./reports/all_departments.php" target="_new" class="btn btn-success pull-right"><span class="glyphicon glyphicon-print"></span> PDF</a>
        </div>
        <div class="" style="height: 10px;">
        </div>
        <div class="row">
            <table id="myTable" class="table table-hover table-bordered table-striped table-responsive">
                <thead>
                <th>#</th>
                <th>DEPARTMENT</th>
                <th>DEPARTMENTAL HEAD</th>
                <th>ADDED ON</th>
                <th>ACTION</th>
                </thead>
                <tbody>
                <?php
                include_once('db.php');
                $sql = "SELECT * FROM `department` WHERE `role` <> '1'";


                $query = $conn->query($sql);

                $i=1;
                while($row = $query->fetch_assoc())
                {
                    echo"<tr>
                    <td>".$i."</td>
					<td>".$row['dept_name']."</td>
					<td>".$row['dept_details']."</td>
					<td>".$row['added_at']."</td>
					<td><a href='#edit_".$row['dept_id']."' class='btn btn-success btn-sm' data-toggle='modal'><span class='glyphicon glyphicon-edit'></span> Edit</a>
					<a href='#delete_".$row['dept_id']."' class='btn btn-danger btn-sm' data-toggle='modal'><span class='glyphicon glyphicon-trash'></span> Delete</a>
					</td>
				</tr>";
                    $i++;
                    include('models/edit_delete_departmentModel.php') ;
                }
                ?>
                </tbody>
            </table>
            <hr>
            <?php
            //add required models
            require_once 'models/add_departmentModel.php';
            ?>
        </div>
    </div>

    <!--end exp1-->
<?php require_once './includes/footer.php'; ?>