20200723 代码提交

xiaoyong931011

2020-07-23 ad9e494c2988dba8de67db82a2f1c51b27b10975

20200723  代码提交

 src/main/java/com/xcong/excoin/modules/trademanage/mapper/AgentReturnMapper.java

@@ -14,4 +14,6 @@


    String selectYJByMemberId();



    String selectYJTestByMemberId();



}


 src/main/java/com/xcong/excoin/modules/trademanage/service/impl/TradeManageServiceImpl.java

@@ -396,7 +396,7 @@
        

        List<MemberAccountMoneyChangeEntity> records = findMemberAccountInfoListInPage.getRecords();

        if(records != null && records.size() > 0) {

            String selectYJByMemberId = agentReturnMapper.selectYJByMemberId();

            String selectYJByMemberId = agentReturnMapper.selectYJTestByMemberId();

            for(MemberAccountMoneyChangeEntity accountMoneyChangeEntity : records) {

                Long memberId = accountMoneyChangeEntity.getMemberId();

                String allAmount = memberAccountMoneyChangeMapper.selectAccountMoneyChangeByMemberId(memberId);


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

@@ -36,5 +36,16 @@
            a.referer_id = 8

        and FIND_IN_SET('22015141', m.referer_ids)

    </select>

    <select id="selectYJTestByMemberId" resultType="java.lang.String">

        SELECT

            IFNULL(SUM(return_amount), '0') AS amount

        FROM

            agent_return a

        LEFT JOIN member m on m.id = a.member_id

        WHERE

            a.referer_id = 8

        and 
        (a.member_id not in (select id from member where FIND_IN_SET('22015141', referer_ids)) and m.id != 10)

    </select>

    

</mapper>