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-common/src/main/java/com/dy/common/mybatis/MyBatisConfig.java | 20 ++++++++++++++++++++ 1 files changed, 20 insertions(+), 0 deletions(-) diff --git a/pipIrr-platform/pipIrr-common/src/main/java/com/dy/common/mybatis/MyBatisConfig.java b/pipIrr-platform/pipIrr-common/src/main/java/com/dy/common/mybatis/MyBatisConfig.java index 82f20fa..60eef8c 100644 --- a/pipIrr-platform/pipIrr-common/src/main/java/com/dy/common/mybatis/MyBatisConfig.java +++ b/pipIrr-platform/pipIrr-common/src/main/java/com/dy/common/mybatis/MyBatisConfig.java @@ -1,8 +1,11 @@ package com.dy.common.mybatis; +import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor; import jakarta.annotation.PostConstruct; import org.apache.ibatis.session.SqlSessionFactory; import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.beans.factory.annotation.Value; +import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; import java.util.List; @@ -13,11 +16,28 @@ @Autowired private List<SqlSessionFactory> sqlSessionFactoryList; + @Value("${mybatis-plus.configuration.print-sql}") + private boolean printSql; + /** + * 涓や釜鎷︽埅鍣紝鑷姩鐢熸垚ID锛屽紓甯告椂杈撳嚭SQL + */ @PostConstruct public void addMyInterceptor() { for (SqlSessionFactory sqlSessionFactory : sqlSessionFactoryList) { sqlSessionFactory.getConfiguration().addInterceptor(new AutoGenerateIdInterceptor()); sqlSessionFactory.getConfiguration().addInterceptor(new PrintExceptionSqlInterceptor()); + if (printSql) { + sqlSessionFactory.getConfiguration().addInterceptor(new PrintSqlInterceptor()); + } } } + + /** + * mybatisPlus鐨勫垎闈㈡彃浠� + * @return 鎷︽埅鍣� + */ + @Bean + public PaginationInnerInterceptor paginationInnerInterceptor(){ + return new PaginationInnerInterceptor() ; + } } -- Gitblit v1.8.0