|
Server IP : 162.214.80.37 / Your IP : 216.73.216.83 Web Server : Apache System : Linux sh013.webhostingservices.com 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64 User : imyrqtmy ( 2189) PHP Version : 8.2.18 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home2/imyrqtmy/public_html/dts/vendor/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
// error_reporting(E_ALL);
// ini_set('display_errors', 1);
session_start();
$se = $_SESSION["id"];
if (!isset($_SESSION['id'])) {
header("Location: login.php");
}
include("inc/config.php");
?>
<!DOCTYPE html>
<html lang="en">
<?php require "inc/head.php"; ?>
<body>
<!-- header-->
<?php require "inc/header.php"; ?>
<div class="wrapper">
<?php require "inc/sidebar.php"; ?>
<div id="content">
<div class="row">
<div class="col-sm-12">
<div class="row mb-xl-4 mb-0">
<?php
$start_date = isset($_GET['start_date']) ? $_GET['start_date'] : '';
$end_date = isset($_GET['end_date']) ? $_GET['end_date'] : '';
if (!isset($_SESSION['id'])) {
die("Unauthorized access.");
}
$se = $_SESSION['id'];
// $query = "SELECT p.*, e.emp_name, c.v_name, c.photo
// FROM projects p
// LEFT JOIN employees e ON p.emp_id = e.id
// LEFT JOIN categories c ON p.category_id = c.id
// WHERE p.emp_id = '$se'";
$query = "SELECT p.*, e.emp_name, c.v_name, c.photo
FROM projects p
LEFT JOIN employees e ON p.emp_id = e.id
LEFT JOIN categories c ON FIND_IN_SET(c.id, p.category_ids) > 0
WHERE p.emp_id = '$se'";
if (!empty($start_date) && !empty($end_date)) {
$query .= " AND p.project_start >= '$start_date' AND p.project_end <= '$end_date'";
}
$query_run = mysqli_query($conn, $query);
if (mysqli_num_rows($query_run) > 0) {
foreach ($query_run as $row) {
?>
<div class="col-12 col-sm-6 col-xl-3 mb-4 mb-xl-0">
<div class="card redial-border-primary redial-shadow redial-bg-primary text-white">
<div class="card-body">
<div class="media d-block d-sm-flex text-center text-sm-left">
<div class="d-md-flex align-self-center mx-auto mb-4 mb-sm-0 mr-0 mr-sm-3">
<?php if (!empty($row['photo'])) { ?>
<img src="<?php echo "../admin/category/" . htmlspecialchars($row['photo']); ?>" alt="Category Image" style="max-width: 70px; height: 37px;">
<?php } else { ?>
<img src="default-image.jpg" alt="No Image" style="max-width: 70px; height: 37px;">
<?php } ?>
</div>
<?php
// Get latest click count & timestamp
// $clickQuery = "SELECT click_count, clicked_at FROM click_records
// WHERE project_id = ? AND category_id = ? AND emp_id = ?
// ORDER BY id DESC LIMIT 1";
// $stmt = $conn->prepare($clickQuery);
// $stmt->bind_param("iii", $row['id'], $row['category_id'], $row['emp_id']);
$clickQuery = "SELECT click_count, clicked_at FROM click_records
WHERE project_id = ? AND FIND_IN_SET(category_id, ?) > 0 AND emp_id = ?
ORDER BY id DESC LIMIT 1";
$stmt = $conn->prepare($clickQuery);
$stmt->bind_param("isi", $row['id'], $row['category_ids'], $row['emp_id']);
$stmt->execute();
$clickResult = $stmt->get_result();
if ($clickRow = $clickResult->fetch_assoc()) {
$clickCount = $clickRow['click_count'];
$clickedAt = $clickRow['clicked_at'];
} else {
$clickCount = 0; // Default to 0 if no record exists
$clickedAt = "Never clicked";
}
?>
<div class="media-body">
<div class="text-center text-sm-right">
<h2 class="mb-1 redial-font-weight-400 text-white count"
id="count-<?php echo $row['id']; ?>" style="padding-right: 17px;">
<?php echo $clickCount; ?>
</h2>
<p class="mb-2" style="padding-right: 17px;">
<?php echo $row['v_name']; ?>
<i class="fa fa-plus add-click"
data-project="<?php echo $row['id']; ?>"
data-category="<?php echo $row['category_ids']; ?>"
data-emp="<?php echo $row['emp_id']; ?>"
aria-hidden="true" style="cursor: pointer;">
</i>
</p>
<p class="text-light">
Last Click: <span id="time-<?php echo $row['id']; ?>"><?php echo $clickedAt; ?></span>
</p>
</div>
</div>
</div>
</div>
</div>
</div>
<?php
}
}
?>
</div>
</div>
</div>
</div>
</div>
<!-- End main-content-->
<!-- Top To Bottom-->
<a href="#" class="scrollup text-center redial-bg-primary redial-rounded-circle-50 ">
<h4 class="text-white mb-0"><i class="icofont icofont-long-arrow-up"></i></h4>
</a>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script>
$(document).ready(function () {
$(".add-click").click(function () {
var project_id = $(this).data("project");
var category_id = $(this).data("category");
var emp_id = $(this).data("emp");
var countElement = $("#count-" + project_id);
var timeElement = $("#time-" + project_id);
$.ajax({
url: "update_click.php",
type: "POST",
data: { project_id: project_id, category_id: category_id, emp_id: emp_id },
dataType: "json",
success: function (response) {
if (response.success) {
countElement.text(response.newCount); // Update count in UI
timeElement.text(response.lastClicked); // Update last clicked time
} else {
alert("Error updating count.");
}
}
});
});
});
</script>
<script src="dist/js/plugins.min.js"></script>
<script src="dist/js/common.js"></script>
</body>
</html>