Hi, On Tue, May 31, 2011 at 10:26:21AM +0200, Lucas Nussbaum wrote: > Applied, the data will be re-imported during the next 24h hours. Thanks! I've also patched bugs.cgi to accept sorting by done_date, you can apply if interested. Kind regards, Ryan
From cf84bfa3545811e9baf64fb32f425aea934c79a6 Mon Sep 17 00:00:00 2001
From: Ryan Kavanagh <ryanakca@kubuntu.org>
Date: Wed, 1 Jun 2011 07:32:06 -0400
Subject: [PATCH] Updated bugs.cgi to include done_date as a sorting option
---
web/bugs.cgi | 9 +++++++--
1 files changed, 7 insertions(+), 2 deletions(-)
diff --git a/web/bugs.cgi b/web/bugs.cgi
index 28f3ee4..9f9856e 100755
--- a/web/bugs.cgi
+++ b/web/bugs.cgi
@@ -63,6 +63,7 @@ SORTS = [
['source', 'source package'],
['package', 'binary package'],
['last_modified', 'last modified'],
+ ['done_date', 'done date'],
['severity', 'severity'],
['popcon', 'popularity contest'],
]
@@ -279,9 +280,9 @@ tstart = Time::now
dbh = DBI::connect('DBI:Pg:dbname=udd;port=5441;host=localhost', 'guest')
dbh.execute("SET statement_timeout TO 90000")
if cols['cpopcon']
- q = "select id, bugs.package, bugs.source, severity, title, last_modified, affects_stable, affects_testing, affects_unstable, affects_experimental, coalesce(popcon_src.insts, 0) as popcon\nfrom bugs left join popcon_src on (bugs.source = popcon_src.source) \n"
+ q = "select id, bugs.package, bugs.source, severity, title, last_modified, done_date, affects_stable, affects_testing, affects_unstable, affects_experimental, coalesce(popcon_src.insts, 0) as popcon\nfrom bugs left join popcon_src on (bugs.source = popcon_src.source) \n"
else
- q = "select id, bugs.package, bugs.source, severity, title, last_modified, affects_stable, affects_testing, affects_unstable, affects_experimental from bugs \n"
+ q = "select id, bugs.package, bugs.source, severity, title, last_modified, done_date, affects_stable, affects_testing, affects_unstable, affects_experimental from bugs \n"
end
q += "where #{RELEASE_RESTRICT.select { |r| r[0] == release }[0][2]} \n"
FILTERS.each do |f|
@@ -392,6 +393,7 @@ puts '<th>claimed by</th>' if cols['cclaimed']
puts '<th>deferred</th>' if cols['cdeferred']
puts '<th>RT tag</th>' if cols['crttags']
puts '<th>last modified</th></tr>'
+puts '<th>done date</th></tr>'
def genhints(source, hints)
return '' if hints.nil?
@@ -478,6 +480,9 @@ rows.each do |r|
d = r['last_modified']
d = Date::new(d.year, d.month, d.day)
puts "<td style='text-align: center;'>#{d}</td></tr>"
+ dd = r['done_date']
+ dd = Date::new(dd.year, dd.month, dd.day)
+ puts "<td style='text-align: center;'>#{dd}</td></td>
end
puts "</table>"
--
1.7.5.3
Attachment:
signature.asc
Description: Digital signature