From edbf6e98e9464f8ae7a58c8462eaab78fc2ddc92 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Mon, 20 Jan 2020 17:42:14 -0500 Subject: [PATCH] add workstation settings for saving default searches Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 27 ++++++++++++++++++ .../XXXX.data.acq_default_search_settings.sql | 33 ++++++++++++++++++++++ 2 files changed, 60 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.acq_default_search_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 a49cf02de8..1825be13ef 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -20308,3 +20308,30 @@ VALUES ( ) ); +INSERT INTO config.workstation_setting_type + (name, grp, datatype, label) +VALUES ( + 'eg.acq.search.default.lineitems', 'gui', 'object', + oils_i18n_gettext( + 'eg.acq.search.default.lineitems', + 'Acquisitions Default Search: Lineitems', + 'cwst', 'label') +), ( + 'eg.acq.search.default.purchaseorders', 'gui', 'object', + oils_i18n_gettext( + 'eg.acq.search.default.purchaseorders', + 'Acquisitions Default Search: Purchase Orders', + 'cwst', 'label') +), ( + 'eg.acq.search.default.invoices', 'gui', 'object', + oils_i18n_gettext( + 'eg.acq.search.default.invoices', + 'Acquisitions Default Search: Invoices', + 'cwst', 'label') +), ( + 'eg.acq.search.default.selectionlists', 'gui', 'object', + oils_i18n_gettext( + 'eg.acq.search.default.selectionlists', + 'Acquisitions Default Search: Selection Lists', + 'cwst', 'label') +); diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.acq_default_search_settings.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.acq_default_search_settings.sql new file mode 100644 index 0000000000..e9a7749e4e --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.acq_default_search_settings.sql @@ -0,0 +1,33 @@ +BEGIN; + +-- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +INSERT INTO config.workstation_setting_type + (name, grp, datatype, label) +VALUES ( + 'eg.acq.search.default.lineitems', 'gui', 'object', + oils_i18n_gettext( + 'eg.acq.search.default.lineitems', + 'Acquisitions Default Search: Lineitems', + 'cwst', 'label') +), ( + 'eg.acq.search.default.purchaseorders', 'gui', 'object', + oils_i18n_gettext( + 'eg.acq.search.default.purchaseorders', + 'Acquisitions Default Search: Purchase Orders', + 'cwst', 'label') +), ( + 'eg.acq.search.default.invoices', 'gui', 'object', + oils_i18n_gettext( + 'eg.acq.search.default.invoices', + 'Acquisitions Default Search: Invoices', + 'cwst', 'label') +), ( + 'eg.acq.search.default.selectionlists', 'gui', 'object', + oils_i18n_gettext( + 'eg.acq.search.default.selectionlists', + 'Acquisitions Default Search: Selection Lists', + 'cwst', 'label') +); + +COMMIT; -- 2.11.0