LaraBug/larabug-app

use App\Models\User;
use Illuminate\Console\Command;
 
class RotateExceptions extends Command
{
    protected $signature = 'rotate:exceptions';
 
    protected $description = 'Rotates all the exceptions that are expired';
 
    protected $starterRetention = 30;
 
    public function handle()
    {
        $users = User::query()
            ->whereHas('projects', function ($query) {
                return $query->whereHas('exceptions', function ($query) {
                    return $query->where('created_at', '<', now()->subDays($this->starterRetention));
                });
            })
            ->with(['projects' => function ($query) {
                return $query
                    ->whereHas('exceptions', function ($query) {
                        return $query->where('created_at', '<', now()->subDays($this->starterRetention));
                    });
            }])
            ->get();
 
        foreach ($users as $user) {
            foreach ($user->projects as $project) {
                $project->exceptions()->where('created_at', '<', now()->subDays($this->starterRetention))->delete();
            }
        }
    }
}