From 3adbcc42d5f84c3c83d220543189361add81e04d Mon Sep 17 00:00:00 2001 From: jiangqs <jiangqs> Date: 星期一, 11 九月 2023 15:22:19 +0800 Subject: [PATCH] bug --- ruoyi-modules/ruoyi-member/src/main/java/com/ruoyi/member/mapper/member/MemberMapper.java | 137 +++++++++++++++++++++++++++++++++++++++++++-- 1 files changed, 131 insertions(+), 6 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..d81beb3 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获取用户简易返回 @@ -114,7 +111,7 @@ * @param mgtUserIdByKeywordDto * @return MgtUserIdByKeywordVo */ - List<Long> getUserIdByKeyword(MgtUserIdByKeywordDto mgtUserIdByKeywordDto); + List<Long> getUserIdByKeyword(@Param("param")MgtUserIdByKeywordDto mgtUserIdByKeywordDto); /** * @description 总用户数 @@ -161,6 +158,15 @@ * @return MgtTotalMemberTotalVo */ List<MgtMapIntTotalVo> getTotalMemberTotalNurse(@Param("param") MgtBaseShopDto mgtBaseShopDto); + + /** + * @description 会员人数统计 + * @author jqs + * @date 2023/6/19 15:26 + * @param + * @return MgtTotalMemberTotalVo + */ + List<MgtMapIntTotalVo> getTotalMemberTotalLevel(@Param("param") MgtBaseShopDto mgtBaseShopDto); /** @@ -212,6 +218,7 @@ List<Long> listUserIdByAge(@Param("param")MgtActivityAgeDto mgtActivityAgeDto); + /** * @description 会员人数统计 * @author jqs @@ -238,6 +245,15 @@ * @return MgtTotalMemberTotalVo */ List<MgtMapIntTotalVo> getPlTotalMemberTotalNurse(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); + + /** + * @description 会员人数统计 + * @author jqs + * @date 2023/6/19 15:26 + * @param + * @return MgtTotalMemberTotalVo + */ + List<MgtMapIntTotalVo> getPlTotalMemberTotalLevel(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); /** * @description 会员人数统计 @@ -294,6 +310,115 @@ * @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> getMerMemberTotalLevel(@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 merTotalDto + * @return List<Long> + */ + List<Long> listOrderAgeUser(@Param("param") MerTotalDto merTotalDto); + + /** + * @description 统计商户今日新增会员 + * @author jqs + * @date 2023/7/14 19:54 + * @param shopIdList + * @return Integer + */ + Integer getAreaNewMember(@Param("shopIdList")List<Long> shopIdList); + + /** + * @description 获取今日生日用户电话 + * @author jqs + * @date 2023/8/7 16:13 + * @param + * @return List<String> + */ + List<String> listTodayBirthday(); } -- Gitblit v1.7.1