From 5715d16c6fc4842191c802adb2e3b94d19f44f17 Mon Sep 17 00:00:00 2001 From: liurunyu <lry9898@163.com> Date: 星期四, 21 八月 2025 16:02:38 +0800 Subject: [PATCH] 完善代码 --- pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoLargeScreen/Ls4StatisticsMapper.java | 86 +++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 86 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..b282b17 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,16 @@ package com.dy.pipIrrGlobal.daoLargeScreen; import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.dy.pipIrrGlobal.voMd.VoCrops; +import com.dy.pipIrrGlobal.voSpecial.VoTopXClient; +import com.dy.pipIrrGlobal.voSpecial.VoTopXIntake; +import com.dy.pipIrrGlobal.voMd.VoCropsSimple; +import com.dy.pipIrrGlobal.voMd.VoEt0Simple; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import java.util.Date; +import java.util.List; /** * @Author: liurunyu @@ -75,4 +81,84 @@ */ 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) ; + + + /** + * 鎵�鏈変綔鐗� + * @return 瀹炰綋闆嗗悎 + */ + List<VoCropsSimple> allCropts() ; + + + /** + * 鎵�鏈変綔鐗� + * @return 瀹炰綋闆嗗悎 + */ + List<VoEt0Simple> et0InWeek(@Param("cropId") Long cropId, @Param("startDate")String startDate, @Param("endDate")String endDate) ; + + + } -- Gitblit v1.8.0