{"id":2938,"date":"2024-10-04T09:55:42","date_gmt":"2024-10-04T14:55:42","guid":{"rendered":"https:\/\/uni-lem.com\/?page_id=2938"},"modified":"2025-02-03T00:06:47","modified_gmt":"2025-02-03T05:06:47","slug":"expedientes-emitidos","status":"publish","type":"page","link":"https:\/\/uni-lem.com\/?page_id=2938","title":{"rendered":"Expedientes Emitidos"},"content":{"rendered":"    <div id=\"expedientes-plugin-container\" style=\"width: 100%; max-width: 100%; text-align: center;\"> <!-- Contenedor que ocupa todo el ancho -->\r\n        <div class=\"columns form-container\" data-index=\"1\" style=\"width: 100%; display: flex; flex-direction: column; align-items: center;\">\r\n            <div class=\"column is-full\" style=\"width: 100%; padding: 0;\">\r\n                <div class=\"field is-grouped is-centered\" style=\"width: 100%; display: flex; justify-content: center; align-items: center;\">\r\n                    <div class=\"control\" style=\"display: flex; align-items: center;\">\r\n                        <button class=\"button is-black\" id=\"searchButton\" style=\"width: 100px; height: 40px;\"><b>BUSCAR<\/b><\/button>\r\n                    <\/div>\r\n                    <div class=\"control\" style=\"display: flex; align-items: center; margin-left: 10px;\">\r\n                        <input class=\"input is-link\" type=\"text\" id=\"searchInput\" placeholder=\"Expediente\" style=\"width: 90px; height: 34px; text-align: center;\"\/>\r\n                    <\/div>\r\n                <\/div>\r\n                <div class=\"control\" style=\"margin-top: 10px; width: 100%; text-align: center;\">\r\n                    <b>Expedientes emitidos listos para ser entregados a clientes que pagaron la totalidad del servicio.<\/b>\r\n                <\/div>\r\n            <\/div>\r\n        <\/div>\r\n\r\n        <!-- Aqu\u00ed la tabla debe aparecer debajo del texto -->\r\n        <div id=\"google-sheets-data\" style=\"margin-top: 20px;\">Cargando datos...<\/div>\r\n    <\/div>\r\n\r\n    <script>\r\n      let allData = []; \/\/ Para almacenar todos los datos\r\n\r\n      function fetchGoogleSheetsData() {\r\n        fetch('https:\/\/script.google.com\/macros\/s\/AKfycbzII6QjZSf1WkHaBfVB4ybEGCzL0S57-U6Coj0X8X8VaBoKYV2XbWzhoXAdc_8oQvEz2w\/exec')\r\n          .then(response => response.json())\r\n          .then(data => {\r\n            allData = data; \/\/ Guardar todos los datos\r\n            renderTable(allData);\r\n          })\r\n          .catch(error => console.error('Error al obtener datos de Google Sheets:', error));\r\n      }\r\n\r\n      function renderTable(data) {\r\n        let htmlContent = '<table>';\r\n        htmlContent += '<thead><tr>';\r\n        data[0].forEach(cell => {\r\n          htmlContent += `<th>${cell}<\/th>`;\r\n        });\r\n        htmlContent += '<\/tr><\/thead><tbody>';\r\n\r\n        const maxRows = 200;\r\n        const rowsToDisplay = data.slice(1, maxRows + 1);\r\n\r\n        rowsToDisplay.forEach(row => {\r\n          htmlContent += '<tr>';\r\n          row.forEach((cell, index) => {\r\n            if (index === 2 || index === 3) { \/\/ Formatear la fecha en la tercera y cuarta columna\r\n              let date = new Date(cell);\r\n              if (!isNaN(date)) {\r\n                let formattedDate = ('0' + date.getDate()).slice(-2) + '\/' + \r\n                                    ('0' + (date.getMonth() + 1)).slice(-2) + '\/' + \r\n                                    date.getFullYear();\r\n                htmlContent += `<td>${formattedDate}<\/td>`;\r\n              } else {\r\n                htmlContent += `<td>${cell}<\/td>`;\r\n              }\r\n            } else if (index === 5) { \/\/ Formatear n\u00famero a 2 decimales\r\n              let num = parseFloat(cell);\r\n              if (!isNaN(num)) {\r\n                htmlContent += `<td>${num.toFixed(2)}<\/td>`;\r\n              } else {\r\n                htmlContent += `<td>${cell}<\/td>`;\r\n              }\r\n            } else {\r\n              htmlContent += `<td>${cell}<\/td>`;\r\n            }\r\n          });\r\n          htmlContent += '<\/tr>';\r\n        });\r\n\r\n        htmlContent += '<\/tbody><\/table>';\r\n        document.getElementById('google-sheets-data').innerHTML = htmlContent;\r\n      }\r\n\r\n      function searchRow() {\r\n        const searchValue = document.getElementById('searchInput').value.toLowerCase();\r\n        const filteredData = allData.filter(row => row[0].toString().toLowerCase() === searchValue);\r\n        \r\n        \/\/ Incluir cabeceras en los resultados\r\n        const resultData = filteredData.length ? [allData[0], ...filteredData] : [['No se encontr\u00f3 el expediente que ingres\u00f3, puede que a\u00fan no culmin\u00f3 sus ensayos o que escribi\u00f3 mal el n\u00famero de expediente']];\r\n        \r\n        renderTable(resultData);\r\n      }\r\n\r\n      document.getElementById('searchButton').addEventListener('click', searchRow);\r\n\r\n      \/\/ Escuchar el evento de tecla \"Enter\"\r\n      document.getElementById('searchInput').addEventListener('keypress', function(event) {\r\n        if (event.key === 'Enter') {\r\n          searchRow();\r\n        }\r\n      });\r\n\r\n      \/\/ Escuchar el evento de tecla \"Escape\"\r\n      document.addEventListener('keydown', function(event) {\r\n        if (event.key === 'Escape') {\r\n          document.getElementById('searchInput').value = ''; \/\/ Limpiar el campo de b\u00fasqueda\r\n          renderTable(allData); \/\/ Mostrar todos los datos\r\n        }\r\n      });\r\n\r\n      window.onload = fetchGoogleSheetsData;\r\n      setInterval(fetchGoogleSheetsData, 30000);\r\n    <\/script>\r\n    \n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"template-full.php","meta":{"_joinchat":[],"footnotes":""},"class_list":["post-2938","page","type-page","status-publish","hentry"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/uni-lem.com\/?page_id=2938\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"es_ES\" \/>\n\t\t<meta property=\"og:site_name\" content=\"UNI-LEM - LABORATORIO N\u00b01 DE ENSAYOS DE MATERIALES\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Expedientes Emitidos - UNI-LEM\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/uni-lem.com\/?page_id=2938\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/uni-lem.com\/wp-content\/uploads\/2023\/11\/Personal2023.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/uni-lem.com\/wp-content\/uploads\/2023\/11\/Personal2023.png\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2024-10-04T14:55:42+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-02-03T05:06:47+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/unificlem\/\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Expedientes Emitidos - UNI-LEM\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/uni-lem.com\/wp-content\/uploads\/2023\/11\/Personal2023.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/uni-lem.com\\\/?page_id=2938#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/uni-lem.com#listItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\\\/\\\/uni-lem.com\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/uni-lem.com\\\/?page_id=2938#listItem\",\"name\":\"Expedientes Emitidos\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/uni-lem.com\\\/?page_id=2938#listItem\",\"position\":2,\"name\":\"Expedientes Emitidos\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/uni-lem.com#listItem\",\"name\":\"Hogar\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/uni-lem.com\\\/#organization\",\"name\":\"UNI-LEM\",\"description\":\"LABORATORIO N\\u00b01 DE ENSAYOS DE MATERIALES\",\"url\":\"https:\\\/\\\/uni-lem.com\\\/\",\"telephone\":\"+51989705524\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/uni-lem.com\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/logolemtransparente2-195x3001-1.png\",\"@id\":\"https:\\\/\\\/uni-lem.com\\\/?page_id=2938\\\/#organizationLogo\",\"width\":195,\"height\":300},\"image\":{\"@id\":\"https:\\\/\\\/uni-lem.com\\\/?page_id=2938\\\/#organizationLogo\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/unificlem\\\/\",\"https:\\\/\\\/www.youtube.com\\\/@uni-lem\",\"https:\\\/\\\/uni-lem.com\\\/\"]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/uni-lem.com\\\/?page_id=2938#webpage\",\"url\":\"https:\\\/\\\/uni-lem.com\\\/?page_id=2938\",\"name\":\"Expedientes Emitidos - UNI-LEM\",\"inLanguage\":\"es-ES\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/uni-lem.com\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/uni-lem.com\\\/?page_id=2938#breadcrumblist\"},\"datePublished\":\"2024-10-04T09:55:42-05:00\",\"dateModified\":\"2025-02-03T00:06:47-05:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/uni-lem.com\\\/#website\",\"url\":\"https:\\\/\\\/uni-lem.com\\\/\",\"name\":\"UNI-LEM\",\"description\":\"LABORATORIO N\\u00b01 DE ENSAYOS DE MATERIALES\",\"inLanguage\":\"es-ES\",\"publisher\":{\"@id\":\"https:\\\/\\\/uni-lem.com\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Expedientes Emitidos - UNI-LEM","description":"","canonical_url":"https:\/\/uni-lem.com\/?page_id=2938","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BreadcrumbList","@id":"https:\/\/uni-lem.com\/?page_id=2938#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/uni-lem.com#listItem","position":1,"name":"Hogar","item":"https:\/\/uni-lem.com","nextItem":{"@type":"ListItem","@id":"https:\/\/uni-lem.com\/?page_id=2938#listItem","name":"Expedientes Emitidos"}},{"@type":"ListItem","@id":"https:\/\/uni-lem.com\/?page_id=2938#listItem","position":2,"name":"Expedientes Emitidos","previousItem":{"@type":"ListItem","@id":"https:\/\/uni-lem.com#listItem","name":"Hogar"}}]},{"@type":"Organization","@id":"https:\/\/uni-lem.com\/#organization","name":"UNI-LEM","description":"LABORATORIO N\u00b01 DE ENSAYOS DE MATERIALES","url":"https:\/\/uni-lem.com\/","telephone":"+51989705524","logo":{"@type":"ImageObject","url":"https:\/\/uni-lem.com\/wp-content\/uploads\/2023\/11\/logolemtransparente2-195x3001-1.png","@id":"https:\/\/uni-lem.com\/?page_id=2938\/#organizationLogo","width":195,"height":300},"image":{"@id":"https:\/\/uni-lem.com\/?page_id=2938\/#organizationLogo"},"sameAs":["https:\/\/www.facebook.com\/unificlem\/","https:\/\/www.youtube.com\/@uni-lem","https:\/\/uni-lem.com\/"]},{"@type":"WebPage","@id":"https:\/\/uni-lem.com\/?page_id=2938#webpage","url":"https:\/\/uni-lem.com\/?page_id=2938","name":"Expedientes Emitidos - UNI-LEM","inLanguage":"es-ES","isPartOf":{"@id":"https:\/\/uni-lem.com\/#website"},"breadcrumb":{"@id":"https:\/\/uni-lem.com\/?page_id=2938#breadcrumblist"},"datePublished":"2024-10-04T09:55:42-05:00","dateModified":"2025-02-03T00:06:47-05:00"},{"@type":"WebSite","@id":"https:\/\/uni-lem.com\/#website","url":"https:\/\/uni-lem.com\/","name":"UNI-LEM","description":"LABORATORIO N\u00b01 DE ENSAYOS DE MATERIALES","inLanguage":"es-ES","publisher":{"@id":"https:\/\/uni-lem.com\/#organization"}}]},"og:locale":"es_ES","og:site_name":"UNI-LEM - LABORATORIO N\u00b01 DE ENSAYOS DE MATERIALES","og:type":"article","og:title":"Expedientes Emitidos - UNI-LEM","og:url":"https:\/\/uni-lem.com\/?page_id=2938","og:image":"https:\/\/uni-lem.com\/wp-content\/uploads\/2023\/11\/Personal2023.png","og:image:secure_url":"https:\/\/uni-lem.com\/wp-content\/uploads\/2023\/11\/Personal2023.png","article:published_time":"2024-10-04T14:55:42+00:00","article:modified_time":"2025-02-03T05:06:47+00:00","article:publisher":"https:\/\/www.facebook.com\/unificlem\/","twitter:card":"summary_large_image","twitter:title":"Expedientes Emitidos - UNI-LEM","twitter:image":"https:\/\/uni-lem.com\/wp-content\/uploads\/2023\/11\/Personal2023.png"},"aioseo_meta_data":{"post_id":"2938","title":null,"description":null,"keywords":null,"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"WebPage","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2024-10-04 14:54:59","updated":"2025-06-10 15:50:05","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/uni-lem.com\" title=\"Hogar\">Hogar<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tExpedientes Emitidos\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Hogar","link":"https:\/\/uni-lem.com"},{"label":"Expedientes Emitidos","link":"https:\/\/uni-lem.com\/?page_id=2938"}],"_links":{"self":[{"href":"https:\/\/uni-lem.com\/index.php?rest_route=\/wp\/v2\/pages\/2938","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/uni-lem.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/uni-lem.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/uni-lem.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/uni-lem.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2938"}],"version-history":[{"count":5,"href":"https:\/\/uni-lem.com\/index.php?rest_route=\/wp\/v2\/pages\/2938\/revisions"}],"predecessor-version":[{"id":3501,"href":"https:\/\/uni-lem.com\/index.php?rest_route=\/wp\/v2\/pages\/2938\/revisions\/3501"}],"wp:attachment":[{"href":"https:\/\/uni-lem.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2938"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}