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; } }