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

1 vote290 views1 answer
How change the languge of fie manager in laravel
PHP
13 votes276 views3 answers
Php check for null
PHP
0 vote292 views1 answer
Doctrine orm refresh
PHP
1 vote246 views2 answers
$validator = Validator::make($request->all(), [
PHP
0 vote233 views1 answer
Eloquent value
PHP
0 vote330 views1 answer
Laravel validation rules for video upload
PHP Laravel
0 vote307 views1 answer
Laravel eloquent with query parameter
PHP
21 votes286 views2 answers
Php delete element by value
PHP
0 vote297 views2 answers
Laravel storage link without command line
PHP Laravel
1 vote300 views1 answer
Popular cms
PHP