prepare("SELECT c.name as class_name,
SUM(CASE WHEN a.status = 'hadir' THEN 1 ELSE 0 END) as hadir,
SUM(CASE WHEN a.status = 'sakit' THEN 1 ELSE 0 END) as sakit,
SUM(CASE WHEN a.status = 'izin' THEN 1 ELSE 0 END) as izin,
SUM(CASE WHEN a.status = 'alpa' THEN 1 ELSE 0 END) as alpa
FROM classes c
LEFT JOIN attendance a ON c.id = a.class_id AND a.attendance_date = ?
GROUP BY c.id");
$recap->execute([$date]);
$data = $recap->fetchAll();
?>
Rekap Absensi — <?= htmlspecialchars($date) ?>