From e1ffe7586b9910ba7c52984500172aeb0349a392 Mon Sep 17 00:00:00 2001 From: Lucas Gass Date: Wed, 28 Apr 2021 20:48:37 +0000 Subject: [PATCH] Bug 28258: Update bad formatting in AUTO_RENEWALS notice To test: -Look at the AUTO_RENEWALS notice and see the syntax [% checkout.date_due as_due_date => 1 %] -Apply patch, updatedatabase -Look at the AUTO_RENEWALS notice and see the syntax [% checkout.date_due | $KohaDates as_due_date => 1%] --- .../atomicupdate/bug_28258_update_auto_renewals_template.perl | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_28258_update_auto_renewals_template.perl diff --git a/installer/data/mysql/atomicupdate/bug_28258_update_auto_renewals_template.perl b/installer/data/mysql/atomicupdate/bug_28258_update_auto_renewals_template.perl new file mode 100644 index 0000000000..612c20cac5 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_28258_update_auto_renewals_template.perl @@ -0,0 +1,10 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + $dbh->do(q{ + UPDATE letter SET + content = REPLACE(content, "The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due as_due_date => 1 %]" , "The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]") + WHERE code = 'AUTO_RENEWALS'; + }); + + NewVersion( $DBversion, 28258, "Update AUTO_RENEWAL content"); +} -- 2.11.0