public function consolidadoHistorialIndividualGalois($idSalon, $anio) { $pdf = new FPDF('P', 'cm', 'Letter'); $salon = new Salon(); $sal = $salon->leerSalonePorId($idSalon); $grado = new Grado(); $grad = $grado->leerGradoPorId($sal->getIdGrado()); $vec = array(); if ($grad->getIdGrado() == 'p1' || $grad->getIdGrado() == 'p2' || $grad->getIdGrado() == 'p3') { $seccion = 'PREESCOLAR'; $vec = ["PMAT", "PLEC", "ING", "PCN", "PCS", "ER", "EV", "ART", "EF", "COM"]; } else { if ($grad->getIdGrado() == '1' || $grad->getIdGrado() == '2' || $grad->getIdGrado() == '3' || $grad->getIdGrado() == '4' || $grad->getIdGrado() == '5') { $seccion = 'BASICA PRIMARIA'; $vec = ["MAT", "ING", "LC", "CN", "CS", "ER", "INF", "EF", "ART", "EV", "COM"]; } else { if ($grad->getIdGrado() == '6' || $grad->getIdGrado() == '7' || $grad->getIdGrado() == '8' || $grad->getIdGrado() == '9' || $grad->getIdGrado() == '10' || $grad->getIdGrado() == '11') { $seccion = 'BASICA SECUNDARIA'; if ($grad->getIdGrado() == '6' || $grad->getIdGrado() == '7' || $grad->getIdGrado() == '8') { $vec = ["AYG", "EST", "ING", "LC", "CN", "GEO", "HIS", "CONS", "ER", "INF", "EF", "ART", "EV", "COM"]; } else { if ($grad->getIdGrado() == '9') { $vec = ["ALYG", "EST", "ING", "LC", "CN", "GEO", "HIS", "CONS", "ER", "INF", "EF", "ART", "EV", "COM"]; } else { if ($grad->getIdGrado() == '10') { $vec = ["TRI", "EST", "ING", "LC", "QUI", "FIS", "FIL", "CS", "ER", "INF", "EF", "ART", "EV", "COM"]; } else { if ($grad->getIdGrado() == '11') { $vec = ["CALC", "EST", "ING", "LC", "QUI", "FIS", "FIL", "CS", "ER", "INF", "EF", "ART", "EV", "COM"]; } } } } } } } $persona = new Persona(); $personas = $persona->leerPorSalonYAnio($idSalon, $anio); foreach ($personas as $per) { $pdf->AddPage(); $pdf->SetFont("Arial", "B", 18); $pdf->SetXY(1, 1); $pdf->cell(19, 1, utf8_decode("CONSOLIDADO FINAL ACADEMICO"), 0, 0, "C"); $pdf->SetFont("Arial", "B", 15); $pdf->SetXY(1, 2); $pdf->SetTextColor(255, 0, 0); $pdf->cell(19, 1, utf8_decode($per->getPApellido() . " " . $per->getNombres()), 0, 0, "C"); $pdf->SetXY(1, 3); $pdf->SetTextColor(0, 0, 0); $pdf->cell(19, 1, utf8_decode("AÑO: " . $anio . ", SALÓN: " . $idSalon), 0, 0, "C"); //_____________________________ $x = 6.5; $y = 5; $pdf->SetXY($x, $y); $pdf->SetFont("Arial", "B", 10); $pdf->Cell(6, 1, "MATERIA", 1, 0, "C"); $pdf->SetXY($x + 6, $y); $pdf->SetFont("Arial", "B", 10); $pdf->Cell(2, 1, "NOTA", 1, 0, "C"); $cont = 0; $sum = 0; foreach ($vec as $v) { $y++; $cont++; $pdf->SetFont("Arial", "", 10); $nota = new Historial(); $not = $nota->leerNotaEstudiante($anio, $per->getIdPersona(), $v); $mate = new Materia(); $materias = $mate->leerMateriaPorId($v); foreach ($materias as $materia) { $nombreMateria = $materia->getNombreMateria(); } $pdf->SetXY($x, $y); $pdf->SetFont("Arial", "B", 10); $pdf->Cell(6, 1, $nombreMateria, 1, 0, "C"); $n = $not->getDefinitiva(); $pdf->SetXY($x, $y); if ($n < 30) { $pdf->SetTextColor(255, 0, 0); } $pdf->SetXY($x + 6, $y); $pdf->SetFont("Arial", "", 10); $pdf->Cell(2, 1, $n, 1, 0, "C"); $pdf->SetTextColor(0, 0, 0); $sum += $n; } $y++; $prom = round($sum / $cont, 2); $pdf->SetFont("Arial", "B", 14); $pdf->SetXY(1, $y); $pdf->cell(19, 1, utf8_decode("Promedio: " . $prom), 0, 0, "C"); } $pdf->Output("Consolidado " . $idSalon, "I"); }