[{"_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",{"_98":97,"_32":45,"_107":88,"_27":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":25,"_122":123,"_124":57,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":31,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"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":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","c8220b7c-7caa-11f1-8212-1607ee4eb77e","name","fileType","http","content","// Learn more: https://docs.val.town/vals/http/\nexport default async function (req: Request): Promise {\n return Response.json({ ok: true })\n}","// AGENDA MÉDICA WEB — Consulta Externa (multi-médico, datos compartidos)\n// Pega este archivo completo en un val de tipo HTTP en https://val.town\n// La clave de acceso por defecto es \"clinica2026\". Para cambiarla, crea una\n// variable de entorno llamada CLAVE_AGENDA en Val Town.\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)`);\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)`);\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: \"INSERT INTO medicos (id, nombre, especialidad) VALUES (?, ?, ?)\",\n args: [id, b.nombre, b.especialidad || \"\"],\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: \"UPDATE medicos SET nombre = ?, especialidad = ? WHERE id = ?\",\n args: [b.nombre, b.especialidad || \"\", c.req.param(\"id\")],\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 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] = { nombre: r.nombre, curp: r.curp, tel: r.tel };\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) VALUES (?, ?, ?, ?, ?, ?)\n ON CONFLICT(medico, fecha, hora) DO UPDATE SET nombre = excluded.nombre, curp = excluded.curp, tel = excluded.tel`,\n args: [\n b.medico,\n b.fecha,\n b.hora,\n b.nombre || \"\",\n (b.curp || \"\").toUpperCase(),\n b.tel || \"\",\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\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, c.fecha, c.hora, 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 = [\"Medico,Especialidad,Fecha,Hora,Nombre,CURP,Telefono\"];\n for (const x of r.rows) {\n filas.push(\n [x.medico, x.especialidad, x.fecha, x.hora, x.nombre, x.curp, x.tel].map(\n esc,\n ).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

Consulta externa 09:00–16:40 · Comida 14:20–15:20 · Consultas privadas a partir de las 17:00

\n\n

Horario de consulta: 09:00 – 16:40 hrs

FECHA:

MÉDICO:

ESPECIALIDAD:

\n\n

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

\n\n

\n \n \n \n \n

\n\n

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

\n\n \n\n

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

HORA	NOMBRE DEL PACIENTE	CURP	TELÉFONO DE CONTACTO

\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;","createdAt",["D",1783720889910],"branchVersion","branchId","4e70f432-6a5a-4bd8-92e0-2201a3b3803e","id","1b730b87-1ac9-450c-87d8-6756d974456e","AGENDA-MEDICA-LCDV",["D",1783720836891],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","bd4199ac-b665-4e2f-8ebe-7ffc963366a0","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"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",{"_98":97,"_106":102},"org",{"_98":97,"_99":100,"_101":102,"_18":-5,"_103":104,"_105":25},"branch",{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"isOwned",9,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","lucero_cabrera_moya","handle","displayName","LUCERO CABRERA MOYA","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/3624a274-32c2-4d2d-aaae-608eb0334100/square512?exp=1789589812&sig=4287be2d10e65706786049169667f8eac52ebeee3b6594a57f84e95b34ec8db7","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":165,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":31,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":166,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":167,"_82":168,"_84":169,"_86":25},"tree",[156,157],"files",[156,157],"counts",{"_145":61,"_146":147,"_148":61,"_149":150,"_151":152},"contents",[129,130],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":141,"_32":28,"_30":31,"_134":-5,"_41":42,"_40":14,"_136":25,"_38":142,"_13":143,"_33":34,"_35":37,"_24":25,"_139":-5,"_27":144},{"_43":131,"_32":132,"_30":133,"_134":-5,"_41":42,"_40":135,"_136":57,"_38":137,"_13":61,"_33":138,"_35":108,"_24":25,"_139":-5,"_27":140},"da9c132c-410a-4f52-89e9-d96dd1515b0d","new-file-827.ts","cce8f094-7caa-11f1-a55a-1607ee4eb77e","parentId",2,"latest",["D",1783720844919],"script","label",[132],"c7515f23-e13b-4a27-a41a-c4753529f001",["D",1783720889910],3,[28],"pulls","branches",1,"forks","envVars",{"_153":61,"_155":61},"connections",{"_153":61,"_154":61},"count","unfilledCount","emptyCount",{"_43":141,"_32":28,"_30":31,"_134":-5,"_41":42,"_40":14,"_136":25,"_38":162,"_13":143,"_33":34,"_35":37,"_24":25,"_139":-5,"_159":163,"_27":164},{"_43":131,"_32":132,"_30":133,"_134":-5,"_41":42,"_40":135,"_136":57,"_38":158,"_13":61,"_33":138,"_35":108,"_24":25,"_139":-5,"_159":160,"_27":161},["D",1783720844919],"children",[],[132],["D",1783720889910],[],[28],["D",1783720836891],["D",1789525843977],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":-5,"_103":104,"_105":25},{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"ctx",{"_80":-5,"_126":203,"_204":205,"_206":207,"_208":25,"_209":25,"_210":25,"_211":57,"_212":-5,"_213":-7,"_214":-7,"_215":61,"_216":25,"_217":25,"_218":-5,"_219":25,"_220":25,"_221":25,"_222":-5},"ENV",{"_174":175,"_176":177,"_178":88,"_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","811aa22498c9b0b5a47e8d778de579cdb990f332","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

Diff · v5