/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 vote209 views1 answer
Fast excel export laravel
PHP Laravel
1 vote205 views1 answer
DB::connection('local')->create() laravel
PHP Laravel
0 vote226 views1 answer
Country code validation in laravel
PHP Laravel
1 vote221 views1 answer
Laravel inverse seeder
PHP Laravel
0 vote228 views1 answer
Laravel get week dates
PHP Laravel
10 votes207 views4 answers
Laravel table data types
PHP Laravel
2 votes241 views2 answers
Get session id in laravel
PHP Laravel
3 votes229 views2 answers
Allowed memory size of 1610612736 bytes exhausted (tried to allocate 4096 bytes) laravel
PHP Laravel
0 vote238 views1 answer
Laravel on cascade set null
PHP Laravel
0 vote242 views1 answer
Laravel seeding with relationships
PHP Laravel