<?php

namespace App\Console\Commands;

use App\Models\Order;
use Illuminate\Console\Command;
use Log;

class UpdateUserSpeedLimit extends Command
{
    protected $signature = 'updateUserSpeedLimit';
    protected $description = '根据商品更新用户限速';

    public function handle()
    {
        $jobStartTime = microtime(true);

        foreach (Order::whereStatus(2)->whereIsExpire(0)->where('goods_id', '>', '0')->oldest()->with(['user', 'goods'])->has('goods')->has('user')->get() as $order) {
            $order->user->update(['speed_limit' => $order->goods->speed_limit]);
        }

        $jobEndTime = microtime(true);
        $jobUsedTime = round(($jobEndTime - $jobStartTime), 4);

        Log::info('---【'.$this->description.'】完成---，耗时'.$jobUsedTime.'秒');
    }
}