From 341fe2b0bbb092b899302c1899b7135c5f29db24 Mon Sep 17 00:00:00 2001
From: mitao <2763622819@qq.com>
Date: 星期五, 11 四月 2025 21:03:36 +0800
Subject: [PATCH] bug修改
---
cloud-server-activity/src/main/resources/mapper/PayHuiminMapper.xml | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/cloud-server-activity/src/main/resources/mapper/PayHuiminMapper.xml b/cloud-server-activity/src/main/resources/mapper/PayHuiminMapper.xml
index 51ad938..2793cb5 100644
--- a/cloud-server-activity/src/main/resources/mapper/PayHuiminMapper.xml
+++ b/cloud-server-activity/src/main/resources/mapper/PayHuiminMapper.xml
@@ -13,7 +13,7 @@
thc.storeIds,
tph.appUserId,
tph.paymentTime,
- thc.endTime,
+ tph.endTime,
tph.studentId,
thc.id as carId,
tph.status
@@ -67,7 +67,7 @@
<select id="getStaticsData" resultType="java.util.Map"
parameterType="com.dsh.activity.entity.HuiminPayQuery">
SELECT
- COALESCE(SUM( tph.salesMoney),0) AS totalAmount,
+ COALESCE(SUM(CASE WHEN tph.status IN (2,3) THEN tph.salesMoney ELSE 0 END),0) AS totalAmount,
COALESCE(SUM(CASE WHEN refundStatus IN (2, 3) THEN tph.salesMoney ELSE 0 END),0) AS refundAmount
FROM t_pay_huimin tph
LEFT JOIN t_huimin_card thc ON tph.cardId = thc.id
--
Gitblit v1.7.1