/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

0 vote154 views1 answer
Import class route laravel
PHP Laravel
-1 vote153 views1 answer
How to check if there is an authenticated user laravel
PHP Laravel
1 vote163 views1 answer
Convert php array to javascript json laravel
PHP Laravel
0 vote167 views1 answer
Laravel - Add conditional where clause in query
PHP Laravel
6 votes155 views1 answer
Laravel bootstrap ui
PHP Laravel
10 votes172 views4 answers
Laravel table data types
PHP Laravel
0 vote156 views1 answer
Laravel create project with auth 2021
PHP Laravel
4 votes160 views2 answers
Laravel collection count
PHP Laravel
17 votes159 views4 answers
Laravel with trashed
PHP Laravel
3 votes201 views1 answer
Laravel cannot create an instance of class viewmodel
PHP Laravel