@@ -, +, @@
-RETURN_RECALLED_ITEM
-PICKUP_RECALLED_ITEM
---
installer/data/mysql/atomicupdate/bug_19532_-_notices_for_recalls.sql | 2 ++
installer/data/mysql/en/mandatory/sample_notices.sql | 4 +++-
2 files changed, 5 insertions(+), 1 deletion(-)
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/en/mandatory/sample_notices.sql
+++ a/installer/data/mysql/en/mandatory/sample_notices.sql
@@ -173,4 +173,6 @@ INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`
('circulation', 'AR_COMPLETED', '', 'Article request - completed', 0, 'Article request completed', 'Dear <> <> (<>),\r\n\r\nWe have completed 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\nYou may pick your article up at <>.\r\n\r\nThank you!', 'email'),
('circulation', 'AR_PENDING', '', 'Article request - open', 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', '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','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');
--