From a8157b2445e6d17fa23fcf19143f5e1fcb179ee2 Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期一, 16 十二月 2024 10:09:40 +0800
Subject: [PATCH] 实现临时任务功能：重新统计所有取水口月用水量和年用水量
---
pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmCommandHistoryMapper.java | 68 ++++++++++++++++++++++++++++++++--
1 files changed, 64 insertions(+), 4 deletions(-)
diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmCommandHistoryMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmCommandHistoryMapper.java
index 9e104c3..183454d 100644
--- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmCommandHistoryMapper.java
+++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmCommandHistoryMapper.java
@@ -2,26 +2,86 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dy.pipIrrGlobal.pojoRm.RmCommandHistory;
+import com.dy.pipIrrGlobal.voRm.VoCommand;
+import com.dy.pipIrrGlobal.voRm.VoRtuAndVc;
+import com.dy.pipIrrGlobal.voRm.VoUnclosedParam;
+import com.dy.pipIrrGlobal.voRm.VoUnclosedValve;
import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+
+import java.util.List;
+import java.util.Map;
/**
* @author ZhuBaoMin
- * @date 2024-05-22 14:29
- * @LastEditTime 2024-05-22 14:29
+ * @date 2024-07-17 10:31
+ * @LastEditTime 2024-07-17 10:31
* @Description
*/
@Mapper
public interface RmCommandHistoryMapper extends BaseMapper<RmCommandHistory> {
- int deleteByPrimaryKey(Long id);
+ int deleteByPrimaryKey(Long comId);
int insert(RmCommandHistory record);
int insertSelective(RmCommandHistory record);
- RmCommandHistory selectByPrimaryKey(Long id);
+ RmCommandHistory selectByPrimaryKey(Long comId);
int updateByPrimaryKeySelective(RmCommandHistory record);
int updateByPrimaryKey(RmCommandHistory record);
+
+
+ /**
+ * 鏍规嵁operator鑾峰彇鏈叧闃�鐨凴TU鍦板潃鍙婅櫄鎷熷崱缂栧彿鏁版嵁瀵癸紝鑾峰彇鏈叧闃�璁板綍浣跨敤
+ * @param operator
+ * @return
+ */
+ List<VoRtuAndVc> getUnclosedRtus(Long operator);
+
+ /**
+ * 鏍规嵁RTU鍦板潃鍜岃櫄鎷熷崱缂栧彿鑾峰彇鎴愬姛寮�闃�鐨勬渶鍚庝竴鏉¤褰曪紝鑾峰彇鏈叧闃�璁板綍浣跨敤
+ * @param rtuAddr
+ * @param vcNum
+ * @return
+ */
+ Long getLastComId(@Param("rtuAddr")String rtuAddr, @Param("vcNum")String vcNum);
+
+ /**
+ * 鏍规嵁鍛戒护鏃ュ織缂栧彿闆嗗悎鑾峰彇鏈叧闃�璁板綍
+ * @param onLineMap
+ * @param comIds
+ * @return
+ */
+ List<VoUnclosedValve> getUnclosedValves(@Param("onLineMap") String onLineMap, @Param("comIds") String comIds);
+
+ /**
+ * 鏍规嵁鍙栨按鍙D鑾峰彇璇ュ彇姘村彛鏈叧闃�鍙傛暟锛屽钩鍙伴�夋嫨鍙栨按鍙ｅ叧闃�浣跨敤
+ * @param intakeId
+ * @return
+ */
+ VoUnclosedParam getUncloseParam(@Param("onLineMap") String onLineMap, @Param("intakeId")Long intakeId);
+
+ /**
+ * 鏍规嵁鎸囧畾鏉′欢鑾峰彇鍛戒护鏃ュ織鍘嗗彶璁板綍鎬绘暟
+ * @param params
+ * @return
+ */
+ Long getCommandHistoriesCount(Map<?, ?> params);
+
+ /**
+ * 鏍规嵁鎸囧畾鏉′欢鑾峰彇鍛戒护鏃ュ織鍘嗗彶璁板綍
+ * @param params
+ * @return
+ */
+ List<VoCommand> getCommandHistories(Map<?, ?> params);
+
+ /**
+ * 鏍规嵁鍛戒护鏃ュ織ID鑾峰彇棰勭害鏃堕棿锛屽悜铏氭嫙鍗″啓寮�闃�鏃堕棿鐢�
+ * @param commId
+ * @return
+ */
+ String getTimeByCommId(Long commId);
}
\ No newline at end of file
--
Gitblit v1.8.0