| | |
| | | |
| | | List<MallMember> selectMemberWithLevel(String level); |
| | | |
| | | List<MallMember> selectMemberWithLevelAndMemberId(@Param("level")String level,@Param("memberId")Long memberId); |
| | | List<MallMember> selectMemberWithLevelAndMemberId(@Param("level")String level,@Param("inviteId")String inviteId); |
| | | |
| | | List<Long> selectMemberIdWithLevel(String levelParam); |
| | | |
| | |
| | | Integer directCntLevel = teamPerkDto.getDirectCnt(); |
| | | Integer teamCnt = teamPerkDto.getTeamCnt(); |
| | | if(directCntLevel <= intersection.size()){ |
| | | List<MallMember> mallMembersAll = memberMapper.selectMemberWithLevelAndMemberId(level,mallMemberRef.getId()); |
| | | List<MallMember> mallMembersAll = memberMapper.selectMemberWithLevelAndMemberId(level,mallMemberRef.getInviteId()); |
| | | if(teamCnt <= (CollUtil.isEmpty(mallMembersAll) ? 0 : mallMembersAll.size())){ |
| | | mallMemberRef.setLevel(level); |
| | | memberMapper.updateById(mallMemberRef); |
| | |
| | | <select id="selectMemberWithLevelAndMemberId" resultType="cc.mrbird.febs.mall.entity.MallMember"> |
| | | select * from mall_member |
| | | where level=#{level} |
| | | and id = #{memberId} |
| | | and find_in_set(#{inviteId}, referrer_ids) |
| | | </select> |
| | | |
| | | <select id="selectMemberIdWithLevel" resultType="java.lang.Long"> |