/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 vote323 views1 answer
Centos 8 laravel permission denied
PHP
0 vote305 views1 answer
Comment supprimer les avis sur les produits de votre boutique WooCommerce
PHP
0 vote265 views1 answer
Php $_session err_miss_cache
PHP
0 vote275 views1 answer
Php object into nested json object
PHP
1 vote248 views1 answer
Invalid datetime format 1292
PHP
0 vote301 views1 answer
How to set db table type in laravel
PHP
0 vote260 views1 answer
Creer un modele laravel
PHP
18 votes239 views5 answers
Create model, controller and migration in single command laravel
PHP
98 votes314 views6 answers
Php check if string contains
PHP
0 vote262 views1 answer
Unknown column type "double" requested. Any Doctrine type that you use has to be registered with \Doctrine\DBAL\Types\Type::addType
PHP