<?php
include_once "../../login/check.php";
if (isset($_POST)) {
include_once "../../class/cuota.php";
include_once "../../class/alumno.php";
include_once "../../class/curso.php";
$cuota = new cuota();
$alumno = new alumno();
$curso = new curso();
$Desde = fecha2Str($_POST['Fecha'], 0);
$cuotas = $cuota->mostrarCuotasWhere("cuota c,alumno a", "a.Paterno,a.Materno,a.Nombres,a.CodCurso,c.*", "c.CodAlumno=a.CodALumno and DATE(c.Fecha) = '{$Desde}' and c.Cancelado=1 ", "a.CodCurso,c.Factura,c.Numero");
$MontoTotal = 0;
$i = 0;
if (count($cuotas)) {
foreach ($cuotas as $cuo) {
$MontoTotal += $cuo['MontoPagar'];
}
$MontoTotal = number_format($MontoTotal, 2);
?>
<a href="#" id="exportarexcel" class="btn btn-success btn-mini"><?php
echo $idioma['ExportarExcel'];
?>
</a>
<table class="table table-bordered table-striped table-hover inicio">
<thead>
<tr><th colspan="5" class="der"><?php
echo $idioma['Total'];
?>
<?php
echo $idioma['Del'];
$DesdeT = $idioma["Novena"];
break;
case 10:
$DesdeT = $idioma["Decima"];
break;
}
$CursoTexto = array_shift($curso->mostrarCurso($CodCurso));
$pdf = new PDF("P", "mm", "letter");
//612,792
$pdf->AddPage();
$i = 0;
$MontoTotal = 0;
$alumnos = $alumno->mostrarDatosAlumnos($CodCurso);
foreach ($alumnos as $al) {
$i++;
$cuotas = $cuota->mostrarCuotasWhere("", "*", "CodAlumno=" . $al['CodAlumno'] . " and Numero{$Or}{$Desde}", "Numero");
if (count($cuotas) <= $Desde) {
if ($i % 2 == 0) {
$relleno = 1;
} else {
$relleno = 0;
}
$pdf->CuadroCuerpo(15, $i, $relleno, "L");
$pdf->CuadroNombre(50, $al['Paterno'], $al['Materno'], $al['Nombres'], 0, $relleno);
$cantidad = 0;
foreach ($cuotas as $cuo) {
if ($cuo['Cancelado']) {
$cantidad++;
$pdf->CuadroCuerpo(10, $idioma["Si"], $relleno, "C");
} else {
$pdf->CuadroCuerpo(10, "", $relleno, "C");
include_once "../../class/alumno.php";
include_once "../../class/curso.php";
$cuota = new cuota();
$alumno = new alumno();
$curso = new curso();
$Desde = $_GET['Desde'];
$Hasta = $_GET['Hasta'];
$Tipo = $_GET['Tipo'];
$pdf = new PDF("P", "mm", "letter");
//612,792
$pdf->AddPage();
if ($Tipo == "Fecha") {
$Desde = date("Y-m-d", strtotime($Desde));
$Hasta = date("Y-m-d", strtotime($Hasta));
if ($Desde == $Hasta) {
$cuotas = $cuota->mostrarCuotasWhere("cuota c,alumno a", "a.Paterno,a.Materno,a.Nombres,a.CodCurso,c.*", "c.CodAlumno=a.CodALumno and DATE(c.{$Tipo}) = '{$Desde}' and c.Cancelado=1 ", "a.CodCurso,c.Factura,c.Numero");
} else {
$cuotas = $cuota->mostrarCuotasWhere("cuota c,alumno a", "a.Paterno,a.Materno,a.Nombres,a.CodCurso,c.*", "c.CodAlumno=a.CodALumno and DATE(c.{$Tipo}) BETWEEN '{$Desde}' and '{$Hasta}' and c.Cancelado=1 ", "a.CodCurso,c.Factura,c.Numero");
}
} else {
$cuotas = $cuota->mostrarCuotasWhere("cuota c,alumno a", "a.Paterno,a.Materno,a.Nombres,a.CodCurso,c.*", "c.CodAlumno=a.CodALumno and c.{$Tipo} BETWEEN {$Desde} and {$Hasta} and c.Cancelado=1 ", "a.CodCurso,c.Factura,c.Numero");
}
$i = 0;
$MontoTotal = 0;
foreach ($cuotas as $cuo) {
$i++;
$al = $alumno->mostrarTodoDatos($cuo['CodAlumno']);
$al = array_shift($al);
$nombre = explode(" ", $al['Nombres']);
$nombre = array_shift($nombre);
$cur = $curso->mostrarCurso($al['CodCurso']);
