query("SELECT id, course_name FROM courses ORDER BY course_name ASC")->fetchAll(PDO::FETCH_ASSOC);
$teachers = $conn->query("SELECT id, name FROM teachers ORDER BY name ASC")->fetchAll(PDO::FETCH_ASSOC);
// 2. الاستعلام الأساسي - تم إضافة جلب session_token للتمييز بين الجلسات
$query = "
SELECT
a.attendance_date,
a.status,
a.hours_count,
a.teacher_name,
a.session_token,
s.full_name as student_name,
s.phone as student_phone,
c.course_name
FROM attendance a
JOIN students s ON a.student_id = s.id
JOIN courses c ON a.course_id = c.id
ORDER BY a.attendance_date DESC, a.id DESC
";
$stmt = $conn->prepare($query);
$stmt->execute();
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>