| | |
| | | package com.yssh.mapper; |
| | | |
| | | import com.yssh.entity.Qxsh; |
| | | import com.yssh.entity.SuYuanMonitorData; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | |
| | | */ |
| | | @Mapper |
| | | public interface QxshMapper { |
| | | List<SuYuanMonitorData> getNewMonitorData(String name, String start, String end); |
| | | |
| | | 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 List<Map<String, Object>> count7DayForAlarm(@Param("start") Integer start, @Param("end") Integer end); |
| | | |
| | | public List<Qxsh> selectByBeginAndEnd(@Param("start") Integer start, @Param("end") Integer end); |
| | | public Integer countFastSuYuan(@Param("id") String id, @Param("time") String time); |
| | | |
| | | 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); |
| | | |