<?php $product.price = $pri; class GroupReductionCore extends ObjectModel { public $id_group; public $id_category; public $reduction; protected $fieldsValidate = array('id_group' => 'isUnsignedId', 'id_category' => 'isUnsignedId', 'reduction' => 'isPrice'); protected $table = 'group_reduction'; protected $identifier = 'id_group_reduction'; public function getFields() { parent::validateFields(); $fields['id_group'] = (int)($this->id_group); $fields['id_category'] = (int)($this->id_category); $fields['reduction'] = (float)($this->reduction); return $fields; } public function add($autodate = true, $nullValues = false) { return (parent::add($autodate, $nullValues) AND $this->_setCache()); } public function update($nullValues = false) { return (parent::update($nullValues) AND $this->_clearCache() AND $this->_setCache()); } public function delete() { return $this->_clearCache() AND parent::delete(); } protected function _clearCache() { return Db::getInstance()->Execute('DELETE FROM `'._DB_PREFIX_.'product_group_reduction_cache` WHERE `id_group` = '.(int)($this->id_group)); } protected function _setCache() { $resource = Db::getInstance()->ExecuteS(' SELECT cp.`id_product` FROM `'._DB_PREFIX_.'category_product` cp INNER JOIN `'._DB_PREFIX_.'product` p ON (p.`id_product` = cp.`id_product`) WHERE cp.`id_category` = '.(int)($this->id_category) , false); $query = 'INSERT INTO `'._DB_PREFIX_.'product_group_reduction_cache` (`id_product`, `id_group`, `reduction`) VALUES '; while ($row = Db::getInstance()->nextRow($resource)) $query .= '('.(int)($row['id_product']).', '.(int)($this->id_group).', '.(float)($this->reduction).'), '; } { return Db::getInstance()->ExecuteS(' SELECT gr.`id_group_reduction`, gr.`id_group`, gr.`id_category`, gr.`reduction`, cl.`name` AS category_name FROM `'._DB_PREFIX_.'group_reduction` gr LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON (cl.`id_category` = gr.`id_category` AND cl.`id_lang` = '.(int)($id_lang).') WHERE `id_group` = '.(int)($id_group) ); } { self::$reductionCache[$id_product.'-'.$id_group] = Db::getInstance()->getValue('SELECT `reduction` FROM `'._DB_PREFIX_.'product_group_reduction_cache` WHERE `id_product` = '.(int)($id_product).' AND `id_group` = '.(int)($id_group)); return self::$reductionCache[$id_product.'-'.$id_group]; } { return (bool)Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue('SELECT `id_group` FROM `'._DB_PREFIX_.'group_reduction` WHERE `id_group` = '.(int)($id_group).' AND `id_category` = '.(int)($id_category)); } }
na początku kodu to dodałem:
$product.price = $pri; Jak to dodałem strona mi się wywaliła.. http://www.pneumaticon.pl/presta/ Plik : GroupReduction.php