From cd6211de678a3638f2813332d436d6e4844d3d60 Mon Sep 17 00:00:00 2001 From: "travis%sedsystems.ca" <> Date: Mon, 24 Jan 2005 13:20:49 +0000 Subject: Bug 201818 : Convert long_list.cgi to a format Patch by Rob Siklos r=wurblzap, glob a=myk --- buglist.cgi | 2 +- long_list.cgi | 105 ++------------------- template/en/default/bug/knob.html.tmpl | 2 +- template/en/default/bug/show-multiple.html.tmpl | 20 ++-- .../en/default/global/site-navigation.html.tmpl | 2 +- template/en/default/list/list.html.tmpl | 7 +- 6 files changed, 28 insertions(+), 110 deletions(-) diff --git a/buglist.cgi b/buglist.cgi index 2e14c6427..9c2632359 100755 --- a/buglist.cgi +++ b/buglist.cgi @@ -863,7 +863,7 @@ if (@bugidlist) { # Define the variables and functions that will be passed to the UI template. $vars->{'bugs'} = \@bugs; -$vars->{'buglist'} = join(',', @bugidlist); +$vars->{'buglist'} = \@bugidlist; $vars->{'columns'} = $columns; $vars->{'displaycolumns'} = \@displaycolumns; diff --git a/long_list.cgi b/long_list.cgi index c3abbafcf..04758729d 100755 --- a/long_list.cgi +++ b/long_list.cgi @@ -24,108 +24,17 @@ use strict; use lib qw(.); -use Bugzilla; - require "CGI.pl"; -use vars qw($userid @legal_keywords); - -# Use global template variables. -use vars qw($template $vars); - -Bugzilla->login(); - -GetVersionTable(); - -my $cgi = Bugzilla->cgi; - -my $generic_query = " - SELECT - bugs.bug_id, - COALESCE(bugs.alias, ''), - classifications.name, - products.name, - bugs.version, - bugs.rep_platform, - bugs.op_sys, - bugs.bug_status, - bugs.resolution, - bugs.priority, - bugs.bug_severity, - components.name, - assign.login_name, - report.login_name, - bugs.bug_file_loc, - bugs.short_desc, - bugs.target_milestone, - bugs.qa_contact, - bugs.status_whiteboard, - bugs.keywords, - bugs.estimated_time, - bugs.remaining_time, - date_format(creation_ts,'%Y.%m.%d %H:%i'), - date_format(bugs.deadline, '%Y-%m-%d') - FROM bugs,profiles assign,profiles report, classifications, 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 - AND products.classification_id = classifications.id"; - -my $buglist = $cgi->param('buglist') || - $cgi->param('bug_id') || - $cgi->param('id') || ""; - -my @bugs; +our $cgi; -foreach my $bug_id (split(/[:,]/, $buglist)) { - detaint_natural($bug_id) || next; - Bugzilla->user->can_see_bug($bug_id) || next; - SendSQL("$generic_query AND bugs.bug_id = $bug_id"); +# Convert comma/space separated elements into separate params +my @ids = (); - my %bug; - my @row = FetchSQLData(); - - foreach my $field ("bug_id", "alias", "classification", "product", - "version", "rep_platform", - "op_sys", "bug_status", "resolution", "priority", - "bug_severity", "component", "assigned_to", "reporter", - "bug_file_loc", "short_desc", "target_milestone", - "qa_contact", "status_whiteboard", "keywords", - "estimated_time", "remaining_time", "creation_ts", - "deadline") - { - $bug{$field} = shift @row; - } - - if ($bug{'bug_id'}) { - $bug{'comments'} = GetComments($bug{'bug_id'}); - $bug{'qa_contact'} = $bug{'qa_contact'} > 0 ? - DBID_to_name($bug{'qa_contact'}) : ""; - - push (@bugs, \%bug); - } - - if (UserInGroup(Param("timetrackinggroup"))) { - SendSQL("SELECT SUM(work_time) FROM longdescs WHERE bug_id=$bug_id"); - - $bug{'actual_time'} = FetchSQLData(); - } +if (defined $cgi->param('buglist')) { + @ids = split (/[, ]+/, $cgi->param('buglist')); } -# Add the list of bug hashes to the variables -$vars->{'bugs'} = \@bugs; - -$vars->{'use_keywords'} = 1 if (@::legal_keywords); - -$vars->{'str2time'} = \&str2time; - -# Work out a sensible filename for Content-Disposition. -# Sadly, I don't think we can tell if this was a named query. -my @time = localtime(time()); -my $date = sprintf "%04d-%02d-%02d", 1900+$time[5],$time[4]+1,$time[3]; -my $filename = "bugs-$date.html"; - -print $cgi->header(-content_disposition => "inline; filename=$filename"); +my $ids = join('', map { $_ = "&id=" . $_ } @ids); -# Generate and return the UI (HTML page) from the appropriate template. -$template->process("bug/show-multiple.html.tmpl", $vars) - || ThrowTemplateError($template->error()); +print $cgi->redirect("show_bug.cgi?format=multiple$ids"); diff --git a/template/en/default/bug/knob.html.tmpl b/template/en/default/bug/knob.html.tmpl index 035db1ae5..463132f9f 100644 --- a/template/en/default/bug/knob.html.tmpl +++ b/template/en/default/bug/knob.html.tmpl @@ -168,7 +168,7 @@ View [% terms.Bug %] Activity   |   - Format For Printing + Format For Printing diff --git a/template/en/default/bug/show-multiple.html.tmpl b/template/en/default/bug/show-multiple.html.tmpl index a57445084..8b42217c1 100644 --- a/template/en/default/bug/show-multiple.html.tmpl +++ b/template/en/default/bug/show-multiple.html.tmpl @@ -89,13 +89,19 @@ [% PROCESS cell attr = { description => "Resolution", name => "resolution" } %] - [% PROCESS cell attr = { description => "Assigned To", - name => "assigned_to" } %] - [% PROCESS cell attr = { description => "Reported By", - name => "reporter" } %] + + Assigned To:  + [% bug.assigned_to.login FILTER html %] + + + Reported By:  + [% bug.reporter.login FILTER html %] + [% IF Param('useqacontact') %] - [% PROCESS cell attr = { description => "QA Contact", - name => "qa_contact" } %] + + QA Contact:  + [% bug.qa_contact.login FILTER html %] + [% END %] @@ -190,7 +196,7 @@ [% PROCESS bug/comments.html.tmpl - comments = bug.comments %] + comments = bug.longdescs %]
[% END %] diff --git a/template/en/default/global/site-navigation.html.tmpl b/template/en/default/global/site-navigation.html.tmpl index 95a7ef423..66c96a137 100644 --- a/template/en/default/global/site-navigation.html.tmpl +++ b/template/en/default/global/site-navigation.html.tmpl @@ -73,7 +73,7 @@ + href="show_bug.cgi?format=multiple&id=[% bug.bug_id %]"> [% END %] diff --git a/template/en/default/list/list.html.tmpl b/template/en/default/list/list.html.tmpl index 48759ceb7..24d00feb6 100644 --- a/template/en/default/list/list.html.tmpl +++ b/template/en/default/list/list.html.tmpl @@ -129,8 +129,11 @@ [% IF bugs.size > 0 %] -
- + + [% FOREACH id = buglist %] + + [% END %] +
-- cgit v1.2.3-24-g4f1b