package com.stylefeng.guns.modular.system.dao;
|
|
import com.baomidou.mybatisplus.mapper.BaseMapper;
|
import com.stylefeng.guns.modular.system.model.DriverOnline;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.util.Date;
|
import java.util.List;
|
|
public interface DriverOnlineMapper extends BaseMapper<DriverOnline> {
|
|
|
/**
|
* 获取当前在线记录
|
* @param driverId
|
* @return
|
*/
|
DriverOnline query(@Param("driverId") Integer driverId, @Param("day") String day, @Param("type") Integer type, @Param("assessment") Integer assessment);
|
|
|
/**
|
* 获取给定日期范围的在线时长
|
* @param driverId
|
* @param assessment
|
* @param start
|
* @param end
|
* @return
|
*/
|
Integer querySumTime(@Param("driverId") Integer driverId, @Param("assessment") Integer assessment,
|
@Param("start") Date start, @Param("end") Date end);
|
|
|
|
List<DriverOnline> queryList(@Param("day") String day, @Param("type") Integer type, @Param("duration") Long duration);
|
}
|
