/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

4 votes231 views3 answers
Delete all records from table using button laravel Eloquent
PHP Laravel
7 votes175 views3 answers
Laravel creat new model
PHP Laravel
2 votes189 views4 answers
How to create controller inside folder in laravel
PHP Laravel
1 vote187 views1 answer
Laravel get first letter of each word
PHP Laravel
0 vote172 views1 answer
How to use union and intersection in laravel query
PHP Laravel
21 votes212 views5 answers
Laravel 7 auth command
PHP Laravel
1 vote177 views3 answers
Laravel artisan command run in route
PHP Laravel
1 vote194 views4 answers
Laravel unique id
PHP Laravel
0 vote179 views5 answers
Laravel authentication in laravel 8
PHP Laravel
6 votes212 views3 answers
Laravel ide helper
PHP Laravel