| Server IP : 162.0.232.25 / Your IP : 3.137.174.253 Web Server : LiteSpeed System : Linux premium276.web-hosting.com 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : kwacuqig ( 988) PHP Version : 8.2.26 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/kwacuqig/gateman.skilltainment.org/ |
Upload File : |
<?php
include './head.php';
include './header.php';
include './sidebar.php';
if (isset($_GET['id'])) {
if (!empty($_GET['id'])) {
$id = $_GET['id'];
}
}
?>
<!--**********************************
Content body start
***********************************-->
<div class="content-body">
<!-- row -->
<div class="page-titles">
<ol class="breadcrumb">
<li>
<h5 class="bc-title">Attendance</h5>
</li>
<li class="breadcrumb-item"><a href="index.html">
<svg width="17" height="17" viewBox="0 0 17 17" fill="none" xmlns="http://www.w3.org/2000/svg">
<path d="M2.125 6.375L8.5 1.41667L14.875 6.375V14.1667C14.875 14.5424 14.7257 14.9027 14.4601 15.1684C14.1944 15.4341 13.8341 15.5833 13.4583 15.5833H3.54167C3.16594 15.5833 2.80561 15.4341 2.53993 15.1684C2.27426 14.9027 2.125 14.5424 2.125 14.1667V6.375Z" stroke="#2C2C2C" stroke-linecap="round" stroke-linejoin="round" />
<path d="M6.375 15.5833V8.5H10.625V15.5833" stroke="#2C2C2C" stroke-linecap="round" stroke-linejoin="round" />
</svg>
Home</a>
</li>
<li class="breadcrumb-item"><a href="javascript:void(0)">Attendance</a></li>
</ol>
</div>
<div class="container-fluid">
<div class="row">
<div class="col-xl-12">
<div class="card">
<div class="card-body p-0">
<div class="table-responsive active-projects style-1">
<div class="tbl-caption">
<h4 class="heading mb-0">
<?php
$run = mysqli_query($conn, "SELECT * FROM `users` WHERE `uid`=$id") or die(mysqli_error($conn));
$user = mysqli_fetch_array($run);
echo $user['firstname'] . ' ' . $user['surname'];
?>
</h4>
</div>
<table id="empoloyees-tblwrapper" class="table">
<thead>
<tr>
<th>Day</th>
<th>Date</th>
<th>In Time</th>
<th>Out Time</th>
<th>Status</th>
<th></th>
</tr>
</thead>
<tbody>
<?php
$run = mysqli_query($conn, "SELECT * FROM `attendance` WHERE `user_id`=$id ORDER BY `aid` DESC") or die(mysqli_error($conn));
while ($row = mysqli_fetch_array($run)) {
?>
<tr>
<td><?php echo date('l', $row['date']); ?></td>
<td><span><?php echo date('d M Y', $row['date']); ?></span></td>
<td><span><?php echo date('H:i', $row['in_time']); ?></span></td>
<td>
<span>
<?php
if ($row['out_time'] == '-') {
echo "--:--";
} else {
echo date('H:i', $row['out_time']);
}
?>
</span>
</td>
<td>
<span>
<?php
$hour = date('H', $row['in_time']);
$minutes = date('i', $row['in_time']);
if ($hour <= 7 && $minutes <= 30) {
echo "Punctual";
} else {
echo 'Not Punctual';
}
?>
</span>
</td>
<td><a href="delete-attendance.php?aid=<?php echo $row['aid'];?>" class="btn btn-danger" onclick="return confirm('Delete this <?php echo date('l', $row['date']);?> attendance?')"><i class="fa fa-trash"></i></a></td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!--**********************************
Content body end
***********************************-->
<?php
include './footer.php';
?>
<?php
include './scripts.php';
?>