Live Research Paper Submissions Portal<\/title>\r\n \r\n \r\n <link rel=\"stylesheet\" href=\"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.3.3\/dist\/css\/bootstrap.min.css\">\r\n \r\n <link rel=\"stylesheet\" href=\"https:\/\/cdn.datatables.net\/1.13.8\/css\/dataTables.bootstrap5.min.css\">\r\n <link rel=\"stylesheet\" href=\"https:\/\/cdn.datatables.net\/buttons\/2.4.2\/css\/buttons.bootstrap5.min.css\">\r\n <link rel=\"stylesheet\" href=\"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap-icons@1.11.3\/font\/bootstrap-icons.min.css\">\r\n\r\n <style>\r\n body {\r\n background-color: #f8fafc;\r\n font-family: -apple-system, BlinkMacSystemFont, \"Segoe UI\", Roboto, Helvetica, Arial, sans-serif;\r\n color: #0f172a;\r\n padding: 1.5rem 0.5rem;\r\n }\r\n .portal-card {\r\n border: 1px solid #e2e8f0;\r\n border-radius: 12px;\r\n box-shadow: 0 4px 6px -1px rgba(0, 0, 0, 0.06), 0 2px 4px -2px rgba(0, 0, 0, 0.04);\r\n background: #ffffff;\r\n overflow: hidden;\r\n }\r\n .header-banner {\r\n background: linear-gradient(135deg, #1e3a8a, #2563eb);\r\n color: #ffffff;\r\n padding: 1.25rem 1.5rem;\r\n }\r\n table.dataTable {\r\n font-size: 0.88rem;\r\n border-collapse: collapse !important;\r\n }\r\n table.dataTable thead th {\r\n background-color: #f1f5f9;\r\n color: #334155;\r\n font-weight: 600;\r\n text-transform: uppercase;\r\n font-size: 0.78rem;\r\n letter-spacing: 0.04em;\r\n border-bottom: 2px solid #cbd5e1 !important;\r\n vertical-align: middle;\r\n }\r\n .salutation-badge {\r\n background-color: #eff6ff;\r\n color: #1d4ed8;\r\n border: 1px solid #bfdbfe;\r\n font-weight: 600;\r\n font-size: 0.78rem;\r\n padding: 0.2rem 0.45rem;\r\n border-radius: 4px;\r\n display: inline-block;\r\n }\r\n .btn-drive {\r\n display: inline-flex;\r\n align-items: center;\r\n gap: 0.25rem;\r\n font-size: 0.78rem;\r\n padding: 0.25rem 0.55rem;\r\n border-radius: 5px;\r\n white-space: nowrap;\r\n }\r\n .table-hover tbody tr:hover {\r\n background-color: #f8fafc !important;\r\n }\r\n #loadingSpinner {\r\n padding: 3rem;\r\n text-align: center;\r\n color: #475569;\r\n }\r\n <\/style>\r\n<\/head>\r\n<body>\r\n\r\n<div class=\"container-fluid px-2 px-md-4\">\r\n <div class=\"portal-card\">\r\n <div class=\"header-banner d-flex justify-content-between align-items-center flex-wrap gap-2\">\r\n <div>\r\n <h4 class=\"mb-1 fw-bold\"><i class=\"bi bi-journal-bookmark-fill me-2\"><\/i>Research Paper Submissions Master Portal<\/h4>\r\n <small class=\"text-white-50\">Live Sync with Published Google Sheet<\/small>\r\n <\/div>\r\n <div class=\"d-flex align-items-center gap-2\">\r\n <button id=\"btnRefresh\" class=\"btn btn-sm btn-outline-light\"><i class=\"bi bi-arrow-clockwise me-1\"><\/i> Refresh<\/button>\r\n <span class=\"badge bg-light text-dark px-3 py-2 fw-semibold fs-7 shadow-sm\" id=\"totalCountBadge\">Loading...<\/span>\r\n <\/div>\r\n <\/div>\r\n\r\n <div class=\"card-body p-3 p-md-4\">\r\n \r\n <div id=\"loadingSpinner\">\r\n <div class=\"spinner-border text-primary mb-2\" role=\"status\"><\/div>\r\n <div>Fetching live submissions data from Google Sheets...<\/div>\r\n <\/div>\r\n\r\n \r\n <div class=\"table-responsive d-none\" id=\"tableContainer\">\r\n <table id=\"papersTable\" class=\"table table-striped table-hover align-middle w-100\">\r\n <thead>\r\n <tr>\r\n <th class=\"text-center\" style=\"width: 45px;\">#<\/th>\r\n <th style=\"width: 75px;\">Prefix<\/th>\r\n <th style=\"width: 170px;\">Full Name<\/th>\r\n <th style=\"width: 120px;\">WhatsApp No.<\/th>\r\n <th>Title of Paper<\/th>\r\n <th style=\"width: 200px;\">Email Address<\/th>\r\n <th class=\"text-center\" style=\"width: 85px;\">Paper<\/th>\r\n <\/tr>\r\n <\/thead>\r\n <tbody id=\"tableBody\"><\/tbody>\r\n <\/table>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n<\/div>\r\n\r\n\r\n<script src=\"https:\/\/code.jquery.com\/jquery-3.7.1.min.js\"><\/script>\r\n<script src=\"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.3.3\/dist\/js\/bootstrap.bundle.min.js\"><\/script>\r\n<script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/PapaParse\/5.4.1\/papaparse.min.js\"><\/script>\r\n<script src=\"https:\/\/cdn.datatables.net\/1.13.8\/js\/jquery.dataTables.min.js\"><\/script>\r\n<script src=\"https:\/\/cdn.datatables.net\/1.13.8\/js\/dataTables.bootstrap5.min.js\"><\/script>\r\n<script src=\"https:\/\/cdn.datatables.net\/buttons\/2.4.2\/js\/dataTables.buttons.min.js\"><\/script>\r\n<script src=\"https:\/\/cdn.datatables.net\/buttons\/2.4.2\/js\/buttons.bootstrap5.min.js\"><\/script>\r\n<script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/jszip\/3.10.1\/jszip.min.js\"><\/script>\r\n<script src=\"https:\/\/cdn.datatables.net\/buttons\/2.4.2\/js\/buttons.html5.min.js\"><\/script>\r\n<script src=\"https:\/\/cdn.datatables.net\/buttons\/2.4.2\/js\/buttons.print.min.js\"><\/script>\r\n\r\n<script>\r\n const CSV_URL = \"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vThoK1r8b0cA8iAVHAg21mM6wETENhDXcpoi6QJ7J0A3Md4Nz8mAAlv-MGwUHFYFT8On3PJt-r0iu_e\/pub?gid=1110327100&single=true&output=csv\";\r\n let dataTableInstance = null;\r\n\r\n function escapeHtml(text) {\r\n if (!text) return \"\";\r\n return text\r\n .toString()\r\n .replace(\/&\/g, \"&\")\r\n .replace(\/<\/g, \"<\")\r\n .replace(\/>\/g, \">\")\r\n .replace(\/\"\/g, \""\")\r\n .replace(\/'\/g, \"'\");\r\n }\r\n\r\n function loadData() {\r\n $('#loadingSpinner').removeClass('d-none');\r\n $('#tableContainer').addClass('d-none');\r\n\r\n Papa.parse(CSV_URL, {\r\n download: true,\r\n header: true,\r\n skipEmptyLines: true,\r\n complete: function(results) {\r\n const rows = results.data;\r\n let htmlRows = \"\";\r\n let validIndex = 0;\r\n\r\n rows.forEach(function(row) {\r\n \/\/ Normalize column headers dynamically\r\n const email = row['Email address'] || row['Email'] || row['Email Address'] || '';\r\n const salutation = row['Salutation'] || row['Prefix'] || '';\r\n const name = row['Full Name'] || row['Name'] || '';\r\n const phone = row['Whatsapp number'] || row['WhatsApp No.'] || row['Phone'] || '';\r\n const title = row['Title of Paper'] || row['Paper Title'] || row['Title'] || '';\r\n const driveLink = row['Upload Research Paper'] || row['Paper Link'] || row['Document'] || '';\r\n\r\n if (!name && !email && !title) return;\r\n\r\n validIndex++;\r\n const badgeHtml = salutation ? `<span class=\"salutation-badge\">${escapeHtml(salutation)}<\/span>` : '';\r\n const linkHtml = driveLink ? `<a href=\"${escapeHtml(driveLink)}\" target=\"_blank\" rel=\"noopener noreferrer\" class=\"btn btn-outline-primary btn-drive\"><i class=\"bi bi-box-arrow-up-right\"><\/i> View<\/a>` : '<span class=\"text-muted\">-<\/span>';\r\n\r\n htmlRows += `\r\n <tr>\r\n <td class=\"text-center\">${validIndex}<\/td>\r\n <td>${badgeHtml}<\/td>\r\n <td class=\"fw-semibold\">${escapeHtml(name)}<\/td>\r\n <td>${escapeHtml(phone)}<\/td>\r\n <td>${escapeHtml(title)}<\/td>\r\n <td><small>${escapeHtml(email)}<\/small><\/td>\r\n <td class=\"text-center\">${linkHtml}<\/td>\r\n <\/tr>\r\n `;\r\n });\r\n\r\n if (dataTableInstance) {\r\n dataTableInstance.destroy();\r\n }\r\n\r\n $('#tableBody').html(htmlRows);\r\n $('#totalCountBadge').text(`Total: ${validIndex}`);\r\n $('#loadingSpinner').addClass('d-none');\r\n $('#tableContainer').removeClass('d-none');\r\n\r\n dataTableInstance = $('#papersTable').DataTable({\r\n pageLength: 25,\r\n lengthMenu: [[10, 25, 50, 100, -1], [10, 25, 50, 100, \"All\"]],\r\n dom: '<\"d-flex flex-wrap justify-content-between align-items-center mb-3 gap-2\"Bf>rt<\"d-flex flex-wrap justify-content-between align-items-center mt-3 gap-2\"lip>',\r\n buttons: [\r\n {\r\n extend: 'excelHtml5',\r\n text: '<i class=\"bi bi-file-earmark-excel-fill text-success me-1\"><\/i> Excel',\r\n className: 'btn btn-light border btn-sm shadow-sm',\r\n exportOptions: { columns: [0, 1, 2, 3, 4, 5] }\r\n },\r\n {\r\n extend: 'csvHtml5',\r\n text: '<i class=\"bi bi-file-earmark-spreadsheet-fill text-primary me-1\"><\/i> CSV',\r\n className: 'btn btn-light border btn-sm shadow-sm',\r\n exportOptions: { columns: [0, 1, 2, 3, 4, 5] }\r\n },\r\n {\r\n extend: 'print',\r\n text: '<i class=\"bi bi-printer-fill me-1\"><\/i> Print',\r\n className: 'btn btn-light border btn-sm shadow-sm',\r\n exportOptions: { columns: [0, 1, 2, 3, 4, 5] }\r\n }\r\n ],\r\n language: {\r\n search: \"\",\r\n searchPlaceholder: \"Search author, title, phone...\",\r\n lengthMenu: \"Show _MENU_ entries\",\r\n info: \"Showing _START_ to _END_ of _TOTAL_ entries\"\r\n }\r\n });\r\n },\r\n error: function(err) {\r\n $('#loadingSpinner').html(`\r\n <div class=\"alert alert-danger\" role=\"alert\">\r\n <i class=\"bi bi-exclamation-triangle-fill me-2\"><\/i>\r\n Failed to fetch published CSV: ${escapeHtml(err.message || 'Check connection or published permissions.')}\r\n <\/div>\r\n `);\r\n }\r\n });\r\n }\r\n\r\n $(document).ready(function() {\r\n loadData();\r\n $('#btnRefresh').on('click', function() {\r\n loadData();\r\n });\r\n });\r\n<\/script>\r\n<\/body>\r\n<\/html>\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>Live Research Paper Submissions Portal Research Paper Submissions Master Portal Live Sync with Published Google Sheet Refresh Loading… Fetching live submissions data from Google Sheets… # Prefix Full Name WhatsApp No. Title of Paper Email Address Paper<\/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":"disabled","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-6471","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\/6471","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=6471"}],"version-history":[{"count":5,"href":"https:\/\/rmasup.edu.in\/index.php\/wp-json\/wp\/v2\/pages\/6471\/revisions"}],"predecessor-version":[{"id":6476,"href":"https:\/\/rmasup.edu.in\/index.php\/wp-json\/wp\/v2\/pages\/6471\/revisions\/6476"}],"wp:attachment":[{"href":"https:\/\/rmasup.edu.in\/index.php\/wp-json\/wp\/v2\/media?parent=6471"}],"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\r\n\r\n\r\n \r\n \r\n Live Research Paper Submissions Portal<\/title>\r\n \r\n \r\n <link rel=\"stylesheet\" href=\"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.3.3\/dist\/css\/bootstrap.min.css\">\r\n \r\n <link rel=\"stylesheet\" href=\"https:\/\/cdn.datatables.net\/1.13.8\/css\/dataTables.bootstrap5.min.css\">\r\n <link rel=\"stylesheet\" href=\"https:\/\/cdn.datatables.net\/buttons\/2.4.2\/css\/buttons.bootstrap5.min.css\">\r\n <link rel=\"stylesheet\" href=\"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap-icons@1.11.3\/font\/bootstrap-icons.min.css\">\r\n\r\n <style>\r\n body {\r\n background-color: #f8fafc;\r\n font-family: -apple-system, BlinkMacSystemFont, \"Segoe UI\", Roboto, Helvetica, Arial, sans-serif;\r\n color: #0f172a;\r\n padding: 1.5rem 0.5rem;\r\n }\r\n .portal-card {\r\n border: 1px solid #e2e8f0;\r\n border-radius: 12px;\r\n box-shadow: 0 4px 6px -1px rgba(0, 0, 0, 0.06), 0 2px 4px -2px rgba(0, 0, 0, 0.04);\r\n background: #ffffff;\r\n overflow: hidden;\r\n }\r\n .header-banner {\r\n background: linear-gradient(135deg, #1e3a8a, #2563eb);\r\n color: #ffffff;\r\n padding: 1.25rem 1.5rem;\r\n }\r\n table.dataTable {\r\n font-size: 0.88rem;\r\n border-collapse: collapse !important;\r\n }\r\n table.dataTable thead th {\r\n background-color: #f1f5f9;\r\n color: #334155;\r\n font-weight: 600;\r\n text-transform: uppercase;\r\n font-size: 0.78rem;\r\n letter-spacing: 0.04em;\r\n border-bottom: 2px solid #cbd5e1 !important;\r\n vertical-align: middle;\r\n }\r\n .salutation-badge {\r\n background-color: #eff6ff;\r\n color: #1d4ed8;\r\n border: 1px solid #bfdbfe;\r\n font-weight: 600;\r\n font-size: 0.78rem;\r\n padding: 0.2rem 0.45rem;\r\n border-radius: 4px;\r\n display: inline-block;\r\n }\r\n .btn-drive {\r\n display: inline-flex;\r\n align-items: center;\r\n gap: 0.25rem;\r\n font-size: 0.78rem;\r\n padding: 0.25rem 0.55rem;\r\n border-radius: 5px;\r\n white-space: nowrap;\r\n }\r\n .table-hover tbody tr:hover {\r\n background-color: #f8fafc !important;\r\n }\r\n #loadingSpinner {\r\n padding: 3rem;\r\n text-align: center;\r\n color: #475569;\r\n }\r\n <\/style>\r\n<\/head>\r\n<body>\r\n\r\n<div class=\"container-fluid px-2 px-md-4\">\r\n <div class=\"portal-card\">\r\n <div class=\"header-banner d-flex justify-content-between align-items-center flex-wrap gap-2\">\r\n <div>\r\n <h4 class=\"mb-1 fw-bold\"><i class=\"bi bi-journal-bookmark-fill me-2\"><\/i>Research Paper Submissions Master Portal<\/h4>\r\n <small class=\"text-white-50\">Live Sync with Published Google Sheet<\/small>\r\n <\/div>\r\n <div class=\"d-flex align-items-center gap-2\">\r\n <button id=\"btnRefresh\" class=\"btn btn-sm btn-outline-light\"><i class=\"bi bi-arrow-clockwise me-1\"><\/i> Refresh<\/button>\r\n <span class=\"badge bg-light text-dark px-3 py-2 fw-semibold fs-7 shadow-sm\" id=\"totalCountBadge\">Loading...<\/span>\r\n <\/div>\r\n <\/div>\r\n\r\n <div class=\"card-body p-3 p-md-4\">\r\n \r\n <div id=\"loadingSpinner\">\r\n <div class=\"spinner-border text-primary mb-2\" role=\"status\"><\/div>\r\n <div>Fetching live submissions data from Google Sheets...<\/div>\r\n <\/div>\r\n\r\n \r\n <div class=\"table-responsive d-none\" id=\"tableContainer\">\r\n <table id=\"papersTable\" class=\"table table-striped table-hover align-middle w-100\">\r\n <thead>\r\n <tr>\r\n <th class=\"text-center\" style=\"width: 45px;\">#<\/th>\r\n <th style=\"width: 75px;\">Prefix<\/th>\r\n <th style=\"width: 170px;\">Full Name<\/th>\r\n <th style=\"width: 120px;\">WhatsApp No.<\/th>\r\n <th>Title of Paper<\/th>\r\n <th style=\"width: 200px;\">Email Address<\/th>\r\n <th class=\"text-center\" style=\"width: 85px;\">Paper<\/th>\r\n <\/tr>\r\n <\/thead>\r\n <tbody id=\"tableBody\"><\/tbody>\r\n <\/table>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n<\/div>\r\n\r\n\r\n<script src=\"https:\/\/code.jquery.com\/jquery-3.7.1.min.js\"><\/script>\r\n<script src=\"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.3.3\/dist\/js\/bootstrap.bundle.min.js\"><\/script>\r\n<script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/PapaParse\/5.4.1\/papaparse.min.js\"><\/script>\r\n<script src=\"https:\/\/cdn.datatables.net\/1.13.8\/js\/jquery.dataTables.min.js\"><\/script>\r\n<script src=\"https:\/\/cdn.datatables.net\/1.13.8\/js\/dataTables.bootstrap5.min.js\"><\/script>\r\n<script src=\"https:\/\/cdn.datatables.net\/buttons\/2.4.2\/js\/dataTables.buttons.min.js\"><\/script>\r\n<script src=\"https:\/\/cdn.datatables.net\/buttons\/2.4.2\/js\/buttons.bootstrap5.min.js\"><\/script>\r\n<script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/jszip\/3.10.1\/jszip.min.js\"><\/script>\r\n<script src=\"https:\/\/cdn.datatables.net\/buttons\/2.4.2\/js\/buttons.html5.min.js\"><\/script>\r\n<script src=\"https:\/\/cdn.datatables.net\/buttons\/2.4.2\/js\/buttons.print.min.js\"><\/script>\r\n\r\n<script>\r\n const CSV_URL = \"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vThoK1r8b0cA8iAVHAg21mM6wETENhDXcpoi6QJ7J0A3Md4Nz8mAAlv-MGwUHFYFT8On3PJt-r0iu_e\/pub?gid=1110327100&single=true&output=csv\";\r\n let dataTableInstance = null;\r\n\r\n function escapeHtml(text) {\r\n if (!text) return \"\";\r\n return text\r\n .toString()\r\n .replace(\/&\/g, \"&\")\r\n .replace(\/<\/g, \"<\")\r\n .replace(\/>\/g, \">\")\r\n .replace(\/\"\/g, \""\")\r\n .replace(\/'\/g, \"'\");\r\n }\r\n\r\n function loadData() {\r\n $('#loadingSpinner').removeClass('d-none');\r\n $('#tableContainer').addClass('d-none');\r\n\r\n Papa.parse(CSV_URL, {\r\n download: true,\r\n header: true,\r\n skipEmptyLines: true,\r\n complete: function(results) {\r\n const rows = results.data;\r\n let htmlRows = \"\";\r\n let validIndex = 0;\r\n\r\n rows.forEach(function(row) {\r\n \/\/ Normalize column headers dynamically\r\n const email = row['Email address'] || row['Email'] || row['Email Address'] || '';\r\n const salutation = row['Salutation'] || row['Prefix'] || '';\r\n const name = row['Full Name'] || row['Name'] || '';\r\n const phone = row['Whatsapp number'] || row['WhatsApp No.'] || row['Phone'] || '';\r\n const title = row['Title of Paper'] || row['Paper Title'] || row['Title'] || '';\r\n const driveLink = row['Upload Research Paper'] || row['Paper Link'] || row['Document'] || '';\r\n\r\n if (!name && !email && !title) return;\r\n\r\n validIndex++;\r\n const badgeHtml = salutation ? `<span class=\"salutation-badge\">${escapeHtml(salutation)}<\/span>` : '';\r\n const linkHtml = driveLink ? `<a href=\"${escapeHtml(driveLink)}\" target=\"_blank\" rel=\"noopener noreferrer\" class=\"btn btn-outline-primary btn-drive\"><i class=\"bi bi-box-arrow-up-right\"><\/i> View<\/a>` : '<span class=\"text-muted\">-<\/span>';\r\n\r\n htmlRows += `\r\n <tr>\r\n <td class=\"text-center\">${validIndex}<\/td>\r\n <td>${badgeHtml}<\/td>\r\n <td class=\"fw-semibold\">${escapeHtml(name)}<\/td>\r\n <td>${escapeHtml(phone)}<\/td>\r\n <td>${escapeHtml(title)}<\/td>\r\n <td><small>${escapeHtml(email)}<\/small><\/td>\r\n <td class=\"text-center\">${linkHtml}<\/td>\r\n <\/tr>\r\n `;\r\n });\r\n\r\n if (dataTableInstance) {\r\n dataTableInstance.destroy();\r\n }\r\n\r\n $('#tableBody').html(htmlRows);\r\n $('#totalCountBadge').text(`Total: ${validIndex}`);\r\n $('#loadingSpinner').addClass('d-none');\r\n $('#tableContainer').removeClass('d-none');\r\n\r\n dataTableInstance = $('#papersTable').DataTable({\r\n pageLength: 25,\r\n lengthMenu: [[10, 25, 50, 100, -1], [10, 25, 50, 100, \"All\"]],\r\n dom: '<\"d-flex flex-wrap justify-content-between align-items-center mb-3 gap-2\"Bf>rt<\"d-flex flex-wrap justify-content-between align-items-center mt-3 gap-2\"lip>',\r\n buttons: [\r\n {\r\n extend: 'excelHtml5',\r\n text: '<i class=\"bi bi-file-earmark-excel-fill text-success me-1\"><\/i> Excel',\r\n className: 'btn btn-light border btn-sm shadow-sm',\r\n exportOptions: { columns: [0, 1, 2, 3, 4, 5] }\r\n },\r\n {\r\n extend: 'csvHtml5',\r\n text: '<i class=\"bi bi-file-earmark-spreadsheet-fill text-primary me-1\"><\/i> CSV',\r\n className: 'btn btn-light border btn-sm shadow-sm',\r\n exportOptions: { columns: [0, 1, 2, 3, 4, 5] }\r\n },\r\n {\r\n extend: 'print',\r\n text: '<i class=\"bi bi-printer-fill me-1\"><\/i> Print',\r\n className: 'btn btn-light border btn-sm shadow-sm',\r\n exportOptions: { columns: [0, 1, 2, 3, 4, 5] }\r\n }\r\n ],\r\n language: {\r\n search: \"\",\r\n searchPlaceholder: \"Search author, title, phone...\",\r\n lengthMenu: \"Show _MENU_ entries\",\r\n info: \"Showing _START_ to _END_ of _TOTAL_ entries\"\r\n }\r\n });\r\n },\r\n error: function(err) {\r\n $('#loadingSpinner').html(`\r\n <div class=\"alert alert-danger\" role=\"alert\">\r\n <i class=\"bi bi-exclamation-triangle-fill me-2\"><\/i>\r\n Failed to fetch published CSV: ${escapeHtml(err.message || 'Check connection or published permissions.')}\r\n <\/div>\r\n `);\r\n }\r\n });\r\n }\r\n\r\n $(document).ready(function() {\r\n loadData();\r\n $('#btnRefresh').on('click', function() {\r\n loadData();\r\n });\r\n });\r\n<\/script>\r\n<\/body>\r\n<\/html>\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>Live Research Paper Submissions Portal Research Paper Submissions Master Portal Live Sync with Published Google Sheet Refresh Loading… Fetching live submissions data from Google Sheets… # Prefix Full Name WhatsApp No. Title of Paper Email Address Paper<\/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":"disabled","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-6471","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\/6471","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=6471"}],"version-history":[{"count":5,"href":"https:\/\/rmasup.edu.in\/index.php\/wp-json\/wp\/v2\/pages\/6471\/revisions"}],"predecessor-version":[{"id":6476,"href":"https:\/\/rmasup.edu.in\/index.php\/wp-json\/wp\/v2\/pages\/6471\/revisions\/6476"}],"wp:attachment":[{"href":"https:\/\/rmasup.edu.in\/index.php\/wp-json\/wp\/v2\/media?parent=6471"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}