From 8ca50537592d2533cea70e032dcfc280f63c2a69 Mon Sep 17 00:00:00 2001 From: Aleisha Amohia Date: Thu, 26 Oct 2017 00:59:44 +0000 Subject: [PATCH] Bug 19532: Notices for recalls The notices: -RETURN_RECALLED_ITEM -PICKUP_RECALLED_ITEM have been created and added to sample_notices.sql Changed tools/letter.pl to use recalls table --- installer/data/mysql/atomicupdate/bug_19532_-_notices_for_recalls.sql | 2 ++ installer/data/mysql/en/mandatory/sample_notices.sql | 2 ++ tools/letter.pl | 2 +- 3 files changed, 5 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_19532_-_notices_for_recalls.sql diff --git a/installer/data/mysql/atomicupdate/bug_19532_-_notices_for_recalls.sql b/installer/data/mysql/atomicupdate/bug_19532_-_notices_for_recalls.sql new file mode 100644 index 0000000..a96b584 --- /dev/null +++ b/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'); diff --git a/installer/data/mysql/en/mandatory/sample_notices.sql b/installer/data/mysql/en/mandatory/sample_notices.sql index 0eb0051..d772291 100644 --- a/installer/data/mysql/en/mandatory/sample_notices.sql +++ b/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'); diff --git a/tools/letter.pl b/tools/letter.pl index 9222079..dda51cb 100755 --- a/tools/letter.pl +++ b/tools/letter.pl @@ -253,7 +253,7 @@ sub add_form { {value => 'items.fine', text => 'items.fine'}, add_fields('borrowers'); if ($module eq 'circulation') { - push @{$field_selection}, add_fields('opac_news'); + push @{$field_selection}, add_fields('opac_news', 'recalls'); } -- 2.1.4