[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_103":104,"_105":106},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","Finidi","name","mantenimiento_webhook","path","new-file-8722.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":25,"_58":32,"_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":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/Finidi/mantenimiento_webhook/code/new-file-8722.ts","extension","id","1118273e-7307-4ee5-8b96-4aab1fb79182","fileId","0956bbe4-a5da-11f1-9a11-1607ee4eb77e","parentId","branchId","ca79179b-2387-45b4-8c70-a79cf726c7a6","branchVersion",9,"latest",true,"createdAt",["D",1788252700904],"version",5,"fileType","http","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 // Migración: añade columnas de neumáticos si no existen todavía\n await sqlite.execute(\n `ALTER TABLE vehiculos ADD COLUMN fecha_ultimo_cambio_neumaticos TEXT`,\n ).catch(() => {});\n await sqlite.execute(\n `ALTER TABLE vehiculos ADD COLUMN km_ultimo_cambio_neumaticos INTEGER`,\n ).catch(() => {});\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 const res = 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 const data = await res.json();\n if (!data.ok) {\n console.error(\"Error enviando mensaje a Telegram:\", JSON.stringify(data));\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: \"pastillas_frenos\", label: \"Pastillas de freno\" },\n { id: \"anticongelante\", label: \"Anticongelante\" },\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 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 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 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 if (text === \"/neumaticos\") {\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, \"neu_fecha\", {\n vehiculo_id: vehiculos[0].id,\n alias: vehiculos[0].alias,\n });\n await sendMessage(\n chatId,\n `Cambio de neumáticos 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: `neuveh_${v.id}` }]);\n await sendMessage(chatId, \"¿Para qué vehículo?\", {\n inline_keyboard: botones,\n });\n }\n return new Response(\"ok\");\n }\n\n if (text === \"/vehiculos\") {\n const rows = await sqlite.execute(\n `SELECT alias, km_actuales, fecha_ultima_revision, intervalo_meses, fecha_vencimiento_itv, fecha_ultimo_cambio_neumaticos, km_ultimo_cambio_neumaticos, tipo 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 const kmActuales = r[1] as number;\n const kmNeumaticos = r[6] as number | null;\n const kmDesdeNeumaticos = kmNeumaticos != null\n ? kmActuales - kmNeumaticos\n : null;\n const emoji = (r[7] as string) === \"moto\" ? \"🛵\" : \"🚗\";\n\n const col1 = `Kilómetros:`.padEnd(14) + `${kmActuales}`;\n const col2 = `Revisión:`.padEnd(14) + `${r[2]}`;\n const col3 = `ITV:`.padEnd(14) + `${r[4]}`;\n const col4 = `Neumáticos:`.padEnd(14) +\n (kmDesdeNeumaticos != null\n ? `${kmDesdeNeumaticos} km`\n : \"sin registrar\");\n\n msg += `${emoji} ${r[0]}\\n`;\n msg += `

${col1}\\n${col2}\\n${col3}\\n${col4}

\\n`;\n }\n await sendMessage(chatId, msg);\n }\n return new Response(\"ok\");\n }\n\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 // --- 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 // --- Registrar mantenimiento/revisión ---\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 // --- Cambio de neumáticos ---\n if (estado?.paso === \"neu_fecha\") {\n const fecha = text.toLowerCase() === \"hoy\"\n ? new Date().toISOString().slice(0, 10)\n : text;\n await setEstado(chatId, \"neu_km\", { ...estado.datos, fecha });\n await sendMessage(chatId, \"¿Kilómetros en el momento del cambio?\");\n return new Response(\"ok\");\n }\n if (estado?.paso === \"neu_km\") {\n const datos = estado.datos;\n const km = parseInt(text);\n await sqlite.execute(\n `UPDATE vehiculos SET fecha_ultimo_cambio_neumaticos = ?, km_ultimo_cambio_neumaticos = ? WHERE id = ?`,\n [datos.fecha, km, datos.vehiculo_id],\n );\n await limpiarEstado(chatId);\n await sendMessage(\n chatId,\n `✅ Neumáticos de ${datos.alias} registrados: ${km} km (${datos.fecha}).`,\n );\n return new Response(\"ok\");\n }\n }\n\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 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 if (data.startsWith(\"neuveh_\")) {\n const vehiculoId = parseInt(data.replace(\"neuveh_\", \"\"));\n const vehiculos = await listarVehiculos(chatId);\n const v = vehiculos.find((x) => x.id === vehiculoId);\n await setEstado(chatId, \"neu_fecha\", {\n vehiculo_id: vehiculoId,\n alias: v?.alias,\n });\n await answerCallback(cb.id);\n await sendMessage(\n chatId,\n `Cambio de neumáticos en ${v?.alias}.\\n¿Fecha? (DD/MM/AAAA o \"hoy\")`,\n );\n return new Response(\"ok\");\n }\n\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 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}","deleted",false,"label",[14],"683645cb-b16b-4387-b0e4-b2ca02f84e46",["D",1788247865026],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","userId","ab13a512-0ebf-4599-9be1-4e1ffb52a140","pinnedFileId","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",{"_9":10,"_102":53},"org",{"_9":10,"_97":53,"_98":53,"_55":56,"_99":100,"_101":42},"branch",{"_35":30,"_11":88,"_22":28,"_89":45,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":12,"_96":10},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","tier","free","canRestrictVals","profileImageUrl","ctx",{"_81":-5,"_136":137,"_138":139,"_140":141,"_142":42,"_143":42,"_144":42,"_145":32,"_146":-5,"_147":-7,"_148":-7,"_149":62,"_150":42,"_151":42,"_152":-5,"_153":42,"_154":42,"_155":42,"_156":-5},"ENV",{"_107":108,"_109":110,"_111":88,"_112":113,"_114":115,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]