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");
}
