{"id":976,"date":"2025-08-26T15:08:14","date_gmt":"2025-08-26T15:08:14","guid":{"rendered":"https:\/\/coffeecopa.agenciathecs.com.br\/?page_id=976"},"modified":"2025-10-27T12:27:59","modified_gmt":"2025-10-27T12:27:59","slug":"tabela","status":"publish","type":"page","link":"https:\/\/coffeecopa.com\/en\/tabela\/","title":{"rendered":"Purchase Prices"},"content":{"rendered":"<div data-elementor-type=\"wp-page\" data-elementor-id=\"976\" class=\"elementor elementor-976\" data-elementor-post-type=\"page\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2f01bc2 e-flex e-con-boxed e-con e-parent\" data-id=\"2f01bc2\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-63d80d0 elementor-widget elementor-widget-html\" data-id=\"63d80d0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<section class=\"cc-price-section\">\r\n  <style>\r\n    .cc-price-section {\r\n      --brand:#61CE70;\r\n      --brand-700:#427629;\r\n      --brand-900:#2f5605;\r\n      --bg:#f6fbf7;\r\n      --text:#1b1b1b;\r\n      --muted:#6b6b6b;\r\n      padding:20px;\r\n      background: linear-gradient(180deg, var(--bg), #ffffff);\r\n      border-radius: 16px;\r\n      box-shadow: 0 6px 24px rgba(0,0,0,.06);\r\n    }\r\n    .cc-price-header {\r\n      display:flex; flex-wrap:wrap; align-items:center; justify-content:space-between;\r\n      gap:10px; margin-bottom:12px;\r\n    }\r\n    .cc-price-title {\r\n      font-size:1.4rem; font-weight:700; color:var(--brand-900);\r\n      display:flex; align-items:center; gap:10px; margin:0;\r\n    }\r\n    .cc-pill {\r\n      background: color-mix(in srgb, var(--brand) 16%, white);\r\n      color: var(--brand-900);\r\n      padding:6px 12px; border-radius:999px; font-size:.8rem; font-weight:600;\r\n      border:1px solid color-mix(in srgb, var(--brand) 40%, transparent);\r\n      white-space:nowrap;\r\n    }\r\n    .cc-table-wrap { overflow-x:auto; border-radius:10px; border:1px solid #e7efe9 }\r\n    .cc-table {\r\n      width:100%; border-collapse:collapse; min-width:380px;\r\n      background:#fff; table-layout:auto;\r\n    }\r\n    .cc-table thead th {\r\n      text-align:left; font-weight:700; font-size:.9rem;\r\n      padding:10px; color:#fff;\r\n      background: linear-gradient(135deg, var(--brand-700), var(--brand-900));\r\n    }\r\n    .cc-table tbody td {\r\n      padding:10px; font-size:.95rem; color:var(--text);\r\n      border-bottom:1px solid #eef3ef;\r\n    }\r\n    .cc-table tbody tr:nth-child(even) td { background:#fafdfb }\r\n    .cc-table tbody tr:hover td { background: color-mix(in srgb, var(--brand) 8%, white); }\r\n    .cc-badge {\r\n      display:inline-block; font-weight:700;\r\n      padding:4px 8px; border-radius:8px; font-size:.85rem;\r\n      background: color-mix(in srgb, var(--brand) 12%, white);\r\n      color: var(--brand-900);\r\n    }\r\n    .cc-money { font-weight:700; color: var(--brand-900); white-space: nowrap; }\r\n    .cc-qualidade { font-weight:600; }\r\n    .cc-note {\r\n      margin-top:14px; color:var(--muted); font-size:.9rem; line-height:1.5;\r\n    }\r\n    .cc-whatsapp {\r\n      display:inline-block; margin-top:10px;\r\n      background:var(--brand); color:#fff; text-decoration:none;\r\n      padding:10px 18px; border-radius:8px; font-weight:600; font-size:.95rem;\r\n      transition:.2s ease;\r\n    }\r\n    .cc-whatsapp:hover { background:var(--brand-700); color: white !important; }\r\n    @media (max-width:640px){\r\n      .cc-table{ font-size:.9rem; }\r\n      .cc-table td, .cc-table th{ padding:8px }\r\n      .cc-price-header{ flex-direction:column; align-items:flex-start; gap:6px; }\r\n    }\r\n  <\/style>\r\n\r\n  <div class=\"cc-price-header\">\r\n    <h2 class=\"cc-price-title\">Lista de Pre\u00e7os<\/h2>\r\n    <span class=\"cc-pill\" id=\"atualizado\">Carregando...<\/span>\r\n  <\/div>\r\n\r\n  <div class=\"cc-table-wrap\" role=\"region\" aria-label=\"Lista de pre\u00e7os\" tabindex=\"0\">\r\n    <table class=\"cc-table\">\r\n      <thead>\r\n        <tr>\r\n          <th scope=\"col\">Qualidade<\/th>\r\n          <th scope=\"col\">Cata<\/th>\r\n          <th scope=\"col\">Pre\u00e7o<\/th>\r\n        <\/tr>\r\n      <\/thead>\r\n      <tbody id=\"tabela-precos\">\r\n        <tr><td colspan=\"3\">Carregando dados...<\/td><\/tr>\r\n      <\/tbody>\r\n    <\/table>\r\n  <\/div>\r\n\r\n  <p class=\"cc-note\">\r\n    Valores de refer\u00eancia internos. Podem sofrer ajustes conforme mercado e especifica\u00e7\u00f5es de lote. <br>\r\n    <strong>Pre\u00e7os Posto Manhumirim \u2013 MG<\/strong><br>\r\n    Para mais informa\u00e7\u00f5es, favor entrar em contato:\r\n  <\/p>\r\n\r\n  <a href=\"https:\/\/wa.me\/553388803867?text=Ol\u00e1%2C+tenho+interesse+na+Lista+de+Pre\u00e7os+de+caf\u00e9s.\" class=\"cc-whatsapp\">Falar no WhatsApp<\/a>\r\n\r\n  <script>\r\n    const SHEET_ID = \"1wNX2fPobme6rAE869H8Zrv82K8eCjaDadE30DHU48tc\";\r\n    const SHEET_NAME = \"Pre\u00e7os\";\r\n    const API_URL = `https:\/\/docs.google.com\/spreadsheets\/d\/${SHEET_ID}\/gviz\/tq?tqx=out:json&sheet=${encodeURIComponent(SHEET_NAME)}`;\r\n\r\n    const LS_TABELA = 'precos_tabela_html';\r\n    const LS_ATUALIZACAO = 'precos_ultima_atualizacao';\r\n\r\n    function dentroDoHorario() {\r\n      const agora = new Date();\r\n      const h = agora.getHours();\r\n      const m = agora.getMinutes();\r\n\r\n      const inicio = 9 * 60 + 30;   \/\/ 09:30 em minutos\r\n      const fim = 18 * 60 + 0;     \/\/ 18:00 em minutos\r\n      const agoraMin = h * 60 + m;\r\n\r\n      return agoraMin >= inicio && agoraMin <= fim;\r\n    }\r\n\r\n    async function carregarPrecos() {\r\n      if (!dentroDoHorario()) {\r\n        \/\/ Fora do hor\u00e1rio comercial \u2192 mostra mensagem fixa\r\n        document.querySelector(\"#tabela-precos\").innerHTML =\r\n          '<tr><td colspan=\"3\" style=\"text-align:center; color:#6b6b6b; font-weight:500;\">Os pre\u00e7os ser\u00e3o atualizados em breve<\/td><\/tr>';\r\n        document.querySelector(\"#atualizado\").textContent = \"Fora do hor\u00e1rio comercial\";\r\n        return;\r\n      }\r\n\r\n      \/\/ Durante o hor\u00e1rio comercial: atualizar dados\r\n      try {\r\n        const response = await fetch(API_URL);\r\n        const text = await response.text();\r\n        const json = JSON.parse(text.substr(47).slice(0, -2));\r\n\r\n        const tabela = document.querySelector(\"#tabela-precos\");\r\n        tabela.innerHTML = \"\";\r\n\r\n        json.table.rows.forEach(row => {\r\n          const qualidade = row.c[0]?.v || \"\";\r\n          let cata = row.c[1]?.v || \"\";\r\n          let preco = row.c[2]?.v || \"\";\r\n\r\n          if (cata !== \"\" && !isNaN(cata)) {\r\n            cata = (Number(cata) * 100).toFixed(0) + \"%\";\r\n          }\r\n          if (preco !== \"\" && !isNaN(preco)) {\r\n            preco = Number(preco).toLocaleString(\"pt-BR\", {\r\n              style: \"currency\",\r\n              currency: \"BRL\"\r\n            });\r\n          }\r\n\r\n          tabela.innerHTML += `\r\n            <tr>\r\n              <td class=\"cc-qualidade\">${qualidade}<\/td>\r\n              <td><span class=\"cc-badge\">${cata}<\/span><\/td>\r\n              <td class=\"cc-money\">${preco}<\/td>\r\n            <\/tr>\r\n          `;\r\n        });\r\n\r\n        \/\/ Salva tabela e hora da \u00faltima atualiza\u00e7\u00e3o no localStorage\r\n        localStorage.setItem(LS_TABELA, tabela.innerHTML);\r\n        const atualizacaoTexto =\r\n          new Date().toLocaleDateString(\"pt-BR\") +\r\n          \" \u00e0s \" +\r\n          new Date().toLocaleTimeString(\"pt-BR\", { hour: \"2-digit\", minute: \"2-digit\" });\r\n        localStorage.setItem(LS_ATUALIZACAO, atualizacaoTexto);\r\n\r\n        document.querySelector(\"#atualizado\").textContent = \"Atualizado em \" + atualizacaoTexto;\r\n\r\n      } catch (err) {\r\n        console.error(\"Erro ao carregar planilha:\", err);\r\n        \/\/ Mostrar mensagem em caso de erro\r\n        document.querySelector(\"#tabela-precos\").innerHTML =\r\n          '<tr><td colspan=\"3\" style=\"text-align:center; color:#6b6b6b; font-weight:500;\">Erro ao carregar dados. Tente novamente mais tarde.<\/td><\/tr>';\r\n        document.querySelector(\"#atualizado\").textContent = \"Erro ao atualizar\";\r\n      }\r\n    }\r\n\r\n    carregarPrecos();\r\n    setInterval(() => {\r\n      if (dentroDoHorario()) {\r\n        carregarPrecos();\r\n      }\r\n    }, 60 * 1000);\r\n  <\/script>\r\n<\/section>\r\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-98c5831 e-flex e-con-boxed e-con e-parent\" data-id=\"98c5831\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e14606a elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"e14606a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c346ce2 elementor-widget elementor-widget-spacer\" data-id=\"c346ce2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/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\t\t<\/div>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>Lista de Pre\u00e7os Carregando&#8230; Qualidade Cata Pre\u00e7o Carregando dados&#8230; Valores de refer\u00eancia internos. Podem sofrer ajustes conforme mercado e especifica\u00e7\u00f5es [&hellip;]<\/p>","protected":false},"author":3,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"elementor_header_footer","meta":{"site-sidebar-layout":"no-sidebar","site-content-layout":"","ast-site-content-layout":"full-width-container","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"disabled","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-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":"","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-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":"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":""},"mobile":{"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":""}},"footnotes":""},"class_list":["post-976","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/coffeecopa.com\/en\/wp-json\/wp\/v2\/pages\/976","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/coffeecopa.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/coffeecopa.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/coffeecopa.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/coffeecopa.com\/en\/wp-json\/wp\/v2\/comments?post=976"}],"version-history":[{"count":60,"href":"https:\/\/coffeecopa.com\/en\/wp-json\/wp\/v2\/pages\/976\/revisions"}],"predecessor-version":[{"id":1255,"href":"https:\/\/coffeecopa.com\/en\/wp-json\/wp\/v2\/pages\/976\/revisions\/1255"}],"wp:attachment":[{"href":"https:\/\/coffeecopa.com\/en\/wp-json\/wp\/v2\/media?parent=976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}