From 6fa8408c8133e8c9aee2bbcdec37bf95c20951c0 Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期五, 07 二月 2025 15:39:16 +0800
Subject: [PATCH] 涉嫌偷水功能增加查询条件用水时长，修改sql语句
---
pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoLargeScreen/Ls4StatisticsMapper.java | 43 +++++++++++++++++++++++++++++++++++++++++++
1 files changed, 43 insertions(+), 0 deletions(-)
diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoLargeScreen/Ls4StatisticsMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoLargeScreen/Ls4StatisticsMapper.java
index 9f27c42..ebf5a7c 100644
--- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoLargeScreen/Ls4StatisticsMapper.java
+++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoLargeScreen/Ls4StatisticsMapper.java
@@ -75,4 +75,47 @@
*/
Integer totalCountOfNoAlarm(@Param("dt") Date dt) ;
+
+ /**
+ * 浠庢煇鏃朵互鏉ワ紝鏇句笂鎶ヨ繃鏁版嵁鐨勬�绘暟
+ */
+ Integer mTotalCountOfReport(@Param("fromDt") Date fromDt) ;
+ /**
+ * 浠庢煇鏃朵互鏉ワ紝鏈浘涓婃姤杩囨暟鎹殑鎬绘暟
+ */
+ Integer mTotalCountOfNoReport(@Param("fromDt") Date fromDt) ;
+ /**
+ * 浠庢湭涓婃姤杩囨暟鎹殑鎬绘暟
+ */
+ Integer mTotalCountOfNeverReport() ;
+
+
+ /**
+ * 浠庢煇鏃朵互鏉ワ紝鏇鹃榾寮�鎬绘暟
+ */
+ Integer mTotalCountOfOpenValve(@Param("fromDt") Date fromDt) ;
+ /**
+ * 浠庢煇鏃朵互鏉ワ紝鏇鹃榾鍏虫�绘暟
+ */
+ Integer mTotalCountOfCloseValve(@Param("fromDt") Date fromDt) ;
+ /**
+ * 浠庢湭寮�杩囬榾鐨勬�绘暟
+ */
+ Integer mTotalCountOfNeverOpenValve() ;
+
+
+
+ /**
+ * 浠庢煇鏃朵互鏉ワ紝鏇炬姤璀︽�绘暟
+ */
+ Integer mTotalCountOfAlarm(@Param("fromDt") Date fromDt) ;
+ /**
+ * 浠庢煇鏃朵互鏉ワ紝鏇炬棤鎶ヨ鎬绘暟
+ */
+ Integer mTotalCountOfNoAlarm(@Param("fromDt") Date fromDt) ;
+ /**
+ * 浠庢湭鎶ヨ繃璀︽�绘暟
+ */
+ Integer mTotalCountOfNeverAlarm() ;
+
}
--
Gitblit v1.8.0