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
34 This script sends membership expiry reminder notices to patrons.
35 It queues them in the message queue, which is processed by
36 the process_message_queue.pl cronjob.
44 Print a brief help message and exits.
48 Prints the manual page and exits.
52 Verbose. Without this flag set, only fatal errors are reported.
56 Do not send any email. Membership expire notices that would have been sent to
57 the patrons are printed to standard out.
61 Confirm flag: Add this option. The script will only print a usage
66 Optional branchcode to restrict the cronjob to that branch.
70 Optional parameter to extend the selection with a number of days BEFORE
71 the date set by the preference.
75 Optional parameter to extend the selection with a number of days AFTER
76 the date set by the preference.
82 The content of the messages is configured in Tools -> Notices and slips. Use the MEMBERSHIP_EXPIRY notice.
84 Typically, messages are prepared for each patron when the memberships are going to expire.
86 These emails are staged in the outgoing message queue, as are messages
87 produced by other features of Koha. This message queue must be
88 processed regularly by the
89 F<misc/cronjobs/process_message_queue.pl> program.
91 In the event that the C<-n> flag is passed to this program, no emails
92 are sent. Instead, messages are sent on standard output from this
95 Notices can contain variables enclosed in double angle brackets like
96 E<lt>E<lt>thisE<gt>E<gt>. Those variables will be replaced with values
97 specific to the soon expiring members.
98 Available variables are:
102 =item E<lt>E<lt>borrowers.*E<gt>E<gt>
104 any field from the borrowers table
106 =item E<lt>E<lt>branches.*E<gt>E<gt>
108 any field from the branches table
119 # find Koha's Perl modules
120 # test carefully before changing this
122 eval { require "$FindBin::Bin/../kohalib.pl" };
129 # These are defaults for command line options.
130 my $confirm; # -c: Confirm that the user has read and configured this script.
131 my $nomail; # -n: No mail. Will not send any emails.
132 my $verbose = 0; # -v: verbose
145 'branch:s' => \$branch,
146 'before:i' => \$before,
147 'after:i' => \$after,
150 pod2usage( -verbose => 2 ) if $man;
151 pod2usage(1) if $help || !$confirm;
155 my $expdays = C4::Context->preference('MembershipExpiryDaysNotice');
157 #If the pref is not set, we will exit
158 warn 'Exiting membership_expiry.pl: MembershipExpiryDaysNotice not set'
163 my $admin_adress = C4::Context->preference('KohaAdminEmailAddress');
164 warn 'getting upcoming membership expires' if $verbose;
165 my $upcoming_mem_expires = C4::Members::GetUpcomingMembershipExpires({ branch => $branch, before => $before, after => $after });
166 warn 'found ' . scalar( @$upcoming_mem_expires ) . ' soon expiring members'
170 foreach my $recent ( @$upcoming_mem_expires ) {
171 my $from_address = $recent->{'branchemail'} || $admin_adress;
172 my $letter_type = 'MEMBERSHIP_EXPIRY';
173 my $letter = C4::Letters::getletter( 'members', $letter_type,
174 $recent->{'branchcode'} );
175 die "no letter of type '$letter_type' found. Please see sample_notices.sql"
178 $letter = parse_letter({
180 borrowernumber => $recent->{'borrowernumber'},
181 firstname => $recent->{'firstname'},
182 categorycode => $recent->{'categorycode'},
183 branchcode => $recent->{'branchcode'},
187 print $letter->{'content'}."\n";
189 C4::Letters::EnqueueLetter({
191 borrowernumber => $recent->{'borrowernumber'},
192 from_address => $from_address,
193 message_transport_type => 'email',
207 foreach my $required ( qw( letter borrowernumber ) ) {
208 return unless exists $params->{$required};
210 my $letter = C4::Letters::GetPreparedLetter (
212 letter_code => 'MEMBERSHIP_EXPIRY',
214 'borrowers', $params->{'borrowernumber'},
215 'branches', $params->{'branchcode'}