RMAS Membership Dashboard<\/title>\n\n \n <link href=\"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.3.7\/dist\/css\/bootstrap.min.css\" rel=\"stylesheet\">\n \n <link rel=\"stylesheet\" href=\"https:\/\/cdn.datatables.net\/2.3.2\/css\/dataTables.bootstrap5.min.css\">\n \n <link rel=\"stylesheet\" href=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/font-awesome\/6.7.2\/css\/all.min.css\"\/>\n\n <style>\n :root {\n --primary: #0d6efd;\n --secondary: #198754;\n --danger: #dc3545;\n --warning: #ffc107;\n --info: #0dcaf0;\n --dark: #212529;\n --light: #f8f9fa;\n --white: #ffffff;\n }\n\n body {\n background: #eef3f9;\n font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;\n }\n\n \/* Header *\/\n .header {\n background: linear-gradient(135deg, #0d6efd, #0b5ed7);\n color: white;\n padding: 25px;\n margin-bottom: 25px;\n box-shadow: 0 4px 15px rgba(0,0,0,.15);\n }\n\n .header h2 {\n font-weight: 700;\n margin-bottom: 5px;\n }\n\n \/* Cards *\/\n .card-box {\n border: none;\n border-radius: 18px;\n transition: .3s;\n box-shadow: 0 5px 15px rgba(0,0,0,.08);\n }\n\n .card-box:hover {\n transform: translateY(-5px);\n }\n\n .card-body i {\n font-size: 38px;\n opacity: .15;\n position: absolute;\n right: 20px;\n top: 20px;\n }\n\n .card-title {\n font-size: 14px;\n font-weight: 600;\n color: rgba(255, 255, 255, 0.85);\n }\n \n .text-bg-warning .card-title {\n color: #555;\n }\n\n .card-value {\n font-size: 34px;\n font-weight: 700;\n }\n\n \/* Search *\/\n .search-box {\n background: white;\n padding: 20px;\n border-radius: 15px;\n box-shadow: 0 5px 12px rgba(0,0,0,.08);\n }\n\n \/* Table Area *\/\n .table-area {\n background: white;\n padding: 20px;\n border-radius: 15px;\n margin-top: 20px;\n box-shadow: 0 5px 12px rgba(0,0,0,.08);\n }\n\n table th {\n background: #0d6efd !important;\n color: white !important;\n font-size: 13px;\n vertical-align: middle;\n }\n\n .btn-action {\n border-radius: 25px;\n padding: 8px 18px;\n }\n\n .btn i {\n margin-right: 5px;\n }\n\n footer {\n margin-top: 40px;\n padding: 15px;\n text-align: center;\n background: #212529;\n color: white;\n }\n\n #loadingOverlay {\n text-align: center;\n padding: 40px;\n font-size: 18px;\n font-weight: 600;\n color: #555;\n }\n\n @media(max-width:768px){\n .card-value { font-size: 28px; }\n .header { text-align: center; }\n }\n <\/style>\n<\/head>\n\n<body>\n\n<div class=\"header\">\n <div class=\"container\">\n <h2><i class=\"fa-solid fa-building-columns\"><\/i> RMAS Membership Dashboard<\/h2>\n <p class=\"mb-0\">Rajkiya Mahavidyalaya Academic Society Membership Management System<\/p>\n <\/div>\n<\/div>\n\n<div class=\"container\">\n \n <div class=\"row g-4\">\n <div class=\"col-md-3\">\n <div class=\"card card-box text-bg-primary\">\n <div class=\"card-body position-relative\">\n <i class=\"fa-solid fa-school\"><\/i>\n <div class=\"card-title\">Total Colleges<\/div>\n <div class=\"card-value\" id=\"collegeCount\">0<\/div>\n <\/div>\n <\/div>\n <\/div>\n <div class=\"col-md-3\">\n <div class=\"card card-box text-bg-success\">\n <div class=\"card-body position-relative\">\n <i class=\"fa-solid fa-users\"><\/i>\n <div class=\"card-title\">Total Teachers<\/div>\n <div class=\"card-value\" id=\"teacherCount\">0<\/div>\n <\/div>\n <\/div>\n <\/div>\n <div class=\"col-md-3\">\n <div class=\"card card-box text-bg-warning\">\n <div class=\"card-body position-relative\">\n <i class=\"fa-solid fa-user-check\"><\/i>\n <div class=\"card-title\">Total Active Members<\/div>\n <div class=\"card-value\" id=\"memberCount\">0<\/div>\n <\/div>\n <\/div>\n <\/div>\n <div class=\"col-md-3\">\n <div class=\"card card-box text-bg-danger\">\n <div class=\"card-body position-relative\">\n <i class=\"fa-solid fa-indian-rupee-sign\"><\/i>\n <div class=\"card-title\">Total Amount Deposited<\/div>\n <div class=\"card-value\" id=\"amountCount\">\u20b90<\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n\n \n <div class=\"search-box mt-4\">\n <div class=\"row g-3\">\n <div class=\"col-md-4\">\n <input type=\"text\" id=\"searchBox\" class=\"form-control form-control-lg\" placeholder=\"Search College \/ AISHE \/ Principal\" disabled>\n <\/div>\n <div class=\"col-md-8 text-end\">\n <button id=\"pdfBtn\" class=\"btn btn-danger btn-action\" disabled>\n <i class=\"fa fa-file-pdf\"><\/i> PDF\n <\/button>\n <button id=\"excelBtn\" class=\"btn btn-success btn-action\" disabled>\n <i class=\"fa fa-file-excel\"><\/i> Excel\n <\/button>\n <button id=\"printBtn\" class=\"btn btn-secondary btn-action\" disabled>\n <i class=\"fa fa-print\"><\/i> Print\n <\/button>\n <\/div>\n <\/div>\n <\/div>\n\n \n <div class=\"table-area\">\n <div id=\"loadingOverlay\">\n <i class=\"fas fa-spinner fa-spin me-2\"><\/i> Fetching Live Membership Data from Google Sheets...\n <\/div>\n <table id=\"membershipTable\" class=\"table table-bordered table-hover align-middle d-none\">\n <thead>\n <tr>\n <th>#<\/th>\n <th>College Name<\/th>\n <th>College AISHE Code<\/th>\n <th>Principal Name<\/th>\n <th>Total Teachers<\/th>\n <th>Existing Annual Members<\/th>\n <th>New Annual Members<\/th>\n <th>Existing Life Members<\/th>\n <th>New Life Members<\/th>\n <th>Total Amount Deposited<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n \n <\/tbody>\n <\/table>\n <\/div>\n<\/div>\n\n<footer>\n \u00a9 2026 Rajkiya Mahavidyalaya Academic Society (RMAS)\n<\/footer>\n\n\n<script src=\"https:\/\/code.jquery.com\/jquery-3.7.1.min.js\"><\/script>\n<script src=\"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.3.7\/dist\/js\/bootstrap.bundle.min.js\"><\/script>\n<script src=\"https:\/\/cdn.datatables.net\/2.3.2\/js\/dataTables.min.js\"><\/script>\n<script src=\"https:\/\/cdn.datatables.net\/2.3.2\/js\/dataTables.bootstrap5.min.js\"><\/script>\n<script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/jspdf\/2.5.1\/jspdf.umd.min.js\"><\/script>\n<script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/jspdf-autotable\/3.8.2\/jspdf.plugin.autotable.min.js\"><\/script>\n<script src=\"https:\/\/cdn.jsdelivr.net\/npm\/xlsx@0.18.5\/dist\/xlsx.full.min.js\"><\/script>\n\n<script>\nconst CSV_URL = \"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vRFArnELp-e8l-5557i6F4TP7CgFwE5NkY6MQCTB3FL3BHkDMiP8uwPuukrgbyIejau9AJ50Qd3IXuI\/pub?gid=513015645&single=true&output=csv\";\n\nlet membershipData = [];\nlet tableInstance = null;\n\n\/*=========================================================\n CUSTOM SCHEMA MAPPING CSV PARSER ENGINE\n=========================================================*\/\nfunction parseCSV(text) {\n let lines = [];\n let row = [\"\"];\n let inQuotes = false;\n\n for (let i = 0; i < text.length; i++) {\n let c = text[i];\n let next = text[i+1];\n\n if (c === '\"') {\n if (inQuotes && next === '\"') { row[row.length - 1] += '\"'; i++; }\n else { inQuotes = !inQuotes; }\n } else if (c === ',' && !inQuotes) {\n row.push('');\n } else if ((c === '\\r' || c === '\\n') && !inQuotes) {\n if (c === '\\r' && next === '\\n') { i++; }\n lines.push(row);\n row = [''];\n } else {\n row[row.length - 1] += c;\n }\n }\n if (row.length > 1 || row[0] !== '') { lines.push(row); }\n if (lines.length === 0) return [];\n\n \/\/ Normalize keys for exact mapping checks\n const headers = lines[0].map(h => h.trim().toLowerCase().replace(\/\\s+\/g, ''));\n \n return lines.slice(1).map(columns => {\n let obj = {\n college: \"\", aishe: \"\", principal: \"\", teachers: 0,\n existingAnnual: 0, newAnnual: 0, existingLife: 0, newLife: 0, amount: 0\n };\n \n columns.forEach((val, idx) => {\n let cleanVal = val.trim();\n let headerName = headers[idx];\n if (!headerName) return;\n\n \/\/ Strict privacy structural drop\n if (headerName.includes(\"mobile\") || headerName.includes(\"email\")) return;\n\n if (headerName.includes(\"collegename\")) obj.college = cleanVal;\n else if (headerName.includes(\"aishe\")) obj.aishe = cleanVal;\n else if (headerName.includes(\"principal\")) obj.principal = cleanVal;\n else if (headerName.includes(\"numberofteachers\")) obj.teachers = parseInt(cleanVal) || 0;\n else if (headerName.includes(\"existingannual\")) obj.existingAnnual = parseInt(cleanVal) || 0;\n else if (headerName.includes(\"newannual\")) obj.newAnnual = parseInt(cleanVal) || 0;\n else if (headerName.includes(\"existinglife\")) obj.existingLife = parseInt(cleanVal) || 0;\n else if (headerName.includes(\"newlife\")) obj.newLife = parseInt(cleanVal) || 0;\n else if (headerName.includes(\"amountdeposited\")) obj.amount = parseFloat(cleanVal.replace(\/[\u20b9,]\/g, '')) || 0;\n });\n return obj;\n }).filter(item => item.college);\n}\n\n\/*=========================================================\n INTERFACE UI AGGREGATION & RENDER Lifecycles\n=========================================================*\/\nfunction loadTable() {\n let tbody = document.querySelector(\"#membershipTable tbody\");\n tbody.innerHTML = \"\";\n\n membershipData.forEach((item, index) => {\n tbody.innerHTML += `\n <tr>\n <td>${index + 1}<\/td>\n <td><strong>${item.college}<\/strong><\/td>\n <td><span class=\"badge bg-light text-dark border\">${item.aishe}<\/span><\/td>\n <td>${item.principal}<\/td>\n <td class=\"text-center\">${item.teachers}<\/td>\n <td class=\"text-center\">${item.existingAnnual}<\/td>\n <td class=\"text-center\">${item.newAnnual}<\/td>\n <td class=\"text-center\">${item.existingLife}<\/td>\n <td class=\"text-center\">${item.newLife}<\/td>\n <td class=\"text-end fw-bold text-success\">\u20b9${item.amount.toLocaleString()}<\/td>\n <\/tr>\n `;\n });\n}\n\nfunction updateDashboard() {\n let colleges = membershipData.length;\n let teachers = 0;\n let members = 0;\n let amount = 0;\n\n membershipData.forEach(item => {\n teachers += item.teachers;\n members += (item.existingAnnual + item.newAnnual + item.existingLife + item.newLife);\n amount += item.amount;\n });\n\n document.getElementById(\"collegeCount\").innerText = colleges;\n document.getElementById(\"teacherCount\").innerText = teachers;\n document.getElementById(\"memberCount\").innerText = members;\n document.getElementById(\"amountCount\").innerText = \"\u20b9\" + amount.toLocaleString();\n}\n\n\/*=========================================================\n REPORT PIPELINES (PDF \/ EXCEL \/ PRINT STRUCTURES)\n=========================================================*\/\nfunction exportPDF() {\n const { jsPDF } = window.jspdf;\n const doc = new jsPDF(\"landscape\", \"mm\", \"a4\");\n\n doc.setFontSize(16);\n doc.setTextColor(13, 110, 253);\n doc.text(\"RMAS Membership Detailed Report\", 14, 15);\n\n doc.setFontSize(10);\n doc.setTextColor(100);\n doc.text(\"Rajkiya Mahavidyalaya Academic Society\", 14, 21);\n\n doc.autoTable({\n startY: 28,\n head: [[\"S.No\", \"College Name\", \"AISHE\", \"Principal\", \"Teachers\", \"Exist. Ann.\", \"New Ann.\", \"Exist. Life\", \"New Life\", \"Deposited\"]],\n body: membershipData.map((item, index) => [\n index + 1,\n item.college,\n item.aishe,\n item.principal,\n item.teachers,\n item.existingAnnual,\n item.newAnnual,\n item.existingLife,\n item.newLife,\n \"\u20b9\" + item.amount\n ]),\n theme: \"grid\",\n headStyles: { fillColor: [13, 110, 253], textColor: 255, fontStyle: \"bold\" },\n alternateRowStyles: { fillColor: [248, 249, 250] },\n styles: { fontSize: 7.5, cellPadding: 2 }\n });\n\n doc.save(\"RMAS_Membership_Report.pdf\");\n}\n\nfunction exportExcel() {\n const wsData = membershipData.map((item, index) => ({\n \"S.No\": index + 1,\n \"College Name\": item.college,\n \"College AISHE Code\": item.aishe,\n \"Principal Name\": item.principal,\n \"Total Number of Teachers\": item.teachers,\n \"Total Number of Existing Annual Member\": item.existingAnnual,\n \"Total Number of New Annual Member\": item.newAnnual,\n \"Total Number of Existing Life Members\": item.existingLife,\n \"Total Number of New Life Members\": item.newLife,\n \"Total Amount Deposited\": item.amount\n }));\n\n const ws = XLSX.utils.json_to_sheet(wsData);\n const wb = XLSX.utils.book_new();\n XLSX.utils.book_append_sheet(wb, ws, \"RMAS Data\");\n XLSX.writeFile(wb, \"RMAS_Membership_Report.xlsx\");\n}\n\nfunction printReport() {\n let html = `\n <html>\n <head>\n <title>RMAS Membership Report<\/title>\n <style>\n body { font-family: Arial, sans-serif; margin: 25px; }\n h2 { text-align: center; color: #0d6efd; margin-bottom: 5px; }\n h4 { text-align: center; color: #555; margin-top: 0; font-weight: normal; }\n table { width: 100%; border-collapse: collapse; margin-top: 20px; }\n th, td { border: 1px solid #ddd; padding: 7px; font-size: 11px; text-align: left; }\n th { background-color: #0d6efd; color: white; }\n tr:nth-child(even) { background-color: #f9f9f9; }\n .text-center { text-align: center; }\n .text-end { text-align: right; }\n <\/style>\n <\/head>\n <body>\n <h2>RMAS Membership Detailed Report<\/h2>\n <h4>Rajkiya Mahavidyalaya Academic Society<\/h4>\n <table>\n <thead>\n <tr>\n <th>S.No<\/th>\n <th>College Name<\/th>\n <th>AISHE<\/th>\n <th>Principal Name<\/th>\n <th>Teachers<\/th>\n <th>Exist. Ann<\/th>\n <th>New Ann<\/th>\n <th>Exist. Life<\/th>\n <th>New Life<\/th>\n <th>Amount Deposited<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n `;\n\n membershipData.forEach((item, index) => {\n html += `\n <tr>\n <td class=\"text-center\">${index + 1}<\/td>\n <td><strong>${item.college}<\/strong><\/td>\n <td>${item.aishe}<\/td>\n <td>${item.principal}<\/td>\n <td class=\"text-center\">${item.teachers}<\/td>\n <td class=\"text-center\">${item.existingAnnual}<\/td>\n <td class=\"text-center\">${item.newAnnual}<\/td>\n <td class=\"text-center\">${item.existingLife}<\/td>\n <td class=\"text-center\">${item.newLife}<\/td>\n <td class=\"text-end\">\u20b9${item.amount.toLocaleString()}<\/td>\n <\/tr>\n `;\n });\n\n html += `\n <\/tbody>\n <\/table>\n <\/body>\n <\/html>\n `;\n\n const win = window.open(\"\", \"PRINT\", \"height=750,width=1100\");\n win.document.write(html);\n win.document.close();\n win.focus();\n setTimeout(() => {\n win.print();\n win.close();\n }, 500);\n}\n\n\/*=========================================================\n CORE INITIALIZATION & ASYNC DATA STREAM LOOPS\n=========================================================*\/\ndocument.addEventListener(\"DOMContentLoaded\", () => {\n fetch(CSV_URL)\n .then(response => {\n if (!response.ok) throw new Error(\"Spreadsheet retrieval failed\");\n return response.text();\n })\n .then(csvText => {\n membershipData = parseCSV(csvText);\n\n loadTable();\n updateDashboard();\n\n document.getElementById(\"loadingOverlay\").classList.add(\"d-none\");\n document.getElementById(\"membershipTable\").classList.remove(\"d-none\");\n\n tableInstance = new DataTable(\"#membershipTable\", {\n pageLength: 10,\n responsive: true,\n ordering: true,\n searching: true,\n layout: { topStart: null },\n lengthMenu: [[10, 25, 50, -1], [10, 25, 50, \"All\"]]\n });\n\n document.getElementById(\"searchBox\").removeAttribute(\"disabled\");\n document.getElementById(\"pdfBtn\").removeAttribute(\"disabled\");\n document.getElementById(\"excelBtn\").removeAttribute(\"disabled\");\n document.getElementById(\"printBtn\").removeAttribute(\"disabled\");\n })\n .catch(err => {\n console.error(\"Critical Orchestration Exception:\", err);\n document.getElementById(\"loadingOverlay\").innerHTML = `\n <span class=\"text-danger\">\n <i class=\"fas fa-exclamation-triangle\"><\/i> Synchronizer Failure.<br>\n <small class=\"text-muted\">Ensure Google Sheets data columns map explicitly to dashboard components.<\/small>\n <\/span>\n `;\n });\n\n document.getElementById(\"searchBox\").addEventListener(\"keyup\", function() {\n if (tableInstance) tableInstance.search(this.value).draw();\n });\n\n document.getElementById(\"pdfBtn\").addEventListener(\"click\", exportPDF);\n document.getElementById(\"excelBtn\").addEventListener(\"click\", exportExcel);\n document.getElementById(\"printBtn\").addEventListener(\"click\", printReport);\n});\n<\/script>\n<\/body>\n<\/html><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>RMAS Membership Dashboard RMAS Membership Dashboard Rajkiya Mahavidyalaya Academic Society Membership Management System Total Colleges 0 Total Teachers 0 Total Active Members 0 Total Amount Deposited \u20b90 PDF Excel Print Fetching Live Membership Data from Google Sheets… # College Name College AISHE Code Principal Name Total Teachers Existing Annual Members New Annual Members Existing Life […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"no-sidebar","site-content-layout":"page-builder","ast-site-content-layout":"full-width-container","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"disabled","ast-main-header-display":"disabled","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"disabled","ast-hfb-mobile-header-display":"disabled","site-post-title":"","ast-breadcrumbs-content":"disabled","ast-featured-img":"disabled","footer-sml-layout":"disabled","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-6416","page","type-page","status-publish","hentry"],"_hostinger_reach_plugin_has_subscription_block":false,"_hostinger_reach_plugin_is_elementor":false,"_links":{"self":[{"href":"https:\/\/rmasup.edu.in\/index.php\/wp-json\/wp\/v2\/pages\/6416","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rmasup.edu.in\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/rmasup.edu.in\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/rmasup.edu.in\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rmasup.edu.in\/index.php\/wp-json\/wp\/v2\/comments?post=6416"}],"version-history":[{"count":25,"href":"https:\/\/rmasup.edu.in\/index.php\/wp-json\/wp\/v2\/pages\/6416\/revisions"}],"predecessor-version":[{"id":6469,"href":"https:\/\/rmasup.edu.in\/index.php\/wp-json\/wp\/v2\/pages\/6416\/revisions\/6469"}],"wp:attachment":[{"href":"https:\/\/rmasup.edu.in\/index.php\/wp-json\/wp\/v2\/media?parent=6416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

