/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

5 votes221 views5 answers
Laravel where creation is today carbon
PHP Laravel
0 vote222 views1 answer
How see the list all artisan in laravel
PHP Laravel
0 vote199 views1 answer
WithCount laravel assign generic name
PHP Laravel
1 vote206 views2 answers
Add laravel sail build as alias
PHP Laravel
0 vote210 views1 answer
Write if and else in one line laravel
PHP Laravel
0 vote201 views1 answer
Laravel components scripts
PHP Laravel
0 vote216 views1 answer
Integrity constraint violation laravel socialite google login
PHP Laravel
0 vote219 views1 answer
PaymentIntent::create laravel
PHP Laravel
2 votes209 views1 answer
Laravel ever over https
PHP Laravel
0 vote172 views0 answer
Laravel
PHP Laravel