From 4eeeb59f6c514b61c78aec2acc95cff4807810e1 Mon Sep 17 00:00:00 2001 From: peng <peng.com> Date: 星期五, 05 九月 2025 10:52:49 +0800 Subject: [PATCH] 抽奖活动中奖跳转 --- framework/src/main/java/cn/lili/modules/order/order/serviceimpl/OrderServiceImpl.java | 106 ++++++++++++++++++++++++++++++++++++++--------------- 1 files changed, 76 insertions(+), 30 deletions(-) diff --git a/framework/src/main/java/cn/lili/modules/order/order/serviceimpl/OrderServiceImpl.java b/framework/src/main/java/cn/lili/modules/order/order/serviceimpl/OrderServiceImpl.java index f73c50e..4d9dd28 100644 --- a/framework/src/main/java/cn/lili/modules/order/order/serviceimpl/OrderServiceImpl.java +++ b/framework/src/main/java/cn/lili/modules/order/order/serviceimpl/OrderServiceImpl.java @@ -27,6 +27,7 @@ import cn.lili.modules.goods.entity.dos.Goods; import cn.lili.modules.goods.entity.dto.GoodsCompleteMessage; import cn.lili.modules.goods.service.GoodsService; +import cn.lili.modules.lmk.domain.vo.OrderCountVO; import cn.lili.modules.lmk.enums.general.AdminRoleEnum; import cn.lili.modules.member.entity.dos.Member; import cn.lili.modules.member.entity.dto.MemberAddressDTO; @@ -70,6 +71,7 @@ import cn.lili.trigger.util.DelayQueueTools; import cn.lili.utils.COSUtil; import cn.lili.utils.CommonUtil; +import com.alibaba.fastjson.JSON; import com.baomidou.mybatisplus.core.conditions.Wrapper; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; @@ -85,17 +87,22 @@ import org.apache.poi.ss.util.CellRangeAddressList; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.apache.rocketmq.spring.core.RocketMQTemplate; +import org.redisson.api.RedissonClient; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.context.ApplicationEventPublisher; +import org.springframework.data.redis.core.RedisTemplate; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.web.multipart.MultipartFile; +import javax.annotation.Resource; import javax.servlet.ServletOutputStream; import javax.servlet.http.HttpServletResponse; import java.io.InputStream; +import java.math.BigDecimal; import java.net.URLEncoder; import java.util.*; +import java.util.concurrent.TimeUnit; import java.util.stream.Collectors; import cn.lili.modules.permission.entity.dos.Role; /** @@ -189,7 +196,10 @@ @Autowired private AdminUserService adminUserService; + @Resource + private RedisTemplate<Object,Object> redisTemplate; + private final static String LOCK_ORDER_NO_MQ="lock_order_no_mq:"; @Override @Transactional(rollbackFor = Exception.class) public void intoDB(TradeDTO tradeDTO) { @@ -244,6 +254,41 @@ } @Override + public OrderCountVO countByIdOrder(String id) { + OrderSearchParams orderSearchParams = new OrderSearchParams(); + + orderSearchParams.setOrderStatus(OrderStatusEnum.COMPLETED.name()); + orderSearchParams.setMemberId(id); + QueryWrapper queryWrapper = orderSearchParams.queryWrapper(); + queryWrapper.groupBy("o.id"); + queryWrapper.orderByDesc("o.id"); + List<OrderSimpleVO> list = this.baseMapper.queryByParamsCount(queryWrapper); + OrderCountVO orderCountVO = new OrderCountVO(); + orderCountVO.setOrderNumCount(0); + orderCountVO.setOrderPriceCount(BigDecimal.ZERO); + if (CollectionUtil.isEmpty(list)) { + return orderCountVO; + }else { + for (OrderSimpleVO vo : list) { + if (vo == null) { + System.out.println("鍑虹幇绌哄厓绱�"); + continue; // 璺宠繃null鍏冪礌锛屾垨鏍规嵁涓氬姟澶勭悊 + } + orderCountVO.setOrderNumCount(orderCountVO.getOrderNumCount() + 1); + + // 閲戦绱姞锛氱敤BigDecimal澶勭悊锛岄伩鍏嶇簿搴﹂棶棰� + BigDecimal flowPrice = vo.getFlowPrice() != null ? + BigDecimal.valueOf(vo.getFlowPrice()) : BigDecimal.ZERO; + + // 鐢˙igDecimal鐨刟dd鏂规硶绱姞 + BigDecimal totalPrice = orderCountVO.getOrderPriceCount().add(flowPrice); + orderCountVO.setOrderPriceCount(totalPrice); + + } + } + return orderCountVO; + } + @Override public IPage<OrderSimpleVO> queryByParams(OrderSearchParams orderSearchParams,Boolean needHide) { QueryWrapper queryWrapper = orderSearchParams.queryWrapper(); queryWrapper.groupBy("o.id"); @@ -258,17 +303,8 @@ } } - for (OrderSimpleVO vo : page.getRecords()){ - Member member = memberMapperMapper.selectById(vo.getMemberId()); - if (member != null){ - vo.setNickName(member.getNickName()); - } - } return page; } - - - @Override public IPage<OrderSimpleXcxVO> queryByXcxParams(OrderSearchXcxParams orderSearchParams) { QueryWrapper queryWrapper = orderSearchParams.queryWrapper(); @@ -417,8 +453,6 @@ vo.setConsigneeMobile(CommonUtil.maskMobile(vo.getConsigneeMobile())); } } - - XSSFWorkbook workbook = initOrderExportData(orderExportDTOS); try { // 璁剧疆鍝嶅簲澶� @@ -458,6 +492,11 @@ @Override @Transactional public String sendMqMessage(String snNo) { + //闄愬埗30绉掑彧鑳借姹備竴娆¢伩鍏嶅嚭鐜伴噸鏂版彁浜ら棶棰� + Boolean b = redisTemplate.opsForValue().setIfAbsent(LOCK_ORDER_NO_MQ + snNo, snNo,30, TimeUnit.SECONDS); + if ( Boolean.FALSE.equals(b)){ + throw new ServiceException("璇峰湪30绉掑悗閲嶈瘯"); + } Order order = this.getBySn(snNo); if (order == null) { throw new ServiceException(ResultCode.ORDER_NOT_EXIST); @@ -505,6 +544,7 @@ throw new ServiceException(ResultCode.ORDER_CAN_NOT_CANCEL); } } + @Override @@ -633,9 +673,12 @@ public Order delivery(String orderSn, String logisticsNo, String logisticsId) { Order order = OperationalJudgment.judgment(this.getBySn(orderSn)); //濡傛灉璁㈠崟鏈彂璐э紝骞朵笖璁㈠崟鐘舵�佸�肩瓑浜庡緟鍙戣揣 + log.info("鑾峰彇鍒扮殑璁㈠崟淇℃伅涓簕}", JSON.toJSONString(order)); if (order.getDeliverStatus().equals(DeliverStatusEnum.UNDELIVERED.name()) && order.getOrderStatus().equals(OrderStatusEnum.UNDELIVERED.name())) { //鑾峰彇瀵瑰簲鐗╂祦 Logistics logistics = logisticsService.getById(logisticsId); + log.info("鑾峰彇鍒扮殑鐗╂祦淇℃伅id涓簕}", logisticsId); + log.info("鑾峰彇鍒扮殑鐗╂祦淇℃伅涓簕}", JSON.toJSONString(logistics)); if (logistics == null) { throw new ServiceException(ResultCode.ORDER_LOGISTICS_ERROR); } @@ -1424,7 +1467,7 @@ // 鍒涘缓琛ㄥご Row header = sheet.createRow(0); String[] headers = {"涓昏鍗曠紪鍙�", "瀛愯鍗曠紪鍙�", "閫夎喘鍟嗗搧", "鍟嗗搧鏁伴噺", "鍟嗗搧ID", "鍟嗗搧鍗曚环", "璁㈠崟搴斾粯閲戦", - "杩愯垂", "浼樻儬鎬婚噾棰�", "骞冲彴浼樻儬", "鍟嗗浼樻儬", "鍟嗗鏀逛环", "鏀粯鏂瑰紡", "鏀朵欢浜�", "鏀朵欢浜烘墜鏈哄彿", + "杩愯垂", "浼樻儬鎬婚噾棰�", "骞冲彴浼樻儬", "鍟嗗浼樻儬", "鍟嗗鏀逛环", "鏀粯鏂瑰紡","涔板鍚嶇О", "鏀朵欢浜�", "鏀朵欢浜烘墜鏈哄彿", "鐪�", "甯�", "鍖�", "琛楅亾", "璇︾粏鍦板潃", "涔板鐣欒█", "璁㈠崟鎻愪氦鏃堕棿", "鏀粯瀹屾垚鏃堕棿", "鏉ユ簮", "璁㈠崟鐘舵��", "璁㈠崟绫诲瀷", "鍞悗鐘舵��", "鍙栨秷鍘熷洜", "鍙戣揣鏃堕棿", "瀹屾垚鏃堕棿", "搴楅摵"}; @@ -1449,24 +1492,27 @@ row.createCell(10).setCellValue(dto.getStoreMarketingCost()!=null?dto.getStoreMarketingCost():0); row.createCell(11).setCellValue(dto.getUpdatePrice()!=null?dto.getUpdatePrice():0); row.createCell(12).setCellValue(dto.getPaymentMethod()); - row.createCell(13).setCellValue(dto.getConsigneeName()); - row.createCell(14).setCellValue(dto.getConsigneeMobile()); - row.createCell(15).setCellValue(dto.getProvince()); - row.createCell(16).setCellValue(dto.getCity()); - row.createCell(17).setCellValue(dto.getDistrict()); - row.createCell(18).setCellValue(dto.getStreet()); - row.createCell(19).setCellValue(dto.getConsigneeDetail()); - row.createCell(20).setCellValue(dto.getRemark()); - row.createCell(21).setCellValue(dto.getCreateTime()); - row.createCell(22).setCellValue(dto.getPaymentTime()); - row.createCell(23).setCellValue(dto.getClientType()); - row.createCell(24).setCellValue(dto.getOrderStatus()); - row.createCell(25).setCellValue(dto.getOrderType()); - row.createCell(26).setCellValue(dto.getAfterSaleStatus()); - row.createCell(27).setCellValue(dto.getCancelReason()); - row.createCell(28).setCellValue(dto.getLogisticsTime()); - row.createCell(29).setCellValue(dto.getCompleteTime()); - row.createCell(30).setCellValue(dto.getStoreName()); + + row.createCell(13).setCellValue(dto.getNickName()); + + row.createCell(14).setCellValue(dto.getConsigneeName()); + row.createCell(15).setCellValue(dto.getConsigneeMobile()); + row.createCell(16).setCellValue(dto.getProvince()); + row.createCell(17).setCellValue(dto.getCity()); + row.createCell(18).setCellValue(dto.getDistrict()); + row.createCell(19).setCellValue(dto.getStreet()); + row.createCell(20).setCellValue(dto.getConsigneeDetail()); + row.createCell(21).setCellValue(dto.getRemark()); + row.createCell(22).setCellValue(dto.getCreateTime()); + row.createCell(23).setCellValue(dto.getPaymentTime()); + row.createCell(24).setCellValue(dto.getClientType()); + row.createCell(25).setCellValue(dto.getOrderStatus()); + row.createCell(26).setCellValue(dto.getOrderType()); + row.createCell(27).setCellValue(dto.getAfterSaleStatus()); + row.createCell(28).setCellValue(dto.getCancelReason()); + row.createCell(29).setCellValue(dto.getLogisticsTime()); + row.createCell(30).setCellValue(dto.getCompleteTime()); + row.createCell(31).setCellValue(dto.getStoreName()); } //淇敼鍒楀 -- Gitblit v1.8.0