Ajouter du HTML dans les caratéristiques produit de Prestashop

<?php

/*

* 2007-2015 PrestaShop

*

* NOTICE OF LICENSE

*

* This source file is subject to the Open Software License (OSL 3.0)

* that is bundled with this package in the file LICENSE.txt.

* It is also available through the world-wide-web at this URL:

* http://opensource.org/licenses/osl-3.0.php

* If you did not receive a copy of the license and are unable to

* obtain it through the world-wide-web, please send an email

* to license@prestashop.com so we can send you a copy immediately.

*

* DISCLAIMER

*

* Do not edit or add to this file if you wish to upgrade PrestaShop to newer

* versions in the future. If you wish to customize PrestaShop for your

* needs please refer to http://www.prestashop.com for more information.

*

*  @author PrestaShop SA <contact@prestashop.com>

*  @copyright  2007-2015 PrestaShop SA

*  @license    http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)

*  International Registered Trademark & Property of PrestaShop SA

*/



/**

 * @deprecated 1.5.0.1

 */

define(\'_CUSTOMIZE_FILE_\', 0);

/**

 * @deprecated 1.5.0.1

 */

define(\'_CUSTOMIZE_TEXTFIELD_\', 1);



class ProductCore extends ObjectModel

{

	/** @var string Tax name */

	public $tax_name;



	/** @var string Tax rate */

	public $tax_rate;



	/** @var int Manufacturer id */

	public $id_manufacturer;



	/** @var int Supplier id */

	public $id_supplier;



	/** @var int default Category id */

	public $id_category_default;



	/** @var int default Shop id */

	public $id_shop_default;



	/** @var string Manufacturer name */

	public $manufacturer_name;



	/** @var string Supplier name */

	public $supplier_name;



	/** @var string Name */

	public $name;



	/** @var string Long description */

	public $description;



	/** @var string Short description */

	public $description_short;



	/** @var int Quantity available */

	public $quantity = 0;



	/** @var int Minimal quantity for add to cart */

	public $minimal_quantity = 1;



	/** @var string available_now */

	public $available_now;



	/** @var string available_later */

	public $available_later;



	/** @var float Price in euros */

	public $price = 0;



	public $specificPrice = 0;



	/** @var float Additional shipping cost */

	public $additional_shipping_cost = 0;



	/** @var float Wholesale Price in euros */

	public $wholesale_price = 0;



	/** @var bool on_sale */

	public $on_sale = false;



	/** @var bool online_only */

	public $online_only = false;



	/** @var string unity */

	public $unity = null;



		/** @var float price for product\'s unity */

	public $unit_price;



		/** @var float price for product\'s unity ratio */

	public $unit_price_ratio = 0;



	/** @var float Ecotax */

	public $ecotax = 0;



	/** @var string Reference */

	public $reference;



	/** @var string Supplier Reference */

	public $supplier_reference;



	/** @var string Location */

	public $location;



	/** @var string Width in default width unit */

	public $width = 0;



	/** @var string Height in default height unit */

	public $height = 0;



	/** @var string Depth in default depth unit */

	public $depth = 0;



	/** @var string Weight in default weight unit */

	public $weight = 0;



	/** @var string Ean-13 barcode */

	public $ean13;



	/** @var string Upc barcode */

	public $upc;



	/** @var string Friendly URL */

	public $link_rewrite;



	/** @var string Meta tag description */

	public $meta_description;



	/** @var string Meta tag keywords */

	public $meta_keywords;



	/** @var string Meta tag title */

	public $meta_title;



	/** @var bool Product statuts */

	public $quantity_discount = 0;



	/** @var bool Product customization */

	public $customizable;



	/** @var bool Product is new */

	public $new = null;



	/** @var int Number of uploadable files (concerning customizable products) */

	public $uploadable_files;



	/** @var int Number of text fields */

	public $text_fields;



	/** @var bool Product statuts */

	public $active = true;



	/** @var bool Product statuts */

	public $redirect_type = \'\';



	/** @var bool Product statuts */

	public $id_product_redirected = 0;



	/** @var bool Product available for order */

	public $available_for_order = true;



	/** @var string Object available order date */

	public $available_date = \'0000-00-00\';



	/** @var string Enumerated (enum) product condition (new, used, refurbished) */

	public $condition;



	/** @var bool Show price of Product */

	public $show_price = true;



	/** @var bool is the product indexed in the search index? */

	public $indexed = 0;



	/** @var string ENUM(\'both\', \'catalog\', \'search\', \'none\') front office visibility */

	public $visibility;



	/** @var string Object creation date */

	public $date_add;



	/** @var string Object last modification date */

	public $date_upd;



	/*** @var array Tags */

	public $tags;



	/**

	 * @var float Base price of the product

	 * @deprecated 1.6.0.13

	 */

	public $base_price;



	public $id_tax_rules_group = 1;



	/**

	 * We keep this variable for retrocompatibility for themes

	 * @deprecated 1.5.0

	 */

	public $id_color_default = 0;



	/**

	 * @since 1.5.0

	 * @var bool Tells if the product uses the advanced stock management

	 */

	public $advanced_stock_management = 0;

	public $out_of_stock;

	public $depends_on_stock;



	public $isFullyLoaded = false;



	public $cache_is_pack;

	public $cache_has_attachments;

	public $is_virtual;

	public $id_pack_product_attribute;

	public $cache_default_attribute;



	/**

	 * @var string If product is populated, this property contain the rewrite link of the default category

	 */

	public $category;



	/**

	 * @var int tell the type of stock management to apply on the pack

	 */

	public $pack_stock_type = 3;



	public static $_taxCalculationMethod = null;

	protected static $_prices = array();

	protected static $_pricesLevel2 = array();

	protected static $_incat = array();



	/**

	 * @since 1.5.6.1

	 * @var array $_cart_quantity is deprecated since 1.5.6.1

	 */

	protected static $_cart_quantity = array();



	protected static $_tax_rules_group = array();

	protected static $_cacheFeatures = array();

	protected static $_frontFeaturesCache = array();

	protected static $producPropertiesCache = array();



	/** @var array cache stock data in getStock() method */

	protected static $cacheStock = array();



	public static $definition = array(

		\'table\' => \'product\',

		\'primary\' => \'id_product\',

		\'multilang\' => true,

		\'multilang_shop\' => true,

		\'fields\' => array(

			/* Classic fields */

			\'id_shop_default\' => 			array(\'type\' => self::TYPE_INT, \'validate\' => \'isUnsignedId\'),

			\'id_manufacturer\' => 			array(\'type\' => self::TYPE_INT, \'validate\' => \'isUnsignedId\'),

			\'id_supplier\' => 				array(\'type\' => self::TYPE_INT, \'validate\' => \'isUnsignedId\'),

			\'reference\' => 					array(\'type\' => self::TYPE_STRING, \'validate\' => \'isReference\', \'size\' => 32),

			\'supplier_reference\' => 		array(\'type\' => self::TYPE_STRING, \'validate\' => \'isReference\', \'size\' => 32),

			\'location\' => 					array(\'type\' => self::TYPE_STRING, \'validate\' => \'isReference\', \'size\' => 64),

			\'width\' => 						array(\'type\' => self::TYPE_FLOAT, \'validate\' => \'isUnsignedFloat\'),

			\'height\' => 					array(\'type\' => self::TYPE_FLOAT, \'validate\' => \'isUnsignedFloat\'),

			\'depth\' => 						array(\'type\' => self::TYPE_FLOAT, \'validate\' => \'isUnsignedFloat\'),

			\'weight\' => 					array(\'type\' => self::TYPE_FLOAT, \'validate\' => \'isUnsignedFloat\'),

			\'quantity_discount\' => 			array(\'type\' => self::TYPE_BOOL, \'validate\' => \'isBool\'),

			\'ean13\' => 						array(\'type\' => self::TYPE_STRING, \'validate\' => \'isEan13\', \'size\' => 13),

			\'upc\' => 						array(\'type\' => self::TYPE_STRING, \'validate\' => \'isUpc\', \'size\' => 12),

			\'cache_is_pack\' => 				array(\'type\' => self::TYPE_BOOL, \'validate\' => \'isBool\'),

			\'cache_has_attachments\' => 		array(\'type\' => self::TYPE_BOOL, \'validate\' => \'isBool\'),

			\'is_virtual\' => 				array(\'type\' => self::TYPE_BOOL, \'validate\' => \'isBool\'),



			/* Shop fields */

			\'id_category_default\' => 		array(\'type\' => self::TYPE_INT, \'shop\' => true, \'validate\' => \'isUnsignedId\'),

			\'id_tax_rules_group\' => 		array(\'type\' => self::TYPE_INT, \'shop\' => true, \'validate\' => \'isUnsignedId\'),

			\'on_sale\' => 					array(\'type\' => self::TYPE_BOOL, \'shop\' => true, \'validate\' => \'isBool\'),

			\'online_only\' => 				array(\'type\' => self::TYPE_BOOL, \'shop\' => true, \'validate\' => \'isBool\'),

			\'ecotax\' => 					array(\'type\' => self::TYPE_FLOAT, \'shop\' => true, \'validate\' => \'isPrice\'),

			\'minimal_quantity\' => 			array(\'type\' => self::TYPE_INT, \'shop\' => true, \'validate\' => \'isUnsignedInt\'),

			\'price\' => 						array(\'type\' => self::TYPE_FLOAT, \'shop\' => true, \'validate\' => \'isPrice\', \'required\' => true),

			\'wholesale_price\' => 			array(\'type\' => self::TYPE_FLOAT, \'shop\' => true, \'validate\' => \'isPrice\'),

			\'unity\' => 						array(\'type\' => self::TYPE_STRING, \'shop\' => true, \'validate\' => \'isString\'),

			\'unit_price_ratio\' => 			array(\'type\' => self::TYPE_FLOAT, \'shop\' => true),

			\'additional_shipping_cost\' => 	array(\'type\' => self::TYPE_FLOAT, \'shop\' => true, \'validate\' => \'isPrice\'),

			\'customizable\' => 				array(\'type\' => self::TYPE_INT, \'shop\' => true, \'validate\' => \'isUnsignedInt\'),

			\'text_fields\' => 				array(\'type\' => self::TYPE_INT, \'shop\' => true, \'validate\' => \'isUnsignedInt\'),

			\'uploadable_files\' => 			array(\'type\' => self::TYPE_INT, \'shop\' => true, \'validate\' => \'isUnsignedInt\'),

			\'active\' => 					array(\'type\' => self::TYPE_BOOL, \'shop\' => true, \'validate\' => \'isBool\'),

			\'redirect_type\' => 				array(\'type\' => self::TYPE_STRING, \'shop\' => true, \'validate\' => \'isString\'),

			\'id_product_redirected\' => 		array(\'type\' => self::TYPE_INT, \'shop\' => true, \'validate\' => \'isUnsignedId\'),

			\'available_for_order\' => 		array(\'type\' => self::TYPE_BOOL, \'shop\' => true, \'validate\' => \'isBool\'),

			\'available_date\' => 			array(\'type\' => self::TYPE_DATE, \'shop\' => true, \'validate\' => \'isDateFormat\'),

			\'condition\' => 					array(\'type\' => self::TYPE_STRING, \'shop\' => true, \'validate\' => \'isGenericName\', \'values\' => array(\'new\', \'used\', \'refurbished\'), \'default\' => \'new\'),

			\'show_price\' => 				array(\'type\' => self::TYPE_BOOL, \'shop\' => true, \'validate\' => \'isBool\'),

			\'indexed\' => 					array(\'type\' => self::TYPE_BOOL, \'shop\' => true, \'validate\' => \'isBool\'),

			\'visibility\' => 				array(\'type\' => self::TYPE_STRING, \'shop\' => true, \'validate\' => \'isProductVisibility\', \'values\' => array(\'both\', \'catalog\', \'search\', \'none\'), \'default\' => \'both\'),

			\'cache_default_attribute\' => 	array(\'type\' => self::TYPE_INT, \'shop\' => true),

			\'advanced_stock_management\' => 	array(\'type\' => self::TYPE_BOOL, \'shop\' => true, \'validate\' => \'isBool\'),

			\'date_add\' => 					array(\'type\' => self::TYPE_DATE, \'shop\' => true, \'validate\' => \'isDate\'),

			\'date_upd\' => 					array(\'type\' => self::TYPE_DATE, \'shop\' => true, \'validate\' => \'isDate\'),

			\'pack_stock_type\' =>			array(\'type\' => self::TYPE_INT, \'shop\' => true, \'validate\' => \'isUnsignedInt\'),



			/* Lang fields */

			\'meta_description\' => 			array(\'type\' => self::TYPE_STRING, \'lang\' => true, \'validate\' => \'isGenericName\', \'size\' => 255),

			\'meta_keywords\' => 				array(\'type\' => self::TYPE_STRING, \'lang\' => true, \'validate\' => \'isGenericName\', \'size\' => 255),

			\'meta_title\' => 				array(\'type\' => self::TYPE_STRING, \'lang\' => true, \'validate\' => \'isGenericName\', \'size\' => 128),

			\'link_rewrite\' =>	array(

				\'type\' => self::TYPE_STRING,

				\'lang\' => true,

				\'validate\' => \'isLinkRewrite\',

				\'required\' => true,

				\'size\' => 128,

				\'ws_modifier\' => array(

					\'http_method\' => WebserviceRequest::HTTP_POST,

					\'modifier\' => \'modifierWsLinkRewrite\'

				)

			),

			\'name\' => 						array(\'type\' => self::TYPE_STRING, \'lang\' => true, \'validate\' => \'isCatalogName\', \'required\' => true, \'size\' => 128),

			\'description\' => 				array(\'type\' => self::TYPE_HTML, \'lang\' => true, \'validate\' => \'isCleanHtml\'),

			\'description_short\' => 			array(\'type\' => self::TYPE_HTML, \'lang\' => true, \'validate\' => \'isCleanHtml\'),

			\'available_now\' => 				array(\'type\' => self::TYPE_STRING, \'lang\' => true, \'validate\' => \'isGenericName\', \'size\' => 255),

			\'available_later\' => 			array(\'type\' => self::TYPE_STRING, \'lang\' => true, \'validate\' => \'IsGenericName\', \'size\' => 255),

		),

		\'associations\' => array(

			\'manufacturer\' => 				array(\'type\' => self::HAS_ONE),

			\'supplier\' => 					array(\'type\' => self::HAS_ONE),

			\'default_category\' => 			array(\'type\' => self::HAS_ONE, \'field\' => \'id_category_default\', \'object\' => \'Category\'),

			\'tax_rules_group\' => 			array(\'type\' => self::HAS_ONE),

			\'categories\' =>					array(\'type\' => self::HAS_MANY, \'field\' => \'id_category\', \'object\' => \'Category\', \'association\' => \'category_product\'),

			\'stock_availables\' =>			array(\'type\' => self::HAS_MANY, \'field\' => \'id_stock_available\', \'object\' => \'StockAvailable\', \'association\' => \'stock_availables\'),

		),

	);



	protected $webserviceParameters = array(

		\'objectMethods\' => array(

			\'add\' => \'addWs\',

			\'update\' => \'updateWs\'

		),

		\'objectNodeNames\' => \'products\',

		\'fields\' => array(

			\'id_manufacturer\' => array(

				\'xlink_resource\' => \'manufacturers\'

			),

			\'id_supplier\' => array(

				\'xlink_resource\' => \'suppliers\'

			),

			\'id_category_default\' => array(

				\'xlink_resource\' => \'categories\'

			),

			\'new\' => array(),

			\'cache_default_attribute\' => array(),

			\'id_default_image\' => array(

				\'getter\' => \'getCoverWs\',

				\'setter\' => \'setCoverWs\',

				\'xlink_resource\' => array(

					\'resourceName\' => \'images\',

					\'subResourceName\' => \'products\'

				)

			),

			\'id_default_combination\' => array(

				\'getter\' => \'getWsDefaultCombination\',

				\'setter\' => \'setWsDefaultCombination\',

				\'xlink_resource\' => array(

					\'resourceName\' => \'combinations\'

				)

			),

			\'id_tax_rules_group\' => array(

				\'xlink_resource\' => array(

					\'resourceName\' => \'tax_rule_groups\'

				)

			),

			\'position_in_category\' => array(

				\'getter\' => \'getWsPositionInCategory\',

				\'setter\' => \'setWsPositionInCategory\'

			),

			\'manufacturer_name\' => array(

				\'getter\' => \'getWsManufacturerName\',

				\'setter\' => false

			),

			\'quantity\' => array(

				\'getter\' => false,

				\'setter\' => false

			),

			\'type\' => array(

				\'getter\' => \'getWsType\',

				\'setter\' => \'setWsType\',

			),

		),

		\'associations\' => array(

			\'categories\' => array(

				\'resource\' => \'category\',

				\'fields\' => array(

					\'id\' => array(\'required\' => true),

				)

			),

			\'images\' => array(

				\'resource\' => \'image\',

				\'fields\' => array(\'id\' => array())

			),

			\'combinations\' => array(

				\'resource\' => \'combination\',

				\'fields\' => array(

					\'id\' => array(\'required\' => true),

				)

			),

			\'product_option_values\' => array(

				\'resource\' => \'product_option_value\',

				\'fields\' => array(

					\'id\' => array(\'required\' => true),

				)

			),

			\'product_features\' => array(

				\'resource\' => \'product_feature\',

				\'fields\' => array(

					\'id\' => array(\'required\' => true),

					\'id_feature_value\' => array(

						\'required\' => true,

						\'xlink_resource\' => \'product_feature_values\'

					),

				)

			),

			\'tags\' => array(\'resource\' => \'tag\',

				\'fields\' => array(

					\'id\' => array(\'required\' => true),

			)),

			\'stock_availables\' => array(\'resource\' => \'stock_available\',

				\'fields\' => array(

					\'id\' => array(\'required\' => true),

					\'id_product_attribute\' => array(\'required\' => true),

				),

				\'setter\' => false

			),

			\'accessories\' => array(

				\'resource\' => \'product\',

				\'api\' => \'products\',

				\'fields\' => array(

					\'id\' => array(

						\'required\' => true,

						\'xlink_resource\' => \'product\'),

				)

			),

			\'product_bundle\' => array(

				\'resource\' => \'product\',

				\'api\' => \'products\',

				\'fields\' => array(

					\'id\' => array(\'required\' => true),

					\'quantity\' => array(),

				),

			),

		),

	);



	const CUSTOMIZE_FILE = 0;

	const CUSTOMIZE_TEXTFIELD = 1;



	/**

	 * Note:  prefix is "PTYPE" because TYPE_ is used in ObjectModel (definition)

	 */

	const PTYPE_SIMPLE = 0;

	const PTYPE_PACK = 1;

	const PTYPE_VIRTUAL = 2;



	public function __construct($id_product = null, $full = false, $id_lang = null, $id_shop = null, Context $context = null)

	{

		parent::__construct($id_product, $id_lang, $id_shop);

		if ($full && $this->id)

		{

			if (!$context)

				$context = Context::getContext();



			$this->isFullyLoaded = $full;

			$this->tax_name = \'deprecated\'; // The applicable tax may be BOTH the product one AND the state one (moreover this variable is some deadcode)

			$this->manufacturer_name = Manufacturer::getNameById((int)$this->id_manufacturer);

			$this->supplier_name = Supplier::getNameById((int)$this->id_supplier);

			$address = null;

			if (is_object($context->cart) && $context->cart->{Configuration::get(\'PS_TAX_ADDRESS_TYPE\')} != null)

				$address = $context->cart->{Configuration::get(\'PS_TAX_ADDRESS_TYPE\')};



			$this->tax_rate = $this->getTaxesRate(new Address($address));



			$this->new = $this->isNew();



			// Keep base price

			$this->base_price = $this->price;



			$this->price = Product::getPriceStatic((int)$this->id, false, null, 6, null, false, true, 1, false, null, null, null, $this->specificPrice);

			$this->unit_price = ($this->unit_price_ratio != 0  ? $this->price / $this->unit_price_ratio : 0);

			if ($this->id)

				$this->tags = Tag::getProductTags((int)$this->id);



			$this->loadStockData();

		}



		if ($this->id_category_default)

			$this->category = Category::getLinkRewrite((int)$this->id_category_default, (int)$id_lang);

	}



	/**

	 * @see ObjectModel::getFieldsShop()

	 * @return array

	 */

	public function getFieldsShop()

	{

		$fields = parent::getFieldsShop();

		if (is_null($this->update_fields) || (!empty($this->update_fields[\'price\']) && !empty($this->update_fields[\'unit_price\'])))

		$fields[\'unit_price_ratio\'] = (float)$this->unit_price > 0 ? $this->price / $this->unit_price : 0;

		$fields[\'unity\'] = pSQL($this->unity);



		return $fields;

	}



	public function add($autodate = true, $null_values = false)

	{

		if (!parent::add($autodate, $null_values))

			return false;



		$id_shop_list = Shop::getContextListShopID();

		if ($this->getType() == Product::PTYPE_VIRTUAL)

		{

			foreach ($id_shop_list as $value)

				StockAvailable::setProductOutOfStock((int)$this->id, 1, $value);



			if ($this->active && !Configuration::get(\'PS_VIRTUAL_PROD_FEATURE_ACTIVE\'))

				Configuration::updateGlobalValue(\'PS_VIRTUAL_PROD_FEATURE_ACTIVE\', \'1\');

		}

		else

			foreach ($id_shop_list as $value)

				StockAvailable::setProductOutOfStock((int)$this->id, 2, $value);



		$this->setGroupReduction();

		Hook::exec(\'actionProductSave\', array(\'id_product\' => (int)$this->id, \'product\' => $this));

		return true;

	}



	public function update($null_values = false)

	{

		$return = parent::update($null_values);

		$this->setGroupReduction();



		// Sync stock Reference, EAN13 and UPC

		if (Configuration::get(\'PS_ADVANCED_STOCK_MANAGEMENT\') && StockAvailable::dependsOnStock($this->id, Context::getContext()->shop->id))

			Db::getInstance()->update(\'stock\', array(

				\'reference\' => pSQL($this->reference),

				\'ean13\'     => pSQL($this->ean13),

				\'upc\'		=> pSQL($this->upc),

			), \'id_product = \'.(int)$this->id.\' AND id_product_attribute = 0\');



		Hook::exec(\'actionProductSave\', array(\'id_product\' => (int)$this->id, \'product\' => $this));

		Hook::exec(\'actionProductUpdate\', array(\'id_product\' => (int)$this->id, \'product\' => $this));

		if ($this->getType() == Product::PTYPE_VIRTUAL && $this->active && !Configuration::get(\'PS_VIRTUAL_PROD_FEATURE_ACTIVE\'))

			Configuration::updateGlobalValue(\'PS_VIRTUAL_PROD_FEATURE_ACTIVE\', \'1\');



		return $return;

	}



	public static function initPricesComputation($id_customer = null)

	{

		if ($id_customer)

		{

			$customer = new Customer((int)$id_customer);

			if (!Validate::isLoadedObject($customer))

				die(Tools::displayError());

			self::$_taxCalculationMethod = Group::getPriceDisplayMethod((int)$customer->id_default_group);

			$cur_cart = Context::getContext()->cart;

			$id_address = 0;

			if (Validate::isLoadedObject($cur_cart))

				$id_address = (int)$cur_cart->{Configuration::get(\'PS_TAX_ADDRESS_TYPE\')};

			$address_infos = Address::getCountryAndState($id_address);



			if (self::$_taxCalculationMethod != PS_TAX_EXC

				&& !empty($address_infos[\'vat_number\'])

				&& $address_infos[\'id_country\'] != Configuration::get(\'VATNUMBER_COUNTRY\')

				&& Configuration::get(\'VATNUMBER_MANAGEMENT\'))

				self::$_taxCalculationMethod = PS_TAX_EXC;

		}

		else

			self::$_taxCalculationMethod = Group::getPriceDisplayMethod(Group::getCurrent()->id);

	}



	public static function getTaxCalculationMethod($id_customer = null)

	{

		if (self::$_taxCalculationMethod === null || $id_customer !== null)

			Product::initPricesComputation($id_customer);



		return (int)self::$_taxCalculationMethod;

	}



	/**

	 * Move a product inside its category

	 * @param bool $way Up (1)  or Down (0)

	 * @param int $position

	 * return boolean Update result

	 */

	public function updatePosition($way, $position)

	{

		if (!$res = Db::getInstance()->executeS(\'

			SELECT cp.`id_product`, cp.`position`, cp.`id_category`

			FROM `\'._DB_PREFIX_.\'category_product` cp

			WHERE cp.`id_category` = \'.(int)Tools::getValue(\'id_category\', 1).\'

			ORDER BY cp.`position` ASC\'

		))

			return false;



		foreach ($res as $product)

			if ((int)$product[\'id_product\'] == (int)$this->id)

				$moved_product = $product;



		if (!isset($moved_product) || !isset($position))

			return false;



		// < and > statements rather than BETWEEN operator

		// since BETWEEN is treated differently according to databases

		return (Db::getInstance()->execute(\'

			UPDATE `\'._DB_PREFIX_.\'category_product`

			SET `position`= `position` \'.($way ? \'- 1\' : \'+ 1\').\'

			WHERE `position`

			\'.($way

				? \'> \'.(int)$moved_product[\'position\'].\' AND `position` <= \'.(int)$position

				: \'< \'.(int)$moved_product[\'position\'].\' AND `position` >= \'.(int)$position).\'

			AND `id_category`=\'.(int)$moved_product[\'id_category\'])

		&& Db::getInstance()->execute(\'

			UPDATE `\'._DB_PREFIX_.\'category_product`

			SET `position` = \'.(int)$position.\'

			WHERE `id_product` = \'.(int)$moved_product[\'id_product\'].\'

			AND `id_category`=\'.(int)$moved_product[\'id_category\']));

	}



	/*

	 * Reorder product position in category $id_category.

	 * Call it after deleting a product from a category.

	 *

	 * @param int $id_category

	 */

	public static function cleanPositions($id_category, $position = 0)

	{

		$return = true;



		if (!(int)$position)

		{



			$result = Db::getInstance()->executeS(\'

				SELECT `id_product`

				FROM `\'._DB_PREFIX_.\'category_product`

				WHERE `id_category` = \'.(int)$id_category.\'

				ORDER BY `position`

			\');

			$total = count($result);



			for ($i = 0; $i < $total; $i++) $return &= Db::getInstance()->update(\'category_product\', array(

					\'position\' => $i,

				), \'`id_category` = \'.(int)$id_category.\' AND `id_product` = \'.(int)$result[$i][\'id_product\']);

		}

		else

			$return &= Db::getInstance()->update(\'category_product\',

				array(\'position\' => array(\'type\' => \'sql\', \'value\' => \'`position`-1\')),

				\'`id_category` = \'.(int)$id_category.\' AND `position` > \'.(int)$position);



		return $return;

	}



	/**

	* Get the default attribute for a product

	*

	* @return int Attributes list

	*/

	public static function getDefaultAttribute($id_product, $minimum_quantity = 0, $reset = false)

	{

		static $combinations = array();



		if (!Combination::isFeatureActive())

			return 0;



		if ($reset && isset($combinations[$id_product]))

			unset($combinations[$id_product]);



		if (!isset($combinations[$id_product]))

			$combinations[$id_product] = array();

		if (isset($combinations[$id_product][$minimum_quantity]))

			return $combinations[$id_product][$minimum_quantity];





		$sql = \'SELECT product_attribute_shop.id_product_attribute

				FROM \'._DB_PREFIX_.\'product_attribute pa

				\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').\'

				WHERE pa.id_product = \'.(int)$id_product;



		$result_no_filter = Db::getInstance()->getValue($sql);

		if (!$result_no_filter)

		{

			$combinations[$id_product][$minimum_quantity] = 0;

			return 0;

		}



		$sql = \'SELECT product_attribute_shop.id_product_attribute

				FROM \'._DB_PREFIX_.\'product_attribute pa

				\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').\'

				\'.($minimum_quantity > 0 ? Product::sqlStock(\'pa\', \'pa\') : \'\').

				\' WHERE product_attribute_shop.default_on = 1 \'

				.($minimum_quantity > 0 ? \' AND IFNULL(stock.quantity, 0) >= \'.(int)$minimum_quantity : \'\').

				\' AND pa.id_product = \'.(int)$id_product;

		$result = Db::getInstance()->getValue($sql);



		if (!$result)

		{

			$sql = \'SELECT product_attribute_shop.id_product_attribute

					FROM \'._DB_PREFIX_.\'product_attribute pa

					\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').\'

					\'.($minimum_quantity > 0 ? Product::sqlStock(\'pa\', \'pa\') : \'\').

					\' WHERE pa.id_product = \'.(int)$id_product

					.($minimum_quantity > 0 ? \' AND IFNULL(stock.quantity, 0) >= \'.(int)$minimum_quantity : \'\');



			$result = Db::getInstance()->getValue($sql);

		}



		if (!$result)

		{

			$sql = \'SELECT product_attribute_shop.id_product_attribute

					FROM \'._DB_PREFIX_.\'product_attribute pa

					\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').\'

					WHERE product_attribute_shop.`default_on` = 1

					AND pa.id_product = \'.(int)$id_product;



			$result = Db::getInstance()->getValue($sql);

		}



		if (!$result)

			$result = $result_no_filter;



		$combinations[$id_product][$minimum_quantity] = $result;

		return $result;

	}



	public function setAvailableDate($available_date = \'0000-00-00\')

	{

		if (Validate::isDateFormat($available_date) && $this->available_date != $available_date)

		{

			$this->available_date = $available_date;

			return $this->update();

		}

		return false;

	}



	/**

	 * For a given id_product and id_product_attribute, return available date

	 *

	 * @param int $id_product

	 * @param int $id_product_attribute Optional

	 * @return string/null

	 */

	public static function getAvailableDate($id_product, $id_product_attribute = null)

	{

		$sql = \'SELECT\';



		if ($id_product_attribute === null)

			$sql .= \' p.`available_date`\';

		else

			$sql .= \' IF(pa.`available_date` = "0000-00-00", p.`available_date`, pa.`available_date`) AS available_date\';



		$sql .= \' FROM `\'._DB_PREFIX_.\'product` p\';



		if ($id_product_attribute !== null)

			$sql .= \' LEFT JOIN `\'._DB_PREFIX_.\'product_attribute` pa ON (pa.`id_product` = p.`id_product`)\';



		$sql .= Shop::addSqlAssociation(\'product\', \'p\');



		if ($id_product_attribute !== null)

			$sql .= Shop::addSqlAssociation(\'product_attribute\', \'pa\');



		$sql .= \' WHERE p.`id_product` = \'.(int)$id_product;



		if ($id_product_attribute !== null)

			$sql .= \' AND pa.`id_product` = \'.(int)$id_product.\' AND pa.`id_product_attribute` = \'.(int)$id_product_attribute;



		$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($sql);



		if ($result == \'0000-00-00\')

			$result = null;



		return $result;

	}



	public static function updateIsVirtual($id_product, $is_virtual = true)

	{

		Db::getInstance()->update(\'product\', array(

			\'is_virtual\' => (bool)$is_virtual,

		), \'id_product = \'.(int)$id_product);

	}



	/**

	 * @see ObjectModel::validateField()

	 */

	public function validateField($field, $value, $id_lang = null, $skip = array(), $human_errors = false)

	{

		if ($field == \'description_short\')

		{

			$limit = (int)Configuration::get(\'PS_PRODUCT_SHORT_DESC_LIMIT\');

			if ($limit <= 0) $limit = 800; $size_without_html = Tools::strlen(strip_tags($value)); $size_with_html = Tools::strlen($value); $this->def[\'fields\'][\'description_short\'][\'size\'] = $limit + $size_with_html - $size_without_html;

		}

		return parent::validateField($field, $value, $id_lang, $skip, $human_errors);

	}



	public function toggleStatus()

	{

		//test if the product is active and if redirect_type is empty string and set default value to id_product_redirected & redirect_type

		//  /! after parent::toggleStatus() active will be false, that why we set 404 by default :p

		if ($this->active)

		{

			//case where active will be false after parent::toggleStatus()

			$this->id_product_redirected = 0;

			$this->redirect_type = \'404\';

		}

		else

		{

			//case where active will be true after parent::toggleStatus()

			$this->id_product_redirected = 0;

			$this->redirect_type = \'\';

		}

		return parent::toggleStatus();

	}



	public function delete()

	{

		/*

		 * @since 1.5.0

		 * It is NOT possible to delete a product if there are currently:

		 * - physical stock for this product

		 * - supply order(s) for this product

		 */

		if (Configuration::get(\'PS_ADVANCED_STOCK_MANAGEMENT\') && $this->advanced_stock_management)

		{

			$stock_manager = StockManagerFactory::getManager();

			$physical_quantity = $stock_manager->getProductPhysicalQuantities($this->id, 0);

			$real_quantity = $stock_manager->getProductRealQuantities($this->id, 0);

			if ($physical_quantity > 0)

				return false;

			if ($real_quantity > $physical_quantity)

				return false;

		}

		$result = parent::delete();



		// Removes the product from StockAvailable, for the current shop

		StockAvailable::removeProductFromStockAvailable($this->id);

		$result &= ($this->deleteProductAttributes() && $this->deleteImages() && $this->deleteSceneProducts());

		// If there are still entries in product_shop, don\'t remove completly the product

		if ($this->hasMultishopEntries())

			return true;



		Hook::exec(\'actionProductDelete\', array(\'id_product\' => (int)$this->id, \'product\' => $this));

		if (!$result ||

			!GroupReduction::deleteProductReduction($this->id) ||

			!$this->deleteCategories(true) ||

			!$this->deleteProductFeatures() ||

			!$this->deleteTags() ||

			!$this->deleteCartProducts() ||

			!$this->deleteAttributesImpacts() ||

			!$this->deleteAttachments(false) ||

			!$this->deleteCustomization() ||

			!SpecificPrice::deleteByProductId((int)$this->id) ||

			!$this->deletePack() ||

			!$this->deleteProductSale() ||

			!$this->deleteSearchIndexes() ||

			!$this->deleteAccessories() ||

			!$this->deleteFromAccessories() ||

			!$this->deleteFromSupplier() ||

			!$this->deleteDownload() ||

			!$this->deleteFromCartRules())

		return false;



		return true;

	}



	public function deleteSelection($products)

	{

		$return = 1;

		if (is_array($products) && ($count = count($products)))

		{

			// Deleting products can be quite long on a cheap server. Let\'s say 1.5 seconds by product (I\'ve seen it!).

			if (intval(ini_get(\'max_execution_time\')) < round($count * 1.5)) ini_set(\'max_execution_time\', round($count * 1.5)); foreach ($products as $id_product) { $product = new Product((int)$id_product); $return &= $product->delete();

			}

		}

		return $return;

	}



	public function deleteFromCartRules()

	{

		CartRule::cleanProductRuleIntegrity(\'products\', $this->id);

		return true;

	}



	public function deleteFromSupplier()

	{

		return Db::getInstance()->delete(\'product_supplier\', \'id_product = \'.(int)$this->id);

	}



	/**

	 * addToCategories add this product to the category/ies if not exists.

	 *

	 * @param mixed $categories id_category or array of id_category

	 * @return bool true if succeed

	 */

	public function addToCategories($categories = array())

	{

		if (empty($categories))

			return false;



		if (!is_array($categories))

			$categories = array($categories);



		if (!count($categories))

			return false;



		$categories = array_map(\'intval\', $categories);



		$current_categories = $this->getCategories();

		$current_categories = array_map(\'intval\', $current_categories);



		// for new categ, put product at last position

		$res_categ_new_pos = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(\'

			SELECT id_category, MAX(position)+1 newPos

			FROM `\'._DB_PREFIX_.\'category_product`

			WHERE `id_category` IN(\'.implode(\',\', $categories).\')

			GROUP BY id_category\');

		foreach ($res_categ_new_pos as $array)

			$new_categories[(int)$array[\'id_category\']] = (int)$array[\'newPos\'];



		$new_categ_pos = array();

		foreach ($categories as $id_category)

			$new_categ_pos[$id_category] = isset($new_categories[$id_category]) ? $new_categories[$id_category] : 0;



		$product_cats = array();



		foreach ($categories as $new_id_categ)

			if (!in_array($new_id_categ, $current_categories))

				$product_cats[] = array(

					\'id_category\' => (int)$new_id_categ,

					\'id_product\' => (int)$this->id,

					\'position\' => (int)$new_categ_pos[$new_id_categ],

				);



		Db::getInstance()->insert(\'category_product\', $product_cats);

		return true;

	}



	/**

	* Update categories to index product into

	*

	* @param string $productCategories Categories list to index product into

	* @param bool $keeping_current_pos (deprecated, no more used)

	* @return array Update/insertion result

	*/

	public function updateCategories($categories, $keeping_current_pos = false)

	{

		if (empty($categories))

			return false;



		$result = Db::getInstance()->executeS(\'

			SELECT c.`id_category`

			FROM `\'._DB_PREFIX_.\'category_product` cp

			LEFT JOIN `\'._DB_PREFIX_.\'category` c ON (c.`id_category` = cp.`id_category`)

			\'.Shop::addSqlAssociation(\'category\', \'c\', true, null, true).\'

			WHERE cp.`id_category` NOT IN (\'.implode(\',\', array_map(\'intval\', $categories)).\')

			AND cp.id_product = \'.$this->id

		);



		// if none are found, it\'s an error

		if (!is_array($result))

			return false;



		foreach ($result as $categ_to_delete)

			$this->deleteCategory($categ_to_delete[\'id_category\']);



		if (!$this->addToCategories($categories))

			return false;



		SpecificPriceRule::applyAllRules(array((int)$this->id));

		return true;

	}



	/**

	 * deleteCategory delete this product from the category $id_category

	 *

	 * @param mixed $id_category

	 * @param mixed $clean_positions

	 * @return bool

	 */

	public function deleteCategory($id_category, $clean_positions = true)

	{

		$result = Db::getInstance()->executeS(

			\'SELECT `id_category`, `position`

			FROM `\'._DB_PREFIX_.\'category_product`

			WHERE `id_product` = \'.(int)$this->id.\'

			AND id_category = \'.(int)$id_category.\'\'

		);



		$return = Db::getInstance()->delete(\'category_product\', \'id_product = \'.(int)$this->id.\' AND id_category = \'.(int)$id_category);

		if ($clean_positions === true)

			foreach ($result as $row)

				$this->cleanPositions((int)$row[\'id_category\'], (int)$row[\'position\']);

		SpecificPriceRule::applyAllRules(array((int)$this->id));

		return $return;

	}



	/**

	* Delete all association to category where product is indexed

	*

	* @param bool $clean_positions clean category positions after deletion

	* @return array Deletion result

	*/

	public function deleteCategories($clean_positions = false)

	{

		if ($clean_positions === true)

			$result = Db::getInstance()->executeS(

				\'SELECT `id_category`, `position`

				FROM `\'._DB_PREFIX_.\'category_product`

				WHERE `id_product` = \'.(int)$this->id

			);



		$return = Db::getInstance()->delete(\'category_product\', \'id_product = \'.(int)$this->id);

		if ($clean_positions === true && is_array($result))

			foreach ($result as $row)

					$return &= $this->cleanPositions((int)$row[\'id_category\'], (int)$row[\'position\']);



		return $return;

	}



	/**

	* Delete products tags entries

	*

	* @return array Deletion result

	*/

	public function deleteTags()

	{

		return Db::getInstance()->delete(\'product_tag\', \'id_product = \'.(int)$this->id)

			&& Db::getInstance()->delete(\'tag\', \'NOT EXISTS (SELECT 1 FROM \'._DB_PREFIX_.\'product_tag

												WHERE \'._DB_PREFIX_.\'product_tag.id_tag = \'._DB_PREFIX_.\'tag.id_tag)\');

	}



	/**

	* Delete product from cart

	*

	* @return array Deletion result

	*/

	public function deleteCartProducts()

	{

		return Db::getInstance()->delete(\'cart_product\', \'id_product = \'.(int)$this->id);

	}



	/**

	* Delete product images from database

	*

	* @return bool success

	*/

	public function deleteImages()

	{

		$result = Db::getInstance()->executeS(\'

			SELECT `id_image`

			FROM `\'._DB_PREFIX_.\'image`

			WHERE `id_product` = \'.(int)$this->id

		);



		$status = true;

		if ($result)

			foreach ($result as $row)

			{

				$image = new Image($row[\'id_image\']);

				$status &= $image->delete();

			}

		return $status;

	}



	/**

	 * @deprecated 1.5.0 Use Combination::getPrice()

	 */

	public static function getProductAttributePrice($id_product_attribute)

	{

		return Combination::getPrice($id_product_attribute);

	}



	/**

	* Get all available products

	*

	* @param int $id_lang Language id

	* @param int $start Start number

	* @param int $limit Number of products to return

	* @param string $order_by Field for ordering

	* @param string $order_way Way for ordering (ASC or DESC)

	* @return array Products details

	*/

	public static function getProducts($id_lang, $start, $limit, $order_by, $order_way, $id_category = false,

		$only_active = false, Context $context = null)

	{

		if (!$context)

			$context = Context::getContext();



		$front = true;

		if (!in_array($context->controller->controller_type, array(\'front\', \'modulefront\')))

			$front = false;



		if (!Validate::isOrderBy($order_by) || !Validate::isOrderWay($order_way))

			die (Tools::displayError());

		if ($order_by == \'id_product\' || $order_by == \'price\' || $order_by == \'date_add\' || $order_by == \'date_upd\')

			$order_by_prefix = \'p\';

		elseif ($order_by == \'name\')

			$order_by_prefix = \'pl\';

		elseif ($order_by == \'position\')

			$order_by_prefix = \'c\';



		if (strpos($order_by, \'.\') > 0)

		{

			$order_by = explode(\'.\', $order_by);

			$order_by_prefix = $order_by[0];

			$order_by = $order_by[1];

		}

		$sql = \'SELECT p.*, product_shop.*, pl.* , m.`name` AS manufacturer_name, s.`name` AS supplier_name

				FROM `\'._DB_PREFIX_.\'product` p

				\'.Shop::addSqlAssociation(\'product\', \'p\').\'

				LEFT JOIN `\'._DB_PREFIX_.\'product_lang` pl ON (p.`id_product` = pl.`id_product` \'.Shop::addSqlRestrictionOnLang(\'pl\').\')

				LEFT JOIN `\'._DB_PREFIX_.\'manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)

				LEFT JOIN `\'._DB_PREFIX_.\'supplier` s ON (s.`id_supplier` = p.`id_supplier`)\'.

				($id_category ? \'LEFT JOIN `\'._DB_PREFIX_.\'category_product` c ON (c.`id_product` = p.`id_product`)\' : \'\').\'

				WHERE pl.`id_lang` = \'.(int)$id_lang.

					($id_category ? \' AND c.`id_category` = \'.(int)$id_category : \'\').

					($front ? \' AND product_shop.`visibility` IN ("both", "catalog")\' : \'\').

					($only_active ? \' AND product_shop.`active` = 1\' : \'\').\'

				ORDER BY \'.(isset($order_by_prefix) ? pSQL($order_by_prefix).\'.\' : \'\').\'`\'.pSQL($order_by).\'` \'.pSQL($order_way).

				($limit > 0 ? \' LIMIT \'.(int)$start.\',\'.(int)$limit : \'\');

		$rq = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);

		if ($order_by == \'price\')

			Tools::orderbyPrice($rq, $order_way);



		foreach ($rq as &$row)

			$row = Product::getTaxesInformations($row);



		return ($rq);

	}



	public static function getSimpleProducts($id_lang, Context $context = null)

	{

		if (!$context)

			$context = Context::getContext();



		$front = true;

		if (!in_array($context->controller->controller_type, array(\'front\', \'modulefront\')))

			$front = false;



		$sql = \'SELECT p.`id_product`, pl.`name`

				FROM `\'._DB_PREFIX_.\'product` p

				\'.Shop::addSqlAssociation(\'product\', \'p\').\'

				LEFT JOIN `\'._DB_PREFIX_.\'product_lang` pl ON (p.`id_product` = pl.`id_product` \'.Shop::addSqlRestrictionOnLang(\'pl\').\')

				WHERE pl.`id_lang` = \'.(int)$id_lang.\'

				\'.($front ? \' AND product_shop.`visibility` IN ("both", "catalog")\' : \'\').\'

				ORDER BY pl.`name`\';

		return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);

	}



	public function isNew()

	{

		$result = Db::getInstance()->executeS(\'

			SELECT p.id_product

			FROM `\'._DB_PREFIX_.\'product` p

			\'.Shop::addSqlAssociation(\'product\', \'p\').\'

			WHERE p.id_product = \'.(int)$this->id.\'

			AND DATEDIFF(

				product_shop.`date_add`,

				DATE_SUB(

					"\'.date(\'Y-m-d\').\' 00:00:00",

					INTERVAL \'.(Validate::isUnsignedInt(Configuration::get(\'PS_NB_DAYS_NEW_PRODUCT\')) ? Configuration::get(\'PS_NB_DAYS_NEW_PRODUCT\') : 20).\' DAY

				)

			) > 0

		\', true, false);

		return count($result) > 0;

	}



	public function productAttributeExists($attributes_list, $current_product_attribute = false, Context $context = null, $all_shops = false, $return_id = false)

	{

		if (!Combination::isFeatureActive())

			return false;

		if ($context === null)

			$context = Context::getContext();

		$result = Db::getInstance()->executeS(

			\'SELECT pac.`id_attribute`, pac.`id_product_attribute`

			FROM `\'._DB_PREFIX_.\'product_attribute` pa

			JOIN `\'._DB_PREFIX_.\'product_attribute_shop` pas ON (pas.id_product_attribute = pa.id_product_attribute)

			LEFT JOIN `\'._DB_PREFIX_.\'product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)

			WHERE 1 \'.(!$all_shops ? \' AND pas.id_shop =\'.(int)$context->shop->id : \'\').\' AND pa.`id_product` = \'.(int)$this->id.

			($all_shops ? \' GROUP BY pac.id_attribute, pac.id_product_attribute \' : \'\')

		);



		/* If something\'s wrong */

		if (!$result || empty($result))

			return false;

		/* Product attributes simulation */

		$product_attributes = array();

		foreach ($result as $product_attribute)

			$product_attributes[$product_attribute[\'id_product_attribute\']][] = $product_attribute[\'id_attribute\'];

		/* Checking product\'s attribute existence */

		foreach ($product_attributes as $key => $product_attribute)

			if (count($product_attribute) == count($attributes_list))

			{

				$diff = false;

				for ($i = 0; $diff == false && isset($product_attribute[$i]); $i++)

					if (!in_array($product_attribute[$i], $attributes_list) || $key == $current_product_attribute)

						$diff = true;

				if (!$diff)

				{

					if ($return_id)

						return $key;

					return true;

				}

			}



		return false;

	}



	/**

	 * addProductAttribute is deprecated

	 *

	 * The quantity params now set StockAvailable for the current shop with the specified quantity

	 * The supplier_reference params now set the supplier reference of the default supplier of the product if possible

	 *

	 * @see StockManager if you want to manage real stock

	 * @see StockAvailable if you want to manage available quantities for sale on your shop(s)

	 * @see ProductSupplier for manage supplier reference(s)

	 *

	 * @deprecated since 1.5.0

	 */

	public function addProductAttribute($price, $weight, $unit_impact, $ecotax, $quantity, $id_images, $reference,

		$id_supplier = null, $ean13, $default, $location = null, $upc = null, $minimal_quantity = 1)

	{

		Tools::displayAsDeprecated();



		$id_product_attribute = $this->addAttribute(

			$price, $weight, $unit_impact, $ecotax, $id_images,

			$reference, $ean13, $default, $location, $upc, $minimal_quantity

		);



		if (!$id_product_attribute)

			return false;



		StockAvailable::setQuantity($this->id, $id_product_attribute, $quantity);

		//Try to set the default supplier reference

		$this->addSupplierReference($id_supplier, $id_product_attribute);

		return $id_product_attribute;

	}



	public function generateMultipleCombinations($combinations, $attributes)

	{

		$res = true;

		$default_on = 1;

		foreach ($combinations as $key => $combination)

		{

			$id_combination = (int)$this->productAttributeExists($attributes[$key], false, null, true, true);

			$obj = new Combination($id_combination);



			if ($id_combination)

			{

				$obj->minimal_quantity = 1;

				$obj->available_date = \'0000-00-00\';

			}



			foreach ($combination as $field => $value)

				$obj->$field = $value;



			$obj->default_on = $default_on;

			$default_on = 0;

			$this->setAvailableDate();



			$obj->save();



			if (!$id_combination)

			{

				$attribute_list = array();

				foreach ($attributes[$key] as $id_attribute)

					$attribute_list[] = array(

						\'id_product_attribute\' => (int)$obj->id,

						\'id_attribute\' => (int)$id_attribute

					);

				$res &= Db::getInstance()->insert(\'product_attribute_combination\', $attribute_list);

			}

		}



		return $res;

	}



	/**

	* @param int $quantity DEPRECATED

	* @param string $supplier_reference DEPRECATED

	*/

	public function addCombinationEntity($wholesale_price, $price, $weight, $unit_impact, $ecotax, $quantity,

		$id_images, $reference, $id_supplier, $ean13, $default, $location = null, $upc = null, $minimal_quantity = 1, array $id_shop_list = array(), $available_date = null)

	{

		$id_product_attribute = $this->addAttribute(

			$price, $weight, $unit_impact, $ecotax, $id_images,

			$reference, $ean13, $default, $location, $upc, $minimal_quantity, $id_shop_list, $available_date);

		$this->addSupplierReference($id_supplier, $id_product_attribute);

		$result = ObjectModel::updateMultishopTable(\'Combination\', array(

			\'wholesale_price\' => (float)$wholesale_price,

		), \'a.id_product_attribute = \'.(int)$id_product_attribute);



		if (!$id_product_attribute || !$result)

			return false;



		return $id_product_attribute;

	}



	/**

	 * @deprecated 1.5.5.0

	 * @param $attributes

	 * @param bool $set_default

	 * @return array

	 */

	public function addProductAttributeMultiple($attributes, $set_default = true)

	{

		Tools::displayAsDeprecated();

		$return = array();

		$default_value = 1;

		foreach ($attributes as &$attribute)

		{

			$obj = new Combination();

			foreach ($attribute as $key => $value)

				$obj->$key = $value;



			if ($set_default)

			{

				$obj->default_on = $default_value;

				$default_value = 0;

				// if we add a combination for this shop and this product does not use the combination feature in other shop,

				// we clone the default combination in every shop linked to this product

				if (!$this->hasAttributesInOtherShops())

				{

					$id_shop_list_array = Product::getShopsByProduct($this->id);

					$id_shop_list = array();

					foreach ($id_shop_list_array as $array_shop)

						$id_shop_list[] = $array_shop[\'id_shop\'];

					$obj->id_shop_list = $id_shop_list;

				}

			}

			$obj->add();

			$return[] = $obj->id;

		}



		return $return;

	}



	/**

	* Del all default attributes for product

	*/

	public function deleteDefaultAttributes()

	{

		return ObjectModel::updateMultishopTable(\'Combination\', array(

			\'default_on\' => null,

		), \'a.`id_product` = \'.(int)$this->id);

	}



	public function setDefaultAttribute($id_product_attribute)

	{

		$result = ObjectModel::updateMultishopTable(\'Combination\', array(

			\'default_on\' => 1

		), \'a.`id_product` = \'.(int)$this->id.\' AND a.`id_product_attribute` = \'.(int)$id_product_attribute);



		$result &= ObjectModel::updateMultishopTable(\'product\', array(

			\'cache_default_attribute\' => (int)$id_product_attribute,

		), \'a.`id_product` = \'.(int)$this->id);

		$this->cache_default_attribute = (int)$id_product_attribute;

		return $result;

	}



	public static function updateDefaultAttribute($id_product)

	{

		$id_default_attribute = (int)Product::getDefaultAttribute($id_product);



		$result = Db::getInstance()->update(\'product_shop\', array(

			\'cache_default_attribute\' => $id_default_attribute,

		), \'id_product = \'.(int)$id_product.Shop::addSqlRestriction());



		$result &= Db::getInstance()->update(\'product\', array(

			\'cache_default_attribute\' => $id_default_attribute,

		), \'id_product = \'.(int)$id_product);



		if ($result && $id_default_attribute)

			return $id_default_attribute;

		else

			return $result;

	}



	/**

	* Update a product attribute

	*

	* @deprecated since 1.5

	* @see updateAttribute() to use instead

	* @see ProductSupplier for manage supplier reference(s)

	*

	*/

	public function updateProductAttribute($id_product_attribute, $wholesale_price, $price, $weight, $unit, $ecotax,

		$id_images, $reference, $id_supplier = null, $ean13, $default, $location = null, $upc = null, $minimal_quantity, $available_date)

	{

		Tools::displayAsDeprecated();



		$return = $this->updateAttribute(

			$id_product_attribute, $wholesale_price, $price, $weight, $unit, $ecotax,

			$id_images, $reference, $ean13, $default, $location = null, $upc = null, $minimal_quantity, $available_date

		);

		$this->addSupplierReference($id_supplier, $id_product_attribute);



		return $return;

	}



	/**

	 * Sets or updates Supplier Reference

	 *

	 * @param int $id_supplier

	 * @param int $id_product_attribute

	 * @param string $supplier_reference

	 * @param float $price

	 * @param int $id_currency

	 */

	public function addSupplierReference($id_supplier, $id_product_attribute, $supplier_reference = null, $price = null, $id_currency = null)

	{

		//in some case we need to add price without supplier reference

		if ($supplier_reference === null)

			$supplier_reference = \'\';



		//Try to set the default supplier reference

		if (($id_supplier > 0) && ($this->id > 0))

		{

			$id_product_supplier = (int)ProductSupplier::getIdByProductAndSupplier($this->id, $id_product_attribute, $id_supplier);



			$product_supplier = new ProductSupplier($id_product_supplier);



			if (!$id_product_supplier)

			{

				$product_supplier->id_product = (int)$this->id;

				$product_supplier->id_product_attribute = (int)$id_product_attribute;

				$product_supplier->id_supplier = (int)$id_supplier;

			}



			$product_supplier->product_supplier_reference = pSQL($supplier_reference);

			$product_supplier->product_supplier_price_te = !is_null($price) ? (float)$price : (float)$product_supplier->product_supplier_price_te;

			$product_supplier->id_currency = !is_null($id_currency) ? (int)$id_currency : (int)$product_supplier->id_currency;

			$product_supplier->save();

		}

	}



	/**

	* Update a product attribute

	*

	* @param int $id_product_attribute Product attribute id

	* @param float $wholesale_price Wholesale price

	* @param float $price Additional price

	* @param float $weight Additional weight

	* @param float $unit

	* @param float $ecotax Additional ecotax

	* @param int $id_image Image id

	* @param string $reference Reference

	* @param string $ean13 Ean-13 barcode

	* @param int $default Default On

	* @param string $upc Upc barcode

	* @param string $minimal_quantity Minimal quantity

	* @return array Update result

	*/

	public function updateAttribute($id_product_attribute, $wholesale_price, $price, $weight, $unit, $ecotax,

		$id_images, $reference, $ean13, $default, $location = null, $upc = null, $minimal_quantity = null, $available_date = null, $update_all_fields = true, array $id_shop_list = array())

	{

		$combination = new Combination($id_product_attribute);



		if (!$update_all_fields)

			$combination->setFieldsToUpdate(array(

				\'price\' => !is_null($price),

				\'wholesale_price\' => !is_null($wholesale_price),

				\'ecotax\' => !is_null($ecotax),

				\'weight\' => !is_null($weight),

				\'unit_price_impact\' => !is_null($unit),

				\'default_on\' => !is_null($default),

				\'minimal_quantity\' => !is_null($minimal_quantity),

				\'available_date\' => !is_null($available_date),

			));



		$price = str_replace(\',\', \'.\', $price);

		$weight = str_replace(\',\', \'.\', $weight);



		$combination->price = (float)$price;

		$combination->wholesale_price = (float)$wholesale_price;

		$combination->ecotax = (float)$ecotax;

		$combination->weight = (float)$weight;

		$combination->unit_price_impact = (float)$unit;

		$combination->reference = pSQL($reference);

		$combination->location = pSQL($location);

		$combination->ean13 = pSQL($ean13);

		$combination->upc = pSQL($upc);

		$combination->default_on = (int)$default;

		$combination->minimal_quantity = (int)$minimal_quantity;

		$combination->available_date = $available_date ? pSQL($available_date) : \'0000-00-00\';



		if (count($id_shop_list))

			$combination->id_shop_list = $id_shop_list;



		$combination->save();



		if (is_array($id_images) && count($id_images))

			$combination->setImages($id_images);



		$id_default_attribute = (int)Product::updateDefaultAttribute($this->id);

		if ($id_default_attribute)

			$this->cache_default_attribute = $id_default_attribute;



		// Sync stock Reference, EAN13 and UPC for this attribute

		if (Configuration::get(\'PS_ADVANCED_STOCK_MANAGEMENT\') && StockAvailable::dependsOnStock($this->id, Context::getContext()->shop->id))

			Db::getInstance()->update(\'stock\', array(

				\'reference\' => pSQL($reference),

				\'ean13\'     => pSQL($ean13),

				\'upc\'		=> pSQL($upc),

			), \'id_product = \'.$this->id.\' AND id_product_attribute = \'.(int)$id_product_attribute);



		Hook::exec(\'actionProductAttributeUpdate\', array(\'id_product_attribute\' => (int)$id_product_attribute));

		Tools::clearColorListCache($this->id);



		return true;

	}



	/**

	 * Add a product attribute

	 * @since 1.5.0.1

	 *

	 * @param float $price Additional price

	 * @param float $weight Additional weight

	 * @param float $ecotax Additional ecotax

	 * @param int $id_images Image ids

	 * @param string $reference Reference

	 * @param string $location Location

	 * @param string $ean13 Ean-13 barcode

	 * @param bool $default Is default attribute for product

	 * @param int $minimal_quantity Minimal quantity to add to cart

	 * @return mixed $id_product_attribute or false

	 */

	public function addAttribute($price, $weight, $unit_impact, $ecotax, $id_images, $reference, $ean13,

								 $default, $location = null, $upc = null, $minimal_quantity = 1, array $id_shop_list = array(), $available_date = null)

	{

		if (!$this->id)

			return;



		$price = str_replace(\',\', \'.\', $price);

		$weight = str_replace(\',\', \'.\', $weight);



		$combination = new Combination();

		$combination->id_product = (int)$this->id;

		$combination->price = (float)$price;

		$combination->ecotax = (float)$ecotax;

		$combination->quantity = 0;

		$combination->weight = (float)$weight;

		$combination->unit_price_impact = (float)$unit_impact;

		$combination->reference = pSQL($reference);

		$combination->location = pSQL($location);

		$combination->ean13 = pSQL($ean13);

		$combination->upc = pSQL($upc);

		$combination->default_on = (int)$default;

		$combination->minimal_quantity = (int)$minimal_quantity;

		$combination->available_date = $available_date;



		if (count($id_shop_list))

			$combination->id_shop_list = array_unique($id_shop_list);



		$combination->add();



		if (!$combination->id)

			return false;



		$total_quantity = (int)Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue(\'

			SELECT SUM(quantity) as quantity

			FROM \'._DB_PREFIX_.\'stock_available

			WHERE id_product = \'.(int)$this->id.\'

			AND id_product_attribute <> 0 \'

		);



		if (!$total_quantity)

			Db::getInstance()->update(\'stock_available\', array(\'quantity\' => 0), \'`id_product` = \'.$this->id);



		$id_default_attribute = Product::updateDefaultAttribute($this->id);



		if ($id_default_attribute)

		{

			$this->cache_default_attribute = $id_default_attribute;

			if (!$combination->available_date)

				$this->setAvailableDate();

		}



		if (!empty($id_images))

			$combination->setImages($id_images);



		Tools::clearColorListCache($this->id);



		if (Configuration::get(\'PS_DEFAULT_WAREHOUSE_NEW_PRODUCT\') != 0 && Configuration::get(\'PS_ADVANCED_STOCK_MANAGEMENT\'))

		{

			$warehouse_location_entity = new WarehouseProductLocation();

			$warehouse_location_entity->id_product = $this->id;

			$warehouse_location_entity->id_product_attribute = (int)$combination->id;

			$warehouse_location_entity->id_warehouse = Configuration::get(\'PS_DEFAULT_WAREHOUSE_NEW_PRODUCT\');

			$warehouse_location_entity->location = pSQL(\'\');

			$warehouse_location_entity->save();

		}



		return (int)$combination->id;

	}





	/**

	 * @deprecated since 1.5.0

	 */

	public function updateQuantityProductWithAttributeQuantity()

	{

		Tools::displayAsDeprecated();



		return Db::getInstance()->execute(\'

		UPDATE `\'._DB_PREFIX_.\'product`

		SET `quantity` = IFNULL(

		(

			SELECT SUM(`quantity`)

			FROM `\'._DB_PREFIX_.\'product_attribute`

			WHERE `id_product` = \'.(int)$this->id.\'

		), \'0\')

		WHERE `id_product` = \'.(int)$this->id);

	}

	/**

	* Delete product attributes

	*

	* @return array Deletion result

	*/

	public function deleteProductAttributes()

	{

		Hook::exec(\'actionProductAttributeDelete\', array(\'id_product_attribute\' => 0, \'id_product\' => (int)$this->id, \'deleteAllAttributes\' => true));



		$result = true;

		$combinations = new PrestaShopCollection(\'Combination\');

		$combinations->where(\'id_product\', \'=\', $this->id);

		foreach ($combinations as $combination)

			$result &= $combination->delete();

		SpecificPriceRule::applyAllRules(array((int)$this->id));

		Tools::clearColorListCache($this->id);

		return $result;

	}



	/**

	 * Delete product attributes impacts

	 *

	 * @return bool

	 */

	public function deleteAttributesImpacts()

	{

		return Db::getInstance()->execute(

			\'DELETE FROM `\'._DB_PREFIX_.\'attribute_impact`

			WHERE `id_product` = \'.(int)$this->id

		);

	}



	/**

	* Delete product features

	*

	* @return array Deletion result

	*/

	public function deleteProductFeatures()

	{

		SpecificPriceRule::applyAllRules(array((int)$this->id));

		return $this->deleteFeatures();

	}





	public static function updateCacheAttachment($id_product)

	{

		$value = (bool)Db::getInstance()->getValue(\'

								SELECT id_attachment

								FROM \'._DB_PREFIX_.\'product_attachment

								WHERE id_product=\'.(int)$id_product);

		return Db::getInstance()->update(

						\'product\',

						array(\'cache_has_attachments\' => (int)$value),

						\'id_product = \'.(int)$id_product

					);

	}



	/**

	* Delete product attachments

	*

	* @param bool $update_cache If set to true attachment cache will be updated

	* @return array Deletion result

	*/

	public function deleteAttachments($update_attachment_cache = true)

	{

		$res = Db::getInstance()->execute(\'

			DELETE FROM `\'._DB_PREFIX_.\'product_attachment`

			WHERE `id_product` = \'.(int)$this->id

		);



		if (isset($update_attachment_cache) && (bool)$update_attachment_cache === true)

			Product::updateCacheAttachment((int)$this->id);



		return $res;

	}



	/**

	* Delete product customizations

	*

	* @return array Deletion result

	*/

	public function deleteCustomization()

	{

		return (

			Db::getInstance()->execute(

				\'DELETE FROM `\'._DB_PREFIX_.\'customization_field`

				WHERE `id_product` = \'.(int)$this->id

			)

			&&

			Db::getInstance()->execute(

				\'DELETE `\'._DB_PREFIX_.\'customization_field_lang` FROM `\'._DB_PREFIX_.\'customization_field_lang` LEFT JOIN `\'._DB_PREFIX_.\'customization_field`

				ON (\'._DB_PREFIX_.\'customization_field.id_customization_field = \'._DB_PREFIX_.\'customization_field_lang.id_customization_field)

				WHERE \'._DB_PREFIX_.\'customization_field.id_customization_field IS NULL\'

			)

		);

	}



	/**

	* Delete product pack details

	*

	* @return array Deletion result

	*/

	public function deletePack()

	{

		return Db::getInstance()->execute(

			\'DELETE FROM `\'._DB_PREFIX_.\'pack`

			WHERE `id_product_pack` = \'.(int)$this->id.\'

			OR `id_product_item` = \'.(int)$this->id

		);

	}



	/**

	* Delete product sales

	*

	* @return array Deletion result

	*/

	public function deleteProductSale()

	{

		return Db::getInstance()->execute(

			\'DELETE FROM `\'._DB_PREFIX_.\'product_sale`

			WHERE `id_product` = \'.(int)$this->id

		);

	}



	/**

	* Delete product in its scenes

	*

	* @return array Deletion result

	*/

	public function deleteSceneProducts()

	{

		return Db::getInstance()->execute(

			\'DELETE FROM `\'._DB_PREFIX_.\'scene_products`

			WHERE `id_product` = \'.(int)$this->id

		);

	}



	/**

	* Delete product indexed words

	*

	* @return array Deletion result

	*/

	public function deleteSearchIndexes()

	{

		return (

			Db::getInstance()->execute(

				\'DELETE `\'._DB_PREFIX_.\'search_index`, `\'._DB_PREFIX_.\'search_word`

				FROM `\'._DB_PREFIX_.\'search_index` JOIN `\'._DB_PREFIX_.\'search_word`

				WHERE `\'._DB_PREFIX_.\'search_index`.`id_product` = \'.(int)$this->id.\'

						AND `\'._DB_PREFIX_.\'search_word`.`id_word` = `\'._DB_PREFIX_.\'search_index`.id_word\'

			)

		);

	}



	/**

	* Add a product attributes combinaison

	*

	* @param int $id_product_attribute Product attribute id

	* @param array $attributes Attributes to forge combinaison

	* @return array Insertion result

	* @deprecated since 1.5.0.7

	*/

	public function addAttributeCombinaison($id_product_attribute, $attributes)

	{

		Tools::displayAsDeprecated();

		if (!is_array($attributes))

			die(Tools::displayError());

		if (!count($attributes))

			return false;



		$combination = new Combination((int)$id_product_attribute);

		return $combination->setAttributes($attributes);

	}



	/**

	 * @deprecated 1.5.5.0

	 * @param $id_attributes

	 * @param $combinations

	 * @return bool

	 * @throws PrestaShopDatabaseException

	 */

	public function addAttributeCombinationMultiple($id_attributes, $combinations)

	{

		Tools::displayAsDeprecated();

		$attributes_list = array();

		foreach ($id_attributes as $nb => $id_product_attribute)

			if (isset($combinations[$nb]))

				foreach ($combinations[$nb] as $id_attribute)

					$attributes_list[] = array(

						\'id_product_attribute\' => (int)$id_product_attribute,

						\'id_attribute\' => (int)$id_attribute,

					);



		return Db::getInstance()->insert(\'product_attribute_combination\', $attributes_list);

	}





	/**

	* Delete a product attributes combination

	*

	* @param int $id_product_attribute Product attribute id

	* @return array Deletion result

	*/

	public function deleteAttributeCombination($id_product_attribute)

	{

		if (!$this->id || !$id_product_attribute || !is_numeric($id_product_attribute))

			return false;



		Hook::exec(

			\'deleteProductAttribute\',

			array(

				\'id_product_attribute\' => $id_product_attribute,

				\'id_product\' => $this->id,

				\'deleteAllAttributes\' => false

			)

		);



		$combination = new Combination($id_product_attribute);

		$res = $combination->delete();

		SpecificPriceRule::applyAllRules(array((int)$this->id));

		return $res;

	}



	/**

	* Delete features

	*

	*/

	public function deleteFeatures()

	{

		// List products features

		$features = Db::getInstance()->executeS(\'

		SELECT p.*, f.*

		FROM `\'._DB_PREFIX_.\'feature_product` as p

		LEFT JOIN `\'._DB_PREFIX_.\'feature_value` as f ON (f.`id_feature_value` = p.`id_feature_value`)

		WHERE `id_product` = \'.(int)$this->id);

		foreach ($features as $tab)

			// Delete product custom features

			if ($tab[\'custom\'])

			{

				Db::getInstance()->execute(\'

				DELETE FROM `\'._DB_PREFIX_.\'feature_value`

				WHERE `id_feature_value` = \'.(int)$tab[\'id_feature_value\']);

				Db::getInstance()->execute(\'

				DELETE FROM `\'._DB_PREFIX_.\'feature_value_lang`

				WHERE `id_feature_value` = \'.(int)$tab[\'id_feature_value\']);

			}

		// Delete product features

		$result = Db::getInstance()->execute(\'

		DELETE FROM `\'._DB_PREFIX_.\'feature_product`

		WHERE `id_product` = \'.(int)$this->id);



		SpecificPriceRule::applyAllRules(array((int)$this->id));

		return ($result);

	}



	/**

	* Get all available product attributes resume

	*

	* @param int $id_lang Language id

	* @return array Product attributes combinations

	*/

	public function getAttributesResume($id_lang, $attribute_value_separator = \' - \', $attribute_separator = \', \')

	{

		if (!Combination::isFeatureActive())

			return array();



		$combinations = Db::getInstance()->executeS(\'SELECT pa.*, product_attribute_shop.*

				FROM `\'._DB_PREFIX_.\'product_attribute` pa

				\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').\'

				WHERE pa.`id_product` = \'.(int)$this->id.\'

				GROUP BY pa.`id_product_attribute`\');



		if (!$combinations)

			return false;



		$product_attributes = array();

		foreach ($combinations as $combination)

			$product_attributes[] = (int)$combination[\'id_product_attribute\'];



		$lang = Db::getInstance()->executeS(\'SELECT pac.id_product_attribute, GROUP_CONCAT(agl.`name`, \'\'.pSQL($attribute_value_separator).\'\',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR \'\'.pSQL($attribute_separator).\'\') as attribute_designation

				FROM `\'._DB_PREFIX_.\'product_attribute_combination` pac

				LEFT JOIN `\'._DB_PREFIX_.\'attribute` a ON a.`id_attribute` = pac.`id_attribute`

				LEFT JOIN `\'._DB_PREFIX_.\'attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`

				LEFT JOIN `\'._DB_PREFIX_.\'attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = \'.(int)$id_lang.\')

				LEFT JOIN `\'._DB_PREFIX_.\'attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = \'.(int)$id_lang.\')

				WHERE pac.id_product_attribute IN (\'.implode(\',\', $product_attributes).\')

				GROUP BY pac.id_product_attribute\');



		foreach ($lang as $k => $row)

			$combinations[$k][\'attribute_designation\'] = $row[\'attribute_designation\'];



		//Get quantity of each variations

		foreach ($combinations as $key => $row)

		{

			$cache_key = $row[\'id_product\'].\'_\'.$row[\'id_product_attribute\'].\'_quantity\';



			if (!Cache::isStored($cache_key))

			{

				$result = StockAvailable::getQuantityAvailableByProduct($row[\'id_product\'], $row[\'id_product_attribute\']);

				Cache::store(

					$cache_key,

					$result

				);

				$combinations[$key][\'quantity\'] = $result;

			}

			else

				$combinations[$key][\'quantity\'] = Cache::retrieve($cache_key);

		}



		return $combinations;

	}



	/**

	* Get all available product attributes combinations

	*

	* @param int $id_lang Language id

	* @return array Product attributes combinations

	*/

	public function getAttributeCombinations($id_lang)

	{

		if (!Combination::isFeatureActive())

			return array();



		$sql = \'SELECT pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,

					a.`id_attribute`

				FROM `\'._DB_PREFIX_.\'product_attribute` pa

				\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').\'

				LEFT JOIN `\'._DB_PREFIX_.\'product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`

				LEFT JOIN `\'._DB_PREFIX_.\'attribute` a ON a.`id_attribute` = pac.`id_attribute`

				LEFT JOIN `\'._DB_PREFIX_.\'attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`

				LEFT JOIN `\'._DB_PREFIX_.\'attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = \'.(int)$id_lang.\')

				LEFT JOIN `\'._DB_PREFIX_.\'attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = \'.(int)$id_lang.\')

				WHERE pa.`id_product` = \'.(int)$this->id.\'

				GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group`

				ORDER BY pa.`id_product_attribute`\';



		$res = Db::getInstance()->executeS($sql);



		//Get quantity of each variations

		foreach ($res as $key => $row)

		{

			$cache_key = $row[\'id_product\'].\'_\'.$row[\'id_product_attribute\'].\'_quantity\';



			if (!Cache::isStored($cache_key))

				Cache::store(

					$cache_key,

					StockAvailable::getQuantityAvailableByProduct($row[\'id_product\'], $row[\'id_product_attribute\'])

				);



			$res[$key][\'quantity\'] = Cache::retrieve($cache_key);

		}



		return $res;

	}



	/**

	* Get product attribute combination by id_product_attribute

	*

	* @param int $id_product_attribute

	* @param int $id_lang Language id

	* @return array Product attribute combination by id_product_attribute

	*/

	public function getAttributeCombinationsById($id_product_attribute, $id_lang)

	{

		if (!Combination::isFeatureActive())

			return array();

		$sql = \'SELECT pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,

					a.`id_attribute`

				FROM `\'._DB_PREFIX_.\'product_attribute` pa

				\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').\'

				LEFT JOIN `\'._DB_PREFIX_.\'product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`

				LEFT JOIN `\'._DB_PREFIX_.\'attribute` a ON a.`id_attribute` = pac.`id_attribute`

				LEFT JOIN `\'._DB_PREFIX_.\'attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`

				LEFT JOIN `\'._DB_PREFIX_.\'attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = \'.(int)$id_lang.\')

				LEFT JOIN `\'._DB_PREFIX_.\'attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = \'.(int)$id_lang.\')

				WHERE pa.`id_product` = \'.(int)$this->id.\'

				AND pa.`id_product_attribute` = \'.(int)$id_product_attribute.\'

				GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group`

				ORDER BY pa.`id_product_attribute`\';



		$res = Db::getInstance()->executeS($sql);



		//Get quantity of each variations

		foreach ($res as $key => $row)

		{

			$cache_key = $row[\'id_product\'].\'_\'.$row[\'id_product_attribute\'].\'_quantity\';



			if (!Cache::isStored($cache_key))

			{

				$result = StockAvailable::getQuantityAvailableByProduct($row[\'id_product\'], $row[\'id_product_attribute\']);

				Cache::store(

					$cache_key,

					$result

				);

				$res[$key][\'quantity\'] = $result;

			}

			else

				$res[$key][\'quantity\'] = Cache::retrieve($cache_key);

		}



		return $res;

	}



	public function getCombinationImages($id_lang)

	{

		if (!Combination::isFeatureActive())

			return false;



		$product_attributes = Db::getInstance()->executeS(

			\'SELECT `id_product_attribute`

			FROM `\'._DB_PREFIX_.\'product_attribute`

			WHERE `id_product` = \'.(int)$this->id

		);



		if (!$product_attributes)

			return false;



		$ids = array();



		foreach ($product_attributes as $product_attribute)

			$ids[] = (int)$product_attribute[\'id_product_attribute\'];



		$result = Db::getInstance()->executeS(\'

			SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend`

			FROM `\'._DB_PREFIX_.\'product_attribute_image` pai

			LEFT JOIN `\'._DB_PREFIX_.\'image_lang` il ON (il.`id_image` = pai.`id_image`)

			LEFT JOIN `\'._DB_PREFIX_.\'image` i ON (i.`id_image` = pai.`id_image`)

			WHERE pai.`id_product_attribute` IN (\'.implode(\', \', $ids).\') AND il.`id_lang` = \'.(int)$id_lang.\' ORDER by i.`position`\'

		);



		if (!$result)

			return false;



		$images = array();



		foreach ($result as $row)

			$images[$row[\'id_product_attribute\']][] = $row;



		return $images;

	}



	public static function getCombinationImageById($id_product_attribute, $id_lang)

	{

		if (!Combination::isFeatureActive() || !$id_product_attribute)

			return false;



		$result = Db::getInstance()->executeS(\'

			SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend`

			FROM `\'._DB_PREFIX_.\'product_attribute_image` pai

			LEFT JOIN `\'._DB_PREFIX_.\'image_lang` il ON (il.`id_image` = pai.`id_image`)

			LEFT JOIN `\'._DB_PREFIX_.\'image` i ON (i.`id_image` = pai.`id_image`)

			WHERE pai.`id_product_attribute` = \'.(int)$id_product_attribute.\' AND il.`id_lang` = \'.(int)$id_lang.\' ORDER by i.`position` LIMIT 1\'

		);



		if (!$result)

			return false;



		return $result[0];

	}



	/**

	* Check if product has attributes combinations

	*

	* @return int Attributes combinations number

	*/

	public function hasAttributes()

	{

		if (!Combination::isFeatureActive())

			return 0;

		return Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue(\'

			SELECT COUNT(*)

			FROM `\'._DB_PREFIX_.\'product_attribute` pa

			\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').\'

			WHERE pa.`id_product` = \'.(int)$this->id

		);

	}



	/**

	* Get new products

	*

	* @param int $id_lang Language id

	* @param int $pageNumber Start from (optional)

	* @param int $nbProducts Number of products to return (optional)

	* @return array New products

	*/

	public static function getNewProducts($id_lang, $page_number = 0, $nb_products = 10, $count = false, $order_by = null, $order_way = null, Context $context = null)

	{

		if (!$context)

			$context = Context::getContext();



		$front = true;

		if (!in_array($context->controller->controller_type, array(\'front\', \'modulefront\')))

			$front = false;



		if ($page_number < 0) $page_number = 0;

		if ($nb_products < 1) $nb_products = 10; if (empty($order_by) || $order_by == \'position\') $order_by = \'date_add\'; if (empty($order_way)) $order_way = \'DESC\'; if ($order_by == \'id_product\' || $order_by == \'price\' || $order_by == \'date_add\' || $order_by == \'date_upd\') $order_by_prefix = \'p\'; elseif ($order_by == \'name\') $order_by_prefix = \'pl\'; if (!Validate::isOrderBy($order_by) || !Validate::isOrderWay($order_way)) die(Tools::displayError()); $sql_groups = \'\'; if (Group::isFeatureActive()) { $groups = FrontController::getCurrentCustomerGroups(); $sql_groups = \' AND EXISTS(SELECT 1 FROM `\'._DB_PREFIX_.\'category_product` cp JOIN `\'._DB_PREFIX_.\'category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` \'.(count($groups) ? \'IN (\'.implode(\',\', $groups).\')\' : \'= 1\').\') WHERE cp.`id_product` = p.`id_product`)\'; } if (strpos($order_by, \'.\') > 0)

		{

			$order_by = explode(\'.\', $order_by);

			$order_by_prefix = $order_by[0];

			$order_by = $order_by[1];

		}



		if ($count)

		{

			$sql = \'SELECT COUNT(p.`id_product`) AS nb

					FROM `\'._DB_PREFIX_.\'product` p

					\'.Shop::addSqlAssociation(\'product\', \'p\').\'

					WHERE product_shop.`active` = 1

					AND product_shop.`date_add` > "\'.date(\'Y-m-d\', strtotime(\'-\'.(Configuration::get(\'PS_NB_DAYS_NEW_PRODUCT\') ? (int)Configuration::get(\'PS_NB_DAYS_NEW_PRODUCT\') : 20).\' DAY\')).\'"

					\'.($front ? \' AND product_shop.`visibility` IN ("both", "catalog")\' : \'\').\'

					\'.$sql_groups;

			return (int)Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($sql);

		}



		$sql = new DbQuery();

		$sql->select(

			\'p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,

			pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name,

			product_shop.`date_add` > "\'.date(\'Y-m-d\', strtotime(\'-\'.(Configuration::get(\'PS_NB_DAYS_NEW_PRODUCT\') ? (int)Configuration::get(\'PS_NB_DAYS_NEW_PRODUCT\') : 20).\' DAY\')).\'" as new\'

		);



		$sql->from(\'product\', \'p\');

		$sql->join(Shop::addSqlAssociation(\'product\', \'p\'));

		$sql->leftJoin(\'product_lang\', \'pl\', \'

			p.`id_product` = pl.`id_product`

			AND pl.`id_lang` = \'.(int)$id_lang.Shop::addSqlRestrictionOnLang(\'pl\')

		);

		$sql->leftJoin(\'image_shop\', \'image_shop\', \'image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=\'.(int)$context->shop->id);

		$sql->leftJoin(\'image_lang\', \'il\', \'image_shop.`id_image` = il.`id_image` AND il.`id_lang` = \'.(int)$id_lang);

		$sql->leftJoin(\'manufacturer\', \'m\', \'m.`id_manufacturer` = p.`id_manufacturer`\');



		$sql->where(\'product_shop.`active` = 1\');

		if ($front)

			$sql->where(\'product_shop.`visibility` IN ("both", "catalog")\');

		$sql->where(\'product_shop.`date_add` > "\'.date(\'Y-m-d\', strtotime(\'-\'.(Configuration::get(\'PS_NB_DAYS_NEW_PRODUCT\') ? (int)Configuration::get(\'PS_NB_DAYS_NEW_PRODUCT\') : 20).\' DAY\')).\'"\');

		if (Group::isFeatureActive())

		{

			$sql->join(\'JOIN \'._DB_PREFIX_.\'category_product cp ON (cp.id_product = p.id_product)\');

			$sql->join(\'JOIN \'._DB_PREFIX_.\'category_group cg ON (cg.id_category = cp.id_category)\');

			$sql->where(\'cg.`id_group` \'.(count($groups) ? \'IN (\'.implode(\',\', $groups).\')\' : \'= 1\'));

		}

		$sql->groupBy(\'product_shop.id_product\');



		$sql->orderBy((isset($order_by_prefix) ? pSQL($order_by_prefix).\'.\' : \'\').\'`\'.pSQL($order_by).\'` \'.pSQL($order_way));

		$sql->limit($nb_products, $page_number * $nb_products);



		if (Combination::isFeatureActive())

		{

			$sql->select(\'product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute\');

			$sql->leftJoin(\'product_attribute_shop\', \'product_attribute_shop\', \'p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=\'.(int)$context->shop->id);

		}

		$sql->join(Product::sqlStock(\'p\', 0));



		$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);



		if ($order_by == \'price\')

			Tools::orderbyPrice($result, $order_way);

		if (!$result)

			return false;



		$products_ids = array();

		foreach ($result as $row)

			$products_ids[] = $row[\'id_product\'];

		// Thus you can avoid one query per product, because there will be only one query for all the products of the cart

		Product::cacheFrontFeatures($products_ids, $id_lang);

		return Product::getProductsProperties((int)$id_lang, $result);

	}



	protected static function _getProductIdByDate($beginning, $ending, Context $context = null, $with_combination = false)

	{

		if (!$context)

			$context = Context::getContext();



		$id_address = $context->cart->{Configuration::get(\'PS_TAX_ADDRESS_TYPE\')};

		$ids = Address::getCountryAndState($id_address);

		$id_country = $ids[\'id_country\'] ? (int)$ids[\'id_country\'] : (int)Configuration::get(\'PS_COUNTRY_DEFAULT\');



		return SpecificPrice::getProductIdByDate(

			$context->shop->id,

			$context->currency->id,

			$id_country,

			$context->customer->id_default_group,

			$beginning,

			$ending,

			0,

			$with_combination

		);

	}



	/**

	* Get a random special

	*

	* @param int $id_lang Language id

	* @return array Special

	*/

	public static function getRandomSpecial($id_lang, $beginning = false, $ending = false, Context $context = null)

	{

		if (!$context)

			$context = Context::getContext();



		$front = true;

		if (!in_array($context->controller->controller_type, array(\'front\', \'modulefront\')))

			$front = false;



		$current_date = date(\'Y-m-d H:i:s\');

		$product_reductions = Product::_getProductIdByDate((!$beginning ? $current_date : $beginning), (!$ending ? $current_date : $ending), $context, true);



		if ($product_reductions)

		{

			$ids_products = \'\';

			foreach ($product_reductions as $product_reduction)

				$ids_products .= \'(\'.(int)$product_reduction[\'id_product\'].\',\'.($product_reduction[\'id_product_attribute\'] ? (int)$product_reduction[\'id_product_attribute\'] :\'0\').\'),\';



			$ids_products = rtrim($ids_products, \',\');

			Db::getInstance(_PS_USE_SQL_SLAVE_)->execute(\'CREATE TEMPORARY TABLE `\'._DB_PREFIX_.\'product_reductions` (id_product INT UNSIGNED NOT NULL DEFAULT 0, id_product_attribute INT UNSIGNED NOT NULL DEFAULT 0) ENGINE=MEMORY\', false);

			if ($ids_products)

				Db::getInstance(_PS_USE_SQL_SLAVE_)->execute(\'INSERT INTO `\'._DB_PREFIX_.\'product_reductions` VALUES \'.$ids_products, false);



			$groups = FrontController::getCurrentCustomerGroups();

			$sql_groups = \' AND EXISTS(SELECT 1 FROM `\'._DB_PREFIX_.\'category_product` cp

				JOIN `\'._DB_PREFIX_.\'category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` \'.(count($groups) ? \'IN (\'.implode(\',\', $groups).\')\' : \'= 1\').\')

				WHERE cp.`id_product` = p.`id_product`)\';



			// Please keep 2 distinct queries because RAND() is an awful way to achieve this result

			$sql = \'SELECT product_shop.id_product, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute

					FROM

					`\'._DB_PREFIX_.\'product_reductions` pr,

					`\'._DB_PREFIX_.\'product` p

					\'.Shop::addSqlAssociation(\'product\', \'p\').\'

					LEFT JOIN `\'._DB_PREFIX_.\'product_attribute_shop` product_attribute_shop

				   		ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=\'.(int)$context->shop->id.\')

					WHERE p.id_product=pr.id_product AND (pr.id_product_attribute = 0 OR product_attribute_shop.id_product_attribute = pr.id_product_attribute) AND product_shop.`active` = 1

						\'.$sql_groups.\'

					\'.($front ? \' AND product_shop.`visibility` IN ("both", "catalog")\' : \'\').\'

					ORDER BY RAND()\';



			$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->getRow($sql);



			if (!$id_product = $result[\'id_product\'])

				return false;



			// no group by needed : there\'s only one attribute with cover=1 for a given id_product + shop

			$sql = \'SELECT p.*, product_shop.*, stock.`out_of_stock` out_of_stock, pl.`description`, pl.`description_short`,

						pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,

						p.`ean13`, p.`upc`, image_shop.`id_image` id_image, il.`legend`,

						DATEDIFF(product_shop.`date_add`, DATE_SUB("\'.date(\'Y-m-d\').\' 00:00:00",

						INTERVAL \'.(Validate::isUnsignedInt(Configuration::get(\'PS_NB_DAYS_NEW_PRODUCT\')) ? Configuration::get(\'PS_NB_DAYS_NEW_PRODUCT\') : 20).\'

							DAY)) > 0 AS new

					FROM `\'._DB_PREFIX_.\'product` p

					LEFT JOIN `\'._DB_PREFIX_.\'product_lang` pl ON (

						p.`id_product` = pl.`id_product`

						AND pl.`id_lang` = \'.(int)$id_lang.Shop::addSqlRestrictionOnLang(\'pl\').\'

					)

					\'.Shop::addSqlAssociation(\'product\', \'p\').\'

					LEFT JOIN `\'._DB_PREFIX_.\'image_shop` image_shop

						ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=\'.(int)$context->shop->id.\')

					LEFT JOIN `\'._DB_PREFIX_.\'image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = \'.(int)$id_lang.\')

					\'.Product::sqlStock(\'p\', 0).\'

					WHERE p.id_product = \'.(int)$id_product;



			$row = Db::getInstance(_PS_USE_SQL_SLAVE_)->getRow($sql);

			if (!$row)

				return false;



			$row[\'id_product_attribute\'] = (int)$result[\'id_product_attribute\'];

			return Product::getProductProperties($id_lang, $row);

		}

		else

			return false;

	}



	/**

	* Get prices drop

	*

	* @param int $id_lang Language id

	* @param int $pageNumber Start from (optional)

	* @param int $nbProducts Number of products to return (optional)

	* @param bool $count Only in order to get total number (optional)

	* @return array Prices drop

	*/

	public static function getPricesDrop($id_lang, $page_number = 0, $nb_products = 10, $count = false,

		$order_by = null, $order_way = null, $beginning = false, $ending = false, Context $context = null)

	{

		if (!Validate::isBool($count))

			die(Tools::displayError());



		if (!$context) $context = Context::getContext();

		if ($page_number < 0) $page_number = 0;

		if ($nb_products < 1) $nb_products = 10; if (empty($order_by) || $order_by == \'position\') $order_by = \'price\'; if (empty($order_way)) $order_way = \'DESC\'; if ($order_by == \'id_product\' || $order_by == \'price\' || $order_by == \'date_add\' || $order_by == \'date_upd\') $order_by_prefix = \'p\'; elseif ($order_by == \'name\') $order_by_prefix = \'pl\'; if (!Validate::isOrderBy($order_by) || !Validate::isOrderWay($order_way)) die (Tools::displayError()); $current_date = date(\'Y-m-d H:i:s\'); $ids_product = Product::_getProductIdByDate((!$beginning ? $current_date : $beginning), (!$ending ? $current_date : $ending), $context); $tab_id_product = array(); foreach ($ids_product as $product) if (is_array($product)) $tab_id_product[] = (int)$product[\'id_product\']; else $tab_id_product[] = (int)$product; $front = true; if (!in_array($context->controller->controller_type, array(\'front\', \'modulefront\')))

			$front = false;



		$sql_groups = \'\';

		if (Group::isFeatureActive())

		{

			$groups = FrontController::getCurrentCustomerGroups();

			$sql_groups = \' AND EXISTS(SELECT 1 FROM `\'._DB_PREFIX_.\'category_product` cp

				JOIN `\'._DB_PREFIX_.\'category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` \'.(count($groups) ? \'IN (\'.implode(\',\', $groups).\')\' : \'= 1\').\')

				WHERE cp.`id_product` = p.`id_product`)\';

		}



		if ($count)

		{

			return Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue(\'

			SELECT COUNT(DISTINCT p.`id_product`)

			FROM `\'._DB_PREFIX_.\'product` p

			\'.Shop::addSqlAssociation(\'product\', \'p\').\'

			WHERE product_shop.`active` = 1

			AND product_shop.`show_price` = 1

			\'.($front ? \' AND product_shop.`visibility` IN ("both", "catalog")\' : \'\').\'

			\'.((!$beginning && !$ending) ? \'AND p.`id_product` IN(\'.((is_array($tab_id_product) && count($tab_id_product)) ? implode(\', \', $tab_id_product) : 0).\')\' : \'\').\'

			\'.$sql_groups);

		}



		if (strpos($order_by, \'.\') > 0)

		{

			$order_by = explode(\'.\', $order_by);

			$order_by = pSQL($order_by[0]).\'.`\'.pSQL($order_by[1]).\'`\';

		}



		$sql = \'

		SELECT

			p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`,

			IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,

			pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`,

			pl.`name`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name,

			DATEDIFF(

				p.`date_add`,

				DATE_SUB(

					"\'.date(\'Y-m-d\').\' 00:00:00",

					INTERVAL \'.(Validate::isUnsignedInt(Configuration::get(\'PS_NB_DAYS_NEW_PRODUCT\')) ? Configuration::get(\'PS_NB_DAYS_NEW_PRODUCT\') : 20).\' DAY

				)

			) > 0 AS new

		FROM `\'._DB_PREFIX_.\'product` p

		\'.Shop::addSqlAssociation(\'product\', \'p\').\'

		LEFT JOIN `\'._DB_PREFIX_.\'product_attribute_shop` product_attribute_shop

			ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=\'.(int)$context->shop->id.\')

		\'.Product::sqlStock(\'p\', 0, false, $context->shop).\'

		LEFT JOIN `\'._DB_PREFIX_.\'product_lang` pl ON (

			p.`id_product` = pl.`id_product`

			AND pl.`id_lang` = \'.(int)$id_lang.Shop::addSqlRestrictionOnLang(\'pl\').\'

		)

		LEFT JOIN `\'._DB_PREFIX_.\'image_shop` image_shop

			ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=\'.(int)$context->shop->id.\')

		LEFT JOIN `\'._DB_PREFIX_.\'image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = \'.(int)$id_lang.\')

		LEFT JOIN `\'._DB_PREFIX_.\'manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)

		WHERE product_shop.`active` = 1

		AND product_shop.`show_price` = 1

		\'.($front ? \' AND p.`visibility` IN ("both", "catalog")\' : \'\').\'

		\'.((!$beginning && !$ending) ? \' AND p.`id_product` IN (\'.((is_array($tab_id_product) && count($tab_id_product)) ? implode(\', \', $tab_id_product) : 0).\')\' : \'\').\'

		\'.$sql_groups.\'

		GROUP BY p.id_product

		ORDER BY \'.(isset($order_by_prefix) ? pSQL($order_by_prefix).\'.\' : \'\').pSQL($order_by).\' \'.pSQL($order_way).\'

		LIMIT \'.(int)($page_number * $nb_products).\', \'.(int)$nb_products;



		$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);



		if (!$result)

			return false;



		if ($order_by == \'price\')

			Tools::orderbyPrice($result, $order_way);



		return Product::getProductsProperties($id_lang, $result);

	}





	/**

	 * getProductCategories return an array of categories which this product belongs to

	 *

	 * @return array of categories

	 */

	public static function getProductCategories($id_product = \'\')

	{

		$cache_id = \'Product::getProductCategories_\'.(int)$id_product;

		if (!Cache::isStored($cache_id))

		{

			$ret = array();



			$row = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(\'

				SELECT `id_category` FROM `\'._DB_PREFIX_.\'category_product`

				WHERE `id_product` = \'.(int)$id_product

			);



			if ($row)

				foreach ($row as $val)

					$ret[] = $val[\'id_category\'];

			Cache::store($cache_id, $ret);

			return $ret;

		}

		return Cache::retrieve($cache_id);

	}



	public static function getProductCategoriesFull($id_product = \'\', $id_lang = null)

	{

		if (!$id_lang)

			$id_lang = Context::getContext()->language->id;



		$ret = array();

		$row = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(\'

			SELECT cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `\'._DB_PREFIX_.\'category_product` cp

			LEFT JOIN `\'._DB_PREFIX_.\'category` c ON (c.id_category = cp.id_category)

			LEFT JOIN `\'._DB_PREFIX_.\'category_lang` cl ON (cp.`id_category` = cl.`id_category`\'.Shop::addSqlRestrictionOnLang(\'cl\').\')

			\'.Shop::addSqlAssociation(\'category\', \'c\').\'

			WHERE cp.`id_product` = \'.(int)$id_product.\'

				AND cl.`id_lang` = \'.(int)$id_lang

		);



		foreach ($row as $val)

			$ret[$val[\'id_category\']] = $val;



		return $ret;

	}



	/**

	 * getCategories return an array of categories which this product belongs to

	 *

	 * @return array of categories

	 */

	public function getCategories()

	{

		return Product::getProductCategories($this->id);

	}



	/**

	 * Gets carriers assigned to the product

	 */

	public function getCarriers()

	{

		return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(\'

			SELECT c.*

			FROM `\'._DB_PREFIX_.\'product_carrier` pc

			INNER JOIN `\'._DB_PREFIX_.\'carrier` c

				ON (c.`id_reference` = pc.`id_carrier_reference` AND c.`deleted` = 0)

			WHERE pc.`id_product` = \'.(int)$this->id.\'

				AND pc.`id_shop` = \'.(int)$this->id_shop);

	}



	/**

	 * Sets carriers assigned to the product

	 */

	public function setCarriers($carrier_list)

	{

		$data = array();



		foreach ($carrier_list as $carrier)

		{

			$data[] = array(

				\'id_product\' => (int)$this->id,

				\'id_carrier_reference\' => (int)$carrier,

				\'id_shop\' => (int)$this->id_shop

			);

		}

		Db::getInstance()->execute(

			\'DELETE FROM `\'._DB_PREFIX_.\'product_carrier`

			WHERE id_product = \'.(int)$this->id.\'

			AND id_shop = \'.(int)$this->id_shop

		);



		$unique_array = array();

		foreach ($data as $sub_array)

			if (!in_array($sub_array, $unique_array))

				$unique_array[] = $sub_array;



		if (count($unique_array))

			Db::getInstance()->insert(\'product_carrier\', $unique_array, false, true, Db::INSERT_IGNORE);

	}



	/**

	* Get product images and legends

	*

	* @param int $id_lang Language id for multilingual legends

	* @return array Product images and legends

	*/

	public function getImages($id_lang, Context $context = null)

	{

		return Db::getInstance()->executeS(\'

			SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`

			FROM `\'._DB_PREFIX_.\'image` i

			\'.Shop::addSqlAssociation(\'image\', \'i\').\'

			LEFT JOIN `\'._DB_PREFIX_.\'image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = \'.(int)$id_lang.\')

			WHERE i.`id_product` = \'.(int)$this->id.\'

			ORDER BY `position`\'

		);

	}



	/**

	* Get product cover image

	*

	* @return array Product cover image

	*/

	public static function getCover($id_product, Context $context = null)

	{

		if (!$context)

			$context = Context::getContext();

		$cache_id = \'Product::getCover_\'.(int)$id_product.\'-\'.(int)$context->shop->id;

		if (!Cache::isStored($cache_id))

		{

			$sql = \'SELECT image_shop.`id_image`

					FROM `\'._DB_PREFIX_.\'image` i

					\'.Shop::addSqlAssociation(\'image\', \'i\').\'

					WHERE i.`id_product` = \'.(int)$id_product.\'

					AND image_shop.`cover` = 1\';

			$result = Db::getInstance()->getRow($sql);

			Cache::store($cache_id, $result);

			return $result;

		}

		return Cache::retrieve($cache_id);

	}



	/**

	 * Returns product price

	 *

	 * @param int      $id_product            Product id

	 * @param bool     $usetax                With taxes or not (optional)

	 * @param int|null $id_product_attribute  Product attribute id (optional).

	 *                                        If set to false, do not apply the combination price impact.

	 *                                        NULL does apply the default combination price impact.

	 * @param int      $decimals              Number of decimals (optional)

	 * @param int|null $divisor               Useful when paying many time without fees (optional)

	 * @param bool     $only_reduc            Returns only the reduction amount

	 * @param bool     $usereduc              Set if the returned amount will include reduction

	 * @param int      $quantity              Required for quantity discount application (default value: 1)

	 * @param bool     $force_associated_tax  DEPRECATED - NOT USED Force to apply the associated tax.

	 *                                        Only works when the parameter $usetax is true

	 * @param int|null $id_customer           Customer ID (for customer group reduction)

	 * @param int|null $id_cart               Cart ID. Required when the cookie is not accessible

	 *                                        (e.g., inside a payment module, a cron task...)

	 * @param int|null $id_address            Customer address ID. Required for price (tax included)

	 *                                        calculation regarding the guest localization

	 * @param null     $specific_price_output If a specific price applies regarding the previous parameters,

	 *                                        this variable is filled with the corresponding SpecificPrice object

	 * @param bool     $with_ecotax           Insert ecotax in price output.

	 * @param bool     $use_group_reduction

	 * @param Context  $context

	 * @param bool     $use_customer_price

	 * @return float                          Product price

	 */

	public static function getPriceStatic($id_product, $usetax = true, $id_product_attribute = null, $decimals = 6, $divisor = null,

		$only_reduc = false, $usereduc = true, $quantity = 1, $force_associated_tax = false, $id_customer = null, $id_cart = null,

		$id_address = null, &$specific_price_output = null, $with_ecotax = true, $use_group_reduction = true, Context $context = null,

		$use_customer_price = true)

	{

		if (!$context)

			$context = Context::getContext();



		$cur_cart = $context->cart;



		if ($divisor !== null)

			Tools::displayParameterAsDeprecated(\'divisor\');



		if (!Validate::isBool($usetax) || !Validate::isUnsignedId($id_product))

			die(Tools::displayError());



		// Initializations

		$id_group = null;

		if ($id_customer)

			$id_group = Customer::getDefaultGroupId((int)$id_customer);

		if (!$id_group)

			$id_group = (int)Group::getCurrent()->id;



		// If there is cart in context or if the specified id_cart is different from the context cart id

		if (!is_object($cur_cart) || (Validate::isUnsignedInt($id_cart) && $id_cart && $cur_cart->id != $id_cart))

		{

			/*

			* When a user (e.g., guest, customer, Google...) is on PrestaShop, he has already its cart as the global (see /init.php)

			* When a non-user calls directly this method (e.g., payment module...) is on PrestaShop, he does not have already it BUT knows the cart ID

			* When called from the back office, cart ID can be inexistant

			*/

			if (!$id_cart && !isset($context->employee))

				die(Tools::displayError());

			$cur_cart = new Cart($id_cart);

			// Store cart in context to avoid multiple instantiations in BO

			if (!Validate::isLoadedObject($context->cart))

				$context->cart = $cur_cart;

		}



		$cart_quantity = 0;

		if ((int)$id_cart)

		{

			$cache_id = \'Product::getPriceStatic_\'.(int)$id_product.\'-\'.(int)$id_cart;

			if (!Cache::isStored($cache_id) || ($cart_quantity = Cache::retrieve($cache_id) != (int)$quantity))

			{

				$sql = \'SELECT SUM(`quantity`)

				FROM `\'._DB_PREFIX_.\'cart_product`

				WHERE `id_product` = \'.(int)$id_product.\'

				AND `id_cart` = \'.(int)$id_cart;

				$cart_quantity = (int)Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($sql);

				Cache::store($cache_id, $cart_quantity);

			}

			else

				$cart_quantity = Cache::retrieve($cache_id);

		}



		$id_currency = Validate::isLoadedObject($context->currency) ? (int)$context->currency->id : (int)Configuration::get(\'PS_CURRENCY_DEFAULT\');



		// retrieve address informations

		$id_country = (int)$context->country->id;

		$id_state = 0;

		$zipcode = 0;



		if (!$id_address && Validate::isLoadedObject($cur_cart))

			$id_address = $cur_cart->{Configuration::get(\'PS_TAX_ADDRESS_TYPE\')};



		if ($id_address)

		{

			$address_infos = Address::getCountryAndState($id_address);

			if ($address_infos[\'id_country\'])

			{

				$id_country = (int)$address_infos[\'id_country\'];

				$id_state = (int)$address_infos[\'id_state\'];

				$zipcode = $address_infos[\'postcode\'];

			}

		}

		elseif (isset($context->customer->geoloc_id_country))

		{

			$id_country = (int)$context->customer->geoloc_id_country;

			$id_state = (int)$context->customer->id_state;

			$zipcode = $context->customer->postcode;

		}



		if (Tax::excludeTaxeOption())

			$usetax = false;



		if ($usetax != false

			&& !empty($address_infos[\'vat_number\'])

			&& $address_infos[\'id_country\'] != Configuration::get(\'VATNUMBER_COUNTRY\')

			&& Configuration::get(\'VATNUMBER_MANAGEMENT\'))

			$usetax = false;



		if (is_null($id_customer) && Validate::isLoadedObject($context->customer))

			$id_customer = $context->customer->id;



		$return = Product::priceCalculation(

			$context->shop->id,

			$id_product,

			$id_product_attribute,

			$id_country,

			$id_state,

			$zipcode,

			$id_currency,

			$id_group,

			$quantity,

			$usetax,

			$decimals,

			$only_reduc,

			$usereduc,

			$with_ecotax,

			$specific_price_output,

			$use_group_reduction,

			$id_customer,

			$use_customer_price,

			$id_cart,

			$cart_quantity

		);



		return $return;

	}



	/**

	 * Price calculation / Get product price

	 *

	 * @param int    $id_shop Shop id

	 * @param int    $id_product Product id

	 * @param int    $id_product_attribute Product attribute id

	 * @param int    $id_country Country id

	 * @param int    $id_state State id

	 * @param string $zipcode

	 * @param int    $id_currency Currency id

	 * @param int    $id_group Group id

	 * @param int    $quantity Quantity Required for Specific prices : quantity discount application

	 * @param bool   $use_tax with (1) or without (0) tax

	 * @param int    $decimals Number of decimals returned

	 * @param bool   $only_reduc Returns only the reduction amount

	 * @param bool   $use_reduc Set if the returned amount will include reduction

	 * @param bool   $with_ecotax insert ecotax in price output.

	 * @param null   $specific_price If a specific price applies regarding the previous parameters,

	 *                               this variable is filled with the corresponding SpecificPrice object

	 * @param bool   $use_group_reduction

	 * @param int    $id_customer

	 * @param bool   $use_customer_price

	 * @param int    $id_cart

	 * @param int    $real_quantity

	 * @return float Product price

	 **/

	public static function priceCalculation($id_shop, $id_product, $id_product_attribute, $id_country, $id_state, $zipcode, $id_currency,

		$id_group, $quantity, $use_tax, $decimals, $only_reduc, $use_reduc, $with_ecotax, &$specific_price, $use_group_reduction,

		$id_customer = 0, $use_customer_price = true, $id_cart = 0, $real_quantity = 0)

	{

		static $address = null;

		static $context = null;



		if ($address === null)

			$address = new Address();



		if ($context == null)

			$context = Context::getContext()->cloneContext();



		if ($id_shop !== null && $context->shop->id != (int)$id_shop)

			$context->shop = new Shop((int)$id_shop);



		if (!$use_customer_price)

			$id_customer = 0;



		if ($id_product_attribute === null)

			$id_product_attribute = Product::getDefaultAttribute($id_product);



		$cache_id = (int)$id_product.\'-\'.(int)$id_shop.\'-\'.(int)$id_currency.\'-\'.(int)$id_country.\'-\'.$id_state.\'-\'.$zipcode.\'-\'.(int)$id_group.

			\'-\'.(int)$quantity.\'-\'.(int)$id_product_attribute.

			\'-\'.(int)$with_ecotax.\'-\'.(int)$id_customer.\'-\'.(int)$use_group_reduction.\'-\'.(int)$id_cart.\'-\'.(int)$real_quantity.

			\'-\'.($only_reduc?\'1\':\'0\').\'-\'.($use_reduc?\'1\':\'0\').\'-\'.($use_tax?\'1\':\'0\').\'-\'.(int)$decimals;



		// reference parameter is filled before any returns

		$specific_price = SpecificPrice::getSpecificPrice(

			(int)$id_product,

			$id_shop,

			$id_currency,

			$id_country,

			$id_group,

			$quantity,

			$id_product_attribute,

			$id_customer,

			$id_cart,

			$real_quantity

		);



		if (isset(self::$_prices[$cache_id]))

			return self::$_prices[$cache_id];



		// fetch price & attribute price

		$cache_id_2 = $id_product.\'-\'.$id_shop;

		if (!isset(self::$_pricesLevel2[$cache_id_2]))

		{

			$sql = new DbQuery();

			$sql->select(\'product_shop.`price`, product_shop.`ecotax`\');

			$sql->from(\'product\', \'p\');

			$sql->innerJoin(\'product_shop\', \'product_shop\', \'(product_shop.id_product=p.id_product AND product_shop.id_shop = \'.(int)$id_shop.\')\');

			$sql->where(\'p.`id_product` = \'.(int)$id_product);

			if (Combination::isFeatureActive())

			{

				$sql->select(\'IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on\');

				$sql->leftJoin(\'product_attribute_shop\', \'product_attribute_shop\', \'(product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = \'.(int)$id_shop.\')\');

			}

			else

				$sql->select(\'0 as id_product_attribute\');



			$res = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);



			if (is_array($res) && count($res))

				foreach ($res as $row)

				{

					$array_tmp = array(

						\'price\' => $row[\'price\'],

						\'ecotax\' => $row[\'ecotax\'],

						\'attribute_price\' => (isset($row[\'attribute_price\']) ? $row[\'attribute_price\'] : null)

					);

					self::$_pricesLevel2[$cache_id_2][(int)$row[\'id_product_attribute\']] = $array_tmp;



					if (isset($row[\'default_on\']) && $row[\'default_on\'] == 1)

						self::$_pricesLevel2[$cache_id_2][0] = $array_tmp;

				}

		}



		if (!isset(self::$_pricesLevel2[$cache_id_2][(int)$id_product_attribute]))

			return;



		$result = self::$_pricesLevel2[$cache_id_2][(int)$id_product_attribute];



		if (!$specific_price || $specific_price[\'price\'] < 0) $price = (float)$result[\'price\']; else $price = (float)$specific_price[\'price\']; // convert only if the specific price is in the default currency (id_currency = 0) if (!$specific_price || !($specific_price[\'price\'] >= 0 && $specific_price[\'id_currency\']))

			$price = Tools::convertPrice($price, $id_currency);



		// Attribute price

		if (is_array($result) && (!$specific_price || !$specific_price[\'id_product_attribute\'] || $specific_price[\'price\'] < 0)) { $attribute_price = Tools::convertPrice($result[\'attribute_price\'] !== null ? (float)$result[\'attribute_price\'] : 0, $id_currency); // If you want the default combination, please use NULL value instead if ($id_product_attribute !== false) $price += $attribute_price; } // Tax $address->id_country = $id_country;

		$address->id_state = $id_state;

		$address->postcode = $zipcode;



		$tax_manager = TaxManagerFactory::getManager($address, Product::getIdTaxRulesGroupByIdProduct((int)$id_product, $context));

		$product_tax_calculator = $tax_manager->getTaxCalculator();



		// Add Tax

		if ($use_tax)

			$price = $product_tax_calculator->addTaxes($price);



		// Eco Tax

		if (($result[\'ecotax\'] || isset($result[\'attribute_ecotax\'])) && $with_ecotax)

		{

			$ecotax = $result[\'ecotax\'];

			if (isset($result[\'attribute_ecotax\']) && $result[\'attribute_ecotax\'] > 0)

				$ecotax = $result[\'attribute_ecotax\'];



			if ($id_currency)

				$ecotax = Tools::convertPrice($ecotax, $id_currency);

			if ($use_tax)

			{

				// reinit the tax manager for ecotax handling

				$tax_manager = TaxManagerFactory::getManager(

					$address,

					(int)Configuration::get(\'PS_ECOTAX_TAX_RULES_GROUP_ID\')

				);

				$ecotax_tax_calculator = $tax_manager->getTaxCalculator();

				$price += $ecotax_tax_calculator->addTaxes($ecotax);

			}

			else

				$price += $ecotax;

		}



		// Reduction

		$specific_price_reduction = 0;

		if (($only_reduc || $use_reduc) && $specific_price)

		{

			if ($specific_price[\'reduction_type\'] == \'amount\')

			{

				$reduction_amount = $specific_price[\'reduction\'];



				if (!$specific_price[\'id_currency\'])

					$reduction_amount = Tools::convertPrice($reduction_amount, $id_currency);



					$specific_price_reduction = $reduction_amount;



					// Adjust taxes if required



					if (!$use_tax && $specific_price[\'reduction_tax\'])

						$specific_price_reduction = $product_tax_calculator->removeTaxes($specific_price_reduction);

					if ($use_tax && !$specific_price[\'reduction_tax\'])

						$specific_price_reduction = $product_tax_calculator->addTaxes($specific_price_reduction);

			}

			else

				$specific_price_reduction = $price * $specific_price[\'reduction\'];

		}



		if ($use_reduc)

			$price -= $specific_price_reduction;



		// Group reduction

		if ($use_group_reduction)

		{

			$reduction_from_category = GroupReduction::getValueForProduct($id_product, $id_group);

			if ($reduction_from_category !== false)

				$group_reduction = $price * (float)$reduction_from_category;

			else // apply group reduction if there is no group reduction for this category

				$group_reduction = (($reduc = Group::getReductionByIdGroup($id_group)) != 0) ? ($price * $reduc / 100) : 0;



			$price -= $group_reduction;

		}



		if ($only_reduc)

			return Tools::ps_round($specific_price_reduction, $decimals);



		$price = Tools::ps_round($price, $decimals);



		if ($price < 0) $price = 0; self::$_prices[$cache_id] = $price; return self::$_prices[$cache_id]; } public static function convertAndFormatPrice($price, $currency = false, Context $context = null) { if (!$context) $context = Context::getContext(); if (!$currency) $currency = $context->currency;

		return Tools::displayPrice(Tools::convertPrice($price, $currency), $currency);

	}



	public static function isDiscounted($id_product, $quantity = 1, Context $context = null)

	{

		if (!$context)

			$context = Context::getContext();



		$id_group = $context->customer->id_default_group;

		$cart_quantity = !$context->cart ? 0 : Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue(\'

			SELECT SUM(`quantity`)

			FROM `\'._DB_PREFIX_.\'cart_product`

			WHERE `id_product` = \'.(int)$id_product.\' AND `id_cart` = \'.(int)$context->cart->id

		);

		$quantity = $cart_quantity ? $cart_quantity : $quantity;



		$id_currency = (int)$context->currency->id;

		$ids = Address::getCountryAndState((int)$context->cart->{Configuration::get(\'PS_TAX_ADDRESS_TYPE\')});

		$id_country = $ids[\'id_country\'] ? (int)$ids[\'id_country\'] : (int)Configuration::get(\'PS_COUNTRY_DEFAULT\');

		return (bool)SpecificPrice::getSpecificPrice((int)$id_product, $context->shop->id, $id_currency, $id_country, $id_group, $quantity, null, 0, 0, $quantity);

	}



	/**

	* Get product price

	* Same as static function getPriceStatic, no need to specify product id

	*

	* @param bool $tax With taxes or not (optional)

	* @param int $id_product_attribute Product attribute id (optional)

	* @param int $decimals Number of decimals (optional)

	* @param int $divisor Util when paying many time without fees (optional)

	* @return float Product price in euros

	*/

	public function getPrice($tax = true, $id_product_attribute = null, $decimals = 6,

		$divisor = null, $only_reduc = false, $usereduc = true, $quantity = 1)

	{

		return Product::getPriceStatic((int)$this->id, $tax, $id_product_attribute, $decimals, $divisor, $only_reduc, $usereduc, $quantity);

	}



	public function getPublicPrice($tax = true, $id_product_attribute = null, $decimals = 6,

			$divisor = null, $only_reduc = false, $usereduc = true, $quantity = 1)

	{

		$specific_price_output = null;

		return Product::getPriceStatic((int)$this->id, $tax, $id_product_attribute, $decimals, $divisor, $only_reduc, $usereduc, $quantity,

			false, null, null, null, $specific_price_output, true, true, null, false);

	}



	public function getIdProductAttributeMostExpensive()

	{

		if (!Combination::isFeatureActive())

			return 0;



		$row = Db::getInstance(_PS_USE_SQL_SLAVE_)->getRow(\'

		SELECT pa.`id_product_attribute`

		FROM `\'._DB_PREFIX_.\'product_attribute` pa

		\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').\'

		WHERE pa.`id_product` = \'.(int)$this->id.\'

		ORDER BY product_attribute_shop.`price` DESC\');



		return (isset($row[\'id_product_attribute\']) && $row[\'id_product_attribute\']) ? (int)$row[\'id_product_attribute\'] : 0;

	}



	public function getDefaultIdProductAttribute()

	{

		if (!Combination::isFeatureActive())

			return 0;



		$row = Db::getInstance(_PS_USE_SQL_SLAVE_)->getRow(\'

			SELECT pa.`id_product_attribute`

			FROM `\'._DB_PREFIX_.\'product_attribute` pa

			\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').\'

			WHERE pa.`id_product` = \'.(int)$this->id.\'

			AND product_attribute_shop.default_on = 1\'

		);



		return (isset($row[\'id_product_attribute\']) && $row[\'id_product_attribute\']) ? (int)$row[\'id_product_attribute\'] : 0;

	}



	public function getPriceWithoutReduct($notax = false, $id_product_attribute = false, $decimals = 6)

	{

		return Product::getPriceStatic((int)$this->id, !$notax, $id_product_attribute, $decimals, null, false, false);

	}



	/**

	* Display price with right format and currency

	*

	* @param array $params Params

	* @param $smarty Smarty object

	* @return string Price with right format and currency

	*/

	public static function convertPrice($params, &$smarty)

	{

		return Tools::displayPrice($params[\'price\'], Context::getContext()->currency);

	}



	/**

	 * Convert price with currency

	 *

	 * @param array $params

	 * @param object $smarty DEPRECATED

	 * @return string Ambigous <string, mixed, Ambigous <number, string>>

	 */

	public static function convertPriceWithCurrency($params, &$smarty)

	{

		return Tools::displayPrice($params[\'price\'], $params[\'currency\'], false);

	}



	public static function displayWtPrice($params, &$smarty)

	{

		return Tools::displayPrice($params[\'p\'], Context::getContext()->currency);

	}



	/**

	 * Display WT price with currency

	 *

	 * @param array $params

	 * @param Smarty $smarty DEPRECATED

	 * @return string Ambigous <string, mixed, Ambigous <number, string>>

	 */

	public static function displayWtPriceWithCurrency($params, &$smarty)

	{

		return Tools::displayPrice($params[\'price\'], $params[\'currency\'], false);

	}



	/**

	* Get available product quantities

	*

	* @param int $id_product Product id

	* @param int $id_product_attribute Product attribute id (optional)

	* @return int Available quantities

	*/

	public static function getQuantity($id_product, $id_product_attribute = null, $cache_is_pack = null)

	{

		if ((int)$cache_is_pack || ($cache_is_pack === null && Pack::isPack((int)$id_product)))

		{

			if (!Pack::isInStock((int)$id_product))

				return 0;

		}



		// @since 1.5.0

		return (StockAvailable::getQuantityAvailableByProduct($id_product, $id_product_attribute));

	}



	/**

	 * Create JOIN query with \'stock_available\' table

	 *

	 * @param string $productAlias Alias of product table

	 * @param string|int $productAttribute If string : alias of PA table ; if int : value of PA ; if null : nothing about PA

	 * @param bool $innerJoin LEFT JOIN or INNER JOIN

	 * @param Shop $shop

	 * @return string

	 */

	public static function sqlStock($product_alias, $product_attribute = null, $inner_join = false, Shop $shop = null)

	{

		$id_shop = ($shop !== null ? (int)$shop->id : null);

		$sql = (($inner_join) ? \' INNER \' : \' LEFT \')

			.\'JOIN \'._DB_PREFIX_.\'stock_available stock

			ON (stock.id_product = \'.pSQL($product_alias).\'.id_product\';



		if (!is_null($product_attribute))

		{

			if (!Combination::isFeatureActive())

				$sql .= \' AND stock.id_product_attribute = 0\';

			elseif (is_numeric($product_attribute))

				$sql .= \' AND stock.id_product_attribute = \'.$product_attribute;

			elseif (is_string($product_attribute))

				$sql .= \' AND stock.id_product_attribute = IFNULL(`\'.bqSQL($product_attribute).\'`.id_product_attribute, 0)\';

		}



		$sql .= StockAvailable::addSqlShopRestriction(null, $id_shop, \'stock\').\' )\';



		return $sql;

	}



	/**

	 * @deprecated since 1.5.0

	 *

	 * It\'s not possible to use this method with new stockManager and stockAvailable features

	 * Now this method do nothing

	 *

	 * @see StockManager if you want to manage real stock

	 * @see StockAvailable if you want to manage available quantities for sale on your shop(s)

	 *

	 * @deprecated 1.5.3.0

	 * @return false

	 */

	public static function updateQuantity()

	{

		Tools::displayAsDeprecated();



		return false;

	}



	/**

	 * @deprecated since 1.5.0

	 *

	 * It\'s not possible to use this method with new stockManager and stockAvailable features

	 * Now this method do nothing

	 *

	 * @deprecated 1.5.3.0

	 * @see StockManager if you want to manage real stock

	 * @see StockAvailable if you want to manage available quantities for sale on your shop(s)

	 * @return false

	 */

	public static function reinjectQuantities()

	{

		Tools::displayAsDeprecated();



		return false;

	}



	public static function isAvailableWhenOutOfStock($out_of_stock)

	{

		// @TODO 1.5.0 Update of STOCK_MANAGEMENT & ORDER_OUT_OF_STOCK

		static $ps_stock_management = null;

		if ($ps_stock_management === null)

			$ps_stock_management = Configuration::get(\'PS_STOCK_MANAGEMENT\');



		if (!$ps_stock_management)

			return true;

		else

		{

			static $ps_order_out_of_stock = null;

			if ($ps_order_out_of_stock === null)

				$ps_order_out_of_stock = Configuration::get(\'PS_ORDER_OUT_OF_STOCK\');



			return (int)$out_of_stock == 2 ? (int)$ps_order_out_of_stock : (int)$out_of_stock;

		}

	}



	/**

	 * Check product availability

	 *

	 * @param int $qty Quantity desired

	 * @return bool True if product is available with this quantity

	 */

	public function checkQty($qty)

	{

		if (Pack::isPack((int)$this->id) && !Pack::isInStock((int)$this->id))

			return false;



		if ($this->isAvailableWhenOutOfStock(StockAvailable::outOfStock($this->id)))

			return true;



		if (isset($this->id_product_attribute))

			$id_product_attribute = $this->id_product_attribute;

		else

			$id_product_attribute = 0;



		return ($qty <= StockAvailable::getQuantityAvailableByProduct($this->id, $id_product_attribute));

	}



	/**

	 * Check if there is no default attribute and create it if not

	 */

	public function checkDefaultAttributes()

	{

		if (!$this->id)

			return false;



		if (Db::getInstance()->getValue(\'SELECT COUNT(*)

				FROM `\'._DB_PREFIX_.\'product_attribute` pa

				\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').\'

				WHERE product_attribute_shop.`default_on` = 1

				AND pa.`id_product` = \'.(int)$this->id) > Shop::getTotalShops(true))

				Db::getInstance()->execute(\'UPDATE \'._DB_PREFIX_.\'product_attribute_shop product_attribute_shop, \'._DB_PREFIX_.\'product_attribute pa

					SET product_attribute_shop.default_on=NULL, pa.default_on = NULL

					WHERE product_attribute_shop.id_product_attribute=pa.id_product_attribute AND pa.id_product=\'.(int)$this->id

					.Shop::addSqlRestriction(false, \'product_attribute_shop\'));



		$row = Db::getInstance()->getRow(\'

			SELECT pa.id_product

			FROM `\'._DB_PREFIX_.\'product_attribute` pa

			\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').\'

			WHERE product_attribute_shop.`default_on` = 1

				AND pa.`id_product` = \'.(int)$this->id

		);

		if ($row)

			return true;



		$mini = Db::getInstance()->getRow(\'

		SELECT MIN(pa.id_product_attribute) as `id_attr`

		FROM `\'._DB_PREFIX_.\'product_attribute` pa

			\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').\'

			WHERE pa.`id_product` = \'.(int)$this->id

		);

		if (!$mini)

			return false;



		if (!ObjectModel::updateMultishopTable(\'Combination\', array(\'default_on\' => 1), \'a.id_product_attribute = \'.(int)$mini[\'id_attr\']))

			return false;

		return true;

	}



	public static function getAttributesColorList(Array $products, $have_stock = true)

	{

		if (!count($products))

			return array();



		$id_lang = Context::getContext()->language->id;



		$check_stock = !Configuration::get(\'PS_DISP_UNAVAILABLE_ATTR\');

		if (!$res = Db::getInstance()->executeS(\'

			SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, \'.($check_stock ? \'SUM(IF(stock.`quantity` > 0, 1, 0))\' : \'0\').\' qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by

			FROM `\'._DB_PREFIX_.\'product_attribute` pa

			\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').

			($check_stock ? Product::sqlStock(\'pa\', \'pa\') : \'\').\'

			JOIN `\'._DB_PREFIX_.\'product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)

			JOIN `\'._DB_PREFIX_.\'attribute` a ON (a.`id_attribute` = pac.`id_attribute`)

			JOIN `\'._DB_PREFIX_.\'attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = \'.(int)$id_lang.\')

			JOIN `\'._DB_PREFIX_.\'attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)

			WHERE pa.`id_product` IN (\'.implode(array_map(\'intval\', $products), \',\').\') AND ag.`is_color_group` = 1

			GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`

			\'.($check_stock ? \'HAVING qty > 0\' : \'\').\'

			ORDER BY a.`position` ASC;\'

			)

		)

			return false;



		$colors = array();

		foreach ($res as $row)

		{

			if (Tools::isEmpty($row[\'color\']) && !@filemtime(_PS_COL_IMG_DIR_.$row[\'id_attribute\'].\'.jpg\'))

				continue;



			$colors[(int)$row[\'id_product\']][] = array(\'id_product_attribute\' => (int)$row[\'id_product_attribute\'], \'color\' => $row[\'color\'], \'id_product\' => $row[\'id_product\'], \'name\' => $row[\'name\'], \'id_attribute\' => $row[\'id_attribute\']);

		}



		return $colors;

	}



	/**

	 * Get all available attribute groups

	 *

	 * @param int $id_lang Language id

	 * @return array Attribute groups

	 */

	public function getAttributesGroups($id_lang)

	{

		if (!Combination::isFeatureActive())

			return array();

		$sql = \'SELECT ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,

					a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,

					IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,

					product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,

					product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`

				FROM `\'._DB_PREFIX_.\'product_attribute` pa

				\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').\'

				\'.Product::sqlStock(\'pa\', \'pa\').\'

				LEFT JOIN `\'._DB_PREFIX_.\'product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)

				LEFT JOIN `\'._DB_PREFIX_.\'attribute` a ON (a.`id_attribute` = pac.`id_attribute`)

				LEFT JOIN `\'._DB_PREFIX_.\'attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)

				LEFT JOIN `\'._DB_PREFIX_.\'attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)

				LEFT JOIN `\'._DB_PREFIX_.\'attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)

				\'.Shop::addSqlAssociation(\'attribute\', \'a\').\'

				WHERE pa.`id_product` = \'.(int)$this->id.\'

					AND al.`id_lang` = \'.(int)$id_lang.\'

					AND agl.`id_lang` = \'.(int)$id_lang.\'

				GROUP BY id_attribute_group, id_product_attribute

				ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC\';

		return Db::getInstance()->executeS($sql);

	}



	/**

	 * Delete product accessories

	 *

	 * @return mixed Deletion result

	 */

	public function deleteAccessories()

	{

		return Db::getInstance()->execute(\'DELETE FROM `\'._DB_PREFIX_.\'accessory` WHERE `id_product_1` = \'.(int)$this->id);

	}



	/**

	 * Delete product from other products accessories

	 *

	 * @return mixed Deletion result

	 */

	public function deleteFromAccessories()

	{

		return Db::getInstance()->execute(\'DELETE FROM `\'._DB_PREFIX_.\'accessory` WHERE `id_product_2` = \'.(int)$this->id);

	}



	/**

	 * Get product accessories (only names)

	 *

	 * @param int $id_lang Language id

	 * @param int $id_product Product id

	 * @return array Product accessories

	 */

	public static function getAccessoriesLight($id_lang, $id_product)

	{

		return Db::getInstance()->executeS(\'

			SELECT p.`id_product`, p.`reference`, pl.`name`

			FROM `\'._DB_PREFIX_.\'accessory`

			LEFT JOIN `\'._DB_PREFIX_.\'product` p ON (p.`id_product`= `id_product_2`)

			\'.Shop::addSqlAssociation(\'product\', \'p\').\'

			LEFT JOIN `\'._DB_PREFIX_.\'product_lang` pl ON (

				p.`id_product` = pl.`id_product`

				AND pl.`id_lang` = \'.(int)$id_lang.Shop::addSqlRestrictionOnLang(\'pl\').\'

			)

			WHERE `id_product_1` = \'.(int)$id_product

		);

	}



	/**

	 * Get product accessories

	 *

	 * @param int $id_lang Language id

	 * @return array Product accessories

	 */

	public function getAccessories($id_lang, $active = true)

	{

		$sql = \'SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,

					pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,

					image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,

					DATEDIFF(

						p.`date_add`,

						DATE_SUB(

							"\'.date(\'Y-m-d\').\' 00:00:00",

							INTERVAL \'.(Validate::isUnsignedInt(Configuration::get(\'PS_NB_DAYS_NEW_PRODUCT\')) ? Configuration::get(\'PS_NB_DAYS_NEW_PRODUCT\') : 20).\' DAY

						)

					) > 0 AS new

				FROM `\'._DB_PREFIX_.\'accessory`

				LEFT JOIN `\'._DB_PREFIX_.\'product` p ON p.`id_product` = `id_product_2`

				\'.Shop::addSqlAssociation(\'product\', \'p\').\'

				LEFT JOIN `\'._DB_PREFIX_.\'product_attribute_shop` product_attribute_shop

					ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=\'.(int)$this->id_shop.\')

				LEFT JOIN `\'._DB_PREFIX_.\'product_lang` pl ON (

					p.`id_product` = pl.`id_product`

					AND pl.`id_lang` = \'.(int)$id_lang.Shop::addSqlRestrictionOnLang(\'pl\').\'

				)

				LEFT JOIN `\'._DB_PREFIX_.\'category_lang` cl ON (

					product_shop.`id_category_default` = cl.`id_category`

					AND cl.`id_lang` = \'.(int)$id_lang.Shop::addSqlRestrictionOnLang(\'cl\').\'

				)

				LEFT JOIN `\'._DB_PREFIX_.\'image_shop` image_shop

					ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=\'.(int)$this->id_shop.\')

				LEFT JOIN `\'._DB_PREFIX_.\'image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = \'.(int)$id_lang.\')

				LEFT JOIN `\'._DB_PREFIX_.\'manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)

				\'.Product::sqlStock(\'p\', 0).\'

				WHERE `id_product_1` = \'.(int)$this->id.

				($active ? \' AND product_shop.`active` = 1 AND product_shop.`visibility` != \'none\'\' : \'\').\'

				GROUP BY product_shop.id_product\';



		if (!$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql))

			return false;



		foreach ($result as &$row)

			$row[\'id_product_attribute\'] = Product::getDefaultAttribute((int)$row[\'id_product\']);



		return $this->getProductsProperties($id_lang, $result);

	}



	public static function getAccessoryById($accessory_id)

	{

		return Db::getInstance()->getRow(\'SELECT `id_product`, `name` FROM `\'._DB_PREFIX_.\'product_lang` WHERE `id_product` = \'.(int)$accessory_id);

	}



	/**

	 * Link accessories with product

	 *

	 * @param array $accessories_id Accessories ids

	 */

	public function changeAccessories($accessories_id)

	{

		foreach ($accessories_id as $id_product_2)

			Db::getInstance()->insert(\'accessory\', array(

				\'id_product_1\' => (int)$this->id,

				\'id_product_2\' => (int)$id_product_2

			));

	}



	/**

	 * Add new feature to product

	 */

	public function addFeaturesCustomToDB($id_value, $lang, $cust)

	{

		$row = array(\'id_feature_value\' => (int)$id_value, \'id_lang\' => (int)$lang, \'value\' => $cust);

		return Db::getInstance()->insert(\'feature_value_lang\', $row);

	}



	public function addFeaturesToDB($id_feature, $id_value, $cust = 0)

	{

		if ($cust)

		{

			$row = array(\'id_feature\' => (int)$id_feature, \'custom\' => 1);

			Db::getInstance()->insert(\'feature_value\', $row);

			$id_value = Db::getInstance()->Insert_ID();

		}

		$row = array(\'id_feature\' => (int)$id_feature, \'id_product\' => (int)$this->id, \'id_feature_value\' => (int)$id_value);

		Db::getInstance()->insert(\'feature_product\', $row);

		SpecificPriceRule::applyAllRules(array((int)$this->id));

		if ($id_value)

			return ($id_value);

	}



	public static function addFeatureProductImport($id_product, $id_feature, $id_feature_value)

	{

		return Db::getInstance()->execute(\'

			INSERT INTO `\'._DB_PREFIX_.\'feature_product` (`id_feature`, `id_product`, `id_feature_value`)

			VALUES (\'.(int)$id_feature.\', \'.(int)$id_product.\', \'.(int)$id_feature_value.\')

			ON DUPLICATE KEY UPDATE `id_feature_value` = \'.(int)$id_feature_value

		);

	}



	/**

	* Select all features for the object

	*

	* @return array Array with feature product\'s data

	*/

	public function getFeatures()

	{

		return Product::getFeaturesStatic((int)$this->id);

	}



	public static function getFeaturesStatic($id_product)

	{

		if (!Feature::isFeatureActive())

			return array();

		if (!array_key_exists($id_product, self::$_cacheFeatures))

			self::$_cacheFeatures[$id_product] = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(\'

				SELECT fp.id_feature, fp.id_product, fp.id_feature_value, custom

				FROM `\'._DB_PREFIX_.\'feature_product` fp

				LEFT JOIN `\'._DB_PREFIX_.\'feature_value` fv ON (fp.id_feature_value = fv.id_feature_value)

				WHERE `id_product` = \'.(int)$id_product

			);

		return self::$_cacheFeatures[$id_product];

	}



	public static function cacheProductsFeatures($product_ids)

	{

		if (!Feature::isFeatureActive())

			return;



		$product_implode = array();

		foreach ($product_ids as $id_product)

			if ((int)$id_product && !array_key_exists($id_product, self::$_cacheFeatures))

				$product_implode[] = (int)$id_product;

		if (!count($product_implode))

			return;



		$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(\'

		SELECT id_feature, id_product, id_feature_value

		FROM `\'._DB_PREFIX_.\'feature_product`

		WHERE `id_product` IN (\'.implode($product_implode, \',\').\')\');

		foreach ($result as $row)

		{

			if (!array_key_exists($row[\'id_product\'], self::$_cacheFeatures))

				self::$_cacheFeatures[$row[\'id_product\']] = array();

			self::$_cacheFeatures[$row[\'id_product\']][] = $row;

		}

	}



	public static function cacheFrontFeatures($product_ids, $id_lang)

	{

		if (!Feature::isFeatureActive())

			return;



		$product_implode = array();

		foreach ($product_ids as $id_product)

			if ((int)$id_product && !array_key_exists($id_product.\'-\'.$id_lang, self::$_cacheFeatures))

				$product_implode[] = (int)$id_product;

		if (!count($product_implode))

			return;



		$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(\'

		SELECT id_product, name, value, pf.id_feature

		FROM \'._DB_PREFIX_.\'feature_product pf

		LEFT JOIN \'._DB_PREFIX_.\'feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = \'.(int)$id_lang.\')

		LEFT JOIN \'._DB_PREFIX_.\'feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = \'.(int)$id_lang.\')

		LEFT JOIN \'._DB_PREFIX_.\'feature f ON (f.id_feature = pf.id_feature)

		\'.Shop::addSqlAssociation(\'feature\', \'f\').\'

		WHERE `id_product` IN (\'.implode($product_implode, \',\').\')

		ORDER BY f.position ASC\');



		foreach ($result as $row)

		{

			if (!array_key_exists($row[\'id_product\'].\'-\'.$id_lang, self::$_frontFeaturesCache))

				self::$_frontFeaturesCache[$row[\'id_product\'].\'-\'.$id_lang] = array();

			if (!isset(self::$_frontFeaturesCache[$row[\'id_product\'].\'-\'.$id_lang][$row[\'id_feature\']]))

				self::$_frontFeaturesCache[$row[\'id_product\'].\'-\'.$id_lang][$row[\'id_feature\']] = $row;

		}

	}



	/**

	* Admin panel product search

	*

	* @param int $id_lang Language id

	* @param string $query Search query

	* @return array Matching products

	*/

	public static function searchByName($id_lang, $query, Context $context = null)

	{

		if (!$context)

			$context = Context::getContext();



		$sql = new DbQuery();

		$sql->select(\'p.`id_product`, pl.`name`, p.`ean13`, p.`upc`, p.`active`, p.`reference`, m.`name` AS manufacturer_name, stock.`quantity`, product_shop.advanced_stock_management, p.`customizable`\');

		$sql->from(\'product\', \'p\');

		$sql->join(Shop::addSqlAssociation(\'product\', \'p\'));

		$sql->leftJoin(\'product_lang\', \'pl\', \'

			p.`id_product` = pl.`id_product`

			AND pl.`id_lang` = \'.(int)$id_lang.Shop::addSqlRestrictionOnLang(\'pl\')

		);

		$sql->leftJoin(\'manufacturer\', \'m\', \'m.`id_manufacturer` = p.`id_manufacturer`\');



		$where = \'pl.`name` LIKE \'%\'.pSQL($query).\'%\'

		OR p.`ean13` LIKE \'%\'.pSQL($query).\'%\'

		OR p.`upc` LIKE \'%\'.pSQL($query).\'%\'

		OR p.`reference` LIKE \'%\'.pSQL($query).\'%\'

		OR p.`supplier_reference` LIKE \'%\'.pSQL($query).\'%\'

		OR EXISTS(SELECT * FROM `\'._DB_PREFIX_.\'product_supplier` sp WHERE sp.`id_product` = p.`id_product` AND `product_supplier_reference` LIKE \'%\'.pSQL($query).\'%\')\';



		$sql->orderBy(\'pl.`name` ASC\');



		if (Combination::isFeatureActive())

		{

			$where .= \' OR EXISTS(SELECT * FROM `\'._DB_PREFIX_.\'product_attribute` `pa` WHERE pa.`id_product` = p.`id_product` AND (pa.`reference` LIKE \'%\'.pSQL($query).\'%\'

			OR pa.`supplier_reference` LIKE \'%\'.pSQL($query).\'%\'

			OR pa.`ean13` LIKE \'%\'.pSQL($query).\'%\'

			OR pa.`upc` LIKE \'%\'.pSQL($query).\'%\'))\';

		}

		$sql->where($where);

		$sql->join(Product::sqlStock(\'p\', 0));



		$result = Db::getInstance()->executeS($sql);



		if (!$result)

			return false;



		$results_array = array();

		foreach ($result as $row)

		{

			$row[\'price_tax_incl\'] = Product::getPriceStatic($row[\'id_product\'], true, null, 2);

			$row[\'price_tax_excl\'] = Product::getPriceStatic($row[\'id_product\'], false, null, 2);

			$results_array[] = $row;

		}

		return $results_array;

	}



	/**

	* Duplicate attributes when duplicating a product

	*

	* @param int $id_product_old Old product id

	* @param int $id_product_new New product id

	*/

	public static function duplicateAttributes($id_product_old, $id_product_new)

	{

		$return = true;

		$combination_images = array();



		$result = Db::getInstance()->executeS(\'

		SELECT pa.*, product_attribute_shop.*

			FROM `\'._DB_PREFIX_.\'product_attribute` pa

			\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').\'

			WHERE pa.`id_product` = \'.(int)$id_product_old

		);

		$combinations = array();



		foreach ($result as $row)

		{

			$id_product_attribute_old = (int)$row[\'id_product_attribute\'];

			if (!isset($combinations[$id_product_attribute_old]))

			{

				$id_combination = null;

				$id_shop = null;

				$result2 = Db::getInstance()->executeS(\'

				SELECT *

				FROM `\'._DB_PREFIX_.\'product_attribute_combination`

					WHERE `id_product_attribute` = \'.$id_product_attribute_old

				);

			}

			else

			{

				$id_combination = (int)$combinations[$id_product_attribute_old];

				$id_shop = (int)$row[\'id_shop\'];

				$context_old = Shop::getContext();

				$context_shop_id_old = Shop::getContextShopID();

				Shop::setContext(Shop::CONTEXT_SHOP, $id_shop);



			}



			$row[\'id_product\'] = $id_product_new;

			unset($row[\'id_product_attribute\']);



			$combination = new Combination($id_combination, null, $id_shop);

			foreach ($row as $k => $v)

				$combination->$k = $v;

			$return &= $combination->save();



			$id_product_attribute_new = (int)$combination->id;



			if ($result_images = Product::_getAttributeImageAssociations($id_product_attribute_old))

			{

				$combination_images[\'old\'][$id_product_attribute_old] = $result_images;

				$combination_images[\'new\'][$id_product_attribute_new] = $result_images;

			}



			if (!isset($combinations[$id_product_attribute_old]))

			{

				$combinations[$id_product_attribute_old] = (int)$id_product_attribute_new;

				foreach ($result2 as $row2)

				{

					$row2[\'id_product_attribute\'] = $id_product_attribute_new;

					$return &= Db::getInstance()->insert(\'product_attribute_combination\', $row2);

				}

			}

			else

				Shop::setContext($context_old, $context_shop_id_old);



			//Copy suppliers

			$result3 = Db::getInstance()->executeS(\'

			SELECT *

			FROM `\'._DB_PREFIX_.\'product_supplier`

			WHERE `id_product_attribute` = \'.(int)$id_product_attribute_old.\'

			AND `id_product` = \'.(int)$id_product_old);



			foreach ($result3 as $row3)

			{

				unset($row3[\'id_product_supplier\']);

				$row3[\'id_product\'] = $id_product_new;

				$row3[\'id_product_attribute\'] = $id_product_attribute_new;

				$return &= Db::getInstance()->insert(\'product_supplier\', $row3);

			}

		}



		$impacts = self::getAttributesImpacts($id_product_old);



		if (is_array($impacts) && count($impacts))

		{

			$impact_sql = \'INSERT INTO `\'._DB_PREFIX_.\'attribute_impact` (`id_product`, `id_attribute`, `weight`, `price`) VALUES \';



			foreach ($impacts as $id_attribute => $impact)

				$impact_sql .= \'(\'.(int)$id_product_new.\', \'.(int)$id_attribute.\', \'.(float)$impacts[$id_attribute][\'weight\'].\', \'

					.(float)$impacts[$id_attribute][\'price\'].\'),\';



			$impact_sql = substr_replace($impact_sql, \'\', -1);

			$impact_sql .= \' ON DUPLICATE KEY UPDATE `price` = VALUES(price), `weight` = VALUES(weight)\';



			Db::getInstance()->execute($impact_sql);

		}



		return !$return ? false : $combination_images;

	}



	public static function getAttributesImpacts($id_product)

	{

		$return = array();

		$result = Db::getInstance()->executeS(

			\'SELECT ai.`id_attribute`, ai.`price`, ai.`weight`

			FROM `\'._DB_PREFIX_.\'attribute_impact` ai

			WHERE ai.`id_product` = \'.(int)$id_product);



		if (!$result)

			return array();

		foreach ($result as $impact)

		{

			$return[$impact[\'id_attribute\']][\'price\'] = (float)$impact[\'price\'];

			$return[$impact[\'id_attribute\']][\'weight\'] = (float)$impact[\'weight\'];

		}

		return $return;

	}



	/**

	* Get product attribute image associations

	* @param int $id_product_attribute

	* @return array

	*/

	public static function _getAttributeImageAssociations($id_product_attribute)

	{

		$combination_images = array();

		$data = Db::getInstance()->executeS(\'

			SELECT `id_image`

			FROM `\'._DB_PREFIX_.\'product_attribute_image`

			WHERE `id_product_attribute` = \'.(int)$id_product_attribute);

		foreach ($data as $row)

			$combination_images[] = (int)$row[\'id_image\'];

		return $combination_images;

	}



	public static function duplicateAccessories($id_product_old, $id_product_new)

	{

		$return = true;



		$result = Db::getInstance()->executeS(\'

		SELECT *

		FROM `\'._DB_PREFIX_.\'accessory`

		WHERE `id_product_1` = \'.(int)$id_product_old);

		foreach ($result as $row)

		{

			$data = array(

				\'id_product_1\' => (int)$id_product_new,

				\'id_product_2\' => (int)$row[\'id_product_2\']);

			$return &= Db::getInstance()->insert(\'accessory\', $data);

		}

		return $return;

	}



	public static function duplicateTags($id_product_old, $id_product_new)

	{

		$tags = Db::getInstance()->executeS(\'SELECT `id_tag`, `id_lang` FROM `\'._DB_PREFIX_.\'product_tag` WHERE `id_product` = \'.(int)$id_product_old);

		if (!Db::getInstance()->NumRows())

			return true;



		$data = array();

		foreach ($tags as $tag)

			$data[] = array(

				\'id_product\' => (int)$id_product_new,

				\'id_tag\' => (int)$tag[\'id_tag\'],

				\'id_lang\' => (int)$tag[\'id_lang\'],

			);



		return Db::getInstance()->insert(\'product_tag\', $data);

	}



	public static function duplicateDownload($id_product_old, $id_product_new)

	{

		$sql = \'SELECT `display_filename`, `filename`, `date_add`, `date_expiration`, `nb_days_accessible`, `nb_downloadable`, `active`, `is_shareable`

				FROM `\'._DB_PREFIX_.\'product_download`

				WHERE `id_product` = \'.(int)$id_product_old;

		$results = Db::getInstance()->executeS($sql);

		if (!$results)

			return true;



		$data = array();

		foreach ($results as $row)

		{

			$new_filename = ProductDownload::getNewFilename();

			copy(_PS_DOWNLOAD_DIR_.$row[\'filename\'], _PS_DOWNLOAD_DIR_.$new_filename);



			$data[] = array(

				\'id_product\' => (int)$id_product_new,

				\'display_filename\' => pSQL($row[\'display_filename\']),

				\'filename\' => pSQL($new_filename),

				\'date_expiration\' => pSQL($row[\'date_expiration\']),

				\'nb_days_accessible\' => (int)$row[\'nb_days_accessible\'],

				\'nb_downloadable\' => (int)$row[\'nb_downloadable\'],

				\'active\' => (int)$row[\'active\'],

				\'is_shareable\' => (int)$row[\'is_shareable\'],

				\'date_add\' => date(\'Y-m-d H:i:s\')

			);

		}

		return Db::getInstance()->insert(\'product_download\', $data);

	}



	public static function duplicateAttachments($id_product_old, $id_product_new)

	{

		// Get all ids attachments of the old product

		$sql = \'SELECT `id_attachment` FROM `\'._DB_PREFIX_.\'product_attachment` WHERE `id_product` = \'.(int)$id_product_old;

		$results = Db::getInstance()->executeS($sql);



		if (!$results)

			return true;



		$data = array();



		// Prepare data of table product_attachment

		foreach ($results as $row)

			$data[] = array(

				\'id_product\' => (int)$id_product_new,

				\'id_attachment\' => (int)$row[\'id_attachment\']

			);



		// Duplicate product attachement

		$res = Db::getInstance()->insert(\'product_attachment\', $data);

		Product::updateCacheAttachment((int)$id_product_new);

		return $res;

	}



	/**

	* Duplicate features when duplicating a product

	*

	* @param int $id_product_old Old product id

	* @param int $id_product_old New product id

	*/

	public static function duplicateFeatures($id_product_old, $id_product_new)

	{

		$return = true;



		$result = Db::getInstance()->executeS(\'

		SELECT *

		FROM `\'._DB_PREFIX_.\'feature_product`

		WHERE `id_product` = \'.(int)$id_product_old);

		foreach ($result as $row)

		{

			$result2 = Db::getInstance()->getRow(\'

			SELECT *

			FROM `\'._DB_PREFIX_.\'feature_value`

			WHERE `id_feature_value` = \'.(int)$row[\'id_feature_value\']);

			// Custom feature value, need to duplicate it

			if ($result2[\'custom\'])

			{

				$old_id_feature_value = $result2[\'id_feature_value\'];

				unset($result2[\'id_feature_value\']);

				$return &= Db::getInstance()->insert(\'feature_value\', $result2);

				$max_fv = Db::getInstance()->getRow(\'

					SELECT MAX(`id_feature_value`) AS nb

					FROM `\'._DB_PREFIX_.\'feature_value`\');

				$new_id_feature_value = $max_fv[\'nb\'];



				foreach (Language::getIDs(false) as $id_lang)

				{

					$result3 = Db::getInstance()->getRow(\'

					SELECT *

					FROM `\'._DB_PREFIX_.\'feature_value_lang`

					WHERE `id_feature_value` = \'.(int)$old_id_feature_value.\'

					AND `id_lang` = \'.(int)$id_lang);



					if ($result3)

					{

						$result3[\'id_feature_value\'] = (int)$new_id_feature_value;

						$result3[\'value\'] = pSQL($result3[\'value\']);

						$return &= Db::getInstance()->insert(\'feature_value_lang\', $result3);

					}

				}

				$row[\'id_feature_value\'] = $new_id_feature_value;

			}



			$row[\'id_product\'] = (int)$id_product_new;

			$return &= Db::getInstance()->insert(\'feature_product\', $row);

		}

		return $return;

	}



	protected static function _getCustomizationFieldsNLabels($product_id, $id_shop = null)

	{

		if (!Customization::isFeatureActive())

			return false;



		if (Shop::isFeatureActive() && !$id_shop)

			$id_shop = (int)Context::getContext()->shop->id;



		$customizations = array();

		if (($customizations[\'fields\'] = Db::getInstance()->executeS(\'

			SELECT `id_customization_field`, `type`, `required`

			FROM `\'._DB_PREFIX_.\'customization_field`

			WHERE `id_product` = \'.(int)$product_id.\'

			ORDER BY `id_customization_field`\')) === false)

			return false;



		if (empty($customizations[\'fields\']))

			return array();



		$customization_field_ids = array();

		foreach ($customizations[\'fields\'] as $customization_field)

			$customization_field_ids[] = (int)$customization_field[\'id_customization_field\'];



		if (($customization_labels = Db::getInstance()->executeS(\'

			SELECT `id_customization_field`, `id_lang`, `name`

			FROM `\'._DB_PREFIX_.\'customization_field_lang`

			WHERE `id_customization_field` IN (\'.implode(\', \', $customization_field_ids).\')\'.($id_shop ? \' AND cfl.`id_shop` = \'.$id_shop : \'\').\'

			ORDER BY `id_customization_field`\')) === false)

			return false;



		foreach ($customization_labels as $customization_label)

			$customizations[\'labels\'][$customization_label[\'id_customization_field\']][] = $customization_label;



		return $customizations;

	}



	public static function duplicateSpecificPrices($old_product_id, $product_id)

	{

		foreach (SpecificPrice::getIdsByProductId((int)$old_product_id) as $data)

		{

			$specific_price = new SpecificPrice((int)$data[\'id_specific_price\']);

			if (!$specific_price->duplicate((int)$product_id))

				return false;

		}

		return true;

	}



	public static function duplicateCustomizationFields($old_product_id, $product_id)

	{

		// If customization is not activated, return success

		if (!Customization::isFeatureActive())

			return true;

		if (($customizations = Product::_getCustomizationFieldsNLabels($old_product_id)) === false)

			return false;

		if (empty($customizations))

			return true;

		foreach ($customizations[\'fields\'] as $customization_field)

		{

			/* The new datas concern the new product */

			$customization_field[\'id_product\'] = (int)$product_id;

			$old_customization_field_id = (int)$customization_field[\'id_customization_field\'];



			unset($customization_field[\'id_customization_field\']);



			if (!Db::getInstance()->insert(\'customization_field\', $customization_field)

				|| !$customization_field_id = Db::getInstance()->Insert_ID())

				return false;



			if (isset($customizations[\'labels\']))

			{

				foreach ($customizations[\'labels\'][$old_customization_field_id] as $customization_label)

				{

					$data = array(

						\'id_customization_field\' => (int)$customization_field_id,

						\'id_lang\' => (int)$customization_label[\'id_lang\'],

						\'name\' => pSQL($customization_label[\'name\']),

					);



					if (!Db::getInstance()->insert(\'customization_field_lang\', $data))

						return false;

				}

			}

		}

		return true;

	}



	/**

	 * Adds suppliers from old product onto a newly duplicated product

	 *

	 * @param int $id_product_old

	 * @param int $id_product_new

	 */

	public static function duplicateSuppliers($id_product_old, $id_product_new)

	{

		$result = Db::getInstance()->executeS(\'

		SELECT *

		FROM `\'._DB_PREFIX_.\'product_supplier`

		WHERE `id_product` = \'.(int)$id_product_old.\' AND `id_product_attribute` = 0\');



		foreach ($result as $row)

		{

			unset($row[\'id_product_supplier\']);

			$row[\'id_product\'] = $id_product_new;

			if (!Db::getInstance()->insert(\'product_supplier\', $row))

				return false;

		}



		return true;

	}



	/**

	* Get the link of the product page of this product

	*/

	public function getLink(Context $context = null)

	{

		if (!$context)

			$context = Context::getContext();

		return $context->link->getProductLink($this);

	}



	public function getTags($id_lang)

	{

		if (!$this->isFullyLoaded && is_null($this->tags))

			$this->tags = Tag::getProductTags($this->id);



		if (!($this->tags && array_key_exists($id_lang, $this->tags)))

			return \'\';



		$result = \'\';

		foreach ($this->tags[$id_lang] as $tag_name)

			$result .= $tag_name.\', \';



		return rtrim($result, \', \');

	}



	public static function defineProductImage($row, $id_lang)

	{

		if (isset($row[\'id_image\']) && $row[\'id_image\'])

			return $row[\'id_product\'].\'-\'.$row[\'id_image\'];



		return Language::getIsoById((int)$id_lang).\'-default\';

	}



	public static function getProductProperties($id_lang, $row, Context $context = null)

	{

		if (!$row[\'id_product\'])

			return false;



		if ($context == null)

			$context = Context::getContext();



		$id_product_attribute = $row[\'id_product_attribute\'] = (!empty($row[\'id_product_attribute\']) ? (int)$row[\'id_product_attribute\'] : null);



		// 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_oosp\'] = Product::isAvailableWhenOutOfStock($row[\'out_of_stock\']);

		if (Combination::isFeatureActive() && $id_product_attribute === null

			&& ((isset($row[\'cache_default_attribute\']) && ($ipa_default = $row[\'cache_default_attribute\']) !== null)

				|| ($ipa_default = Product::getDefaultAttribute($row[\'id_product\'], !$row[\'allow_oosp\']))))

			$id_product_attribute = $row[\'id_product_attribute\'] = $ipa_default;

		if (!Combination::isFeatureActive() || !isset($row[\'id_product_attribute\']))

			$id_product_attribute = $row[\'id_product_attribute\'] = 0;



		// Tax

		$usetax = Tax::excludeTaxeOption();



		$cache_key = $row[\'id_product\'].\'-\'.$id_product_attribute.\'-\'.$id_lang.\'-\'.(int)$usetax;

		if (isset($row[\'id_product_pack\']))

			$cache_key .= \'-pack\'.$row[\'id_product_pack\'];



		if (isset(self::$producPropertiesCache[$cache_key]))

			return array_merge($row, self::$producPropertiesCache[$cache_key]);



		// Datas

		$row[\'category\'] = Category::getLinkRewrite((int)$row[\'id_category_default\'], (int)$id_lang);

		$row[\'link\'] = $context->link->getProductLink((int)$row[\'id_product\'], $row[\'link_rewrite\'], $row[\'category\'], $row[\'ean13\']);



		$row[\'attribute_price\'] = 0;

		if ($id_product_attribute)

			$row[\'attribute_price\'] = (float)Product::getProductAttributePrice($id_product_attribute);



		$row[\'price_tax_exc\'] = Product::getPriceStatic(

			(int)$row[\'id_product\'],

			false,

			$id_product_attribute,

			(self::$_taxCalculationMethod == PS_TAX_EXC ? 2 : 6)

		);



		if (self::$_taxCalculationMethod == PS_TAX_EXC)

		{

			$row[\'price_tax_exc\'] = Tools::ps_round($row[\'price_tax_exc\'], 2);

			$row[\'price\'] = Product::getPriceStatic(

				(int)$row[\'id_product\'],

				true,

				$id_product_attribute,

				6

			);

			$row[\'price_without_reduction\'] = Product::getPriceStatic(

				(int)$row[\'id_product\'],

				false,

				$id_product_attribute,

				2,

				null,

				false,

				false

			);

		}

		else

		{

			$row[\'price\'] = Tools::ps_round(

				Product::getPriceStatic(

					(int)$row[\'id_product\'],

					true,

					$id_product_attribute,

					6

				),

				(int)Configuration::get(\'PS_PRICE_DISPLAY_PRECISION\')

			);

			$row[\'price_without_reduction\'] = Product::getPriceStatic(

				(int)$row[\'id_product\'],

				true,

				$id_product_attribute,

				6,

				null,

				false,

				false

			);

		}



		$row[\'reduction\'] = Product::getPriceStatic(

			(int)$row[\'id_product\'],

			(bool)$usetax,

			$id_product_attribute,

			6,

			null,

			true,

			true,

			1,

			true,

			null,

			null,

			null,

			$specific_prices

		);



		$row[\'specific_prices\'] = $specific_prices;



		$row[\'quantity\'] = Product::getQuantity(

			(int)$row[\'id_product\'],

			0,

			isset($row[\'cache_is_pack\']) ? $row[\'cache_is_pack\'] : null

		);



		$row[\'quantity_all_versions\'] = $row[\'quantity\'];



		if ($row[\'id_product_attribute\'])

			$row[\'quantity\'] = Product::getQuantity(

				(int)$row[\'id_product\'],

				$id_product_attribute,

				isset($row[\'cache_is_pack\']) ? $row[\'cache_is_pack\'] : null

			);



		$row[\'id_image\'] = Product::defineProductImage($row, $id_lang);

		$row[\'features\'] = Product::getFrontFeaturesStatic((int)$id_lang, $row[\'id_product\']);



		$row[\'attachments\'] = array();

		if (!isset($row[\'cache_has_attachments\']) || $row[\'cache_has_attachments\'])

			$row[\'attachments\'] = Product::getAttachmentsStatic((int)$id_lang, $row[\'id_product\']);



		$row[\'virtual\'] = ((!isset($row[\'is_virtual\']) || $row[\'is_virtual\']) ? 1 : 0);



		// Pack management

		$row[\'pack\'] = (!isset($row[\'cache_is_pack\']) ? Pack::isPack($row[\'id_product\']) : (int)$row[\'cache_is_pack\']);

		$row[\'packItems\'] = $row[\'pack\'] ? Pack::getItemTable($row[\'id_product\'], $id_lang) : array();

		$row[\'nopackprice\'] = $row[\'pack\'] ? Pack::noPackPrice($row[\'id_product\']) : 0;

		if ($row[\'pack\'] && !Pack::isInStock($row[\'id_product\']))

			$row[\'quantity\'] = 0;



		$row[\'customization_required\'] = false;

		if (isset($row[\'customizable\']) && $row[\'customizable\'] && Customization::isFeatureActive())

			if (count(Product::getRequiredCustomizableFieldsStatic((int)$row[\'id_product\'])))

				$row[\'customization_required\'] = true;



		$row = Product::getTaxesInformations($row, $context);

		self::$producPropertiesCache[$cache_key] = $row;

		return self::$producPropertiesCache[$cache_key];

	}



	public static function getTaxesInformations($row, Context $context = null)

	{

		static $address = null;



		if ($context === null)

			$context = Context::getContext();

		if ($address === null)

			$address = new Address();



		$address->id_country = (int)$context->country->id;

		$address->id_state = 0;

		$address->postcode = 0;



		$tax_manager = TaxManagerFactory::getManager($address, Product::getIdTaxRulesGroupByIdProduct((int)$row[\'id_product\'], $context));

		$row[\'rate\'] = $tax_manager->getTaxCalculator()->getTotalRate();

		$row[\'tax_name\'] = $tax_manager->getTaxCalculator()->getTaxesName();



		return $row;

	}



	public static function getProductsProperties($id_lang, $query_result)

	{

		$results_array = array();



		if (is_array($query_result))

			foreach ($query_result as $row)

				if ($row2 = Product::getProductProperties($id_lang, $row))

					$results_array[] = $row2;



		return $results_array;

	}



	/*

	* Select all features for a given language

	*

	* @param $id_lang Language id

	* @return array Array with feature\'s data

	*/

	public static function getFrontFeaturesStatic($id_lang, $id_product)

	{

		if (!Feature::isFeatureActive())

			return array();

		if (!array_key_exists($id_product.\'-\'.$id_lang, self::$_frontFeaturesCache))

		{

			self::$_frontFeaturesCache[$id_product.\'-\'.$id_lang] = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(\'

				SELECT name, value, pf.id_feature

				FROM \'._DB_PREFIX_.\'feature_product pf

				LEFT JOIN \'._DB_PREFIX_.\'feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = \'.(int)$id_lang.\')

				LEFT JOIN \'._DB_PREFIX_.\'feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = \'.(int)$id_lang.\')

				LEFT JOIN \'._DB_PREFIX_.\'feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = \'.(int)$id_lang.\')

				\'.Shop::addSqlAssociation(\'feature\', \'f\').\'

				WHERE pf.id_product = \'.(int)$id_product.\'

				ORDER BY f.position ASC\'

			);

		}

		return self::$_frontFeaturesCache[$id_product.\'-\'.$id_lang];

	}



	public function getFrontFeatures($id_lang)

	{

		return Product::getFrontFeaturesStatic($id_lang, $this->id);

	}



	public static function getAttachmentsStatic($id_lang, $id_product)

	{

		return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(\'

		SELECT *

		FROM \'._DB_PREFIX_.\'product_attachment pa

		LEFT JOIN \'._DB_PREFIX_.\'attachment a ON a.id_attachment = pa.id_attachment

		LEFT JOIN \'._DB_PREFIX_.\'attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = \'.(int)$id_lang.\')

		WHERE pa.id_product = \'.(int)$id_product);

	}



	public function getAttachments($id_lang)

	{

		return Product::getAttachmentsStatic($id_lang, $this->id);

	}



	/*

	** Customization management

	*/



	public static function getAllCustomizedDatas($id_cart, $id_lang = null, $only_in_cart = true, $id_shop = null)

	{

		if (!Customization::isFeatureActive())

			return false;



		// No need to query if there isn\'t any real cart!

		if (!$id_cart)

			return false;

		if (!$id_lang)

			$id_lang = Context::getContext()->language->id;

		if (Shop::isFeatureActive() && !$id_shop)

			$id_shop = (int)Context::getContext()->shop->id;





		if (!$result = Db::getInstance()->executeS(\'

			SELECT cd.`id_customization`, c.`id_address_delivery`, c.`id_product`, cfl.`id_customization_field`, c.`id_product_attribute`,

				cd.`type`, cd.`index`, cd.`value`, cfl.`name`

			FROM `\'._DB_PREFIX_.\'customized_data` cd

			NATURAL JOIN `\'._DB_PREFIX_.\'customization` c

			LEFT JOIN `\'._DB_PREFIX_.\'customization_field_lang` cfl ON (cfl.id_customization_field = cd.`index` AND id_lang = \'.(int)$id_lang.

				($id_shop ? \' AND cfl.`id_shop` = \'.$id_shop : \'\').\')

			WHERE c.`id_cart` = \'.(int)$id_cart.

			($only_in_cart ? \' AND c.`in_cart` = 1\' : \'\').\'

			ORDER BY `id_product`, `id_product_attribute`, `type`, `index`\'))

			return false;



		$customized_datas = array();



		foreach ($result as $row)

			$customized_datas[(int)$row[\'id_product\']][(int)$row[\'id_product_attribute\']][(int)$row[\'id_address_delivery\']][(int)$row[\'id_customization\']][\'datas\'][(int)$row[\'type\']][] = $row;



		if (!$result = Db::getInstance()->executeS(

			\'SELECT `id_product`, `id_product_attribute`, `id_customization`, `id_address_delivery`, `quantity`, `quantity_refunded`, `quantity_returned`

			FROM `\'._DB_PREFIX_.\'customization`

			WHERE `id_cart` = \'.(int)$id_cart.($only_in_cart ? \'

			AND `in_cart` = 1\' : \'\')))

			return false;



		foreach ($result as $row)

		{

			$customized_datas[(int)$row[\'id_product\']][(int)$row[\'id_product_attribute\']][(int)$row[\'id_address_delivery\']][(int)$row[\'id_customization\']][\'quantity\'] = (int)$row[\'quantity\'];

			$customized_datas[(int)$row[\'id_product\']][(int)$row[\'id_product_attribute\']][(int)$row[\'id_address_delivery\']][(int)$row[\'id_customization\']][\'quantity_refunded\'] = (int)$row[\'quantity_refunded\'];

			$customized_datas[(int)$row[\'id_product\']][(int)$row[\'id_product_attribute\']][(int)$row[\'id_address_delivery\']][(int)$row[\'id_customization\']][\'quantity_returned\'] = (int)$row[\'quantity_returned\'];

		}



		return $customized_datas;

	}



	public static function addCustomizationPrice(&$products, &$customized_datas)

	{

		if (!$customized_datas)

			return;



		foreach ($products as &$product_update)

		{

			if (!Customization::isFeatureActive())

			{

				$product_update[\'customizationQuantityTotal\'] = 0;

				$product_update[\'customizationQuantityRefunded\'] = 0;

				$product_update[\'customizationQuantityReturned\'] = 0;

			}

			else

			{

				$customization_quantity = 0;

				$customization_quantity_refunded = 0;

				$customization_quantity_returned = 0;



				/* Compatibility */

				$product_id = isset($product_update[\'id_product\']) ? (int)$product_update[\'id_product\'] : (int)$product_update[\'product_id\'];

				$product_attribute_id = isset($product_update[\'id_product_attribute\']) ? (int)$product_update[\'id_product_attribute\'] : (int)$product_update[\'product_attribute_id\'];

				$id_address_delivery = (int)$product_update[\'id_address_delivery\'];

				$product_quantity = isset($product_update[\'cart_quantity\']) ? (int)$product_update[\'cart_quantity\'] : (int)$product_update[\'product_quantity\'];

				$price = isset($product_update[\'price\']) ? $product_update[\'price\'] : $product_update[\'product_price\'];

				if (isset($product_update[\'price_wt\']) && $product_update[\'price_wt\'])

					$price_wt = $product_update[\'price_wt\'];

				else

					$price_wt = $price * (1 + ((isset($product_update[\'tax_rate\']) ? $product_update[\'tax_rate\'] : $product_update[\'rate\']) * 0.01));



				if (!isset($customized_datas[$product_id][$product_attribute_id][$id_address_delivery]))

					$id_address_delivery = 0;

				if (isset($customized_datas[$product_id][$product_attribute_id][$id_address_delivery]))

				{

					foreach ($customized_datas[$product_id][$product_attribute_id][$id_address_delivery] as $customization)

					{

						$customization_quantity += (int)$customization[\'quantity\'];

						$customization_quantity_refunded += (int)$customization[\'quantity_refunded\'];

						$customization_quantity_returned += (int)$customization[\'quantity_returned\'];

					}

				}



				$product_update[\'customizationQuantityTotal\'] = $customization_quantity;

				$product_update[\'customizationQuantityRefunded\'] = $customization_quantity_refunded;

				$product_update[\'customizationQuantityReturned\'] = $customization_quantity_returned;



				if ($customization_quantity)

				{

					$product_update[\'total_wt\'] = $price_wt * ($product_quantity - $customization_quantity);

					$product_update[\'total_customization_wt\'] = $price_wt * $customization_quantity;

					$product_update[\'total\'] = $price * ($product_quantity - $customization_quantity);

					$product_update[\'total_customization\'] = $price * $customization_quantity;

				}

			}

		}

	}



	/*

	** Customization fields\' label management

	*/



	protected function _checkLabelField($field, $value)

	{

		if (!Validate::isLabel($value))

			return false;

		$tmp = explode(\'_\', $field);

		if (count($tmp) < 4) return false; return $tmp; } protected function _deleteOldLabels() { $max = array( Product::CUSTOMIZE_FILE => (int)$this->uploadable_files,

			Product::CUSTOMIZE_TEXTFIELD => (int)$this->text_fields

		);



		/* Get customization field ids */

		if (($result = Db::getInstance()->executeS(

			\'SELECT `id_customization_field`, `type`

			FROM `\'._DB_PREFIX_.\'customization_field`

			WHERE `id_product` = \'.(int)$this->id.\'

			ORDER BY `id_customization_field`\')

		) === false)

			return false;



		if (empty($result))

			return true;



		$customization_fields = array(

			Product::CUSTOMIZE_FILE => array(),

			Product::CUSTOMIZE_TEXTFIELD => array()

		);



		foreach ($result as $row)

			$customization_fields[(int)$row[\'type\']][] = (int)$row[\'id_customization_field\'];



		$extra_file = count($customization_fields[Product::CUSTOMIZE_FILE]) - $max[Product::CUSTOMIZE_FILE];

		$extra_text = count($customization_fields[Product::CUSTOMIZE_TEXTFIELD]) - $max[Product::CUSTOMIZE_TEXTFIELD];



		/* If too much inside the database, deletion */

		if ($extra_file > 0 && count($customization_fields[Product::CUSTOMIZE_FILE]) - $extra_file >= 0 &&

		(!Db::getInstance()->execute(

			\'DELETE `\'._DB_PREFIX_.\'customization_field`,`\'._DB_PREFIX_.\'customization_field_lang`

			FROM `\'._DB_PREFIX_.\'customization_field` JOIN `\'._DB_PREFIX_.\'customization_field_lang`

			WHERE `\'._DB_PREFIX_.\'customization_field`.`id_product` = \'.(int)$this->id.\'

			AND `\'._DB_PREFIX_.\'customization_field`.`type` = \'.Product::CUSTOMIZE_FILE.\'

			AND `\'._DB_PREFIX_.\'customization_field_lang`.`id_customization_field` = `\'._DB_PREFIX_.\'customization_field`.`id_customization_field`

			AND `\'._DB_PREFIX_.\'customization_field`.`id_customization_field` >= \'.(int)$customization_fields[Product::CUSTOMIZE_FILE][count($customization_fields[Product::CUSTOMIZE_FILE]) - $extra_file]

		)))

			return false;



		if ($extra_text > 0 && count($customization_fields[Product::CUSTOMIZE_TEXTFIELD]) - $extra_text >= 0 &&

		(!Db::getInstance()->execute(

			\'DELETE `\'._DB_PREFIX_.\'customization_field`,`\'._DB_PREFIX_.\'customization_field_lang`

			FROM `\'._DB_PREFIX_.\'customization_field` JOIN `\'._DB_PREFIX_.\'customization_field_lang`

			WHERE `\'._DB_PREFIX_.\'customization_field`.`id_product` = \'.(int)$this->id.\'

			AND `\'._DB_PREFIX_.\'customization_field`.`type` = \'.Product::CUSTOMIZE_TEXTFIELD.\'

			AND `\'._DB_PREFIX_.\'customization_field_lang`.`id_customization_field` = `\'._DB_PREFIX_.\'customization_field`.`id_customization_field`

			AND `\'._DB_PREFIX_.\'customization_field`.`id_customization_field` >= \'.(int)$customization_fields[Product::CUSTOMIZE_TEXTFIELD][count($customization_fields[Product::CUSTOMIZE_TEXTFIELD]) - $extra_text]

		)))

			return false;



		// Refresh cache of feature detachable

		Configuration::updateGlobalValue(\'PS_CUSTOMIZATION_FEATURE_ACTIVE\', Customization::isCurrentlyUsed());



		return true;

	}



	protected function _createLabel($languages, $type)

	{

		// Label insertion

		if (!Db::getInstance()->execute(\'

			INSERT INTO `\'._DB_PREFIX_.\'customization_field` (`id_product`, `type`, `required`)

			VALUES (\'.(int)$this->id.\', \'.(int)$type.\', 0)\') ||

			!$id_customization_field = (int)Db::getInstance()->Insert_ID())

			return false;



		// Multilingual label name creation

		$values = \'\';



		foreach ($languages as $language)

			foreach (Shop::getContextListShopID() as $id_shop)

				$values .= \'(\'.(int)$id_customization_field.\', \'.(int)$language[\'id_lang\'].\', \'.$id_shop .\',\'\'), \';



		$values = rtrim($values, \', \');

		if (!Db::getInstance()->execute(\'

			INSERT INTO `\'._DB_PREFIX_.\'customization_field_lang` (`id_customization_field`, `id_lang`, `id_shop`, `name`)

			VALUES \'.$values))

			return false;



		// Set cache of feature detachable to true

		Configuration::updateGlobalValue(\'PS_CUSTOMIZATION_FEATURE_ACTIVE\', \'1\');



		return true;

	}



	public function createLabels($uploadable_files, $text_fields)

	{

		$languages = Language::getLanguages();

		if ((int)$uploadable_files > 0)

			for ($i = 0; $i < (int)$uploadable_files; $i++) if (!$this->_createLabel($languages, Product::CUSTOMIZE_FILE))

					return false;



		if ((int)$text_fields > 0)

			for ($i = 0; $i < (int)$text_fields; $i++) if (!$this->_createLabel($languages, Product::CUSTOMIZE_TEXTFIELD))

					return false;



		return true;

	}



	public function updateLabels()

	{

		$has_required_fields = 0;

		foreach ($_POST as $field => $value)

			/* Label update */

			if (strncmp($field, \'label_\', 6) == 0)

			{

				if (!$tmp = $this->_checkLabelField($field, $value))

					return false;

				/* Multilingual label name update */

				if (Shop::isFeatureActive())

				{

					foreach (Shop::getContextListShopID() as $id_shop)

						if (!Db::getInstance()->execute(\'INSERT INTO `\'._DB_PREFIX_.\'customization_field_lang`

						(`id_customization_field`, `id_lang`, `id_shop`, `name`) VALUES (\'.(int)$tmp[2].\', \'.(int)$tmp[3].\', \'.$id_shop.\', \'\'.pSQL($value).\'\')

						ON DUPLICATE KEY UPDATE `name` = \'\'.pSQL($value).\'\'\'))

							return false;

				}

				elseif (!Db::getInstance()->execute(\'

					INSERT INTO `\'._DB_PREFIX_.\'customization_field_lang`

					(`id_customization_field`, `id_lang`, `name`) VALUES (\'.(int)$tmp[2].\', \'.(int)$tmp[3].\', \'\'.pSQL($value).\'\')

					ON DUPLICATE KEY UPDATE `name` = \'\'.pSQL($value).\'\'\'))

					return false;



				$is_required = isset($_POST[\'require_\'.(int)$tmp[1].\'_\'.(int)$tmp[2]]) ? 1 : 0;

				$has_required_fields |= $is_required;

				/* Require option update */

				if (!Db::getInstance()->execute(

					\'UPDATE `\'._DB_PREFIX_.\'customization_field`

					SET `required` = \'.(int)$is_required.\'

					WHERE `id_customization_field` = \'.(int)$tmp[2]))

					return false;

			}



		if ($has_required_fields && !ObjectModel::updateMultishopTable(\'product\', array(\'customizable\' => 2), \'a.id_product = \'.(int)$this->id))

			return false;



		if (!$this->_deleteOldLabels())

			return false;



		return true;

	}



	public function getCustomizationFields($id_lang = false, $id_shop = null)

	{

		if (!Customization::isFeatureActive())

			return false;



		if (Shop::isFeatureActive() && !$id_shop)

			$id_shop = (int)Context::getContext()->shop->id;



		if (!$result = Db::getInstance()->executeS(\'

			SELECT cf.`id_customization_field`, cf.`type`, cf.`required`, cfl.`name`, cfl.`id_lang`

			FROM `\'._DB_PREFIX_.\'customization_field` cf

			NATURAL JOIN `\'._DB_PREFIX_.\'customization_field_lang` cfl

			WHERE cf.`id_product` = \'.(int)$this->id.($id_lang ? \' AND cfl.`id_lang` = \'.(int)$id_lang : \'\').

				($id_shop ? \' AND cfl.`id_shop` = \'.$id_shop : \'\').\'

			ORDER BY cf.`id_customization_field`\'))

			return false;



		if ($id_lang)

			return $result;



		$customization_fields = array();

		foreach ($result as $row)

			$customization_fields[(int)$row[\'type\']][(int)$row[\'id_customization_field\']][(int)$row[\'id_lang\']] = $row;



		return $customization_fields;

	}



	public function getCustomizationFieldIds()

	{

		if (!Customization::isFeatureActive())

			return array();

		return Db::getInstance()->executeS(\'

			SELECT `id_customization_field`, `type`, `required`

			FROM `\'._DB_PREFIX_.\'customization_field`

			WHERE `id_product` = \'.(int)$this->id);

	}



	public function getRequiredCustomizableFields()

	{

		if (!Customization::isFeatureActive())

			return array();

		return Product::getRequiredCustomizableFieldsStatic($this->id);

	}



	public static function getRequiredCustomizableFieldsStatic($id)

	{

		if (!$id || !Customization::isFeatureActive())

			return array();

		return Db::getInstance()->executeS(\'

			SELECT `id_customization_field`, `type`

			FROM `\'._DB_PREFIX_.\'customization_field`

			WHERE `id_product` = \'.(int)$id.\'

			AND `required` = 1\'

		);

	}



	public function hasAllRequiredCustomizableFields(Context $context = null)

	{

		if (!Customization::isFeatureActive())

			return true;

		if (!$context)

			$context = Context::getContext();



		$fields = $context->cart->getProductCustomization($this->id, null, true);

		if (($required_fields = $this->getRequiredCustomizableFields()) === false)

			return false;



		$fields_present = array();

		foreach ($fields as $field)

			$fields_present[] = array(\'id_customization_field\' => $field[\'index\'], \'type\' => $field[\'type\']);



		if (is_array($required_fields) && count($required_fields))

			foreach ($required_fields as $required_field)

				if (!in_array($required_field, $fields_present))

					return false;

		return true;

	}





	/**

	 * Checks if the product is in at least one of the submited categories

	 *

	 * @param int $id_product

	 * @param array $categories array of category arrays

	 * @return bool is the product in at least one category

	 */

	public static function idIsOnCategoryId($id_product, $categories)

	{

		if (!((int)$id_product > 0) || !is_array($categories) || empty($categories))

			return false;

		$sql = \'SELECT id_product FROM `\'._DB_PREFIX_.\'category_product` WHERE `id_product` = \'.(int)$id_product.\' AND `id_category` IN (\';

		foreach ($categories as $category)

			$sql .= (int)$category[\'id_category\'].\',\';

		$sql = rtrim($sql, \',\').\')\';



		$hash = md5($sql);

		if (!isset(self::$_incat[$hash]))

		{

			if (!Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($sql))

				return false;

			self::$_incat[$hash] = (Db::getInstance(_PS_USE_SQL_SLAVE_)->NumRows() > 0 ? true : false);

		}

		return self::$_incat[$hash];

	}



	public function getNoPackPrice()

	{

		return Pack::noPackPrice((int)$this->id);

	}



	public function checkAccess($id_customer)

	{

		return Product::checkAccessStatic((int)$this->id, (int)$id_customer);

	}



	public static function checkAccessStatic($id_product, $id_customer)

	{

		if (!Group::isFeatureActive())

			return true;



		$cache_id = \'Product::checkAccess_\'.(int)$id_product.\'-\'.(int)$id_customer.(!$id_customer ? \'-\'.(int)Group::getCurrent()->id : \'\');

		if (!Cache::isStored($cache_id))

		{

			if (!$id_customer)

				$result = (bool)Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue(\'

				SELECT ctg.`id_group`

				FROM `\'._DB_PREFIX_.\'category_product` cp

				INNER JOIN `\'._DB_PREFIX_.\'category_group` ctg ON (ctg.`id_category` = cp.`id_category`)

				WHERE cp.`id_product` = \'.(int)$id_product.\' AND ctg.`id_group` = \'.(int)Group::getCurrent()->id);

			else

				$result = (bool)Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue(\'

				SELECT cg.`id_group`

				FROM `\'._DB_PREFIX_.\'category_product` cp

				INNER JOIN `\'._DB_PREFIX_.\'category_group` ctg ON (ctg.`id_category` = cp.`id_category`)

				INNER JOIN `\'._DB_PREFIX_.\'customer_group` cg ON (cg.`id_group` = ctg.`id_group`)

				WHERE cp.`id_product` = \'.(int)$id_product.\' AND cg.`id_customer` = \'.(int)$id_customer);



			Cache::store($cache_id, $result);

			return $result;

		}

		return Cache::retrieve($cache_id);

	}



	/**

	 * Add a stock movement for current product

	 *

	 * Since 1.5, this method only permit to add/remove available quantities of the current product in the current shop

	 *

	 * @see StockManager if you want to manage real stock

	 * @see StockAvailable if you want to manage available quantities for sale on your shop(s)

	 *

	 * @deprecated since 1.5.0

	 *

	 * @param int $quantity

	 * @param int $id_reason - useless

	 * @param int $id_product_attribute

	 * @param int $id_order - DEPRECATED

	 * @param int $id_employee - DEPRECATED

	 * @return bool

	 */

	public function addStockMvt($quantity, $id_reason, $id_product_attribute = null, $id_order = null, $id_employee = null)

	{

		if (!$this->id || !$id_reason)

			return false;



		if ($id_product_attribute == null)

			$id_product_attribute = 0;



		$reason = new StockMvtReason((int)$id_reason);

		if (!Validate::isLoadedObject($reason))

			return false;



		$quantity = abs((int)$quantity) * $reason->sign;



		return StockAvailable::updateQuantity($this->id, $id_product_attribute, $quantity);

	}



	/**

	 * @deprecated since 1.5.0

	 */

	public function getStockMvts($id_lang)

	{

		Tools::displayAsDeprecated();



		return Db::getInstance()->executeS(\'

			SELECT sm.id_stock_mvt, sm.date_add, sm.quantity, sm.id_order,

			CONCAT(pl.name, \' \', GROUP_CONCAT(IFNULL(al.name, \'\'), \'\')) product_name, CONCAT(e.lastname, \' \', e.firstname) employee, mrl.name reason

			FROM `\'._DB_PREFIX_.\'stock_mvt` sm

			LEFT JOIN `\'._DB_PREFIX_.\'product_lang` pl ON (

				sm.id_product = pl.id_product

				AND pl.id_lang = \'.(int)$id_lang.Shop::addSqlRestrictionOnLang(\'pl\').\'

			)

			LEFT JOIN `\'._DB_PREFIX_.\'stock_mvt_reason_lang` mrl ON (

				sm.id_stock_mvt_reason = mrl.id_stock_mvt_reason

				AND mrl.id_lang = \'.(int)$id_lang.\'

			)

			LEFT JOIN `\'._DB_PREFIX_.\'employee` e ON (

				e.id_employee = sm.id_employee

			)

			LEFT JOIN `\'._DB_PREFIX_.\'product_attribute_combination` pac ON (

				pac.id_product_attribute = sm.id_product_attribute

			)

			LEFT JOIN `\'._DB_PREFIX_.\'attribute_lang` al ON (

				al.id_attribute = pac.id_attribute

				AND al.id_lang = \'.(int)$id_lang.\'

			)

			WHERE sm.id_product=\'.(int)$this->id.\'

			GROUP BY sm.id_stock_mvt

		\');

	}



	public static function getUrlRewriteInformations($id_product)

	{

		return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(\'

			SELECT pl.`id_lang`, pl.`link_rewrite`, p.`ean13`, cl.`link_rewrite` AS category_rewrite

			FROM `\'._DB_PREFIX_.\'product` p

			LEFT JOIN `\'._DB_PREFIX_.\'product_lang` pl ON (p.`id_product` = pl.`id_product`\'.Shop::addSqlRestrictionOnLang(\'pl\').\')

			\'.Shop::addSqlAssociation(\'product\', \'p\').\'

			LEFT JOIN `\'._DB_PREFIX_.\'lang` l ON (pl.`id_lang` = l.`id_lang`)

			LEFT JOIN `\'._DB_PREFIX_.\'category_lang` cl ON (cl.`id_category` = product_shop.`id_category_default`  AND cl.`id_lang` = pl.`id_lang`\'.Shop::addSqlRestrictionOnLang(\'cl\').\')

			WHERE p.`id_product` = \'.(int)$id_product.\'

			AND l.`active` = 1

		\');

	}



	public function getIdTaxRulesGroup()

	{

		return $this->id_tax_rules_group;

	}



	public static function getIdTaxRulesGroupByIdProduct($id_product, Context $context = null)

	{

		if (!$context)

			$context = Context::getContext();

		$key = \'product_id_tax_rules_group_\'.(int)$id_product.\'_\'.(int)$context->shop->id;

		if (!Cache::isStored($key))

		{

			$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue(\'

							SELECT `id_tax_rules_group`

							FROM `\'._DB_PREFIX_.\'product_shop`

							WHERE `id_product` = \'.(int)$id_product.\' AND id_shop=\'.(int)$context->shop->id);

			Cache::store($key, (int)$result);

			return (int)$result;

		}

		return Cache::retrieve($key);

	}



	/**

	 * Returns tax rate.

	 *

	 * @param Address|null $address

	 * @return float The total taxes rate applied to the product

	 */

	public function getTaxesRate(Address $address = null)

	{

		if (!$address || !$address->id_country)

			$address = Address::initialize();



		$tax_manager = TaxManagerFactory::getManager($address, $this->id_tax_rules_group);

		$tax_calculator = $tax_manager->getTaxCalculator();



		return $tax_calculator->getTotalRate();

	}



	/**

	* Webservice getter : get product features association

	*

	* @return array

	*/

	public function getWsProductFeatures()

	{

		$rows = $this->getFeatures();

		foreach ($rows as $keyrow => $row)

		{

			foreach ($row as $keyfeature => $feature)

			{

				if ($keyfeature == \'id_feature\')

				{

					$rows[$keyrow][\'id\'] = $feature;

					unset($rows[$keyrow][\'id_feature\']);

				}

				unset($rows[$keyrow][\'id_product\']);

				unset($rows[$keyrow][\'custom\']);

			}

			asort($rows[$keyrow]);

		}

		return $rows;

	}



	/**

	 * Webservice setter : set product features association

	 *

	 * @param $product_features Product Feature ids

	 * @return bool

	 */

	public function setWsProductFeatures($product_features)

	{

		Db::getInstance()->execute(\'

			DELETE FROM `\'._DB_PREFIX_.\'feature_product`

			WHERE `id_product` = \'.(int)$this->id

		);

		foreach ($product_features as $product_feature)

			$this->addFeaturesToDB($product_feature[\'id\'], $product_feature[\'id_feature_value\']);

		return true;

	}



	/**

	* Webservice getter : get virtual field default combination

	*

	* @return int

	*/

	public function getWsDefaultCombination()

	{

		return Product::getDefaultAttribute($this->id);

	}



	/**

	 * Webservice setter : set virtual field default combination

	 *

	 * @param int $id_combination id default combination

	 * @return bool

	 */

	public function setWsDefaultCombination($id_combination)

	{

		$this->deleteDefaultAttributes();

		return $this->setDefaultAttribute((int)$id_combination);

	}



	/**

	* Webservice getter : get category ids of current product for association

	*

	* @return array

	*/

	public function getWsCategories()

	{

		$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(

			\'SELECT cp.`id_category` AS id

			FROM `\'._DB_PREFIX_.\'category_product` cp

			LEFT JOIN `\'._DB_PREFIX_.\'category` c ON (c.id_category = cp.id_category)

			\'.Shop::addSqlAssociation(\'category\', \'c\').\'

			WHERE cp.`id_product` = \'.(int)$this->id

		);

		return $result;

	}



	/**

	 * Webservice setter : set category ids of current product for association

	 *

	 * @param array $category_ids category ids

	 * @return bool

	 */

	public function setWsCategories($category_ids)

	{

		$ids = array();

		foreach ($category_ids as $value)

			$ids[] = $value[\'id\'];

		if ($this->deleteCategories())

		{

			if ($ids)

			{

				$sql_values = \'\';

				$ids = array_map(\'intval\', $ids);

				foreach ($ids as $position => $id)

					$sql_values[] = \'(\'.(int)$id.\', \'.(int)$this->id.\', \'.(int)$position.\')\';

				$result = Db::getInstance()->execute(\'

					INSERT INTO `\'._DB_PREFIX_.\'category_product` (`id_category`, `id_product`, `position`)

					VALUES \'.implode(\',\', $sql_values)

				);

				Hook::exec(\'updateProduct\', array(\'id_product\' => (int)$this->id));

				return $result;

			}

		}

		Hook::exec(\'updateProduct\', array(\'id_product\' => (int)$this->id));

		return true;

	}



	/**

	* Webservice getter : get product accessories ids of current product for association

	*

	* @return array

	*/

	public function getWsAccessories()

	{

		$result = Db::getInstance()->executeS(

			\'SELECT p.`id_product` AS id

			FROM `\'._DB_PREFIX_.\'accessory` a

			LEFT JOIN `\'._DB_PREFIX_.\'product` p ON (p.id_product = a.id_product_2)

			\'.Shop::addSqlAssociation(\'product\', \'p\').\'

			WHERE a.`id_product_1` = \'.(int)$this->id

		);



		return $result;

	}



	/**

	* Webservice setter : set product accessories ids of current product for association

	*

	* @param $accessories product ids

	*/

	public function setWsAccessories($accessories)

	{

		$this->deleteAccessories();

		foreach ($accessories as $accessory)

			Db::getInstance()->execute(\'INSERT INTO `\'._DB_PREFIX_.\'accessory` (`id_product_1`, `id_product_2`) VALUES (\'.(int)$this->id.\', \'.(int)$accessory[\'id\'].\')\');



		return true;

	}



	/**

	* Webservice getter : get combination ids of current product for association

	*

	* @return array

	*/

	public function getWsCombinations()

	{

		$result = Db::getInstance()->executeS(

			\'SELECT pa.`id_product_attribute` as id

			FROM `\'._DB_PREFIX_.\'product_attribute` pa

			\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').\'

			WHERE pa.`id_product` = \'.(int)$this->id

		);



		return $result;

	}



	/**

	* Webservice setter : set combination ids of current product for association

	*

	* @param $combinations combination ids

	*/

	public function setWsCombinations($combinations)

	{

		// No hook exec

		$ids_new = array();

		foreach ($combinations as $combination)

			$ids_new[] = (int)$combination[\'id\'];



		$ids_orig = array();

		$original = Db::getInstance()->executeS(

			\'SELECT pa.`id_product_attribute` as id

			FROM `\'._DB_PREFIX_.\'product_attribute` pa

			\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').\'

			WHERE pa.`id_product` = \'.(int)$this->id

		);



		if (is_array($original))

			foreach ($original as $id)

				$ids_orig[] = $id[\'id\'];



		$all_ids = array();

		$all = Db::getInstance()->executeS(\'SELECT pa.`id_product_attribute` as id FROM `\'._DB_PREFIX_.\'product_attribute` pa \'.Shop::addSqlAssociation(\'product_attribute\', \'pa\'));

		if (is_array($all))

			foreach ($all as $id)

				$all_ids[] = $id[\'id\'];



		$to_add = array();

		foreach ($ids_new as $id)

			if (!in_array($id, $ids_orig))

				$to_add[] = $id;



		$to_delete = array();

		foreach ($ids_orig as $id)

			if (!in_array($id, $ids_new))

				$to_delete[] = $id;



		// Delete rows

		if (count($to_delete) > 0)

			foreach ($to_delete as $id)

			{

				$combination = new Combination($id);

				$combination->delete();

			}



		foreach ($to_add as $id)

		{

			// Update id_product if exists else create

			if (in_array($id, $all_ids))

				Db::getInstance()->execute(\'UPDATE `\'._DB_PREFIX_.\'product_attribute` SET id_product = \'.(int)$this->id.\' WHERE id_product_attribute=\'.$id);

			else

				Db::getInstance()->execute(\'INSERT INTO `\'._DB_PREFIX_.\'product_attribute` (`id_product`) VALUES (\'.$this->id.\')\');

		}

		return true;

	}



	/**

	* Webservice getter : get product option ids of current product for association

	*

	* @return array

	*/

	public function getWsProductOptionValues()

	{

		$result = Db::getInstance()->executeS(\'SELECT DISTINCT pac.id_attribute as id

			FROM `\'._DB_PREFIX_.\'product_attribute` pa

			\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').\'

			LEFT JOIN `\'._DB_PREFIX_.\'product_attribute_combination` pac ON (pac.id_product_attribute = pa.id_product_attribute)

			WHERE pa.id_product = \'.(int)$this->id);

		return $result;

	}



	/**

	* Webservice getter : get virtual field position in category

	*

	* @return int

	*/

	public function getWsPositionInCategory()

	{

		$result = Db::getInstance()->executeS(\'SELECT position

			FROM `\'._DB_PREFIX_.\'category_product`

			WHERE id_category = \'.(int)$this->id_category_default.\'

			AND id_product = \'.(int)$this->id);

		if (count($result) > 0)

			return $result[0][\'position\'];

		return \'\';

	}



	/**

	* Webservice setter : set virtual field position in category

	*

	* @return bool

	*/

	public function setWsPositionInCategory($position)

	{

		if ($position < 0) WebserviceRequest::getInstance()->setError(500, Tools::displayError(\'You cannot set a negative position, the minimum for a position is 0.\'), 134);

		$result = Db::getInstance()->executeS(\'

			SELECT `id_product`

			FROM `\'._DB_PREFIX_.\'category_product`

			WHERE `id_category` = \'.(int)$this->id_category_default.\'

			ORDER BY `position`

		\');

		if (($position > 0) && ($position + 1 > count($result)))

			WebserviceRequest::getInstance()->setError(500, Tools::displayError(\'You cannot set a position greater than the total number of products in the category, minus 1 (position numbering starts at 0).\'), 135);



		foreach ($result as &$value)

			$value = $value[\'id_product\'];

		$current_position = $this->getWsPositionInCategory();



		if ($current_position && isset($result[$current_position]))

		{

			$save = $result[$current_position];

			unset($result[$current_position]);

			array_splice($result, (int)$position, 0, $save);

		}



		foreach ($result as $position => $id_product)

		{

			Db::getInstance()->update(\'category_product\', array(

				\'position\' => $position,

			), \'`id_category` = \'.(int)$this->id_category_default.\' AND `id_product` = \'.(int)$id_product);

		}

		return true;

	}



	/**

	* Webservice getter : get virtual field id_default_image in category

	*

	* @return int

	*/

	public function getCoverWs()

	{

		$result = $this->getCover($this->id);

		return $result[\'id_image\'];

	}



	/**

	* Webservice setter : set virtual field id_default_image in category

	*

	* @return bool

	*/

	public function setCoverWs($id_image)

	{

		Db::getInstance()->execute(\'UPDATE `\'._DB_PREFIX_.\'image_shop` image_shop, `\'._DB_PREFIX_.\'image` i

			SET image_shop.`cover` = 0

			WHERE i.`id_product` = \'.(int)$this->id.\' AND i.id_image = image_shop.id_image

			AND image_shop.id_shop=\'.(int)Context::getContext()->shop->id);

		Db::getInstance()->execute(\'UPDATE `\'._DB_PREFIX_.\'image_shop`

			SET `cover` = 1 WHERE `id_image` = \'.(int)$id_image);



		return true;

	}



	/**

	* Webservice getter : get image ids of current product for association

	*

	* @return array

	*/

	public function getWsImages()

	{

		return Db::getInstance()->executeS(\'

		SELECT i.`id_image` as id

		FROM `\'._DB_PREFIX_.\'image` i

		\'.Shop::addSqlAssociation(\'image\', \'i\').\'

		WHERE i.`id_product` = \'.(int)$this->id.\'

		ORDER BY i.`position`\');

	}



	public function getWsStockAvailables()

	{

		return Db::getInstance()->executeS(\'SELECT `id_stock_available` id, `id_product_attribute`

														FROM `\'._DB_PREFIX_.\'stock_available`

														WHERE `id_product`=\'.($this->id).StockAvailable::addSqlShopRestriction());

	}



	public function getWsTags()

	{

		return Db::getInstance()->executeS(\'

		SELECT `id_tag` as id

		FROM `\'._DB_PREFIX_.\'product_tag`

		WHERE `id_product` = \'.(int)$this->id);

	}



	/**

	* Webservice setter : set tag ids of current product for association

	*

	* @param $tag_ids tag ids

	*/

	public function setWsTags($tag_ids)

	{

		$ids = array();

		foreach ($tag_ids as $value)

			$ids[] = $value[\'id\'];

		if ($this->deleteWsTags())

		{

			if ($ids)

			{

				$sql_values = \'\';

				$ids = array_map(\'intval\', $ids);

				foreach ($ids as $position => $id)

				{

					$id_lang = Db::getInstance()->getValue(\'SELECT `id_lang` FROM `\'._DB_PREFIX_.\'tag` WHERE `id_tag`=\'.(int)$id);

					$sql_values[] = \'(\'.(int)$this->id.\', \'.(int)$id.\', \'.(int)$id_lang.\')\';

				}

				$result = Db::getInstance()->execute(\'

					INSERT INTO `\'._DB_PREFIX_.\'product_tag` (`id_product`, `id_tag`, `id_lang`)

					VALUES \'.implode(\',\', $sql_values)

				);

				return $result;

			}

		}

		return true;

	}



	/**

	* Delete products tags entries without delete tags for webservice usage

	*

	* @return array Deletion result

	*/

	public function deleteWsTags()

	{

		return Db::getInstance()->delete(\'product_tag\', \'id_product = \'.(int)$this->id);

	}





	public function getWsManufacturerName()

	{

		return Manufacturer::getNameById((int)$this->id_manufacturer);

	}



	public static function resetEcoTax()

	{

		return ObjectModel::updateMultishopTable(\'product\', array(

			\'ecotax\' => 0,

		));

	}



	/**

	 * Set Group reduction if needed

	 */

	public function setGroupReduction()

	{

		return GroupReduction::setProductReduction($this->id);

	}



	/**

	 * Checks if reference exists

	 * @return bool

	 */

	public function existsRefInDatabase($reference)

	{

		$row = Db::getInstance()->getRow(\'

		SELECT `reference`

		FROM `\'._DB_PREFIX_.\'product` p

		WHERE p.reference = "\'.pSQL($reference).\'"\');



		return isset($row[\'reference\']);

	}



	/**

	 * Get all product attributes ids

	 *

	 * @since 1.5.0

	 * @param int $id_product the id of the product

	 * @return array product attribute id list

	 */

	public static function getProductAttributesIds($id_product, $shop_only = false)

	{

		return Db::getInstance()->executeS(\'

		SELECT pa.id_product_attribute

		FROM `\'._DB_PREFIX_.\'product_attribute` pa\'.

		($shop_only ? Shop::addSqlAssociation(\'product_attribute\', \'pa\') : \'\').\'

		WHERE pa.`id_product` = \'.(int)$id_product);

	}



	/**

	 * Get label by lang and value by lang too

	 * @todo Remove existing module condition

	 * @param int $id_product

	 * @param int $product_attribute_id

	 * @return array

	 */

	public static function getAttributesParams($id_product, $id_product_attribute)

	{

		$id_lang = (int)Context::getContext()->language->id;

		$id_shop = (int)Context::getContext()->shop->id;

		$cache_id = \'Product::getAttributesParams_\'.(int)$id_product.\'-\'.(int)$id_product_attribute.\'-\'.(int)$id_lang.\'-\'.(int)$id_shop;



		// if blocklayered module is installed we check if user has set custom attribute name

		if (Module::isInstalled(\'blocklayered\') && Module::isEnabled(\'blocklayered\'))

		{

			$nb_custom_values = Db::getInstance()->executeS(\'

			SELECT DISTINCT la.`id_attribute`, la.`url_name` as `name`

			FROM `\'._DB_PREFIX_.\'attribute` a

			LEFT JOIN `\'._DB_PREFIX_.\'product_attribute_combination` pac

				ON (a.`id_attribute` = pac.`id_attribute`)

			LEFT JOIN `\'._DB_PREFIX_.\'product_attribute` pa

				ON (pac.`id_product_attribute` = pa.`id_product_attribute`)

			\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').\'

			LEFT JOIN `\'._DB_PREFIX_.\'layered_indexable_attribute_lang_value` la

				ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = \'.(int)$id_lang.\')

			WHERE la.`url_name` IS NOT NULL AND la.`url_name` != \'\'

			AND pa.`id_product` = \'.(int)$id_product.\'

			AND pac.`id_product_attribute` = \'.(int)$id_product_attribute);



			if (!empty($nb_custom_values))

			{

				$tab_id_attribute = array();

				foreach ($nb_custom_values as $attribute)

				{

					$tab_id_attribute[] = $attribute[\'id_attribute\'];



					$group = Db::getInstance()->executeS(\'

					SELECT a.`id_attribute`, g.`id_attribute_group`, g.`url_name` as `group`

					FROM `\'._DB_PREFIX_.\'layered_indexable_attribute_group_lang_value` g

					LEFT JOIN `\'._DB_PREFIX_.\'attribute` a

						ON (a.`id_attribute_group` = g.`id_attribute_group`)

					WHERE a.`id_attribute` = \'.(int)$attribute[\'id_attribute\'].\'

					AND g.`id_lang` = \'.(int)$id_lang.\'

					AND g.`url_name` IS NOT NULL AND g.`url_name` != \'\'\');

					if (empty($group))

					{

						$group = Db::getInstance()->executeS(\'

						SELECT g.`id_attribute_group`, g.`name` as `group`

						FROM `\'._DB_PREFIX_.\'attribute_group_lang` g

						LEFT JOIN `\'._DB_PREFIX_.\'attribute` a

							ON (a.`id_attribute_group` = g.`id_attribute_group`)

						WHERE a.`id_attribute` = \'.(int)$attribute[\'id_attribute\'].\'

						AND g.`id_lang` = \'.(int)$id_lang.\'

						AND g.`name` IS NOT NULL\');

					}

					$result[] = array_merge($attribute, $group[0]);

				}

				$values_not_custom = Db::getInstance()->executeS(\'

				SELECT DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`

				FROM `\'._DB_PREFIX_.\'attribute` a

				LEFT JOIN `\'._DB_PREFIX_.\'attribute_lang` al

					ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = \'.(int)$id_lang.\')

				LEFT JOIN `\'._DB_PREFIX_.\'attribute_group_lang` agl

					ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = \'.(int)$id_lang.\')

				LEFT JOIN `\'._DB_PREFIX_.\'product_attribute_combination` pac

					ON (a.`id_attribute` = pac.`id_attribute`)

				LEFT JOIN `\'._DB_PREFIX_.\'product_attribute` pa

					ON (pac.`id_product_attribute` = pa.`id_product_attribute`)

				\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').\'

				WHERE pa.`id_product` = \'.(int)$id_product.\'

				AND pac.id_product_attribute = \'.(int)$id_product_attribute.\'

				AND a.`id_attribute` NOT IN(\'.implode(\', \', $tab_id_attribute).\')\');

				return array_merge($values_not_custom, $result);

			}

		}



		if (!Cache::isStored($cache_id))

		{

			$result = Db::getInstance()->executeS(\'

			SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`

			FROM `\'._DB_PREFIX_.\'attribute` a

			LEFT JOIN `\'._DB_PREFIX_.\'attribute_lang` al

				ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = \'.(int)$id_lang.\')

			LEFT JOIN `\'._DB_PREFIX_.\'product_attribute_combination` pac

				ON (pac.`id_attribute` = a.`id_attribute`)

			LEFT JOIN `\'._DB_PREFIX_.\'product_attribute` pa

				ON (pa.`id_product_attribute` = pac.`id_product_attribute`)

			\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').\'

			LEFT JOIN `\'._DB_PREFIX_.\'attribute_group_lang` agl

				ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = \'.(int)$id_lang.\')

			WHERE pa.`id_product` = \'.(int)$id_product.\'

				AND pac.`id_product_attribute` = \'.(int)$id_product_attribute.\'

				AND agl.`id_lang` = \'.(int)$id_lang);

			Cache::store($cache_id, $result);

		}

		else

			$result = Cache::retrieve($cache_id);

		return $result;

	}



	/**

	 * @todo Remove existing module condition

	 * @param int $id_product

	 */

	public static function getAttributesInformationsByProduct($id_product)

	{

		// if blocklayered module is installed we check if user has set custom attribute name

		if (Module::isInstalled(\'blocklayered\') && Module::isEnabled(\'blocklayered\'))

		{

			$nb_custom_values = Db::getInstance()->executeS(\'

			SELECT DISTINCT la.`id_attribute`, la.`url_name` as `attribute`

			FROM `\'._DB_PREFIX_.\'attribute` a

			LEFT JOIN `\'._DB_PREFIX_.\'product_attribute_combination` pac

				ON (a.`id_attribute` = pac.`id_attribute`)

			LEFT JOIN `\'._DB_PREFIX_.\'product_attribute` pa

				ON (pac.`id_product_attribute` = pa.`id_product_attribute`)

			\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').\'

			LEFT JOIN `\'._DB_PREFIX_.\'layered_indexable_attribute_lang_value` la

				ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = \'.(int)Context::getContext()->language->id.\')

			WHERE la.`url_name` IS NOT NULL AND la.`url_name` != \'\'

			AND pa.`id_product` = \'.(int)$id_product);



			if (!empty($nb_custom_values))

			{

				$tab_id_attribute = array();

				foreach ($nb_custom_values as $attribute)

				{

					$tab_id_attribute[] = $attribute[\'id_attribute\'];



					$group = Db::getInstance()->executeS(\'

					SELECT g.`id_attribute_group`, g.`url_name` as `group`

					FROM `\'._DB_PREFIX_.\'layered_indexable_attribute_group_lang_value` g

					LEFT JOIN `\'._DB_PREFIX_.\'attribute` a

						ON (a.`id_attribute_group` = g.`id_attribute_group`)

					WHERE a.`id_attribute` = \'.(int)$attribute[\'id_attribute\'].\'

					AND g.`id_lang` = \'.(int)Context::getContext()->language->id.\'

					AND g.`url_name` IS NOT NULL AND g.`url_name` != \'\'\');

					if (empty($group))

					{

						$group = Db::getInstance()->executeS(\'

						SELECT g.`id_attribute_group`, g.`name` as `group`

						FROM `\'._DB_PREFIX_.\'attribute_group_lang` g

						LEFT JOIN `\'._DB_PREFIX_.\'attribute` a

							ON (a.`id_attribute_group` = g.`id_attribute_group`)

						WHERE a.`id_attribute` = \'.(int)$attribute[\'id_attribute\'].\'

						AND g.`id_lang` = \'.(int)Context::getContext()->language->id.\'

						AND g.`name` IS NOT NULL\');

					}

					$result[] = array_merge($attribute, $group[0]);

				}

				$values_not_custom = Db::getInstance()->executeS(\'

				SELECT DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`

				FROM `\'._DB_PREFIX_.\'attribute` a

				LEFT JOIN `\'._DB_PREFIX_.\'attribute_lang` al

					ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = \'.(int)Context::getContext()->language->id.\')

				LEFT JOIN `\'._DB_PREFIX_.\'attribute_group_lang` agl

					ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = \'.(int)Context::getContext()->language->id.\')

				LEFT JOIN `\'._DB_PREFIX_.\'product_attribute_combination` pac

					ON (a.`id_attribute` = pac.`id_attribute`)

				LEFT JOIN `\'._DB_PREFIX_.\'product_attribute` pa

					ON (pac.`id_product_attribute` = pa.`id_product_attribute`)

				\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').\'

				\'.Shop::addSqlAssociation(\'attribute\', \'pac\').\'

				WHERE pa.`id_product` = \'.(int)$id_product.\'

				AND a.`id_attribute` NOT IN(\'.implode(\', \', $tab_id_attribute).\')\');

				$result = array_merge($values_not_custom, $result);

			}

			else

			{

				$result = Db::getInstance()->executeS(\'

				SELECT DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`

				FROM `\'._DB_PREFIX_.\'attribute` a

				LEFT JOIN `\'._DB_PREFIX_.\'attribute_lang` al

					ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = \'.(int)Context::getContext()->language->id.\')

				LEFT JOIN `\'._DB_PREFIX_.\'attribute_group_lang` agl

					ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = \'.(int)Context::getContext()->language->id.\')

				LEFT JOIN `\'._DB_PREFIX_.\'product_attribute_combination` pac

					ON (a.`id_attribute` = pac.`id_attribute`)

				LEFT JOIN `\'._DB_PREFIX_.\'product_attribute` pa

					ON (pac.`id_product_attribute` = pa.`id_product_attribute`)

				\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').\'

				\'.Shop::addSqlAssociation(\'attribute\', \'pac\').\'

				WHERE pa.`id_product` = \'.(int)$id_product);

			}

		}

		else

		{

			$result = Db::getInstance()->executeS(\'

			SELECT DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`

			FROM `\'._DB_PREFIX_.\'attribute` a

			LEFT JOIN `\'._DB_PREFIX_.\'attribute_lang` al

				ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = \'.(int)Context::getContext()->language->id.\')

			LEFT JOIN `\'._DB_PREFIX_.\'attribute_group_lang` agl

				ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = \'.(int)Context::getContext()->language->id.\')

			LEFT JOIN `\'._DB_PREFIX_.\'product_attribute_combination` pac

				ON (a.`id_attribute` = pac.`id_attribute`)

			LEFT JOIN `\'._DB_PREFIX_.\'product_attribute` pa

				ON (pac.`id_product_attribute` = pa.`id_product_attribute`)

			\'.Shop::addSqlAssociation(\'product_attribute\', \'pa\').\'

			\'.Shop::addSqlAssociation(\'attribute\', \'pac\').\'

			WHERE pa.`id_product` = \'.(int)$id_product);

		}

		return $result;

	}



	/**

	 * Get the combination url anchor of the product

	 *

	 * @param int $id_product_attribute

	 * @return string

	 */

	public function getAnchor($id_product_attribute, $with_id = false)

	{

		$attributes = Product::getAttributesParams($this->id, $id_product_attribute);

		$anchor = \'#\';

		$sep = Configuration::get(\'PS_ATTRIBUTE_ANCHOR_SEPARATOR\');

		foreach ($attributes as &$a)

		{

			foreach ($a as &$b)

				$b = str_replace($sep, \'_\', Tools::link_rewrite($b));

			$anchor .= \'/\'.($with_id && isset($a[\'id_attribute\']) && $a[\'id_attribute\']? (int)$a[\'id_attribute\'].$sep : \'\').$a[\'group\'].$sep.$a[\'name\'];

		}

		return $anchor;

	}



	/**

	 * Gets the name of a given product, in the given lang

	 *

	 * @since 1.5.0

	 * @param int $id_product

	 * @param int $id_product_attribute Optional

	 * @param int $id_lang Optional

	 * @return string

	 */

	public static function getProductName($id_product, $id_product_attribute = null, $id_lang = null)

	{

		// use the lang in the context if $id_lang is not defined

		if (!$id_lang)

			$id_lang = (int)Context::getContext()->language->id;



		// creates the query object

		$query = new DbQuery();



		// selects different names, if it is a combination

		if ($id_product_attribute)

			$query->select(\'IFNULL(CONCAT(pl.name, \' : \', GROUP_CONCAT(DISTINCT agl.`name`, \' - \', al.name SEPARATOR \', \')),pl.name) as name\');

		else

			$query->select(\'DISTINCT pl.name as name\');



		// adds joins & where clauses for combinations

		if ($id_product_attribute)

		{

			$query->from(\'product_attribute\', \'pa\');

			$query->join(Shop::addSqlAssociation(\'product_attribute\', \'pa\'));

			$query->innerJoin(\'product_lang\', \'pl\', \'pl.id_product = pa.id_product AND pl.id_lang = \'.(int)$id_lang.Shop::addSqlRestrictionOnLang(\'pl\'));

			$query->leftJoin(\'product_attribute_combination\', \'pac\', \'pac.id_product_attribute = pa.id_product_attribute\');

			$query->leftJoin(\'attribute\', \'atr\', \'atr.id_attribute = pac.id_attribute\');

			$query->leftJoin(\'attribute_lang\', \'al\', \'al.id_attribute = atr.id_attribute AND al.id_lang = \'.(int)$id_lang);

			$query->leftJoin(\'attribute_group_lang\', \'agl\', \'agl.id_attribute_group = atr.id_attribute_group AND agl.id_lang = \'.(int)$id_lang);

			$query->where(\'pa.id_product = \'.(int)$id_product.\' AND pa.id_product_attribute = \'.(int)$id_product_attribute);

		}

		else // or just adds a \'where\' clause for a simple product

		{

			$query->from(\'product_lang\', \'pl\');

			$query->where(\'pl.id_product = \'.(int)$id_product);

			$query->where(\'pl.id_lang = \'.(int)$id_lang.Shop::addSqlRestrictionOnLang(\'pl\'));

		}



		return Db::getInstance()->getValue($query);

	}



	public function addWs($autodate = true, $null_values = false)

	{

		$success = $this->add($autodate, $null_values);

		if ($success && Configuration::get(\'PS_SEARCH_INDEXATION\'))

			Search::indexation(false, $this->id);

		return $success;

	}



	public function updateWs($null_values = false)

	{

		$success = parent::update($null_values);

		if ($success && Configuration::get(\'PS_SEARCH_INDEXATION\'))

			Search::indexation(false, $this->id);

		Hook::exec(\'updateProduct\', array(\'id_product\' => (int)$this->id));

		return $success;

	}



	/**

	 * For a given product, returns its real quantity

	 *

	 * @since 1.5.0

	 * @param int $id_product

	 * @param int $id_product_attribute

	 * @param int $id_warehouse

	 * @param int $id_shop

	 * @return int real_quantity

	 */

	public static function getRealQuantity($id_product, $id_product_attribute = 0, $id_warehouse = 0, $id_shop = null)

	{

		static $manager = null;



		if (Configuration::get(\'PS_ADVANCED_STOCK_MANAGEMENT\') && is_null($manager))

			$manager = StockManagerFactory::getManager();



		if (Configuration::get(\'PS_ADVANCED_STOCK_MANAGEMENT\') && Product::usesAdvancedStockManagement($id_product) &&

			StockAvailable::dependsOnStock($id_product, $id_shop))

			return $manager->getProductRealQuantities($id_product, $id_product_attribute, $id_warehouse, true);

		else

			return StockAvailable::getQuantityAvailableByProduct($id_product, $id_product_attribute, $id_shop);

	}



	/**

	 * For a given product, tells if it uses the advanced stock management

	 *

	 * @since 1.5.0

	 * @param int $id_product

	 * @return bool

	 */

	public static function usesAdvancedStockManagement($id_product)

	{

		$query = new DbQuery;

		$query->select(\'product_shop.advanced_stock_management\');

		$query->from(\'product\', \'p\');

		$query->join(Shop::addSqlAssociation(\'product\', \'p\'));

		$query->where(\'p.id_product = \'.(int)$id_product);



		return (bool)Db::getInstance()->getValue($query);

	}



	/**

	 * This method allows to flush price cache

	 *

	 * @since 1.5.0

	 */

	public static function flushPriceCache()

	{

		self::$_prices = array();

		self::$_pricesLevel2 = array();

	}



	/**

	 * Get list of parent categories

	 *

	 * @since 1.5.0

	 * @param int $id_lang

	 * @return array

	 */

	public function getParentCategories($id_lang = null)

	{

		if (!$id_lang)

			$id_lang = Context::getContext()->language->id;



		$interval = Category::getInterval($this->id_category_default);

		$sql = new DbQuery();

		$sql->from(\'category\', \'c\');

		$sql->leftJoin(\'category_lang\', \'cl\', \'c.id_category = cl.id_category AND id_lang = \'.(int)$id_lang.Shop::addSqlRestrictionOnLang(\'cl\'));

		$sql->where(\'c.nleft <= \'.(int)$interval[\'nleft\'].\' AND c.nright >= \'.(int)$interval[\'nright\']);

		$sql->orderBy(\'c.nleft\');



		return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);

	}



	/**

	 * Fill the variables used for stock management

	 */

	public function loadStockData()

	{

		if (Validate::isLoadedObject($this))

		{

			// By default, the product quantity correspond to the available quantity to sell in the current shop

			$this->quantity = StockAvailable::getQuantityAvailableByProduct($this->id, 0);

			$this->out_of_stock = StockAvailable::outOfStock($this->id);

			$this->depends_on_stock = StockAvailable::dependsOnStock($this->id);

			if (Context::getContext()->shop->getContext() == Shop::CONTEXT_GROUP && Context::getContext()->shop->getContextShopGroup()->share_stock == 1)

				$this->advanced_stock_management = $this->useAdvancedStockManagement();

		}

	}



	public function useAdvancedStockManagement()

	{

		return Db::getInstance()->getValue(\'

					SELECT `advanced_stock_management`

					FROM \'._DB_PREFIX_.\'product_shop

					WHERE id_product=\'.(int)$this->id.Shop::addSqlRestriction()

				);

	}



	public function setAdvancedStockManagement($value)

	{

		$this->advanced_stock_management = (int)$value;

		if (Context::getContext()->shop->getContext() == Shop::CONTEXT_GROUP && Context::getContext()->shop->getContextShopGroup()->share_stock == 1)

			Db::getInstance()->execute(\'

				UPDATE `\'._DB_PREFIX_.\'product_shop`

				SET `advanced_stock_management`=\'.(int)$value.\'

				WHERE id_product=\'.(int)$this->id.Shop::addSqlRestriction()

			);

		else

		{

			$this->setFieldsToUpdate(array(\'advanced_stock_management\' => true));

			$this->save();

		}

	}



	/**

	 * get the default category according to the shop

	 */

	public function getDefaultCategory()

	{

		$default_category = Db::getInstance()->getValue(\'

			SELECT product_shop.`id_category_default`

			FROM `\'._DB_PREFIX_.\'product` p

			\'.Shop::addSqlAssociation(\'product\', \'p\').\'

			WHERE p.`id_product` = \'.(int)$this->id);



		if (!$default_category)

			return array(\'id_category_default\' => Context::getContext()->shop->id_category);

		else

			return $default_category;



	}



	public static function getShopsByProduct($id_product)

	{

		return Db::getInstance()->executeS(\'

			SELECT `id_shop`

			FROM `\'._DB_PREFIX_.\'product_shop`

			WHERE `id_product` = \'.(int)$id_product);

	}



	/**

	 * Remove all downloadable files for product and its attributes

	 *

	 * @return bool

	 */

	public function deleteDownload()

	{

		$result = true;

		$collection_download = new PrestaShopCollection(\'ProductDownload\');

		$collection_download->where(\'id_product\', \'=\', $this->id);

		foreach ($collection_download as $product_download)

		{

			/** @var ProductDownload $product_download */

			$result &= $product_download->delete($product_download->checkFile());

		}

		return $result;

	}



	/**

	 * @deprecated 1.5.0.10

	 * @see Product::getAttributeCombinations()

	 * @param int $id_lang

	 */

	public function getAttributeCombinaisons($id_lang)

	{

		Tools::displayAsDeprecated(\'Use Product::getAttributeCombinations($id_lang)\');

		return $this->getAttributeCombinations($id_lang);

	}



	/**

	 * @deprecated 1.5.0.10

	 * @see Product::deleteAttributeCombination()

	 * @param int $id_product_attribute

	 */

	public function deleteAttributeCombinaison($id_product_attribute)

	{

		Tools::displayAsDeprecated(\'Use Product::deleteAttributeCombination($id_product_attribute)\');

		return $this->deleteAttributeCombination($id_product_attribute);

	}



	/**

	 * Get the product type (simple, virtual, pack)

	 * @since in 1.5.0

	 *

	 * @return int

	 */

	public function getType()

	{

		if (!$this->id)

			return Product::PTYPE_SIMPLE;

		if (Pack::isPack($this->id))

			return Product::PTYPE_PACK;

		if ($this->is_virtual)

			return Product::PTYPE_VIRTUAL;



		return Product::PTYPE_SIMPLE;

	}



	public function hasAttributesInOtherShops()

	{

		return (bool)Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue(\'

			SELECT pa.id_product_attribute

			FROM `\'._DB_PREFIX_.\'product_attribute` pa

			LEFT JOIN `\'._DB_PREFIX_.\'product_attribute_shop` pas ON (pa.`id_product_attribute` = pas.`id_product_attribute`)

			WHERE pa.`id_product` = \'.(int)$this->id

		);

	}



	public static function getIdTaxRulesGroupMostUsed()

	{

		return Db::getInstance()->getValue(\'

					SELECT id_tax_rules_group

					FROM (

						SELECT COUNT(*) n, product_shop.id_tax_rules_group

						FROM \'._DB_PREFIX_.\'product p

						\'.Shop::addSqlAssociation(\'product\', \'p\').\'

						JOIN \'._DB_PREFIX_.\'tax_rules_group trg ON (product_shop.id_tax_rules_group = trg.id_tax_rules_group)

						WHERE trg.active = 1 AND trg.deleted = 0

						GROUP BY product_shop.id_tax_rules_group

						ORDER BY n DESC

						LIMIT 1

					) most_used\'

				);

	}



	/**

	 * For a given ean13 reference, returns the corresponding id

	 *

	 * @param string $ean13

	 * @return int id

	 */

	public static function getIdByEan13($ean13)

	{

		if (empty($ean13))

			return 0;



		if (!Validate::isEan13($ean13))

			return 0;



		$query = new DbQuery();

		$query->select(\'p.id_product\');

		$query->from(\'product\', \'p\');

		$query->where(\'p.ean13 = \'\'.pSQL($ean13).\'\'\');



		return Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($query);

	}



	public function getWsType()

	{

		$type_information = array(

			Product::PTYPE_SIMPLE => \'simple\',

			Product::PTYPE_PACK => \'pack\',

			Product::PTYPE_VIRTUAL => \'virtual\',

		);

		return $type_information[$this->getType()];

	}



	/*

		Create the link rewrite if not exists or invalid on product creation

	*/

	public function modifierWsLinkRewrite()

	{

		foreach ($this->name as $id_lang => $name)

		{

			if (empty($this->link_rewrite[$id_lang]))

				$this->link_rewrite[$id_lang] = Tools::link_rewrite($name);

			elseif (!Validate::isLinkRewrite($this->link_rewrite[$id_lang]))

				$this->link_rewrite[$id_lang] = Tools::link_rewrite($this->link_rewrite[$id_lang]);

		}



		return true;

	}



	public function getWsProductBundle()

	{

		return Db::getInstance()->executeS(\'SELECT id_product_item as id, quantity FROM \'._DB_PREFIX_.\'pack WHERE id_product_pack = \'.(int)$this->id);

	}



	public function setWsType($type_str)

	{

		$reverse_type_information = array(

			\'simple\' => Product::PTYPE_SIMPLE,

			\'pack\' => Product::PTYPE_PACK,

			\'virtual\' => Product::PTYPE_VIRTUAL,

		);



		if (!isset($reverse_type_information[$type_str]))

			return false;



		$type = $reverse_type_information[$type_str];



		if (Pack::isPack((int)$this->id) && $type != Product::PTYPE_PACK)

			Pack::deleteItems($this->id);



		$this->cache_is_pack = ($type == Product::PTYPE_PACK);

		$this->is_virtual = ($type == Product::PTYPE_VIRTUAL);



		return true;

	}



	public function setWsProductBundle($items)

	{

		if ($this->is_virtual)

			return false;



		Pack::deleteItems($this->id);



		foreach ($items as $item)

			if ((int)$item[\'id\'] > 0)

				Pack::addItem($this->id, (int)$item[\'id\'], (int)$item[\'quantity\']);

		return true;

	}



	public function isColorUnavailable($id_attribute, $id_shop)

	{

		return Db::getInstance()->getValue(\'

			SELECT sa.id_product_attribute

			FROM \'._DB_PREFIX_.\'stock_available sa

			WHERE id_product=\'.(int)$this->id.\' AND quantity <= 0 \'.StockAvailable::addSqlShopRestriction(null, $id_shop, \'sa\').\' AND EXISTS ( SELECT 1 FROM \'._DB_PREFIX_.\'product_attribute pa JOIN \'._DB_PREFIX_.\'product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop=\'.(int)$id_shop.\') JOIN \'._DB_PREFIX_.\'product_attribute_combination pac ON (pac.id_product_attribute AND product_attribute_shop.id_product_attribute) WHERE sa.id_product_attribute = pa.id_product_attribute AND pa.id_product=\'.(int)$this->id.\' AND pac.id_attribute=\'.(int)$id_attribute.\'

			)\'

		);

	}



	public static function getColorsListCacheId($id_product)

	{

		return \'productlist_colors|\'.(int)$id_product.\'|\'.(int)Context::getContext()->shop->id.\'|\'.(int)Context::getContext()->cookie->id_lang;

	}



	public static function setPackStockType($id_product, $pack_stock_type)

	{

		return Db::getInstance()->execute(\'UPDATE \'._DB_PREFIX_.\'product p

		\'.Shop::addSqlAssociation(\'product\', \'p\').\' SET product_shop.pack_stock_type = \'.(int)$pack_stock_type.\' WHERE p.`id_product` = \'.(int)$id_product);

	}

}

<?php

/*

* 2007-2015 PrestaShop

*

* NOTICE OF LICENSE

*

* This source file is subject to the Open Software License (OSL 3.0)

* that is bundled with this package in the file LICENSE.txt.

* It is also available through the world-wide-web at this URL:

* http://opensource.org/licenses/osl-3.0.php

* If you did not receive a copy of the license and are unable to

* obtain it through the world-wide-web, please send an email

* to license@prestashop.com so we can send you a copy immediately.

*

* DISCLAIMER

*

* Do not edit or add to this file if you wish to upgrade PrestaShop to newer

* versions in the future. If you wish to customize PrestaShop for your

* needs please refer to http://www.prestashop.com for more information.

*

*  @author PrestaShop SA <contact@prestashop.com>

*  @copyright  2007-2015 PrestaShop SA

*  @license    http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)

*  International Registered Trademark & Property of PrestaShop SA

*/



class FeatureValueCore extends ObjectModel

{

	/** @var int Group id which attribute belongs */

	public $id_feature;



	/** @var string Name */

	public $value;



	/** @var bool Custom */

	public $custom = 0;



	/**

	 * @see ObjectModel::$definition

	 */

	public static $definition = array(

		\'table\' => \'feature_value\',

		\'primary\' => \'id_feature_value\',

		\'multilang\' => true,

		\'fields\' => array(

			\'id_feature\' => array(\'type\' => self::TYPE_INT, \'validate\' => \'isUnsignedId\', \'required\' => true),

			\'custom\' => 	array(\'type\' => self::TYPE_BOOL, \'validate\' => \'isBool\'),



			/* Lang fields */

			\'value\' => 		array(\'type\' => self::TYPE_STRING, \'lang\' => true, \'validate\' => \'isCleanHtml\', \'required\' => true, \'size\' => 4500000000000),

		),

	);



	protected $webserviceParameters = array(

		\'objectsNodeName\' => \'product_feature_values\',

		\'objectNodeName\' => \'product_feature_value\',

		\'fields\' => array(

			\'id_feature\' => array(\'xlink_resource\'=> \'product_features\'),

		),

	);



	/**

	 * Get all values for a given feature

	 *

	 * @param bool $id_feature Feature id

	 * @return array Array with feature\'s values

	 */

	public static function getFeatureValues($id_feature)

	{

		return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(\'

			SELECT *

			FROM `\'._DB_PREFIX_.\'feature_value`

			WHERE `id_feature` = \'.(int)$id_feature

		);

	}



	/**

	 * Get all values for a given feature and language

	 *

	 * @param int $id_lang Language id

	 * @param bool $id_feature Feature id

	 * @return array Array with feature\'s values

	 */

	public static function getFeatureValuesWithLang($id_lang, $id_feature, $custom = false)

	{

		return Db::getInstance()->executeS(\'

			SELECT *

			FROM `\'._DB_PREFIX_.\'feature_value` v

			LEFT JOIN `\'._DB_PREFIX_.\'feature_value_lang` vl

				ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = \'.(int)$id_lang.\')

			WHERE v.`id_feature` = \'.(int)$id_feature.\'

				\'.(!$custom ? \'AND (v.`custom` IS NULL OR v.`custom` = 0)\' : \'\').\'

			ORDER BY vl.`value` ASC

		\');

	}



	/**

	 * Get all language for a given value

	 *

	 * @param bool $id_feature_value Feature value id

	 * @return array Array with value\'s languages

	 */

	public static function getFeatureValueLang($id_feature_value)

	{

		return Db::getInstance()->executeS(\'

			SELECT *

			FROM `\'._DB_PREFIX_.\'feature_value_lang`

			WHERE `id_feature_value` = \'.(int)$id_feature_value.\'

			ORDER BY `id_lang`

		\');

	}



	/**

	 * Select the good lang in tab

	 *

	 * @param array $lang Array with all language

	 * @param int $id_lang Language id

	 * @return string String value name selected

	 */

	public static function selectLang($lang, $id_lang)

	{

		foreach ($lang as $tab)

			if ($tab[\'id_lang\'] == $id_lang)

				return $tab[\'value\'];

	}



	public static function addFeatureValueImport($id_feature, $value, $id_product = null, $id_lang = null, $custom = false)

	{

		$id_feature_value = false;

		if (!is_null($id_product) && $id_product)

		{

			$id_feature_value = Db::getInstance()->getValue(\'

				SELECT fp.`id_feature_value`

				FROM \'._DB_PREFIX_.\'feature_product fp

				INNER JOIN \'._DB_PREFIX_.\'feature_value fv USING (`id_feature_value`)

				WHERE fp.`id_feature` = \'.(int)$id_feature.\'

				AND fv.`custom` = \'.(int)$custom.\'

				AND fp.`id_product` = \'.(int)$id_product);



			if ($custom && $id_feature_value && !is_null($id_lang) && $id_lang)

				Db::getInstance()->execute(\'

				UPDATE \'._DB_PREFIX_.\'feature_value_lang

				SET `value` = \'\'.pSQL($value).\'\'

				WHERE `id_feature_value` = \'.(int)$id_feature_value.\'

				AND `value` != \'\'.pSQL($value).\'\'

				AND `id_lang` = \'.(int)$id_lang);

		}



		if (!$custom)

			$id_feature_value = Db::getInstance()->getValue(\'

				SELECT fv.`id_feature_value`

				FROM \'._DB_PREFIX_.\'feature_value fv

				LEFT JOIN \'._DB_PREFIX_.\'feature_value_lang fvl ON (fvl.`id_feature_value` = fv.`id_feature_value` AND fvl.`id_lang` = \'.(int)$id_lang.\')

				WHERE `value` = \'\'.pSQL($value).\'\'

				AND fv.`id_feature` = \'.(int)$id_feature.\'

				AND fv.`custom` = 0

				GROUP BY fv.`id_feature_value`\');



		if ($id_feature_value)

			return (int)$id_feature_value;



		// Feature doesn\'t exist, create it

		$feature_value = new FeatureValue();

		$feature_value->id_feature = (int)$id_feature;

		$feature_value->custom = (bool)$custom;

		$feature_value->value = array_fill_keys(Language::getIDs(false), $value);

		$feature_value->add();



		return (int)$feature_value->id;

	}



	public function add($autodate = true, $nullValues = false)

	{

		$return = parent::add($autodate, $nullValues);

		if ($return)

			Hook::exec(\'actionFeatureValueSave\', array(\'id_feature_value\' => $this->id));

		return $return;

	}



	public function delete()

	{

		/* Also delete related products */

		Db::getInstance()->execute(\'

			DELETE FROM `\'._DB_PREFIX_.\'feature_product`

			WHERE `id_feature_value` = \'.(int)$this->id

		);

		$return = parent::delete();



		if ($return)

			Hook::exec(\'actionFeatureValueDelete\', array(\'id_feature_value\' => $this->id));

		return $return;

	}



	public function update($nullValues = false)

	{

		$return = parent::update($nullValues);

		if ($return)

			Hook::exec(\'actionFeatureValueSave\', array(\'id_feature_value\' => $this->id));

		return $return;

	}

}