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

(-)a/installer/data/mysql/de-DE/mandatory/sample_notices.sql (+21 lines)
Lines 318-320 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here
318
318
319
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
319
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
320
('circulation', 'SR_SLIP', '', 'Report über Bestandsrotation', 0, 'Report über Bestandsrotation', 'Report über Bestandsrotation für [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] Exemplare wurden für diese Bibliothek bearbeitet.\r\n[% ELSE %]Es wurden keine Exemplare für diese Bibliothek bearbeitet\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Titel: [% item.title %]\r\nVerfasser: [% item.author %]\r\nSignatur: [% item.callnumber %]\r\nStandort: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nAusgeliehen?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nAktuelle Bibliothek: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
320
('circulation', 'SR_SLIP', '', 'Report über Bestandsrotation', 0, 'Report über Bestandsrotation', 'Report über Bestandsrotation für [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] Exemplare wurden für diese Bibliothek bearbeitet.\r\n[% ELSE %]Es wurden keine Exemplare für diese Bibliothek bearbeitet\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Titel: [% item.title %]\r\nVerfasser: [% item.author %]\r\nSignatur: [% item.callnumber %]\r\nStandort: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nAusgeliehen?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nAktuelle Bibliothek: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
321
322
INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'notification on auto renewing', 'Auto renewals',
323
"Dear [% borrower.firstname %] [% borrower.surname %],
324
[% IF checkout.auto_renew_error %]
325
The following item [% biblio.title %] has not been correctly renewed
326
[% IF checkout.auto_renew_error == 'too_many' %]
327
You have reach the maximum of checkouts possible.
328
[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
329
This item is on hold for another patron.
330
[% ELSIF checkout.auto_renew_error == 'restriction' %]
331
You are currently restricted.
332
[% ELSIF checkout.auto_renew_error == 'overdue' %]
333
You have overdues.
334
[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
335
It\'s too late to renew this checkout.
336
[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
337
You have too much unpaid fines.
338
[% END %]
339
[% ELSE %]
340
The following item [% biblio.title %] has correctly been renewed and is now due [% checkout.date_due %]
341
[% END %]", 'email');
(-)a/installer/data/mysql/en/mandatory/sample_notices.sql (+21 lines)
Lines 316-318 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here
316
316
317
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
317
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
318
('circulation', 'SR_SLIP', '', 'Stock rotation slip', 0, 'Stock rotation report', 'Stock rotation report for [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] items to be processed for this branch.\r\n[% ELSE %]No items to be processed for this branch\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Title: [% item.title %]\r\nAuthor: [% item.author %]\r\nCallnumber: [% item.callnumber %]\r\nLocation: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nOn loan?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nCurrent library: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
318
('circulation', 'SR_SLIP', '', 'Stock rotation slip', 0, 'Stock rotation report', 'Stock rotation report for [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] items to be processed for this branch.\r\n[% ELSE %]No items to be processed for this branch\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Title: [% item.title %]\r\nAuthor: [% item.author %]\r\nCallnumber: [% item.callnumber %]\r\nLocation: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nOn loan?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nCurrent library: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
319
320
INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'notification on auto renewing', 'Auto renewals',
321
"Dear [% borrower.firstname %] [% borrower.surname %],
322
[% IF checkout.auto_renew_error %]
323
The following item [% biblio.title %] has not been correctly renewed
324
[% IF checkout.auto_renew_error == 'too_many' %]
325
You have reach the maximum of checkouts possible.
326
[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
327
This item is on hold for another patron.
328
[% ELSIF checkout.auto_renew_error == 'restriction' %]
329
You are currently restricted.
330
[% ELSIF checkout.auto_renew_error == 'overdue' %]
331
You have overdues.
332
[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
333
It\'s too late to renew this checkout.
334
[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
335
You have too much unpaid fines.
336
[% END %]
337
[% ELSE %]
338
The following item [% biblio.title %] has correctly been renewed and is now due [% checkout.date_due %]
339
[% END %]", 'email');
(-)a/installer/data/mysql/es-ES/mandatory/sample_notices.sql (+21 lines)
Lines 311-313 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here
311
311
312
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
312
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
313
('circulation', 'SR_SLIP', '', 'Stock rotation slip', 0, 'Stock rotation report', 'Stock rotation report for [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] items to be processed for this branch.\r\n[% ELSE %]No items to be processed for this branch\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Title: [% item.title %]\r\nAuthor: [% item.author %]\r\nCallnumber: [% item.callnumber %]\r\nLocation: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nOn loan?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nCurrent library: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
313
('circulation', 'SR_SLIP', '', 'Stock rotation slip', 0, 'Stock rotation report', 'Stock rotation report for [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] items to be processed for this branch.\r\n[% ELSE %]No items to be processed for this branch\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Title: [% item.title %]\r\nAuthor: [% item.author %]\r\nCallnumber: [% item.callnumber %]\r\nLocation: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nOn loan?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nCurrent library: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
314
315
INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'notification on auto renewing', 'Auto renewals',
316
"Dear [% borrower.firstname %] [% borrower.surname %],
317
[% IF checkout.auto_renew_error %]
318
The following item [% biblio.title %] has not been correctly renewed
319
[% IF checkout.auto_renew_error == 'too_many' %]
320
You have reach the maximum of checkouts possible.
321
[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
322
This item is on hold for another patron.
323
[% ELSIF checkout.auto_renew_error == 'restriction' %]
324
You are currently restricted.
325
[% ELSIF checkout.auto_renew_error == 'overdue' %]
326
You have overdues.
327
[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
328
It\'s too late to renew this checkout.
329
[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
330
You have too much unpaid fines.
331
[% END %]
332
[% ELSE %]
333
The following item [% biblio.title %] has correctly been renewed and is now due [% checkout.date_due %]
334
[% END %]", 'email');
(-)a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql (+21 lines)
Lines 199-201 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here
199
199
200
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
200
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
201
('circulation', 'SR_SLIP', '', 'Ticket de rotation automatique d\'exemplaires', 0, 'Rapport de rotation automatique d\'exemplaires', 'Rapport de rotation automatique d\'exemplaires pour [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] exemplaires de cette bibliothèque à traiter.\r\n[% ELSE %]Aucun exemplaire de cette bibliothèque à traiter\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Titre : [% item.title %]\r\nAuteur : [% item.author %]\r\nCote : [% item.callnumber %]\r\nLocalisation : [% item.location %]\r\nCode-barres: [% item.barcode %]\r\nEn prêt? : [% item.onloan %]\r\nStatut : [% item.reason %]\r\nBibliothèque dépositaire : [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
201
('circulation', 'SR_SLIP', '', 'Ticket de rotation automatique d\'exemplaires', 0, 'Rapport de rotation automatique d\'exemplaires', 'Rapport de rotation automatique d\'exemplaires pour [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] exemplaires de cette bibliothèque à traiter.\r\n[% ELSE %]Aucun exemplaire de cette bibliothèque à traiter\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Titre : [% item.title %]\r\nAuteur : [% item.author %]\r\nCote : [% item.callnumber %]\r\nLocalisation : [% item.location %]\r\nCode-barres: [% item.barcode %]\r\nEn prêt? : [% item.onloan %]\r\nStatut : [% item.reason %]\r\nBibliothèque dépositaire : [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
202
203
INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'notification on auto renewing', 'Auto renewals',
204
"Dear [% borrower.firstname %] [% borrower.surname %],
205
[% IF checkout.auto_renew_error %]
206
The following item [% biblio.title %] has not been correctly renewed
207
[% IF checkout.auto_renew_error == 'too_many' %]
208
You have reach the maximum of checkouts possible.
209
[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
210
This item is on hold for another patron.
211
[% ELSIF checkout.auto_renew_error == 'restriction' %]
212
You are currently restricted.
213
[% ELSIF checkout.auto_renew_error == 'overdue' %]
214
You have overdues.
215
[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
216
It\'s too late to renew this checkout.
217
[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
218
You have too much unpaid fines.
219
[% END %]
220
[% ELSE %]
221
The following item [% biblio.title %] has correctly been renewed and is now due [% checkout.date_due %]
222
[% END %]", 'email');
(-)a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql (+21 lines)
Lines 312-314 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here
312
312
313
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
313
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
314
('circulation', 'SR_SLIP', '', 'Stock rotation slip', 0, 'Stock rotation report', 'Stock rotation report for [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] items to be processed for this branch.\r\n[% ELSE %]No items to be processed for this branch\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Title: [% item.title %]\r\nAuthor: [% item.author %]\r\nCallnumber: [% item.callnumber %]\r\nLocation: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nOn loan?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nCurrent library: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
314
('circulation', 'SR_SLIP', '', 'Stock rotation slip', 0, 'Stock rotation report', 'Stock rotation report for [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] items to be processed for this branch.\r\n[% ELSE %]No items to be processed for this branch\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Title: [% item.title %]\r\nAuthor: [% item.author %]\r\nCallnumber: [% item.callnumber %]\r\nLocation: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nOn loan?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nCurrent library: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
315
316
INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'notification on auto renewing', 'Auto renewals',
317
"Dear [% borrower.firstname %] [% borrower.surname %],
318
[% IF checkout.auto_renew_error %]
319
The following item [% biblio.title %] has not been correctly renewed
320
[% IF checkout.auto_renew_error == 'too_many' %]
321
You have reach the maximum of checkouts possible.
322
[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
323
This item is on hold for another patron.
324
[% ELSIF checkout.auto_renew_error == 'restriction' %]
325
You are currently restricted.
326
[% ELSIF checkout.auto_renew_error == 'overdue' %]
327
You have overdues.
328
[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
329
It\'s too late to renew this checkout.
330
[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
331
You have too much unpaid fines.
332
[% END %]
333
[% ELSE %]
334
The following item [% biblio.title %] has correctly been renewed and is now due [% checkout.date_due %]
335
[% END %]", 'email');
(-)a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql (+21 lines)
Lines 331-333 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here
331
331
332
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
332
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
333
('circulation', 'SR_SLIP', '', 'Stock rotation slip', 0, 'Stock rotation report', 'Stock rotation report for [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] items to be processed for this branch.\r\n[% ELSE %]No items to be processed for this branch\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Title: [% item.title %]\r\nAuthor: [% item.author %]\r\nCallnumber: [% item.callnumber %]\r\nLocation: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nOn loan?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nCurrent library: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
333
('circulation', 'SR_SLIP', '', 'Stock rotation slip', 0, 'Stock rotation report', 'Stock rotation report for [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] items to be processed for this branch.\r\n[% ELSE %]No items to be processed for this branch\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Title: [% item.title %]\r\nAuthor: [% item.author %]\r\nCallnumber: [% item.callnumber %]\r\nLocation: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nOn loan?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nCurrent library: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
334
335
INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'notification on auto renewing', 'Auto renewals',
336
"Dear [% borrower.firstname %] [% borrower.surname %],
337
[% IF checkout.auto_renew_error %]
338
The following item [% biblio.title %] has not been correctly renewed
339
[% IF checkout.auto_renew_error == 'too_many' %]
340
You have reach the maximum of checkouts possible.
341
[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
342
This item is on hold for another patron.
343
[% ELSIF checkout.auto_renew_error == 'restriction' %]
344
You are currently restricted.
345
[% ELSIF checkout.auto_renew_error == 'overdue' %]
346
You have overdues.
347
[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
348
It\'s too late to renew this checkout.
349
[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
350
You have too much unpaid fines.
351
[% END %]
352
[% ELSE %]
353
The following item [% biblio.title %] has correctly been renewed and is now due [% checkout.date_due %]
354
[% END %]", 'email');
(-)a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql (+21 lines)
Lines 309-311 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here
309
309
310
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
310
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
311
('circulation', 'SR_SLIP', '', 'Stock rotation slip', 0, 'Stock rotation report', 'Stock rotation report for [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] items to be processed for this branch.\r\n[% ELSE %]No items to be processed for this branch\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Title: [% item.title %]\r\nAuthor: [% item.author %]\r\nCallnumber: [% item.callnumber %]\r\nLocation: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nOn loan?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nCurrent library: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
311
('circulation', 'SR_SLIP', '', 'Stock rotation slip', 0, 'Stock rotation report', 'Stock rotation report for [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] items to be processed for this branch.\r\n[% ELSE %]No items to be processed for this branch\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Title: [% item.title %]\r\nAuthor: [% item.author %]\r\nCallnumber: [% item.callnumber %]\r\nLocation: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nOn loan?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nCurrent library: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
312
313
INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'notification on auto renewing', 'Auto renewals',
314
"Dear [% borrower.firstname %] [% borrower.surname %],
315
[% IF checkout.auto_renew_error %]
316
The following item [% biblio.title %] has not been correctly renewed
317
[% IF checkout.auto_renew_error == 'too_many' %]
318
You have reach the maximum of checkouts possible.
319
[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
320
This item is on hold for another patron.
321
[% ELSIF checkout.auto_renew_error == 'restriction' %]
322
You are currently restricted.
323
[% ELSIF checkout.auto_renew_error == 'overdue' %]
324
You have overdues.
325
[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
326
It\'s too late to renew this checkout.
327
[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
328
You have too much unpaid fines.
329
[% END %]
330
[% ELSE %]
331
The following item [% biblio.title %] has correctly been renewed and is now due [% checkout.date_due %]
332
[% END %]", 'email');
(-)a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql (+21 lines)
Lines 311-313 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here
311
311
312
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
312
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
313
('circulation', 'SR_SLIP', '', 'Stock Rotation Slip', 0, 'Stockrotation Report', 'Stockrotation report for [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] items to be processed for this branch.\r\n[% ELSE %]No items to be processed for this branch\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Title: [% item.title %]\r\nAuthor: [% item.author %]\r\nCallnumber: [% item.callnumber %]\r\nLocation: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nOn loan?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nCurrent library: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
313
('circulation', 'SR_SLIP', '', 'Stock Rotation Slip', 0, 'Stockrotation Report', 'Stockrotation report for [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] items to be processed for this branch.\r\n[% ELSE %]No items to be processed for this branch\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Title: [% item.title %]\r\nAuthor: [% item.author %]\r\nCallnumber: [% item.callnumber %]\r\nLocation: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nOn loan?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nCurrent library: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
314
315
INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'notification on auto renewing', 'Auto renewals',
316
"Dear [% borrower.firstname %] [% borrower.surname %],
317
[% IF checkout.auto_renew_error %]
318
The following item [% biblio.title %] has not been correctly renewed
319
[% IF checkout.auto_renew_error == 'too_many' %]
320
You have reach the maximum of checkouts possible.
321
[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
322
This item is on hold for another patron.
323
[% ELSIF checkout.auto_renew_error == 'restriction' %]
324
You are currently restricted.
325
[% ELSIF checkout.auto_renew_error == 'overdue' %]
326
You have overdues.
327
[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
328
It\'s too late to renew this checkout.
329
[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
330
You have too much unpaid fines.
331
[% END %]
332
[% ELSE %]
333
The following item [% biblio.title %] has correctly been renewed and is now due [% checkout.date_due %]
334
[% END %]", 'email');
(-)a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql (-1 / +21 lines)
Lines 400-402 INSERT IGNORE INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, Link Here
400
400
401
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
401
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
402
('circulation', 'SR_SLIP', '', 'Stock rotation slip', 0, 'Stock rotation report', 'Stock rotation report for [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] items to be processed for this branch.\r\n[% ELSE %]No items to be processed for this branch\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Title: [% item.title %]\r\nAuthor: [% item.author %]\r\nCallnumber: [% item.callnumber %]\r\nLocation: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nOn loan?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nCurrent library: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
402
('circulation', 'SR_SLIP', '', 'Stock rotation slip', 0, 'Stock rotation report', 'Stock rotation report for [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] items to be processed for this branch.\r\n[% ELSE %]No items to be processed for this branch\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Title: [% item.title %]\r\nAuthor: [% item.author %]\r\nCallnumber: [% item.callnumber %]\r\nLocation: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nOn loan?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nCurrent library: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
403
- 
403
404
INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'notification on auto renewing', 'Auto renewals',
405
"Dear [% borrower.firstname %] [% borrower.surname %],
406
[% IF checkout.auto_renew_error %]
407
The following item [% biblio.title %] has not been correctly renewed
408
[% IF checkout.auto_renew_error == 'too_many' %]
409
You have reach the maximum of checkouts possible.
410
[% ELSIF checkout.auto_renew_error == 'on_reserve' %]
411
This item is on hold for another patron.
412
[% ELSIF checkout.auto_renew_error == 'restriction' %]
413
You are currently restricted.
414
[% ELSIF checkout.auto_renew_error == 'overdue' %]
415
You have overdues.
416
[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]
417
It\'s too late to renew this checkout.
418
[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]
419
You have too much unpaid fines.
420
[% END %]
421
[% ELSE %]
422
The following item [% biblio.title %] has correctly been renewed and is now due [% checkout.date_due %]
423
[% END %]", 'email');

Return to bug 23787