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/WaterFacilityParameterMapper.java | 21 ++++++++++++++++++++-
1 files changed, 20 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/fengdu/gas/repository/mapper/WaterFacilityParameterMapper.java b/src/main/java/com/fengdu/gas/repository/mapper/WaterFacilityParameterMapper.java
index e2b1810..585a685 100644
--- a/src/main/java/com/fengdu/gas/repository/mapper/WaterFacilityParameterMapper.java
+++ b/src/main/java/com/fengdu/gas/repository/mapper/WaterFacilityParameterMapper.java
@@ -1,10 +1,29 @@
package com.fengdu.gas.repository.mapper;
-import com.fengdu.gas.repository.BasicMapper;import com.fengdu.gas.repository.po.WaterFacilityParameterPO;
+import com.fengdu.gas.repository.BasicMapper;
+import com.fengdu.gas.repository.po.WaterFacilityParameterPO;
+import com.fengdu.gas.repository.vo.WaterFacilityParameterVO;
+import org.apache.ibatis.annotations.Select;
+
+import java.util.List;
/**
* 设备设定参数 mapper
* @author zr
*/
public interface WaterFacilityParameterMapper extends BasicMapper<WaterFacilityParameterPO> {
+
+ @Select({
+ "<script>",
+ "SELECT a.*,b.facility_state,b.facility_name,b.point_id,b.point_name FROM water_facility_parameter a ",
+ "left join water_facility b ON a.facility_id=b.id WHERE a.is_delete=0",
+ "<if test= \"pointId!=null and pointId>0 \">",
+ "and b.point_id=#{pointId}",
+ "</if>",
+ "<if test= \"facilityState!=null\">",
+ "and b.facility_state=#{facilityState}",
+ "</if>",
+ "</script>"
+ })
+ List<WaterFacilityParameterVO> getListData(Long pointId, Integer facilityState);
}
--
Gitblit v1.9.3