/**
* Return cart products
*
* @result array Products
* @param bool $refresh
* @param bool $product_id
* @param null $country_id
* @return array|null
*/
public function getProducts($refresh = false, $product_id = false, $country_id = null)
{
if (!$this->cart_id) {
return array();
}
// Product cache must be strictly compared to NULL, or else an empty cart will add dozens of queries
if ($this->_products !== null && !$refresh) {
// Return product row with specified ID if it exists
if (is_int($product_id)) {
foreach ($this->_products as $product) {
if ($product->product_id == $product_id) {
return array($product);
}
}
return array();
}
return $this->_products;
}
$db = JFactory::getDBO();
$select = $leftJoin = "";
if (JeproshopCustomization::isFeaturePublished()) {
$select .= 'cu.`id_customization`, cu.`quantity` AS customization_quantity';
$leftJoin .= " LEFT JOIN " . $db->quoteName('#__jeproshop_customization') . " AS customization ";
/*
'p.`id_product` = cu.`id_product` AND cart_product.`id_product_attribute` = cu.`id_product_attribute` AND cu.`id_cart` = '.(int)$this->id); */
} else {
$select .= 'NULL AS customization_quantity, NULL AS id_customization';
}
if (JeproshopCombinationModelCombination::isFeaturePublished()) {
$select .= '
product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr,
IF (IFNULL(pa.`reference`, \'\') = \'\', p.`reference`, pa.`reference`) AS reference,
(p.`weight`+ pa.`weight`) weight_attribute,
IF (IFNULL(pa.`ean13`, \'\') = \'\', p.`ean13`, pa.`ean13`) AS ean13,
IF (IFNULL(pa.`upc`, \'\') = \'\', p.`upc`, pa.`upc`) AS upc,
pai.`id_image` as pai_id_image, il.`legend` as pai_legend,
IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity
';
/*$sql->leftJoin('product_attribute', 'pa', 'pa.`id_product_attribute` = cart_product.`id_product_attribute`');
$sql->leftJoin('product_attribute_shop', 'product_attribute_shop', '(product_attribute_shop.`id_shop` = cart_product.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`)');
$sql->leftJoin('product_attribute_image', 'pai', 'pai.`id_product_attribute` = pa.`id_product_attribute`');
$sql->leftJoin('image_lang', 'il', 'il.`id_image` = pai.`id_image` AND il.`id_lang` = '.(int)$this->id_lang); */
} else {
$select .= 'p.`reference` AS reference, p.`ean13`,
p.`upc` AS upc, product_shop.`minimal_quantity` AS minimal_quantity';
}
$query = "SELECT cart_product." . $db->quoteName('product_attribute_id') . ", cart_product." . $db->quoteName('product_id') . ", cart_product.";
$query .= $db->quoteName('quantity') . " AS cart_quantity, cart_product." . $db->quoteName('shop_id') . ", product_lang." . $db->quoteName('name');
$query .= ", product." . $db->quoteName('is_virtual') . ", product_lang." . $db->quoteName('short_description') . ", product_lang." . $db->quoteName('available_now');
$query .= ", product_lang." . $db->quoteName('available_later') . ", product_shop." . $db->quoteName('default_category_id') . ", product.";
$query .= $db->quoteName('supplier_id') . ", product." . $db->quoteName('manufacturer_id') . ", product_shop." . $db->quoteName('on_sale') . ", product_shop.";
$query .= $db->quoteName('ecotax') . ", product_shop." . $db->quoteName('additional_shipping_cost') . ", product_shop." . $db->quoteName('available_for_order');
$query .= ", product_shop." . $db->quoteName('price') . ", product_shop." . $db->quoteName('published') . ", product_shop." . $db->quoteName('unity');
$query .= ", product_shop." . $db->quoteName('unit_price_ratio') . ", stock." . $db->quoteName('quantity') . " AS quantity_available, product." . $db->quoteName('width');
$query .= ", product." . $db->quoteName('height') . ", product." . $db->quoteName('depth') . ", stock." . $db->quoteName('out_of_stock') . ", product.";
$query .= $db->quoteName('weight') . ", product." . $db->quoteName('date_add') . ", product." . $db->quoteName('date_upd') . ", IFNULL(stock.quantity, 0) as quantity, ";
$query .= "product_lang." . $db->quoteName('link_rewrite') . ", category_lang." . $db->quoteName('link_rewrite') . " AS category, CONCAT(LPAD(cart_product.";
$query .= $db->quoteName('product_id') . ", 10, 0), LPAD(IFNULL(cart_product." . $db->quoteName('product_attribute_id') . ", 0), 10, 0), IFNULL(cart_product.";
$query .= $db->quoteName('address_delivery_id') . ", 0)) AS unique_id, cart_product.address_delivery_id, product_shop." . $db->quoteName('wholesale_price');
$query .= ", product_shop.advanced_stock_management, product_supplier.product_supplier_reference supplier_reference, IFNULL(specific_price." . $db->quoteName('reduction_type');
$query .= ", 0) AS reduction_type FROM " . $db->quoteName('#__jeproshop_cart_product') . " AS cart_product LEFT JOIN " . $db->quoteName('#__jeproshop_product') . " AS product ";
$query .= " ON (product." . $db->quoteName('product_id') . " = cart_product." . $db->quoteName('product_id') . ") INNER JOIN " . $db->quoteName('#__jeproshop_product_shop');
$query .= " AS product_shop ON (product_shop." . $db->quoteName('shop_id') . " = cart_product." . $db->quoteName('shop_id') . " AND product_shop." . $db->quoteName('product_id');
$query .= " = product." . $db->quoteName('product_id') . ") LEFT JOIN " . $db->quoteName('#__jeproshop_product_lang') . " AS product_lang ON (product." . $db->quoteName('product_id');
$query .= " = product_lang." . $db->quoteName('product_id') . "\tAND product_lang." . $db->quoteName('lang_id') . " = " . (int) $this->lang_id;
$query .= JeproshopShopModelShop::addSqlRestrictionOnLang('product_lang', 'cart_product.shop_id') . ") LEFT JOIN " . $db->quoteName('#__jeproshop_category_lang');
$query .= " AS category_lang ON(product_shop." . $db->quoteName('default_category_id') . " = category_lang." . $db->quoteName('category_id') . " AND category_lang." . $db->quoteName('lang_id');
$query .= " = " . (int) $this->lang_id . JeproshopShopModelShop::addSqlRestrictionOnLang('category_lang', 'cart_product.shop_id') . ") LEFT JOIN " . $db->quoteName('#__jeproshop_product_supplier');
$query .= " AS product_supplier ON (product_supplier." . $db->quoteName('product_id') . " = cart_product." . $db->quoteName('product_id') . " AND product_supplier.";
$query .= $db->quoteName('product_attribute_id') . " = cart_product." . $db->quoteName('product_attribute_id') . " AND product_supplier." . $db->quoteName('supplier_id');
$query .= " = product." . $db->quoteName('supplier_id') . ") LEFT JOIN " . $db->quoteName('#__jeproshop_specific_price') . " AS specific_price ON (specific_price.";
$query .= $db->quoteName('product_id') . " = cart_product." . $db->quoteName('product_id') . ") " . JeproshopProductModelProduct::sqlStock('cart_product');
// AND 'sp.`id_shop` = cart_product.`id_shop`
// @todo test if everything is ok, then refactorise call of this method
//$sql->join(Product::sqlStock('cart_product', 'cart_product'));
$query .= " WHERE cart_product." . $db->quoteName('cart_id') . " = " . (int) $this->cart_id;
if ($product_id) {
$query .= " AND cart_product." . $db->quoteName('product_id') . " = " . (int) $product_id;
}
$query .= " AND product." . $db->quoteName('product_id') . " IS NOT NULL GROUP BY unique_id ORDER BY cart_product." . $db->quoteName('date_add');
$query .= ", product." . $db->quoteName('product_id') . ", cart_product." . $db->quoteName('product_attribute_id') . " ASC";
$db->setQuery($query);
$result = $db->loadObjectList();
// Reset the cache before the following return, or else an empty cart will add dozens of queries
$products_ids = array();
$product_attribute_ids = array();
if ($result) {
foreach ($result as $row) {
$products_ids[] = $row->product_id;
$product_attribute_ids[] = $row->product_attribute_id;
}
}
// Thus you can avoid one query per product, because there will be only one query for all the products of the cart
JeproshopProductModelProduct::cacheProductsFeatures($products_ids);
JeproshopCartModelCart::cacheSomeAttributesLists($product_attribute_ids, $this->lang_id);
$this->_products = array();
if (empty($result)) {
return array();
}
$cart_shop_context = JeproshopContext::getContext()->cloneContext();
foreach ($result as &$row) {
if (isset($row->ecotax_attr) && $row->ecotax_attr > 0) {
$row->ecotax = (double) $row->ecotax_attr;
}
$row->stock_quantity = (int) $row->quantity;
// for compatibility with 1.2 themes
$row->quantity = (int) $row->cart_quantity;
if (isset($row->product_attribute_id) && (int) $row->product_attribute_id && isset($row->weight_attribute)) {
$row->weight = (double) $row->weight_attribute;
}
if (JeproshopSettingModelSetting::getValue('tax_address_type') == 'address_invoice_id') {
$address_id = (int) $this->address_invoice_id;
} else {
$address_id = (int) $row->address_delivery_id;
}
if (!JeproshopAddressModelAddress::addressExists($address_id)) {
$address_id = null;
}
if ($cart_shop_context->shop->shop_id != $row->shop_id) {
$cart_shop_context->shop = new JeproshopShopModelShop((int) $row->shop_id);
}
$specific_price_output = null;
$null = null;
if ($this->_taxCalculationMethod == COM_JEPROSHOP_TAX_EXCLUDED) {
$row->price = JeproshopProductModelProduct::getStaticPrice((int) $row->product_id, false, isset($row->product_attribute_id) ? (int) $row->product_attribute_id : null, 2, null, false, true, (int) $row->cart_quantity, false, (int) $this->customer_id ? (int) $this->customer_id : null, (int) $this->cart_id, (int) $address_id ? (int) $address_id : null, $specific_price_output, true, true, $cart_shop_context);
// Here taxes are computed only once the quantity has been applied to the product price
$row->price_wt = JeproshopProductModelProduct::getStaticPrice((int) $row->product_id, true, isset($row->product_attribute_id) ? (int) $row->product_attribute_id : null, 2, null, false, true, (int) $row->cart_quantity, false, (int) $this->customer_id ? (int) $this->customer_id : null, (int) $this->cart_id, (int) $address_id ? (int) $address_id : null, $null, true, true, $cart_shop_context);
$tax_rate = JeproshopTaxModelTax::getProductTaxRate((int) $row->product_id, (int) $address_id);
$row->total_wt = JeproshopTools::roundPrice($row->price * (double) $row->cart_quantity * (1 + (double) $tax_rate / 100), 2);
$row->total = $row->price * (int) $row->cart_quantity;
} else {
$row->price = JeproshopProductModelProduct::getStaticPrice((int) $row->product_id, false, (int) $row->product_attribute_id, 2, null, false, true, $row->cart_quantity, false, (int) $this->customer_id ? (int) $this->customer_id : null, (int) $this->cart_id, (int) $address_id ? (int) $address_id : null, $specific_price_output, true, true, $cart_shop_context);
$row->price_wt = JeproshopProductModelProduct::getStaticPrice((int) $row->product_id, true, (int) $row->product_attribute_id, 2, null, false, true, $row->cart_quantity, false, (int) $this->customer_id ? (int) $this->customer_id : null, (int) $this->cart_id, (int) $address_id ? (int) $address_id : null, $null, true, true, $cart_shop_context);
// In case when you use QuantityDiscount, getPriceStatic() can be return more of 2 decimals
$row->price_wt = JeproshopTools::roundPrice($row->price_wt, 2);
$row->total_wt = $row->price_wt * (int) $row->cart_quantity;
$row->total = JeproshopTools::roundPrice($row->price * (int) $row->cart_quantity, 2);
$row->description_short = JeproshopTools::nl2br($row->short_description);
}
if (!isset($row->product_attribute_id_image_id) || $row->product_attribute_id_image_id == 0) {
$cache_id = 'jeproshop_cart_get_products_product_attribute_id_image_id_' . (int) $row->product_id . '_' . (int) $this->lang_id . '_' . (int) $row->shop_id;
if (!JeproshopCache::isStored($cache_id)) {
$db = JFactory::getDBO();
$query = "SELECT image_shop." . $db->quoteName('image_id') . " AS image_id, image_lang." . $db->quoteName('legend') . " FROM ";
$query .= $db->quoteName('#__jeproshop_image') . " AS image JOIN " . $db->quoteName('#__jeproshop_image_shop') . " AS image_shop ON (";
$query .= " image.image_id = image_shop.image_id AND image_shop.cover=1 AND image_shop.shop_id = " . (int) $row->shop_id . ") LEFT JOIN ";
$query .= $db->quoteName('#__jeproshop_image_lang') . " AS image_lang ON (image_shop." . $db->quoteName('image_id') . " = image_lang.";
$query .= $db->quoteName('image_id') . " AND image_lang." . $db->quoteName('lang_id') . " = " . (int) $this->lang_id . ") WHERE image.";
$query .= $db->quoteName('product_id') . " = " . (int) $row->product_id . " AND image_shop." . $db->quoteName('cover') . " = 1";
$db->setQuery($query);
$row2 = $db->loadObject();
JeproshopCache::store($cache_id, $row2);
}
$row2 = JeproshopCache::retrieve($cache_id);
if (!$row2) {
$row2 = new JObject();
$row2->image_id = false;
$row2->legend = false;
} else {
$row = array_merge($row, $row2);
}
} else {
$row->image_id = $row->product_attribute_id_image_id;
$row->legend = $row->product_attribute_legend;
}
$row->reduction_applies = $specific_price_output && (double) $specific_price_output->reduction;
$row->quantity_discount_applies = $specific_price_output && $row->cart_quantity >= (int) $specific_price_output->from_quantity;
$row->image_id = JeproshopProductModelProduct::defineProductImage($row, $this->lang_id);
$row->allow_out_of_sp = JeproshopProductModelProduct::isAvailableWhenOutOfStock($row->out_of_stock);
$row->features = JeproshopProductModelProduct::getStaticFeatures((int) $row->product_id);
if (array_key_exists($row->product_attribute_id . '_' . $this->lang_id, self::$_attributesLists)) {
$row = array_merge($row, self::$_attributesLists[$row->product_attribute_id . '_' . $this->lang_id]);
}
$row = JeproshopProductModelProduct::getTaxesInformations($row, $cart_shop_context);
$this->_products[] = $row;
}
return $this->_products;
}
public function product()
{
// Update the cart ONLY if $this->cookies are available, in order to avoid ghost carts created by bots
if (!$this->context) {
$this->context = JeproshopContext::getContext();
}
if ($this->context->cookie->exists() && !$this->has_errors && !($this->context->customer->isLogged() && !$this->isTokenValid())) {
// Send noindex to avoid ghost carts by bots
header("X-Robots-Tag: noindex, nofollow", true);
if (!$this->isInitialized()) {
$this->initialize();
}
$app = JFactory::getApplication();
$product_id = $app->input->get('product_id', null);
$customization_id = (int) $app->input->get('customization_id', null);
$address_delivery_id = (int) $app->input->get('address_delivery_id', null);
$product_attribute_id = $app->input->get('product_attribute_id', null);
$mode = $app->input->get('task') == 'update' && $product_id ? 'update' : 'add';
if ($app->input->get('quantity') == 0) {
$this->has_errors = true;
echo JText::_('COM_JEPROSHOP_NULL_QUANTITY_MESSAGE') . ' ' . !$app->input->get('use_ajax');
} elseif (!$product_id) {
$this->has_errors = true;
echo JText::_('COM_JEPROSHOP_PRODUCT_ID_NOT_FOUND_MESSAGE') . ' ' . !$app->input->get('use_ajax');
}
$product = new JeproshopProductModelProduct($product_id, true, $this->context->language->lang_id);
if (!$product->product_id || !$product->published) {
$this->has_errors = true;
echo JText::_('COM_JEPROSHOP_THIS_PRODUCT_IS_NO_LONGER_AVAILABLE_MESSAGE.') . ' ' . !$app->input->get('use_ajax');
exit;
}
$quantity = abs($app->input->get('quantity', 1));
$qty_to_check = $quantity;
$cart_products = $this->context->cart->getProducts();
if (is_array($cart_products)) {
foreach ($cart_products as $cart_product) {
if ((!isset($this->product_attribute_id) || $cart_product->product_attribute_id == $product_attribute_id) && (isset($product_id) && $cart_product->product_id == $product_id)) {
$qty_to_check = $cart_product->cart_quantity;
if ($app->input->get('op', 'up') == 'down') {
$qty_to_check -= $quantity;
} else {
$qty_to_check += $quantity;
}
break;
}
}
}
// Check product quantity availability
if ($product_attribute_id) {
if (!JeproshopProductModelProduct::isAvailableWhenOutOfStock($product->out_of_stock) && !JeproshopAttributeModelAttribute::checkAttributeQty($product_attribute_id, $qty_to_check)) {
$this->has_errors = true;
echo JText::_('COM_JEPROSHOP_THERE_IS_NOT_ENOUGH_PRODUCT_IN_STOCK_MESSAGE') . ' ' . __LINE__ . !$app->input->get('use_ajax');
}
} elseif ($product->hasAttributes()) {
$minimumQuantity = $product->out_of_stock == 2 ? !JeproshopSettingModelSetting::getValue('order_out_of_stock') : !$product->out_of_stock;
$product_attribute_id = JeproshopProductModelProduct::getDefaultAttribute($product->product_id, $minimumQuantity);
// @todo do something better than a redirect admin !!
if (!$product_attribute_id) {
$app->redirect($this->getProductLink($product));
} elseif (!JeproshopProductModelProduct::isAvailableWhenOutOfStock($product->out_of_stock) && !JeproshopAttributeModelAttribute::checkAttributeQty($product_attribute_id, $qty_to_check)) {
$this->has_errors = true;
echo JText::_('COM_JEPROSHOP_THERE_IS_NOT_ENOUGH_PRODUCT_IN_STOCK_MESSAGE') . ' ' . __LINE__ . !$app->input->get('use_ajax');
}
} elseif (!$product->checkQuantity($qty_to_check)) {
$this->has_errors = true;
echo JText::_('COM_JEPROSHOP_THERE_IS_NOT_ENOUGH_PRODUCT_IN_STOCK_MESSAGE') . ' ' . __LINE__ . !$app->input->get('use_ajax');
}
// If no errors, process product addition
if ($mode == 'add') {
// Add cart if no cart found
if (!$this->context->cart->cart_id) {
if (JeproshopContext::getContext()->cookie->guest_id) {
$guest = new JeproshopGuestModelGuest(JeproshopContext::getContext()->cookie->guest_id);
$this->context->cart->mobile_theme = $guest->mobile_theme;
}
$this->context->cart->add();
if ($this->context->cart->cart_id) {
$this->context->cookie->cart_id = (int) $this->context->cart->cart_id;
}
}
// Check customizable fields
if (!$product->hasAllRequiredCustomizableFields() && !$customization_id) {
// $this->errors[] = Tools::displayError('Please fill in all of the required fields, and then save your customizations.', !Tools::getValue('ajax'));
}
if (!$this->has_errors) {
$cart_rules = $this->context->cart->getCartRules();
$update_quantity = $this->context->cart->updateQuantity($quantity, $product_id, $product_attribute_id, $customization_id, $app->input->get('op', 'up'), $address_delivery_id);
if ($update_quantity < 0) {
// If product has attribute, minimal quantity is set with minimal quantity of attribute
$minimal_quantity = $product_attribute_id ? JeproshopAttributeModelAttribute::getAttributeMinimalQty($product_attribute_id) : $product->minimal_quantity;
$this->has_errors = true;
sprintf(Tools::displayError('You must add %d minimum quantity', !$app->input->get('use_ajax')), $minimal_quantity);
} elseif (!$update_quantity) {
$this->has_errors = true;
echo JText::_('COM_JEPROSHOP_YOU_ALREADY_HAVE_THE_MAXIMUM_AVAILABLE_FOR_THIS_PRODUCT_MESSAGE') . ' ' . !$app->input->get('use_ajax');
} elseif ((int) $app->input->get('allow_refresh')) {
// If the cart rules has changed, we need to refresh the whole cart
$cart_rules2 = $this->context->cart->getCartRules();
if (count($cart_rules2) != count($cart_rules)) {
$this->ajax_refresh = true;
} else {
$rule_list = array();
foreach ($cart_rules2 as $rule) {
$rule_list[] = $rule->cart_rule_id;
}
foreach ($cart_rules as $rule) {
if (!in_array($rule->cart_rule_id, $rule_list)) {
$this->ajax_refresh = true;
break;
}
}
}
}
}
}
$removed = JeproshopCartRuleModelCartRule::autoRemoveFromCart();
JeproshopCartRuleModelCartRule::autoAddToCart();
if (count($removed) && (int) $app->input->get('allow_refresh')) {
$this->ajax_refresh = true;
}
echo 'bonjour';
exit;
} elseif (!$this->context->cookie->exists()) {
echo 'bonjour cookkie';
exit;
} elseif ($this->has_errors) {
} elseif ($this->context->customer->isLogged() && !$this->isTokenValid()) {
}
}
/**
* Assign template vars related to attribute groups and colors
*/
protected function assignAttributesGroups()
{
$colors = array();
$groups = array();
if ($this->context == null) {
$this->context = JeproshopContext::getContext();
}
// @todo (RM) should only get groups and not all declination ?
$attributes_groups = $this->product->getAttributesGroups($this->context->language->lang_id);
if (is_array($attributes_groups) && $attributes_groups) {
$combination_images = $this->product->getCombinationImages($this->context->language->lang_id);
$combination_prices_set = array();
$combinations = array();
foreach ($attributes_groups as $k => $row) {
// Color management
if (isset($row->is_color_group) && $row->is_color_group && (isset($row->attribute_color) && $row->attribute_color) || file_exists(JURI::base() . COM_JEPROSHOP_COLOR_IMAGE_DIRECTORY . $row->attribute_id . '.jpg')) {
$colors[$row->attribute_id]['value'] = $row->attribute_color;
$colors[$row->attribute_id]['name'] = $row->attribute_name;
if (!isset($colors[$row->attribute_id]['attributes_quantity'])) {
$colors[$row->attribute_id]['attributes_quantity'] = 0;
}
$colors[$row->attribute_id]['attributes_quantity'] += (int) $row->quantity;
}
if (!isset($groups[$row->attribute_group_id])) {
$attribute_row = new JObject();
$attribute_row->set('group_name', $row->group_name);
$attribute_row->set('name', $row->public_group_name);
$attribute_row->set('group_type', $row->group_type);
$attribute_row->set('default', -1);
$groups[$row->attribute_group_id] = $attribute_row;
}
$groups[$row->attribute_group_id]->attributes[$row->attribute_id] = $row->attribute_name;
if ($row->default_on && $groups[$row->attribute_group_id]->default == -1) {
$groups[$row->attribute_group_id]->default = (int) $row->attribute_id;
}
if (!isset($groups[$row->attribute_group_id]->attributes_quantity[$row->attribute_id])) {
$groups[$row->attribute_group_id]->attributes_quantity[$row->attribute_id] = 0;
}
$groups[$row->attribute_group_id]->attributes_quantity[$row->attribute_id] += (int) $row->quantity;
$data = new JObject();
$combinations[$row->product_attribute_id]->attributes_values[$row->attribute_group_id] = $row->attribute_name;
$combinations[$row->product_attribute_id]->attributes[] = (int) $row->attribute_id;
$combinations[$row->product_attribute_id]->price = (double) $row->price;
// Call getPriceStatic in order to set $combination_specific_price
if (!isset($combination_prices_set[(int) $row->product_attribute_id])) {
$combination_specific_price = null;
JeproshopProductModelProduct::getStaticPrice((int) $this->product->product_id, false, $row->product_attribute_id, 6, null, false, true, 1, false, null, null, null, $combination_specific_price);
$combination_prices_set[(int) $row->product_attribute_id] = true;
$combinations[$row->product_attribute_id]->specific_price = $combination_specific_price;
}
$combinations[$row->product_attribute_id]->ecotax = (double) $row->ecotax;
$combinations[$row->product_attribute_id]->weight = (double) $row->weight;
$combinations[$row->product_attribute_id]->quantity = (int) $row->quantity;
$combinations[$row->product_attribute_id]->reference = $row->reference;
$combinations[$row->product_attribute_id]->unit_impact = $row->unit_price_impact;
$combinations[$row->product_attribute_id]->minimal_quantity = $row->minimal_quantity;
if ($row->available_date != '0000-00-00') {
$combinations[$row->product_attribute_id]->available_date = $row->available_date;
$combinations[$row->product_attribute_id]->date_formatted = JeproshopTools::displayDate($row->available_date);
} else {
$combinations[$row->product_attribute_id]->available_date = '';
}
if (!isset($combination_images[$row->product_attribute_id][0]->image_id)) {
$combinations[$row->product_attribute_id]->image_id = -1;
} else {
$combinations[$row->product_attribute_id]->image_id = $image_id = (int) $combination_images[$row->product_attribute_id][0]->image_id;
if ($row->default_on) {
if (isset($this->cover->value)) {
$current_cover = $this->cover->value;
}
if (is_array($combination_images[$row->product_attribute_id])) {
foreach ($combination_images[$row->product_attribute_id] as $tmp) {
if ($tmp->image_id == $current_cover->image_id) {
$combinations[$row->product_attribute_id]->image_id = $image_id = (int) $tmp->image_id;
break;
}
}
}
if ($image_id > 0) {
if (isset($this->images->value)) {
$product_images = $this->images->value;
}
if (isset($product_images) && is_array($product_images) && isset($product_images[$image_id])) {
$product_images[$image_id]->cover = 1;
$this->assignRef('mainImage', $product_images[$image_id]);
if (count($product_images)) {
$this->assignRef('images', $product_images);
}
}
if (isset($this->cover->value)) {
$cover = $this->cover->value;
}
if (isset($cover) && is_array($cover) && isset($product_images) && is_array($product_images)) {
$product_images[$cover->image_id]->cover = 0;
if (isset($product_images[$image_id])) {
$cover = $product_images[$image_id];
}
$cover->image_id = JeproshopSettingModelSetting::getValue('legacy_images') ? $this->product->product_id . '_' . $image_id : (int) $image_id;
$cover->image_only_id = (int) $image_id;
$this->assignRef('cover', $cover);
}
}
}
}
}
// wash attributes list (if some attributes are unavailable and if allowed to wash it)
if (!JeproshopProductModelProduct::isAvailableWhenOutOfStock($this->product->out_of_stock) && JeproshopSettingModelSetting::getValue('display_unavailable_attributes') == 0) {
foreach ($groups as &$group) {
foreach ($group->attributes_quantity as $key => &$quantity) {
if ($quantity <= 0) {
unset($group->attributes[$key]);
}
}
}
foreach ($colors as $key => $color) {
if ($color->attributes_quantity <= 0) {
unset($colors[$key]);
}
}
}
foreach ($combinations as $product_attribute_id => $comb) {
$attribute_list = '';
foreach ($comb->attributes as $attribute_id) {
$attribute_list .= '\'' . (int) $attribute_id . '\',';
}
$attribute_list = rtrim($attribute_list, ',');
$combinations[$product_attribute_id]->list = $attribute_list;
}
$this->assignRef('groups', $groups);
$isColors = count($colors) ? $colors : false;
$this->assignRef('colors', $isColors);
$this->assignRef('combinations', $combinations);
$this->assignRef('combinationImages', $combination_images);
}
}
public static function getProductProperties($lang_id, $row, JeproshopContext $context = null)
{
if (!$row->product_id) {
return false;
}
if ($context == null) {
$context = JeproshopContext::getContext();
}
// Product::getDefaultAttribute is only called if id_product_attribute is missing from the SQL query at the origin of it:
// consider adding it in order to avoid unnecessary queries
$row->allow_out_of_stock_ordering = JeproshopProductModelProduct::isAvailableWhenOutOfStock($row->out_of_stock);
if (JeproshopCombinationModelCombination::isFeaturePublished() && (!isset($row->product_attribute_id) || !$row->product_attribute_id) && (isset($row->cache_default_attribute) && ($default_product_attribute_id = $row->cache_default_attribute) !== null || ($default_product_attribute_id = JeproshopProductModelProduct::getDefaultAttribute($row->product_id, !$row->allow_out_of_stock_ordering)))) {
$row->product_attribute_id = $default_product_attribute_id;
}
if (!JeproshopCombinationModelCombination::isFeaturePublished() || !isset($row->product_attribute_id)) {
$row->product_attribute_id = 0;
}
// Tax
$useTax = JeproshopTaxModelTax::taxExcludedOption();
$cache_key = $row->product_id . '_' . $row->product_attribute_id . '_' . $lang_id . '_' . (int) $useTax;
if (isset($row->product_pack_id)) {
$cache_key .= '_pack_' . $row->product_pack_id;
}
if (isset(self::$_productPropertiesCache[$cache_key])) {
return JeproshopTools::updateObjectData($row, self::$_productPropertiesCache[$cache_key]);
}
// Datas
$row->category = JeproshopCategoryModelCategory::getLinkRewrite((int) $row->default_category_id, (int) $lang_id);
$row->link = $context->controller->getProductLink((int) $row->product_id, $row->link_rewrite, $row->category, $row->ean13);
$row->attribute_price = 0;
if (isset($row->product_attribute_id) && $row->product_attribute_id) {
$row->attribute_price = (double) JeproshopProductModelProduct::getProductAttributePrice($row->product_attribute_id);
}
$row->price_tax_exc = JeproshopProductModelProduct::getStaticPrice((int) $row->product_id, false, isset($row->product_attribute_id) && !empty($row->product_attribute_id) ? (int) $row->product_attribute_id : null, self::$_taxCalculationMethod == COM_JEPROSHOP_TAX_EXCLUDED ? 2 : 6);
if (self::$_taxCalculationMethod == COM_JEPROSHOP_TAX_EXCLUDED) {
$row->price_tax_exc = JeproshopTools::roundPrice($row->price_tax_exc, 2);
$row->price = JeproshopProductModelProduct::getStaticPrice((int) $row->product_id, true, isset($row->product_attribute_id) && !empty($row->product_attribute_id) ? (int) $row->product_attribute_id : null, 6);
$row->price_without_reduction = JeproshopProductModelProduct::getStaticPrice((int) $row->product_id, false, isset($row->product_attribute_id) && !empty($row->product_attribute_id) ? (int) $row->product_attribute_id : null, 2, null, false, false);
} else {
$row->price = JeproshopTools::roundPrice(JeproshopProductModelProduct::getStaticPrice((int) $row->product_id, true, isset($row->product_attribute_id) && !empty($row->product_attribute_id) ? (int) $row->product_attribute_id : null, 2), 2);
$row->price_without_reduction = JeproshopProductModelProduct::getStaticPrice((int) $row->product_id, true, isset($row->product_attribute_id) && !empty($row->product_attribute_id) ? (int) $row->product_attribute_id : null, 6, null, false, false);
}
$specific_prices = null;
$row->reduction = JeproshopProductModelProduct::getStaticPrice((int) $row->product_id, (bool) $useTax, (int) $row->product_attribute_id, 6, null, true, true, 1, true, null, null, null, $specific_prices);
$row->specific_prices = $specific_prices;
$row->quantity = JeproshopProductModelProduct::getQuantity((int) $row->product_id, 0, isset($row->cache_is_pack) ? $row->cache_is_pack : null);
$row->quantity_all_versions = $row->quantity;
if ($row->product_attribute_id) {
$row->quantity = JeproshopProductModelProduct::getQuantity((int) $row->product_id, $row->product_attribute_id, isset($row->cache_is_pack) ? $row->cache_is_pack : null);
}
$row->image_id = JeproshopProductModelProduct::defineProductImage($row, $lang_id);
$row->features = JeproshopProductModelProduct::getFrontStaticFeatures((int) $lang_id, $row->product_id);
$row->attachments = array();
if (!isset($row->cache_has_attachments) || $row->cache_has_attachments) {
$row->attachments = JeproshopProductModelProduct::getStaticAttachments((int) $lang_id, $row->product_id);
}
$row->virtual = !isset($row->is_virtual) || $row->is_virtual ? 1 : 0;
// Pack management
$row->pack = !isset($row->cache_is_pack) ? JeproshopProductPack::isPack($row->product_id) : (int) $row->cache_is_pack;
$row->packItems = $row->pack ? JeproshopProductPack::getItemTable($row->product_id, $lang_id) : array();
$row->no_pack_price = $row->pack ? JeproshopProductPack::noPackPrice($row->product_id) : 0;
if ($row->pack && !JeproshopProductPack::isInStock($row->product_id)) {
$row->quantity = 0;
}
$row->customization_required = false;
if (isset($row->customizable) && $row->customizable && JeproshopCustomization::isFeaturePublished()) {
if (count(JeproshopProductModelProduct::getStaticRequiredCustomizableFields((int) $row->product_id))) {
$row->customization_required = true;
}
}
$row = JeproshopProductModelProduct::getTaxesInformations($row, $context);
self::$_productPropertiesCache[$cache_key] = $row;
return self::$_productPropertiesCache[$cache_key];
}
/**
* Update product quantity
*
* @param integer $quantity Quantity to add (or substract)
* @param $product_id
* @param null $product_attribute_id
* @param bool $customization_id
* @param string $operator Indicate if quantity must be increased or decreased
* @param int $address_delivery_id
* @param JeproshopShopModelShop $shop
* @param bool $auto_add_cart_rule
* @return bool|int
* @internal param int $id_product Product ID
* @internal param int $id_product_attribute Attribute ID if needed
*/
public function updateQuantity($quantity, $product_id, $product_attribute_id = null, $customization_id = false, $operator = 'up', $address_delivery_id = 0, JeproshopShopModelShop $shop = null, $auto_add_cart_rule = true)
{
if (!$shop) {
$shop = JeproshopContext::getContext()->shop;
}
$db = JFactory::getDBO();
if (JeproshopContext::getContext()->customer->customer_id) {
if ($address_delivery_id == 0 && (int) $this->address_delivery_id) {
// The $id_address_delivery is null, use the cart delivery address
$address_delivery_id = $this->address_delivery_id;
} elseif ($address_delivery_id == 0) {
// The $id_address_delivery is null, get the default customer address
$address_delivery_id = (int) JeproshopAddressModelAddress::getCustomerFirstAddressId((int) JeproshopContext::getContext()->customer->customer_id);
} elseif (!JeproshopCustomerModelCustomer::customerHasAddress(JeproshopContext::getContext()->customer->customer_id, $address_delivery_id)) {
// The $id_address_delivery must be linked with customer
$address_delivery_id = 0;
}
}
$quantity = (int) $quantity;
$product_id = (int) $product_id;
$product_attribute_id = (int) $product_attribute_id;
$product = new JeproshopProductModelProduct($product_id, false, JeproshopSettingModelSetting::getValue('default_lang'), $shop->shop_id);
if ($product_attribute_id) {
$combination = new JeproshopCombinationModelCombination((int) $product_attribute_id);
if ($combination->product_id != $product_id) {
return false;
}
}
/* If we have a product combination, the minimal quantity is set with the one of this combination */
if (!empty($product_attribute_id)) {
$minimal_quantity = (int) JeproshopAttributeModelAttribute::getAttributeMinimalQty($product_attribute_id);
} else {
$minimal_quantity = (int) $product->minimal_quantity;
}
if (!JeproshopValidator::isLoadedObject($product, 'product_id')) {
die(Tools::displayError());
}
if (isset(self::$_nbProducts[$this->cart_id])) {
unset(self::$_nbProducts[$this->cart_id]);
}
if (isset(self::$_totalWeight[$this->cart_id])) {
unset(self::$_totalWeight[$this->cart_id]);
}
if ((int) $quantity <= 0) {
return $this->deleteProduct($product_id, $product_attribute_id, (int) $customization_id);
} elseif (!$product->available_for_order || JeproshopSettingModelSeting::getValue('catalog_mode')) {
return false;
} else {
/* Check if the product is already in the cart */
$result = $this->containsProduct($product_id, $product_attribute_id, (int) $customization_id, (int) $address_delivery_id);
/* Update quantity if product already exist */
if ($result) {
if ($operator == 'up') {
$query = "SELECT stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity FROM " . $db->quoteName('#__jeproshop_product') . " AS product" . JeproshopProductModelProduct::sqlStock('p', $product_attribute_id, true, $shop);
$query .= " WHERE product.product_id = " . $product_id;
$db->setQuery($query);
$result2 = $db->loadObject();
$product_qty = (int) $result2->quantity;
// Quantity for product pack
if (JeproshopProductPack::isPack($product_id)) {
$product_qty = JeproshopProductPack::getQuantity($product_id, $product_attribute_id);
}
$new_qty = (int) $result->quantity + (int) $quantity;
$qty = '+ ' . (int) $quantity;
if (!JeproshopProductModelProduct::isAvailableWhenOutOfStock((int) $result2->out_of_stock)) {
if ($new_qty > $product_qty) {
return false;
}
}
} else {
if ($operator == 'down') {
$qty = '- ' . (int) $quantity;
$new_qty = (int) $result->quantity - (int) $quantity;
if ($new_qty < $minimal_quantity && $minimal_quantity > 1) {
return -1;
}
} else {
return false;
}
}
/* Delete product from cart */
if ($new_qty <= 0) {
return $this->deleteProduct((int) $product_id, (int) $product_attribute_id, (int) $customization_id);
} else {
if ($new_qty < $minimal_quantity) {
return -1;
} else {
$query = "UPDATE " . $db->quoteName('#__jeproshop_cart_product') . " SET " . $db->quoteName('quantity') . " = " . $db->quoteName('quantity') . $qty . ", ";
$query .= $db->quoteName('date_add') . " = NOW() WHERE " . $db->quoteName('product_id') . " = " . (int) $product_id;
$query .= (!empty($product_attribute_id) ? " AND " . $db->quoteName('product_attribute_id') . " = " . (int) $product_attribute_id : "") . " AND " . $db->quoteName('cart_id') . " = " . (int) $this->cart_id;
$query .= (JeproshopSettingModelSeting::getValue('allow_multi_shipping') && $this->isMultiAddressDelivery() ? " AND " . $db->quoteName('address_delivery_id') . " = " . (int) $address_delivery_id : "") . " LIMIT 1";
$db->setQuery($query);
$db->query();
}
}
} elseif ($operator == 'up') {
$sql = 'SELECT stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity
FROM ' . _DB_PREFIX_ . 'product p
' . Product::sqlStock('p', $product_attribute_id, true, $shop) . '
WHERE p.id_product = ' . $product_id;
$result2 = Db::getInstance()->getRow($sql);
// Quantity for product pack
if (Pack::isPack($product_id)) {
$result2['quantity'] = Pack::getQuantity($product_id, $product_attribute_id);
}
if (!Product::isAvailableWhenOutOfStock((int) $result2['out_of_stock'])) {
if ((int) $quantity > $result2['quantity']) {
return false;
}
}
if ((int) $quantity < $minimal_quantity) {
return -1;
}
$result_add = Db::getInstance()->insert('cart_product', array('id_product' => (int) $product_id, 'id_product_attribute' => (int) $product_attribute_id, 'id_cart' => (int) $this->cart_id, 'id_address_delivery' => (int) $address_delivery_id, 'id_shop' => $shop->shop_id, 'quantity' => (int) $quantity, 'date_add' => date('Y-m-d H:i:s')));
if (!$result_add) {
return false;
}
}
}
// refresh cache of self::_products
$this->_products = $this->getProducts(true);
$this->update(true);
$context = Context::getContext()->cloneContext();
$context->cart = $this;
Cache::clean('getContextualValue_*');
if ($auto_add_cart_rule) {
CartRule::autoAddToCart($context);
}
if ($product->customizable) {
return $this->updateCustomizationQuantity((int) $quantity, (int) $customization_id, (int) $product_id, (int) $product_attribute_id, (int) $address_delivery_id, $operator);
} else {
return true;
}
}
