Quartz关闭超时订单

蔚落 2022-05-16 12:47 174阅读 0赞

### 订单服务 ###

用户下单之后会占用库存  
如果，用户不处理订单，需要系统自动关闭已经下单的订单

比如，秒杀的时候，设置的时间可能非常短  
下单之后，需要用户马上付款，否则，马上就会关闭，释放商品的库存  
否则，秒杀结束了，某个用户还占用着库存

这里，关闭超时2天的订单

### 导入依赖 ###

<dependency>
        <groupId>org.quartz-scheduler</groupId>
        <artifactId>quartz</artifactId>
        <version>2.2.2</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context-support</artifactId>
        <version>4.1.3.RELEASE</version>
    </dependency>

### 创建Job ###

/** * 扫描超过2天未付款的订单关闭 */
    public class PaymentOrderJob extends QuartzJobBean { 
    
        @Override
        protected void executeInternal(JobExecutionContext context) throws JobExecutionException {
            ApplicationContext applicationContext = (ApplicationContext) context.getJobDetail().getJobDataMap()
                    .get("applicationContext");
            //时间参数，当前时间向前推2天
            applicationContext.getBean(OrderMapper.class).paymentOrderScan(new DateTime().minusDays(2).toDate());
        }
    
    }

### 添加配置 ###

applicationContext-scheduler.xml

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans" xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">
    
        
        <bean name="paymentOrderJobDetail" class="org.springframework.scheduling.quartz.JobDetailFactoryBean">
            
            <property name="jobClass" value="com.taotao.store.order.job.PaymentOrderJob" />
            
            <property name="name" value="paymentOrder" />
            
            <property name="group" value="Order" />
            
            <property name="durability" value="true"/>
            
            <property name="applicationContextJobDataKey" value="applicationContext"/>
        </bean>
    
        
        <bean id="cronTrigger" class="org.springframework.scheduling.quartz.CronTriggerFactoryBean">
            <property name="jobDetail" ref="paymentOrderJobDetail" />
            
            <property name="cronExpression" value="0 0/1 * * * ?" />
        </bean>
    
        
        <bean class="org.springframework.scheduling.quartz.SchedulerFactoryBean">
            <property name="triggers">
                <list>
                    <ref bean="cronTrigger" />
                </list>
            </property>
        </bean>
    
    </beans>

### OrderMapper ###

扫描超时订单并关闭  
定时的做一个update操作，触发由quartz完成

<update id="paymentOrderScan" parameterType="Date">
        UPDATE tb_order SET
            status = 6,
            update_time = NOW(),
            close_time = NOW(),
            end_time = NOW()
        WHERE status = 1 AND payment_type = 1 AND create_time <= #{
       date}
    </update>

业务状态  
订单状态为6，表示关闭状态  
更新时间、关闭时间、结束时间等于当前时间

付款状态为1，表示未付款  
支付方式为1，表示在线支付  
创建时间小于等于传入的时间