如何使用 ActiveRecord 按星期几排序? [英] How to order by day of the week using ActiveRecord?

问题描述

在我的控制器中，我有:

In my controller I have:

  def index
    @event = Event.all(:order => 'id DESC')
  end

我有一个名为 Day 的属性，其内容如下:星期一、星期二、星期三...等

I have an attribute called Day with the following: Monday, Tuesday, Wednesday... etc.

如何返回按星期几排序的事件?

How do I return Events ordered by day of the week?

注意:我知道这效率不高，但我有我的理由.

Note: I know this is not efficient, but I have my reasons.

推荐答案

def index
  @event = Event.all(:order => 'CASE Day WHEN "Monday" THEN 1 WHEN "Tuesday" THEN 2 WHEN "Wednesday" THEN 3 WHEN "Thursday" THEN 4 WHEN "Friday" THEN 5 WHEN "Saturday" THEN 6 WHEN "Sunday" THEN 7 END')
end

这篇关于如何使用 ActiveRecord 按星期几排序?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！