public function index() { vendor("GuoYaoService", LIB_PATH . "\\Service"); define('DEBUG', true); $model = new OrderModel(); //$sql = "UPDATE web_order SET orderNo='G01131009029',billDate='2013-10-09 10:29:05',userId='000032',userName='******',departure='',client='国药控股广州有限公司',clientName='(国药集团)高唐库',clientPhone='',clientMobile='',clientAddress='广东省-广州市-天河区-高唐工业园高普路91号',destination='',consignee='佛山市顺德区北滘医院',consigneeName='',consigneePhone='',consigneeMobile='',consigneeAddress='广东省-佛山市-顺德区-(北滘医院)(西)顺德区北滘镇林上路东城区一南路1号北滘医院西药库',goods='药品',qty=195,weight=0,cubage=0,package='纸箱',payType='月结',declareValue=0,insuranceValue=0,getMoney=0,transtype='汽运',deliverType='零担',signBackType='',receipt=0,receiptPhone=null,receiptAddress=null,receiptTime=null,requirementDate='2014-05-27 15:00:00',requirementTime='2014-05-27 15:00:00',addition=0,notice='0.0',sendFax=0,company='000032',sysdno=null,synupcount=0,synupsign=0,synupsigncount=0 WHERE id='88819'"; $sql = "UPDATE web_order SET orderNo='G01131009029',billDate='2013-10-09 10:29:05',userId='000032',userName='******',departure='',client='',clientName='',clientPhone='',clientMobile='',clientAddress='',destination='',consignee='北滘医院',consigneeName='',consigneePhone='',consigneeMobile='',consigneeAddress='',goods='药品',qty=195,weight=0,cubage=0,package='纸箱',payType='月结',declareValue=0,insuranceValue=0,getMoney=0,transtype='汽运',deliverType='零担',signBackType='',receipt=0,receiptPhone=null,receiptAddress=null,receiptTime=null,requirementDate='2014-05-27 15:00:00',requirementTime='2014-05-27 15:00:00',addition=0,notice='0.0',sendFax=0,company='000032',sysdno=null,synupcount=0,synupsign=0,synupsigncount=0 WHERE id='88819'"; $result = $model->execute($sql); //$service = new GuoYaoService(); //echo "kenlong"; //$service->readFromSPL(); //$service->synup(); //$service->updateFlag(); /* $headmodel = new OrderModel(); $find = $headmodel->where("orderNo = 'G01140307156'")->find(); unset($find['dno']); unset($find['synup']); unset($find['billNo']); unset($find['OrderInfoId']); unset($find['status']); print_r($find); */ }
/** * 保存订单 * */ private function saveOrder($data) { try { $headmodel = new OrderModel(); //作废标记处理 if ($data['FILEFUNCTION'] === 'CANCEL') { $sql = "update web_order set status = -1 where orderNo = '" . $data['ECNO'] . "';"; $headmodel->execute($sql); $headmodel->commit(); return true; } //查找已经存在的记录 $find = $headmodel->where("orderNo = '" . $data['ECNO'] . "'")->find(); if ($find['id']) { unset($find['dno']); unset($find['synup']); unset($find['billNo']); unset($find['OrderInfoId']); unset($find['status']); $head = $find; } //订单头文件 $head["departure"] = ''; $head["destination"] = ''; $head["orderNo"] = $data['ECNO']; $head["client"] = '国药控股广州有限公司'; $head["clientName"] = $data['CONSIGNOR'] != 'null' ? $data['CONSIGNOR'] : ''; $head["clientPhone"] = $data['CONPHONE'] != 'null' ? $data['CONPHONE'] : ''; $head["clientAddress"] = $data['CONADDRESS'] != 'null' ? $data['CONADDRESS'] : ''; $head["consignee"] = $data['CUSTOMERNNAME'] != 'null' ? $data['CUSTOMERNNAME'] : ''; $head["consigneeName"] = $data['CUSCONTACT'] != 'null' ? $data['CUSCONTACT'] : ''; $head["consigneePhone"] = $data['CUSNPHONENO'] != 'null' ? $data['CUSNPHONENO'] : ''; $head["consigneeAddress"] = $data['CUSTADDRESS'] != 'null' ? $data['CUSTADDRESS'] : ''; $head["deliverType"] = $data['TMSLOADINGMETHOD'] != 'null' ? $data['TMSLOADINGMETHOD'] : ''; $head["goods"] = '药品'; //$data['GOODSTYPE']!='null'?$data['GOODSTYPE']:''; $head["package"] = ''; $head["qty"] = intval($data['TOTALQUANTITY']); $head["weight"] = 0; $head["addition"] = intval($data['INVOICENUMBER']); $head["notice"] = $data['REQUIREMENT'] != 'null' ? $data['REQUIREMENT'] : ''; $head["transtype"] = $this->authname == 'NGWL01' ? '空运' : '汽运'; //$orderhead->Transporttype; $head["declareValue"] = 0; $head["sendFax"] = 0; $head["requirementDate"] = $data['DELIVETIME']; $head["requirementTime"] = $data['DELIVETIME']; $head["userName"] = $data['CREATER'] != 'null' ? $data['CREATER'] : ''; $head["userId"] = '000032'; $head["company"] = '000032'; $head["billDate"] = $data['CREATETIME']; date_default_timezone_set("Asia/Shanghai"); //额外信息 $head["clientMobile"] = ''; $head["consigneeMobile"] = ''; $head["getMoney"] = 0; $head["cubage"] = 0; $head["package"] = '纸箱'; $head["payType"] = "月结"; $head["insuranceValue"] = 0; $head["signBackType"] = ''; //save head if ($head['id']) { $rs = $headmodel->save($head); } else { $rs = $headmodel->where("not exist")->add($head); } if ($rs === false) { $this->addLog("save head error"); return false; } //save detail $detail['orderNo'] = $data["ECNO"]; $detail['businessNo'] = $data["LEGNO"]; $detail['OUTORDERID'] = $data["OUTORDERID"]; $detail['LOTNO'] = $data["LOTNO"]; $detail['GOODSTYPE'] = $data["GOODSTYPE"]; $detail['TRASNCONDITION'] = $data['TRASNCONDITION']; $detail['PRODUCTTYPE'] = $data["PRODUCTTYPE"]; $detail['QUANTITY'] = intval($data["QUANTITY"]); $detail['QUANTITYUNIT'] = intval($data["QUANTITYUNIT"]); $detail['QUNITNAME'] = $data["QUNITNAME"]; $detail['PACKWEIGHT'] = intval($data["PACKWEIGHT"]); $detail['CARTONQUANITTY'] = intval($data["CARTONQUANITTY"]); $detail['PLACESUPPLYDTLID'] = $data["PLACESUPPLYDTLID"]; $detail['OWNERGOODSID'] = $data["OWNERGOODSID"]; $detailmodel = new OrderdetailModel(); $find = $detailmodel->where("orderNo = '" . $data['ECNO'] . "' and businessNo='" . $data['LEGNO'] . "'")->find(); if (!$find) { $detailmodel->add($detail); } else { if (DEBUG) { $this->debug('duplicate', "found detail" . $detail['orderNo'] . " " . $data['LEGNO']); } } } catch (Exception $e) { $this->addLog("save order Exception error" . $e->getMessage()); return false; } $this->orderno = $data['ECNO']; return true; }