| Server IP : 74.208.127.88 / Your IP : 18.191.136.109 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/muebles/pos11/core/app/view/ |
Upload File : |
<section class="content-header">
<nav class = "navbar navbar-inverse">
<div class = "container-fluid">
<h1 style="color:white;">Cobranza de Clientes</h1>
</div>
</nav>
<ol class="breadcrumb">
<li><a href="#"><i class="fa fa-dashboard"></i> cobranza</a></li>
<li class="active">cobro </li>
</ol>
</section>
<section class="content">
<div class="row">
<div class="col-md-12">
<?php
$id="SI";
$users = PersonData::getClientsWithCredit2($id);
//print_r($users);
if(count($users)>0){
// si hay usuarios
?>
<br><br>
<div class="box box-primary">
<div class="box-header">
<h3 class="box-title">Lista General de Clientes Pendiente de cobro</h3></div>
<div class="box-body">
<table class="table table-bordered table-hover table-responsive datatable">
<thead>
<th>Contrato</th>
<th>Nombre completo</th>
<th></th>
<th>Saldo Pendiente</th>
</thead>
<?php
$granTotal=0;
foreach($users as $user){
$totalT = PaymentData::sumByClientId2($user->contract)->total;
//obtenemos los abonos
$abonos = PaymentData::sumByClientId($user->contract)->total;
//buscamos el enganche pagado
$EnganchePag = PaymentData::ClientPayByContProgPagado($user->contract);
if($totalT>0){
?>
<tr>
<td><?php echo $user->contract; ?></td>
<td><?php echo $user->name; ?></td>
<td style="width:230px;">
<a href="index.php?view=makepayment&id=<?php echo $user->id_cust;?>" class="btn btn-default btn-xs">Realizar Pago</a>
<a href="index.php?view=paymenthistory&id=<?php echo $user->id_cust;?>" class="btn btn-default btn-xs">Historial</a>
</td>
<td>$ <?php
if(isset($EnganchePag->val)){
//print_r($EnganchePag->val);
echo number_format( $saldo=$totalT-$abonos - $EnganchePag->val,2,".",",");
}else{
echo number_format( $saldo=$totalT-$abonos,2,".",",");
}
?></td>
</tr>
<?php
$granTotal = $granTotal + $saldo;
}
}?>
</table>
<h1 algn='right'>Saldo:<?php echo number_format($granTotal,2);?></h1>
<br>
<div id="myWatch1"></div>
</div>
</div>
<?php
}else{
echo "<p class='alert alert-danger'>No hay clientes</p>";
}
?>
</div>
</div>
</section>
<script type="text/javascript">
function getTimeAJAX() {
//GUARDAMOS EN UNA VARIABLE EL RESULTADO DE LA CONSULTA AJAX
var time = $.ajax({
url: './index.php?action=credit', //indicamos la ruta donde se genera la hora
dataType: 'text',//indicamos que es de tipo texto plano
async: false //ponemos el parámetro asyn a falso
}).responseText;
//actualizamos el div que nos mostrará la hora actual
document.getElementById("myWatch").innerHTML = " "+ time;
}
//con esta funcion llamamos a la función getTimeAJAX cada segundo para actualizar el div que mostrará la hora
setInterval(getTimeAJAX,1000);
</script>