@@ -, +, @@
-RETURN_RECALLED_ITEM
-PICKUP_RECALLED_ITEM
---
.../data/mysql/atomicupdate/bug_19532_-_notices_for_recalls.sql | 2 ++
installer/data/mysql/de-DE/mandatory/sample_notices.sql | 4 +++-
installer/data/mysql/en/mandatory/sample_notices.sql | 2 ++
installer/data/mysql/es-ES/mandatory/sample_notices.sql | 4 +++-
installer/data/mysql/fr-CA/obligatoire/sample_notices.sql | 4 +++-
installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql | 4 +++-
installer/data/mysql/it-IT/necessari/notices.sql | 4 +++-
installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql | 4 +++-
installer/data/mysql/pl-PL/mandatory/sample_notices.sql | 4 +++-
installer/data/mysql/ru-RU/mandatory/sample_notices.sql | 4 +++-
installer/data/mysql/uk-UA/mandatory/sample_notices.sql | 5 +++--
tools/letter.pl | 2 +-
12 files changed, 32 insertions(+), 11 deletions(-)
create mode 100644 installer/data/mysql/atomicupdate/bug_19532_-_notices_for_recalls.sql
--- a/installer/data/mysql/atomicupdate/bug_19532_-_notices_for_recalls.sql
+++ a/installer/data/mysql/atomicupdate/bug_19532_-_notices_for_recalls.sql
@@ -0,0 +1,2 @@
+INSERT IGNORE INTO `letter` (module, code, branchcode, name, is_html, title, content, message_transport_type) VALUES ('circulation','RETURN_RECALLED_ITEM','','Notification to return a recalled item','0','Notification to return a recalled item',"
Date: <>
\n\n<> <>,
\n\nA recall has been placed on the following item: <> / <> (<>). The due date has been updated, and is now <>. Please return the item before the due date.\n\nThank you!",'email');
+INSERT IGNORE INTO `letter` (module, code, branchcode, name, is_html, title, content, message_transport_type) VALUES ('circulation','PICKUP_RECALLED_ITEM','','Recalled item awaiting pickup','0','Recalled item awaiting pickup',"Date: <>
\n\n<> <>,
\n\nA recall that you requested on the following item: <> / <> (<>) is now ready for you to pick up at <>. Please pick up your item by <>.\n\nThank you!",'email');
--- a/installer/data/mysql/de-DE/mandatory/sample_notices.sql
+++ a/installer/data/mysql/de-DE/mandatory/sample_notices.sql
@@ -162,4 +162,6 @@ INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`
('circulation', 'AR_PENDING', '', 'Artikelbestellung - Offen', 0, 'Artikelbestellung ist eingegangen', 'Liebe/r <> <> (<>)\r\n\r\nIhre Artikelbestellung aus <> (<>) ist bei uns eingegangen.\r\n\r\nBestellter Artikel:\r\nTitel: <>\r\nVerfasser: <>\r\nJahrgang/Band: <>\r\nHeft: <>\r\nJahr/Datum: <>\r\nSeiten: <>\r\nKapitel: <>\r\nHinweise: <>\r\n\r\n\r\nVielen Dank!', 'email'),
('circulation', 'AR_SLIP', '', 'Artikelbestellung - Quittung', 0, 'Artikelbestellung', 'Artikelbestellung:\r\n\r\n<> <> (<>)\r\n\r\nTitel: <>\r\nBarcode: <>\r\n\r\nBestellter Artikel:\r\nTitle: <>\r\nVerfasser: <>\r\nJahrgang/Band: <>\r\nHeft: <>\r\nJahr/Datum: <>\r\nSeiten: <>\r\nKapitel: <>\r\nHinweise: <>\r\n', 'print'),
('circulation', 'AR_PROCESSING', '', 'Artikelbestellung - In Bearbeitung', 0, 'Artikelbestellung in Bearbeitung', 'Liebe/r <> <> (<>)\r\n\r\nIhre Artikelbestellung aus <> (<>) wird zur Zeit bearbeitet.\r\n\r\nBestellter Artikel:\r\nTitel: <>\r\nVerfasser: <>\r\nBand/Jahrgang: <>\r\nHeft: <>\r\nJahr/Datum: <>\r\nSeiten: <>\r\nKapitel: <>\r\nHinweise: <>\r\n\r\nVielen Dank!', 'email'),
-('circulation', 'CHECKOUT_NOTE', '', 'Checkout note on item set by patron', '0', 'Checkout note', '<> <> has added a note to the item <> - <> (<>).','email');
+('circulation', 'CHECKOUT_NOTE', '', 'Checkout note on item set by patron', '0', 'Checkout note', '<> <> has added a note to the item <> - <> (<>).','email'),
+('circulation','RETURN_RECALLED_ITEM','','Notification to return a recalled item','0','Notification to return a recalled item',"Date: <>
\n\n<> <>,
\n\nA recall has been placed on the following item: <> / <> (<>). The due date has been updated, and is now <>. Please return the item before the due date.\n\nThank you!",'email'),
+('circulation','PICKUP_RECALLED_ITEM','','Recalled item awaiting pickup','0','Recalled item awaiting pickup',"Date: <>
\n\n<> <>,
\n\nA recall that you requested on the following item: <> / <> (<>) is now ready for you to pick up at <>. Please pick up your item by <>.\n\nThank you!",'email');
--- a/installer/data/mysql/en/mandatory/sample_notices.sql
+++ a/installer/data/mysql/en/mandatory/sample_notices.sql
@@ -175,3 +175,5 @@ INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`
('circulation', 'AR_SLIP', '', 'Article request - print slip', 0, 'Article request', 'Article request:\r\n\r\n<> <> (<>),\r\n\r\nTitle: <>\r\nBarcode: <>\r\n\r\nArticle requested:\r\nTitle: <>\r\nAuthor: <>\r\nVolume: <>\r\nIssue: <>\r\nDate: <>\r\nPages: <>\r\nChapters: <>\r\nNotes: <>\r\n', 'print'),
('circulation', 'AR_PROCESSING', '', 'Article request - processing', 0, 'Article request processing', 'Dear <> <> (<>),\r\n\r\nWe are now processing your request for an article from <> (<>).\r\n\r\nArticle requested:\r\nTitle: <>\r\nAuthor: <>\r\nVolume: <>\r\nIssue: <>\r\nDate: <>\r\nPages: <>\r\nChapters: <>\r\nNotes: <>\r\n\r\nThank you!', 'email'),
('circulation', 'CHECKOUT_NOTE', '', 'Checkout note on item set by patron', '0', 'Checkout note', '<> <> has added a note to the item <> - <> (<>).','email');
+('circulation','RETURN_RECALLED_ITEM','','Notification to return a recalled item','0','Notification to return a recalled item',"Date: <>
\n\n<> <>,
\n\nA recall has been placed on the following item: <> / <> (<>). The due date has been updated, and is now <>. Please return the item before the due date.\n\nThank you!",'email'),
+('circulation','PICKUP_RECALLED_ITEM','','Recalled item awaiting pickup','0','Recalled item awaiting pickup',"Date: <>
\n\n<> <>,
\n\nA recall that you requested on the following item: <> / <> (<>) is now ready for you to pick up at <>. Please pick up your item by <>.\n\nThank you!",'email');
--- a/installer/data/mysql/es-ES/mandatory/sample_notices.sql
+++ a/installer/data/mysql/es-ES/mandatory/sample_notices.sql
@@ -169,4 +169,6 @@ INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`
('circulation', 'AR_PENDING', '', 'Article request - pending', 0, 'Article request received', 'Dear <> <> (<>)\r\n\r\nWe have received your request for an article from <> (<>).\r\n\r\nArticle requested:\r\nTitle: <>\r\nAuthor: <>\r\nVolume: <>\r\nIssue: <>\r\nDate: <>\r\nPages: <>\r\nChapters: <>\r\nNotes: <>\r\n\r\n\r\nThank you!', 'email'),
('circulation', 'AR_SLIP', '', 'Article request - print slip', 0, 'Article request', 'Article request:\r\n\r\n<> <> (<>),\r\n\r\nTitle: <>\r\nBarcode: <>\r\n\r\nArticle requested:\r\nTitle: <>\r\nAuthor: <>\r\nVolume: <>\r\nIssue: <>\r\nDate: <>\r\nPages: <>\r\nChapters: <>\r\nNotes: <>\r\n', 'print'),
('circulation', 'AR_PROCESSING', '', 'Article request - processing', 0, 'Article request processing', 'Dear <> <> (<>),\r\n\r\nWe are now processing your request for an article from <> (<>).\r\n\r\nArticle requested:\r\nTitle: <>\r\nAuthor: <>\r\nVolume: <>\r\nIssue: <>\r\nDate: <>\r\nPages: <>\r\nChapters: <>\r\nNotes: <>\r\n\r\nThank you!', 'email'),
-('circulation', 'CHECKOUT_NOTE', '', 'Checkout note on item set by patron', '0', 'Checkout note', '<> <> has added a note to the item <> - <> (<>).','email');
+('circulation', 'CHECKOUT_NOTE', '', 'Checkout note on item set by patron', '0', 'Checkout note', '<> <> has added a note to the item <> - <> (<>).','email'),
+('circulation','RETURN_RECALLED_ITEM','','Notification to return a recalled item','0','Notification to return a recalled item',"Date: <>
\n\n<> <>,
\n\nA recall has been placed on the following item: <> / <> (<>). The due date has been updated, and is now <>. Please return the item before the due date.\n\nThank you!",'email'),
+('circulation','PICKUP_RECALLED_ITEM','','Recalled item awaiting pickup','0','Recalled item awaiting pickup',"Date: <>
\n\n<> <>,
\n\nA recall that you requested on the following item: <> / <> (<>) is now ready for you to pick up at <>. Please pick up your item by <>.\n\nThank you!",'email');
--- a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql
+++ a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql
@@ -53,7 +53,9 @@ INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`
('circulation', 'AR_PENDING', '', 'Article request - pending', 0, 'Article request received', 'Dear <> <> (<>)\r\n\r\nWe have received your request for an article from <> (<>).\r\n\r\nArticle requested:\r\nTitle: <>\r\nAuthor: <>\r\nVolume: <>\r\nIssue: <>\r\nDate: <>\r\nPages: <>\r\nChapters: <>\r\nNotes: <>\r\n\r\n\r\nThank you!', 'email'),
('circulation', 'AR_SLIP', '', 'Article request - print slip', 0, 'Article request', 'Article request:\r\n\r\n<> <> (<>),\r\n\r\nTitle: <>\r\nBarcode: <>\r\n\r\nArticle requested:\r\nTitle: <>\r\nAuthor: <>\r\nVolume: <>\r\nIssue: <>\r\nDate: <>\r\nPages: <>\r\nChapters: <>\r\nNotes: <>\r\n', 'print'),
('circulation', 'AR_PROCESSING', '', 'Article request - processing', 0, 'Article request processing', 'Dear <> <> (<>),\r\n\r\nWe are now processing your request for an article from <> (<>).\r\n\r\nArticle requested:\r\nTitle: <>\r\nAuthor: <>\r\nVolume: <>\r\nIssue: <>\r\nDate: <>\r\nPages: <>\r\nChapters: <>\r\nNotes: <>\r\n\r\nThank you!', 'email'),
-('circulation', 'CHECKOUT_NOTE', '', 'Checkout note on item set by patron', '0', 'Checkout note', '<> <> has added a note to the item <> - <> (<>).','email');
+('circulation', 'CHECKOUT_NOTE', '', 'Checkout note on item set by patron', '0', 'Checkout note', '<> <> has added a note to the item <> - <> (<>).','email'),
+('circulation','RETURN_RECALLED_ITEM','','Notification to return a recalled item','0','Notification to return a recalled item',"Date: <>
\n\n<> <>,
\n\nA recall has been placed on the following item: <> / <> (<>). The due date has been updated, and is now <>. Please return the item before the due date.\n\nThank you!",'email'),
+('circulation','PICKUP_RECALLED_ITEM','','Recalled item awaiting pickup','0','Recalled item awaiting pickup',"Date: <>
\n\n<> <>,
\n\nA recall that you requested on the following item: <> / <> (<>) is now ready for you to pick up at <>. Please pick up your item by <>.\n\nThank you!",'email');
INSERT INTO `letter` (module, code, branchcode, name, is_html, title, content, message_transport_type)
VALUES ('members','PASSWORD_RESET','','Online password reset',1,'Koha password recovery','\r\nThis email has been sent in response to your password recovery request for the account <>.\r\n
\r\n\r\nYou can now create your new password using the following link:\r\n
>\"><>\r\n
\r\nThis link will be valid for 2 days from this email\'s reception, then you must reapply if you do not change your password.
\r\nThank you.
\r\n\r\n','email'),
--- a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
+++ a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
@@ -170,4 +170,6 @@ INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`
('circulation', 'AR_PENDING', '', 'Article request - pending', 0, 'Article request received', 'Dear <> <> (<>)\r\n\r\nWe have received your request for an article from <> (<>).\r\n\r\nArticle requested:\r\nTitle: <>\r\nAuthor: <>\r\nVolume: <>\r\nIssue: <>\r\nDate: <>\r\nPages: <>\r\nChapters: <>\r\nNotes: <>\r\n\r\n\r\nThank you!', 'email'),
('circulation', 'AR_SLIP', '', 'Article request - print slip', 0, 'Article request', 'Article request:\r\n\r\n<> <> (<>),\r\n\r\nTitle: <>\r\nBarcode: <>\r\n\r\nArticle requested:\r\nTitle: <>\r\nAuthor: <>\r\nVolume: <>\r\nIssue: <>\r\nDate: <>\r\nPages: <>\r\nChapters: <>\r\nNotes: <>\r\n', 'print'),
('circulation', 'AR_PROCESSING', '', 'Article request - processing', 0, 'Article request processing', 'Dear <> <> (<>),\r\n\r\nWe are now processing your request for an article from <> (<