From b8eb5917f8271573e60a84d3eb591e92fd50f374 Mon Sep 17 00:00:00 2001
From: xiaoyong931011 <15274802129@163.com>
Date: Tue, 13 Apr 2021 18:04:04 +0800
Subject: [PATCH] 20210413 划转记录
---
src/main/resources/mapper/member/MemberCoinWithdrawDao.xml | 2 +-
src/main/resources/mapper/member/MemberAccountMoneyChangeDao.xml | 3 +--
2 files changed, 2 insertions(+), 3 deletions(-)
diff --git a/src/main/resources/mapper/member/MemberAccountMoneyChangeDao.xml b/src/main/resources/mapper/member/MemberAccountMoneyChangeDao.xml
index d3c6b83..0c3addb 100644
--- a/src/main/resources/mapper/member/MemberAccountMoneyChangeDao.xml
+++ b/src/main/resources/mapper/member/MemberAccountMoneyChangeDao.xml
@@ -5,8 +5,7 @@
<select id="coinInList" resultType="com.xcong.excoin.modules.coin.entity.MemberAccountMoneyChange">
select * from member_account_money_change
where member_id = #{record.memberId}
- and (content like '%转%' or content like '%收款%' or (content like '%提币%' and withdraw_id in
- (select id from member_coin_withdraw w where w.member_id = #{record.memberId} and is_inside = "Y")) )
+ and (content like '%转%' or content like '%收款%')
order by create_time desc
</select>
diff --git a/src/main/resources/mapper/member/MemberCoinWithdrawDao.xml b/src/main/resources/mapper/member/MemberCoinWithdrawDao.xml
index bafe4bc..f2376b1 100644
--- a/src/main/resources/mapper/member/MemberCoinWithdrawDao.xml
+++ b/src/main/resources/mapper/member/MemberCoinWithdrawDao.xml
@@ -4,7 +4,7 @@
<select id="findMemberCoinWithdrawInPage" resultType="com.xcong.excoin.modules.member.entity.MemberCoinWithdrawEntity">
select * from member_coin_withdraw
- where member_id = #{record.memberId} and is_inside = 'N'
+ where member_id = #{record.memberId}
order by create_time desc
</select>
--
Gitblit v1.9.1