/PHP/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

4 votes115 views2 answers
Laravel reduce
PHP Laravel
1 vote121 views1 answer
Syntax error or access violation: 1072 Key column 'user_id' doesn't exist in table (SQL: alter table `groups` add constraint `groups_user_id_foreign` foreign key (`user_id`) references `users` (`id`))
PHP
1 vote114 views1 answer
Used resoure route how to add another route
PHP
0 vote103 views1 answer
Php median
PHP
2 votes119 views1 answer
Laravel crud generator
PHP Laravel
0 vote107 views1 answer
Order table in laravel
PHP
0 vote96 views2 answers
PHP check if url parameter exists
PHP
12 votes155 views6 answers
Laravel api routes
PHP
2 votes123 views2 answers
Laravel get public path url
PHP Laravel
8 votes67 views2 answers
Laravel password hash online
PHP Laravel