From dbff53150cdc807faa56c0d1a947d24b69f372b9 Mon Sep 17 00:00:00 2001 From: jiangqs <jiangqs> Date: 星期四, 31 八月 2023 18:43:20 +0800 Subject: [PATCH] bug --- ruoyi-modules/ruoyi-order/src/main/java/com/ruoyi/order/mapper/order/OrderMapper.java | 205 ++++++++++++++++++++++++++++++++++++++++++++++++--- 1 files changed, 193 insertions(+), 12 deletions(-) diff --git a/ruoyi-modules/ruoyi-order/src/main/java/com/ruoyi/order/mapper/order/OrderMapper.java b/ruoyi-modules/ruoyi-order/src/main/java/com/ruoyi/order/mapper/order/OrderMapper.java index 55acdf9..331ec33 100644 --- a/ruoyi-modules/ruoyi-order/src/main/java/com/ruoyi/order/mapper/order/OrderMapper.java +++ b/ruoyi-modules/ruoyi-order/src/main/java/com/ruoyi/order/mapper/order/OrderMapper.java @@ -4,12 +4,13 @@ import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.ruoyi.order.domain.dto.*; import com.ruoyi.order.domain.pojo.order.Order; +import com.ruoyi.order.domain.vo.MerMemberNoClearOrderVo; +import com.ruoyi.order.domain.vo.MerOrderPageVo; +import com.ruoyi.order.domain.vo.MerOrderTotalVo; +import com.ruoyi.order.domain.vo.MerTotalOrderVo; import com.ruoyi.order.domain.vo.*; import com.ruoyi.system.api.domain.dto.*; -import com.ruoyi.system.api.domain.vo.MerHomeShopTotalVo; -import com.ruoyi.system.api.domain.vo.MgtBulletinBoardVo; -import com.ruoyi.system.api.domain.vo.MgtMapBigTotalVo; -import com.ruoyi.system.api.domain.vo.MgtMapIntTotalVo; +import com.ruoyi.system.api.domain.vo.*; import org.apache.ibatis.annotations.Param; import java.math.BigDecimal; @@ -39,7 +40,7 @@ * @param userId * @return */ - List<MerMemberNoClearOrderVo> pageMerMemberNoClearOrder(Page page, @Param("userId") Long userId); + List<MerMemberNoClearOrderVo> pageMerMemberNoClearOrder(Page page, @Param("userId") Long userId); @@ -48,7 +49,7 @@ * @param merOrderPageDto * @return */ - List<MerOrderPageVo> pageMerOrder(Page page,@Param("param") MerOrderPageDto merOrderPageDto); + List<MerOrderPageVo> pageMerOrder(Page page, @Param("param") MerOrderPageDto merOrderPageDto); /** @@ -57,7 +58,7 @@ * @param userId * @return */ - List<MerMemberNoClearOrderVo> pageMerMemberOrder(Page page, @Param("userId") Long userId); + List<MerMemberOrderVo> pageMerMemberOrder(Page page, @Param("userId") Long userId,@Param("shopId") Long shopId); /** * 获取用户订单统计 @@ -92,7 +93,7 @@ * @param * @return MgtOrderTotal */ - MgtOrderTotal totalOrderFirst(); + MgtOrderTotal totalOrderFirst(@Param("param")MgtShopOrderPageDto mgtShopOrderPageDto); /** * @description 统计门店订单总数 @@ -141,6 +142,15 @@ * @date 2023/6/18 17:20 */ MgtBulletinBoardVo boardOrderTotal(); + + /** + * @description 活动人数统计 + * @author jqs + * @date 2023/8/3 21:12 + * @param + * @return Integer + */ + Integer activityUserTotal(); /** * @description getTotalOrderTotalOrderFrom @@ -266,6 +276,15 @@ /** * @description * @author jqs + * @date 2023/6/20 15:50 + * @param mgtBaseShopDto + * @return MgtTotalDataTotalVo + */ + MgtTotalDataTotalVo getTotalDataMemberTotal(@Param("param")MgtBaseShopDto mgtBaseShopDto); + + /** + * @description + * @author jqs * @date 2023/6/20 18:16 * @param * @return Integer @@ -355,6 +374,24 @@ */ MgtPlTotalActivityTotalVo getPlTotalActivityTotal(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); + /** + * @description 活动获客人数 + * @author jqs + * @date 2023/8/26 16:07 + * @param mgtBasePlatformDto + * @return MgtPlTotalActivityTotalVo + */ + MgtPlTotalActivityTotalVo getPlTotalActivityMemberTotal(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); + + /** + * @description 活动获客人数 + * @author jqs + * @date 2023/8/26 16:07 + * @param mgtBaseShopDto + * @return getTotalActivityMemberTotal + */ + MgtTotalActivityTotalVo getTotalActivityMemberTotal(@Param("param") MgtBaseShopDto mgtBaseShopDto); + /** * @description listTotalActivityTotalGoodsType @@ -431,6 +468,17 @@ /** * @description + * @author jqs + * @date 2023/6/25 17:28 + * @param shopId + * @return MerHomeShopTotalVo + */ + MerHomeShopTotalVo getMerHomeShopServiceTotalVo(Long shopId); + + + + /** + * @description * @author cheny * @param shopIds * @return MerHomeShopTotalVo @@ -471,10 +519,10 @@ * @description 获取各年龄层统计 * @author jqs * @date 2023/7/4 10:27 - * @param userIdList + * @param merTotalDto * @return MgtMapTotalPlusVo */ - MgtMapTotalPlusVo listMerOrderDistributionTotal(@Param("userIdList")List<Long> userIdList); + List<MgtMapTotalPlusVo> listMerOrderDistributionTotal(@Param("param")MerTotalDto merTotalDto); /** * @description 商户获取销售占比统计 @@ -507,10 +555,10 @@ * @description 商户端订单管理统计 * @author jqs * @date 2023/7/4 16:27 - * @param shopId + * @param merOrderPageDto * @return MerTotalOrderVo */ - MerTotalOrderVo totalMerOrder(@Param("shopId")Long shopId); + MerTotalOrderVo totalMerOrder(@Param("param")MerOrderPageDto merOrderPageDto); /** @@ -532,4 +580,137 @@ * @return Integer */ Integer countUserActivityByActivity(@Param("userId")Long userId, @Param("activityId")String activityId); + + + /** + * @description 员工端活动订单统计 + * @author jqs + * @date 2023/7/17 15:25 + * @param staffTotalDto + * @return StaffActivityOrderTotalVo + */ + StaffActivityOrderTotalVo getStaffActivityOrderTotal(@Param("param")StaffTotalDto staffTotalDto); + + + /** + * @description 员工端活动订单统计 + * @author jqs + * @date 2023/7/17 15:25 + * @param staffTotalDto + * @return StaffActivityOrderTotalVo + */ + StaffActivityOrderTotalVo getStaffActivityOrderGoodsTotal(@Param("param")StaffTotalDto staffTotalDto); + + /** + * @description 员工端活动统计 + * @author jqs + * @date 2023/7/17 15:51 + * @param staffTotalDto + * @return StaffActivityTotalVo + */ + StaffActivityTotalVo getStaffActivityTotal(@Param("param")StaffTotalDto staffTotalDto); + + + /** + * @description 获取各年龄层统计 + * @author jqs + * @date 2023/7/4 10:27 + * @param staffTotalDto + * @return MgtMapTotalPlusVo + */ + List<MgtMapTotalPlusVo> listStaffActivityOrderDistributionTotal(@Param("param")StaffTotalDto staffTotalDto); + + + /** + * @description 员工端活动统计销售占比 + * @author jqs + * @date 2023/7/17 17:05 + * @param staffTotalDto + * @return List<MgtMapTotalPlusVo> + */ + List<MgtMapTotalPlusVo> listStaffOrderTotalGoodsType(@Param("param")StaffTotalDto staffTotalDto); + + + /** + * @description 员工端获取活动获客人数 + * @author jqs + * @date 2023/7/17 18:44 + * @param staffTotalDto + * @return List<MgtMapIntTotalVo> + */ + List<MgtMapIntTotalVo> getStaffActivityGetMemberTotal(@Param("param")StaffTotalDto staffTotalDto); + + + List<MgtMapIntTotalVo> getMgtActivityGetMemberTotal(@Param("param")MgtBasePlatformDto mgtBasePlatformDto); + + /** + * @description 员工端获取活动获客人数 + * @author jqs + * @date 2023/7/17 18:44 + * @param staffTotalDto + * @return List<MgtMapIntTotalVo> + */ + List<MgtMapIntTotalVo> getStaffActivityMemberTotal(@Param("param")StaffTotalDto staffTotalDto); + + + List<MgtMapIntTotalVo> getMgtActivityMemberTotal(@Param("param")MgtBasePlatformDto mgtBasePlatformDto); + + + List<MgtMapIntTotalVo> getActivityMemberTotal(@Param("param")MgtBaseShopDto mgtBaseShopDto); + + /** + * @description 获取用户商品购买数量 + * @author jqs + * @date 2023/7/23 18:17 + * @param userId + * @param goodsId + * @return Integer + */ + Integer countUserBuyGoodsNum(@Param("userId")Long userId, @Param("goodsId")String goodsId); + + + /** + * @description 获取商户订单统计 + * @author jqs + * @date 2023/8/4 10:25 + * @param mgtShopAllOrderPageDto + * @return MgtShopAllOrderTotal + */ + MgtShopAllOrderTotal getMgtShopAllOrderTotal(@Param("param")MgtShopAllOrderPageDto mgtShopAllOrderPageDto); + + + /** + * 分页获取消费记录 + * @param merOrderPageDto + * @return + */ + List<MerOrderPageVo> pageMerMemberPayOrder(Page page,@Param("param") MerMemberNoClearOrderDto merOrderPageDto); + + /** + * @description 获取销售排行 + * @author jqs + * @date 2023/8/24 18:00 + * @param shopIdList + * @return List<MgtMapIntTotalVo> + */ + List<MgtMapBigTotalVo> shopSalesRank(@Param("shopIdList")List<Long> shopIdList); + + /** + * @description 获取区域统计 + * @author jqs + * @date 2023/8/25 11:49 + * @param shopIdList + * @return AgencyTotalVo + */ + AgencyTotalVo getAgencyTotalVo(@Param("shopIdList")List<Long> shopIdList); + + + /** + * @description 商户端会员订单统计 + * @author jqs + * @date 2023/8/29 17:39 + * @param merBaseDto + * @return MerMemberSimpleTotalVo + */ + MerMemberSimpleTotalVo getMerMemberSimpleTotalVo(@Param("param") MerBaseDto merBaseDto); } -- Gitblit v1.7.1