/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

0 vote194 views1 answer
Add another column in a table in laravel
PHP Laravel
1 vote190 views1 answer
Date casting from datetime to d-m-Y laravel using cast
PHP Laravel
2 votes219 views2 answers
How to store file in public folder laravel
PHP Laravel
0 vote197 views1 answer
Laravel collection flip
PHP Laravel
1 vote368 views2 answers
Laravel 8 livewire tutorial
PHP Laravel
1 vote228 views4 answers
Laravel queue timeout
PHP Laravel
4 votes263 views2 answers
Laravel sum group by
PHP Laravel
8 votes203 views4 answers
Get single column value in laravel eloquent
PHP Laravel
0 vote219 views2 answers
Registration welcome email laravel
PHP Laravel
12 votes198 views6 answers
Laravel where and where
PHP Laravel