项目-苍穹外卖（十四) Spring Task+订单状态定时处理

一、Spring Task介绍

二、Spring Task_cron表达式

在线Cron表达式生成器https://cron.qqe2.com/

三、入门案例

四、订单状态定时处理

package com.sky.task;

import com.sky.entity.Orders;
import com.sky.mapper.OrderMapper;
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.time.LocalDateTime;
import java.util.List;

@Component
@Slf4j
public class OrderTask {

    @Autowired
    OrderMapper orderMapper;


    /**
     * 处理支付超时订单的方法
     * */
    @Scheduled(cron = "0 * * * * ? ")
    public void processTimeoutOrder(){
        log.info("处理超时订单：{}", LocalDateTime.now());

        //查询超时订单
        //select * from order where status = ? and order_time < (当前时间-15分钟)
        List<Orders> orderList = orderMapper.getByStatusAndOrderTimeLT(Orders.UN_PAID, LocalDateTime.now().plusMinutes(-15));

        if(orderList != null && orderList.size()>0){
            for (Orders orders : orderList) {
                orders.setStatus(Orders.CANCELLED);
                orders.setCancelReason("订单超时，自动取消");
                orders.setCancelTime(LocalDateTime.now());
                orderMapper.update(orders);
            }
        }
    }

    /**
     * 处理派送超时订单
     * */
    @Scheduled(cron = "0 0 1 * * ?")
    public void processDeliveryOrder(){
        log.info("处理派送超时订单：{}",LocalDateTime.now());

        List<Orders> ordersList = orderMapper.getByStatusAndOrderTimeLT(Orders.DELIVERY_IN_PROGRESS, LocalDateTime.now().plusMinutes(-60));

        for (Orders orders : ordersList) {
            orders.setStatus(Orders.COMPLETED);
            orderMapper.update(orders);
        }

    }
}