[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_104":105,"_106":107},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","lucero_cabrera_moya","name","AGENDA-MEDICA-LCDV","path","main.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":-5,"_53":-5,"_54":55,"_56":25,"_57":32,"_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":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/lucero_cabrera_moya/AGENDA-MEDICA-LCDV/code/main.ts","extension","id","aac4ca82-db7a-4c2a-a8b5-34ff8715adf0","fileId","c8220b7c-7caa-11f1-8212-1607ee4eb77e","parentId","branchId","4e70f432-6a5a-4bd8-92e0-2201a3b3803e","branchVersion",9,"latest",true,"createdAt",["D",1784389696883],"version",7,"fileType","http","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;","deleted",false,"label",[14],"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",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",{"_9":10,"_103":99},"org",{"_9":10,"_96":97,"_98":99,"_54":-5,"_100":101,"_102":42},"branch",{"_35":30,"_11":87,"_22":28,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":12,"_95":10},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","LUCERO CABRERA MOYA","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/3624a274-32c2-4d2d-aaae-608eb0334100/square512?exp=1789563599&sig=fcfaaed2bac401c8d4ad022a2bd994da692540cc6c2248277881117d5d6cfc61","tier","free","canRestrictVals","profileImageUrl","ctx",{"_80":-5,"_137":138,"_139":140,"_141":142,"_143":42,"_144":42,"_145":42,"_146":32,"_147":-5,"_148":-7,"_149":-7,"_150":61,"_151":42,"_152":42,"_153":-5,"_154":42,"_155":42,"_156":42,"_157":-5},"ENV",{"_108":109,"_110":111,"_112":87,"_113":114,"_115":116,"_117":118,"_119":120,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132,"_133":134,"_135":136},"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"]

Agenda Médica — Acceso

AGENDA MÉDICA — CONSULTA EXTERNA