From cbc564a7088503ad8cc7af4e1d2ba417d061e615 Mon Sep 17 00:00:00 2001 From: jiangqs <jiangqs> Date: 星期五, 30 六月 2023 11:35:05 +0800 Subject: [PATCH] 联调bug和统计完善 --- ruoyi-modules/ruoyi-member/src/main/java/com/ruoyi/member/mapper/member/MemberMapper.java | 188 ++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 185 insertions(+), 3 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 eaa6253..56b649e 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 @@ -5,11 +5,14 @@ import com.ruoyi.member.domain.dto.MerCashMemberPageDto; import com.ruoyi.member.domain.dto.MerMemberPageDto; import com.ruoyi.member.domain.dto.MgtMemberPageDto; -import com.ruoyi.member.domain.vo.MerCashMemberPageVo; -import com.ruoyi.member.domain.vo.MerMemberPageVo; -import com.ruoyi.member.domain.vo.MgtMemberPageVo; +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.poji.member.Member; +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; @@ -112,6 +115,185 @@ * @return MgtUserIdByKeywordVo */ List<Long> getUserIdByKeyword(MgtUserIdByKeywordDto mgtUserIdByKeywordDto); + + /** + * @description 总用户数 + * @param + * @return Integer + * @author jqs34 + * @date 2023/6/18 16:46 + */ + Integer memberTotal(); + + /** + * @description 今日新增用户数 + * @param + * @return Integer + * @author jqs34 + * @date 2023/6/18 16:47 + */ + Integer memberToday(); + + + /** + * @description 会员人数统计 + * @author jqs + * @date 2023/6/19 15:26 + * @param + * @return MgtTotalMemberTotalVo + */ + MgtTotalMemberTotalVo getTotalMemberTotal(@Param("param") MgtBaseShopDto mgtBaseShopDto); + + /** + * @description 会员人数统计 + * @author jqs + * @date 2023/6/19 15:26 + * @param + * @return MgtTotalMemberTotalVo + */ + MgtAgeTotalVo getTotalMemberTotalAge(@Param("param") MgtBaseShopDto mgtBaseShopDto); + + /** + * @description 会员人数统计 + * @author jqs + * @date 2023/6/19 15:26 + * @param + * @return MgtTotalMemberTotalVo + */ + List<MgtMapIntTotalVo> getTotalMemberTotalNurse(@Param("param") MgtBaseShopDto mgtBaseShopDto); + + + /** + * @description 会员人数统计 + * @author jqs + * @date 2023/6/19 15:26 + * @param + * @return MgtTotalMemberTotalVo + */ + List<MgtMapIntTotalVo> getTotalMemberTotalGoodsType(@Param("param") MgtBaseShopDto mgtBaseShopDto); + + /** + * @description getTotalMemberTotalActiveness + * @param shopId + * @param actStartDate + * @param actEndDate + * @return Integer + * @author jqs34 + * @date 2023/6/19 21:24 + */ + Integer getTotalMemberTotalActiveness(@Param("shopId") Long shopId,@Param("actStartDate") String actStartDate,@Param("actEndDate") String actEndDate); + + /** + * @description 会员人数统计 + * @author jqs + * @date 2023/6/19 15:26 + * @param + * @return MgtTotalMemberTotalVo + */ + List<MgtMapIntTotalVo> getTotalMemberRankPay(@Param("param") MgtBaseShopDto mgtBaseShopDto); + + + /** + * @description 会员人数统计 + * @author jqs + * @date 2023/6/19 15:26 + * @param + * @return MgtTotalMemberTotalVo + */ + List<MgtMapIntTotalVo> getTotalMemberRankCustomerSource(@Param("param") MgtBaseShopDto mgtBaseShopDto); + + /** + * @description + * @author jqs + * @date 2023/6/20 11:49 + * @param mgtActivityAgeDto + * @return List<Long> + */ + List<Long> listUserIdByAge(@Param("param")MgtActivityAgeDto mgtActivityAgeDto); + + + /** + * @description 会员人数统计 + * @author jqs + * @date 2023/6/21 10:59 + * @param mgtBasePlatformDto + * @return MgtPlTotalMemberTotalVo + */ + MgtPlTotalMemberTotalVo getPlTotalMemberTotal(@Param("param")MgtBasePlatformDto mgtBasePlatformDto); + + /** + * @description 会员人数统计 + * @author jqs + * @date 2023/6/19 15:26 + * @param + * @return MgtTotalMemberTotalVo + */ + MgtAgeTotalVo getPlTotalMemberTotalAge(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); + + /** + * @description 会员人数统计 + * @author jqs + * @date 2023/6/19 15:26 + * @param + * @return MgtTotalMemberTotalVo + */ + List<MgtMapIntTotalVo> getPlTotalMemberTotalNurse(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); + + /** + * @description 会员人数统计 + * @author jqs + * @date 2023/6/19 15:26 + * @param + * @return MgtTotalMemberTotalVo + */ + List<MgtMapIntTotalVo> getPlTotalMemberTotalGoodsType(@Param("param")MgtBasePlatformDto mgtBasePlatformDto); + + /** + * @description getTotalMemberTotalActiveness + * @param shopIdList + * @param actStartDate + * @param actEndDate + * @return Integer + * @author jqs34 + * @date 2023/6/19 21:24 + */ + Integer getPlTotalMemberTotalActiveness(@Param("shopIdList") List<Long> shopIdList,@Param("actStartDate") String actStartDate,@Param("actEndDate") String actEndDate); + + /** + * @description 会员人数统计 + * @author jqs + * @date 2023/6/19 15:26 + * @param + * @return MgtTotalMemberTotalVo + */ + List<MgtMapIntTotalVo> getPlTotalMemberRankPay(@Param("param")MgtBasePlatformDto mgtBasePlatformDto); + + /** + * @description 会员人数统计 + * @author jqs + * @date 2023/6/19 15:26 + * @param + * @return MgtTotalMemberTotalVo + */ + List<MgtMapIntTotalVo> getPlTotalMemberRankCustomerSource(@Param("param")MgtBasePlatformDto mgtBasePlatformDto); + + /** + * @description + * @author jqs + * @date 2023/6/21 14:35 + * @param mgtBasePlatformDto + * @return List<MgtMapIntTotalVo> + */ + List<MgtMapIntTotalVo> getPlTotalMemberRank(@Param("param")MgtBasePlatformDto mgtBasePlatformDto); + + /** + * @description 通过shopId获取userId + * @author jqs + * @date 2023/6/21 17:11 + * @param shopIdList + * @return List<Long> + */ + List<Long> listUserIdByShopId(@Param("shopIdList")List<Long> shopIdList); } -- Gitblit v1.7.1