gistfile1.txt

def gen_sql
    relation     = Set

    @recipient   ||= "company"
    @date_window ||= "1year"
 


    case @date_window
    when "1day"
      relation = relation.from_to(Time.now - 1.days, Time.now)
    when "1week"
      relation = relation.from_to(Time.now - 7.days, Time.now)
    when "1month"
      relation = relation.from_to(Time.now - 1.month, Time.now)
    when "3month"
      relation = relation.from_to(Time.now - 3.months, Time.now)
    when "6month"
      relation = relation.from_to(Time.now - 6.months, Time.now)
    when "1year"
      relation = relation.from_to(Time.now - 1.year, Time.now)
    end
end