From 3d379f8ea0c100f91d3518c37ddc95370aef10f2 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Thu, 20 Aug 2020 12:26:46 -0400 Subject: [PATCH] Bug 25534: (QA follow-up) Add sample notice --- .../mysql/atomicupdate/cancellation_reason.perl | 4 ++++ .../data/mysql/en/mandatory/sample_notices.yml | 13 +++++++++++++ 2 files changed, 17 insertions(+) diff --git a/installer/data/mysql/atomicupdate/cancellation_reason.perl b/installer/data/mysql/atomicupdate/cancellation_reason.perl index cd73a1803b..f1c1257de9 100644 --- a/installer/data/mysql/atomicupdate/cancellation_reason.perl +++ b/installer/data/mysql/atomicupdate/cancellation_reason.perl @@ -1,5 +1,9 @@ $DBversion = 'XXX'; # will be replaced by the RM if ( CheckVersion( $DBversion ) ) { + $dbh->do(q{ +INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default'); + }); + if ( !column_exists( 'reserves', 'cancellation_reason' ) ) { $dbh->do(q{ ALTER TABLE reserves ADD COLUMN `cancellation_reason` varchar(80) default NULL AFTER cancellationdate; diff --git a/installer/data/mysql/en/mandatory/sample_notices.yml b/installer/data/mysql/en/mandatory/sample_notices.yml index e2d4b121bf..7554abb5d3 100644 --- a/installer/data/mysql/en/mandatory/sample_notices.yml +++ b/installer/data/mysql/en/mandatory/sample_notices.yml @@ -1208,3 +1208,16 @@ tables: - "[% ELSE %]" - "The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]" - "[% END %]" + + - module: reserves + code: HOLD_CANCELLATION + branchcode: "" + name: "Notification of hold cancellation" + is_html: 0 + title: "Your hold was canceled." + message_transport_type: email + lang: default + content: + - "[%- USE AuthorisedValues -%]" + - "Dear [% borrower.firstname %] [% borrower.surname %]," + - "Your hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( 'HOLD_CANCELLATION', hold.cancellation_reason ) %]" -- 2.24.1 (Apple Git-126)