/PHP/Laravel/Laravel eloquent relationships count

Laravel eloquent relationships count

class Category extends Model
{

    protected $appends = [
        'articleCount'
    ];

    public function articles()
    {
        return $this->hasMany(Article::class);
    }

    public function children()
    {
        return $this->hasMany(Category::class, 'parent_id');
    }

    public function childrenArticles()
    {
        return $this->hasManyThrough(Article::class, Category::class, 'parent_id');
    }

    public function getArticleCountAttribute()
    {
        return $this->articles()->count() + $this->childrenArticles()->count();
    }
}

Source: stackoverflow.com

Similar codes

1 vote139 views2 answers
Laravel migration check if table has column
PHP Laravel
7 votes497 views3 answers
Laravel active menu item
PHP Laravel
0 vote87 views1 answer
Laravel sanctum Protecting routes
PHP Laravel
1 vote141 views1 answer
How to check the laravel version mac
PHP Laravel
8 votes129 views3 answers
Force delete soft delete laravel
PHP Laravel
0 vote140 views1 answer
Add custom attribute for validation errors laravel
PHP Laravel
0 vote131 views1 answer
Laravel throw 503
PHP Laravel
0 vote123 views1 answer
Laravel collection splice
PHP Laravel
0 vote122 views2 answers
Collection get first element laravel
PHP Laravel
3 votes148 views6 answers
Laravel find query
PHP Laravel