From 780ea836252e49c2ca392a3865f7132afdcd3971 Mon Sep 17 00:00:00 2001
From: xuhy <3313886187@qq.com>
Date: 星期六, 26 十月 2024 11:37:45 +0800
Subject: [PATCH] 修改
---
ruoyi-service/ruoyi-order/src/main/resources/mapper/order/TShoppingOrderMapper.xml | 24 +++++++++++++-----------
ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/TShoppingOrderServiceImpl.java | 2 --
2 files changed, 13 insertions(+), 13 deletions(-)
diff --git a/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/TShoppingOrderServiceImpl.java b/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/TShoppingOrderServiceImpl.java
index 0e55c4c..bcd19e9 100644
--- a/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/TShoppingOrderServiceImpl.java
+++ b/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/TShoppingOrderServiceImpl.java
@@ -106,7 +106,6 @@
List<TActivityStatisticslVO> list = this.baseMapper.activityStatistics(pageInfo,dto);
List<TActivityStatisticslVO> list1 = this.baseMapper.activityStatistics(pageInfo1,dto);
- list.sort((o1, o2) -> o2.getCreateTime().compareTo(o1.getCreateTime()));
// 优惠券金额
BigDecimal coupon = new BigDecimal("0");
// 会员抵扣金额
@@ -202,7 +201,6 @@
stringBuilder.append("优惠券抵扣").append("+");
}
if (tActivityStatisticslVO.getVipDiscountAmount()!=null &&(tActivityStatisticslVO.getVipDiscountAmount().compareTo(BigDecimal.ZERO)>0)){
- discount = discount.add(tActivityStatisticslVO.getVipDiscountAmount());
stringBuilder.append("会员抵扣").append("+");
}
if (stringBuilder.length()>0){
diff --git a/ruoyi-service/ruoyi-order/src/main/resources/mapper/order/TShoppingOrderMapper.xml b/ruoyi-service/ruoyi-order/src/main/resources/mapper/order/TShoppingOrderMapper.xml
index 8d9321b..e0b7c1a 100644
--- a/ruoyi-service/ruoyi-order/src/main/resources/mapper/order/TShoppingOrderMapper.xml
+++ b/ruoyi-service/ruoyi-order/src/main/resources/mapper/order/TShoppingOrderMapper.xml
@@ -44,6 +44,7 @@
id, code, app_user_id, order_type, goods_id, coupon_id, purchase_quantity, app_user_address_id, order_amount, app_coupon_id, coupon_discount_amount, vip_discount, vip_discount_amount, payment_amount, payment_status, payment_type, serial_number, remark, status, express_company, express_number, consigner_id, consigner_time, receiving_time, cancellation_time, cancellation_id, refund_code, refund_amount, refund_status, refund_serial_number, refund_time, create_time, del_flag
</sql>
<select id="activityStatistics" resultType="com.ruoyi.order.api.vo.TActivityStatisticslVO">
+ select * from (
select t9.code ,t9.order_amount as orderAmount,
t9.coupon_discount_amount as couponDiscountAmount,
t9.vip_discount_amount as vipDiscountAmount,
@@ -52,19 +53,19 @@
t9.app_user_id as appUserId,
1 as orderType
from t_charging_order t9
- where t9.id = 0 limit 1
+ where t9.id = 0
<if test="req.orderType == null or req.orderType == 1">
<if test="req.type == null or req.type == 1 or req.type == 2">
union all
select
- t1.code ,
- t1.order_amount as orderAmount,
- t1.coupon_discount_amount as couponDiscountAmount,
- t1.vip_discount_amount as vipDiscountAmount,
- t1.payment_amount as paymentAmount,
- t1.create_time as createTime,
+ t1.code ,
+ t1.order_amount as orderAmount,
+ t1.coupon_discount_amount as couponDiscountAmount,
+ t1.vip_discount_amount as vipDiscountAmount,
+ t1.payment_amount as paymentAmount,
+ t1.create_time as createTime,
t1.app_user_id as appUserId,
- 1 as orderType
+ 1 as orderType
from t_charging_order t1
where 1 = 1
<if test="null != req.code and req.code!=''">
@@ -141,8 +142,8 @@
<if test="req.type == null or req.type == 3">
union all
select t3.code ,t3.order_amount as orderAmount,
- t3.discount_amount as couponDiscountAmount,
- 0 as vipDiscountAmount,
+ 0 as couponDiscountAmount,
+ t3.discount_amount as vipDiscountAmount,
t3.payment_amount as paymentAmount,
t3.create_time as createTime,
t3.app_user_id as appUserId,
@@ -194,10 +195,11 @@
AND (t5.create_time between CONCAT(#{req.startTime},':00') and CONCAT(#{req.endTime},':59'))
</if>
AND t5.del_flag = ${@com.ruoyi.common.core.enums.DelFlagEnum@NO.getCode()}
-
</if>
</if>
</if>
+ ) a
+ order by a.create_time DESC
</select>
--
Gitblit v1.7.1