如何按评级排序我的唱片部分？

发布于 2024-11-06 20:47:06 字数 324 浏览 0 评论 0原文

我有一个场地表，其中每个场地都有很多评论，并且每个评论都有一个评级 (1-5)，我的场地索引页面当前将所有场地按照创建顺序显示为部分场地，最旧的位于顶部，我该如何更改这是为了在顶部显示平均评分最高的场馆吗？

我的场地控制器索引目前如下所示：

  def index
    if
      @venues = Venue.with_type(params[:venuetypes]).with_area(params[:areas])
    else
      @venues = Venue.all
    end
  end

感谢您的帮助！

原文

I have a table of venues where each has many reviews and each review has a rating (1-5), my venue index page currently shows all the venues as partials in the order they were created with the oldest at the top how can I change this to display the venues with the highest average rating at the top?

My venues controller index currently looks like this:

  def index
    if
      @venues = Venue.with_type(params[:venuetypes]).with_area(params[:areas])
    else
      @venues = Venue.all
    end
  end

Thanks for any help!

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

你爱我像她 2024-11-13 20:47:07

使用 Rails 3？这是一个起点。

def index
  if
    @venues = Venue.with_type(params[:venuetypes]).with_area(params[:areas]).joins(:reviews).order("reviews.rating DESC")
  else
    @venues = Venue.joins(:reviews).order("reviews.rating DESC").all
  end
end

Using Rails 3? Here's a starting point.

def index
  if
    @venues = Venue.with_type(params[:venuetypes]).with_area(params[:areas]).joins(:reviews).order("reviews.rating DESC")
  else
    @venues = Venue.joins(:reviews).order("reviews.rating DESC").all
  end
end

回复收藏 0 原文

~没有更多了~