20210413 划转记录

xiaoyong931011

2021-04-13 b8eb5917f8271573e60a84d3eb591e92fd50f374

20210413 划转记录

 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>

    


 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>