| Server IP : 74.208.127.88 / Your IP : 3.20.221.0 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 : |
<?php
$clients = PersonData::getClients();
?>
<section class="content-header">
<h1>Reporte de Abonos a Creditos</h1>
<ol class="breadcrumb">
<li><a href="#"><i class="fa fa-dashboard"></i> Ventas a Credito</a></li>
<li class="active">Abonos</li>
</ol>
</section>
<section class="content">
<div class="box box-primary">
<div class="box-header">
<h3 class="box-title">Ingresar las fechas para revisar reporte</h3>
</div><!-- /.box-header -->
<div class="box-body">
<div class="row">
<div class="col-md-12">
<form>
<input type="hidden" name="view" value="paymentreport">
<div class="row">
<div class="col-md-3">
<select name="client_id" class="form-control">
<option value="">-- TODOS --</option>
<?php foreach($clients as $p):?>
<option value="<?php echo $p->id_cust;?>"><?php echo $p->name;?></option>
<?php endforeach; ?>
</select>
</div>
<div class="col-md-3">
<input type="date" name="sd" value="<?php if(isset($_GET["sd"])){ echo $_GET["sd"]; }?>" class="form-control">
</div>
<div class="col-md-3">
<input type="date" name="ed" value="<?php if(isset($_GET["ed"])){ echo $_GET["ed"]; }?>" class="form-control">
</div>
<div class="col-md-3">
<input type="submit" class="btn btn-success btn-block" value="Procesar">
</div>
</div>
</form>
</div>
</div>
<br><!--- -->
<div class="row">
<div class="col-md-12">
<?php if(isset($_GET["sd"]) && isset($_GET["ed"]) ):?>
<?php if($_GET["sd"]!=""&&$_GET["ed"]!=""):?>
<?php
$operations = array();
if(isset($_GET["client_id"]) && $_GET["client_id"]!=""){
$operations = PaymentData::getAllByDateAndClient($_GET["sd"],$_GET["ed"],$_GET["client_id"]);
}else{
$operations = PaymentData::getAllByDate($_GET["sd"],$_GET["ed"]);
}
?>
<?php if(count($operations)>0):?>
<?php $t=0; foreach($operations as $operation){ $t+=$operation->val; }?>
<a href="./report/paymentreport-xlsx.php?client_id=<?php echo $_GET["client_id"]; ?>&sd=<?php echo $_GET["sd"]; ?>&ed=<?php echo $_GET["ed"]; ?>" class="btn btn-default">Descargar en Excel (.xlsx)</a><br><br>
<div class = "table-responsive">
<div class="box box-primary">
<table class="table table-bordered">
<thead class="alert-info">
<th>Cliente</th>
<th>Valor</th>
<th>Fecha</th>
</thead>
<?php foreach($operations as $operation):?>
<tr>
<td><?php $c= $operation->getClient();echo $c->name." ".$c->lastname; ?></td>
<td>$ <?php echo number_format(abs($operation->val),2,".",","); ?></td>
<td><?php echo $operation->created_at; ?></td>
</tr>
<?php endforeach; ?>
</table>
<td> <h2>Total Recaudado: $ <?php echo number_format(abs($t),2,".",","); ?></h2></td>
</div>
<?php else:
// si no hay operaciones
?>
<script>
$("#wellcome").hide();
</script>
<div class="jumbotron">
<h2>No hay operaciones</h2>
<p>El rango de fechas seleccionado no proporciono ningun resultado de operaciones.</p>
</div>
<?php endif; ?>
<?php else:?>
<script>
$("#wellcome").hide();
</script>
<div class="jumbotron">
<h2>Fecha Incorrectas</h2>
<p>Puede ser que no selecciono un rango de fechas, o el rango seleccionado es incorrecto.</p>
</div>
<?php endif;?>
<?php endif; ?>
</div>
</div>
</div>
</div>
</section>