/**
* 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;
}