From ce84b0344bbe92eda39bb172a2cced4fd514594a Mon Sep 17 00:00:00 2001
From: KKSU <15274802129@163.com>
Date: Mon, 04 Dec 2023 16:17:27 +0800
Subject: [PATCH] 用户留言
---
src/main/resources/mapper/modules/MallProductBuyRecordMapper.xml | 1 +
src/main/resources/mapper/modules/MallProductSellRecordMapper.xml | 1 +
2 files changed, 2 insertions(+), 0 deletions(-)
diff --git a/src/main/resources/mapper/modules/MallProductBuyRecordMapper.xml b/src/main/resources/mapper/modules/MallProductBuyRecordMapper.xml
index 9b862c4..11243dc 100644
--- a/src/main/resources/mapper/modules/MallProductBuyRecordMapper.xml
+++ b/src/main/resources/mapper/modules/MallProductBuyRecordMapper.xml
@@ -17,6 +17,7 @@
left join mall_member b on a.member_id = b.id
left join mall_member_payment c on a.member_id = c.member_id
where a.buy_id = #{productBuyId}
+ and a.state != 0
</select>
<select id="selectListByBuyId" resultType="cc.mrbird.febs.mall.entity.MallProductBuyRecord">
diff --git a/src/main/resources/mapper/modules/MallProductSellRecordMapper.xml b/src/main/resources/mapper/modules/MallProductSellRecordMapper.xml
index 0ce0321..f9ad184 100644
--- a/src/main/resources/mapper/modules/MallProductSellRecordMapper.xml
+++ b/src/main/resources/mapper/modules/MallProductSellRecordMapper.xml
@@ -17,6 +17,7 @@
left join mall_member b on a.member_id = b.id
left join mall_member_payment c on a.member_id = c.member_id
where a.sell_id = #{productSellId}
+ and a.state != 0
</select>
<select id="selectListBySellId" resultType="cc.mrbird.febs.mall.entity.MallProductSellRecord">
--
Gitblit v1.9.1