/PHP/Laravel/Calculate average in eager loading laravel

Calculate average in eager loading laravel

public function reviewRows()
{
    return $this->hasManyThrough('ReviewRow', 'Review');
}

public function avgRating()
{
    return $this->reviewRows()
      ->selectRaw('avg(rating) as aggregate, product_id')
      ->groupBy('product_id');
}

public function getAvgRatingAttribute()
{
    if ( ! array_key_exists('avgRating', $this->relations)) {
       $this->load('avgRating');
    }

    $relation = $this->getRelation('avgRating')->first();

    return ($relation) ? $relation->aggregate : null;
}

Source: stackoverflow.com

Similar codes

5 votes185 views4 answers
Laravel response redirect
PHP Laravel
0 vote204 views3 answers
Laravel package console command
PHP Laravel
12 votes169 views4 answers
Laravel call controller method from another controller
PHP Laravel
15 votes174 views6 answers
Laravel migration default value
PHP Laravel
2 votes186 views1 answer
How get all files name in one folder in laravel
PHP Laravel
27 votes166 views3 answers
How to migrate a specific table in laravel
PHP Laravel
1 vote177 views1 answer
Scedule work laravel
PHP Laravel
0 vote171 views1 answer
Why phpunit don't work in commend laravel
PHP Laravel
3 votes187 views2 answers
Set image asset path in laravel
PHP Laravel
3 votes179 views1 answer
Laravel find by
PHP Laravel