public function updateProductPrice($id_product)
{
$product_sbm = $this->GetMultiCurrency($id_product);
$def_currency = CurrencyCore::getDefaultCurrency();
$sbm_currency = new Currency((int) $product_sbm['id_currency']);
$new_product_price = (double) $product_sbm['product_price'] * ($def_currency->conversion_rate / $sbm_currency->conversion_rate);
$new_product_sale_price = (double) $product_sbm['product_sale_price'] * ($def_currency->conversion_rate / $sbm_currency->conversion_rate);
// $new_product_price = (float)$this->priceRound($new_product_price);
// $new_product_sale_price = (float)$this->priceRound($new_product_sale_price);
$sql1 = "UPDATE `" . _DB_PREFIX_ . "product` SET \n\t \t\t\t\t\t\t\t\t`price` = " . $new_product_price . ", \n\t \t\t\t\t\t\t\t\t`wholesale_price` = " . $new_product_sale_price . " \n\t \t\t\t\t\t\t\t\tWHERE `id_product` = " . $id_product . " LIMIT 1 ";
$sql2 = "UPDATE `" . _DB_PREFIX_ . "product_shop` SET \n\t \t\t\t\t\t\t\t\t`price` = " . $new_product_price . ",\t\n\t \t\t\t\t\t\t\t\t`wholesale_price` = " . $new_product_sale_price . " \n\t \t\t\t\t\t\t\t\tWHERE `id_product` = " . $id_product . " ";
if (Db::getInstance()->Execute($sql1, false) and Db::getInstance()->Execute($sql2, false)) {
return true;
}
return false;
}
