From e8f0b3422d307c686b3a81269f9e9e4fb34a846e Mon Sep 17 00:00:00 2001
From: wjli <591616088@qq.com>
Date: 星期五, 12 四月 2024 10:49:46 +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