From 63849bd22996f301b8d63c3c349ffee0f2bb0186 Mon Sep 17 00:00:00 2001
From: "endico%mozilla.org" <>
Date: Fri, 6 Aug 1999 04:21:01 +0000
Subject: Oops. was counting closed bugs too.

---
 reports.cgi | 14 +++++++++++++-
 1 file changed, 13 insertions(+), 1 deletion(-)

(limited to 'reports.cgi')

diff --git a/reports.cgi b/reports.cgi
index 992f60fa3..b8d71cafa 100755
--- a/reports.cgi
+++ b/reports.cgi
@@ -576,7 +576,19 @@ FIN
         my $bugtotal = 0;
         foreach $person (@people)
                 {
-                SendSQL ("select count(bug_id) from bugs,profiles where target_milestone=\"$ms\" and userid=assigned_to and userid=\"$person\"");
+                my $query = "select count(bug_id) from bugs,profiles where target_milestone=\"$ms\" and userid=assigned_to and userid=\"$person\"";
+	        if( $::FORM{'product'} ne "-All-" ) {
+                    $query .= "and    bugs.product='$::FORM{'product'}'";
+                    }
+	        $query .= <<FIN;
+and 	 
+	( 
+	bugs.bug_status = 'NEW' or 
+	bugs.bug_status = 'ASSIGNED' or 
+	bugs.bug_status = 'REOPENED'
+	)
+FIN
+                SendSQL ($query);
 	        my $bugcount = FetchSQLData();
                 $bugsperperson{$person} = $bugcount;
                 $bugtotal += $bugcount;
-- 
cgit v1.2.3-24-g4f1b