From b3ed26028083bbf66bb47601d11f42cad802b903 Mon Sep 17 00:00:00 2001 From: jiangqs <jiangqs> Date: 星期一, 03 七月 2023 19:21:37 +0800 Subject: [PATCH] 商户端会员统计 --- ruoyi-modules/ruoyi-order/src/main/java/com/ruoyi/order/mapper/order/OrderMapper.java | 313 ++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 313 insertions(+), 0 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 0c0d230..fcad0f5 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,8 +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.*; +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 org.apache.ibatis.annotations.Param; +import java.math.BigDecimal; import java.util.List; /** @@ -125,4 +131,311 @@ * @return List<MgtShopOrderPageVo> */ List<MgtShopOrderPageVo> pageMgtShopOrder(Page page, @Param("param")MgtShopOrderPageDto mgtShopOrderPageDto); + + + /** + * @description boardOrderTotal + * @param + * @return MgtBulletinBoardVo + * @author jqs34 + * @date 2023/6/18 17:20 + */ + MgtBulletinBoardVo boardOrderTotal(); + + /** + * @description getTotalOrderTotalOrderFrom + * @param mgtBaseShopDto + * @return MgtTotalOrderTotalVo + * @author jqs34 + * @date 2023/6/19 22:24 + */ + MgtTotalOrderTotalVo getTotalOrderTotalOrderFrom(@Param("param") MgtBaseShopDto mgtBaseShopDto); + + /** + * @description getTotalOrderTotalGoodsType + * @param mgtBaseShopDto + * @return MgtTotalOrderTotalVo + * @author jqs34 + * @date 2023/6/19 22:24 + */ + MgtTotalOrderTotalVo getTotalOrderTotalGoodsType(@Param("param") MgtBaseShopDto mgtBaseShopDto); + + /** + * @description listTotalOrderTotal + * @param mgtBaseShopDto + * @return List<MgtMapIntTotalVo> + * @author jqs34 + * @date 2023/6/19 22:48 + */ + List<MgtMapTotalPlusVo> listTotalOrderTotal(@Param("param") MgtBaseShopDto mgtBaseShopDto); + + /** + * @description listTotalOrderTotalGoodsType + * @param mgtBaseShopDto + * @return List<MgtMapIntTotalVo> + * @author jqs34 + * @date 2023/6/19 22:48 + */ + List<MgtMapTotalPlusVo> listTotalOrderTotalGoodsType(@Param("param") MgtBaseShopDto mgtBaseShopDto); + + + /** + * @description listTotalOrderTotalGoodsRank + * @param mgtBaseShopDto + * @return List<MgtMapIntTotalVo> + * @author jqs34 + * @date 2023/6/19 22:48 + */ + List<MgtMapBigTotalVo> listTotalOrderTotalGoodsRank(@Param("param") MgtBaseShopDto mgtBaseShopDto); + + /** + * @description listTotalOrderTotalOrderFrom + * @param mgtBaseShopDto + * @return List<MgtMapIntTotalVo> + * @author jqs34 + * @date 2023/6/19 22:48 + */ + List<MgtMapBigTotalVo> listTotalOrderTotalOrderFrom(@Param("param") MgtBaseShopDto mgtBaseShopDto); + + + /** + * @description getTotalActivityTotal + * @author jqs + * @date 2023/6/20 9:28 + * @param mgtBaseShopDto + * @return MgtTotalActivityTotalVo + */ + MgtTotalActivityTotalVo getTotalActivityTotal(@Param("param")MgtBaseShopDto mgtBaseShopDto); + + + /** + * @description listTotalActivityTotalGoodsType + * @param mgtBaseShopDto + * @return List<MgtMapIntTotalVo> + * @author jqs34 + * @date 2023/6/19 22:48 + */ + List<MgtMapTotalPlusVo> listTotalActivityTotalGoodsType(@Param("param") MgtBaseShopDto mgtBaseShopDto); + + + /** + * @description listTotalActivityTotal + * @param mgtBaseShopDto + * @return List<MgtMapIntTotalVo> + * @author jqs34 + * @date 2023/6/19 22:48 + */ + List<MgtMapTotalPlusVo> listTotalActivityTotal(@Param("param") MgtBaseShopDto mgtBaseShopDto); + + /** + * @description + * @author jqs + * @date 2023/6/20 11:37 + * @param mgtActivityAgeDto + * @return List<Long> + */ + List<Long> getUserIdAgeRank(@Param("param") MgtActivityAgeDto mgtActivityAgeDto); + + /** + * @description + * @author jqs + * @date 2023/6/20 9:57 + * @param mgtActivityAgeDto + * @return MgtTotalActivityTotalVo + */ + List<MgtMapIntTotalVo> getTotalActivityAgeRank(@Param("param")MgtActivityAgeDto mgtActivityAgeDto); + + /** + * @description + * @author jqs + * @date 2023/6/20 15:50 + * @param mgtBaseShopDto + * @return MgtTotalDataTotalVo + */ + MgtTotalDataTotalVo getTotalDataTotal(@Param("param")MgtBaseShopDto mgtBaseShopDto); + + /** + * @description + * @author jqs + * @date 2023/6/20 18:16 + * @param + * @return Integer + */ + Integer getReorderPerson(@Param("param")MgtBaseShopDto mgtBaseShopDto); + + /** + * @description + * @author jqs + * @date 2023/6/20 18:16 + * @param + * @return Integer + */ + Integer getReturnedPerson(@Param("param")MgtBaseShopDto mgtBaseShopDto); + + /** + * @description + * @author jqs + * @date 2023/6/21 15:27 + * @param mgtBasePlatformDto + * @return List<MgtMapIntTotalVo> + */ + List<MgtMapIntTotalVo> listMemberGoodsRank(@Param("param")MgtBasePlatformDto mgtBasePlatformDto); + + + /** + * @description getTotalOrderTotalOrderFrom + * @param mgtBasePlatformDto + * @return MgtTotalOrderTotalVo + * @author jqs34 + * @date 2023/6/19 22:24 + */ + MgtTotalOrderTotalVo getPlTotalOrderTotalOrderFrom(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); + + /** + * @description getTotalOrderTotalGoodsType + * @param mgtBasePlatformDto + * @return MgtTotalOrderTotalVo + * @author jqs34 + * @date 2023/6/19 22:24 + */ + MgtTotalOrderTotalVo getPlTotalOrderTotalGoodsType(@Param("param")MgtBasePlatformDto mgtBasePlatformDto); + + /** + * @description listTotalOrderTotal + * @param mgtBasePlatformDto + * @return List<MgtMapIntTotalVo> + * @author jqs34 + * @date 2023/6/19 22:48 + */ + List<MgtMapTotalPlusVo> listPlTotalOrderTotal(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); + + /** + * @description listTotalOrderTotalGoodsType + * @param mgtBasePlatformDto + * @return List<MgtMapIntTotalVo> + * @author jqs34 + * @date 2023/6/19 22:48 + */ + List<MgtMapTotalPlusVo> listPlTotalOrderTotalGoodsType(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); + + + /** + * @description listTotalOrderTotalGoodsRank + * @param mgtBasePlatformDto + * @return List<MgtMapIntTotalVo> + * @author jqs34 + * @date 2023/6/19 22:48 + */ + List<MgtMapBigTotalVo> listPlTotalOrderTotalGoodsRank(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); + + /** + * @description listTotalOrderTotalOrderFrom + * @param mgtBasePlatformDto + * @return List<MgtMapIntTotalVo> + * @author jqs34 + * @date 2023/6/19 22:48 + */ + List<MgtMapBigTotalVo> listPlTotalOrderTotalOrderFrom(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); + + /** + * @description getTotalActivityTotal + * @author jqs + * @date 2023/6/20 9:28 + * @param mgtBasePlatformDto + * @return MgtTotalActivityTotalVo + */ + MgtPlTotalActivityTotalVo getPlTotalActivityTotal(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); + + + /** + * @description listTotalActivityTotalGoodsType + * @param mgtBasePlatformDto + * @return List<MgtMapIntTotalVo> + * @author jqs34 + * @date 2023/6/19 22:48 + */ + List<MgtMapTotalPlusVo> listPlTotalActivityTotalGoodsType(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); + + + /** + * @description listTotalActivityTotal + * @param mgtBasePlatformDto + * @return List<MgtMapIntTotalVo> + * @author jqs34 + * @date 2023/6/19 22:48 + */ + List<MgtMapTotalPlusVo> listPlTotalActivityTotal(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); + + /** + * @description + * @author jqs + * @date 2023/6/20 11:37 + * @param mgtActivityAgeDto + * @return List<Long> + */ + List<Long> getPlUserIdAgeRank(@Param("param") MgtPlActivityAgeDto mgtActivityAgeDto); + + /** + * @description + * @author jqs + * @date 2023/6/20 9:57 + * @param mgtActivityAgeDto + * @return MgtTotalActivityTotalVo + */ + List<MgtMapIntTotalVo> getPlTotalActivityAgeRank(@Param("param")MgtPlActivityAgeDto mgtActivityAgeDto); + + /** + * @description listPlTotalShopActivityRank + * @param mgtBasePlatformDto + * @return List<MgtMapIntTotalVo> + * @author jqs34 + * @date 2023/6/19 22:48 + */ + List<MgtMapBigTotalVo> listPlTotalShopActivityRank(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); + + /** + * @description listTotalActivityTotal + * @param mgtBasePlatformDto + * @return List<MgtMapIntTotalVo> + * @author jqs34 + * @date 2023/6/19 22:48 + */ + List<MgtMapBigTotalVo> listPlTotalShopActivitySalesRank(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); + + /** + * @description listTotalActivityTotal + * @param mgtBasePlatformDto + * @return List<MgtMapIntTotalVo> + * @author jqs34 + * @date 2023/6/19 22:48 + */ + List<MgtMapBigTotalVo> listPlTotalActivitySalesRank(@Param("param") MgtBasePlatformDto mgtBasePlatformDto); + + /** + * @description + * @author jqs + * @date 2023/6/25 17:28 + * @param shopId + * @return MerHomeShopTotalVo + */ + MerHomeShopTotalVo getMerHomeShopTotalVo(Long shopId); + + /** + * @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); } -- Gitblit v1.7.1