From b3ed26028083bbf66bb47601d11f42cad802b903 Mon Sep 17 00:00:00 2001 From: jiangqs <jiangqs> Date: 星期一, 03 七月 2023 19:21:37 +0800 Subject: [PATCH] 商户端会员统计 --- ruoyi-modules/ruoyi-member/src/main/java/com/ruoyi/member/mapper/member/MemberMapper.java | 81 ++++++++++++++++++++++++++++++++++++++-- 1 files changed, 76 insertions(+), 5 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 56b649e..b7fc156 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,10 +6,7 @@ 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.MgtMapIntTotalVo; import com.ruoyi.system.api.domain.vo.MgtPlTotalMemberTotalVo; @@ -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获取用户简易返回 @@ -212,6 +209,7 @@ List<Long> listUserIdByAge(@Param("param")MgtActivityAgeDto mgtActivityAgeDto); + /** * @description 会员人数统计 * @author jqs @@ -294,6 +292,79 @@ * @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); } -- Gitblit v1.7.1