From 2b5c36b4830adf4227f248d4e10bdb90b1e5f3d8 Mon Sep 17 00:00:00 2001
From: liulin <lin.liu@88.com>
Date: 星期四, 17 七月 2025 08:42:39 +0800
Subject: [PATCH] 添加首页大屏数据统计
---
src/main/java/com/fengdu/gas/repository/mapper/FacilityAlarmRecordMapper.java | 10 +++++++++-
1 files changed, 9 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/fengdu/gas/repository/mapper/FacilityAlarmRecordMapper.java b/src/main/java/com/fengdu/gas/repository/mapper/FacilityAlarmRecordMapper.java
index 87e9f54..041eb0f 100644
--- a/src/main/java/com/fengdu/gas/repository/mapper/FacilityAlarmRecordMapper.java
+++ b/src/main/java/com/fengdu/gas/repository/mapper/FacilityAlarmRecordMapper.java
@@ -3,9 +3,11 @@
import com.fengdu.gas.entity.response.alarm.FacilityAlarm;
import com.fengdu.gas.repository.BasicMapper;
import com.fengdu.gas.repository.po.FacilityAlarmRecordPO;
+import com.fengdu.gas.repository.vo.FacilityAlarmRecordCount;
import org.apache.ibatis.annotations.Select;
import java.util.List;
+import java.util.Map;
/**
* 设备报警记录 mapper
@@ -13,7 +15,13 @@
*/
public interface FacilityAlarmRecordMapper extends BasicMapper<FacilityAlarmRecordPO> {
@Select("SELECT description AS NAME ,MIN(min_value) AS minValue ,MAX(max_value) AS maxValue,COUNT(id) AS count FROM facility_alarm_record \n" +
- "WHERE is_delete=0 AND latest_alarm_time BETWEEN #{beginTime} AND #{endTime} '\n" +
+ "WHERE is_delete=0 and columns_code is Not NULL AND columns_code<>'' AND latest_alarm_time BETWEEN #{beginTime} AND #{endTime} '\n" +
"GROUP BY description\n")
List<FacilityAlarm> getByDateType(String beginTime, String endTime);
+
+ @Select("SELECT point_name, COUNT(*) as count FROM facility_alarm_record WHERE is_delete=0 AND latest_alarm_time IS NOT NULL AND latest_alarm_time<>'' and columns_code is Not NULL AND columns_code<>'' GROUP BY point_name ;")
+ List<FacilityAlarmRecordCount> getAlarmListByPoint();
+
+ @Select("SELECT facility_id,columns_code,alarm_type,COUNT(*) AS alarm_count FROM facility_alarm_record WHERE is_delete=0 and columns_code is Not NULL AND columns_code<>'' GROUP BY facility_id,columns_code,alarm_type;")
+ List<FacilityAlarmRecordPO> getGroupList();
}
--
Gitblit v1.9.3