public function updateInvoice($invoiceID, $data)
{
// Delete invoice-lines and add 'em later again
$this->query('DELETE FROM PREFIX_invoice_line WHERE invoice_id = :invoiceID', array('invoiceID' => $invoiceID));
$this->query('DELETE FROM PREFIX_invoice_total WHERE invoice_id = :invoiceID', array('invoiceID' => $invoiceID));
$totalTax = $total = 0;
foreach ($data['amount'] as $line => $amount) {
// Recalculate tax-amount based on the tax-percentage
if ($data['tax_percentage'][$line] > 0) {
$data['tax'][$line] = round($data['amount'][$line] * $data['quantity'][$line] * ($data['tax_percentage'][$line] / 100), 4);
$totalTax += $data['tax'][$line];
} else {
$data['tax'][$line] = 0;
}
$total += $amount * $data['quantity'][$line];
$this->query('INSERT INTO PREFIX_invoice_line (invoice_id, product_id, product, quantity, amount, tax_percentage, description) VALUES (
:invoiceID,
:productID,
:product,
:quantity,
:amount,
:taxPercentage,
:description)', array('invoiceID' => $invoiceID, 'productID' => $data['product_id'][$line], 'product' => $data['product'][$line], 'quantity' => $data['quantity'][$line], 'amount' => $data['amount'][$line], 'taxPercentage' => $data['tax_percentage'][$line], 'description' => $data['description'][$line]));
}
foreach ($data['totals'] as $sortOrder => $productTotal) {
$labelInject = isset($productTotal['label_inject']) ? $productTotal['label_inject'] : '';
$this->query("INSERT INTO PREFIX_invoice_total\n SET invoice_id = :id,\n sort_order = :sortOrder,\n label = :label,\n label_inject = :labelInject,\n value = :value,\n value_hr = :valueHR", array('id' => $invoiceID, 'sortOrder' => $sortOrder, 'label' => $productTotal['label'], 'labelInject' => $labelInject, 'value' => $productTotal['value'], 'valueHR' => Formatter::currency($productTotal['value'])));
}
// Totalamount is always the last line.
$total = $productTotal['value'];
$invoicePrefix = $this->config->get('invoice_prefix');
// Customer country numeric? Change to plain text
if (preg_match("/^\\d+\$/", $data['customer_country'])) {
$countryData = $this->query("SELECT name FROM PREFIX_country WHERE country_id = :countryID", array('countryID' => $data['customer_country']))->fetch();
$data['customer_country'] = !empty($countryData) ? $countryData['name'] : '-';
}
$this->query('UPDATE PREFIX_invoice SET
invoice_no = :invoiceNO,
customer_id = :customerID,
customer_no = :customerNo,
customer_name = :customerName,
customer_address = :customerAddress,
customer_postcode = :customerPostcode,
customer_city = :customerCity,
customer_country = :customerCountry,
customer_email = :customerEmail,
payment_amount = :paymentAmount,
payment_tax_percentage = :paymentTax,
shipping_amount = :shippingAmount,
shipping_tax_percentage = :shippingTax,
discount = :discount,
total_amount = :amount,
sent_date = :sentDate,
notes = :notes,
template = :template,
term = :term,
auto = :auto,
reference = :reference
WHERE invoice_id = :invoiceID', array('invoiceNO' => $invoicePrefix . str_pad($invoiceID, 5, 0, STR_PAD_LEFT), 'customerNo' => $customerNo, 'customerID' => $data['customer_id'], 'customerName' => $data['customer_name'], 'customerAddress' => $data['customer_address'], 'customerPostcode' => $data['customer_postcode'], 'customerCity' => $data['customer_city'], 'customerCountry' => $data['customer_country'], 'customerEmail' => $data['customer_email'], 'paymentAmount' => $data['payment_amount'], 'paymentTax' => $data['payment_tax'], 'shippingAmount' => $data['shipping_amount'], 'shippingTax' => $data['shipping_tax'], 'discount' => json_encode($data['discount']), 'amount' => $total, 'sentDate' => Formatter::dateReverse($data['sent_date']), 'notes' => $data['notes'], 'template' => $data['template'], 'term' => $data['term'], 'auto' => $data['auto'], 'reference' => $data['reference'], 'invoiceID' => $invoiceID));
}
public function editReturn($return_id, $data)
{
$data['quantity'] = (int) $data['quantity'];
$data['opened'] = (int) $data['opened'];
$data['date_ordered'] = Formatter::dateReverse($data['date_ordered']);
$data['return_id'] = $return_id;
$this->query("UPDATE PREFIX_return\n SET order_id = :order_id,\n product_id = :product_id,\n customer_id = :customer_id,\n firstname = :firstname,\n lastname = :lastname,\n telephone = :telephone,\n product = :product,\n model = :model,\n quantity = :quantity,\n opened = :opened,\n return_reason_id = :return_reason_id,\n return_action_id = :return_action_id,\n return_status_id = :return_status_id,\n comment = :comment,\n date_ordered = :date_ordered,\n date_modified = NOW()\n WHERE return_id = :return_id", $data);
Cache::removeAll();
}
public function editCoupon($coupon_id, $data)
{
$this->query("UPDATE PREFIX_coupon\n SET name = :name,\n code = :code,\n discount = :discount,\n tax_percentage = :tax_percentage,\n type = :type,\n total = :total,\n logged = :logged,\n shipping = :shipping,\n date_start = :date_start,\n date_end = :date_end,\n uses_total = :uses_total,\n uses_customer = :uses_customer,\n status = :status\n WHERE coupon_id = :id", array('name' => $data['name'], 'code' => $data['code'], 'discount' => (double) $data['discount'], 'tax_percentage' => (double) $data['tax_percentage'], 'type' => $data['type'], 'total' => (double) $data['total'], 'logged' => (int) $data['logged'], 'shipping' => (int) $data['shipping'], 'date_start' => Formatter::dateReverse($data['date_start']), 'date_end' => Formatter::dateReverse($data['date_end']), 'uses_total' => (int) $data['uses_total'], 'uses_customer' => (int) $data['uses_customer'], 'status' => (int) $data['status'], 'id' => $coupon_id));
$this->query("DELETE FROM PREFIX_coupon_product WHERE coupon_id = " . (int) $coupon_id);
if (isset($data['coupon_product'])) {
foreach ($data['coupon_product'] as $product_id) {
$this->query("INSERT INTO PREFIX_coupon_product SET coupon_id = " . (int) $coupon_id . ", product_id = " . (int) $product_id);
}
}
$this->query("DELETE FROM PREFIX_coupon_category WHERE coupon_id = " . (int) $coupon_id);
if (isset($data['coupon_category'])) {
foreach ($data['coupon_category'] as $category_id) {
$this->query("INSERT INTO PREFIX_coupon_category SET coupon_id = " . (int) $coupon_id . ", category_id = " . (int) $category_id);
}
}
}
public function redeem($coupon_id, $order_id, $customer_id, $amount)
{
$this->query("INSERT INTO PREFIX_coupon_history\n SET coupon_id = :id,\n customer_id = :cid,\n order_id = :oid,\n amount = :amount,\n date_added = :date", array('id' => $coupon_id, 'cid' => $customer_id, 'oid' => $order_id, 'amount' => $amount, 'date' => Formatter::dateReverse(time())));
}
public function editProduct($product_id, $data)
{
// stock & quantity
if (isset($data['stock_product']) && !$data['stock_product'] || $data['stock_id'] == $product_id) {
$data['stock_id'] = $product_id;
$data['product_quantity'] = (int) $data['product_quantity'];
if (!isset($data['stock_status_id'])) {
$data['stock_status_id'] = 1;
}
$data['stock_status_id'] = (int) $data['stock_status_id'];
} else {
// Existing product as stock_id?
$query = $this->query('SELECT product_id FROM PREFIX_product WHERE product_id = ' . (int) $data['stock_id'])->fetch();
if ($query['product_id'] > 0) {
$data['product_quantity'] = 'p2.quantity';
$data['stock_status_id'] = 'p2.stock_status_id';
} else {
$data['stock_status_id'] = 1;
$data['stock_id'] = $product_id;
$data['product_quantity'] = (int) $data['product_quantity'];
}
}
$data['product_price'] = str_replace(',', '.', $data['product_price']);
$data['cost_price'] = str_replace(',', '.', $data['cost_price']);
$this->query("UPDATE PREFIX_product\n SET stock_id = :stock\n WHERE product_id = :pid", array('stock' => $data['stock_id'], 'pid' => $product_id));
$this->query("UPDATE PREFIX_product AS p\n INNER JOIN PREFIX_product AS p2\n ON p.stock_id = p2.product_id\n SET p.model_2 = :model,\n p.model_supplier = :model_supplier,\n p.location = :location,\n p.minimum = :minimum,\n p.subtract = :subtract,\n p.quantity = :quantity,\n p.stock_status_id = :stock_status_id,\n p.stock_id = :stock_id,\n p.stock_visible = :stock_visible,\n p.date_available = :date_available,\n p.manufacturer_id = :manufacturer_id,\n p.shipping = :shipping,\n p.price = :price,\n p.cost_price = :cost_price,\n p.points = :points,\n p.weight = :weight,\n p.weight_class_id = :wclass_id,\n p.length = :length,\n p.width = :width,\n p.height = :height,\n p.length_class_id = :lclass_id,\n p.status = :status,\n p.tax_percentage = :tax_percentage,\n p.date_modified = :modified\n WHERE p.product_id = :product_id", array('model' => $data['model_2'], 'model_supplier' => $data['model_supplier'], 'location' => $data['location'], 'minimum' => $data['minimum'], 'subtract' => $data['subract'], 'quantity' => $data['product_quantity'], 'stock_status_id' => $data['stock_status_id'], 'stock_id' => $data['stock_id'], 'stock_visible' => $data['stock_visible'], 'date_available' => Formatter::dateReverse($data['date_available']), 'manufacturer_id' => $data['manufacturer_id'], 'shipping' => $data['shipping'], 'price' => $data['product_price'], 'cost_price' => $data['cost_price'], 'points' => $data['product_points'], 'weight' => $data['product_weight'], 'wclass_id' => $data['weight_class_id'], 'length' => $data['length'], 'lclass_id' => $data['length_class_id'], 'height' => $data['height'], 'width' => $data['width'], 'status' => $data['status'], 'tax_percentage' => $data['tax_percentage'], 'modified' => date('Y-m-d H:i:s'), 'product_id' => $product_id));
$info_types = array('sku', 'upc', 'ean', 'jan', 'isbn', 'mpn');
foreach ($info_types as $type) {
if (isset($data[$type])) {
if (!isset($data[$type . '_visible'])) {
$data[$type . '_visible'] = 0;
}
$this->query("\n UPDATE PREFIX_product\n SET " . $type . " = :var,\n " . $type . "_visible = " . (int) $data[$type . '_visible'] . "\n WHERE product_id = :pid", array('pid' => $product_id, 'var' => !empty($data[$type]) ? $data[$type] : ''));
}
}
if (!isset($data['sort_order'])) {
$sort_order = 0;
// Get highest sort order for all categories
foreach ($data['product_category'] as $k => $category_id) {
$row = $this->query("\n SELECT MAX(sort_order) AS sort_order\n FROM PREFIX_product p\n LEFT JOIN PREFIX_product_to_category AS ptc\n ON ptc.product_id = p.product_id\n WHERE ptc.category_id = " . $category_id)->fetch();
if ($row['sort_order'] > $sort_order) {
$sort_order = $row['sort_order'];
}
}
$this->query("\n UPDATE PREFIX_product\n SET sort_order = " . (int) ($sort_order + 1) . "\n WHERE product_id = " . (int) $product_id);
}
// Delete existing url-aliases (this may cause SEO-issues, investigate that a bit...)
$this->query("DELETE FROM PREFIX_url_alias WHERE `query` = 'product_id=" . $product_id . "'");
$this->query("DELETE FROM PREFIX_product_description WHERE product_id = " . (int) $product_id);
foreach ($data['product_description'] as $language_id => $value) {
unset($value['keyword']);
$value['product_id'] = $product_id;
$value['language_id'] = $language_id;
$this->query("\n INSERT INTO PREFIX_product_description\n SET product_id = :product_id,\n language_id = :language_id,\n name = :name,\n title = :title,\n meta_keyword = :meta_keyword,\n meta_description = :meta_description,\n description = :description,\n tag = :tag", $value);
foreach (array_unique($data['product_category']) as $category_id) {
foreach (array_unique($data['product_store']) as $store_id) {
Formatter::generateSeoURL($value['name'], 'product_id', $product_id, $language_id, $store_id, $category_id);
}
}
}
$this->query("DELETE FROM PREFIX_product_to_store WHERE product_id = " . (int) $product_id);
$this->query("DELETE FROM PREFIX_product_to_category WHERE product_id = " . (int) $product_id);
foreach (array_unique($data['product_category']) as $category_id) {
$this->query("\n INSERT INTO PREFIX_product_to_category\n SET product_id = " . (int) $product_id . ",\n category_id = " . (int) $category_id);
}
foreach (array_unique($data['product_store']) as $store_id) {
$this->query("\n INSERT INTO PREFIX_product_to_store\n SET product_id = " . (int) $product_id . ",\n store_id = " . (int) $store_id);
}
$this->query("DELETE FROM PREFIX_product_attribute WHERE product_id = " . (int) $product_id);
if (!empty($data['attribute']) && is_array($data['attribute'])) {
$this->load->model('catalog/attribute');
foreach ($data['attribute'] as $attributeID) {
// Get attribute info
$attributeInfo = $this->model_catalog_attribute->getAttributeDescriptions($attributeID);
if (!empty($attributeInfo) && is_array($attributeInfo)) {
foreach ($attributeInfo as $languageID => $attributeDescription) {
$this->query("\n INSERT INTO PREFIX_product_attribute\n SET product_id = " . (int) $product_id . ",\n attribute_id = " . (int) $attributeID . ",\n language_id = " . (int) $languageID . ",\n text = :text", array('text' => $attributeDescription['name']));
}
}
}
}
$this->query("DELETE FROM PREFIX_product_option_value_description WHERE value_id IN (SELECT value_id FROM PREFIX_product_option_value WHERE option_id IN (SELECT option_id FROM PREFIX_product_option WHERE product_id = " . (int) $product_id . "))");
$this->query("DELETE FROM PREFIX_product_option_value WHERE option_id IN (SELECT option_id FROM PREFIX_product_option WHERE product_id = " . (int) $product_id . ")");
$this->query("DELETE FROM PREFIX_product_option_description WHERE option_id IN (SELECT option_id FROM PREFIX_product_option WHERE product_id = " . (int) $product_id . ")");
$this->query("DELETE FROM PREFIX_product_option WHERE product_id = " . (int) $product_id);
if (isset($data['product_option'])) {
foreach ($data['product_option'] as $productOption) {
if (!empty($productOption['option_description'][$this->config->get('language_id')]['name'])) {
$this->query("INSERT INTO PREFIX_product_option SET\n product_id = :productID,\n type = :type,\n sort_order = 0", array('productID' => $product_id, 'type' => $productOption['type']));
$optionID = $this->lastInsertId();
// Insert translations
foreach ($productOption['option_description'] as $languageID => $productOptionDescription) {
$this->query("INSERT INTO PREFIX_product_option_description SET\n option_id = :optionID,\n language_id = :languageID,\n name = :name", array('optionID' => $optionID, 'languageID' => $languageID, 'name' => $productOptionDescription['name']));
}
// Insert values (if applicable)
if (in_array($productOption['type'], array('select', 'radio', 'checkbox')) && isset($productOption['product_option_value'])) {
foreach ($productOption['product_option_value'] as $productOptionValue) {
if (!empty($productOptionValue['option_value_description'][$this->config->get('language_id')]['name'])) {
// We want to store the price excluding the tax. Why? The Dutch government likes to change tax
// rates. So! Store as ex-tax, show as inc-tax.
// Make sure commas are replaced with decimal points
$productOptionValue['price'] = str_replace(',', '.', $productOptionValue['price']);
$productOptionValue['weight'] = str_replace(',', '.', $productOptionValue['weight']);
$productOptionValue['price'] = round(floatval($productOptionValue['price']) / (1 + $data['tax_percentage'] / 100), 4);
$this->query("INSERT INTO PREFIX_product_option_value SET\n option_id = :optionID,\n active = :active,\n quantity = :quantity,\n subtract = :subtract,\n price = :price,\n price_prefix = :pricePrefix,\n weight = :weight,\n weight_prefix = :weightPrefix", array('optionID' => $optionID, 'active' => $productOptionValue['active'], 'quantity' => $productOptionValue['quantity'], 'subtract' => $productOptionValue['subtract'], 'price' => $productOptionValue['price'], 'pricePrefix' => $productOptionValue['price_prefix'], 'weight' => $productOptionValue['weight'], 'weightPrefix' => $productOptionValue['weight_prefix']));
$valueID = $this->lastInsertId();
// Insert translations
foreach ($productOptionValue['option_value_description'] as $languageID => $productOptionValueDescription) {
$this->query("INSERT INTO PREFIX_product_option_value_description SET\n value_id = :valueID,\n language_id = :languageID,\n name = :name", array('valueID' => $valueID, 'languageID' => $languageID, 'name' => $productOptionValueDescription['name']));
}
}
}
}
}
}
}
$this->query("DELETE FROM PREFIX_product_discount WHERE product_id = " . (int) $product_id);
if (isset($data['product_discount']) && count($data['product_discount'])) {
foreach ($data['product_discount'] as $list) {
if (empty($list['customer_group_id'])) {
continue;
}
if (empty($list['customer_group_id'])) {
$list['customer_group_id'] = 0;
}
$this->db->query("\n INSERT INTO PREFIX_product_discount\n SET product_id = :product_id,\n customer_group_id = :customer_group_id,\n quantity = :quantity,\n priority = :priority,\n price = :price,\n date_start = :date_start\n date_end = :date_end", array('product_id' => $product_id, 'customer_group_id' => $list['customer_group_id'], 'quantity' => $list['quantity'], 'priority' => $list['priority'], 'price' => $list['price'], 'date_start' => Formatter::dateReverse($list['date_start']), 'date_end' => Formatter::dateReverse($list['date_end'])));
}
}
$this->query("DELETE FROM PREFIX_product_special WHERE product_id = " . (int) $product_id);
if (isset($data['product_special'])) {
foreach ($data['product_special'] as $list) {
if (empty($list['customer_group_id'])) {
continue;
}
if (empty($list['priority'])) {
$list['priority'] = 1;
}
$this->query("\n INSERT INTO PREFIX_product_special\n SET product_id = :product_id,\n customer_group_id = :customer_group_id,\n priority = :priority,\n price = :price,\n date_start = :date_start,\n date_end = :date_end", array('product_id' => $product_id, 'customer_group_id' => $list['customer_group_id'], 'priority' => $list['priority'], 'price' => $list['price'], 'date_start' => Formatter::dateReverse($list['date_start']), 'date_end' => Formatter::dateReverse($list['date_end'])));
}
}
$this->query("DELETE FROM PREFIX_product_image WHERE product_id = " . (int) $product_id);
if (isset($data['product_image']) && sizeof($data['product_image']) > 0) {
foreach ($data['product_image'] as $i => $product_image) {
if ($i == 0) {
$this->query("\n UPDATE PREFIX_product\n SET image = :image\n WHERE product_id = " . (int) $product_id, array('image' => $product_image));
} else {
$this->query("\n INSERT INTO PREFIX_product_image\n SET product_id = " . (int) $product_id . ",\n image = :name,\n sort_order = " . ($i + 1), array('name' => $product_image));
}
}
} else {
// Remove main image
$this->query("UPDATE PREFIX_product SET image = '' WHERE product_id = " . (int) $product_id);
}
$this->query("DELETE FROM PREFIX_product_to_download WHERE product_id = " . (int) $product_id);
if (isset($data['product_download'])) {
foreach ($data['product_download'] as $download_id) {
$this->query("\n INSERT INTO PREFIX_product_to_download\n SET product_id = " . (int) $product_id . ",\n download_id = " . (int) $download_id);
}
}
$this->query("DELETE FROM PREFIX_product_related WHERE product_id = '" . (int) $product_id . "'");
if (isset($data['product_related'])) {
foreach ($data['product_related'] as $related_id) {
$this->query("INSERT INTO PREFIX_product_related SET product_id = " . (int) $product_id . ", related_id = " . (int) $related_id);
}
}
Cache::removeAll();
}
protected function validateForm()
{
if (utf8_strlen($this->request->post['name']) < 3 || utf8_strlen($this->request->post['name']) > 128) {
$this->error['name'] = Language::getVar('SUMO_ERROR_NAME');
}
if (utf8_strlen($this->request->post['code']) < 3 || utf8_strlen($this->request->post['code']) > 50) {
$this->error['code'] = Language::getVar('SUMO_ERROR_CODE');
}
if (!empty($this->request->post['date_start']) && !empty($this->request->post['date_end']) && strtotime(Formatter::dateReverse($this->request->post['date_end'])) < strtotime(Formatter::dateReverse($this->request->post['date_start']))) {
$this->error[] = Language::getVar('SUMO_ERROR_DATE_END_BEFORE_START');
}
$coupon_info = $this->model_sale_coupon->getCouponByCode($this->request->post['code']);
if ($coupon_info) {
if (!isset($this->request->get['coupon_id'])) {
$this->error['warning'] = Language::getVar('SUMO_ERROR_CODE_EXISTS');
} elseif ($coupon_info['coupon_id'] != $this->request->get['coupon_id']) {
$this->error['warning'] = Language::getVar('SUMO_ERROR_CODE_EXISTS');
}
}
if (!$this->error) {
return true;
}
return false;
}
public function addHistory($customer_id, $comment)
{
if (!empty($comment)) {
$this->query("INSERT INTO PREFIX_customer_history\n SET customer_id = :customer_id,\n comment = :comment,\n date_added = :date_added", array('customer_id' => $customer_id, 'comment' => strip_tags($comment), 'date_added' => Formatter::dateReverse(time())));
Cache::removeAll();
}
}
protected function validateForm($data)
{
// Set new product price
$this->load->model('catalog/product');
$productData = $this->model_catalog_product->getProduct($data['product_id']);
if (!$productData) {
$this->data['error'] = Language::getVar('SUMO_ERROR_NO_PRODUCT_FOR_DISCOUNT');
return false;
}
$this->request->post['price'] = $productData['price'];
// Comma's, decimals..
$data['discount'] = str_replace(',', '.', $data['discount']);
if (mb_substr(trim($data['discount']), -1) == '%') {
$discount = trim($data['discount']);
$discount = mb_substr($discount, 0, mb_strlen($discount) - 1);
$discount = floatval($discount);
if ($discount <= 100) {
$data['price'] = $productData['price'] - $productData['price'] * ($discount / 100);
}
$data['discount_suffix'] = '%';
} else {
if (floatval($data['discount']) > $productData['price']) {
$data['price'] = 0;
} else {
$data['price'] = $productData['price'] - floatval($data['discount']);
}
// Amount, no suffix necessary
$data['discount_suffix'] = '';
}
// Check if dates are correct
$data['date_start'] = Formatter::dateReverse($data['date_start']);
$data['date_end'] = Formatter::dateReverse($data['date_end']);
if (strtotime($data['date_end']) < strtotime($data['date_start'])) {
$this->data['error'] = Language::getVar('SUMO_ERROR_END_BEFORE_START');
return false;
}
return $data;
}
private function getDataProductSales($filters)
{
$cache = 'report.products.sales.' . json_encode($filters);
$data = Cache::find($cache);
if (is_array($data) && count($data)) {
//return $data;
}
$sql = "SELECT * FROM PREFIX_orders_lines AS ol LEFT JOIN PREFIX_orders AS o ON o.order_id = ol.order_id";
if (!empty($filters['date_start'])) {
$sql .= " AND DATE(order_date) >= '" . Formatter::dateReverse($filters['date_start']) . "'";
}
if (!empty($filters['date_end'])) {
$sql .= " AND DATE(order_date) <= '" . Formatter::dateReverse($filters['date_end']) . "'";
}
if (isset($filters['start']) && !empty($filters['limit'])) {
if ($filters['start'] < 1) {
$filters['start'] = 0;
}
}
$return = $temp = array();
$products = $this->fetchAll($sql);
$i = 0;
foreach ($products as $list) {
//$list = json_decode($list['data'], true);
$check = $this->query("SELECT viewed FROM PREFIX_product WHERE product_id = :id", array('id' => $list['product_id']))->fetch();
if (empty($check['viewed'])) {
$check['viewed'] = 0;
}
$poc = $list['name'] . $list['product_id'];
if (!isset($temp[$poc])) {
$temp[$poc] = array(0 => $list['name'], 1 => !empty($list['model']) ? $list['model'] : 'P' . $list['product_id'], 2 => $check['viewed'], 3 => 0, 4 => 0);
}
$temp[$poc][3] += $list['quantity'];
$temp[$poc][4] += $list['price'] * $list['quantity'];
}
$quantity = $total = array();
foreach ($temp as $key => $row) {
$quantity[$key] = $row[3];
$total[$key] = $row[4];
}
unset($products);
array_multisort($quantity, SORT_DESC, $total, SORT_DESC, $temp);
unset($quantity);
unset($total);
if (isset($filters['start']) && !empty($filters['limit'])) {
$return = array_slice($temp, $filters['start'], $filters['limit']);
} else {
return count($temp);
}
foreach ($return as $key => $list) {
$return[$key][4] = Formatter::currency($list[4]);
$return[$key][5] = round($list[3] / $list[2] * 100, 2) . '%';
}
Cache::set($cache, $return);
return $return;
}
public function addReturn($data)
{
//$returnStatusID = (int)$this->config->get('return_status_id');
$returnStatusID = 1;
$this->query("INSERT INTO PREFIX_return SET \n order_id = :orderID, \n customer_id = :customerID,\n firstname = :firstname,\n lastname = :lastname,\n email = :email,\n telephone = :telephone,\n product = :product,\n product_id = :productID,\n model = :model,\n quantity = :quantity,\n opened = :opened,\n return_reason_id = :returnReasonID,\n return_status_id = :returnStatusID, \n comment = :comment, \n date_ordered = :dateOrdered, \n date_added = NOW(), \n date_modified = NOW()", array('orderID' => $data['order_id'], 'customerID' => (int) $this->customer->getId(), 'firstname' => $data['firstname'], 'lastname' => $data['lastname'], 'email' => $data['email'], 'telephone' => $data['telephone'], 'product' => $data['product'], 'productID' => $data['product_id'], 'model' => $data['model'], 'quantity' => $data['quantity'], 'opened' => $data['opened'], 'returnReasonID' => $data['return_reason_id'], 'returnStatusID' => $returnStatusID, 'comment' => $data['comment'], 'dateOrdered' => Formatter::dateReverse($data['date_ordered'])));
}
public function editReview($reviewID, $data)
{
$this->query("UPDATE PREFIX_review SET\n author = :author,\n product_id = :productID,\n text = :text,\n rating = :rating,\n status = :status,\n date_added = :dateAdded,\n date_modified = NOW()\n WHERE review_id = :reviewID", array('reviewID' => $reviewID, 'author' => $data['author'], 'productID' => $data['product_id'], 'text' => strip_tags($data['text']), 'rating' => $data['rating'], 'status' => $data['status'], 'dateAdded' => Formatter::dateReverse($data['date_added'])));
Cache::removeAll();
}