\n\t\t\t\t\t\t

\n\t\t\t\t\t

\n\t\t\t

\n\t\t\t\t\t\t

\n\t\t\t\t

\n\t\t\t\t\t\t\t

\n\n\n \n \n RMAS Membership Dashboard<\/title>\n\n \n <link href=\"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.3.7\/dist\/css\/bootstrap.min.css\" rel=\"stylesheet\">\n \n <link rel=\"stylesheet\" href=\"https:\/\/cdn.datatables.net\/2.3.2\/css\/dataTables.bootstrap5.min.css\">\n \n <link rel=\"stylesheet\" href=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/font-awesome\/6.7.2\/css\/all.min.css\"\/>\n\n <style>\n :root {\n --primary: #0d6efd;\n --secondary: #198754;\n --danger: #dc3545;\n --warning: #ffc107;\n --info: #0dcaf0;\n --dark: #212529;\n --light: #f8f9fa;\n --white: #ffffff;\n }\n\n body {\n background: #eef3f9;\n font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;\n }\n\n \/* Header *\/\n .header {\n background: linear-gradient(135deg, #0d6efd, #0b5ed7);\n color: white;\n padding: 25px;\n margin-bottom: 25px;\n box-shadow: 0 4px 15px rgba(0,0,0,.15);\n }\n\n .header h2 {\n font-weight: 700;\n margin-bottom: 5px;\n }\n\n \/* Cards *\/\n .card-box {\n border: none;\n border-radius: 18px;\n transition: .3s;\n box-shadow: 0 5px 15px rgba(0,0,0,.08);\n }\n\n .card-box:hover {\n transform: translateY(-5px);\n }\n\n .card-body i {\n font-size: 38px;\n opacity: .15;\n position: absolute;\n right: 20px;\n top: 20px;\n }\n\n .card-title {\n font-size: 14px;\n font-weight: 600;\n color: rgba(255, 255, 255, 0.85);\n }\n \n .text-bg-warning .card-title {\n color: #555;\n }\n\n .card-value {\n font-size: 34px;\n font-weight: 700;\n }\n\n \/* Search *\/\n .search-box {\n background: white;\n padding: 20px;\n border-radius: 15px;\n box-shadow: 0 5px 12px rgba(0,0,0,.08);\n }\n\n \/* Table Area *\/\n .table-area {\n background: white;\n padding: 20px;\n border-radius: 15px;\n margin-top: 20px;\n box-shadow: 0 5px 12px rgba(0,0,0,.08);\n }\n\n table th {\n background: #0d6efd !important;\n color: white !important;\n font-size: 13px;\n vertical-align: middle;\n }\n\n .btn-action {\n border-radius: 25px;\n padding: 8px 18px;\n }\n\n .btn i {\n margin-right: 5px;\n }\n\n footer {\n margin-top: 40px;\n padding: 15px;\n text-align: center;\n background: #212529;\n color: white;\n }\n\n #loadingOverlay {\n text-align: center;\n padding: 40px;\n font-size: 18px;\n font-weight: 600;\n color: #555;\n }\n\n @media(max-width:768px){\n .card-value { font-size: 28px; }\n .header { text-align: center; }\n }\n <\/style>\n<\/head>\n\n<body>\n\n<div class=\"header\">\n <div class=\"container\">\n <h2><i class=\"fa-solid fa-building-columns\"><\/i> RMAS Membership Dashboard<\/h2>\n <p class=\"mb-0\">Rajkiya Mahavidyalaya Academic Society Membership Management System<\/p>\n <\/div>\n<\/div>\n\n<div class=\"container\">\n \n <div class=\"row g-4\">\n <div class=\"col-md-3\">\n <div class=\"card card-box text-bg-primary\">\n <div class=\"card-body position-relative\">\n <i class=\"fa-solid fa-school\"><\/i>\n <div class=\"card-title\">Total Colleges<\/div>\n <div class=\"card-value\" id=\"collegeCount\">0<\/div>\n <\/div>\n <\/div>\n <\/div>\n <div class=\"col-md-3\">\n <div class=\"card card-box text-bg-success\">\n <div class=\"card-body position-relative\">\n <i class=\"fa-solid fa-users\"><\/i>\n <div class=\"card-title\">Total Teachers<\/div>\n <div class=\"card-value\" id=\"teacherCount\">0<\/div>\n <\/div>\n <\/div>\n <\/div>\n <div class=\"col-md-3\">\n <div class=\"card card-box text-bg-warning\">\n <div class=\"card-body position-relative\">\n <i class=\"fa-solid fa-user-check\"><\/i>\n <div class=\"card-title\">Total Active Members<\/div>\n <div class=\"card-value\" id=\"memberCount\">0<\/div>\n <\/div>\n <\/div>\n <\/div>\n <div class=\"col-md-3\">\n <div class=\"card card-box text-bg-danger\">\n <div class=\"card-body position-relative\">\n <i class=\"fa-solid fa-indian-rupee-sign\"><\/i>\n <div class=\"card-title\">Total Amount Deposited<\/div>\n <div class=\"card-value\" id=\"amountCount\">\u20b90<\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n\n \n <div class=\"search-box mt-4\">\n <div class=\"row g-3\">\n <div class=\"col-md-4\">\n <input type=\"text\" id=\"searchBox\" class=\"form-control form-control-lg\" placeholder=\"Search College \/ AISHE \/ Principal\" disabled>\n <\/div>\n <div class=\"col-md-8 text-end\">\n <button id=\"pdfBtn\" class=\"btn btn-danger btn-action\" disabled>\n <i class=\"fa fa-file-pdf\"><\/i> PDF\n <\/button>\n <button id=\"excelBtn\" class=\"btn btn-success btn-action\" disabled>\n <i class=\"fa fa-file-excel\"><\/i> Excel\n <\/button>\n <button id=\"printBtn\" class=\"btn btn-secondary btn-action\" disabled>\n <i class=\"fa fa-print\"><\/i> Print\n <\/button>\n <\/div>\n <\/div>\n <\/div>\n\n \n <div class=\"table-area\">\n <div id=\"loadingOverlay\">\n <i class=\"fas fa-spinner fa-spin me-2\"><\/i> Fetching Live Membership Data from Google Sheets...\n <\/div>\n <table id=\"membershipTable\" class=\"table table-bordered table-hover align-middle d-none\">\n <thead>\n <tr>\n <th>#<\/th>\n <th>College Name<\/th>\n <th>College AISHE Code<\/th>\n <th>Principal Name<\/th>\n <th>Total Teachers<\/th>\n <th>Existing Annual Members<\/th>\n <th>New Annual Members<\/th>\n <th>Existing Life Members<\/th>\n <th>New Life Members<\/th>\n <th>Total Amount Deposited<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n \n <\/tbody>\n <\/table>\n <\/div>\n<\/div>\n\n<footer>\n \u00a9 2026 Rajkiya Mahavidyalaya Academic Society (RMAS)\n<\/footer>\n\n\n<script src=\"https:\/\/code.jquery.com\/jquery-3.7.1.min.js\"><\/script>\n<script src=\"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.3.7\/dist\/js\/bootstrap.bundle.min.js\"><\/script>\n<script src=\"https:\/\/cdn.datatables.net\/2.3.2\/js\/dataTables.min.js\"><\/script>\n<script src=\"https:\/\/cdn.datatables.net\/2.3.2\/js\/dataTables.bootstrap5.min.js\"><\/script>\n<script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/jspdf\/2.5.1\/jspdf.umd.min.js\"><\/script>\n<script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/jspdf-autotable\/3.8.2\/jspdf.plugin.autotable.min.js\"><\/script>\n<script src=\"https:\/\/cdn.jsdelivr.net\/npm\/xlsx@0.18.5\/dist\/xlsx.full.min.js\"><\/script>\n\n<script>\nconst CSV_URL = \"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vRFArnELp-e8l-5557i6F4TP7CgFwE5NkY6MQCTB3FL3BHkDMiP8uwPuukrgbyIejau9AJ50Qd3IXuI\/pub?gid=513015645&single=true&output=csv\";\n\nlet membershipData = [];\nlet tableInstance = null;\n\n\/*=========================================================\n CUSTOM SCHEMA MAPPING CSV PARSER ENGINE\n=========================================================*\/\nfunction parseCSV(text) {\n let lines = [];\n let row = [\"\"];\n let inQuotes = false;\n\n for (let i = 0; i < text.length; i++) {\n let c = text[i];\n let next = text[i+1];\n\n if (c === '\"') {\n if (inQuotes && next === '\"') { row[row.length - 1] += '\"'; i++; }\n else { inQuotes = !inQuotes; }\n } else if (c === ',' && !inQuotes) {\n row.push('');\n } else if ((c === '\\r' || c === '\\n') && !inQuotes) {\n if (c === '\\r' && next === '\\n') { i++; }\n lines.push(row);\n row = [''];\n } else {\n row[row.length - 1] += c;\n }\n }\n if (row.length > 1 || row[0] !== '') { lines.push(row); }\n if (lines.length === 0) return [];\n\n \/\/ Normalize keys for exact mapping checks\n const headers = lines[0].map(h => h.trim().toLowerCase().replace(\/\\s+\/g, ''));\n \n return lines.slice(1).map(columns => {\n let obj = {\n college: \"\", aishe: \"\", principal: \"\", teachers: 0,\n existingAnnual: 0, newAnnual: 0, existingLife: 0, newLife: 0, amount: 0\n };\n \n columns.forEach((val, idx) => {\n let cleanVal = val.trim();\n let headerName = headers[idx];\n if (!headerName) return;\n\n \/\/ Strict privacy structural drop\n if (headerName.includes(\"mobile\") || headerName.includes(\"email\")) return;\n\n if (headerName.includes(\"collegename\")) obj.college = cleanVal;\n else if (headerName.includes(\"aishe\")) obj.aishe = cleanVal;\n else if (headerName.includes(\"principal\")) obj.principal = cleanVal;\n else if (headerName.includes(\"numberofteachers\")) obj.teachers = parseInt(cleanVal) || 0;\n else if (headerName.includes(\"existingannual\")) obj.existingAnnual = parseInt(cleanVal) || 0;\n else if (headerName.includes(\"newannual\")) obj.newAnnual = parseInt(cleanVal) || 0;\n else if (headerName.includes(\"existinglife\")) obj.existingLife = parseInt(cleanVal) || 0;\n else if (headerName.includes(\"newlife\")) obj.newLife = parseInt(cleanVal) || 0;\n else if (headerName.includes(\"amountdeposited\")) obj.amount = parseFloat(cleanVal.replace(\/[\u20b9,]\/g, '')) || 0;\n });\n return obj;\n }).filter(item => item.college);\n}\n\n\/*=========================================================\n INTERFACE UI AGGREGATION & RENDER Lifecycles\n=========================================================*\/\nfunction loadTable() {\n let tbody = document.querySelector(\"#membershipTable tbody\");\n tbody.innerHTML = \"\";\n\n membershipData.forEach((item, index) => {\n tbody.innerHTML += `\n <tr>\n <td>${index + 1}<\/td>\n <td><strong>${item.college}<\/strong><\/td>\n <td><span class=\"badge bg-light text-dark border\">${item.aishe}<\/span><\/td>\n <td>${item.principal}<\/td>\n <td class=\"text-center\">${item.teachers}<\/td>\n <td class=\"text-center\">${item.existingAnnual}<\/td>\n <td class=\"text-center\">${item.newAnnual}<\/td>\n <td class=\"text-center\">${item.existingLife}<\/td>\n <td class=\"text-center\">${item.newLife}<\/td>\n <td class=\"text-end fw-bold text-success\">\u20b9${item.amount.toLocaleString()}<\/td>\n <\/tr>\n `;\n });\n}\n\nfunction updateDashboard() {\n let colleges = membershipData.length;\n let teachers = 0;\n let members = 0;\n let amount = 0;\n\n membershipData.forEach(item => {\n teachers += item.teachers;\n members += (item.existingAnnual + item.newAnnual + item.existingLife + item.newLife);\n amount += item.amount;\n });\n\n document.getElementById(\"collegeCount\").innerText = colleges;\n document.getElementById(\"teacherCount\").innerText = teachers;\n document.getElementById(\"memberCount\").innerText = members;\n document.getElementById(\"amountCount\").innerText = \"\u20b9\" + amount.toLocaleString();\n}\n\n\/*=========================================================\n REPORT PIPELINES (PDF \/ EXCEL \/ PRINT STRUCTURES)\n=========================================================*\/\nfunction exportPDF() {\n const { jsPDF } = window.jspdf;\n const doc = new jsPDF(\"landscape\", \"mm\", \"a4\");\n\n doc.setFontSize(16);\n doc.setTextColor(13, 110, 253);\n doc.text(\"RMAS Membership Detailed Report\", 14, 15);\n\n doc.setFontSize(10);\n doc.setTextColor(100);\n doc.text(\"Rajkiya Mahavidyalaya Academic Society\", 14, 21);\n\n doc.autoTable({\n startY: 28,\n head: [[\"S.No\", \"College Name\", \"AISHE\", \"Principal\", \"Teachers\", \"Exist. Ann.\", \"New Ann.\", \"Exist. Life\", \"New Life\", \"Deposited\"]],\n body: membershipData.map((item, index) => [\n index + 1,\n item.college,\n item.aishe,\n item.principal,\n item.teachers,\n item.existingAnnual,\n item.newAnnual,\n item.existingLife,\n item.newLife,\n \"\u20b9\" + item.amount\n ]),\n theme: \"grid\",\n headStyles: { fillColor: [13, 110, 253], textColor: 255, fontStyle: \"bold\" },\n alternateRowStyles: { fillColor: [248, 249, 250] },\n styles: { fontSize: 7.5, cellPadding: 2 }\n });\n\n doc.save(\"RMAS_Membership_Report.pdf\");\n}\n\nfunction exportExcel() {\n const wsData = membershipData.map((item, index) => ({\n \"S.No\": index + 1,\n \"College Name\": item.college,\n \"College AISHE Code\": item.aishe,\n \"Principal Name\": item.principal,\n \"Total Number of Teachers\": item.teachers,\n \"Total Number of Existing Annual Member\": item.existingAnnual,\n \"Total Number of New Annual Member\": item.newAnnual,\n \"Total Number of Existing Life Members\": item.existingLife,\n \"Total Number of New Life Members\": item.newLife,\n \"Total Amount Deposited\": item.amount\n }));\n\n const ws = XLSX.utils.json_to_sheet(wsData);\n const wb = XLSX.utils.book_new();\n XLSX.utils.book_append_sheet(wb, ws, \"RMAS Data\");\n XLSX.writeFile(wb, \"RMAS_Membership_Report.xlsx\");\n}\n\nfunction printReport() {\n let html = `\n <html>\n <head>\n <title>RMAS Membership Report<\/title>\n <style>\n body { font-family: Arial, sans-serif; margin: 25px; }\n h2 { text-align: center; color: #0d6efd; margin-bottom: 5px; }\n h4 { text-align: center; color: #555; margin-top: 0; font-weight: normal; }\n table { width: 100%; border-collapse: collapse; margin-top: 20px; }\n th, td { border: 1px solid #ddd; padding: 7px; font-size: 11px; text-align: left; }\n th { background-color: #0d6efd; color: white; }\n tr:nth-child(even) { background-color: #f9f9f9; }\n .text-center { text-align: center; }\n .text-end { text-align: right; }\n <\/style>\n <\/head>\n <body>\n <h2>RMAS Membership Detailed Report<\/h2>\n <h4>Rajkiya Mahavidyalaya Academic Society<\/h4>\n <table>\n <thead>\n <tr>\n <th>S.No<\/th>\n <th>College Name<\/th>\n <th>AISHE<\/th>\n <th>Principal Name<\/th>\n <th>Teachers<\/th>\n <th>Exist. Ann<\/th>\n <th>New Ann<\/th>\n <th>Exist. Life<\/th>\n <th>New Life<\/th>\n <th>Amount Deposited<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n `;\n\n membershipData.forEach((item, index) => {\n html += `\n <tr>\n <td class=\"text-center\">${index + 1}<\/td>\n <td><strong>${item.college}<\/strong><\/td>\n <td>${item.aishe}<\/td>\n <td>${item.principal}<\/td>\n <td class=\"text-center\">${item.teachers}<\/td>\n <td class=\"text-center\">${item.existingAnnual}<\/td>\n <td class=\"text-center\">${item.newAnnual}<\/td>\n <td class=\"text-center\">${item.existingLife}<\/td>\n <td class=\"text-center\">${item.newLife}<\/td>\n <td class=\"text-end\">\u20b9${item.amount.toLocaleString()}<\/td>\n <\/tr>\n `;\n });\n\n html += `\n <\/tbody>\n <\/table>\n <\/body>\n <\/html>\n `;\n\n const win = window.open(\"\", \"PRINT\", \"height=750,width=1100\");\n win.document.write(html);\n win.document.close();\n win.focus();\n setTimeout(() => {\n win.print();\n win.close();\n }, 500);\n}\n\n\/*=========================================================\n CORE INITIALIZATION & ASYNC DATA STREAM LOOPS\n=========================================================*\/\ndocument.addEventListener(\"DOMContentLoaded\", () => {\n fetch(CSV_URL)\n .then(response => {\n if (!response.ok) throw new Error(\"Spreadsheet retrieval failed\");\n return response.text();\n })\n .then(csvText => {\n membershipData = parseCSV(csvText);\n\n loadTable();\n updateDashboard();\n\n document.getElementById(\"loadingOverlay\").classList.add(\"d-none\");\n document.getElementById(\"membershipTable\").classList.remove(\"d-none\");\n\n tableInstance = new DataTable(\"#membershipTable\", {\n pageLength: 10,\n responsive: true,\n ordering: true,\n searching: true,\n layout: { topStart: null },\n lengthMenu: [[10, 25, 50, -1], [10, 25, 50, \"All\"]]\n });\n\n document.getElementById(\"searchBox\").removeAttribute(\"disabled\");\n document.getElementById(\"pdfBtn\").removeAttribute(\"disabled\");\n document.getElementById(\"excelBtn\").removeAttribute(\"disabled\");\n document.getElementById(\"printBtn\").removeAttribute(\"disabled\");\n })\n .catch(err => {\n console.error(\"Critical Orchestration Exception:\", err);\n document.getElementById(\"loadingOverlay\").innerHTML = `\n <span class=\"text-danger\">\n <i class=\"fas fa-exclamation-triangle\"><\/i> Synchronizer Failure.<br>\n <small class=\"text-muted\">Ensure Google Sheets data columns map explicitly to dashboard components.<\/small>\n <\/span>\n `;\n });\n\n document.getElementById(\"searchBox\").addEventListener(\"keyup\", function() {\n if (tableInstance) tableInstance.search(this.value).draw();\n });\n\n document.getElementById(\"pdfBtn\").addEventListener(\"click\", exportPDF);\n document.getElementById(\"excelBtn\").addEventListener(\"click\", exportExcel);\n document.getElementById(\"printBtn\").addEventListener(\"click\", printReport);\n});\n<\/script>\n<\/body>\n<\/html><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>RMAS Membership Dashboard RMAS Membership Dashboard Rajkiya Mahavidyalaya Academic Society Membership Management System Total Colleges 0 Total Teachers 0 Total Active Members 0 Total Amount Deposited \u20b90 PDF Excel Print Fetching Live Membership Data from Google Sheets… # College Name College AISHE Code Principal Name Total Teachers Existing Annual Members New Annual Members Existing Life […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"no-sidebar","site-content-layout":"page-builder","ast-site-content-layout":"full-width-container","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"disabled","ast-main-header-display":"disabled","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"disabled","ast-hfb-mobile-header-display":"disabled","site-post-title":"","ast-breadcrumbs-content":"disabled","ast-featured-img":"disabled","footer-sml-layout":"disabled","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-6416","page","type-page","status-publish","hentry"],"_hostinger_reach_plugin_has_subscription_block":false,"_hostinger_reach_plugin_is_elementor":false,"_links":{"self":[{"href":"https:\/\/rmasup.edu.in\/index.php\/wp-json\/wp\/v2\/pages\/6416","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rmasup.edu.in\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/rmasup.edu.in\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/rmasup.edu.in\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rmasup.edu.in\/index.php\/wp-json\/wp\/v2\/comments?post=6416"}],"version-history":[{"count":25,"href":"https:\/\/rmasup.edu.in\/index.php\/wp-json\/wp\/v2\/pages\/6416\/revisions"}],"predecessor-version":[{"id":6469,"href":"https:\/\/rmasup.edu.in\/index.php\/wp-json\/wp\/v2\/pages\/6416\/revisions\/6469"}],"wp:attachment":[{"href":"https:\/\/rmasup.edu.in\/index.php\/wp-json\/wp\/v2\/media?parent=6416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}