From 1a2b07f01ba4616fd9e894dddf474b56d020158c Mon Sep 17 00:00:00 2001
From: zhubaomin <zhubaomin>
Date: 星期一, 07 四月 2025 15:18:51 +0800
Subject: [PATCH] 整理版本
---
pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoLargeScreen/Ls4StatisticsMapper.java | 146 ++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 146 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
new file mode 100644
index 0000000..450fd42
--- /dev/null
+++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoLargeScreen/Ls4StatisticsMapper.java
@@ -0,0 +1,146 @@
+package com.dy.pipIrrGlobal.daoLargeScreen;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.dy.pipIrrGlobal.voSpecial.VoTopXClient;
+import com.dy.pipIrrGlobal.voSpecial.VoTopXIntake;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+
+import java.util.Date;
+import java.util.List;
+
+/**
+ * @Author: liurunyu
+ * @Date: 2025/2/6 10:46
+ * @Description
+ */
+@Mapper
+public interface Ls4StatisticsMapper extends BaseMapper<Object> {
+
+ /**
+ * 娑夊強琛屾斂鍖哄垝鎬绘暟
+ * @return
+ */
+ Integer totalCountOfDistrict(@Param("level")Integer level) ;
+ /**
+ * 鐗囧尯鎬绘暟
+ * @return
+ */
+ Integer totalCountOfBlock() ;
+ /**
+ * 鍒嗘按鎴挎�绘暟
+ * @return
+ */
+ Integer totalCountOfDivide() ;
+ /**
+ * 鍙栨按鍙ｆ�绘暟
+ * @return
+ */
+ Integer totalCountOfIntake() ;
+ /**
+ * 宸茬粦瀹氭帶鍒跺櫒鐨勫彇姘村彛鎬绘暟
+ * @return
+ */
+ Integer totalCountOfIntakeWithController() ;
+ /**
+ * 鏈粦瀹氭帶鍒跺櫒鐨勫彇姘村彛鎬绘暟
+ * @return
+ */
+ Integer totalCountOfIntakeWithoutController() ;
+ /**
+ * 闃�鎺у櫒鎬绘暟
+ * @return
+ */
+ Integer totalCountOfController() ;
+ /**
+ * 娴佹氮闃�鎺у櫒鎬绘暟
+ * @return
+ */
+ Integer totalCountOfControllerTramp() ;
+
+ /**
+ * 寮�闃�鎬绘暟
+ */
+ Integer totalCountOfOpenValve(@Param("dt") Date dt) ;
+
+ /**
+ * 鍏抽榾鎬绘暟
+ */
+ Integer totalCountOfCloseValve(@Param("dt") Date dt) ;
+
+ /**
+ * 鎶ヨ鎬绘暟
+ */
+ Integer totalCountOfAlarm(@Param("dt") Date dt) ;
+
+ /**
+ * 鏃犳姤璀︽�绘暟
+ */
+ 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() ;
+
+
+
+
+ /**
+ * 鏌愭棩鍐滄埛鐢ㄦ按鍓峏鍚�
+ * @param idStart 璧峰id
+ * @param idEnd 鎴id
+ * @param count 鍓嶅嚑鍚�
+ * @return 瀹炰綋闆嗗悎
+ */
+ List<VoTopXClient> topXClientAtCertainDay(@Param("idStart") Long idStart, @Param("idEnd") Long idEnd, @Param("count") int count) ;
+
+ /**
+ * 鏌愭棩鍙栨按鍙ｇ敤姘村墠X鍚�
+ * @param idStart 璧峰id
+ * @param idEnd 鎴id
+ * @param count 鍓嶅嚑鍚�
+ * @return 瀹炰綋闆嗗悎
+ */
+ List<VoTopXIntake> topXIntakeAtCertainDay(@Param("idStart") Long idStart, @Param("idEnd") Long idEnd, @Param("count") int count) ;
+
+
+}
--
Gitblit v1.8.0