/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

1 vote274 views1 answer
Laravel order by raw
PHP Laravel
1 vote255 views1 answer
Groupby in laravel with count
PHP Laravel
2 votes298 views1 answer
Create laravel project old version
PHP Laravel
5 votes221 views6 answers
Laravel sort collection
PHP Laravel
4 votes248 views5 answers
Laravel route multiple middleware
PHP Laravel
1 vote251 views1 answer
Laravel insert or ignore
PHP Laravel
3 votes267 views1 answer
Get soft deleted data laravel
PHP Laravel
4 votes247 views2 answers
Switch in laravel
PHP Laravel
0 vote259 views1 answer
Polymorph laravel return order by
PHP Laravel
-1 vote248 views1 answer
Ziparchive laravel not found
PHP Laravel