/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

15 votes145 views4 answers
Php remove file
PHP
76 votes107 views6 answers
Php string length
PHP
1 vote123 views1 answer
Php get index of current item array_reduce
PHP
0 vote130 views1 answer
Laravel carbon first day of month
PHP Laravel
0 vote142 views1 answer
Object of class stdclass could not be converted to string php laravel
PHP Laravel
1 vote135 views1 answer
Start server in laravel
PHP
1 vote119 views1 answer
Routing code in drupal 8
PHP
2 votes115 views2 answers
Php if $_POST
PHP
1 vote117 views1 answer
PHP | get client ip simple
PHP
0 vote122 views1 answer
Reference — What does this symbol mean in PHP?
PHP