OpenCart 🇺🇦

$this->log('updateReserve() - start');
$this->log('updateReserve() - $product_id: '.$product_id);
$this->log('updateReserve() - $item_id: '.$item_id);
$this->log('updateReserve() - $reserve: '.$reserve);
$this->log('updateReserve() - $sku: '.$sku);
$this->log('updateReserve() - $variant: '.$variant);

if($reserve == 0) {
	$this->deleteReserve($product_id, $item_id, $sku);
}else{
	if($this->getReserve($product_id, $item_id, $sku) != false) {
		$this->db->query("UPDATE `" . DB_PREFIX . "ebay_stock_reserve` SET `reserve` = '".(int)$reserve."' WHERE `product_id` = '".(int)$product_id."' AND `variant_id` = '".$this->db->escape($sku)."' AND `item_id` = '".$this->db->escape($item_id)."'  LIMIT 1");
	}else{
		if($variant == 0) {
			$this->log('updateReserve() - not a variant');
			$this->addReserve(array('product_id' => $product_id, 'qty' => array(0 => $reserve)), $item_id, 0);
		}else{
			$this->log('updateReserve() - variant');
			$this->addReserve(array('product_id' => $product_id, 'opt' => array(array('sku' => $sku, 'qty' => $reserve))), $item_id, 1);
		}
	}
}