{"id":77,"date":"2026-03-01T11:50:43","date_gmt":"2026-03-01T03:50:43","guid":{"rendered":"https:\/\/desatest.yzz.me\/wp\/?p=77"},"modified":"2026-03-09T09:15:39","modified_gmt":"2026-03-09T01:15:39","slug":"77","status":"publish","type":"post","link":"https:\/\/desamenamangkiri.id\/m\/?p=77","title":{"rendered":"Tabel report"},"content":{"rendered":"\n<div style=\"width:100%; overflow:auto;\">\n  <iframe \n    id=\"sheetFrame\"\n    src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vRY_1gzQKSP_7b0rwe4Ww_2v44LUQq38P92tt9ezReFG3QbqCTtVRPjjWy2-Wbio2x4oWjp7dTD26nj\/pubhtml?gid=0&#038;single=true&#038;widget=true&#038;headers=false\"\n    style=\"\n      width:200%;\n      height:1200px;\n      border:none;\n      transform:scale(0.5);\n      transform-origin: top left;\n    \">\n  <\/iframe>\n<\/div>\n\n<script>\n  setInterval(function(){\n    var iframe = document.getElementById('sheetFrame');\n    iframe.src = iframe.src;\n  }, 30000); \/\/ 30000 = 30 detik\n<\/script>\n\n\n    <form id=\"ksm-google-form\" enctype=\"multipart\/form-data\">\n\n        <input type=\"text\" name=\"nama\" placeholder=\"Nama\" required><br><br>\n\n        <input type=\"email\" name=\"email\" placeholder=\"Email\" required><br><br>\n\n        <input type=\"text\" name=\"nohp\" placeholder=\"No HP\" required><br><br>\n\n        <input type=\"text\" name=\"jabatan\" placeholder=\"Jabatan\" required><br><br>\n\n        <select name=\"kategori\" required>\n            <option value=\"\">Pilih Kategori<\/option>\n            <option value=\"Pengaduan\">Pengaduan<\/option>\n            <option value=\"Permohonan\">Permohonan<\/option>\n            <option value=\"Informasi\">Informasi<\/option>\n        <\/select><br><br>\n\n        <textarea name=\"pesan\" placeholder=\"Pesan\"><\/textarea><br><br>\n\n        <input type=\"file\" name=\"dokumen\"><br><br>\n\n        <input type=\"hidden\" name=\"action\" value=\"ksm_submit_form\">\n\n        <button type=\"submit\">Kirim<\/button>\n\n    <\/form>\n\n    <div id=\"ksm-response\"><\/div>\n\n    \n    <div class=\"ksm-sheet-container\">\n        <input type=\"text\" id=\"ksmSearch\" placeholder=\"Cari data...\" \/>\n        <div id=\"ksmSheetData\">Loading data...<\/div>\n    <\/div>\n\n    <script>\n    document.addEventListener(\"DOMContentLoaded\", function(){\n        fetch(\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vRY_1gzQKSP_7b0rwe4Ww_2v44LUQq38P92tt9ezReFG3QbqCTtVRPjjWy2-Wbio2x4oWjp7dTD26nj\/pub?output=csv\")\n        .then(response => response.text())\n        .then(data => {\n            let rows = data.trim().split(\"\\n\").map(row => row.split(\",\"));\n            let table = \"<table><thead><tr>\";\n            \n            rows[0].forEach(col => {\n                table += \"<th>\" + col + \"<\/th>\";\n            });\n            \n            table += \"<\/tr><\/thead><tbody>\";\n\n            for(let i=1; i<rows.length; i++){\n                table += \"<tr>\";\n                rows[i].forEach(col => {\n                    table += \"<td>\" + col + \"<\/td>\";\n                });\n                table += \"<\/tr>\";\n            }\n\n            table += \"<\/tbody><\/table>\";\n            document.getElementById(\"ksmSheetData\").innerHTML = table;\n        });\n\n        document.getElementById(\"ksmSearch\").addEventListener(\"keyup\", function(){\n            let filter = this.value.toLowerCase();\n            let rows = document.querySelectorAll(\"#ksmSheetData tbody tr\");\n\n            rows.forEach(row => {\n                let text = row.textContent.toLowerCase();\n                row.style.display = text.includes(filter) ? \"\" : \"none\";\n            });\n        });\n    });\n    <\/script>\n    \n\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":135,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-77","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-anggaran-desa"],"_links":{"self":[{"href":"https:\/\/desamenamangkiri.id\/m\/index.php?rest_route=\/wp\/v2\/posts\/77","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/desamenamangkiri.id\/m\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/desamenamangkiri.id\/m\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/desamenamangkiri.id\/m\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/desamenamangkiri.id\/m\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=77"}],"version-history":[{"count":1,"href":"https:\/\/desamenamangkiri.id\/m\/index.php?rest_route=\/wp\/v2\/posts\/77\/revisions"}],"predecessor-version":[{"id":133,"href":"https:\/\/desamenamangkiri.id\/m\/index.php?rest_route=\/wp\/v2\/posts\/77\/revisions\/133"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/desamenamangkiri.id\/m\/index.php?rest_route=\/wp\/v2\/media\/135"}],"wp:attachment":[{"href":"https:\/\/desamenamangkiri.id\/m\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=77"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/desamenamangkiri.id\/m\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=77"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/desamenamangkiri.id\/m\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=77"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}