/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

2 votes334 views4 answers
Strict types php
PHP
1 vote352 views1 answer
Group_concat laravel
PHP
0 vote356 views2 answers
How to fix Column not found: 1054 Unknown column 'api_token' in 'where clause' (SQL: select * from `users` where `api_token laravel
PHP
1 vote365 views1 answer
Img src php wordpress
PHP Wordpress
33 votes355 views6 answers
Laravel query builder
PHP Laravel
0 vote341 views1 answer
Menampilkan hari dan tanggal sekarang di php
PHP
0 vote334 views2 answers
Warning: parameter 2 to search_by_title() expected to be a reference, value given inwp-includes\class-wp-hook.php on line 287
PHP
0 vote343 views1 answer
Messagebird php curl send sms example
PHP
0 vote467 views1 answer
Laravel 8 Factory - One To Many (Polymorphic) Relationship
PHP Laravel
0 vote379 views1 answer
Running a laravel app locally
PHP Laravel