$id_product = Tools::getValue('id_product');
$id_product_attribute = Tools::getValue('id_product_attribute');
$wholesale_price = Tools::getValue('wholesale_price');
$id_supplier = Tools::getValue('id_supplier');
/* If we have a price for this supplier update for the supplier
* At any case we update principal price for product or attribute
*/
$query = 'SELECT COUNT(id_product_supplier) as nb_products, id_product_supplier
FROM ' . _DB_PREFIX_ . 'product_supplier
WHERE id_product = ' . (int) $id_product . ' AND id_product_attribute = ' . (int) $id_product_attribute . ' ' . 'AND id_supplier = ' . (int) $id_supplier . ' AND product_supplier_price_te >0.000000';
$nbProducts = DB::getInstance(_PS_USE_SQL_SLAVE_)->getRow($query);
/* If price for this supplier, update */
if ((int) $nbProducts['nb_products'] > 0) {
$product_supplier = new ErpProductSupplier($nbProducts['id_product_supplier']);
$product_supplier->product_supplier_price_te = $wholesale_price;
$product_supplier->save();
}
/* If not global update of the product in any case */
/* Product */
if ($id_product_attribute == '0') {
$product = new Product($id_product);
$product->wholesale_price = $wholesale_price;
$product->save();
} else {
$combination = new Combination($id_product_attribute);
$combination->id_product = $id_product;
$combination->wholesale_price = $wholesale_price;
$combination->save();
}
$update = DB::getInstance(_PS_USE_SQL_SLAVE_)->execute($query);
echo $update;
