| | |
| | | if (keyTimeout!=null && keyTimeout>24){ |
| | | Date estimatedDepartureTime = keyCollectionInfo.getEstimatedDepartureTime(); |
| | | String dateToStr = DateUtils.parseDateToStr(DateUtils.YYYY_MM_DD_HH_MM_SS, estimatedDepartureTime); |
| | | return AjaxResult.error("预计出发时间"+ dateToStr+",领取钥匙超时"+keyTimeout+"个小时"); |
| | | return AjaxResult.error("要求出发时间"+ dateToStr+",领取钥匙超时"+keyTimeout+"个小时"); |
| | | } |
| | | return AjaxResult.success("成功",2); |
| | | } |
| | |
| | | ord.CREATED_TIME as orderCreatedTime, |
| | | ts.CREATED_TIME as dispatchCreatedTime, |
| | | now() as keyCollectionTime, -- 放请求查询到的时间 |
| | | ord.ESTIMATED_DEPARTURE_TIME as estimatedDepartureTime, |
| | | ord.REQUIRED_DEPARTURE_TIME as estimatedDepartureTime, |
| | | ord.CONSIGNOR_ADDRESS_ADDR_INFO as consignorAddress, |
| | | ord.CONSIGNEE_ADDRESS_ADDR_INFO as consigneeAddress, |
| | | driver_m.`NAME` as mainDriver, |
| | |
| | | ts.DISPATCH_QUANTITY as dispatchQuantity, |
| | | ts.REMARK as remark, |
| | | TIMESTAMPDIFF(HOUR, ord.ORDER_TIME, ord.CREATED_TIME) as schedulingTimeout, |
| | | TIMESTAMPDIFF(HOUR, ord.ESTIMATED_DEPARTURE_TIME, NOW()) as keyTimeout |
| | | TIMESTAMPDIFF(HOUR, ord.REQUIRED_DEPARTURE_TIME, NOW()) as keyTimeout |
| | | |
| | | FROM |
| | | tms_shipment ts |