<?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_leave_vocation SET startus='Active' WHERE 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 
          ('','','Vocation Active','Vocation','".$_SESSION['user']['id']."','".$_SESSION['user']['user_type']."','$currentDate')");
       }
   
      if ($result) {
          echo "<script>
                  window.alert('Activated successfully.');
                  window.location.href = 'leave-and-vocation.php';
                 </script>";
      }
     }
   
      if (isset($_POST['inactive'])) {
       // Handle the inactive logic here
       $checkedIDs = $_POST['checkedIDs'];
   
      foreach ($checkedIDs as $pageID) {
          $sql = "UPDATE tbl_leave_vocation SET startus='Inactive' WHERE 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 
          ('','','Vocation Inactive','Vocation','".$_SESSION['user']['id']."','".$_SESSION['user']['user_type']."','$currentDate')");
      }
   
      if ($result) {
          echo "<script>
                  window.alert('Deactivated successfully.');
                  window.location.href = 'leave-and-vocation.php';
                 </script>";
      }
     }
     
     if (isset($_POST['archive'])) {
       // Handle the inactive logic here
       $checkedIDs = $_POST['checkedIDs'];
   
      foreach ($checkedIDs as $pageID) {
          $sql = "UPDATE tbl_leave_vocation SET startus='Archive' WHERE 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 
          ('','','Vocation Archive','Vocation','".$_SESSION['user']['id']."','".$_SESSION['user']['user_type']."','$currentDate')");
      }
   
      if ($result) {
          echo "<script>
                  window.alert('Archive successfully.');
                  window.location.href = 'leave-and-vocation.php';
                 </script>";
      }
     }
     
    if (isset($_POST['delete'])) {
       // Handle the inactive logic here
       $checkedIDs = $_POST['checkedIDs'];
   
      foreach ($checkedIDs as $pageID) {
          $sql = "DELETE FROM `tbl_leave_vocation` WHERE 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 
          ('','','Vocation Delete','Vocation','".$_SESSION['user']['id']."','".$_SESSION['user']['user_type']."','$currentDate')");
      }
   
      if($result){
          echo "<script>
                window.alert('Deleted successfully.');
                window.location.href = 'leave-and-vocation.php';
                </script>";	
         }
     }
    
    // if (isset($_POST['delete'])) {
    //     $pageID=$_POST['pageID'];
    //     $sql="DELETE FROM `login_tbl` WHERE id='$pageID' ";	
    //     $result=mysqli_query($db, $sql) or die("Query unsuccessful");	
    //     if($result){
    //       echo "<script>
    //             window.alert('Page Deleted successfully.');
    //             window.location.href = 'manage-sub-users.php';
    //             </script>";	
    //      }
    // }
}
?>
<!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">
<?php
            echo'<h1 class="page-title" style="text-align:center; padding-top:30px;">Coming Soon! </h1>';
            echo'<h4 class="page-title" style="text-align:center;">This Section is under construction.</h4>';
            exit;
            ?>
                <!-- Start Content-->
                <div class="container-fluid">
                    <div class="row">
                        <div class="col-12">
                            <div class="card">
                                <div class="card-header">
                                    <h4 class="header-title">Leave and Vocation Management</h4>
                                    <?php
                                    if ($_SESSION['user']['user_type'] == 'supadmin' || 
                                        $_SESSION['user']['user_type'] == 'admin') {
                                        echo '<button onclick="window.location.href=\'add-leave-and-vocation.php\'" class="float-left"> + Add Leave and Vocation</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 class="col-6">
                                            <!--<div class="form-group" style="width:100px;">-->
                                            <!--    <input type="text" id="searchInput" placeholder="Search Data">-->
                                            <!--</div>-->
                                            <div class="app-search  d-lg-block">
                                            <label for="entriesPerPage">Search Data:</label>
                                                <div class="input-group">
                                                    <input type="text" class="form-control" id="searchInput" placeholder="<?php if(isset($_GET['search'])){ echo $_GET['search']; }else{ echo'Search by Date...';} ?>" onkeydown="if(event.keyCode==13){ search(); }">
                                                    <!--<span class="ri-search-line search-icon text-muted"></span>-->
                                                </div>
                                            </div>
                                        </div>
                                    </div><hr>
                                    <table id="basic-datatable" class="table table-striped dt-responsive nowrap w-100">
                                        <thead>
                                            <tr>
                                                <th>Sr No</th>
                                                <th>Date</th>
                                                <th>Vocation For</th>
                                                <th>Vocation Details</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_leave_vocation` WHERE startus = 'Active'";
                                                if (!empty($searchTerm)) {
                                                    $sql .= " AND `date` LIKE '%$searchTerm%'";
                                                }
                                                $sql .= " ORDER BY 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['date']; ?> </td>
                                                    <td>
                                                        <?php if($data["vocation_for"]=="0"){?>
                                                        <button type="button" class="btn btn-primary"><span class="label label-default">All</span></button>
                                                        <?php }else{?>
                                                            <?php 
                                                                $d = mysqli_fetch_assoc(mysqli_query($db, "select * from tbl_roles where ro_id='".$data["vocation_for"]."' "));
                                                                echo '<button type="button" class="btn btn-primary"><span class="label label-default">'.$d['role_name'].'</span></button>';
                                                            ?>
                                                        <?php }?>
                                                    </td>
                                                    <td><?php echo $data['vocation_detail']; ?></td>
                                                    <td class="text-center">
                                                        <?php if($data["startus"]=="Active"){?>
                                                        <button type="button" class="btn btn-primary"><span class="label label-default">Active</span></button>
                                                        <?php }elseif($data["startus"]=="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["id"]?>" />
                                                        <input type="hidden" name="pageID[]" value="<?php echo $data["id"]?>">
                                                    </td>
                                                    <td><a href="#"><i class="ri-edit-fill" style="font-size: medium; color: green;"></i> </a></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 `login_tbl`";
                                    if (!empty($searchTerm)) {
                                        $sqlCount .= " WHERE `name` 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>
<script>
    function togglePasswordVisibility() {
        var passwordField = document.getElementById('password');
        var passwordToggle = document.getElementById('password-toggle');
        if (passwordField.type === 'password') {
            passwordField.type = 'text';
            passwordToggle.className = 'fa fa-eye-slash';
        } else {
            passwordField.type = 'password';
            passwordToggle.className = 'fa fa-eye';
        }
    }
</script>
<?php include "footer.php"?>

</body>
</html>