/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 vote350 views3 answers
Laravel Eloquent sum of multiplied columns
PHP Laravel
0 vote326 views1 answer
Laravel migrate test environment
PHP Laravel
3 votes297 views1 answer
Laravel middleware route
PHP Laravel
0 vote382 views2 answers
How to use flash message in laravel
PHP Laravel
18 votes325 views4 answers
Create model view controller laravel
PHP Laravel
3 votes336 views2 answers
How to change laravel port
PHP Laravel
0 vote321 views1 answer
Laravel eloquent select one column
PHP Laravel
0 vote331 views1 answer
Db connection postgres laravel
PHP Laravel
1 vote336 views1 answer
Laravel search data relationship
PHP Laravel
0 vote371 views1 answer
Laravel imap - Set message flags
PHP Laravel