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((