function act_getGroupInfo() { $userId = $_SESSION['userId']; $shipOrderGroup = $_POST['order_group']; $group_sql = WhGoodsAssignModel::getOrderGroup("*", array('assignNumber' => $shipOrderGroup)); //var_dump($group_sql);exit; if (empty($group_sql)) { self::$errCode = "001"; self::$errMsg = "该调拨单号不存在,请重新输入!"; return false; } if ($group_sql[0]['status'] != 106) { self::$errCode = "002"; self::$errMsg = "调拨单只有在接收复核后才可完结!"; return false; } $orderIds = WhGoodsAssignModel::getAssignOrderIds($group_sql[0]['id']); if (!$orderIds) { self::$errCode = "003"; self::$errMsg = "该调拨单下没有关联的B仓订单!"; return false; } $ids = array(); foreach ($orderIds as $id) { $ids[] = $id['orderId']; } TransactionBaseModel::begin(); //更新调拨单状态 $info = WhGoodsAssignModel::updateAssignListStatus(array('id' => $group_sql[0]['id']), array('status' => 107)); if (!$info) { self::$errCode = "004"; self::$errMsg = "更新调拨单状态失败!"; TransactionBaseModel::rollback(); return false; } $ids = implode(',', $ids); $info = CommonModel::updateOrderStatus($ids, 745); if ($info['errCode'] != 200) { self::$errCode = "004"; self::$errMsg = "同步旧ERP订单状态失败!"; TransactionBaseModel::rollback(); return false; } self::$errCode = "0"; self::$errMsg = "调拨单完结成功!"; TransactionBaseModel::commit(); return TRUE; }
function act_getGroupInfo() { $userId = $_SESSION['userId']; $shipOrderGroup = $_POST['order_group']; $group_sql = WhGoodsAssignModel::getOrderGroup("*", array('assignNumber' => $shipOrderGroup)); //var_dump($group_sql);exit; if (empty($group_sql)) { self::$errCode = "003"; self::$errMsg = "该调拨单号不存在,请重新输入!"; return false; } else { if ($group_sql[0]['status'] != 104) { self::$errCode = "003"; self::$errMsg = "该调拨单不在待出库状态!"; return false; } if ($group_sql[0]['status'] == 105) { self::$errCode = "0"; self::$errMsg = "该调拨单已完成出库扫描,请扫描其他清单!"; return false; } //$sku_info = WhGoodsAssignModel::getDetail( $group_sql[0]['id'] ," and a.checkUid = 0"); // if(!empty($sku_info)){ // self::$errCode = "004"; // self::$errMsg = "该调拨单仍有料号未复核!"; // return FALSE; // }else{ $where = array('id' => $group_sql[0]['id']); $update = array('status' => 105, 'statusTime' => time()); $sku_info = WhGoodsAssignModel::updateAssignListStatus($where, $update); if (!$sku_info) { self::$errCode = "004"; self::$errMsg = "调拨单出库状态变更失败!"; return FALSE; } else { self::$errCode = "0"; self::$errMsg = "调拨清单出库成功!"; return TRUE; } //} } }
function act_endAssignList() { $assignNumber = $_POST['group'] ? $_POST['group'] : 0; //$goodsAssignId = intval($goodsAssignId); if (!$assignNumber) { self::$errCode = "014"; self::$errMsg = "请输入调拨单号!"; return false; } $assingInfo = WhGoodsAssignModel::getOrderGroup('id, status', array('assignNumber' => $assignNumber)); if (empty($assingInfo)) { self::$errCode = "014"; self::$errMsg = "该调拨单不存在!"; return false; } if ($assingInfo[0]['status'] != 101) { self::$errCode = "015"; self::$errMsg = "该调拨单不是待配货状态!"; return FALSE; } $where = array('id' => $assingInfo[0]['id']); $update = array('status' => 102, 'statusTime' => time()); $info = WhGoodsAssignModel::updateAssignListStatus($where, $update); if (!$info) { self::$errCode = "016"; self::$errMsg = "更新调拨单状态失败!"; return FALSE; } else { self::$errCode = "0"; self::$errMsg = "该调拨单已完成配货,请输入下一调拨单号!"; return TRUE; } }
/** * WhGoodsAssignAct::act_editList() * 调拨单修改 * @return void */ public function act_editList() { $outStoreId = intval($_POST['outStoreId']); $inStoreId = intval($_POST['inStoreId']); $createdUid = intval($_POST['createdUid']); $sku = $_POST['sku'] ? $_POST['sku'] : array(); $num = $_POST['num'] ? $_POST['num'] : array(); $id = intval(trim($_POST['id'])) ? intval(trim($_POST['id'])) : 0; //print_r($id);exit; if ($outStoreId == $inStoreId) { self::$errCode = 401; self::$errMsg = '转出仓库和转入仓库不能相同!'; return $res; exit; } if (!$outStoreId || !$inStoreId || !is_array($sku) || !is_array($num) || count($sku) != count($num) || !$id) { self::$errCode = 402; self::$errMsg = '数据不完整!'; return $res; exit; } //$assignNumber = self::buildAssignNumber(); //获取调拨单编号 TransactionBaseModel::begin(); //删除原来的调拨明细 $where = array('goodsAssignId' => $id); $update = array('is_delete' => 1); $info = WhGoodsAssignModel::updateAssignDetail($where, $update); if (!$info) { self::$errCode = 403; self::$errMsg = '调拨明细清除不成功!调拨单修改失败!'; TransactionBaseModel::rollback(); return $res; exit; } //更新调拨单信息 $where = array('id' => $id); $update = array('inStoreId' => $inStoreId, 'outStoreId' => $outStoreId); $info = WhGoodsAssignModel::updateAssignListStatus($where, $update); $listDetails = self::buildDetails($sku, $num, $outStoreId, $id); //拼接调拨单明数据 if ($listDetails === FALSE) { self::$errCode = 404; self::$errMsg = '参数不正确,生成调拨明细失败!'; TransactionBaseModel::rollback(); return $res; exit; } $info = WhGoodsAssignModel::addAssignListDetail($listDetails); if ($info == FALSE) { self::$errCode = 405; self::$errMsg = '生成调拨明细表失败!'; TransactionBaseModel::rollback(); return $res; exit; } TransactionBaseModel::commit(); self::$errCode = 200; self::$errMsg = '修改成功!'; return $res; }
function act_checkSkuNum() { $bool = false; //标志是否有摒弃订单 $assignNUmber = $_POST['order_group']; $sku = trim($_POST['sku']); $sku = get_goodsSn($sku); $sku_num = intval($_POST['sku_num']); $goodsAssignId = intval($_POST['now_group_id']); $sku_info = WhGoodsAssignModel::getDetail($goodsAssignId, " and a.sku='{$sku}' and a.scanUid != 0"); if (empty($sku_info)) { self::$errCode = "001"; self::$errMsg = "该调拨单无此出库复核料号!"; return FALSE; } else { if ($sku_info['assignNum'] <= $sku_info['outCheckNum']) { self::$errCode = "002"; self::$errMsg = "该料号已完成出库复核!"; return FALSE; } $outCheckNum = $sku_info['outCheckNum'] + $sku_num; //系统累计出库复核数量 if ($outCheckNum > $sku_info['assignNum']) { self::$errCode = "003"; self::$errMsg = "总复核数量不能大于配货数量,请确认!"; return false; } //print_r($sku_info);exit; $where = array('goodsAssignId' => $goodsAssignId, 'sku' => $sku); //生成where条件 $update = array('outCheckNum' => $outCheckNum); if ($outCheckNum >= $sku_info['assignNum']) { $update['checkTime'] = time(); $update['checkUid'] = $_SESSION['userId']; } $arr = array('sku' => $sku, 'sku_amount' => $sku_info['assignNum'], 'check_num' => $outCheckNum); $info = WhGoodsAssignModel::updateAssignDetail($where, $update); if (!$info) { self::$errCode = "004"; self::$errMsg = "更新出库明细复核数量失败!"; return $arr; } if (isset($update['checkUid'])) { $assignList = WhGoodsAssignModel::getDetail($goodsAssignId, ' and a.checkUid=0 and a.scanUid !=0'); if (empty($assignList)) { //该调拨单下所有料号复核完毕 $where = array('id' => $goodsAssignId); $update = array('statusTime' => time(), 'status' => 103); $info = WhGoodsAssignModel::updateAssignListStatus($where, $update); if ($info) { self::$errCode = "006"; self::$errMsg = "该调拨单出库复核完毕!"; return $arr; } else { self::$errCode = "005"; self::$errMsg = "调拨单更新失败!"; return FALSE; } } else { self::$errCode = "0"; self::$errMsg = "该料号复核完毕!"; return $arr; } } else { self::$errCode = "0"; self::$errMsg = "该料号已复核,请录入下一料号!"; return $arr; } } }
/** * InCheckPdaAssignListAct::act_inCheckEnd() * 调拨单接收复核完成变更状态 * @return void */ function act_inCheckEnd() { $assignNumber = trim($_POST['group_id']); if (!preg_match("/AN\\d{8}/", $assignNumber)) { self::$errCode = '001'; self::$errMsg = '请不要输入非调拨单号!'; return FALSE; } $group_sql = WhGoodsAssignModel::getOrderGroup("id, status", array('assignNumber' => $assignNumber)); if (empty($group_sql)) { self::$errCode = '002'; self::$errMsg = '没有该调拨单号!'; return FALSE; } //print_r($group_sql);exit; if ($group_sql[0]['status'] != 105) { self::$errCode = '003'; self::$errMsg = '该调拨单不在接收复核状态!'; return FALSE; } $assignId = $group_sql[0]['id']; //$assignDetail = WhGoodsAssignModel::getDetail($assignId, ' and inCheckNum = 0'); // if(empty($assignDetail)){ // // } $where = array('id' => $assignId); $update = array('status' => 106, 'statusTime' => time()); $info = WhGoodsAssignModel::updateAssignListStatus($where, $update); if ($info) { self::$errCode = '200'; self::$errMsg = '该调拨单复核接收完成!'; return TRUE; } else { self::$errCode = '004'; self::$errMsg = '该调拨单复核接收完成!'; return FALSE; } }