From 2f55cebbad3dea187a5f91d16ec80a9677dab699 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 13 十一月 2024 11:16:53 +0800
Subject: [PATCH] 1
---
src/main/java/com/yssh/mapper/QxshMapper.java | 45 +++++++++++++++++++++++++++++++++++++--------
1 files changed, 37 insertions(+), 8 deletions(-)
diff --git a/src/main/java/com/yssh/mapper/QxshMapper.java b/src/main/java/com/yssh/mapper/QxshMapper.java
index d13bffa..75e7140 100644
--- a/src/main/java/com/yssh/mapper/QxshMapper.java
+++ b/src/main/java/com/yssh/mapper/QxshMapper.java
@@ -1,27 +1,56 @@
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;
import java.util.List;
+import java.util.Map;
-/**
- * @author WWW
- * @date 2023-05-18
- * QxshMapper
- */
@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> select3Hours(@Param("times") List<String> times);
+ public List<Qxsh> selectWeekTop10(@Param("start") Integer start, @Param("end") Integer end);
- public List<Qxsh> selectByBeginAndEnd(@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 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);
+
+ public List<Qxsh> selectForReport(@Param("start") Integer start, @Param("end") Integer end);
public Double selectLastYearVal(@Param("time") Integer time, @Param("name") String name);
- public Qxsh selectByTimeAndName(@Param("time") Integer time, @Param("name") String name);
+ public Integer countGcsjByTime(@Param("start") Integer start, @Param("end") Integer end);
+
+ public Integer countQxshByTime(@Param("start") Integer start, @Param("end") Integer end);
+
+ public Integer countSuYuan46ByTime(@Param("start") String start, @Param("end") String end);
+
+ public Integer countSuYuan70ByTime(@Param("start") String start, @Param("end") String end);
+
+ public Integer countSuYuanFastByTime(@Param("start") String start, @Param("end") String end);
}
--
Gitblit v1.9.3