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(7, 8, 7); $pdf->SetAutoPageBreak(false); $pdf->SetFont('helvetica', '', 9); $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, $map) { foreach ($map[$subject] as $range) { if ($mark >= $range[0] && $mark <= $range[1]) return $range[2]; } return ''; } $reportCount = 0; $reportsPerPage = 2; $reportHeight = 145; // fits 2 on A4 (297mm) foreach ($students as $student) { if ($reportCount % $reportsPerPage === 0) { $pdf->AddPage(); } $startY = 8 + ($reportHeight * ($reportCount % $reportsPerPage)); $pdf->SetY($startY); $pdf->SetFont('helvetica', '', 9); // Header & Logo // Centered logo + text block using a table $headerHTML = '

LUZIRA CHURCH OF UGANDA PRIMARY SCHOOL
P.O.BOX 20061, KAMPALA - Uganda
STUDENT\'S MIDTERM RESULTS - '.htmlspecialchars($term).' '.htmlspecialchars($year).'

'; // Write the header table $pdf->writeHTML($headerHTML, true, false, false, false, ''); // Add a bit of spacing below to avoid overlap with next content $pdf->Ln(3); // Student Info $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'; $pdf->writeHTML("ID: $student_id Name: $student_name Class: $student_class Sex: $student_sex", true, false, false, false, ''); // Midterm Data $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); $midterm_total = $midterm['TOTAL_MARKS'] ?? ''; $midterm_agg = $midterm['TOTAL_AGG'] ?? ''; $midterm_div = $midterm['DIVISION'] ?? ''; if ($midterm) { $midtermTable = ''; foreach ($commentsMap as $code => $ranges) { $mark = $midterm[$code] ?? 0; $agg = $midterm[$code.'_AGG'] ?? ''; $comment = getComment($code, $mark, $commentsMap); $initial = $initials[$class][$code] ?? ''; $midtermTable .= ""; } $midtermTable .= "

SUBJECT	MARK	OUT OF	AGG	COMMENT	INITIAL
$code	$mark	100	$agg	$comment	$initial
Total	$midterm_total	400	$midterm_agg	Div: $midterm_div

"; $pdf->writeHTML($midtermTable, true, false, false, false, ''); } // Class teacher comment $pdf->writeHTML("Class Teacher's Comment: " . ($student['REMARKS'] ?? ''), true, false, false, false, ''); // Add spacing and title before Requirements table $pdf->Ln(2); // vertical space before the title $pdf->writeHTML('

Requirements

', true, false, false, false, ''); // Now the table $requirements = '

Item	Status
PARENTS CONTRIBUTION	Bank
REAM OF DOUBLE A PAPER	Provided
4 ROLLS OF TISSUE	Provided

'; $pdf->writeHTML($requirements, 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 and footer $sigY = $pdf->GetY(); $pdf->Image('signature.png', $pdf->GetX(), $sigY, 15); $pdf->SetY($sigY + 12); $pdf->Cell(30, 5, 'Headteacher', 0, 1, 'L'); $pdf->SetFont('', 'BI'); $pdf->SetTextColor(255, 255, 255); $pdf->SetFillColor(0, 0, 0); $pdf->Cell(0, 5, 'Verify results via https://luziracouprimaryschool.com/', 0, 1, 'R', true); $pdf->SetTextColor(0, 0, 0); $pdf->SetFont('', ''); $reportCount++; } ob_end_clean(); $pdf->Output("Class_Report_$class.pdf", 'I'); exit; } ?>