[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_170":171,"_172":173},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_128":-5,"_20":129,"_22":130,"_131":132,"_133":134,"_26":135,"_24":136,"_137":-5,"_138":-5,"_139":64,"_140":141,"_142":58,"_143":-5,"_144":-5,"_145":146},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","lucero_cabrera_moya","name","AGENDA-MEDICA-LCDV","branchName","main","version","path","main.ts","project",{"_33":71,"_13":14,"_45":72,"_73":-5,"_74":64,"_75":76,"_77":76,"_78":-5,"_79":-5,"_80":81,"_82":38,"_83":58,"_84":-5,"_85":-5,"_86":60,"_87":88,"_89":90,"_91":92,"_93":94,"_95":-5,"_96":97,"_98":97,"_99":100,"_101":100,"_102":100,"_103":97,"_104":97,"_105":106,"_107":108,"_109":110,"_111":64},"tree",[51,52],"file",{"_33":34,"_35":36,"_37":38,"_13":19,"_39":40,"_41":42,"_17":43,"_44":-5,"_45":46,"_47":48,"_49":-5,"_18":50},"contents",[],"upstream","pull","ahead","behind","envVars","id","aac4ca82-db7a-4c2a-a8b5-34ff8715adf0","branchId","4e70f432-6a5a-4bd8-92e0-2201a3b3803e","fileId","c8220b7c-7caa-11f1-8212-1607ee4eb77e","content","// AGENDA MÉDICA WEB — Consulta Externa\n// Multi-médico · turnos 08:00/09:00 · agenda especial de cardiología (consultas 40 min + ECO 1 hr)\n// Pega este archivo completo en tu val HTTP de https://val.town (reemplaza todo el código).\n// Clave por defecto: \"clinica2026\" (cámbiala con la variable de entorno CLAVE_AGENDA).\n\nimport { Hono } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst CLAVE = () => Deno.env.get(\"CLAVE_AGENDA\") || \"clinica2026\";\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS medicos (\n id TEXT PRIMARY KEY, nombre TEXT NOT NULL, especialidad TEXT DEFAULT ''\n)`);\ntry {\n await sqlite.execute(\n `ALTER TABLE medicos ADD COLUMN turno TEXT DEFAULT '09:00'`,\n );\n} catch (_e) { /* ya existe */ }\ntry {\n await sqlite.execute(\n `ALTER TABLE medicos ADD COLUMN modo TEXT DEFAULT 'normal'`,\n );\n} catch (_e) { /* ya existe */ }\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS citas (\n medico TEXT, fecha TEXT, hora TEXT,\n nombre TEXT DEFAULT '', curp TEXT DEFAULT '', tel TEXT DEFAULT '',\n PRIMARY KEY (medico, fecha, hora)\n)`);\ntry {\n await sqlite.execute(\n `ALTER TABLE citas ADD COLUMN tipo TEXT DEFAULT 'consulta'`,\n );\n} catch (_e) { /* ya existe */ }\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS obs (\n medico TEXT, fecha TEXT, texto TEXT DEFAULT '',\n PRIMARY KEY (medico, fecha)\n)`);\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\n// ---------- API ----------\napp.use(\"/api/*\", async (c, next) => {\n if (c.req.header(\"x-clave\") !== CLAVE()) {\n return c.json({ error: \"clave\" }, 401);\n }\n await next();\n});\n\napp.post(\"/api/login\", (c) => c.json({ ok: true }));\n\napp.get(\"/api/medicos\", async (c) => {\n const r = await sqlite.execute(\"SELECT * FROM medicos ORDER BY nombre\");\n return c.json(r.rows);\n});\napp.post(\"/api/medicos\", async (c) => {\n const b = await c.req.json();\n const id = \"m\" + Date.now();\n await sqlite.execute({\n sql:\n \"INSERT INTO medicos (id, nombre, especialidad, turno, modo) VALUES (?, ?, ?, ?, ?)\",\n args: [\n id,\n b.nombre,\n b.especialidad || \"\",\n b.turno === \"08:00\" ? \"08:00\" : \"09:00\",\n b.modo === \"cardio\" ? \"cardio\" : \"normal\",\n ],\n });\n return c.json({ id });\n});\napp.put(\"/api/medicos/:id\", async (c) => {\n const b = await c.req.json();\n await sqlite.execute({\n sql:\n \"UPDATE medicos SET nombre = ?, especialidad = ?, turno = ?, modo = ? WHERE id = ?\",\n args: [\n b.nombre,\n b.especialidad || \"\",\n b.turno === \"08:00\" ? \"08:00\" : \"09:00\",\n b.modo === \"cardio\" ? \"cardio\" : \"normal\",\n c.req.param(\"id\"),\n ],\n });\n return c.json({ ok: true });\n});\napp.delete(\"/api/medicos/:id\", async (c) => {\n const id = c.req.param(\"id\");\n await sqlite.batch([\n { sql: \"DELETE FROM medicos WHERE id = ?\", args: [id] },\n { sql: \"DELETE FROM citas WHERE medico = ?\", args: [id] },\n { sql: \"DELETE FROM obs WHERE medico = ?\", args: [id] },\n ]);\n return c.json({ ok: true });\n});\n\napp.get(\"/api/dia\", async (c) => {\n const medico = c.req.query(\"medico\"), fecha = c.req.query(\"fecha\");\n const citas = await sqlite.execute({\n sql:\n \"SELECT hora, nombre, curp, tel, tipo FROM citas WHERE medico = ? AND fecha = ?\",\n args: [medico, fecha],\n });\n const o = await sqlite.execute({\n sql: \"SELECT texto FROM obs WHERE medico = ? AND fecha = ?\",\n args: [medico, fecha],\n });\n const slots: Record = {};\n for (const r of citas.rows) {\n slots[r.hora as string] = {\n nombre: r.nombre,\n curp: r.curp,\n tel: r.tel,\n tipo: r.tipo || \"consulta\",\n };\n }\n return c.json({ slots, obs: o.rows[0]?.texto || \"\" });\n});\n\napp.post(\"/api/cita\", async (c) => {\n const b = await c.req.json();\n const vacio =\n !((b.nombre || \"\").trim() || (b.curp || \"\").trim() || (b.tel || \"\").trim());\n if (vacio) {\n await sqlite.execute({\n sql: \"DELETE FROM citas WHERE medico = ? AND fecha = ? AND hora = ?\",\n args: [b.medico, b.fecha, b.hora],\n });\n } else {\n await sqlite.execute({\n sql:\n `INSERT INTO citas (medico, fecha, hora, nombre, curp, tel, tipo) VALUES (?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(medico, fecha, hora) DO UPDATE SET nombre = excluded.nombre, curp = excluded.curp, tel = excluded.tel, tipo = excluded.tipo`,\n args: [\n b.medico,\n b.fecha,\n b.hora,\n b.nombre || \"\",\n (b.curp || \"\").toUpperCase(),\n b.tel || \"\",\n b.tipo === \"eco\" ? \"eco\" : \"consulta\",\n ],\n });\n }\n return c.json({ ok: true });\n});\n\napp.post(\"/api/obs\", async (c) => {\n const b = await c.req.json();\n if ((b.texto || \"\").trim()) {\n await sqlite.execute({\n sql: `INSERT INTO obs (medico, fecha, texto) VALUES (?, ?, ?)\n ON CONFLICT(medico, fecha) DO UPDATE SET texto = excluded.texto`,\n args: [b.medico, b.fecha, b.texto],\n });\n } else {\n await sqlite.execute({\n sql: \"DELETE FROM obs WHERE medico = ? AND fecha = ?\",\n args: [b.medico, b.fecha],\n });\n }\n return c.json({ ok: true });\n});\n\napp.get(\"/api/buscar\", async (c) => {\n const q = \"%\" + (c.req.query(\"q\") || \"\") + \"%\";\n const r = await sqlite.execute({\n sql:\n `SELECT c.medico, m.nombre AS medicoNombre, c.fecha, c.hora, c.nombre, c.curp, c.tel, c.tipo\n FROM citas c LEFT JOIN medicos m ON m.id = c.medico\n WHERE c.nombre LIKE ? OR c.curp LIKE ? OR c.tel LIKE ?\n ORDER BY c.fecha, c.hora LIMIT 30`,\n args: [q, q, q],\n });\n return c.json(r.rows);\n});\n\napp.get(\"/api/export\", async (c) => {\n const r = await sqlite.execute(\n `SELECT m.nombre AS medico, m.especialidad, m.turno, c.fecha, c.hora, c.tipo, c.nombre, c.curp, c.tel\n FROM citas c LEFT JOIN medicos m ON m.id = c.medico ORDER BY m.nombre, c.fecha, c.hora`,\n );\n const esc = (v: unknown) => '\"' + String(v ?? \"\").replace(/\"/g, '\"\"') + '\"';\n const filas = [\n \"Medico,Especialidad,Turno,Fecha,Hora,Tipo,Nombre,CURP,Telefono\",\n ];\n for (const x of r.rows) {\n filas.push(\n [\n x.medico,\n x.especialidad,\n x.turno,\n x.fecha,\n x.hora,\n x.tipo,\n x.nombre,\n x.curp,\n x.tel,\n ].map(esc).join(\",\"),\n );\n }\n return new Response(\"\" + filas.join(\"\\n\"), {\n headers: {\n \"Content-Type\": \"text/csv; charset=utf-8\",\n \"Content-Disposition\": \"attachment; filename=agenda_medica.csv\",\n },\n });\n});\n\n// ---------- PÁGINA ----------\nconst HTML = `\n\n\n\n\nAgenda Médica — Consulta Externa\n\n\n\n\n\n

