<div class=""> <div class="table-responsive "> <!-- .table - Uses sparkline charts--> <?php $meseros = UserData::getAllMeseros(); if (count($meseros) > 0) { ?> <table class="table table-striped table-bordered datatable "> <thead> <th></th> <th>Nombre</th> <th>Total</th> </thead> <?php foreach ($meseros as $mesero) { $sells = SellData::getAllDayliByMesero($mesero->id); $total = 0; if (count($sells) > 0) { foreach ($sells as $sell) { $total += $sell->total; } } ?> <tr> <td><a href="index.php?view=reportbymesero&mesero_id=<?php echo $mesero->id; ?> " class="btn btn-default btn-xs"><i class="glyphicon glyphicon-chevron-right"></i></a> </td> <td><?php echo $mesero->name . " " . $mesero->lastname; ?>
<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/onere-word.php?id=<?php echo $_GET["id"]; ?> ">Word 2007 (.docx)</a></li> </ul> </div> <h1>Resumen de Reabastecimiento</h1> <?php if (isset($_GET["id"]) && $_GET["id"] != "") { $sell = SellData::getById($_GET["id"]); $operations = OperationData::getAllProductsBySellId($_GET["id"]); $total = 0; if (isset($_COOKIE["selled"])) { foreach ($operations as $operation) { // print_r($operation); $qx = OperationData::getQYesF($operation->product_id); // print "qx=$qx"; $p = $operation->getProduct(); if ($qx == 0) { echo "<p class='alert alert-danger'>El producto <b style='text-transform:uppercase;'> {$p->name}</b> no tiene existencias en inventario.</p>"; } else { if ($qx <= $p->inventary_min / 2) { echo "<p class='alert alert-danger'>El producto <b style='text-transform:uppercase;'> {$p->name}</b> tiene muy pocas existencias en inventario.</p>"; } else { if ($qx <= $p->inventary_min) {
Autoloader::register(); $word = new PhpOffice\PhpWord\PhpWord(); $clients = PersonData::getClients(); $section1 = $word->AddSection(); $section1->addText("HISTORIAL DE CAJA", array("size" => 22, "bold" => true, "align" => "right")); $boxes = BoxData::getAll(); $products = SellData::getSellsUnBoxed(); $styleTable = array('borderSize' => 6, 'borderColor' => '888888', 'cellMargin' => 40); $styleFirstRow = array('borderBottomColor' => '0000FF', 'bgColor' => 'AAAAAA'); $table1 = $section1->addTable("table1"); $table1->addRow(); $table1->addCell()->addText("Total"); $table1->addCell()->addText("Fecha"); $total_total = 0; foreach ($boxes as $box) { $sells = SellData::getByBoxId($box->id); $total = 0; foreach ($sells as $sell) { $operations = OperationData::getAllProductsBySellId($sell->id); foreach ($operations as $operation) { $product = $operation->getProduct(); $total += $operation->q * $product->price_out; } } $total_total += $total; $table1->addRow(); $table1->addCell(5000)->addText("\$ " . number_format($total, 2, ".", ",")); $table1->addCell(2500)->addText($box->created_at); } $section1->addText(""); $section1->addText("Total: \$" . number_format($total_total, 2, ".", ","), array("size" => 22));
</div> </div> <br><!--- --> <div class="row"> <div class="col-md-12"> <?php if (isset($_GET["sd"]) && isset($_GET["ed"])) { if ($_GET["sd"] != "" && $_GET["ed"] != "") { ?> <?php $operations = array(); if ($_GET["client_id"] == "") { $operations = SellData::getAllByDateOp($_GET["sd"], $_GET["ed"], 2); } else { $operations = SellData::getAllByDateBCOp($_GET["client_id"], $_GET["sd"], $_GET["ed"], 2); } ?> <?php if (count($operations) > 0) { ?> <?php $supertotal = 0; ?> <table class="table table-bordered"> <thead> <th>Id</th> <th>Subtotal</th> <th>Descuento</th> <th>Total</th>
<table class="table table-bordered table-hover datatable"> <thead> <th>Numero</th> <th></th> </thead> <?php foreach (ItemData::getAll() as $career) { ?> <tr> <td><b><?php echo $career->name; ?> </b></td> <td> <?php $sells = SellData::getAllUnAppliedByItemId($career->id); if (count($sells) > 0) { ?> <?php foreach ($sells as $s) { ?> <?php $operations = OperationData::getAllProductsBySellId($s->id); $mesero = UserData::getById($s->mesero_id); ?> <?php if (count($operations) > 0) { ?> <table class="table table-bordered"> <tr> <td><a href="./?view=onesell&id=<?php
} if ($num_succ == count($cart)) { $process = true; } if ($process == false) { $_SESSION["errors"] = $errors; ?> <script> window.location="index.php?view=sell"; </script> <?php } ////////////////////////////////// if ($process == true) { $sell = new SellData(); $sell->q = $_POST["q"]; $sell->mesero_id = $_POST["mesero_id"]; $sell->item_id = $_POST["mesa"]; $s = $sell->add(); foreach ($cart as $c) { print_r($c); print "<br>"; $op = new OperationData(); $op->product_id = $c["product_id"]; $op->operation_type_id = OperationTypeData::getByName("salida")->id; $op->sell_id = $s[1]; $op->q = $c["q"]; if (isset($_POST["is_oficial"])) { $op->is_oficial = 1; }
<li><a href="report/box-word.php?id=<?php echo $_GET["id"]; ?> ">Word 2007 (.docx)</a></li> </ul> </div> </div> <h1><i class='fa fa-archive'></i> Corte de Caja #<?php echo $_GET["id"]; ?> </h1> <div class="clearfix"></div> <?php $products = SellData::getByBoxId($_GET["id"]); if (count($products) > 0) { $total_total = 0; ?> <br> <table class="table table-bordered table-hover "> <thead> <th></th> <th>Total</th> <th>Fecha</th> </thead> <?php foreach ($products as $sell) { ?> <tr>
include "../core/autoload.php"; include "../core/app/model/BoxData.php"; include "../core/app/model/SellData.php"; include "../core/app/model/PersonData.php"; include "../core/app/model/OperationData.php"; include "../core/app/model/ProductData.php"; require_once '../PhpWord/Autoloader.php'; use PhpOffice\PhpWord\Autoloader; use PhpOffice\PhpWord\Settings; Autoloader::register(); $word = new PhpOffice\PhpWord\PhpWord(); $clients = PersonData::getClients(); $section1 = $word->AddSection(); $section1->addText("CORTE DE CAJA #" . $_GET["id"], array("size" => 22, "bold" => true, "align" => "right")); $sells = SellData::getByBoxId($_GET["id"]); $styleTable = array('borderSize' => 6, 'borderColor' => '888888', 'cellMargin' => 40); $styleFirstRow = array('borderBottomColor' => '0000FF', 'bgColor' => 'AAAAAA'); $table1 = $section1->addTable("table1"); $table1->addRow(); $table1->addCell()->addText("Total"); $table1->addCell()->addText("Fecha"); $total_total = 0; foreach ($sells as $sell) { $total = 0; $operations = OperationData::getAllProductsBySellId($sell->id); foreach ($operations as $operation) { $product = $operation->getProduct(); $total += $operation->q * $product->price_out; } $total_total += $total;
if (isset($_GET["page"])) { $page = $_GET["page"]; } $limit = 10; if (isset($_GET["limit"]) && $_GET["limit"] != "" && $_GET["limit"] != $limit) { $limit = $_GET["limit"]; } $products = null; if (!isset($_GET["t"])) { $products = SellData::getAll(); } else { if (isset($_GET["t"]) && $_GET["t"] == "0") { $products = SellData::getAllUnApplied(); } else { if (isset($_GET["t"]) && $_GET["t"] == "1") { $products = SellData::getAllApplied(); } } } if (count($products) > 0) { ?> <div class="box box-solid box-primary"> <div class="box-header"> <h3 class="box-title"></h3> </div> <div class="box-body table-responsive"> <table class="table table-bordered table-hover datatable"> <thead> <th></th> <th>Id</th>
} if ($num_succ == count($cart)) { $process = true; } if ($process == false) { $_SESSION["errors"] = $errors; ?> <script> window.location="index.php?view=sell"; </script> <?php } ////////////////////////////////// if ($process == true) { $sell = new SellData(); $sell->user_id = $_SESSION["user_id"]; $sell->total = $_POST["total"]; $sell->discount = $_POST["discount"]; if (isset($_POST["client_id"]) && $_POST["client_id"] != "") { $sell->person_id = $_POST["client_id"]; $s = $sell->add_with_client(); } else { $s = $sell->add(); } foreach ($cart as $c) { $op = new OperationData(); $op->product_id = $c["product_id"]; $op->operation_type_id = OperationTypeData::getByName("salida")->id; $op->sell_id = $s[1]; $op->q = $c["q"];
<div class="row"> <div class="col-md-12"> <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" class="btn btn-primary ">Procesar Ventas <i class="fa fa-arrow-right"></i></a> </div> <h1><i class='fa fa-archive'></i> Caja</h1> <div class="clearfix"></div> <?php $products = SellData::getSellsUnBoxed(); if (count($products) > 0) { $total_total = 0; ?> <br> <table class="table table-bordered table-hover "> <thead> <th></th> <th>Producto</th> <th>Total</th> <th>Fecha</th> </thead> <?php foreach ($products as $sell) { ?> <tr> <td style="width:30px;"> <td>
<div class="row"> <div class="col-md-12"> <h1><i class='glyphicon glyphicon-shopping-cart'></i> Lista de Ventas</h1> <div class="clearfix"></div> <?php $products = SellData::getSells(); if (count($products) > 0) { ?> <br> <table class="table table-bordered table-hover "> <thead> <th></th> <th>Producto</th> <th>Total</th> <th>Fecha</th> <th></th> </thead> <?php foreach ($products as $sell) { ?> <tr> <td style="width:30px;"> <a href="index.php?view=onesell&id=<?php echo $sell->id; ?> " class="btn btn-xs btn-default"><i class="glyphicon glyphicon-eye-open"></i></a></td> <td>
<div class="row"> <div class="col-md-12"> <h1><i class='glyphicon glyphicon-shopping-cart'></i> Reabastecimientos</h1> <div class="clearfix"></div> <?php $products = SellData::getRes(); if (count($products) > 0) { ?> <br> <table class="table table-bordered table-hover "> <thead> <th></th> <th>Producto</th> <th>Total</th> <th>Fecha</th> <th></th> </thead> <?php foreach ($products as $sell) { ?> <tr> <td style="width:30px;"><a href="index.php?view=onere&id=<?php echo $sell->id; ?> " class="btn btn-xs btn-default"><i class="glyphicon glyphicon-eye-open"></i></a></td> <td>
<?php $sells = SellData::getSellsUnBoxed(); if (count($sells)) { $box = new BoxData(); $b = $box->add(); foreach ($sells as $sell) { $sell->box_id = $b[1]; $sell->update_box(); } Core::redir("./index.php?view=b&id=" . $b[1]); }
<?php if (isset($_SESSION["reabastecer"])) { $cart = $_SESSION["reabastecer"]; if (count($cart) > 0) { $process = true; ////////////////////////////////// if ($process == true) { $sell = new SellData(); $sell->user_id = $_SESSION["user_id"]; if (isset($_POST["client_id"]) && $_POST["client_id"] != "") { $sell->person_id = $_POST["client_id"]; $s = $sell->add_re_with_client(); } else { $s = $sell->add_re(); } foreach ($cart as $c) { $op = new OperationData(); $op->product_id = $c["product_id"]; $op->operation_type_id = 1; // 1 - entrada $op->sell_id = $s[1]; $op->q = $c["q"]; if (isset($_POST["is_oficial"])) { $op->is_oficial = 1; } $add = $op->add(); } unset($_SESSION["reabastecer"]); setcookie("selled", "selled"); ////////////////////