From 789aece5bb6d719bcc56738c43187f92cf5d7e79 Mon Sep 17 00:00:00 2001 From: Jason Boyer Date: Tue, 21 Sep 2021 14:34:26 -0400 Subject: [PATCH] LP1174498: Recalculate on account_adjustment A missing trigger causes mmpbt to be out of date if the last "payment" for a bill is an account_adjustment Signed-off-by: Jason Boyer --- Open-ILS/src/sql/Pg/080.schema.money.sql | 4 ++++ .../Pg/upgrade/XXXX.money.materialized_payment_by_billing_type.sql | 3 +++ 2 files changed, 7 insertions(+) diff --git a/Open-ILS/src/sql/Pg/080.schema.money.sql b/Open-ILS/src/sql/Pg/080.schema.money.sql index 3f69b37c67..057d651ba9 100644 --- a/Open-ILS/src/sql/Pg/080.schema.money.sql +++ b/Open-ILS/src/sql/Pg/080.schema.money.sql @@ -1357,6 +1357,10 @@ CREATE TRIGGER calculate_payment_by_btype_tgr AFTER INSERT OR UPDATE OR DELETE ON money.credit_card_payment FOR EACH ROW EXECUTE PROCEDURE money.payment_by_billing_type_trigger(); +CREATE TRIGGER calculate_payment_by_btype_tgr + AFTER INSERT OR UPDATE OR DELETE ON money.account_adjustment + FOR EACH ROW EXECUTE PROCEDURE money.payment_by_billing_type_trigger(); + COMMIT; diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.money.materialized_payment_by_billing_type.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.money.materialized_payment_by_billing_type.sql index 98fee86fa9..9afbed4aa4 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.money.materialized_payment_by_billing_type.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.money.materialized_payment_by_billing_type.sql @@ -569,6 +569,9 @@ CREATE TRIGGER calculate_payment_by_btype_tgr AFTER INSERT OR UPDATE OR DELETE ON money.credit_card_payment FOR EACH ROW EXECUTE PROCEDURE money.payment_by_billing_type_trigger(); +CREATE TRIGGER calculate_payment_by_btype_tgr + AFTER INSERT OR UPDATE OR DELETE ON money.account_adjustment + FOR EACH ROW EXECUTE PROCEDURE money.payment_by_billing_type_trigger(); COMMIT; -- 2.11.0