${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 ------------------ // ------------------ START EMPLOYEE DISCOUNT PROGRAM FROM SPREADSHEET (Spreadsheet gets data from Google Form) ------------------ document.addEventListener("appLoaded", () => { UtilityHelpers.waitForElement( "#app", "#custom-spreadsheet-app-employee-form", (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"' : ""; // Extends the shared CourseCatalog without modifying it: // a vendor with several categories ("CAT01,CAT05" in Category-ID) // is listed under each of its category headings. class MultiGroupCatalog extends CourseCatalog { splitMultiValue(value) { return String(value ?? "") .split(",") .map((s) => s.trim()) .filter(Boolean); } _renderGrouped(listingArea) { const { organiseByLabel, organiseByMulti } = this.config; const { idColumn, labelColumn } = organiseByMulti; const groups = new Map(); // id -> { label, items } const addTo = (key, label, item) => { if (!groups.has(key)) groups.set(key, { label, items: [] }); groups.get(key).items.push(item); }; // ID -> label from the (already translated) filters data const idToLabel = new Map(); (this.filters || []).forEach((f) => { if (f[idColumn] != null && f[labelColumn]) idToLabel.set(String(f[idColumn]).trim(), f[labelColumn]); }); // When filtering by this column, only show the selected groups const activeIds = new Set( Array.from( document.querySelectorAll( `.js-is-filter input[type=checkbox]:checked[data-filter-type="${idColumn}"]` ) ).map((cb) => cb.value) ); this.filteredData.forEach((item) => { const ids = this.splitMultiValue(item[idColumn]); if (!ids.length) { if (!activeIds.size) addTo("", this.t("Other"), item); return; } ids.forEach((id) => { if (activeIds.size && !activeIds.has(id)) return; addTo(id, idToLabel.get(id) || id, item); }); }); Array.from(groups.entries()) .sort(([ka, a], [kb, b]) => { if (ka === "") return 1; // "Other" last if (kb === "") return -1; return String(a.label).localeCompare(String(b.label)); }) .forEach(([, group]) => { const headingWrapper = document.createElement("div"); headingWrapper.classList.add("group-heading"); const h2 = document.createElement("h2"); h2.textContent = organiseByLabel ? `${organiseByLabel}: ${group.label}` : group.label; headingWrapper.appendChild(h2); listingArea.appendChild(headingWrapper); group.items.forEach((item) => { listingArea.appendChild(this._createItemElement(item)); }); }); } } const itemTemplate = `

${t("moreDetails")}

${t("vendorLink")}

`; // Google Form version (appscript-template-from-form.js) const BASE_URL = "https://script.google.com/macros/s/AKfycbxrfTUMuQ8rF9OQRRhvtjXBMojMFTJqPq6DgBomrvu9Vqw9w0mf_zWpehTadsOjgvbZMw/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 employeeDiscountFormConfig = { 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-form", ), // 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-form", ), // 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: "Vendor-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 organiseByMulti: { idColumn: "Category-ID", labelColumn: "Category" }, // multi-select: group by comma-separated IDs, headings from the Filters sheet 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 employeeDiscountForm = new MultiGroupCatalog( employeeDiscountFormConfig, ); }, ); }); // ------------------ END EMPLOYEE DISCOUNT PROGRAM FROM SPREADSHEET (Spreadsheet gets data from Google Form) ------------------

${schoolCategory}

{{ IHE-Name }}

{{ Program-Name }}

{{ Course-Name }}

{{ Course-Name }}

{{ Vendor-Name }}

{{ Vendor-Name }}

UPDATE ON PHASE 2 REDISTRICTING PROCESS