From b63e80d18dc87f30d66fdd4914ea77bd24d6a75e Mon Sep 17 00:00:00 2001 From: Kathy Lussier Date: Wed, 29 Aug 2018 17:00:39 -0400 Subject: [PATCH] LP#1712854: Add wide_hold grid settings to server storage Adds the new wide_hold grid settings used in the holds shelf and record holds interfaces to server storage, as is done with other grid settings. Also removes the legacy eg.grid.circ.holds.shelf and eg.grid.cat.catalog.holds settings. Signed-off-by: Kathy Lussier Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 12 ++++----- ...X.data.wide_holds-workstation-settings.sql | 25 +++++++++++++++++++ 2 files changed, 31 insertions(+), 6 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.wide_holds-workstation-settings.sql diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql index cf51b6007f..7973a4df59 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -18714,10 +18714,10 @@ VALUES ( 'cwst', 'label' ) ), ( - 'eg.grid.cat.catalog.holds', 'gui', 'object', + 'eg.grid.cat.catalog.wide_holds', 'gui', 'object', oils_i18n_gettext( - 'eg.grid.cat.catalog.holds', - 'Grid Config: cat.catalog.holds', + 'eg.grid.cat.catalog.wide_holds', + 'Grid Config: cat.catalog.wide_holds', 'cwst', 'label' ) ), ( @@ -18735,10 +18735,10 @@ VALUES ( 'cwst', 'label' ) ), ( - 'eg.grid.circ.holds.shelf', 'gui', 'object', + 'eg.grid.circ.wide_holds.shelf', 'gui', 'object', oils_i18n_gettext( - 'eg.grid.circ.holds.shelf', - 'Grid Config: circ.holds.shelf', + 'eg.grid.circ.wide_holds.shelf', + 'Grid Config: circ.wide_holds.shelf', 'cwst', 'label' ) ), ( diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.wide_holds-workstation-settings.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.wide_holds-workstation-settings.sql new file mode 100644 index 0000000000..e693d68782 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.wide_holds-workstation-settings.sql @@ -0,0 +1,25 @@ +BEGIN; + +--SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +INSERT into config.workstation_setting_type (name, grp, datatype, label) +VALUES ( + 'eg.grid.circ.wide_holds.shelf', 'gui', 'object', + oils_i18n_gettext ( + 'eg.grid.circ.wide_holds.shelf', + 'Grid Config: circ.wide_holds.shelf', + 'cwst', 'label' + ) +), ( + 'eg.grid.cat.catalog.wide_holds', 'gui', 'object', + oils_i18n_gettext( + 'eg.grid.cat.catalog.wide_holds', + 'Grid Config: cat.catalog.wide_holds', + 'cwst', 'label' + ) +); + +DELETE from config.workstation_setting_type +WHERE name = 'eg.grid.cat.catalog.holds' OR name = 'eg.grid.circ.holds.shelf'; + +COMMIT; -- 2.43.2