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