From 8e40461f90e1ac1cf5978757813743956376867f Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Mon, 20 Jan 2020 17:42:14 -0500 Subject: [PATCH] LP#1850547: Seed data for Angular acquisitions search * grid persistance WS settings * retrieve-results-immediately sticky checkbox settings * default saved searches settings Sponsored-by: Evergreen Community Development Initiative Sponsored-by: Georgia Public Library Service Sponsored-by: Indiana State Library Sponsored-by: C/W MARS Signed-off-by: Galen Charlton Signed-off-by: Tiffany Little Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 83 ++++++++++++++++++++ .../Pg/upgrade/XXXX.data.angular_acq_search.sql | 89 ++++++++++++++++++++++ 2 files changed, 172 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.angular_acq_search.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 36e655d460..7ddbde596a 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -20456,3 +20456,86 @@ 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') +); + +INSERT INTO config.workstation_setting_type + (name, grp, datatype, label) +VALUES ( + 'eg.acq.search.lineitems.run_immediately', 'gui', 'bool', + oils_i18n_gettext( + 'eg.acq.search.lineitems.run_immediately', + 'Acquisitions Search: Immediately Search Lineitems', + 'cwst', 'label') +), ( + 'eg.acq.search.purchaseorders.run_immediately', 'gui', 'bool', + oils_i18n_gettext( + 'eg.acq.search.purchaseorders.run_immediately', + 'Acquisitions Search: Immediately Search Purchase Orders', + 'cwst', 'label') +), ( + 'eg.acq.search.invoices.run_immediately', 'gui', 'bool', + oils_i18n_gettext( + 'eg.acq.search.invoices.run_immediately', + 'Acquisitions Search: Immediately Search Invoices', + 'cwst', 'label') +), ( + 'eg.acq.search.selectionlists.run_immediately', 'gui', 'bool', + oils_i18n_gettext( + 'eg.acq.search.selectionlists.run_immediately', + 'Acquisitions Search: Immediately Search Selection Lists', + 'cwst', 'label') +); + +INSERT INTO config.workstation_setting_type + (name, grp, datatype, label) +VALUES ( + 'eg.grid.acq.search.lineitems', 'gui', 'object', + oils_i18n_gettext( + 'eg.grid.acq.search.lineitems', + 'Grid Config: acq.search.lineitems', + 'cwst', 'label') +), ( + 'eg.grid.acq.search.purchaseorders', 'gui', 'object', + oils_i18n_gettext( + 'eg.grid.acq.search.purchaseorders', + 'Grid Config: acq.search.purchaseorders', + 'cwst', 'label') +), ( + 'eg.grid.acq.search.selectionlists', 'gui', 'object', + oils_i18n_gettext( + 'eg.grid.acq.search.selectionlists', + 'Grid Config: acq.search.selectionlists', + 'cwst', 'label') +), ( + 'eg.grid.acq.search.invoices', 'gui', 'object', + oils_i18n_gettext( + 'eg.grid.acq.search.invoices', + 'Grid Config: acq.search.invoices', + 'cwst', 'label') +); diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.angular_acq_search.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.angular_acq_search.sql new file mode 100644 index 0000000000..b3482e0e6c --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.angular_acq_search.sql @@ -0,0 +1,89 @@ +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') +); + +INSERT INTO config.workstation_setting_type + (name, grp, datatype, label) +VALUES ( + 'eg.acq.search.lineitems.run_immediately', 'gui', 'bool', + oils_i18n_gettext( + 'eg.acq.search.lineitems.run_immediately', + 'Acquisitions Search: Immediately Search Lineitems', + 'cwst', 'label') +), ( + 'eg.acq.search.purchaseorders.run_immediately', 'gui', 'bool', + oils_i18n_gettext( + 'eg.acq.search.purchaseorders.run_immediately', + 'Acquisitions Search: Immediately Search Purchase Orders', + 'cwst', 'label') +), ( + 'eg.acq.search.invoices.run_immediately', 'gui', 'bool', + oils_i18n_gettext( + 'eg.acq.search.invoices.run_immediately', + 'Acquisitions Search: Immediately Search Invoices', + 'cwst', 'label') +), ( + 'eg.acq.search.selectionlists.run_immediately', 'gui', 'bool', + oils_i18n_gettext( + 'eg.acq.search.selectionlists.run_immediately', + 'Acquisitions Search: Immediately Search Selection Lists', + 'cwst', 'label') +); + +INSERT INTO config.workstation_setting_type + (name, grp, datatype, label) +VALUES ( + 'eg.grid.acq.search.lineitems', 'gui', 'object', + oils_i18n_gettext( + 'eg.grid.acq.search.lineitems', + 'Grid Config: acq.search.lineitems', + 'cwst', 'label') +), ( + 'eg.grid.acq.search.purchaseorders', 'gui', 'object', + oils_i18n_gettext( + 'eg.grid.acq.search.purchaseorders', + 'Grid Config: acq.search.purchaseorders', + 'cwst', 'label') +), ( + 'eg.grid.acq.search.selectionlists', 'gui', 'object', + oils_i18n_gettext( + 'eg.grid.acq.search.selectionlists', + 'Grid Config: acq.search.selectionlists', + 'cwst', 'label') +), ( + 'eg.grid.acq.search.invoices', 'gui', 'object', + oils_i18n_gettext( + 'eg.grid.acq.search.invoices', + 'Grid Config: acq.search.invoices', + 'cwst', 'label') +); + +COMMIT; -- 2.11.0