From 548678d4cf3d1792e2cb989f26cf7e8af0ec8fde Mon Sep 17 00:00:00 2001 From: zhubaomin <zhubaomin> Date: 星期三, 09 四月 2025 11:41:49 +0800 Subject: [PATCH] 优化灌溉计划起止时间格式,精确到分钟 --- pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoLargeScreen/Ls4StatisticsMapper.java | 68 ++++++++++++++++++++++++++++++++++ 1 files changed, 68 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..450fd42 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 @@ -1,10 +1,13 @@ 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 @@ -75,4 +78,69 @@ */ 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) ; + + /** + * 鏌愭棩鍙栨按鍙g敤姘村墠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