0) {
$where[] = 'id.hall_id = ?';
$bindings[] = $hallId;
}
if ($examDate !== '') {
$where[] = 'id.exam_date = ?';
$bindings[] = $examDate;
}
if ($session !== '') {
$where[] = 'id.session = ?';
$bindings[] = $session;
}
if ($staffId > 0) {
$where[] = 'id.staff_id = ?';
$bindings[] = $staffId;
}
if ($role !== '') {
$where[] = 'id.role = ?';
$bindings[] = $role;
}
if ($status !== '') {
$where[] = 'id.status = ?';
$bindings[] = $status;
}
$whereClause = $where ? 'WHERE ' . implode(' AND ', $where) : '';
// Get invigilation duties data
$sql = "SELECT
id.duty_id,
id.hall_id,
id.exam_date,
id.session,
id.staff_id,
id.role,
id.status,
id.created_at,
h.hall_name,
h.capacity,
s.first_name,
s.last_name,
s.staff_code,
ha.num_students
FROM invigilation_duties id
LEFT JOIN halls h ON id.hall_id = h.hall_id
LEFT JOIN staff s ON id.staff_id = s.staff_id
LEFT JOIN hall_allocations ha ON id.allocation_id = ha.allocation_id
$whereClause
ORDER BY id.exam_date DESC, id.session, h.hall_name, id.role, s.first_name";
$stmt = $pdo->prepare($sql);
foreach ($bindings as $index => $value) {
$stmt->bindValue($index + 1, $value, is_int($value) ? PDO::PARAM_INT : PDO::PARAM_STR);
}
$stmt->execute();
$data = $stmt->fetchAll(PDO::FETCH_ASSOC);
// Debug information
if (isset($_GET['debug']) && $_GET['debug'] === '1') {
echo "Debug Information:
";
echo "SQL Query: " . $sql . "
";
echo "Bindings: " . print_r($bindings, true) . "
";
echo "Data Count: " . count($data) . "
";
echo "Data:
";
echo "" . print_r($data, true) . "
";
exit;
}
// Get college information for header
$collegeInfo = null;
if (!empty($data)) {
// Try to get college info from staff table
$collegeSql = "SELECT DISTINCT col.college_id, col.college_name, col.college_code,
col.address, col.location, col.logo, col.seal
FROM staff s
LEFT JOIN colleges col ON s.college_id = col.college_id
WHERE s.staff_id = ?
LIMIT 1";
$stmtCollege = $pdo->prepare($collegeSql);
$stmtCollege->execute([$data[0]['staff_id']]);
$collegeData = $stmtCollege->fetch(PDO::FETCH_ASSOC);
if ($collegeData) {
$collegeInfo = [
'college_id' => $collegeData['college_id'],
'college_name' => $collegeData['college_name'],
'college_code' => $collegeData['college_code'],
'address' => $collegeData['address'],
'location' => $collegeData['location'],
'logo' => $collegeData['logo'],
'seal' => $collegeData['seal']
];
}
}
// Get exam details for header
$examDetails = null;
if (!empty($data)) {
$examDetails = [
'exam_date' => $data[0]['exam_date'],
'session' => $data[0]['session']
];
}
// Generate HTML report
?>
Invigilation Duties Report
|
|
|
|
|
|
|
| No invigilation duties found for the selected criteria |
Error";
echo "An error occurred: " . htmlspecialchars($e->getMessage()) . "
";
echo "Debug Info:
";
echo "";
echo "- Academic Year: " . htmlspecialchars($_GET['academic_year'] ?? 'Not set') . "
";
echo "- Course ID: " . htmlspecialchars($_GET['course_id'] ?? 'Not set') . "
";
echo "- Hall ID: " . htmlspecialchars($_GET['hall_id'] ?? 'Not set') . "
";
echo "- Exam Date: " . htmlspecialchars($_GET['exam_date'] ?? 'Not set') . "
";
echo "- Session: " . htmlspecialchars($_GET['session'] ?? 'Not set') . "
";
echo "- Staff ID: " . htmlspecialchars($_GET['staff_id'] ?? 'Not set') . "
";
echo "- Role: " . htmlspecialchars($_GET['role'] ?? 'Not set') . "
";
echo "- Status: " . htmlspecialchars($_GET['status'] ?? 'Not set') . "
";
echo "
";
echo "Stack Trace:
";
echo "" . htmlspecialchars($e->getTraceAsString()) . "
";
}
?>