1 ALTER TABLE issues ADD COLUMN auto_renew_error VARCHAR(32) DEFAULT NULL AFTER auto_renew;
2 ALTER TABLE old_issues ADD COLUMN auto_renew_error VARCHAR(32) DEFAULT NULL AFTER auto_renew;
4 INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'notification on auto renewing', 'Auto renewals',
5 "Dear [% borrower.firstname %] [% borrower.surname %],
6 [% IF checkout.auto_renew_error %]
7 The following item [% biblio.title %] has not been correctly renewed
8 [% IF checkout.auto_renew_error == 'too_many' %]
9 You have reach the maximum of checkouts possible.
10 [% ELSIF checkout.auto_renew_error == 'on_reserve' %]
11 This item is on hold for another patron.
12 [% ELSIF checkout.auto_renew_error == 'restriction' %]
13 You are currently restricted.
14 [% ELSIF checkout.auto_renew_error == 'overdue' %]
16 [% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
17 It\'s too late to renew this checkout.
18 [% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
19 You have too much unpaid fines.
22 The following item [% biblio.title %] has correctly been renewed and is now due [% checkout.date_due %]