| Server IP : 74.208.127.88 / Your IP : 18.222.188.218 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();
$users = UserData::getAll2();
?>
<section class="content">
<div class="row">
<div class="col-md-12">
<nav class = "navbar navbar-inverse">
<div class = "container-fluid">
<a href = "#" class = "navbar-brand">Reportes de Facturacion</a>
</div>
</nav>
</content>
<div class = "row-fluid" class="form-control">
<div class = "col-md-3"></div>
<div class="panel panel-default">
<hr style = "border-top:1px dotted #000;"/>
<div class = "form-inline">
<div class="row">
<div class="col-md-12">
<form>
<input type="hidden" name="view" value="factreports">
<div class="row">
<div class="col-md-2">
<select name="user_id" class="form-control">
<option value="">-- VENDEDOR --</option>
<?php foreach($users as $p):?>
<option value="<?php echo $p->id_user;?>"><?php echo $p->username;?></option>
<?php endforeach; ?>
</select>
</div>
<div class="col-md-3">
<select name="client_id" class="form-control">
<option value="">-- CLIENTE --</option>
<?php foreach($clients as $p):?>
<option value="<?php echo $p->rfc;?>"> <?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-1">
<button type="submit" class="btn btn-primary btn-block"><i class="fa fa-file-text"></i></button>
</div>
</div>
<!--
<br>
<div class="row">
<div class="col-md-4">
<select name="mesero_id" class="form-control">
<option value="">-- MESEROS --</option>
<?php foreach($meseros as $p):?>
<option value="<?php echo $p->id;?>"><?php echo $p->name;?></option>
<?php endforeach; ?>
</select>
</div>
<div class="col-md-4">
<select name="operation_type_id" class="form-control">
<option value="1">VENTA</option>
</select>
</div>
</div>
-->
</form>
</div>
</div>
<br>
<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($_GET["client_id"]=="" && $_GET["user_id"]==""){
$operations = FacturaData::getAllByDateOp($_GET["sd"],$_GET["ed"],2);
}
else if($_GET["client_id"]=="" && $_GET["user_id"]!=""){
$operations = FacturaData::getAllByDateOpByUserId($_GET["user_id"],$_GET["sd"],$_GET["ed"],2);
}
else if($_GET["client_id"]!="" && $_GET["user_id"]==""){
$operations = FacturaData::getAllByDateBCOp($_GET["client_id"],$_GET["sd"],$_GET["ed"],2);
}else{
$operations = FacturaData::getAllByDateBCOpByUserId($_GET["user_id"],$_GET["client_id"],$_GET["sd"],$_GET["ed"],2);
}
?>
<?php if(count($operations)>0):?>
<?php $supertotal = 0;
$subtotal_total= 0;
$impuestos_total= 0;
?>
<a onclick="thePDF()" id="makepdf" class="btn btn-default" class="">PDF (.pdf)</a>
<a href="./report/sellreports-xlsx.php?client_id=<?php echo $_GET["client_id"]; ?>&sd=<?php echo $_GET["sd"]; ?>&ed=<?php echo $_GET["ed"]; ?>" class="btn btn-default">Excel (.xlsx)</a><br><br>
<div class = "table-responsive">
<div class="box box-primary">
<table class="table table-bordered">
<thead class="alert-success">
<th>Id</th>
<th>Rfc</th>
<th>CFDI</th>
<th>Folio</th>
<th>Subtotal</th>
<th>Impuestos</th>
<th>total</th>
<th>Fecha</th>
</thead>
<?php foreach($operations as $operation):
$c = PersonData::getById($operation->person_id);
?>
<tr>
<td style="width:130px;">
<a href="index.php?view=oneFac&id=<?php echo $operation->sell_id;?>&sale_id=<?php echo $operation->sale_id;?>" class="btn btn-xs btn-default"><i class="glyphicon glyphicon-eye-open"></i></a><?php echo $operation->sale_id; ?>
</td>
<td> <?php echo $operation->description; ?></td>
<td> <?php echo $operation->name; ?></td>
<td> <?php echo $operation->sell_id; ?></td>
<td>$ <?php echo number_format($operation->subtotal,2,'.',','); ?> </td>
<td>$ <?php echo number_format($operation->impuestos,2,'.',','); ?> </td>
<td>$ <?php echo number_format($operation->price_out,2,'.',','); ?> </td>
<td><?php echo $operation->created_at; ?></td>
</tr>
<?php
$supertotal+= ($operation->price_out);
$subtotal_total+= ($operation->subtotal);
$impuestos_total+= ($operation->impuestos);
endforeach; ?>
</table>
</div>
<div class="row">
<div class="col-md-4">
<div class="box box-primary">
<table class="table table-bordered">
<tr>
<td>Subtotal:</td>
<td align="right"><u><b> $ <?php echo number_format($subtotal_total,2,'.',','); ?></b></u></td>
</tr>
<tr>
<td>Impuestos:</td>
<td align="right"><u><b>$ <?php echo number_format($impuestos_total,2,'.',','); ?></b></u></td>
</tr>
<tr>
<td>Total:</td>
<td align="right"><u><b>$ <?php echo number_format($supertotal,2,'.',','); ?></b></u></td>
</tr>
</table>
</div>
</div>
</div>
<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("REPORTE DE FACTURACION", 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: "Fecha", dataKey: "id"},
{title: "Folio", dataKey: "subtotal"},
{title: "Cliente", dataKey: "discount"},
{title: "Importe Neto", dataKey: "total"},
{title: "Imp", dataKey: "client"},
{title: "Total", dataKey: "vendor"},
];
var rows = [
<?php foreach($operations as $operation):
?>
{
"id": "<?php echo $operation->created_at; ?>",
"subtotal": " A<?php echo $operation->sell_id; ?>",
"discount": " <?php echo $operation->presentation; ?>",
"total": " <?php echo number_format($operation->subtotal,2,'.',','); ?>",
"client": "$ <?php echo number_format($operation->impuestos,2,'.',','); ?>",
"vendor": "<?php echo number_format($operation->price_out,2,'.',','); ?>",
},
<?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("Subtotal : $ <?php echo number_format($subtotal_total,2,'.',','); ?>", 40, doc.autoTableEndPosY()+40);
doc.setFontSize(12);
doc.text("Impuestos: $ <?php echo number_format($impuestos_total,2,'.',','); ?>", 40, doc.autoTableEndPosY()+65);
doc.setFontSize(12);
doc.text("Gran Total: $ <?php echo number_format($supertotal,2,'.',','); ?>", 40, doc.autoTableEndPosY()+85);
<?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('sellreports-<?php echo date("d-m-Y h:i:s",time()); ?>.pdf');
}
<?php else:?>
doc.save('sellreports-<?php echo date("d-m-Y h:i:s",time()); ?>.pdf');
<?php endif; ?>
}
</script>
<?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>
</div>
</div>