From c9cbc0947f6fe578d1f178d73a2dd46d95bec275 Mon Sep 17 00:00:00 2001
From: wang-hao-jie <1550036656@qq.com>
Date: 星期一, 07 二月 2022 08:40:22 +0800
Subject: [PATCH] 违章记录
---
xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/CarMapper.java | 24 ++++++++++++------------
1 files changed, 12 insertions(+), 12 deletions(-)
diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/CarMapper.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/CarMapper.java
index 5fdb0bf..0f88580 100644
--- a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/CarMapper.java
+++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/CarMapper.java
@@ -43,18 +43,18 @@
List<Car> getCarInfo2(@Param(Constants.WRAPPER) QueryWrapper<Car> wrapper);
@Select("select \n" +
- "sum(case when create_time <= '${year}-01' then 1 else 0 end) as january,\n" +
- "sum(case when create_time <= '${year}-02' then 1 else 0 end) as february,\n" +
- "sum(case when create_time <= '${year}-03' then 1 else 0 end) as march,\n" +
- "sum(case when create_time <= '${year}-04' then 1 else 0 end) as april,\n" +
- "sum(case when create_time <= '${year}-05' then 1 else 0 end) as may,\n" +
- "sum(case when create_time <= '${year}-06' then 1 else 0 end) as june,\n" +
- "sum(case when create_time <= '${year}-07' then 1 else 0 end) as july,\n" +
- "sum(case when create_time <= '${year}-08' then 1 else 0 end) as august,\n" +
- "sum(case when create_time <= '${year}-09' then 1 else 0 end) as september,\n" +
- "sum(case when create_time <= '${year}-10' then 1 else 0 end) as october,\n" +
- "sum(case when create_time <= '${year}-11' then 1 else 0 end) as november,\n" +
- "sum(case when create_time <= '${year}-12' then 1 else 0 end) as december\n" +
+ "sum(case when create_time < '${year}-02' then 1 else 0 end) as january,\n" +
+ "sum(case when create_time < '${year}-03' then 1 else 0 end) as february,\n" +
+ "sum(case when create_time < '${year}-04' then 1 else 0 end) as march,\n" +
+ "sum(case when create_time < '${year}-05' then 1 else 0 end) as april,\n" +
+ "sum(case when create_time < '${year}-06' then 1 else 0 end) as may,\n" +
+ "sum(case when create_time < '${year}-07' then 1 else 0 end) as june,\n" +
+ "sum(case when create_time < '${year}-08' then 1 else 0 end) as july,\n" +
+ "sum(case when create_time < '${year}-09' then 1 else 0 end) as august,\n" +
+ "sum(case when create_time < '${year}-10' then 1 else 0 end) as september,\n" +
+ "sum(case when create_time < '${year}-11' then 1 else 0 end) as october,\n" +
+ "sum(case when create_time < '${year}-12' then 1 else 0 end) as november,\n" +
+ "sum(case when create_time < '${year}-13' then 1 else 0 end) as december\n" +
"from t_car")
Month getCarCount(@Param("year")Integer year);
--
Gitblit v1.9.1