#!/usr/bonsaitools/bin/perl -w # -*- Mode: perl; indent-tabs-mode: nil -*- # # The contents of this file are subject to the Mozilla Public License # Version 1.0 (the "License"); you may not use this file except in # compliance with the License. You may obtain a copy of the License at # http://www.mozilla.org/MPL/ # # Software distributed under the License is distributed on an "AS IS" # basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the # License for the specific language governing rights and limitations # under the License. # # The Original Code is the Bugzilla Bug Tracking System. # # The Initial Developer of the Original Code is Netscape Communications # Corporation. Portions created by Netscape are Copyright (C) 1998 # Netscape Communications Corporation. All Rights Reserved. # # Contributor(s): Terry Weissman use diagnostics; use strict; require "CGI.pl"; # Shut up misguided -w warnings about "used only once": use vars %::versions, %::components, %::COOKIE; confirm_login(); print "Content-type: text/html\n\n"; GetVersionTable(); if ($::FORM{'product'} ne $::dontchange) { my $prod = $::FORM{'product'}; my $vok = lsearch($::versions{$prod}, $::FORM{'version'}) >= 0; my $cok = lsearch($::components{$prod}, $::FORM{'component'}) >= 0; if (!$vok || !$cok) { print "

Changing product means changing version and component.

\n"; print "You have chosen a new product, and now the version and/or\n"; print "component fields are not correct. (Or, possibly, the bug did\n"; print "not have a valid component or version field in the first place.)\n"; print "Anyway, please set the version and component now.

\n"; print "

\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "
Product:$prod
Version:" . Version_element($::FORM{'version'}, $prod) . "
Component:" . Component_element($::FORM{'component'}, $prod) . "
\n"; foreach my $i (keys %::FORM) { if ($i ne 'version' && $i ne 'component') { print "\n"; } } print "\n"; print "
\n"; print "\n"; print "Cancel all this and go back to the query page.\n"; exit; } } my @idlist; if (defined $::FORM{'id'}) { push @idlist, $::FORM{'id'}; } else { foreach my $i (keys %::FORM) { if ($i =~ /^id_/) { push @idlist, substr($i, 3); } } } if (!defined $::FORM{'who'}) { $::FORM{'who'} = $::COOKIE{'Bugzilla_login'}; } print "Update Bug " . join(" ", @idlist) . "\n"; if (defined $::FORM{'id'}) { navigation_header(); } print "
\n"; $::query = "update bugs\nset"; $::comma = ""; umask(0); sub DoComma { $::query .= "$::comma\n "; $::comma = ","; } sub ChangeStatus { my ($str) = (@_); if ($str ne $::dontchange) { DoComma(); $::query .= "bug_status = '$str'"; } } sub ChangeResolution { my ($str) = (@_); if ($str ne $::dontchange) { DoComma(); $::query .= "resolution = '$str'"; } } my $foundbit = 0; foreach my $b (grep(/^bit-\d*$/, keys %::FORM)) { if (!$foundbit) { $foundbit = 1; DoComma(); $::query .= "groupset = 0"; } if ($::FORM{$b}) { my $v = substr($b, 4); $::query .= "+ $v"; # Carefully written so that the math is # done by MySQL, which can handle 64-bit math, # and not by Perl, which I *think* can not. } } foreach my $field ("rep_platform", "priority", "bug_severity", "url", "summary", "component", "bug_file_loc", "short_desc", "product", "version", "component", "op_sys", "target_milestone", "status_whiteboard") { if (defined $::FORM{$field}) { if ($::FORM{$field} ne $::dontchange) { DoComma(); $::query .= "$field = " . SqlQuote(trim($::FORM{$field})); } } } if (defined $::FORM{'qa_contact'}) { my $name = trim($::FORM{'qa_contact'}); if ($name ne $::dontchange) { my $id = 0; if ($name ne "") { $id = DBNameToIdAndCheck($name); } DoComma(); $::query .= "qa_contact = $id"; } } ConnectToDatabase(); SWITCH: for ($::FORM{'knob'}) { /^none$/ && do { last SWITCH; }; /^accept$/ && do { ChangeStatus('ASSIGNED'); last SWITCH; }; /^clearresolution$/ && do { ChangeResolution(''); last SWITCH; }; /^resolve$/ && do { ChangeStatus('RESOLVED'); ChangeResolution($::FORM{'resolution'}); last SWITCH; }; /^reassign$/ && do { ChangeStatus('NEW'); DoComma(); my $newid = DBNameToIdAndCheck($::FORM{'assigned_to'}); $::query .= "assigned_to = $newid"; last SWITCH; }; /^reassignbycomponent$/ && do { if ($::FORM{'component'} eq $::dontchange) { print "You must specify a component whose owner should get\n"; print "assigned these bugs.\n"; exit 0 } ChangeStatus('NEW'); SendSQL("select initialowner from components where program=" . SqlQuote($::FORM{'product'}) . " and value=" . SqlQuote($::FORM{'component'})); my $newname = FetchOneColumn(); my $newid = DBNameToIdAndCheck($newname, 1); DoComma(); $::query .= "assigned_to = $newid"; last SWITCH; }; /^reopen$/ && do { ChangeStatus('REOPENED'); last SWITCH; }; /^verify$/ && do { ChangeStatus('VERIFIED'); last SWITCH; }; /^close$/ && do { ChangeStatus('CLOSED'); last SWITCH; }; /^duplicate$/ && do { ChangeStatus('RESOLVED'); ChangeResolution('DUPLICATE'); my $num = trim($::FORM{'dup_id'}); if ($num !~ /^[0-9]*$/) { print "You must specify a bug number of which this bug is a\n"; print "duplicate. The bug has not been changed.\n"; exit; } if ($::FORM{'dup_id'} == $::FORM{'id'}) { print "Nice try, $::FORM{'who'}. But it doesn't really make sense to mark a\n"; print "bug as a duplicate of itself, does it?\n"; exit; } AppendComment($::FORM{'dup_id'}, $::FORM{'who'}, "*** Bug $::FORM{'id'} has been marked as a duplicate of this bug. ***"); $::FORM{'comment'} .= "\n\n*** This bug has been marked as a duplicate of $::FORM{'dup_id'} ***"; print "

