From 5b1a5025c72a80f58fe6bdbaf90eeaf487d71076 Mon Sep 17 00:00:00 2001
From: xiaoyong931011 <15274802129@163.com>
Date: Mon, 17 Apr 2023 16:35:08 +0800
Subject: [PATCH] 只针对一星会员做修改： 按购买业绩（不按权益积分）每天静态释0.6%~1.2%
---
src/main/java/cc/mrbird/febs/mall/mapper/MallMemberMapper.java | 31 +++++++++++++++++++++++++++++++
1 files changed, 31 insertions(+), 0 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 2a7731e..8318cac 100644
--- a/src/main/java/cc/mrbird/febs/mall/mapper/MallMemberMapper.java
+++ b/src/main/java/cc/mrbird/febs/mall/mapper/MallMemberMapper.java
@@ -72,4 +72,35 @@
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);
+
+ 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<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);
}
--
Gitblit v1.9.1