<?php
include_once('include/config.php');
if (!isLoggedIn()) {
    $_SESSION['msg'] = "You must log in first";
    header('location: login.php');
}
if (!isAdmin()) {
    $_SESSION['msg'] = "You are not Admin";
    header('location: login.php');
}
if ($_SERVER["REQUEST_METHOD"] === "POST") {
    if (isset($_POST['active'])) {
       // Handle the active logic here
       $checkedIDs = $_POST['checkedIDs'];
   
       foreach ($checkedIDs as $pageID) {
           $sql = "UPDATE tbl_shift SET shift_status='Active' WHERE shift_id='$pageID'";
           $result = mysqli_query($db, $sql) or die("Query unsuccessful");
           
        mysqli_query($db, "INSERT INTO `notification`(`emp_id`, `cus_id`, `info`, `action`, `action_by`, `user_type`, `date`)
        VALUES ('','','Shift Active','Shift','".$_SESSION['user']['id']."','".$_SESSION['user']['user_type']."','$currentDate')");
       }
   
       if ($result) {
           echo "<script>
                   window.alert('Activated successfully.');
                   window.location.href = 'manage-shifts.php';
                 </script>";
       }
    }
   
      if (isset($_POST['inactive'])) {
       // Handle the inactive logic here
       $checkedIDs = $_POST['checkedIDs'];
   
       foreach ($checkedIDs as $pageID) {
           $sql = "UPDATE tbl_shift SET shift_status='Inactive' WHERE shift_id='$pageID'";
           $result = mysqli_query($db, $sql) or die("Query unsuccessful");
           
        mysqli_query($db, "INSERT INTO `notification`(`emp_id`, `cus_id`, `info`, `action`, `action_by`, `user_type`, `date`)
        VALUES ('','','Shift Inactive','Shift','".$_SESSION['user']['id']."','".$_SESSION['user']['user_type']."','$currentDate')");
       }
   
       if ($result) {
           echo "<script>
                   window.alert('Deactivated successfully.');
                   window.location.href = 'manage-shifts.php';
                 </script>";
       }
     }
     
     if (isset($_POST['archive'])) {
       // Handle the inactive logic here
       $checkedIDs = $_POST['checkedIDs'];
   
       foreach ($checkedIDs as $pageID) {
           $sql = "UPDATE tbl_shift SET shift_status='Archive' WHERE shift_id='$pageID'";
           $result = mysqli_query($db, $sql) or die("Query unsuccessful");
           
        mysqli_query($db, "INSERT INTO `notification`(`emp_id`, `cus_id`, `info`, `action`, `action_by`, `user_type`, `date`)
        VALUES ('','','Shift in Archive','Shift','".$_SESSION['user']['id']."','".$_SESSION['user']['user_type']."','$currentDate')");
       }
   
       if ($result) {
           echo "<script>
                   window.alert('Archive successfully.');
                   window.location.href = 'manage-shifts.php';
                 </script>";
       }
     }
     
    if (isset($_POST['delete'])) {
       // Handle the inactive logic here
       $checkedIDs = $_POST['checkedIDs'];
   
       foreach ($checkedIDs as $pageID) {
           $sql = "DELETE FROM `tbl_shift` WHERE shift_id='$pageID'";
           $result = mysqli_query($db, $sql) or die("Query unsuccessful");
           
        mysqli_query($db, "INSERT INTO `notification`(`emp_id`, `cus_id`, `info`, `action`, `action_by`, `user_type`, `date`)
        VALUES ('','','Shift Delete','Shift','".$_SESSION['user']['id']."','".$_SESSION['user']['user_type']."','$currentDate')");
       }
   
       if($result){
          echo "<script>
                window.alert('Deleted successfully.');
                window.location.href = 'manage-shifts.php';
                </script>";	
         }
     }
     
    
    if (isset($_POST['Update-order'])) {
    $pageIDs = $_POST['paID'];
    $site_pages_order_bys = $_POST['site_pages_order_by'];
    $stmt = my_prepared("UPDATE tbl_shift SET emp_order = ? WHERE shift_id = ?");

    for ($i = 0; $i < count($pageIDs); $i++) {
        $pageID = $pageIDs[$i];
        $orderValue = $site_pages_order_bys[$i];

        mysqli_stmt_bind_param($stmt, 'ii', $orderValue, $pageID);
        $result = mysqli_stmt_execute($stmt);

        if (!$result) {
            die("Query unsuccessful: " . mysqli_error($db));
        }
     }
     mysqli_stmt_close($stmt);
     header("Location: manage-shifts.php");
     exit();
  }

}
?>
<!DOCTYPE html>
<html lang="en">
    
<head>
    <?php include "top-links.php"?>
</head>

<body>
    <div class="wrapper">
    <?php include "header.php"?>

    <?php include "sidebar.php"?>

        <div class="content-page">
            <div class="content">

                <!-- Start Content-->
                <div class="container-fluid">
                <div class="row">
                        <div class="col-12">
                            <div class="card">
                                <div class="card-header">
                                    <h4 class="header-title">Manage Shift</h4>
                                    <button  onclick="window.location.href='add-shift.php'" class="float-left"> + Add Shift</button>
                                </div>
                                <div class="card-body">
                                    <div class="row">
                                        <div class="col-6">
                                            <div class="form-group" style="width:100px;">
                                                <label for="entriesPerPage">Show entries:</label>
                                                <select class="form-control" id="entriesPerPage" onchange="changeEntriesPerPage(this.value)">
                                                    <option value="20" <?php if ($limit == 20) echo "selected"; ?>>20</option>
                                                    <option value="50" <?php if ($limit == 50) echo "selected"; ?>>50</option>
                                                    <option value="100" <?php if ($limit == 100) echo "selected"; ?>>100</option>
                                                    <option value="500" <?php if ($limit == 500) echo "selected"; ?>>500</option>
                                                </select>
                                            </div>
                                        </div>
                                        
                                    </div><hr>
                                    <table id="basic-datatable" class="table table-striped dt-responsive nowrap w-100">
                                        <thead>
                                            <tr>
                                                <th>Sr No</th>
                                                <th>Shift</th>
                                                <th>Total Hours</th>
                                                <th class="text-center">Status</th>
                                                <th class="text-center"><input type="checkbox" id="selectAll"/></th>
                                                <th>Edit</th>
                                                <!--<th>Delete</th>-->
                                            </tr>
                                        </thead>
                                        <form method="POST" action="<?php $_PHP_SELF?>" onsubmit="return validateForm()">
                                        <tbody>
                                            <?php
                                                $limit = isset($_GET['entries']) ? $_GET['entries'] : 20;
                                                $page = isset($_GET['page']) ? $_GET['page'] : 1;
                                                $start = ($page - 1) * $limit;
                                                $searchTerm = isset($_GET['search']) ? $_GET['search'] : '';
                                                $sql = "SELECT * FROM `tbl_shift`";
                                                if (!empty($searchTerm)) {
                                                    $sql .= " WHERE `shift_time` LIKE '%$searchTerm%'";
                                                }
                                                $sql .= " ORDER BY shift_id DESC LIMIT $start, $limit";
                                                $run = mysqli_query($db, $sql) or die("Query Not run");
                                                $count = $start;
                                                while ($data = mysqli_fetch_assoc($run)) {
                                                $count++;
                                            ?>
                                                <tr>
                                                    <td><?php echo $count; ?></td>
                                                    <td><?php echo $data['shift_time']; ?> - <?php echo $data['shift_end']; ?></td>
                                                    <td><?php echo $data['shift_hours']; ?></td>
                                                    <td class="text-center">
                                                        <?php if($data["shift_status"]=="Active"){?>
                                                        <button type="button" class="btn btn-primary"><span class="label label-default">Active</span></button>
                                                        <?php }elseif($data["shift_status"]=="Archive"){?>
                                                        <button type="button" class="btn btn-warning"><span class="label label-default">Archive</span></button>
                                                        <?php }else{?>
                                                        <button type="button" class="btn btn-danger"><span class="label label-default">Inactive</span></button>
                                                        <?php }?>
                                                    </td>
                                                    <td class="text-center">
                                                        <input type="checkbox" name="checkedIDs[]" class="selectItem" value="<?php echo $data["shift_id"]?>" />
                                                        <input type="hidden" name="pageID[]" value="<?php echo $data["shift_id"]?>">
                                                    </td>
                                                    <td><a href="edit-shift.php?id=<?php echo $data['shift_id']; ?>"><i class="ri-edit-fill" style="font-size: medium; color: green;"></i> </a></td>
                                                    <!--<td>-->
                                                    <!--    <form action="" method="POST">-->
                                                    <!--        <input type="hidden" name="id" value="">-->
                                                    <!--        <button name="delete_employee" type="submit" style="border:none;"><i class="ri-delete-bin-fill" style="font-size: x-large; color: red;"></i></button>-->
                                                    <!--    </form>-->
                                                    <!--</td>-->
                                
                                                </tr>
                                            <?php } ?>
                                        </tbody>
                                        <tfoot>
                                        <tr style="text-align: right;"> 
                                            <td colspan="10" class="text-right">
                                                <button type="submit" name="active" class="btn btn-success pull-right mr5" >Active</button>
                                                <button type="submit" name="inactive" class="btn btn-danger pull-right mr5" >Inactive</button>
                                                <button type="submit" name="archive" class="btn btn-warning pull-right mr5" >Archive</button>
                                                <button type="submit" name="delete" class="btn btn-danger pull-right mr5" >Delete</button>
                                            </td>
                                        </tr> 
                                        <tfoot>
                                        </form>
                                    </table>
                                
                                    <?php
                                    // Set the limit and page number
                                    $limit = isset($_GET['entries']) ? (int)$_GET['entries'] : 20;
                                    $page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
                                    $start = ($page - 1) * $limit;
                                    
                                    // Search term
                                    $searchTerm = isset($_GET['search']) ? $_GET['search'] : '';
                                    
                                    // Count total records
                                    $sqlCount = "SELECT COUNT(*) AS total FROM `tbl_shift`";
                                    if (!empty($searchTerm)) {
                                        $sqlCount .= " WHERE `shift_time` LIKE '%$searchTerm%'";
                                    }
                                    $result = mysqli_query($db, $sqlCount);
                                    $row = mysqli_fetch_assoc($result);
                                    $total_records = $row['total'];
                                    
                                    // Calculate total pages
                                    $total_pages = ceil($total_records / $limit);
                                    $range = 10;
                                    
                                    if ($total_pages > 1) { // Only show pagination if there's more than one page
                                        echo "<ul class='pagination' style='text-align: right;'>";
                                    
                                        // First and Previous links
                                        if ($page > 1) {
                                            echo "<li class='page-item'><a class='page-link' href='?page=1&entries=$limit&search=$searchTerm'>First</a></li>";
                                            echo "<li class='page-item'><a class='page-link' href='?page=" . ($page - 1) . "&entries=$limit&search=$searchTerm'>&laquo;</a></li>";
                                        }
                                    
                                        // Page number links
                                        for ($i = max(1, $page - $range); $i <= min($page + $range, $total_pages); $i++) {
                                            $activeClass = ($page == $i) ? "active" : "";
                                            echo "<li class='page-item $activeClass'><a class='page-link' href='?page=$i&entries=$limit&search=$searchTerm'>$i</a></li>";
                                        }
                                    
                                        // Next and Last links
                                        if ($page < $total_pages) {
                                            echo "<li class='page-item'><a class='page-link' href='?page=" . ($page + 1) . "&entries=$limit&search=$searchTerm'>&raquo;</a></li>";
                                            echo "<li class='page-item'><a class='page-link' href='?page=$total_pages&entries=$limit&search=$searchTerm'>Last</a></li>";
                                        }
                                    
                                        echo "</ul>";
                                    }
                                    ?>

                                </div>
                                 <!-- end card body-->
                            </div> <!-- end card -->
                        </div><!-- end col-->
                    </div> 
                    </div>
                    </div>
    </div>
</div>

<?php include "footer.php"?>

</body>
</html>