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.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;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.math.BigDecimal;
|
import java.util.List;
|
|
/**
|
* @author wzy
|
* @date 2021-09-16
|
**/
|
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);
|
|
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);
|
|
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("inviteId")String inviteId);
|
|
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);
|
|
List<MallMember> selectMemberWithLevelAndInviteId(@Param("levelType")String levelType,@Param("inviteId")String inviteId);
|
}
|
