From 49aaecfb0617b0e6043147c86f3d303e9f24867e Mon Sep 17 00:00:00 2001
From: liulin <lin.liu@88.com>
Date: 星期三, 09 七月 2025 20:27:56 +0800
Subject: [PATCH] 修改yml配置
---
src/main/java/com/fengdu/gas/repository/mapper/FacilityAlarmRecordMapper.java | 11 ++++++++++-
1 files changed, 10 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 a03181b..87e9f54 100644
--- a/src/main/java/com/fengdu/gas/repository/mapper/FacilityAlarmRecordMapper.java
+++ b/src/main/java/com/fengdu/gas/repository/mapper/FacilityAlarmRecordMapper.java
@@ -1,10 +1,19 @@
package com.fengdu.gas.repository.mapper;
-import com.fengdu.gas.repository.BasicMapper;import com.fengdu.gas.repository.po.FacilityAlarmRecordPO;
+import com.fengdu.gas.entity.response.alarm.FacilityAlarm;
+import com.fengdu.gas.repository.BasicMapper;
+import com.fengdu.gas.repository.po.FacilityAlarmRecordPO;
+import org.apache.ibatis.annotations.Select;
+
+import java.util.List;
/**
* 设备报警记录 mapper
* @author zr
*/
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" +
+ "GROUP BY description\n")
+ List<FacilityAlarm> getByDateType(String beginTime, String endTime);
}
--
Gitblit v1.9.3