|
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/destinytrafficsolutions/vendor/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
session_start();
if (!isset($_SESSION['id'])) {
header("Location: login.php");
exit;
}
include("inc/config.php");
?>
<!DOCTYPE html>
<html lang="en">
<?php require "inc/head.php"; ?>
<body>
<?php require "inc/header.php"; ?>
<div class="wrapper">
<?php require "inc/sidebar.php"; ?>
<div id="content">
<?php
if (isset($_SESSION['status']) && $_SESSION['status'] != '') {
?>
<div class="alert alert-warning alert-dismissible fade show" role="alert">
<strong>Hey!</strong> <?php echo $_SESSION['status']; ?>
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
</div>
<?php
unset($_SESSION['status']);
}
?>
<div class="row">
<div class="col-12">
<!-- Search and Date Filter Form -->
<form method="GET" class="mb-3">
<div class="row">
<div class="col-md-3">
<label for="start_date">Start Date:</label>
<input type="date" name="start_date" id="start_date" class="form-control"
value="<?php echo isset($_GET['start_date']) ? $_GET['start_date'] : ''; ?>">
</div>
<div class="col-md-3">
<label for="end_date">End Date:</label>
<input type="date" name="end_date" id="end_date" class="form-control"
value="<?php echo isset($_GET['end_date']) ? $_GET['end_date'] : ''; ?>">
</div>
<div class="col-md-3">
<label for="search">Search:</label>
<input type="text" name="search" id="search" class="form-control"
value="<?php echo isset($_GET['search']) ? $_GET['search'] : ''; ?>" placeholder="Enter keyword...">
</div>
<div class="col-md-3 d-flex align-items-end mt-2">
<button type="submit" class="btn btn-primary">Filter</button>
</div>
</div>
</form>
<div class="row mb-5">
<?php
// Base query
$query = "
SELECT t.*,
p.project_name,
e.photo,
e.mileage AS emp_mileage,
e.trvl_rate,
(e.mileage * e.trvl_rate) AS travel_amount
FROM tasks t
LEFT JOIN projects p ON t.project_name = p.id
LEFT JOIN employees e ON t.emp_name = CONCAT(e.femp_name, ' ', e.lemp_name)
WHERE 1 = 1";
// Apply date filter
if (!empty($_GET['start_date']) && !empty($_GET['end_date'])) {
$start_date = mysqli_real_escape_string($conn, $_GET['start_date']);
$end_date = mysqli_real_escape_string($conn, $_GET['end_date']);
$query .= " AND DATE(t.end_datetime) BETWEEN '$start_date' AND '$end_date'";
}
// Apply search filter
if (!empty($_GET['search'])) {
$search = mysqli_real_escape_string($conn, $_GET['search']);
$query .= " AND (t.task_name LIKE '%$search%'
OR p.project_name LIKE '%$search%'
OR t.emp_name LIKE '%$search%'
OR t.po_no LIKE '%$search%')";
}
$query_run = mysqli_query($conn, $query);
if (!$query_run) {
die("Query Error: " . mysqli_error($conn));
}
if (mysqli_num_rows($query_run) > 0) {
foreach ($query_run as $row) {
$grand_total = $row['total_amt'] + $row['travel_amount'];
?>
<div class="col-12 col-sm-6 col-xl-4 mb-4">
<h5 class="text-center"><?php echo htmlspecialchars($row['project_name']); ?></h5>
<div class="card redial-border-light redial-shadow">
<div class="media d-block d-sm-flex text-center text-sm-left p-3">
<a href="#">
<img src="<?php echo "employee/" . htmlspecialchars($row['photo']); ?>"
alt="Employee Image"
class="img-fluid rounded-circle mr-sm-3 mb-3 mb-sm-0"
width="40" height="39" />
</a>
<div class="media-body">
<a href="#"><h4><?php echo htmlspecialchars($row['emp_name']); ?></h4></a>
<ul class="list-unstyled redial-font-weight-600">
<li><b>PO No.:</b> <?php echo htmlspecialchars($row['po_no']); ?></li>
<li><b>Task Name:</b> <?php echo htmlspecialchars($row['task_name']); ?></li>
<li><b>Grand Total:</b>$ <?php echo number_format($grand_total, 2); ?></li>
</ul>
<a href="info-task.php?id=<?php echo $row['id']; ?>" class="btn btn-primary btn-xs mb-2">
<i class="icofont icofont-info-circle pr-1"></i>
</a>
<a href="update-task.php?id=<?php echo $row['id']; ?>" class="btn btn-primary btn-xs mb-2">
<i class="icofont icofont-edit"></i> Edit Task
</a>
<form action="add_task.php" method="post" style="display:inline-block;">
<input type="hidden" name="delete_id" value="<?php echo $row['id']; ?>">
<button type="submit" name="delete_task" class="btn btn-primary btn-xs mb-2" data-bs-toggle="tooltip" title="Delete Task">
<i class="icofont icofont-delete"></i>
</button>
</form>
<!-- <a href="update-task.php?id=<?php echo $row['id']; ?>" class="btn btn-primary btn-xs mb-2">
<i class="icofont icofont-delete"></i>
</a> -->
</div>
</div>
</div>
</div>
<?php
}
} else {
echo "<div class='col-12'><p class='text-center text-danger'>No records found.</p></div>";
}
?>
</div>
</div>
</div>
</div>
</div>
<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="dist/js/plugins.min.js"></script>
<script src="dist/js/common.js"></script>
</body>
</html>