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('L', 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); // Header $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 FOR - " . $student['STUDENT_ID'], 0, 1, 'C'); // Student Info $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
Name: $student_name
Class: $student_class
Sex: $student_sex
Position: $student_position
", true, false, false, false, ''); // Midterm Results $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, ''); $pdf->writeHTML('
ENGENG_AGG MTCMTC_AGG SSTSST_AGG SCISCI_AGG TotalT_AggDivision
' . ($midterm['ENG'] ?? '') . '' . ($midterm['ENG_AGG'] ?? '') . ' ' . ($midterm['MTC'] ?? '') . '' . ($midterm['MTC_AGG'] ?? '') . ' ' . ($midterm['SST'] ?? '') . '' . ($midterm['SST_AGG'] ?? '') . ' ' . ($midterm['SCI'] ?? '') . '' . ($midterm['SCI_AGG'] ?? '') . ' ' . ($midterm['TOTAL_MARKS'] ?? '') . ' ' . ($midterm['TOTAL_AGG'] ?? '') . ' ' . ($midterm['DIVISION'] ?? '') . '
', true, false, false, false, ''); } // End of Term Results $pdf->writeHTML('

End of Term Results

', true, false, false, false, ''); $pdf->writeHTML('
ENGENG_AGG MTCMTC_AGG SSTSST_AGG SCISCI_AGG TotalT_AggDivision
' . ($student['ENG'] ?? '') . '' . ($student['ENG_AGG'] ?? '') . ' ' . ($student['MTC'] ?? '') . '' . ($student['MTC_AGG'] ?? '') . ' ' . ($student['SST'] ?? '') . '' . ($student['SST_AGG'] ?? '') . ' ' . ($student['SCI'] ?? '') . '' . ($student['SCI_AGG'] ?? '') . ' ' . ($student['TOTAL_MARKS'] ?? '') . ' ' . ($student['TOTAL_AGG'] ?? '') . ' ' . ($student['DIVISION'] ?? '') . '
', true, false, false, false, ''); $pdf->writeHTML('Class Teacher\'s Comment: ' . ($student['REMARKS'] ?? ''), true, false, false, false, ''); // Requirements $pdf->Ln(1); $pdf->SetFont('helvetica', 'B', 12); $pdf->writeHTML('Requirements', true, false, false, false, ''); $requirementsTable = '
ItemStatus
PARENTS CONTRIBUTIONPaid at Bank with Pay Code
A REAM OF DOUBLE A PAPERProvided
4 ROLLS OF TOILET PAPERProvided
'; $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 = 'No comment available.'; } $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(); // Clear any output to avoid header issues $pdf->Output("Class_Report_$class.pdf", 'I'); exit; } ?>