����JFIF��H�H����Exif��MM�*���� ��3����V�����3������3�(��������������������3�����
Server IP : 74.208.127.88 / Your IP : 3.128.190.205 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 ?> <?php $con = new Conexion(); if(isset($_POST['fecini'])){ $fIni = $_POST['fecini']; $fFin = $_POST['fecfin']; }else{ $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 $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); $color="COLOR_LISTA_02"; $tIng=0; ?> <section class="content-header"> <h1>SALDO DE CUENTAS</h1> <ol class="breadcrumb"> <li><a href="#"><i class="fa fa-dashboard"></i> Bancos</a></li> <li class="active">Polizas</li> </ol> </section> <section class="content"> <div class="row"> <div class="col-md-12"> <br> <a href="index.php?view=indexBancos" class="btn btn-default">Regresar</a> <div class="box box-primary"> <div class="box-body"> <table class="table table-bordered datatable table-hover"> <tr> <h2>Saldo de Cuentas</h2> <td width="100px" align="right"><input type="text" value="<?php echo $fIni; ?>" name="fecini" id="fecini" style="width:80px; text-align:center"/>>>Fecha Inicio</td> <td width="100px" align="right"><input type="text" value="<?php echo $fFin; ?>" name="fecfin" id="fecfin" style="width:80px; text-align:center"/>>>Fecha Fin</td> <td width="90px" align="right"><button type="submit" name="btnBusca" class="button icon search">Buscar</button></td> </tr> </table> </div> </div> <br> <div class="box box-primary"> <div class="box-body"> <table class="table table-bordered datatable table-hover"> <thead> <tr height="26px" class="lista_header"> <td align="center" width="50px">ID</td> <td>PERSONA</td> <td align="center">IMPORTE</td> <td width="10px"></td> <td width="270px"> </td> </tr> </thead> <?php for($i=0;$i<count($datos);$i++){ ?> <tr height="25px" style="background-color: #<?php echo $color; ?>"> <td class="lista_celda" align="center"><?php echo $datos[$i]['id']; ?></td> <td class="lista_celda"><?php echo $datos[$i]['persona']; ?></td> <td class="lista_celda" align="right"><?php echo number_format($datos[$i]['importe'],2); ?></td> <td class="lista_celda"></td> <td class="lista_celda">Cuenta de <?php if($datos[$i]['importe']<0){ echo $_SESSION['nombre']; }else{ echo $datos[$i]['persona']; } ?></td> </tr> <?php } ?> <tr height="25px"> <td class="lista_celda" align="center"></td> <td class="lista_celda" align="center"></td> <td class="lista_celda" align="right"><?php echo number_format($tIng,2); ?></td> <td class="lista_celda" align="center"></td> <td class="lista_celda" align="center"></td> </tr> </table> </div> </div> <br> </section>