UpdateUserSpeedLimit.php 751 B

1234567891011121314151617181920212223242526
  1. <?php
  2. namespace App\Console\Commands;
  3. use App\Models\Order;
  4. use Illuminate\Console\Command;
  5. use Log;
  6. class UpdateUserSpeedLimit extends Command
  7. {
  8. protected $signature = 'updateUserSpeedLimit';
  9. protected $description = '根据商品更新用户限速';
  10. public function handle()
  11. {
  12. $jobTime = microtime(true);
  13. foreach (Order::whereStatus(2)->whereIsExpire(0)->where('goods_id', '<>', null)->oldest()->with(['user', 'goods'])->has('goods')->has('user')->get() as $order) {
  14. $order->user->update(['speed_limit' => $order->goods->speed_limit]);
  15. }
  16. $jobTime = round(microtime(true) - $jobTime, 4);
  17. Log::info('---【'.$this->description.'】完成---,耗时'.$jobTime.'秒');
  18. }
  19. }