public function act_search($buyer_userid = "", $recordnumber = "") { if (!empty($buyer_userid) || !empty($recordnumber)) { $paramArr = array('method' => 'erp.scan_returnSearch.php', 'buyer_userid' => $buyer_userid, 'recordnumber' => ${$recordnumber}); $data = UserCacheModel::callOpenSystem2($paramArr); return $data; } else { self::$errCode = "301"; self::$errMsg = "非法搜索条件不"; return false; } }
public function view_printOrder() { @session_start(); $orderId = isset($_GET['orderId']) ? trim($_GET['orderId']) : NULL; if (empty($orderId)) { goErrMsgPage(array('data' => array('缺少参数!'), 'link' => 'index.php?mod=owGoodsReplenishManage&act=showOrderList')); exit; } $preObj = new PreGoodsOrdderManageModel(); $idar = explode(",", $orderId); $idar = array_map('intval', $idar); $finalAr = array(); foreach ($idar as $id) { $newData = array(); $orderInf = $preObj->getOrderInfroByid($id); if (FALSE == $orderInf) { continue; } //如果备货单状态为待处理更状态为待配货状态 if ($orderInf['status'] == 1) { $preObj->changeOrderStatus($id, 2, $_SESSION['userId']); } $tempAr = array('orderInf' => $orderInf); $deatil = $preObj->getSKUDetailByStatus($id); $skuArr = ''; foreach ($deatil as $k => $v) { $sku = $v['sku']; $skuArr .= "'" . $sku . "',"; } $skuArr = substr($skuArr, 0, strlen($skuArr) - 1); $paramArr['method'] = 'wh.OverSeaGetSkuStock'; //API名称 $paramArr['sku'] = $skuArr; $rtnInfo = UserCacheModel::callOpenSystem2($paramArr); $code = $rtnInfo['errCode']; $data = array(); $printArr = array(); $skuStock = array(); if ($code == 200) { $data = $rtnInfo['data']; foreach ($data as $m => $n) { $sku = $n['sku']; $qty = $n['qty']; //B仓库存 if ($qty > 0) { if (!in_array($sku, $printArr)) { $printArr[] = $sku; $skuStock[$sku] = $qty; } } } } $detail = array(); $num = 0; foreach ($deatil as $kk => $vv) { $sku = $vv['sku']; if (in_array($sku, $printArr)) { $detail[$num]['id'] = $vv['id']; $detail[$num]['sku'] = $vv['sku']; $detail[$num]['amount'] = $vv['amount']; $detail[$num]['qtyB'] = $skuStock[$sku]; $num++; } } $tempAr['skulist'] = $detail; $finalAr[] = $tempAr; } include WEB_PATH . 'html/template/v1/pregoodsprint.htm'; }
/** * CommonModel::updateOrderStatusFromWhAfterMQ() * 接收队列接收订单时,推送订单号到订单系统 * @author Gary * @param int $orderId * @return */ public static function updateOrderStatusFromWhAfterMQ($orderId) { $paramArr = array('method' => 'order.updateOrderStatusFromWhAfterMQ', 'omOrderIds' => $orderId); $res = UserCacheModel::callOpenSystem2($paramArr); unset($paramArr); return $res; }
public function outStock($sku, $num, $opuser, $orderid, &$isEnd, $waitScan, $orderSn) { $isLastOne = true; //是否为最后一个待配货sku $preGoods_Obj = new PreGoodsOrdderManageModel(); $allSkuInfo = $preGoods_Obj->getSKUDetail($orderid); //订单的全部sku列表 foreach ($allSkuInfo as $row) { //判断该料号配完以后是否可以终结该备货单 if ($row['amount'] != $row['scantnum'] && $row['sku'] != $sku) { $isLastOne = FALSE; } } if ($waitScan != $num) { $isLastOne = FALSE; } $isEnd = $isLastOne; //$this->logRequest(" sku==> $sku 数量==> $num"); //记录请求日志 $paramArr['method'] = 'ow_pregood_changestock'; //API名称 $paramArr['sku'] = $sku; $paramArr['num'] = $num; $paramArr['orderSn'] = $orderSn; $paramArr['operUser'] = getUserNameById($opuser); $messageInfo = UserCacheModel::callOpenSystem2($paramArr); //先到老系统扣库存 if (FALSE === $messageInfo) { //请求开发系统出错 self::$errmsg = '请求开放系统出错!'; return FALSE; } $code = isset($messageInfo['code']) ? trim($messageInfo['code']) : ''; if ($code !== 'success') { //扣库存失败 self::$errmsg = $messageInfo['msg']; return FALSE; } $sku = mysql_real_escape_string($sku); $this->dbConn->begin(); $rcordInfo = $this->getSkuInboxRecords($sku); if (FALSE === $rcordInfo) { //还没有封箱库存记录 则新增一条记录 $insertResult = $this->insertNewInboxRecords($sku, $num); if (FALSE === $insertResult) { //插入失败 回滚 $this->dbConn->rollback(); self::$errmsg = "新增封箱库存记录失败!"; return FALSE; } } else { //追加库存 $updateSql = "update wh_inboxStock set num=num+{$num} where sku='{$sku}'"; $updateQuery = $this->dbConn->query($updateSql); if (FALSE === $updateQuery) { //更新封箱库存失败 回滚 $this->dbConn->rollback(); self::$errmsg = "更新封箱库存失败!"; return FALSE; } } $time = time(); $updateOrder = "\n update wh_prepDetail set scantnum=scantnum+{$num}, scantime={$time}, scanuser='******' where \n sku='{$sku}' and orderid='{$orderid}'\n "; $upOrderQuery = $this->dbConn->query($updateOrder); //更新备货单的扫描数量 if (FALSE === $upOrderQuery) { $this->dbConn->rollback(); self::$errmsg = '更新备货单数据失败!'; return FALSE; } if (TRUE === $isLastOne) { //配货完成 修改备货单状态 $upStatusSql = "update wh_prepGoodsOrder set status=3 where id='{$orderid}'"; $upStatusQuery = $this->dbConn->query($upStatusSql); if (FALSE === $upStatusQuery) { $this->dbConn->rollback(); self::$errmsg = '更新备货单状态失败!'; return FALSE; } } $originNum = isset($rcordInfo['num']) ? $rcordInfo['num'] : 0; $logSql = "insert into wh_skuscanLog (orderId, sku, scanNum, originNum, opuser, scanTime) values\n ({$orderid}, '{$sku}', '{$num}', '{$originNum}', '{$opuser}', '{$time}')\n "; $logResult = $this->dbConn->query($logSql); //记录操作日志 if (FALSE === $logResult) { //写日志失败 回滚 $this->dbConn->rollback(); self::$errmsg = '写入操作日志失败!'; return FALSE; } $this->dbConn->commit(); return TRUE; }