From 8444084e6aa11efa23287e7f82474ac22378a5c4 Mon Sep 17 00:00:00 2001 From: Pu Zhibing <393733352@qq.com> Date: 星期二, 01 四月 2025 16:03:19 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- ruoyi-modules/ruoyi-order/src/main/java/com/ruoyi/order/mapper/order/OrderMapper.java | 296 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++-- 1 files changed, 285 insertions(+), 11 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 fcad0f5..74a124c 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; @@ -36,10 +37,10 @@ /** * 收银未结清订单列表 * @param page - * @param userId + * @param pageMerMemberNoClearOrder * @return */ - List<MerMemberNoClearOrderVo> pageMerMemberNoClearOrder(Page page, @Param("userId") Long userId); + List<MerMemberNoClearOrderVo> pageMerMemberNoClearOrder(Page page, @Param("param") MerMemberNoClearOrderDto pageMerMemberNoClearOrder); @@ -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 统计门店订单总数 @@ -140,7 +141,16 @@ * @author jqs34 * @date 2023/6/18 17:20 */ - MgtBulletinBoardVo boardOrderTotal(); + MgtBulletinBoardVo boardOrderTotal(@Param("shopIds") List<Long> shopIds); + + /** + * @description 活动人数统计 + * @author jqs + * @date 2023/8/3 21:12 + * @param + * @return Integer + */ + Integer activityUserTotal(@Param("shopIds") List<Long> shopIds); /** * @description getTotalOrderTotalOrderFrom @@ -150,6 +160,15 @@ * @date 2023/6/19 22:24 */ MgtTotalOrderTotalVo getTotalOrderTotalOrderFrom(@Param("param") MgtBaseShopDto mgtBaseShopDto); + + /** + * @description getTotalOrderTotalGoodsType + * @param merTotalDto + * @return MgtTotalOrderTotalVo + * @author jqs34 + * @date 2023/6/19 22:24 + */ + MerOrderTotalVo getMerTotalOrderTotalGoodsType(@Param("param") MerTotalDto merTotalDto); /** * @description getTotalOrderTotalGoodsType @@ -257,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 @@ -346,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 @@ -391,7 +437,7 @@ * @author jqs34 * @date 2023/6/19 22:48 */ - List<MgtMapBigTotalVo> listPlTotalShopActivityRank(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); + List<MgtMapIntTotalVo> listPlTotalShopActivityRank(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); /** * @description listTotalActivityTotal @@ -421,6 +467,25 @@ MerHomeShopTotalVo getMerHomeShopTotalVo(Long shopId); /** + * @description + * @author jqs + * @date 2023/6/25 17:28 + * @param shopId + * @return MerHomeShopTotalVo + */ + MerHomeShopTotalVo getMerHomeShopServiceTotalVo(Long shopId); + + + + /** + * @description + * @author cheny + * @param shopIds + * @return MerHomeShopTotalVo + */ + MerHomeShopTotalVo getMerHomeShopsTotalVo(List<Long> shopIds); + + /** * @description 统计商户营业额 * @author jqs * @date 2023/6/27 19:13 @@ -438,4 +503,213 @@ * @return BigDecimal */ BigDecimal getMemberUnpaidOrder(@Param("param")MerBaseDto merBaseDto); + + + /** + * @description getTotalOrderTotalOrderFrom + * @param merTotalDto + * @return MgtTotalOrderTotalVo + * @author jqs34 + * @date 2023/6/19 22:24 + */ + MerOrderTotalVo getMerOrderTotalOrderFrom(@Param("param")MerTotalDto merTotalDto); + + + /** + * @description 获取各年龄层统计 + * @author jqs + * @date 2023/7/4 10:27 + * @param merTotalDto + * @return MgtMapTotalPlusVo + */ + List<MgtMapTotalPlusVo> listMerOrderDistributionTotal(@Param("param")MerTotalDto merTotalDto); + + /** + * @description 商户获取销售占比统计 + * @param merTotalDto + * @return List<MgtMapIntTotalVo> + * @author jqs34 + * @date 2023/6/19 22:48 + */ + List<MgtMapTotalPlusVo> listMerOrderTotalGoodsType(@Param("param")MerTotalDto merTotalDto); + + /** + * @description 商户获取销售排名 + * @param merTotalDto + * @return List<MgtMapIntTotalVo> + * @author jqs34 + * @date 2023/6/19 22:48 + */ + List<MgtMapBigTotalVo> listMerOrderTotalGoodsRank(@Param("param")MerTotalDto merTotalDto); + + /** + * @description listTotalOrderTotalOrderFrom + * @param merTotalDto + * @return List<MgtMapIntTotalVo> + * @author jqs34 + * @date 2023/6/19 22:48 + */ + List<MgtMapBigTotalVo> listMerOrderTotalOrderFrom(@Param("param")MerTotalDto merTotalDto); + + /** + * @description 商户端订单管理统计 + * @author jqs + * @date 2023/7/4 16:27 + * @param merOrderPageDto + * @return MerTotalOrderVo + */ + MerTotalOrderVo totalMerOrder(@Param("param")MerOrderPageDto merOrderPageDto); + + + /** + * @description 平台获取商户订单记录 + * @author jqs + * @date 2023/7/5 20:17 + * @param page + * @param mgtShopAllOrderPageDto + * @return List<MgtShopAllOrderPageVo> + */ + List<MgtShopAllOrderPageVo> pageMgtShopAllOrder(Page page, @Param("param")MgtShopAllOrderPageDto mgtShopAllOrderPageDto); + + /** + * @description 统计用户活动参与次数 + * @author jqs + * @date 2023/7/13 18:27 + * @param userId + * @param activityId + * @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 goodsId + * @return Integer + */ + Integer countUserBuyGoodsNum(@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