From b1a00e89429eee12558fb5e7e5dcb0534c7d3c4c Mon Sep 17 00:00:00 2001 From: Andrew Fuerste-Henry Date: Wed, 11 Mar 2020 00:43:20 +0000 Subject: [PATCH] Bug 23787: add AUTO_RENEWALS to sample_notices To test: - create a new install - confirm presence of auto renewal notice Signed-off-by: David Nind --- .../data/mysql/atomicupdate/add_auto_renewals.perl | 35 ++++++++++++++++++++++ .../data/mysql/en/mandatory/sample_notices.yml | 29 ++++++++++++++++++ 2 files changed, 64 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/add_auto_renewals.perl diff --git a/installer/data/mysql/atomicupdate/add_auto_renewals.perl b/installer/data/mysql/atomicupdate/add_auto_renewals.perl new file mode 100644 index 0000000000..f9a16bba7c --- /dev/null +++ b/installer/data/mysql/atomicupdate/add_auto_renewals.perl @@ -0,0 +1,35 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + # you can use $dbh here like: + $dbh->do( q{ + INSERT INTO letter (module, code, name, title, content, message_transport_type) VALUES ('circulation', 'AUTO_RENEWALS', 'Notification of automatic renewal', 'Automatic renewal notice', +"Dear [% borrower.firstname %] [% borrower.surname %], +[% IF checkout.auto_renew_error %] +The following item, [% biblio.title %], has not been renewed because: +[% IF checkout.auto_renew_error == 'too_many' %] +You have reached the maximum number of checkouts possible. +[% ELSIF checkout.auto_renew_error == 'on_reserve' %] +This item is on hold for another patron. +[% ELSIF checkout.auto_renew_error == 'restriction' %] +You are currently restricted. +[% ELSIF checkout.auto_renew_error == 'overdue' %] +You have overdue items. +[% ELSIF checkout.auto_renew_error == 'auto_too_late' %] +It\'s too late to renew this item. +[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %] +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 %] +[% END %]", 'email'); + } ); + + # or perform some test and warn + # if( !column_exists( 'biblio', 'biblionumber' ) ) { + # warn "There is something wrong"; + # } + + # Always end with this (adjust the bug info) + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 23787 - add AUTO_RENEWALS to sample_notices)\n"; +} diff --git a/installer/data/mysql/en/mandatory/sample_notices.yml b/installer/data/mysql/en/mandatory/sample_notices.yml index a2b7dec89b..e21ad3e3e1 100644 --- a/installer/data/mysql/en/mandatory/sample_notices.yml +++ b/installer/data/mysql/en/mandatory/sample_notices.yml @@ -1145,3 +1145,32 @@ tables: - "Thank you," - "" - "<>" + + - module: circulation + code: AUTO_RENEWALS + branchcode: "" + name: "Notification of automatic renewal" + is_html: 0 + title: "Automatic renewal notice" + message_transport_type: email + lang: default + content: + - "Dear [% borrower.firstname %] [% borrower.surname %]," + - "[% IF checkout.auto_renew_error %]" + - "The following item, [% biblio.title %], has not been renewed because:" + - "[% IF checkout.auto_renew_error == 'too_many' %]" + - "You have reached the maximum number of checkouts possible." + - "[% ELSIF checkout.auto_renew_error == 'on_reserve' %]" + - "This item is on hold for another patron." + - "[% ELSIF checkout.auto_renew_error == 'restriction' %]" + - "You are currently restricted." + - "[% ELSIF checkout.auto_renew_error == 'overdue' %]" + - "You have overdue items." + - "[% ELSIF checkout.auto_renew_error == 'auto_too_late' %]" + - "It\'s too late to renew this item." + - "[% ELSIF checkout.auto_renew_error == 'auto_too_much_oweing' %]" + - "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 %]" + - "[% END %]" -- 2.11.0