UpdateUserSpeedLimit.php 806 B

123456789101112131415161718192021222324252627
  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. $jobStartTime = 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. $jobEndTime = microtime(true);
  17. $jobUsedTime = round(($jobEndTime - $jobStartTime), 4);
  18. Log::info('---【'.$this->description.'】完成---,耗时'.$jobUsedTime.'秒');
  19. }
  20. }