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 | 125 +++++++++++++++++++++++++++++++++++++++++
1 files changed, 124 insertions(+), 1 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 da00ab7..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,8 +1,131 @@
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 class MallMemberMapper {
+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("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