CatchUnoptimizedMedia.php 1.4 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061
  1. <?php
  2. namespace App\Console\Commands;
  3. use DB;
  4. use App\Jobs\ImageOptimizePipeline\ImageOptimize;
  5. use App\Media;
  6. use Illuminate\Console\Command;
  7. class CatchUnoptimizedMedia extends Command
  8. {
  9. /**
  10. * The name and signature of the console command.
  11. *
  12. * @var string
  13. */
  14. protected $signature = 'media:optimize';
  15. /**
  16. * The console command description.
  17. *
  18. * @var string
  19. */
  20. protected $description = 'Find and optimize media that has not yet been optimized.';
  21. /**
  22. * Create a new command instance.
  23. *
  24. * @return void
  25. */
  26. public function __construct(Media $media)
  27. {
  28. parent::__construct();
  29. }
  30. /**
  31. * Execute the console command.
  32. *
  33. * @return mixed
  34. */
  35. public function handle()
  36. {
  37. DB::transaction(function() {
  38. Media::whereNull('processed_at')
  39. ->where('skip_optimize', '!=', true)
  40. ->whereNull('remote_url')
  41. ->whereNotNull('status_id')
  42. ->whereNotNull('media_path')
  43. ->where('created_at', '>', now()->subHours(1))
  44. ->whereIn('mime', [
  45. 'image/jpeg',
  46. 'image/png',
  47. ])
  48. ->chunk(50, function($medias) {
  49. foreach ($medias as $media) {
  50. ImageOptimize::dispatch($media);
  51. }
  52. });
  53. });
  54. }
  55. }