20210129

xiaoyong931011

2021-01-29 19d8915857872167150ee33dd34e134075501f16

20210129

 src/main/resources/mapper/member/MemberAccountMoneyChangeDao.xml

@@ -5,7 +5,8 @@
    <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 '%收款%')

                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")) )

        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}

                where member_id = #{record.memberId} and is_inside = “N”

        order by create_time desc

    </select>