${schoolCategory}

${buttonHTML}

`; }) .join(''); const customSchoolsDropdownHTML = `

${tabTitles}

${schoolsListHTML}

No school was found

`; const customSchoolsDropdown = UtilityHelpers.createEl( 'div', 'customSchoolsDropdown', 'customSchoolsDropdown' ); customSchoolsDropdown.innerHTML = customSchoolsDropdownHTML; document .querySelector('.header-bar-wrapper > div') .appendChild(customSchoolsDropdown); } }); window.filterSchools = () => { const filterValue = document .getElementById('filterInput') .value.toLowerCase(); const tabContents = document.querySelectorAll('.tabcontent'); const notFound = document.querySelector('.not-found'); let anySchoolFound = false; if (filterValue.length < 2) { tabContents.forEach((tabContent) => { tabContent .querySelectorAll('.custom-school-button') .forEach((button) => { button.style.display = ''; }); tabContent.classList.remove('found-items'); }); notFound.classList.remove('active'); return; } tabContents.forEach((tabContent) => { let foundInThisTabContent = false; tabContent.querySelectorAll('.custom-school-button').forEach((button) => { const match = button.innerText.toLowerCase().includes(filterValue); button.style.display = match ? '' : 'none'; if (match) foundInThisTabContent = true; }); tabContent.classList.toggle('found-items', foundInThisTabContent); if (foundInThisTabContent) anySchoolFound = true; }); notFound.classList.toggle('active', !anySchoolFound); }; window.openTab = (evt, tabName) => { document .querySelectorAll('.tabcontent') .forEach((tabContent) => tabContent.classList.remove('active')); document.querySelectorAll('.tablinks').forEach((tabLink) => { tabLink.classList.remove('active'); tabLink.setAttribute('aria-selected', 'false'); }); document.getElementById(tabName).classList.add('active'); evt.currentTarget.classList.add('active'); evt.currentTarget.setAttribute('aria-selected', 'true'); }; window.openAccordion = () => { const element = event.currentTarget; const content = element.nextElementSibling; element.parentNode.classList.toggle('active-accordion'); content.style.maxHeight = element.parentNode.classList.contains( 'active-accordion' ) ? `${content.scrollHeight}px` : null; }; const addSchoolsButtonToMobileHeader = () => { const mobileHeader = document.querySelector('#cms-header .mobile-header'); if (mobileHeader && !document.querySelector('#schoolsbutton')) { const schoolsButtonHTML = ` `; mobileHeader.insertAdjacentHTML('beforeend', schoolsButtonHTML); } }; const toggleDropdown = () => { const header = document.getElementById('cms-header'); if (header) { header.classList.toggle('has-custom-schools-menu-active'); document.getElementById('filterInput').focus(); } }; document.addEventListener('appLoaded', () => { addSchoolsButtonToMobileHeader(); const existingSchoolsButton = document.getElementById('schoolsbutton'); const header = document.getElementById('cms-header'); if (existingSchoolsButton) { // Use a small interval to check when the dropdown is created const waitForDropdown = setInterval(() => { const dropdown = document.getElementById('customSchoolsDropdown'); if (!dropdown) return; // still not created clearInterval(waitForDropdown); // stop checking const openDropdown = () => { if (window.innerWidth >= 1024) header.classList.add('has-custom-schools-menu-active'); }; const closeDropdown = () => { if (window.innerWidth >= 1024) header.classList.remove('has-custom-schools-menu-active'); }; existingSchoolsButton.addEventListener('mouseenter', openDropdown); existingSchoolsButton.addEventListener('mouseleave', () => { setTimeout(() => { if ( !dropdown.matches(':hover') && !existingSchoolsButton.matches(':hover') ) { closeDropdown(); } }, 10); }); dropdown.addEventListener('mouseenter', openDropdown); dropdown.addEventListener('mouseleave', closeDropdown); // Mobile click/keyboard stays the same existingSchoolsButton.addEventListener('click', () => { if (window.innerWidth < 1024) toggleDropdown(); }); existingSchoolsButton.addEventListener('keydown', (e) => { if ( (e.key === 'Enter' || e.key === ' ') && window.innerWidth < 1024 ) { e.preventDefault(); toggleDropdown(); } }); }, 50); // check every 50ms } }); window.addEventListener( 'resize', UtilityHelpers.debounce(() => { document .querySelectorAll('.tabcontent.active .custom-schools-list') .forEach((content) => { content.style.maxHeight = `${content.scrollHeight}px`; }); addSchoolsButtonToMobileHeader(); }, 250) ); document.addEventListener('keydown', (e) => { if (e.key === 'Escape' || e.key === 'Esc') { document .getElementById('cms-header') .classList.remove('has-custom-schools-menu-active'); document.getElementById('schoolsbutton').focus(); } }); document.addEventListener('keydown', (e) => { if (e.key !== 'ArrowLeft' && e.key !== 'ArrowRight') return; const activeTab = document.querySelector('.tablinks.active'); if (!activeTab) return; const tablinks = document.querySelectorAll('.tablinks'); const currentIndex = Array.from(tablinks).indexOf(activeTab); const newActiveIndex = e.key === 'ArrowLeft' ? (currentIndex - 1 + tablinks.length) % tablinks.length : (currentIndex + 1) % tablinks.length; tablinks[newActiveIndex].click(); setTimeout(() => { const activeAccordion = document.querySelector('.tabcontent.active'); if (activeAccordion) { const firstButton = activeAccordion.querySelector( '.custom-school-button' ); if (firstButton) { firstButton.focus(); } } }, 0); }); })(); /* END Extended schools new dropdown for Header V3 */ // ------------------ START PARTNERSHIP PROGRAMS FROM SPREADSHEET ------------------ document.addEventListener("appLoaded", () => { UtilityHelpers.waitForElement('#app', '#custom-spreadsheet-app', (element) => { const getInfo = new GetInfo(); const currentLanguage = (getInfo.orgTranslation || 'en').toLowerCase(); // IMPORTANT NOTE: the translated languages (and name of the filters) are part of the AppScript (Google Spreadsheet -> Extensions) const TRANSLATIONS = { en: { moreDetails: "More Details", programWebpage: "Program's Webpage" }, es: { moreDetails: "Más detalles", programWebpage: "Página del programa" }, ar: { moreDetails: "مزيد من التفاصيل", programWebpage: "صفحة البرنامج" }, "zh-cn": { moreDetails: "了解更多", programWebpage: "项目网页" }, ko: { moreDetails: "자세히 보기", programWebpage: "프로그램 웹페이지" }, vi: { moreDetails: "Xem chi tiết", programWebpage: "Trang web của chương trình" }, ur: { moreDetails: "مزید تفصیلات", programWebpage: "پروگرام کا ویب صفحہ" } }; const t = (key) => (TRANSLATIONS[currentLanguage] && TRANSLATIONS[currentLanguage][key]) || TRANSLATIONS.en[key]; // (Optional) RTL languages, if you want to add dir="rtl" on the buttons/links const RTL_LANGS = new Set(["ar", "ur"]); const maybeDir = RTL_LANGS.has(currentLanguage) ? ' dir="rtl"' : ""; const itemTemplate = `

