%# BEGIN BPS TAGGED BLOCK {{{ %# %# COPYRIGHT: %# %# This software is Copyright (c) 1996-2007 Best Practical Solutions, LLC %# %# %# (Except where explicitly superseded by other copyright notices) %# %# %# LICENSE: %# %# This work is made available to you under the terms of Version 2 of %# the GNU General Public License. A copy of that license should have %# been provided with this software, but in any event can be snarfed %# from www.gnu.org. %# %# This work is distributed in the hope that it will be useful, but %# WITHOUT ANY WARRANTY; without even the implied warranty of %# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU %# General Public License for more details. %# %# You should have received a copy of the GNU General Public License %# along with this program; if not, write to the Free Software %# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA %# 02110-1301 or visit their web page on the internet at %# http://www.gnu.org/copyleft/gpl.html. %# %# %# CONTRIBUTION SUBMISSION POLICY: %# %# (The following paragraph is not intended to limit the rights granted %# to you to modify and distribute this software under the terms of %# the GNU General Public License and is only of importance to you if %# you choose to contribute your changes and enhancements to the %# community by submitting them to Best Practical Solutions, LLC.) %# %# By intentionally submitting any modifications, corrections or %# derivatives to this work, or any other work intended for use with %# Request Tracker, to Best Practical Solutions, LLC, you confirm that %# you are the copyright holder for those contributions and you grant %# Best Practical Solutions, LLC a nonexclusive, worldwide, irrevocable, %# royalty-free, perpetual, license to use, copy, create derivative %# works based on those contributions, and sublicense and distribute %# those contributions and any derivatives thereof. %# %# END BPS TAGGED BLOCK }}} <& /Elements/Header, Title => $title &> <& /Ticket/Elements/Tabs, current_tab => "Search/Bulk.html", Title => $title, Format => $ARGS{'Format'}, # we don't want the locally modified one Query => $Query, Rows => $Rows, OrderBy => $OrderBy, Order => $Order &> <& /Elements/ListActions, actions => \@results &>
% foreach my $var qw(Query Format OrderBy Order Rows Page) { %} <& /Elements/TicketList, Query => $Query, DisplayFormat => $Format, Format => $ARGS{'Format'}, Verbatim => 1, AllowSorting => 1, OrderBy => $OrderBy, Order => $Order, Rows => $Rows, Page => $Page, BaseURL => $RT::WebPath."/Search/Bulk.html?" &>
<& /Elements/Submit, Label => loc('Update'), CheckAll => 1, ClearAll => 1 &>
<&|/Widgets/TitleBox, title => $title &>
<&|/l&>Make Owner: <& /Elements/SelectOwner, Name => "Owner" &> ( <&|/l&>Force change)
<&|/l&>Add Requestor:
<&|/l&>Remove Requestor:
<&|/l&>Add Cc:
<&|/l&>Remove Cc:
<&|/l&>Add AdminCc:
<&|/l&>Remove AdminCc:
<&|/l&>Make subject:
<&|/l&>Make priority:
<&|/l&>Make queue: <& /Elements/SelectQueue, Name => "Queue" &>
<&|/l&>Make Status: <& /Elements/SelectStatus, Name => "Status" &>
<&|/l&>Make date Starts: <& /Elements/SelectDate, Name => "Starts_Date", ShowTime => 0, Default => '' &>
<&|/l&>Make date Started: <& /Elements/SelectDate, Name => "Started_Date", ShowTime => 0, Default => '' &>
<&|/l&>Make date Told: <& /Elements/SelectDate, Name => "Told_Date", ShowTime => 0, Default => '' &>
<&|/l&>Make date Due: <& /Elements/SelectDate, Name => "Due_Date", ShowTime => 0, Default => '' &>
<&|/l&>Make date Resolved: <& /Elements/SelectDate, Name => "Resolved_Date", ShowTime => 0, Default => '' &>
<&| /Widgets/TitleBox, title => loc('Add comments or replies to selected tickets') &> % while (my $CF = $TxnCFs->Next()) { % } # end if while
<&|/l&>Update Type:
<&|/l&>Subject:
<% $CF->Name %>: <& /Elements/EditCustomField, CustomField => $CF, NamePrefix => "Object-RT::Transaction--CustomField-" &><% $CF->FriendlyType %>
<&|/l&>Attach:
<&|/l&>Message: <& /Elements/MessageBox, Name=>"UpdateContent"&>
<&|/Widgets/TitleBox, title => loc('Edit Custom Fields'), color => "#336633"&> <%perl> my $cfs = RT::CustomFields->new($session{'CurrentUser'}); $cfs->LimitToGlobal(); $cfs->LimitToQueue($_) for keys %$seen_queues; % while (my $cf = $cfs->Next()) { % my $rows = 5; % my @add = (NamePrefix => 'Bulk-Add-CustomField-', CustomField => $cf, Rows => $rows, Multiple => ($cf->MaxValues ==1 ? 0 : 1) , Cols => 25); % my @del = (NamePrefix => 'Bulk-Delete-CustomField-', CustomField => $cf, Rows => $rows, Multiple => 1, Cols => 25); % if ($cf->Type eq 'Select') { % } elsif ($cf->Type eq 'Combobox') { % } elsif ($cf->Type eq 'Freeform') { % } elsif ($cf->Type eq 'Text') { % } else { % $RT::Logger->crit("Unknown CustomField type: " . $cf->Type); % } % }
<&|/l&>Name <&|/l&>Add values <&|/l&>Delete values
<%$cf->Name%>
(<%$cf->FriendlyType%>)
<& /Elements/EditCustomFieldSelect, @add &> <& /Elements/EditCustomFieldSelect, @del &><& /Elements/EditCustomFieldCombobox, @add &> <& /Elements/EditCustomFieldCombobox, @del &><& /Elements/EditCustomFieldFreeform, @add &> <& /Elements/EditCustomFieldFreeform, @del &><& /Elements/EditCustomFieldText, @add &>  
<&|/Widgets/TitleBox, title => loc('Edit Links'), color => "#336633"&> <&|/l&>Enter tickets or URIs to link tickets to. Separate multiple entries with spaces.
<& /Ticket/Elements/BulkLinks &> <& /Elements/Submit, Label => loc('Update') &>
<%INIT> my $title = loc("Update multiple tickets"); # Iterate through the ARGS hash and remove anything with a null value. map ( $ARGS{$_} =~ /^$/ && ( delete $ARGS{$_} ), keys %ARGS ); my (@results); $Page ||= 1; $Format ||= $RT::DefaultSearchResultFormat; # inject _CHECKBOX to the first field. $Format =~ s/'?([^']+)'?,/'___CHECKBOX__$1',/; my $Tickets = RT::Tickets->new( $session{'CurrentUser'} ); $Tickets->FromSQL($Query); if ( $OrderBy =~ /\|/ ) { # Multiple Sorts my @OrderBy = split /\|/, $OrderBy; my @Order = split /\|/, $Order; $Tickets->OrderByCols( map { { FIELD => $OrderBy[$_], ORDER => $Order[$_] } } ( 0 .. $#OrderBy ) ); } else { $Tickets->OrderBy( FIELD => $OrderBy, ORDER => $Order ); } $Tickets->RowsPerPage($Rows) if ($Rows); $Tickets->GotoPage( $Page - 1 ); # SB uses page 0 as the first page Abort( loc("No search to operate on.") ) unless ($Tickets); # build up a list of all custom fields for tickets that we're displaying, so # we can display sane edit widgets. my $fields = {}; my $seen_queues = {}; while ( my $ticket = $Tickets->Next ) { next if $seen_queues->{ $ticket->Queue }++; my $custom_fields = $ticket->QueueObj->TicketCustomFields; while ( my $field = $custom_fields->Next ) { $fields->{ $field->id } = $field; } } my $do_comment_reply = 0; # Prepare for ticket updates if ($ARGS{'UpdateContent'}) { $ARGS{'UpdateContent'} =~ s/\r\n/\n/g; chomp( $ARGS{'UpdateContent'} ); if ($ARGS{'UpdateContent'} ne '' && $ARGS{'UpdateContent'} ne "-- \n" . $session{'CurrentUser'}->UserObj->Signature ) { $do_comment_reply = 1; } } #Iterate through each ticket we've been handed my @linkresults; my %queues; $Tickets->RedoSearch(); # pull out the labels for any custom fields we want to update my $cf_del_keys; @$cf_del_keys = grep { /^Bulk-Delete-CustomField/ } keys %ARGS; my $cf_add_keys; @$cf_add_keys = grep { /^Bulk-Add-CustomField/ } keys %ARGS; while ( my $Ticket = $Tickets->Next ) { next unless ( $ARGS{ "UpdateTicket" . $Ticket->Id } ); #Update the links $ARGS{'id'} = $Ticket->id; $queues{ $Ticket->QueueObj->Id }++; my @updateresults; if ($do_comment_reply) { ProcessUpdateMessage( TicketObj => $Ticket, ARGSRef => \%ARGS, Actions => \@updateresults ); } #Update the basics. my @basicresults = ProcessTicketBasics( TicketObj => $Ticket, ARGSRef => \%ARGS ); my @dateresults = ProcessTicketDates( TicketObj => $Ticket, ARGSRef => \%ARGS ); #Update the watchers my @watchresults = ProcessTicketWatchers( TicketObj => $Ticket, ARGSRef => \%ARGS ); foreach my $type qw(MergeInto DependsOn MemberOf RefersTo) { $ARGS{ $Ticket->id . "-" . $type } = $ARGS{"Ticket-$type"}; $ARGS{ $type . "-" . $Ticket->id } = $ARGS{"$type-Ticket"}; } @linkresults = ProcessTicketLinks( TicketObj => $Ticket, ARGSRef => \%ARGS ); foreach my $type qw(MergeInto DependsOn MemberOf RefersTo) { delete $ARGS{ $type . "-" . $Ticket->id }; delete $ARGS{ $Ticket->id . "-" . $type }; } my @cfresults; foreach my $list ( $cf_add_keys, $cf_del_keys ) { next unless $list->[0]; my $op; if ( $list->[0] =~ /Add/ ) { $op = 'add'; } elsif ( $list->[0] =~ /Del/ ) { $op = 'del'; } else { $RT::Logger->crit( "Got an op that was neither add nor delete. can never happen" . $list->[0] ); last; } foreach my $key (@$list) { my ( $cfid, $cf ); if ( $key =~ /CustomField-(\d+)-/ ) { $cfid = $1; $cf = RT::CustomField->new( $session{'CurrentUser'} ); $cf->Load($cfid); } else {next} my @values = ref( $ARGS{$key} ) eq 'ARRAY' ? @{ $ARGS{$key} } : ( $ARGS{$key} ); map { s/(\r\n|\r)/\n/g; } @values; # fix the newlines # now break the multiline values into multivalues @values = map { split( /\n/, $_ ) } @values unless ( $cf->SingleValue ); my $current_values = $Ticket->CustomFieldValues($cfid); foreach my $value (@values) { if ( $op eq 'del' && $current_values->HasEntry($value) ) { my ( $id, $msg ) = $Ticket->DeleteCustomFieldValue( Field => $cfid, Value => $value ); push @cfresults, $msg; } elsif ( $op eq 'add' && !$current_values->HasEntry($value) ) { my ( $id, $msg ) = $Ticket->AddCustomFieldValue( Field => $cfid, Value => $value ); push @cfresults, $msg; } } } } my @tempresults = ( @watchresults, @basicresults, @dateresults, @updateresults, @linkresults, @cfresults ); @tempresults = map { loc( "Ticket [_1]: [_2]", $Ticket->Id, $_ ) } @tempresults; @results = ( @results, @tempresults ); } my $TxnCFs = RT::CustomFields->new( $session{CurrentUser} ); $TxnCFs->LimitToLookupType( RT::Transaction->CustomFieldLookupType ); $TxnCFs->LimitToGlobalOrObjectId( sort keys %queues ); <%args> $Format => undef $Page => 1 $Rows => undef $Order => 'ASC' $OrderBy => 'id' $Query => undef