From 421e01bc2af7515bb67df5f7f81652710b403067 Mon Sep 17 00:00:00 2001
From: kongdeqiang <123456>
Date: 星期五, 10 二月 2023 16:41:24 +0800
Subject: [PATCH] 增加功能
---
xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/CarMapper.java | 11 ++++++++++-
1 files changed, 10 insertions(+), 1 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 0f88580..1db91a0 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
@@ -58,4 +58,13 @@
"from t_car")
Month getCarCount(@Param("year")Integer year);
-}
\ No newline at end of file
+ @Select("SELECT\n" +
+ "\t( MAX( amount ) - MIN( amount ) ) AS amount,\n" +
+ "\tSUM( money ) AS money,\n" +
+ "\t( MAX( mileage ) - MIN( mileage ) ) AS mileage, \n" +
+ "\tSUM(amount) AS allAmount,SUM(money) AS allMoney,(MAX(mileage)) AS allMileage \n"+
+ "FROM\n" +
+ "\t t_add_oil a\n" +
+ "\t WHERE a.car_id = #{carId}")
+ Car getCarInfoByCarId(@Param("carId")String carId);
+}
--
Gitblit v1.9.1