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.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.Date; import java.util.List; /** * @author wzy * @date 2021-09-16 **/ public interface MallMemberMapper extends BaseMapper { MallMember selectInfoByAccount(@Param("account") String account); IPage selectMallMemberListInPage(Page 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 selectTeamListByInviteId(@Param("inviteId") String inviteId); BigDecimal selectOwnOrderAmountByInviteId(@Param("inviteId") String inviteId); Integer selectOwnCntByInviteId(@Param("inviteId") String inviteId); Integer selectOwnOrderCntByInviteId(@Param("inviteId") String inviteId); List selectByRefererId(@Param("inviteId") String inviteId); List selectChildAgentList(@Param("inviteId") String inviteId, @Param("agentLevel") String agentLevel); List selectByInviteIds(@Param("list") List inviteIds); IPage getAgentListInPage(Page page, @Param("record")AgentDto agentDto); List selectChildAgentListByInviteId(@Param("inviteId")String inviteId); List selectAllChildAgentListByInviteId(@Param("inviteId")String inviteId); List selectMemberParentAgentList(@Param("list") List inviteIds, @Param("refererId") String refererId); IPage getAgentLevelListInPage(Page page, @Param("record")AgentLevelDto agentLevelDto); IPage getAgentChildInPage(Page page, @Param("record")MallMember mallMember); IPage getRankAwardListInPage(Page page, RankAwardDto rankAwardDto); BigDecimal getAgentTeamAmountByInviteId(@Param("inviteId")String inviteId); IPage getAppVersionListInPage(Page page, AppVersion appVersion); List selectByIdAndNoLevel(@Param("refererId") String refererId, @Param("level") String level); List selectMallMemberByInviteIdAndLevel(@Param("inviteId")String inviteId, @Param("level")String level); AdminAgentLevelSetInfoVo getAgentLevelSetInfoByMemberId(@Param("id")long id); IPage getMallDataListInPage(Page page, @Param("record")MallMember mallMember); IPage selectRankListInPage(IPage page, @Param("record") MallMember mallMember); BigDecimal selectAchieveByMemberId(@Param("inviteId") String inviteId, @Param("type") Integer type); List selectMemberByName(@Param("name") String name); // 查询有下级的用户 List selectMemberListHasChild(); List selectMemberDirectForHasLevel(@Param("inviteId") String inviteId); List selectDirectorsOrStoreMaster(@Param("type") Integer type); List selectMemberWithLevel(String level); MallMember selectMemberByOpenId(@Param("openId")String openId); IPage getsalemanRuleList(Page page, @Param("record")MallMember mallMember); void updateReferrerId(@Param("id")Long id); void updateLastLoginTime(@Param("id")Long id,@Param("lastLoginTime") Date lastLoginTime); }