[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_105":106,"_107":108},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","lucero_cabrera_moya","name","CONSULTORIOSSIM","path","main.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/lucero_cabrera_moya/CONSULTORIOSSIM/code/main.ts","extension","id","423f5be8-16b9-42e7-b839-f18db6510074","fileId","69332e1e-91f1-11f1-a80d-1607ee4eb77e","parentId","branchId","a3a3e721-ddfb-46db-a6d5-cea9ec899253","branchVersion",8,"latest",true,"createdAt",["D",1786076890177],"version",7,"fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst encCols = [\n \"attention_date\",\n \"visit_type\",\n \"patient_name\",\n \"curp\",\n \"birth_date\",\n \"age\",\n \"sex\",\n \"locality\",\n \"record_number\",\n \"membership\",\n \"mido_done\",\n \"medical_assessment\",\n \"medical_program\",\n \"teleconsult_office\",\n \"diagnosis\",\n \"cie10\",\n \"nursing_care\",\n \"nurse_name\",\n \"nursing_program\",\n \"medicine_delivered\",\n \"medicine_qty\",\n \"medicine_detail\",\n \"medicine_not_delivered\",\n \"medicine_not_detail\",\n \"diagnostic_aid\",\n \"recovery_fee\",\n \"observation\",\n \"referred_lcdv\",\n \"referred_service\",\n \"referral_date\",\n \"other_referral\",\n \"pregnancy_multivitamin\",\n \"dg_kit\",\n \"crecimido\",\n \"albendazole\",\n \"vitamin_a\",\n \"atlc\",\n \"general_notes\",\n \"doctor_name\",\n \"procedure_name\",\n \"referral_type\",\n \"vulnerability\",\n \"vulnerability_condition\",\n] as const;\n\nasync function init() {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS sim_v2_users(id TEXT PRIMARY KEY,username TEXT UNIQUE NOT NULL,full_name TEXT NOT NULL,role TEXT NOT NULL CHECK(role IN ('admin','capture')),clinic TEXT NOT NULL DEFAULT '',salt TEXT NOT NULL,password_hash TEXT NOT NULL,active INTEGER NOT NULL DEFAULT 1,created_at TEXT NOT NULL)`,\n `CREATE TABLE IF NOT EXISTS sim_v2_sessions(token_hash TEXT PRIMARY KEY,user_id TEXT NOT NULL,expires_at TEXT NOT NULL,created_at TEXT NOT NULL)`,\n `CREATE TABLE IF NOT EXISTS encounters(id TEXT PRIMARY KEY,attention_date TEXT NOT NULL,visit_type TEXT DEFAULT '',patient_name TEXT NOT NULL,curp TEXT DEFAULT '',birth_date TEXT DEFAULT '',age INTEGER,sex TEXT DEFAULT '',locality TEXT DEFAULT '',record_number TEXT DEFAULT '',membership TEXT DEFAULT '',mido_done TEXT DEFAULT '',medical_assessment TEXT DEFAULT '',medical_program TEXT DEFAULT '',teleconsult_office TEXT DEFAULT '',diagnosis TEXT NOT NULL,cie10 TEXT NOT NULL,nursing_care TEXT DEFAULT '',nurse_name TEXT DEFAULT '',nursing_program TEXT DEFAULT '',medicine_delivered TEXT DEFAULT '',medicine_qty REAL,medicine_detail TEXT DEFAULT '',medicine_not_delivered TEXT DEFAULT '',medicine_not_detail TEXT DEFAULT '',diagnostic_aid TEXT DEFAULT '',recovery_fee REAL,observation TEXT DEFAULT '',referred_lcdv TEXT DEFAULT '',referred_service TEXT DEFAULT '',referral_date TEXT DEFAULT '',other_referral TEXT DEFAULT '',pregnancy_multivitamin TEXT DEFAULT '',dg_kit TEXT DEFAULT '',crecimido TEXT DEFAULT '',albendazole TEXT DEFAULT '',vitamin_a TEXT DEFAULT '',atlc TEXT DEFAULT '',general_notes TEXT DEFAULT '',doctor_name TEXT NOT NULL,procedure_name TEXT DEFAULT '',clinic TEXT DEFAULT '',created_by TEXT NOT NULL,created_by_name TEXT NOT NULL,source TEXT NOT NULL DEFAULT 'capture',source_sheet TEXT DEFAULT '',source_row INTEGER,raw_json TEXT DEFAULT '',created_at TEXT NOT NULL,updated_at TEXT NOT NULL)`,\n `CREATE INDEX IF NOT EXISTS idx_enc_date ON encounters(attention_date)`,\n `CREATE INDEX IF NOT EXISTS idx_enc_user_date ON encounters(created_by,attention_date)`,\n `CREATE INDEX IF NOT EXISTS idx_enc_curp ON encounters(curp)`,\n `CREATE TABLE IF NOT EXISTS audit_log(id TEXT PRIMARY KEY,user_id TEXT,action TEXT NOT NULL,entity TEXT NOT NULL,entity_id TEXT,detail TEXT,created_at TEXT NOT NULL)`,\n `CREATE TABLE IF NOT EXISTS app_settings(key TEXT PRIMARY KEY,value TEXT NOT NULL,updated_at TEXT NOT NULL)`,\n `CREATE TABLE IF NOT EXISTS sim_catalogs(id TEXT PRIMARY KEY,type TEXT NOT NULL,code TEXT NOT NULL DEFAULT '',name TEXT NOT NULL,price REAL,unit TEXT NOT NULL DEFAULT '',active INTEGER NOT NULL DEFAULT 1,meta TEXT NOT NULL DEFAULT '',updated_at TEXT NOT NULL,UNIQUE(type,code,name))`,\n `CREATE INDEX IF NOT EXISTS idx_sim_catalogs_type ON sim_catalogs(type,active,name)`,\n ]);\n const tableInfo = await sqlite.execute(\"PRAGMA table_info(encounters)\");\n const existing = new Set(\n (tableInfo.rows as any[]).map((r) => String(r.name)),\n );\n for (\n const col of [\"referral_type\", \"vulnerability\", \"vulnerability_condition\"]\n ) {\n if (!existing.has(col)) {\n await sqlite.execute(\n `ALTER TABLE encounters ADD COLUMN ${col} TEXT NOT NULL DEFAULT ''`,\n );\n }\n }\n // SIM_ADMIN_PASSWORD is also the recovery mechanism. If its value changes,\n // the existing admin account is updated without deleting clinical records.\n // Password de arranque. Puede sustituirse después con SIM_ADMIN_PASSWORD.\n // El valor de entorno tiene prioridad cuando esté configurado.\n const pass = Deno.env.get(\"SIM_ADMIN_PASSWORD\") || \"SIM-LCDV-2026*Temporal\";\n if (pass) {\n const fingerprint = await digest(\"SIM_ADMIN_PASSWORD:\" + pass);\n const saved = await sqlite.execute({\n sql: \"SELECT value FROM app_settings WHERE key=?\",\n args: [\"sim_v2_admin_password_fingerprint\"],\n });\n const admin = await sqlite.execute({\n sql: \"SELECT id FROM sim_v2_users WHERE username=?\",\n args: [\"admin\"],\n });\n if (!admin.rows[0]) {\n await createUser(\n \"admin\",\n \"Administrador General\",\n \"admin\",\n \"Todos\",\n pass,\n );\n } else if ((saved.rows[0] as any)?.value !== fingerprint) {\n const salt = b64(crypto.getRandomValues(new Uint8Array(16))),\n hash = await passHash(pass, salt);\n await sqlite.execute({\n sql:\n \"UPDATE sim_v2_users SET salt=?,password_hash=?,role='admin',active=1 WHERE username='admin'\",\n args: [salt, hash],\n });\n await sqlite.execute(\"DELETE FROM sim_v2_sessions\");\n }\n await sqlite.execute({\n sql:\n `INSERT INTO app_settings(key,value,updated_at) VALUES(?,?,?) ON CONFLICT(key) DO UPDATE SET value=excluded.value,updated_at=excluded.updated_at`,\n args: [\"sim_v2_admin_password_fingerprint\", fingerprint, now()],\n });\n }\n}\n\nconst now = () => new Date().toISOString();\nconst b64 = (a: Uint8Array) => btoa(String.fromCharCode(...a));\nconst bytes = (s: string) => Uint8Array.from(atob(s), (c) => c.charCodeAt(0));\nasync function digest(s: string) {\n return b64(\n new Uint8Array(\n await crypto.subtle.digest(\"SHA-256\", new TextEncoder().encode(s)),\n ),\n );\n}\nasync function passHash(password: string, salt: string) {\n const key = await crypto.subtle.importKey(\n \"raw\",\n new TextEncoder().encode(password),\n \"PBKDF2\",\n false,\n [\"deriveBits\"],\n );\n const bits = await crypto.subtle.deriveBits(\n { name: \"PBKDF2\", salt: bytes(salt), iterations: 210000, hash: \"SHA-256\" },\n key,\n 256,\n );\n return b64(new Uint8Array(bits));\n}\nasync function createUser(\n username: string,\n fullName: string,\n role: string,\n clinic: string,\n password: string,\n) {\n const salt = b64(crypto.getRandomValues(new Uint8Array(16))),\n hash = await passHash(password, salt);\n await sqlite.execute({\n sql:\n `INSERT INTO sim_v2_users(id,username,full_name,role,clinic,salt,password_hash,created_at) VALUES(?,?,?,?,?,?,?,?)`,\n args: [\n crypto.randomUUID(),\n username.trim().toLowerCase(),\n fullName.trim(),\n role,\n clinic.trim(),\n salt,\n hash,\n now(),\n ],\n });\n}\nfunction json(data: unknown, status = 200) {\n return Response.json(data, {\n status,\n headers: {\n \"Cache-Control\": \"no-store\",\n \"X-Content-Type-Options\": \"nosniff\",\n },\n });\n}\nasync function body(req: Request) {\n try {\n return await req.json();\n } catch {\n return {};\n }\n}\nasync function auth(req: Request) {\n const token = (req.headers.get(\"authorization\") || \"\").replace(\n /^Bearer\\s+/i,\n \"\",\n );\n if (!token) return null;\n const h = await digest(token);\n const r = await sqlite.execute({\n sql:\n `SELECT u.id,u.username,u.full_name,u.role,u.clinic FROM sim_v2_sessions s JOIN sim_v2_users u ON u.id=s.user_id WHERE s.token_hash=? AND s.expires_at>? AND u.active=1`,\n args: [h, now()],\n });\n return r.rows[0] as any || null;\n}\nasync function audit(\n u: any,\n action: string,\n entity: string,\n id = \"\",\n detail = \"\",\n) {\n await sqlite.execute({\n sql: `INSERT INTO audit_log VALUES(?,?,?,?,?,?,?)`,\n args: [\n crypto.randomUUID(),\n u?.id || null,\n action,\n entity,\n id,\n detail,\n now(),\n ],\n });\n}\nconst clean = (v: any, n = 500) => String(v ?? \"\").trim().slice(0, n);\nconst num = (v: any) =>\n v === \"\" || v == null\n ? null\n : (Number.isFinite(Number(v)) ? Number(v) : null);\nfunction validDate(v: string) {\n return /^\\d{4}-\\d{2}-\\d{2}$/.test(v) &&\n !Number.isNaN(Date.parse(v + \"T12:00:00Z\"));\n}\nfunction normalize(x: any, u: any, source = \"capture\") {\n const e: any = {};\n for (const c of encCols) {\n e[c] = clean(x[c], c.includes(\"notes\") || c === \"raw_json\" ? 4000 : 500);\n }\n e.age = num(x.age);\n e.medicine_qty = num(x.medicine_qty);\n e.recovery_fee = num(x.recovery_fee);\n e.attention_date = clean(x.attention_date, 10);\n e.birth_date = clean(x.birth_date, 10);\n e.referral_date = clean(x.referral_date, 10);\n e.patient_name = clean(x.patient_name, 200);\n e.diagnosis = clean(x.diagnosis, 500);\n e.cie10 = clean(x.cie10, 20).toUpperCase();\n e.doctor_name = clean(x.doctor_name || u.full_name, 200);\n const sx = clean(x.sex, 30).toLowerCase();\n e.sex = [\"hombre\", \"masculino\", \"m\"].includes(sx)\n ? \"Hombre\"\n : [\"mujer\", \"femenino\", \"f\"].includes(sx)\n ? \"Mujer\"\n : clean(x.sex, 30);\n e.vulnerability =\n [\"sí\", \"si\", \"true\", \"1\"].includes(clean(x.vulnerability, 10).toLowerCase())\n ? \"Sí\"\n : \"No\";\n if (e.vulnerability !== \"Sí\") e.vulnerability_condition = \"\";\n if (e.referred_lcdv !== \"Sí\") e.referral_type = \"\";\n e.clinic = clean(x.clinic || u.clinic, 150);\n e.source = source;\n e.source_sheet = clean(x.source_sheet, 100);\n e.source_row = num(x.source_row);\n e.raw_json = clean(\n typeof x.raw_json === \"string\"\n ? x.raw_json\n : JSON.stringify(x.raw_json || {}),\n 12000,\n );\n return e;\n}\nasync function insertEncounter(e: any, u: any) {\n const id = crypto.randomUUID(), ts = now();\n const cols = [\n ...encCols,\n \"clinic\",\n \"created_by\",\n \"created_by_name\",\n \"source\",\n \"source_sheet\",\n \"source_row\",\n \"raw_json\",\n \"created_at\",\n \"updated_at\",\n ];\n const vals = [\n ...encCols.map((c) => e[c]),\n e.clinic,\n u.id,\n u.full_name,\n e.source,\n e.source_sheet,\n e.source_row,\n e.raw_json,\n ts,\n ts,\n ];\n await sqlite.execute({\n sql: `INSERT INTO encounters(${cols.join(\",\")}) VALUES(${\n cols.map(() => \"?\").join(\",\")\n })`,\n args: vals,\n });\n return id;\n}\nfunction validate(e: any) {\n const errors = [];\n if (!validDate(e.attention_date)) errors.push(\"Fecha de atención inválida\");\n if (!e.patient_name) errors.push(\"Falta nombre del paciente\");\n if (!e.diagnosis) errors.push(\"Falta diagnóstico\");\n if (!/^[A-Z][0-9]{2}(\\.[0-9A-Z]{1,4})?$/.test(e.cie10)) {\n errors.push(\"Código CIE-10 inválido\");\n }\n if (!e.doctor_name) errors.push(\"Falta médico\");\n if (![\"Hombre\", \"Mujer\"].includes(e.sex)) {\n errors.push(\"Sexo debe ser Hombre o Mujer\");\n }\n if (e.birth_date && !validDate(e.birth_date)) {\n errors.push(\"Fecha de nacimiento inválida\");\n }\n if (e.age != null && (e.age < 0 || e.age > 130)) {\n errors.push(\"Edad fuera de rango\");\n }\n if (e.recovery_fee != null && (e.recovery_fee < 0 || e.recovery_fee > 50)) {\n errors.push(\"La cuota de recuperación debe estar entre $0 y $50\");\n }\n return errors;\n}\nasync function validateCatalogSelection(e: any) {\n const errors: string[] = [];\n if (\n ![\"SIM E\", \"SIM D\", \"Personal\", \"Familiar\", \"Empresarial\"].includes(\n e.membership,\n )\n ) errors.push(\"Seleccione una membresía válida\");\n const cie = await sqlite.execute({\n sql:\n \"SELECT 1 ok FROM sim_catalogs WHERE type='cie10' AND upper(code)=upper(?) AND name=? AND active=1 LIMIT 1\",\n args: [e.cie10, e.diagnosis],\n });\n if (!cie.rows[0]) {\n errors.push(\"El código y nombre deben corresponder al catálogo CIE-10\");\n }\n const doctor = await sqlite.execute({\n sql:\n \"SELECT 1 ok FROM sim_catalogs WHERE type='doctors' AND name=? AND active=1 LIMIT 1\",\n args: [e.doctor_name],\n });\n if (!doctor.rows[0]) errors.push(\"Seleccione un médico del catálogo médico\");\n if (e.nurse_name) {\n const nurse = await sqlite.execute({\n sql:\n \"SELECT 1 ok FROM sim_catalogs WHERE type='nurses' AND name=? AND active=1 LIMIT 1\",\n args: [e.nurse_name],\n });\n if (!nurse.rows[0]) {\n errors.push(\"Seleccione una enfermera del catálogo de enfermería\");\n }\n }\n if (e.medical_program) {\n const program = await sqlite.execute({\n sql:\n \"SELECT 1 ok FROM sim_catalogs WHERE type='programs' AND name=? AND active=1 LIMIT 1\",\n args: [e.medical_program],\n });\n if (!program.rows[0]) {\n errors.push(\"Seleccione el programa desde su catálogo\");\n }\n }\n if (e.medicine_delivered) {\n const medicine = await sqlite.execute({\n sql:\n \"SELECT 1 ok FROM sim_catalogs WHERE type='medicines' AND name=? AND active=1 LIMIT 1\",\n args: [e.medicine_delivered],\n });\n if (!medicine.rows[0]) {\n errors.push(\"Seleccione el medicamento desde su catálogo\");\n }\n }\n if (![\"Sí\", \"No\"].includes(e.referred_lcdv)) {\n errors.push(\"Indique Sí o No en referencia\");\n }\n if (\n e.referred_lcdv === \"Sí\" &&\n ![\"Referencia\", \"Contrarreferencia\"].includes(e.referral_type)\n ) errors.push(\"Seleccione Referencia o Contrarreferencia\");\n if (e.vulnerability === \"Sí\") {\n const condition = await sqlite.execute({\n sql:\n \"SELECT 1 ok FROM sim_catalogs WHERE type='vulnerabilities' AND name=? AND active=1 LIMIT 1\",\n args: [e.vulnerability_condition],\n });\n if (!condition.rows[0]) {\n errors.push(\n \"Seleccione la condición de vulnerabilidad desde su catálogo\",\n );\n }\n }\n return errors;\n}\nfunction csv(rows: any[], cols: { k: string; l: string }[]) {\n const q = (v: any) => `\"${String(v ?? \"\").replaceAll('\"', '\"\"')}\"`;\n return \"\\ufeff\" + cols.map((c) => q(c.l)).join(\",\") + \"\\r\\n\" +\n rows.map((r) => cols.map((c) => q(r[c.k])).join(\",\")).join(\"\\r\\n\");\n}\nconst dailyCols = [\n { k: \"attention_date\", l: \"Fecha de atención\" },\n { k: \"patient_name\", l: \"Nombre del paciente\" },\n { k: \"age\", l: \"Edad\" },\n { k: \"sex\", l: \"Sexo\" },\n { k: \"curp\", l: \"CURP\" },\n { k: \"birth_date\", l: \"Fecha de nacimiento\" },\n { k: \"diagnosis\", l: \"Diagnóstico\" },\n { k: \"cie10\", l: \"CIE-10\" },\n { k: \"record_number\", l: \"Expediente\" },\n { k: \"membership\", l: \"Membresía\" },\n { k: \"doctor_name\", l: \"Médico que atiende\" },\n { k: \"nurse_name\", l: \"Enfermera que atiende\" },\n { k: \"procedure_name\", l: \"Procedimiento\" },\n];\nconst powerCols = [\n ...dailyCols,\n { k: \"clinic\", l: \"Consultorio\" },\n { k: \"visit_type\", l: \"Primera vez/Subsecuente\" },\n { k: \"medical_program\", l: \"Programa de atención\" },\n { k: \"medicine_delivered\", l: \"Medicamento\" },\n { k: \"nursing_program\", l: \"Programa enfermería\" },\n { k: \"diagnostic_aid\", l: \"Auxiliar diagnóstico\" },\n { k: \"recovery_fee\", l: \"Cuota de recuperación\" },\n { k: \"referred_lcdv\", l: \"Tiene referencia/contrarreferencia\" },\n { k: \"referral_type\", l: \"Tipo de referencia\" },\n { k: \"referred_service\", l: \"Servicio referido\" },\n { k: \"other_referral\", l: \"Otra institución\" },\n { k: \"vulnerability\", l: \"Condición de vulnerabilidad\" },\n { k: \"vulnerability_condition\", l: \"Tipo de vulnerabilidad\" },\n { k: \"created_by_name\", l: \"Usuario capturista\" },\n { k: \"source\", l: \"Origen\" },\n { k: \"created_at\", l: \"Fecha de captura\" },\n];\n\nasync function api(req: Request, path: string) {\n if (path === \"/api/setup-status\") {\n const r = await sqlite.execute(\"SELECT count(*) n FROM sim_v2_users\");\n return json({ ready: Number((r.rows[0] as any).n) > 0, needsEnv: false });\n }\n if (path === \"/api/login\" && req.method === \"POST\") {\n const b: any = await body(req),\n r = await sqlite.execute({\n sql: `SELECT * FROM sim_v2_users WHERE username=? AND active=1`,\n args: [clean(b.username, 80).toLowerCase()],\n });\n const u: any = r.rows[0];\n if (\n !u || await passHash(clean(b.password, 200), u.salt) !== u.password_hash\n ) return json({ error: \"Usuario o contraseña incorrectos\" }, 401);\n const token = b64(crypto.getRandomValues(new Uint8Array(32))),\n exp = new Date(Date.now() + 12 * 3600000).toISOString();\n await sqlite.execute({\n sql: `INSERT INTO sim_v2_sessions VALUES(?,?,?,?)`,\n args: [await digest(token), u.id, exp, now()],\n });\n await audit(u, \"LOGIN\", \"session\");\n return json({\n token,\n user: {\n id: u.id,\n username: u.username,\n full_name: u.full_name,\n role: u.role,\n clinic: u.clinic,\n },\n });\n }\n const u = await auth(req);\n if (!u) return json({ error: \"Sesión inválida o vencida\" }, 401);\n if (path === \"/api/me\") return json({ user: u });\n if (path === \"/api/logout\" && req.method === \"POST\") {\n const t = (req.headers.get(\"authorization\") || \"\").replace(\n /^Bearer\\s+/i,\n \"\",\n );\n await sqlite.execute({\n sql: \"DELETE FROM sim_v2_sessions WHERE token_hash=?\",\n args: [await digest(t)],\n });\n return json({ ok: true });\n }\n if (path === \"/api/users\" && req.method === \"GET\") {\n if (u.role !== \"admin\") return json({ error: \"No autorizado\" }, 403);\n const r = await sqlite.execute(\n \"SELECT id,username,full_name,role,clinic,active,created_at FROM sim_v2_users ORDER BY full_name\",\n );\n return json({ rows: r.rows });\n }\n if (path === \"/api/users\" && req.method === \"POST\") {\n if (u.role !== \"admin\") return json({ error: \"No autorizado\" }, 403);\n const b: any = await body(req);\n if (!b.username || !b.full_name || String(b.password || \"\").length < 8) {\n return json({\n error: \"Complete los datos; contraseña mínima de 8 caracteres\",\n }, 400);\n }\n try {\n await createUser(\n b.username,\n b.full_name,\n b.role === \"admin\" ? \"admin\" : \"capture\",\n b.clinic || \"\",\n b.password,\n );\n await audit(u, \"CREATE\", \"user\", \"\", b.username);\n return json({ ok: true });\n } catch {\n return json(\n { error: \"El usuario ya existe o los datos son inválidos\" },\n 400,\n );\n }\n }\n if (path === \"/api/catalogs\" && req.method === \"GET\") {\n const z = new URL(req.url), type = clean(z.searchParams.get(\"type\"), 40);\n const r = await sqlite.execute({\n sql:\n `SELECT id,type,code,name,price,unit,active,meta FROM sim_catalogs WHERE active=1 ${\n type ? \"AND type=?\" : \"\"\n } ORDER BY name LIMIT 20000`,\n args: type ? [type] : [],\n });\n return json({ rows: r.rows });\n }\n if (path === \"/api/catalogs\" && req.method === \"POST\") {\n if (u.role !== \"admin\") return json({ error: \"No autorizado\" }, 403);\n const b: any = await body(req),\n type = clean(b.type, 40),\n name = clean(b.name, 500),\n code = clean(b.code, 80).toUpperCase();\n if (!type || !name) {\n return json({ error: \"Tipo y nombre son obligatorios\" }, 400);\n }\n await sqlite.execute({\n sql:\n `INSERT INTO sim_catalogs(id,type,code,name,price,unit,active,meta,updated_at) VALUES(?,?,?,?,?,?,?,?,?) ON CONFLICT(type,code,name) DO UPDATE SET price=excluded.price,unit=excluded.unit,active=1,meta=excluded.meta,updated_at=excluded.updated_at`,\n args: [\n crypto.randomUUID(),\n type,\n code,\n name,\n num(b.price),\n clean(b.unit, 80),\n 1,\n clean(b.meta, 2000),\n now(),\n ],\n });\n await audit(u, \"UPSERT\", \"catalog\", \"\", type + \":\" + code + \":\" + name);\n return json({ ok: true });\n }\n if (path === \"/api/catalogs/bulk\" && req.method === \"POST\") {\n if (u.role !== \"admin\") return json({ error: \"No autorizado\" }, 403);\n const b: any = await body(req),\n type = clean(b.type, 40),\n rows = Array.isArray(b.rows) ? b.rows : [];\n if (!type || rows.length > 500) {\n return json({ error: \"Tipo inválido o bloque mayor a 500 filas\" }, 400);\n }\n let saved = 0, errors: any[] = [];\n for (let i = 0; i < rows.length; i++) {\n const x = rows[i],\n name = clean(x.name, 500),\n code = clean(x.code, 80).toUpperCase();\n if (!name) {\n errors.push({\n row: x.row || i + 2,\n error: \"Falta nombre o descripción\",\n });\n continue;\n }\n try {\n await sqlite.execute({\n sql:\n `INSERT INTO sim_catalogs(id,type,code,name,price,unit,active,meta,updated_at) VALUES(?,?,?,?,?,?,?,?,?) ON CONFLICT(type,code,name) DO UPDATE SET price=excluded.price,unit=excluded.unit,active=1,meta=excluded.meta,updated_at=excluded.updated_at`,\n args: [\n crypto.randomUUID(),\n type,\n code,\n name,\n num(x.price),\n clean(x.unit, 80),\n 1,\n clean(JSON.stringify(x.raw || {}), 2000),\n now(),\n ],\n });\n saved++;\n } catch (e) {\n errors.push({ row: x.row || i + 2, error: String(e) });\n }\n }\n await audit(\n u,\n \"BULK_CATALOG\",\n \"catalog\",\n \"\",\n JSON.stringify({ type, saved, errors: errors.length }),\n );\n return json({ saved, errors });\n }\n if (path.startsWith(\"/api/catalogs/\") && req.method === \"PUT\") {\n if (u.role !== \"admin\") return json({ error: \"No autorizado\" }, 403);\n const id = clean(path.split(\"/\").pop(), 80), b: any = await body(req);\n await sqlite.execute({\n sql:\n \"UPDATE sim_catalogs SET code=?,name=?,price=?,unit=?,active=?,updated_at=? WHERE id=?\",\n args: [\n clean(b.code, 80).toUpperCase(),\n clean(b.name, 500),\n num(b.price),\n clean(b.unit, 80),\n b.active === false ? 0 : 1,\n now(),\n id,\n ],\n });\n await audit(u, \"UPDATE\", \"catalog\", id);\n return json({ ok: true });\n }\n if (path === \"/api/encounters\" && req.method === \"POST\") {\n const b: any = await body(req), e = normalize(b, u);\n const er = [...validate(e), ...await validateCatalogSelection(e)];\n if (er.length) return json({ error: er.join(\". \") }, 400);\n const id = await insertEncounter(e, u);\n await audit(u, \"CREATE\", \"encounter\", id);\n return json({ ok: true, id });\n }\n if (path === \"/api/bulk\" && req.method === \"POST\") {\n if (u.role !== \"admin\") return json({ error: \"No autorizado\" }, 403);\n const b: any = await body(req), rows = Array.isArray(b.rows) ? b.rows : [];\n if (rows.length > 200) {\n return json({ error: \"Máximo 200 filas por bloque\" }, 400);\n }\n let inserted = 0;\n const errors: any[] = [];\n for (let i = 0; i < rows.length; i++) {\n const e = normalize(rows[i], u, \"mass_upload\"), er = validate(e);\n if (er.length) {\n errors.push({ row: rows[i].source_row || i + 1, error: er.join(\"; \") });\n continue;\n }\n try {\n await insertEncounter(e, u);\n inserted++;\n } catch (ex) {\n errors.push({ row: rows[i].source_row || i + 1, error: String(ex) });\n }\n }\n await audit(\n u,\n \"BULK_IMPORT\",\n \"encounter\",\n \"\",\n JSON.stringify({ inserted, errors: errors.length }),\n );\n return json({ inserted, errors });\n }\n if (path === \"/api/encounters\" && req.method === \"GET\") {\n const url = new URL(req.url),\n from = clean(url.searchParams.get(\"from\"), 10),\n to = clean(url.searchParams.get(\"to\"), 10);\n if (!validDate(from) || !validDate(to)) {\n return json({ error: \"Rango inválido\" }, 400);\n }\n const own = u.role !== \"admin\";\n const r = await sqlite.execute({\n sql: `SELECT * FROM encounters WHERE attention_date BETWEEN ? AND ? ${\n own ? \"AND created_by=?\" : \"\"\n } ORDER BY attention_date,patient_name LIMIT 10000`,\n args: own ? [from, to, u.id] : [from, to],\n });\n return json({ rows: r.rows });\n }\n if (path.startsWith(\"/api/encounters/\") && req.method === \"PUT\") {\n if (u.role !== \"admin\") {\n return json(\n { error: \"Solo el administrador puede modificar atenciones\" },\n 403,\n );\n }\n const id = clean(path.split(\"/\").pop(), 80),\n b: any = await body(req),\n old = await sqlite.execute({\n sql: \"SELECT * FROM encounters WHERE id=?\",\n args: [id],\n });\n if (!old.rows[0]) return json({ error: \"Atención no encontrada\" }, 404);\n const e = normalize({ ...old.rows[0], ...b }, u, \"admin_correction\"),\n er = [...validate(e), ...await validateCatalogSelection(e)];\n if (er.length) return json({ error: er.join(\". \") }, 400);\n const editable = [...encCols, \"clinic\"];\n const set = editable.map((c) => c + \"=?\").join(\",\");\n await sqlite.execute({\n sql: `UPDATE encounters SET ${set},updated_at=? WHERE id=?`,\n args: [...editable.map((c) => e[c]), now(), id],\n });\n await audit(u, \"UPDATE\", \"encounter\", id, clean(b.correction_reason, 500));\n return json({ ok: true });\n }\n if (path === \"/api/stats\" && req.method === \"GET\") {\n if (u.role !== \"admin\") return json({ error: \"No autorizado\" }, 403);\n const z = new URL(req.url),\n f = clean(z.searchParams.get(\"from\"), 10),\n t = clean(z.searchParams.get(\"to\"), 10);\n const a = validDate(f) && validDate(t)\n ? [f, t]\n : [\"1900-01-01\", \"2999-12-31\"];\n const [total, sex, clinic, program, top] = await Promise.all([\n sqlite.execute({\n sql:\n \"SELECT count(*) total,count(DISTINCT curp) patients,count(DISTINCT attention_date) days FROM encounters WHERE attention_date BETWEEN ? AND ?\",\n args: a,\n }),\n sqlite.execute({\n sql:\n \"SELECT sex label,count(*) value FROM encounters WHERE attention_date BETWEEN ? AND ? GROUP BY sex ORDER BY value DESC\",\n args: a,\n }),\n sqlite.execute({\n sql:\n \"SELECT clinic label,count(*) value FROM encounters WHERE attention_date BETWEEN ? AND ? GROUP BY clinic ORDER BY value DESC\",\n args: a,\n }),\n sqlite.execute({\n sql:\n \"SELECT medical_program label,count(*) value FROM encounters WHERE attention_date BETWEEN ? AND ? GROUP BY medical_program ORDER BY value DESC\",\n args: a,\n }),\n sqlite.execute({\n sql:\n \"SELECT cie10||' · '||diagnosis label,count(*) value FROM encounters WHERE attention_date BETWEEN ? AND ? GROUP BY cie10,diagnosis ORDER BY value DESC LIMIT 10\",\n args: a,\n }),\n ]);\n return json({\n total: total.rows[0],\n sex: sex.rows,\n clinic: clinic.rows,\n program: program.rows,\n top: top.rows,\n });\n }\n if (path === \"/api/export.csv\" && req.method === \"GET\") {\n if (u.role !== \"admin\") return json({ error: \"No autorizado\" }, 403);\n const z = new URL(req.url),\n f = clean(z.searchParams.get(\"from\"), 10),\n t = clean(z.searchParams.get(\"to\"), 10);\n if (!validDate(f) || !validDate(t)) {\n return json({ error: \"Rango inválido\" }, 400);\n }\n const r = await sqlite.execute({\n sql:\n \"SELECT * FROM encounters WHERE attention_date BETWEEN ? AND ? ORDER BY attention_date,clinic,patient_name\",\n args: [f, t],\n });\n return new Response(csv(r.rows as any[], powerCols), {\n headers: {\n \"Content-Type\": \"text/csv; charset=utf-8\",\n \"Content-Disposition\":\n `attachment; filename=\"SIM_PowerBI_${f}_${t}.csv\"`,\n \"Cache-Control\": \"no-store\",\n },\n });\n }\n return json({ error: \"Ruta no encontrada\" }, 404);\n}\n\nconst sw =\n `const C='sim-offline-v1';self.addEventListener('install',e=>e.waitUntil(caches.open(C).then(c=>c.addAll(['/']))));self.addEventListener('activate',e=>e.waitUntil(self.clients.claim()));self.addEventListener('fetch',e=>{if(e.request.method==='GET'&&!e.request.url.includes('/api/'))e.respondWith(fetch(e.request).then(r=>{let x=r.clone();caches.open(C).then(c=>c.put(e.request,x));return r}).catch(()=>caches.match(e.request)))})`;\n\nconst logoSIM =\n \"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAxgAAAJkCAYAAACS6odqAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAJYlJREFUeNrs3T9220iCB2D0vMmXe4Jhn2DkE5g6gaVgYlHZZLLSTiQlk0rKOhMdd2D2CUyfwJwTNPsEqz3BLsou9rDpAgmQAAkC3/cen2faloh/VagfqgqVZQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA0Fc/OAQAp+enn385y/8Y5J/Rhn/2mn/m4fOvf/7jtSP7Pcz/GMb/u77vi/jJurTPAAIGAE0FitCgfrclVBRZxLDxa/6ZnkLjO4aJsK9v889Z/FTxR8DKP5/zz0zoABAwAPocKkIPxTj/3GT/eWpfl2kIG3mDe9LCUHGRf652CBRlrIasuasMQMAA6EuwuIvhYtDw14Un+s/55+mYT/fzfb6IQWp0wK9dxH2f6NkAEDAAuhou7mNDe3Dgrw4N7Ie8of104P0dxzA1PPKhn4SwoVcDQMAA6EqwCMOBPragoR0a2Ld5Q3vW8P6OYrAYtexUzGLQmrkqAQQMgFMNF/exsd0moZF938C+hp6Zx+zb8K82m8WgpUcDQMAAOJlg0fbGdmhcn9c1PyH2WoRemsEJnaZJDBrmaAAIGACtDxefsmbelFSn1xgy5nvubwhS70/0dB1lfgqAgAFA18JFLSEj39+XrP1DosqYZYZNAQgYAMLF8UJGh8LFqlu9GQACBkBbAkaYg3BxoptfOmTEIBX2ddTRUznLP5fmZgAIGADHDBenPA9hNWS8yRvWiy3h4hR7aXY5FpdeaQsgYAAcI1yMYqO7CwrfLnUC4WIRP8uA8O/883bl78N2V33LlSFTAAIGwEHDRWiw/pad1utZt5nmjerLEwgXIQz9mn9mVXoaYiAM+/H37Nswr+GWH5nkv//a1Q4gYAAcImB0YWhUylPeqL5tYbhY5J/nGIIWNZ3Dsxg0rjbsY63rhgAIGACkGqbD7FvvRVeFp/bTloSLECbCehWTA5zTi4KwIWQAAoZDALBXYzM8uT8rGn6T/31oeI86fhjmRw4XoTH/nJ+D+yOc/7DfNzFwDFaCzqX1MgABA4BdGpfhVazXqYAR//6LI9V4uLmsayjUnkFzHMPGMKtpBXQAAQOgP+EiNCbD3Ipp0eTeji4y1yZ/zAFp2bVxEYNGCJg/Gi4F9M1fHAKAyg3IECxe4v+9Lfg3A+GiUddtDBdBvl0hdJ7n/zN8LpwqoG/+6hAAlA4WITQ8rgSH5w1PpzUsm3Eyi9vF4VGGSAECBgCF4WL1TUmhobtpcbV3jloj4cK8BoCWM0QKoHq4CKZbxtbrwRAuAHpJDwZA9XARPGz4mdERGt9hLYrf4///e8cCjnABIGAAdMZjIlzMtrwW9ZBrQoSg87TemxKD0V12+iuICxcAAgZAN8S3RY0Tf/Vhy4/+7UCbeF20anUMHLf5PoRtDWt1DE/wFFgVG0DAAOhMuAjBoujp/3TLjx+iB+O2KFysBY15vi9vsvQwL+Gi+PyHY7VcmXu0tl2v8djOlBSA71loDyDduPy00sD8U8M3b1i+2fLzn9YapXVb5NvwY8V9GpxQyDhouMiPzTCer7fx+FQ5Rou4vZ+zbxP/F0oQ0Hd6MAC+b4h/LAgXwa8lfs2o4c18qPoDobGe79v5CYSMg4SLlYUQr/Y8HsP4CZPqH/PfGwJGGJY2ETaAvvKaWoA/u8s2z1dow2TjnRqusdF+nrV38bfGw0Xorcg/YRX2/8nSE/j3NYzX0G/he47wRjEAAQOgLWJjcNtbl2YtaYjvpMUho9FwsRIsfsvSE/ebEL7nU/69H+MwLAABA6BH4SIMmXnZ8s9eW/JGo72eurcwZDQdLkJo/HLAYLEuDJ8KPRr3ShogYAD0R2iEDks0hMtoOoSM9v0FLQoZjYWL2GsR5pyEoVCDFlxjd/n2fNGbAQgYAB0XG3x3NTeam3RVxy9ZCRnH6pV5bTBchBD2JWt+wn1Voffpi7kZgIAB0G1lw0VbhhQN47CfUw4ZTYaLcVb8muE2+PrK4LidAAIGQJfE3ouyDb3/LfnvPh8iFNU11CYsxnfgkLEMF/MGzmc4ly8ncvm9CBmAgAHQPXcN/M5D9HR8Xa8jTk4/tZBxLVwIGYCAAdA5FXsv2hYwgq8rjp9YyAjhYtrAuXw8wXCxGjJGSiQgYACcvqq9F/9VsqG+yHZcDK9FIaMJD/nvnzQQLkKweH/i16K1MgABA+CUxQb5xQ6N+bKmB9ydJkLGdc3bOMl/731D4WLcgUvy65A3JRMQMABO10XW7FuGPh94f+oOGZMaQ8Y8/311B5YsLlw37tA1eWYxPkDAADhdNzs24ss20EMPxkLI+HoMah9yFSdG33XwugxvBztTPAEBA+CExLHuuzTiBhUb7x+OsHttChlhsvhl3WtdnOjboqp4VEoBAQPgtFzs8bNVgsnTkfavLSHjtu7X0fYgXAQjb5UCBAyA0/J2n8ZfhYZ5eHI/6VDIqLIvtb8xqifhYulOMQUEDIDTsU8Pxt8r/vuH7HArZDcdMq5Lhoxp3W+M6lm4+Bpk9WIAAgbACaih0Vbp5+OaGM9H3OWzOhvmJUJG7a+47WG4WLpRYgEBA6D99g0YYaJ31R6QMBdjccR9vojrRTQdMkJPzXWdk7p7HC6W522gyAICBkC7va3hd7yr2CD/2vA+8n6PDxAyruuc1N3zcPFHyFBkAQEDoN2Gx2j05Q3vWfZtPkZnQkbuNvs2JCp4imt/CBf1eucQAAIGQPcDxi7DpLI48XnWlZARe2bOY7i47XC4eI3nbZYdfsL+SJEFTs0PDgHQF3GC96eafl14U9LlDtswiNtw7NWaaw0FNZ6jcFy+tGRzQqB4Xu+ZieHysaawWsabutcTAWiSHgyA3VzEFcErWZmP8Xrk7X8fewraFi4+tWBTliuQn6eGfcX/9iY7XG/USHEDBAyAdqq7obbTYmjxafR5C0LGS1tCxkq4OPZbk8K5ebNtPkkMipfZf+agNMmbpAABA6Andn6NqJDR2nBxHtcuKXMOw7k7xDCzt4oaIGAA9ENoEL/f9YeFjFaGi9eK53CWHaYXA0DAAOiJu13mYrQ0ZBx0zYVTDxcrflUMAAQMgFpDxj4/3LKQcZC3W3UoXASzhrdxpIgBAgZAv4zjK3BPPWR8fYVu0yGjY+Eiy0zCBhAwABrwuO8v6EPIiMPJuhQugqYnYc8UL0DAAOifs7zxfC9kbAwX4fd+7Fi4CC5c/gACBkATbupolLcsZNQSBlq0gnmt4SLfr/AWsaFLH0DAAPppdoBG+Usdv6hLIaPD4SLsz92BthtAwABooUM01msZKtWikHG2T8jocLg45HCv3xVdQMAAaKHYYD+Eu33fKtWFkNHxcBH2a3jA7QcQMABa6lCNtY/7LMB36iGjB+HiYPsVVwsHEDAAeh4wBjFk1DKEpkUhY+scE+GiVlNFFhAwANrt84Eb5I91/bKWhIyLvKG9LWQIF6d5vQIIGAA7OPQT4bDKd9dCxrgoZMT/LlzUZ6LIAgIGQIvFRuehJ82+zxup466HjPj/x0c+xV0KF9MaFwMEEDAAGvThCN/50uWQIVw04llRBU7RDw4B0Dex4fg/R/r667wBPKlxX85iI3hwxEM6zwyLqtss35dzpRU4RXowgN6JjdDJkb6+iz0ZwkX9HpRUQMAAOC3HHH7SxZAhXNRnZu0LQMAAODGxUX7MRpyQIVykhH25VkIBAQPgNB27ISdkCBfrHvJ9WiiagIABcIJiQ+5JyBAuWhIuwmtpn5RMQMAAOG1hMu2igyGjq8NsuhouunzOAAEDoD9iQ7UNDbu6Q8a0gw3WroaLsD+XFtUDBAyA7oSMWf7HbQdDxqRDIaPL4eLcvAugSyy0B/CfRmcbVqMO6l6ML+zTi3DR2nAxV/qALtGDAfAft7Exe2x6MoQLgJOlBwPg+wbol/wzbMHm9L0nQ7gAOEF6MABWxMbsZdaO17z2uSdDuAAQMAA6EzKWa0m0QQgZ9z0LGcIFgIAB0MmQ0ZaG+F2cgN6HkCFcAAgYAJ0NGaEhftuSzRn3IGQIFwAdYJI3wPaGalteXxtM8obqdY37FvarDRO/hQsAAQNAyBAyhAvhAkDAANi14RoarSMhQ7gQLgCKmYMBUN5l1o6F+IIuzMkQLgA6SA8GwGk2YpdOtSdDuAAQMAAQMoQL4QJAwABoKmT8ln8GQkYli/zzRrgA6C5zMAB2EBvI57Fh2QanMCcjHKtL4QKg2/RgAOzXyD2LjVw9GQdshAsXAAIGgJDR35AhXAAIGAAIGbWEDOECoGfMwQCoQWxompPxvVvhAkDAAEDIKAoZkwo/ch1/RrgA6BFDpABq1oPhUiG0jIULAFL0YADUrAc9GSGsbAoPD8IFQH/pwQBoSE97Mmr7DuEC4DTpwQBoSEt7Mh5r3L/1ngzhAgA9GABNa2FPRm3zI+L+vawEDuECQMAAQMhozXESLgAEDACEDOECAAEDoM+N6FaFDOECQMAAQMgQLgAQMACEjPaEDOECQMAAQMgQLgAQMACEjPaEDOECoLsstAdwRHnD9msDN/vzgnXH9JI3/sfCBQC70oMB0BJxwbpxSzankZ4M4QJAwABAyBAuABAwAISM9oQM4QKgP8zBAGiZvPF7nf/x0JLN2XtOhnAB0C96MABaKjbsX1qyOTv1ZAgXAAIGAEJGLSFDuAAQMAAQMmoJGcIFgIABQLtDxkUMGYO2hwzhAkDAAOA0QsZZbLi3NmTEbXwRLgAEDACEjKpu8wb8Uwu3TbgAEDAAONGQMQmv1RUuABAwAE4/ZHzMP8MWbM40/4yECwAEDIDTDhltmUzdBsIFgIABgJAhXAAIGAAIGcIFAAIGgJAhXADQtL84BACnL29kf21s55+ZcAHAMenBAOiYn37+JSx0NxYuABAwABAyhAsAAQMAIUO4AEDAABAyhAsABAwAehUyhAsAAQMAIUO4ABAwABAyhAsABAwAOhYyhAsAAQMAIUO4ABAwABAyhAsABAwAOhYyhAsAAQMAIUO4AEDAAKA9IUO4ABAwABAyhAsABAwA2hMyhAsAAQMAIUO4AKDYXxwCAFbc5p+mG/3CBUCH6cEA4E9++vmXQf7Hp/xzJlwAIGAA0NaQIVwACBgACBm1hAzhAkDAAEDIqCVkCBcAAgYA1BIyhAsAAQMAkiHjt/wzEC4A2MRragHYKg8JX8NCDA3CBQCF9GAAUNpPP/8ShkmF4VID4QIAAQOApkOGcAEgYABALSFDuADAHAwAqoshYnVOxly4ACDQgwHAzmJPxlX+eYgTwQEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAoBV+cAgAgD756edfXvI/hom/uv7XP/+xcIRgP391CACAHoWL9/kfY+ECmqMHAwDoS7gY5n98yT+DRLiYOEJQj784BABAT7wIFyBgAADs7aeff7nP/xit/eeJcAH1M0QKAOh6uDjLvg2NWg8X144O1M8kbwCg667yz2zl/8/zcHHrsAAAAAAAAAAAAAAVmeTdEj/9/Mso/+Nd/gkT0UZrfz3LP/P88+Ff//zHvMFtCN+9+vq+17q/L/+OQdzHrOHvWd+XIIy5fT3kdhZsx0b5d8xO4Frd97ikjm+wqLrQVWJ7Sh/D1M/WoNQ+xPfxD2v4vtLXdcnzcpF/3sZtSx2fZX30Of/eaQ3fWfU4LA61GFqi/Nb+3QVlYdHGBd821We71ltbzn/la7uuMl1mfzbUY5WOR9Fx3fd31H0viedqWT+cJc7bfFk35J9pXfXShjrqLFV24me5DfOMozDJux0V9mPBjXxpFD/v838fKozbhgrNx/UKI/++/665kgj7+ynRYDmveV9Sx/Q8+/Mkv0Ns57Zzm7omlhV1+L7nFjY06jguqeP7Nazk+/9jxWvu0x4PTz41cHwe8s99iX83zj93NXxflet60007rG58UyIQr9ZH4Tw955+nPeqJyschfm8INw9NlY+VBdnWGy8/1vxVqbJQ9ho6tML6LD9elzsGzo9FjfQdr+26yvTWOiRc8/l+38QG707Ho+DtVlm8vmd7npsfaioLo1g3XJS4ls9imX7Mf27fumG9PN5l6RXYVw1XHo7c5T83j/XENOOgrINx3HAxjpVhlQZo+Ldf4s/WvS3DxF+9d6aO4iwe+9/yc/MpVq59EBq3L07/weuh3+LNe7DD+bqL1+nFga+Tcfzex4a+4ybVeGmo16sL3u1w7Z1tCBenIrzmNtWAfonBvUww+O5BS/y9x64bBrF8fSoRLjbVDaM9t+N9DGG7tHvC9fWxZ/dRAaPnN/Vlz8Vgx1/xEn9HXa4q/ncOZxQr6fue7O/FgRurfa6HXrL0ysa7NPg/1v3go6T3cT9qbVhtaMzcuHKSxiUb1J26v8Sn89cFZeKlRMM51fi+bmJ40Q5lIASL9zXUDZ92rdNj2d6nrbR6H/1Sc7sJAaOVigpM6M4L7+Y+j5+n7Fu3/LqHuoZJxQJX9IRheKRGA9+7q7sh1ebysUNjheo37k1lO9Q7k+zbcJ3lZ1JQH7WhcVtnPXWxoUFz4Ulo8Xlo+N+3NWSE4TfTgmtlVFD+wjWUGho4PfZwnpVwsakxPlurG5621A0vVctNiTpqHr93dTvCsXvdEnaEjAMwB+M4hbeoQR9Cw32iEN+uFbTwdGNS4yZteyJ3FRsW1ON8ffLdymTB8Hm3IfCFhlTWg9VnlzffRhfCyo/jD1vK6ndDGLf9TN3XRkN10PsNN+5ZrItmG35+HM/PaoOhznopVReuvgwj9VT1rsZ6atuckJumr80TdRMbfGWuwXG2/1PpWsp5Ta5jXTFINKzfJHokUg8ZWzE0Kts8L2aSFc99uo1l9HHt58N+3VaZLxV77DfVUYVzUbfMKVv2tr45di9R1+nBOI5U43GWuqGuVJDXsWDXGi7iE4Xxtu2V+Bu/AYY3MYVrIEyICz1XYSLpdEPI6MMQovfGuzcSLoZZetz3smG/NeTEOujNSoO+7oceRd87i6svp14qMKyjnorX3HDLPxvrYUs/GKhwDt51acdjY/Vyw8OS1Wss1N+pOrwNQ6OKhm29xgcg15uCQqw7zlfqhnn8uUmFbTjbEPJvYx0133I/vY911LzgnDwqrgJGF6VuTJ9LVGBN3MRT4SJVII07PuzNKrymMtysip5mvfSkgfOiIVe7uw3h4r5iKL4+VLhINGJmJevWOo7PLPE95gmlbb1XrLzutGv1drhOnjY9LIn1WWqoa1uGRt1tCBezCmHrNh6L8x2Gcxc1/kNd81ThfCxi2FkUPCQYKq4CBoe7Gbxm6aeDntgd54Y1ydJDMZZdwF2SurkOs3pe5Uq2scdyViVcJK7RY/jc0PEZJcLFQ4Wg1ncXJe4V44JGbBc8FDRoH1eum7YOjRoXhPTKcz7jA4jbHdYxSZXBZQCrXNdsmISvDAsYnZQqcFeHbsAXjIGdxAKZKsheWXuckPGUpZ/Wdu0NX//Otjz9Y//GX8F/P8X5BE0MsUk1OD7EJ7frjUavrE0/GCjTu3NV8gHDKdbXRQ3as/x6+VhwH71uyXyA1HlZVOk1qCnk1FpHxfI7qVAfImCcrFRjMaT2Twe+YaW6sp+XN9UeNGhPyXPqmung3Jiip3/WxmiuUT4/tdVu48OR5Erwe/zOVMP4deWp6XPJOrRvfq1yXArmuIRw8XtXDsiGoVKpBu20DYvAbViV/PnAm/K24Bgt9vy9qf0YeEjQHG+ROk7lM48rcq9f2GcxZCxiYZg2uErtKFGZzJbfFyrIuB3DtQbt+IhDIvp8zUzj6sWDxDUz79B+hpVxw9O/T4kwdb/rMJ4TclXxhjer+NapVAPiw4mEikGsM0NIGhcEpX3qy3GifE3W/vf62PCvr6xtqp4+kTI7iYuxrR678LT+rCC4XhVcg2cNXjtV643Jvuc0DA8quM+uB+K2vBGwaDsPHX5GJUPsLu2uRSLchv2eZQgYHRK6+74U/N0w3sge4zL3HxoIG1clGhrPiRuqV9YezzxR+Q472GAJ4TY8/VsfShDWAZme2tP2HRq5VVW5ORatvbOtgTYuea0tanoAEc511fHR+w7z2tSjuwy/k8Q58srab/eE94l7xTwREseJa2bacG/s3Q5lqo777fWG+/zXv2/Rq1JT5fu1JeG5rjo/FTDMLW2IIVLHa0TNY+WzrXJZrvgdVnKu5Y06BRM9XxMNg1RDwStrT7+SPQUPBWXDUKn6lWlAXMVG2rbPsYZRXu+zfkh8beh6w2OWaFylenu8ACM9/CQVllNDhD509aDE+3xR4J4dYs2bPQPGQe85Rb23NT5U+pwhYPQkZISKJ7ynuWwlEyrsOpa6Tz2pmyS2r2iyt3HHx/G/PSobmyZK3rsUaj3WixPe/K9rD9TQa3JTpuFbMNl7kHVkReo9r6H1+9ggsbp6qXtPV8R7ddG1MTL+vxX+5hAIGJ2tmOPCaiFoPGXbnyaGpwyfdn1iVtBFHRRN5PLErj3e9qxshLG/qfG/d3rRam0EnWIjJ9STYVjSj/tOkI3X0voxeN0QWkz2Ln+vuFo7zuvldtrx+Svbelzbvs7P4Ajluqjd0lSY+F3RbYY5GO1pTIUuwPC5jRVxqJhT3fbLQh+GTe0yOewiUWnMiir5gsneQRhve+/MHb2yf+34Pl/Hxt8gceN+08H9PT/CsIkyN++iIQpNhZPJSoP1JksPrZnUNH696lP1Sfb93LTwEoKLNrwN6Ij3sNRk79HKJPgy8/6a2rYfjhDc77PtE9fDffUua8ccnln2/VyVswNfQ4v8uKX+qq6J2B5MCRjCxkrYeJ+lF+YJvQi3O9xgU5Pdwk3g/yr+nisB46A3q2FB5TjveFkIE2tvs++fBIahUu8P/H72LpgnrqPwVqbplvNwW3Bd/l9D2/n7MmjFBxzrIXNYx0OODT2672PdWzWoTHt+fU2y7yd7j+N5Wj/Oi64GsviQMHWvXWSJh3X5v//cgmPxWrAvowM/9Egdo3f7BowNr+GdZzTCEKn2N7BCA+q8jjRe8P7xXQ0T42tpzrjg+pj1oAxMCm4udzF4UV7qOF60eZhGfPr93ND5r3Px0JHrMXmergoWde3k5O5Ylj4WNJzfZAXr/By7DMYHm8lFgNtQR9Xwey8qfB8CRm9CxrymQlD3OOE2L7w33zOQDQtuEMe4YRU9DZv0qBik3rgWbsjeKlVN6i0qg5ob2k0omp+27/mvuw676/PFVTDZO9Sljz2qv+4K7h/XG15e0Za6bFrwAOKQwTm15sVeDzRjeEuVzVmLXhMsYNCqBnOVAjas6SnAqja/BSM1cavKJOnUisf/PkK4KHoaFnzoy8UfGy4PqWtQ1VDpOE4LGuo3bZ44HxsBDwV10MWOZWuc1b+OzIUXYCTrpfVj0snJ3fF+mArrT8ve5k2rfO96LdfoueDcPe54PC6q1isb6qjHPYJOUej7kCFgdLAiCq/w+xg+ZRvze37lXUFoeajwSRX6tvZiFD2JGZU4N2cFYWx2hJvVbwUV41Mfhket3XieMt3ZdXgoaES8tHmIz4ahcrsOL7kqKONV6sRUr9q459fXNNv+8onONeziNZjqhUiF46L76VHL4IbREuHe+VLxeIT7aGjffNnh1eJFddTHqmU9PkhIhb66FgWlgEnex6uIPmVxyE4ouPmFfr2lgOw8OSl+X6rB/FylgMXJluuVTJhs/tC2p1HxbRSpCa2hAj8v2t4NN4nFoVaQjk+xbjaEynlBBdwHYbLxF7XIfg31/Bq7SlxfZ7ExcN3iybcPie1eDn+4rVDGRgXl67pKXZb/nr9l6ZW9n3p8fYUXM0w3BK2uTu7eNjRq/Rhdx3bAd0E/K553eQjL1cdTL5YZZCVWH4/3sNX7aJgvFUYFXJYpX7GOukncv1frqFmJds/jhuvwOkPA6Fi4OIuVymCt4Ib//rBa8a6suL3v2MFxorJ43SG9T2OBHSR+//0eh2VY8QnHpGQj4CH7fnjRMFZQz6u/Z+VY32Tp13bW2aC/SvSk/D1+72jLz76WqeA73HiZh0CbdXes+9UOww53eRJX1IhYPiUMIfZDrGfma3VS+LzL6h9yWeb8h9dmTxKNhvAmng8VHgJcFdSpVR+UPCe2pY5X1r5tqE48lOcNDbuD917suDhn6ZW2NwyNmhZdB/FanibK0eiYb8iLD+dSb+7L4raOYhn8dfX4rDzIvCq4jy3XQSl7nV4W1FGh/glrgc1W6qjFyjacxfppnBW/gvuhbyMABIx+OCu46M/ijT3873n8N8Mtjeeyalk9dcOTqZt9A0bFBuOsTCUVKvaCCnz5xPOu4J3bqZvEpMZrYLzjz83LPgHqeMi4j0/DuvhO812ujVnV8hwbEeeJhx3rjYGsZBk5pIcsvZ5PePix9cnvysOEVKN4l8Cb6ind95W1o6zasNhSdeKBHwTMC8ro5AibtOsDiVmJ62nT0KhtvWpF6/yEe9PsUL3mifM3ieU+tV/Ll0K8r1g3TKqE7hJ11B9lZIftuM9onDkYRyi42fauubMt4eK2wpOVosX6nnfcheTYyBa/svY622+C/DxrR1dqOO7nfQ8Xa+eVPRuBsUE+P7HtXhTUX6OS9VDq3+wzbKdoW4Y9v8RSx2XWwTqsaGjU1qHDbX6rVMm2SpVG/fUO27Cso+q6Zh522Q4EjFMLGZfZbqswX1fsOk31Xuz8Bo+C1xAWfU8bjvVrrKB2aTxMY6P+WMORwveGa+XH8MTF6/S+u/FYZK++kFHHEMBpdri5QUWvrX0sMQk0VVd92OMYTgrq8rueX16pyd6dmty9YWjUrOx9Ogbb1P3pbMehXXW3Vd5ku79cI5z/y30a9bGOerNnfR+2/42ei8MyROp4BXcaxxCO4w1vuO0JQJknImuV32ClcK163nPznwu+b1hi+16z/d8E9FrxWH+t5OLNINz0RyUqo7rGaO7ydPhzVmH87xHMatjH1HVQNfQ+xHLT5GtBm3y6v8jqeSvWXtsYy8f9ytyGq6z861uXczX2ee3oouq1sLLCeyosjIsaI7EOmBfUr/sI1+L6q60He5SFRuvEQ1xr8RyFe8XbtQZrletgl/2a1Vg+t7kq+L7bit91XXC9hLk4g5IPlxqpq5YPIWLZCft7UeLaXsR64amOB2Pxd9zG6+kmbkOZOioEt2fzLY7jB4egNU9ChrHhO1yrXOcKRyPH+o8x5msV9NwwJJSRPyZzjwoaDwv1EvS2fli2VYbHuoduuI9rNwEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADQB/8vwABGEr+x1/rY8gAAAABJRU5ErkJggg==\";\nconst html = String\n .raw`SIM · Consultorios Comunitarios

$\"Salud$

Consultorios Comunitarios

Tablero de seguimiento y atención

En línea

\n\n

Registro de atención

Los campos con * son obligatorios. Si no hay internet, el registro quedará en este dispositivo y se enviará automáticamente al reconectarse.

\nFecha de atención *Nombre del paciente *Fecha de nacimientoEdadSexo *CURPExpedienteMembresía *Primera vez / SubsecuenteLocalidadMédico que atiende *Enfermera que atiendeProcedimientoCódigo CIE-10 *Nombre del diagnóstico CIE-10 *Programa de atenciónMedicamento entregadoCantidad entregadaAuxiliar diagnósticoCuota de recuperación (máximo $50)¿Es referencia o contrarreferencia? *TipoServicio o institución de referencia Tiene condición de vulnerabilidadCondición de vulnerabilidad *Observaciones

Mi hoja diaria de atención

DesdeHasta

Tablero administrativo

DesdeHasta

0Atenciones

0Pacientes con CURP

0Días con actividad

Por consultorio

Por sexo

Diagnósticos principales

Carga masiva del registro histórico

Admite el Excel original con sus 39 columnas. No elimina duplicados: conserva todas las atenciones y registra hoja y número de fila de origen.

Catálogos separados del sistema

Cada opción se guarda únicamente en el catálogo seleccionado. Los médicos no se mezclan con enfermería, medicamentos, programas, vulnerabilidad, precios ni CIE‑10.

Seleccione el catálogoArchivo exclusivo de este catálogo

Catálogo seleccionado: CIE-10

Agregar o modificar opción del catálogo CIE-10

Correcciones de atenciones

DesdeHasta

Seleccione Editar. Cada modificación queda registrada en la bitácora con el usuario administrador.

Administración de usuarios

`;\n\nexport default async function (req: Request): Promise {\n await init();\n const path = new URL(req.url).pathname;\n if (path === \"/sw.js\") {\n return new Response(sw, {\n headers: {\n \"Content-Type\": \"application/javascript\",\n \"Cache-Control\": \"no-cache\",\n \"Service-Worker-Allowed\": \"/\",\n },\n });\n }\n if (path.startsWith(\"/api/\")) return api(req, path);\n return new Response(html, {\n headers: {\n \"Content-Type\": \"text/html; charset=utf-8\",\n \"Cache-Control\": \"no-cache\",\n \"Content-Security-Policy\":\n \"default-src 'self'; script-src 'self' 'unsafe-inline' https://cdn.jsdelivr.net; style-src 'self' 'unsafe-inline'; connect-src 'self'; img-src 'self' data:; frame-ancestors 'none'\",\n \"Referrer-Policy\": \"no-referrer\",\n \"X-Frame-Options\": \"DENY\",\n },\n });\n}","deleted",false,"label",[14],"97e2efb0-4e30-4e23-a2bd-4b36321627f9",["D",1786060146299],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","TABLERO DE CONSULTORIOS SIM","imageUrl","userId","bd4199ac-b665-4e2f-8ebe-7ffc963366a0","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019f4e07-da8f-738d-93ff-a83fde53036f","tursoName","97e2efb04e304e23a2bd4b36321627f9","tursoHostname","97e2efb04e304e23a2bd4b36321627f9-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789474853273],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_104":100},"org",{"_9":10,"_97":98,"_99":100,"_55":-5,"_101":102,"_103":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","LUCERO CABRERA MOYA","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/3624a274-32c2-4d2d-aaae-608eb0334100/square512?exp=1789559999&sig=4f06610559e44bdf461925e4d6c0e11747e511e8fa53827be1910d9eaaec1713","tier","free","canRestrictVals","profileImageUrl","ctx",{"_81":-5,"_138":139,"_140":141,"_142":143,"_144":42,"_145":42,"_146":42,"_147":32,"_148":-5,"_149":-7,"_150":-7,"_151":62,"_152":42,"_153":42,"_154":-5,"_155":42,"_156":42,"_157":42,"_158":-5},"ENV",{"_109":110,"_111":112,"_113":88,"_114":115,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137},"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"]

Ingreso seguro

Registro de atención

Mi hoja diaria de atención

Tablero administrativo

Por consultorio

Por sexo

Diagnósticos principales

Carga masiva del registro histórico

Catálogos separados del sistema

Agregar o modificar opción del catálogo CIE-10

Correcciones de atenciones

Modificar atención

Administración de usuarios