/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 vote194 views1 answer
Comparison of two tables in laravel using model
PHP Laravel
1 vote133 views1 answer
Date format in laravel month name day name
PHP Laravel
3 votes155 views2 answers
How to check null and empty array in laravel 8
PHP Laravel
4 votes146 views2 answers
Numbric validate laravel
PHP Laravel
0 vote159 views1 answer
Store image to s3 laravel
PHP Laravel
4 votes140 views1 answer
Use str laravel
PHP Laravel
28 votes199 views12 answers
Laravel middleware
PHP Laravel
-1 vote149 views4 answers
How to include file in laravel blade
PHP Laravel
4 votes140 views1 answer
Uuid nom package for laravel 18.04
PHP Laravel
1 vote138 views1 answer
Check which database connect laravel
PHP Laravel