// ------------------ START COVENTRY PS, CT COURSE CATALOG ------------------ document.addEventListener("appLoaded", () => { UtilityHelpers.waitForElement( "#app", "#custom-spreadsheet-app-programs-of-studies", (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", }, }; 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("moreDetails")}

${t("vendorLink")}

`; const BASE_URL = "https://script.google.com/macros/s/AKfycbytgOefHSN7vX4P1gOId7pJ_qZU07oqRrzgU5v2dtQme7TBBhXJHi-anHscYkeNq4B3SQ/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-programs-of-studies", ), // 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: true, 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-programs-of-studies", ), // this is the main app ID; required itemsPerPageDefaultValue: 72, 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: "description", target: ".modal-description", type: "html", }, { data: "department", target: ".modal-department", type: "text", }, { data: "credits", target: ".modal-credits", type: "text", }, { data: "grades", target: ".modal-grades", type: "text", }, { data: "level", target: ".modal-level", type: "text", }, { data: "requirement", target: ".modal-requirement", type: "text", }, { data: "term", target: ".modal-term", type: "text", }, { data: "pathway", target: ".modal-pathway", type: "text", }, { data: "prerequisite", target: ".modal-prerequisite", type: "text", }, { data: "course-code", target: ".modal-course-code", type: "text", }, { data: "corequisite", target: ".modal-corequisite", type: "text", }, { data: "link", target: ".modal-link", type: "link", }, { data: "notes", target: ".modal-notes", type: "html", }, ], }, searchInColumns: ["Course-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 checkboxFilters: { department: { filterTitle: "Department", filterLabel: "Department", filterId: "Department-ID", listedColumn: "Department-ID", parentIdInPage: "custom-spreadsheet-app-filter-area", extraClass: "department js-is-collapsable is-collapsed", filterLogic: "OR", }, credits: { filterTitle: "Credits", filterLabel: "Credits", filterId: "Credits-ID", listedColumn: "Credits-ID", parentIdInPage: "custom-spreadsheet-app-filter-area", extraClass: "credits js-is-collapsable is-collapsed", filterLogic: "OR", }, grades: { filterTitle: "Grades", filterLabel: "Grades", filterId: "Grades-ID", listedColumn: "Grades-ID", parentIdInPage: "custom-spreadsheet-app-filter-area", extraClass: "grades js-is-collapsable is-collapsed", filterLogic: "OR", }, pathway: { filterTitle: "Pathway", filterLabel: "Pathway", filterId: "Pathway-ID", listedColumn: "Pathway-ID", parentIdInPage: "custom-spreadsheet-app-filter-area", extraClass: "pathway js-is-collapsable is-collapsed", filterLogic: "OR", }, }, radioFilters: { requirement: { filterTitle: "Requirement", filterLabel: "Requirement", filterId: "Requirement-ID", listedColumn: "Requirement-ID", parentIdInPage: "custom-spreadsheet-app-filter-area", extraClass: "requirement js-is-collapsable is-collapsed", filterLogic: "OR", optionAll: true, allButtonText: "All", }, term: { filterTitle: "Term", filterLabel: "Term", filterId: "Term-ID", listedColumn: "Term-ID", parentIdInPage: "custom-spreadsheet-app-filter-area", extraClass: "term js-is-collapsable is-collapsed", filterLogic: "OR", optionAll: true, allButtonText: "All", }, }, }; const highSchoolProgramofStudy = new CourseCatalog( highSchoolProgramofStudyConfig, ); }, ); }); // ------------------ END COVENTRY PS, CT COURSE CATALOG ------------------

{{ Course-Name }}

Coventry Grammar School

Coventry Grammar School