package com.zbkj.service.dao;

import cn.hutool.core.date.DateTime;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zbkj.common.model.vehicle.EbVehicleInfo;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface EbVehicleInfoDao extends BaseMapper<EbVehicleInfo> {
//    @Select("SELECT MAX(queue_number) FROM eb_vehicle_info")
//    String selectMaxQueueNumber();

    @Select("SELECT MAX(queue_number) FROM eb_vehicle_info WHERE register_time >= #{startDateTime} AND register_time <= #{endDateTime}")
    String selectMaxQueueNumber(@Param(value = "startDateTime") String startDateTime, @Param(value = "endDateTime") String endDateTime);

    @Select("SELECT MAX(sort) FROM eb_vehicle_info WHERE register_time >= #{startDateTime} AND register_time <= #{endDateTime}")
    String selectMaxSort(@Param(value = "startDateTime") String startDateTime, @Param(value = "endDateTime") String endDateTime);
}