/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 vote221 views2 answers
Laravel rename file ftp
PHP Laravel
7 votes225 views2 answers
Date time format for laravel validation
PHP Laravel
15 votes244 views6 answers
Laravel migration delete column
PHP Laravel
0 vote218 views1 answer
Composer create-project --prefer-dist laravel/laravel blog
PHP Laravel
1 vote188 views1 answer
Custom column for latest() laravel
PHP Laravel
1 vote270 views4 answers
Laravel scheduler run
PHP Laravel
1 vote225 views1 answer
Default index page for laravel in cpanel
PHP Laravel
28 votes228 views6 answers
Laravel make model with migration
PHP Laravel
56 votes560 views6 answers
Laravel seeder
PHP Laravel
7 votes285 views1 answer
Laravel db seed specific class
PHP Laravel