From ff2845059d92bb71c7901e18a4936a246b7aa1e5 Mon Sep 17 00:00:00 2001
From: KKSU <15274802129@163.com>
Date: Mon, 23 Dec 2024 18:13:28 +0800
Subject: [PATCH] perf(mall): 优化节点助力功能

---
 src/main/java/cc/mrbird/febs/mall/quartz/OrderOvertimeJob.java |   93 ++++++++++++++++++++++++++++++++++------------
 1 files changed, 68 insertions(+), 25 deletions(-)

diff --git a/src/main/java/cc/mrbird/febs/mall/quartz/OrderOvertimeJob.java b/src/main/java/cc/mrbird/febs/mall/quartz/OrderOvertimeJob.java
index c9ca6a6..d9197bc 100644
--- a/src/main/java/cc/mrbird/febs/mall/quartz/OrderOvertimeJob.java
+++ b/src/main/java/cc/mrbird/febs/mall/quartz/OrderOvertimeJob.java
@@ -1,18 +1,10 @@
 package cc.mrbird.febs.mall.quartz;
 
-import cc.mrbird.febs.common.enumerates.OrderStatusEnum;
-import cc.mrbird.febs.mall.entity.MallOrderInfo;
-import cc.mrbird.febs.mall.mapper.MallOrderInfoMapper;
-import cn.hutool.core.collection.CollUtil;
-import cn.hutool.core.date.DateUnit;
-import cn.hutool.core.date.DateUtil;
+import cc.mrbird.febs.mall.mapper.*;
 import lombok.extern.slf4j.Slf4j;
 import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.scheduling.annotation.Scheduled;
+import org.springframework.boot.autoconfigure.condition.ConditionalOnProperty;
 import org.springframework.stereotype.Component;
-
-import java.util.Date;
-import java.util.List;
 
 /**
  * @author wzy
@@ -20,26 +12,77 @@
  **/
 @Slf4j
 @Component
+@ConditionalOnProperty(prefix = "system", name = "job", havingValue = "true")
 public class OrderOvertimeJob {
 
     @Autowired
     private MallOrderInfoMapper orderInfoMapper;
 
-    @Scheduled(cron = "0 0/5 * * * ? ")
-    public void overtimeJob() {
-        log.info("订单超时任务执行");
-        List<MallOrderInfo> orderList = orderInfoMapper.selectOrderInfoByStatus(OrderStatusEnum.WAIT_PAY.getValue());
-        if (CollUtil.isNotEmpty(orderList)) {
-            for (MallOrderInfo orderInfo : orderList) {
-                long subTime = DateUtil.between(orderInfo.getOrderTime(), new Date(), DateUnit.MINUTE, false);
+    @Autowired
+    private MallMemberMapper mallMemberMapper;
 
-                if (subTime > 15) {
-                    orderInfo.setStatus(OrderStatusEnum.CANCEL.getValue());
-                    orderInfo.setCancelType(MallOrderInfo.CANCEL_OVERTIME_NO_PAY);
-                    orderInfoMapper.updateById(orderInfo);
-                }
-            }
-        }
+    @Autowired
+    private MallOrderItemMapper mallOrderItemMapper;
 
-    }
+    @Autowired
+    private MallGoodsMapper mallGoodsMapper;
+
+    @Autowired
+    private MallGoodsSkuMapper mallGoodsSkuMapper;
+
+    @Autowired
+    private MallMemberCouponMapper mallMemberCouponMapper;
+
+//    @Scheduled(cron = "0 0/5 * * * ? ")
+//    public void overtimeJob() {
+//        log.info("订单超时任务执行");
+//        List<MallOrderInfo> orderList = orderInfoMapper.selectOrderInfoUpTime(OrderStatusEnum.WAIT_PAY.getValue());
+//        if (CollUtil.isNotEmpty(orderList)) {
+//            for (MallOrderInfo orderInfo : orderList) {
+//                //更新订单状态
+//                orderInfo.setStatus(OrderStatusEnum.CANCEL.getValue());
+//                orderInfo.setCancelType(MallOrderInfo.CANCEL_OVERTIME_NO_PAY);
+//                orderInfoMapper.updateById(orderInfo);
+//
+//                List<MallOrderItem> mallOrderItemList = mallOrderItemMapper.selectListByOrderId(orderInfo.getId());
+//                if(CollUtil.isNotEmpty(mallOrderItemList)){
+//                    for(MallOrderItem mallOrderItem : mallOrderItemList){
+//                        MallGoodsSku sku = mallGoodsSkuMapper.selectSkuInfoById(mallOrderItem.getSkuId());
+//                        if (sku == null) {
+//                            throw new FebsException("购买商品或sku不存在");
+//                        }
+//
+////                        if (sku.getStock() < mallOrderItem.getCnt()) {
+////                            throw new FebsException(sku.getSkuName() + "库存不足");
+////                        }
+//
+//                        MallGoods mallGoods = mallGoodsMapper.selectById(sku.getGoodsId());
+//                        Integer goodsResult = mallGoodsMapper.updateStockAndVolumeByGoodsId(mallGoods.getId(), mallOrderItem.getCnt());
+//                        if(1 != goodsResult){
+//                            throw new FebsException(mallGoods.getGoodsName() + "库存不足");
+//                        }
+//
+//                        Integer skuResult = mallGoodsSkuMapper.updateStockAndVolumeBySkuId(sku.getId(),mallOrderItem.getCnt());
+//                        if(1 != skuResult){
+//                            throw new FebsException(sku.getSkuName() + "库存不足");
+//                        }
+//                        Long memberCouponId = mallOrderItem.getMemberCouponId();
+//                        MallMemberCoupon mallMemberCoupon = mallMemberCouponMapper.selectById(memberCouponId);
+//                        if(ObjectUtil.isNotEmpty(mallMemberCoupon)){
+//                            mallMemberCoupon.setState(1);
+//                            mallMemberCouponMapper.updateById(mallMemberCoupon);
+//                        }
+//                    }
+//                }
+//            }
+//        }
+//
+//    }
+
+//    @Scheduled(cron = "0/5 * * * * ? ")
+//    public void wakeup() {
+//        log.info("本地保持唤醒状态");
+//        Long id = 5L;
+//        mallMemberMapper.selectById(id);
+//    }
 }

--
Gitblit v1.9.1