From e3208d7d762bcc05b0c943a5bda181ba2a0c0435 Mon Sep 17 00:00:00 2001 From: Helius <wangdoubleone@gmail.com> Date: Wed, 21 Jul 2021 10:48:18 +0800 Subject: [PATCH] modify --- gc-shop/src/main/java/com/xzx/gc/shop/service/JhyService.java | 130 ++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 128 insertions(+), 2 deletions(-) diff --git a/gc-shop/src/main/java/com/xzx/gc/shop/service/JhyService.java b/gc-shop/src/main/java/com/xzx/gc/shop/service/JhyService.java index e0f39e4..f2bdae2 100644 --- a/gc-shop/src/main/java/com/xzx/gc/shop/service/JhyService.java +++ b/gc-shop/src/main/java/com/xzx/gc/shop/service/JhyService.java @@ -1,17 +1,32 @@ package com.xzx.gc.shop.service; +import cn.hutool.core.bean.BeanUtil; +import cn.hutool.core.collection.CollUtil; import cn.hutool.core.convert.Convert; +import cn.hutool.core.util.StrUtil; import com.github.pagehelper.PageHelper; import com.github.pagehelper.PageInfo; +import com.xzx.gc.common.utils.StringUtils; +import com.xzx.gc.entity.JhyOrder; +import com.xzx.gc.entity.JhyOrderItems; +import com.xzx.gc.entity.ScoreOrder; +import com.xzx.gc.entity.ScoreOrderDetails; +import com.xzx.gc.shop.dto.CancelJhyOrderDto; import com.xzx.gc.shop.dto.QueryJhyOrderListDto; +import com.xzx.gc.shop.mapper.JhyOrderItemsMapper; import com.xzx.gc.shop.mapper.JhyOrderMapper; -import com.xzx.gc.shop.vo.QueryGoodsListVo; -import com.xzx.gc.shop.vo.QueryJhyOrderListVo; +import com.xzx.gc.shop.mapper.OrderInfoMapper; +import com.xzx.gc.shop.mapper.ScoreOrderMapper; +import com.xzx.gc.shop.vo.*; import lombok.extern.slf4j.Slf4j; +import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; +import tk.mybatis.mapper.entity.Example; import javax.annotation.Resource; +import java.math.BigDecimal; +import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; @@ -23,10 +38,36 @@ @Resource JhyOrderMapper jhyOrderMapper; + @Resource + JhyOrderItemsMapper jhyOrderItemsMapper; + + @Autowired + private OrderInfoMapper orderInfoMapper; + + @Autowired + private ScoreOrderMapper scoreOrderMapper; public Map<String, Object> queryOrderList(QueryJhyOrderListDto model) { PageHelper.startPage(model.getPage(), model.getLimit()); + String accountPhone = model.getAccount(); +// String name = StrUtil.isEmpty(model.getAccount())?model.getAccount():StringUtils.encode(model.getAccount()); + String name = model.getAccount(); + model.setAccount(name); + model.setAccountPhone(accountPhone); List<QueryJhyOrderListVo> maps = jhyOrderMapper.queryOrderList(model); + if(CollUtil.isNotEmpty(maps)){ + for(QueryJhyOrderListVo queryJhyOrderListVo : maps){ + Long id = queryJhyOrderListVo.getId(); + List<JhyOrderItemsVo> jhyOrderItemsVos = jhyOrderItemsMapper.selectByOrderId(id); + queryJhyOrderListVo.setJhyOrderItemsVos(jhyOrderItemsVos); + } + } +// if(CollUtil.isNotEmpty(maps)){ +// for(QueryJhyOrderListVo queryJhyOrderListVo : maps){ +// String decode = StringUtils.decode(queryJhyOrderListVo.getName()); +// queryJhyOrderListVo.setName(decode); +// } +// } PageInfo pageInfo = new PageInfo(maps); int count = Convert.toInt(pageInfo.getTotal()); Map<String, Object> map = new HashMap<>(); @@ -36,4 +77,89 @@ return map; } + public ViewJhyOrderVo viewJhyOrder(Long id) { + ViewJhyOrderVo viewJhyOrderVo = new ViewJhyOrderVo(); + viewJhyOrderVo = jhyOrderMapper.viewJhyOrder(id); + + String decode = StringUtils.decode(viewJhyOrderVo.getNickName()); + viewJhyOrderVo.setNickName(decode); + + List<JhyOrderItemsVo> jhyOrderItemsList = jhyOrderItemsMapper.selectJhyOrderItemListByOrderId(id); + if(CollUtil.isNotEmpty(jhyOrderItemsList)){ + for(JhyOrderItemsVo jhyOrderItemsVo : jhyOrderItemsList){ + BigDecimal multiply = jhyOrderItemsVo.getPrice().multiply(new BigDecimal(40)); + jhyOrderItemsVo.setPrice(multiply); + jhyOrderItemsVo.setAllPrice(new BigDecimal(StrUtil.isEmpty(jhyOrderItemsVo.getScore())?"0":jhyOrderItemsVo.getScore()).setScale( 2, BigDecimal.ROUND_DOWN )); + } + } + viewJhyOrderVo.setJhyOrderItems(jhyOrderItemsList); + + return viewJhyOrderVo; + } + + public void cancelJhyOrder(CancelJhyOrderDto model) { + Long id = model.getId(); + JhyOrder jhyOrder = jhyOrderMapper.selectByPrimaryKey(id); + jhyOrder.setStatus(JhyOrder.ORDER_STATUS_CANCEL); + jhyOrderMapper.updateByPrimaryKey(jhyOrder); + } + + public StatisticsVo orderStatistics(String userId) { + // 骑手订单 + List<Map<String, Object>> qsAllData = orderInfoMapper.selectOrderTitleStatistics(null); + List<Map<String, Object>> qsUserData = orderInfoMapper.selectOrderTitleStatistics(userId); + + // 集物员订单 + List<Map<String, Object>> jhyAllData = jhyOrderMapper.selectJhyOrderTitleStatistics(null); + List<Map<String, Object>> jhyUserData = jhyOrderMapper.selectJhyOrderTitleStatistics(userId); + + BigDecimal allCarbon = totalData(qsAllData).add(totalData(jhyAllData)); + BigDecimal userCarbon = totalData(qsUserData).add(totalData(jhyUserData)); + + Integer qsAllCnt = orderInfoMapper.selectOrderCnt(null); + Integer qsUserCnt = orderInfoMapper.selectOrderCnt(userId); + + Integer jhyAllCnt = jhyOrderMapper.selectJhyOrderCnt(null); + Integer jhyUserCnt = jhyOrderMapper.selectJhyOrderCnt(userId); + + Integer allCnt = scoreOrderMapper.selectScoreOrderCnt(null); + BigDecimal score = jhyOrderMapper.selectTotalScoreHasGet(userId); + + StatisticsVo result = new StatisticsVo(); + result.setTotalReduceCarbon(allCarbon.divide(BigDecimal.valueOf(1000), 2, BigDecimal.ROUND_DOWN)); + result.setReduceCarbon(userCarbon.setScale(2, BigDecimal.ROUND_DOWN)); + + result.setOrderCnt(qsUserCnt + jhyUserCnt); + result.setTotalOrderCnt(qsAllCnt + jhyAllCnt); + + result.setTotalBuyCnt(allCnt); + result.setScore(score); + return result; + } + + private BigDecimal totalData(List<Map<String, Object>> data) { + Map<String, BigDecimal> type = new HashMap<>(); + type.put("金属", BigDecimal.valueOf(0.02)); + type.put("纸类", BigDecimal.valueOf(1.5)); + type.put("塑料", BigDecimal.valueOf(0.61)); + type.put("衣服", BigDecimal.valueOf(1.63)); + + if (CollUtil.isEmpty(data)) { + return BigDecimal.ZERO; + } + + BigDecimal total = BigDecimal.ZERO; + for (Map<String, Object> map : data) { + String title = (String) map.get("title"); + BigDecimal value = type.get(title); + if (value == null) { + continue; + } + + BigDecimal weight = new BigDecimal(map.get("weight").toString()); + total = total.add(weight.multiply(value)); + } + + return total; + } } -- Gitblit v1.9.1