Sorry I forgot to include the code it's below
Posted: 2021-04-05 19:19
function InventoryItem_after_insert($data, $memberInfo, &$args) {
$new_qty=sqlvalue("SELECT IFNULL(i.Quantity,0)-{$data['Add']} from InventoryItem i where i.itemtype= {$data['itemtype']}");
sqlvalue("UPDATE Inventoryitem i set i.Quantity = {$new_qty} where i.itemtype ={$data['itemtype']}");
return TRUE;
}
$new_qty=sqlvalue("SELECT IFNULL(i.Quantity,0)-{$data['Add']} from InventoryItem i where i.itemtype= {$data['itemtype']}");
sqlvalue("UPDATE Inventoryitem i set i.Quantity = {$new_qty} where i.itemtype ={$data['itemtype']}");
return TRUE;
}