function Iva_excento() { $data = array(); $_SESSION['pagina_anterior'] = 'iva_excento'; $class_transaccion = new transaccion(); if (isset($_POST['mes_iva'])) { $_SESSION['mes_informe'] = $_POST['mes_iva']; } $mes_informe = isset($_SESSION['mes_informe']) ? $_SESSION['mes_informe'] : date("m", time()); $data['mes_informe'] = $mes_informe; $data['boletas'] = $class_transaccion->obtenerIVAexcento($_SESSION['base_datos']->anio . '-' . $mes_informe, true); $data['usuario'] = $_SESSION['usuario']->login; $this->load->view('SEC-iva_excento.php', $data); }
<?php session_start(); require "../main_Lib.php"; require "../smartyLib/Smarty.class.php"; include_once "../class/class_mensualidad.php"; include_once "../class/class_transaccion.php"; include_once '../class/class_curso.php'; include_once '../class/class_alumno.php'; $smarty = new Smarty(); require_once '../phpLib/SmartyToolbox.php'; validarAcceso(AuthUser::TIPO_SECRETARIA); smartyTemplate($smarty, "../"); $class_transaccion = new transaccion(); $class_curso = new curso(); $class_mensualidad = new mensualidad(); $class_alumno = new alumno(); $cursos = $class_curso->obtenerCursos(); $curso_ID = isset($_POST['curso_ID']) ? $_POST['curso_ID'] : $_SESSION['curso_ID']; $mes_selec_beca = isset($_POST['mes_selec_beca']) ? $_POST['mes_selec_beca'] : $_SESSION['mes_selec_beca']; if (!$mes_selec_beca) { $mes_selec_beca = date("m"); } $_SESSION['mes_selec_beca'] = $mes_selec_beca; $totales = array(); $becasAlumnos = array(); if ($curso_ID != null) { $alumnos = $class_alumno->obtenerAlumnos($curso_ID); $tot_monto = $tot_interes = $tot_beca = $tot_descuento = $tot_totalPagar = $tot_totalBeca = 0; foreach ($alumnos as $rut => $alumno) { $transacciones = $class_transaccion->obtenerTransaccionPorMes($rut, $mes_selec_beca);
function efectuarPagoAlumno($monto, $descuento, $rut, $trans_ID) { $class_transaccion = new transaccion(); $mensualidades = $this->obtenerMensualidad($rut); $beca = $mensualidades['descuentos'] * $mensualidades['mensualidad'] / 100; $mensualidades['cuota_real'] = $mensualidades['mensualidad'] - $beca; $total = $monto + $descuento; $abono_beca = 0; for ($i = 1; $i <= 10; $i++) { if ($total <= 0) { break; } $abono_cuota = $mensualidades['cuota_real'] - $mensualidades['c' . $i]; if ($abono_cuota > 0) { if ($total >= $abono_cuota) { $cuota_pago = $total == $abono_cuota ? "C" . $i : "Abono"; $pago_men['c' . $i] = $mensualidades['c' . $i] + $abono_cuota; $abono_beca += $beca; $total -= $abono_cuota; $class_transaccion->insertarDetalleTransaccion($trans_ID, $abono_cuota, "Pago", "c" . $i); } else { $pago_men['c' . $i] = $mensualidades['c' . $i] + $total; $cuota_pago = "Abono"; $class_transaccion->insertarDetalleTransaccion($trans_ID, $total, "Abono", "c" . $i); $total = 0; } } } DBSQLUpdate($pago_men, array("rut" => $rut), "mensualidades"); DBSQLUpdate(array("trans_beca" => $abono_beca), array("trans_ID" => $trans_ID), "transaccion"); return $cuota_pago; }
<?php require_once '../tcpdf/config/lang/eng.php'; require_once '../tcpdf/tcpdf.php'; require "../../../capaNegocio/transaccion_Rep.php"; $objTransaccion = new transaccion(); $perfil = ""; $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false); // set document information $pdf->SetCreator(PDF_CREATOR); $pdf->SetAuthor('http://codigoweblibre.comli.com'); $pdf->SetTitle('Reporte de Datos'); $pdf->SetSubject('Tutirial de reportes en PDF con PHP y MySQL'); $pdf->SetKeywords('Reporte, usuario, php, mysql'); $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED); //set margins $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT); $pdf->SetHeaderMargin(PDF_MARGIN_HEADER); $pdf->SetFooterMargin(PDF_MARGIN_FOOTER); //set auto page breaks $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM); //set image scale factor $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO); //set some language-dependent strings $pdf->setLanguageArray($l); // --------------------------------------------------------- // set default font subsetting mode $pdf->setFontSubsetting(true); $pdf->SetFont('helvetica', '', 9, '', true); // Add a page // This method has several options, check the source code documentation for more information.
<?php require "../main_Lib.php"; require "../smartyLib/Smarty.class.php"; include_once '../class/class_transaccion.php'; validarAcceso(AuthUser::TIPO_SECRETARIA); $smarty = new Smarty(); smartyTemplate($smarty, "../"); require_once '../phpLib/SmartyToolbox.php'; $class_transaccion = new transaccion(); if (isset($_POST['mes'])) { $_SESSION['mes_informe'] = $_POST['mes']; } $mes_informe = isset($_SESSION['mes_informe']) ? $_SESSION['mes_informe'] : date("m", time()); $transacciones = $class_transaccion->obtenerIVA19($_SESSION['base_datos']->anio . '-' . $mes_informe); $smarty->assign("mes_informe", $mes_informe); $smarty->assign("transacciones", $transacciones); $smarty->assign("file_content", "secretaria/SEC-iva19.tpl"); $smarty->display('LAYOUT-SEC-main.tpl');
<?php session_start(); require "../main_Lib.php"; include_once "../class/class_mensualidad.php"; include_once "../class/class_transaccion.php"; $rut = $_GET['rut']; $class_mensualidad = new mensualidad(); $class_transaccion = new transaccion(); $mensualidades = $class_mensualidad->obtenerMensualidad($rut); //dpr($mensualidades); $deuda_total = $mensualidades['deuda']; if ($_SESSION['token'] != $token) { session_destroy(); moveLocation("../ingreso.php", 0, 2); } if ($_POST['estado_pago'] == 1) { // dpr($_SESSION); // exit (); $datos_historial['rut'] = $datos_transaccion['FK_alumnos_rut'] = $_POST['rut']; $datos_historial['abono'] = $datos_transaccion['trans_monto'] = $_POST['monto']; $datos_historial['tipo'] = $datos_transaccion['trans_tipo_pago'] = $_POST['radiobutton']; $datos_historial['numboleta'] = $datos_transaccion['trans_num_boleta'] = $_POST['num_boleta']; $datos_historial['descuento'] = $datos_transaccion['trans_descuento'] = $_POST['descuento']; $datos_historial['observacion'] = $datos_transaccion['trans_observaciones'] = $_POST['observacion']; $datos_transaccion['trans_forma_pago'] = $_POST['forma_pago']; $datos_transaccion['trans_fecha_pago'] = DateToIso($fecha_hoy); $datos_historial['fechapago'] = $fecha_hoy; $datos_historial['cuota'] = "Abono"; if ($_POST['forma_pago'] != "efectivo") { $datos_transaccion['trans_banco'] = $_POST['banco'];
function anularPago($trans_ID) { $class_transaccion = new transaccion(); $class_mensualidad = new mensualidad(); $transaccion = $class_transaccion->obtenertransaccion($trans_ID); $class_mensualidad->anularPagoAlumno($transaccion['FK_alumnos_rut'], $trans_ID); unset($_POST); unset($_GET); //dpr ($transaccion); }
<?php session_start(); require "../main_Lib.php"; require "../smartyLib/Smarty.class.php"; include_once '../class/class_transaccion.php'; $smarty = new Smarty(); require_once '../phpLib/SmartyToolbox.php'; smartyTemplate($smarty, "../"); validarAcceso(AuthUser::TIPO_SECRETARIA); $mes_selec = isset($_POST['mes_selec']) ? $_POST['mes_selec'] : null; if (!$mes_selec) { $mes_selec = date("m"); } $class_transaccion = new transaccion(); $transDiaria = array(); if (count($_POST) > 0) { $transaccionesDia = $class_transaccion->obtenerTransaccionMensualConsolidada($mes_selec, "boleta"); foreach ($transaccionesDia as $dia => $transacciones) { $desde = null; $hasta = null; $escolaridad = $excension = $interes = $matricula = 0; foreach ($transacciones as $id => $transaccion) { if ($desde == null) { $desde = $transaccion["trans_num_boleta"]; } $hasta = $transaccion["trans_num_boleta"]; $interes += $transaccion["trans_interes"]; $escolaridad += $transaccion["trans_monto"]; $exencion += $transaccion["trans_descuento"] + $transaccion["trans_beca"]; }
?> <br /><br /> <?php $cuota_fecha = explode("/", $fechapago); //dpr($cuota_fecha); $mescuota = $cuota[strlen($cuota) - 1]; $y = $cuota_fecha[2]; $mensualidad = number_format($mensualidad, 0, ",", "."); //$mescuota = DateToMonth($cuota_fecha[1]); //$mescuota = $cuota == "Abono"?"Abono":DateToMonth($mescuota+2); $mescuota = "Abono"; //dpr($mescuota); $mensualidad = $abono + $descuento + $beca; $total = $abono + $interes; $exencion = $descuento + $beca; $class_transaccion = new transaccion(); $detalles = $class_transaccion->obtenerDetalleTransaccion($_GET[trans_ID]); $porcentajeDescuento = round($exencion * 100 / $mensualidad, 2); foreach ($detalles as $det_ID => $det_datos) { $kk++; $aux_detalle[] = $det_datos[det_tipo] . " " . $det_datos[det_cuota]; if ($kk == 4) { $aux_detalle[] = "<br>"; } } $txt_detalle = implode(", ", $aux_detalle); //$abono=$abono-$descuento; //else $abono=0; echo " {$nombres} {$apellidop} {$curso}<br><br><br><br><br><br><br><br><br><br><br><br></p><p class=\"Estilo2\"> {$mescuota} {$y} \r\n\$ {$mensualidad}<br>\r\n Detalle: {$txt_detalle} \r\n<br> Intereses \$ {$interes}\r\n<br><br><br><br> \r\n{$porcentajeDescuento}% \$ {$exencion}<br><br><br><br><br><br>   \r\n\$ {$total}<br></p>"; ?> <br />
<?php require '../../capaNegocio/transaccion.php'; $objTransaccion = new transaccion(); #Metodos(Funciones) de resultado. function accede($ruta) { ?> <script> alert('El registro fue .:.¡Exitoso!.:.'); var url = "../../capaPresentacion/UI/" + "<?php echo $ruta; ?> "; location.href = url; </script><?php } function denegar($ruta) { ?> <script> alert('El registro fue :.:¡No Exitoso!:.:'); var url = "../../capaPresentacion/UI/" + "<?php echo $ruta; ?> "; location.href = url; </script><?php } #Push of buttom Autos.********** if (isset($_POST[add_Auto])) {
} /*********************************** Libreria para los templates ***********************************/ include_once "../smartyLib/Smarty.class.php"; $smarty = new Smarty(); smartyTemplate($smarty, "../"); include_once '../phpLib/SmartyToolbox.php'; $smarty->assign("path_logo", $_SESSION['path']); $smarty->assign("archivo", "silueta.png"); $rut = $_GET['rut']; $class_apoderado = new apoderado(); $smarty->assign("rut", $rut); $class_mensualidad = new mensualidad(); $class_alumno = new alumno(); $class_transaccion = new transaccion(); $alumno = $class_alumno->obtenerAlumno($rut); $smarty->assign("rut", $rut); $smarty->assign("curso", mostrar_curso($alumno['curso'], true)); $smarty->assign("curso_ID", $alumno['curso']); $smarty->assign("apellidop", $alumno['apellidop']); $smarty->assign("apellidom", $alumno['apellidom']); $smarty->assign("nombres", $alumno['nombres']); $mensualidad = $class_mensualidad->obtenerMensualidad($rut); $beca = $mensualidad['mensualidad'] * ($mensualidad['descuentos'] / 100); $beca = round($beca); $num_cuotas_impagas = 0; $total_cuotas = 0; $fecha_vencimiento = "30/" . $fechames . "/" . $_SESSION['base_datos']->anio; for ($i = 1; $i <= 10; $i++) { $deuda = $mensualidad['mensualidad'] - $mensualidad["c" . $i];
<?php session_start(); require "../main_Lib.php"; session_autorefresh(); include_once '../class/class_mensualidad.php'; include_once '../class/class_alumno.php'; include_once '../class/class_transaccion.php'; $rut = $_GET['rut']; $class_mensualidad = new mensualidad(); $class_alumno = new alumno(); $class_transaccion = new transaccion(); $transacciones = $class_transaccion->obtenerTransacciones($rut); $alumno = $class_alumno->obtenerAlumno($rut); if ($_SESSION['token'] != $token) { session_destroy(); moveLocation("../ingreso.php", 0, 2); } if (isset($_POST['trans'])) { foreach ($_POST['trans'] as $trans_ID => $datos) { $datos_historial['numboleta'] = $datos['trans_num_boleta']; $datos_historial['tipo'] = $datos['tipo']; if ($datos_historial['numboleta'] > 0) { $class_transaccion->actualizarHistorial($datos_historial, array('FK_transaccion_trans_ID' => $trans_ID)); $class_transaccion->actualizarTransacciones(array("trans_num_boleta" => $datos['trans_num_boleta'], 'trans_tipo_pago' => $datos['tipo']), array('trans_ID' => $trans_ID)); } } moveLocation("SEC-historial.php", 0, $rut, "rut"); } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">