[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_159":160,"_161":162},"routes/_app.x.$handle.$name",{"_99":98,"_32":45,"_108":89,"_27":53,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":25,"_122":123,"_124":58,"_125":-5,"_126":-5,"_127":128},"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":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",25,"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","e17ef9de-a7c2-11f1-9e2a-1607ee4eb77e","name","fileType","http","content","import { JWT } from \"npm:google-auth-library@9\";\n\nconst SPREADSHEET_ID = Deno.env.get(\"SPREADSHEET_ID\")!;\nconst WHATSAPP_ACCESS_TOKEN = Deno.env.get(\"WHATSAPP_ACCESS_TOKEN\")!;\nconst WHATSAPP_PHONE_NUMBER_ID = Deno.env.get(\"WHATSAPP_PHONE_NUMBER_ID\")!;\nconst WHATSAPP_VERIFY_TOKEN = Deno.env.get(\"WHATSAPP_VERIFY_TOKEN\")!;\n\nconst serviceAccount = JSON.parse(Deno.env.get(\"GOOGLE_SERVICE_ACCOUNT_KEY\")!);\nconst jwtClient = new JWT({\n email: serviceAccount.client_email,\n key: serviceAccount.private_key,\n scopes: [\"https://www.googleapis.com/auth/spreadsheets\"],\n});\n\n// ---------- Google Sheets helpers ----------\n\nasync function getSheetIdByName(sheetName: string): Promise {\n const data = await sheetsFetch(\"?fields=sheets.properties\");\n const sheet = data.sheets.find((s: { properties: { title: string } }) =>\n s.properties.title === sheetName\n );\n return sheet.properties.sheetId;\n}\n\nasync function deleteRow(sheetName: string, rowNumber: number) {\n const sheetId = await getSheetIdByName(sheetName);\n await sheetsFetch(\":batchUpdate\", {\n method: \"POST\",\n body: JSON.stringify({\n requests: [\n {\n deleteDimension: {\n range: {\n sheetId,\n dimension: \"ROWS\",\n startIndex: rowNumber - 1,\n endIndex: rowNumber,\n },\n },\n },\n ],\n }),\n });\n}\n\nasync function sheetsFetch(path: string, options: RequestInit = {}) {\n const token = await jwtClient.authorize();\n const res = await fetch(\n `https://sheets.googleapis.com/v4/spreadsheets/${SPREADSHEET_ID}${path}`,\n {\n ...options,\n headers: {\n ...(options.headers || {}),\n Authorization: `Bearer ${token.access_token}`,\n \"Content-Type\": \"application/json\",\n },\n },\n );\n const data = await res.json();\n if (!res.ok) {\n console.error(\n \"Erro na API do Google Sheets:\",\n res.status,\n JSON.stringify(data),\n );\n }\n return data;\n}\n\nasync function getValues(range: string) {\n const data = await sheetsFetch(`/values/${encodeURIComponent(range)}`);\n return data.values || [];\n}\n\nasync function appendRow(sheetName: string, values: (string | number)[]) {\n await sheetsFetch(\n `/values/${\n encodeURIComponent(sheetName)\n }:append?valueInputOption=USER_ENTERED`,\n {\n method: \"POST\",\n body: JSON.stringify({ values: [values] }),\n },\n );\n}\n\nasync function updateCell(\n sheetName: string,\n row: number,\n col: string,\n value: string,\n) {\n const range = `${sheetName}!${col}${row}`;\n await sheetsFetch(\n `/values/${encodeURIComponent(range)}?valueInputOption=USER_ENTERED`,\n {\n method: \"PUT\",\n body: JSON.stringify({ values: [[value]] }),\n },\n );\n}\n\n// Colunas da aba Agendamentos: A Data/Hora, B Telefone, C Etapa, D Cliente,\n// E Fornecedor, F Data pretendida, G Data confirmada, H Status, I Tipo de Coleta, J Material\nasync function findLatestRowForPhone(phone: string) {\n const rows = await getValues(\"Agendamentos!A:J\");\n for (let i = rows.length - 1; i >= 1; i--) {\n if (String(rows[i][1] || \"\").replace(/^'/, \"\").trim() === phone) {\n return {\n rowNumber: i + 1,\n etapa: rows[i][2] || \"\",\n cliente: rows[i][3] || \"\",\n };\n }\n }\n return null;\n}\n\nasync function getFornecedorForCliente(clienteName: string) {\n const rows = await getValues(\"Clientes!A:B\");\n for (let i = 1; i < rows.length; i++) {\n if (rows[i][0] === clienteName) return rows[i][1] || \"\";\n }\n return \"\";\n}\n\nasync function getCronogramaForCliente(clienteName: string) {\n const rows = await getValues(\"Cronograma!A:E\");\n console.log(\"Cronograma - linhas lidas:\", JSON.stringify(rows));\n console.log(\"Procurando cliente:\", JSON.stringify(clienteName));\n const linhas: string[] = [];\n for (let i = 1; i < rows.length; i++) {\n console.log(`Linha ${i}: cliente=\"${rows[i][0]}\" ativo=\"${rows[i][3]}\"`);\n if (rows[i][0] === clienteName && rows[i][3] !== \"Não\") {\n const dataCancelada = rows[i][4];\n const aviso = dataCancelada ? ` (⚠️ dia ${dataCancelada} cancelado)` : \"\";\n linhas.push(`• ${rows[i][1]}: ${rows[i][2]}${aviso}`);\n }\n }\n return linhas;\n}\n\nasync function getExtrasForCliente(clienteName: string) {\n const rows = await getValues(\"Agendamentos!A:J\");\n const linhas: string[] = [];\n for (let i = 1; i < rows.length; i++) {\n const cliente = rows[i][3];\n const status = rows[i][7];\n if (cliente === clienteName && status && status !== \"Cancelado\") {\n const material = rows[i][9] || \"-\";\n const data = rows[i][6] || rows[i][5] || \"a definir\";\n linhas.push(`• ${material} — data: ${data} — status: ${status}`);\n }\n }\n return linhas;\n}\n\nasync function getActiveRequestsForCliente(clienteName: string) {\n const rows = await getValues(\"Agendamentos!A:J\");\n const resultado: {\n rowNumber: number;\n material: string;\n data: string;\n status: string;\n }[] = [];\n for (let i = 1; i < rows.length; i++) {\n const cliente = rows[i][3];\n const status = rows[i][7];\n if (cliente === clienteName && status && status !== \"Cancelado\") {\n resultado.push({\n rowNumber: i + 1,\n material: rows[i][9] || \"-\",\n data: rows[i][5] || \"a definir\",\n status,\n });\n }\n }\n return resultado;\n}\n\nasync function messageAlreadyProcessed(messageId: string) {\n const rows = await getValues(\"Log!A:A\");\n return rows.some((r: string[]) => r[0] === messageId);\n}\n\n// ---------- WhatsApp helpers ----------\n\nasync function sendWhatsApp(payload: Record) {\n await fetch(\n `https://graph.facebook.com/v21.0/${WHATSAPP_PHONE_NUMBER_ID}/messages`,\n {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n Authorization: `Bearer ${WHATSAPP_ACCESS_TOKEN}`,\n },\n body: JSON.stringify(payload),\n },\n );\n}\n\nfunction sendMainMenu(to: string) {\n return sendWhatsApp({\n messaging_product: \"whatsapp\",\n to,\n type: \"interactive\",\n interactive: {\n type: \"list\",\n header: { type: \"text\", text: \"Central de Coletas\" },\n body: { text: \"Olá! Como posso te ajudar hoje?\" },\n footer: { text: \"Toque para ver as opções\" },\n action: {\n button: \"Ver opções\",\n sections: [\n {\n title: \"Menu principal\",\n rows: [\n { id: \"menu_extra\", title: \"🚚 Coleta Extra\" },\n { id: \"menu_ver_programadas\", title: \"📅 Ver Programadas\" },\n { id: \"menu_cancelar\", title: \"❌ Cancelar Coleta\" },\n ],\n },\n ],\n },\n },\n });\n}\n\nasync function sendClienteList(to: string) {\n const rows = await getValues(\"Clientes!A:A\");\n const nomes = rows.slice(1).map((r: string[]) => r[0]).filter(Boolean);\n const linhas = nomes.map((nome: string, i: number) => `${i + 1}. ${nome}`)\n .join(\"\\n\");\n await sendText(\n to,\n `Perfeito! Digite o número da sua unidade/cliente:\\n\\n${linhas}`,\n );\n}\n\nasync function getClienteByNumero(numeroTexto: string): Promise {\n const rows = await getValues(\"Clientes!A:A\");\n const nomes = rows.slice(1).map((r: string[]) => r[0]).filter(Boolean);\n const idx = parseInt((numeroTexto || \"\").trim(), 10) - 1;\n if (isNaN(idx) || idx < 0 || idx >= nomes.length) return null;\n return nomes[idx];\n}\n\nfunction sendMaterialList(to: string) {\n return sendWhatsApp({\n messaging_product: \"whatsapp\",\n to,\n type: \"interactive\",\n interactive: {\n type: \"list\",\n body: {\n text:\n \"Entendido. Agora selecione o principal tipo de material a ser recolhido:\",\n },\n action: {\n button: \"Selecionar material\",\n sections: [\n {\n title: \"Materiais\",\n rows: [\n { id: \"papel\", title: \"📄 Papel/Papelão\" },\n { id: \"plastico\", title: \"🧴 Plástico\" },\n { id: \"metal\", title: \"⚙️ Sucata Metálica\" },\n { id: \"madeira\", title: \"🪵 Madeira/Pallets\" },\n { id: \"rejeito\", title: \"🧹 Resíduo Geral\" },\n ],\n },\n ],\n },\n },\n });\n}\n\nfunction sendText(to: string, body: string) {\n return sendWhatsApp({\n messaging_product: \"whatsapp\",\n to,\n type: \"text\",\n text: { body },\n });\n}\n\n// ---------- Webhook principal ----------\n\nexport default async function (req: Request): Promise {\n if (req.method === \"GET\") {\n const url = new URL(req.url);\n const mode = url.searchParams.get(\"hub.mode\");\n const token = url.searchParams.get(\"hub.verify_token\");\n const challenge = url.searchParams.get(\"hub.challenge\");\n if (mode === \"subscribe\" && token === WHATSAPP_VERIFY_TOKEN) {\n return new Response(challenge ?? \"\", {\n status: 200,\n headers: { \"Content-Type\": \"text/plain\" },\n });\n }\n return new Response(\"Forbidden\", { status: 403 });\n }\n\n if (req.method !== \"POST\") {\n return new Response(\"Method Not Allowed\", { status: 405 });\n }\n\n try {\n const body = await req.json();\n const message = body?.entry?.[0]?.changes?.[0]?.value?.messages?.[0];\n\n // Ignora notificações de status (entregue/lida) e qualquer coisa sem mensagem de verdade\n if (!message?.from) {\n return new Response(\"OK\", { status: 200 });\n }\n\n const from = message.from as string;\n const messageId = message.id as string;\n\n // Deduplicação\n if (await messageAlreadyProcessed(messageId)) {\n return new Response(\"OK\", { status: 200 });\n }\n await appendRow(\"Log\", [messageId]);\n\n // Extrai o conteúdo relevante, dependendo do tipo de resposta\n const listReplyId = message.interactive?.list_reply?.id as\n | string\n | undefined;\n const listReplyTitle = message.interactive?.list_reply?.title as\n | string\n | undefined;\n const buttonReplyTitle = message.interactive?.button_reply?.title as\n | string\n | undefined;\n const textBody = message.text?.body as string | undefined;\n\n const existing = await findLatestRowForPhone(from);\n const etapa = existing?.etapa || \"\";\n\n if (!existing || etapa === \"concluída\") {\n const now = new Date().toISOString();\n await appendRow(\"Agendamentos\", [now, \"'\" + from, \"aguardando_menu\"]);\n await sendMainMenu(from);\n } else if (etapa === \"aguardando_menu\") {\n const row = existing.rowNumber;\n if (listReplyId === \"menu_extra\") {\n await updateCell(\"Agendamentos\", row, \"C\", \"aguardando_cliente\");\n await sendClienteList(from);\n } else if (listReplyId === \"menu_ver_programadas\") {\n await updateCell(\n \"Agendamentos\",\n row,\n \"C\",\n \"aguardando_cliente_programadas\",\n );\n await sendClienteList(from);\n } else if (listReplyId === \"menu_cancelar\") {\n await updateCell(\n \"Agendamentos\",\n row,\n \"C\",\n \"aguardando_cliente_cancelar\",\n );\n await sendClienteList(from);\n }\n } else if (etapa === \"aguardando_cliente\") {\n const row = existing.rowNumber;\n const cliente = await getClienteByNumero(textBody || \"\");\n if (!cliente) {\n await sendText(\n from,\n \"Não entendi. Digite só o número da unidade, como mostrado na lista.\",\n );\n } else {\n const fornecedor = await getFornecedorForCliente(cliente);\n await updateCell(\"Agendamentos\", row, \"D\", cliente);\n await updateCell(\"Agendamentos\", row, \"E\", fornecedor);\n await updateCell(\"Agendamentos\", row, \"I\", \"Coleta Extra\");\n await updateCell(\"Agendamentos\", row, \"C\", \"aguardando_material\");\n await sendMaterialList(from);\n }\n } else if (etapa === \"aguardando_cliente_programadas\") {\n const row = existing.rowNumber;\n const cliente = await getClienteByNumero(textBody || \"\");\n if (!cliente) {\n await sendText(\n from,\n \"Não entendi. Digite só o número da unidade, como mostrado na lista.\",\n );\n return new Response(\"OK\", { status: 200 });\n }\n const fixas = await getCronogramaForCliente(cliente);\n const extras = await getExtrasForCliente(cliente);\n\n let texto = `📋 Coletas de *${cliente}*:\\n\\n`;\n texto += \"📅 Fixas (semanais):\\n\";\n texto += fixas.length\n ? fixas.join(\"\\n\")\n : \"Nenhuma coleta fixa cadastrada.\";\n texto += \"\\n\\n🚚 Extras solicitadas:\\n\";\n texto += extras.length\n ? extras.join(\"\\n\")\n : \"Nenhuma coleta extra em aberto.\";\n\n await sendText(from, texto);\n await deleteRow(\"Agendamentos\", row);\n } else if (etapa === \"aguardando_cliente_cancelar\") {\n const row = existing.rowNumber;\n const cliente = await getClienteByNumero(textBody || \"\");\n if (!cliente) {\n await sendText(\n from,\n \"Não entendi. Digite só o número da unidade, como mostrado na lista.\",\n );\n return new Response(\"OK\", { status: 200 });\n }\n const ativos = await getActiveRequestsForCliente(cliente);\n if (ativos.length === 0) {\n await sendText(\n from,\n `Não encontrei nenhuma coleta ativa para *${cliente}* pra cancelar.`,\n );\n await deleteRow(\"Agendamentos\", row);\n } else {\n const linhas = ativos\n .map((a, i) =>\n `${i + 1}. ${a.material} — data: ${a.data} — status: ${a.status}`\n )\n .join(\"\\n\");\n await updateCell(\"Agendamentos\", row, \"D\", cliente);\n await updateCell(\n \"Agendamentos\",\n row,\n \"C\",\n \"aguardando_escolha_cancelamento\",\n );\n await sendText(\n from,\n `Qual coleta você quer cancelar? Digite o número:\\n\\n${linhas}`,\n );\n }\n } else if (etapa === \"aguardando_escolha_cancelamento\") {\n const row = existing.rowNumber;\n const cliente = existing.cliente || \"\";\n const extras = await getActiveRequestsForCliente(cliente);\n const programadas = await getActiveCronogramaForCliente(cliente);\n const idx = parseInt((textBody || \"\").trim(), 10) - 1;\n\n if (isNaN(idx) || idx < 0 || idx >= extras.length + programadas.length) {\n await sendText(\n from,\n \"Não entendi. Digite só o número da coleta que quer cancelar.\",\n );\n return new Response(\"OK\", { status: 200 });\n }\n\n if (idx < extras.length) {\n const alvo = extras[idx];\n await updateCell(\"Agendamentos\", alvo.rowNumber, \"H\", \"Cancelado\");\n await deleteRow(\"Agendamentos\", row);\n await sendText(\n from,\n `Prontinho! A coleta extra de *${alvo.material}* (${alvo.data}) foi cancelada.`,\n );\n } else {\n const alvo = programadas[idx - extras.length];\n const data = proximaData(alvo.dia);\n await updateCell(\"Cronograma\", alvo.rowNumber, \"E\", data);\n await deleteRow(\"Agendamentos\", row);\n await sendText(\n from,\n `Prontinho! A coleta programada de ${alvo.dia} (${alvo.material}) do dia ${data} foi cancelada. As próximas semanas continuam programadas normalmente.`,\n );\n }\n } else if (etapa === \"aguardando_material\") {\n const row = existing.rowNumber;\n await updateCell(\"Agendamentos\", row, \"J\", listReplyTitle || \"\");\n await updateCell(\"Agendamentos\", row, \"C\", \"aguardando_data\");\n await sendText(\n from,\n \"Última etapa: me diga a data pretendida para a coleta (ex: 15/09).\",\n );\n } else if (etapa === \"aguardando_data\") {\n const row = existing.rowNumber;\n const texto = textBody || \"\";\n if (/^\\d{1,2}\\/\\d{1,2}(\\/\\d{2,4})?$/.test(texto.trim())) {\n await updateCell(\"Agendamentos\", row, \"F\", texto);\n await updateCell(\"Agendamentos\", row, \"H\", \"Solicitado\");\n await updateCell(\"Agendamentos\", row, \"C\", \"concluída\");\n await sendText(\n from,\n \"Prontinho! Recebemos sua solicitação de coleta e nossa equipe vai confirmar a data com o fornecedor. Assim que tivermos a confirmação, te avisamos por aqui!\",\n );\n } else {\n await sendText(\n from,\n \"Não entendi essa data 😕 Pode mandar de novo no formato dia/mês? Exemplo: 15/09\",\n );\n }\n }\n\n return new Response(\"OK\", { status: 200 });\n } catch (err) {\n console.error(\"Erro no webhook:\", err);\n return new Response(\"Erro interno, mas confirmando recebimento\", {\n status: 200,\n });\n }\n}","import { JWT } from \"npm:google-auth-library@9\";\n\nconst SPREADSHEET_ID = Deno.env.get(\"SPREADSHEET_ID\")!;\nconst WHATSAPP_ACCESS_TOKEN = Deno.env.get(\"WHATSAPP_ACCESS_TOKEN\")!;\nconst WHATSAPP_PHONE_NUMBER_ID = Deno.env.get(\"WHATSAPP_PHONE_NUMBER_ID\")!;\nconst WHATSAPP_VERIFY_TOKEN = Deno.env.get(\"WHATSAPP_VERIFY_TOKEN\")!;\n\nconst serviceAccount = JSON.parse(Deno.env.get(\"GOOGLE_SERVICE_ACCOUNT_KEY\")!);\nconst jwtClient = new JWT({\n email: serviceAccount.client_email,\n key: serviceAccount.private_key,\n scopes: [\"https://www.googleapis.com/auth/spreadsheets\"],\n});\n\n// ---------- Google Sheets helpers ----------\n\nasync function getSheetIdByName(sheetName: string): Promise {\n const data = await sheetsFetch(\"?fields=sheets.properties\");\n const sheet = data.sheets.find((s: { properties: { title: string } }) =>\n s.properties.title === sheetName\n );\n return sheet.properties.sheetId;\n}\n\nasync function getActiveCronogramaForCliente(clienteName: string) {\n const rows = await getValues(\"Cronograma!A:E\");\n console.log(\"getActiveCronograma - procurando:\", JSON.stringify(clienteName));\n console.log(\"getActiveCronograma - linhas:\", JSON.stringify(rows));\n const resultado: { rowNumber: number; dia: string; material: string }[] = [];\n for (let i = 1; i < rows.length; i++) {\n if (rows[i][0] === clienteName && rows[i][3] !== \"Não\") {\n resultado.push({\n rowNumber: i + 1,\n dia: rows[i][1],\n material: rows[i][2],\n });\n }\n }\n console.log(\"getActiveCronograma - resultado:\", JSON.stringify(resultado));\n return resultado;\n}\n\nasync function deleteRow(sheetName: string, rowNumber: number) {\n const sheetId = await getSheetIdByName(sheetName);\n await sheetsFetch(\":batchUpdate\", {\n method: \"POST\",\n body: JSON.stringify({\n requests: [\n {\n deleteDimension: {\n range: {\n sheetId,\n dimension: \"ROWS\",\n startIndex: rowNumber - 1,\n endIndex: rowNumber,\n },\n },\n },\n ],\n }),\n });\n}\n\nasync function sheetsFetch(path: string, options: RequestInit = {}) {\n const token = await jwtClient.authorize();\n const res = await fetch(\n `https://sheets.googleapis.com/v4/spreadsheets/${SPREADSHEET_ID}${path}`,\n {\n ...options,\n headers: {\n ...(options.headers || {}),\n Authorization: `Bearer ${token.access_token}`,\n \"Content-Type\": \"application/json\",\n },\n },\n );\n const data = await res.json();\n if (!res.ok) {\n console.error(\n \"Erro na API do Google Sheets:\",\n res.status,\n JSON.stringify(data),\n );\n }\n return data;\n}\n\nasync function getValues(range: string) {\n const data = await sheetsFetch(`/values/${encodeURIComponent(range)}`);\n return data.values || [];\n}\n\nasync function appendRow(sheetName: string, values: (string | number)[]) {\n await sheetsFetch(\n `/values/${\n encodeURIComponent(sheetName)\n }:append?valueInputOption=USER_ENTERED`,\n {\n method: \"POST\",\n body: JSON.stringify({ values: [values] }),\n },\n );\n}\n\nasync function updateCell(\n sheetName: string,\n row: number,\n col: string,\n value: string,\n) {\n const range = `${sheetName}!${col}${row}`;\n await sheetsFetch(\n `/values/${encodeURIComponent(range)}?valueInputOption=USER_ENTERED`,\n {\n method: \"PUT\",\n body: JSON.stringify({ values: [[value]] }),\n },\n );\n}\n\n// Colunas da aba Agendamentos: A Data/Hora, B Telefone, C Etapa, D Cliente,\n// E Fornecedor, F Data pretendida, G Data confirmada, H Status, I Tipo de Coleta, J Material\nasync function findLatestRowForPhone(phone: string) {\n const rows = await getValues(\"Agendamentos!A:J\");\n for (let i = rows.length - 1; i >= 1; i--) {\n if (String(rows[i][1] || \"\").replace(/^'/, \"\").trim() === phone) {\n return {\n rowNumber: i + 1,\n etapa: rows[i][2] || \"\",\n cliente: rows[i][3] || \"\",\n };\n }\n }\n return null;\n}\n\nasync function getFornecedorForCliente(clienteName: string) {\n const rows = await getValues(\"Clientes!A:B\");\n for (let i = 1; i < rows.length; i++) {\n if (rows[i][0] === clienteName) return rows[i][1] || \"\";\n }\n return \"\";\n}\n\nasync function getCronogramaForCliente(clienteName: string) {\n const rows = await getValues(\"Cronograma!A:E\");\n console.log(\"Cronograma - linhas lidas:\", JSON.stringify(rows));\n console.log(\"Procurando cliente:\", JSON.stringify(clienteName));\n const linhas: string[] = [];\n for (let i = 1; i < rows.length; i++) {\n console.log(`Linha ${i}: cliente=\"${rows[i][0]}\" ativo=\"${rows[i][3]}\"`);\n if (rows[i][0] === clienteName && rows[i][3] !== \"Não\") {\n const dataCancelada = rows[i][4];\n const aviso = dataCancelada ? ` (⚠️ dia ${dataCancelada} cancelado)` : \"\";\n linhas.push(`• ${rows[i][1]}: ${rows[i][2]}${aviso}`);\n }\n }\n return linhas;\n}\n\nasync function getExtrasForCliente(clienteName: string) {\n const rows = await getValues(\"Agendamentos!A:J\");\n const linhas: string[] = [];\n for (let i = 1; i < rows.length; i++) {\n const cliente = rows[i][3];\n const status = rows[i][7];\n if (cliente === clienteName && status && status !== \"Cancelado\") {\n const material = rows[i][9] || \"-\";\n const data = rows[i][6] || rows[i][5] || \"a definir\";\n linhas.push(`• ${material} — data: ${data} — status: ${status}`);\n }\n }\n return linhas;\n}\n\nasync function getActiveRequestsForCliente(clienteName: string) {\n const rows = await getValues(\"Agendamentos!A:J\");\n const resultado: {\n rowNumber: number;\n material: string;\n data: string;\n status: string;\n }[] = [];\n for (let i = 1; i < rows.length; i++) {\n const cliente = rows[i][3];\n const status = rows[i][7];\n if (cliente === clienteName && status && status !== \"Cancelado\") {\n resultado.push({\n rowNumber: i + 1,\n material: rows[i][9] || \"-\",\n data: rows[i][5] || \"a definir\",\n status,\n });\n }\n }\n return resultado;\n}\n\nasync function messageAlreadyProcessed(messageId: string) {\n const rows = await getValues(\"Log!A:A\");\n return rows.some((r: string[]) => r[0] === messageId);\n}\n\n// ---------- WhatsApp helpers ----------\n\nasync function sendWhatsApp(payload: Record) {\n await fetch(\n `https://graph.facebook.com/v21.0/${WHATSAPP_PHONE_NUMBER_ID}/messages`,\n {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n Authorization: `Bearer ${WHATSAPP_ACCESS_TOKEN}`,\n },\n body: JSON.stringify(payload),\n },\n );\n}\n\nfunction sendMainMenu(to: string) {\n return sendWhatsApp({\n messaging_product: \"whatsapp\",\n to,\n type: \"interactive\",\n interactive: {\n type: \"list\",\n header: { type: \"text\", text: \"Central de Coletas\" },\n body: { text: \"Olá! Como posso te ajudar hoje?\" },\n footer: { text: \"Toque para ver as opções\" },\n action: {\n button: \"Ver opções\",\n sections: [\n {\n title: \"Menu principal\",\n rows: [\n { id: \"menu_extra\", title: \"🚚 Coleta Extra\" },\n { id: \"menu_ver_programadas\", title: \"📅 Ver Programadas\" },\n { id: \"menu_cancelar\", title: \"❌ Cancelar Coleta\" },\n ],\n },\n ],\n },\n },\n });\n}\n\nasync function sendClienteList(to: string) {\n const rows = await getValues(\"Clientes!A:A\");\n const nomes = rows.slice(1).map((r: string[]) => r[0]).filter(Boolean);\n const linhas = nomes.map((nome: string, i: number) => `${i + 1}. ${nome}`)\n .join(\"\\n\");\n await sendText(\n to,\n `Perfeito! Digite o número da sua unidade/cliente:\\n\\n${linhas}`,\n );\n}\n\nasync function getClienteByNumero(numeroTexto: string): Promise {\n const rows = await getValues(\"Clientes!A:A\");\n const nomes = rows.slice(1).map((r: string[]) => r[0]).filter(Boolean);\n const idx = parseInt((numeroTexto || \"\").trim(), 10) - 1;\n if (isNaN(idx) || idx < 0 || idx >= nomes.length) return null;\n return nomes[idx];\n}\n\nfunction sendMaterialList(to: string) {\n return sendWhatsApp({\n messaging_product: \"whatsapp\",\n to,\n type: \"interactive\",\n interactive: {\n type: \"list\",\n body: {\n text:\n \"Entendido. Agora selecione o principal tipo de material a ser recolhido:\",\n },\n action: {\n button: \"Selecionar material\",\n sections: [\n {\n title: \"Materiais\",\n rows: [\n { id: \"papel\", title: \"📄 Papel/Papelão\" },\n { id: \"plastico\", title: \"🧴 Plástico\" },\n { id: \"metal\", title: \"⚙️ Sucata Metálica\" },\n { id: \"madeira\", title: \"🪵 Madeira/Pallets\" },\n { id: \"rejeito\", title: \"🧹 Resíduo Geral\" },\n ],\n },\n ],\n },\n },\n });\n}\n\nfunction sendText(to: string, body: string) {\n return sendWhatsApp({\n messaging_product: \"whatsapp\",\n to,\n type: \"text\",\n text: { body },\n });\n}\n\n// ---------- Webhook principal ----------\n\nexport default async function (req: Request): Promise {\n if (req.method === \"GET\") {\n const url = new URL(req.url);\n const mode = url.searchParams.get(\"hub.mode\");\n const token = url.searchParams.get(\"hub.verify_token\");\n const challenge = url.searchParams.get(\"hub.challenge\");\n if (mode === \"subscribe\" && token === WHATSAPP_VERIFY_TOKEN) {\n return new Response(challenge ?? \"\", {\n status: 200,\n headers: { \"Content-Type\": \"text/plain\" },\n });\n }\n return new Response(\"Forbidden\", { status: 403 });\n }\n\n if (req.method !== \"POST\") {\n return new Response(\"Method Not Allowed\", { status: 405 });\n }\n\n try {\n const body = await req.json();\n const message = body?.entry?.[0]?.changes?.[0]?.value?.messages?.[0];\n\n // Ignora notificações de status (entregue/lida) e qualquer coisa sem mensagem de verdade\n if (!message?.from) {\n return new Response(\"OK\", { status: 200 });\n }\n\n const from = message.from as string;\n const messageId = message.id as string;\n\n // Deduplicação\n if (await messageAlreadyProcessed(messageId)) {\n return new Response(\"OK\", { status: 200 });\n }\n await appendRow(\"Log\", [messageId]);\n\n // Extrai o conteúdo relevante, dependendo do tipo de resposta\n const listReplyId = message.interactive?.list_reply?.id as\n | string\n | undefined;\n const listReplyTitle = message.interactive?.list_reply?.title as\n | string\n | undefined;\n const buttonReplyTitle = message.interactive?.button_reply?.title as\n | string\n | undefined;\n const textBody = message.text?.body as string | undefined;\n\n const existing = await findLatestRowForPhone(from);\n const etapa = existing?.etapa || \"\";\n\n if (!existing || etapa === \"concluída\") {\n const now = new Date().toISOString();\n await appendRow(\"Agendamentos\", [now, \"'\" + from, \"aguardando_menu\"]);\n await sendMainMenu(from);\n } else if (etapa === \"aguardando_menu\") {\n const row = existing.rowNumber;\n if (listReplyId === \"menu_extra\") {\n await updateCell(\"Agendamentos\", row, \"C\", \"aguardando_cliente\");\n await sendClienteList(from);\n } else if (listReplyId === \"menu_ver_programadas\") {\n await updateCell(\n \"Agendamentos\",\n row,\n \"C\",\n \"aguardando_cliente_programadas\",\n );\n await sendClienteList(from);\n } else if (listReplyId === \"menu_cancelar\") {\n await updateCell(\n \"Agendamentos\",\n row,\n \"C\",\n \"aguardando_cliente_cancelar\",\n );\n await sendClienteList(from);\n }\n } else if (etapa === \"aguardando_cliente\") {\n const row = existing.rowNumber;\n const cliente = await getClienteByNumero(textBody || \"\");\n if (!cliente) {\n await sendText(\n from,\n \"Não entendi. Digite só o número da unidade, como mostrado na lista.\",\n );\n } else {\n const fornecedor = await getFornecedorForCliente(cliente);\n await updateCell(\"Agendamentos\", row, \"D\", cliente);\n await updateCell(\"Agendamentos\", row, \"E\", fornecedor);\n await updateCell(\"Agendamentos\", row, \"I\", \"Coleta Extra\");\n await updateCell(\"Agendamentos\", row, \"C\", \"aguardando_material\");\n await sendMaterialList(from);\n }\n } else if (etapa === \"aguardando_cliente_programadas\") {\n const row = existing.rowNumber;\n const cliente = await getClienteByNumero(textBody || \"\");\n if (!cliente) {\n await sendText(\n from,\n \"Não entendi. Digite só o número da unidade, como mostrado na lista.\",\n );\n return new Response(\"OK\", { status: 200 });\n }\n const fixas = await getCronogramaForCliente(cliente);\n const extras = await getExtrasForCliente(cliente);\n\n let texto = `📋 Coletas de *${cliente}*:\\n\\n`;\n texto += \"📅 Fixas (semanais):\\n\";\n texto += fixas.length\n ? fixas.join(\"\\n\")\n : \"Nenhuma coleta fixa cadastrada.\";\n texto += \"\\n\\n🚚 Extras solicitadas:\\n\";\n texto += extras.length\n ? extras.join(\"\\n\")\n : \"Nenhuma coleta extra em aberto.\";\n\n await sendText(from, texto);\n await deleteRow(\"Agendamentos\", row);\n } else if (etapa === \"aguardando_cliente_cancelar\") {\n const row = existing.rowNumber;\n const cliente = await getClienteByNumero(textBody || \"\");\n if (!cliente) {\n await sendText(\n from,\n \"Não entendi. Digite só o número da unidade, como mostrado na lista.\",\n );\n return new Response(\"OK\", { status: 200 });\n }\n const ativos = await getActiveRequestsForCliente(cliente);\n if (ativos.length === 0) {\n await sendText(\n from,\n `Não encontrei nenhuma coleta ativa para *${cliente}* pra cancelar.`,\n );\n await deleteRow(\"Agendamentos\", row);\n } else {\n const linhas = ativos\n .map((a, i) =>\n `${i + 1}. ${a.material} — data: ${a.data} — status: ${a.status}`\n )\n .join(\"\\n\");\n await updateCell(\"Agendamentos\", row, \"D\", cliente);\n await updateCell(\n \"Agendamentos\",\n row,\n \"C\",\n \"aguardando_escolha_cancelamento\",\n );\n await sendText(\n from,\n `Qual coleta você quer cancelar? Digite o número:\\n\\n${linhas}`,\n );\n }\n } else if (etapa === \"aguardando_escolha_cancelamento\") {\n const row = existing.rowNumber;\n const cliente = existing.cliente || \"\";\n const extras = await getActiveRequestsForCliente(cliente);\n const programadas = await getActiveCronogramaForCliente(cliente);\n const idx = parseInt((textBody || \"\").trim(), 10) - 1;\n\n if (isNaN(idx) || idx < 0 || idx >= extras.length + programadas.length) {\n await sendText(\n from,\n \"Não entendi. Digite só o número da coleta que quer cancelar.\",\n );\n return new Response(\"OK\", { status: 200 });\n }\n\n if (idx < extras.length) {\n const alvo = extras[idx];\n await updateCell(\"Agendamentos\", alvo.rowNumber, \"H\", \"Cancelado\");\n await deleteRow(\"Agendamentos\", row);\n await sendText(\n from,\n `Prontinho! A coleta extra de *${alvo.material}* (${alvo.data}) foi cancelada.`,\n );\n } else {\n const alvo = programadas[idx - extras.length];\n const data = proximaData(alvo.dia);\n await updateCell(\"Cronograma\", alvo.rowNumber, \"E\", data);\n await deleteRow(\"Agendamentos\", row);\n await sendText(\n from,\n `Prontinho! A coleta programada de ${alvo.dia} (${alvo.material}) do dia ${data} foi cancelada. As próximas semanas continuam programadas normalmente.`,\n );\n }\n } else if (etapa === \"aguardando_material\") {\n const row = existing.rowNumber;\n await updateCell(\"Agendamentos\", row, \"J\", listReplyTitle || \"\");\n await updateCell(\"Agendamentos\", row, \"C\", \"aguardando_data\");\n await sendText(\n from,\n \"Última etapa: me diga a data pretendida para a coleta (ex: 15/09).\",\n );\n } else if (etapa === \"aguardando_data\") {\n const row = existing.rowNumber;\n const texto = textBody || \"\";\n if (/^\\d{1,2}\\/\\d{1,2}(\\/\\d{2,4})?$/.test(texto.trim())) {\n await updateCell(\"Agendamentos\", row, \"F\", texto);\n await updateCell(\"Agendamentos\", row, \"H\", \"Solicitado\");\n await updateCell(\"Agendamentos\", row, \"C\", \"concluída\");\n await sendText(\n from,\n \"Prontinho! Recebemos sua solicitação de coleta e nossa equipe vai confirmar a data com o fornecedor. Assim que tivermos a confirmação, te avisamos por aqui!\",\n );\n } else {\n await sendText(\n from,\n \"Não entendi essa data 😕 Pode mandar de novo no formato dia/mês? Exemplo: 15/09\",\n );\n }\n }\n\n return new Response(\"OK\", { status: 200 });\n } catch (err) {\n console.error(\"Erro no webhook:\", err);\n return new Response(\"Erro interno, mas confirmando recebimento\", {\n status: 200,\n });\n }\n}","createdAt",["D",1789418373981],"branchVersion","branchId","64baa4d8-4625-4d57-9b35-5d2a2b4f3eb8","id","cc432ec9-8b28-4901-bcb8-0c309a877cb8","teste",["D",1788459087365],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","7a9b14fb-5434-4708-95bc-70d1677dec71","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a06876-6500-703a-8dd7-d8fb51364f39","tursoName","cc432ec98b284901bcb80c309a877cb8","tursoHostname","cc432ec98b284901bcb80c309a877cb8-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789501878689],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":55,"_104":105,"_106":25},"branch",{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"isOwned",29,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","gustavoteixeira","handle","displayName","GUSTAVO TEIXEIRA","avatar","https://lh3.googleusercontent.com/a/ACg8ocLRyaRj-8_CCO-4h557BVGQygbhfqFC_gqdtyUrP5mzGzxRWQ=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":154,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":155,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":156,"_83":157,"_85":158,"_87":25},"tree",[149],"files",[149],"counts",{"_137":62,"_138":139,"_140":62,"_141":142,"_143":144},"contents",[129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":25,"_38":133,"_13":134,"_33":34,"_35":37,"_24":25,"_135":-5,"_27":136},"488ccc33-8cf6-41a1-b1e5-61b4d898decc","parentId","latest",["D",1789418373981],24,"label",[28],"pulls","branches",1,"forks","envVars",{"_145":147,"_148":62},"connections",{"_145":62,"_146":62},"count","unfilledCount",6,"emptyCount",{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":25,"_38":150,"_13":134,"_33":34,"_35":37,"_24":25,"_135":-5,"_151":152,"_27":153},["D",1789418373981],"children",[],[28],["D",1788459087365],["D",1789501878689],{"_99":98,"_107":103},{"_99":98,"_100":101,"_102":103,"_18":55,"_104":105,"_106":25},{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"ctx",{"_81":-5,"_126":192,"_193":194,"_195":196,"_197":25,"_198":25,"_199":25,"_200":58,"_201":-5,"_202":-7,"_203":-7,"_204":62,"_205":25,"_206":25,"_207":-5,"_208":25,"_209":25,"_210":25,"_211":-5},"ENV",{"_163":164,"_165":166,"_167":89,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191},"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 · v25