prepare("SELECT * FROM RANKED_RESULTS WHERE CLASS = ? ORDER BY POSITION ASC");
$stmt->execute([$class]);
$students = $stmt->fetchAll(PDO::FETCH_ASSOC);
if (!$students) {
ob_end_clean();
die('No students 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);
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_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("Name: $student_name
Class: $student_class
Sex: $student_sex
Position: $student_position
", true, false, false, false, '');
$pdf->writeHTML("
", true, false, false, false, '');
$stmtMid = $pdo->prepare("SELECT * FROM midterm_results WHERE STUDENT_ID = ?");
$stmtMid->execute([$student['STUDENT_ID']]);
$midterm = $stmtMid->fetch(PDO::FETCH_ASSOC);
if ($midterm) {
$pdf->writeHTML('MIDTERM RESULTS
', true, false, false, false, '');
$midtermTable = '
| LEARNING AREA | MARKS OBTAINED | OUT OF | AGG | TEACHER\'S COMMENT | INITIAL |
';
$subjects = ['MTC' => 'MATHS', 'ENG' => 'ENGLISH', 'SST' => 'SST', 'SCI' => 'SCIENCE'];
foreach ($subjects as $code => $name) {
$agg = $midterm[$code.'_AGG'] ?? '';
$mark = $midterm[$code] ?? '';
$midtermTable .= "| $name | $mark | 100 | $agg | | |
";
}
$midtermTable .= '| GENERAL COMMENT: |
';
$pdf->writeHTML($midtermTable, true, false, false, false, '');
}
$pdf->writeHTML('END OF TERM RESULTS
', true, false, false, false, '');
$eotTable = '
| LEARNING AREA | MARKS OBTAINED | OUT OF | AGG | TEACHER\'S COMMENT | INITIAL |
';
foreach ($subjects as $code => $name) {
$agg = $student[$code.'_AGG'] ?? '';
$mark = $student[$code] ?? '';
$eotTable .= "| $name | $mark | 100 | $agg | | |
";
}
$eotTable .= '| GENERAL COMMENT: |
';
$pdf->writeHTML($eotTable, 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 |
| 4 ROLLS OF TOILET PAPER | Provided |
';
$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');
}
ob_end_clean();
$pdf->Output("Class_Report_$class.pdf", 'I');
exit;
}
?>