0) {
$where[] = 's.staff_id = ?';
$bindings[] = $staffId;
}
if ($status !== '') {
$where[] = 's.status = ?';
$bindings[] = $status;
}
$whereClause = $where ? 'WHERE ' . implode(' AND ', $where) : '';
// Get squad data
$sql = "SELECT
s.squad_id,
s.squad_name,
s.exam_date,
s.session,
s.staff_id,
s.status,
s.created_at,
st.first_name,
st.last_name,
st.staff_code
FROM squads s
LEFT JOIN staff st ON s.staff_id = st.staff_id
$whereClause
ORDER BY s.exam_date DESC, s.session, s.squad_name, st.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)) {
$collegeSql = "SELECT DISTINCT col.college_id, col.college_name, col.college_code,
col.address, col.location, col.logo, col.seal
FROM squads s
LEFT JOIN staff st ON s.staff_id = st.staff_id
LEFT JOIN colleges col ON st.college_id = col.college_id
$whereClause
LIMIT 1";
$stmtCollege = $pdo->prepare($collegeSql);
foreach ($bindings as $index => $value) {
$stmtCollege->bindValue($index + 1, $value, is_int($value) ? PDO::PARAM_INT : PDO::PARAM_STR);
}
$stmtCollege->execute();
$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']
];
}
}
// Generate HTML report
?>
Squad Report
|
|
|
|
|
| No squad assignments found for the selected criteria |
Error";
echo "An error occurred: " . htmlspecialchars($e->getMessage()) . "
";
echo "Debug Info:
";
echo "";
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 "- Status: " . htmlspecialchars($_GET['status'] ?? 'Not set') . "
";
echo "
";
echo "Stack Trace:
";
echo "" . htmlspecialchars($e->getTraceAsString()) . "
";
}
?>