From 3eb2997736da1cf1e996ba8effdc5382ec3d189b Mon Sep 17 00:00:00 2001
From: xiaoyong931011 <15274802129@163.com>
Date: Wed, 11 Oct 2023 16:12:34 +0800
Subject: [PATCH] redbagprod
---
src/main/resources/mapper/modules/MallMemberCouponMapper.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/src/main/resources/mapper/modules/MallMemberCouponMapper.xml b/src/main/resources/mapper/modules/MallMemberCouponMapper.xml
index 852ed90..ec06208 100644
--- a/src/main/resources/mapper/modules/MallMemberCouponMapper.xml
+++ b/src/main/resources/mapper/modules/MallMemberCouponMapper.xml
@@ -8,7 +8,7 @@
b.cost_amount costAmount,
b.real_amount realAmount
from mall_member_coupon a
- left join mall_goods_coupon b on b.id = a.coupon_id
+ left join mall_goods_coupon b on b.id = a.coupon_id and b.state = 2
<where>
a.member_id=#{record.memberId}
<if test="record.state == 1">
--
Gitblit v1.9.1