From fd742d6fc8849328749866dbff2936d43abcc7d1 Mon Sep 17 00:00:00 2001
From: "bugreport%peshkin.net" <>
Date: Sun, 13 Oct 2002 11:26:02 +0000
Subject: Bug 24789 [E|A|R] Add Estimated, Actual, Remaining Time Fields patch
 by jeff.hedlund@matrixsi.com 2xr=joel,justdave

---
 long_list.cgi | 13 +++++++++++--
 1 file changed, 11 insertions(+), 2 deletions(-)

(limited to 'long_list.cgi')

diff --git a/long_list.cgi b/long_list.cgi
index 6df8a8bad..5047d271e 100755
--- a/long_list.cgi
+++ b/long_list.cgi
@@ -56,7 +56,9 @@ my $generic_query = "
     bugs.target_milestone,
     bugs.qa_contact, 
     bugs.status_whiteboard, 
-    bugs.keywords
+    bugs.keywords,
+    bugs.estimated_time,
+    bugs.remaining_time
   FROM bugs,profiles assign,profiles report, products, components
   WHERE assign.userid = bugs.assigned_to AND report.userid = bugs.reporter
     AND bugs.product_id=products.id AND bugs.component_id=components.id";
@@ -79,7 +81,8 @@ foreach my $bug_id (split(/[:,]/, $buglist)) {
                        "op_sys", "bug_status", "resolution", "priority",
                        "bug_severity", "component", "assigned_to", "reporter",
                        "bug_file_loc", "short_desc", "target_milestone",
-                       "qa_contact", "status_whiteboard", "keywords") 
+                       "qa_contact", "status_whiteboard", "keywords", 
+                       "estimated_time", "remaining_time") 
     {
         $bug{$field} = shift @row;
     }
@@ -91,6 +94,12 @@ foreach my $bug_id (split(/[:,]/, $buglist)) {
 
         push (@bugs, \%bug);
     }
+
+    if (UserInGroup(Param("timetrackinggroup"))) {
+        SendSQL("SELECT SUM(work_time) FROM longdescs WHERE bug_id=$bug_id");
+
+        $bug{'actual_time'} = FetchSQLData();
+    }
 }
 
 # Add the list of bug hashes to the variables
-- 
cgit v1.2.3-24-g4f1b