return averageRating with models collection

[BechirAhmed]

It would be nice to be able to return the average ratings with models. This would allow us to show the average ratings in a models list;
for ex. $posts = Post::with('averageRating')->get();
or something like that

[codebyray]

You could write a simple query to do this now:

SELECT reviewrateable_id, AVG(rating) AS avgRating FROM reviews GROUP BY reviewrateable_id;

This particular query would give you the average overall rating for each model that has been rated. Could do the same for each of the other rating fields.

And if you wanted to get an average rating >= 3 you could do something like this:

SELECT reviewrateable_id, AVG(rating) AS avgRating FROM reviews GROUP BY reviewrateable_id HAVING AVG(rating) >= 3;

Hope this gets you pointed in the right direction.

I like the idea and will note to add that in the next release.

Regards,
Ray

[BechirAhmed]

Okay thanks, We are waiting for the next release, good luck!