66 lines
1.6 KiB
PHP
66 lines
1.6 KiB
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');
|
|
});
|
|
}
|
|
}
|