2017-09-11 10:20:00,289 [pool-12-thread-496] [com.datang.flow.service.ss.recharge.TxRechargeServer] [ERROR] [com.datang.flow.service.ss.common.log.LogManager.errorLog(LogManager.java:154)] - 原订单:[ DT170911065811TM012011119734 ],根据mobile:13581728983,productID:10211,operatorID:1,createTime:2017-09-11 06:58:11 查询到[ 0 ]条记录,请人工处理!!!




2017-09-11 14:20:00,294 [pool-12-thread-499] [com.datang.flow.service.ss.recharge.TxRechargeServer] [ERROR] [com.datang.flow.service.ss.common.log.LogManager.errorLog(LogManager.java:154)] - 原订单:[ DT170911093441TM012011122688 ],根据mobile:15711369029,productID:10211,operatorID:1,createTime:2017-09-11 09:34:41 查询到[ 0 ]条记录,请人工处理!!!





    /*int addVirtualOrderItem(@Param("mobile") String mobile, @Param("operatorID") Integer operatorID, @Param("provinceID") Integer provinceID,
                            @Param("packageSize") String packageSize, @Param("orderStatusCode") Integer orderStatusCode, @Param("useRange") Integer useRange,
                            @Param("describe") String describe);*/



SELECT * FROM orders_201709 t 
WHERE t.`merchantID` = 'TM01' 
AND t.`orderStatusCode` = 1
AND t.scan !=2
AND t.`createTime` >= '2017-09-13 00:00:000'



			    // 根据运营商、产品查找productID
                String product = this.selectProductID();



http://apir.digitaltechmf.com:8092/QMacro/craw/importVirtualOrder?filePath=/data/test.xls

http://apir.digitaltechmf.com:8092/QMacro/craw/receiveVirtualOrder?id=5&mobile=13514018088&packageSize=1G

http://apir.digitaltechmf.com:8092/QMacro/craw/getVirtualOrders?operatorID=-1&provinceID=-1&count=20




##### 导入订单
http://apir.digitaltechmf.com:8092/QMacro/craw/importVirtualOrder?filePath=/data/天猫9.13日10-10点半.xls


http://apir.digitaltechmf.com:8092/QMacro/craw/importVirtualOrder?filePath=/data/天猫9.13日10-10点半-bak.xls