From 5063143ed489912d5fade46b75cc7bf1b4be7541 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Fri, 3 Sep 2021 11:54:02 -0400 Subject: [PATCH] staff portal: update seed data Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/002.schema.config.sql | 26 +++++++++++++++++ Open-ILS/src/sql/Pg/800.fkeys.sql | 5 ++++ Open-ILS/src/sql/Pg/950.data.seed-values.sql | 34 ++++++++++++++++++++-- .../Pg/upgrade/XXXX.schema.portal_page_table.sql | 4 +-- 4 files changed, 65 insertions(+), 4 deletions(-) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 20f10915a2..6562fde41a 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -1382,4 +1382,30 @@ CREATE TABLE config.geolocation_service ( api_key TEXT ); +CREATE TABLE config.ui_staff_portal_page_entry_type ( + code TEXT PRIMARY KEY, + label TEXT NOT NULL +); + +INSERT INTO config.ui_staff_portal_page_entry_type (code, label) +VALUES + ('link', oils_i18n_gettext('link', 'Link', 'cusppet', 'label')), + ('menuitem', oils_i18n_gettext('menuitem', 'Menu Item', 'cusppet', 'label')), + ('text', oils_i18n_gettext('text', 'Text and/or HTML', 'cusppet', 'label')), + ('header', oils_i18n_gettext('header', 'Header', 'cusppet', 'label')), + ('catalogsearch', oils_i18n_gettext('catalogsearch', 'Catalog Search Box', 'cusppet', 'label')); + + +CREATE TABLE config.ui_staff_portal_page_entry ( + id SERIAL PRIMARY KEY, + page_col INTEGER NOT NULL, + col_pos INTEGER NOT NULL, + entry_type TEXT NOT NULL, -- REFERENCES config.ui_staff_portal_page_entry_type(code) + label TEXT, + image_url TEXT, + target_url TEXT, + entry_text TEXT, + owner INT NOT NULL -- REFERENCES actor.org_unit (id) +); + COMMIT; diff --git a/Open-ILS/src/sql/Pg/800.fkeys.sql b/Open-ILS/src/sql/Pg/800.fkeys.sql index 6ddf4cc326..9fdb93305f 100644 --- a/Open-ILS/src/sql/Pg/800.fkeys.sql +++ b/Open-ILS/src/sql/Pg/800.fkeys.sql @@ -269,4 +269,9 @@ ALTER TABLE config.print_template ADD CONSTRAINT cpt_owner_fkey ALTER TABLE config.geolocation_service ADD CONSTRAINT cgs_owner_fkey FOREIGN KEY (owner) REFERENCES actor.org_unit(id) DEFERRABLE INITIALLY DEFERRED; +ALTER TABLE config.ui_staff_portal_page_entry ADD CONSTRAINT cusppe_entry_type_fkey + FOREIGN KEY (entry_type) REFERENCES config.ui_staff_portal_page_entry_type(code) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED; +ALTER TABLE config.ui_staff_portal_page_entry ADD CONSTRAINT cusppe_owner_fkey + FOREIGN KEY (owner) REFERENCES actor.org_unit(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED; + COMMIT; 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 027aecb0ff..5cb799078b 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -1960,10 +1960,11 @@ INSERT INTO permission.perm_list ( id, code, description ) VALUES ( 631, 'ADMIN_GEOLOCATION_SERVICES', oils_i18n_gettext(631, 'Administer geographic location services', 'ppl', 'description')), ( 632, 'UPDATE_USER_PHOTO_URL', oils_i18n_gettext(632, - 'Update the user photo url field in patron registration and editor', 'ppl', 'description')) + 'Update the user photo url field in patron registration and editor', 'ppl', 'description')), + ( 633, 'ADMIN_STAFF_PORTAL_PAGE', oils_i18n_gettext( 633, + 'Update the staff client portal page', 'ppl', 'description' )) ; - SELECT SETVAL('permission.perm_list_id_seq'::TEXT, 1000); INSERT INTO permission.grp_tree (id, name, parent, description, perm_interval, usergroup, application_perm) VALUES @@ -21813,3 +21814,32 @@ VALUES ( ) ); +INSERT INTO config.ui_staff_portal_page_entry + (id, page_col, col_pos, entry_type, label, image_url, target_url, owner) +VALUES + ( 1, 1, 0, 'header', oils_i18n_gettext( 1, 'Circulation and Patrons', 'cusppe', 'label'), NULL, NULL, 1) +, ( 2, 1, 1, 'menuitem', oils_i18n_gettext( 2, 'Check Out Items', 'cusppe', 'label'), '/images/portal/forward.png', '/eg/staff/circ/patron/bcsearch', 1) +, ( 3, 1, 2, 'menuitem', oils_i18n_gettext( 3, 'Check In Items', 'cusppe', 'label'), '/images/portal/back.png', '/eg/staff/circ/checkin/index', 1) +, ( 4, 1, 3, 'menuitem', oils_i18n_gettext( 4, 'Search For Patron By Name', 'cusppe', 'label'), '/images/portal/retreivepatron.png', '/eg/staff/circ/patron/search', 1) +, ( 5, 2, 0, 'header', oils_i18n_gettext( 5, 'Item Search and Cataloging', 'cusppe', 'label'), NULL, NULL, 1) +, ( 6, 2, 1, 'catalogsearch', oils_i18n_gettext( 6, 'Search Catalog', 'cusppe', 'label'), NULL, NULL, 1) +, ( 7, 2, 2, 'menuitem', oils_i18n_gettext( 7, 'Record Buckets', 'cusppe', 'label'), '/images/portal/bucket.png', '/eg/staff/cat/bucket/record/', 1) +, ( 8, 2, 3, 'menuitem', oils_i18n_gettext( 8, 'Item Buckets', 'cusppe', 'label'), '/images/portal/bucket.png', '/eg/staff/cat/bucket/copy/', 1) +, ( 9, 3, 0, 'header', oils_i18n_gettext( 9, 'Administration', 'cusppe', 'label'), NULL, NULL, 1) +, (10, 3, 1, 'link', oils_i18n_gettext(10, 'Evergreen Documentation', 'cusppe', 'label'), '/images/portal/helpdesk.png', 'https://docs.evergreen-ils.org', 1) +, (11, 3, 2, 'menuitem', oils_i18n_gettext(11, 'Workstation Administration', 'cusppe', 'label'), '/images/portal/helpdesk.png', '/eg/staff/admin/workstation/index', 1) +, (12, 3, 3, 'menuitem', oils_i18n_gettext(12, 'Reports', 'cusppe', 'label'), '/images/portal/reports.png', '/eg/staff/reporter/legacy/main', 1) +; + +SELECT setval('config.ui_staff_portal_page_entry_id_seq', 100); + + +INSERT INTO config.workstation_setting_type (name, grp, datatype, label) +VALUES ( + 'eg.grid.admin.config.ui_staff_portal_page_entry', 'gui', 'object', + oils_i18n_gettext( + 'eg.grid.admin.config.ui_staff_portal_page_entry', + 'Grid Config: admin.config.ui_staff_portal_page_entry', + 'cwst', 'label' + ) +); diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.portal_page_table.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.portal_page_table.sql index 80ac803323..41e872c9b2 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.portal_page_table.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.portal_page_table.sql @@ -1,6 +1,6 @@ BEGIN; -CREATE TABLE config.ui_staff_portal_page_entry_type( +CREATE TABLE config.ui_staff_portal_page_entry_type ( code TEXT PRIMARY KEY, label TEXT NOT NULL ); @@ -18,7 +18,7 @@ CREATE TABLE config.ui_staff_portal_page_entry ( id SERIAL PRIMARY KEY, page_col INTEGER NOT NULL, col_pos INTEGER NOT NULL, - entry_type TEXT NOT NULL, + entry_type TEXT NOT NULL, -- REFERENCES config.ui_staff_portal_page_entry_type(code) label TEXT, image_url TEXT, target_url TEXT, -- 2.11.0