diff options
| author | bugreport%peshkin.net <> | 2002-10-13 13:26:02 +0200 |
|---|---|---|
| committer | bugreport%peshkin.net <> | 2002-10-13 13:26:02 +0200 |
| commit | fd742d6fc8849328749866dbff2936d43abcc7d1 (patch) | |
| tree | 1e4d7646a4589bcf44adceb452b38924286f7af1 /long_list.cgi | |
| parent | f61593bee73b37fc12caabbb2958b6515d688420 (diff) | |
| download | bugzilla-fd742d6fc8849328749866dbff2936d43abcc7d1.tar.gz bugzilla-fd742d6fc8849328749866dbff2936d43abcc7d1.tar.xz | |
Bug 24789 [E|A|R] Add Estimated, Actual, Remaining Time Fields
patch by jeff.hedlund@matrixsi.com
2xr=joel,justdave
Diffstat (limited to 'long_list.cgi')
| -rwxr-xr-x | long_list.cgi | 13 |
1 files changed, 11 insertions, 2 deletions
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 |