From 3c99aaadfe74c8e86d115717e52672c494e30d81 Mon Sep 17 00:00:00 2001 From: KKSU <15274802129@163.com> Date: Mon, 05 Aug 2024 18:28:59 +0800 Subject: [PATCH] 后台 --- src/main/java/cc/mrbird/febs/mall/service/impl/AgentServiceImpl.java | 2 +- src/main/java/cc/mrbird/febs/mall/mapper/MallMemberMapper.java | 2 ++ src/main/resources/mapper/modules/MallMemberMapper.xml | 6 ++++++ 3 files changed, 9 insertions(+), 1 deletions(-) diff --git a/src/main/java/cc/mrbird/febs/mall/mapper/MallMemberMapper.java b/src/main/java/cc/mrbird/febs/mall/mapper/MallMemberMapper.java index f4b0d59..410ba03 100644 --- a/src/main/java/cc/mrbird/febs/mall/mapper/MallMemberMapper.java +++ b/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); diff --git a/src/main/java/cc/mrbird/febs/mall/service/impl/AgentServiceImpl.java b/src/main/java/cc/mrbird/febs/mall/service/impl/AgentServiceImpl.java index 7fb3294..ea00902 100644 --- a/src/main/java/cc/mrbird/febs/mall/service/impl/AgentServiceImpl.java +++ b/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; } diff --git a/src/main/resources/mapper/modules/MallMemberMapper.xml b/src/main/resources/mapper/modules/MallMemberMapper.xml index 334e474..1f3732d 100644 --- a/src/main/resources/mapper/modules/MallMemberMapper.xml +++ b/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} -- Gitblit v1.9.1