/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 vote146 views1 answer
Laravel factory get foreign key
PHP Laravel
0 vote158 views1 answer
Get basename without extension Laravel
PHP Laravel
1 vote152 views1 answer
Laravel server sent events
PHP Laravel
0 vote171 views2 answers
Pass guzzle client data to view laravel
PHP Laravel
0 vote182 views1 answer
Laravel env pgsql
PHP Laravel
0 vote164 views1 answer
Laravel signed Route custom domain
PHP Laravel
0 vote231 views1 answer
Laravel timestamps on pivot table
PHP Laravel
0 vote148 views1 answer
Laravel collection median
PHP Laravel
1 vote149 views1 answer
Laravel query get big table records
PHP Laravel
0 vote161 views1 answer
Setup cron on macos for laravel
PHP Laravel