[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_184":185,"_186":187},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_17":18,"_39":-7,"_132":-5,"_19":133,"_134":135,"_136":137,"_138":139,"_140":141,"_21":-5,"_142":-5,"_143":-5,"_144":24,"_145":146,"_147":77,"_148":-5,"_149":-5,"_150":151},"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":26,"_27":28,"_29":24,"_30":-5},"handle","gustavoteixeira","name","teste","branchName","main","path","main-copy.ts","project",{"_33":79,"_13":14,"_37":80,"_81":-5,"_82":24,"_83":84,"_85":84,"_86":87,"_88":-5,"_30":67,"_89":90,"_91":77,"_92":-5,"_93":-5,"_94":26,"_41":42,"_95":96,"_97":98,"_99":100,"_101":-5,"_102":103,"_104":103,"_105":106,"_107":106,"_108":106,"_109":103,"_110":103,"_52":111,"_112":113,"_114":115,"_116":24},"file",{"_62":63,"_13":18,"_64":65,"_66":77,"_78":72},"isDirectory",false,"page",0,"history",[31,32],"hasNext","userId",{"_33":70,"_35":36,"_37":71,"_39":72,"_41":42,"_43":34,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":73,"_21":74,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":75},{"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_21":54,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60},"id","7c8e392e-bd68-4f53-9b32-19a955e81edb","branchId","64baa4d8-4625-4d57-9b35-5d2a2b4f3eb8","createdAt",["D",1789477313883],"version",27,"orgId","01a06876-6500-703a-8dd7-d8fb51364f39","parentId","7ade679b-5782-4e76-865d-a12e416c61c9","incomingCommitId","aiChatMessageId","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","clientLabel","user",{"_33":67,"_41":42,"_11":12,"_68":69},{"_62":63,"_13":18,"_64":65,"_66":24},"pull","merge","revert","multiple","commits",[61],{"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_21":54,"_55":-5,"_56":-5,"_57":-5},"fileId","9fcb64fe-b105-11f1-96cb-1607ee4eb77e","fileType","http","deleted","7a9b14fb-5434-4708-95bc-70d1677dec71","avatar","https://lh3.googleusercontent.com/a/ACg8ocLRyaRj-8_CCO-4h557BVGQygbhfqFC_gqdtyUrP5mzGzxRWQ=s96-c","76708789-8915-477f-a56c-59c135168f0a",["D",1789477859490],28,{"_33":67,"_41":42,"_11":12,"_68":69},{"_62":63,"_13":18,"_64":65,"_66":77},[76],{"_33":70,"_35":36,"_37":71,"_39":72,"_41":42,"_43":34,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":73,"_21":74,"_55":-5,"_56":-5,"_57":-5},true,"deletedAtVersion","cc432ec9-8b28-4901-bcb8-0c309a877cb8",["D",1788459087365],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","pinnedFileId","e17ef9de-a7c2-11f1-9e2a-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount","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",{"_11":12,"_131":69},"org",{"_11":12,"_126":127,"_68":69,"_30":67,"_128":129,"_130":24},"branch",{"_39":117,"_13":16,"_33":36,"_118":79,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":-5,"_124":14,"_125":12},"isOwned",31,"projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","GUSTAVO TEIXEIRA","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":79,"_13":14,"_37":179,"_81":-5,"_82":24,"_83":84,"_85":84,"_86":87,"_88":-5,"_30":67,"_89":90,"_91":77,"_92":-5,"_93":-5,"_94":26,"_41":42,"_95":96,"_97":98,"_99":180,"_101":-5,"_102":103,"_104":103,"_105":106,"_107":106,"_108":106,"_109":103,"_110":103,"_52":181,"_112":182,"_114":183,"_116":24},"tree",[174],"files",[174],"counts",{"_162":26,"_163":164,"_165":26,"_166":167,"_168":169},"contents",[152],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":153,"_13":154,"_62":90,"_43":-5,"_35":36,"_155":117,"_156":77,"_37":157,"_39":72,"_64":65,"_158":159,"_66":24,"_160":-5,"_17":161},"ca9f0a52-abdd-4314-8704-6d5f5333575b","main.ts","branchVersion","latest",["D",1789562867721],"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(\"Erro na API do Google Sheets:\", res.status, JSON.stringify(data));\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/${encodeURIComponent(sheetName)}:append?valueInputOption=USER_ENTERED`,\n {\n method: \"POST\",\n body: JSON.stringify({ values: [values] }),\n },\n );\n}\n\nasync function updateCell(sheetName: string, row: number, col: string, value: string) {\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 { rowNumber: i + 1, etapa: rows[i][2] || \"\", cliente: rows[i][3] || \"\" };\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({ rowNumber: i + 1, dia: rows[i][1], material: rows[i][2] });\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: { rowNumber: number; material: string; data: string; status: 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 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, \"segunda-feira\": 1, \"terça-feira\": 2, \"quarta-feira\": 3,\n \"quinta-feira\": 4, \"sexta-feira\": 5, \"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(mediaId: string): 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(\"downloadWhatsAppMedia: resposta sem url:\", JSON.stringify(meta));\n throw new Error(\"Não consegui obter a URL da mídia da Meta: \" + JSON.stringify(meta));\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(bytes: Uint8Array, mimeType: string, fileName: string): Promise {\n const token = (await jwtClient.authorize()).access_token;\n const boundary = \"foto_boundary_\" + Date.now();\n const metadata = JSON.stringify({ name: fileName, parents: [DRIVE_FOLDER_ID] });\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(preamble.length + bytes.length + closing.length);\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(\"Erro no upload pro Drive:\", res.status, JSON.stringify(data));\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(`https://graph.facebook.com/v21.0/${WHATSAPP_PHONE_NUMBER_ID}/messages`, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n Authorization: `Bearer ${WHATSAPP_ACCESS_TOKEN}`,\n },\n body: JSON.stringify(payload),\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(to, \"Pra continuar, digite o CNPJ da sua empresa (só números, sem pontuação):\");\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: { text: \"Entendido. Agora selecione o principal tipo de material a ser recolhido:\" },\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 ?? \"\", { status: 200, headers: { \"Content-Type\": \"text/plain\" } });\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 string | undefined;\n const listReplyTitle = message.interactive?.list_reply?.title as string | 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(\"Agendamentos\", row, \"C\", \"aguardando_cliente_programadas\");\n await sendPedirCNPJ(from);\n } else if (listReplyId === \"menu_cancelar\") {\n await updateCell(\"Agendamentos\", row, \"C\", \"aguardando_cliente_cancelar\");\n await sendPedirCNPJ(from);\n } else if (listReplyId === \"menu_confirmar_coleta\") {\n await updateCell(\"Agendamentos\", row, \"C\", \"aguardando_codigo_motorista\");\n await sendText(from, \"Digite o código da coleta que foi informado ao cliente:\");\n }\n } else if (etapa === \"aguardando_cliente\") {\n const row = existing.rowNumber;\n const cliente = await getClienteByCNPJ(textBody || \"\");\n if (!cliente) {\n await sendText(from, \"CNPJ não encontrado. Confira o número e tente de novo.\");\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(from, \"CNPJ não encontrado. Confira o número e tente de novo.\");\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 ? fixas.join(\"\\n\") : \"Nenhuma coleta fixa cadastrada.\";\n texto += \"\\n\\n🚚 Extras solicitadas:\\n\";\n texto += extras.length ? extras.join(\"\\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(from, \"CNPJ não encontrado. Confira o número e tente de novo.\");\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(from, `Não encontrei nenhuma coleta ativa para *${cliente}* pra cancelar.`);\n await deleteRow(\"Agendamentos\", row);\n } else {\n let numero = 1;\n const linhas: string[] = [];\n extras.forEach((a) => {\n linhas.push(`${numero}. [Extra] ${a.material} — data: ${a.data} — status: ${a.status}`);\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(\"Agendamentos\", row, \"C\", \"aguardando_escolha_cancelamento\");\n await sendText(from, `Qual coleta você quer cancelar? Digite o número:\\n\\n${linhas.join(\"\\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(from, \"Não entendi. Digite só o número da coleta que quer cancelar.\");\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(from, `Prontinho! A coleta extra de *${alvo.material}* (${alvo.data}) foi cancelada.`);\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(from, \"Última etapa: me diga a data pretendida para a coleta (ex: 15/09).\");\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(from, \"Não entendi essa data 😕 Pode mandar de novo no formato dia/mês? Exemplo: 15/09\");\n }\n } else if (etapa === \"aguardando_codigo_motorista\") {\n const row = existing.rowNumber;\n const targetRow = parseInt((textBody || \"\").trim().replace(/\\D/g, \"\"), 10);\n if (isNaN(targetRow)) {\n await sendText(from, \"Não entendi. Digite só o número do código, como foi informado ao cliente.\");\n return new Response(\"OK\", { status: 200 });\n }\n const linhaRows = await getValues(`Agendamentos!A${targetRow}:K${targetRow}`);\n const linha = linhaRows[0];\n if (linha && linha[7] && linha[7] !== \"Cancelado\" && linha[7] !== \"Concluído\") {\n await updateCell(\"Agendamentos\", row, \"D\", String(targetRow));\n await updateCell(\"Agendamentos\", row, \"C\", \"aguardando_foto_motorista\");\n await sendText(from, `Código encontrado! Agora me manda uma foto como comprovação dessa coleta (${linha[8] || \"Coleta\"}).`);\n } else {\n await sendText(from, \"Não encontrei uma coleta ativa com esse código. Confira o número e tente de novo.\");\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 try {\n const { bytes, mimeType } = await downloadWhatsAppMedia(message.image.id);\n const ext = mimeType.includes(\"png\") ? \"png\" : \"jpg\";\n const link = await uploadToDrive(bytes, mimeType, `comprovante-linha${targetRow}-${Date.now()}.${ext}`);\n await updateCell(\"Agendamentos\", targetRow, \"K\", link);\n await updateCell(\"Agendamentos\", targetRow, \"H\", \"Concluído\");\n await deleteRow(\"Agendamentos\", row);\n await sendText(from, \"Recebido! Coleta confirmada como concluída. Obrigado! 🙌\");\n } catch (err) {\n console.error(\"Erro ao processar foto de comprovação:\", err);\n await sendText(from, \"Tive um problema ao processar a foto. Pode tentar mandar de novo?\");\n }\n } else {\n await sendText(from, \"Preciso de uma foto como comprovação da coleta. Pode mandar a foto?\");\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\", { status: 200 });\n }\n}","label",[154],"pulls","branches",1,"forks","envVars",{"_170":172,"_173":26},"connections",{"_170":26,"_171":26},"count","unfilledCount",7,"emptyCount",{"_33":153,"_13":154,"_62":90,"_43":-5,"_35":36,"_155":117,"_156":77,"_37":175,"_39":72,"_64":65,"_158":159,"_66":24,"_160":-5,"_176":177,"_17":178},["D",1789562867721],"children",[],[154],["D",1788459087365],["D",1789501878689],{"_11":12,"_131":69},{"_11":12,"_126":127,"_68":69,"_30":67,"_128":129,"_130":24},{"_39":117,"_13":16,"_33":36,"_118":79,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":-5,"_124":14,"_125":12},"ctx",{"_52":-5,"_149":217,"_218":219,"_220":221,"_222":24,"_223":24,"_224":24,"_225":77,"_226":-5,"_227":-7,"_228":-7,"_229":26,"_230":24,"_231":24,"_232":-5,"_233":24,"_234":24,"_235":24,"_236":-5},"ENV",{"_188":189,"_190":191,"_192":16,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216},"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"]

History · main-copy.ts