public function getSalesInfo()
{
$res = Sales::getInstance()->getSalesByCategory(intval($_GET['active']), intval($_GET['records']), intval($_GET['id_shop_session']));
while ($row = PDOQuery::getInstance()->next_row($res)) {
$this->sale_info[] = array('quantity' => $row['quantity'], 'total' => $row['total'], 'category' => explode(',', $row['category']), 'category_color' => explode(',', $row['category_color']), 'session_date' => date('d/m/Y', $row['session_date']), 'total_cash' => $this->getTotalBySaleType(1, explode(',', $row['id_payment_type']), explode(',', $row['amount'])), 'cash_movements' => $this->getOperationsQty(1, explode(',', $row['id_payment_type']), explode(',', $row['amount'])), 'total_credit' => $this->getTotalBySaleType(2, explode(',', $row['id_payment_type']), explode(',', $row['amount'])), 'credit_movements' => $this->getOperationsQty(2, explode(',', $row['id_payment_type']), explode(',', $row['amount'])), 'total_check' => $this->getTotalBySaleType(3, explode(',', $row['id_payment_type']), explode(',', $row['amount'])), 'check_movements' => $this->getOperationsQty(3, explode(',', $row['id_payment_type']), explode(',', $row['amount'])), 'total_other' => $this->getTotalBySaleType(4, explode(',', $row['id_payment_type']), explode(',', $row['amount'])), 'other_movements' => $this->getOperationsQty(4, explode(',', $row['id_payment_type']), explode(',', $row['amount'])), 'total_refund' => $this->getTotalBySaleType(5, explode(',', $row['id_payment_type']), explode(',', $row['amount'])), 'refund_movements' => $this->getOperationsQty(5, explode(',', $row['id_payment_type']), explode(',', $row['amount'])), 'total_cancellation' => $this->getTotalBySaleType(6, explode(',', $row['id_payment_type']), explode(',', $row['amount'])), 'cancellation_movements' => $this->getOperationsQty(6, explode(',', $row['id_payment_type']), explode(',', $row['amount'])), 'total_replacement' => $this->getTotalBySaleType(7, explode(',', $row['id_payment_type']), explode(',', $row['amount'])), 'replacement_movements' => $this->getOperationsQty(7, explode(',', $row['id_payment_type']), explode(',', $row['amount'])), 'total_otherC' => $this->getTotalBySaleType(8, explode(',', $row['id_payment_type']), explode(',', $row['amount'])), 'otherC_movements' => $this->getOperationsQty(8, explode(',', $row['id_payment_type']), explode(',', $row['amount'])), 'total_invoice' => $this->getTotalBySaleType(1, explode(',', $row['invoice']), explode(',', $row['amount'])), 'invoice_movements' => $this->getOperationsQty(1, explode(',', $row['invoice']), explode(',', $row['amount'])), 'total_ticket' => $this->getTotalBySaleType(0, explode(',', $row['invoice']), explode(',', $row['amount'])), 'ticket_movements' => $this->getOperationsQty(0, explode(',', $row['invoice']), explode(',', $row['amount'])));
}
$this->context->smarty->assign("sale_info", $this->sale_info);
$this->context->smarty->assign("pagination", Sales::getInstance()->pagination_render);
}
public function getSalesInfo()
{
$records = $this->getRecordsToShow();
$res = Sales::getInstance()->getSessionSales(intval($_GET['active']), $records, intval($_GET['id_shop_session']));
while ($row = PDOQuery::getInstance()->next_row($res)) {
$this->summary_products[] = array('amount' => $row['amount'], 'employee_name' => $row['employee_name'], 'reference' => $row['reference'], 'price' => $row['price'], 'quantity' => $row['quantity'], 'product' => $row['product'], 'related_product' => $row['related_product'], 'related_reference' => $row['related_reference'], 'date_sale' => date('H:i ', $row['date_sale']), 'session_date' => date('d/m/Y', $row['session_date']), 'note' => htmlspecialchars($row['note']), 'payment_type' => $row['payment'], 'invoice' => $row['invoice'], 'color' => $row['color'], 'sale_type' => $row['id_sale_type'], 'id_payment_type' => $row['id_payment_type'], 'id_sale' => $row['id_sale'], 'position' => $row['position']);
}
$this->context->smarty->assign("summary_products", $this->summary_products);
$this->context->smarty->assign("pagination", Sales::getInstance()->pagination_render);
}
public function getSalesHistory()
{
$res = Sales::getInstance()->getTotalSaleList(intval($_GET['orderBy']), intval($_GET['records']));
$odd = true;
while ($row = PDOQuery::getInstance()->next_row($res)) {
$odd = $odd == true ? false : true;
$this->sale_info[] = array('total' => $row['total'], 'id_shop_session' => $row['id_shop_session'], 'date' => date('d/m/Y - H:i', $row['date']), 'odd' => $odd);
}
$this->context->smarty->assign("sale_info", $this->sale_info);
$this->context->smarty->assign("pagination", Sales::getInstance()->pagination_render);
}
public function getCurrentMonthSalesInformation()
{
$month_info = array();
$sales = Sales::getInstance();
$res = $sales->getTotalMonthSales();
$operations = 0;
while ($row = PDOQuery::getInstance()->next_row($res)) {
if (_CURRENT_MONTH_ == date('n', $row['date_sale'])) {
$operations++;
$total += $row['amount'];
}
}
$month_info['operations'] = $operations > 0 ? $operations : 0;
$month_info['total'] = $operations > 0 ? $total : 0;
return $month_info;
}
