From 60041d6ee9bd2fcd8b6bcb827bf46e0727941665 Mon Sep 17 00:00:00 2001
From: elkers <elkers@163.com>
Date: 星期六, 12 四月 2025 11:24:28 +0800
Subject: [PATCH] 添加报警记录
---
src/main/java/com/nanjing/water/repository/mapper/WaterFacilityParameterMapper.java | 8 ++++++++
1 files changed, 8 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/nanjing/water/repository/mapper/WaterFacilityParameterMapper.java b/src/main/java/com/nanjing/water/repository/mapper/WaterFacilityParameterMapper.java
index 25c40de..4e6615d 100644
--- a/src/main/java/com/nanjing/water/repository/mapper/WaterFacilityParameterMapper.java
+++ b/src/main/java/com/nanjing/water/repository/mapper/WaterFacilityParameterMapper.java
@@ -2,6 +2,10 @@
import com.nanjing.water.repository.BasicMapper;
import com.nanjing.water.repository.po.WaterFacilityParameterPO;
+import com.nanjing.water.repository.vo.FacilityParameterDataVO;
+import org.apache.ibatis.annotations.Select;
+
+import java.util.List;
/**
* 设备设定参数 mapper
@@ -9,4 +13,8 @@
* @author lin.liu
*/
public interface WaterFacilityParameterMapper extends BasicMapper<WaterFacilityParameterPO> {
+
+ @Select("SELECT wf.id,wf.facility_code,wf.facility_name,wfp.columns_code,wfp.columns_show,wfp.column_value,wfp.last_time FROM water_facility wf right JOIN water_facility_parameter wfp ON wf.id=wfp.facility_id WHERE wf.is_delete=0\n" +
+ "AND (wfp.columns_code='B001StartNumber' OR wfp.columns_code='B002StartNumber')")
+ List<FacilityParameterDataVO> getListNewPump();
}
--
Gitblit v1.9.3