/** * Execute the console command. * * @return mixed */ public function handle() { $pictures = Storage::files(); Tracking::with(['location', 'facing'])->where('image_url', '')->orderBy('id', 'desc')->chunk(200, function ($trackings) use($pictures) { foreach ($trackings as $tracking) { $ref = $this->reference($tracking->location->city, $tracking->facing->name, new Carbon($tracking->tracking_date)); $image_url = "{$ref}.jpg"; if (in_array($image_url, $pictures)) { $tracking->update(['image_url' => $image_url]); $this->info('Tracking #' . $ref . ' updated with image url ' . $image_url); } else { $this->error('Tracking #' . $ref . ' picture missing.'); } } }); }