/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

0 vote58 views0 answer
PHP
1 vote116 views1 answer
How to save data from api to laravel
PHP Laravel
11 votes166 views5 answers
Php get json array
PHP
5 votes111 views2 answers
Trim elements of array php
PHP
0 vote105 views1 answer
Laravel validating birthdate by 13 years old
PHP
2 votes114 views4 answers
Enable / Disable modules in PHP
PHP
3 votes112 views1 answer
Php foreach string char
PHP
0 vote95 views1 answer
Laravel collection partition
PHP
1 vote99 views2 answers
Php document root
PHP
0 vote60 views1 answer
Application/x-www-form-urlencoded curl php
PHP