From 6c764f473b1e0e9dd2fb13034fe0d7295ab3724e Mon Sep 17 00:00:00 2001
From: xuefei <564615061@qq.cm>
Date: 星期二, 08 八月 2023 11:05:58 +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