${t("programWebpage")}

${t("moreDetails")}

`; // const BASE_URL = 'https://script.google.com/macros/s/AKfycbwm3RO9EdnBUedlvZ0DD3laojnD1n0ZldB3TEAM5cZBq1j6Yktq2ObC4P6BxCsUqrXJsw/exec'; const BASE_URL = 'https://script.google.com/macros/s/AKfycbw_m3VVz4RMha2DW8ntxH6axcdbfoGse9IvJBzahpUw3DF-xZVaKU07mGwQV5WO3-pspQ/exec'; const fetchDataUrl = BASE_URL + (BASE_URL.includes('?') ? '&' : '?') + 'lang=' + encodeURIComponent(currentLanguage); const fallbackFetchDataUrl = BASE_URL; // 2 sheets should exist; one with the main data, the other one with the filters const partnershipProgramsConfig = { jsonDataKeys: { mainFileKey: 'programs', // Default key for the main file (ex: courses) data filtersKey: 'filters' // Default key for filters data }, fetchDataUrl, fallbackFetchDataUrl, translateFailureRetries: 2, addLoadedClassTo: document.getElementById("custom-spreadsheet-app"), // when the content is loaded, a css class is added in order to hide the loader searchElement: document.getElementById("search-input"), // commejnt to disable search; also remove from HTML searchAsYouType: false, resetAllFiltersElement: ".js-reset-all-filters", // comment if the reset functionality is not needed; also remove from HTML sortButtonElement: ".js-sort-button", // comment if sort functionality is not needed; also remove from HTML itemsPerPageElement: ".js-items-per-page", // select how many items per page are shown; comment if not neeeded // also remove from HTML infoAreaElement: '.js-info-area', // search info: Showing X to Y of TOTAL entries; comment if not needed; also remove from HTML mainListArea: document.getElementById("main-list"), // this is where the results will be listed; required mainApp: document.getElementById("custom-spreadsheet-app"), // this is the main app ID; required itemsPerPageDefaultValue: 24, scrollToAppOnFilter: true, // scrolls to mainApp on filter isTranslateable: true, currentLanguage: currentLanguage, translationFeedbackElement: '#feedback-area', preferServerFilterTitles: true, itemTemplate, // modalConfig - builds the modal - you have to match a column name from thee spreadsheet with a CSS selector inside the modal modalConfig: { enabled: true, triggerSelector: ".custom-button--2", modalWrapperClass: "spreadsheet-item-modal", // generic naming fields: [ // maps data-* to modal class { data: "ihe-name", target: ".modal-ihe-name", type: "text" }, { data: "program-name", target: ".modal-program-name", type: "text" }, { data: "program-description", target: ".modal-program-description", type: "html" }, { data: "program-webpage", target: ".modal-program-webpage", type: "link" }, { data: "degree-certification", target: ".modal-degree-certification", type: "text" }, { data: "licence", target: ".modal-licence", type: "text" }, { data: "program-format", target: ".modal-program-format", type: "text" }, { data: "program-time", target: ".modal-program-time", type: "text" }, { data: "program-credits", target: ".modal-program-credits", type: "text" }, { data: "program-cost", target: ".modal-program-cost", type: "text" }, // { data: "program-contract", target: ".modal-program-contract", type: "text" }, { data: "program-aacps-specific-cohort", target: ".modal-program-aacps-specific-cohort", type: "text" }, { data: "program-endorsement-area", target: ".modal-program-endorsement-area", type: "text" }, { data: "primary-contact-person", target: ".modal-primary-contact-person", type: "text" }, { data: "primary-contact-email", target: ".modal-primary-contact-email", type: "mailto" }, { data: "secondary-contact-person", target: ".modal-secondary-contact-person", type: "text" }, { data: "secondary-contact-email", target: ".modal-secondary-contact-email", type: "mailto" }, { data: "image", target: ".modal-image", type: "image" }, ] }, searchInColumns: ["IHE-Name", "Program-Name", "Program-Description"], // if search is enabled, this is required sortingCriteria: "Program-Name", // if sortButtonElement is enabled, this is required; ONLY ONE enablePagination: true, // Set to false to disable pagination; option to create your own #pagination-area anywhere in the page //filterLogicBetweenGroups: "OR", // or AND checkboxFilters: { ihe: { filterTitle: "Institution of Higher Education", filterLabel: "IHE", filterId: "IHE-ID", listedColumn: "IHE-ID", parentIdInPage: "custom-spreadsheet-app-filter-area", extraClass: "ihe-filters js-is-collapsable is-collapsed", filterLogic: "OR" }, certification: { filterTitle: "Degree/Certification Program", filterLabel: "Certification", filterId: "Certification-ID", listedColumn: "Certification-ID", parentIdInPage: "custom-spreadsheet-app-filter-area", extraClass: "certification-filters js-is-collapsable is-collapsed", filterLogic: "OR" }, programFormat: { filterTitle: "Program Format", filterLabel: "Program-Format", filterId: "Program-Format-ID", listedColumn: "Program-Format-ID", parentIdInPage: "custom-spreadsheet-app-filter-area", extraClass: "program-format-filters js-is-collapsable is-collapsed", filterLogic: "OR" }, endorsementArea: { filterTitle: "License/Endorsement Area", filterLabel: "Endorsement-Area", filterId: "Endorsement-Area-ID", listedColumn: "Endorsement-Area-ID", parentIdInPage: "custom-spreadsheet-app-filter-area", extraClass: "endorsement-filters js-is-collapsable is-collapsed", filterLogic: "OR" } }, radioFilters: { licence: { filterTitle: "Initial Professional License Program", filterLabel: "License", filterId: "LICENSE-ID", listedColumn: "LICENSE-ID", parentIdInPage: "custom-spreadsheet-app-filter-area", optionAll: true, allButtonText: "Any", extraClass: 'licence-filter js-is-collapsable is-collapsed', filterLogic: "OR" }, directBilling: { filterTitle: "Direct Billing Agreement with AACPS", filterLabel: "Direct-Billing", filterId: "Direct-Billing-ID", listedColumn: "Direct-Billing-ID", parentIdInPage: "custom-spreadsheet-app-filter-area", optionAll: true, allButtonText: "Any", extraClass: 'direct-billing-filter js-is-collapsable is-collapsed', filterLogic: "OR" } } }; const partnershipPrograms = new CourseCatalog(partnershipProgramsConfig); }); }); // ------------------ END PARTNERSHIP PROGRAMS FROM SPREADSHEET ------------------ // ------------------ START PROGRAMS OF STUDY (HIGH SCHOOL) FROM SPREADSHEET ------------------ document.addEventListener("appLoaded", () => { UtilityHelpers.waitForElement('#app', '#custom-spreadsheet-app-courses', (element) => { const getInfo = new GetInfo(); const currentLanguage = (getInfo.orgTranslation || 'en').toLowerCase(); // IMPORTANT NOTE: the translated languages (and name of the filters) are part of the AppScript (Google Spreadsheet -> Extensions) const TRANSLATIONS = { en: { moreDetails: "More Details", programWebpage: "Program's Webpage" }, es: { moreDetails: "Más detalles", programWebpage: "Página del programa" }, ar: { moreDetails: "مزيد من التفاصيل", programWebpage: "صفحة البرنامج" }, "zh-cn": { moreDetails: "了解更多", programWebpage: "项目网页" }, ko: { moreDetails: "자세히 보기", programWebpage: "프로그램 웹페이지" }, vi: { moreDetails: "Xem chi tiết", programWebpage: "Trang web của chương trình" }, ur: { moreDetails: "مزید تفصیلات", programWebpage: "پروگرام کا ویب صفحہ" } }; const t = (key) => (TRANSLATIONS[currentLanguage] && TRANSLATIONS[currentLanguage][key]) || TRANSLATIONS.en[key]; // (Optional) RTL languages, if you want to add dir="rtl" on the buttons/links const RTL_LANGS = new Set(["ar", "ur"]); const maybeDir = RTL_LANGS.has(currentLanguage) ? ' dir="rtl"' : ""; const itemTemplate = `

