20220902

xiaoyong931011

2022-09-24 ece2f207cb4ae03e76c32941d2bca42721a15f06

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

@@ -1,8 +1,90 @@
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.*;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.List;

/**
 * @author wzy
 * @date 2021-09-16
 **/
public class MallMemberMapper {
public interface MallMemberMapper extends BaseMapper<MallMember> {

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

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

    MallMember selectInfoByInviteId(@Param("inviteId") String inviteId);

    MallMember selectInfoByAccountAndPwd(@Param("account") String account, @Param("password") String password);

    MallMemberVo getMallMemberInfoById(@Param("id")long id);

    List<TeamListVo> selectTeamListByInviteId(@Param("inviteId") String inviteId);

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

    Integer selectOwnCntByInviteId(@Param("inviteId") String inviteId);

    Integer selectOwnOrderCntByInviteId(@Param("inviteId") String inviteId);

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

    List<MallMember> selectChildAgentList(@Param("inviteId") String inviteId, @Param("agentLevel") String agentLevel);

    List<MallMember> selectByInviteIds(@Param("list") List<String> inviteIds);

    IPage<AdminAgentVo> getAgentListInPage(Page<AdminAgentVo> page, @Param("record")AgentDto agentDto);

    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);

    MallMember selectMemberByOpenId(@Param("openId")String openId);
}