后台修改

xiaoyong931011

2023-08-29 eac9127fec0c66863b54a3801e093335d69a55b1

后台修改

 src/main/java/cc/mrbird/febs/dapp/mapper/DappMemberDao.java

@@ -78,6 +78,8 @@

    BigDecimal selectAllAchieveByInviteId(@Param("inviteId")String inviteId);

    BigDecimal selectAllAchieveByRefId(@Param("inviteId")String inviteId);

    List<DappMemberEntity> selectMemberByNotAccountType(@Param("accountType")String type);

    List<DappMemberEntity> selectByNodetype();

 src/main/java/cc/mrbird/febs/dapp/service/impl/DappMemberServiceImpl.java

@@ -229,7 +229,7 @@
                memberEntity.setMyShareAchieve(myShareAchieve);


                BigDecimal totalIncomeMember = dappMemberDao.selectAllAchieveByInviteId(memberEntity.getInviteId());
                BigDecimal totalIncomeMember = dappMemberDao.selectAllAchieveByRefId(memberEntity.getInviteId());
                memberEntity.setMyTeamAchieve(totalIncomeMember);

                BigDecimal withdrawAmount = memberCoinWithdrawDao.selectByMemberIdAndStatus(memberId, MemberCoinWithdrawEntity.STATUS_YES);

 src/main/resources/mapper/dapp/DappMemberDao.xml

@@ -246,6 +246,13 @@
        where find_in_set(#{inviteId}, b.referer_ids) or b.invite_id = #{inviteId}
    </select>

    <select id="selectAllAchieveByRefId" resultType="java.math.BigDecimal">
        select IFNULL(sum(IFNULL(a.amount, 0)),0)
        from mall_achieve_record a
        inner join dapp_member b on a.member_id = b.id
        where find_in_set(#{inviteId}, b.referer_ids)
    </select>

    <select id="selectMemberByNotAccountType" resultType="cc.mrbird.febs.dapp.entity.DappMemberEntity">
        select * from dapp_member
            where active_status = 1