Attachment #102868 for bug #23787

View | Details | Raw Unified | Return to bug 23787
Collapse All | Expand All




    </tr>
</tfoot>
</table>', 'print', 'default');

INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
"Dear [% borrower.firstname %] [% borrower.surname %],
[% IF checkout.auto_renew_error %]
The following item, [% biblio.title %], has not been renewed because:
[% IF checkout.auto_renew_error == 'too_many' %]
You have reached the maximum number of checkouts possible.
[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
This item is on hold for another patron.
[% ELSIF checkout.auto_renew_error == 'restriction' %]
You are currently restricted.
[% ELSIF checkout.auto_renew_error == 'overdue' %]
You have overdue items.
[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
It\'s too late to renew this item.
[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
Your total unpaid fines are too high.
[% END %]
[% ELSE %]
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
[% END %]", 'email');




    </tr>
</tfoot>
</table>', 'print', 'default');

INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
"Dear [% borrower.firstname %] [% borrower.surname %],
[% IF checkout.auto_renew_error %]
The following item, [% biblio.title %], has not been renewed because:
[% IF checkout.auto_renew_error == 'too_many' %]
You have reached the maximum number of checkouts possible.
[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
This item is on hold for another patron.
[% ELSIF checkout.auto_renew_error == 'restriction' %]
You are currently restricted.
[% ELSIF checkout.auto_renew_error == 'overdue' %]
You have overdue items.
[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
It\'s too late to renew this item.
[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
Your total unpaid fines are too high.
[% END %]
[% ELSE %]
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
[% END %]", 'email');




    </tr>
</tfoot>
</table>', 'print', 'default');

INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
"Dear [% borrower.firstname %] [% borrower.surname %],
[% IF checkout.auto_renew_error %]
The following item, [% biblio.title %], has not been renewed because:
[% IF checkout.auto_renew_error == 'too_many' %]
You have reached the maximum number of checkouts possible.
[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
This item is on hold for another patron.
[% ELSIF checkout.auto_renew_error == 'restriction' %]
You are currently restricted.
[% ELSIF checkout.auto_renew_error == 'overdue' %]
You have overdue items.
[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
It\'s too late to renew this item.
[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
Your total unpaid fines are too high.
[% END %]
[% ELSE %]
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
[% END %]", 'email');




    </tr>
</tfoot>
</table>', 'print', 'default');

INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
"Dear [% borrower.firstname %] [% borrower.surname %],
[% IF checkout.auto_renew_error %]
The following item, [% biblio.title %], has not been renewed because:
[% IF checkout.auto_renew_error == 'too_many' %]
You have reached the maximum number of checkouts possible.
[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
This item is on hold for another patron.
[% ELSIF checkout.auto_renew_error == 'restriction' %]
You are currently restricted.
[% ELSIF checkout.auto_renew_error == 'overdue' %]
You have overdue items.
[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
It\'s too late to renew this item.
[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
Your total unpaid fines are too high.
[% END %]
[% ELSE %]
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
[% END %]", 'email');




    </tr>
</tfoot>
</table>', 'print', 'default');

INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
"Dear [% borrower.firstname %] [% borrower.surname %],
[% IF checkout.auto_renew_error %]
The following item, [% biblio.title %], has not been renewed because:
[% IF checkout.auto_renew_error == 'too_many' %]
You have reached the maximum number of checkouts possible.
[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
This item is on hold for another patron.
[% ELSIF checkout.auto_renew_error == 'restriction' %]
You are currently restricted.
[% ELSIF checkout.auto_renew_error == 'overdue' %]
You have overdue items.
[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
It\'s too late to renew this item.
[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
Your total unpaid fines are too high.
[% END %]
[% ELSE %]
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
[% END %]", 'email');




    </tr>
</tfoot>
</table>', 'print', 'default');

INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
"Dear [% borrower.firstname %] [% borrower.surname %],
[% IF checkout.auto_renew_error %]
The following item, [% biblio.title %], has not been renewed because:
[% IF checkout.auto_renew_error == 'too_many' %]
You have reached the maximum number of checkouts possible.
[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
This item is on hold for another patron.
[% ELSIF checkout.auto_renew_error == 'restriction' %]
You are currently restricted.
[% ELSIF checkout.auto_renew_error == 'overdue' %]
You have overdue items.
[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
It\'s too late to renew this item.
[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
Your total unpaid fines are too high.
[% END %]
[% ELSE %]
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
[% END %]", 'email');




    </tr>
</tfoot>
</table>', 'print', 'default');

INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
"Dear [% borrower.firstname %] [% borrower.surname %],
[% IF checkout.auto_renew_error %]
The following item, [% biblio.title %], has not been renewed because:
[% IF checkout.auto_renew_error == 'too_many' %]
You have reached the maximum number of checkouts possible.
[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
This item is on hold for another patron.
[% ELSIF checkout.auto_renew_error == 'restriction' %]
You are currently restricted.
[% ELSIF checkout.auto_renew_error == 'overdue' %]
You have overdue items.
[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
It\'s too late to renew this item.
[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
Your total unpaid fines are too high.
[% END %]
[% ELSE %]
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
[% END %]", 'email');




    </tr>
</tfoot>
</table>', 'print', 'default');

INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
"Dear [% borrower.firstname %] [% borrower.surname %],
[% IF checkout.auto_renew_error %]
The following item, [% biblio.title %], has not been renewed because:
[% IF checkout.auto_renew_error == 'too_many' %]
You have reached the maximum number of checkouts possible.
[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
This item is on hold for another patron.
[% ELSIF checkout.auto_renew_error == 'restriction' %]
You are currently restricted.
[% ELSIF checkout.auto_renew_error == 'overdue' %]
You have overdue items.
[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
It\'s too late to renew this item.
[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
Your total unpaid fines are too high.
[% END %]
[% ELSE %]
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
[% END %]", 'email');

Return to bug 23787

Lines 386-388 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here

(-)a/installer/data/mysql/de-DE/mandatory/sample_notices.sql (+21 lines)
386	</tr>	386	</tr>
387	</tfoot>	387	</tfoot>
388	</table>', 'print', 'default');	388	</table>', 'print', 'default');
		389
		390	INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
		391	"Dear [% borrower.firstname %] [% borrower.surname %],
		392	[% IF checkout.auto_renew_error %]
		393	The following item, [% biblio.title %], has not been renewed because:
		394	[% IF checkout.auto_renew_error == 'too_many' %]
		395	You have reached the maximum number of checkouts possible.
		396	[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
		397	This item is on hold for another patron.
		398	[% ELSIF checkout.auto_renew_error == 'restriction' %]
		399	You are currently restricted.
		400	[% ELSIF checkout.auto_renew_error == 'overdue' %]
		401	You have overdue items.
		402	[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
		403	It\'s too late to renew this item.
		404	[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
		405	Your total unpaid fines are too high.
		406	[% END %]
		407	[% ELSE %]
		408	The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
		409	[% END %]", 'email');

Lines 268-270 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here

(-)a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql (+21 lines)
268	</tr>	268	</tr>
269	</tfoot>	269	</tfoot>
270	</table>', 'print', 'default');	270	</table>', 'print', 'default');
		271
		272	INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
		273	"Dear [% borrower.firstname %] [% borrower.surname %],
		274	[% IF checkout.auto_renew_error %]
		275	The following item, [% biblio.title %], has not been renewed because:
		276	[% IF checkout.auto_renew_error == 'too_many' %]
		277	You have reached the maximum number of checkouts possible.
		278	[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
		279	This item is on hold for another patron.
		280	[% ELSIF checkout.auto_renew_error == 'restriction' %]
		281	You are currently restricted.
		282	[% ELSIF checkout.auto_renew_error == 'overdue' %]
		283	You have overdue items.
		284	[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
		285	It\'s too late to renew this item.
		286	[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
		287	Your total unpaid fines are too high.
		288	[% END %]
		289	[% ELSE %]
		290	The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
		291	[% END %]", 'email');

Lines 379-381 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here

(-)a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql (+21 lines)
379	</tr>	379	</tr>
380	</tfoot>	380	</tfoot>
381	</table>', 'print', 'default');	381	</table>', 'print', 'default');
		382
		383	INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
		384	"Dear [% borrower.firstname %] [% borrower.surname %],
		385	[% IF checkout.auto_renew_error %]
		386	The following item, [% biblio.title %], has not been renewed because:
		387	[% IF checkout.auto_renew_error == 'too_many' %]
		388	You have reached the maximum number of checkouts possible.
		389	[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
		390	This item is on hold for another patron.
		391	[% ELSIF checkout.auto_renew_error == 'restriction' %]
		392	You are currently restricted.
		393	[% ELSIF checkout.auto_renew_error == 'overdue' %]
		394	You have overdue items.
		395	[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
		396	It\'s too late to renew this item.
		397	[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
		398	Your total unpaid fines are too high.
		399	[% END %]
		400	[% ELSE %]
		401	The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
		402	[% END %]", 'email');

Lines 382-384 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here

(-)a/installer/data/mysql/it-IT/necessari/notices.sql (+21 lines)
382	</tr>	382	</tr>
383	</tfoot>	383	</tfoot>
384	</table>', 'print', 'default');	384	</table>', 'print', 'default');
		385
		386	INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
		387	"Dear [% borrower.firstname %] [% borrower.surname %],
		388	[% IF checkout.auto_renew_error %]
		389	The following item, [% biblio.title %], has not been renewed because:
		390	[% IF checkout.auto_renew_error == 'too_many' %]
		391	You have reached the maximum number of checkouts possible.
		392	[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
		393	This item is on hold for another patron.
		394	[% ELSIF checkout.auto_renew_error == 'restriction' %]
		395	You are currently restricted.
		396	[% ELSIF checkout.auto_renew_error == 'overdue' %]
		397	You have overdue items.
		398	[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
		399	It\'s too late to renew this item.
		400	[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
		401	Your total unpaid fines are too high.
		402	[% END %]
		403	[% ELSE %]
		404	The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
		405	[% END %]", 'email');

Lines 398-400 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here

(-)a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql (+21 lines)
398	</tr>	398	</tr>
399	</tfoot>	399	</tfoot>
400	</table>', 'print', 'default');	400	</table>', 'print', 'default');
		401
		402	INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
		403	"Dear [% borrower.firstname %] [% borrower.surname %],
		404	[% IF checkout.auto_renew_error %]
		405	The following item, [% biblio.title %], has not been renewed because:
		406	[% IF checkout.auto_renew_error == 'too_many' %]
		407	You have reached the maximum number of checkouts possible.
		408	[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
		409	This item is on hold for another patron.
		410	[% ELSIF checkout.auto_renew_error == 'restriction' %]
		411	You are currently restricted.
		412	[% ELSIF checkout.auto_renew_error == 'overdue' %]
		413	You have overdue items.
		414	[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
		415	It\'s too late to renew this item.
		416	[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
		417	Your total unpaid fines are too high.
		418	[% END %]
		419	[% ELSE %]
		420	The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
		421	[% END %]", 'email');

Lines 376-378 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here

(-)a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql (+21 lines)
376	</tr>	376	</tr>
377	</tfoot>	377	</tfoot>
378	</table>', 'print', 'default');	378	</table>', 'print', 'default');
		379
		380	INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
		381	"Dear [% borrower.firstname %] [% borrower.surname %],
		382	[% IF checkout.auto_renew_error %]
		383	The following item, [% biblio.title %], has not been renewed because:
		384	[% IF checkout.auto_renew_error == 'too_many' %]
		385	You have reached the maximum number of checkouts possible.
		386	[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
		387	This item is on hold for another patron.
		388	[% ELSIF checkout.auto_renew_error == 'restriction' %]
		389	You are currently restricted.
		390	[% ELSIF checkout.auto_renew_error == 'overdue' %]
		391	You have overdue items.
		392	[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
		393	It\'s too late to renew this item.
		394	[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
		395	Your total unpaid fines are too high.
		396	[% END %]
		397	[% ELSE %]
		398	The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
		399	[% END %]", 'email');

Lines 378-380 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here

(-)a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql (+21 lines)
378	</tr>	378	</tr>
379	</tfoot>	379	</tfoot>
380	</table>', 'print', 'default');	380	</table>', 'print', 'default');
		381
		382	INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
		383	"Dear [% borrower.firstname %] [% borrower.surname %],
		384	[% IF checkout.auto_renew_error %]
		385	The following item, [% biblio.title %], has not been renewed because:
		386	[% IF checkout.auto_renew_error == 'too_many' %]
		387	You have reached the maximum number of checkouts possible.
		388	[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
		389	This item is on hold for another patron.
		390	[% ELSIF checkout.auto_renew_error == 'restriction' %]
		391	You are currently restricted.
		392	[% ELSIF checkout.auto_renew_error == 'overdue' %]
		393	You have overdue items.
		394	[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
		395	It\'s too late to renew this item.
		396	[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
		397	Your total unpaid fines are too high.
		398	[% END %]
		399	[% ELSE %]
		400	The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
		401	[% END %]", 'email');

Lines 469-471 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here

(-)a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql (-1 / +21 lines)
469	</tr>	469	</tr>
470	</tfoot>	470	</tfoot>
471	</table>', 'print', 'default');	471	</table>', 'print', 'default');
472	-	472
		473	INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice',
		474	"Dear [% borrower.firstname %] [% borrower.surname %],
		475	[% IF checkout.auto_renew_error %]
		476	The following item, [% biblio.title %], has not been renewed because:
		477	[% IF checkout.auto_renew_error == 'too_many' %]
		478	You have reached the maximum number of checkouts possible.
		479	[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
		480	This item is on hold for another patron.
		481	[% ELSIF checkout.auto_renew_error == 'restriction' %]
		482	You are currently restricted.
		483	[% ELSIF checkout.auto_renew_error == 'overdue' %]
		484	You have overdue items.
		485	[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
		486	It\'s too late to renew this item.
		487	[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
		488	Your total unpaid fines are too high.
		489	[% END %]
		490	[% ELSE %]
		491	The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
		492	[% END %]", 'email');