AGENDA MÉDICA — CONSULTA EXTERNA

Turno 08:00 · comida 14:00–15:00 · particulares desde 17:40 | Turno 09:00 · comida 14:20–15:20 · privadas desde 17:00

\n\n

FECHA:

MÉDICO:

ESPECIALIDAD:

\n\n

\n MÉDICO:\n \n \n \n \n \n \n \n

\n\n

\n \n \n \n Agenda cardiología (permite estudios ECO de 1 hr)\n \n \n

\n\n

\n \n \n \n \n \n

\n\n \n\n

\n\n \n \n \n

\n\n

\n OBSERVACIONES:\n \n

\n\n

Los datos se guardan en línea y son compartidos por todos los que usan este enlace.

\n\n\n\n\n`;\n\napp.get(\"/\", (c) => c.html(HTML));\n\nexport default app.fetch;","fileType","http",7,"parentId","createdAt",["D",1784389696883],"branchVersion",9,"label",[19],{"_33":34,"_13":19,"_37":38,"_44":-5,"_35":36,"_47":48,"_57":58,"_45":68,"_17":43,"_41":42,"_39":40,"_63":64,"_49":-5,"_65":69,"_18":70},{"_33":53,"_13":54,"_37":55,"_44":-5,"_35":36,"_47":56,"_57":58,"_45":59,"_17":60,"_41":61,"_39":62,"_63":64,"_49":-5,"_65":66,"_18":67},"da9c132c-410a-4f52-89e9-d96dd1515b0d","new-file-827.ts","cce8f094-7caa-11f1-a55a-1607ee4eb77e",2,"latest",true,["D",1783720844919],0,"script","","deleted",false,"children",[],[54],["D",1784389696883],[],[19],"1b730b87-1ac9-450c-87d8-6756d974456e",["D",1783720836891],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","bd4199ac-b665-4e2f-8ebe-7ffc963366a0","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019f4e07-da8f-738d-93ff-a83fde53036f","tursoName","1b730b871ac9450c87d86756d974456e","tursoHostname","1b730b871ac9450c87d86756d974456e-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789525843977],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_127":123},"org",{"_11":12,"_120":121,"_122":123,"_80":-5,"_124":125,"_126":64},"branch",{"_17":48,"_13":16,"_33":36,"_112":71,"_113":-5,"_114":-5,"_115":-5,"_116":-5,"_117":-5,"_118":14,"_119":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","LUCERO CABRERA MOYA","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/3624a274-32c2-4d2d-aaae-608eb0334100/square512?exp=1789570799&sig=bc9fd5449fc58cd561ab56b7c5e73b9987e40aac9ecea43f688ad0f011869104","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":71,"_13":14,"_45":165,"_73":-5,"_74":64,"_75":76,"_77":76,"_78":-5,"_79":-5,"_80":81,"_82":38,"_83":58,"_84":-5,"_85":-5,"_86":60,"_87":88,"_89":90,"_91":92,"_93":166,"_95":-5,"_96":97,"_98":97,"_99":100,"_101":100,"_102":100,"_103":97,"_104":97,"_105":167,"_107":168,"_109":169,"_111":64},[159,160],"files",[159,160],"counts",{"_149":60,"_150":151,"_152":60,"_32":153,"_154":155},[],{"_33":34,"_35":36,"_37":38,"_13":19,"_39":40,"_41":42,"_17":43,"_44":-5,"_45":147,"_47":48,"_49":-5,"_18":148},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1784389696883],[19],"pulls","branches",1,"forks",{"_156":60,"_158":60},"connections",{"_156":60,"_157":60},"count","unfilledCount","emptyCount",{"_33":34,"_13":19,"_37":38,"_44":-5,"_35":36,"_47":48,"_57":58,"_45":68,"_17":43,"_41":42,"_39":40,"_63":64,"_49":-5,"_65":163,"_18":164},{"_33":53,"_13":54,"_37":55,"_44":-5,"_35":36,"_47":56,"_57":58,"_45":59,"_17":60,"_41":61,"_39":62,"_63":64,"_49":-5,"_65":161,"_18":162},[],[54],[],[19],["D",1783720836891],["D",1789525843977],{"_11":12,"_127":123},{"_11":12,"_120":121,"_122":123,"_80":-5,"_124":125,"_126":64},{"_17":48,"_13":16,"_33":36,"_112":71,"_113":-5,"_114":-5,"_115":-5,"_116":-5,"_117":-5,"_118":14,"_119":12},"ctx",{"_105":-5,"_144":203,"_204":205,"_206":207,"_208":64,"_209":64,"_210":64,"_211":58,"_212":-5,"_213":-7,"_214":-7,"_215":60,"_216":64,"_217":64,"_218":-5,"_219":64,"_220":64,"_221":64,"_222":-5},"ENV",{"_174":175,"_176":177,"_178":16,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202},"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"]

Agenda Médica — Acceso

AGENDA MÉDICA — CONSULTA EXTERNA