[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_149":150,"_151":152},"routes/_app.x.$handle.$name",{"_16":17,"_20":21,"_88":70,"_89":31,"_68":-7,"_90":-5,"_13":91,"_92":93,"_11":94,"_95":96,"_97":98,"_99":-5,"_100":-5,"_101":-5,"_102":26,"_103":104,"_105":38,"_106":-5,"_107":-5,"_108":109},"routes/_app.x.$handle.$name.search.$(branch)",{"_11":12,"_13":14,"_15":-5,"_16":17},"files",[],"project",{"_18":19,"_20":21,"_22":23,"_24":-5,"_25":26,"_27":28,"_29":28,"_30":31,"_32":-5,"_33":34,"_35":36,"_37":38,"_39":-5,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":-5,"_52":53,"_54":53,"_55":56,"_57":56,"_58":56,"_59":53,"_60":53,"_61":62,"_63":64,"_65":66,"_67":26},"query","handle","gustavoteixeira","id","cc432ec9-8b28-4901-bcb8-0c309a877cb8","name","teste","createdAt",["D",1788459087365],"deletedAt","legacyEnvVars",false,"privacy","public","httpPrivacy","description","","imageUrl","userId","7a9b14fb-5434-4708-95bc-70d1677dec71","pinnedFileId","e17ef9de-a7c2-11f1-9e2a-1607ee4eb77e","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",{"_16":17,"_87":83},"org",{"_16":17,"_80":81,"_82":83,"_33":34,"_84":85,"_86":26},"branch",{"_68":69,"_20":70,"_18":71,"_72":19,"_73":-5,"_74":-5,"_75":-5,"_76":-5,"_77":-5,"_78":21,"_79":17},"isOwned","version",33,"main","64baa4d8-4625-4d57-9b35-5d2a2b4f3eb8","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","GUSTAVO TEIXEIRA","avatar","https://lh3.googleusercontent.com/a/ACg8ocLRyaRj-8_CCO-4h557BVGQygbhfqFC_gqdtyUrP5mzGzxRWQ=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","path","adoptOrgId",{"_18":19,"_20":21,"_22":144,"_24":-5,"_25":26,"_27":28,"_29":28,"_30":31,"_32":-5,"_33":34,"_35":36,"_37":38,"_39":-5,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":48,"_49":145,"_51":-5,"_52":53,"_54":53,"_55":56,"_57":56,"_58":56,"_59":53,"_60":53,"_61":146,"_63":147,"_65":148,"_67":26},"tree",[139],[139],"counts",{"_127":42,"_128":129,"_130":42,"_131":132,"_133":134},"contents",[110],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_18":111,"_20":112,"_113":36,"_114":-5,"_115":71,"_116":69,"_117":38,"_22":118,"_68":119,"_120":121,"_122":123,"_124":26,"_125":-5,"_89":126},"8144b386-7aa4-4866-bc1e-a9f2a1bb301c","main.ts","fileId","parentId","branchId","branchVersion","latest",["D",1789570478983],30,"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\")!;\nconst DRIVE_FOLDER_ID = Deno.env.get(\"DRIVE_FOLDER_ID\")!;\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: [\n \"https://www.googleapis.com/auth/spreadsheets\",\n \"https://www.googleapis.com/auth/drive.file\",\n ],\n});\n\n// ---------- Google Sheets helpers ----------\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\nasync function getSheetIdByName(sheetName: string): Promise {\n const data = await sheetsFetch(\"?fields=sheets.properties\");\n const sheet = data.sheets.find(\n (s: { properties: { title: string } }) => 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\n// Colunas da aba Agendamentos: A Data/Hora, B Telefone, C Etapa, D Cliente\n// (em linhas de motorista, guarda temporariamente o nº da linha-alvo), E Fornecedor,\n// F Data pretendida, G Data confirmada, H Status, I Tipo de Coleta, J Material, K Comprovante\nasync function findLatestRowForPhone(phone: string) {\n const rows = await getValues(\"Agendamentos!A:K\");\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 getClienteByCNPJ(cnpjTexto: string): Promise {\n const limpo = (cnpjTexto || \"\").replace(/\\D/g, \"\");\n if (!limpo) return null;\n const rows = await getValues(\"Clientes!A:D\");\n for (let i = 1; i < rows.length; i++) {\n const cnpjPlanilha = String(rows[i][3] || \"\").replace(/\\D/g, \"\");\n if (cnpjPlanilha && cnpjPlanilha === limpo) return rows[i][0];\n }\n return null;\n}\n\nasync function getCronogramaForCliente(clienteName: string) {\n const rows = await getValues(\"Cronograma!A:E\");\n const linhas: string[] = [];\n for (let i = 1; i < rows.length; i++) {\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 getActiveCronogramaForCliente(clienteName: string) {\n const rows = await getValues(\"Cronograma!A:E\");\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 return resultado;\n}\n\nasync function getExtrasForCliente(clienteName: string) {\n const rows = await getValues(\"Agendamentos!A:K\");\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:K\");\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\nfunction proximaData(diaSemana: string): string {\n const dias: Record = {\n \"domingo\": 0,\n \"segunda-feira\": 1,\n \"terça-feira\": 2,\n \"quarta-feira\": 3,\n \"quinta-feira\": 4,\n \"sexta-feira\": 5,\n \"sábado\": 6,\n };\n const alvo = dias[diaSemana.toLowerCase().trim()];\n if (alvo === undefined) return \"data não identificada\";\n const hoje = new Date();\n const diasParaSomar = (alvo - hoje.getDay() + 7) % 7;\n const proxima = new Date(hoje);\n proxima.setDate(hoje.getDate() + diasParaSomar);\n return proxima.toLocaleDateString(\"pt-BR\");\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 media + Google Drive ----------\n\nasync function downloadWhatsAppMedia(\n mediaId: string,\n): Promise<{ bytes: Uint8Array; mimeType: string }> {\n const metaRes = await fetch(`https://graph.facebook.com/v21.0/${mediaId}`, {\n headers: { Authorization: `Bearer ${WHATSAPP_ACCESS_TOKEN}` },\n });\n const meta = await metaRes.json();\n if (!meta.url) {\n console.error(\n \"downloadWhatsAppMedia: resposta sem url:\",\n JSON.stringify(meta),\n );\n throw new Error(\n \"Não consegui obter a URL da mídia da Meta: \" + JSON.stringify(meta),\n );\n }\n const fileRes = await fetch(meta.url, {\n headers: { Authorization: `Bearer ${WHATSAPP_ACCESS_TOKEN}` },\n });\n if (!fileRes.ok) {\n throw new Error(`Falha ao baixar a mídia (status ${fileRes.status})`);\n }\n const buf = new Uint8Array(await fileRes.arrayBuffer());\n return { bytes: buf, mimeType: meta.mime_type || \"image/jpeg\" };\n}\n\nasync function uploadToDrive(\n bytes: Uint8Array,\n mimeType: string,\n fileName: string,\n): Promise {\n const token = (await jwtClient.authorize()).access_token;\n const boundary = \"foto_boundary_\" + Date.now();\n const metadata = JSON.stringify({\n name: fileName,\n parents: [DRIVE_FOLDER_ID],\n });\n const encoder = new TextEncoder();\n const preamble = encoder.encode(\n `--${boundary}\\r\\nContent-Type: application/json; charset=UTF-8\\r\\n\\r\\n${metadata}\\r\\n--${boundary}\\r\\nContent-Type: ${mimeType}\\r\\n\\r\\n`,\n );\n const closing = encoder.encode(`\\r\\n--${boundary}--`);\n const uploadBody = new Uint8Array(\n preamble.length + bytes.length + closing.length,\n );\n uploadBody.set(preamble, 0);\n uploadBody.set(bytes, preamble.length);\n uploadBody.set(closing, preamble.length + bytes.length);\n\n const res = await fetch(\n \"https://www.googleapis.com/upload/drive/v3/files?uploadType=multipart&fields=id,webViewLink\",\n {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${token}`,\n \"Content-Type\": `multipart/related; boundary=${boundary}`,\n },\n body: uploadBody,\n },\n );\n const data = await res.json();\n if (!res.ok) {\n console.error(\n \"Erro no upload pro Drive:\",\n res.status,\n JSON.stringify(data),\n );\n throw new Error(\"Erro no upload pro Drive: \" + JSON.stringify(data));\n }\n return data.webViewLink || data.id || \"\";\n}\n\n// ---------- WhatsApp helpers ----------\n\nasync function sendWhatsApp(payload: Record) {\n const res = 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 if (!res.ok) {\n console.error(\"Erro ao enviar WhatsApp:\", res.status, await res.text());\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 { id: \"menu_confirmar_coleta\", title: \"📦 Confirmar Coleta\" },\n ],\n },\n ],\n },\n },\n });\n}\n\nfunction sendPedirCNPJ(to: string) {\n return sendText(\n to,\n \"Pra continuar, digite o CNPJ da sua empresa (só números, sem pontuação):\",\n );\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 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 if (await messageAlreadyProcessed(messageId)) {\n return new Response(\"OK\", { status: 200 });\n }\n await appendRow(\"Log\", [messageId]);\n\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 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 sendPedirCNPJ(from);\n } else if (listReplyId === \"menu_ver_programadas\") {\n await updateCell(\n \"Agendamentos\",\n row,\n \"C\",\n \"aguardando_cliente_programadas\",\n );\n await sendPedirCNPJ(from);\n } else if (listReplyId === \"menu_cancelar\") {\n await updateCell(\n \"Agendamentos\",\n row,\n \"C\",\n \"aguardando_cliente_cancelar\",\n );\n await sendPedirCNPJ(from);\n } else if (listReplyId === \"menu_confirmar_coleta\") {\n await updateCell(\n \"Agendamentos\",\n row,\n \"C\",\n \"aguardando_codigo_motorista\",\n );\n await sendText(\n from,\n \"Digite o código da coleta que foi informado ao cliente:\",\n );\n }\n } else if (etapa === \"aguardando_cliente\") {\n const row = existing.rowNumber;\n const cliente = await getClienteByCNPJ(textBody || \"\");\n if (!cliente) {\n await sendText(\n from,\n \"CNPJ não encontrado. Confira o número e tente de novo.\",\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 getClienteByCNPJ(textBody || \"\");\n if (!cliente) {\n await sendText(\n from,\n \"CNPJ não encontrado. Confira o número e tente de novo.\",\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 getClienteByCNPJ(textBody || \"\");\n if (!cliente) {\n await sendText(\n from,\n \"CNPJ não encontrado. Confira o número e tente de novo.\",\n );\n return new Response(\"OK\", { status: 200 });\n }\n const extras = await getActiveRequestsForCliente(cliente);\n const programadas = await getActiveCronogramaForCliente(cliente);\n\n if (extras.length === 0 && programadas.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 let numero = 1;\n const linhas: string[] = [];\n extras.forEach((a) => {\n linhas.push(\n `${numero}. [Extra] ${a.material} — data: ${a.data} — status: ${a.status}`,\n );\n numero++;\n });\n programadas.forEach((p) => {\n linhas.push(`${numero}. [Programada] ${p.dia}: ${p.material}`);\n numero++;\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${\n linhas.join(\"\\n\")\n }`,\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 (código: ${row}) e nossa equipe vai confirmar a data com o fornecedor. Assim que tivermos a confirmação, te avisamos por aqui!\\n\\nGuarde esse código — o motorista vai precisar dele na hora da coleta.`,\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 } else if (etapa === \"aguardando_codigo_motorista\") {\n const row = existing.rowNumber;\n const targetRow = parseInt(\n (textBody || \"\").trim().replace(/\\D/g, \"\"),\n 10,\n );\n if (isNaN(targetRow)) {\n await sendText(\n from,\n \"Não entendi. Digite só o número do código, como foi informado ao cliente.\",\n );\n return new Response(\"OK\", { status: 200 });\n }\n const linhaRows = await getValues(\n `Agendamentos!A${targetRow}:K${targetRow}`,\n );\n const linha = linhaRows[0];\n if (\n linha && linha[7] && linha[7] !== \"Cancelado\" &&\n linha[7] !== \"Concluído\"\n ) {\n await updateCell(\"Agendamentos\", row, \"D\", String(targetRow));\n await updateCell(\"Agendamentos\", row, \"C\", \"aguardando_foto_motorista\");\n await sendText(\n from,\n `Código encontrado! Agora me manda uma foto como comprovação dessa coleta (${\n linha[8] || \"Coleta\"\n }).`,\n );\n } else {\n await sendText(\n from,\n \"Não encontrei uma coleta ativa com esse código. Confira o número e tente de novo.\",\n );\n }\n } else if (etapa === \"aguardando_foto_motorista\") {\n const row = existing.rowNumber;\n const targetRow = parseInt(existing.cliente || \"\", 10);\n if (message.type === \"image\" && message.image?.id) {\n // Por enquanto só confirmamos o recebimento, sem guardar a foto —\n // isso será implementado quando o Drive Compartilhado estiver liberado.\n await updateCell(\n \"Agendamentos\",\n targetRow,\n \"K\",\n \"Foto recebida (não armazenada ainda)\",\n );\n await updateCell(\"Agendamentos\", targetRow, \"H\", \"Concluído\");\n await deleteRow(\"Agendamentos\", row);\n await sendText(\n from,\n \"Recebido! Coleta confirmada como concluída. Obrigado! 🙌\",\n );\n } else {\n await sendText(\n from,\n \"Preciso de uma foto como comprovação da coleta. Pode mandar a foto?\",\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}","deleted","label",[112],"pulls","branches",1,"forks","envVars",{"_135":137,"_138":42},"connections",{"_135":42,"_136":42},"count","unfilledCount",7,"emptyCount",{"_18":111,"_20":112,"_113":36,"_114":-5,"_115":71,"_116":69,"_117":38,"_22":140,"_68":119,"_120":121,"_122":123,"_124":26,"_125":-5,"_141":142,"_89":143},["D",1789570478983],"children",[],[112],["D",1788459087365],["D",1789501878689],{"_16":17,"_87":83},{"_16":17,"_80":81,"_82":83,"_33":34,"_84":85,"_86":26},{"_68":69,"_20":70,"_18":71,"_72":19,"_73":-5,"_74":-5,"_75":-5,"_76":-5,"_77":-5,"_78":21,"_79":17},"ctx",{"_61":-5,"_107":182,"_183":184,"_185":186,"_187":26,"_188":26,"_189":26,"_190":38,"_191":-5,"_192":-7,"_193":-7,"_194":42,"_195":26,"_196":26,"_197":-5,"_198":26,"_199":26,"_200":26,"_201":-5},"ENV",{"_153":154,"_155":156,"_157":70,"_158":159,"_160":161,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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"]

Search