From f012423a2fac597b215a89c82f2fb627895580b5 Mon Sep 17 00:00:00 2001 From: KKSU <15274802129@163.com> Date: Mon, 20 May 2024 17:59:29 +0800 Subject: [PATCH] 会员等级升级 --- src/main/java/cc/mrbird/febs/mall/mapper/MallMemberMapper.java | 55 +++++++++++++++++++++++++++++++++++++++++++++++++++---- 1 files changed, 51 insertions(+), 4 deletions(-) diff --git a/src/main/java/cc/mrbird/febs/mall/mapper/MallMemberMapper.java b/src/main/java/cc/mrbird/febs/mall/mapper/MallMemberMapper.java index 4470b42..6fadd78 100644 --- a/src/main/java/cc/mrbird/febs/mall/mapper/MallMemberMapper.java +++ b/src/main/java/cc/mrbird/febs/mall/mapper/MallMemberMapper.java @@ -1,11 +1,10 @@ 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.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; @@ -22,6 +21,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); @@ -75,10 +76,56 @@ 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); } -- Gitblit v1.9.1