| | |
| | | package com.ruoyi.system.mapper; |
| | | |
| | | import com.ruoyi.common.annotation.DataSource; |
| | | import com.ruoyi.common.enums.DataSourceType; |
| | | import com.ruoyi.system.domain.DictionaryCondition; |
| | | import com.ruoyi.system.domain.DispatchOrd; |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import java.util.List; |
| | | |
| | |
| | | * |
| | | * @author ruoyi |
| | | */ |
| | | @DataSource(DataSourceType.SQLSERVER) |
| | | public interface DispatchOrdMapper { |
| | | /** |
| | | * 根据服务订单ID查询调度订单 |
| | |
| | | * @return 司机手机号 |
| | | */ |
| | | public String selectDriverMobileByName(String driverName); |
| | | |
| | | /** |
| | | * 根据派工单号查询图片URL列表 |
| | | * |
| | | * @param dOrdIDDt 派工单号 |
| | | * @return 图片URL列表 |
| | | */ |
| | | public List<String> selectImageUrlsByDOrdIDDt(String dOrdIDDt); |
| | | |
| | | /** |
| | | * 根据调度单ID查询调度单状态 |
| | | * |
| | | * @param dispatchOrdID 调度单ID |
| | | * @return 调度单状态码 |
| | | */ |
| | | public Integer selectDispatchOrdStateByID(Long dispatchOrdID); |
| | | |
| | | /** |
| | | * 批量查询调度单状态 |
| | | * |
| | | * @param dispatchOrdIDs 调度单ID列表 |
| | | * @return 调度单ID和状态的映射集合 |
| | | */ |
| | | public List<DispatchOrd> selectDispatchOrdStatesByIDs(List<Long> dispatchOrdIDs); |
| | | |
| | | /** |
| | | * 更新调度单状态 |
| | | * |
| | | * @param dispatchOrdID 调度单ID |
| | | * @param dispatchOrdState 状态码 |
| | | * @return 影响行数 |
| | | */ |
| | | public int updateDispatchOrdState(@Param("dispatchOrdID") Long dispatchOrdID, @Param("dispatchOrdState") Integer dispatchOrdState); |
| | | |
| | | /** |
| | | * 更新调度单取消原因 |
| | | * |
| | | * @param dispatchOrdID 调度单ID |
| | | * @param cancelReasonId 取消原因ID |
| | | * @param cancelReasonText 取消原因文本 |
| | | * @return 影响行数 |
| | | */ |
| | | public int updateDispatchOrdCancelReason(@Param("dispatchOrdID") Long dispatchOrdID, |
| | | @Param("cancelReasonId") Integer cancelReasonId, |
| | | @Param("cancelReasonText") String cancelReasonText); |
| | | |
| | | /** |
| | | * 更新调度单实际开始时间 |
| | | * |
| | | * @param dispatchOrdID 调度单ID |
| | | * @param actualDate 实际开始时间 |
| | | * @return 影响行数 |
| | | */ |
| | | public int updateDispatchOrdActualDate(@Param("dispatchOrdID") Long dispatchOrdID, |
| | | @Param("actualDate") java.util.Date actualDate); |
| | | } |