From 61cd88d889547379c1c30c534e56a590e2577f49 Mon Sep 17 00:00:00 2001 From: liurunyu <lry9898@163.com> Date: 星期五, 07 二月 2025 15:49:51 +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