123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960 |
- <?php
- namespace app\api\controller;
- use app\common\controller\Api;
- use app\common\model\Order;
- use think\Db;
- use think\Exception;
- /**
- * 定时任务
- */
- class TimedTask extends Api
- {
- protected $noNeedLogin = ['*'];
- protected $noNeedRight = '*';
- /**
- * 订单过期自动取消
- * @return void
- */
- public function cancellation_order(){
- //订单过期自动取消
- $orderlist = Order::all(function ($query){
- $query->where(['type'=>1,'status'=>1])->field('id,create_time');
- });
- foreach ($orderlist as $k=>$value){
- if($value){
- $create_time = strtotime($value['create_time']) + 1800;
- if($create_time < time()){
- Db::startTrans();
- try {
- Order::where('id',$value['id'])->update(['status'=>0]);
- Db::commit();
- }catch (Exception $exception){
- Db::rollback();
- $this->error($exception);
- }
- }
- }
- }
- //报价单过期自动取消
- $pjdorderlist = Order::all(function ($query){
- $query->where(['type'=>2,'status'=>1])->field('id,valid_time');
- });
- foreach ($pjdorderlist as $k=>$v){
- $valid_time = strtotime($v['valid_time']);
- if($valid_time < time()){
- Db::startTrans();
- try {
- Order::where('id',$v['id'])->update(['status'=>0]);
- Db::commit();
- }catch (Exception $exception){
- Db::rollback();
- $this->error($exception);
- }
- }
- }
- }
- }
|