<?php
echo 'start';
function recuperation_info_product_et_decrementation($reference, $stock_fichier, $isDeclinaison){ /* Fonction de récupèration et décrementation produit */
global $version_sup_egale_1531;
$product_infos = array();
$tables = array('product_attribute');
if($isDeclinaison === false) {
array_unshift($tables, 'product');
}
foreach($tables as $table) {
$query = 'SELECT * FROM `'._DB_PREFIX_.$table.'` WHERE `reference` = "'.$reference.'";';
$result = Db::getInstance()->executeS($query);
if($result !== false) {
$product_infos = $result[0];
decremente_stock($product_infos['id_product'], $qty, $reference, $table);
break;
}
}
return $product_infos;
}
/* fonction qui retourne l'IdProduct et l'IdProductAttribute du produit commandé */
function recuperation_idProduct_idProductAttribute($reference_fichier){
$product_infos = array();
$query = 'SELECT * FROM `'._DB_PREFIX_.'product` WHERE `reference` = "'.pSQL($reference).'";';
$result = Db::getInstance()->executeS($query);
$product_infos['id_product'] = $result[0]['id_product'];
$query = 'SELECT * FROM `'._DB_PREFIX_.'product_attribute` WHERE `reference` = "'.pSQL($reference).'";';
$result = Db::getInstance()->executeS($query);
$product_infos['id_product_attribute'] = $result[0]['id_product_attribute'];
return $product_infos;
}
function decremente_stock($id_product, $qty, $reference, $table) {
switch ($GLOBALS['versionPourSwitch']){
case '1.5.4.0': // [-] Core: Hook actionUpdateQuantity was not called for product without attributes which depends on the physical stock
$query = ' UPDATE `'._DB_PREFIX_.'stock_available`
SET quantity = (quantity - "'.$qty.'")
WHERE id_product = "'.$id_product.'"
AND `reference` = "'.$reference.'";';
Db::getInstance()->execute($query);
$query2 = ' UPDATE `'._DB_PREFIX_.'stock`
SET physical_quantity = (physical_quantity - "'.$qty.'")
WHERE id_product = "'.$id_product.'"
AND `reference` = "'.$reference.'";';
Db::getInstance()->execute($query2);
break;
default:
if($version_sup_egale_1531) {
$query = ' UPDATE `'._DB_PREFIX_.'stock_available`
SET quantity = (quantity - "'.$qty.'")
WHERE id_product = "'.$id_product.'"
AND `reference` = "'.$reference.'";';
}
else {
$query = ' UPDATE `'._DB_PREFIX_.$table.'`
SET quantity = (quantity - "'.$qty.'")
WHERE id_product = "'.$id_product.'"
AND `reference` = "'.$reference.'";';
}
Db::getInstance()->execute($query);
break;
}
}
echo 'done';
- Output for 5.0.0 - 5.0.5, 5.1.0 - 5.1.6, 5.2.0 - 5.2.17, 5.3.0 - 5.3.29, 5.4.0 - 5.4.45, 5.5.0 - 5.5.38, 5.6.0 - 5.6.28, 7.0.0 - 7.0.20, 7.1.0 - 7.1.33, 7.2.0 - 7.2.33, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.6
- startdone
- Output for 4.4.2 - 4.4.9
- Parse error: syntax error, unexpected T_OBJECT_OPERATOR in /in/COcFH on line 14
Process exited with code 255. - Output for 4.3.0 - 4.3.1, 4.3.5 - 4.3.11, 4.4.0 - 4.4.1
- Parse error: parse error, unexpected T_OBJECT_OPERATOR in /in/COcFH on line 14
Process exited with code 255. - Output for 4.3.2 - 4.3.4
- Parse error: parse error in /in/COcFH on line 14
Process exited with code 255.
preferences:
246.62 ms | 401 KiB | 390 Q