prepare("
SELECT a.*, e.name_en, e.name_ar
FROM attendance_logs a
JOIN employees e ON a.employee_id = e.id
WHERE $where
ORDER BY a.date DESC, a.check_in DESC
LIMIT $limit OFFSET $offset
");
$logs->execute($params);
$logs = $logs->fetchAll(PDO::FETCH_ASSOC);
$total_logs = $pdo->prepare("SELECT COUNT(*) FROM attendance_logs a WHERE $where");
$total_logs->execute($params);
$total_rows = $total_logs->fetchColumn();
$total_pages = ceil($total_rows / $limit);
$employees = $pdo->query("SELECT id, name_en FROM employees ORDER BY name_en")->fetchAll(PDO::FETCH_KEY_PAIR);
// Handle Manual Add
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['add_attendance'])) {
$emp_id = $_POST['employee_id'];
$date = $_POST['date'];
$check_in = $_POST['check_in'] ? "$date " . $_POST['check_in'] : null;
$check_out = $_POST['check_out'] ? "$date " . $_POST['check_out'] : null;
$status = $_POST['status'];
$stmt = $pdo->prepare("INSERT INTO attendance_logs (employee_id, date, check_in, check_out, status, source) VALUES (?, ?, ?, ?, ?, 'Manual')");
$stmt->execute([$emp_id, $date, $check_in, $check_out, $status]);
echo "";
}
?>