/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

3 votes150 views1 answer
Laravel get project root
PHP Laravel
0 vote287 views1 answer
Make model inside module laravel
PHP Laravel
0 vote154 views1 answer
Laravel resource command
PHP Laravel
7 votes129 views6 answers
Laravel validation unique email
PHP Laravel
0 vote143 views1 answer
Laravel capsule schema datatime CURRENT_TIMESTAMP
PHP Laravel
9 votes143 views3 answers
Laravel documentation
PHP Laravel
1 vote143 views2 answers
Redirect::route('profile') and with() in laravel
PHP Laravel
0 vote120 views1 answer
Laravel CORS config `allowed_origins` should be an array
PHP Laravel
5 votes147 views3 answers
Laravel validation time hours minutes format
PHP Laravel
0 vote126 views3 answers
Laravel public ParseError syntax error, unexpected '$conversion' (T_VARIABLE), expecting ',' or ')' /
PHP Laravel