根据节假日显示内容

Question

• ruby 1.9.2p290
• rails 3.1.1

我有这样的模型：

class Recipe < ActiveRecord::Base
 belongs_to :festivity 
end

class Festivity < ActiveRecord::Base
 has_many :recipes 
end

我在“食谱”表中有以下字段：

festivity_id

以及“庆祝活动”表中的下列日期时间字段：

starts_at
ends_at

如何根据节日日期显示内容？

我开始用这种静态的方式思考：

class PagesController < ApplicationController
 def home
  @recipes_by_festivities = Recipe.where(:festivity_id => 4).all(:order => 'RAND()', :limit => 8)
 end
end

例如:在圣诞节期间(大约整个12月)，我想显示一个festivity_id = 1的食谱列表，而在感恩节期间，我只想显示一个festivity_id = 4的菜谱列表。

我说清楚了吗？如果我不告诉我。

溶液

@current_festivity = Festivity.find(:last, :conditions => ["? between starts_at AND ends_at", Time.utc(0,Time.now.month,Time.now.day,0,0,0)])

@recipes_by_festivities = Recipe.where(:festivity_id => @current_festivity).all(:order => 'RAND()', :limit => 8)

Answer 1

这假设starts_at和ends_at与相同的年份(0)一起保存，但如果期间为两年(例如圣诞节时间)，则除外:在这种情况下，ends_at年份必须是1。

Festivity.create(name: 'Christmas time', starts_at: Time.utc(0,12,25,0,0,0), ends_at: Time.utc(1,1,6,23,59,59))
Festivity.create(name: 'Ferragosto', starts_at: Time.utc(0,8,15,0,0,0), ends_at: Time.utc(0,8,15,23,59,59))

Recipe.create(festivity: Festivity.find_by_name('Periodo natalizio'))
Recipe.create(festivity: Festivity.find_by_name('Ferragosto'))

# Searching for festivities today
Recipe.includes(:festivity).where(['? BETWEEN festivities.starts_at AND festivities.ends_at', Time.utc(0,Time.now.month,Time.now.day,12,0,0)]).all
# Searching for festivities on 15 August (in Italy there is a festivity that is called Ferragosto)
Recipe.includes(:festivity).where(['? BETWEEN festivities.starts_at AND festivities.ends_at', Time.utc(0,8,15,12,0,0)]).all
# Searching for festivities on 28 December
Recipe.includes(:festivity).where(['? BETWEEN festivities.starts_at AND festivities.ends_at', Time.utc(0,12,28,12,0,0)]).all

这是一种可能的功能实现：

def recipes_on(day, month)
  Recipe.includes(:festivity).where(['? BETWEEN festivities.starts_at AND festivities.ends_at', Time.utc(0,month,day,12,0,0)]).all
end

Answer 2

我要做的是在“节日”表中创建一个“名称”字段，然后使用节假日宝石来确定某个特定日期是否有假日。

Holdays.on(Date.today)

它将返回一个散列列表:每个散列都有一个名称键。然后您可以使用它来查找正确的Festivity对象current_festival = Festivies.where(:name => Holdays.on(Date.today)[0][:name])，然后从那里得到菜谱：current_festival.recipes

Answer 3

因为你想通过庆祝活动找到食谱，所以你可以这样做：

def home
  festivity_today = some_custom_festivity_lookup(Time.now)
  if !festivity_today.nil?
    @recipes = Recipe.where(festivity_id: festivity_today.id).limit(8)
  else
    @recipes = Recipe.limit(8)
  end
end