public static function updateInv($sku, $invPeopleId, $storeId = 1)
{
self::initDB();
$time = time();
$sql = "select actualStock from wh_sku_location where sku='{$sku}' and storeId={$storeId} ";
$sku_location = self::$dbConn->fetch_first($sql);
if (empty($sku_location)) {
$invNums = 0;
} else {
$invNums = $sku_location['actualStock'];
}
$update_sql = "update wh_waitforInventory_list set invStatus=1,invNums={$invNums},invPeopleId={$invPeopleId},invTime={$time} \n\t\t\t\t\t\t where sku='{$sku}' and invStatus=0 and storeId={$storeId}";
$query = self::$dbConn->query($update_sql);
if ($query) {
return true;
} else {
self::$errCode = "003";
self::$errMsg = "error";
return false;
}
}
