| Server IP : 74.208.127.88 / Your IP : 3.140.184.203 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
//$clients = PersonData::getClients();
date_default_timezone_set("America/Mexico_City");
$fecha = date('Y-m-d h:i:s');
$fechaAtras = strtotime ( '-1 day' , strtotime ( $fecha ) ) ;
$fechaAtras = date ( 'Y-m-d h:i:s' , $fechaAtras );
//print "FECHA INICIAL_:";
//echo $fechaAtras;
//print "____FECHA FINAL_:";
$fechaActual = date("Y-m-d h:i:s",time());
//echo $fechaActual;
$almacenid = $_SESSION['stock_id'];
$almacen = $_SESSION['stock_id'];
$id_seller = UserData::getByIdStock1($almacen);
//print_r($id_seller);
?>
<section class="content">
<div class="row">
<div class="col-md-26">
<div class="btn-group pull-right">
<button type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown">
<i class="fa fa-download"></i> Corte Caja <span class="caret"></span>
</button>
<ul class="dropdown-menu" role="menu">
<li><a onclick="thePDF()" id="makepdf" class="">Corte en (.pdf)</a>
</ul>
</div>
<div class="btn-group pull-right">
<a href="./index.php?view=boxhistory" class="btn btn-primary "><i class="fa fa-clock-o"></i> Historial</a>
<a href="./index.php?view=processbox&stock_id=<?php echo $_SESSION['stock_id'];?>" class="btn btn-primary ">Procesar Corte <i class="fa fa-arrow-right"></i></a>
</div>
<h1><i class='fa fa-archive'></i>Detalle De Operaciones</h1>
<h1>Desglose Ventas</h1>
<p>Al procesar ventas se generara un corte de caja para todas las ventas del almacen: <b>
<?php
echo $almacen= StockData::getById($almacenid)->name;
?></b></p>
<div class="clearfix"></div>
<?php
//echo $id_seller->id_user;
// echo $stock_id = StockData::getById($id_seller->id_user)->id;
//die;
$products = SellData::getSellsUnBoxed();
$sellsCredit = SellData::getSellCreditsUnBoxed();
//print_r($sellsCredit);
$total_total = 0;
?>
<?php
if(count($products)>0){
?>
<br>
<div class="box box-primary">
<div><h3><u>Ventas de Contado</u></h3></div>
<table class="table table-bordered table-hover ">
<thead>
<th></th>
<th></th>
<th>Folio</th>
<th> Id Venta</th>
<th>Total</th>
<th>Monto FP1</th>
<th>Monto FP2</th>
<th>Fecha</th>
<th>Formas de pago </th>
</thead>
<tbody>
<?php
$Total_F1=0;
$Total_F2=0;
$Total_F3=0;
$Total_F4=0;
$MontoFP2=0;
$Total_A=0;
foreach($products as $sell):
$idseller = $sell->id_seller;
$sellsF = SellData::getByIdSale($sell->sale_id);
$NameP1 = FData::getById($sellsF->f_pago1);
$NameP2 = FData::getById($sellsF->f_pago2);
//totalizamos forma de pago 2
if($sell->cash<$sell->total){
$MontoFP2=abs($sell->cash-$sell->total);
}else{
$MontoFP2=0;
}
if($sellsF->f_pago2 == 1){
$Total_F1 += $MontoFP2;
}elseif($sellsF->f_pago2 == 4){
$Total_F2 += $MontoFP2;
}elseif($sellsF->f_pago2 == 5){
$Total_F3 += $MontoFP2;
}else{
$Total_F4 += $MontoFP2;
}
//totalizamos forma de pago 1 con forma de pago 2
if($sellsF->f_pago1 == 1 && $MontoFP2!=0){
$Total_F1 += $sell->cash;
}elseif($sellsF->f_pago1 == 4 && $MontoFP2!=0){
$Total_F2 += $sell->cash;
}elseif($sellsF->f_pago1 == 5 && $MontoFP2!=0){
$Total_F3 += $sell->cash;
}else{
if($MontoFP2!=0){
$Total_F4 += $sell->cash;}
}
//totalizamos forma de pago 1
if($sellsF->f_pago1 == 1 && $MontoFP2==0){
$Total_F1 += $sell->total;
}elseif($sellsF->f_pago1 == 4 && $MontoFP2==0){
$Total_F2 += $sell->total;
}elseif($sellsF->f_pago1 == 5 && $MontoFP2==0){
$Total_F3 += $sell->total;
}else{
if($MontoFP2==0){
$Total_F4 += $sell->total;}
}
?>
<tr>
<td style="width:30px;">
</td>
<td style="width:30px;">
</td>
<td>
<a href="index.php?view=onesell1&id=<?php echo $sell->id;?>&sale_id=<?php echo $sell->sale_id;?>" class="btn btn-xs btn-default"><i class="glyphicon glyphicon-eye-open"></i> # <?php echo $sell->id; ?></a>
</td>
<td>
<?php echo $sell->sale_id; ?>
</td>
<td>
<?php
$total_total += $sell->total;
echo "<b>$ ".number_format($sell->total,2,".",",")."</b>";
?>
</td>
<td><?php echo $sell->cash; ?></td>
<?php if($sell->cash<$sell->total):?>
<td><?php echo number_format(abs($sell->cash-$sell->total),2); ?></td>
<?php else:?>
<td><?php echo $sell->discount; ?></td>
<?php endif;?>
<td><?php echo $sell->created_at; ?></td>
<td colspan="2"><p><small><?php echo $sellsF->f_pago1; ?>--<?php echo $NameP1->name; ?></p></small></td>
<?php if($sell->cash<$sell->total):?>
<td><p><small><?php echo $sellsF->f_pago2; ?>--<?php echo $NameP2->name; ?></p></small></td>
<?php else:?>
<?php if($sell->cash>$sell->total):?>
<td>Cambio: <?php echo number_format(abs($sell->cash-$sell->total),2)?></td>
<?php else:?>
<td></td>
<?php endif;?>
<?php endif;?>
<td>
</td>
</tr>
<?php endforeach; ?>
</tbody>
<td><td><td colspan="2"><td><u><h4>Total Contado:<?php echo "$ ".number_format($Total_F1,2,".",","); ?></h4></u></td></td></td></td>
</table>
</div>
<?php
if(count($sellsCredit)>0){
?>
<br>
<div class="box box-primary">
<div><h3><u>Ventas Credito</u></h3></div>
<table class="table table-bordered table-hover ">
<thead>
<th></th>
<th>Folio</th>
<th> Id Venta</th>
<th>Total</th>
<th>Abono</th>
<th>Monto a Credito</th>
<th>Fecha</th>
<th>Forma de Pago(Abono)</th>
</thead>
<?php
foreach($sellsCredit as $sell):
?>
<tr>
<td style="width:30px;">
</td>
<td>
<?php echo $sell->id; ?>
</td>
<td>
<?php echo $sell->sale_id; ?>
</td>
<td>
<?php
echo "<b>$ ".number_format($sell->total,2,".",",")."</b>";
//sumar total de abonos
$Total_A += $sell->cash;
?>
</td>
<td><?php echo $sell->cash; ?></td>
<td><?php echo $sell->discount; ?></td>
<td><?php echo $sell->created_at; ?></td>
<td colspan="2"><p><small><?php echo $sellsF->f_pago1; ?>--<?php echo $NameP1->name; ?></p></small></td>
<td></td>
</tr>
<td><td><td colspan="2">Total Abonos:<td><u><p><?php echo "$ ".number_format($Total_A,2,".",","); ?></p></u></td></td></td></td>
<?php endforeach;
}//final if de ventas a credito
?>
</table>
</div>
<?php
}else {
?>
<div class="jumbotron">
<h2>No hay ventas</h2>
<p>No se ha realizado ninguna venta.</p>
</div>
<?php } ?>
<?php
//desglosamos la dev por vendedor o cajero
$users = SpendData::getAllSpends($id_seller->id_user);
$totaldev = 0;
if(!empty($users)>0):
?>
<h1>Desglose Devoluciones</h1>
<p> Almacen:<b><?php echo StockData::getPrincipal()->name;
$almacen= StockData::getPrincipal()->name;
?></b></p>
<div class="clearfix"></div>
<div class="box box-primary">
<table class="table table-bordered table-hover ">
<thead>
<th>Datos Devolucion</th>
<th>Folio</th>
<th>Forma de Pago</th>
<th>Monto</th>
<th></th>
</thead>
<tbody>
<?php foreach($users as $user):?>
<tr>
<td><?php echo $user->name; ?></td>
<td><?php echo $user->id_dev; ?></td>
<td><?php
$NameDev = FData::getById($user->f_pago);
echo $NameDev->id;
echo "-";
echo $NameDev->name;
?>
</td>
<td>$ <?php echo $user->price; ?></td>
<td></td>
</tr>
<?php $totaldev+=$user->price; ?>
<?php endforeach; ?>
</tbody>
<td><td><td colspan="2"> <h4 align="left"><u>Total Devoluciones: $ <?php echo number_format($totaldev,2,".",","); ?></u></h4> </td></td></td></td>
</table>
</div>
<?php
else:
$totaldev=0;
?>
<?php endif; ?>
<?php
$operations = array();
$operations = PaymentData::getAllBoxNull();
?>
<?php if(count($operations)>0):?>
<h1> Desglose Pagos</h1>
<?php $t=0; foreach($operations as $operation){ $t+=$operation->val; }?>
<div class="box box-primary">
<table class="table table-bordered">
<thead>
<th></th>
<th>Cliente</th>
<th>Valor</th>
<th>Fecha</th>
</thead>
<?php foreach($operations as $operation):?>
<tr>
<td></td>
<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; ?>
<td>
<td>
<td colspan="2"> <h4 align="left"><u>Total Pagos: $ <?php echo number_format(abs($t),2,".",","); ?></u></h4> </td>
</td>
</td>
</table>
</div>
<?php $gran_p=abs($t); ?>
<?php else:
// si no hay operaciones pagos
$gran_p=0;
?>
<?php endif; ?>
<?php $gran_total=$gran_p + $total_total;
?>
<?php
$totalIngreso = $Total_F1 +$Total_F2 +$Total_F3 + $Total_F4 + $Total_A + abs($t);
if($totalIngreso > 0 ){
?>
<div class="row">
<div class="col-md-26">
<div class="box box-primary">
<table class="table table-bordered table-hover ">
<thead>
<th></th>
<th>Efectivo</th>
<th>T. Credito </th>
<th>T.Debito</th>
<th>Otros(Cheque,Transferencia)</th>
</thead>
<tr>
<td></td>
<?php if(isset($Total_F1)):?>
<td><u><p><?php echo "$ ".number_format($Total_F1 + $Total_A,2,".",","); ?></p></u></td>
<td><u><p><?php echo "$ ".number_format($Total_F2,2,".",","); ?></p></u></td>
<td><u><p><?php echo "$ ".number_format($Total_F3,2,".",","); ?></p></u></td>
<td><u><p><?php echo "$ ".number_format($Total_F4 + abs($t) ,2,".",","); ?></p></u></td>
<?php else:?>
<td><u><p>$ 0</p></u></td>
<td><u><p>$ 0</p></u></td>
<td><u><p>$ 0</p></u></td>
<td><u><p>$ 0</p></u></td>
<?php endif;?>
</tr>
</table>
</div>
</div>
</div>
<div class="box box-primary">
<table class="table table-bordered table-hover ">
<?php if(isset($Total_A)):?>
<th><h2 align="right"><u>Total al Corte: $ <?php echo number_format(($gran_total + $Total_A) - $totaldev,2,".",","); ?></u></h2></th>
<td></td>
<?php else:?>
<th><h2 align="right"><u>Total al Corte: $ <?php echo number_format($gran_total-$totaldev,2,".",","); ?></u></h2></th>
<td></td>
<?php endif;?>
</table>
</div>
<?php
}
?>
</div>
</div>
</section>
<script type="text/javascript">
function thePDF() {
var doc = new jsPDF('p', 'pt');
doc.setFontSize(26);
doc.text("<?php echo ConfigurationData::getByPreffix("company_name")->val;?>", 80, 85);
doc.setFontSize(16);
doc.text( "CORTE: <?php echo date("d-m-Y h:i:s");?> ", 40, 130);
doc.text( "TOTAL VENTAS.................................................: <?php echo "$ ".number_format($total_total,2,".",","); ?> ", 50, 180);
doc.text( "TOTAL PAGOS..................................................: <?php echo " $ ".number_format(abs($t),2,".",","); ?> ", 50, 200);
doc.text( "TOTAL DEVOLUCION.......................................: <?php echo " $ ".number_format($totaldev,2,".",","); ?> ", 50, 220);
doc.text( "______________________________________________________________", 40, 230);
doc.text( "TOTAL CORTE...................................................: <?php echo " $ ".number_format($gran_total,2,".",","); ?> ", 50, 260);
doc.setFontSize(12);
doc.text("Usuario: <?php echo Core::$user->name." ".Core::$user->lastname; ?> ", 50, 150);
<?php
$con = ConfigurationData::getByPreffix("report_image");
if($con!=null && $con->val!=""):
?>
var img = new Image();
img.src= "storage/configuration/<?php echo $con->val;?>";
img.onload = function(){
doc.addImage(img, 'PNG', 20, 50, 60, 60,'mon');
doc.save('CORTE-<?php echo date("d-m-Y",time()); ?>.pdf');
}
<?php else:?>
doc.save('Corte-<?php echo date("d-m-Y",time()); ?>.pdf');
<?php endif; ?>
}
</script>