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">
