/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

39 votes130 views6 answers
Foreign key laravel migration
PHP Laravel
0 vote129 views1 answer
Laravel move file from local to s3
PHP Laravel
1 vote115 views1 answer
Create new laravel project ubuntu
PHP Laravel
-1 vote113 views6 answers
How to install bootstrap in laravel 8
PHP Laravel
0 vote114 views1 answer
Laravel resource set status code
PHP Laravel
0 vote121 views2 answers
How to rollback if one table in laravel didn't save data successfully
PHP Laravel
16 votes124 views6 answers
Session laravel
PHP Laravel
0 vote115 views1 answer
@method overide form laravel
PHP Laravel
4 votes125 views1 answer
Laravel install production
PHP Laravel
9 votes127 views6 answers
Laravel validation custom message
PHP Laravel