From f975b6d0832b447654aaf2372ce72f71ebb7f095 Mon Sep 17 00:00:00 2001 From: chenye <chenye0811@qq.com> Date: 星期二, 11 七月 2023 11:11:55 +0800 Subject: [PATCH] 1 --- ruoyi-modules/ruoyi-order/src/main/java/com/ruoyi/order/mapper/order/OrderMapper.java | 166 +++++++++++++++++++++++++++++++++++++++++++++---------- 1 files changed, 135 insertions(+), 31 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 5892db8..5b5a7f4 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 @@ -5,15 +5,14 @@ import com.ruoyi.order.domain.dto.*; import com.ruoyi.order.domain.pojo.order.Order; import com.ruoyi.order.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.MgtPlActivityAgeDto; +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.MgtMapTotalVo; +import com.ruoyi.system.api.domain.vo.MgtMapBigTotalVo; +import com.ruoyi.system.api.domain.vo.MgtMapIntTotalVo; import org.apache.ibatis.annotations.Param; +import java.math.BigDecimal; import java.util.List; /** @@ -154,6 +153,15 @@ /** * @description getTotalOrderTotalGoodsType + * @param merTotalDto + * @return MgtTotalOrderTotalVo + * @author jqs34 + * @date 2023/6/19 22:24 + */ + MerOrderTotalVo getMerTotalOrderTotalGoodsType(@Param("param") MerTotalDto merTotalDto); + + /** + * @description getTotalOrderTotalGoodsType * @param mgtBaseShopDto * @return MgtTotalOrderTotalVo * @author jqs34 @@ -164,7 +172,7 @@ /** * @description listTotalOrderTotal * @param mgtBaseShopDto - * @return List<MgtMapTotalVo> + * @return List<MgtMapIntTotalVo> * @author jqs34 * @date 2023/6/19 22:48 */ @@ -173,7 +181,7 @@ /** * @description listTotalOrderTotalGoodsType * @param mgtBaseShopDto - * @return List<MgtMapTotalVo> + * @return List<MgtMapIntTotalVo> * @author jqs34 * @date 2023/6/19 22:48 */ @@ -183,20 +191,20 @@ /** * @description listTotalOrderTotalGoodsRank * @param mgtBaseShopDto - * @return List<MgtMapTotalVo> + * @return List<MgtMapIntTotalVo> * @author jqs34 * @date 2023/6/19 22:48 */ - List<MgtMapTotalPlusVo> listTotalOrderTotalGoodsRank(@Param("param") MgtBaseShopDto mgtBaseShopDto); + List<MgtMapBigTotalVo> listTotalOrderTotalGoodsRank(@Param("param") MgtBaseShopDto mgtBaseShopDto); /** * @description listTotalOrderTotalOrderFrom * @param mgtBaseShopDto - * @return List<MgtMapTotalVo> + * @return List<MgtMapIntTotalVo> * @author jqs34 * @date 2023/6/19 22:48 */ - List<MgtMapTotalPlusVo> listTotalOrderTotalOrderFrom(@Param("param") MgtBaseShopDto mgtBaseShopDto); + List<MgtMapBigTotalVo> listTotalOrderTotalOrderFrom(@Param("param") MgtBaseShopDto mgtBaseShopDto); /** @@ -212,7 +220,7 @@ /** * @description listTotalActivityTotalGoodsType * @param mgtBaseShopDto - * @return List<MgtMapTotalVo> + * @return List<MgtMapIntTotalVo> * @author jqs34 * @date 2023/6/19 22:48 */ @@ -222,7 +230,7 @@ /** * @description listTotalActivityTotal * @param mgtBaseShopDto - * @return List<MgtMapTotalVo> + * @return List<MgtMapIntTotalVo> * @author jqs34 * @date 2023/6/19 22:48 */ @@ -244,7 +252,7 @@ * @param mgtActivityAgeDto * @return MgtTotalActivityTotalVo */ - MgtTotalActivityTotalVo getTotalActivityAgeRank(@Param("param")MgtActivityAgeDto mgtActivityAgeDto); + List<MgtMapIntTotalVo> getTotalActivityAgeRank(@Param("param")MgtActivityAgeDto mgtActivityAgeDto); /** * @description @@ -278,9 +286,9 @@ * @author jqs * @date 2023/6/21 15:27 * @param mgtBasePlatformDto - * @return List<MgtMapTotalVo> + * @return List<MgtMapIntTotalVo> */ - List<MgtMapTotalVo> listMemberGoodsRank(@Param("param")MgtBasePlatformDto mgtBasePlatformDto); + List<MgtMapIntTotalVo> listMemberGoodsRank(@Param("param")MgtBasePlatformDto mgtBasePlatformDto); /** @@ -304,7 +312,7 @@ /** * @description listTotalOrderTotal * @param mgtBasePlatformDto - * @return List<MgtMapTotalVo> + * @return List<MgtMapIntTotalVo> * @author jqs34 * @date 2023/6/19 22:48 */ @@ -313,7 +321,7 @@ /** * @description listTotalOrderTotalGoodsType * @param mgtBasePlatformDto - * @return List<MgtMapTotalVo> + * @return List<MgtMapIntTotalVo> * @author jqs34 * @date 2023/6/19 22:48 */ @@ -323,20 +331,20 @@ /** * @description listTotalOrderTotalGoodsRank * @param mgtBasePlatformDto - * @return List<MgtMapTotalVo> + * @return List<MgtMapIntTotalVo> * @author jqs34 * @date 2023/6/19 22:48 */ - List<MgtMapTotalPlusVo> listPlTotalOrderTotalGoodsRank(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); + List<MgtMapBigTotalVo> listPlTotalOrderTotalGoodsRank(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); /** * @description listTotalOrderTotalOrderFrom * @param mgtBasePlatformDto - * @return List<MgtMapTotalVo> + * @return List<MgtMapIntTotalVo> * @author jqs34 * @date 2023/6/19 22:48 */ - List<MgtMapTotalPlusVo> listPlTotalOrderTotalOrderFrom(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); + List<MgtMapBigTotalVo> listPlTotalOrderTotalOrderFrom(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); /** * @description getTotalActivityTotal @@ -351,7 +359,7 @@ /** * @description listTotalActivityTotalGoodsType * @param mgtBasePlatformDto - * @return List<MgtMapTotalVo> + * @return List<MgtMapIntTotalVo> * @author jqs34 * @date 2023/6/19 22:48 */ @@ -361,7 +369,7 @@ /** * @description listTotalActivityTotal * @param mgtBasePlatformDto - * @return List<MgtMapTotalVo> + * @return List<MgtMapIntTotalVo> * @author jqs34 * @date 2023/6/19 22:48 */ @@ -383,34 +391,34 @@ * @param mgtActivityAgeDto * @return MgtTotalActivityTotalVo */ - MgtPlTotalActivityTotalVo getPlTotalActivityAgeRank(@Param("param")MgtPlActivityAgeDto mgtActivityAgeDto); + List<MgtMapIntTotalVo> getPlTotalActivityAgeRank(@Param("param")MgtPlActivityAgeDto mgtActivityAgeDto); /** * @description listPlTotalShopActivityRank * @param mgtBasePlatformDto - * @return List<MgtMapTotalVo> + * @return List<MgtMapIntTotalVo> * @author jqs34 * @date 2023/6/19 22:48 */ - List<MgtMapTotalPlusVo> listPlTotalShopActivityRank(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); + List<MgtMapBigTotalVo> listPlTotalShopActivityRank(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); /** * @description listTotalActivityTotal * @param mgtBasePlatformDto - * @return List<MgtMapTotalVo> + * @return List<MgtMapIntTotalVo> * @author jqs34 * @date 2023/6/19 22:48 */ - List<MgtMapTotalPlusVo> listPlTotalShopActivitySalesRank(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); + List<MgtMapBigTotalVo> listPlTotalShopActivitySalesRank(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); /** * @description listTotalActivityTotal * @param mgtBasePlatformDto - * @return List<MgtMapTotalVo> + * @return List<MgtMapIntTotalVo> * @author jqs34 * @date 2023/6/19 22:48 */ - List<MgtMapTotalPlusVo> listPlTotalActivitySalesRank(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); + List<MgtMapBigTotalVo> listPlTotalActivitySalesRank(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); /** * @description @@ -420,4 +428,100 @@ * @return MerHomeShopTotalVo */ MerHomeShopTotalVo getMerHomeShopTotalVo(Long shopId); + + /** + * @description + * @author cheny + * @param shopIds + * @return MerHomeShopTotalVo + */ + MerHomeShopTotalVo getMerHomeShopsTotalVo(List<Long> shopIds); + + /** + * @description 统计商户营业额 + * @author jqs + * @date 2023/6/27 19:13 + * @param mgtBaseShopDto + * @return BigDecimal + */ + BigDecimal shopSalesTotal(@Param("param")MgtBaseShopDto mgtBaseShopDto); + + + /** + * @description 获取用户未支付金额 + * @author jqs + * @date 2023/6/29 18:00 + * @param merBaseDto + * @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 userIdList + * @return MgtMapTotalPlusVo + */ + MgtMapTotalPlusVo listMerOrderDistributionTotal(@Param("userIdList")List<Long> userIdList); + + /** + * @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 shopId + * @return MerTotalOrderVo + */ + MerTotalOrderVo totalMerOrder(@Param("shopId")Long shopId); + + + /** + * @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); + + } -- Gitblit v1.7.1