function act_updateActualStock($paraArr)
{
$sku = $paraArr['sku'];
//sku
$pId = $paraArr['pId'];
//skuId
$positionId = $paraArr['positionId'];
//仓位ID
$amount = $paraArr['amount'];
//数量
$ioType = $paraArr['ioType'];
//出/入库，1为出库，2为入库
$storeId = isset($paraArr['storeId']) ? intval($paraArr['storeId']) : 1;
//仓库，默认为1
if (empty($sku)) {
self::$errCode = '0401';
self::$errMsg = 'sku';
return 0;
}
if (empty($amount)) {
self::$errCode = '0501';
self::$errMsg = 'empty amount';
return 0;
}
if ($ioType != 1 && $ioType != 2) {
self::$errCode = '1101';
self::$errMsg = 'error ioType';
return 0;
}
$tName = 'wh_sku_location';
if ($ioType == 1) {
$amount = -1 * $amount;
} else {
$amount = "+" . $amount;
}
$set = "SET actualStock=actualStock" . $amount;
$where = "WHERE sku='{$sku}' AND storeId='{$storeId}'";
$affectRow = WhIoRecordsModel::updateTNameRow($tName, $set, $where);
if ($affectRow) {
$tName2 = 'wh_product_position_relation';
$set2 = "SET nums=nums" . $amount;
$where2 = "WHERE pId='{$pId}' AND positionId='{$positionId}' LIMIT 1";
$affectRow2 = WhIoRecordsModel::updateTNameRow($tName2, $set2, $where2);
self::$errCode = '200';
self::$errMsg = 'success';
return 1;
} else {
self::$errCode = '404';
//库存加减错误
self::$errMsg = 'error';
return 0;
}
}