Notation added to bug $::FORM{'dup_id'}

\n"; system("./processmail $::FORM{'dup_id'} $::FORM{'who'}"); print "
Go To BUG# $::FORM{'dup_id'}
\n"; last SWITCH; }; # default print "Unknown action $::FORM{'knob'}!\n"; exit; } if ($#idlist < 0) { print "You apparently didn't choose any bugs to modify.\n"; print "

Click Back and try again.\n"; exit; } if ($::comma eq "") { if (!defined $::FORM{'comment'} || $::FORM{'comment'} =~ /^\s*$/) { print "Um, you apparently did not change anything on the selected\n"; print "bugs.

Click Back and try again.\n"; exit } } my $basequery = $::query; my $delta_ts; sub SnapShotBug { my ($id) = (@_); SendSQL("select delta_ts, " . join(',', @::log_columns) . " from bugs where bug_id = $id"); my @row = FetchSQLData(); $delta_ts = shift @row; return @row; } sub SnapShotDeps { my ($i, $target, $me) = (@_); SendSQL("select $target from dependencies where $me = $i order by $target"); my @list; while (MoreSQLData()) { push(@list, FetchOneColumn()); } return join(',', @list); } my $whoid = DBNameToIdAndCheck($::FORM{'who'}); my $timestamp; sub LogDependencyActivity { my ($i, $oldstr, $target, $me) = (@_); my $newstr = SnapShotDeps($i, $target, $me); if ($oldstr ne $newstr) { SendSQL("insert into bugs_activity (bug_id,who,when,field,oldvalue,newvalue) values ($i,$whoid,$timestamp,'$target','$oldstr','$newstr')"); return 1; } return 0; } foreach my $id (@idlist) { my %dependencychanged; SendSQL("lock tables bugs write, bugs_activity write, cc write, profiles write, dependencies write"); my @oldvalues = SnapShotBug($id); if (defined $::FORM{'delta_ts'} && $::FORM{'delta_ts'} ne $delta_ts) { print "

Mid-air collision detected!

Someone else has made changes to this bug at the same time you were trying to. The changes made were:

"; DumpBugActivity($id, $delta_ts); my $longdesc = GetLongDescription($id); my $longchanged = 0; if (length($longdesc) > $::FORM{'longdesclength'}) { $longchanged = 1; print "

Added text to the long description:

";
            print html_quote(substr($longdesc, $::FORM{'longdesclength'}));
            print "
