From 55c0fd83e5555bbe6fca21f0f4626037cffa6a98 Mon Sep 17 00:00:00 2001 From: Michele Morgan Date: Fri, 5 Apr 2019 16:55:19 -0400 Subject: [PATCH] LP#1729435: Add Seed Data for WS type for Bill Full Details grids Adds the config.workstation_setting_type values to the seed data and an upgrade script to allow storing in the database. Signed-off-by: Michele Morgan Signed-off-by: Jennifer Pringle Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 15 +++++++++++++++ ...XX.data.circ-payment-detail-grid-persist-key.sql | 21 +++++++++++++++++++++ 2 files changed, 36 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.circ-payment-detail-grid-persist-key.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 8c0d5fd12e..f1442266f4 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -19974,3 +19974,18 @@ VALUES ( 'cwst', 'label' ) ); + +INSERT INTO config.workstation_setting_type (name, grp, datatype, label) +VALUES ( + 'eg.grid.circ.patron.xact_details_details_bills', 'gui', 'object', + oils_i18n_gettext( + 'eg.grid.circ.patron.xact_details_details_bills', + 'Grid Config: circ.patron.xact_details_details_bills', + 'cwst', 'label') +), ( + 'eg.grid.circ.patron.xact_details_details_payments', 'gui', 'object', + oils_i18n_gettext( + 'eg.grid.circ.patron.xact_details_details_payments', + 'Grid Config: circ.patron.xact_details_details_payments', + 'cwst', 'label') +); diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.circ-payment-detail-grid-persist-key.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.circ-payment-detail-grid-persist-key.sql new file mode 100644 index 0000000000..32ee3075f5 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.circ-payment-detail-grid-persist-key.sql @@ -0,0 +1,21 @@ +BEGIN; + +-- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +INSERT INTO config.workstation_setting_type + (name, grp, datatype, label) +VALUES ( + 'eg.grid.circ.patron.xact_details_details_bills', 'gui', 'object', + oils_i18n_gettext( + 'eg.grid.circ.patron.xact_details_details_bills', + 'Grid Config: circ.patron.xact_details_details_bills', + 'cwst', 'label') +), ( + 'eg.grid.circ.patron.xact_details_details_payments', 'gui', 'object', + oils_i18n_gettext( + 'eg.grid.circ.patron.xact_details_details_payments', + 'Grid Config: circ.patron.xact_details_details_payments', + 'cwst', 'label') +); + +COMMIT; -- 2.11.0