app/Jobs/AssignAppsToTimeInterval.php
<?php
namespace App\Jobs;
use App\Models\TimeInterval;
use Illuminate\Bus\Queueable;
use Illuminate\Contracts\Queue\ShouldBeUnique;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Foundation\Bus\Dispatchable;
use Illuminate\Queue\InteractsWithQueue;
use Illuminate\Support\Facades\DB;
class AssignAppsToTimeInterval implements ShouldQueue, ShouldBeUnique
{
use Dispatchable, InteractsWithQueue, Queueable;
public int $uniqueFor = 60;
public function __construct(protected TimeInterval $interval)
{
}
public function uniqueId(): string
{
return $this->interval->id;
}
public function handle(): void
{
DB::table('tracked_applications')
->whereNull('time_interval_id')
->where('user_id', $this->interval->user_id)
->where('created_at', '>', $this->interval->start_at->setTimezone(config('app.timezone')))
->where('created_at', '<', $this->interval->end_at->setTimezone(config('app.timezone')))
->update(['time_interval_id' => $this->interval->id]);
}
}