modify

Helius

2020-07-11 27bfdf62608008555876d295c18661c0f0f7e7ba

modify

 src/main/resources/mapper/modules/CoinMapper.xml

@@ -30,7 +30,7 @@
                b.symbol symbol,
                b.create_time createTime
            from member a
            inner join member_coin_charge b on a.id=b.member_id and b.status=2
            inner join member_coin_charge b on a.id=b.member_id --and b.status=3
            where find_in_set(#{record.refererId}, a.referer_ids)
            <if test="record.account!=null and record.account!=''">
                and (a.phone=#{record.account} or a.email=#{record.account} or a.invite_id=#{record.account})
@@ -67,7 +67,7 @@
                b.symbol symbol,
                b.create_time createTime
            from member a
            inner join member_coin_withdraw b on a.id=b.member_id and b.status=2
            inner join member_coin_withdraw b on a.id=b.member_id --and b.status=2
            where find_in_set(#{record.refererId}, a.referer_ids)
            <if test="record.account!=null and record.account!=''">
                and (a.phone=#{record.account} or a.email=#{record.account} or a.invite_id=#{record.account})

 src/main/resources/mapper/modules/ContractOrderMapper.xml

@@ -12,7 +12,7 @@
            c.closing_fee_amount*(select fee_spread_ratio from platform_trade_setting) closing_fee_amount,
            c.*
        from member a
        inner join member_authentication b on a.id=b.member_id
        left join member_authentication b on a.id=b.member_id
        inner join contract_order c on a.id=c.member_id
        <where>
            <if test="record!=null">