public function getTotal()
{
$products = BuyProductData::getAllByBuyId($this->id);
$total = 0;
foreach ($products as $px) {
$p = ProductData::getById($px->product_id);
$total += $p->price * $px->q;
}
return $total;
}
<?php
$buy = BuyData::getById($_GET["buy_id"]);
$products = BuyProductData::getAllByBuyId($_GET["buy_id"]);
?>
<div class="row">
<div class="col-md-12">
<h2> Compra #<?php
echo $buy->id;
?>
[<?php
echo $buy->getStatus()->name;
?>
]</h2>
<?php
if (count($products) > 0) {
?>
<table class="table table-bordered">
<thead>
<th></th>
<th>Codigo</th>
<th>Total</th>
<th>Estado</th>
</thead>
<?php
foreach ($products as $p) {
$px = $p->getProduct();
?>
<tr>
<td><a href="index.php?view=producto&product_id=<?php
echo $px->id;
///////////////////////////////////// Emailing
$client = ClientData::getById($_SESSION["client_id"]);
$adminemail = $paypal_business = ConfigurationData::getByPreffix("general_main_email")->val;
$replymessage = '
<meta content="es-mx" http-equiv="Content-Language" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<body>
<h2>Tienda en Linea</h2>
<h3>Compra Pendiente</h3>
<p><span class="style3"><strong>Estimado ' . $client->getFullname() . '</strong></span></p>
<p>Se a agregado una compra a tu lista de pendientes, te invitamos a seguir el procedimiento de pago correspondiente para recibir tus productos.</p>
<p>Gracias por tu compra.</p>
<hr>
<p>Powered By <a href="http://evilnapsis.com/product/katana/" target="_blank"> Katana PRO</a></p>
</body>';
$products = BuyProductData::getAllByBuyId($b[1]);
$data = "";
$total = 0;
foreach ($products as $px) {
$product = $px->getProduct();
$data .= "<tr>";
$data .= "<td>{$px->q}</td>";
$data .= "<td>{$product->name}</td>";
$data .= "<td> \$" . number_format($product->price, 2, ".", ",") . "</td>";
$data .= "<td> \$" . number_format($px->q * $product->price, 2, ".", ",") . "</td></tr>";
$total += $px->q * $product->price;
}
$themessage = '
<meta content="es-mx" http-equiv="Content-Language" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<body>
function ImprovedTable($data)
{
$iva = ConfigurationData::getByPreffix("general_iva")->val;
$iva_txt = ConfigurationData::getByPreffix("general_iva_txt")->val;
$coin = ConfigurationData::getByPreffix("general_coin")->val;
$service = BuyData::getByCode($_GET["code"]);
$products = BuyProductData::getAllByBuyId($service->id);
$client = ClientData::getById($service->client_id);
$this->setY(31);
$this->setX(20);
$this->setY(31);
$this->setX(20);
$this->SetFont('Arial', 'B', 8);
$this->setY(33);
$this->setX(20);
$this->setY(40);
$this->setX(20);
$this->SetFont('Arial', 'B', 8);
// $this->Cell(0,35,"",1);
$this->setY(38);
$this->setX(20);
$this->Cell(0, 10, " NOMBRE: " . $client->getFullname());
$this->setY(43);
$this->setX(20);
$this->Cell(0, 10, " DIRECCION: " . $client->address);
$this->setY(48);
$this->setX(20);
$this->Cell(0, 10, "TEL: " . $client->phone);
$this->setY(53);
$this->setX(20);
$this->setY(80);
$this->setX(20);
$this->SetFont('Arial', '', 14);
$this->Cell(0, 10, " DETALLES DE LA COMPRA ");
$this->SetFont('Arial', 'B', 10);
$starty = 0;
$total = 0;
// $inventary_item = InventaryData::getAllBySII($service->id,$ii->id);
$this->setY(95 + $starty);
$this->setX(20);
//// omito el super trabajo
/// $this->Cell(0,10,strtoupper($w->getWork()->name));
$this->setY(95 + $starty);
$this->setX(65);
// $starty+=5;
//////////////////////// materiales
if (count($products)) {
$starty += 5;
foreach ($products as $itemx) {
$item = $itemx->getProduct();
$mtx = null;
$this->setY(95 + $starty);
$this->setX(20);
$this->Cell(0, 10, strtoupper($itemx->q));
$this->setX(30);
$this->Cell(0, 10, strtoupper($item->getUnit()->name));
$this->setX(50);
$this->Cell(0, 10, strtoupper($item->name));
$this->setX(180);
$this->Cell(0, 10, utf8_decode($coin) . " " . number_format($item->price, 2, ".", ","));
$total += $itemx->q * $item->price;
$this->setY(95 + $starty);
$this->setX(65);
$starty += 5;
}
}
$starty += 5;
///////////////////////////////////////////////////////////// Total
$this->SetFont('Arial', '', 12);
$this->setY(125 + $starty);
$this->setX(20);
$this->Cell(0, 10, "SubTotal: " . utf8_decode($coin) . " " . number_format($total * (1 - $iva / 100), 2, ".", ","));
$starty += 5;
$this->setY(125 + $starty);
$this->setX(20);
$this->Cell(0, 10, "{$iva_txt}: " . utf8_decode($coin) . " " . number_format($total * ($iva / 100), 2, ".", ","));
$starty += 5;
$this->setY(125 + $starty);
$this->setX(20);
$this->Cell(0, 10, "Total: " . utf8_decode($coin) . " " . number_format($total, 2, ".", ","));
/////////////////////////////////////////////////////////////
////////////////////////////////////////////////////
}
function ImprovedTable($data)
{
$service = BuyData::getByCode($_GET["code"]);
$products = BuyProductData::getAllByBuyId($service->id);
$client = ClientData::getById($service->client_id);
$this->setY(31);
$this->setX(20);
$this->setY(31);
$this->setX(20);
$this->SetFont('Arial', 'B', 8);
$this->setY(33);
$this->setX(20);
$this->setY(40);
$this->setX(20);
$this->SetFont('Arial', 'B', 8);
// $this->Cell(0,35,"",1);
$this->setY(38);
$this->setX(20);
$this->Cell(0, 10, " NOMBRE: " . $client->name);
$this->setY(43);
$this->setX(20);
$this->Cell(0, 10, " DIRECCION: " . $client->address);
$this->setY(48);
$this->setX(20);
$this->Cell(0, 10, "TEL: " . $client->phone);
$this->setY(53);
$this->setX(20);
$this->setY(80);
$this->setX(20);
$this->SetFont('Arial', '', 14);
$this->Cell(0, 10, " DETALLES DE LA COMPRA ");
$this->SetFont('Arial', 'B', 10);
$starty = 0;
$total = 0;
// $inventary_item = InventaryData::getAllBySII($service->id,$ii->id);
$this->setY(95 + $starty);
$this->setX(20);
//// omito el super trabajo
/// $this->Cell(0,10,strtoupper($w->getWork()->name));
$this->setY(95 + $starty);
$this->setX(65);
// $starty+=5;
//////////////////////// materiales
if (count($products)) {
$starty += 5;
foreach ($products as $itemx) {
$item = $itemx->getProduct();
$mtx = null;
$this->setY(95 + $starty);
$this->setX(20);
$this->Cell(0, 10, strtoupper($itemx->q));
$this->setX(30);
$this->Cell(0, 10, strtoupper($item->getUnit()->name));
$this->setX(50);
$this->Cell(0, 10, strtoupper($item->name));
$this->setX(180);
$this->Cell(0, 10, "\$ " . number_format($item->price, 2, ".", ","));
$total += $itemx->q * $item->price;
$this->setY(95 + $starty);
$this->setX(65);
$starty += 5;
}
}
////////////////////////
//////////////////////// materiales
/*if(count($subworks)){
$this->setX(20);
$this->Cell(0,(count($subworks)*5)+10,"",1);
$this->setY(95+$starty);
$this->setX(20);
$this->Cell(0,10,strtoupper("**MATERIALES"));
$starty+=5;
foreach($subworks as $item){
$mtx=null;
foreach($mts as $mt){ if($mt->material_id==$item->id){ $mtx = $mt; }}
if($mtx!=null&& $mtx->material_id==$item->id){
$this->setY(95+$starty);
$this->setX(20);
$this->Cell(0,10,strtoupper($item->name));
$this->setX(180);
$this->Cell(0,10,"$ ".number_format($item->price,2,".",","));
$this->setY(95+$starty);
$this->setX(65);
$starty+=5;
}
}
}
*/
////////////////////////
// $this->Cell(0,10,"|X|__| ");
// $this->Cell(0,10,"|__|X| ");
$starty += 5;
///////////////////////////////////////////////////////////// Total
$this->SetFont('Arial', '', 12);
$this->setY(125 + $starty);
$this->setX(20);
$this->Cell(0, 10, "SubTotal: \$ " . number_format($total * 0.84, 2, ".", ","));
$starty += 5;
$this->setY(125 + $starty);
$this->setX(20);
$this->Cell(0, 10, "IVA: \$ " . number_format($total * 0.16, 2, ".", ","));
$starty += 5;
$this->setY(125 + $starty);
$this->setX(20);
$this->Cell(0, 10, "Total: \$ " . number_format($total, 2, ".", ","));
/////////////////////////////////////////////////////////////
////////////////////////////////////////////////////
}
?>
<div class="box box-primary">
<div id="graph" class="animate" data-animate="fadeInUp" ></div>
</div>
<script>
<?php
echo "var c=0;";
echo "var dates=Array();";
echo "var data=Array();";
echo "var total=Array();";
for ($i = $start_at; $i <= $finish_at; $i += 60 * 60 * 24) {
$operations = BuyData::getAllByDate(date("Y-m-d", $i));
$total = 0;
foreach ($operations as $buy) {
$opxs = BuyProductData::getAllByBuyId($buy->id);
foreach ($opxs as $op) {
$product = $op->getProduct();
$total += $op->q * $product->price;
}
}
// echo $operations[0]->t;
// $sl = $operations[0]->t!=null?$operations[0]->t:0;
// $sp = $spends[0]->t!=null?$spends[0]->t:0;
echo "dates[c]=\"" . date("Y-m-d", $i) . "\";";
echo "data[c]=" . $total . ";";
echo "total[c]={x: dates[c],y: data[c]};";
echo "c++;";
}
?>
// Use Morris.Area instead of Morris.Line