Bugzilla – Attachment 148252 Details for
Bug 30555
Add more sample notice for SMS messages
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 30555: Add more sample notice for sms messages
Bug-30555-Add-more-sample-notice-for-sms-messages.patch (text/plain), 8.17 KB, created by
Martin Renvoize (ashimema)
on 2023-03-16 08:36:04 UTC
(
hide
)
Description:
Bug 30555: Add more sample notice for sms messages
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2023-03-16 08:36:04 UTC
Size:
8.17 KB
patch
obsolete
>From c11167a9eb8760bf517ab9a5a4bb750c33ab9e34 Mon Sep 17 00:00:00 2001 >From: Shi Yao Wang <shiyao@inlibro.com> >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 <martin.renvoize@ptfs-europe.com> >--- > .../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 <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThe following item is now due:\r\n\r\n<<biblio.title>>','sms','default'), >+ ('circulation','DUEDGST','','Item due reminder (digest)',0,'Item due reminder','Dear <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nYou have <<count>> 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 <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThe following item will be due soon:\r\n\r\n<<biblio.title>>','sms','default'), >+ ('circulation','PREDUEDGST','','Advance notice of item due (digest)',0,'Advance notice of item due','Dear <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nYou have <<count>> 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 <<branches.branchname>>','Dear <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nYour hold for <<biblio.title>> 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: > - "" > - "<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)" > >+ - module: circulation >+ code: DUE >+ branchcode: "" >+ name: "Item due reminder" >+ is_html: 0 >+ title: "Item due reminder" >+ message_transport_type: sms >+ lang: default >+ content: >+ - "Dear <<borrowers.firstname>> <<borrowers.surname>>," >+ - "" >+ - "The following item is now due:" >+ - "" >+ - "<<biblio.title>>" >+ > - 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 <<borrowers.firstname>> <<borrowers.surname>>," >+ - "" >+ - "You have <<count>> item(s) that are now due" >+ - "" >+ - "Thank you." >+ > - module: circulation > code: HOLD_SLIP > branchcode: "" >@@ -778,6 +838,21 @@ tables: > - "" > - "<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)" > >+ - 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 <<borrowers.firstname>> <<borrowers.surname>>," >+ - "" >+ - "The following item will be due soon:" >+ - "" >+ - "<<biblio.title>>" >+ > - 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 <<borrowers.firstname>> <<borrowers.surname>>," >+ - "" >+ - "You have <<count>> item(s) that will be due soon." >+ - "" >+ - "Thank you." >+ > - module: circulation > code: RENEWAL > branchcode: "" >@@ -1681,6 +1771,19 @@ tables: > - "<<branches.branchaddress3>>" > - "<<branches.branchcity>> <<branches.branchzip>>" > >+ - module: reserves >+ code: HOLD >+ branchcode: "" >+ name: "Hold available for pickup" >+ is_html: 0 >+ title: "Hold available for pickup at <<branches.branchname>>" >+ message_transport_type: sms >+ lang: default >+ content: >+ - "Dear <<borrowers.firstname>> <<borrowers.surname>>," >+ - "" >+ - "Your hold for <<biblio.title>> is available for pickup." >+ > - module: reserves > code: HOLD > branchcode: "" >-- >2.39.2
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 30555
:
133360
|
139692
|
140192
| 148252