From a41edcb537563fc28aed3e442e7420beaae2e504 Mon Sep 17 00:00:00 2001 From: xiaoyong931011 <15274802129@163.com> Date: Thu, 22 Sep 2022 18:08:41 +0800 Subject: [PATCH] 20220902 --- src/main/java/cc/mrbird/febs/mall/quartz/OrderOvertimeJob.java | 32 ++++++++++++++++++++++++++++++-- 1 files changed, 30 insertions(+), 2 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 57f42b8..5430477 100644 --- a/src/main/java/cc/mrbird/febs/mall/quartz/OrderOvertimeJob.java +++ b/src/main/java/cc/mrbird/febs/mall/quartz/OrderOvertimeJob.java @@ -1,9 +1,11 @@ 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.mapper.MallMemberMapper; -import cc.mrbird.febs.mall.mapper.MallOrderInfoMapper; +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; @@ -29,6 +31,15 @@ @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("订单超时任务执行"); @@ -42,6 +53,23 @@ 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); + } + } } } -- Gitblit v1.9.1