/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 vote319 views1 answer
NAME OF YOUR FORM in contact form 7
PHP
1 vote337 views1 answer
Hex to bin php
PHP
31 votes392 views6 answers
Update or create laravel
PHP
0 vote378 views1 answer
Laravel count data wise
PHP Laravel
4 votes375 views3 answers
Laravel view routes
PHP
0 vote362 views1 answer
How To Clear Laravel.Log In Laravel?
PHP
0 vote405 views1 answer
Laravel update single field
PHP Laravel
2 votes341 views4 answers
In date function + 1 month and - 1 day in php
PHP
0 vote429 views1 answer
Laravel reload relationship
PHP Laravel
0 vote327 views1 answer
Php fpdf in phpmailer
PHP