More Details

`; const BASE_URL = 'https://script.google.com/macros/s/AKfycbzoOiA0tszJZLu9vC1EaJzflKSBr4dZdsWTWex9_uBqGmf6NC3XnzwAkPbCNgfsG4ZI/exec'; const fetchDataUrl = BASE_URL + (BASE_URL.includes('?') ? '&' : '?') + 'lang=' + encodeURIComponent(currentLanguage); const fallbackFetchDataUrl = BASE_URL; // 2 sheets should exist; one with the main data, the other one with the filters const highSchoolProgramofStudyConfig = { jsonDataKeys: { mainFileKey: 'courses', // Default key for the main file (ex: courses) data filtersKey: 'filters' // Default key for filters data }, fetchDataUrl, fallbackFetchDataUrl, translateFailureRetries: 2, addLoadedClassTo: document.getElementById("custom-spreadsheet-app-courses"), // when the content is loaded, a css class is added in order to hide the loader searchElement: document.getElementById("search-input"), // commejnt to disable search; also remove from HTML searchAsYouType: false, resetAllFiltersElement: ".js-reset-all-filters", // comment if the reset functionality is not needed; also remove from HTML sortButtonElement: ".js-sort-button", // comment if sort functionality is not needed; also remove from HTML itemsPerPageElement: ".js-items-per-page", // select how many items per page are shown; comment if not neeeded // also remove from HTML infoAreaElement: '.js-info-area', // search info: Showing X to Y of TOTAL entries; comment if not needed; also remove from HTML mainListArea: document.getElementById("main-list"), // this is where the results will be listed; required mainApp: document.getElementById("custom-spreadsheet-app-courses"), // this is the main app ID; required itemsPerPageDefaultValue: 24, scrollToAppOnFilter: true, // scrolls to mainApp on filter isTranslateable: true, currentLanguage: currentLanguage, translationFeedbackElement: '#feedback-area', preferServerFilterTitles: true, itemTemplate, // modalConfig - builds the modal - you have to match a column name from thee spreadsheet with a CSS selector inside the modal modalConfig: { enabled: true, triggerSelector: ".custom-button--2", modalWrapperClass: "spreadsheet-item-modal", // generic naming fields: [ { data: "course-name", target: ".modal-course-name", type: "text", }, { data: "course-description", target: ".modal-course-description", type: "html", }, { data: "course-prerequisite", target: ".modal-course-prerequisite", type: "text", }, { data: "credits-earned-sem", target: ".modal-credits-earned-sem", type: "text", }, { data: "credit-subject", target: ".modal-credit-subject", type: "text", }, { data: "course-subject", target: ".modal-course-subject", type: "text", }, { data: "about-course-subject-dec", target: ".modal-about-course-subject-dec", type: "html", }, ], }, searchInColumns: ["Course-Name", "Course-Description"], // if search is enabled, this is required sortingCriteria: "Course-Name", // if sortButtonElement is enabled, this is required; ONLY ONE enablePagination: true, // Set to false to disable pagination; option to create your own #pagination-area anywhere in the page checkboxFilters: { creditSubject: { filterTitle: "Credit Subject", filterLabel: "Credit-Subject", filterId: "Credit-Subject-ID", listedColumn: "Credit-Subject-ID", parentIdInPage: "custom-spreadsheet-app-filter-area", extraClass: "ihe-filters js-is-collapsable is-collapsed", filterLogic: "OR" }, certification: { filterTitle: "Course Subject", filterLabel: "Course-Subject", filterId: "Course-Subject-ID", listedColumn: "Course-Subject-ID", parentIdInPage: "custom-spreadsheet-app-filter-area", extraClass: "certification-filters js-is-collapsable is-collapsed", filterLogic: "OR" }, }, }; const highSchoolProgramofStudy = new CourseCatalog( highSchoolProgramofStudyConfig ); }); }); // ------------------ END PROGRAMS OF STUDY (HIGH SCHOOL) FROM SPREADSHEET ------------------ // ------------------ START PROGRAMS OF STUDY (MIDDLE SCHOOL) FROM SPREADSHEET ------------------ document.addEventListener("appLoaded", () => { UtilityHelpers.waitForElement( "#app", "#custom-spreadsheet-app-courses-middle", (element) => { const getInfo = new GetInfo(); const currentLanguage = ( getInfo.orgTranslation || "en" ).toLowerCase(); // IMPORTANT NOTE: the translated languages (and name of the filters) are part of the AppScript (Google Spreadsheet -> Extensions) const TRANSLATIONS = { en: { moreDetails: "More Details", programWebpage: "Program's Webpage", }, es: { moreDetails: "Más detalles", programWebpage: "Página del programa", }, ar: { moreDetails: "مزيد من التفاصيل", programWebpage: "صفحة البرنامج", }, "zh-cn": { moreDetails: "了解更多", programWebpage: "项目网页", }, ko: { moreDetails: "자세히 보기", programWebpage: "프로그램 웹페이지", }, vi: { moreDetails: "Xem chi tiết", programWebpage: "Trang web của chương trình", }, ur: { moreDetails: "مزید تفصیلات", programWebpage: "پروگرام کا ویب صفحہ", }, }; const t = (key) => (TRANSLATIONS[currentLanguage] && TRANSLATIONS[currentLanguage][key]) || TRANSLATIONS.en[key]; // (Optional) RTL languages, if you want to add dir="rtl" on the buttons/links const RTL_LANGS = new Set(["ar", "ur"]); const maybeDir = RTL_LANGS.has(currentLanguage) ? ' dir="rtl"' : ""; const itemTemplate = `

