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, main has been updated via b25f6a8837881e0c9b050a63764418bf9849d770 (commit) from fd26d0fcd024dab8d0268aeb3c94dd2f7a117d00 (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 b25f6a8837881e0c9b050a63764418bf9849d770 Author: Jane Sandberg <js7389@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@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