|
Server IP : 103.53.40.154 / Your IP : 18.223.213.76 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/thedigitaldubai.com/../aiidm.in/../skyinfra.net/../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_daily_task 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']."','','Task Approve','Task Report','".$_SESSION['user']['id']."','".$_SESSION['user']['user_type']."','$currentDate')");
}
if ($result) {
echo "<script>
window.alert('Approve successfully.');
window.location.href = 'reporting.php';
</script>";
}
}
if (isset($_POST['inactive'])) {
// Handle the inactive logic here
$checkedIDs = $_POST['checkedIDs'];
foreach ($checkedIDs as $pageID) {
$sql = "UPDATE tbl_daily_task SET status='Disapprove' 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']."','','Task Disapprove','Task Report','".$_SESSION['user']['id']."','".$_SESSION['user']['user_type']."','$currentDate')");
}
if ($result) {
echo "<script>
window.alert('Disapprove successfully.');
window.location.href = 'reporting.php';
</script>";
}
}
if (isset($_POST['delete'])) {
// Handle the inactive logic here
$checkedIDs = $_POST['checkedIDs'];
foreach ($checkedIDs as $pageID) {
$imgde = mysqli_query($db, "select * from `tbl_daily_task` WHERE id='$pageID'");
$row = mysqli_fetch_assoc($imgde);
$im1 = $row['task_image'];
$im2 = $row['task_image2'];
$im3 = $row['task_image3'];
$im4 = $row['task_image4'];
$im5 = $row['task_image5'];
$im6 = $row['task_image6'];
unlink('./images/employee/task-report/'.$im1);
unlink('./images/employee/task-report/'.$im2);
unlink('./images/employee/task-report/'.$im3);
unlink('./images/employee/task-report/'.$im4);
unlink('./images/employee/task-report/'.$im5);
unlink('./images/employee/task-report/'.$im6);
$sql = "DELETE FROM `tbl_daily_task` 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']."','','Delete Task Req.','Task Report','".$_SESSION['user']['id']."','".$_SESSION['user']['user_type']."','$currentDate')");
}
if($result){
echo "<script>
window.alert('Deleted successfully.');
window.location.href = 'reporting.php';
</script>";
}
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<?php include "top-links.php"?>
<style>
/* Style for the popup and overlay */
.popup {
display: none;
position: fixed;
z-index: 1;
left: 0;
top: 0;
width: 100%;
height: 100%;
overflow: auto;
background-color: rgba(0,0,0,0.8);
}
.popup-content {
margin: auto;
padding-top: 80px;
display: block;
width: auto;
height: 90%;
max-width: 400px;
}
.close {
position: absolute;
top: 20px;
right: 35px;
color: #fff;
font-size: 40px;
font-weight: bold;
transition: 0.3s;
}
.close:hover,
.close:focus {
color: #bbb;
text-decoration: none;
cursor: pointer;
}
</style>
</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 Reporting</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>Task Time</th>
<th>Employee Detail</th>
<th>Image 1</th>
<th>Image 2</th>
<th>Image 3</th>
<th>Image 4</th>
<th>Image 5</th>
<th>Image 6</th>
<th>Date & Time</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_daily_task`";
// $sql = "SELECT * FROM `tbl_daily_task` WHERE datetime LIKE '%$date%' ";
if (!empty($searchTerm)) {
$sql .= " WHERE task_emp_id ='$searchTerm' OR `datetime` 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['task_title']; ?> </td>
<td>
<?php
$d = mysqli_fetch_assoc(mysqli_query($db, "select * from tbl_employee where emp_id='".$data["task_emp_id"]."' "));
echo $d['emp_name'] .'<br>';
?>
<?php
$company_id=$d["emp_company_id"];
$d = mysqli_fetch_assoc(mysqli_query($db, "select * from tbl_customer where cus_id='$company_id' "));
?>
<?php echo $d['cp_name']; ?> - <?php echo $d['cust_address']; ?> - <?php echo $d['cust_state']; ?>
</td>
<td>
<img src="./images/employee/task-report/<?php echo $data['task_image']; ?>" width="50px" onclick="openPopup(this)">
</td>
<td>
<img src="./images/employee/task-report/<?php echo $data['task_image2']; ?>" width="50px" onclick="openPopup(this)">
</td>
<td>
<img src="./images/employee/task-report/<?php echo $data['task_image3']; ?>" width="50px" onclick="openPopup(this)">
</td>
<td>
<img src="./images/employee/task-report/<?php echo $data['task_image4']; ?>" width="50px" onclick="openPopup(this)">
</td>
<td>
<img src="./images/employee/task-report/<?php echo $data['task_image5']; ?>" width="50px" onclick="openPopup(this)">
</td>
<td>
<img src="./images/employee/task-report/<?php echo $data['task_image6']; ?>" width="50px" onclick="openPopup(this)">
</td>
<td> <?php echo $data['datetime']; ?></td>
<?php
$status = $data['status'];
$class = '';
switch ($status) {
case 'Pending':
$class = 'btn-dark';
break;
case 'Disapprove':
$class = 'btn-danger';
break;
case 'Approve':
$class = 'btn-info';
break;
default:
$class = 'btn-dark';
break;
}
?>
<!--<td> <?php echo $data['status']; ?></td>-->
<td><button class="btn <?php echo $class; ?> pull-right mr5"><?php echo $status; ?></button></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["task_emp_id"]?>">
</td>
<!--<td><a href="#"><i class="ri-edit-fill" style="font-size: medium; color: green;"></i> </a></td>-->
<div id="popup" class="popup">
<span class="close" onclick="closePopup()">×</span>
<img class="popup-content" id="popup-image">
</div>
</tr>
<?php } ?>
</tbody>
<tfoot>
<tr style="text-align: right;">
<td colspan="12" 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_daily_task`";
if (!empty($searchTerm)) {
$sqlCount .= " WHERE `task_title` 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>
<script>
function openPopup(element) {
var popup = document.getElementById("popup");
var popupImg = document.getElementById("popup-image");
popup.style.display = "block";
popupImg.src = element.src.replace('50px', '200px');
}
function closePopup() {
var popup = document.getElementById("popup");
popup.style.display = "none";
}
// Close the popup if the user clicks outside of the image
window.onclick = function(event) {
var popup = document.getElementById("popup");
if (event.target == popup) {
popup.style.display = "none";
}
}
</script>
<?php include "footer.php"?>
</body>
</html>