/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

13 votes271 views5 answers
How to change validation message in laravel
PHP Laravel
1 vote275 views1 answer
Laravel increment column value in update query
PHP Laravel
0 vote265 views1 answer
Determining if input is present in Laravel
PHP Laravel
4 votes261 views2 answers
Laravel carbon get month name español
PHP Laravel
1 vote305 views1 answer
Laravel set config value dynamically
PHP Laravel
9 votes284 views6 answers
Laravel current url
PHP Laravel
18 votes284 views4 answers
Create model view controller laravel
PHP Laravel
0 vote252 views1 answer
Get base class name laravel
PHP Laravel
3 votes307 views1 answer
Generate autodump laravel
PHP Laravel
1 vote252 views5 answers
Laravel collection methods
PHP Laravel