This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "Evergreen ILS".
The branch, rel_3_15 has been updated
via d55b8ed60518dc2bfffd6a33089b5d672202aca5 (commit)
from dffe1bb95d0ea74a86d0421d4a76903defd60cb7 (commit)
Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.
- Log -----------------------------------------------------------------
commit d55b8ed60518dc2bfffd6a33089b5d672202aca5
Author: Jane Sandberg <js7389(a)princeton.edu>
Date: Fri Dec 20 14:16:31 2024 -0800
Forward-port 3.14.1 -> 3.14.2 upgrade script
Signed-off-by: Jane Sandberg <js7389(a)princeton.edu>
diff --git a/Open-ILS/src/sql/Pg/version-upgrade/3.14.1-3.14.2-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/3.14.1-3.14.2-upgrade-db.sql
new file mode 100644
index 0000000000..61a567826e
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/version-upgrade/3.14.1-3.14.2-upgrade-db.sql
@@ -0,0 +1,130 @@
+--Upgrade Script for 3.14.1 to 3.14.2
+\set eg_version '''3.14.2'''
+BEGIN;
+INSERT INTO config.upgrade_log (version, applied_to) VALUES ('3.14.2', :eg_version);
+-- check whether patch can be applied
+SELECT evergreen.upgrade_deps_block_check('1445', :eg_version);
+
+UPDATE action_trigger.event_definition
+SET template =
+$$
+
+[%- USE date -%][%- SET user = target.0.xact.usr -%]
+<div style="font-family: Arial, Helvetica, sans-serif;">
+
+ <!-- Header aligned left -->
+ <div style="text-align:left;">
+ <span style="padding-top:1em;">[% date.format %]</span>
+ </div><br/>
+
+ [% SET grand_total = 0.00 %]
+ <ol>
+ [% SET xact_mp_hash = {} %]
+ [% FOR mp IN target %][%# Create an array of transactions/amount paid for each payment made %]
+ [% SET xact_id = mp.xact.id %]
+ [% SET amount = mp.amount %]
+ [% IF ! xact_mp_hash.defined( xact_id ) %]
+ [% xact_mp_hash.$xact_id = { 'xact' => mp.xact, 'payment' => amount } %]
+ [% END %]
+ [% END %]
+
+ [% FOR xact_id IN xact_mp_hash.keys.sort %]
+ [% SET xact = xact_mp_hash.$xact_id.xact %]
+ <li>
+ Transaction ID: [% xact_mp_hash.$xact_id.xact.id %]<br />
+ [% IF xact.circulation %]
+ Title: "[% helpers.get_copy_bib_basics(xact.circulation.target_copy).title %]" <br />
+ [% END %]
+
+ [%# Go get all the date needed from xact_summary %]
+
+ [% SET mbts = xact.summary %]
+
+ Transaction Type: [% mbts.last_billing_type%]<br />
+ Date: [% mbts.last_billing_ts %] <br />
+
+ Note: [% mbts.last_billing_note %] <br />
+
+ Amount: $[% xact_mp_hash.$xact_id.payment | format("%.2f") %]
+ [% grand_total = grand_total + xact_mp_hash.$xact_id.payment %]
+ </li>
+ <br />
+ [% END %]
+ </ol>
+
+ <div> <!-- Summary of all the information -->
+ Payment Type: [% SWITCH mp.payment_type -%]
+ [% CASE "cash_payment" %]Cash
+ [% CASE "check_payment" %]Check
+ [% CASE "credit_card_payment" %]Credit Card
+ [%- IF mp.credit_card_payment.cc_number %] ([% mp.credit_card_payment.cc_number %])[% END %]
+ [% CASE "debit_card_payment" %]Debit Card
+ [% CASE "credit_payment" %]Credit
+ [% CASE "forgive_payment" %]Forgiveness
+ [% CASE "goods_payment" %]Goods
+ [% CASE "work_payment" %]Work
+ [%- END %] <br />
+ Total:<strong> $[% grand_total | format("%.2f") %] </strong>
+ </div>
+
+</div>
+$$
+WHERE id = 30 AND template =
+$$
+
+[%- USE date -%][%- SET user = target.0.xact.usr -%]
+<div style="font-family: Arial, Helvetica, sans-serif;">
+
+ <!-- Header aligned left -->
+ <div style="text-align:left;">
+ <span style="padding-top:1em;">[% date.format %]</span>
+ </div><br/>
+
+ [% SET grand_total = 0.00 %]
+ <ol>
+ [% SET xact_mp_hash = {} %]
+ [% FOR mp IN target %][%# Create an array of transactions/amount paid for each payment made %]
+ [% SET xact_id = mp.xact.id %]
+ [% SET amount = mp.amount %]
+ [% IF ! xact_mp_hash.defined( xact_id ) %]
+ [% xact_mp_hash.$xact_id = { 'xact' => mp.xact, 'payment' => amount } %]
+ [% END %]
+ [% END %]
+
+ [% FOR xact_id IN xact_mp_hash.keys.sort %]
+ [% SET xact = xact_mp_hash.$xact_id.xact %]
+ <li>
+ Transaction ID: [% xact_mp_hash.$xact_id.xact.id %]<br />
+ [% IF xact.circulation %]
+ Title: "[% helpers.get_copy_bib_basics(xact.circulation.target_copy).title %]" <br />
+ [% END %]
+
+ [%# Go get all the date needed from xact_summary %]
+
+ [% SET mbts = xact.summary %]
+
+ Transaction Type: [% mbts.last_billing_type%]<br />
+ Date: [% mbts.last_billing_ts %] <br />
+
+ Note: [% mbts.last_billing_note %] <br />
+
+ Amount: $[% xact_mp_hash.$xact_id.payment | format("%.2f") %]
+ [% grand_total = grand_total + xact_mp_hash.$xact_id.payment %]
+ </li>
+ <br />
+ [% END %]
+ </ol>
+
+ <div> <!-- Summary of all the information -->
+ Payment Type: Credit Card <br />
+ Total:<strong> $[% grand_total | format("%.2f") %] </strong>
+ </div>
+
+</div>
+$$;
+
+COMMIT;
+
+-- Update auditor tables to catch changes to source tables.
+-- Can be removed/skipped if there were no schema changes.
+SELECT auditor.update_auditors();
-----------------------------------------------------------------------
Summary of changes:
.../{3.13.6-3.13.7-upgrade-db.sql => 3.14.1-3.14.2-upgrade-db.sql} | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
copy Open-ILS/src/sql/Pg/version-upgrade/{3.13.6-3.13.7-upgrade-db.sql => 3.14.1-3.14.2-upgrade-db.sql} (98%)
hooks/post-receive
--
Evergreen ILS
