public function act_packageCheck()
{
//print_r($_POST);
//ob_start();
$infoarr = $_POST['infoarr'];
//print_r($infoarr);exit;
$userId = $_SESSION['userId'];
$checkUser = intval(trim($_POST['checkUser']));
$storeId = intval(trim($_POST['storeId']));
$storeId = $storeId ? $storeId : 1;
if (empty($infoarr) || !$checkUser) {
self::$errCode = 201;
self::$errMsg = "点货人或点货详情为空！请确认！";
return false;
}
if (empty($userId)) {
self::$errCode = 202;
self::$errMsg = "登录超时，请先登录！";
return false;
}
$message = "";
$sku_arr = array();
$time = date('YmdHis', time());
//批次号时间
$rand_arr = range(10, 2000);
//批次号随机数组
//foreach($infoarr as $key => $value){
// $info = explode("*",$value);
// $sku = trim($info[0]);
// $skuinfo = packageCheckModel::selectSku($sku);
// if(!$skuinfo || empty($skuinfo)){
// self::$errCode = 401;
// self::$errMsg = "此sku {$sku} 不存在";
//
// return false;
// }
// }
OmAvailableModel::begin();
foreach ($infoarr as $key => $value) {
$insertArr = array();
//插入数据初始化
$info = explode("*", $value);
if (!empty($info[0]) && !empty($info[1])) {
$entryStatus = 0;
$sku = trim($info[0]);
$amount = trim($info[1]);
if ($amount <= 0) {
self::$errCode = 401;
self::$errMsg = "此{$sku} :数量必须大于0";
return FALSE;
}
$skuinfo = packageCheckModel::selectSku($sku);
//检测sku是否存在
if (!$skuinfo) {
self::$errCode = 401;
self::$errMsg = "此sku {$sku} 不存在";
OmAvailableModel::rollback();
return false;
} else {
if (array_key_exists($sku, $sku_arr)) {
$sornum = $sku_arr[$sku] + 1;
$sku_arr[$sku] = $sornum;
} else {
$sornum = 1;
$sku_new_arr = array($sku => 1);
$sku_arr = array_merge($sku_arr, $sku_new_arr);
}
$skuid = $skuinfo[0]['id'];
$purchaseId = $skuinfo[0]['purchaseId'];
$insertArr['batchNum'] = $time . $skuid . $sornum . array_shift($rand_arr);
}
//判断是否是包材料号
$is_package = preg_match("/^MT\\d+\$/", $sku);
if ($is_package) {
$checkOnWaySku = 0;
//包材料号不许推送采购
$insertArr['ichibanNums'] = $amount;
$insertArr['ichibanTime'] = time();
} else {
//验证sku在途数量是否足够
//print_r($amount);exit;
$checkOnWaySku = checkSkuPackage($sku, $amount);
}
if ($checkOnWaySku == 0) {
$skulocation = packageCheckModel::selectStore($sku, $storeId);
if (!empty($skulocation)) {
$msg = packageCheckModel::updateStore($sku, $amount, $storeId);
} else {
$msg = packageCheckModel::insertStore($sku, $amount, $storeId);
}
if (!$msg) {
self::$errCode = 402;
self::$errMsg = "sku {$sku} 更新库存失败";
OmAvailableModel::rollback();
return false;
}
} else {
$entryStatus = 1;
}
$insertArr['sku'] = $sku;
$insertArr['num'] = $amount;
$insertArr['tallyUserId'] = $checkUser;
$insertArr['entryUserId'] = $userId;
$insertArr['entryTime'] = time();
$insertArr['purchaseId'] = $purchaseId;
$insertArr['storeId'] = $storeId;
$insertArr['entryStatus'] = $entryStatus;
$queryinfo = packageCheckModel::insertRecord($insertArr);
if ($queryinfo) {
if ($checkOnWaySku == 1) {
$message .= "<font color='#FF0000'>料号{$sku} 点货数量{$amount} 异常，需到异常录入确认数量并推送采购系统！</font><br>";
} else {
$message .= "料号{$sku} 点货数量{$amount} 录入系统成功！<br>";
}
} else {
$arr['errCode'] = 403;
OmAvailableModel::rollback();
$message .= "料号{$sku} 点货数量{$amount} 录入系统失败！请确认！<br>";
}
}
}
OmAvailableModel::commit();
return urlencode($message);
}
public function act_whShelf()
{
//print_r($_POST);
$userCnName = $_SESSION['userCnName'];
$sku = trim($_POST['sku']);
$sku = get_goodsSn($sku);
$nums = $_POST['nums'];
$select_now_position = $_POST['select_now_position'];
$select_now_store = $_POST['select_now_store'];
$select_hope_position = $_POST['select_hope_position'];
$select_hope_store = $_POST['select_hope_store'];
if (empty($sku)) {
self::$errCode = 401;
self::$errMsg = "sku不能为空";
return false;
}
if (empty($select_now_position) && empty($select_now_store) && empty($select_hope_position) && empty($select_hope_store)) {
self::$errCode = 401;
self::$errMsg = "上架位置不能为空";
return false;
}
/*
$where = "where sku='{$sku}' and tallyStatus=0";
$tallying_list = packageCheckModel::selectList($where);
if(empty($tallying_list)){
self::$errCode = 402;
self::$errMsg = "无该料号点货信息";
return false;
}else{
$tallying_num = 0;
foreach($tallying_list as $tallying){
$tallying_num += $tallying['ichibanNums']-$tallying['shelvesNums'];
}
if($nums>$tallying_num){
self::$errCode = 402;
self::$errMsg = "上架数不能大于点货良品数[{$tallying_num}]";
return false;
}
}
*/
if ($nums < 1) {
self::$errCode = 403;
self::$errMsg = "上架数量不能小于1";
return false;
}
$where = " where sku = '{$sku}'";
$skuinfo = whShelfModel::selectSku($where);
if (empty($skuinfo)) {
self::$errCode = 404;
self::$errMsg = "无该料号信息";
return false;
} else {
$skuId = $skuinfo['id'];
$purchaseId = $skuinfo['purchaseId'];
}
/*
$purInfo = CommonModel::endPurchaseOrder($sku,$nums); //api获取采购订单处理情况
if($purInfo!=0){
self::$errCode = 405;
self::$errMsg = "完结采购订单出错,上架失败";
return false;
}
//更新旧erp库存
$update_onhand = CommonModel::updateOnhand($sku,$nums);
if($update_onhand==0){
self::$errCode = 415;
self::$errMsg = "更新erp库存失败";
return false;
}*/
$return_num = $nums;
$in_positionId = 0;
$userId = $_SESSION['userId'];
TransactionBaseModel::begin();
/****插入采购未订单记录****/
/*
if($return_num>0){
$where = " where sku = '{$sku}' and tallyStatus=0";
$list = whShelfModel::selectList($where);
$purchaseId = $list[0]['purchaseId'];
$totalNums = 0;
foreach($list as $key=>$value){
$totalNums += $value['num'];
}
if ($return_num==$nums){
$reach_note = "sku[{$sku}]到货{$nums}个,未找到该料号的订单,请物料点货确认和采购补单!";
}else{
$reach_note = "sku[{$sku}]到货{$nums}个,入库完毕后还多余{$return_num}个,请物料点货确认和采购补单!";
}
$msg = whShelfModel::insertNoOrder($sku,$return_num,$totalNums,$purchaseId,$userId,$reach_note);
if(!$msg){
self::$errCode = whShelfModel::$errCode;
self::$errMsg = whShelfModel::$errMsg;
return false;
}
}
*/
/***无料号对应仓位的关系时更新关系表***/
if ($select_hope_store != 0 || $select_hope_position != 0) {
$type = 1;
$positionId = $select_hope_position;
if ($select_hope_store != 0) {
$type = 2;
$positionId = $select_hope_store;
}
$in_positionId = $positionId;
$tname = "wh_product_position_relation";
$set = "set pId='{$skuId}',positionId='{$positionId}',nums='{$nums}',type='{$type}',storeId=2";
$insert_relation = OmAvailableModel::insertRow($tname, $set);
if (!$insert_relation) {
self::$errCode = 408;
self::$errMsg = "插入关系表失败！";
TransactionBaseModel::rollback();
return false;
}
//更新仓位使用状态
$update_position = OmAvailableModel::updateTNameRow("wh_position_distribution", "set is_enable=1", "where id={$positionId}");
if ($update_position === false) {
self::$errCode = 409;
self::$errMsg = "更新仓位使用状态失败！";
TransactionBaseModel::rollback();
return false;
}
}
//更新指定仓位存货数量
if ($select_now_store != 0) {
$positioninfo = whShelfModel::selectRelation("where id={$select_now_store}");
$in_positionId = $positioninfo[0]['positionId'];
$update_position = whShelfModel::updateProductPositionRelation($nums, "where id='{$select_now_store}'");
if (!$update_position) {
self::$errCode = 410;
self::$errMsg = "更新仓位库存失败！";
TransactionBaseModel::rollback();
return false;
}
}
if ($select_now_store == 0 && $select_hope_position == 0 && $select_hope_store == 0) {
$positioninfo = whShelfModel::selectRelation("where id={$select_now_position}");
$in_positionId = $positioninfo[0]['positionId'];
$update_position = whShelfModel::updateProductPositionRelation($nums, "where id='{$select_now_position}'");
if (!$update_position) {
self::$errCode = 411;
self::$errMsg = "更新仓位库存失败！";
TransactionBaseModel::rollback();
return false;
}
}
/**** 更新总库存 *****/
$actualStock = whShelfModel::selectSkuNums($sku, 2);
if (!empty($actualStock)) {
$where = "where sku='{$sku}' and storeId=2";
$info = whShelfModel::updateStoreNum($nums, $where);
if (!$info) {
self::$errCode = 412;
self::$errMsg = "更新总库存失败！";
TransactionBaseModel::rollback();
return false;
}
} else {
$info = packageCheckModel::insertStore($sku, $nums, 2);
if (!$info) {
self::$errCode = 412;
self::$errMsg = "更新总库存失败！";
TransactionBaseModel::rollback();
return false;
}
}
/**** 插入出入库记录 *****/
$paraArr = array('sku' => $sku, 'amount' => $nums, 'positionId' => $in_positionId, 'purchaseId' => $purchaseId, 'ioType' => 2, 'ioTypeId' => 13, 'userId' => $userId, 'reason' => '上架入库', 'storeId' => 2);
$record = CommonModel::addIoRecores($paraArr);
//出库记录
if (!$record) {
self::$errCode = 413;
self::$errMsg = "插入出入库记录失败！";
TransactionBaseModel::rollback();
return false;
}
/*
//更新点货记录状态
$where = "where sku='{$sku}' and tallyStatus=0 and ichibanNums>0";
$list = packageCheckModel::selectList($where);
$i = 0;
while($list[$i]&&$nums){
$need_nums = $list[$i]['ichibanNums']-$list[$i]['shelvesNums'];
if($nums >= $need_nums){
//更改状态
$msg = whShelfModel::updateTallyStatus($list[$i]['id'],$need_nums);
if(!$msg){
self::$errCode = 413;
self::$errMsg = "更新点货记录状态失败！";
TransactionBaseModel :: rollback();
return false;
}
$nums = $nums-$need_nums;
}else{
$msg = whShelfModel::updateShelfNum($list[$i]['id'],$nums);
if(!$msg){
self::$errCode = 414;
self::$errMsg = "更新点货记录已上架数量失败！";
TransactionBaseModel :: rollback();
return false;
}
$nums = 0;
}
$i++;
}
*/
/*
$purInfo = CommonModel::endPurchaseOrder($sku,$return_num); //api获取采购订单处理情况
if($purInfo!=0){
self::$errCode = 405;
self::$errMsg = "完结采购订单出错,上架失败";
TransactionBaseModel :: rollback();
return false;
}
//更新旧erp库存
$position_info = PositionModel::getPositionList("pName","where id={$in_positionId}");
$update_onhand = CommonModel::updateOnhand($sku,$return_num,$userCnName,$position_info[0]['pName']);
if($update_onhand==0){
self::$errCode = 415;
self::$errMsg = "更新旧erp库存失败";
TransactionBaseModel :: rollback();
return false;
}
*/
TransactionBaseModel::commit();
self::$errMsg = "料号[{$sku}]上架成功！";
return true;
}
