Bug 24378: (follow-up) Format due date as due date

Changes the due date formatting as was already done
for the new sample files on bug 23787.

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>

diff --git a/installer/data/mysql/atomicupdate/bug_24378_auto_renewals.perl b/installer/data/mysql/atomicupdate/bug_24378_auto_renewals.perl
index a958035..6dd5c1d 100644 (file)
--- a/installer/data/mysql/atomicupdate/bug_24378_auto_renewals.perl
+++ b/installer/data/mysql/atomicupdate/bug_24378_auto_renewals.perl
@@ -27,7 +27,7 @@ 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 [% checkout.date_due %]", "The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
+        content = REPLACE(content, "The following item [% biblio.title %] has correctly been renewed and is now due [% checkout.date_due | $KohaDates as_due_date => 1 %]", "The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
 ")
         WHERE code = 'AUTO_RENEWALS';
     });

diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
index d31355c..5333deb 100755 (executable)
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -14456,7 +14456,7 @@ if( CheckVersion( $DBversion ) ) {
         Your total unpaid fines are too high.
         [% END %]
         [% ELSE %]
-        The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %]
+        The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
         [% END %]", 'email');
     });