/PHP/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

15 votes163 views6 answers
Confirm password validation in laravel
PHP Laravel
3 votes147 views2 answers
How to redirect a particular user role to a page after login laravel
PHP Laravel
19 votes132 views2 answers
Navigate json decode php
PHP
0 vote141 views1 answer
Shorten long numbers to K/M/B?
PHP
0 vote140 views1 answer
Php curl detect 404
PHP
11 votes180 views2 answers
Wp-config override site url
PHP
0 vote168 views1 answer
Drupal 9 custom blocks dependency injection
PHP Drupal
3 votes110 views1 answer
Laravel use relations in where
PHP Laravel
0 vote134 views2 answers
Twig server
PHP
4 votes159 views2 answers
Ubuntu laravel storage permission
PHP Laravel