calculate average in eager loading laravel

Solutions on MaxInterview for calculate average in eager loading laravel by the best coders in the world

showing results for - "calculate average in eager loading laravel"

09 Feb 2020

1public function reviewRows()
2{
3    return $this->hasManyThrough('ReviewRow', 'Review');
4}
5
6public function avgRating()
7{
8    return $this->reviewRows()
9      ->selectRaw('avg(rating) as aggregate, product_id')
10      ->groupBy('product_id');
11}
12
13public function getAvgRatingAttribute()
14{
15    if ( ! array_key_exists('avgRating', $this->relations)) {
16       $this->load('avgRating');
17    }
18
19    $relation = $this->getRelation('avgRating')->first();
20
21    return ($relation) ? $relation->aggregate : null;
22}
23

source

similar questions

laravel get nested relationships data with eager loading how do we calculate average in laravel 8 php ffi get load average throttle laravel counting time execution duration in time laravel laravel eager loading closure laravel eager loading where clause slow laravel testing laravel get average from a column lazy loading in laravel optimistic locking laravel avg rating get in join in laravel 8 time left laravel seconds laravel artisan progress bar laravel display the date the participation was created laravel throttle

queries leading to this page

get average rating with eager loading in laravel calculate average in eager loading laravel calculate average in eager loading laravel