<?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']);