From 2aabed512ca44772d16d31bce833f31184676867 Mon Sep 17 00:00:00 2001
From: yeg <1347747024@qq.com>
Date: 星期四, 17 九月 2026 11:10:08 +0800
Subject: [PATCH] fix(merchant): 首页交易总额只统计已核销订单，退款受理后立即回落
---
talent-card-server/src/main/java/com/talentcard/server/mapper/StatisticsQuerySql.java | 3 +++
1 files changed, 3 insertions(+), 0 deletions(-)
diff --git a/talent-card-server/src/main/java/com/talentcard/server/mapper/StatisticsQuerySql.java b/talent-card-server/src/main/java/com/talentcard/server/mapper/StatisticsQuerySql.java
index 0f856d6..e5ebb0b 100644
--- a/talent-card-server/src/main/java/com/talentcard/server/mapper/StatisticsQuerySql.java
+++ b/talent-card-server/src/main/java/com/talentcard/server/mapper/StatisticsQuerySql.java
@@ -382,10 +382,13 @@
return sql("""
select
coalesce((
+ -- 只算已核销的实付金额：未核销的钱还扣在通道的延迟户里，核销后才分账给商户；
+ -- 退款中的订单在通道结果收敛前仍是 order_status = 1，只有「已核销」能立刻挡住它。
select sum(o.pay_amount)
from benefit_order o
where o.deleted = 0
and o.order_status = 1
+ and o.verify_status = 1
and o.merchant_id = #{merchantId}
), 0) as transactionAmountCents,
coalesce((
--
Gitblit v1.7.1