| Server IP : 74.208.127.88 / Your IP : 18.117.186.60 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
$stock_id = $_SESSION['stock_id'];
$stock = StockData::getByid($stock_id);
date_default_timezone_set("America/Mexico_City");
?>
<section class="content">
<div class="row">
<div class="col-md-12">
<?php if(isset($_SESSION["client_id"])):?>
<h1><i class='glyphicon glyphicon-shopping-cart'></i>Mis Ventas</h1>
<?php else:?>
<div class="btn-group pull-right">
<button type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown">
<i class="fa fa-download"></i> Descargar <span class="caret"></span>
</button>
<ul class="dropdown-menu" role="menu">
<li><a href="report/sells-word.php">Word 2007 (.docx)</a></li>
<li><a href="report/sells-xlsx.php">Excel 2007 (.xlsx)</a></li>
<li><a onclick="thePDF()" id="makepdf" class="">PDF (.pdf)</a></li>
</ul>
</div>
<div class="clearfix"></div>
<nav class = "navbar navbar-inverse">
<div class = "container-fluid">
<a href = "#" class = "navbar-brand"><i class='glyphicon glyphicon-shopping-cart'></i> Ventas Generales </a>
</div>
</nav>
<span>Procesando Informacion en tiempo real</span>
<?php endif;?>
<div class="clearfix"></div>
<?php
$products = null;
$fecha = date('Y-m-d h:i:s');
$fechaAtras = strtotime ( '-10 day' , strtotime ( $fecha ) ) ;
$fechaAtras = date ( 'Y-m-d ' , $fechaAtras );
$fechaActual = date("Y-m-d h:i:s",time());
$products = SellData::getSellAll();
if(count($products)>0){
?>
<br>
<div class="box box-primary">
<div class="box-header">
<h3 class="box-title"> Detalle De las Ultimas Ventas</h3></div>
<div class="box-body">
<table class="table table-bordered table-hover table-responsive datatable">
<thead>
<th>Facturar</th>
<th>Folio</th>
<th>Id</th>
<th>Pago</th>
<th>Entrega</th>
<th>Total</th>
<th>Cliente</th>
<th>Vendedor</th>
<th>Almacen</th>
<th>Fecha</th>
<th></th>
</thead>
<?php foreach($products as $sell):
?>
<tr>
<td style="width:130px;">
<?php
$facturada = FacturaData::getByIdFacturada($sell->id);
//print_r($facturada);
if(!isset($facturada->sell_id)){
?>
<a title="Facturar version 4.0" href="index.php?view=addfactura&id=<?php echo $sell->id;?>&sale_id=<?php echo $sell->sale_id;?>&client_id=<?php echo $sell->getPerson()->id_cust;?>" class="btn btn-info"><i class="glyphicon glyphicon-file"> PRO1</i></a>
<a title="Facturar Proveedor 2" href="index.php?view=addfactura2&id=<?php echo $sell->id;?>&sale_id=<?php echo $sell->sale_id;?>&client_id=<?php echo $sell->getPerson()->id_cust;?>" class="btn btn-danger"><i class="glyphicon glyphicon-list-alt"> PRO2</i></a>
<?php }else{?>
<label>Facturada</label>
<?php }?>
</td>
<?php if($sell->getP()->id != 4):?>
<td style="width:130px;">
<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></a><?php echo $sell->sale_id; ?>
</td>
<?php else:?>
<td style="width:130px;">
<a href="index.php?view=onesellN&id=<?php echo $sell->sale_id;?>" class="btn btn-xs btn-default"><i class="glyphicon glyphicon-file"></i></a><?php echo $sell->sale_id; ?>
</td>
<?php endif;?>
<td><?php echo $sell->id; ?></td>
<td><?php echo $sell->getP()->name; ?></td>
<td><?php echo $sell->getD()->name; ?></td>
<td>
<?php
$total= $sell->total-$sell->discount;
echo "<b>$ ".number_format($sell->total,2,".",",")."</b>";
?>
</td>
<td>
<?php
//buscamos al cliente
echo $sell->getPerson()->name;
?>
</td>
<td>
<?php if($sell->user_id!=null){
$c= $sell->getUser();
if(isset($c->name)){
echo $c->name." ".$c->lastname;
}else{
echo "Vendedor Eliminado";
}
}
?>
<?php
if(isset($sell->id_seller)){
$c1= UserData::getById2($sell->id_seller);
if(isset($c1->username)){
echo $sell->id_seller."-".$c1->username;
}else{
echo "Id Vendedor: ".$sell->id_seller;
}
}else{
echo "sin vendedor";
}
?>
</td>
<td><?php
if( $sell->id_seller != NULL){
//verificamos el valor de stock_id en tabla user-
$user = UserData::getById($sell->id_seller);
if( $sell->id_seller != 0){
echo utf8_encode(StockData::getById($user->stock_id)->name);
}else{
echo "Sin Vendedor asignado";
}
}else{
echo "Sin Almacen";
}
?></td>
<?php $fecha = explode("-",$sell->created_at);
$fecha2 = explode(":",$fecha[2]);
$fecha3 = explode(" ",$fecha2[0]);
?>
<td><b><?php echo $fecha3[0]; echo "/"; echo $fecha[1]; echo "/"; echo $fecha[0]; ?></b></td>
<td style="width:30px;">
<a href="index.php?view=factura_demo&id=<?php echo $sell->id;?>&sale_id=<?php echo $sell->sale_id;?>" class="btn btn-xs btn-info" title="Demo de Facturacion Iva Agregado"><i class="glyphicon glyphicon-file"></i></a>
<a href="index.php?view=factura_demo2&id=<?php echo $sell->id;?>&sale_id=<?php echo $sell->sale_id;?>" class="btn btn-xs btn-warning" title="Demo de Facturacion Iva Desglosado"><i class="glyphicon glyphicon-file"></i></a>
<?php if(Core::$user->kind==1):?>
<a href="index.php?view=delsellSeguridad&id=<?php echo $sell->id; ?>" class="btn btn-xs btn-danger"><i class="fa fa-trash"></i></a>
<?php endif;?>
</td>
</tr>
<?php endforeach; ?>
</table>
</div>
</div>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<div class="clearfix"></div>
<?php
}else{
?>
<div class="jumbotron">
<h2>No hay ventas</h2>
<p>No se ha realizado ninguna venta.</p>
</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;?>", 40, 65);
doc.setFontSize(18);
doc.text("VENTAS", 40, 80);
doc.setFontSize(12);
doc.text("Usuario: <?php echo Core::$user->name." ".Core::$user->lastname; ?> - Fecha: <?php echo date("d-m-Y h:i:s");?> ", 40, 90);
var columns = [
{title: "Id", dataKey: "id"},
{title: "Cliente", dataKey: "client"},
{title: "Total", dataKey: "total"},
{title: "Estado de pago", dataKey: "p"},
{title: "Estado de entrega", dataKey: "d"},
{title: "Almacen", dataKey: "stock"},
{title: "Fecha", dataKey: "created_at"},
];
var rows = [
<?php foreach($products as $sell):
?>
{
"id": "<?php echo $sell->id; ?>",
"client": "<?php if($sell->person_id!=null){$c= $sell->getPerson();echo $c->name." ".$c->lastname;} ?>",
"total": "<?php
$total= $sell->total-$sell->discount;
echo "$ ".number_format($total,2,".",",");
?> ",
"p": "<?php echo $sell->getP()->name; ?>",
"d": "<?php echo $sell->getD()->name; ?>",
"stock": "<?php echo $sell->getStockTo()->name; ?>",
"created_at": "<?php echo $sell->created_at; ?>",
},
<?php endforeach; ?>
];
doc.autoTable(columns, rows, {
theme: 'grid',
overflow:'linebreak',
styles: {
fillColor: <?php echo Core::$pdf_table_fillcolor;?>
},
columnStyles: {
id: {fillColor: <?php echo Core::$pdf_table_column_fillcolor;?>}
},
margin: {top: 100},
afterPageContent: function(data) {
}
});
doc.setFontSize(12);
doc.text("<?php echo Core::$pdf_footer;?>", 40, doc.autoTableEndPosY()+25);
<?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', 495, 20, 60, 60,'mon');
doc.save('sells-<?php echo date("d-m-Y h:i:s",time()); ?>.pdf');
}
<?php else:?>
doc.save('sells-<?php echo date("d-m-Y h:i:s",time()); ?>.pdf');
<?php endif; ?>
}
</script>