$MontoGeneral = $cnf['Valor'];
} else {
$cnf = $conf->mostrarConfig("MontoGeneral");
$MontoGeneral = $cnf['Valor'];
}
$valuesDoc = array('CodDocumento' => 'Null', 'CodAlumno' => $CodAlumno, 'CertificadoNac' => $CertificadoNac, 'LibretaEsc' => $LibretaEsc, 'LibretaVac' => $LibretaVac, 'CedulaId' => $CedulaId, 'CedulaIdP' => $CedulaIdP, 'CedulaIdM' => $CedulaIdM, 'Observaciones' => "LOWER('{$ObservacionesDoc}')");
$valuesAl = array('CodAlumno' => "{$CodAlumno}", 'Paterno' => "LOWER('{$Paterno}')", 'Materno' => "LOWER('{$Materno}')", 'Nombres' => "LOWER('{$Nombres}')", 'Sexo' => $Sexo, 'LugarNac' => "LOWER('{$LugarNac}')", 'FechaNac' => "'{$FechaNac}'", 'Ci' => "'{$Ci}'", 'CiExt' => "'{$CiExt}'", 'Zona' => "LOWER('{$Zona}')", 'Calle' => "LOWER('{$Calle}')", 'Numero' => "LOWER('{$Numero}')", 'TelefonoCasa' => "'{$TelefonoCasa}'", 'Celular' => "'{$Celular}'", 'CelularSMS' => "'{$CelularSMS}'", 'ActivarSMS' => "'{$ActivarSMS}'", 'Procedencia' => "LOWER('{$Procedencia}')", 'Repitente' => $Repitente, 'Traspaso' => $Traspaso, 'Becado' => $Becado, 'MontoBeca' => $MontoBeca, 'PorcentajeBeca' => $PorcentajeBeca, 'Retirado' => $Retirado, 'FechaRetiro' => "'{$FechaRetiro}'", 'Rude' => "'{$Rude}'", 'Observaciones' => "LOWER('{$Observaciones}')", 'ApellidosPadre' => "LOWER('{$ApellidosPadre}')", 'NombrePadre' => "LOWER('{$NombrePadre}')", 'CiPadre' => "'{$CiPadre}'", 'CiExtP' => "'{$CiExtP}'", 'OcupPadre' => "LOWER('{$OcupPadre}')", 'CelularP' => "'{$CelularP}'", 'ApellidosMadre' => "LOWER('{$ApellidosMadre}')", 'NombreMadre' => "LOWER('{$NombreMadre}')", 'CiMadre' => "'{$CiMadre}'", 'CiExtM' => "'{$CiExtM}'", 'OcupMadre' => "LOWER('{$OcupMadre}')", 'CelularM' => "'{$CelularM}'", 'Email' => "LOWER('{$Email}')", 'Nit' => "'{$Nit}'", 'FacturaA' => "LOWER('{$FacturaA}')", 'CodCurso' => $CodCurso, 'FechaIns' => "'{$FechaInsc}'", 'HoraIns' => "'{$HoraIns}'", 'UsuarioAlumno' => "'{$CodUsuarioAlumno}'", 'CodBarra' => "'{$CodBarra}'", 'Password' => "'{$Password}'", 'PasswordP' => "'{$PasswordP}'", 'UsuarioPadre' => "'{$UsuarioPadre}'");
$fechaCuota = date("Y-m-d H:i:s");
for ($i = 1; $i <= 10; $i++) {
if ($i == 1) {
$valuesCuota = array('CodCuota' => 'NULL', 'CodAlumno' => $CodAlumno, 'Numero' => $i, 'MontoPagar' => $MontoGeneral, 'Factura' => "''", 'Cancelado' => 0, 'Fecha' => "'{$fechaCuota}'", 'Observaciones' => "''");
} else {
$valuesCuota = array('CodCuota' => 'NULL', 'CodAlumno' => $CodAlumno, 'Numero' => $i, 'MontoPagar' => $MontoPagar, 'Factura' => "''", 'Cancelado' => 0, 'Fecha' => "'{$fechaCuota}'", 'Observaciones' => "''");
}
//echo "<br>";
//print_r($valuesCuota);
$cuota->guardar($valuesCuota);
}
if ($NombreFoto = subirArchivo($_FILES['Foto'], "imagenes/alumnos/")) {
$valuesAl = array_merge(array("Foto" => "'{$NombreFoto}'"), $valuesAl);
}
$alumno->insertarAlumno($valuesAl);
$documento->guardarDocumento($valuesDoc);
$valuesRude = array('CodAlumno' => $CodAlumno, 'PaisN' => "'" . $tmprude['PaisN'] . "'", 'ProvinciaN' => "'" . $tmprude['ProvinciaN'] . "'", 'LocalidadN' => "'" . $tmprude['LocalidadN'] . "'", 'Documento' => $tmprude['Documento'], 'CertOfi' => "'" . $tmprude['CertOfi'] . "'", 'CertLibro' => "'" . $tmprude['CertLibro'] . "'", 'CertPartida' => "'" . $tmprude['CertPartida'] . "'", 'CertFolio' => "'" . $tmprude['CertFolio'] . "'", 'Paralelo' => "'" . $tmprude['Paralelo'] . "'", 'Turno' => "'" . $tmprude['Turno'] . "'", 'CodigoSie' => "''", 'NombreUnidad' => "''", 'ProvinciaE' => "'" . $tmprude['ProvinciaE'] . "'", 'MunicipioE' => "'" . $tmprude['MunicipioE'] . "'", 'ComunidadE' => "'" . $tmprude['ComunidadE'] . "'", 'LenguaMater' => "'" . $tmprude['LenguaMater'] . "'", 'CastellanoI' => $tmprude['CastellanoI'], 'AymaraI' => $tmprude['AymaraI'], 'InglesI' => $tmprude['InglesI'], 'PerteneceA' => "'" . $tmprude['PerteneceA'] . "'", 'CentroSalud' => $tmprude['CentroSalud'], 'VecesCentro' => "'" . $tmprude['VecesCentro'] . "'", 'Discapacidad' => "'" . $tmprude['Discapacidad'] . "'", 'AguaDomicilio' => $tmprude['AguaDomicilio'], 'Electricidad' => $tmprude['Electricidad'], 'Alcantarillado' => $tmprude['Alcantarillado'], 'Trabaja' => "'" . $tmprude['Trabaja'] . "'", 'InternetCasa' => $tmprude['InternetCasa'], 'Transporte' => "'" . $tmprude['Transporte'] . "'", 'TiempoLlegada' => "'" . $tmprude['TiempoLlegada'] . "'", 'InstruccionP' => "'" . $tmprude['InstruccionP'] . "'", 'IdiomaP' => "'" . $tmprude['IdiomaP'] . "'", 'ParentescoP' => "'" . $tmprude['ParentescoP'] . "'", 'InstruccionM' => "'" . $tmprude['InstruccionM'] . "'", 'IdiomaM' => "'" . $tmprude['IdiomaM'] . "'", 'Lugar' => "'" . $tmprude['Lugar'] . "'", 'FechaReg' => "'" . date("Y-m-d H:i:s") . "'");
$classrude->insertarAlumno($valuesRude);
$tmpalumno->actualizarVisor($CodAlu);
include_once "../class/tmpcola.php";
$tmpcola = new tmpcola();
$tmpcola->insertarRegistro(array("CodAlumno" => $CodAlumno, "Estado" => "'Espera'"));
header("Location:../rude/esperarude/?CodAlumno=" . $CodAlumno);
}
<?php
include_once "../../login/check.php";
$Fecha = $_POST['Fecha'];
$Estado = $_POST['Estado'];
include_once "../../class/tmpcola.php";
include_once "../../class/alumno.php";
include_once "../../class/curso.php";
$tmpcola = new tmpcola();
$alumno = new alumno();
$curso = new curso();
$Estado = $Estado != "" ? "Estado LIKE '{$Estado}'" : "Estado LIKE '%'";
$tmp = $tmpcola->mostrarEspera("FechaRegistro='" . fecha2Str($Fecha, 0) . "' and {$Estado}");
if (count($tmp)) {
$i = 0;
?>
<table class="table table-hover table-bordered table-striped">
<thead>
<tr>
<th>N</th><th><?php
echo $idioma['Paterno'];
?>
</th><th><?php
echo $idioma['Materno'];
?>
</th><th><?php
echo $idioma['Nombres'];
?>
</th><th><?php
echo $idioma['Curso'];
?>
<?php include_once "login/check.php"; include_once "class/alumno.php"; include_once "class/documento.php"; include_once "class/rude.php"; include_once "class/factura.php"; include_once "class/facturadetalle.php"; include_once "class/cuota.php"; include_once "class/tmpcola.php"; include_once "class/tmp_alumno.php"; $alumno = new alumno(); $cuota = new cuota(); $rude = new rude(); $documento = new documento(); $tmp_alumno = new tmp_alumno(); $facturadetalle = new facturadetalle(); $factura = new factura(); $tmpcola = new tmpcola(); $alumno->vaciar(); $cuota->vaciar(); $rude->vaciar(); $documento->vaciar(); $factura->vaciar(); $facturadetalle->vaciar(); $tmpcola->vaciar(); $tmp_alumno->iniciar();
<?php
include_once "../../login/check.php";
$CodAlumno = $_GET['CodAlumno'];
$Ruta = $_GET['Ruta'];
include_once "../../class/tmpcola.php";
$tmpcola = new tmpcola();
$tmpcola->actualizarRegistro(array("Estado" => "'Proceso'"), "CodAlumno=" . $CodAlumno);
header("Location:" . $Ruta . "/index.php?CodAlumno=" . $CodAlumno);