/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 vote207 views1 answer
Factorial in php
PHP
0 vote215 views1 answer
Laraverl add collect
PHP Laravel
6 votes235 views4 answers
Php check if string is integer
PHP
1 vote234 views1 answer
Extract all arrays from sql response in php
PHP
17 votes310 views3 answers
Laravel make model controller and migration one time
PHP Laravel
17 votes311 views5 answers
Wordpress debug mode
PHP Wordpress
0 vote244 views1 answer
Use php artisan command through controller
PHP
0 vote227 views2 answers
Php curl ssl certificate problem
PHP
1 vote232 views1 answer
Laravel Squashing Migrations
PHP
0 vote233 views1 answer
Your Composer dependencies require the following PHP extensions to be installed: dom, xml, xmlwriter
PHP