[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_332":333,"_334":335},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_272":83,"_52":-7,"_273":-5,"_17":274,"_275":276,"_277":278,"_279":280,"_281":282,"_66":-5,"_283":-5,"_284":-5,"_285":24,"_286":287,"_288":289,"_290":-5,"_291":-5,"_292":293},"routes/_app.x.$handle.$name.branch.$branch.history",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":-5},"handle","Finidi","name","Pepito_Grillo","branchName","main","project",{"_46":222,"_13":14,"_50":223,"_224":-5,"_225":24,"_226":227,"_228":227,"_229":230,"_231":-5,"_25":81,"_232":-5,"_233":24,"_234":-5,"_235":-5,"_236":20,"_54":55,"_237":238,"_239":240,"_241":242,"_243":-5,"_244":245,"_246":245,"_247":248,"_249":248,"_250":248,"_251":245,"_252":245,"_64":253,"_254":255,"_256":257,"_258":24},"page",0,"history",[26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45],"hasNext",false,"userId",{"_46":215,"_48":49,"_50":216,"_52":217,"_54":55,"_56":208,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":218,"_66":219,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":220},{"_46":208,"_48":49,"_50":209,"_52":210,"_54":55,"_56":201,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":211,"_66":212,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":213},{"_46":201,"_48":49,"_50":202,"_52":203,"_54":55,"_56":194,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":204,"_66":205,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":206},{"_46":194,"_48":49,"_50":195,"_52":196,"_54":55,"_56":187,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":197,"_66":198,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":199},{"_46":187,"_48":49,"_50":188,"_52":189,"_54":55,"_56":180,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":190,"_66":191,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":192},{"_46":180,"_48":49,"_50":181,"_52":182,"_54":55,"_56":173,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":183,"_66":184,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":185},{"_46":173,"_48":49,"_50":174,"_52":175,"_54":55,"_56":166,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":176,"_66":177,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":178},{"_46":166,"_48":49,"_50":167,"_52":168,"_54":55,"_56":159,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":169,"_66":170,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":171},{"_46":159,"_48":49,"_50":160,"_52":161,"_54":55,"_56":152,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":162,"_66":163,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":164},{"_46":152,"_48":49,"_50":153,"_52":154,"_54":55,"_56":145,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":155,"_66":156,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":157},{"_46":145,"_48":49,"_50":146,"_52":147,"_54":55,"_56":137,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":148,"_66":149,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":150},{"_46":137,"_48":49,"_50":138,"_52":139,"_54":55,"_56":130,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":140,"_66":141,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":142},{"_46":130,"_48":49,"_50":131,"_52":132,"_54":55,"_56":123,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":133,"_66":134,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":135},{"_46":123,"_48":49,"_50":124,"_52":125,"_54":55,"_56":115,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":126,"_66":127,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":128},{"_46":115,"_48":49,"_50":116,"_52":117,"_54":55,"_56":108,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":118,"_66":119,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":120},{"_46":108,"_48":49,"_50":109,"_52":110,"_54":55,"_56":99,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":111,"_66":112,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":113},{"_46":99,"_48":49,"_50":100,"_52":101,"_54":55,"_56":91,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":102,"_66":103,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":104},{"_46":91,"_48":49,"_50":92,"_52":93,"_54":55,"_56":84,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":94,"_66":95,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":96},{"_46":84,"_48":49,"_50":85,"_52":86,"_54":55,"_56":47,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":87,"_66":88,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":89},{"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":65,"_66":67,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":73},"id","d5047f9a-2d14-4eef-9d89-54d6a125b411","branchId","7a30cb27-1ecc-4a50-9f06-b563b8aa5d82","createdAt",["D",1783596784507],"version",1,"orgId","019f21ce-7c3c-7738-8f89-94c2ca47d7cd","parentId","incomingCommitId","aiChatMessageId","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","clientLabel","user",{"_46":81,"_54":55,"_11":12,"_82":83},"file",{"_75":76,"_13":77,"_78":79,"_80":24},"pull","merge","revert","multiple","commits",[74],{"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":65,"_66":67,"_68":-5,"_69":-5,"_70":-5},"fileId","f324775a-7b89-11f1-92c3-1607ee4eb77e","main.ts","fileType","script","deleted","ab13a512-0ebf-4599-9be1-4e1ffb52a140","avatar","","2c4c85ad-7990-4aec-80cc-e6867293a83a",["D",1783597363524],2,{"_46":81,"_54":55,"_11":12,"_82":83},{"_75":76,"_13":77,"_78":79,"_80":24},[90],{"_46":84,"_48":49,"_50":85,"_52":86,"_54":55,"_56":47,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":87,"_66":88,"_68":-5,"_69":-5,"_70":-5},"5ba434d9-509c-4b5f-8f04-878749bf2205",["D",1783597884336],3,{"_46":81,"_54":55,"_11":12,"_82":83},{"_75":76,"_13":77,"_78":98,"_80":24},[97],{"_46":91,"_48":49,"_50":92,"_52":93,"_54":55,"_56":84,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":94,"_66":95,"_68":-5,"_69":-5,"_70":-5},"http","b11fc175-f412-4a87-bead-58423d1b64cd",["D",1783599158538],4,{"_46":81,"_54":55,"_11":12,"_82":83},{"_75":106,"_13":107,"_78":79,"_80":24},[105],{"_46":99,"_48":49,"_50":100,"_52":101,"_54":55,"_56":91,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":102,"_66":103,"_68":-5,"_69":-5,"_70":-5},"7a31a7d6-7b8f-11f1-b1db-1607ee4eb77e","new-file-34.ts","a8e9da05-74e1-43b9-97ca-ad0530d9f8d4",["D",1783599196057],5,{"_46":81,"_54":55,"_11":12,"_82":83},{"_75":106,"_13":107,"_78":79,"_80":24},[114],{"_46":108,"_48":49,"_50":109,"_52":110,"_54":55,"_56":99,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":111,"_66":112,"_68":-5,"_69":-5,"_70":-5},"518e18d6-4e37-4d63-abf5-c4a6185f5490",["D",1783599208697],6,{"_46":81,"_54":55,"_11":12,"_82":83},{"_75":106,"_13":122,"_78":79,"_80":24},[121],{"_46":115,"_48":49,"_50":116,"_52":117,"_54":55,"_56":108,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":118,"_66":119,"_68":-5,"_69":-5,"_70":-5},"cron.ts","546a5d94-bad7-47d6-b03e-25f36d91fe1a",["D",1783599221979],7,{"_46":81,"_54":55,"_11":12,"_82":83},{"_75":106,"_13":122,"_78":79,"_80":24},[129],{"_46":123,"_48":49,"_50":124,"_52":125,"_54":55,"_56":115,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":126,"_66":127,"_68":-5,"_69":-5,"_70":-5},"f553eeeb-f233-4347-80a1-5f2be0245a1b",["D",1783599226983],8,{"_46":81,"_54":55,"_11":12,"_82":83},{"_75":76,"_13":77,"_78":98,"_80":24},[136],{"_46":130,"_48":49,"_50":131,"_52":132,"_54":55,"_56":123,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":133,"_66":134,"_68":-5,"_69":-5,"_70":-5},"926d571f-efdf-4bd5-807e-6e0e1c8111d0",["D",1783659713114],9,{"_46":81,"_54":55,"_11":12,"_82":83},{"_75":106,"_13":122,"_78":144,"_80":24},[143],{"_46":137,"_48":49,"_50":138,"_52":139,"_54":55,"_56":130,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":140,"_66":141,"_68":-5,"_69":-5,"_70":-5},"interval","bcf8d97e-3aec-4e00-bcfb-d68c3ae98044",["D",1783660207349],10,{"_46":81,"_54":55,"_11":12,"_82":83},{"_75":76,"_13":77,"_78":98,"_80":24},[151],{"_46":145,"_48":49,"_50":146,"_52":147,"_54":55,"_56":137,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":148,"_66":149,"_68":-5,"_69":-5,"_70":-5},"2ce96c30-a16e-41d9-a8e0-3caf613e5b59",["D",1783660234363],11,{"_46":81,"_54":55,"_11":12,"_82":83},{"_75":106,"_13":122,"_78":144,"_80":24},[158],{"_46":152,"_48":49,"_50":153,"_52":154,"_54":55,"_56":145,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":155,"_66":156,"_68":-5,"_69":-5,"_70":-5},"daa563dc-7d11-4ece-a577-2482cf49782e",["D",1783660600706],12,{"_46":81,"_54":55,"_11":12,"_82":83},{"_75":76,"_13":77,"_78":98,"_80":24},[165],{"_46":159,"_48":49,"_50":160,"_52":161,"_54":55,"_56":152,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":162,"_66":163,"_68":-5,"_69":-5,"_70":-5},"bc40e71d-4803-4449-a7cd-33314e8692d7",["D",1783662324516],13,{"_46":81,"_54":55,"_11":12,"_82":83},{"_75":76,"_13":77,"_78":98,"_80":24},[172],{"_46":166,"_48":49,"_50":167,"_52":168,"_54":55,"_56":159,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":169,"_66":170,"_68":-5,"_69":-5,"_70":-5},"ef64bff2-ef06-4764-9127-c99bcc7749ed",["D",1783664101796],14,{"_46":81,"_54":55,"_11":12,"_82":83},{"_75":76,"_13":77,"_78":98,"_80":24},[179],{"_46":173,"_48":49,"_50":174,"_52":175,"_54":55,"_56":166,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":176,"_66":177,"_68":-5,"_69":-5,"_70":-5},"dd3cb074-7dbf-4363-b35f-6fc968739aee",["D",1783664235115],15,{"_46":81,"_54":55,"_11":12,"_82":83},{"_75":76,"_13":77,"_78":98,"_80":24},[186],{"_46":180,"_48":49,"_50":181,"_52":182,"_54":55,"_56":173,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":183,"_66":184,"_68":-5,"_69":-5,"_70":-5},"5995220b-1935-42c3-b8e0-45427f6d9559",["D",1783673876238],16,{"_46":81,"_54":55,"_11":12,"_82":83},{"_75":76,"_13":77,"_78":98,"_80":24},[193],{"_46":187,"_48":49,"_50":188,"_52":189,"_54":55,"_56":180,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":190,"_66":191,"_68":-5,"_69":-5,"_70":-5},"ccf8f65f-3f74-4ec3-96e1-5d7c37a1b284",["D",1783674359515],17,{"_46":81,"_54":55,"_11":12,"_82":83},{"_75":76,"_13":77,"_78":98,"_80":24},[200],{"_46":194,"_48":49,"_50":195,"_52":196,"_54":55,"_56":187,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":197,"_66":198,"_68":-5,"_69":-5,"_70":-5},"7e1f4c67-a884-47ad-b712-179ebe67ead6",["D",1783674458691],18,{"_46":81,"_54":55,"_11":12,"_82":83},{"_75":76,"_13":77,"_78":98,"_80":24},[207],{"_46":201,"_48":49,"_50":202,"_52":203,"_54":55,"_56":194,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":204,"_66":205,"_68":-5,"_69":-5,"_70":-5},"c309193c-1752-4820-b298-beb6e25bf9fa",["D",1784025705132],19,{"_46":81,"_54":55,"_11":12,"_82":83},{"_75":76,"_13":77,"_78":98,"_80":24},[214],{"_46":208,"_48":49,"_50":209,"_52":210,"_54":55,"_56":201,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":211,"_66":212,"_68":-5,"_69":-5,"_70":-5},"fcfc783a-da52-49fb-8002-5e3d3a323b1b",["D",1784704694703],20,{"_46":81,"_54":55,"_11":12,"_82":83},{"_75":76,"_13":77,"_78":98,"_80":24},[221],{"_46":215,"_48":49,"_50":216,"_52":217,"_54":55,"_56":208,"_57":-5,"_58":-5,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":218,"_66":219,"_68":-5,"_69":-5,"_70":-5},"d339095b-4749-467d-a45e-b7c644a6fae8",["D",1783596784491],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","@Pagos_futuros_bot","imageUrl","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","tursoName","d339095b4749467da45eb7c644a6fae8","tursoHostname","d339095b4749467da45eb7c644a6fae8-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789437645046],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_11":12,"_271":83},"org",{"_11":12,"_267":83,"_82":83,"_25":81,"_268":269,"_270":24},"branch",{"_52":217,"_13":16,"_46":49,"_259":222,"_260":-5,"_261":-5,"_262":-5,"_263":-5,"_264":-5,"_265":14,"_266":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","tier","free","canRestrictVals","profileImageUrl","path","adoptOrgId",{"_46":222,"_13":14,"_50":327,"_224":-5,"_225":24,"_226":227,"_228":227,"_229":230,"_231":-5,"_25":81,"_232":-5,"_233":24,"_234":-5,"_235":-5,"_236":20,"_54":55,"_237":238,"_239":240,"_241":328,"_243":-5,"_244":245,"_246":245,"_247":248,"_249":248,"_250":248,"_251":245,"_252":245,"_64":329,"_254":330,"_256":331,"_258":24},"tree",[318,319],"files",[318,319],"counts",{"_308":20,"_309":53,"_310":20,"_311":312,"_313":314},"contents",[294,295],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_46":304,"_13":122,"_75":106,"_56":-5,"_48":49,"_297":154,"_298":289,"_50":305,"_52":110,"_78":144,"_300":306,"_80":24,"_302":-5,"_272":307},{"_46":296,"_13":77,"_75":76,"_56":-5,"_48":49,"_297":217,"_298":289,"_50":299,"_52":168,"_78":98,"_300":301,"_80":24,"_302":-5,"_272":303},"3ed46e8d-4db8-4721-9164-24ddaa2f336a","branchVersion","latest",["D",1784704694703],"content","// ============================================================\n// BOT DE RECORDATORIOS DE PAGOS (seguros, impuestos, etc.)\n// ============================================================\n// COMANDOS:\n// /añadir -> flujo: grupo (botones) -> empresa -> importe -> fecha -> días de aviso\n// /lista -> ver todos tus pagos (numerados solo para ti, empezando en #1)\n// /editar -> modificar nombre/importe/fecha/empresa de un pago tuyo\n// /grupos -> ver tus grupos\n// /borrar -> eliminar un pago tuyo\n// /cancelar -> cancelar cualquier flujo en curso\n//\n// NOTA SOBRE LA NUMERACIÓN: cada usuario tiene su propia numeración\n// independiente (columna \"numero\" en items), separada del id interno\n// de la base de datos (que sí es compartido entre todos los usuarios).\n// Así, tu primer pago será siempre #1, y el de otra persona que use\n// el mismo bot también será #1 el suyo, sin mezclarse.\n// ============================================================\n\nimport { 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\nconst GRUPOS_POR_DEFECTO = [\"Impuesto\", \"Seguro\"];\n\n// ============================================================\n// HELPER ANTI-SORPRESAS: sqlite.execute a veces devuelve cada fila\n// como un ARRAY posicional (row[0], row[1]...) y a veces como un\n// OBJETO con las columnas como claves (row.nombre, row.importe...).\n// Esta función funciona en los dos casos.\n// ============================================================\nfunction val(row: any, index: number, key: string) {\n if (Array.isArray(row)) return row[index];\n return row[key];\n}\n\n// ============================================================\n// BASE DE DATOS\n// ============================================================\nasync function initDb() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS items (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n chat_id INTEGER,\n grupo TEXT,\n nombre TEXT,\n importe REAL,\n fecha_pago TEXT\n )`);\n\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS sesiones (\n chat_id INTEGER PRIMARY KEY,\n paso TEXT,\n nombre TEXT,\n grupo TEXT,\n importe REAL,\n fecha_pago TEXT\n )`);\n\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS grupos (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n chat_id INTEGER,\n nombre TEXT,\n UNIQUE(chat_id, nombre)\n )`);\n\n // Contador de numeración PROPIO de cada usuario (para /lista, /editar, /borrar).\n // Es independiente del \"id\" interno de la tabla items.\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS contadores (\n chat_id INTEGER PRIMARY KEY,\n siguiente INTEGER DEFAULT 1\n )`);\n\n // Columnas añadidas en versiones posteriores. Si ya existen, el error\n // se ignora (try/catch), así nunca perdemos datos al actualizar el código.\n const alters = [\n `ALTER TABLE items ADD COLUMN dias_aviso INTEGER DEFAULT 7`,\n `ALTER TABLE items ADD COLUMN pospuesto_hasta TEXT DEFAULT NULL`,\n `ALTER TABLE items ADD COLUMN esperando_confirmacion INTEGER DEFAULT 0`,\n `ALTER TABLE items ADD COLUMN empresa TEXT DEFAULT NULL`,\n `ALTER TABLE items ADD COLUMN numero INTEGER DEFAULT NULL`,\n `ALTER TABLE sesiones ADD COLUMN item_id INTEGER DEFAULT NULL`,\n `ALTER TABLE sesiones ADD COLUMN empresa TEXT DEFAULT NULL`,\n `ALTER TABLE sesiones ADD COLUMN campo_editar TEXT DEFAULT NULL`,\n ];\n for (const sql of alters) {\n try {\n await sqlite.execute(sql);\n } catch {\n // La columna ya existía, no pasa nada.\n }\n }\n}\n\nasync function asegurarGruposPorDefecto(chatId: number) {\n const res = await sqlite.execute(`SELECT id FROM grupos WHERE chat_id = ?`, [\n chatId,\n ]);\n if (res.rows.length === 0) {\n for (const g of GRUPOS_POR_DEFECTO) {\n await sqlite.execute(\n `INSERT INTO grupos (chat_id, nombre) VALUES (?, ?) ON CONFLICT(chat_id, nombre) DO NOTHING`,\n [chatId, g],\n );\n }\n }\n}\n\nasync function getGrupos(chatId: number): Promise {\n const res = await sqlite.execute(\n `SELECT nombre FROM grupos WHERE chat_id = ? ORDER BY nombre`,\n [chatId],\n );\n return res.rows.map((row: any) => val(row, 0, \"nombre\"));\n}\n\nasync function crearGrupoSiNoExiste(chatId: number, nombre: string) {\n await sqlite.execute(\n `INSERT INTO grupos (chat_id, nombre) VALUES (?, ?) ON CONFLICT(chat_id, nombre) DO NOTHING`,\n [chatId, nombre],\n );\n}\n\n// ============================================================\n// NUMERACIÓN PROPIA POR USUARIO\n// ============================================================\n\n// Devuelve el siguiente número disponible PARA ESTE USUARIO (empieza en 1)\n// y avanza el contador para la próxima vez.\nasync function getSiguienteNumero(chatId: number): Promise {\n await sqlite.execute(\n `INSERT INTO contadores (chat_id, siguiente) VALUES (?, 1) ON CONFLICT(chat_id) DO NOTHING`,\n [chatId],\n );\n const res = await sqlite.execute(\n `SELECT siguiente FROM contadores WHERE chat_id = ?`,\n [chatId],\n );\n const numero = Number(val(res.rows[0], 0, \"siguiente\"));\n await sqlite.execute(\n `UPDATE contadores SET siguiente = ? WHERE chat_id = ?`,\n [numero + 1, chatId],\n );\n return numero;\n}\n\n// Por si hay pagos antiguos guardados antes de existir esta numeración\n// (o creados justo cuando cambiamos el código): les asigna un número\n// propio, en el orden en que se crearon, la primera vez que hagan falta.\nasync function asegurarNumerosExistentes(chatId: number) {\n const res = await sqlite.execute(\n `SELECT id FROM items WHERE chat_id = ? AND numero IS NULL ORDER BY id ASC`,\n [chatId],\n );\n for (const row of res.rows as any[]) {\n const itemId = val(row, 0, \"id\");\n const numero = await getSiguienteNumero(chatId);\n await sqlite.execute(`UPDATE items SET numero = ? WHERE id = ?`, [\n numero,\n itemId,\n ]);\n }\n}\n\n// ============================================================\n// TELEGRAM: funciones auxiliares\n// ============================================================\nasync function sendMessage(chatId: number, text: string, replyMarkup?: object) {\n await fetch(`${API}/sendMessage`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ chat_id: chatId, text, reply_markup: replyMarkup }),\n });\n}\n\nasync function answerCallback(callbackId: string, text?: string) {\n await fetch(`${API}/answerCallbackQuery`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ callback_query_id: callbackId, text }),\n });\n}\n\nfunction botonesGrupos(grupos: string[]) {\n const filas = grupos.map((g) => [{ text: g, callback_data: `grupo:${g}` }]);\n filas.push([{ text: \"➕ Crear grupo nuevo\", callback_data: \"grupo_nuevo\" }]);\n return { inline_keyboard: filas };\n}\n\n// Botones para elegir qué campo modificar con /editar\nfunction botonesCamposEditar() {\n return {\n inline_keyboard: [\n [\n { text: \"✏️ Nombre\", callback_data: \"editar:nombre\" },\n { text: \"💶 Importe\", callback_data: \"editar:importe\" },\n ],\n [\n { text: \"📅 Fecha\", callback_data: \"editar:fecha\" },\n { text: \"🏢 Empresa\", callback_data: \"editar:empresa\" },\n ],\n [\n { text: \"🔔 Días de aviso\", callback_data: \"editar:dias_aviso\" },\n ],\n ],\n };\n}\n\n// ============================================================\n// FECHAS\n// ============================================================\nfunction parseFechaEspanola(texto: string): string | null {\n const partes = texto.trim().split(\"/\");\n if (partes.length !== 3) return null;\n const [dStr, mStr, yStr] = partes;\n const d = Number(dStr), m = Number(mStr), y = Number(yStr);\n if (!d || !m || !y) return null;\n const fecha = new Date(y, m - 1, d);\n if (\n fecha.getDate() !== d || fecha.getMonth() !== m - 1 ||\n fecha.getFullYear() !== y\n ) return null;\n return `${y}-${String(m).padStart(2, \"0\")}-${String(d).padStart(2, \"0\")}`;\n}\n\nfunction formatFechaEspanola(iso: string): string {\n const [y, m, d] = iso.split(\"-\");\n return `${d}/${m}/${y}`;\n}\n\nfunction iconoGrupo(grupo: string): string {\n const g = grupo.toLowerCase();\n if (g.includes(\"seguro\")) return \"🛡️\";\n if (g.includes(\"impuesto\")) return \"🏛️\";\n return \"📌\";\n}\n\nfunction diasHasta(iso: string): number {\n const hoy = new Date();\n hoy.setHours(0, 0, 0, 0);\n const [y, m, d] = iso.split(\"-\").map(Number);\n const fecha = new Date(y, m - 1, d);\n return Math.round((fecha.getTime() - hoy.getTime()) / (1000 * 60 * 60 * 24));\n}\n\n// ============================================================\n// SESIONES\n// ============================================================\nasync function getSesion(chatId: number) {\n const res = await sqlite.execute(\n `SELECT paso, nombre, grupo, empresa, importe, fecha_pago, item_id, campo_editar FROM sesiones WHERE chat_id = ?`,\n [chatId],\n );\n const row = res.rows[0];\n if (!row) return null;\n return {\n paso: val(row, 0, \"paso\") as string,\n nombre: val(row, 1, \"nombre\") as string | null,\n grupo: val(row, 2, \"grupo\") as string | null,\n empresa: val(row, 3, \"empresa\") as string | null,\n importe: val(row, 4, \"importe\") as number | null,\n fecha_pago: val(row, 5, \"fecha_pago\") as string | null,\n item_id: val(row, 6, \"item_id\") as number | null,\n campo_editar: val(row, 7, \"campo_editar\") as string | null,\n };\n}\n\nasync function guardarSesion(\n chatId: number,\n paso: string,\n campos: {\n nombre?: string | null;\n grupo?: string | null;\n empresa?: string | null;\n importe?: number | null;\n fecha_pago?: string | null;\n item_id?: number | null;\n campo_editar?: string | null;\n },\n) {\n await sqlite.execute(\n `INSERT INTO sesiones (chat_id, paso, nombre, grupo, empresa, importe, fecha_pago, item_id, campo_editar)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(chat_id) DO UPDATE SET\n paso = excluded.paso, nombre = excluded.nombre, grupo = excluded.grupo, empresa = excluded.empresa,\n importe = excluded.importe, fecha_pago = excluded.fecha_pago, item_id = excluded.item_id,\n campo_editar = excluded.campo_editar`,\n [\n chatId,\n paso,\n campos.nombre ?? null,\n campos.grupo ?? null,\n campos.empresa ?? null,\n campos.importe ?? null,\n campos.fecha_pago ?? null,\n campos.item_id ?? null,\n campos.campo_editar ?? null,\n ],\n );\n}\n\nasync function borrarSesion(chatId: number) {\n await sqlite.execute(`DELETE FROM sesiones WHERE chat_id = ?`, [chatId]);\n}\n\n// ============================================================\n// RENOVACIÓN\n// ============================================================\nasync function aplicarRenovacion(itemId: number, importeNuevo: number) {\n const res = await sqlite.execute(\n `SELECT fecha_pago FROM items WHERE id = ?`,\n [itemId],\n );\n const row = res.rows[0];\n if (!row) return null;\n\n const fechaAnterior = val(row, 0, \"fecha_pago\") as string;\n const [y, m, d] = fechaAnterior.split(\"-\").map(Number);\n const nuevaFecha = new Date(y + 1, m - 1, d);\n const fechaNuevaIso = `${nuevaFecha.getFullYear()}-${\n String(nuevaFecha.getMonth() + 1).padStart(2, \"0\")\n }-${String(nuevaFecha.getDate()).padStart(2, \"0\")}`;\n\n await sqlite.execute(\n `UPDATE items SET importe = ?, fecha_pago = ?, pospuesto_hasta = NULL, esperando_confirmacion = 0 WHERE id = ?`,\n [importeNuevo, fechaNuevaIso, itemId],\n );\n\n return { fechaAnterior, fechaNuevaIso };\n}\n\n// ============================================================\n// HANDLER PRINCIPAL\n// ============================================================\nexport default async function (req: Request): Promise {\n if (req.method === \"GET\") {\n return new Response(\"🤖 Bot de recordatorios de pagos funcionando.\", {\n headers: { \"Content-Type\": \"text/plain\" },\n });\n }\n if (!TOKEN) {\n return new Response(\"Falta TELEGRAM_BOT_TOKEN\", { status: 500 });\n }\n\n await initDb();\n const update = await req.json();\n\n // ------------------------------------------------------------\n // CASO A: botón pulsado\n // ------------------------------------------------------------\n if (update.callback_query) {\n const cq = update.callback_query;\n const chatId = cq.message.chat.id;\n const data: string = cq.data;\n\n // --- Botón \"✅ Ya renovado\" ---\n if (data.startsWith(\"renovado:\")) {\n const itemId = Number(data.split(\":\")[1]);\n await answerCallback(cq.id, \"Vale\");\n await guardarSesion(chatId, \"esperando_importe_renovacion\", {\n item_id: itemId,\n });\n await sendMessage(\n chatId,\n \"Genial 🎉 ¿Por cuánto dinero se ha renovado? (ej: 480.20)\",\n );\n return new Response(\"ok\");\n }\n\n // --- Botón \"❌ Aún no\" ---\n if (data.startsWith(\"aun_no:\")) {\n await answerCallback(cq.id, \"Vale, te lo seguiré preguntando\");\n await sendMessage(\n chatId,\n \"Entendido, te lo volveré a preguntar mañana si sigue sin renovarse.\",\n );\n return new Response(\"ok\");\n }\n\n // --- Botones de POSPONER ---\n if (data.startsWith(\"posponer:\")) {\n const [, idStr, opcion] = data.split(\":\");\n const itemId = Number(idStr);\n\n const res = await sqlite.execute(\n `SELECT fecha_pago FROM items WHERE id = ?`,\n [itemId],\n );\n const row = res.rows[0];\n if (!row) {\n await answerCallback(cq.id, \"Este pago ya no existe.\");\n return new Response(\"ok\");\n }\n const fechaPago = val(row, 0, \"fecha_pago\") as string;\n\n let pospuestoHasta: string;\n let textoConfirmacion: string;\n const hoy = new Date();\n\n if (opcion === \"semana\") {\n const en7dias = new Date(hoy);\n en7dias.setDate(en7dias.getDate() + 7);\n pospuestoHasta = `${en7dias.getFullYear()}-${\n String(en7dias.getMonth() + 1).padStart(2, \"0\")\n }-${String(en7dias.getDate()).padStart(2, \"0\")}`;\n textoConfirmacion = \"Vale, te lo recuerdo de nuevo en 1 semana.\";\n } else if (opcion === \"mes\") {\n const en30dias = new Date(hoy);\n en30dias.setDate(en30dias.getDate() + 30);\n pospuestoHasta = `${en30dias.getFullYear()}-${\n String(en30dias.getMonth() + 1).padStart(2, \"0\")\n }-${String(en30dias.getDate()).padStart(2, \"0\")}`;\n textoConfirmacion = \"Vale, te lo recuerdo de nuevo en 1 mes.\";\n } else {\n pospuestoHasta = fechaPago;\n textoConfirmacion =\n \"Vale, no te aviso más hasta el próximo vencimiento.\";\n }\n\n await sqlite.execute(\n `UPDATE items SET pospuesto_hasta = ? WHERE id = ?`,\n [pospuestoHasta, itemId],\n );\n await answerCallback(cq.id, \"Anotado\");\n await sendMessage(chatId, textoConfirmacion);\n return new Response(\"ok\");\n }\n\n // --- Botones de EDITAR (elegir qué campo modificar) ---\n if (data.startsWith(\"editar:\")) {\n const campo = data.replace(\"editar:\", \"\");\n const sesionActual = await getSesion(chatId);\n if (\n !sesionActual || sesionActual.paso !== \"esperando_campo_editar\" ||\n !sesionActual.item_id\n ) {\n await answerCallback(\n cq.id,\n \"Esto ya no está en curso, usa /editar de nuevo.\",\n );\n return new Response(\"ok\");\n }\n await answerCallback(cq.id);\n await guardarSesion(chatId, \"esperando_valor_edicion\", {\n item_id: sesionActual.item_id,\n campo_editar: campo,\n });\n\n const preguntas: Record = {\n nombre: \"¿Cuál es el nuevo nombre?\",\n importe: \"¿Cuál es el nuevo importe? (ej: 145.50)\",\n fecha: \"¿Cuál es la nueva fecha? Formato DD/MM/AAAA (ej: 15/03/2027)\",\n empresa: '¿Cuál es la nueva empresa? (escribe \"-\" para quitarla)',\n dias_aviso:\n \"¿Con cuántos días de antelación quieres que te avise? (un número entre 0 y 365)\",\n };\n await sendMessage(chatId, preguntas[campo] ?? \"¿Cuál es el nuevo valor?\");\n return new Response(\"ok\");\n }\n\n // --- Botones del ALTA (elegir grupo al hacer /añadir) ---\n const sesion = await getSesion(chatId);\n if (!sesion || sesion.paso !== \"esperando_grupo\") {\n await answerCallback(\n cq.id,\n \"Esto ya no está en curso, usa /añadir para empezar de nuevo.\",\n );\n return new Response(\"ok\");\n }\n\n if (data === \"grupo_nuevo\") {\n await answerCallback(cq.id);\n await guardarSesion(chatId, \"esperando_nombre_grupo_nuevo\", {\n nombre: sesion.nombre,\n });\n await sendMessage(\n chatId,\n \"¿Cómo quieres llamar al grupo nuevo? (ej: Comunidad, Suministros...)\",\n );\n } else if (data.startsWith(\"grupo:\")) {\n const grupoElegido = data.replace(\"grupo:\", \"\");\n await answerCallback(cq.id, `Grupo: ${grupoElegido}`);\n await guardarSesion(chatId, \"esperando_empresa\", {\n nombre: sesion.nombre,\n grupo: grupoElegido,\n });\n await sendMessage(\n chatId,\n `Grupo \"${grupoElegido}\" ✅\\n¿Con qué empresa es \"${sesion.nombre}\"? (ej: Allianz, Banc Sabadell, Ayuntamiento...)\\nSi no aplica, escribe \"-\"`,\n );\n }\n return new Response(\"ok\");\n }\n\n // ------------------------------------------------------------\n // CASO B: mensaje de texto\n // ------------------------------------------------------------\n const message = update.message;\n if (!message?.text) return new Response(\"ok\");\n\n const chatId = message.chat.id;\n const text = message.text.trim();\n\n if (text.startsWith(\"/\")) {\n await borrarSesion(chatId);\n await asegurarGruposPorDefecto(chatId);\n await asegurarNumerosExistentes(chatId);\n\n if (text === \"/start\") {\n await sendMessage(\n chatId,\n `👋 Hola! Soy tu bot de recordatorios de pagos.\\n\\nComandos:\\n/añadir — dar de alta un pago (ej: /añadir Coche)\\n/lista — ver todos tus pagos\\n/editar — modificar nombre, importe, fecha o empresa de un pago\\n/grupos — ver tus grupos\\n/borrar — eliminar uno\\n/cancelar — cancelar lo que esté en curso`,\n );\n } else if (text.startsWith(\"/añadir\")) {\n const nombre = text.replace(\"/añadir\", \"\").trim();\n if (!nombre) {\n await sendMessage(\n chatId,\n \"Formato: /añadir \\nEj: /añadir Coche\",\n );\n } else {\n const grupos = await getGrupos(chatId);\n await guardarSesion(chatId, \"esperando_grupo\", { nombre });\n await sendMessage(\n chatId,\n `¿A qué grupo pertenece \"${nombre}\"?`,\n botonesGrupos(grupos),\n );\n }\n } else if (text === \"/grupos\") {\n const grupos = await getGrupos(chatId);\n await sendMessage(\n chatId,\n `📂 Tus grupos:\\n${grupos.map((g) => `- ${g}`).join(\"\\n\")}`,\n );\n } else if (text === \"/lista\") {\n const res = await sqlite.execute(\n `SELECT numero, grupo, nombre, empresa, importe, fecha_pago, dias_aviso FROM items WHERE chat_id = ? ORDER BY fecha_pago ASC`,\n [chatId],\n );\n if (res.rows.length === 0) {\n await sendMessage(\n chatId,\n \"No tienes ningún pago guardado todavía. Usa /añadir para crear el primero.\",\n );\n } else {\n const lineas = res.rows.map((row: any) => {\n const numero = val(row, 0, \"numero\");\n const grupo = val(row, 1, \"grupo\");\n const nombre = val(row, 2, \"nombre\");\n const empresa = val(row, 3, \"empresa\");\n const importe = val(row, 4, \"importe\");\n const fechaIso = val(row, 5, \"fecha_pago\");\n const diasAviso = val(row, 6, \"dias_aviso\");\n const dias = diasHasta(fechaIso);\n const diasTexto = dias < 0\n ? `hace ${\n Math.abs(dias)\n } días (¡pendiente de confirmar renovación!)`\n : dias === 0\n ? \"¡hoy!\"\n : `en ${dias} días`;\n const empresaTexto = empresa ? ` (${empresa})` : \"\";\n return `${\n iconoGrupo(grupo)\n } #${numero} ${grupo} - ${nombre}${empresaTexto}: ${\n Number(importe).toFixed(2)\n }€ el ${\n formatFechaEspanola(fechaIso)\n } (${diasTexto}) · aviso: ${diasAviso}d antes`;\n });\n await sendMessage(chatId, `📋 Tus pagos:\\n\\n${lineas.join(\"\\n\")}`);\n }\n } else if (text.startsWith(\"/editar\")) {\n const numStr = text.replace(\"/editar\", \"\").trim();\n const numero = Number(numStr);\n if (!numero) {\n await sendMessage(\n chatId,\n \"Formato: /editar \\nEj: /editar 3 (usa /lista para ver los números)\",\n );\n } else {\n const res = await sqlite.execute(\n `SELECT id FROM items WHERE numero = ? AND chat_id = ?`,\n [numero, chatId],\n );\n const row = res.rows[0];\n if (!row) {\n await sendMessage(\n chatId,\n `No encuentro ningún pago con el número ${numero}. Usa /lista para ver los tuyos.`,\n );\n } else {\n const itemId = val(row, 0, \"id\");\n await guardarSesion(chatId, \"esperando_campo_editar\", {\n item_id: itemId,\n });\n await sendMessage(\n chatId,\n `¿Qué quieres modificar del pago #${numero}?`,\n botonesCamposEditar(),\n );\n }\n }\n } else if (text.startsWith(\"/borrar\")) {\n const numStr = text.replace(\"/borrar\", \"\").trim();\n const numero = Number(numStr);\n if (!numero) {\n await sendMessage(\n chatId,\n \"Formato: /borrar \\nEj: /borrar 3 (usa /lista para ver los números)\",\n );\n } else {\n await sqlite.execute(\n `DELETE FROM items WHERE numero = ? AND chat_id = ?`,\n [numero, chatId],\n );\n await sendMessage(chatId, `Eliminado el pago #${numero} (si existía).`);\n }\n } else if (text === \"/cancelar\") {\n await sendMessage(chatId, \"Todo cancelado.\");\n } else {\n await sendMessage(\n chatId,\n \"No entiendo ese comando. Prueba /añadir, /lista, /editar, /grupos o /borrar.\",\n );\n }\n\n return new Response(\"ok\");\n }\n\n // ------------------------------------------------------------\n // Si NO es un comando, miramos en qué paso de conversación está el usuario\n // ------------------------------------------------------------\n const sesion = await getSesion(chatId);\n if (!sesion) {\n await sendMessage(\n chatId,\n \"No entiendo ese mensaje. Prueba /añadir, /lista o /borrar.\",\n );\n return new Response(\"ok\");\n }\n\n if (sesion.paso === \"esperando_nombre_grupo_nuevo\") {\n const nombreGrupo = text;\n await crearGrupoSiNoExiste(chatId, nombreGrupo);\n await guardarSesion(chatId, \"esperando_empresa\", {\n nombre: sesion.nombre,\n grupo: nombreGrupo,\n });\n await sendMessage(\n chatId,\n `Grupo \"${nombreGrupo}\" creado ✅\\n¿Con qué empresa es \"${sesion.nombre}\"? (ej: Allianz, Banc Sabadell, Ayuntamiento...)\\nSi no aplica, escribe \"-\"`,\n );\n return new Response(\"ok\");\n }\n\n if (sesion.paso === \"esperando_empresa\") {\n const empresa = text === \"-\" ? null : text;\n await guardarSesion(chatId, \"esperando_importe\", {\n nombre: sesion.nombre,\n grupo: sesion.grupo,\n empresa,\n });\n await sendMessage(\n chatId,\n `¿Qué importe tiene \"${sesion.nombre}\"? (ej: 145.50)`,\n );\n return new Response(\"ok\");\n }\n\n if (sesion.paso === \"esperando_importe\") {\n const importe = parseFloat(text.replace(\",\", \".\"));\n if (isNaN(importe)) {\n await sendMessage(\n chatId,\n \"Eso no parece un número. Dime el importe, ej: 145.50\",\n );\n } else {\n await guardarSesion(chatId, \"esperando_fecha\", {\n nombre: sesion.nombre,\n grupo: sesion.grupo,\n empresa: sesion.empresa,\n importe,\n });\n await sendMessage(\n chatId,\n \"¿Qué día se pagó? Formato: DD/MM/AAAA (ej: 15/03/2026)\",\n );\n }\n return new Response(\"ok\");\n }\n\n if (sesion.paso === \"esperando_fecha\") {\n let fechaIso = parseFechaEspanola(text);\n if (!fechaIso) {\n await sendMessage(\n chatId,\n \"Fecha no válida. Usa el formato DD/MM/AAAA, ej: 15/03/2026\",\n );\n return new Response(\"ok\");\n }\n\n // Si la fecha ya ha pasado, sumamos años automáticamente hasta que\n // caiga en el futuro (es normal poner el último pago hecho al dar de alta).\n let fechaOriginal: string | null = null;\n while (diasHasta(fechaIso) < 0) {\n if (!fechaOriginal) fechaOriginal = fechaIso;\n const [y, m, d] = fechaIso.split(\"-\").map(Number);\n const siguiente = new Date(y + 1, m - 1, d);\n fechaIso = `${siguiente.getFullYear()}-${\n String(siguiente.getMonth() + 1).padStart(2, \"0\")\n }-${String(siguiente.getDate()).padStart(2, \"0\")}`;\n }\n\n await guardarSesion(chatId, \"esperando_dias_aviso\", {\n nombre: sesion.nombre,\n grupo: sesion.grupo,\n empresa: sesion.empresa,\n importe: sesion.importe,\n fecha_pago: fechaIso,\n });\n\n if (fechaOriginal) {\n await sendMessage(\n chatId,\n `Esa fecha ya pasó, así que he calculado el próximo vencimiento: ${\n formatFechaEspanola(fechaIso)\n }.\\n\\n¿Con cuántos días de antelación quieres que te avise? (un número entre 0 y 365, ej: 7)`,\n );\n } else {\n await sendMessage(\n chatId,\n \"¿Con cuántos días de antelación quieres que te avise? (un número entre 0 y 365, ej: 7)\",\n );\n }\n return new Response(\"ok\");\n }\n\n if (sesion.paso === \"esperando_dias_aviso\") {\n const diasAviso = parseInt(text, 10);\n if (isNaN(diasAviso) || diasAviso < 0 || diasAviso > 365) {\n await sendMessage(chatId, \"Dame un número entre 0 y 365, ej: 7\");\n } else {\n const numero = await getSiguienteNumero(chatId);\n await sqlite.execute(\n `INSERT INTO items (chat_id, grupo, nombre, empresa, importe, fecha_pago, dias_aviso, pospuesto_hasta, esperando_confirmacion, numero)\n VALUES (?, ?, ?, ?, ?, ?, ?, NULL, 0, ?)`,\n [\n chatId,\n sesion.grupo,\n sesion.nombre,\n sesion.empresa,\n sesion.importe,\n sesion.fecha_pago,\n diasAviso,\n numero,\n ],\n );\n await borrarSesion(chatId);\n await sendMessage(\n chatId,\n `✅ Guardado (#${numero}): ${sesion.grupo} - ${sesion.nombre}${\n sesion.empresa ? ` (${sesion.empresa})` : \"\"\n }, ${(sesion.importe as number).toFixed(2)}€, vence el ${\n formatFechaEspanola(sesion.fecha_pago as string)\n }.\\nTe avisaré ${diasAviso} día(s) antes.`,\n );\n }\n return new Response(\"ok\");\n }\n\n if (sesion.paso === \"esperando_importe_renovacion\") {\n const importeNuevo = parseFloat(text.replace(\",\", \".\"));\n if (isNaN(importeNuevo)) {\n await sendMessage(\n chatId,\n \"Eso no parece un número. Dime el importe nuevo, ej: 480.20\",\n );\n } else {\n const resultado = await aplicarRenovacion(\n sesion.item_id as number,\n importeNuevo,\n );\n await borrarSesion(chatId);\n if (!resultado) {\n await sendMessage(\n chatId,\n \"No he encontrado ese pago, puede que se haya borrado.\",\n );\n } else {\n await sendMessage(\n chatId,\n `✅ Renovado por ${importeNuevo.toFixed(2)}€. Próximo vencimiento: ${\n formatFechaEspanola(resultado.fechaNuevaIso)\n }.`,\n );\n }\n }\n return new Response(\"ok\");\n }\n\n // --- Paso: valor nuevo tras /editar (nombre, importe, fecha o empresa) ---\n if (sesion.paso === \"esperando_valor_edicion\") {\n const itemId = sesion.item_id as number;\n const campo = sesion.campo_editar as string;\n\n if (campo === \"nombre\") {\n await sqlite.execute(\n `UPDATE items SET nombre = ? WHERE id = ? AND chat_id = ?`,\n [text, itemId, chatId],\n );\n await borrarSesion(chatId);\n await sendMessage(chatId, `✅ Nombre actualizado a \"${text}\".`);\n } else if (campo === \"importe\") {\n const nuevoImporte = parseFloat(text.replace(\",\", \".\"));\n if (isNaN(nuevoImporte)) {\n await sendMessage(\n chatId,\n \"Eso no parece un número. Dime el importe, ej: 145.50\",\n );\n return new Response(\"ok\"); // se queda esperando un valor válido, no cancelamos\n }\n await sqlite.execute(\n `UPDATE items SET importe = ? WHERE id = ? AND chat_id = ?`,\n [nuevoImporte, itemId, chatId],\n );\n await borrarSesion(chatId);\n await sendMessage(\n chatId,\n `✅ Importe actualizado a ${nuevoImporte.toFixed(2)}€.`,\n );\n } else if (campo === \"fecha\") {\n const fechaIso = parseFechaEspanola(text);\n if (!fechaIso) {\n await sendMessage(\n chatId,\n \"Fecha no válida. Usa el formato DD/MM/AAAA, ej: 15/03/2027\",\n );\n return new Response(\"ok\");\n }\n await sqlite.execute(\n `UPDATE items SET fecha_pago = ? WHERE id = ? AND chat_id = ?`,\n [fechaIso, itemId, chatId],\n );\n await borrarSesion(chatId);\n await sendMessage(\n chatId,\n `✅ Fecha actualizada a ${formatFechaEspanola(fechaIso)}.`,\n );\n } else if (campo === \"empresa\") {\n const empresa = text === \"-\" ? null : text;\n await sqlite.execute(\n `UPDATE items SET empresa = ? WHERE id = ? AND chat_id = ?`,\n [empresa, itemId, chatId],\n );\n await borrarSesion(chatId);\n await sendMessage(\n chatId,\n `✅ Empresa actualizada${empresa ? ` a \"${empresa}\"` : \" (quitada)\"}.`,\n );\n } else if (campo === \"dias_aviso\") {\n const diasAviso = parseInt(text, 10);\n if (isNaN(diasAviso) || diasAviso < 0 || diasAviso > 365) {\n await sendMessage(chatId, \"Dame un número entre 0 y 365, ej: 7\");\n return new Response(\"ok\"); // se queda esperando un valor válido, no cancelamos\n }\n await sqlite.execute(\n `UPDATE items SET dias_aviso = ? WHERE id = ? AND chat_id = ?`,\n [diasAviso, itemId, chatId],\n );\n await borrarSesion(chatId);\n await sendMessage(\n chatId,\n `✅ Días de aviso actualizados a ${diasAviso}.`,\n );\n }\n return new Response(\"ok\");\n }\n\n return new Response(\"ok\");\n}","label",[77],"ae843c11-8473-4732-88e4-70979b8f36e4",["D",1783660234363],"// ============================================================\n// CRON: revisa todos los pagos guardados, una vez al día.\n//\n// Para cada pago:\n// - Si ya ha vencido (fecha_pago en el pasado): pregunta \"¿se ha\n// renovado?\" con botones Sí/Aún no. Se repite cada día hasta que\n// el usuario confirme la renovación (desde el val principal).\n// - Si falta <= dias_aviso días para vencer, y no está pospuesto:\n// manda el aviso con 4 botones (Ya renovado / 1 semana / 1 mes / Nunca).\n// ============================================================\n\nimport { 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\n// ============================================================\n// Mismo helper que en main.ts: sqlite.execute puede devolver cada\n// fila como array (row[0]) o como objeto (row.columna). Esta función\n// funciona con los dos formatos, para no depender de cuál usa Val Town\n// en cada momento.\n// ============================================================\nfunction val(row: any, index: number, key: string) {\n if (Array.isArray(row)) return row[index];\n return row[key];\n}\n\nasync function sendMessage(chatId: number, text: string, replyMarkup?: object) {\n await fetch(`${API}/sendMessage`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ chat_id: chatId, text, reply_markup: replyMarkup }),\n });\n}\n\nfunction formatFechaEspanola(iso: string): string {\n const [y, m, d] = iso.split(\"-\");\n return `${d}/${m}/${y}`;\n}\n\nfunction diasHasta(iso: string): number {\n const hoy = new Date();\n hoy.setHours(0, 0, 0, 0);\n const [y, m, d] = iso.split(\"-\").map(Number);\n const fecha = new Date(y, m - 1, d);\n return Math.round((fecha.getTime() - hoy.getTime()) / (1000 * 60 * 60 * 24));\n}\n\nfunction hoyIso(): string {\n const hoy = new Date();\n return `${hoy.getFullYear()}-${String(hoy.getMonth() + 1).padStart(2, \"0\")}-${\n String(hoy.getDate()).padStart(2, \"0\")\n }`;\n}\n\n// Botones para cuando el pago ya ha vencido\nfunction botonesVencido(itemId: number) {\n return {\n inline_keyboard: [[\n { text: \"✅ Sí, renovado\", callback_data: `renovado:${itemId}` },\n { text: \"❌ Aún no\", callback_data: `aun_no:${itemId}` },\n ]],\n };\n}\n\n// Botones para el aviso previo al vencimiento\nfunction botonesAvisoPrevio(itemId: number) {\n return {\n inline_keyboard: [\n [{ text: \"✅ Ya renovado\", callback_data: `renovado:${itemId}` }],\n [\n { text: \"🔁 1 semana\", callback_data: `posponer:${itemId}:semana` },\n { text: \"🔁 1 mes\", callback_data: `posponer:${itemId}:mes` },\n { text: \"🚫 Nunca\", callback_data: `posponer:${itemId}:nunca` },\n ],\n ],\n };\n}\n\nexport default async function () {\n const res = await sqlite.execute(\n `SELECT id, chat_id, grupo, nombre, importe, fecha_pago, dias_aviso, pospuesto_hasta FROM items`,\n );\n\n const hoy = hoyIso();\n\n for (const row of res.rows as any[]) {\n const id = val(row, 0, \"id\");\n const chatId = val(row, 1, \"chat_id\");\n const grupo = val(row, 2, \"grupo\");\n const nombre = val(row, 3, \"nombre\");\n const importe = val(row, 4, \"importe\");\n const fechaIso = val(row, 5, \"fecha_pago\");\n const diasAviso = val(row, 6, \"dias_aviso\");\n const pospuestoHasta = val(row, 7, \"pospuesto_hasta\");\n\n const dias = diasHasta(fechaIso);\n\n // --- CASO 1: ya ha vencido -> preguntamos si se ha renovado ---\n if (dias < 0) {\n await sendMessage(\n chatId,\n `📌 \"${grupo} - ${nombre}\" (${Number(importe).toFixed(2)}€) venció el ${\n formatFechaEspanola(fechaIso)\n }.\\n¿Se ha renovado ya?`,\n botonesVencido(id),\n );\n continue; // no hace falta mirar nada más de este item hoy\n }\n\n // --- CASO 2: todavía no ha vencido -> ¿toca avisar? ---\n if (dias > diasAviso) continue; // aún faltan más días de los que pediste\n if (pospuestoHasta && hoy < pospuestoHasta) continue; // el usuario pidió esperar\n\n const diasTexto = dias === 0 ? \"¡es hoy!\" : `en ${dias} día(s)`;\n await sendMessage(\n chatId,\n `⏰ \"${grupo} - ${nombre}\" (${\n Number(importe).toFixed(2)\n }€) vence ${diasTexto} (${formatFechaEspanola(fechaIso)}).`,\n botonesAvisoPrevio(id),\n );\n }\n\n return new Response(\"ok\");\n}",[122],"pulls","branches","forks","envVars",{"_315":53,"_317":20},"connections",{"_315":20,"_316":20},"count","unfilledCount","emptyCount",{"_46":304,"_13":122,"_75":106,"_56":-5,"_48":49,"_297":154,"_298":289,"_50":324,"_52":110,"_78":144,"_300":306,"_80":24,"_302":-5,"_321":325,"_272":326},{"_46":296,"_13":77,"_75":76,"_56":-5,"_48":49,"_297":217,"_298":289,"_50":320,"_52":168,"_78":98,"_300":301,"_80":24,"_302":-5,"_321":322,"_272":323},["D",1784704694703],"children",[],[77],["D",1783660234363],[],[122],["D",1783596784491],["D",1789437645046],{"_11":12,"_271":83},{"_11":12,"_267":83,"_82":83,"_25":81,"_268":269,"_270":24},{"_52":217,"_13":16,"_46":49,"_259":222,"_260":-5,"_261":-5,"_262":-5,"_263":-5,"_264":-5,"_265":14,"_266":12},"ctx",{"_64":-5,"_291":365,"_366":367,"_368":369,"_370":24,"_371":24,"_372":24,"_373":289,"_374":-5,"_375":-7,"_376":-7,"_377":20,"_378":24,"_379":24,"_380":-5,"_381":24,"_382":24,"_383":24,"_384":-5},"ENV",{"_336":337,"_338":339,"_340":16,"_341":342,"_343":344,"_345":346,"_347":348,"_349":350,"_351":352,"_353":354,"_355":356,"_357":358,"_359":360,"_361":362,"_363":364},"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