/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

2 votes201 views1 answer
Create laravel project old version
PHP Laravel
8 votes222 views2 answers
Laravel drop multiple columns
PHP Laravel
10 votes185 views2 answers
Laravel collection toArray
PHP Laravel
5 votes192 views3 answers
Mobile number validation in laravel 8
PHP Laravel
0 vote172 views1 answer
Laravel csrf token or protection or laravel form
PHP Laravel
12 votes171 views5 answers
Laravel run single migration
PHP Laravel
6 votes162 views4 answers
Laravel blade foreach index value
PHP Laravel
0 vote178 views1 answer
Laravel.log" could not be opened in append mode
PHP Laravel
2 votes124 views2 answers
Laravel select query return array
PHP Laravel
0 vote217 views7 answers
Laravel eloquent tricks
PHP Laravel