/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

6 votes198 views4 answers
Unique check with multiple columns laravel validation
PHP Laravel
13 votes178 views6 answers
Route group in laravel
PHP Laravel
31 votes203 views6 answers
Make model with migration laravel
PHP Laravel
0 vote192 views1 answer
Laravel orm latest()
PHP Laravel
0 vote200 views1 answer
Spatie/laravel-activitylog display only changed data
PHP Laravel
2 votes191 views2 answers
Get all sort by laravel
PHP Laravel
0 vote205 views3 answers
Laravel where json array column
PHP Laravel
0 vote185 views1 answer
Laravel observer check if field changed
PHP Laravel
0 vote189 views1 answer
Case inside laravel query
PHP Laravel
6 votes175 views5 answers
Laravel collection map
PHP Laravel