2 # BEGIN BPS TAGGED BLOCK {{{
6 # This software is Copyright (c) 1996-2014 Best Practical Solutions, LLC
7 # <sales@bestpractical.com>
9 # (Except where explicitly superseded by other copyright notices)
14 # This work is made available to you under the terms of Version 2 of
15 # the GNU General Public License. A copy of that license should have
16 # been provided with this software, but in any event can be snarfed
19 # This work is distributed in the hope that it will be useful, but
20 # WITHOUT ANY WARRANTY; without even the implied warranty of
21 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
22 # General Public License for more details.
24 # You should have received a copy of the GNU General Public License
25 # along with this program; if not, write to the Free Software
26 # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
27 # 02110-1301 or visit their web page on the internet at
28 # http://www.gnu.org/licenses/old-licenses/gpl-2.0.html.
31 # CONTRIBUTION SUBMISSION POLICY:
33 # (The following paragraph is not intended to limit the rights granted
34 # to you to modify and distribute this software under the terms of
35 # the GNU General Public License and is only of importance to you if
36 # you choose to contribute your changes and enhancements to the
37 # community by submitting them to Best Practical Solutions, LLC.)
39 # By intentionally submitting any modifications, corrections or
40 # derivatives to this work, or any other work intended for use with
41 # Request Tracker, to Best Practical Solutions, LLC, you confirm that
42 # you are the copyright holder for those contributions and you grant
43 # Best Practical Solutions, LLC a nonexclusive, worldwide, irrevocable,
44 # royalty-free, perpetual, license to use, copy, create derivative
45 # works based on those contributions, and sublicense and distribute
46 # those contributions and any derivatives thereof.
48 # END BPS TAGGED BLOCK }}}
53 # fix lib paths, some may be relative
54 BEGIN { # BEGIN RT CMD BOILERPLATE
57 my @libs = ("lib", "local/lib");
61 unless ( File::Spec->file_name_is_absolute($lib) ) {
62 $bin_path ||= ( File::Spec->splitpath(Cwd::abs_path(__FILE__)) )[1];
63 $lib = File::Spec->catfile( $bin_path, File::Spec->updir, $lib );
74 use RT::Interface::CLI qw(CleanEnv GetCurrentUser GetMessageContent loc);
76 my ( $search, $condition, $action, $search_arg, $condition_arg, $action_arg,
77 $template, $template_id, $transaction, $transaction_type, $help, $log, $verbose );
79 "search=s" => \$search,
80 "search-arg=s" => \$search_arg,
81 "condition=s" => \$condition,
82 "condition-arg=s" => \$condition_arg,
83 "action-arg=s" => \$action_arg,
84 "action=s" => \$action,
85 "template=s" => \$template,
86 "template-id=s" => \$template_id,
87 "transaction=s" => \$transaction,
88 "transaction-type=s" => \$transaction_type,
90 "verbose|v" => \$verbose,
94 # Load the config file
97 # adjust logging to the screen according to options
98 RT->Config->Set( LogToSTDERR => $log ) if $log;
100 #Connect to the database and get RT::SystemUser and RT::Nobody loaded
103 # Clean out all the nasties from the environment
107 require RT::Template;
109 #Get the current user all loaded
110 my $CurrentUser = GetCurrentUser();
112 # show help even if there is no current user
115 unless ( $CurrentUser->Id ) {
116 print loc("No RT user found. Please consult your RT administrator.");
120 help() unless $search && $action;
122 $transaction = lc( $transaction||'' );
123 if ( $transaction && $transaction !~ /^(first|all|last)$/i ) {
124 print STDERR loc("--transaction argument could be only 'first', 'last' or 'all'");
128 if ( $template && $template_id ) {
129 print STDERR loc("--template-id is deprecated argument and can not be used with --template");
132 elsif ( $template_id ) {
134 $template = $template_id;
137 # We _must_ have a search object
138 load_module($search);
139 load_module($action) if ($action);
140 load_module($condition) if ($condition);
142 my $void_scrip = RT::Scrip->new( $CurrentUser );
143 my $void_scrip_action = RT::ScripAction->new( $CurrentUser );
145 #At the appointed time:
147 #find a bunch of tickets
148 my $tickets = RT::Tickets->new($CurrentUser);
149 $search = $search->new(
150 TicketsObj => $tickets,
151 Argument => $search_arg,
152 CurrentUser => $CurrentUser
156 #for each ticket we've found
157 while ( my $ticket = $tickets->Next() ) {
158 print $ticket->Id() . ":\n" if ($verbose);
160 my $template_obj = get_template( $ticket );
162 if ( $transaction ) {
163 my $txns = get_transactions($ticket);
165 while ( my $txn = $txns->Next ) {
166 print "\t".loc("Using transaction #[_1]...", $txn->id)."\n"
168 process($ticket, $txn, $template_obj);
171 print "\t".loc("Couldn't find suitable transaction, skipping")."\n"
172 if $verbose && !$found;
174 print "\t".loc("Processing without transaction, some conditions and actions may fail. Consider using --transaction argument")."\n"
177 process($ticket, undef, $template_obj);
183 my $transaction = shift;
184 my $template_obj = shift;
186 # perform some more advanced check
188 my $condition_obj = $condition->new(
189 TransactionObj => $transaction,
190 TicketObj => $ticket,
191 ScripObj => $void_scrip,
192 TemplateObj => $template_obj,
193 Argument => $condition_arg,
194 CurrentUser => $CurrentUser,
197 # if the condition doesn't apply, get out of here
199 return unless $condition_obj->IsApplicable;
200 print "\t".loc("Condition matches...")."\n" if $verbose;
204 my $action_obj = $action->new(
205 TicketObj => $ticket,
206 TransactionObj => $transaction,
207 TemplateObj => $template_obj,
208 Argument => $action_arg,
209 ScripObj => $void_scrip,
210 ScripActionObj => $void_scrip_action,
211 CurrentUser => $CurrentUser,
214 #if our preparation, move onto the next ticket
215 return unless $action_obj->Prepare;
216 print "\t".loc("Action prepared...")."\n" if $verbose;
219 return unless $action_obj->Commit;
220 print "\t".loc("Action committed.")."\n" if $verbose;
223 # =head2 get_transactions
225 # Takes ticket and returns L<RT::Transactions> object with transactions
226 # of the ticket according to command line arguments C<--transaction>
227 # and <--transaction-type>.
231 sub get_transactions {
233 my $txns = $ticket->Transactions;
234 my $order = $transaction eq 'last'? 'DESC': 'ASC';
236 { FIELD => 'Created', ORDER => $order },
237 { FIELD => 'id', ORDER => $order },
239 if ( $transaction_type ) {
240 $transaction_type =~ s/^\s+//;
241 $transaction_type =~ s/\s+$//;
242 foreach my $type ( split /\s*,\s*/, $transaction_type ) {
243 $txns->Limit( FIELD => 'Type', VALUE => $type, ENTRYAGGREGATOR => 'OR' );
246 $txns->RowsPerPage(1) unless $transaction eq 'all';
250 # =head2 get_template
252 # Takes a ticket and returns a template according to command line options.
259 return undef unless $template;
261 unless ( $template =~ /\D/ ) {
263 return $cache if $cache;
265 my $cache = RT::Template->new( RT->SystemUser );
266 $cache->Load( $template );
267 die "Failed to load template '$template'"
272 my $queue = $ticket->Queue;
273 return $cache->{ $queue } if $cache->{ $queue };
275 my $res = RT::Template->new( RT->SystemUser );
276 $res->LoadQueueTemplate( Queue => $queue, Name => $template );
277 unless ( $res->id ) {
278 $res->LoadGlobalTemplate( $template );
279 die "Failed to load template '$template', either for queue #$queue or global"
282 return $cache->{ $queue } = $res;
288 # Loads a perl module, dying nicely if it can't find it.
294 eval "require $modname";
296 die loc( "Failed to load module [_1]. ([_2])", $modname, $@ );
304 print loc( "[_1] is a tool to act on tickets from an external scheduling tool, such as cron.", $0 )
306 print loc("It takes several arguments:") . "\n\n";
309 . loc( "[_1] - Specify the search module you want to use", "--search" )
312 . loc( "[_1] - An argument to pass to [_2]", "--search-arg", "--search" )
316 . loc( "[_1] - Specify the condition module you want to use", "--condition" )
319 . loc( "[_1] - An argument to pass to [_2]", "--condition-arg", "--condition" )
322 . loc( "[_1] - Specify the action module you want to use", "--action" )
325 . loc( "[_1] - An argument to pass to [_2]", "--action-arg", "--action" )
328 . loc( "[_1] - Specify name or id of template(s) you want to use", "--template" )
331 . loc( "[_1] - Specify if you want to use either 'first', 'last' or 'all' transactions", "--transaction" )
334 . loc( "[_1] - Specify the comma separated list of transactions' types you want to use", "--transaction-type" )
337 . loc( "[_1] - Adjust LogToSTDERR config option", "--log" ) . "\n";
339 . loc( "[_1] - Output status updates to STDOUT", "--verbose" ) . "\n";
342 print loc("Security:")."\n";
343 print loc("This tool allows the user to run arbitrary perl modules from within RT.")." ".
344 loc("If this tool were setgid, a hostile local user could use this tool to gain administrative access to RT.")." ".
345 loc("It is incredibly important that nonprivileged users not be allowed to run this tool."). " " .
346 loc("It is suggested that you create a non-privileged unix user with the correct group membership and RT access to run this tool.")."\n";
348 print loc("Example:");
351 . loc( "The following command will find all active tickets in the queue 'general' and set their priority to 99 if they are overdue:"
355 print " bin/rt-crontool \\\n";
356 print " --search RT::Search::ActiveTicketsInQueue --search-arg general \\\n";
357 print " --condition RT::Condition::Overdue \\\n";
358 print " --action RT::Action::SetPriority --action-arg 99 \\\n";
359 print " --verbose\n";
362 print loc("Escalate tickets"). "\n";
363 print " bin/rt-crontool \\\n";
364 print " --search RT::Search::ActiveTicketsInQueue --search-arg general \\\n";
365 print" --action RT::Action::EscalatePriority\n";
379 rt-crontool - a tool to act on tickets from an external scheduling tool
383 # find all active tickets in the queue 'general' and set their priority to 99 if they are overdue:
385 --search RT::Search::ActiveTicketsInQueue --search-arg general \
386 --condition RT::Condition::Overdue \
387 --action RT::Action::SetPriority --action-arg 99 \
392 --search RT::Search::ActiveTicketsInQueue --search-arg general \
393 --action RT::Action::EscalatePriority
397 This script is a tool to act on tickets from an external scheduling tool, such
402 This tool allows the user to run arbitrary perl modules from within RT. If
403 this tool were setgid, a hostile local user could use this tool to gain
404 administrative access to RT. It is incredibly important that nonprivileged
405 users not be allowed to run this tool. It is suggested that you create a
406 non-privileged unix user with the correct group membership and RT access to
416 Specify the search module you want to use
420 An argument to pass to --search
424 Specify the condition module you want to use
428 An argument to pass to --condition
432 Specify the action module you want to use
436 An argument to pass to --action
440 Specify name or id of template(s) you want to use
444 Specify if you want to use either 'first', 'last' or 'all' transactions
447 =item transaction-type
449 Specify the comma separated list of transactions' types you want to use
453 Adjust LogToSTDERR config option
457 Output status updates to STDOUT