| Server IP : 74.208.127.88 / Your IP : 18.222.185.243 Web Server : Apache/2.4.41 (Ubuntu) System : Linux ubuntu 5.4.0-163-generic #180-Ubuntu SMP Tue Sep 5 13:21:23 UTC 2023 x86_64 User : www-data ( 33) PHP Version : 7.4.3-4ubuntu2.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/html/t/sae/appsae/core/app/view/ |
Upload File : |
<?php
include "../../../../application/model/dbconn.php";
include "../../../../application/model/pos.php";
include "../../core/autoload.php";
include "../../core/app/model/ConfigurationData.php";
$con = new Conexion();
$sqlPer = "SELECT persona.id, persona.nombres FROM persona ORDER BY persona.nombres ASC";
$sqlBan = "SELECT * FROM entidad ORDER BY id ASC";
$sqlCon = "SELECT concepto.id, concepto.descripcion FROM concepto ORDER BY concepto.descripcion ASC";
$sqlCta = "SELECT cuenta.id, cuenta.descripcion, cuenta.idmoneda FROM cuenta ORDER BY cuenta.descripcion ASC";
$sqlMon = "SELECT moneda.id, moneda.descripcion FROM moneda ORDER BY moneda.descripcion ASC";
$datosPer = $con->retrieveArray($sqlPer);
$datosBan = $con->retrieveArray($sqlBan);
$datosCon = $con->retrieveArray($sqlCon);
$datosCta = $con->retrieveArray($sqlCta);
$datosMon = $con->retrieveArray($sqlMon);
$fIni = '28-10-2024';
$fFin = date('d-m-Y');
$f_ini = substr($fIni,6,4) . "-" . substr($fIni,3,2) . "-" . substr($fIni,0,2);
$f_fin = substr($fFin,6,4) . "-" . substr($fFin,3,2) . "-" . substr($fFin,0,2);
//QUERY PARA CONTENIDO saldo
$sql = "SELECT persona.id, persona.nombres AS persona, SUM(movimiento.importe * IF(movimiento.tipo='P',1,-1)) AS importe FROM movimiento INNER JOIN persona ON ( movimiento.idpersona = persona.id ) WHERE movimiento.idpersona <> 3 AND movimiento.fecha BETWEEN '$f_ini' AND '$f_fin' GROUP BY persona.id, persona.nombres ORDER BY importe DESC";
$datos = $con->retrieveArray($sql);
if( isset($datos[0]['importe']))
{
$saldoBancos = $datos[0]['importe'];
}else{
$saldoBancos = 0;
}
//ultima poliza ingresada
$sql = "SELECT * FROM movimiento order by id desc limit 1";
$datos = $con->retrieveArray($sql);
/*
echo "///";
print_r($datos[0]['importe']);
echo "xxxx";
*/
if( isset($datos[0]['importe']))
{
$ultima = $datos[0]['importe'];
}else{
$ultima = 0;
}
?>
<!DOCTYPE html>
<html>
<section class="content">
<head>
<meta charset="UTF-8">
</head>
<div class="row">
</div>
<div class="row">
<div class="info-box bg-aqua">
<span class="info-box-icon"><i class="fa fa-comments-o"></i></span>
<div class="info-box-content">
<span class="info-box-text">Entidades Financieras Dadas de Alta </span>
<span class="info-box-number">Bancos: <?php echo count($datosBan);?></span>
<!-- The progress section is optional -->
<div class="progress">
<div class="progress-bar" style="width: 20%"></div>
</div>
<span class="progress-description">
<a href="./index.php?view=polizasnewE">Ver Detalles</a>
</span>
</div>
<!-- /.info-box-content -->
</div>
<div class="info-box bg-blue">
<span class="info-box-icon"><i class="fa fa-book"></i></span>
<div class="info-box-content">
<span class="info-box-text">Detalle de Saldos</span>
<span class="info-box-number">Revisar Fechas</span>
<!-- The progress section is optional -->
<div class="progress">
<div class="progress-bar" style="width: 20%"></div>
</div>
<span class="progress-description">
<a href="index.php?view=polizas">Ver Detalles</a>
</span>
</div>
<!-- /.info-box-content -->
</div>
<div class="info-box bg-navy">
<span class="info-box-icon"><i class="fa fa-calendar"></i></span>
<div class="info-box-content">
<span class="info-box-text">Detalle de Polizas</span>
<span class="info-box-number">Lista de Registros</span>
<!-- The progress section is optional -->
<div class="progress">
<div class="progress-bar" style="width: 20%"></div>
</div>
<span class="progress-description">
<a href="index.php?view=polizasnew">Ver Detalles</a>
</span>
</div>
<!-- /.info-box-content -->
</div>
</div>
<!-- /.row -->
<div class="row">
<div class="col-md-3 col-sm-6 col-xs-12">
<div class="info-box">
<!-- Apply any bg-* class to to the icon to color it -->
<span class="info-box-icon bg-navy"><i class="fa fa-archive"></i></span>
<div class="info-box-content">
<span class="info-box-text">Cuentas</span>
<span class="info-box-number">#: <?php echo count($datosCta);?></span>
<div class="progress">
<div class="progress-bar" style="width: 10%"></div>
</div>
<a href="./index.php?view=polizasnewC">Ver Detalles</a>
</div>
<!-- /.info-box-content -->
</div>
<!-- /.info-box -->
</div>
<!-- /.col -->
<div class="col-md-3 col-sm-6 col-xs-12">
<div class="info-box">
<span class="info-box-icon bg-black"><i class="fa fa-male"></i></span>
<div class="info-box-content">
<span class="info-box-text">Saldo Bancos</span>
<span class="info-box-number">$<?php echo number_format($saldoBancos,2);?></span>
<div class="progress">
<div class="progress-bar" style="width: 10%"></div>
</div>
<a href="index.php?view=polizas">Ver Detalles</a>
</div>
<!-- /.info-box-content -->
</div>
<!-- /.info-box -->
</div>
<!-- /.col -->
<!-- fix for small devices only -->
<div class="clearfix visible-sm-block"></div>
<div class="col-md-3 col-sm-6 col-xs-12">
<div class="info-box">
<span class="info-box-icon bg-navy"><i class="fa fa-shopping-cart"></i></span>
<div class="info-box-content">
<span class="info-box-text"><a href="#">Estado de cuenta</a></span>
<span class="info-box-number">2 Reportes </span>
<div class="progress">
<div class="progress-bar" style="width: 10%"></div>
</div>
<a href="#">Ver Detalles</a>
</div>
<!-- /.info-box-content -->
</div>
<!-- /.info-box -->
</div>
<!-- /.col -->
<div class="col-md-3 col-sm-6 col-xs-12">
<div class="info-box">
<span class="info-box-icon bg-black"><i class="fa fa-area-chart"></i></span>
<div class="info-box-content">
<span class="info-box-text">Poliza ultima</span>
<span class="info-box-number"> $<?php echo number_format($ultima,2);?> </span>
<div class="progress">
<div class="progress-bar" style="width: 10%"></div>
</div>
<a href="index.php?view=polizasnew">Ver Detalles</a>
</div>
<!-- /.info-box-content -->
</div>
<!-- /.info-box -->
</div>
<!-- /.col -->
</div>
<!-- /.row -->
</html>