From bcf8c46e009d5d825a7bf07b9eac46fb7432418b Mon Sep 17 00:00:00 2001
From: liulin <lin.liu@88.com>
Date: 星期四, 17 七月 2025 08:42:13 +0800
Subject: [PATCH] 添加首页大屏数据统计
---
src/main/java/com/fengdu/gas/repository/mapper/WaterFacilityMapper.java | 9 ++++++++-
1 files changed, 8 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/fengdu/gas/repository/mapper/WaterFacilityMapper.java b/src/main/java/com/fengdu/gas/repository/mapper/WaterFacilityMapper.java
index e57d58d..e949106 100644
--- a/src/main/java/com/fengdu/gas/repository/mapper/WaterFacilityMapper.java
+++ b/src/main/java/com/fengdu/gas/repository/mapper/WaterFacilityMapper.java
@@ -1,10 +1,17 @@
package com.fengdu.gas.repository.mapper;
-import com.fengdu.gas.repository.BasicMapper;import com.fengdu.gas.repository.po.WaterFacilityPO;
+import com.fengdu.gas.entity.response.facility.FacilityPointCount;
+import com.fengdu.gas.repository.BasicMapper;
+import com.fengdu.gas.repository.po.WaterFacilityPO;
+import org.apache.ibatis.annotations.Select;
+
+import java.util.List;
/**
* 设备信息 mapper
* @author zr
*/
public interface WaterFacilityMapper extends BasicMapper<WaterFacilityPO> {
+ @Select("SELECT point_name,COUNT(*) FROM water_facility WHERE is_delete=0 GROUP BY point_name")
+ List<FacilityPointCount> getFacilityPointCount();
}
--
Gitblit v1.9.3