From 4b4376bdf7de9d45010f8b56ab7f5d1aebfad4c6 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Thu, 20 Feb 2025 15:18:04 +0000 Subject: [PATCH] Bug 31642: Add sql entries for new AV categories and values Content-Type: text/plain; charset=utf-8 Test plan: Run a new install. Verify that you have the new AV categories and values like ADD_CONT_HTML_OPAC_SYSTEM. Signed-off-by: Marcel de Rooy Ran load_sql on the auth_values.yml. --- .../data/mysql/en/mandatory/auth_values.yml | 148 ++++++++++++++++++ .../data/mysql/mandatory/auth_val_cat.sql | 6 + 2 files changed, 154 insertions(+) diff --git a/installer/data/mysql/en/mandatory/auth_values.yml b/installer/data/mysql/en/mandatory/auth_values.yml index 1686a4de25..341304944b 100644 --- a/installer/data/mysql/en/mandatory/auth_values.yml +++ b/installer/data/mysql/en/mandatory/auth_values.yml @@ -4854,3 +4854,151 @@ tables: authorised_value: "770" lib: "Writer of accompanying material" lib_opac: "Writer of accompanying material" + + # Locations for HTML blocks + - authorised_values: + translatable: [ lib, lib_opac ] + multiline: [] + rows: + # OPAC + - category: "ADD_CONT_HTML_OPAC_SYSTEM" + authorised_value: "OpacNavRight" + lib: "OpacNavRight" + lib_opac: "OpacNavRight" + - category: "ADD_CONT_HTML_OPAC_SYSTEM" + authorised_value: "opacheader" + lib: "opacheader" + lib_opac: "opacheader" + - category: "ADD_CONT_HTML_OPAC_SYSTEM" + authorised_value: "OpacCustomSearch" + lib: "OpacCustomSearch" + lib_opac: "OpacCustomSearch" + - category: "ADD_CONT_HTML_OPAC_SYSTEM" + authorised_value: "OpacMainUserBlock" + lib: "OpacMainUserBlock" + lib_opac: "OpacMainUserBlock" + - category: "ADD_CONT_HTML_OPAC_SYSTEM" + authorised_value: "opaccredits" + lib: "opaccredits" + lib_opac: "opaccredits" + - category: "ADD_CONT_HTML_OPAC_SYSTEM" + authorised_value: "OpacLoginInstructions" + lib: "OpacLoginInstructions" + lib_opac: "OpacLoginInstructions" + - category: "ADD_CONT_HTML_OPAC_SYSTEM" + authorised_value: "OpacNav" + lib: "OpacNav" + lib_opac: "OpacNav" + - category: "ADD_CONT_HTML_OPAC_SYSTEM" + authorised_value: "OpacNavBottom" + lib: "OpacNavBottom" + lib_opac: "OpacNavBottom" + - category: "ADD_CONT_HTML_OPAC_SYSTEM" + authorised_value: "OpacSuggestionInstructions" + lib: "OpacSuggestionInstructions" + lib_opac: "OpacSuggestionInstructions" + - category: "ADD_CONT_HTML_OPAC_SYSTEM" + authorised_value: "ArticleRequestsDisclaimerText" + lib: "ArticleRequestsDisclaimerText" + lib_opac: "ArticleRequestsDisclaimerText" + - category: "ADD_CONT_HTML_OPAC_SYSTEM" + authorised_value: "OpacMoreSearches" + lib: "OpacMoreSearches" + lib_opac: "OpacMoreSearches" + - category: "ADD_CONT_HTML_OPAC_SYSTEM" + authorised_value: "OpacMySummaryNote" + lib: "OpacMySummaryNote" + lib_opac: "OpacMySummaryNote" + - category: "ADD_CONT_HTML_OPAC_SYSTEM" + authorised_value: "OpacLibraryInfo" + lib: "OpacLibraryInfo" + lib_opac: "OpacLibraryInfo" + - category: "ADD_CONT_HTML_OPAC_SYSTEM" + authorised_value: "OpacMaintenanceNotice" + lib: "OpacMaintenanceNotice" + lib_opac: "OpacMaintenanceNotice" + - category: "ADD_CONT_HTML_OPAC_SYSTEM" + authorised_value: "OPACResultsSidebar" + lib: "OPACResultsSidebar" + lib_opac: "OPACResultsSidebar" + - category: "ADD_CONT_HTML_OPAC_SYSTEM" + authorised_value: "OpacSuppressionMessage" + lib: "OpacSuppressionMessage" + lib_opac: "OpacSuppressionMessage" + - category: "ADD_CONT_HTML_OPAC_SYSTEM" + authorised_value: "SCOMainUserBlock" + lib: "SCOMainUserBlock" + lib_opac: "SCOMainUserBlock" + - category: "ADD_CONT_HTML_OPAC_SYSTEM" + authorised_value: "SelfCheckInMainUserBlock" + lib: "SelfCheckInMainUserBlock" + lib_opac: "SelfCheckInMainUserBlock" + - category: "ADD_CONT_HTML_OPAC_SYSTEM" + authorised_value: "SelfCheckHelpMessage" + lib: "SelfCheckHelpMessage" + lib_opac: "SelfCheckHelpMessage" + - category: "ADD_CONT_HTML_OPAC_SYSTEM" + authorised_value: "CatalogConcernHelp" + lib: "CatalogConcernHelp" + lib_opac: "CatalogConcernHelp" + - category: "ADD_CONT_HTML_OPAC_SYSTEM" + authorised_value: "CatalogConcernTemplate" + lib: "CatalogConcernTemplate" + lib_opac: "CatalogConcernTemplate" + - category: "ADD_CONT_HTML_OPAC_SYSTEM" + authorised_value: "CookieConsentBar" + lib: "CookieConsentBar" + lib_opac: "CookieConsentBar" + - category: "ADD_CONT_HTML_OPAC_SYSTEM" + authorised_value: "CookieConsentPopup" + lib: "CookieConsentPopup" + lib_opac: "CookieConsentPopup" + - category: "ADD_CONT_HTML_OPAC_SYSTEM" + authorised_value: "PatronSelfRegistrationAdditionalInstructions" + lib: "PatronSelfRegistrationAdditionalInstructions" + lib_opac: "PatronSelfRegistrationAdditionalInstructions" + - category: "ADD_CONT_HTML_OPAC_SYSTEM" + authorised_value: "ILLModuleCopyrightClearance" + lib: "ILLModuleCopyrightClearance" + lib_opac: "ILLModuleCopyrightClearance" + # Staff + - category: "ADD_CONT_HTML_STAFF_SYSTEM" + authorised_value: "IntranetmainUserblock" + lib: "IntranetmainUserblock" + lib_opac: "IntranetmainUserblock" + - category: "ADD_CONT_HTML_STAFF_SYSTEM" + authorised_value: "RoutingListNote" + lib: "RoutingListNote" + lib_opac: "RoutingListNote" + - category: "ADD_CONT_HTML_STAFF_SYSTEM" + authorised_value: "StaffAcquisitionsHome" + lib: "StaffAcquisitionsHome" + lib_opac: "StaffAcquisitionsHome" + - category: "ADD_CONT_HTML_STAFF_SYSTEM" + authorised_value: "StaffAuthoritiesHome" + lib: "StaffAuthoritiesHome" + lib_opac: "StaffAuthoritiesHome" + - category: "ADD_CONT_HTML_STAFF_SYSTEM" + authorised_value: "StaffCataloguingHome" + lib: "StaffCataloguingHome" + lib_opac: "StaffCataloguingHome" + - category: "ADD_CONT_HTML_STAFF_SYSTEM" + authorised_value: "StaffListsHome" + lib: "StaffListsHome" + lib_opac: "StaffListsHome" + - category: "ADD_CONT_HTML_STAFF_SYSTEM" + authorised_value: "StaffLoginInstructions" + lib: "StaffLoginInstructions" + lib_opac: "StaffLoginInstructions" + - category: "ADD_CONT_HTML_STAFF_SYSTEM" + authorised_value: "StaffPatronsHome" + lib: "StaffPatronsHome" + lib_opac: "StaffPatronsHome" + - category: "ADD_CONT_HTML_STAFF_SYSTEM" + authorised_value: "StaffPOSHome" + lib: "StaffPOSHome" + lib_opac: "StaffPOSHome" + - category: "ADD_CONT_HTML_STAFF_SYSTEM" + authorised_value: "StaffSerialsHome" + lib: "StaffSerialsHome" + lib_opac: "StaffSerialsHome" diff --git a/installer/data/mysql/mandatory/auth_val_cat.sql b/installer/data/mysql/mandatory/auth_val_cat.sql index c1428e4a3c..81ac8dbfe2 100644 --- a/installer/data/mysql/mandatory/auth_val_cat.sql +++ b/installer/data/mysql/mandatory/auth_val_cat.sql @@ -106,3 +106,9 @@ VALUES INSERT IGNORE INTO authorised_value_categories (category_name, is_system) VALUES ('BOOKING_CANCELLATION', 1); + +-- For locations of HTML blocks +INSERT IGNORE INTO authorised_value_categories (category_name, is_system) VALUES + ('ADD_CONT_HTML_OPAC_SYSTEM', 1), + ('ADD_CONT_HTML_STAFF_SYSTEM', 1), + ('ADD_CONT_HTML_CUSTOM', 0); -- 2.39.5