diff options
Diffstat (limited to 'rt/lib/RT/Shredder/Plugin/Tickets.pm')
| -rw-r--r-- | rt/lib/RT/Shredder/Plugin/Tickets.pm | 153 |
1 files changed, 153 insertions, 0 deletions
diff --git a/rt/lib/RT/Shredder/Plugin/Tickets.pm b/rt/lib/RT/Shredder/Plugin/Tickets.pm new file mode 100644 index 0000000..ebbfb3e --- /dev/null +++ b/rt/lib/RT/Shredder/Plugin/Tickets.pm @@ -0,0 +1,153 @@ +# BEGIN BPS TAGGED BLOCK {{{ +# +# COPYRIGHT: +# +# This software is Copyright (c) 1996-2009 Best Practical Solutions, LLC +# <jesse@bestpractical.com> +# +# (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/licenses/old-licenses/gpl-2.0.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 }}} + +package RT::Shredder::Plugin::Tickets; + +use strict; +use warnings FATAL => 'all'; +use base qw(RT::Shredder::Plugin::Base::Search); + +=head1 NAME + +RT::Shredder::Plugin::Tickets - search plugin for wiping tickets. + +=head1 ARGUMENTS + +=head2 query - query string + +Search tickets with query string. +Examples: + Queue = 'my queue' AND ( Status = 'deleted' OR Status = 'rejected' ) + LastUpdated < '2003-12-31 23:59:59' + +B<Hint:> You can construct query with the query builder in RT's web +interface and then open advanced page and copy query string. + +Arguments C<queue>, C<status> and C<updated_before> have been dropped +as you can easy make the same search with the C<query> option. +See examples above. + +=head2 with_linked - boolen + +Deletes all tickets that are linked to tickets that match L<query>. + +=head2 apply_query_to_linked - boolean + +Delete linked tickets only if those too match L<query>. + +See also L<with_linked>. + +=cut + +sub SupportArgs { return $_[0]->SUPER::SupportArgs, qw(query with_linked apply_query_to_linked) } + +sub TestArgs +{ + my $self = shift; + my %args = @_; + my $queue; + if( $args{'query'} ) { + my $objs = RT::Tickets->new( $RT::SystemUser ); + $objs->{'allow_deleted_search'} = 1; + my ($status, $msg) = $objs->FromSQL( $args{'query'} ); + return( 0, "Bad query argument, error: $msg" ) unless $status; + $self->{'opt'}{'objects'} = $objs; + } + $args{'with_linked'} = 1 if $args{'apply_query_to_linked'}; + + return $self->SUPER::TestArgs( %args ); +} + +sub Run +{ + my $self = shift; + my $objs = $self->{'opt'}{'objects'} + or return (1, undef); + + $objs->OrderByCols( { FIELD => 'id', ORDER => 'ASC' } ); + unless ( $self->{'opt'}{'with_linked'} ) { + if( $self->{'opt'}{'limit'} ) { + $objs->RowsPerPage( $self->{'opt'}{'limit'} ); + } + return (1, $objs); + } + + my (@top, @linked, %seen); + $self->FetchNext($objs, 1); + while ( my $obj = $self->FetchNext( $objs ) ) { + next if $seen{ $obj->id }++; + push @linked, $self->GetLinked( Object => $obj, Seen => \%seen ); + push @top, $obj; + last if $self->{'opt'}{'limit'} + && @top >= $self->{'opt'}{'limit'}; + } + return (1, @top, @linked); +} + +sub GetLinked +{ + my $self = shift; + my %arg = @_; + my @res = (); + my $query = 'Linked = '. $arg{'Object'}->id; + if ( $self->{'opt'}{'apply_query_to_linked'} ) { + $query .= " AND ( ". $self->{'opt'}{'query'} ." )"; + } + my $objs = RT::Tickets->new( $RT::SystemUser ); + $objs->{'allow_deleted_search'} = 1; + $objs->FromSQL( $query ); + $self->FetchNext( $objs, 1 ); + while ( my $linked_obj = $self->FetchNext( $objs ) ) { + next if $arg{'Seen'}->{ $linked_obj->id }++; + push @res, $self->GetLinked( %arg, Object => $linked_obj ); + push @res, $linked_obj; + } + return @res; +} + +1; |