package com.ruoyi.system.mapper;

import java.math.BigDecimal;
import java.util.Date;
import java.util.List;
import org.apache.ibatis.annotations.Param;
import com.ruoyi.system.domain.VehicleGpsSegmentMileage;

/**
 * 车辆GPS分段里程Mapper接口
 */
public interface VehicleGpsSegmentMileageMapper {
    
    /**
     * 查询车辆GPS分段里程
     */
    public VehicleGpsSegmentMileage selectVehicleGpsSegmentMileageById(Long segmentId);

    /**
     * 查询车辆GPS分段里程列表
     */
    public List<VehicleGpsSegmentMileage> selectVehicleGpsSegmentMileageList(VehicleGpsSegmentMileage vehicleGpsSegmentMileage);

    /**
     * 新增车辆GPS分段里程
     */
    public int insertVehicleGpsSegmentMileage(VehicleGpsSegmentMileage vehicleGpsSegmentMileage);

    /**
     * 修改车辆GPS分段里程
     */
    public int updateVehicleGpsSegmentMileage(VehicleGpsSegmentMileage vehicleGpsSegmentMileage);

    /**
     * 删除车辆GPS分段里程
     */
    public int deleteVehicleGpsSegmentMileageById(Long segmentId);

    /**
     * 批量删除车辆GPS分段里程
     */
    public int deleteVehicleGpsSegmentMileageByIds(Long[] segmentIds);

    /**
     * 查询车辆在指定时间段是否已存在分段里程记录
     */
    public VehicleGpsSegmentMileage selectByVehicleIdAndTime(@Param("vehicleId") Long vehicleId, 
                                                              @Param("segmentStartTime") Date segmentStartTime);

    /**
     * 查询车辆在指定日期范围内的分段里程统计
     */
    public List<VehicleGpsSegmentMileage> selectSegmentsByDateRange(@Param("vehicleId") Long vehicleId,
                                                                     @Param("startDate") Date startDate,
                                                                     @Param("endDate") Date endDate);
    
    /**
     * 按任务ID查询分段里程列表
     */
    public List<VehicleGpsSegmentMileage> selectSegmentsByTaskId(@Param("taskId") Long taskId);
    
    /**
     * 查询任务的总里程（直接求和）
     */
    public BigDecimal selectTotalMileageByTaskId(@Param("taskId") Long taskId);
    
    /**
     * 记录GPS点已被计算（插入到tb_vehicle_gps_calculated表）
     */
    public int insertGpsCalculated(@Param("gpsId") Long gpsId, 
                                    @Param("segmentId") Long segmentId,
                                    @Param("vehicleId") Long vehicleId);
    
    /**
     * 检查GPS点是否已被计算
     */
    public Long selectGpsCalculatedSegmentId(@Param("gpsId") Long gpsId);
    
    /**
     * 查询车辆在指定时间之前最后一个已处理的GPS坐标ID
     * @param vehicleId 车辆ID
     * @param beforeTime 截止时间（查询此时间之前的最后一个已处理GPS点）
     * @return GPS坐标ID，如果没有则返回null
     */
    public Long selectLastCalculatedGpsId(@Param("vehicleId") Long vehicleId,
                                           @Param("beforeTime") Date beforeTime);
}