/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 votes160 views1 answer
How send user to 404 page if not exist page in laravel
PHP Laravel
0 vote151 views1 answer
How to validate multi image upload in laravel
PHP Laravel
2 votes172 views1 answer
Laravel validate integer between
PHP Laravel
0 vote155 views1 answer
Laravel override eloquent all function
PHP Laravel
0 vote155 views1 answer
How to execute “php artisan migrate” and other Laravel commands in remote server?
PHP Laravel
46 votes196 views5 answers
Add column migration laravel
PHP Laravel
0 vote168 views1 answer
Eager load relationships by default in the model laravel
PHP Laravel
1 vote168 views2 answers
Where clause with paginate laravel multiple column
PHP Laravel
0 vote180 views1 answer
Laravel share
PHP Laravel
4 votes151 views4 answers
Multiple middleware laravel
PHP Laravel