<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Collection;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Relations\HasMany;
use Illuminate\Database\Eloquent\Relations\HasOne;
/**
* Class Category
*
* @property int id
* @property int sort
* @property int parent_id
* @property string name
* @property int count_blogs
* @property int closed
* @property Collection children
*/
class Category extends BaseModel
{
/**
* Indicates if the model should be timestamped.
*
* @var bool
*/
public $timestamps = false;
/**
* The attributes that aren't mass assignable.
*
* @var array
*/
protected $guarded = [];
/**
* Возвращает связь родительской категории
*
* @return BelongsTo
*/
public function parent(): BelongsTo
{
return $this->belongsTo(self::class, 'parent_id')->withDefault();
}
/**
* Возвращает связь подкатегорий
*
* @return HasMany
*/
public function children(): HasMany
{
return $this->hasMany(self::class, 'parent_id')->orderBy('sort');
}
/**
* Возвращает количество статей за последние 3 дня
*
* @return hasOne
*/
public function new(): hasOne
{
return $this->hasOne(Blog::class, 'category_id')
->selectRaw('category_id, count(*) as count_blogs')
->where('created_at', '>', strtotime('-3 day', SITETIME))
->groupBy('category_id');
}
}