Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def self.all_dates
- @selected = { "All" => nil }
- dates = connection.select_all("SELECT DISTINCT(DATE(submitted)) AS DATE FROM submissions ORDER BY submitted ASC").map {|h| h["DATE"] }
- dates.each do |h|
- x = h.split('-')
- d = "#{Date::MONTHNAMES[x[1].to_i]}, #{x[0]}"
- @selected[d] = x[0]+'-'+x[1]
- end
- return @selected
- end
Add Comment
Please, Sign In to add comment