From f52dec1307fded163c1011a948c430072779fad9 Mon Sep 17 00:00:00 2001 From: xiaoyong931011 <15274802129@163.com> Date: Wed, 10 Aug 2022 15:14:47 +0800 Subject: [PATCH] 20220810 --- src/main/java/cc/mrbird/febs/mall/mapper/MallOrderInfoMapper.java | 3 +++ src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallTeamLeaderServiceImpl.java | 19 +++++++++++++++++++ src/main/java/cc/mrbird/febs/mall/controller/ApiMallTeamLeaderController.java | 6 ++++++ src/main/resources/mapper/modules/MallOrderInfoMapper.xml | 9 +++++++++ src/main/java/cc/mrbird/febs/mall/service/IApiMallTeamLeaderService.java | 2 ++ 5 files changed, 39 insertions(+), 0 deletions(-) diff --git a/src/main/java/cc/mrbird/febs/mall/controller/ApiMallTeamLeaderController.java b/src/main/java/cc/mrbird/febs/mall/controller/ApiMallTeamLeaderController.java index d1a84d3..bb1ddd1 100644 --- a/src/main/java/cc/mrbird/febs/mall/controller/ApiMallTeamLeaderController.java +++ b/src/main/java/cc/mrbird/febs/mall/controller/ApiMallTeamLeaderController.java @@ -111,5 +111,11 @@ return iApiMallTeamLeaderService.leaderTitle(apiLeaderTitleDto); } + @ApiOperation(value = "获取团长订单角标数量") + @GetMapping(value = "/findTeamOrderMarkCnt") + public FebsResponse findTeamOrderMarkCnt() { + return iApiMallTeamLeaderService.findTeamOrderMarkCnt(); + } + } diff --git a/src/main/java/cc/mrbird/febs/mall/mapper/MallOrderInfoMapper.java b/src/main/java/cc/mrbird/febs/mall/mapper/MallOrderInfoMapper.java index fc4e284..3499662 100644 --- a/src/main/java/cc/mrbird/febs/mall/mapper/MallOrderInfoMapper.java +++ b/src/main/java/cc/mrbird/febs/mall/mapper/MallOrderInfoMapper.java @@ -63,4 +63,7 @@ BigDecimal selectSumAmountByPayMethodAndStatue(@Param("payMethod")String name, @Param("statue")int value); void updateOrderStateAndDeliveryState(@Param("orderId")Long orderId, @Param("orderState")int orderState, @Param("deliveryState")int deliveryState); + + List<Map<String, Integer>> selectMemberOrderStatusCntByUniquecode(@Param("uniqueCode")String uniqueCode); + } diff --git a/src/main/java/cc/mrbird/febs/mall/service/IApiMallTeamLeaderService.java b/src/main/java/cc/mrbird/febs/mall/service/IApiMallTeamLeaderService.java index 4718121..55de473 100644 --- a/src/main/java/cc/mrbird/febs/mall/service/IApiMallTeamLeaderService.java +++ b/src/main/java/cc/mrbird/febs/mall/service/IApiMallTeamLeaderService.java @@ -24,4 +24,6 @@ FebsResponse leaderOrderConfirm(ApiLeaderOrderConfirmDto apiLeaderOrderConfirmDto); FebsResponse leaderTitle(ApiLeaderTitleDto apiLeaderTitleDto); + + FebsResponse findTeamOrderMarkCnt(); } diff --git a/src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallTeamLeaderServiceImpl.java b/src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallTeamLeaderServiceImpl.java index edcce8a..d5f1fe2 100644 --- a/src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallTeamLeaderServiceImpl.java +++ b/src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallTeamLeaderServiceImpl.java @@ -34,7 +34,9 @@ import org.springframework.transaction.annotation.Transactional; import java.util.Arrays; +import java.util.HashMap; import java.util.List; +import java.util.Map; @Slf4j @Service @@ -237,4 +239,21 @@ return new FebsResponse().success().data(apiLeaderInfoVo); } + @Override + public FebsResponse findTeamOrderMarkCnt() { + MallMember loginUser = LoginUserUtil.getLoginUser(); + MallTeamLeader mallTeamLeader = this.baseMapper.selectLeaderByUniqueCode(loginUser.getInviteId()); + String uniqueCode = mallTeamLeader.getUniqueCode(); + List<Map<String, Integer>> maps = mallOrderInfoMapper.selectMemberOrderStatusCntByUniquecode(uniqueCode); + Map<Integer, Integer> orderCnt = new HashMap<>(); + if (CollUtil.isNotEmpty(maps)) { + for (Map<String, Integer> map : maps) { + orderCnt.put(map.get("status"), map.get("cnt")); + } + } + Map<String, Object> result = new HashMap<>(); + result.put("order", orderCnt); + return new FebsResponse().success().data(result); + } + } diff --git a/src/main/resources/mapper/modules/MallOrderInfoMapper.xml b/src/main/resources/mapper/modules/MallOrderInfoMapper.xml index b1ebead..aff7cc1 100644 --- a/src/main/resources/mapper/modules/MallOrderInfoMapper.xml +++ b/src/main/resources/mapper/modules/MallOrderInfoMapper.xml @@ -342,4 +342,13 @@ delivery_state = #{deliveryState} where id = #{orderId} </update> + + <select id="selectMemberOrderStatusCntByUniquecode" resultType="java.util.Map"> + select + status, + count(1) cnt + from mall_order_info + where del_flag = 2 and take_unique_code = #{uniqueCode} + group by status + </select> </mapper> \ No newline at end of file -- Gitblit v1.9.1