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/daoSe/SeWalletMapper.java | 34 ++++++++++++++++++++++++++++++---- 1 files changed, 30 insertions(+), 4 deletions(-) diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeWalletMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeWalletMapper.java index 1cc0294..45f3f55 100644 --- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeWalletMapper.java +++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeWalletMapper.java @@ -2,17 +2,22 @@ import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.dy.pipIrrGlobal.pojoSe.SeWallet; +import com.dy.pipIrrGlobal.voSe.VoWallet; import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Param; + +import java.util.List; +import java.util.Map; /** * @author ZhuBaoMin - * @date 2023/12/11 16:29 - * @LastEditTime 2023/12/11 16:29 - * @Description + * @date 2024-01-30 15:41 + * @LastEditTime 2024-01-30 15:41 + * @Description 鐢靛瓙閽卞寘Mapper鎺ュ彛 */ @Mapper -public interface SeWalletMapper extends BaseMapper<SeWallet> { +public interface SeWalletMapper extends BaseMapper { int deleteByPrimaryKey(Long id); int insert(SeWallet record); @@ -24,4 +29,25 @@ int updateByPrimaryKeySelective(SeWallet record); int updateByPrimaryKey(SeWallet record); + + /** + * 鏍规嵁鍐滄埛ID鑾峰彇鐢靛瓙閽卞寘瀵硅薄 + * @param clientId + * @return + */ + SeWallet getWalletByClientId(@Param("clientId") Long clientId); + + /** + * 鏍规嵁鍐滄埛濮撳悕鑾峰彇鐢靛瓙閽卞寘璐︽埛璁板綍鏁� + * @param params + * @return + */ + Long getRecordCount(Map<?, ?> params); + + /*** + * 鏍规嵁鍐滄埛濮撳悕鑾峰彇鐢靛瓙閽卞寘璐︽埛璁板綍 + * @param params + * @return + */ + List<VoWallet> getWallets(Map<?, ?> params); } \ No newline at end of file -- Gitblit v1.8.0