\n"; } SendSQL("unlock tables"); print "You have the following choices: \n}; navigation_header(); exit; } my %deps; if (defined $::FORM{'dependson'}) { my $me = "blocked"; my $target = "dependson"; for (1..2) { $deps{$target} = []; my %seen; foreach my $i (split('[\s,]+', $::FORM{$target})) { if ($i eq "") { next; } SendSQL("select bug_id from bugs where bug_id = " . SqlQuote($i)); my $comp = FetchOneColumn(); if ($comp ne $i) { print "

$i is not a legal bug number

\n"; print "

Click Back and try again.\n"; exit; } if (!exists $seen{$i}) { push(@{$deps{$target}}, $i); $seen{$i} = 1; } } my @stack = @{$deps{$target}}; while (@stack) { my $i = shift @stack; SendSQL("select $target from dependencies where $me = $i"); while (MoreSQLData()) { my $t = FetchOneColumn(); if ($t == $id) { print "

Dependency loop detected!

\n"; print "The change you are making to dependencies\n"; print "has caused a circular dependency chain.\n"; print "

Click Back and try again.\n"; exit; } if (!exists $seen{$t}) { push @stack, $t; $seen{$t} = 1; } } } my $tmp = $me; $me = $target; $target = $tmp; } } my $query = "$basequery\nwhere bug_id = $id"; # print "

$query
\n"; if ($::comma ne "") { SendSQL($query); } if (defined $::FORM{'comment'}) { AppendComment($id, $::FORM{'who'}, $::FORM{'comment'}); } if (defined $::FORM{'cc'} && ShowCcList($id) ne $::FORM{'cc'}) { my %ccids; foreach my $person (split(/[ ,]/, $::FORM{'cc'})) { if ($person ne "") { my $cid = DBNameToIdAndCheck($person); $ccids{$cid} = 1; } } SendSQL("delete from cc where bug_id = $id"); foreach my $ccid (keys %ccids) { SendSQL("insert into cc (bug_id, who) values ($id, $ccid)"); } } SendSQL("select delta_ts from bugs where bug_id = $id"); $timestamp = FetchOneColumn(); if (defined $::FORM{'dependson'}) { my $me = "blocked"; my $target = "dependson"; for (1..2) { SendSQL("select $target from dependencies where $me = $id order by $target"); my %snapshot; my @oldlist; while (MoreSQLData()) { push(@oldlist, FetchOneColumn()); } my @newlist = sort {$a <=> $b} @{$deps{$target}}; @dependencychanged{@oldlist} = 1; @dependencychanged{@newlist} = 1; while (0 < @oldlist || 0 < @newlist) { if (@oldlist == 0 || (@newlist > 0 && $oldlist[0] > $newlist[0])) { $snapshot{$newlist[0]} = SnapShotDeps($newlist[0], $me, $target); shift @newlist; } elsif (@newlist == 0 || (@oldlist > 0 && $newlist[0] > $oldlist[0])) { $snapshot{$oldlist[0]} = SnapShotDeps($oldlist[0], $me, $target); shift @oldlist; } else { if ($oldlist[0] != $newlist[0]) { die "Error in list comparing code"; } shift @oldlist; shift @newlist; } } my @keys = keys(%snapshot); if (@keys) { my $oldsnap = SnapShotDeps($id, $target, $me); SendSQL("delete from dependencies where $me = $id"); foreach my $i (@{$deps{$target}}) { SendSQL("insert into dependencies ($me, $target) values ($id, $i)"); } foreach my $k (@keys) { LogDependencyActivity($k, $snapshot{$k}, $me, $target); } LogDependencyActivity($id, $oldsnap, $target, $me); } my $tmp = $me; $me = $target; $target = $tmp; } } my @newvalues = SnapShotBug($id); foreach my $col (@::log_columns) { my $old = shift @oldvalues; my $new = shift @newvalues; if (!defined $old) { $old = ""; } if (!defined $new) { $new = ""; } if ($old ne $new) { if ($col eq 'assigned_to' || $col eq 'qa_contact') { $old = DBID_to_name($old) if $old != 0; $new = DBID_to_name($new) if $new != 0; } $col = SqlQuote($col); $old = SqlQuote($old); $new = SqlQuote($new); my $q = "insert into bugs_activity (bug_id,who,when,field,oldvalue,newvalue) values ($id,$whoid,$timestamp,$col,$old,$new)"; # puts "
$q
" SendSQL($q); } } print "

Changes to bug $id submitted

\n"; SendSQL("unlock tables"); system("./processmail $id $::FORM{'who'}"); print "
Back To BUG# $id
\n"; foreach my $k (keys(%dependencychanged)) { print "

Checking for dependency changes on bug $k

\n"; system("./processmail $k $::FORM{'who'}"); print "
Go To BUG# $k
\n"; } } if (defined $::next_bug) { print("

The next bug in your list is:\n"); $::FORM{'id'} = $::next_bug; print "


\n"; navigation_header(); do "bug_form.pl"; } else { navigation_header(); }