后台

KKSU

2024-08-05 3c99aaadfe74c8e86d115717e52672c494e30d81

后台

 src/main/java/cc/mrbird/febs/mall/mapper/MallMemberMapper.java

@@ -95,6 +95,8 @@

    List<MallMember> selectMemberWithLevelAndMemberId(@Param("level")String level,@Param("inviteId")String inviteId);

    List<MallMember> selectMemberWithLevelAndMemberIdNew(@Param("level")String level,@Param("inviteId")String inviteId);

    List<Long> selectMemberIdWithLevel(String levelParam);

    List<MallMember> selectAllChildAgentListByInviteIdAndStoreMaster(@Param("inviteId")String inviteId,@Param("state")Integer state);

 src/main/java/cc/mrbird/febs/mall/service/impl/AgentServiceImpl.java

@@ -2022,7 +2022,7 @@
                        String levelType = MemberLevelNewEnum.ZERO_LEVEL.getLevelType(levelCode - 1);
                        List<MallMember>  mallMembersDirects = memberMapper.selectByRefererId(mallMemberRef.getInviteId());
                        for(MallMember memberDirect : mallMembersDirects){
                            List<MallMember> mallMembers1 = memberMapper.selectMemberWithLevelAndMemberId(levelType, memberDirect.getInviteId());
                            List<MallMember> mallMembers1 = memberMapper.selectMemberWithLevelAndMemberIdNew(levelType, memberDirect.getInviteId());
                            if(CollUtil.isEmpty(mallMembers1)){
                                continue;
                            }

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

@@ -472,6 +472,12 @@
        and find_in_set(#{inviteId}, referrer_ids)
    </select>

    <select id="selectMemberWithLevelAndMemberIdNew" resultType="cc.mrbird.febs.mall.entity.MallMember">
        select * from mall_member
        where level=#{level}
          and (find_in_set(#{inviteId}, referrer_ids) or  invite_id = #{inviteId})
    </select>

    <select id="selectMemberIdWithLevel" resultType="java.lang.Long">
        select id from mall_member
        where level = #{level}