More Details

`; const BASE_URL = "https://script.google.com/macros/s/AKfycbxaG-xXwMv_XXgVG4rh_ZGD2idgF_MKfZZLJZK5koH3y2FBOeA8t4-3S4QJQ8QyujhF/exec"; const fetchDataUrl = BASE_URL + (BASE_URL.includes("?") ? "&" : "?") + "lang=" + encodeURIComponent(currentLanguage); const fallbackFetchDataUrl = BASE_URL; // 2 sheets should exist; one with the main data, the other one with the filters const highSchoolProgramofStudyConfig = { jsonDataKeys: { mainFileKey: "courses", // Default key for the main file (ex: courses) data filtersKey: "filters", // Default key for filters data }, fetchDataUrl, fallbackFetchDataUrl, translateFailureRetries: 2, addLoadedClassTo: document.getElementById( "custom-spreadsheet-app-courses-middle", ), // when the content is loaded, a css class is added in order to hide the loader searchElement: document.getElementById("search-input"), // commejnt to disable search; also remove from HTML searchAsYouType: false, resetAllFiltersElement: ".js-reset-all-filters", // comment if the reset functionality is not needed; also remove from HTML sortButtonElement: ".js-sort-button", // comment if sort functionality is not needed; also remove from HTML itemsPerPageElement: ".js-items-per-page", // select how many items per page are shown; comment if not neeeded // also remove from HTML infoAreaElement: ".js-info-area", // search info: Showing X to Y of TOTAL entries; comment if not needed; also remove from HTML mainListArea: document.getElementById("main-list"), // this is where the results will be listed; required mainApp: document.getElementById( "custom-spreadsheet-app-courses-middle", ), // this is the main app ID; required itemsPerPageDefaultValue: 24, scrollToAppOnFilter: true, // scrolls to mainApp on filter isTranslateable: true, currentLanguage: currentLanguage, translationFeedbackElement: "#feedback-area", preferServerFilterTitles: true, itemTemplate, // modalConfig - builds the modal - you have to match a column name from thee spreadsheet with a CSS selector inside the modal modalConfig: { enabled: true, triggerSelector: ".custom-button--2", modalWrapperClass: "spreadsheet-item-modal", // generic naming fields: [ { data: "course-name", target: ".modal-course-name", type: "text", }, { data: "course-description", target: ".modal-course-description", type: "html", }, { data: "course-prerequisite", target: ".modal-course-prerequisite", type: "text", }, { data: "credits-earned-sem", target: ".modal-credits-earned-sem", type: "text", }, { data: "credit-subject", target: ".modal-credit-subject", type: "text", }, { data: "course-subject", target: ".modal-course-subject", type: "text", }, { data: "about-course-subject-dec", target: ".modal-about-course-subject-dec", type: "html", }, ], }, searchInColumns: ["Course-Name", "Course-Description"], // if search is enabled, this is required sortingCriteria: "Course-Name", // if sortButtonElement is enabled, this is required; ONLY ONE enablePagination: true, // Set to false to disable pagination; option to create your own #pagination-area anywhere in the page checkboxFilters: { creditSubject: { filterTitle: "Credit Subject", filterLabel: "Credit-Subject", filterId: "Credit-Subject-ID", listedColumn: "Credit-Subject-ID", parentIdInPage: "custom-spreadsheet-app-filter-area", extraClass: "ihe-filters js-is-collapsable is-collapsed", filterLogic: "OR", }, certification: { filterTitle: "Course Subject", filterLabel: "Course-Subject", filterId: "Course-Subject-ID", listedColumn: "Course-Subject-ID", parentIdInPage: "custom-spreadsheet-app-filter-area", extraClass: "certification-filters js-is-collapsable is-collapsed", filterLogic: "OR", }, }, }; const highSchoolProgramofStudy = new CourseCatalog( highSchoolProgramofStudyConfig, ); }, ); }); // ------------------ END PROGRAMS OF STUDY (MIDDLE SCHOOL) FROM SPREADSHEET ------------------ // ------------------ START EMPLOYEE DISCOUNT PROGRAM FROM SPREADSHEET ------------------ document.addEventListener("appLoaded", () => { UtilityHelpers.waitForElement( "#app", "#custom-spreadsheet-app-employee", (element) => { const getInfo = new GetInfo(); const currentLanguage = ( getInfo.orgTranslation || "en" ).toLowerCase(); // IMPORTANT NOTE: the translated languages (and name of the filters) are part of the AppScript (Google Spreadsheet -> Extensions) const TRANSLATIONS = { en: { moreDetails: "More Details", vendorLink: "Link", }, es: { moreDetails: "Más detalles", vendorLink: "Enlace", }, ar: { moreDetails: "مزيد من التفاصيل", vendorLink: "رابط", }, "zh-cn": { moreDetails: "了解更多", vendorLink: "链接", }, ko: { moreDetails: "자세히 보기", vendorLink: "링크", }, vi: { moreDetails: "Xem chi tiết", vendorLink: "Liên kết", }, ur: { moreDetails: "مزید تفصیلات", vendorLink: "لنک", }, }; const t = (key) => (TRANSLATIONS[currentLanguage] && TRANSLATIONS[currentLanguage][key]) || TRANSLATIONS.en[key]; // (Optional) RTL languages, if you want to add dir="rtl" on the buttons/links const RTL_LANGS = new Set(["ar", "ur"]); const maybeDir = RTL_LANGS.has(currentLanguage) ? ' dir="rtl"' : ""; const itemTemplate = `

