package com.yssh.mapper;
|
|
import com.yssh.entity.Qxsh;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* @author WWW
|
* @date 2023-05-18
|
* QxshMapper
|
*/
|
@Mapper
|
public interface QxshMapper {
|
public List<Qxsh> selectByTime(String time);
|
|
public List<Qxsh> selectMonthTop10(String time);
|
|
public List<Qxsh> selectWeekTop10(@Param("start") Integer start, @Param("end") Integer end);
|
|
public List<Qxsh> selectDayTop10(String time);
|
|
public List<Qxsh> selectWarnByBeginAndEnd(@Param("start") Integer start, @Param("end") Integer end);
|
|
public List<Qxsh> selectAlarmByBeginAndEnd(@Param("start") Integer start, @Param("end") Integer end);
|
|
public Integer countMonthForWarn(@Param("start") Integer start, @Param("end") Integer end);
|
|
public Integer countMonthForAlarm(@Param("start") Integer start, @Param("end") Integer end);
|
|
public List<Map<String, Object>> count7DayForWarn(@Param("start") Integer start, @Param("end") Integer end);
|
|
public List<Map<String, Object>> count7DayForAlarm(@Param("start") Integer start, @Param("end") Integer end);
|
|
public Integer hasSuYuan(@Param("suYuanId") String suYuanId, @Param("createTime") String createTime);
|
|
public List<Qxsh> select3Hours(@Param("start") Integer start, @Param("end") Integer end);
|
|
public Qxsh selectByTimeAndName(@Param("time") Integer time, @Param("name") String name);
|
|
public List<Qxsh> selectForReport(@Param("start") Integer start, @Param("end") Integer end);
|
|
public Double selectLastYearVal(@Param("time") Integer time, @Param("name") String name);
|
}
|