Front Page Ordering

[rtucker-mozilla]

IRC notes:

• open events should be first.
  • "open", as in, "not starting in the future, and not status closed"
  • emergencies before scheduled maintenance
• upcoming events should be second.
  • ordered soonest (tomorrow) first, furthest (next month) last
  • no specific priority sorting
• past events should be last
  • ordered newest (yesterday) first, oldest (last year) last
  • no specific priority sorting

[rtucker-mozilla]

This needs some housekeeping SQL:

alter table whistlepig_severity add column sort_order int not null default 0; alter table whistlepig_status add column sort_order int not null default 0; update whistlepig_status set sort_order = 1 where name = 'Open'; update whistlepig_status set sort_order = 2 where name = 'Upcoming'; update whistlepig_status set sort_order = 3 where name = 'Resolved'; update whistlepig_severity set sort_order = 1 where name = 'Emergency'; update whistlepig_severity set sort_order = 2 where name = 'Downtime Expected'; update whistlepig_severity set sort_order = 3 where name = 'No Downtime';