More Details

${t("vendorLink")}

`; const BASE_URL = "https://script.google.com/macros/s/AKfycbzd33fLXCnOxKFofpSWnhDj_dJfY7WGoNov0Rf90jWfVdPh2Doc936wUq2gaTFgVXsF/exec"; const fetchDataUrl = BASE_URL + (BASE_URL.includes("?") ? "&" : "?") + "lang=" + encodeURIComponent(currentLanguage); const fallbackFetchDataUrl = BASE_URL; // 2 sheets should exist; one with the main data, the other one with the filters const highSchoolProgramofStudyConfig = { jsonDataKeys: { mainFileKey: "programs", // Default key for the main file (ex: courses) data filtersKey: "filters", // Default key for filters data }, fetchDataUrl, fallbackFetchDataUrl, translateFailureRetries: 2, addLoadedClassTo: document.getElementById( "custom-spreadsheet-app-employee", ), // when the content is loaded, a css class is added in order to hide the loader searchElement: document.getElementById("search-input"), // commejnt to disable search; also remove from HTML searchAsYouType: false, resetAllFiltersElement: ".js-reset-all-filters", // comment if the reset functionality is not needed; also remove from HTML sortButtonElement: ".js-sort-button", // comment if sort functionality is not needed; also remove from HTML itemsPerPageElement: ".js-items-per-page", // select how many items per page are shown; comment if not neeeded // also remove from HTML infoAreaElement: ".js-info-area", // search info: Showing X to Y of TOTAL entries; comment if not needed; also remove from HTML mainListArea: document.getElementById("main-list"), // this is where the results will be listed; required mainApp: document.getElementById( "custom-spreadsheet-app-employee", ), // this is the main app ID; required itemsPerPageDefaultValue: 24, scrollToAppOnFilter: true, // scrolls to mainApp on filter isTranslateable: true, currentLanguage: currentLanguage, translationFeedbackElement: "#feedback-area", preferServerFilterTitles: true, itemTemplate, // modalConfig - builds the modal - you have to match a column name from thee spreadsheet with a CSS selector inside the modal modalConfig: { enabled: true, triggerSelector: ".custom-button--2", modalWrapperClass: "spreadsheet-item-modal", // generic naming fields: [ { data: "vendor-name", target: ".modal-vendor-name", type: "text", }, { data: "description", target: ".modal-description", type: "html", }, { data: "link", target: ".modal-link", type: "link", }, ], }, searchInColumns: ["Vendor-Name", "Description"], // if search is enabled, this is required sortingCriteria: "Course-Name", // if sortButtonElement is enabled, this is required; ONLY ONE enablePagination: true, // Set to false to disable pagination; option to create your own #pagination-area anywhere in the page organiseBy: "Category", // group items by this data field; disables pagination and sort organiseByLabel: "Category", // optional heading prefix: "Category: Automotive" checkboxFilters: { category: { filterTitle: "Category", filterLabel: "Category", filterId: "Category-ID", listedColumn: "Category-ID", parentIdInPage: "custom-spreadsheet-app-filter-area", extraClass: "category js-is-collapsable", filterLogic: "OR", }, }, }; const highSchoolProgramofStudy = new CourseCatalog( highSchoolProgramofStudyConfig, ); }, ); }); // ------------------ END EMPLOYEE DISCOUNT PROGRAM FROM SPREADSHEET ------------------

${schoolCategory}

{{ IHE-Name }}

{{ Program-Name }}

{{ Course-Name }}

{{ Course-Name }}

{{ Vendor-Name }}

BOARD WORKSHOP SCHEDULED FOR MARCH 16, 2026, POSTPONED