Tableau de participation<\/title>\n <style>\n\n.button-container {\n display: flex;\n justify-content: center;\n gap: 2%;\n margin: 2%;\n width: 60%;\n max-width: 100%;\n margin-left: auto;\n margin-right: auto;\n}\n\n.button {\n width: 30%;\n padding: 10px;\n border: none;\n color: white;\n cursor: pointer;\n text-align: center;\n}\n\n.green {\n background-color: green;\n}\n\n.blue {\n background-color: blue;\n}\n\n.orange {\n background-color: orange;\n}\n\n@media (max-width: 600px) {\n .button-container {\n width: 90%;\n }\n .button {\n width: 90%;\n margin: 2% 0;\n }\n}\n\n table { width: 100%; border-collapse: collapse; }\n th, td { border: 1px solid black; padding: 8px; text-align: left; }\n.table-header { font-size: 16px; } \/* R\u00e9duire de 10% par rapport \u00e0 16px *\/\n <\/style>\n<\/head>\n<body>\n\n\n\n<div class=\"button-container\">\n <button class=\"button green\" onclick=\"sortTable(0, 'alpha')\">Trier par Nom d’\u00c9cole<\/button>\n <button class=\"button blue\" onclick=\"sortTable(7, 'num')\">Trier par Taux de Participation<\/button>\n <button class=\"button orange\" onclick=\"sortTable(6, 'num')\">Trier par Total Participation<\/button>\n<\/div>\n\n\n<div id=\"tableContainer\"><\/div>\n\n<script>\nfunction fetchData() {\n fetch('https:\/\/ecoliers-cyclistes.avelomalo.fr\/wp-content\/php-scripts-jbj\/lire-participation.php')\n .then(response => response.text())\n .then(data => {\n document.getElementById('tableContainer').innerHTML = data;\n formatPercentage();\n });\n}\n\nfunction formatPercentage() {\n const table = document.querySelector('#tableContainer table');\n const rows = table.rows;\n for (let i = 1; i < rows.length; i++) {\n const cell = rows[i].cells[7];\n cell.innerText = parseInt(cell.innerText) + '%';\n }\n}\n\nfunction sortTable(columnIndex, type) {\n const table = document.querySelector('#tableContainer table');\n const rows = Array.from(table.rows).slice(1);\n rows.sort((a, b) => {\n const cellA = a.cells[columnIndex].innerText;\n const cellB = b.cells[columnIndex].innerText;\n if (type === 'alpha') {\n return cellA.localeCompare(cellB);\n } else if (type === 'num') {\n return parseFloat(cellB) - parseFloat(cellA);\n }\n });\n rows.forEach(row => table.appendChild(row));\n}\n\n document.addEventListener('DOMContentLoaded', fetchData);\n\n<\/script>\n\n<\/body>\n<\/html>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tableau de participation Trier par Nom d’\u00c9cole Trier par Taux de Participation Trier par Total Participation<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-830","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/ecoliers-cyclistes.avelomalo.fr\/index.php\/wp-json\/wp\/v2\/pages\/830","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ecoliers-cyclistes.avelomalo.fr\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/ecoliers-cyclistes.avelomalo.fr\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/ecoliers-cyclistes.avelomalo.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ecoliers-cyclistes.avelomalo.fr\/index.php\/wp-json\/wp\/v2\/comments?post=830"}],"version-history":[{"count":33,"href":"https:\/\/ecoliers-cyclistes.avelomalo.fr\/index.php\/wp-json\/wp\/v2\/pages\/830\/revisions"}],"predecessor-version":[{"id":891,"href":"https:\/\/ecoliers-cyclistes.avelomalo.fr\/index.php\/wp-json\/wp\/v2\/pages\/830\/revisions\/891"}],"wp:attachment":[{"href":"https:\/\/ecoliers-cyclistes.avelomalo.fr\/index.php\/wp-json\/wp\/v2\/media?parent=830"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

{"id":830,"date":"2025-03-20T15:56:21","date_gmt":"2025-03-20T14:56:21","guid":{"rendered":"https:\/\/ecoliers-cyclistes.avelomalo.fr\/?page_id=830"},"modified":"2025-04-01T09:20:43","modified_gmt":"2025-04-01T07:20:43","slug":"test-kpi","status":"publish","type":"page","link":"https:\/\/ecoliers-cyclistes.avelomalo.fr\/index.php\/test-kpi\/","title":{"rendered":"Suivi Participation"},"content":{"rendered":"\n\n\n\n \n Tableau de participation<\/title>\n <style>\n\n.button-container {\n display: flex;\n justify-content: center;\n gap: 2%;\n margin: 2%;\n width: 60%;\n max-width: 100%;\n margin-left: auto;\n margin-right: auto;\n}\n\n.button {\n width: 30%;\n padding: 10px;\n border: none;\n color: white;\n cursor: pointer;\n text-align: center;\n}\n\n.green {\n background-color: green;\n}\n\n.blue {\n background-color: blue;\n}\n\n.orange {\n background-color: orange;\n}\n\n@media (max-width: 600px) {\n .button-container {\n width: 90%;\n }\n .button {\n width: 90%;\n margin: 2% 0;\n }\n}\n\n table { width: 100%; border-collapse: collapse; }\n th, td { border: 1px solid black; padding: 8px; text-align: left; }\n.table-header { font-size: 16px; } \/* R\u00e9duire de 10% par rapport \u00e0 16px *\/\n <\/style>\n<\/head>\n<body>\n\n\n\n<div class=\"button-container\">\n <button class=\"button green\" onclick=\"sortTable(0, 'alpha')\">Trier par Nom d’\u00c9cole<\/button>\n <button class=\"button blue\" onclick=\"sortTable(7, 'num')\">Trier par Taux de Participation<\/button>\n <button class=\"button orange\" onclick=\"sortTable(6, 'num')\">Trier par Total Participation<\/button>\n<\/div>\n\n\n<div id=\"tableContainer\"><\/div>\n\n<script>\nfunction fetchData() {\n fetch('https:\/\/ecoliers-cyclistes.avelomalo.fr\/wp-content\/php-scripts-jbj\/lire-participation.php')\n .then(response => response.text())\n .then(data => {\n document.getElementById('tableContainer').innerHTML = data;\n formatPercentage();\n });\n}\n\nfunction formatPercentage() {\n const table = document.querySelector('#tableContainer table');\n const rows = table.rows;\n for (let i = 1; i < rows.length; i++) {\n const cell = rows[i].cells[7];\n cell.innerText = parseInt(cell.innerText) + '%';\n }\n}\n\nfunction sortTable(columnIndex, type) {\n const table = document.querySelector('#tableContainer table');\n const rows = Array.from(table.rows).slice(1);\n rows.sort((a, b) => {\n const cellA = a.cells[columnIndex].innerText;\n const cellB = b.cells[columnIndex].innerText;\n if (type === 'alpha') {\n return cellA.localeCompare(cellB);\n } else if (type === 'num') {\n return parseFloat(cellB) - parseFloat(cellA);\n }\n });\n rows.forEach(row => table.appendChild(row));\n}\n\n document.addEventListener('DOMContentLoaded', fetchData);\n\n<\/script>\n\n<\/body>\n<\/html>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tableau de participation Trier par Nom d’\u00c9cole Trier par Taux de Participation Trier par Total Participation<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-830","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/ecoliers-cyclistes.avelomalo.fr\/index.php\/wp-json\/wp\/v2\/pages\/830","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ecoliers-cyclistes.avelomalo.fr\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/ecoliers-cyclistes.avelomalo.fr\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/ecoliers-cyclistes.avelomalo.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ecoliers-cyclistes.avelomalo.fr\/index.php\/wp-json\/wp\/v2\/comments?post=830"}],"version-history":[{"count":33,"href":"https:\/\/ecoliers-cyclistes.avelomalo.fr\/index.php\/wp-json\/wp\/v2\/pages\/830\/revisions"}],"predecessor-version":[{"id":891,"href":"https:\/\/ecoliers-cyclistes.avelomalo.fr\/index.php\/wp-json\/wp\/v2\/pages\/830\/revisions\/891"}],"wp:attachment":[{"href":"https:\/\/ecoliers-cyclistes.avelomalo.fr\/index.php\/wp-json\/wp\/v2\/media?parent=830"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}