prepare("
SELECT r.*,
(SELECT COUNT(*) FROM RANKED_RESULTS r2
WHERE r2.CLASS = r.CLASS AND r2.TERM = r.TERM AND r2.YEAR = r.YEAR) AS TOTAL_STUDENTS
FROM RANKED_RESULTS r
WHERE r.STUDENT_ID = ? AND r.TERM = ? AND r.YEAR = ?
");
$stmt->execute([$student_id, $term, $year]);
$student = $stmt->fetch(PDO::FETCH_ASSOC);
if (!$student) {
ob_end_clean();
die('No Report found for this 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("Student Report - " . $student['STUDENT_NAME']);
$pdf->setPrintHeader(false);
$pdf->setPrintFooter(false);
$pdf->SetMargins(5, 4, 5);
$pdf->SetAutoPageBreak(TRUE, 10);
$pdf->SetFont('helvetica', '', 10);
// ✅ Subject names
$subjectNames = [
'MTC' => 'Mathematics',
'ENG' => 'English',
'LIT1' => 'Literacy 1',
'LIT2' => 'Literacy 2',
'RE' => 'Religious Education',
'SST' => 'Social Studies',
'SCI' => 'Science'
];
// ✅ Comments mapping
$commentsMap = [
'MTC' => [[0,39,'Improve'], [40,54,'Tried'], [55,69,'Fair'], [70,89,'Very Good'], [90,100,'Excellent']],
'ENG' => [[0,39,'Improve'], [40,54,'Tried'], [55,69,'Fair'], [70,89,'Very Good'], [90,100,'Excellent']],
'SST' => [[0,39,'Improve'], [40,54,'Tried'], [55,69,'Fair'], [70,89,'Very Good'], [90,100,'Excellent']],
'SCI' => [[0,39,'Improve'], [40,54,'Tried'], [55,69,'Fair'], [70,89,'Very Good'], [90,100,'Excellent']]
];
// ✅ Teacher initials
$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'=>'NM'],
'P7' => ['MTC'=>'OD','ENG'=>'SE','SST'=>'AP','SCI'=>'BY']
];
// ✅ Comment generator
function getComment($subject, $mark, $commentsMap) {
if (!isset($commentsMap[$subject])) return '';
foreach ($commentsMap[$subject] as $range) {
if ($mark >= $range[0] && $mark <= $range[1]) return $range[2];
}
return '';
}
// Start Report
$pdf->AddPage();
$pdf->Rect(5, 5, $pdf->getPageWidth() - 10, $pdf->getPageHeight() - 10);
// ✅ Header
$pdf->Image('logo.png', 7, 5, 20);
$pdf->SetFont('helvetica', 'B', 14);
$pdf->Cell(0, 5, 'LUZIRA CHURCH OF UGANDA PRIMARY SCHOOL', 0, 1, 'C');
$pdf->SetFont('helvetica', 'B', 7);
$pdf->Cell(0, 5, "P.O.Box 20061, Kampala - Uganda Email: luziracouprim@ymail.com Website: https://luziracouprimaryschool.com", 0, 1, 'C');
$pdf->SetFont('helvetica', 'B', 10);
$pdf->Cell(0, 5, "STUDENT'S TERMLY PROGRESSIVE REPORT - $term $year", 0, 1, 'C');
$pdf->Ln(8);
// ✅ Student details
$pdf->Ln(5); // moves down 5 units (you can adjust)
$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']} out of {$student['TOTAL_STUDENTS']}
", true, false, false, false, '');
// ✅ 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 ($midterm) {
$pdf->Ln(5); // moves down 5 units (you can adjust)
$pdf->writeHTML('MIDTERM RESULTS
', true, false, false, false, '');
$midtermTable = '
| LEARNING AREA | MARKS OBTAINED | OUT OF | AGG | TEACHER\'S COMMENT | INITIAL |
';
foreach ($commentsMap as $code => $ranges) {
$mark = $midterm[$code] ?? 0;
$agg = $midterm[$code.'_AGG'] ?? '';
$comment = getComment($code, $mark, $commentsMap);
$initial = $initials[$student['CLASS']][$code] ?? '';
$subjectName = $subjectNames[$code] ?? $code;
$midtermTable .= "
| $subjectName | $mark | 100 | $agg | $comment | $initial |
";
}
$midtermTable .= "
| TOTAL MARKS | {$midterm['TOTAL_MARKS']} |
TOTAL AGG | {$midterm['TOTAL_AGG']} |
DIVISION {$midterm['DIVISION']} | |
";
$pdf->writeHTML($midtermTable, true, false, false, false, '');
}
// ✅ End of Term Results
$pdf->writeHTML('END OF TERM RESULTS
', true, false, false, false, '');
$eotTable = '
| LEARNING AREA | MARKS OBTAINED | OUT OF | AGG | TEACHER\'S COMMENT | INITIAL |
';
foreach ($commentsMap as $code => $ranges) {
$mark = $student[$code] ?? 0;
$agg = $student[$code.'_AGG'] ?? '';
$comment = getComment($code, $mark, $commentsMap);
$initial = $initials[$student['CLASS']][$code] ?? '';
$subjectName = $subjectNames[$code] ?? $code;
$eotTable .= "
| $subjectName | $mark | 100 | $agg | $comment | $initial |
";
}
$eotTable .= "
| TOTAL MARKS | {$student['TOTAL_MARKS']} |
TOTAL AGG | {$student['TOTAL_AGG']} |
DIVISION {$student['DIVISION']} | |
";
$pdf->writeHTML($eotTable, true, false, false, false, '');
// ✅ Teacher remarks
$pdf->Ln(5);
$pdf->writeHTML("Class Teacher's Comment: " . ($student['REMARKS'] ?? ''), true, false, false, false, '');
// ✅ Requirements
$pdf->Ln(5);
$pdf->SetFont('helvetica', 11);
$pdf->writeHTML('Requirements', true, false, false, false, '');
$requirementsTable = '
| Item | Status |
|---|
| PARENTS CONTRIBUTION: P1-P2 Ugx75,000 P3-P5 Ugx85,000 and P6-P7 UGX115,000 | Should be Paid at Bank with Pay Code |
| A REAM OF DOUBLE A/DOLOPHINE | Should be Provided by parent |
| 4 ROLLS OF TOILET PAPER | Should be Provided by parent |
';
$pdf->writeHTML($requirementsTable, true, false, false, false, '');
// ✅ Headteacher comment
$div = $student['DIVISION'];
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 ($div == '4' || $div == 'U') $ht_comment = 'Work harder next time.';
else $ht_comment = 'Avoid missing exams.';
$pdf->writeHTML('Headteacher\'s Comment: ' . $ht_comment, true, false, false, false, '');
// ✅ Signature
$yBefore = $pdf->GetY();
$pdf->Image('signature.png', $pdf->GetX(), $yBefore, 20);
$pdf->SetY($yBefore + 20);
$pdf->Cell(20, 3, 'Headteacher', 0, 1, 'L');
// ✅ Footer disclaimer
$pdf->Ln(1);
$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);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont('', '');
ob_end_clean();
$pdf->Output("Student_Report_{$student['STUDENT_NAME']}.pdf", 'I');
exit;
}
?>