public static function setProductReduction($product_id, $group_id = null, $category_id, $reduction = null) { $res = true; JeproshopGroupReductionModelGroupReduction::deleteProductReduction((int) $product_id); $reductions = JeproshopGroupReductionModelGroupReduction::getGroupsByCategoryId((int) $category_id); if ($reductions) { $db = JFactory::getDBO(); foreach ($reductions as $reduction) { $query = "INSERT INTO " . $db->quoteName('#__jeproshop_product_group_reduction_cache') . " (" . $db->quoteName('product_id'); $query .= ", " . $db->quoteName('group_id') . ", " . $db->quoteName('reduction') . ") VALUES (" . (int) $product_id . ", "; $query .= (int) $reduction->group_id . ", " . (double) $reduction->reduction . ")"; $db->setQuery($query); $res &= $db->query(); } } return $res; }