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 | 26 +++++++++++++++++++++-----
1 files changed, 21 insertions(+), 5 deletions(-)
diff --git a/src/main/java/com/yssh/mapper/QxshMapper.java b/src/main/java/com/yssh/mapper/QxshMapper.java
index 18e8cb4..75e7140 100644
--- a/src/main/java/com/yssh/mapper/QxshMapper.java
+++ b/src/main/java/com/yssh/mapper/QxshMapper.java
@@ -1,22 +1,24 @@
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> 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);
@@ -30,6 +32,10 @@
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);
@@ -37,4 +43,14 @@
public List<Qxsh> selectForReport(@Param("start") Integer start, @Param("end") Integer end);
public Double selectLastYearVal(@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