/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

0 vote191 views1 answer
Make a global php function in laravel so that accessed anywhere
PHP Laravel
0 vote197 views1 answer
Laravel value eloquent
PHP Laravel
2 votes201 views2 answers
Public_path laravel
PHP Laravel
-1 vote199 views4 answers
How to include file in laravel blade
PHP Laravel
32 votes196 views1 answer
How to count the characters in laravel
PHP Laravel
31 votes191 views6 answers
Laravel update
PHP Laravel
4 votes202 views4 answers
Laravel 8 carbon if date is today
PHP Laravel
6 votes189 views2 answers
Laravel generate key
PHP Laravel
1 vote189 views3 answers
Laravel artisan command run in route
PHP Laravel
0 vote257 views5 answers
Laravel tricks and tips
PHP Laravel