| Server IP : 46.105.57.169 / Your IP : 216.73.216.67 Web Server : Apache System : Linux webm002.cluster120.gra.hosting.ovh.net 6.18.42-ovh-vps-grsec-zfs+ #1 SMP PREEMPT_DYNAMIC Wed Aug 5 15:59:48 CEST 2026 x86_64 User : verseaumee ( 152031) PHP Version : 8.5.7 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/verseaumee/zenit/administrator/components/com_hikashop/classes/ |
Upload File : |
<?php
/**
* @package HikaShop for Joomla!
* @version 4.5.1
* @author hikashop.com
* @copyright (C) 2010-2022 HIKARI SOFTWARE. All rights reserved.
* @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html
*/
defined('_JEXEC') or die('Restricted access');
?><?php
class hikashopOrder_productClass extends hikashopClass {
var $tables = array('order_product');
var $pkeys = array('order_product_id');
public function get($order_product_id, $default = null) {
$result = parent::get($order_product_id);
if(!empty($result->order_product_tax_info))
$result->order_product_tax_info = hikashop_unserialize($result->order_product_tax_info);
return $result;
}
public function save(&$products) {
if(empty($products))
return true;
$config = hikashop_config();
$items = array();
$updates = array();
$wishlistUpdates = array();
$productsQuantity = array();
$discounts = array();
$fields = array(
'order_id',
'product_id',
'order_product_quantity',
'order_product_name',
'order_product_code',
'order_product_price',
'order_product_tax',
'order_product_options',
'order_product_option_parent_id',
'order_product_tax_info',
'order_product_wishlist_id',
'order_product_wishlist_product_id',
'order_product_shipping_id',
'order_product_shipping_method',
'order_product_shipping_price',
'order_product_shipping_tax',
'order_product_shipping_params',
'order_product_weight',
'order_product_weight_unit',
'order_product_width',
'order_product_length',
'order_product_height',
'order_product_dimension_unit',
'order_product_price_before_discount',
'order_product_tax_before_discount',
'order_product_discount_code',
'order_product_discount_info',
);
if(hikashop_level(2)) {
$element = null;
$fieldsClass = hikashop_get('class.field');
$itemFields = $fieldsClass->getFields('frontcomp', $products, 'item');
if(!empty($itemFields)) {
foreach($itemFields as $field){
if($field->field_type == 'customtext')
continue;
$fields[] = $field->field_namekey;
}
}
}
$productClass = hikashop_get('class.product');
$product_ids = array();
foreach($products as $product) {
$product_ids[ (int)$product->product_id ] = (int)$product->product_id;
}
if(hikashop_level(1)) {
$this->handleProductBundles($product_ids, $products);
}
$query = 'SELECT product_id, product_type, product_parent_id FROM ' . hikashop_table('product') . ' WHERE product_id IN ('.implode(',', $product_ids).')';
unset($product_ids);
$this->database->setQuery($query);
$products_data = $this->database->loadObjectList('product_id');
$order_id = 0;
foreach($products as $product) {
$order_id = (int)$product->order_id;
if(isset($product->order_product_tax_info) && !is_string($product->order_product_tax_info))
$product->order_product_tax_info = serialize($product->order_product_tax_info);
if(!empty($product->order_product_options) && (!is_string($product->order_product_options) || is_numeric($product->order_product_options)))
$product->order_product_options = serialize($product->order_product_options);
if(isset($product->order_product_discount_info) && !is_string($product->order_product_discount_info))
$product->order_product_discount_info = serialize($product->order_product_discount_info);
$line = array(
$order_id,
(int)$product->product_id,
(int)$product->order_product_quantity,
$this->database->Quote($product->order_product_name),
$this->database->Quote($product->order_product_code),
$this->database->Quote(@$product->order_product_price),
$this->database->Quote(@$product->order_product_tax),
$this->database->Quote(@$product->order_product_options),
(int)@$product->cart_product_id,
$this->database->Quote(@$product->order_product_tax_info),
(int)@$product->order_product_wishlist_id,
(int)@$product->order_product_wishlist_product_id,
$this->database->Quote(@$product->order_product_shipping_id),
$this->database->Quote(@$product->order_product_shipping_method),
(float)@$product->order_product_shipping_price,
(float)@$product->order_product_shipping_tax,
$this->database->Quote(@$product->order_product_shipping_params),
(float)@$product->order_product_weight,
$this->database->Quote(@$product->order_product_weight_unit),
(float)@$product->order_product_width,
(float)@$product->order_product_length,
(float)@$product->order_product_height,
$this->database->Quote(@$product->order_product_dimension_unit),
(float)@$product->order_product_price_before_discount,
(float)@$product->order_product_tax_before_discount,
(float)@$product->order_product_discount_code,
$this->database->Quote(@$product->order_product_discount_info),
);
if(!empty($itemFields)) {
foreach($itemFields as $field) {
if($field->field_type == 'customtext')
continue;
$namekey = $field->field_namekey;
$line[] = $this->database->Quote(@$product->$namekey);
}
}
$items[] = '('.implode(',',$line).')';
if(!empty($product->product_id) && empty($product->no_update_qty)) {
if(empty($productsQuantity[(int)$product->product_id]))
$productsQuantity[(int)$product->product_id] = 0;
$quantity = $product->order_product_quantity;
if(empty($quantity) && !empty($product->order_product_options)){
$options = hikashop_unserialize($product->order_product_options);
if(!empty($options['type']) && $options['type'] == 'bundle' && !empty($options['related_quantity']) && !empty($product->cart_product_option_parent_id)){
foreach($products as $main_product){
if($main_product->cart_product_id == $product->cart_product_option_parent_id){
$quantity = $options['related_quantity'] * $main_product->order_product_quantity;
break;
}
}
}
}
$productsQuantity[(int)$product->product_id] += $quantity;
$prod = $products_data[(int)$product->product_id];
if($prod->product_type == 'variant' && !empty($prod->product_parent_id)) {
if(empty($productsQuantity[(int)$prod->product_parent_id]))
$productsQuantity[(int)$prod->product_parent_id] = 0;
$productsQuantity[(int)$prod->product_parent_id] += $quantity;
}
}
if(!empty($product->discount)) {
if(empty($discounts[$product->discount->discount_code]))
$discounts[$product->discount->discount_code] = 0;
$discounts[$product->discount->discount_code] += (int)$product->order_product_quantity;
}
if(isset($product->order_product_wishlist_id) && (int)$product->order_product_wishlist_id != 0) {
$wishlistUpdates[] = array(
'product' => $product->product_id,
'cart' => (int)$product->order_product_wishlist_id,
'cart_product' => (int)@$product->order_product_wishlist_product_id,
'qty' => (int)$product->order_product_quantity
);
}
}
if(!empty($productsQuantity)) {
foreach($productsQuantity as $id => $qty) {
if(empty($updates[$qty]))
$updates[$qty] = array();
$updates[$qty][] = $id;
}
}
if(!empty($updates)) {
$this->updateQuantityAndSales($updates);
}
if(!empty($wishlistUpdates) && (int)$config->get('update_wishlist_quantity', 0)) {
$this->updateWishlistProducts($wishlistUpdates);
}
unset($wishlistUpdates);
$query = 'INSERT IGNORE INTO '.hikashop_table('order_product').' ('.implode(',', $fields).') VALUES '.implode(',', $items);
$this->database->setQuery($query);
$this->database->execute();
$query = 'SELECT * FROM '.hikashop_table('order_product').' WHERE order_id = '.$order_id;
$this->database->setQuery($query);
$newProducts = $this->database->loadObjectList('order_product_option_parent_id');
$mainProducts = array();
foreach($products as &$product) {
if(!empty($product->cart_product_option_parent_id) && (int)$product->cart_product_id > 0)
$mainProducts[$product->cart_product_option_parent_id][] = (int)$product->cart_product_id;
if(!empty($product->cart_product_id) && (int)$product->cart_product_id > 0 && isset($newProducts[$product->cart_product_id]))
$product->order_product_id = (int)$newProducts[$product->cart_product_id]->order_product_id;
}
unset($product);
$keep = array();
if(!empty($mainProducts)) {
foreach($mainProducts as $k => $v) {
$keep[] = (int)@$newProducts[$k]->order_product_id;
$query = 'UPDATE ' . hikashop_table('order_product') .
' SET order_product_option_parent_id = ' . (int)@$newProducts[$k]->order_product_id .
' WHERE order_product_option_parent_id IN (' . implode(',', $v) . ') AND order_id = ' . $order_id;
$this->database->setQuery($query);
$this->database->execute();
}
}
$query = 'UPDATE '.hikashop_table('order_product').
' SET order_product_option_parent_id = 0 '.
' WHERE order_id = ' . $order_id;
if(!empty($keep))
$query .= ' AND order_product_option_parent_id NOT IN (' . implode(',', $keep) . ')';
$this->database->setQuery($query);
$this->database->execute();
if(!empty($discounts)) {
$discountUpdates = array();
foreach($discounts as $code => $qty) {
if(empty($discountUpdates[$qty]))
$discountUpdates[$qty] = array();
$discountUpdates[$qty][] = $this->database->Quote($code);
}
foreach($discountUpdates as $k => $update) {
$query = 'UPDATE ' . hikashop_table('discount') .
' SET discount_used_times = discount_used_times + ' . (int)$k.
' WHERE discount_code IN (' . implode(',', $update) . ')';
$this->database->setQuery($query);
$this->database->execute();
}
}
$ret = array();
foreach($products as $product) {
if(empty($product->cart_product_id) || (int)$product->cart_product_id <= 0)
continue;
$ret[ (int)$product->cart_product_id ] = isset($newProducts[$product->cart_product_id]) ? (int)$newProducts[$product->cart_product_id]->order_product_id : 0;
}
if(empty($ret))
$ret = true;
return $ret;
}
protected function updateQuantityAndSales(&$updates, $cancel = false) {
$config = hikashop_config();
$authorize_restock = (int)$config->get('authorize_restock', 1);
JPluginHelper::importPlugin('hikashop');
$app = JFactory::getApplication();
$app->triggerEvent('onBeforeProductStockUpdate', array(&$updates, $cancel));
if(!empty($updates)) {
foreach($updates as $k => $update) {
$localCancel = $cancel;
if($k < 0) {
$k = -$k;
$localCancel = !$cancel;
}
if($localCancel) {
$query = 'UPDATE '.hikashop_table('product').' SET product_sales = (GREATEST('.(int)$k.', product_sales) - '.(int)$k.') WHERE product_id IN ('.implode(',',$update).')';
} else {
$query = 'UPDATE '.hikashop_table('product').' SET product_sales = product_sales + '.(int)$k.' WHERE product_id IN ('.implode(',',$update).')';
}
$this->database->setQuery($query);
$this->database->execute();
if(!$authorize_restock && (($localCancel && $k > 0) || (!$localCancel && $k < 0)))
continue;
if($localCancel) {
$query = 'UPDATE '.hikashop_table('product').' SET product_quantity = product_quantity + '.(int)$k.' WHERE product_id IN ('.implode(',',$update).') AND product_quantity > -1';
} else {
$query = 'UPDATE '.hikashop_table('product').' SET product_quantity = GREATEST(0, product_quantity - '.(int)$k.') WHERE product_id IN ('.implode(',',$update).') AND product_quantity >= 0';
}
$this->database->setQuery($query);
$this->database->execute();
}
$app->triggerEvent('onAfterProductStockUpdate', array(&$updates, $cancel));
}
}
protected function handleProductBundles(&$product_ids, &$products) {
$bundle_product_ids = array();
foreach($products as $product) {
if(!empty($product->bundle_done))
continue;
$bundle_product_ids[ (int)$product->product_id ] = (int)$product->product_id;
}
if(empty($bundle_product_ids))
return;
$query = 'SELECT pr.product_id as `bundle_id`, pr.product_related_id as `product_id`, pr.product_related_quantity, p.product_name, p.product_code, p.product_tax_id '.
' FROM #__hikashop_product_related as pr '.
' LEFT JOIN #__hikashop_product as p ON pr.product_related_id = p.product_id '.
' WHERE pr.product_id IN ('.implode(',', $bundle_product_ids).') AND pr.product_related_type=\'bundle\' ORDER BY pr.product_related_ordering ASC';
$this->database->setQuery($query);
$bundles_data = $this->database->loadObjectList();
if(empty($bundles_data))
return;
$order_id = 0;
foreach($products as $product) {
$order_id = (int)$product->order_id;
break;
}
$bundle_product_ids = array();
foreach($bundles_data as $bundle_data) {
$bundle_product_ids[ (int)$bundle_data->product_id ] = (int)$bundle_data->product_id;
}
$config = hikashop_config();
$currencyClass = hikashop_get('class.currency');
$orderclass = hikashop_get('class.order');
$order = $orderclass->get($order_id);
$currency_id = (int)$order->order_currency_id;
$tax_zone_id = hikashop_getZone();
$main_currency = (int)$config->get('main_currency', 1);
$discount_before_tax = (int)$config->get('discount_before_tax', 0);
$currencyClass->getPrices($bundles_data, $bundle_product_ids, $currency_id, $main_currency, $tax_zone_id, $discount_before_tax);
$max_cart_product_id = 0;
foreach($products as $product) {
$max_cart_product_id = max($max_cart_product_id, (int)$product->cart_product_id);
}
$max_cart_product_id += 1;
$p = array();
foreach($products as $product) {
foreach($bundles_data as $bundle_data) {
if($product->product_id != $bundle_data->bundle_id)
continue;
if(empty($bundle_data->product_related_quantity))
$bundle_data->product_related_quantity = 1;
$tax = '';
$taxInfo = '';
if(!empty($bundle_data->prices[0]->price_value_with_tax) && !empty($bundle_data->prices[0]->price_value)) {
$tax = $bundle_data->prices[0]->price_value_with_tax - $bundle_data->prices[0]->price_value;
}
if(!empty($bundle_data->taxes)) {
$taxInfo = serialize($bundle_data->taxes);
}
$b = new stdClass();
$b->product_id = $bundle_data->product_id;
$b->order_id = $product->order_id;
if(isset($product->no_update_qty))
$b->no_update_qty = $product->no_update_qty;
$b->order_product_quantity = 0;
$b->order_product_name = $bundle_data->product_name;
$b->order_product_code = $bundle_data->product_code;
$b->order_product_price = @$bundle_data->prices[0]->price_value;
$b->order_product_tax = $tax;
$b->order_product_options = array(
'type' => 'bundle',
'related_quantity' => (int)$bundle_data->product_related_quantity
);
$b->cart_product_id = $max_cart_product_id++;
$b->cart_product_option_parent_id = $product->cart_product_id;
$b->order_product_tax_info = $taxInfo;
$b->order_product_wishlist_id = 0;
$b->order_product_wishlist_product_id = 0;
$b->order_product_shipping_id = 0;
$b->order_product_shipping_method = '';
$b->order_product_shipping_price = '';
$b->order_product_shipping_tax = '';
$b->order_product_shipping_params = '';
$p[] = $b;
$product_ids[ (int)$b->product_id ] = (int)$b->product_id;
}
}
$products = array_merge($products, $p);
unset($bundles_data);
}
protected function updateWishlistProducts($wishlistUpdates) {
if(empty($wishlistUpdates))
return;
foreach($wishlistUpdates as $k => $update) {
$filters = array(
'cart_id = '.(int)abs($update['cart']),
'product_id = '.(int)$update['product'],
);
if(!empty($update['cart_product']))
$filters[] = 'cart_product_id = '.(int)abs($update['cart_product']);
$query = 'UPDATE '.hikashop_table('cart_product').
' SET cart_product_quantity = GREATEST(0, cart_product_quantity - '.(int)$update['qty'].') '.
' WHERE ('.implode(') AND (', $filters).')';
$this->db->setQuery($query);
$this->db->execute();
}
$query = ' DELETE FROM '.hikashop_table('cart_product').
' WHERE cart_id = '.(int)abs($update['cart']).' AND cart_product_quantity = 0';
$this->db->setQuery($query);
$this->db->execute();
}
public function update(&$product) {
$old = null;
if(!empty($product->order_product_id))
$old = $this->get($product->order_product_id);
$update_quantities = empty($product->no_update_qty);
unset($product->no_update_qty);
if($update_quantities && (isset($product->change) || ((empty($old) && !empty($product->product_id)) || (!empty($old->product_id) && $old->order_product_quantity != $product->order_product_quantity)))) {
$k = (int)$product->order_product_quantity;
if(!empty($old)){
$k = $product->order_product_quantity - $old->order_product_quantity;
if(isset($product->change) && $product->change == 'plus') {
$k = -(int)$product->order_product_quantity;
} elseif(isset($product->change) && $product->change == 'minus') {
$k = (int)$product->order_product_quantity;
}
}
if(!empty($product->product_id))
$product_id = (int)$product->product_id;
else
$product_id = (int)$old->product_id;
$productClass = hikashop_get('class.product');
$prod = $productClass->get($product_id);
$updates = array($k => array((int)$product_id));
if(!empty($prod) && $prod->product_type == 'variant' && !empty($prod->product_parent_id)) {
$updates[$k][] = (int)$prod->product_parent_id;
}
if(hikashop_level(1) && !empty($old->order_id) && !empty($old->order_product_id)) {
$query = 'SELECT * FROM '.hikashop_table('order_product').' WHERE order_id = '.(int)$old->order_id.' AND order_product_option_parent_id = '.(int)$old->order_product_id;
$this->database->setQuery($query);
$items = $this->database->loadObjectList('order_product_id');
if(!empty($items)) {
foreach($items as $item) {
if(!empty($item->order_product_quantity) || empty($item->order_product_options))
continue;
$options = hikashop_unserialize($item->order_product_options);
if(!empty($options['type']) && $options['type'] == 'bundle' && !empty($options['related_quantity'])) {
$q = (int)$options['related_quantity'] * $k;
if(!isset($updates[$q]))
$updates[$q] = array();
$updates[$q][] = (int)$item->product_id;
}
}
}
}
$this->updateQuantityAndSales($updates);
}
if(!empty($product->tax_namekey)) {
$tax = new stdClass();
if(!empty($product->product_id) && !empty($old)) {
if(is_string($old->order_product_tax_info))
$old->order_product_tax_info = hikashop_unserialize($old->order_product_tax_info);
if(!empty($old->order_product_tax_info) && is_array($old->order_product_tax_info)) {
$tax = reset($old->order_product_tax_info);
if(!is_object($tax))
$tax = new stdClass();
}
}
$tax->tax_namekey = $product->tax_namekey;
$tax->tax_amount = $product->order_product_tax;
$tax->amount = $product->order_product_price;
$product->order_product_tax_info = array($tax);
}
if(isset($product->order_product_tax_info) && !is_string($product->order_product_tax_info)) {
$product->order_product_tax_info = serialize($product->order_product_tax_info);
}
if(empty($product->order_product_quantity) && @$product->order_product_code != 'order additional') {
if(empty($product->order_product_id)) {
return false;
}
return $this->delete($product->order_product_id);
}
unset($product->change);
unset($product->tax_namekey);
$product->order_product_id = parent::save($product);
return $product->order_product_id;
}
}