| | |
| | | |
| | | private String shelfCode; |
| | | |
| | | private String receiverAddress; |
| | | |
| | | private String shipperAddress; |
| | | |
| | | |
| | | // 0 = '行程中',1= '待甩挂' 2 = '待接挂',3 = '已甩挂',4 = '已接挂'5 = '完成行程' |
| | | private Integer tddStatus; |
| | | // 要求最晚发车时间 |
| | |
| | | </select> |
| | | <select id="selectAssignedItineraryDetail" resultType="com.ruoyi.tms.domain.vo.DriverDispatchVo"> |
| | | SELECT tdo.dispatch_no, tdo.customer_name, tdo.license_plate,tdo.transport_line,tdo.status,tdo.latest_departure, |
| | | tdd.status as tddStatus,tdd.driver_id,tdd.dispatch_id,tdo.ok_time,tdo.shelf_code |
| | | tdd.status as tddStatus,tdd.driver_id,tdd.dispatch_id,tdo.ok_time,tdo.shelf_code,tdo.shipper_address,tdo.receiver_address |
| | | FROM tms_dispatch_order AS tdo |
| | | LEFT JOIN tms_driver_dispatch AS tdd |
| | | ON tdo.id = tdd.dispatch_id |