From cae68ff1db7de8f097a443ec93ae245e3f600d94 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Thu, 11 Jan 2018 13:00:31 -0500 Subject: [PATCH] Bug 19955 - Add ability to process only one 'type' of message ( sms, email, etc ) for a given run of process_message_queue.pl It would be nice to allow emails to be sent overnight, but limit the sending of SMS messages to hours when people are awake. Adding a type limit to process_message_queue.pl would allow this to be accomplished easily. --- C4/Letters.pm | 8 ++++++-- misc/cronjobs/process_message_queue.pl | 5 ++++- 2 files changed, 10 insertions(+), 3 deletions(-) diff --git a/C4/Letters.pm b/C4/Letters.pm index 42893f1..37802c3 100644 --- a/C4/Letters.pm +++ b/C4/Letters.pm @@ -1023,7 +1023,7 @@ ENDSQL =head2 SendQueuedMessages ([$hashref]) - my $sent = SendQueuedMessages({ verbose => 1, limit => 50 }); + my $sent = SendQueuedMessages({ verbose => 1, limit => 50, type => 'sms' }); Sends all of the 'pending' items in the message queue, unless the optional limit parameter is passed too. The verbose parameter is also optional. @@ -1035,7 +1035,7 @@ Returns number of messages sent. sub SendQueuedMessages { my $params = shift; - my $unsent_messages = _get_unsent_messages( { limit => $params->{limit} } ); + my $unsent_messages = _get_unsent_messages( { limit => $params->{limit}, type => $params->{type} } ); MESSAGE: foreach my $message ( @$unsent_messages ) { # warn Data::Dumper->Dump( [ $message ], [ 'message' ] ); warn sprintf( 'sending %s message to patron: %s', @@ -1286,6 +1286,10 @@ sub _get_unsent_messages { $statement .= ' AND borrowernumber = ? '; push @query_params, $params->{'borrowernumber'}; } + if ( $params->{'type'} ) { + $statement .= ' AND message_transport_type = ? '; + push @query_params, $params->{'type'}; + } if ( $params->{'limit'} ) { $statement .= ' limit ? '; push @query_params, $params->{'limit'}; diff --git a/misc/cronjobs/process_message_queue.pl b/misc/cronjobs/process_message_queue.pl index adb11bd..93f5c35 100755 --- a/misc/cronjobs/process_message_queue.pl +++ b/misc/cronjobs/process_message_queue.pl @@ -35,6 +35,7 @@ my $limit = undef; my $method = 'LOGIN'; my $help = 0; my $verbose = 0; +my $type = q{}; GetOptions( 'u|username:s' => \$username, @@ -43,6 +44,7 @@ GetOptions( 'm|method:s' => \$method, 'h|help|?' => \$help, 'v|verbose' => \$verbose, + 't|type' => \$type, ); my $usage = << 'ENDUSAGE'; @@ -55,11 +57,11 @@ advance_notices.pl script. This script has the following parameters : -u --username: username of mail account -p --password: password of mail account + -t --type: If supplied, only processes this type of message ( email, sms ) -l --limit: The maximum number of messages to process for this run -m --method: authentication method required by SMTP server (See perldoc Sendmail.pm for supported authentication types.) -h --help: this message -v --verbose: provides verbose output to STDOUT - ENDUSAGE die $usage if $help; @@ -73,6 +75,7 @@ C4::Letters::SendQueuedMessages( password => $password, method => $method, limit => $limit, + type => $type, } ); -- 2.10.2