public static
setNewOriginalPrice
(mixed $productId, mixed $price_original, mixed $price, mixed $params)
public static function setNewOriginalPrice($productId, $price_original, $price, $params)
{
$db = Factory::getDBO();
$original_price_change_run = $params->get('original_price_change_run', 0);
if ($original_price_change_run == 0) {
// No change
return $price_original;
} else {
if ($original_price_change_run == 1) {
// Current price becomes new original price
$query = 'UPDATE #__phocacart_products SET price_original = ' . $db->quote($price) . ' WHERE id = ' . (int) $productId;
$db->setQuery($query);
$db->execute();
return $price;
} else {
if ($original_price_change_run == 2) {
// Original price will be emptied
$query = 'UPDATE #__phocacart_products SET price_original = \'0\' WHERE id = ' . (int) $productId;
$db->setQuery($query);
$db->execute();
return '';
}
}
}
return $price_original;
}