public function act_handelSubmit() { $expressdata = null; if ($_SERVER['REQUEST_METHOD'] == "POST") { // 以post方式提交的数据为 一个订单有多个跟踪号的情况 $orderid = trim($_POST['orderid']); $expressid = trim($_POST['expressid']); $expressid = trim($_POST['expressid'], "\n"); $exidar = explode("\n", $expressid); $len = count($exidar); for ($i = 0; $i < $len; $i++) { // 去除中间的空白 $temp = trim($exidar[$i]); if (empty($temp)) { unset($exidar[$i]); } } if (empty($exidar)) { // 提交的是空白 self::$errCode = 0; self::$errMsg = '快递号为空!'; return; } $expressdata = $exidar; // $expressid = implode('和', $exidar); } else { $orderid = trim($_GET['orderid']); $expressid = trim($_GET['expressid']); $expressdata = $expressid; } if ($orderid < 1 || empty($orderid)) { // 不合法的id self::$errCode = 0; self::$errMsg = '单号不合法!'; return; } if (empty($expressdata)) { self::$errCode = 0; self::$errMsg = '追踪号码不能为空!'; return; } $po_obj = new PackingOrderModel(); $orderinfo = $po_obj->getOrderInfoById($orderid); if (empty($orderinfo)) { self::$errCode = 0; self::$errMsg = '单号不正确'; return; } if ($orderinfo['orderStatus'] != PKS_EX_TNRCK) { //该订单不在快递待复核状态 self::$errCode = 0; self::$errMsg = '该发货单不在快递待复核组!'; return; } $tir_obj = new TrackInfoRecordModel(); $result = $tir_obj->validataTracnumber($orderid, $expressdata, 1); self::$errCode = TrackInfoRecordModel::$errCode; self::$errMsg = TrackInfoRecordModel::$errMsg; return; }
public function view_fileDataImport() { // var_dump($_FILES);exit; // 处理联邦快递数据导入 $_FILES['excelsheet']; if ($_FILES['excelsheet']['error'] != 0) { // 文件没有上传成功 $data = array("data" => array('文件上传失败!'), 'link' => 'index.php?mod=expressRecheck&act=trackNumberInput'); goErrMsgPage($data); exit; } else { $tir_obj = new TrackInfoRecordModel(); $result = $tir_obj->recordDataFromExecl_all(); // var_dump($result);exit(); if (empty($result)) { // 么有成功 $data = array("data" => array('操作失败!'), 'link' => 'index.php?mod=expressRecheck&act=trackNumberInput'); goErrMsgPage($data); exit; } } $navlist = array(array('url' => '', 'title' => '出库'), array('url' => '', 'title' => '快递待复核数据导入')); $this->smarty->assign('navlist', $navlist); $toptitle = '复核数据导入'; // 顶部链接 $this->smarty->assign('toptitle', $toptitle); $toplevel = 2; // 顶层菜单 $this->smarty->assign('toplevel', $toplevel); $secondlevel = '28'; // 当前的二级菜单 $this->smarty->assign('secondlevel', $secondlevel); $this->smarty->assign('list', TrackInfoRecordModel::$data); $this->smarty->display('tracknumimport.htm'); }
public function validataTracnumber($orderid, $expressid) { $sqlstr = 'select expressid from wh_orderid_expressid_map where orderid=' . "'{$orderid}'"; $result = $this->dbconn->query($sqlstr); $checkresult = 0; $haveone = FALSE; if ($_SERVER['REQUEST_METHOD'] == 'POST') { // 处理一个订单多个跟踪号的情况 while ($row = mysql_fetch_assoc($result)) { $haveone = TRUE; $tempar = explode('和', $row['expressid']); //var_dump($tempar);exit; //print_r($expressid);exit; $checkresult = 1; foreach ($tempar as $exval) { if (!in_array($exval, $expressid)) { $checkresult = 0; break; } } if ($checkresult == 0) { continue; } else { break; } } } else { while ($row = mysql_fetch_assoc($result)) { $haveone = TRUE; // if( $row['expressid'] == $expressid ){ if (strpos($expressid, sprintf('%s', $row['expressid'])) !== false) { if (strlen($expressid) != $row['expressid']) { // 判断为联邦快递 $offset = strpos($expressid, sprintf('%s', $row['expressid'])); // 偏移量 $cutlen = strlen($expressid) - strlen($row['expressid']); // 前后缀长之和 $formatedtrid = substr($expressid, $offset, strlen($expressid) - $cutlen); $expressid = $formatedtrid; $expressid = $row['expressid']; // 2013/7/10 修改 涂兴隆 } // 验证成功 $sql_updata = 'update wh_orderid_expressid_map set checked =1 where orderid=' . "'{$orderid}'"; // echo $sql_updata;exit; $this->dbconn->query($sql_updata); $checkresult = 1; break; } } } if (!$haveone) { self::$errCode = 0; self::$errMsg = '跟踪号未录入!'; return FALSE; } //echo $checkresult;exit; if ($checkresult == 1) { //验证成功 $upres = $this->updataExpressId($expressid, $orderid, 1); if (!$upres) { self::$errCode = 0; self::$errMsg = '验证失败'; return FALSE; } else { self::$errCode = 1; self::$errMsg = '成功'; return TRUE; } } else { self::$errCode = 0; self::$errMsg = '复核失败,请检查包裹!'; return FALSE; } }