/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 vote356 views1 answer
Check for headers laravel
PHP Laravel
0 vote388 views1 answer
Laravel collection namespace
PHP Laravel
0 vote330 views1 answer
Composer create-project --prefer-dist laravel/laravel blog
PHP Laravel
8 votes337 views5 answers
Laravel belongs to
PHP Laravel
1 vote364 views4 answers
Laravel unique id
PHP Laravel
24 votes361 views6 answers
Laravel get auth user id
PHP Laravel
1 vote368 views2 answers
How console log laravel
PHP Laravel
5 votes392 views3 answers
Merge collections laravel
PHP Laravel
0 vote380 views1 answer
Laravel get only validated data
PHP Laravel
0 vote356 views1 answer
Optimize clear laravel not working
PHP Laravel