From a67de67b5d5981e74d076dd8f5e1987f39c1079f Mon Sep 17 00:00:00 2001 From: Jane Sandberg Date: Mon, 1 Apr 2024 17:09:52 -0700 Subject: [PATCH 01/16] Forward-port 3.12.2-3.12.3 upgrade script Signed-off-by: Jane Sandberg --- .../3.12.2-3.12.3-upgrade-db.sql | 51 +++++++++++++++++++ 1 file changed, 51 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/version-upgrade/3.12.2-3.12.3-upgrade-db.sql diff --git a/Open-ILS/src/sql/Pg/version-upgrade/3.12.2-3.12.3-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/3.12.2-3.12.3-upgrade-db.sql new file mode 100644 index 0000000000..483cd7522d --- /dev/null +++ b/Open-ILS/src/sql/Pg/version-upgrade/3.12.2-3.12.3-upgrade-db.sql @@ -0,0 +1,51 @@ +--Upgrade Script for 3.12.2 to 3.12.3 +\set eg_version '''3.12.3''' +BEGIN; +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('3.12.3', :eg_version); + +SELECT evergreen.upgrade_deps_block_check('1403', :eg_version); + +UPDATE action_trigger.event_definition SET template = + +$$ +[%- +# target is the book list itself. The 'items' variable does not need to be in +# the environment because a special reactor will take care of filling it in. + +FOR item IN items; + bibxml = helpers.unapi_bre(item.target_biblio_record_entry, {flesh => '{mra}'}); + title = ""; + FOR part IN bibxml.findnodes('//*[@tag="245"]/*[@code="a" or @code="b" or @code="n" or @code="p"]'); + title = title _ part.textContent; + END; + author = bibxml.findnodes('//*[@tag="100"]/*[@code="a"]').textContent; + item_type = bibxml.findnodes('//*[local-name()="attributes"]/*[local-name()="field"][@name="item_type"]').getAttribute('coded-value'); + pub_date = ""; + FOR pdatum IN bibxml.findnodes('//*[@tag="260"]/*[@code="c"]'); + IF pub_date ; + pub_date = pub_date _ ", " _ pdatum.textContent; + ELSE ; + pub_date = pdatum.textContent; + END; + END; + helpers.csv_datum(title) %],[% helpers.csv_datum(author) %],[% helpers.csv_datum(pub_date) %],[% helpers.csv_datum(item_type) %],[% FOR note IN item.notes; helpers.csv_datum(note.note); ","; END; "\n"; +END -%] +$$ + +WHERE hook = 'container.biblio_record_entry_bucket.csv' AND MD5(template) = '386d7ab2a78a69a44a47e2b0b8c5699b'; + + +SELECT evergreen.upgrade_deps_block_check('1404', :eg_version); + +UPDATE config.org_unit_setting_type +SET description = oils_i18n_gettext('acq.default_owning_lib_for_auto_lids_strategy', + 'Strategy to use when setting the default owning library for line item items that are auto-created due to the provider''s default copy count being set. Valid values are "workstation" to use the workstation library, "blank" to leave it blank, and "use_setting" to use the "Default owning library for auto-created line item items" setting. If not set, the workstation library will be used.', + 'coust', 'description') +WHERE name = 'acq.default_owning_lib_for_auto_lids_strategy' +AND description = 'Stategy to use to set default owning library to set when line item items are auto-created because the provider''s default copy count has been set. Valid values are "workstation" to use the workstation library, "blank" to leave it blank, and "use_setting" to use the "Default owning library for auto-created line item items" setting. If not set, the workstation library will be used.'; + +COMMIT; + +-- Update auditor tables to catch changes to source tables. +-- Can be removed/skipped if there were no schema changes. +SELECT auditor.update_auditors(); -- 2.43.2 From 5ec7c5e025a800aa76126ac03f2a9cc031e6ff21 Mon Sep 17 00:00:00 2001 From: Terran McCanna Date: Mon, 10 Dec 2018 14:17:42 -0500 Subject: [PATCH 02/16] LP#2002572 Alert when no hold notification options Present an alert if no notification options are selected in the OPAC. Fixed the removed classes used for counting the number of notification methods used. Signed-off-by: Terran McCanna Signed-off-by: Steven Mayo Signed-off-by: Michele Morgan Signed-off-by: Gina Monti Signed-off-by: Jane Sandberg Signed-off-by: blake --- .../opac/parts/place_hold.tt2 | 4 ++-- .../js/ui/default/opac/holds-validation.js | 19 +++++++++++++++++-- 2 files changed, 19 insertions(+), 4 deletions(-) diff --git a/Open-ILS/src/templates-bootstrap/opac/parts/place_hold.tt2 b/Open-ILS/src/templates-bootstrap/opac/parts/place_hold.tt2 index b07679656f..0bead4906b 100755 --- a/Open-ILS/src/templates-bootstrap/opac/parts/place_hold.tt2 +++ b/Open-ILS/src/templates-bootstrap/opac/parts/place_hold.tt2 @@ -310,7 +310,7 @@ document.addEventListener("DOMContentLoaded", () => { [% l('Notify when hold is ready for pickup?') %]

- +