function PRESENT_CheckOUT_QUERY()
{
// Get session variables
$FROM_DATE = $_SESSION['FROM_DATE'];
$TO_DATE = $_SESSION['TO_DATE'];
$USERID = $_SESSION['USERID'];
// Query to fetch CheckOut data
$QUERY = "SELECT DISTINCT b.BADGENUMBER,
CONVERT(VARCHAR, CONVERT(DATE, a.CHECKTIME)) PRESENT_DATES_CHECKOUT,
CONVERT(VARCHAR, a.CHECKTIME, 108) CHECKOUT_TIME
FROM dbo.CHECKINOUT a
INNER JOIN dbo.USERINFO b
ON a.USERID = b.USERID
WHERE CONVERT(DATE, a.CHECKTIME) BETWEEN '$FROM_DATE' and '$TO_DATE'
AND (DATEPART(dw, CONVERT(DATE, a.CHECKTIME)) NOT IN (7,1))
AND b.DEFAULTDEPTID != 1008
AND b.USERID = '$USERID'
"; // Assuming 'OUT' represents a check-out action
return $QUERY;
}
<?php
// Check if the current row's total working days exists in the PRESENT_DATES_ARRAY
if (in_array($row['TOTAL_WORKING_DAYS'], $PRESENT_DATES_ARRAY)) {
// Find the index of the matching date in PRESENT_DATES_ARRAY
$index = array_search($row['TOTAL_WORKING_DAYS'], $PRESENT_DATES_ARRAY);
// Ensure the indices exist, otherwise fallback to "N/A"
$checkOutTime = isset($CHECKOUT_TIMES_ARRAY[$index]) ? $CHECKOUT_TIMES_ARRAY[$index] : "N/A";
// Display the present status with check-in and check-out times
echo "(Check-Out: " . $checkOutTime .")";
} else {
echo "ABSENT";
}
?>