Guest User

Untitled

a guest
Feb 21st, 2018
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. def self.all_dates
  2. @selected = { "All" => nil }
  3. dates = connection.select_all("SELECT DISTINCT(DATE(submitted)) AS DATE FROM submissions ORDER BY submitted ASC").map {|h| h["DATE"] }
  4. dates.each do |h|
  5. x = h.split('-')
  6. d = "#{Date::MONTHNAMES[x[1].to_i]}, #{x[0]}"
  7. @selected[d] = x[0]+'-'+x[1]
  8. end
  9. return @selected
  10. end
Add Comment
Please, Sign In to add comment