public function add() { $db = JFactory::getDBO(); $query = "INSERT INTO " . $db->quoteName('#__jeproshop_specific_price') . "(" . $db->quoteName('specific_price_rule_id'); $query .= ", " . $db->quoteName('product_id') . ", " . $db->quoteName('shop_id') . ", " . $db->quoteName('shop_group_id'); $query .= ", " . $db->quoteName('currency_id') . ", " . $db->quoteName('country_id') . ", " . $db->quoteName('group_id'); $query .= ", " . $db->quoteName('customer_id') . ", " . $db->quoteName('product_attribute_id') . ", " . $db->quoteName('price'); $query .= ", " . $db->quoteName('from_quantity') . ", " . $db->quoteName('reduction') . ", " . $db->quoteName('reduction_type'); $query .= ", " . $db->quoteName('from') . ", " . $db->quoteName('to') . ") VALUES (" . (int) $this->specific_price_rule_id . ", "; $query .= (int) $this->product_id . ", " . (int) $this->shop_id . ", " . (int) $this->shop_group_id . ", " . (int) $this->currency_id . ", "; $query .= (int) $this->country_id . ", " . (int) $this->group_id . ", " . (int) $this->customer_id . ", " . (int) $this->product_attribute_id; $query .= ", " . (double) $this->price . ", " . (int) $this->from_quantity . ", " . (double) $this->reduction . ", " . $db->quote($this->reduction_type); $query .= ", " . $db->quote($this->from) . ", " . $db->quote($this->to) . ")"; $db->setQuery($query); if ($db->query()) { // Flush cache when we adding a new specific price JeproshopSpecificPriceModelSpecificPrice::$_specific_price_cache = array(); JeproshopProductModelProduct::flushPriceCache(); // Set cache of feature detachable to true JeproshopSettingModelSetting::updateValue('specific_price_feature_active', '1'); return true; } return false; }