Просмотр файла app/Models/Blog.php

<?php

declare(strict_types=1);

namespace App\Models;

use App\Traits\CategoryTreeTrait;
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_articles
 * @property int    $closed
 * @property-read Blog             $parent
 * @property-read Collection<Blog> $children
 */
class Blog extends BaseModel
{
    use CategoryTreeTrait;

    /**
     * Indicates if the model should be timestamped.
     */
    public $timestamps = false;

    /**
     * The attributes that aren't mass assignable.
     */
    protected $guarded = [];

    /**
     * Возвращает связь родительской категории
     */
    public function parent(): BelongsTo
    {
        return $this->belongsTo(self::class, 'parent_id')->withDefault();
    }

    /**
     * Возвращает связь подкатегорий
     */
    public function children(): HasMany
    {
        return $this->hasMany(self::class, 'parent_id')->orderBy('sort');
    }

    /**
     * Возвращает количество статей за последние 3 дня
     */
    public function new(): hasOne
    {
        return $this->hasOne(Article::class, 'category_id')
            ->active()
            ->selectRaw('category_id, count(*) as count_articles')
            ->where('created_at', '>', strtotime('-3 day', SITETIME))
            ->groupBy('category_id');
    }

    /**
     * Возвращает статьи
     */
    public function articles(): HasMany
    {
        return $this->hasMany(Article::class, 'category_id');
    }

    /**
     * Возвращает последнюю статью
     */
    public function lastArticle(): hasOne
    {
        return $this->hasOne(Article::class, 'category_id')
            ->active()
            ->latest('created_at')
            ->limit(1);
    }

    /**
     * Пересчет раздела
     */
    public function restatement(): void
    {
        $this->update([
            'count_articles' => $this->articles()->active()->count(),
        ]);
    }
}