匹配

KKSU

2023-11-28 93ed0466abb1a825705d8a92eded1879b329c623

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

@@ -1,10 +1,12 @@
package cc.mrbird.febs.mall.mapper;

import cc.mrbird.febs.mall.dto.AgentDto;
import cc.mrbird.febs.mall.dto.AgentLevelDto;
import cc.mrbird.febs.mall.dto.RankAwardDto;
import cc.mrbird.febs.mall.dto.RankListDto;
import cc.mrbird.febs.mall.entity.AppVersion;
import cc.mrbird.febs.mall.entity.MallMember;
import cc.mrbird.febs.mall.vo.AdminAgentVo;
import cc.mrbird.febs.mall.vo.MallMemberVo;
import cc.mrbird.febs.mall.vo.TeamListVo;
import cc.mrbird.febs.mall.vo.*;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
@@ -20,6 +22,8 @@
public interface MallMemberMapper extends BaseMapper<MallMember> {

    MallMember selectInfoByAccount(@Param("account") String account);

    MallMember selectInfoByAccountNew(@Param("account") String account,@Param("phone") String phone);

    IPage<MallMember> selectMallMemberListInPage(Page<MallMember> page, @Param("record")MallMember mallMember);

@@ -48,4 +52,69 @@
    List<MallMember> selectChildAgentListByInviteId(@Param("inviteId")String inviteId);

    List<MallMember> selectAllChildAgentListByInviteId(@Param("inviteId")String inviteId);

    List<MallMember> selectMemberParentAgentList(@Param("list") List<String> inviteIds, @Param("refererId") String refererId);

    IPage<AdminAgentLevelVo> getAgentLevelListInPage(Page<AdminAgentLevelVo> page, @Param("record")AgentLevelDto agentLevelDto);

    IPage<AdminAgentMemberVo> getAgentChildInPage(Page<AdminAgentMemberVo> page, @Param("record")MallMember mallMember);

    IPage<AdminRankAwardVo> getRankAwardListInPage(Page<AdminRankAwardVo> page, RankAwardDto rankAwardDto);

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

    IPage<AppVersion> getAppVersionListInPage(Page<AppVersion> page, AppVersion appVersion);

    List<MallMember> selectByIdAndNoLevel(@Param("refererId") String refererId, @Param("level") String level);

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

    AdminAgentLevelSetInfoVo getAgentLevelSetInfoByMemberId(@Param("id")long id);

    IPage<MallDataVo> getMallDataListInPage(Page<MallDataVo> page,  @Param("record")MallMember mallMember);

    IPage<MallMember> selectRankListInPage(IPage<MallMember> page, @Param("record") MallMember mallMember);

    BigDecimal selectAchieveByMemberId(@Param("inviteId") String inviteId, @Param("type") Integer type);

    List<MallMember> selectMemberByName(@Param("name") String name);

    // 查询有下级的用户
    List<MallMember> selectMemberListHasChild();

    List<MallMember> selectMemberDirectForHasLevel(@Param("inviteId") String inviteId);

    List<MallMember> selectDirectorsOrStoreMaster(@Param("type") Integer type);

    List<MallMember> selectMemberWithLevel(String level);

    List<Long> selectMemberIdWithLevel(String levelParam);

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

    List<MallMember> selectMemberByDirector(@Param("state")Integer state);

    List<MallMember> selectMemberByStoreMaster(@Param("state")Integer state);

    /**
     * 根据type查询对应的角色的集合
     * @param type 3：联创 4：合伙人
     * @param state 1：是 2：否
     * @return
     */
    List<MallMember> selectByRole(@Param("type") int type, @Param("state")int state);

    List<MallMember> selectByLevel( @Param("level")String type);

    MallMember selectByAccountLogin(@Param("accountLogin")String accountLogin);

    MallMember selectInfoByAccountLoginAndPwd(@Param("accountLogin")String account, @Param("password")String md5Pwd);

    MallMember selectByUserKey(@Param("userKey")String userKey);

    MallMember selectAccountLoginAndUserKey(@Param("accountLogin")String accountLogin, @Param("userKey")String userKey);

    IPage<AdminMallMemberVo> getFcmMallMemberList(Page<AdminMallMemberVo> page,  @Param("record")MallMember mallMember);

    MallMemberVo getMallmemberAmountByMemberId(@Param("memberId")long id);
}