prepare("SELECT * FROM midterm_results WHERE CLASS = ? AND TERM = ? AND YEAR = ? ORDER BY DIVISION ASC");
$stmt->execute([$class, $term, $year]);
$students = $stmt->fetchAll(PDO::FETCH_ASSOC);
if (!$students) {
ob_end_clean();
die('No Reports found for this class.');
}
$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' => 'ZA', 'ENG' => 'ZA', 'SST' => 'ZA', 'SCI' => 'ZA'],
'P5' => ['MTC' => 'ZA', 'ENG' => 'ZA', 'SST' => 'ZA', 'SCI' => 'ZA'],
'P6' => ['MTC' => 'ZA', 'ENG' => 'ZA', 'SST' => 'ZA', 'SCI' => 'ZA'],
'P7' => ['MTC' => 'ZA', 'ENG' => 'ZA', 'SST' => 'ZA', 'SCI' => 'ZA']
];
function getComment($subject, $mark, $commentsMap) {
foreach ($commentsMap[$subject] as $range) {
if ($mark >= $range[0] && $mark <= $range[1]) return $range[2];
}
return '';
}
foreach ($students as $student) {
$pdf->AddPage();
$pdf->Rect(5, 5, $pdf->getPageWidth() - 10, $pdf->getPageHeight() - 10);
$pdf->Image('logo.png', 7, 5, 20);
$pdf->SetFont('helvetica', 'B', 16);
$pdf->Cell(0, 10, 'LUZIRA CHURCH OF UGANDA PRIMARY SCHOOL', 0, 1, 'C');
$pdf->SetFont('helvetica', 'B', 12);
$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_id = $student['STUDENT_ID'] ?? 'N/A';
$student_name = $student['STUDENT_NAME'] ?? 'N/A';
$student_class = $student['CLASS'] ?? 'N/A';
$student_sex = $student['SEX'] ?? 'N/A';
$student_position = $student['POSITION'] ?? 'N/A';
$pdf->writeHTML("Pupil's Details
", true, false, false, false, '');
$pdf->writeHTML("
ID: $student_id
Name: $student_name
Class: $student_class
Sex: $student_sex
", true, false, false, false, '');
$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);
// define midterm totals
$midterm_total = $midterm['TOTAL_MARKS'] ?? '';
$midterm_agg = $midterm['TOTAL_AGG'] ?? '';
$midterm_div = $midterm['DIVISION'] ?? '';
if ($midterm) {
$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[$class][$code] ?? '';
$midtermTable .= "| $code | $mark | 100 | $agg | $comment | $initial |
";
}
$midtermTable .= "
| TOTAL MARKS |
$midterm_total |
TOTAL AGG |
$midterm_agg |
DIVISION |
$midterm_div |
";
$pdf->writeHTML($midtermTable, true, false, false, false, '');
}
$pdf->writeHTML("Class Teacher's Comment: " . ($student['REMARKS'] ?? ''), true, false, false, false, '');
$pdf->Ln(1);
$pdf->SetFont('helvetica', 'B', 12);
$pdf->writeHTML('Requirements', true, false, false, false, '');
$requirementsTable = '| Item | Status |
|---|
| PARENTS CONTRIBUTION | Paid at Bank with Pay Code |
| A REAM OF DOUBLE A PAPER | Provided by parent |
| 4 ROLLS OF TOILET PAPER | Provided by parent |
';
$pdf->writeHTML($requirementsTable, true, false, false, false, '');
$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, '');
$yBefore = $pdf->GetY();
$pdf->Image('signature.png', $pdf->GetX(), $yBefore, 20);
$pdf->SetY($yBefore + 20);
$pdf->Cell(20, 3, 'Headteacher', 0, 1, 'L');
$pdf->Ln(1);
$pdf->SetFont('', 'BI'); // BOLD Italic
$pdf->SetTextColor(255, 255, 255); // White text
$pdf->SetFillColor(0, 0, 0); // Black background
$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); // Reset text color to black
$pdf->SetFont('', ''); // Reset font style
}
ob_end_clean();
$pdf->Output("Class_Report_$class.pdf", 'I');
exit;
}
?>