Initial commit

liding

3 天以前 7f9e375391e30fd3c367cb5a080a609a6e25e524

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
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);
}