<?php include('../dbconnect.php'); 
include('../phps.php');
ob_start();
session_start();
$user = $_SESSION['user'];
$sqla = "SELECT * FROM account WHERE userid = '$user'";
$resulta = mysqli_query($conn, $sqla);
$rowa  = mysqli_fetch_assoc($resulta);

if( !isset($_SESSION['user']) ) {
 header("Location: ../index.php");
 exit;
}
elseif($rowa['level']=='admin' || $rowa['level'] == 'user'){
    header("Location: ../accessdenied.php");
  }
  


   $search = phps($_POST['searchtxt']);
   $team = phps($_POST['team']);
   $team = str_replace("&amp;","&",$team);

   $status = phps($_POST['status']);


   $search = mysqli_real_escape_string($conn, $search);
   $team = mysqli_real_escape_string($conn, $team);
   $status = mysqli_real_escape_string($conn, $status); 

              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 empinfo JOIN empdetails ON empinfo.empid = empdetails.detailid WHERE empinfo.empid LIKE '%".$search."%' OR empinfo.firstname LIKE '%".$search."%' OR empinfo.surname LIKE '%".$search."%' OR empdetails.team LIKE '%".$search."%' OR empdetails.status LIKE '%".$search."%' ";
              /*
              if(isset($_POST['searchb'])){
                $query ="SELECT * FROM empinfo LEFT JOIN empdetails ON empinfo.empid = empdetails.detailid WHERE CONCAT(empinfo.empid, empinfo.surname, empinfo.firstname, empinfo.middlename,empdetails.status, empdetails.team)  LIKE '%".$search."%' LIMIT $start_from, $record_per_page";
              }      

              else*/if (isset($_POST["filter"])) {


                if($team != 'All' && $status != 'All'){
                $query = "SELECT * FROM empinfo JOIN empdetails ON empinfo.empid = empdetails.detailid  WHERE status='$status' AND team ='$team'";
                  
                }
                else if($status != 'All'){
                   $query = "SELECT * FROM empinfo JOIN empdetails ON empinfo.empid = empdetails.detailid  WHERE status='$status'";
          
              
                }
                else if($team != 'All'){
                 $query = "SELECT * FROM empinfo JOIN empdetails ON empinfo.empid = empdetails.detailid  WHERE  team='$team'";

          
         
                }
                else {
                   $query = "SELECT * FROM empinfo JOIN empdetails ON empinfo.empid = empdetails.detailid" ;
      
                }


               
             
             
               
                
              }
             
              $result = mysqli_query($conn, $query);
              $rows = mysqli_num_rows($result);
             
                $numrow = $rows;

              
              

            
     
?>
<!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 | Employee</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">
	<div id="preloader">
   		<img src="../images/loaderS.gif" alt="processing..." height="150px" width="200px"/>
	</div>

  <div id="pageloader">
   <img src="../images/loaderS.gif" alt="processing..." height="150px" width="200px"/>
</div>



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

    <div id="wrapper">

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

        <div class="container-fluid">

          <!-- Breadcrumbs-->
          <ol class="breadcrumb">
            <li class="breadcrumb-item">
              <a href="employee.php">Employee</a>
            </li>
         
          </ol>
         
  
          <div class="row p-3" >
        

          <div class="col-sm-12" style="padding: 10px 0;">
          <form class="form-inline" method="post" action="employee.php" enctype="multipart/form-data"> 
            <div class="col-sm-12">
              <h4>Employee</h4> <br>

            </div>

     
            <div class="col-sm-12">
              <button class="btn btn-primary" name="searchb" type="submit"> <i class='fas fa-search'></i> Search </button> &nbsp 

                <input type="text" class="form-control" name="searchtxt" value="<?php echo $search;?>" placeholder="Search here..."> 
           
            </div>
          
            <div class="col-sm-12" style="margin-top: 05px;">
              <button class="btn btn-primary sm" name="filter" type="submit"> <i class='fas fa-filter'></i> Filter  &nbsp </button>  &nbsp
              <?php 
                                        $qt = "SELECT * FROM empdetails GROUP BY team";                                                
                                        $rt = mysqli_query ($conn,$qt); 
                                        echo "<select name='team' class='form-control'>"; 
                                        echo "<option value='' disabled selected> Team </option>";
                                        echo "<option value='All'> All </option>";
                                        
                                        while($r = mysqli_fetch_array($rt)) {
                                            if($team ==$r['team']){
                                                echo "<option value='".$r['team']."' selected>".$r['team']."</option>";
                                         
                                            }
                                           else{
                                            echo "<option value='".$r['team']."' >".$r['team']."</option>";
                                           }
                                            
                                        }
                                        echo "</select>"; ?>
                <?php 
                                        $qs = "SELECT * FROM empdetails GROUP BY status";                                                
                                        $rs1 = mysqli_query ($conn,$qs); 
                                        echo "<select name='status' class='form-control'>"; 
                                        echo "<option value=''  selected disabled> Status </option>";
                                        echo "<option value='All'> All </option>";
                                        while($rowstat = mysqli_fetch_array($rs1)) {
                                            if($status==$rowstat['status']){
                                                echo "<option value='".$rowstat['status']."' selected='selected'>".$rowstat['status']."</option>";
                                         
                                            }else if($status=='All'){

                                              echo "<option value='All' selected='selected'>All</option>";
                                            }
                                           else{
                                            echo "<option value='".$rowstat['status']."' >".$rowstat['status']."</option>";
                                           }
                                            
                                        }
                                        echo "</select>"; ?>
                
                
           
            </div> 
            <div class="col-sm-12" style="margin-top: 05px;">
         

            </div>
            </form>
   
          </div>

          <table class="table table-hover" id="emptbl">
            <thead class="thead-dark">
              <tr class="thead-dark">
                <th scope="col">Employee ID</th>
                <th scope="col">First Name</th>
                <th scope="col">Last Name</th>
                <th scope="col">Team</th>
                <th scope="col">Status</th>
                <th scope="col">Action</th>
              </tr>
            </thead>
            <tbody>
              <?php 

               
                if (mysqli_num_rows($result) > 0) {

             
                   while($row = mysqli_fetch_assoc($result)) {
                    $pi = "style='display:block;'";
                       echo'
                       <tr>
                       <td>'.$row['empid'].'</td>
                       <td>'.$row['firstname'].'</td>
                       <td>'.$row['surname'].'</td>
                       <td>'.$row['team'].'</td>
                       <td>'.$row['status'].'</td>
                       <td> <a href="viewemp.php?ID='.$row['empid'].'&pi='.$pi.'" class="btn btn-primary btn-sm"> <i class="fa fa-eye"></i> View </a>  
                       <a href="updateemp.php?ID='.$row['empid'].'&pi='.$pi.'" class="btn btn-success btn-sm"> <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("emptbl"),
                // number of rows per page
                $n = 20,
                // 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>


          <!-- 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>
