From 8da533ecb4126fdaa6cd6386a4468fe11550e4da Mon Sep 17 00:00:00 2001 From: Jane Sandberg Date: Tue, 25 Oct 2022 21:08:04 -0700 Subject: [PATCH] LP1411819 stamp upgrade script and add release notes Signed-off-by: Jane Sandberg --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...exceeds-fines.sql => 1342.permit-renew-when-exceeds-fines.sql} | 2 ++ docs/RELEASE_NOTES_NEXT/Administration/renewal_on_max_fines.adoc | 8 ++++++++ 3 files changed, 11 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.permit-renew-when-exceeds-fines.sql => 1342.permit-renew-when-exceeds-fines.sql} (99%) create mode 100644 docs/RELEASE_NOTES_NEXT/Administration/renewal_on_max_fines.adoc diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index a440396847..991f4eeef4 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -92,7 +92,7 @@ CREATE TRIGGER no_overlapping_deps BEFORE INSERT OR UPDATE ON config.db_patch_dependencies FOR EACH ROW EXECUTE PROCEDURE evergreen.array_overlap_check ('deprecates'); -INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1341', :eg_version); -- miker/sandbergja/dyrcona/blake +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1342', :eg_version); -- jeffdavis/blake/sandbergja CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.permit-renew-when-exceeds-fines.sql b/Open-ILS/src/sql/Pg/upgrade/1342.permit-renew-when-exceeds-fines.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.permit-renew-when-exceeds-fines.sql rename to Open-ILS/src/sql/Pg/upgrade/1342.permit-renew-when-exceeds-fines.sql index ec127d74ab..9632a42ac7 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.permit-renew-when-exceeds-fines.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1342.permit-renew-when-exceeds-fines.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('1342', :eg_version); + INSERT INTO config.org_unit_setting_type (name, label, datatype, description, grp, update_perm, view_perm) VALUES ( diff --git a/docs/RELEASE_NOTES_NEXT/Administration/renewal_on_max_fines.adoc b/docs/RELEASE_NOTES_NEXT/Administration/renewal_on_max_fines.adoc new file mode 100644 index 0000000000..83f203fec9 --- /dev/null +++ b/docs/RELEASE_NOTES_NEXT/Administration/renewal_on_max_fines.adoc @@ -0,0 +1,8 @@ +== Optionally allow patrons to renew after hitting fine maximum == + +When a patron hits the max fine limit, a standing penalty is applied to their account. By default, that penalty (PATRON_EXCEEDS_FINES) +is configured to block renewals. + +This release adds a new org unit setting, _circ.permit_renew_when_exceeds_fines_. If enabled for a particular org unit, renewals are +permitted (as long as all other circulation eligibility criteria are met). + -- 2.11.0