From a15a8cfd7b01ce4bba6fe9fd876f6704ca23a12d Mon Sep 17 00:00:00 2001 From: liurunyu <lry9898@163.com> Date: 星期二, 07 一月 2025 16:40:32 +0800 Subject: [PATCH] 1、取水口用水日统计表中增加金额、次数字段; 2、优化或重写“累计流量超过指定值的取水口”、“累计流量低于指定值的取水口”、“指定时间段内用水量超过指定值的取水口”、“指定时间段内消费金额超过指定值的取水口”几个统计查询; 3、改“指定时间段内用水时长超过指定值的取水口”为“指定时间段内用水次数超过指定值的取水口” --- pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmOnHourReportLastMapper.java | 88 +++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 87 insertions(+), 1 deletions(-) diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmOnHourReportLastMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmOnHourReportLastMapper.java index d02ab16..bb17720 100644 --- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmOnHourReportLastMapper.java +++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmOnHourReportLastMapper.java @@ -2,10 +2,12 @@ import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.dy.pipIrrGlobal.pojoRm.RmOnHourReportLast; -import com.dy.pipIrrGlobal.pojoRm.RmOpenCloseValveHistory; +import com.dy.pipIrrGlobal.voRm.VoOnHour; +import com.dy.pipIrrGlobal.voSt.*; import org.apache.ibatis.annotations.Mapper; import java.util.List; +import java.util.Map; /** * @Author: liurunyu @@ -64,4 +66,88 @@ * @return */ List<RmOnHourReportLast> getRmOnHourReportLast(Long intakeId); + + /** + * 鏍规嵁鎸囧畾鏉′欢鑾峰彇鏁寸偣鎶ユ渶鏂拌褰曟暟閲� + * @param params + * @return + */ + Long getOnHourReportsCount_last(Map<?, ?> params); + + /** + * 鏍规嵁鎸囧畾鏉′欢鑾峰彇鏁寸偣鎶ユ渶鏂拌褰� + * @param params + * @return + */ + List<VoOnHour> getOnHourReports_last(Map<?, ?> params); + + /** + * 鑾峰彇绱娴侀噺瓒呰繃鎸囧畾鍊肩殑鍙栨按鍙f暟閲� + * @param params + * @return + */ + Long getLargeFlowIntakesCount(Map<?, ?> params); + + /** + * 鑾峰彇绱娴侀噺瓒呰繃鎸囧畾鍊肩殑鍙栨按鍙� + * @param params + * @return + */ + List<VoCumulativeFlow> getLargeFlowIntakes(Map<?, ?> params); + + /** + * 鑾峰彇绱娴侀噺浣庝簬鎸囧畾鍊肩殑鍙栨按鍙f暟閲� + * @param params + * @return + */ + Long getSmallFlowIntakesCount(Map<?, ?> params); + + /** + * 鑾峰彇绱娴侀噺浣庝簬鎸囧畾鍊肩殑鍙栨按鍙� + * @param params + * @return + */ + List<VoCumulativeFlow> getSmallFlowIntakes(Map<?, ?> params); + + /** + * 鑾峰彇娆犲帇鍙栨按鍙f暟閲� + * @param params + * @return + */ + Long getUnderVoltIntakesCount(Map<?, ?> params); + + /** + * 鑾峰彇娆犲帇鍙栨按鍙� + * @param params + * @return + */ + List<VoBatteryVolt> getUnderVoltIntakes(Map<?, ?> params); + + /** + * 鑾峰彇鎸囧畾淇″彿寮哄害鐨勫彇姘村彛鏁伴噺 + * @param params + * @return + */ + Long getSpecifiedSignalIntakesCount(Map<?, ?> params); + + /** + * 鑾峰彇鎸囧畾淇″彿寮哄害鐨勫彇姘村彛 + * @param params + * @return + */ + List<VoSignalIntensity> getSpecifiedSignalIntakes(Map<?, ?> params); + + /** + * 鏈�杩戞湭鎶ユ暟鐨勫彇姘村彛鏁伴噺 + * @param params + * @return + */ + Long getUnReportedIntakesCount(Map<String, Object> params); + + /** + * 鏈�杩戞湭鎶ユ暟鐨勫彇姘村彛 + * @param params + * @return + */ + List<VoIntakeUnReported> getUnReportedIntakes(Map<String, Object> params); } \ No newline at end of file -- Gitblit v1.8.0