From d1a520822aacce86a047185d08216a22270f90ec 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! --- .../bug_30555-add_sample_notice_sms.pl | 22 +++++ .../mysql/en/mandatory/sample_notices.yml | 94 +++++++++++++++++++ 2 files changed, 116 insertions(+) create mode 100644 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 100644 index 0000000000..18bdcdc4ec --- /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','Hi <> <>,\r\nThe 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','Hi <> <>,\r\nThe following items have been checked out:\r\n----\r\n[% biblio.title %]\r\n----\r\nThank you.','sms','default'), + ('circulation','DUE','','Item due reminder',0,'Item due reminder','Hi,\r\nThe following item(s) are now due:\r\n<>','sms','default'), + ('circulation','DUEDGST','','Item due reminder (digest)',0,'Item due reminder','Hi\r\nYou have <> item(s) that are now due','sms','default'), + ('circulation','PREDUE','','Advance notice of item due',0,'Advance notice of item due','Hi\r\nThe following item will be due soon:\r\n<>, <> (<>)','sms','default'), + ('circulation','PREDUEDGST','','Advance notice of item due (digest)',0,'Advance notice of item due','Hi\r\nYou have <> item(s) that will be due soon.','sms','default'), + ('reserves','HOLD','','Hold available for pickup',0,'Hold available for pickup at <>','Hi\r\nYour hold for <> is available for pickup as of <>','sms','default') + }); + }, +}; diff --git a/installer/data/mysql/en/mandatory/sample_notices.yml b/installer/data/mysql/en/mandatory/sample_notices.yml index 95852015f5..f7f16bc9e1 100644 --- a/installer/data/mysql/en/mandatory/sample_notices.yml +++ b/installer/data/mysql/en/mandatory/sample_notices.yml @@ -402,6 +402,22 @@ 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: + - "Hi <> <>," + - "The following items have been checked in:" + - "----" + - "[% biblio.title %]" + - "----" + - "Thank you." + - module: circulation code: CHECKOUT branchcode: "" @@ -417,6 +433,22 @@ 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: + - "Hi <> <>," + - "The following items have been checked out:" + - "----" + - "[% biblio.title %]" + - "----" + - "Thank you." + - module: circulation code: CHECKOUT_NOTE branchcode: "" @@ -443,6 +475,19 @@ tables: - "" - "<>, <> (<>)" + - module: circulation + code: DUE + branchcode: "" + name: "Item due reminder" + is_html: 0 + title: "Item due reminder" + message_transport_type: sms + lang: default + content: + - "Hi," + - "The following item(s) are now due:" + - "<>" + - module: circulation code: DUEDGST branchcode: "" @@ -460,6 +505,18 @@ 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: + - "Hi" + - "You have <> item(s) that are now due" + - module: circulation code: HOLD_SLIP branchcode: "" @@ -627,6 +684,19 @@ 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: + - "Hi" + - "The following item will be due soon:" + - "<>, <> (<>)" + - module: circulation code: PREDUEDGST branchcode: "" @@ -644,6 +714,18 @@ 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: + - "Hi" + - "You have <> item(s) that will be due soon." + - module: circulation code: RENEWAL branchcode: "" @@ -1265,6 +1347,18 @@ 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: + - "Hi" + - "Your hold for <> is available for pickup as of <>" + - module: reserves code: HOLD branchcode: "" -- 2.25.1