From c11167a9eb8760bf517ab9a5a4bb750c33ab9e34 Mon Sep 17 00:00:00 2001 From: Shi Yao Wang Date: Fri, 15 Apr 2022 11:42:29 -0400 Subject: [PATCH] Bug 30555: Add more sample notice for sms messages Adds sms sample notice for due, hold, checkin and checkout Test plan: 1. Check that there are no SMS messages for these notices (Tools > Notices & slips): . CHECKIN - Item check-in (digest) . CHECKOUT - Item check-out (digest) . DUE - Item due reminder . DUEDGST - Item due reminder (digest) . PREDUE - Advance notice of item due . PREDUEDGST - Advance notice of item due (digest) . HOLD - Hold available for pickup 2. Apply the patch. 3. Update the database (./installer/data/mysql/updatedatabase.pl) 4. Refresh page 5. Check that there are now SMS notices for the notices listed in step 1. 6. Sign-off! Signed-off-by: Martin Renvoize --- .../bug_30555-add_sample_notice_sms.pl | 22 ++++ .../mysql/en/mandatory/sample_notices.yml | 103 ++++++++++++++++++ 2 files changed, 125 insertions(+) create mode 100755 installer/data/mysql/atomicupdate/bug_30555-add_sample_notice_sms.pl diff --git a/installer/data/mysql/atomicupdate/bug_30555-add_sample_notice_sms.pl b/installer/data/mysql/atomicupdate/bug_30555-add_sample_notice_sms.pl new file mode 100755 index 0000000000..9b9b70a084 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_30555-add_sample_notice_sms.pl @@ -0,0 +1,22 @@ +use Modern::Perl; + +return { + bug_number => "30555", + description => "Add more sample notice for sms messages", + up => sub { + my ($args) = @_; + my ($dbh, $out) = @$args{qw(dbh out)}; + $dbh->do(q{ + INSERT IGNORE INTO letter + (module,code,branchcode,name,is_html,title,content,message_transport_type,lang) + VALUES + ('circulation','CHECKIN','','Item check-in (digest)',0,'Check-ins','The following items have been checked in:\r\n----\r\n[% biblio.title %]\r\n----\r\nThank you.','sms','default'), + ('circulation','CHECKOUT','','Item check-out (digest)',0,'Checkouts','The following items have been checked out:\r\n----\r\n[% biblio.title %]\r\n----\r\nThank you for visiting [% branch.branchname %].','sms','default'), + ('circulation','DUE','','Item due reminder',0,'Item due reminder','Dear <> <>,\r\n\r\nThe following item is now due:\r\n\r\n<>','sms','default'), + ('circulation','DUEDGST','','Item due reminder (digest)',0,'Item due reminder','Dear <> <>,\r\n\r\nYou have <> item(s) that are now due\r\n\r\nThank you.','sms','default'), + ('circulation','PREDUE','','Advance notice of item due',0,'Advance notice of item due','Dear <> <>,\r\n\r\nThe following item will be due soon:\r\n\r\n<>','sms','default'), + ('circulation','PREDUEDGST','','Advance notice of item due (digest)',0,'Advance notice of item due','Dear <> <>,\r\n\r\nYou have <> item(s) that will be due soon.\r\n\r\nThank you.','sms','default'), + ('reserves','HOLD','','Hold available for pickup',0,'Hold available for pickup at <>','Dear <> <>,\r\n\r\nYour hold for <> is available for pickup.','sms','default') + }); + }, +}; diff --git a/installer/data/mysql/en/mandatory/sample_notices.yml b/installer/data/mysql/en/mandatory/sample_notices.yml index b18824ae20..a3c9c51a57 100644 --- a/installer/data/mysql/en/mandatory/sample_notices.yml +++ b/installer/data/mysql/en/mandatory/sample_notices.yml @@ -553,6 +553,21 @@ tables: - "----" - "Thank you." + - module: circulation + code: CHECKIN + branchcode: "" + name: "Item check-in (digest)" + is_html: 0 + title: "Check-ins" + message_transport_type: sms + lang: default + content: + - "The following items have been checked in:" + - "----" + - "[% biblio.title %]" + - "----" + - "Thank you." + - module: circulation code: CHECKOUT branchcode: "" @@ -568,6 +583,21 @@ tables: - "----" - "Thank you for visiting [% branch.branchname %]." + - module: circulation + code: CHECKOUT + branchcode: "" + name: "Item check-out (digest)" + is_html: 0 + title: "Checkouts" + message_transport_type: sms + lang: default + content: + - "The following items have been checked out:" + - "----" + - "[% biblio.title %]" + - "----" + - "Thank you for visiting [% branch.branchname %]." + - module: circulation code: CHECKOUT_NOTE branchcode: "" @@ -594,6 +624,21 @@ tables: - "" - "<>, <> (<>)" + - module: circulation + code: DUE + branchcode: "" + name: "Item due reminder" + is_html: 0 + title: "Item due reminder" + message_transport_type: sms + lang: default + content: + - "Dear <> <>," + - "" + - "The following item is now due:" + - "" + - "<>" + - module: circulation code: DUEDGST branchcode: "" @@ -611,6 +656,21 @@ tables: - "" - "Thank you." + - module: circulation + code: DUEDGST + branchcode: "" + name: "Item due reminder (digest)" + is_html: 0 + title: "Item due reminder" + message_transport_type: sms + lang: default + content: + - "Dear <> <>," + - "" + - "You have <> item(s) that are now due" + - "" + - "Thank you." + - module: circulation code: HOLD_SLIP branchcode: "" @@ -778,6 +838,21 @@ tables: - "" - "<>, <> (<>)" + - module: circulation + code: PREDUE + branchcode: "" + name: "Advance notice of item due" + is_html: 0 + title: "Advance notice of item due" + message_transport_type: sms + lang: default + content: + - "Dear <> <>," + - "" + - "The following item will be due soon:" + - "" + - "<>" + - module: circulation code: PREDUEDGST branchcode: "" @@ -795,6 +870,21 @@ tables: - "" - "Thank you." + - module: circulation + code: PREDUEDGST + branchcode: "" + name: "Advance notice of item due (digest)" + is_html: 0 + title: "Advance notice of item due" + message_transport_type: sms + lang: default + content: + - "Dear <> <>," + - "" + - "You have <> item(s) that will be due soon." + - "" + - "Thank you." + - module: circulation code: RENEWAL branchcode: "" @@ -1681,6 +1771,19 @@ tables: - "<>" - "<> <>" + - module: reserves + code: HOLD + branchcode: "" + name: "Hold available for pickup" + is_html: 0 + title: "Hold available for pickup at <>" + message_transport_type: sms + lang: default + content: + - "Dear <> <>," + - "" + - "Your hold for <> is available for pickup." + - module: reserves code: HOLD branchcode: "" -- 2.39.2