fix
Helius
2022-09-23 4f6c4b291dfe70cf8f65b082d7bbdfa5e0eccb3f
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
package cc.mrbird.febs.mall.quartz;
 
import cc.mrbird.febs.common.enumerates.OrderStatusEnum;
import cc.mrbird.febs.mall.entity.MallGoods;
import cc.mrbird.febs.mall.entity.MallGoodsSku;
import cc.mrbird.febs.mall.entity.MallOrderInfo;
import cc.mrbird.febs.mall.entity.MallOrderItem;
import cc.mrbird.febs.mall.mapper.*;
import cn.hutool.core.collection.CollUtil;
import cn.hutool.core.date.DateUnit;
import cn.hutool.core.date.DateUtil;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.scheduling.annotation.Scheduled;
import org.springframework.stereotype.Component;
 
import java.util.Date;
import java.util.List;
 
/**
 * @author wzy
 * @date 2021-09-25
 **/
@Slf4j
@Component
public class OrderOvertimeJob {
 
    @Autowired
    private MallOrderInfoMapper orderInfoMapper;
 
    @Autowired
    private MallMemberMapper mallMemberMapper;
 
    @Autowired
    private MallOrderItemMapper mallOrderItemMapper;
 
    @Autowired
    private MallGoodsMapper mallGoodsMapper;
 
    @Autowired
    private MallGoodsSkuMapper mallGoodsSkuMapper;
 
    @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);
 
                if (subTime > 15) {
                    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) {
                            Long goodsId = mallOrderItem.getGoodsId();
                            Long skuId = mallOrderItem.getSkuId();
                            Integer cnt = mallOrderItem.getCnt();
                            MallGoods mallGoods = mallGoodsMapper.selectById(goodsId);
                            mallGoods.setVolume(mallGoods.getVolume() - cnt);
                            mallGoods.setStock(mallGoods.getStock() + cnt);
                            mallGoodsMapper.updateById(mallGoods);
 
                            MallGoodsSku mallGoodsSku = mallGoodsSkuMapper.selectById(skuId);
                            mallGoodsSku.setSkuVolume(mallGoodsSku.getSkuVolume() - cnt);
                            mallGoodsSku.setStock(mallGoodsSku.getStock() + cnt);
                            mallGoodsSkuMapper.updateById(mallGoodsSku);
                        }
                    }
                }
            }
        }
 
    }
 
//    @Scheduled(cron = "0/5 * * * * ? ")
//    public void wakeup() {
//        log.info("本地保持唤醒状态");
//        Long id = 5L;
//        mallMemberMapper.selectById(id);
//    }
}