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;
}
