|
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
// session_start();
include("inc/config.php");
if (!isset($_SESSION['id'])) {
header("Location: login.php");
exit();
}
$se = $_SESSION['id'];
// Fetch projects for the logged-in employee
$query = "SELECT * FROM projects WHERE emp_id = ?";
$stmt = $conn->prepare($query);
$stmt->bind_param("i", $se);
$stmt->execute();
$result = $stmt->get_result();
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
// Decode category_ids from JSON to an array
$category_ids = json_decode($row['category_ids'], true);
if (!is_array($category_ids)) {
continue; // Skip if decoding fails
}
// Loop through each category ID
foreach ($category_ids as $category_id) {
// Fetch category details
$catQuery = "SELECT v_name, photo FROM categories WHERE id = ?";
$catStmt = $conn->prepare($catQuery);
$catStmt->bind_param("i", $category_id);
$catStmt->execute();
$catResult = $catStmt->get_result();
if ($catRow = $catResult->fetch_assoc()) {
// Fetch the latest click count and last clicked time for this project-category
$clickQuery = "SELECT click_count, clicked_at FROM click_records
WHERE project_id = ? AND category_id = ? AND emp_id = ?
ORDER BY id DESC LIMIT 1";
$clickStmt = $conn->prepare($clickQuery);
$clickStmt->bind_param("iii", $row['id'], $category_id, $row['emp_id']);
$clickStmt->execute();
$clickResult = $clickStmt->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="col-4 col-sm-6 col-xl-3 mb-4">
<!-- <div class="col-12 col-sm-6 col-xl-3 mb-4"> -->
<div class="card redial-border-primary redial-shadow redial-bg-primary text-white">
<div class="card-body">
<div class="text-center">
<h4 class="v_name"><?php echo htmlspecialchars($catRow['v_name']); ?></h4>
<img src="<?php echo "../admin/category/" . htmlspecialchars($catRow['photo']); ?>"
alt="Category Image" style="max-width: 70px; height: 37px;">
<p>Project: <?php echo htmlspecialchars($row['project_name']); ?></p>
<!-- Click Count Display -->
<h2 class="mb-1 redial-font-weight-400 text-white count"
id="count-<?php echo $row['id'] . '-' . $category_id; ?>">
<?php echo $clickCount; ?>
</h2>
<!-- Click Button -->
<p>
<i class="fa fa-plus add-click"
data-project="<?php echo $row['id']; ?>"
data-category="<?php echo $category_id; ?>"
data-emp="<?php echo $row['emp_id']; ?>"
aria-hidden="true" style="cursor: pointer;">
</i>
</p>
<!-- Last Clicked Time -->
<!-- <p class="text-light">
Last Click: <span id="time-<?php echo $row['id'] . '-' . $category_id; ?>">
<?php echo $clickedAt; ?>
</span>
</p> -->
</div>
</div>
</div>
</div>
<?php
}
}
}
} else {
echo "<p>No projects found.</p>";
}
?>
</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 + "-" + category_id);
var timeElement = $("#time-" + project_id + "-" + category_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="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);
timeElement.text(response.lastClicked);
} else {
alert("Error updating count.");
}
}
});
});
});
</script> -->
<script src="dist/js/plugins.min.js"></script>
<script src="dist/js/common.js"></script>
</body>
</html>