From f975b6d0832b447654aaf2372ce72f71ebb7f095 Mon Sep 17 00:00:00 2001
From: chenye <chenye0811@qq.com>
Date: 星期二, 11 七月 2023 11:11:55 +0800
Subject: [PATCH] 1
---
ruoyi-modules/ruoyi-member/src/main/java/com/ruoyi/member/mapper/member/MemberMapper.java | 112 ++++++++++++++++++++++++++++++++++++++++++++++++--------
1 files changed, 96 insertions(+), 16 deletions(-)
diff --git a/ruoyi-modules/ruoyi-member/src/main/java/com/ruoyi/member/mapper/member/MemberMapper.java b/ruoyi-modules/ruoyi-member/src/main/java/com/ruoyi/member/mapper/member/MemberMapper.java
index f109c1c..181ff9b 100644
--- a/ruoyi-modules/ruoyi-member/src/main/java/com/ruoyi/member/mapper/member/MemberMapper.java
+++ b/ruoyi-modules/ruoyi-member/src/main/java/com/ruoyi/member/mapper/member/MemberMapper.java
@@ -6,12 +6,9 @@
import com.ruoyi.member.domain.dto.MerMemberPageDto;
import com.ruoyi.member.domain.dto.MgtMemberPageDto;
import com.ruoyi.member.domain.vo.*;
-import com.ruoyi.system.api.domain.dto.MgtActivityAgeDto;
-import com.ruoyi.system.api.domain.dto.MgtBasePlatformDto;
-import com.ruoyi.system.api.domain.dto.MgtBaseShopDto;
-import com.ruoyi.system.api.domain.dto.MgtUserIdByKeywordDto;
+import com.ruoyi.system.api.domain.dto.*;
import com.ruoyi.system.api.domain.poji.member.Member;
-import com.ruoyi.system.api.domain.vo.MgtMapTotalVo;
+import com.ruoyi.system.api.domain.vo.MgtMapIntTotalVo;
import com.ruoyi.system.api.domain.vo.MgtPlTotalMemberTotalVo;
import com.ruoyi.system.api.domain.vo.MgtSimpleMemberVo;
import org.apache.ibatis.annotations.Param;
@@ -96,7 +93,7 @@
* @param sendType
* @return List<Long>
*/
- List<Long> listIdBySendType(@Param("sendType")Integer sendType);
+ List<Long> listIdBySendType(@Param("sendType")Integer sendType,@Param("shopId")Long shopId);
/**
* @description 通过ids获取用户简易返回
@@ -160,7 +157,7 @@
* @param
* @return MgtTotalMemberTotalVo
*/
- List<MgtMapTotalVo> getTotalMemberTotalNurse(@Param("param") MgtBaseShopDto mgtBaseShopDto);
+ List<MgtMapIntTotalVo> getTotalMemberTotalNurse(@Param("param") MgtBaseShopDto mgtBaseShopDto);
/**
@@ -170,7 +167,7 @@
* @param
* @return MgtTotalMemberTotalVo
*/
- List<MgtMapTotalVo> getTotalMemberTotalGoodsType(@Param("param") MgtBaseShopDto mgtBaseShopDto);
+ List<MgtMapIntTotalVo> getTotalMemberTotalGoodsType(@Param("param") MgtBaseShopDto mgtBaseShopDto);
/**
* @description getTotalMemberTotalActiveness
@@ -190,7 +187,7 @@
* @param
* @return MgtTotalMemberTotalVo
*/
- List<MgtMapTotalVo> getTotalMemberRankPay(@Param("param") MgtBaseShopDto mgtBaseShopDto);
+ List<MgtMapIntTotalVo> getTotalMemberRankPay(@Param("param") MgtBaseShopDto mgtBaseShopDto);
/**
@@ -200,7 +197,7 @@
* @param
* @return MgtTotalMemberTotalVo
*/
- List<MgtMapTotalVo> getTotalMemberRankCustomerSource(@Param("param") MgtBaseShopDto mgtBaseShopDto);
+ List<MgtMapIntTotalVo> getTotalMemberRankCustomerSource(@Param("param") MgtBaseShopDto mgtBaseShopDto);
/**
* @description
@@ -210,6 +207,7 @@
* @return List<Long>
*/
List<Long> listUserIdByAge(@Param("param")MgtActivityAgeDto mgtActivityAgeDto);
+
/**
@@ -237,7 +235,7 @@
* @param
* @return MgtTotalMemberTotalVo
*/
- List<MgtMapTotalVo> getPlTotalMemberTotalNurse(@Param("param") MgtBasePlatformDto mgtBasePlatformDto);
+ List<MgtMapIntTotalVo> getPlTotalMemberTotalNurse(@Param("param") MgtBasePlatformDto mgtBasePlatformDto);
/**
* @description 会员人数统计
@@ -246,7 +244,7 @@
* @param
* @return MgtTotalMemberTotalVo
*/
- List<MgtMapTotalVo> getPlTotalMemberTotalGoodsType(@Param("param")MgtBasePlatformDto mgtBasePlatformDto);
+ List<MgtMapIntTotalVo> getPlTotalMemberTotalGoodsType(@Param("param")MgtBasePlatformDto mgtBasePlatformDto);
/**
* @description getTotalMemberTotalActiveness
@@ -266,7 +264,7 @@
* @param
* @return MgtTotalMemberTotalVo
*/
- List<MgtMapTotalVo> getPlTotalMemberRankPay(@Param("param")MgtBasePlatformDto mgtBasePlatformDto);
+ List<MgtMapIntTotalVo> getPlTotalMemberRankPay(@Param("param")MgtBasePlatformDto mgtBasePlatformDto);
/**
* @description 会员人数统计
@@ -275,16 +273,16 @@
* @param
* @return MgtTotalMemberTotalVo
*/
- List<MgtMapTotalVo> getPlTotalMemberRankCustomerSource(@Param("param")MgtBasePlatformDto mgtBasePlatformDto);
+ List<MgtMapIntTotalVo> getPlTotalMemberRankCustomerSource(@Param("param")MgtBasePlatformDto mgtBasePlatformDto);
/**
* @description
* @author jqs
* @date 2023/6/21 14:35
* @param mgtBasePlatformDto
- * @return List<MgtMapTotalVo>
+ * @return List<MgtMapIntTotalVo>
*/
- List<MgtMapTotalVo> getPlTotalMemberRank(@Param("param")MgtBasePlatformDto mgtBasePlatformDto);
+ List<MgtMapIntTotalVo> getPlTotalMemberRank(@Param("param")MgtBasePlatformDto mgtBasePlatformDto);
/**
* @description 通过shopId获取userId
@@ -294,6 +292,88 @@
* @return List<Long>
*/
List<Long> listUserIdByShopId(@Param("shopIdList")List<Long> shopIdList);
+
+ /**
+ * @description
+ * @author jqs
+ * @date 2023/7/3 18:29
+ * @param merTotalDto
+ * @return MerMemberTotalVo
+ */
+ MerMemberTotalVo getMerMemberTotal(@Param("param")MerTotalDto merTotalDto);
+
+
+ /**
+ * @description 会员年龄分布统计
+ * @author jqs
+ * @date 2023/6/19 15:26
+ * @param
+ * @return MgtTotalMemberTotalVo
+ */
+ MgtAgeTotalVo getMerMemberTotalAge(@Param("param") MerTotalDto merTotalDto);
+
+ /**
+ * @description 会员调理问题人数统计
+ * @author jqs
+ * @date 2023/6/19 15:26
+ * @param
+ * @return MgtTotalMemberTotalVo
+ */
+ List<MgtMapIntTotalVo> getMerMemberTotalNurse(@Param("param") MerTotalDto merTotalDto);
+
+ /**
+ * @description 会员商品类型人数统计
+ * @author jqs
+ * @date 2023/6/19 15:26
+ * @param
+ * @return MgtTotalMemberTotalVo
+ */
+ List<MgtMapIntTotalVo> getMerMemberTotalGoodsType(@Param("param") MerTotalDto merTotalDto);
+
+ /**
+ * @description 会员活跃度统计
+ * @param merTotalDto
+ * @return Integer
+ * @author jqs34
+ * @date 2023/6/19 21:24
+ */
+ Integer getMerMemberTotalActiveness(@Param("param") MerTotalDto merTotalDto);
+
+ /**
+ * @description 会员消费次数排名
+ * @author jqs
+ * @date 2023/6/19 15:26
+ * @param
+ * @return MgtTotalMemberTotalVo
+ */
+ List<MgtMapIntTotalVo> getMerMemberPayRank(@Param("param") MerTotalDto merTotalDto);
+
+ /**
+ * @description 会员来源排名计
+ * @author jqs
+ * @date 2023/6/19 15:26
+ * @param
+ * @return MgtTotalMemberTotalVo
+ */
+ List<MgtMapIntTotalVo> getMerMemberCustomerSourceRank(@Param("param") MerTotalDto merTotalDto);
+
+ /**
+ * @description 会员推荐排名
+ * @author jqs
+ * @date 2023/7/3 19:16
+ * @param merTotalDto
+ * @return List<MgtMapIntTotalVo>
+ */
+ List<MgtMapIntTotalVo> getMerMemberRecommendRank(@Param("param") MerTotalDto merTotalDto);
+
+ /**
+ * @description 获取各年龄层用户
+ * @author jqs
+ * @date 2023/7/4 9:55
+ * @param ageType
+ * @return List<Long>
+ */
+ List<Long> listOrderAgeUser(@Param("param") MerTotalDto merTotalDto);
}
--
Gitblit v1.7.1