3 # This file is part of Koha.
5 # Copyright (C) 2015 Amit Gupta (amitddng135@gmail.com)
7 # Koha is free software; you can redistribute it and/or modify it
8 # under the terms of the GNU General Public License as published by
9 # the Free Software Foundation; either version 3 of the License, or
10 # (at your option) any later version.
12 # Koha is distributed in the hope that it will be useful, but
13 # WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with Koha; if not, see <http://www.gnu.org/licenses>.
22 membership_expiry.pl - cron script to put membership expiry reminders into the message queue
26 ./membership_expiry.pl -c
30 0 1 * * * membership_expiry.pl -c
33 --help brief help message
34 --man full documentation
35 --where <conditions> where clause to add to the query
36 -v -verbose verbose mode
37 -n --nomail if supplied messages will be output to STDOUT and not sent
38 -c --confirm commit changes to db, no action will be taken unless this switch is included
39 -b --branch <branchname> only deal with patrons from this library/branch
40 --before=X include patrons expiring a number of days BEFORE the date set by the preference
41 --after=X include patrons expiring a number of days AFTER the date set by the preference
42 -l --letter <lettercode> use a specific notice rather than the default
46 This script sends membership expiry reminder notices to patrons.
47 It queues them in the message queue, which is processed by
48 the process_message_queue.pl cronjob.
56 Print a brief help message and exits.
60 Prints the manual page and exits.
64 Verbose. Without this flag set, only fatal errors are reported.
68 Do not send any email. Membership expire notices that would have been sent to
69 the patrons are printed to standard out.
73 Confirm flag: Add this option. The script will only print a usage
78 Optional branchcode to restrict the cronjob to that branch.
82 Optional parameter to extend the selection with a number of days BEFORE
83 the date set by the preference.
87 Optional parameter to extend the selection with a number of days AFTER
88 the date set by the preference.
92 Use this option to specify a condition built with columns from the borrowers table
95 --where 'lastseen IS NOT NULL'
96 will only notify patrons who have been seen.
100 Optional parameter to use another notice than the default: MEMBERSHIP_EXPIRY
106 The content of the messages is configured in Tools -> Notices and slips. Use the MEMBERSHIP_EXPIRY notice or
107 supply another via the parameters.
109 Typically, messages are prepared for each patron when the memberships are going to expire.
111 These emails are staged in the outgoing message queue, as are messages
112 produced by other features of Koha. This message queue must be
113 processed regularly by the
114 F<misc/cronjobs/process_message_queue.pl> program.
116 In the event that the C<-n> flag is passed to this program, no emails
117 are sent. Instead, messages are sent on standard output from this
120 Notices can contain variables enclosed in double angle brackets like
121 E<lt>E<lt>thisE<gt>E<gt>. Those variables will be replaced with values
122 specific to the soon expiring members.
123 Available variables are:
127 =item E<lt>E<lt>borrowers.*E<gt>E<gt>
129 any field from the borrowers table
131 =item E<lt>E<lt>branches.*E<gt>E<gt>
133 any field from the branches table
140 use Getopt::Long qw( GetOptions );
141 use Pod::Usage qw( pod2usage );
143 use Koha::Script -cron;
146 use C4::Log qw( cronlogaction );
150 # These are defaults for command line options.
151 my $confirm; # -c: Confirm that the user has read and configured this script.
152 my $nomail; # -n: No mail. Will not send any emails.
153 my $verbose = 0; # -v: verbose
158 my ( $branch, $letter_type );
161 my $command_line_options = join(" ",@ARGV);
169 'branch:s' => \$branch,
170 'before:i' => \$before,
171 'after:i' => \$after,
172 'letter:s' => \$letter_type,
173 'where=s' => \@where,
176 pod2usage( -verbose => 2 ) if $man;
177 pod2usage(1) if $help || !$confirm;
179 cronlogaction({ info => $command_line_options });
181 my $expdays = C4::Context->preference('MembershipExpiryDaysNotice');
183 #If the pref is not set, we will exit
184 warn 'Exiting membership_expiry.pl: MembershipExpiryDaysNotice not set'
189 warn 'getting upcoming membership expires' if $verbose;
190 my $upcoming_mem_expires = Koha::Patrons->search_upcoming_membership_expires(
192 ( $branch ? ( 'me.branchcode' => $branch ) : () ),
198 my $where_literal = join ' AND ', @where;
199 $upcoming_mem_expires = $upcoming_mem_expires->search( \$where_literal ) if @where;
201 warn 'found ' . $upcoming_mem_expires->count . ' soon expiring members'
205 $letter_type = 'MEMBERSHIP_EXPIRY' if !$letter_type;
206 while ( my $recent = $upcoming_mem_expires->next ) {
207 my $from_address = $recent->library->from_email_address;
208 my $letter = C4::Letters::GetPreparedLetter(
210 letter_code => $letter_type,
211 branchcode => $recent->branchcode,
212 lang => $recent->lang,
214 borrowers => $recent->borrowernumber,
215 branches => $recent->branchcode,
218 last if !$letter; # Letters.pm already warned, just exit
220 print $letter->{'content'}."\n";
222 C4::Letters::EnqueueLetter({
224 borrowernumber => $recent->borrowernumber,
225 from_address => $from_address,
226 message_transport_type => 'email',
231 cronlogaction({ action => 'End', info => "COMPLETED" });