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/daoTmp/DeleteMapper.java | 86 +++++++++++++++++++++++++++++++++++++++++-- 1 files changed, 82 insertions(+), 4 deletions(-) diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoTmp/DeleteMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoTmp/DeleteMapper.java index bb61453..017e23b 100644 --- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoTmp/DeleteMapper.java +++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoTmp/DeleteMapper.java @@ -1,7 +1,7 @@ package com.dy.pipIrrGlobal.daoTmp; import com.baomidou.mybatisplus.core.mapper.BaseMapper; -import com.dy.pipIrrGlobal.voTmp.VoStLossMonth; +import com.dy.pipIrrGlobal.voTmp.*; import org.apache.ibatis.annotations.Mapper; import java.util.List; @@ -15,10 +15,88 @@ public interface DeleteMapper extends BaseMapper<Object> { /** - * 鏌ヨ鍏ㄩ儴婕忔崯鏈堢粺璁� + * 鏌ヨ鍏ㄩ儴婕忔崯鏃ョ粺璁� + * * @return 瀹炰綋闆嗗悎 */ - List<VoStLossMonth> selectAllStLossMonth() ; + List<VoStLossAmountDay> selectAllStLossDay(); - int deleteByMainKey(Long id) ; + int deleteStLossDayById(Long id); + + /** + * 鏌ヨ鍏ㄩ儴婕忔崯鏈堢粺璁� + * + * @return 瀹炰綋闆嗗悎 + */ + List<VoStLossAmountMonth> selectAllStLossMonth(); + + int deleteStLossMonthById(Long id); + + /** + * 鏌ヨ鍏ㄩ儴婕忔崯骞寸粺璁� + * + * @return 瀹炰綋闆嗗悎 + */ + List<VoStLossAmountYear> selectAllStLossYear(); + + int deleteStLossYearById(Long id); + + + /** + * 鏌ヨ鍏ㄩ儴鍙栨按鍙f棩缁熻 + * + * @return 瀹炰綋闆嗗悎 + */ + List<VoStIntakeAmountDay> selectAllStIntakeDay(); + + int deleteStIntakeDayById(Long id); + + + /** + * 鏌ヨ鍏ㄩ儴鍙栨按鍙f湀缁熻 + * + * @return 瀹炰綋闆嗗悎 + */ + List<VoStIntakeAmountMonth> selectAllStIntakeMonth(); + + int deleteStIntakeMonthById(Long id); + + /** + * 鏌ヨ鍏ㄩ儴鍙栨按鍙e勾缁熻 + * + * @return 瀹炰綋闆嗗悎 + */ + List<VoStIntakeAmountYear> selectAllStIntakeYear(); + + int deleteStIntakeYearById(Long id); + + + /** + * 鏌ヨ鍏ㄩ儴鍐滄埛鏈堢粺璁� + * + * @return 瀹炰綋闆嗗悎 + */ + List<VoStClientAmountDay> selectAllStClientDay(); + + int deleteStClientDayById(Long id); + + + /** + * 鏌ヨ鍏ㄩ儴鍐滄埛鏈堢粺璁� + * + * @return 瀹炰綋闆嗗悎 + */ + List<VoStClientAmountMonth> selectAllStClientMonth(); + + int deleteStClientMonthById(Long id); + + /** + * 鏌ヨ鍏ㄩ儴鍐滄埛骞寸粺璁� + * + * @return 瀹炰綋闆嗗悎 + */ + List<VoStClientAmountYear> selectAllStClientYear(); + + int deleteStClientYearById(Long id); + } \ No newline at end of file -- Gitblit v1.8.0