20200721 代码提交

xiaoyong931011

2020-07-21 5b2b6707557b5f0b2aaf790ac352eff22e9ec8da

20200721  代码提交

 src/main/java/com/xcong/excoin/modules/member/mapper/MemberMapper.java

@@ -92,6 +92,7 @@
    IPage<MemberEntity> findMemberAloneInPage(Page<MemberEntity> page, @Param("record") MemberEntity member);



    IPage<MemberDataInfoVo> selectMemberDataInfoDtoListInPageAlone(Page<MemberEntity> page, @Param("record") MemberEntity memberEntity);

    IPage<MemberDataInfoVo> selectMemberDataInfoDtoRealListInPageAlone(Page<MemberEntity> page, @Param("record") MemberEntity memberEntity);



    String selectTotalAmountUsdtBForBasicRealDataAlone();




 src/main/java/com/xcong/excoin/modules/member/service/impl/MemberServiceImpl.java

@@ -841,7 +841,7 @@
    public IPage<MemberDataInfoVo> findMemberDataInfoAloneDtoListInPage(MemberEntity memberEntity,
            QueryRequest request) {
        Page<MemberEntity> page = new Page<>(request.getPageNum(), request.getPageSize());
        IPage<MemberDataInfoVo> selectMemberListInPage = memberMapper.selectMemberDataInfoDtoListInPageAlone(page, memberEntity);
        IPage<MemberDataInfoVo> selectMemberListInPage = memberMapper.selectMemberDataInfoDtoRealListInPageAlone(page, memberEntity);
        //USDT充币总额+USDT提币总额
        String totalAmountUsdtB = memberMapper.selectTotalAmountUsdtBForBasicRealDataAlone();
        String totalAmountUsdtS = memberMapper.selectTotalAmountUsdtSForBasicRealDataAlone();

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

@@ -96,6 +96,10 @@
        select COUNT(m.id) as memberCount  from member m     WHERE (FIND_IN_SET('22015141', m.referer_ids) or m.id = 10)

    </select>

    

    <select id="selectMemberDataInfoDtoRealListInPageAlone" resultType="com.xcong.excoin.modules.member.vo.MemberDataInfoVo">

        select COUNT(m.id) as memberCount  from member m     WHERE (FIND_IN_SET('22015141', m.referer_ids) or m.id = 10) and m.account_type = 1

    </select>

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

        SELECT

            IFNULL(SUM(a.amount),'0')  as amount