CleanOldShortUrls.php

Aller à la documentation de ce fichier.

<?php
 
namespace App\Console\Commands;
 
use Illuminate\Console\Command;
use App\Models\ShortUrl;
 
class CleanOldShortUrls extends Command
{
    protected $signature = 'shorturls:clean';
 
    protected $description = 'Supprime les short URLs non utilisées depuis plus de 3 mois, URLs courtes non cliquées ou non copiées.';
 
    public function handle(): int
    {
        $deleted = ShortUrl::where(function ($query) {
            $query->where('last_used_at', '<', now()->subMonths(3));
        })->delete();
 
        $this->info("{$deleted} short URLs deleted (not used for +3 months)");
 
        return $deleted;
    }
}