public static function getItems($product_id, $lang_id) { if (!JeproshopProductPack::isFeaturePublished()) { return array(); } if (array_key_exists($product_id, self::$cachePackItems)) { return self::$cachePackItems[$product_id]; } $db = JFactory::getDBO(); $query = "SELECT product_item_id, quantity FROM " . $db->quoteName('#__jeproshop_pack') . " WHERE product_pack_id = " . (int) $product_id; $db->setQuery($query); $result = $db->loadObjectList(); $array_result = array(); foreach ($result as $row) { $product = new JeproshopProductModelProduct($row->product_item_id, false, $lang_id); $product->loadStockData(); $product->pack_quantity = $row->quantity; $array_result[] = $product; } self::$cachePackItems[$product_id] = $array_result; return self::$cachePackItems[$product_id]; }
public static function getPacksTable($product_id, $lang_id, $full = false, $limit = null) { if (!JeproshopProductPack::isFeaturePublished()) { return array(); } $db = JFactory::getDBO(); $query = "SELECT GROUP_CONCAT(pack." . $db->quoteName('product_pack_id') . ") FROM " . $db->quoteName('#__jeproshop_pack') . " AS pack WHERE pack." . $db->qsuoteName('product_item_id') . " = " . (int) $product_id; $db->quoteName($query); $packs = $db->loadResult(); if (!(int) $packs) { return array(); } $query = "SELECT product.*, product_shop.*, product_lang.*, MAX(image_shop." . $db->quoteName('image_id') . ") image_id, image_lang." . $db->quoteName('legend') . " FROM " . $db->quoteName('#__jeproshop_product') . " AS product NATURAL LEFT JOIN "; $query .= $db->quoteName('#__jeproshop_product_lang') . " AS product_lang " . JeproshopShopModelShop::addSqlAssociation('product') . " LEFT JOIN " . $db->quoteName('#__jeproshop_image') . " AS image ON (image." . $db->quoteName('product_id') . " = product."; $query .= $db->quoteName('product_id') . ") " . JeproshopShopModelShop::addSqlAssociation('image', false, 'image_shop.cover=1') . "\tLEFT JOIN " . $db->quoteName('#__jeproshop_image_lang') . " AS image_lang ON (image." . $db->quoteName('image_id'); $query .= " = image_lang." . $db->quoteName('image_id') . " AND image_lang." . $db->quoteName('lang_id') . " = " . (int) $lang_id . ") WHERE product_lang." . $db->quoteName('lang_id') . " = " . (int) $lang_id . JeproshopShopModelShop::addSqlRestrictionOnLang('product_lang'); $query .= "\tAND product." . $db->quoteName('product_id') . " IN (" . $packs . ") GROUP BY product_shop.product_id"; if ($limit) { $query .= " LIMIT " . (int) $limit; } $db->setQuery($query); $result = $db->loadObjectList(); if (!$full) { return $result; } $array_result = array(); foreach ($result as $row) { if (!JeproshopProductPack::isPacked($row->product_id)) { $array_result[] = JeproshopProductModelProduct::getProductProperties($lang_id, $row); } } return $array_result; }