| | |
| | | |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import com.ruoyi.system.domain.VehicleMileageStats; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import com.ruoyi.system.domain.VehicleMileageStats; |
| | | import com.ruoyi.system.domain.TaskTimeInterval; |
| | | |
| | | /** |
| | | * 车辆里程统计Mapper接口 |
| | | * |
| | | * @author ruoyi |
| | | * @date 2025-01-15 |
| | | */ |
| | | public interface VehicleMileageStatsMapper |
| | | { |
| | | public interface VehicleMileageStatsMapper { |
| | | |
| | | /** |
| | | * 查询车辆里程统计 |
| | | * |
| | | * @param statsId 车辆里程统计主键 |
| | | * @param statsId 统计ID |
| | | * @return 车辆里程统计 |
| | | */ |
| | | public VehicleMileageStats selectVehicleMileageStatsByStatsId(Long statsId); |
| | | public VehicleMileageStats selectVehicleMileageStatsById(Long statsId); |
| | | |
| | | /** |
| | | * 查询车辆里程统计列表 |
| | |
| | | /** |
| | | * 删除车辆里程统计 |
| | | * |
| | | * @param statsId 车辆里程统计主键 |
| | | * @param statsId 统计ID |
| | | * @return 结果 |
| | | */ |
| | | public int deleteVehicleMileageStatsByStatsId(Long statsId); |
| | | public int deleteVehicleMileageStatsById(Long statsId); |
| | | |
| | | /** |
| | | * 批量删除车辆里程统计 |
| | | * |
| | | * @param statsIds 需要删除的数据主键集合 |
| | | * @param statsIds 需要删除的数据ID |
| | | * @return 结果 |
| | | */ |
| | | public int deleteVehicleMileageStatsByStatsIds(Long[] statsIds); |
| | | public int deleteVehicleMileageStatsByIds(Long[] statsIds); |
| | | |
| | | /** |
| | | * 查询指定车辆和日期的统计记录 |
| | | * 查询车辆在指定日期的统计记录 |
| | | * |
| | | * @param vehicleId 车辆ID |
| | | * @param statsDate 统计日期 |
| | | * @param statDate 统计日期 |
| | | * @return 统计记录 |
| | | */ |
| | | public VehicleMileageStats selectByVehicleIdAndDate(@Param("vehicleId") Long vehicleId, @Param("statsDate") Date statsDate); |
| | | public VehicleMileageStats selectByVehicleIdAndDate(@Param("vehicleId") Long vehicleId, |
| | | @Param("statDate") Date statDate); |
| | | |
| | | /** |
| | | * 查询车辆在指定时间范围内的任务时间区间 |
| | | * |
| | | * @param vehicleId 车辆ID |
| | | * @param startTime 开始时间 |
| | | * @param endTime 结束时间 |
| | | * @return 任务时间区间列表 |
| | | */ |
| | | public List<TaskTimeInterval> selectTaskTimeIntervals(@Param("vehicleId") Long vehicleId, |
| | | @Param("startTime") Date startTime, |
| | | @Param("endTime") Date endTime); |
| | | } |