[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_157":158,"_159":160},"routes/_app.x.$handle.$name",{"_99":98,"_32":45,"_108":89,"_27":36,"_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":25,"_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":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_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":25},"version",2,"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","69332e1e-91f1-11f1-a80d-1607ee4eb77e","name","fileType","script","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] as const;\n\nasync function init() {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS 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 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 ]);\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 const pass = Deno.env.get(\"SIM_ADMIN_PASSWORD\") || \"\";\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: [\"admin_password_fingerprint\"],\n });\n const admin = await sqlite.execute({\n sql: \"SELECT id FROM 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 users SET salt=?,password_hash=?,role='admin',active=1 WHERE username='admin'\",\n args: [salt, hash],\n });\n await sqlite.execute(\"DELETE FROM 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: [\"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 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 sessions s JOIN 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 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 (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 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 médico\" },\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: \"Referencia LCDV\" },\n { k: \"referred_service\", l: \"Servicio referido\" },\n { k: \"other_referral\", l: \"Otra institución\" },\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 users\");\n return json({\n ready: Number((r.rows[0] as any).n) > 0,\n needsEnv: !Deno.env.get(\"SIM_ADMIN_PASSWORD\"),\n });\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 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 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 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 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/encounters\" && req.method === \"POST\") {\n const b: any = await body(req), e = normalize(b, u);\n const er = validate(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 === \"/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 html = String\n .raw`SIM · Consultorios Comunitarios

Salud Integral México

Tablero de Consultorios Comunitarios

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.

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.

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}","createdAt",["D",1786060200189],"branchVersion","branchId","a3a3e721-ddfb-46db-a6d5-cea9ec899253","id","97e2efb0-4e30-4e23-a2bd-4b36321627f9","CONSULTORIOSSIM",["D",1786060146299],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","TABLERO DE CONSULTORIOS SIM","imageUrl","bd4199ac-b665-4e2f-8ebe-7ffc963366a0","pinnedFileId","pinPreview",true,"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",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":-5,"_104":105,"_106":25},"branch",{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"isOwned",8,"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=1789563599&sig=fcfaaed2bac401c8d4ad022a2bd994da692540cc6c2248277881117d5d6cfc61","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":152,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":153,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":154,"_83":155,"_85":156,"_87":25},"tree",[147],"files",[147],"counts",{"_137":62,"_138":134,"_139":62,"_140":141,"_142":143},"contents",[129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":25,"_38":133,"_13":134,"_33":34,"_35":37,"_24":25,"_135":-5,"_27":136},"dcdfc5d7-ae7f-4ef7-8115-a1e77032845b","parentId","latest",["D",1786060200189],1,"label",[28],"pulls","branches","forks","envVars",{"_144":62,"_146":62},"connections",{"_144":62,"_145":62},"count","unfilledCount","emptyCount",{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":25,"_38":148,"_13":134,"_33":34,"_35":37,"_24":25,"_135":-5,"_149":150,"_27":151},["D",1786060200189],"children",[],[28],["D",1786060146299],["D",1789474853273],{"_99":98,"_107":103},{"_99":98,"_100":101,"_102":103,"_18":-5,"_104":105,"_106":25},{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"ctx",{"_81":-5,"_126":190,"_191":192,"_193":194,"_195":25,"_196":25,"_197":25,"_198":58,"_199":-5,"_200":-7,"_201":-7,"_202":62,"_203":25,"_204":25,"_205":-5,"_206":25,"_207":25,"_208":25,"_209":-5},"ENV",{"_161":162,"_163":164,"_165":89,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189},"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"]

Ingreso seguro

Diff · v2