/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

4 votes270 views2 answers
Laravel duplicate row
PHP Laravel
8 votes318 views1 answer
Laravel show routes artisan
PHP Laravel
2 votes278 views2 answers
Laravel create migration file
PHP Laravel
1 vote296 views2 answers
Db name laravel
PHP Laravel
0 vote324 views1 answer
Laravel denny request by ip
PHP Laravel
0 vote358 views1 answer
Laravel imap - Set message flags
PHP Laravel
1 vote384 views1 answer
How laravel return the old value
PHP Laravel
8 votes298 views6 answers
Laravel command not found
PHP Laravel
8 votes340 views4 answers
Get single column value in laravel eloquent
PHP Laravel
0 vote334 views1 answer
Laravel env pgsql
PHP Laravel