/** * 单据查询 01 * * @param string $request */ private function billsQuery($request) { try { $dno = $request["body"]["no"]; $dno = ereg_replace("[^a-zA-Z0-9,-]", '', $dno); $dno = str_replace(',', "','", $dno); $dno = "'" . $dno . "'"; $condition = "dno in (" . $dno . ") or adno in (" . $dno . ")"; $model = new AirwaybillModel(); $result = $model->where($condition)->select(); if ($result) { for ($i = 0; $i < count($result); $i++) { $item .= "<item>"; $item .= "<ID>" . $result[$i]["ID"] . "</ID>"; $item .= "<DNO>" . $result[$i]["ADNO"] . "</DNO>"; $item .= "<DBilldate>" . $result[$i]["DBilldate"] . "</DBilldate>"; $item .= "<Departure>" . $result[$i]["Departure"] . "</Departure>"; $item .= "<Destination>" . $result[$i]["Destination"] . "</Destination>"; $item .= "<Qty>" . $result[$i]["Qty"] . "</Qty>"; $item .= "<Weight>" . $result[$i]["Weight"] . "</Weight>"; $item .= "<SignIn>" . $result[$i]["SignIn"] . "</SignIn>"; $item .= "<SignDate>" . $result[$i]["SignDate"] . "</SignDate>"; $item .= "<Memo>" . $result[$i]["Memo"] . "</Memo>"; $item .= "</item>"; } return $this->createResult($request["head"]["type"], 1, '', count($result), $item); } else { return $this->createResult($request["head"]["type"], 1, '', 0); } } catch (Exception $e) { return $this->createResult($request["head"]["type"], -1, "error in bills query"); } }
/** * 上传签收图片 * */ private function uploadImg() { $this->create(); //上传签收信息 convert(money,a.cubage) $model = new AirwaybillModel(); $sql = "SELECT top 100 d.id, w.orderno, w.company, a.dno, d.businessNo\n\t\t FROM airwaybill a INNER JOIN web_order w ON a.weborder = w.id INNER JOIN web_orderdetail d ON w.orderno = d.orderno\n\t\t WHERE d.synupsign = 0 and d.synupsigncount < 3"; $rs = $model->query($sql); if ($rs) { for ($i = 0; $i < count($rs); $i++) { $data['orderno'] = $rs[$i]['orderno']; $data['dno'] = $rs[$i]['dno']; $data['businessNo'] = $rs[$i]['businessNo']; $data['company'] = $rs[$i]['company']; //太经常访问,国药服务器会崩溃的,休息下再说 $this->sleep4awhile(); //upload 签收 $result = $this->sendToSPLImage($data); if ($result === 404) { return; } else { if ($result === -100) { $this->addLog("the img file was not existed!"); continue; } else { if ($result) { $model->execute("update web_orderdetail set synupsign = 1 where id =" . $rs[$i]["id"]); } } } //上传次数 $model->execute("update web_orderdetail set synupsigncount = synupsigncount +1 where id =" . $rs[$i]["id"]); } } }