/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

9 votes173 views5 answers
Return view with variable laravel
PHP Laravel
2 votes155 views1 answer
A complete piece of nice and clear PHP code returning JSON
PHP
0 vote172 views3 answers
Laravel load relationship
PHP Laravel
1 vote201 views1 answer
Php routing htaccess
PHP
0 vote114 views1 answer
Php home url
PHP
0 vote147 views2 answers
Laravel notification database
PHP
37 votes151 views6 answers
Carbon now format
PHP
2 votes154 views4 answers
Laravel print query with parameters
PHP
6 votes149 views2 answers
Disable laravel debugbar
PHP
5 votes160 views4 answers
Laravel auth register false
PHP Laravel