Contact Us We are here to serve the USC community. </section></div> </div> </div> </div> </div> </div> </div> </div> </article> </div> <footer id="main-footer"> <div class="container"> <div id="footer-widgets" class="clearfix"> <div class="footer-widget"><div id="text-4" class="fwidget et_pb_widget widget_text"> <div class="textwidget"><p><span style="color: #ffffff"><strong>NAVIGATE</strong></span></p> <p><a href="https://usg.usc.edu/branches/about-2-0/#structure">Our Structure</a><br /> <a href="https://usg.usc.edu/page-not-available/">Our Branches</a><br /> <a href="https://usg.usc.edu/meet-our-team-executive-cabinet/">Our Team</a><br /> <a href="https://usg.usc.edu/resources">Our Resources</a><br /> <a href="https://usg.usc.edu/newsroom/">Press & News</a></p> </div> </div></div><div class="footer-widget"><div id="text-5" class="fwidget et_pb_widget widget_text"> <div class="textwidget"><p><span style="color: #ffffff"><strong>DOCUMENTS</strong></span></p> <p><a href="https://docs.google.com/document/d/1GA3JV8HDT4y3ziezuwqWutpmExest0o3DlUyisBhTwE/edit?usp=sharing" target="_blank" rel="noopener">Constitution</a><br /> <a href="https://docs.google.com/document/d/19fgff3Iy-YjHaMS8v_cKppMuWFwfrVsTEohmMUjw7Go/edit?usp=sharing">Bylaws</a></p> <p><a href="https://docs.google.com/spreadsheets/d/1IqxmWHuKzV2E-LGw4zC-NgMA3ew9FddBcqRDx2vFYcs/edit?usp=sharing">Office Hours & Staff Roster</a><br /> <a href="https://drive.google.com/file/d/1XtNwGSYmPG-8oMTRCtMwxWflBKDV-x0N/view?usp=drive_link">Brand Guidelines</a></p> </div> </div></div><div class="footer-widget"><div id="text-3" class="fwidget et_pb_widget widget_text"> <div class="textwidget"><p><span style="color: #ffffff"><strong>CONTACT US</strong></span></p> <p>USC Undergraduate Student Government<br /> 3607 Trousdale Pkwy, SKS 404<br /> Los Angeles, California 90089</p> <p><a href="mailto:usg@usc.edu">usg@usc.edu</a></p> <p> </p> </div> </div><div id="custom_html-2" class="widget_text fwidget et_pb_widget widget_custom_html"><div class="textwidget custom-html-widget"></div></div><div id="block-2" class="fwidget et_pb_widget widget_block"></div></div><div class="footer-widget"></div> </div> </div> <div id="footer-bottom"> <div class="container clearfix"> <div id="footer-info">© University of Southern California<br> Designed & Operated by the Undergraduate Student Government<br> Website issues? Contact <a href="http://it.provost.usc.edu/">USC Provost IT</a></div> </div> </div> </footer> </div> </div> <script type="speculationrules"> {"prefetch":[{"source":"document","where":{"and":[{"href_matches":"\/*"},{"not":{"href_matches":["\/wp-*.php","\/wp-admin\/*","\/wp-content\/uploads\/*","\/wp-content\/*","\/wp-content\/plugins\/*","\/wp-content\/themes\/Divi\/*","\/*\\?(.+)"]}},{"not":{"selector_matches":"a[rel~=\"nofollow\"]"}},{"not":{"selector_matches":".no-prefetch, .no-prefetch a"}}]},"eagerness":"conservative"}]} </script> <script> ( function ( body ) { 'use strict'; body.className = body.className.replace( /\btribe-no-js\b/, 'tribe-js' ); } )( document.body ); </script> <!-- Instagram Feed JS --> <script type="text/javascript"> var sbiajaxurl = "https://usg.usc.edu/wp-admin/admin-ajax.php"; </script> <script> /* <![CDATA[ */var tribe_l10n_datatables = {"aria":{"sort_ascending":": activate to sort column ascending","sort_descending":": activate to sort column descending"},"length_menu":"Show _MENU_ entries","empty_table":"No data available in table","info":"Showing _START_ to _END_ of _TOTAL_ entries","info_empty":"Showing 0 to 0 of 0 entries","info_filtered":"(filtered from _MAX_ total entries)","zero_records":"No matching records found","search":"Search:","all_selected_text":"All items on this page were selected. ","select_all_link":"Select all pages","clear_selection":"Clear Selection.","pagination":{"all":"All","next":"Next","previous":"Previous"},"select":{"rows":{"0":"","_":": Selected %d rows","1":": Selected 1 row"}},"datepicker":{"dayNames":["Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"],"dayNamesShort":["Sun","Mon","Tue","Wed","Thu","Fri","Sat"],"dayNamesMin":["S","M","T","W","T","F","S"],"monthNames":["January","February","March","April","May","June","July","August","September","October","November","December"],"monthNamesShort":["January","February","March","April","May","June","July","August","September","October","November","December"],"monthNamesMin":["Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"],"nextText":"Next","prevText":"Prev","currentText":"Today","closeText":"Done","today":"Today","clear":"Clear"}};/* ]]> */ </script><script> document.addEventListener("DOMContentLoaded", function () { const mobileMenuButton = document.getElementById("mobilemenu"); const sidebarNavigation = document.getElementById("sidebarnavigation"); const overlay = document.createElement("div"); // Create overlay element dynamically overlay.id = "overlay"; document.body.appendChild(overlay); function showMenu() { sidebarNavigation.classList.add("show"); overlay.classList.add("show"); } function hideMenu() { sidebarNavigation.classList.remove("show"); overlay.classList.remove("show"); } // Show sidebar on mobile menu button click mobileMenuButton.addEventListener("click", function (event) { showMenu(); event.stopPropagation(); // Prevents immediate closing }); // Hide sidebar when clicking outside or on overlay overlay.addEventListener("click", hideMenu); // Hide sidebar when selecting an option document.querySelectorAll("#sidebarnavigation button").forEach(button => { button.addEventListener("click", hideMenu); }); }); let currentPage = 1; const cardsPerPage = 12; let projectsForCurrentFilter = []; async function fetchProjects() { const sheetURL = "https://docs.google.com/spreadsheets/d/e/2PACX-1vTpDRrRtY-6BCNoe6psBsBa_7rkf_lTj1upbOeFHLM_J1fyRLSOULRcFBvcsFleXtNSPRJlAg5Avo9I/pub?output=csv"; try { const response = await fetch(sheetURL); const data = await response.text(); console.log("Raw CSV Data:", data); // Debugging log const rows = data.split("\n").slice(1); // Remove header console.log("Processed Rows:", rows); // Debugging log const committeeMap = { 1: "EXE", 2: "ADV", 3: "LEG", 4: "ACA", 5: "ACC", 6: "ABN", 7: "CIS", 8: "EXT", 9: "WEL", 10: "BIL" }; const cleanColumn = col => col ? col.replace(/^"(.*)"$/, "$1") : ""; const projects = rows .map(row => { const columns = row.split(/,(?=(?:(?:[^"]*"){2})*[^"]*$)/).map(col => col.trim()); if (columns.length < 9) { console.warn("Skipping row due to missing columns:", columns); return null; } return { title: cleanColumn(columns[0]) || "Untitled Project", description: cleanColumn(columns[1]) || "No description available", date: cleanColumn(columns[2]) || "N/A", committee: committeeMap[parseInt(columns[3], 10)] || "N/A", imageUrl: cleanColumn(columns[4]) || "https://via.placeholder.com/64", statusValue: parseInt(columns[5]) || 1, linkTarget: cleanColumn(columns[6]) || "#", backgroundImage: cleanColumn(columns[8]) || "" }; }) .filter(project => project !== null); console.log("Final Parsed Projects:", projects); // Debugging log projectsForCurrentFilter = projects; renderProjects(projects); setupSidebarFilter(projects); } catch (error) { console.error("Error fetching data:", error); } } function renderProjects(projects) { const container = document.getElementById("projects"); container.innerHTML = ""; const startIndex = (currentPage - 1) * cardsPerPage; const endIndex = startIndex + cardsPerPage; const paginatedProjects = projects.slice(startIndex, endIndex); paginatedProjects.forEach(project => { const statusMap = { 1: { text: "Planning", color: "status-planning" }, 2: { text: "In Progress", color: "status-inprogress" }, 3: { text: "Almost Done", color: "status-almostdone" }, 4: { text: "Postponed", color: "status-postponed" }, 5: { text: "Completed", color: "status-completed" }, }; const statusText = statusMap[project.statusValue]?.text || "Unknown"; const statusClass = statusMap[project.statusValue]?.color || "status-planning"; const cardWrapper = document.createElement("div"); cardWrapper.classList.add("card-wrapper"); cardWrapper.dataset.committee = project.committee; cardWrapper.innerHTML = ` <div class="projectcard"> <div class="card-front" style="background-image: url('${project.backgroundImage}');"> <div class="card-header"> <div class="status"> <div class="status-indicator ${statusClass}"></div> <span>${statusText}</span> </div> <div class="card-icon"> <img src="${project.imageUrl}" alt="Icon"> </div> </div> <div class="card-title">${project.title}</div> <div class="card-footer"> <div class="footer-item"> <img src="https://cdn.prod.website-files.com/6720076e7585a2373cf76f4e/67a47b48b63a004d52565e7f_calendar-date.svg" alt="Date"> <span>${project.date}</span> </div> <div class="footer-item"> <img src="https://cdn.prod.website-files.com/6720076e7585a2373cf76f4e/67a47b48c9f9271c4598e87b_users-03.svg" alt="Committee"> <span>${project.committee}</span> </div> </div> </div> <div class="card-back"> <div class="card-description">${project.description}</div> <a href="${project.linkTarget}" target="_blank" class="link-button">View Project</a> </div> </div> `; cardWrapper.querySelector(".projectcard").addEventListener("click", function (event) { if (!event.target.classList.contains("link-button")) { this.classList.toggle("flipped"); } }); container.appendChild(cardWrapper); }); renderPaginationControls(projects.length); } function renderPaginationControls(totalProjects) { const container = document.getElementById("projects"); const existingControls = document.getElementById("pagination-controls"); if (existingControls) existingControls.remove(); const controls = document.createElement("div"); controls.id = "pagination-controls"; controls.style.gridColumn = "1 / -1"; if (currentPage > 1) { const prevButton = document.createElement("button"); prevButton.innerText = "Previous"; prevButton.classList.add("pagination-button"); prevButton.addEventListener("click", () => { currentPage--; renderProjects(projectsForCurrentFilter); }); controls.appendChild(prevButton); } const totalPages = Math.ceil(totalProjects / cardsPerPage); if (currentPage < totalPages) { const nextButton = document.createElement("button"); nextButton.innerText = "Next"; nextButton.classList.add("pagination-button"); nextButton.addEventListener("click", () => { currentPage++; renderProjects(projectsForCurrentFilter); }); controls.appendChild(nextButton); } container.appendChild(controls); } function setupSidebarFilter(projects) { document.querySelectorAll(".filter-button").forEach(button => { button.addEventListener("click", () => { document.querySelectorAll(".filter-button").forEach(btn => btn.classList.remove("active")); button.classList.add("active"); const filter = button.dataset.filter; projectsForCurrentFilter = filter === "all" ? projects : projects.filter(p => p.committee === filter); currentPage = 1; renderProjects(projectsForCurrentFilter); }); }); } fetchProjects(); </script> <script src="https://cdn.jsdelivr.net/npm/chart.js"></script> <script> // URL for fetching data const sheetURL = "https://docs.google.com/spreadsheets/d/e/2PACX-1vTpDRrRtY-6BCNoe6psBsBa_7rkf_lTj1upbOeFHLM_J1fyRLSOULRcFBvcsFleXtNSPRJlAg5Avo9I/pub?output=csv"; // Committee mapping const committeeMap = { 2: "Executive", 3: "Advocacy", 4: "Senate/Legislative", 5: "Academic Affairs", 6: "Accessibility", 7: "Affordability & Basic Needs", 8: "Campus Infrastructure & Sustainability", 9: "External Affairs", 10: "Wellness" }; async function fetchAndRenderCharts() { try { const response = await fetch(sheetURL); const data = await response.text(); const rows = data.split("\n"); // Data for the first chart (Projects by Committee) const labels1 = []; const values1 = []; rows.slice(1, 10).forEach((row, index) => { const columns = row.split(/,(?=(?:(?:[^"]*"){2})*[^"]*$)/).map(col => col.trim()); const committee = committeeMap[index + 2]; const numProjects = parseInt(columns[9], 10); // Column J (index 9) if (committee && !isNaN(numProjects)) { labels1.push(committee); values1.push(numProjects); } }); // Data for the second chart (Project Completion Status) const labels2 = ["Planning", "In Progress", "Almost Done", "Postponed/Paused", "Completed"]; const values2 = rows.slice(1, 6).map(row => { const columns = row.split(/,(?=(?:(?:[^"]*"){2})*[^"]*$)/).map(col => col.trim()); return parseInt(columns[10], 10); // Column K (index 10) }); // Render charts into the first set of containers renderChart("committeeChartContainer", "pie", labels1, values1, "Projects by Committee"); renderChart("completionStatusChartContainer", "doughnut", labels2, values2, "Project Status Distribution"); // Render charts into the second set of containers renderChart("committeeChartContainer2", "pie", labels1, values1, "Projects by Committee"); renderChart("completionStatusChartContainer2", "doughnut", labels2, values2, "Project Status Distribution"); } catch (error) { console.error("Error fetching data:", error); } } function renderChart(containerId, chartType, labels, values, chartTitle) { const container = document.getElementById(containerId); const canvas = document.createElement("canvas"); container.appendChild(canvas); new Chart(canvas, { type: chartType, data: { labels: labels, datasets: [{ data: values, backgroundColor: [ "#ef3a38", "#f7c337", "#3b9eb0", "#ef6c57", "#f4a261", "#2a9d8f", "#e76f51", "#264653", "#fcbf49" ], hoverOffset: 4 }] }, options: { responsive: true, plugins: { legend: { display: false // Removes the legend }, tooltip: { callbacks: { label: function (context) { const projects = context.raw; return ` ${projects} projects`; } }, bodyFont: { family: 'Rethink Sans', size: 14 } } } } }); } // Fetch and render both sets of charts fetchAndRenderCharts(); </script> <script> document.addEventListener("DOMContentLoaded", async () => { // Define selectors for dynamic value updates const totalBudgetElement = document.querySelector("#totalbudget .bentolargetext"); const studentsImpactedElement = document.querySelector("#totalstudents .bentolargetext"); const totalProjectsElement = document.querySelector("#activeprojects .bentolargetext"); const nextDeadlineElement = document.querySelector("#nextdeadline .bentolargetext"); // Define selectors for collaborators list in both containers const collaboratorsList = document.getElementById("collaborators-list"); const collaboratorsList2 = document.getElementById("collaborators-list2"); try { // Fetch data from the Google Sheets CSV const response = await fetch( "https://docs.google.com/spreadsheets/d/e/2PACX-1vTpDRrRtY-6BCNoe6psBsBa_7rkf_lTj1upbOeFHLM_J1fyRLSOULRcFBvcsFleXtNSPRJlAg5Avo9I/pub?output=csv" ); if (!response.ok) { throw new Error(`HTTP error! status: ${response.status}`); } const data = await response.text(); // Parse CSV data and remove quotes from cell values const rows = data.split("\n").map((row) => row.split(",").map((cell) => cell.replace(/^"|"$/g, "").trim()) ); if (rows.length < 10) { throw new Error("Not enough rows in the spreadsheet"); } // Extract data for cells O3, O5, O7, and O9 let budgetAllocated = rows[2]?.[14] || "10000"; // Cell O3 (Row 3, Column O) let studentsImpacted = rows[4]?.[14] || "49323"; // Cell O5 (Row 5, Column O) const totalProjects = rows[6]?.[14] || "34"; // Cell O7 (Row 7, Column O) const nextDeadline = rows[8]?.[14] || "Dec 1"; // Cell O9 (Row 9, Column O) // Add commas at the 4th last character position for budget and students budgetAllocated = budgetAllocated.replace(/(\d)(?=(\d{3})+$)/g, "$1,"); studentsImpacted = studentsImpacted.replace(/(\d)(?=(\d{3})+$)/g, "$1,"); // Replace the entire contents of the corresponding HTML elements totalBudgetElement.textContent = budgetAllocated; studentsImpactedElement.textContent = studentsImpacted; totalProjectsElement.textContent = totalProjects; nextDeadlineElement.textContent = nextDeadline; console.log("Updated HTML values with formatted values:", { budgetAllocated, studentsImpacted, totalProjects, nextDeadline, }); // Extract data for the collaborators (Column N for all rows) const collaborators = rows .slice(1) // Skip the header row .map((row) => (row[13] ? row[13].trim() : "")) .filter((item) => item !== ""); // Remove empty entries if (collaborators.length === 0) { console.warn("No collaborators found in the specified column."); } // Duplicate collaborators to create an infinite scrolling effect const infiniteCollaborators = [...collaborators, ...collaborators]; // Populate both collaborators lists infiniteCollaborators.forEach((collaborator) => { const listItem = document.createElement("li"); listItem.textContent = collaborator; listItem.classList.add("bentosmalltext"); // Apply bentosmalltext styling collaboratorsList.appendChild(listItem); // Clone the item for the second list so both have identical content const listItem2 = listItem.cloneNode(true); collaboratorsList2.appendChild(listItem2); }); console.log("Populated collaborators list:", collaborators); } catch (error) { console.error("Error fetching or processing data:", error); } }); </script> <script> document.addEventListener('DOMContentLoaded', function() { // Get references to both elements const elementA = document.querySelector('.bentoparenta'); const elementB = document.querySelector('.bentoparentb'); // Check if both elements exist if (!elementA || !elementB) { console.error('One or both of the required elements (bentoparenta, bentoparentb) were not found.'); return; } // Assume both share the same parent container const container = elementA.parentNode; // Function to update the displayed element based on viewport width function updateDisplay() { if (window.innerWidth <= 680) { // For viewports 680px or less, remove elementA (bentoparenta) if present, // and ensure elementB (bentoparentb) is in the DOM. if (container.contains(elementA)) { container.removeChild(elementA); } if (!container.contains(elementB)) { container.appendChild(elementB); } } else { // For viewports 681px or more, remove elementB (bentoparentb) if present, // and ensure elementA (bentoparenta) is in the DOM. if (container.contains(elementB)) { container.removeChild(elementB); } if (!container.contains(elementA)) { container.appendChild(elementA); } } } // Run the function once on page load updateDisplay(); // Listen for window resize events to update the display accordingly window.addEventListener('resize', updateDisplay); }); </script> <link rel='stylesheet' id='wp-block-library-css' href='https://usg.usc.edu/wp-includes/css/dist/block-library/style.min.css?ver=6.8.3' type='text/css' media='none' onload="media='all'" /> <script type="text/javascript" id="divi-custom-script-js-extra"> /* <![CDATA[ */ var DIVI = {"item_count":"%d Item","items_count":"%d Items"}; var et_builder_utils_params = {"condition":{"diviTheme":true,"extraTheme":false},"scrollLocations":["app","top"],"builderScrollLocations":{"desktop":"app","tablet":"app","phone":"app"},"onloadScrollLocation":"app","builderType":"fe"}; var et_frontend_scripts = {"builderCssContainerPrefix":"#et-boc","builderCssLayoutPrefix":"#et-boc .et-l"}; var et_pb_custom = {"ajaxurl":"https:\/\/usg.usc.edu\/wp-admin\/admin-ajax.php","images_uri":"https:\/\/usg.usc.edu\/wp-content\/themes\/Divi\/images","builder_images_uri":"https:\/\/usg.usc.edu\/wp-content\/themes\/Divi\/includes\/builder\/images","et_frontend_nonce":"73aae684a7","subscription_failed":"Please, check the fields below to make sure you entered the correct information.","et_ab_log_nonce":"b0407b6f98","fill_message":"Please, fill in the following fields:","contact_error_message":"Please, fix the following errors:","invalid":"Invalid email","captcha":"Captcha","prev":"Prev","previous":"Previous","next":"Next","wrong_captcha":"You entered the wrong number in captcha.","wrong_checkbox":"Checkbox","ignore_waypoints":"no","is_divi_theme_used":"1","widget_search_selector":".widget_search","ab_tests":[],"is_ab_testing_active":"","page_id":"285","unique_test_id":"","ab_bounce_rate":"5","is_cache_plugin_active":"yes","is_shortcode_tracking":"","tinymce_uri":"https:\/\/usg.usc.edu\/wp-content\/themes\/Divi\/includes\/builder\/frontend-builder\/assets\/vendors","accent_color":"#990000","waypoints_options":[]}; var et_pb_box_shadow_elements = []; /* ]]> */ </script> <script type="text/javascript" src="https://usg.usc.edu/wp-content/themes/Divi/js/scripts.min.js?ver=4.27.4" id="divi-custom-script-js"></script> <script type="text/javascript" src="https://usg.usc.edu/wp-content/themes/Divi/includes/builder/feature/dynamic-assets/assets/js/jquery.fitvids.js?ver=4.27.4" id="fitvids-js"></script> <script type="text/javascript" src="https://usg.usc.edu/wp-content/plugins/page-links-to/dist/new-tab.js?ver=3.3.7" id="page-links-to-js"></script> <script type="text/javascript" src="https://usg.usc.edu/wp-content/themes/Divi/core/admin/js/common.js?ver=4.27.4" id="et-core-common-js"></script> </body> </html>
