<?php 

include('../dbconnect.php');
ob_start();
session_start();

if( !isset($_SESSION['user']) ) {
 header("Location: ../index.php");
 exit;
}
//$search = $_POST['search'];
$emplevel = $_POST['level'];
$empstatus = $_POST['status'];



$search = null;

if(isset($_POST["search"]))
{
    $search = $_POST["search"];
}
if(isset($_GET["search"]))
{
    $search = $_GET["search"];
}

?>
<!DOCTYPE html>
<html lang="en">

  <head>

    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <meta name="description" content="">
    <meta name="author" content="">

    <title>Super Admin | Users</title>

    <!-- Bootstrap core CSS-->
    <link href="../vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">

    <!-- Custom fonts for this template-->
    <link href="../vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css">

    <!-- Page level plugin CSS-->
    <link href="../vendor/datatables/dataTables.bootstrap4.css" rel="stylesheet">

    <!-- Custom styles for this template-->
        <link href="../css/sb-admin.css" rel="stylesheet">
    <link href="../css/style.css" rel="stylesheet">
    <link rel="icon" href="../images/logo.jpg" type="image/gif" sizes="16x16">

    


  </head>

  <body id="page-top" onload=display_ct();>

    <?php include('uppernav.php')?>



      <!-- Sidebar -->
      
      <?php 
      $user = "active";
      $admintools = "active";
      include('sidebar.php');
      ?>
      <div id="content-wrapper">

        <div class="container-fluid">

          <!-- Breadcrumbs-->
          <ol class="breadcrumb">
            <li class="breadcrumb-item">
              <a href="user.php">Users</a>
            </li>
            
          </ol>
          <div class="row p-3" >
          <form class="form-inline" method="post" action="user.php" enctype="multipart/form-data"> 
            <div class="col-sm-12">
                <h4>Users</h4>
            </div>
            
            <div class="col-sm-12">
              <a href="adduser.php" class="btn btn-primary" role="button"><i class="fa fa-plus"></i> Add </a> 
            </div>
            <div class="col-sm-12"  style="margin: 5px 0px;">

            
              <button type="submit" class="btn btn-primary" name="searchb"  > <i class='fas fa-search'></i>  Search </button>
              <input type="text" class="form-control" name="search" placeholder="Search here..." value="<?php echo $search?>"> &nbsp 

              <button class="btn btn-primary" name="filter" type="submit"> <i class='fas fa-filter'></i> Filter  </button>  
              <?php 
                                        $levelquery = "SELECT * FROM account GROUP BY level";                                                
                                        $levelresult = mysqli_query ($conn,$levelquery); 
                                        echo "<select name='level'  class='form-control'>"; 
                                        echo "<option value='' disabled selected> Level </option>";
                                        echo "<option value='All'> All </option>";
                                        while($levelr = mysqli_fetch_array($levelresult)) {
                                            if($emplevel == $levelr['level']){
                                                echo "<option value='".$levelr['level']."' selected='selected'>".$levelr['level']."</option>";
                                         
                                            }
                                           else{
                                            echo "<option value='".$levelr['level']."' >".$levelr['level']."</option>";
                                           }
                                            
                                        }
                                        echo "</select>"; 
                            ?>
                
         
                <?php 
                                        $query = "SELECT * FROM account GROUP BY status";                                                
                                        $result = mysqli_query ($conn,$query); 
                                        echo "<select name='status'  class='form-control'>"; 
                                        echo "<option value='' disabled selected> Status </option>";
                                        echo "<option value='All'> All </option>";
                                        while($r = mysqli_fetch_array($result)) {
                                            if($empstatus==$r['status']){
                                                echo "<option value='".$r['status']."' selected='selected'>".$r['status']."</option>";
                                         
                                            }
                                           else{
                                            echo "<option value='".$r['status']."' >".$r['status']."</option>";
                                           }
                                            
                                        }
                                        echo "</select>"; ?>
                  
                    
              

            </div>
            

            <div class="col-sm-12 col-lg-12 col-md-12">
                <table class="table table-hover" id="myTable">
                    <thead class="thead-dark">
                        <tr class="thead-dark">
                            <th>Username</th>
                            <th>Name</th>
                            <th>Level</th>
                            <th>Status</th>
                            <th>Action</th>
                        </tr>
                    </thead>
                    <tbody>
                    <?php 
                    //search box 
                      if(isset($_POST["search"]))
                      {
                          $search = $_POST["search"];
                      }
                      if(isset($_GET["search"]))
                      {
                          $search = $_GET["search"];
                      }
                    //level filter

                    if(isset($_POST["level"]))
                    {
                        $level = $_POST["level"];
                    }
                    if(isset($_GET["level"]))
                    {
                        $level= $_GET["level"];
                    }
                    
                    //Status filter

                    if(isset($_POST["status"]))
                    {
                        $status = $_POST["status"];
                    }
                    if(isset($_GET["status"]))
                    {
                        $status = $_GET["status"];
                    }
                    
                      
            
                      $query = "SELECT * FROM account JOIN empinfo ON account.userid = empinfo.empid WHERE account.level LIKE '%".$search."%' OR account.userid LIKE '%".$search."%' OR account.status LIKE '%".$search."%' OR empinfo.firstname LIKE '%".$search."%' OR empinfo.surname LIKE '%".$search."%'";

                     /*if(isset($_POST['searchb'])){
                        $query ="SELECT * FROM account WHERE CONCAT(`userid`, `level`, `status` ) LIKE '%".$search."%' LIMIT $start_from, $record_per_page";
                      } 
                      else*/if (isset($_POST["filter"])) {

                        if($emplevel != 'All' && $empstatus != 'All'){
                          $query = "SELECT * FROM account  JOIN empinfo ON account.userid = empinfo.empid WHERE level='$emplevel' AND status = '$empstatus'";
                
                        }
                        else if($empstatus != 'All'){
                          $query = "SELECT * FROM account JOIN empinfo ON account.userid = empinfo.empid WHERE status='$empstatus'";
                  
                      
                        }
                        else if($emplevel != 'All'){
                          $query = "SELECT * FROM account JOIN empinfo ON account.userid = empinfo.empid WHERE level='$emplevel'";
                 
                        }
                        else {
                          $query = "SELECT * FROM account JOIN empinfo ON account.userid = empinfo.empid";
              
                        }
                        
                      }

                      $result = mysqli_query($conn, $query);
                      
                    ?>
            
            
                    <?php 
              
                      if (mysqli_num_rows($result) > 0) {
            
                      while($row = mysqli_fetch_assoc($result)) {
                          echo'
                          <tr>
                          
                          <td>'.$row['userid'].'</td>
                          <td>'.$row['firstname'].' '.$row['surname'].'</td>
                          <td>'.$row['level'].'</td>
                          <td>'.$row['status'].'</td>
                        
                          <td> <a href="updateuser.php?userid='.$row['userid'].'" class="btn btn-primary"> <i class="fas fa-edit"></i> Update </a>  
                          
                          
                          </td>
                          </tr>';

                      }
                    }else {
                      echo '<tr><td><h6> No Record Found</h6> <td> </tr>';
                    }
                    mysqli_close($conn);
                    ?>
                    </tbody>
                </table>
                <script>
                // get the table element
                var $table = document.getElementById("myTable"),
                // number of rows per page
                $n = 8,
                // number of rows of the table
                $rowCount = $table.rows.length,
                // get the first cell's tag name (in the first row)
                $firstRow = $table.rows[0].firstElementChild.tagName,
                // boolean var to check if table has a head row
                $hasHead = ($firstRow === "TH"),
                // an array to hold each row
                $tr = [],
                // loop counters, to start count from rows[1] (2nd row) if the first row has a head tag
                $i,$ii,$j = ($hasHead)?1:0,
                // holds the first row if it has a (<TH>) & nothing if (<TD>)
                $th = ($hasHead?$table.rows[(0)].outerHTML:"");
                // count the number of pages
                var $pageCount = Math.ceil($rowCount / $n);
                // if we had one page only, then we have nothing to do ..
                if ($pageCount > 1) {
                  // assign each row outHTML (tag name & innerHTML) to the array
                  for ($i = $j,$ii = 0; $i < $rowCount; $i++, $ii++)
                    $tr[$ii] = $table.rows[$i].outerHTML;
                  // create a div block to hold the buttons
                  $table.insertAdjacentHTML("afterend","<div id='buttons'></div");
                  // the first sort, default page is the first one
                  sort(1);
                }

                // ($p) is the selected page number. it will be generated when a user clicks a button
                function sort($p) {
                  /* create ($rows) a variable to hold the group of rows
                  ** to be displayed on the selected page,
                  ** ($s) the start point .. the first row in each page, Do The Math
                  */
                  var $rows = $th,$s = (($n * $p)-$n);
                  for ($i = $s; $i < ($s+$n) && $i < $tr.length; $i++)
                    $rows += $tr[$i];
                  
                  // now the table has a processed group of rows ..
                  $table.innerHTML = $rows;
                  // create the pagination buttons
                  document.getElementById("buttons").innerHTML = pageButtons($pageCount,$p);
                  // CSS Stuff
                  document.getElementById("id"+$p).setAttribute("class","btn btn-primary btn-sm active");
                }


                // ($pCount) : number of pages,($cur) : current page, the selected one ..
                function pageButtons($pCount,$cur) {
                  /* this variables will disable the "Prev" button on 1st page
                    and "next" button on the last one */
                  var	$prevDis = ($cur == 1)?"disabled":"",
                    $nextDis = ($cur == $pCount)?"disabled":"",
                    /* this ($buttons) will hold every single button needed
                    ** it will creates each button and sets the onclick attribute
                    ** to the "sort" function with a special ($p) number..
                    */
                    $buttons = "<input type='button' class='btn btn-default btn-sm text-primary' value='« Prev' onclick='sort("+($cur - 1)+")' "+$prevDis+"> &nbsp";
                  for ($i=1; $i<=$pCount;$i++)
                    $buttons += "<input type='button' class='btn btn-default btn-sm text-primary' id='id"+$i+"'value='"+$i+"' onclick='sort("+$i+")'> &nbsp";
                  $buttons += "<input type='button' class='btn btn-default btn-sm text-primary' value='Next »;' onclick='sort("+($cur + 1)+")' "+$nextDis+"> &nbsp";
                  return $buttons;
                }
                </script>
             
            </div>
            
            </form>
          </div>
        

          

          <!-- Icon Cards-->
      
        <!-- /.container-fluid -->

        <!-- Sticky Footer -->


      </div>
      <!-- /.content-wrapper -->

    </div>
    <!-- /#wrapper -->

    <!-- Scroll to Top Button-->
    <a class="scroll-to-top rounded" href="#page-top">
      <i class="fas fa-angle-up"></i>
    </a>

    <!-- Logout Modal-->
    <div class="modal fade" id="logoutModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
      <div class="modal-dialog" role="document">
        <div class="modal-content">
          <div class="modal-header">
            <h5 class="modal-title" id="exampleModalLabel">Ready to Leave?</h5>
            <button class="close" type="button" data-dismiss="modal" aria-label="Close">
              <span aria-hidden="true">×</span>
            </button>
          </div>
          <div class="modal-body">Select "Logout" below if you are ready to end your current session.</div>
          <div class="modal-footer">
            <button class="btn btn-secondary" type="button" data-dismiss="modal">Cancel</button>
            <a class="btn btn-primary" href="login.html">Logout</a>
          </div>
        </div>
      </div>
    </div>

    <!-- Bootstrap core JavaScript-->
    <script src="../vendor/jquery/jquery.min.js"></script>
    <script src="../vendor/bootstrap/js/bootstrap.bundle.min.js"></script>

    <!-- Core plugin JavaScript-->
    <script src="../vendor/jquery-easing/jquery.easing.min.js"></script>

    <!-- Page level plugin JavaScript-->
    <script src="../vendor/chart.js/Chart.min.js"></script>
    <script src="../vendor/datatables/jquery.dataTables.js"></script>
    <script src="../vendor/datatables/dataTables.bootstrap4.js"></script>

    <!-- Custom scripts for all pages-->
    <script src="../js/sb-admin.min.js"></script>

    <!-- Demo scripts for this page-->
    <script src="../js/demo/datatables-demo.js"></script>
    <script src="../js/demo/chart-area-demo.js"></script>

          <script language="javascript" type="text/javascript">
            $(document).ready(function(){
            $("form").on("submit", function(){
                $("#pageloader").fadeIn();
            });//submit

             $('#preloader').fadeOut();
            });//document ready



        </script>
</body>

</html>
