[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-commits
Subject:    bugs/bugz
From:       Dirk Mueller <mueller () kde ! org>
Date:       2005-06-05 20:34:09
Message-ID: 1118003649.563016.22748.nullmailer () svn ! kde ! org
[Download RAW message or body]

SVN commit 422579 by mueller:

only list those bugs which have been fixed by a SVN commit
which was not done by the same person like the reporter


 M  +10 -2     weekly-summary-utils.pl  


--- trunk/bugs/bugz/weekly-summary-utils.pl #422578:422579
@@ -372,7 +372,7 @@
     MIN(UNIX_TIMESTAMP(bugs_activity.bug_when)-UNIX_TIMESTAMP(bugs.creation_ts))
         AS open_time
 FROM
-    bugs, bugs_activity, profiles
+    bugs, bugs_activity, profiles, longdescs
 WHERE
     bugs.resolution='FIXED'
 AND
@@ -385,6 +385,14 @@
     bugs_activity.added='FIXED'
 AND
     bugs_activity.who=profiles.userid
+AND
+    bugs.reporter != bugs_activity.who
+AND
+    longdescs.bug_id = bugs.bug_id
+AND
+    longdescs.who = bugs_activity.who
+AND
+    longdescs.thetext like "SVN commit%"
 GROUP BY
     profiles.login_name, bugs.bug_id
 ORDER BY
@@ -397,7 +405,7 @@
     if ($format eq "HTML") {
             # Print a nice cross-referenced table of results.
             print "<table border=\"0\" cellspacing=\"2\" cellpadding=\"5\">\n";
-            print "<tr style=\"background-color: #EEF6FF;\"><th>User</th><th># Resolved</th></tr>\n";
+            print "<tr style=\"background-color: #EEF6FF;\"><th>User</th><th>Elapsed time</th></tr>\n";
     } else {
             print $fh "<bug-fixers>\n";
     }
[prev in list] [next in list] [prev in thread] [next in thread]