modify

Helius

2020-06-29 59e44342eb0970ec4754d8361f5275fa011490ef

modify

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

@@ -47,13 +47,19 @@
            a.referer_id,
            a.invite_id,
            concat(c.first_name, c.second_name) account,
            sum(b.opening_fee_amount) openFeeAmount,
            sum(b.closing_fee_amount) closeFeeAmount,
            sum(b.hold_amount) holdFeeAmount,
            sum(reward_amount) loseOrProfit
            b.openFeeAmount openFeeAmount,
            d.holdAmount closeFeeAmount,
            d.closingFeeAmount holdFeeAmount,
            d.rewardAmount loseOrProfit
        from member a
        inner join member_authentication c on a.id=c.member_id
        inner join contract_order b on a.id=b.member_id and b.order_status=1
        inner join (select member_id, sum(opening_fee_amount) openFeeAmount from contract_order where order_type in (1,2) and order_status=1 group by member_id) b on a.id=b.member_id
        inner join (select
                   member_id,
                   sum(closing_fee_amount) closingFeeAmount,
                   sum(hold_amount) holdAmount,
                   sum(reward_amount) rewardAmount
            from contract_order where order_type in (3,4) and order_status=1 group by member_id) d on a.id=d.member_id
        where find_in_set(#{record.refererId}, a.referer_ids)
        group by a.create_time,a.phone, a.email
        order by a.create_time desc