会员等级升级

KKSU

2024-05-20 f012423a2fac597b215a89c82f2fb627895580b5

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

@@ -1,8 +1,11 @@
package cc.mrbird.febs.mall.mapper;

import cc.mrbird.febs.mall.dto.*;
import cc.mrbird.febs.mall.entity.AppVersion;
import cc.mrbird.febs.mall.entity.MallMember;
import cc.mrbird.febs.mall.vo.MallMemberVo;
import cc.mrbird.febs.mall.vo.TeamListVo;
import cc.mrbird.febs.mall.entity.MallMemberCharge;
import cc.mrbird.febs.mall.entity.MallMemberWithdraw;
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;
@@ -19,6 +22,8 @@

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

    MallMember selectInfoByInviteId(@Param("inviteId") String inviteId);
@@ -29,7 +34,98 @@

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

    BigDecimal selectOwnAmountByInviteId(@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);

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

    Integer selectAchieveBuyOrderCntByMemberId(@Param("inviteId") String inviteId);
    Integer selectAchieveSellOrderCntByMemberId(@Param("inviteId") String inviteId);

    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<MallMember> selectMemberWithLevelAndMemberId(@Param("level")String level,@Param("memberId")Long memberId);

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

    IPage<MallMemberCharge> getMemberChargeListInPage(Page<MallMemberCharge> page,  @Param("record")MoneyChargeListDto moneyChargeListDto);

    IPage<MallMemberWithdraw> getMemberWithDrawListInPage(Page<MallMemberWithdraw> page, @Param("record")MoneyChargeListDto moneyChargeListDto);
}