[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_157":158,"_159":160},"routes/_app.x.$handle.$name",{"_97":96,"_32":45,"_105":87,"_27":53,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":25,"_119":120,"_121":25,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",35,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","154f39ca-667a-11f1-bdcd-1607ee4eb77e","name","fileType","interval","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// ── CONFIGURAÇÕES ─────────────────────────────────────────────────────────────\nconst API_URL =\n `https://www.tesourodireto.com.br/o/historico-rentabilidade/187?days=30`;\n\nconst MARKET_OPEN = { hour: 9, minute: 30 };\nconst MARKET_CLOSE = { hour: 18, minute: 0 };\n\nconst RECIPIENTS = [\n \"matheus306@gmail.com\",\n \"marioljunior84@gmail.com\",\n \"lucasmendes2105@gmail.com\",\n \"marquedson@gmail.com\",\n];\n\n// O e-mail de envio deve ser o mesmo e-mail que você usará para criar a conta no Brevo (ex: seu e-mail pessoal)\nconst EMAIL_SENDER = \"matheus306@gmail.com\";\n// ──────────────────────────────────────────────────────────────────────────────\n\nexport default async function (interval: Interval) {\n // 1. Validar Fuso Horário de Brasília (BRT)\n const now = new Date();\n const brtString = now.toLocaleString(\"en-US\", {\n timeZone: \"America/Sao_Paulo\",\n });\n const brtDate = new Date(brtString);\n\n const day = brtDate.getDay(); // 0 = Domingo, 6 = Sábado\n const hour = brtDate.getHours();\n const minute = brtDate.getMinutes();\n\n if (day === 0 || day === 6) {\n console.log(\"Fim de semana. Nenhuma ação.\");\n return;\n }\n\n const currentMinutes = hour * 60 + minute;\n const openMinutes = MARKET_OPEN.hour * 60 + MARKET_OPEN.minute;\n const closeMinutes = MARKET_CLOSE.hour * 60 + MARKET_CLOSE.minute;\n\n if (currentMinutes < openMinutes || currentMinutes >= closeMinutes) {\n console.log(\n `Fora do horário de mercado (${hour.toString().padStart(2, \"0\")}:${\n minute.toString().padStart(2, \"0\")\n } BRT). Nenhuma ação.`,\n );\n return;\n }\n\n // Formatar a data de hoje no padrão DD/MM/YYYY\n const dd = String(brtDate.getDate()).padStart(2, \"0\");\n const mm = String(brtDate.getMonth() + 1).padStart(2, \"0\");\n const yyyy = brtDate.getFullYear();\n const todayLabel = `${dd}/${mm}/${yyyy}`;\n const todayStr = `${yyyy}-${mm}-${dd}`;\n\n // 2. Buscar dados da API com mecanismo de Retentativa (Fallback)\n //\n // A tesourodireto.com.br está atrás de um Managed Challenge da Cloudflare\n // (confirmado 02/09/2026: header cf-mitigated=challenge, corpo \"Just a\n // moment...\" em toda tentativa) — nenhum fetch direto passa por isso,\n // então a chamada vai pela ScraperAPI (resolve o challenge com browser\n // real do lado deles e devolve o JSON puro). Precisa da env var\n // \"scraperapi\" configurada no Val Town com a chave de\n // https://www.scraperapi.com (mesmo padrão da env var \"brevo\" já usada\n // abaixo).\n const scraperApiKey = Deno.env.get(\"scraperapi\");\n if (!scraperApiKey) {\n console.error(\n \"Variável de ambiente 'scraperapi' não está configurada no Val Town.\",\n );\n return;\n }\n // Escalada de custo (03/09/2026, pedido explícito: evitar gastar 50\n // créditos por chamada quando não precisa) — o bypass de Cloudflare da\n // ScraperAPI já tenta rotação de proxy/headers/cookies automaticamente\n // até numa chamada simples (1 crédito, +10 se detectar e precisar\n // acionar o bypass = ~11), só escalando pro combo caro quando o alvo\n // resiste. Por isso cada tentativa do loop abaixo sobe um degrau em vez\n // de já sair gastando render+premium (25) de cara: simples primeiro,\n // premium sozinho se a simples falhar, e só na última tentativa o combo\n // completo (25, que com o bypass de Cloudflare detectado vira ~50).\n const SCRAPER_API_STRATEGIES = [\n \"\",\n \"&premium=true\",\n \"&render=true&premium=true\",\n ];\n const buildScraperApiUrl = (extraParams: string) =>\n `https://api.scraperapi.com/?api_key=${scraperApiKey}&url=${\n encodeURIComponent(API_URL)\n }${extraParams}`;\n\n let data: any = null;\n let idx = -1;\n const maxRetries = SCRAPER_API_STRATEGIES.length;\n const retryDelayMs = 3000;\n\n for (let attempt = 1; attempt <= maxRetries; attempt++) {\n const extraParams = SCRAPER_API_STRATEGIES[attempt - 1];\n console.log(\n `Tentativa ${attempt} de buscar dados da API (estratégia: ${\n extraParams || \"requisição simples\"\n })...`,\n );\n try {\n const response = await fetch(buildScraperApiUrl(extraParams));\n\n if (!response.ok) {\n // Diagnóstico do bloqueio (03/09/2026, 403 recorrente no Val Town) —\n // lê como texto (não .json(), corpo de bloqueio/challenge pode não\n // ser JSON válido) e loga os headers que denunciam Cloudflare, pra\n // saber se é fingerprint/WAF antes de tentar qualquer outra coisa.\n const errorBody = await response.text().catch(() =>\n \"\"\n );\n console.warn(\n `Tentativa ${attempt} falhou com status HTTP ${response.status}.`,\n );\n console.warn(\n `Headers relevantes: server=${\n response.headers.get(\"server\")\n }, cf-ray=${response.headers.get(\"cf-ray\")}, cf-mitigated=${\n response.headers.get(\"cf-mitigated\")\n }`,\n );\n console.warn(\n `Corpo da resposta (primeiros 2000 chars):\\n${\n errorBody.slice(0, 2000)\n }`,\n );\n\n if (attempt < maxRetries) {\n await new Promise((r) => setTimeout(r, retryDelayMs));\n continue;\n }\n throw new Error(`Erro HTTP: ${response.status}`);\n }\n\n data = await response.json();\n const labels = data?.TrsrBd?.label || [];\n idx = labels.indexOf(todayLabel);\n\n if (idx !== -1) {\n console.log(`Dados encontrados!`);\n break;\n } else {\n console.warn(\n `Tentativa ${attempt}: Dados de hoje (${todayLabel}) ainda não constavam no JSON recebido.`,\n );\n if (attempt < maxRetries) {\n await new Promise((r) => setTimeout(r, retryDelayMs));\n }\n }\n } catch (err: any) {\n console.warn(\n `Tentativa ${attempt} falhou devido ao erro: ${err.message}`,\n );\n if (attempt === maxRetries) {\n throw err;\n }\n await new Promise((r) => setTimeout(r, retryDelayMs));\n }\n }\n\n if (idx === -1) {\n console.log(\n `Dados de hoje (${todayLabel}) indisponíveis na API após ${maxRetries} tentativas.`,\n );\n return;\n }\n\n const bond = data.TrsrBd;\n const currentRate = bond.anulInvstmtRate[idx];\n const currentRedRate = bond.anulRedRate[idx];\n const untrInvstmtVal = bond.untrInvstmtVal[idx];\n const untrRedVal = bond.untrRedVal[idx];\n const bondName = bond.nm;\n\n const timeStr = `${hour.toString().padStart(2, \"0\")}:${\n minute.toString().padStart(2, \"0\")\n }`;\n console.log(`Taxa atual (${todayLabel} ${timeStr}): ${currentRate}% a.a.`);\n\n // 3. Inicializar Tabela do SQLite (se não existir)\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS tesouro_alert_state (\n key TEXT PRIMARY KEY,\n value TEXT\n )\n `);\n\n const getVal = async (key: string): Promise => {\n const res = await sqlite.execute({\n sql: \"SELECT value FROM tesouro_alert_state WHERE key = :key\",\n args: { key },\n });\n return res.rows[0]?.[0] ?? null;\n };\n\n const setVal = async (key: string, value: string) => {\n await sqlite.execute({\n sql:\n \"INSERT OR REPLACE INTO tesouro_alert_state (key, value) VALUES (:key, :value)\",\n args: { key, value },\n });\n };\n\n // 4. Ler estado anterior\n const lastRateRaw = await getVal(\"last-known-rate\");\n const lastRedRateRaw = await getVal(\"last-known-red-rate\");\n const lastInvValRaw = await getVal(\"last-known-inv-val\");\n const lastRedValRaw = await getVal(\"last-known-red-val\");\n const lastRunDate = await getVal(\"last-run-date\");\n\n const lastRate = lastRateRaw ? parseFloat(lastRateRaw) : null;\n const lastRedRate = lastRedRateRaw\n ? parseFloat(lastRedRateRaw)\n : currentRedRate;\n const lastInvVal = lastInvValRaw ? parseFloat(lastInvValRaw) : untrInvstmtVal;\n const lastRedVal = lastRedValRaw ? parseFloat(lastRedValRaw) : untrRedVal;\n\n // ── Função auxiliar para enviar o e-mail via Brevo ────────────────────────\n async function sendAlert(\n isFirstRun: boolean,\n prevRate: number,\n prevRedRate: number,\n prevInvVal: number,\n prevRedVal: number,\n ) {\n const delta = currentRate - prevRate;\n const taxaCaiu = delta < 0;\n\n const typeLabel = isFirstRun ? \"Abertura\" : (taxaCaiu ? \"Caiu\" : \"Subiu\");\n const subLabel = isFirstRun\n ? \"snapshot de abertura do mercado\"\n : (taxaCaiu\n ? \"preço subiu — título mais valorizado\"\n : \"preço caiu — momento mais atrativo para comprar\");\n const color = isFirstRun ? \"#2d5fa6\" : (taxaCaiu ? \"#1a6b3c\" : \"#b20f03\");\n const icon = isFirstRun ? \"📊\" : (taxaCaiu ? \"📉\" : \"📈\");\n\n const brevoApiKey = Deno.env.get(\"brevo\");\n if (!brevoApiKey) {\n console.error(\n \"Variável de ambiente 'brevo' não está configurada no Val Town.\",\n );\n return false;\n }\n\n const formatDiff = (\n now: number,\n prev: number,\n isPercent = false,\n ): string => {\n if (isFirstRun) return \"—\";\n const diff = now - prev;\n if (diff === 0) return \"—\";\n const sign = diff > 0 ? \"+\" : \"\";\n const suffix = isPercent ? \"%\" : \"\";\n const diffColor = diff < 0 ? \"#1a6b3c\" : \"#b20f03\";\n return `${sign}${\n diff.toFixed(2)\n }${suffix}`;\n };\n\n // Lucro/Prejuízo = PU Compra - PU Venda\n const spreadAtual = untrInvstmtVal - untrRedVal;\n const spreadAnterior = prevInvVal - prevRedVal;\n const spreadColor = spreadAtual >= 0 ? \"#b20f03\" : \"#1a6b3c\";\n const spreadLabel = spreadAtual >= 0\n ? `R$ +${spreadAtual.toFixed(2)} (custo ao comprar agora)`\n : `R$ ${spreadAtual.toFixed(2)} (ganho ao resgatar agora)`;\n\n const htmlBody = `\n

${icon} Tesouro Direto — Taxa ${typeLabel}!

${subLabel}

${todayLabel} às ${timeStr} (Horário de Brasília)

${bondName}

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

Métrica	Anterior	Agora	Variação
Taxa de Compra	${\n prevRate.toFixed(2)\n }%	${\n currentRate.toFixed(2)\n }%	${\n formatDiff(currentRate, prevRate, true)\n }
Preço Unitário (Compra)	R$ ${\n prevInvVal.toFixed(2)\n }	R$ ${\n untrInvstmtVal.toFixed(2)\n }	${\n formatDiff(untrInvstmtVal, prevInvVal)\n }
Taxa de Venda (Resgate)	${\n prevRedRate.toFixed(2)\n }%	${\n currentRedRate.toFixed(2)\n }%	${\n formatDiff(currentRedRate, prevRedRate, true)\n }
Preço Unitário (Venda)	R$ ${\n prevRedVal.toFixed(2)\n }	R$ ${\n untrRedVal.toFixed(2)\n }	${\n formatDiff(untrRedVal, prevRedVal)\n }
Compra − Venda (PU atual)	${spreadLabel}

\n \n Ir para o Tesouro Direto\n \n

\n `;\n\n const formattedRecipients = RECIPIENTS.map((email) => ({ email }));\n const emailResponse = await fetch(\"https://api.brevo.com/v3/smtp/email\", {\n method: \"POST\",\n headers: {\n \"accept\": \"application/json\",\n \"api-key\": brevoApiKey,\n \"content-type\": \"application/json\",\n },\n body: JSON.stringify({\n sender: { name: \"Tesouro Alerta\", email: EMAIL_SENDER },\n to: formattedRecipients,\n subject:\n `${icon} Tesouro Direto — Taxa ${typeLabel.toLowerCase()} para ${\n currentRate.toFixed(2)\n }% a.a.`,\n htmlContent: htmlBody,\n }),\n });\n\n if (emailResponse.ok) {\n console.log(\"E-mails enviados com sucesso via Brevo!\");\n return true;\n } else {\n const errText = await emailResponse.text();\n console.error(`Falha ao enviar e-mail pelo Brevo: ${errText}`);\n return false;\n }\n }\n // ──────────────────────────────────────────────────────────────────────────\n\n // 5. Primeira execução do dia: envia snapshot de abertura e salva estado\n if (lastRate === null || lastRunDate !== todayStr) {\n console.log(\n `Primeira execução do dia (${todayLabel}). Enviando snapshot de abertura...`,\n );\n const sent = await sendAlert(\n true,\n currentRate,\n currentRedRate,\n untrInvstmtVal,\n untrRedVal,\n );\n if (sent) {\n await setVal(\"last-known-rate\", currentRate.toString());\n await setVal(\"last-known-red-rate\", currentRedRate.toString());\n await setVal(\"last-known-inv-val\", untrInvstmtVal.toString());\n await setVal(\"last-known-red-val\", untrRedVal.toString());\n await setVal(\"last-run-date\", todayStr);\n }\n return;\n }\n\n // 6. Execuções seguintes: alerta somente se a taxa mudou\n if (currentRate !== lastRate) {\n console.log(\n `A taxa mudou! Anterior: ${lastRate}% -> Atual: ${currentRate}%. Enviando e-mail...`,\n );\n const sent = await sendAlert(\n false,\n lastRate,\n lastRedRate,\n lastInvVal,\n lastRedVal,\n );\n if (sent) {\n await setVal(\"last-known-rate\", currentRate.toString());\n await setVal(\"last-known-red-rate\", currentRedRate.toString());\n await setVal(\"last-known-inv-val\", untrInvstmtVal.toString());\n await setVal(\"last-known-red-val\", untrRedVal.toString());\n }\n } else {\n console.log(`Taxa não se alterou (${currentRate}%). Nenhuma ação.`);\n }\n}","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// ── CONFIGURAÇÕES ─────────────────────────────────────────────────────────────\nconst API_URL =\n `https://www.tesourodireto.com.br/o/historico-rentabilidade/187?days=30`;\n\nconst MARKET_OPEN = { hour: 9, minute: 30 };\nconst MARKET_CLOSE = { hour: 18, minute: 0 };\n\nconst RECIPIENTS = [\n \"matheus306@gmail.com\",\n \"marioljunior84@gmail.com\",\n \"lucasmendes2105@gmail.com\",\n \"marquedson@gmail.com\",\n];\n\n// O e-mail de envio deve ser o mesmo e-mail que você usará para criar a conta no Brevo (ex: seu e-mail pessoal)\nconst EMAIL_SENDER = \"matheus306@gmail.com\";\n// ──────────────────────────────────────────────────────────────────────────────\n\nexport default async function (interval: Interval) {\n // 1. Validar Fuso Horário de Brasília (BRT)\n const now = new Date();\n const brtString = now.toLocaleString(\"en-US\", {\n timeZone: \"America/Sao_Paulo\",\n });\n const brtDate = new Date(brtString);\n\n const day = brtDate.getDay(); // 0 = Domingo, 6 = Sábado\n const hour = brtDate.getHours();\n const minute = brtDate.getMinutes();\n\n if (day === 0 || day === 6) {\n console.log(\"Fim de semana. Nenhuma ação.\");\n return;\n }\n\n const currentMinutes = hour * 60 + minute;\n const openMinutes = MARKET_OPEN.hour * 60 + MARKET_OPEN.minute;\n const closeMinutes = MARKET_CLOSE.hour * 60 + MARKET_CLOSE.minute;\n\n if (currentMinutes < openMinutes || currentMinutes >= closeMinutes) {\n console.log(\n `Fora do horário de mercado (${hour.toString().padStart(2, \"0\")}:${\n minute.toString().padStart(2, \"0\")\n } BRT). Nenhuma ação.`,\n );\n return;\n }\n\n // Formatar a data de hoje no padrão DD/MM/YYYY\n const dd = String(brtDate.getDate()).padStart(2, \"0\");\n const mm = String(brtDate.getMonth() + 1).padStart(2, \"0\");\n const yyyy = brtDate.getFullYear();\n const todayLabel = `${dd}/${mm}/${yyyy}`;\n const todayStr = `${yyyy}-${mm}-${dd}`;\n\n // 2. Buscar dados da API com mecanismo de Retentativa (Fallback)\n //\n // A tesourodireto.com.br está atrás de um Managed Challenge da Cloudflare\n // (confirmado 02/09/2026: header cf-mitigated=challenge, corpo \"Just a\n // moment...\" em toda tentativa) — nenhum fetch direto passa por isso.\n // Trocado de ScraperAPI pro FlareSolverr self-hosted em 11/09/2026 (a\n // conta gratuita do ScraperAPI estourou o crédito mensal, compartilhada\n // com outro projeto) — FlareSolverr roda num container Docker próprio,\n // resolve o challenge com Chromium de verdade sem custo por chamada, e\n // devolve o HTML/JSON puro dentro de solution.response (embrulhado em\n //

, ver extractJsonFromFlareSolverr abaixo). Precisa das env vars\n  // \"flaresolverr_url\", \"flaresolverr_user\" e \"flaresolverr_password\"\n  // configuradas no Val Town (mesmo padrão da env var \"brevo\" já usada\n  // abaixo).\n  const flaresolverrUrl = Deno.env.get(\"flaresolverr_url\");\n  const flaresolverrUser = Deno.env.get(\"flaresolverr_user\");\n  const flaresolverrPassword = Deno.env.get(\"flaresolverr_password\");\n  if (!flaresolverrUrl) {\n    console.error(\n      \"Variável de ambiente 'flaresolverr_url' não está configurada no Val Town.\",\n    );\n    return;\n  }\n\n  function extractJsonFromFlareSolverr(html: string): any {\n    const match = /]*>([\\s\\S]*?)<\\/pre>/i.exec(html || \"\");\n    return JSON.parse(match ? match[1] : html);\n  }\n\n  let data: any = null;\n  let idx = -1;\n  const maxRetries = 2;\n  const retryDelayMs = 3000;\n\n  for (let attempt = 1; attempt <= maxRetries; attempt++) {\n    console.log(\n      `Tentativa ${attempt} de buscar dados da API via FlareSolverr...`,\n    );\n    try {\n      const authHeader = flaresolverrUser\n        ? {\n          Authorization: \"Basic \" +\n            btoa(`${flaresolverrUser}:${flaresolverrPassword}`),\n        }\n        : {};\n      const response = await fetch(flaresolverrUrl, {\n        method: \"POST\",\n        headers: { \"Content-Type\": \"application/json\", ...authHeader },\n        body: JSON.stringify({\n          cmd: \"request.get\",\n          url: API_URL,\n          maxTimeout: 30000,\n        }),\n      });\n\n      if (!response.ok) {\n        const errorBody = await response.text().catch(() =>\n          \"\"\n        );\n        console.warn(\n          `Tentativa ${attempt} falhou com status HTTP ${response.status}.\\nCorpo (primeiros 2000 chars):\\n${\n            errorBody.slice(0, 2000)\n          }`,\n        );\n        if (attempt < maxRetries) {\n          await new Promise((r) => setTimeout(r, retryDelayMs));\n          continue;\n        }\n        throw new Error(`Erro HTTP: ${response.status}`);\n      }\n\n      const outer = await response.json();\n      if (outer.status !== \"ok\") {\n        console.warn(\n          `Tentativa ${attempt}: FlareSolverr retornou status \"${outer.status}\": ${outer.message}`,\n        );\n        if (attempt < maxRetries) {\n          await new Promise((r) => setTimeout(r, retryDelayMs));\n          continue;\n        }\n        throw new Error(`FlareSolverr falhou: ${outer.message}`);\n      }\n\n      data = extractJsonFromFlareSolverr(outer.solution?.response);\n      const labels = data?.TrsrBd?.label || [];\n      idx = labels.indexOf(todayLabel);\n\n      if (idx !== -1) {\n        console.log(`Dados encontrados!`);\n        break;\n      } else {\n        console.warn(\n          `Tentativa ${attempt}: Dados de hoje (${todayLabel}) ainda não constavam no JSON recebido.`,\n        );\n        if (attempt < maxRetries) {\n          await new Promise((r) => setTimeout(r, retryDelayMs));\n        }\n      }\n    } catch (err: any) {\n      console.warn(\n        `Tentativa ${attempt} falhou devido ao erro: ${err.message}`,\n      );\n      if (attempt === maxRetries) {\n        throw err;\n      }\n      await new Promise((r) => setTimeout(r, retryDelayMs));\n    }\n  }\n\n  if (idx === -1) {\n    console.log(\n      `Dados de hoje (${todayLabel}) indisponíveis na API após ${maxRetries} tentativas.`,\n    );\n    return;\n  }\n\n  const bond = data.TrsrBd;\n  const currentRate = bond.anulInvstmtRate[idx];\n  const currentRedRate = bond.anulRedRate[idx];\n  const untrInvstmtVal = bond.untrInvstmtVal[idx];\n  const untrRedVal = bond.untrRedVal[idx];\n  const bondName = bond.nm;\n\n  const timeStr = `${hour.toString().padStart(2, \"0\")}:${\n    minute.toString().padStart(2, \"0\")\n  }`;\n  console.log(`Taxa atual (${todayLabel} ${timeStr}): ${currentRate}% a.a.`);\n\n  // 3. Inicializar Tabela do SQLite (se não existir)\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS tesouro_alert_state (\n      key TEXT PRIMARY KEY,\n      value TEXT\n    )\n  `);\n\n  const getVal = async (key: string): Promise => {\n    const res = await sqlite.execute({\n      sql: \"SELECT value FROM tesouro_alert_state WHERE key = :key\",\n      args: { key },\n    });\n    return res.rows[0]?.[0] ?? null;\n  };\n\n  const setVal = async (key: string, value: string) => {\n    await sqlite.execute({\n      sql:\n        \"INSERT OR REPLACE INTO tesouro_alert_state (key, value) VALUES (:key, :value)\",\n      args: { key, value },\n    });\n  };\n\n  // 4. Ler estado anterior\n  const lastRateRaw = await getVal(\"last-known-rate\");\n  const lastRedRateRaw = await getVal(\"last-known-red-rate\");\n  const lastInvValRaw = await getVal(\"last-known-inv-val\");\n  const lastRedValRaw = await getVal(\"last-known-red-val\");\n  const lastRunDate = await getVal(\"last-run-date\");\n\n  const lastRate = lastRateRaw ? parseFloat(lastRateRaw) : null;\n  const lastRedRate = lastRedRateRaw\n    ? parseFloat(lastRedRateRaw)\n    : currentRedRate;\n  const lastInvVal = lastInvValRaw ? parseFloat(lastInvValRaw) : untrInvstmtVal;\n  const lastRedVal = lastRedValRaw ? parseFloat(lastRedValRaw) : untrRedVal;\n\n  // ── Função auxiliar para enviar o e-mail via Brevo ────────────────────────\n  async function sendAlert(\n    isFirstRun: boolean,\n    prevRate: number,\n    prevRedRate: number,\n    prevInvVal: number,\n    prevRedVal: number,\n  ) {\n    const delta = currentRate - prevRate;\n    const taxaCaiu = delta < 0;\n\n    const typeLabel = isFirstRun ? \"Abertura\" : (taxaCaiu ? \"Caiu\" : \"Subiu\");\n    const subLabel = isFirstRun\n      ? \"snapshot de abertura do mercado\"\n      : (taxaCaiu\n        ? \"preço subiu — título mais valorizado\"\n        : \"preço caiu — momento mais atrativo para comprar\");\n    const color = isFirstRun ? \"#2d5fa6\" : (taxaCaiu ? \"#1a6b3c\" : \"#b20f03\");\n    const icon = isFirstRun ? \"📊\" : (taxaCaiu ? \"📉\" : \"📈\");\n\n    const brevoApiKey = Deno.env.get(\"brevo\");\n    if (!brevoApiKey) {\n      console.error(\n        \"Variável de ambiente 'brevo' não está configurada no Val Town.\",\n      );\n      return false;\n    }\n\n    const formatDiff = (\n      now: number,\n      prev: number,\n      isPercent = false,\n    ): string => {\n      if (isFirstRun) return \"—\";\n      const diff = now - prev;\n      if (diff === 0) return \"—\";\n      const sign = diff > 0 ? \"+\" : \"\";\n      const suffix = isPercent ? \"%\" : \"\";\n      const diffColor = diff < 0 ? \"#1a6b3c\" : \"#b20f03\";\n      return `${sign}${\n        diff.toFixed(2)\n      }${suffix}`;\n    };\n\n    // Lucro/Prejuízo = PU Compra - PU Venda\n    const spreadAtual = untrInvstmtVal - untrRedVal;\n    const spreadAnterior = prevInvVal - prevRedVal;\n    const spreadColor = spreadAtual >= 0 ? \"#b20f03\" : \"#1a6b3c\";\n    const spreadLabel = spreadAtual >= 0\n      ? `R$ +${spreadAtual.toFixed(2)} (custo ao comprar agora)`\n      : `R$ ${spreadAtual.toFixed(2)} (ganho ao resgatar agora)`;\n\n    const htmlBody = `\n      \n        \n          ${icon} Tesouro Direto — Taxa ${typeLabel}!
\n          ${subLabel}
\n          ${todayLabel} às ${timeStr} (Horário de Brasília)
\n        
\n        \n          ${bondName}
\n          \n            \n              \n              \n              \n              \n            \n            \n              \n              \n              \n              \n            \n            \n              \n              \n              \n              \n            \n            \n              \n              \n              \n              \n            \n            \n              \n              \n              \n              \n            \n            \n              \n              \n            \n          Métrica Anterior Agora Variação
Taxa de Compra ${\n      prevRate.toFixed(2)\n    }% ${\n      currentRate.toFixed(2)\n    }% ${\n      formatDiff(currentRate, prevRate, true)\n    }
Preço Unitário (Compra) R$ ${\n      prevInvVal.toFixed(2)\n    } R$ ${\n      untrInvstmtVal.toFixed(2)\n    } ${\n      formatDiff(untrInvstmtVal, prevInvVal)\n    }
Taxa de Venda (Resgate) ${\n      prevRedRate.toFixed(2)\n    }% ${\n      currentRedRate.toFixed(2)\n    }% ${\n      formatDiff(currentRedRate, prevRedRate, true)\n    }
Preço Unitário (Venda) R$ ${\n      prevRedVal.toFixed(2)\n    } R$ ${\n      untrRedVal.toFixed(2)\n    } ${\n      formatDiff(untrRedVal, prevRedVal)\n    }
Compra − Venda (PU atual) ${spreadLabel}
\n          \n            \n              Ir para o Tesouro Direto\n            \n          
\n        
\n      \n    `;\n\n    const formattedRecipients = RECIPIENTS.map((email) => ({ email }));\n    const emailResponse = await fetch(\"https://api.brevo.com/v3/smtp/email\", {\n      method: \"POST\",\n      headers: {\n        \"accept\": \"application/json\",\n        \"api-key\": brevoApiKey,\n        \"content-type\": \"application/json\",\n      },\n      body: JSON.stringify({\n        sender: { name: \"Tesouro Alerta\", email: EMAIL_SENDER },\n        to: formattedRecipients,\n        subject:\n          `${icon} Tesouro Direto — Taxa ${typeLabel.toLowerCase()} para ${\n            currentRate.toFixed(2)\n          }% a.a.`,\n        htmlContent: htmlBody,\n      }),\n    });\n\n    if (emailResponse.ok) {\n      console.log(\"E-mails enviados com sucesso via Brevo!\");\n      return true;\n    } else {\n      const errText = await emailResponse.text();\n      console.error(`Falha ao enviar e-mail pelo Brevo: ${errText}`);\n      return false;\n    }\n  }\n  // ──────────────────────────────────────────────────────────────────────────\n\n  // 5. Primeira execução do dia: envia snapshot de abertura e salva estado\n  if (lastRate === null || lastRunDate !== todayStr) {\n    console.log(\n      `Primeira execução do dia (${todayLabel}). Enviando snapshot de abertura...`,\n    );\n    const sent = await sendAlert(\n      true,\n      currentRate,\n      currentRedRate,\n      untrInvstmtVal,\n      untrRedVal,\n    );\n    if (sent) {\n      await setVal(\"last-known-rate\", currentRate.toString());\n      await setVal(\"last-known-red-rate\", currentRedRate.toString());\n      await setVal(\"last-known-inv-val\", untrInvstmtVal.toString());\n      await setVal(\"last-known-red-val\", untrRedVal.toString());\n      await setVal(\"last-run-date\", todayStr);\n    }\n    return;\n  }\n\n  // 6. Execuções seguintes: alerta somente se a taxa mudou\n  if (currentRate !== lastRate) {\n    console.log(\n      `A taxa mudou! Anterior: ${lastRate}% -> Atual: ${currentRate}%. Enviando e-mail...`,\n    );\n    const sent = await sendAlert(\n      false,\n      lastRate,\n      lastRedRate,\n      lastInvVal,\n      lastRedVal,\n    );\n    if (sent) {\n      await setVal(\"last-known-rate\", currentRate.toString());\n      await setVal(\"last-known-red-rate\", currentRedRate.toString());\n      await setVal(\"last-known-inv-val\", untrInvstmtVal.toString());\n      await setVal(\"last-known-red-val\", untrRedVal.toString());\n    }\n  } else {\n    console.log(`Taxa não se alterou (${currentRate}%). Nenhuma ação.`);\n  }\n}","createdAt",["D",1789142089891],"branchVersion","branchId","8ac61cc5-b883-456d-b6ca-99b709a6b8f5","id","cfd06c6d-7087-4b23-8f3e-8975c3515363","matheus306",["D",1781280995443],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","395d9fa1-9e1f-4dc3-99e9-fa260dd69c60","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019ebc9e-34d3-7039-9ae4-95e6bbae3263","tursoName","cfd06c6d70874b238f3e8975c3515363","tursoHostname","cfd06c6d70874b238f3e8975c3515363-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789499469860],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_104":100},"org",{"_97":96,"_98":96,"_99":100,"_18":55,"_101":102,"_103":25},"branch",{"_13":14,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","matheus","handle","displayName","avatar","https://lh3.googleusercontent.com/a/ACg8ocLif3-AgExKQic8AY_2q-kZkwvvvNk7e7PHvPyN61xChmotnPebYA=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":152,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":153,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":154,"_82":155,"_84":156,"_86":25},"tree",[147],"files",[147],"counts",{"_135":61,"_136":137,"_138":61,"_139":140,"_141":142},"contents",[126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":130,"_38":131,"_13":132,"_33":34,"_35":37,"_24":25,"_133":-5,"_27":134},"26902e74-0e41-45d9-be47-7faa53f2ce1b","parentId","latest",true,["D",1789142089891],34,"label",[28],"pulls","branches",1,"forks","envVars",{"_143":145,"_146":61},"connections",{"_143":61,"_144":61},"count","unfilledCount",6,"emptyCount",{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":130,"_38":148,"_13":132,"_33":34,"_35":37,"_24":25,"_133":-5,"_149":150,"_27":151},["D",1789142089891],"children",[],[28],["D",1781280995443],["D",1789499469860],{"_97":96,"_104":100},{"_97":96,"_98":96,"_99":100,"_18":55,"_101":102,"_103":25},{"_13":14,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"ctx",{"_80":-5,"_123":190,"_191":192,"_193":194,"_195":25,"_196":25,"_197":25,"_198":130,"_199":-5,"_200":-7,"_201":-7,"_202":61,"_203":25,"_204":25,"_205":-5,"_206":25,"_207":25,"_208":25,"_209":-5},"ENV",{"_161":162,"_163":164,"_165":87,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v35