|
Server IP : 103.53.40.154 / Your IP : 18.224.53.246 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/greenenvirofoundation.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 salary_manage SET status='Approve' 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
('".$_POST['pageID']."','','Salary Approve','Salary Status','".$_SESSION['user']['id']."','".$_SESSION['user']['user_type']."','$currentDate')");
}
if ($result) {
echo "<script>
window.alert('Activated successfully.');
window.location.href = 'salary-management.php';
</script>";
}
}
if (isset($_POST['inactive'])) {
// Handle the inactive logic here
$checkedIDs = $_POST['checkedIDs'];
foreach ($checkedIDs as $pageID) {
$sql = "UPDATE salary_manage SET status='Pending' 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
('".$_POST['pageID']."','','Salary Pending','Salary Status','".$_SESSION['user']['id']."','".$_SESSION['user']['user_type']."','$currentDate')");
}
if ($result) {
echo "<script>
window.alert('Deactivated successfully.');
window.location.href = 'salary-management.php';
</script>";
}
}
if (isset($_POST['delete'])) {
// Handle the inactive logic here
$checkedIDs = $_POST['checkedIDs'];
foreach ($checkedIDs as $pageID) {
$sql = "DELETE FROM `salary_manage` 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
('".$_POST['pageID']."','','Salary Request Delete','Salary Status','".$_SESSION['user']['id']."','".$_SESSION['user']['user_type']."','$currentDate')");
}
if($result){
echo "<script>
window.alert('Deleted successfully.');
window.location.href = 'salary-management.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">Salary Management</h4>
<?php
// if ($_SESSION['user']['user_type'] == 'supadmin' ||
// $_SESSION['user']['user_type'] == 'admin') {
// echo '<button onclick="window.location.href=\'salary-management.php\'" class="float-left"> + Add Salary Management</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>Emp. Name</th>
<th>Emp. Supervisor</th>
<th>Emp. Company</th>
<th class="">Emp. Salary</th>
<th class="">Day Salary</th>
<th class="">Date</th>
<th class="">Status</th>
<th class="">Slip Img</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'] : '';
$s = mysqli_fetch_assoc(mysqli_query($db, "select * from tbl_employee where emp_name='".$searchTerm."' "));
$sid = $s['emp_id'];
$sql = "SELECT * FROM `salary_manage`";
if (!empty($searchTerm)) {
$sql .= " WHERE `date` LIKE '%$searchTerm%' OR `emp_id` LIKE '%$sid%'";
}
$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
$s = mysqli_fetch_assoc(mysqli_query($db, "select * from tbl_employee where emp_id='".$data["emp_id"]."' "));
echo $s['emp_name'] . '-' . $s['emp_number'];
?>
</td>
<td>
<?php
$d = mysqli_fetch_assoc(mysqli_query($db, "select * from login_tbl where id='".$s["emp_supervisor_id"]."' "));
echo $d['name'];
?>
</td>
<td>
<?php
$ds = mysqli_fetch_assoc(mysqli_query($db, "select * from tbl_customer where cus_id='".$s["emp_company_id"]."' "));
echo $ds['cp_name'];
?>
</td>
<td>₹<?php echo $s['slr']; ?> </td>
<?php
$salary = $s['slr']; // Monthly salary
$dth = $data['date'];
$month = date('m', strtotime($data['date'])); // May (Month 5)
$year = date('Y', strtotime($data['date']));
$daysInMonth = cal_days_in_month(CAL_GREGORIAN, $month, $year);
$dailySalary = $salary / $daysInMonth;
?>
<td>
<a target="_blank" href="show.php?id=<?php echo $data["emp_id"]; ?>"><i class="ri-eye-fill" style="font-size: medium; color: #1a2942;" title="View"></i> </a>
<?php
//number_format($dailySalary, 2)
// $ds = mysqli_query($db, "select * from tbl_attendance where atndc_by_id='".$data["emp_id"]."' and atndc_datetime like '%$dth%' and status='P' ; ");
// echo "</br>Total P. : ". mysqli_num_rows($ds);
// $ds = mysqli_query($db, "select * from tbl_attendance where atndc_by_id='".$data["emp_id"]."' and atndc_datetime like '%$dth%' and status='A' ; ");
// echo "</br>Total A. : ". mysqli_num_rows($ds);
?>
</td>
<td><?php echo $data['date']; ?> </td>
<td><?php echo $data['status']; ?> </td>
<td>
<a target="_blank" href="./images/<?php echo $data['slip_img']; ?>"><i class="ri-eye-fill" style="font-size: medium; color: #1a2942;" title="View"></i> </a>
</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["emp_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" >Pending</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 `salary_manage`";
if (!empty($searchTerm)) {
$sqlCount .= " WHERE `date` 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>