yyyfs/application/api/controller/Timedtask.php

<?php


namespace app\api\controller;
use AlibabaCloud\Client\AlibabaCloud;
use AlibabaCloud\Client\Exception\ClientException;
use AlibabaCloud\Client\Exception\ServerException;
use think\Db;
/**
 * @title 定时任务
 * Class Timedtask
 * @controller Timedtask
 * @group base
 */
class Timedtask
{
    /**
     * @title 会员优惠券过期
     * @desc  会员优惠券过期
     * @author  qc
     * @url /api/Timedtask/userCouponOver
     * @method GET
     */
    public function userCouponOver()
    {
        user_coupon_over();
    }

    /**
     * @title 取消订单定时任务
     * @desc  十五分钟内未支付的自动取消
     * @author  qc
     * @url /api/Timedtask/goodsOrder
     * @method GET
     */
    public function goodsOrder()
    {
       $sel_time = time() - 300;// 五分钟内未支付的自动取消
       $order_data = Db::table('goods_order')
           ->where('create_at','< time',date('Y-m-d H:i:s',$sel_time))
           ->where('status','=',0)
           ->where('cancel_state','=',0)
           ->select();
       foreach ($order_data as $order_info) {
           Db::startTrans();
           try {
               Db::table('goods_order')->where(['id'=>$order_info['id']])
                   ->update(['status'=>9,'cancel_state'=>1,'cancel_at'=>date('Y-m-d H:i:s'),'cancel_desc'=>'支付超时！自动取消']);
               Db::table('store_goods')->where('id', $order_info['goods_id'])
                   ->setInc('stock', $order_info['goods_num']);
               Db::commit();
           }catch (\Exception $e){
               Db::rollback();
           }
       }

    }



    /**
     * @title 分解魔玩柜
     * @desc  十五分钟内未支付的自动取消
     * @author  qc
     * @url /api/Timedtask/resolveMagic
     * @method GET
     */
    public function resolveMagic(){
        resolve_magic();
    }




}