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@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