ldc-doux/app/Models/Slider.php

<?php

namespace App\Models;

use Carbon\Carbon;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Spatie\Translatable\HasTranslations;

class Slider extends Model
{
    use HasFactory;
    use HasTranslations;

    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    #[\Override]
    protected $fillable = [
        'label',
        'slug',
        'commentaire',
        'published'
    ];

    /**
     * The attributes that are translatable.
     *
     * @var array
     */
    public $translatable = [
        'label',
        'slug',
        'commentaire'
    ];

    /**
     * HasMany slides relation
     *
     * @return \Illuminate\Database\Eloquent\Relations\HasMany
     */
    public function slides()
    {
        return $this->hasMany(Slide::class, 'slider_id')->orderBy('order', 'ASC');
    }

    /**
     * HasMany showable slides relation
     *
     * @return \Illuminate\Database\Eloquent\Relations\HasMany
     */
    public function showableSlides()
    {
        $now = \Illuminate\Support\Facades\Date::now();
        return $this->hasMany(Slide::class, 'slider_id')
            ->orderBy('order', 'ASC')->where(function (\Illuminate\Contracts\Database\Query\Builder $q) use ($now): void {
                $q->whereDate('date_start', '<=', $now)
                    ->orWhereNull('date_start');
            })->where(function (\Illuminate\Contracts\Database\Query\Builder $q) use ($now): void {
                $q->whereDate('date_end', '>=', $now)
                    ->orWhereNull('date_end');
            });
    }
}