prepare("
SELECT s.STUDENT_ID, s.STUDENT_NAME, s.CLASS, s.SEX
FROM STUDENTS s
WHERE s.STUDENT_ID = ? AND s.STATUS = 'Sponsored'
");
$stmt->execute([$student_id]);
$student = $stmt->fetch(PDO::FETCH_ASSOC);
if (!$student) {
ob_end_clean();
die('Student not found or not sponsored.');
}
// Get end of term results
$stmtEOT = $pdo->prepare("
SELECT * FROM RANKED_RESULTS
WHERE STUDENT_ID = ? AND TERM = ? AND YEAR = ?
");
$stmtEOT->execute([$student_id, $term, $year]);
$eot = $stmtEOT->fetch(PDO::FETCH_ASSOC);
// Get midterm results
$stmtMid = $pdo->prepare("
SELECT * FROM midterm_results
WHERE STUDENT_ID = ? AND CLASS = ? AND TERM = ? AND YEAR = ?
");
$stmtMid->execute([$student['STUDENT_ID'], $student['CLASS'], $term, $year]);
$midterm = $stmtMid->fetch(PDO::FETCH_ASSOC);
if (!$eot && !$midterm) {
ob_end_clean();
die('No report (midterm or end of term) found for the selected student.');
}
$pdf = new TCPDF('P', PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
$pdf->SetCreator('Luzira COU Primary School');
$pdf->SetAuthor('Luzira COU Primary School');
$pdf->SetTitle("Class Report - $class");
$pdf->setPrintHeader(false);
$pdf->setPrintFooter(false);
$pdf->SetMargins(5, 4, 5);
$pdf->SetAutoPageBreak(TRUE, 10);
$pdf->SetFont('helvetica', '', 10);
$commentsMap = [
'MTC' => [[0, 39, 'IMPROVE'], [40, 54, 'TRIED'], [55, 69, 'FAIR'], [70, 89, 'VGOOD'], [90, 100, 'EXCELLENT']],
'ENG' => [[0, 39, 'IMPROVE'], [40, 54, 'TRIED'], [55, 69, 'FAIR'], [70, 89, 'VGOOD'], [90, 100, 'EXCELLENT']],
'SST' => [[0, 39, 'IMPROVE'], [40, 54, 'TRIED'], [55, 69, 'FAIR'], [70, 89, 'VGOOD'], [90, 100, 'EXCELLENT']],
'SCI' => [[0, 39, 'IMPROVE'], [40, 54, 'TRIED'], [55, 69, 'FAIR'], [70, 89, 'VGOOD'], [90, 100, 'EXCELLENT']]
];
$initials = [
'P1' => ['MTC' => 'KA', 'ENG' => 'MA', 'SST' => 'JJ', 'SCI' => 'LL'],
'P2' => ['MTC' => 'KK', 'ENG' => 'HH', 'SST' => 'QQ', 'SCI' => 'DD'],
'P3' => ['MTC' => 'MN', 'ENG' => 'PA', 'SST' => 'RR', 'SCI' => 'EE'],
'P4' => ['MTC' => 'KS', 'ENG' => 'S', 'SST' => 'AS', 'SCI' => 'DM'],
'P5' => ['MTC' => 'NR', 'ENG' => 'NR', 'SST' => 'AD', 'SCI' => 'RI'],
'P6' => ['MTC' => 'AH', 'ENG' => 'AJ', 'SST' => 'BI', 'SCI' => 'BJ'],
'P7' => ['MTC' => 'OD', 'ENG' => 'SE', 'SST' => 'AP', 'SCI' => 'BY']
];
function getComment($subject, $mark, $commentsMap) {
foreach ($commentsMap[$subject] as $range) {
if ($mark >= $range[0] && $mark <= $range[1]) return $range[2];
}
return '';
}
// Header
$pdf->AddPage();
$pdf->Rect(5, 5, $pdf->getPageWidth() - 10, $pdf->getPageHeight() - 10);
$pdf->Image('logo.png', 7, 5, 20);
$pdf->SetFont('helvetica', 'B', 14);
$pdf->Cell(0, 10, 'LUZIRA CHURCH OF UGANDA PRIMARY SCHOOL', 0, 1, 'C');
$pdf->SetFont('helvetica', 'B', 11);
$pdf->Cell(0, 5, "P.O.BOX 20061, KAMPALA - Uganda", 0, 1, 'C');
$pdf->Cell(0, 5, "STUDENT'S TERMLY PROGRESSIVE REPORT - $term $year", 0, 1, 'C');
// Student Details
$student_position = $eot['POSITION'] ?? 'N/A';
$pdf->writeHTML("Pupil's Details
", true, false, false, false, '');
$pdf->writeHTML("
ID: {$student['STUDENT_ID']}
Name: {$student['STUDENT_NAME']}
Class: {$student['CLASS']}
Sex: {$student['SEX']}
Position: {$student_position}
", true, false, false, false, '');
// MIDTERM section
if ($midterm) {
$pdf->writeHTML('MIDTERM RESULTS
', true, false, false, false, '');
$midtermTable = '| LEARNING AREA | MARKS | OUT OF | AGG | COMMENT | INITIAL |
|---|
';
foreach ($commentsMap as $code => $ranges) {
$mark = $midterm[$code] ?? 0;
$agg = $midterm[$code.'_AGG'] ?? '';
$comment = getComment($code, $mark, $commentsMap);
$initial = $initials[$class][$code] ?? '';
$midtermTable .= "| $code | $mark | 100 | $agg | $comment | $initial |
";
}
$midtermTable .= "| TOTAL MARKS | {$midterm['TOTAL_MARKS']} | TOTAL AGG | {$midterm['TOTAL_AGG']} | DIVISION | {$midterm['DIVISION']} |
";
$midtermTable .= "
";
$pdf->writeHTML($midtermTable, true, false, false, false, '');
}
// END OF TERM section
if ($eot) {
$pdf->writeHTML('END OF TERM RESULTS
', true, false, false, false, '');
$eotTable = '| LEARNING AREA | MARKS | OUT OF | AGG | COMMENT | INITIAL |
|---|
';
foreach ($commentsMap as $code => $ranges) {
$mark = $eot[$code] ?? 0;
$agg = $eot[$code.'_AGG'] ?? '';
$comment = getComment($code, $mark, $commentsMap);
$initial = $initials[$class][$code] ?? '';
$eotTable .= "| $code | $mark | 100 | $agg | $comment | $initial |
";
}
$eotTable .= "| TOTAL MARKS | {$eot['TOTAL_MARKS']} | TOTAL AGG | {$eot['TOTAL_AGG']} | DIVISION | {$eot['DIVISION']} |
";
$eotTable .= "
";
$pdf->writeHTML($eotTable, true, false, false, false, '');
}
// Remarks if EOT
if ($eot && isset($eot['REMARKS'])) {
$pdf->writeHTML("Class Teacher's Comment: " . $eot['REMARKS'], true, false, false, false, '');
}
// Requirements
$pdf->Ln(2);
$pdf->SetFont('helvetica', 11);
$pdf->writeHTML('Requirements', true, false, false, false, '');
$requirementsTable = '| ITEM | STATUS |
|---|
PARENTS CONTRIBUTION:
P1-P2 Ugx75,000 P3-P6 Ugx85,000 P7 Ugx90,000 | Paid at Bank with Pay Code |
| A REAM OF DOUBLE A/DOLOPHINE/ROTATRIM PAPER | Provided by parent |
| 4 ROLLS OF TOILET PAPER | Provided by parent |
';
$pdf->writeHTML($requirementsTable, true, false, false, false, '');
// HT Comment
$div = $eot['DIVISION'] ?? $midterm['DIVISION'] ?? '';
$ht_comment = 'Avoid missing exams.';
if ($div === '1') $ht_comment = 'Excellent performance. Keep it up.';
elseif ($div === '2') $ht_comment = 'Good work. Aim higher.';
elseif ($div === '3') $ht_comment = 'Fair performance. Needs improvement.';
elseif (in_array($div, ['4', 'U'])) $ht_comment = 'Work harder next time.';
$pdf->Ln(2);
$pdf->writeHTML('Headteacher\'s Comment: ' . $ht_comment, true, false, false, false, '');
$pdf->Image('signature.png', $pdf->GetX(), $pdf->GetY(), 20);
$pdf->Ln(18);
$pdf->Cell(20, 3, 'Headteacher', 0, 1, 'L');
$pdf->Ln(2);
$pdf->SetFont('', 'BI');
$pdf->SetTextColor(255, 255, 255);
$pdf->SetFillColor(0, 0, 0);
$pdf->Cell(0, 6, 'Disclaimer: These results can be verified via our website https://luziracouprimaryschool.com/', 0, 1, 'R', true);
$filename = "{$student['STUDENT_NAME']}-{$class}-END OF TERM {$term} REPORT-{$year}.pdf";
ob_end_clean();
$pdf->Output($filename, 'I');
exit;
}
?>