Merge lp:~clint-fewbar/launchpad-work-items-tracker/server-team-mods into lp:launchpad-work-items-tracker

[Clint Byrum]

Fixed the issues with milestone-only generation and with postponed missing from burndown charts.

=== modified file 'burndown-chart'
--- burndown-chart	2010-09-13 06:50:12 +0000
+++ burndown-chart	2010-09-13 16:35:55 +0000
@@ -156,14 +156,14 @@
     plot10.line_style = None
 
     plot11 = bar_plot.T(label='total', hcol=9)
-    plot10.fill_style = None
-    plot10.line_style = line_style.gray30
+    plot11.fill_style = None
+    plot11.line_style = line_style.gray30
 
     # create the canvas with the specified filename and file format
     can = canvas.init(filename,format)
 
     # add the data to the area and  draw it
-    ar.add_plot(plot2, plot1, plot4, plot3, plot6, plot5, plot7)
+    ar.add_plot(plot2, plot1, plot4, plot3, plot6, plot5, plot8, plot7, plot10, plot9)
     ar.draw()
 
     # create and arrow for the trend line

=== modified file 'report_tools.py'
--- report_tools.py	2010-09-03 05:55:34 +0000
+++ report_tools.py	2010-09-13 16:35:55 +0000
@@ -189,7 +189,7 @@
         cur.execute('SELECT status, date, count(*) FROM work_items w '
                 'WHERE 1=1 %s GROUP BY status, date' % ms_sql)
 
-        for (date, num) in cur:
+        for (s, date, num) in cur:
             data.setdefault(date, {})[s] = num
     return data
 
@@ -235,9 +235,9 @@
         cur.execute('SELECT w.status, s.name, COUNT(DISTINCT w.description), s.status, s.priority, s.implementation, s.url, s.roadmap_notes '
                 'FROM work_items w, specs s '
                 'ON w.spec = s.name '
-                'WHERE w.status = ? AND w.date = ? %s '
+                'WHERE w.date = ? %s '
                 'GROUP BY w.status, w.spec' % ms_sql,
-                (last_date))
+                (last_date,))
 
     for (s, bp, num, status, priority, impl, url, roadmap_notes) in cur:
         info = data.setdefault(bp, {'todo': 0, 'blocked': 0, 'done': 0, 'postponed': 0, 'inprogress': 0})