[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_158":159,"_160":161},"routes/_app.x.$handle.$name",{"_99":98,"_32":44,"_106":89,"_27":53,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":48,"_120":121,"_122":25,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":48,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":25,"_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":48},"version",5,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",true,"deletedHere","path","main.ts","latestPath","fileId","17371ea0-a5d7-11f1-b344-1607ee4eb77e","name","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst TOKEN = Deno.env.get(\"TELEGRAM_BOT_TOKEN\");\nconst API = `https://api.telegram.org/bot${TOKEN}`;\n\nasync function initDb() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS vehiculos (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n chat_id TEXT,\n alias TEXT,\n tipo TEXT,\n km_actuales INTEGER,\n intervalo_meses INTEGER,\n intervalo_km INTEGER,\n fecha_ultima_revision TEXT,\n fecha_vencimiento_itv TEXT\n )\n `);\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS mantenimientos (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n vehiculo_id INTEGER,\n fecha TEXT,\n km INTEGER,\n tipos TEXT,\n nota TEXT\n )\n `);\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS estado_chat (\n chat_id TEXT PRIMARY KEY,\n paso TEXT,\n datos TEXT\n )\n `);\n}\n\nasync function sendMessage(chatId: string, text: string, replyMarkup?: any) {\n await fetch(`${API}/sendMessage`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n chat_id: chatId,\n text,\n reply_markup: replyMarkup,\n parse_mode: \"HTML\",\n }),\n });\n}\n\nasync function answerCallback(callbackId: string) {\n await fetch(`${API}/answerCallbackQuery`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ callback_query_id: callbackId }),\n });\n}\n\nasync function getEstado(chatId: string) {\n const rows = await sqlite.execute(\n `SELECT paso, datos FROM estado_chat WHERE chat_id = ?`,\n [chatId],\n );\n if (rows.rows.length === 0) return null;\n return {\n paso: rows.rows[0][0],\n datos: JSON.parse(rows.rows[0][1] as string),\n };\n}\n\nasync function setEstado(chatId: string, paso: string, datos: any) {\n await sqlite.execute(\n `INSERT INTO estado_chat (chat_id, paso, datos) VALUES (?, ?, ?)\n ON CONFLICT(chat_id) DO UPDATE SET paso = excluded.paso, datos = excluded.datos`,\n [chatId, paso, JSON.stringify(datos)],\n );\n}\n\nasync function limpiarEstado(chatId: string) {\n await sqlite.execute(`DELETE FROM estado_chat WHERE chat_id = ?`, [chatId]);\n}\n\nconst TIPOS_MANTENIMIENTO = [\n { id: \"aceite\", label: \"Aceite\" },\n { id: \"filtro_aceite\", label: \"Filtro de aceite\" },\n { id: \"filtro_aire\", label: \"Filtro de aire\" },\n { id: \"liquido_frenos\", label: \"Líquido de frenos\" },\n { id: \"anticongelante\", label: \"Anticongelante\" },\n { id: \"neumaticos\", label: \"Neumáticos\" },\n { id: \"bateria\", label: \"Batería\" },\n];\n\nfunction tecladoMantenimiento(seleccionados: string[]) {\n const filas = TIPOS_MANTENIMIENTO.map((t) => [{\n text: (seleccionados.includes(t.id) ? \"✅ \" : \"⬜ \") + t.label,\n callback_data: `toggle_${t.id}`,\n }]);\n filas.push([{\n text: \"✔️ Confirmar\",\n callback_data: \"confirmar_mantenimiento\",\n }]);\n return { inline_keyboard: filas };\n}\n\nasync function listarVehiculos(chatId: string) {\n const rows = await sqlite.execute(\n `SELECT id, alias FROM vehiculos WHERE chat_id = ?`,\n [chatId],\n );\n return rows.rows.map((r) => ({ id: r[0], alias: r[1] as string }));\n}\n\nexport default async function (req: Request) {\n await initDb();\n\n if (req.method !== \"POST\") {\n return new Response(\"Bot de mantenimiento activo\", { status: 200 });\n }\n\n const body = await req.json();\n\n // --- Mensajes de texto normales ---\n if (body.message) {\n const chatId = String(body.message.chat.id);\n const text = (body.message.text || \"\").trim();\n const estado = await getEstado(chatId);\n\n // Comando: nuevo vehículo\n if (text === \"/nuevovehiculo\") {\n await setEstado(chatId, \"nv_alias\", {});\n await sendMessage(\n chatId,\n \"¿Qué alias le pones al vehículo? (ej: Moto, Coche familiar)\",\n );\n return new Response(\"ok\");\n }\n\n // Comando: registrar mantenimiento\n if (text === \"/registrar\") {\n const vehiculos = await listarVehiculos(chatId);\n if (vehiculos.length === 0) {\n await sendMessage(\n chatId,\n \"Primero da de alta un vehículo con /nuevovehiculo\",\n );\n return new Response(\"ok\");\n }\n if (vehiculos.length === 1) {\n await setEstado(chatId, \"reg_fecha\", {\n vehiculo_id: vehiculos[0].id,\n alias: vehiculos[0].alias,\n });\n await sendMessage(\n chatId,\n `Registrando en ${\n vehiculos[0].alias\n }.\\n¿Fecha? (DD/MM/AAAA o \"hoy\")`,\n );\n } else {\n const botones = vehiculos.map((\n v,\n ) => [{ text: v.alias, callback_data: `regveh_${v.id}` }]);\n await sendMessage(chatId, \"¿Para qué vehículo?\", {\n inline_keyboard: botones,\n });\n }\n return new Response(\"ok\");\n }\n\n // Comando: listar vehículos\n if (text === \"/vehiculos\") {\n const rows = await sqlite.execute(\n `SELECT alias, km_actuales, fecha_ultima_revision, intervalo_meses, fecha_vencimiento_itv FROM vehiculos WHERE chat_id = ?`,\n [chatId],\n );\n if (rows.rows.length === 0) {\n await sendMessage(\n chatId,\n \"No tienes vehículos. Usa /nuevovehiculo para crear uno.\",\n );\n } else {\n let msg = \"Tus vehículos:\\n\\n\";\n for (const r of rows.rows) {\n msg += `🚗 ${r[0]}\\nKm actuales: ${r[1]}\\nÚltima revisión: ${\n r[2]\n } (cada ${r[3]} meses)\\nITV: ${r[4]}\\n\\n`;\n }\n await sendMessage(chatId, msg);\n }\n return new Response(\"ok\");\n }\n\n // Comando: historial\n if (text.startsWith(\"/historial\")) {\n const partes = text.split(\" \");\n const aliasBuscado = partes[1];\n const vehiculos = await listarVehiculos(chatId);\n const vehiculo = aliasBuscado\n ? vehiculos.find((v) =>\n v.alias.toLowerCase() === aliasBuscado.toLowerCase()\n )\n : vehiculos[0];\n if (!vehiculo) {\n await sendMessage(\n chatId,\n \"No encuentro ese vehículo. Usa /vehiculos para ver los nombres.\",\n );\n return new Response(\"ok\");\n }\n const rows = await sqlite.execute(\n `SELECT fecha, km, tipos FROM mantenimientos WHERE vehiculo_id = ? ORDER BY fecha DESC`,\n [vehiculo.id],\n );\n if (rows.rows.length === 0) {\n await sendMessage(\n chatId,\n `Sin mantenimientos registrados en ${vehiculo.alias}.`,\n );\n } else {\n let msg = `Historial de ${vehiculo.alias}:\\n\\n`;\n for (const r of rows.rows) {\n msg += `📅 ${r[0]} — ${r[1]} km\\n${r[2]}\\n\\n`;\n }\n await sendMessage(chatId, msg);\n }\n return new Response(\"ok\");\n }\n\n // --- Flujo conversacional: alta de vehículo ---\n if (estado?.paso === \"nv_alias\") {\n await setEstado(chatId, \"nv_tipo\", { ...estado.datos, alias: text });\n await sendMessage(chatId, \"¿Tipo de vehículo? (moto / coche)\");\n return new Response(\"ok\");\n }\n if (estado?.paso === \"nv_tipo\") {\n await setEstado(chatId, \"nv_km\", {\n ...estado.datos,\n tipo: text.toLowerCase(),\n });\n await sendMessage(chatId, \"¿Kilómetros actuales?\");\n return new Response(\"ok\");\n }\n if (estado?.paso === \"nv_km\") {\n await setEstado(chatId, \"nv_intervalo_meses\", {\n ...estado.datos,\n km: parseInt(text),\n });\n await sendMessage(\n chatId,\n \"¿Cada cuántos meses quieres el recordatorio de revisión?\",\n );\n return new Response(\"ok\");\n }\n if (estado?.paso === \"nv_intervalo_meses\") {\n await setEstado(chatId, \"nv_intervalo_km\", {\n ...estado.datos,\n intervalo_meses: parseInt(text),\n });\n await sendMessage(\n chatId,\n '¿Cada cuántos km quieres el recordatorio? (o escribe \"no\" para no usar km)',\n );\n return new Response(\"ok\");\n }\n if (estado?.paso === \"nv_intervalo_km\") {\n const intervaloKm = text.toLowerCase() === \"no\" ? null : parseInt(text);\n await setEstado(chatId, \"nv_itv\", {\n ...estado.datos,\n intervalo_km: intervaloKm,\n });\n await sendMessage(\n chatId,\n '¿Fecha de vencimiento de la ITV? (DD/MM/AAAA, o \"no\" si no aplica)',\n );\n return new Response(\"ok\");\n }\n if (estado?.paso === \"nv_itv\") {\n const datos = estado.datos;\n const hoy = new Date().toISOString().slice(0, 10);\n const itv = text.toLowerCase() === \"no\" ? null : text;\n await sqlite.execute(\n `INSERT INTO vehiculos (chat_id, alias, tipo, km_actuales, intervalo_meses, intervalo_km, fecha_ultima_revision, fecha_vencimiento_itv)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n chatId,\n datos.alias,\n datos.tipo,\n datos.km,\n datos.intervalo_meses,\n datos.intervalo_km,\n hoy,\n itv,\n ],\n );\n await limpiarEstado(chatId);\n await sendMessage(\n chatId,\n `✅ Vehículo ${datos.alias} creado correctamente.`,\n );\n return new Response(\"ok\");\n }\n\n // --- Flujo conversacional: registrar mantenimiento ---\n if (estado?.paso === \"reg_fecha\") {\n const fecha = text.toLowerCase() === \"hoy\"\n ? new Date().toISOString().slice(0, 10)\n : text;\n await setEstado(chatId, \"reg_km\", { ...estado.datos, fecha });\n await sendMessage(chatId, \"¿Kilómetros actuales?\");\n return new Response(\"ok\");\n }\n if (estado?.paso === \"reg_km\") {\n const datos = { ...estado.datos, km: parseInt(text), seleccionados: [] };\n await setEstado(chatId, \"reg_tipos\", datos);\n await sendMessage(\n chatId,\n \"¿Qué has cambiado? (marca todo lo que aplique)\",\n tecladoMantenimiento([]),\n );\n return new Response(\"ok\");\n }\n }\n\n // --- Callbacks (botones) ---\n if (body.callback_query) {\n const cb = body.callback_query;\n const chatId = String(cb.message.chat.id);\n const data = cb.data;\n const estado = await getEstado(chatId);\n\n // Selección de vehículo para registrar\n if (data.startsWith(\"regveh_\")) {\n const vehiculoId = parseInt(data.replace(\"regveh_\", \"\"));\n const vehiculos = await listarVehiculos(chatId);\n const v = vehiculos.find((x) => x.id === vehiculoId);\n await setEstado(chatId, \"reg_fecha\", {\n vehiculo_id: vehiculoId,\n alias: v?.alias,\n });\n await answerCallback(cb.id);\n await sendMessage(\n chatId,\n `Registrando en ${v?.alias}.\\n¿Fecha? (DD/MM/AAAA o \"hoy\")`,\n );\n return new Response(\"ok\");\n }\n\n // Toggle de checkboxes de mantenimiento\n if (data.startsWith(\"toggle_\") && estado?.paso === \"reg_tipos\") {\n const tipo = data.replace(\"toggle_\", \"\");\n const seleccionados: string[] = estado.datos.seleccionados;\n const nuevos = seleccionados.includes(tipo)\n ? seleccionados.filter((t) => t !== tipo)\n : [...seleccionados, tipo];\n await setEstado(chatId, \"reg_tipos\", {\n ...estado.datos,\n seleccionados: nuevos,\n });\n await answerCallback(cb.id);\n await fetch(`${API}/editMessageReplyMarkup`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n chat_id: chatId,\n message_id: cb.message.message_id,\n reply_markup: tecladoMantenimiento(nuevos),\n }),\n });\n return new Response(\"ok\");\n }\n\n // Confirmar mantenimiento\n if (data === \"confirmar_mantenimiento\" && estado?.paso === \"reg_tipos\") {\n const datos = estado.datos;\n const tiposTexto = datos.seleccionados\n .map((id: string) =>\n TIPOS_MANTENIMIENTO.find((t) => t.id === id)?.label\n )\n .join(\", \") || \"(nada marcado)\";\n await sqlite.execute(\n `INSERT INTO mantenimientos (vehiculo_id, fecha, km, tipos) VALUES (?, ?, ?, ?)`,\n [datos.vehiculo_id, datos.fecha, datos.km, tiposTexto],\n );\n await sqlite.execute(\n `UPDATE vehiculos SET km_actuales = ?, fecha_ultima_revision = ? WHERE id = ?`,\n [datos.km, datos.fecha, datos.vehiculo_id],\n );\n await limpiarEstado(chatId);\n await answerCallback(cb.id);\n await sendMessage(\n chatId,\n `✅ Registrado en ${datos.alias}:\\n${tiposTexto}`,\n );\n return new Response(\"ok\");\n }\n }\n\n return new Response(\"ok\");\n}","createdAt",["D",1788249270617],"branchVersion","branchId","ca79179b-2387-45b4-8c70-a79cf726c7a6","id","683645cb-b16b-4387-b0e4-b2ca02f84e46","mantenimiento_webhook",["D",1788247865026],"deletedAt","legacyEnvVars",false,"privacy","public","httpPrivacy","description","","imageUrl","ab13a512-0ebf-4599-9be1-4e1ffb52a140","pinnedFileId","0956bbe4-a5da-11f1-9a11-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019f21ce-7c3c-7738-8f89-94c2ca47d7cd","tursoName","683645cbb16b4387b0e4b2ca02f84e46","tursoHostname","683645cbb16b4387b0e4b2ca02f84e46-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789464074488],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_105":53},"org",{"_99":98,"_100":53,"_101":53,"_18":55,"_102":103,"_104":48},"branch",{"_13":88,"_32":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"isOwned",9,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Finidi","handle","displayName","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_42":43,"_32":44,"_37":153,"_46":-5,"_47":48,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":25,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":154,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":155,"_83":156,"_85":157,"_87":48},"tree",[148],"files",[148],"counts",{"_138":62,"_139":134,"_140":62,"_141":142,"_143":144},"contents",[127],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":128,"_32":129,"_30":57,"_130":-5,"_40":41,"_39":131,"_132":48,"_37":133,"_13":134,"_33":135,"_35":36,"_24":48,"_136":-5,"_27":137},"03319506-42d9-4898-8440-af2f6ad47729","new-file-8722.ts","parentId",4,"latest",["D",1788249218601],1,"http","label",[129],"pulls","branches","forks","envVars",{"_145":134,"_147":62},"connections",{"_145":62,"_146":62},"count","unfilledCount","emptyCount",{"_42":128,"_32":129,"_30":57,"_130":-5,"_40":41,"_39":131,"_132":48,"_37":149,"_13":134,"_33":135,"_35":36,"_24":48,"_136":-5,"_150":151,"_27":152},["D",1788249218601],"children",[],[129],["D",1788247865026],["D",1789464074488],{"_99":98,"_105":53},{"_99":98,"_100":53,"_101":53,"_18":55,"_102":103,"_104":48},{"_13":88,"_32":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"ctx",{"_81":-5,"_124":191,"_192":193,"_194":195,"_196":48,"_197":48,"_198":48,"_199":25,"_200":-5,"_201":-7,"_202":-7,"_203":62,"_204":48,"_205":48,"_206":-5,"_207":48,"_208":48,"_209":48,"_210":-5},"ENV",{"_162":163,"_164":165,"_166":89,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190},"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 · v5