¡Bienvenido al Club!

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_263":264,"_265":266},"routes/_app.x.$handle.$name",{"_97":96,"_32":45,"_105":87,"_27":106,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":59,"_123":-5,"_124":-5,"_125":126},"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":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",24,"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","restantes.ts","latestPath","fileId","ed79803c-a57f-11f1-b44c-1607ee4eb77e","name","fileType","http","content","import { blob } from \"https://esm.town/v/std/blob\";\n\nconst MESES = [\"2026-03\", \"2026-04\", \"2026-05\", \"2026-06\", \"2026-07\", \"2026-08\"];\nconst EXCL = [\"LADYS LAVANDERIA\", \"LUIS LUFI\", \"LADYS \", \"CLIENTE LOCAL\", \"X X\"];\n\n// ya contactados o descartados en esta ronda\nconst YA = [\n \"ALEJANDRA MORA\", \"SARA GALAZ\", \"CARLA VIVANCO\", \"MIREYA QUITRAL\",\n \"JOANNA CELLA\", \"MIGUEL ZARATE\", \"MANCILLA ALVEAR\", \"MANUEL SILVA\",\n \"PABLO PRADINES\", \"CATA DANIELS\", \"SERGIO MANRIQUEZ\", \"FERNANDO BERNDT\",\n \"PAOLA DUARTE\", \"DANIELA RIVAS\", \"ANDREA ILABACA\", \"MARIA PIA OLIVA\",\n \"CHRISTIAN LENIZ\", \"MARIO HERRERA\", \"SERGIO CANALES\",\n];\n\nconst B2B = [\"ULTRATUG\", \"AFIM\", \"MD CARS\", \"CASAS BALI\", \"GLIEWE\", \"CARDINAL\",\n \"SPA\", \"EIRL\", \"LTDA\", \"HOTEL\"];\n\nexport default async function (req: Request): Promise {\n const u = new URL(req.url);\n const min = Number(u.searchParams.get(\"min\") ?? 40000);\n\n const data: Record> = {};\n for (const m of MESES) {\n let d: any = null;\n try { d = await blob.getJSON(\"el_\" + m); } catch { }\n if (!d?.cli) continue;\n for (const [n, v] of Object.entries(d.cli as Record)) {\n data[n] ??= {};\n data[n][m] = v as number;\n }\n }\n\n const filas: any[] = [];\n for (const [n, mm] of Object.entries(data)) {\n if (EXCL.some((e) => n.startsWith(e))) continue;\n if (YA.some((y) => n.includes(y))) continue;\n\n const vals = MESES.map((m) => mm[m] ?? 0);\n const activos = vals.filter((v) => v > 0).length;\n const total = vals.reduce((a, b) => a + b, 0);\n const prom = activos ? Math.round(total / activos) : 0;\n const ago = vals[5];\n const ult3 = vals.slice(3).filter((v) => v > 0).length;\n\n if (prom < min) continue;\n if (ult3 === 0) continue; // sin consumo en los ultimos 3 meses\n\n filas.push({\n cliente: n,\n prom, total, ago, activos,\n empresa: B2B.some((b) => n.includes(b)),\n meses: vals,\n });\n }\n\n filas.sort((a, b) => b.prom - a.prom);\n return new Response(JSON.stringify({\n n: filas.length,\n filas: filas.map((f) => ({\n cliente: f.cliente,\n prom: f.prom,\n ago: f.ago,\n meses_activos: f.activos,\n total_6m: f.total,\n empresa: f.empresa || undefined,\n })),\n }), { headers: { \"Content-Type\": \"application/json\" } });\n}\n","import { blob } from \"https://esm.town/v/std/blob\";\n\nconst MESES = [\"2026-06\", \"2026-07\", \"2026-08\"];\nconst EXCL = [\"LADYS LAVANDERIA\", \"LUIS LUFI\", \"LADYS \", \"CLIENTE LOCAL\", \"X X\"];\nconst B2B = [\"ULTRATUG\", \"AFIM\", \"MD CARS\", \"CASAS BALI\", \"GLIEWE\", \"CARDINAL\",\n \"SPA\", \"E.I.R.L\", \"EIRL\", \"LTDA\", \"HOTEL\", \"RESTAURANTE\"];\n\nexport default async function (req: Request): Promise {\n const u = new URL(req.url);\n const min = Number(u.searchParams.get(\"min\") ?? 0);\n const orden = u.searchParams.get(\"orden\") ?? \"asc\";\n\n const data: Record> = {};\n for (const m of MESES) {\n let d: any = null;\n try { d = await blob.getJSON(\"el_\" + m); } catch { }\n if (!d?.cli) continue;\n for (const [n, v] of Object.entries(d.cli as Record)) {\n data[n] ??= {};\n data[n][m] = v as number;\n }\n }\n\n const filas: any[] = [];\n for (const [n, mm] of Object.entries(data)) {\n if (EXCL.some((e) => n.startsWith(e))) continue;\n const v = MESES.map((m) => mm[m] ?? 0);\n const activos = v.filter((x) => x > 0).length;\n if (!activos) continue;\n const total = v.reduce((a, b) => a + b, 0);\n const prom = Math.round(total / activos); // promedio de meses activos\n if (prom < min) continue;\n\n filas.push({\n cliente: n,\n jun: v[0], jul: v[1], ago: v[2],\n total, prom, meses: activos,\n emp: B2B.some((b) => n.includes(b)) ? 1 : 0,\n });\n }\n\n filas.sort((a, b) => orden === \"desc\" ? b.prom - a.prom : a.prom - b.prom);\n\n const t = filas.reduce((a, f) => a + f.total, 0);\n return new Response(JSON.stringify({\n periodo: \"jun-jul-ago 2026\",\n clientes: filas.length,\n facturacion_total: t,\n nota: \"prom = promedio de los meses en que SI consumio\",\n filas,\n }), { headers: { \"Content-Type\": \"application/json\" } });\n}\n","createdAt",["D",1788210589444],"branchVersion","branchId","bdb49211-1e51-4906-9961-66884c839ce2","id","c6eaeccc-7f0c-4f09-8ea1-89c2dc20d6a9","club-ladys",["D",1787417208400],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Página de bienvenida Club Ladys (fundadores plan Total)","imageUrl","019d4994-8d78-7000-b4ab-acb550747512","pinnedFileId","1143d104-9e49-11f1-a1ac-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019d4994-8d78-7000-b4ab-b1c5ddec9378","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":55,"_101":102,"_103":25},"branch",{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"isOwned",42,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","LUFI","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzNCbEZzUENZZHpzbHpkTThyejIzUERENVltdiJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":259,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":260,"_81":261,"_83":262,"_85":25},"tree",[218,219,220,221,222,223,224,225,226,227],"files",[218,219,220,221,222,223,224,225,226,227],"counts",{"_208":63,"_209":144,"_210":63,"_211":212,"_213":214},"contents",[127,128,129,130,131,132,133,134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":202,"_32":203,"_30":57,"_140":-5,"_41":42,"_40":204,"_142":59,"_38":205,"_13":144,"_33":34,"_35":206,"_24":25,"_146":-5,"_27":207},{"_43":195,"_32":196,"_30":197,"_140":-5,"_41":42,"_40":198,"_142":59,"_38":199,"_13":144,"_33":34,"_35":200,"_24":25,"_146":-5,"_27":201},{"_43":187,"_32":188,"_30":189,"_140":-5,"_41":42,"_40":190,"_142":25,"_38":191,"_13":192,"_33":34,"_35":193,"_24":25,"_146":-5,"_27":194},{"_43":180,"_32":181,"_30":182,"_140":-5,"_41":42,"_40":183,"_142":25,"_38":184,"_13":144,"_33":34,"_35":185,"_24":25,"_146":-5,"_27":186},{"_43":173,"_32":174,"_30":175,"_140":-5,"_41":42,"_40":176,"_142":25,"_38":177,"_13":63,"_33":34,"_35":178,"_24":25,"_146":-5,"_27":179},{"_43":165,"_32":166,"_30":167,"_140":-5,"_41":42,"_40":168,"_142":59,"_38":169,"_13":170,"_33":34,"_35":171,"_24":25,"_146":-5,"_27":172},{"_43":158,"_32":159,"_30":160,"_140":-5,"_41":42,"_40":161,"_142":59,"_38":162,"_13":63,"_33":34,"_35":163,"_24":25,"_146":-5,"_27":164},{"_43":151,"_32":152,"_30":153,"_140":-5,"_41":42,"_40":154,"_142":59,"_38":155,"_13":63,"_33":34,"_35":156,"_24":25,"_146":-5,"_27":157},{"_43":148,"_32":28,"_30":31,"_140":-5,"_41":42,"_40":14,"_142":25,"_38":149,"_13":144,"_33":34,"_35":37,"_24":25,"_146":-5,"_27":150},{"_43":137,"_32":138,"_30":139,"_140":-5,"_41":42,"_40":141,"_142":59,"_38":143,"_13":144,"_33":34,"_35":145,"_24":25,"_146":-5,"_27":147},"13782d37-075a-46d4-9549-836f94777630","status_club.ts","3b238c0e-a320-11f1-a8ca-1607ee4eb77e","parentId",11,"latest",["D",1787949441577],1,"const LOC = \"o1V9sCKjH5Ywd9PRURj0\";\nconst V = \"2021-07-28\";\nconst BASE = \"https://services.leadconnectorhq.com\";\n\nfunction key(): string {\n return Deno.env.get(\"GHL_API_KEY_LADYS\")\n ?? Deno.env.get(\"PIT_LADYS\")\n ?? \"pit-7cdd6c37-c485-42b4-a557-644beb7d2b02\";\n}\n\nfunction H() {\n return {\n \"Authorization\": \"Bearer \" + key(),\n \"Version\": V,\n \"Accept\": \"application/json\",\n \"Content-Type\": \"application/json\",\n };\n}\n\nconst TARGETS = [\n { n: \"MIREYA QUITRAL\", t: \"+56997995000\" },\n { n: \"SARA GALAZ\", t: \"+56997060814\" },\n { n: \"CARLA VIVANCO\", t: \"+56976970499\" },\n { n: \"ALEJANDRA MORA\", t: \"+56962087915\" },\n { n: \"PAOLA DUARTE\", t: \"+56940369561\" },\n { n: \"DANIELA RIVAS\", t: \"+56932799704\" },\n { n: \"MARIO HERRERA\", t: \"\" },\n { n: \"SERGIO CANALES\", t: \"\" },\n];\n\nexport default async function (req: Request): Promise {\n const out: any = { key_ok: key().slice(0, 12), rows: [] };\n\n for (const tg of TARGETS) {\n const row: any = { cliente: tg.n };\n try {\n const body: any = { locationId: LOC, pageLimit: 5 };\n if (tg.t) {\n body.filters = [{ field: \"phone\", operator: \"eq\", value: tg.t }];\n } else {\n body.query = tg.n.split(\" \")[0];\n }\n const rs = await fetch(BASE + \"/contacts/search\", {\n method: \"POST\", headers: H(), body: JSON.stringify(body),\n });\n const js = await rs.json();\n let c = (js.contacts ?? [])[0];\n if (!tg.t && js.contacts) {\n const ap = tg.n.split(\" \")[1] ?? \"\";\n c = js.contacts.find((x: any) =>\n (`${x.firstName ?? \"\"} ${x.lastName ?? \"\"}`).toUpperCase().includes(ap)) ?? c;\n }\n if (!c) { row.estado = \"NO EN GHL\"; out.rows.push(row); continue; }\n row.id = c.id;\n row.nombre_ghl = `${c.firstName ?? \"\"} ${c.lastName ?? \"\"}`.trim();\n row.tel = c.phone;\n row.tags = (c.tags ?? []).slice(0, 8);\n\n const cv = await fetch(\n `${BASE}/conversations/search?locationId=${LOC}&contactId=${c.id}&limit=3`,\n { headers: H() });\n const cj = await cv.json();\n const conv = (cj.conversations ?? [])[0];\n if (!conv) { row.estado = \"SIN CONVERSACION\"; out.rows.push(row); continue; }\n row.conv = conv.id;\n row.unread = conv.unreadCount;\n\n const mg = await fetch(\n `${BASE}/conversations/${conv.id}/messages?limit=12`, { headers: H() });\n const mj = await mg.json();\n const msgs = (mj.messages?.messages ?? mj.messages ?? []).slice(0, 12);\n row.msgs = msgs.map((m: any) => ({\n d: m.direction === \"inbound\" ? \"CLIENTE\" : \"NOSOTROS\",\n f: (m.dateAdded ?? \"\").slice(0, 16),\n t: String(m.body ?? m.messageType ?? \"\").replace(/\\s+/g, \" \").slice(0, 180),\n }));\n const inb = row.msgs.filter((m: any) => m.d === \"CLIENTE\");\n row.respondio = inb.length > 0 ? \"SI\" : \"NO\";\n row.ultimo = row.msgs[0]?.d ?? \"-\";\n } catch (e) {\n row.error = String(e).slice(0, 120);\n }\n out.rows.push(row);\n }\n return new Response(JSON.stringify(out), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n}\n","label",[138],"69113300-2a0f-4c51-bab1-982d2a96b2a4",["D",1788210589444],[28],"83435983-dfaa-4a7e-b311-e9ae01577598","nuevos_club.ts","bf3b4a74-a337-11f1-9dbc-1607ee4eb77e",14,["D",1787959525196],"import { blob } from \"https://esm.town/v/std/blob\";\n\nconst MESES = [\"2026-03\", \"2026-04\", \"2026-05\", \"2026-06\", \"2026-07\", \"2026-08\"];\nconst VIEJOS = MESES.slice(0, 4); // mar-jun\nconst NUEVOS = MESES.slice(4); // jul-ago\n\nconst EXCL = [\"LADYS LAVANDERIA\", \"LUIS LUFI\", \"LADYS \", \"CLIENTE LOCAL\"];\n\nexport default async function (req: Request): Promise {\n const min = Number(new URL(req.url).searchParams.get(\"min\") ?? 60000);\n\n const data: Record> = {};\n for (const m of MESES) {\n let d: any = null;\n try { d = await blob.getJSON(\"el_\" + m); } catch { }\n if (!d) continue;\n for (const [n, v] of Object.entries(d.cli as Record)) {\n data[n] ??= {};\n data[n][m] = v as number;\n }\n }\n\n const filas: any[] = [];\n for (const [n, mm] of Object.entries(data)) {\n if (EXCL.some((e) => n.startsWith(e))) continue;\n\n const gastoViejo = VIEJOS.reduce((a, m) => a + (mm[m] ?? 0), 0);\n if (gastoViejo > 0) continue; // ya existia antes -> no es nuevo\n\n const jul = mm[\"2026-07\"] ?? 0;\n const ago = mm[\"2026-08\"] ?? 0;\n const total = jul + ago;\n const activos = [jul, ago].filter((x) => x > 0).length;\n const prom = activos ? Math.round(total / activos) : 0;\n if (prom < min) continue;\n\n let plan = \"\";\n if (prom >= 170000) plan = \"TOTAL $200k\";\n else if (prom >= 130000) plan = \"TOTAL o DOMICILIO\";\n else if (prom >= 95000) plan = \"DOMICILIO $150k\";\n else plan = \"HOGAR BASICO $100k\";\n\n filas.push({ cliente: n, jul, ago, total, prom, meses: activos, plan });\n }\n\n filas.sort((a, b) => b.prom - a.prom);\n return new Response(JSON.stringify({ n: filas.length, filas }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n}\n",[152],"31ce00bd-98ae-4fce-8d16-2c72b038d72d","ghl_diag.ts","4d08d028-a320-11f1-8930-1607ee4eb77e",12,["D",1787949455175],"const LOC = \"o1V9sCKjH5Ywd9PRURj0\";\nconst PIT = \"pit-7cdd6c37-c485-42b4-a557-644beb7d2b02\";\nconst BASE = \"https://services.leadconnectorhq.com\";\n\nfunction H(v = \"2021-07-28\") {\n return {\n \"Authorization\": \"Bearer \" + PIT,\n \"Version\": v,\n \"Accept\": \"application/json\",\n \"Content-Type\": \"application/json\",\n };\n}\n\nexport default async function (): Promise {\n const out: any = {};\n\n const a = await fetch(BASE + \"/contacts/search\", {\n method: \"POST\", headers: H(),\n body: JSON.stringify({\n locationId: LOC, pageLimit: 3,\n filters: [{ field: \"phone\", operator: \"eq\", value: \"+56997060814\" }],\n }),\n });\n out.filtro_phone = { status: a.status, body: (await a.text()).slice(0, 600) };\n\n const b = await fetch(BASE + \"/contacts/search\", {\n method: \"POST\", headers: H(),\n body: JSON.stringify({ locationId: LOC, pageLimit: 3, query: \"GALAZ\" }),\n });\n out.query = { status: b.status, body: (await b.text()).slice(0, 600) };\n\n const c = await fetch(`${BASE}/contacts/?locationId=${LOC}&limit=3`, { headers: H() });\n out.listar = { status: c.status, body: (await c.text()).slice(0, 700) };\n\n return new Response(JSON.stringify(out, null, 1), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n}\n",[159],"118fee37-c434-417d-82c5-cf95ebba2bf4","el_probe.ts","5959236c-a31d-11f1-92cf-1607ee4eb77e",8,["D",1787948260137],5,"const BASE = \"https://admin.easylaundry.cl\";\nconst EMAIL = \"xlufix@gmail.com\";\nconst PASS = \"Julieta7533#\";\nconst LOCAL = \"251\";\n\nfunction ck(res: Response, prev = \"\"): string {\n const m = new Map();\n for (const c of prev.split(\"; \").filter(Boolean)) {\n const i = c.indexOf(\"=\"); m.set(c.slice(0, i), c.slice(i + 1));\n }\n for (const raw of res.headers.getSetCookie?.() ?? []) {\n const f = raw.split(\";\")[0]; const i = f.indexOf(\"=\");\n if (i > 0) m.set(f.slice(0, i).trim(), f.slice(i + 1));\n }\n return [...m].map(([k, v]) => `${k}=${v}`).join(\"; \");\n}\n\nconst UA = \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) Chrome/124 Safari/537.36\";\n\nasync function ws(path: string, body: any, cookie: string) {\n const r = await fetch(BASE + path, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json; charset=utf-8\",\n \"Cookie\": cookie,\n \"User-Agent\": UA,\n \"X-Requested-With\": \"XMLHttpRequest\",\n },\n body: JSON.stringify(body),\n });\n const t = await r.text();\n return { status: r.status, text: t, cookie: ck(r, cookie) };\n}\n\nfunction ventanas(desde: string, hasta: string) {\n const out: [string, string][] = [];\n let d = new Date(desde + \"T00:00:00Z\");\n const fin = new Date(hasta + \"T00:00:00Z\");\n while (d <= fin) {\n const last = new Date(Date.UTC(d.getUTCFullYear(), d.getUTCMonth() + 1, 0));\n const f = last > fin ? fin : last;\n out.push([d.toISOString().slice(0, 10), f.toISOString().slice(0, 10)]);\n d = new Date(f.getTime() + 86400000);\n }\n return out;\n}\n\nexport default async function (req: Request): Promise {\n const u = new URL(req.url);\n const desde = u.searchParams.get(\"desde\") ?? \"2026-03-01\";\n const hasta = u.searchParams.get(\"hasta\") ?? \"2026-08-28\";\n\n const out: any = { log: [], campos: null, muestra: null, meses: {}, clientes: {} };\n\n const r0 = await fetch(BASE + \"/\", { headers: { \"User-Agent\": UA } });\n await r0.text();\n let cookie = ck(r0);\n\n const lg = await ws(\"/WebServices.aspx/iniciarSesion\", { usr: EMAIL, pass: PASS }, cookie);\n cookie = lg.cookie;\n if (lg.text.includes('\"d\":\"0\"')) {\n return new Response(JSON.stringify({ error: \"login rechazado\" }), { status: 401 });\n }\n out.log.push(\"login ok\");\n\n const sl = await ws(\"/WebServices.aspx/SET_ID_LOCAL_GLOBAL\", { ID_LOCAL: LOCAL }, cookie);\n cookie = sl.cookie;\n out.log.push(\"local \" + LOCAL + \" -> \" + sl.status);\n\n for (const [i, f] of ventanas(desde, hasta)) {\n const mes = i.slice(0, 7);\n const r = await ws(\"/ws.aspx/OT_RETIRADAS_X_LOCAL_Traer_Periodo\",\n { FECHA_INICIO: i, FECHA_TERMINO: f }, cookie);\n let arr: any[] = [];\n try {\n const j = JSON.parse(r.text);\n arr = j.d === \"\" ? [] : JSON.parse(j.d);\n } catch {\n out.log.push(mes + \" ERR \" + r.text.slice(0, 200));\n continue;\n }\n if (!out.campos && arr.length) {\n out.campos = Object.keys(arr[0]);\n out.muestra = arr[0];\n }\n let tot = 0;\n for (const o of arr) {\n const nom = String(o.nombre ?? \"\").trim().toUpperCase();\n if (!nom) continue;\n let monto = 0;\n const raw = String(o.monto_total ?? \"\").replace(/<[^>]*>/g, \"\");\n const n = parseInt(raw.replace(/[^\\d]/g, \"\"), 10);\n if (!isNaN(n)) monto = n;\n tot += monto;\n out.clientes[nom] ??= { _ots: 0 };\n out.clientes[nom][mes] = (out.clientes[nom][mes] ?? 0) + monto;\n out.clientes[nom]._ots++;\n }\n out.meses[mes] = { ots: arr.length, monto: tot };\n out.log.push(`${i}->${f}: ${arr.length} OTs $${tot}`);\n }\n\n return new Response(JSON.stringify(out), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n}\n",[166],"9a5330e6-21ac-4a3e-918d-6ca272fb5846","el_mes.ts","b4b4bb0e-a31d-11f1-a097-1607ee4eb77e",9,["D",1787948340624],"import { blob } from \"https://esm.town/v/std/blob\";\n\nconst BASE = \"https://admin.easylaundry.cl\";\nconst EMAIL = \"xlufix@gmail.com\";\nconst PASS = \"Julieta7533#\";\nconst LOCAL = \"251\";\nconst UA = \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) Chrome/124 Safari/537.36\";\n\nfunction ck(res: Response, prev = \"\"): string {\n const m = new Map();\n for (const c of prev.split(\"; \").filter(Boolean)) {\n const i = c.indexOf(\"=\"); m.set(c.slice(0, i), c.slice(i + 1));\n }\n for (const raw of res.headers.getSetCookie?.() ?? []) {\n const f = raw.split(\";\")[0]; const i = f.indexOf(\"=\");\n if (i > 0) m.set(f.slice(0, i).trim(), f.slice(i + 1));\n }\n return [...m].map(([k, v]) => `${k}=${v}`).join(\"; \");\n}\n\nasync function ws(path: string, body: any, cookie: string) {\n const r = await fetch(BASE + path, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json; charset=utf-8\",\n \"Cookie\": cookie, \"User-Agent\": UA, \"X-Requested-With\": \"XMLHttpRequest\",\n },\n body: JSON.stringify(body),\n });\n return { status: r.status, text: await r.text(), cookie: ck(r, cookie) };\n}\n\nconst MESES = [\"2026-03\", \"2026-04\", \"2026-05\", \"2026-06\", \"2026-07\", \"2026-08\"];\nconst FIN: Record = {\n \"2026-03\": \"2026-03-31\", \"2026-04\": \"2026-04-30\", \"2026-05\": \"2026-05-31\",\n \"2026-06\": \"2026-06-30\", \"2026-07\": \"2026-07-31\", \"2026-08\": \"2026-08-28\",\n};\n\nexport default async function (req: Request): Promise {\n const u = new URL(req.url);\n const mes = u.searchParams.get(\"mes\");\n\n if (u.searchParams.get(\"reporte\")) {\n const acc: Record> = {};\n const tot: Record = {};\n for (const m of MESES) {\n let d: any = null;\n try { d = await blob.getJSON(\"el_\" + m); } catch { }\n if (!d) continue;\n tot[m] = d.total;\n for (const [n, v] of Object.entries(d.cli as Record)) {\n acc[n] ??= {};\n acc[n][m] = v;\n }\n }\n const EXCL = [\"LADYS LAVANDERIA\", \"LUIS LUFI\", \"LADYS \"];\n const filas: string[] = [\"cliente|\" + MESES.join(\"|\") + \"|total|prom|pico|mes_pico|meses\"];\n for (const [n, mm] of Object.entries(acc)) {\n if (EXCL.some(e => n.startsWith(e))) continue;\n const vals = MESES.map(m => mm[m] ?? 0);\n const total = vals.reduce((a, b) => a + b, 0);\n if (total < 150000) continue;\n const activos = vals.filter(v => v > 0).length;\n const pico = Math.max(...vals);\n const mp = MESES[vals.indexOf(pico)];\n filas.push([n, ...vals, total, Math.round(total / (activos || 1)), pico, mp, activos].join(\"|\"));\n }\n return new Response(JSON.stringify({ totales: tot, n: filas.length - 1, csv: filas.join(\"\\n\") }),\n { headers: { \"Content-Type\": \"application/json\" } });\n }\n\n if (!mes || !FIN[mes]) return new Response(\"usa ?mes=2026-03 o ?reporte=1\", { status: 400 });\n\n const r0 = await fetch(BASE + \"/\", { headers: { \"User-Agent\": UA } });\n await r0.text();\n let cookie = ck(r0);\n const lg = await ws(\"/WebServices.aspx/iniciarSesion\", { usr: EMAIL, pass: PASS }, cookie);\n cookie = lg.cookie;\n if (lg.text.includes('\"d\":\"0\"')) return new Response(\"login fail\", { status: 401 });\n const sl = await ws(\"/WebServices.aspx/SET_ID_LOCAL_GLOBAL\", { ID_LOCAL: LOCAL }, cookie);\n cookie = sl.cookie;\n\n const r = await ws(\"/ws.aspx/OT_RETIRADAS_X_LOCAL_Traer_Periodo\",\n { FECHA_INICIO: mes + \"-01\", FECHA_TERMINO: FIN[mes] }, cookie);\n let arr: any[] = [];\n try { const j = JSON.parse(r.text); arr = j.d === \"\" ? [] : JSON.parse(j.d); }\n catch { return new Response(\"parse err \" + r.text.slice(0, 200), { status: 500 }); }\n\n const cli: Record = {};\n let total = 0;\n for (const o of arr) {\n const nom = String(o.nombre ?? \"\").trim().toUpperCase().replace(/\\s+/g, \" \");\n if (!nom) continue;\n const raw = String(o.monto_total ?? \"\").replace(/<[^>]*>/g, \"\");\n const n = parseInt(raw.replace(/[^\\d]/g, \"\"), 10);\n const monto = isNaN(n) ? 0 : n;\n total += monto;\n cli[nom] = (cli[nom] ?? 0) + monto;\n }\n await blob.setJSON(\"el_\" + mes, { mes, ots: arr.length, total, cli });\n return new Response(JSON.stringify({ mes, ots: arr.length, total, clientes: Object.keys(cli).length }),\n { headers: { \"Content-Type\": \"application/json\" } });\n}\n",[174],"11a4d347-5708-4098-8da7-22f52063d7bc","el_fichas.ts","c5fa8d26-a331-11f1-9171-1607ee4eb77e",15,["D",1787959538247],"const BASE = \"https://admin.easylaundry.cl\";\nconst EMAIL = \"xlufix@gmail.com\";\nconst PASS = \"Julieta7533#\";\nconst LOCAL = \"251\";\nconst UA = \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) Chrome/124 Safari/537.36\";\n\nconst OBJETIVO = [\n \"CATA DANIELS\", \"INTI\", \"CHRISTIAN LENIZ\", \"PAULA CEA\", \"CECILIA VEGA\",\n \"ANDREA ILABACA\", \"JAQUELINE ZAVALA\", \"MARIA PIA OLIVA\",\n];\n\nfunction ck(res: Response, prev = \"\"): string {\n const m = new Map();\n for (const c of prev.split(\"; \").filter(Boolean)) {\n const i = c.indexOf(\"=\"); m.set(c.slice(0, i), c.slice(i + 1));\n }\n for (const raw of res.headers.getSetCookie?.() ?? []) {\n const f = raw.split(\";\")[0]; const i = f.indexOf(\"=\");\n if (i > 0) m.set(f.slice(0, i).trim(), f.slice(i + 1));\n }\n return [...m].map(([k, v]) => `${k}=${v}`).join(\"; \");\n}\n\nasync function ws(path: string, body: any, cookie: string) {\n const r = await fetch(BASE + path, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json; charset=utf-8\",\n \"Cookie\": cookie, \"User-Agent\": UA, \"X-Requested-With\": \"XMLHttpRequest\",\n },\n body: JSON.stringify(body),\n });\n return { status: r.status, text: await r.text(), cookie: ck(r, cookie) };\n}\n\nfunction tel(html: string): string[] {\n const vals = new Set();\n for (const m of html.matchAll(/id=\"([^\"]*(?:elefono|Fono|Celular|movil|Movil)[^\"]*)\"[^>]*value=\"([^\"]*)\"/gi)) {\n const v = m[2].trim();\n if (v && /\\d{6,}/.test(v)) vals.add(v);\n }\n for (const m of html.matchAll(/value=\"(\\+?56\\s?9[\\d\\s\\-]{7,})\"/g)) vals.add(m[1].trim());\n return [...vals];\n}\n\nfunction email(html: string): string[] {\n const s = new Set();\n for (const m of html.matchAll(/value=\"([^\"@]+@[^\"]+\\.[a-z]{2,})\"/gi)) s.add(m[1].trim());\n return [...s];\n}\n\nexport default async function (req: Request): Promise {\n const desde = new URL(req.url).searchParams.get(\"desde\") ?? \"2026-06-01\";\n const hasta = new URL(req.url).searchParams.get(\"hasta\") ?? \"2026-08-28\";\n\n const r0 = await fetch(BASE + \"/\", { headers: { \"User-Agent\": UA } });\n await r0.text();\n let cookie = ck(r0);\n const lg = await ws(\"/WebServices.aspx/iniciarSesion\", { usr: EMAIL, pass: PASS }, cookie);\n cookie = lg.cookie;\n const sl = await ws(\"/WebServices.aspx/SET_ID_LOCAL_GLOBAL\", { ID_LOCAL: LOCAL }, cookie);\n cookie = sl.cookie;\n\n const r = await ws(\"/ws.aspx/OT_RETIRADAS_X_LOCAL_Traer_Periodo\",\n { FECHA_INICIO: desde, FECHA_TERMINO: hasta }, cookie);\n let arr: any[] = [];\n try { const j = JSON.parse(r.text); arr = j.d === \"\" ? [] : JSON.parse(j.d); }\n catch { return new Response(\"parse err\", { status: 500 }); }\n\n const porCliente = new Map();\n for (const o of arr) {\n const nom = String(o.nombre ?? \"\").trim().toUpperCase().replace(/\\s+/g, \" \");\n const lk = String(o.link_cliente ?? \"\");\n if (!nom || !lk) continue;\n if (!OBJETIVO.some((t) => nom.includes(t))) continue;\n if (!porCliente.has(nom)) porCliente.set(nom, lk);\n }\n\n const out: any[] = [];\n for (const [nom, lk] of porCliente) {\n try {\n const pg = await fetch(BASE + lk, {\n headers: { \"Cookie\": cookie, \"User-Agent\": UA },\n });\n const html = await pg.text();\n out.push({ cliente: nom, tels: tel(html), emails: email(html) });\n } catch (e) {\n out.push({ cliente: nom, error: String(e).slice(0, 80) });\n }\n }\n return new Response(JSON.stringify({ n: out.length, datos: out }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n}\n",[181],"c2d2cf2b-07b1-4fd2-9b80-13b818f72aff","el_detalle.ts","08096806-a33a-11f1-9812-1607ee4eb77e",20,["D",1787960662067],4,"const BASE = \"https://admin.easylaundry.cl\";\nconst EMAIL = \"xlufix@gmail.com\";\nconst PASS = \"Julieta7533#\";\nconst LOCAL = \"251\";\nconst UA = \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) Chrome/124 Safari/537.36\";\n\nconst OBJETIVO = [\n \"FERNANDO BERNDT\", \"PABLO PRADINES\", \"MIGUEL ZARATE\", \"MANCILLA ALVEAR\",\n \"JOANNA CELLA\", \"MANUEL SILVA\", \"CATA DANIELS\", \"CHRISTIAN LENIZ\",\n \"JAQUELINE ZAVALA\", \"MARIA PIA OLIVA\", \"SERGIO MANRIQUEZ\",\n];\n\nfunction ck(res: Response, prev = \"\"): string {\n const m = new Map();\n for (const c of prev.split(\"; \").filter(Boolean)) {\n const i = c.indexOf(\"=\"); m.set(c.slice(0, i), c.slice(i + 1));\n }\n for (const raw of res.headers.getSetCookie?.() ?? []) {\n const f = raw.split(\";\")[0]; const i = f.indexOf(\"=\");\n if (i > 0) m.set(f.slice(0, i).trim(), f.slice(i + 1));\n }\n return [...m].map(([k, v]) => `${k}=${v}`).join(\"; \");\n}\n\nasync function ws(path: string, body: any, cookie: string) {\n const r = await fetch(BASE + path, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json; charset=utf-8\",\n \"Cookie\": cookie, \"User-Agent\": UA, \"X-Requested-With\": \"XMLHttpRequest\",\n },\n body: JSON.stringify(body),\n });\n return { status: r.status, text: await r.text(), cookie: ck(r, cookie) };\n}\n\nfunction campo(html: string, id: string): string {\n const re = new RegExp(`id=\"${id}\"[^>]*value=\"([^\"]*)\"`, \"i\");\n const m = html.match(re);\n if (m) return m[1];\n const re2 = new RegExp(`id=\"${id}\"[^>]*>([^<]*)<`, \"i\");\n const m2 = html.match(re2);\n return m2 ? m2[1].trim() : \"\";\n}\n\nfunction itemsDeTabla(h: string): string[] {\n const out: string[] = [];\n for (const tr of h.matchAll(//gi)) {\n const tds = [...tr[0].matchAll(/]*>([\\s\\S]*?)<\\/td>/gi)]\n .map((m) => m[1].replace(/<[^>]*>/g, \" \").replace(/ /g, \" \")\n .replace(/\\s+/g, \" \").trim())\n .filter((x) => x.length);\n if (tds.length >= 2) out.push(tds.slice(0, 4).join(\" | \"));\n }\n return out;\n}\n\nexport default async function (req: Request): Promise {\n const u = new URL(req.url);\n const desde = u.searchParams.get(\"desde\") ?? \"2026-08-01\";\n const hasta = u.searchParams.get(\"hasta\") ?? \"2026-08-28\";\n const max = Number(u.searchParams.get(\"max\") ?? 5);\n const skip = Number(u.searchParams.get(\"skip\") ?? 0);\n\n const r0 = await fetch(BASE + \"/\", { headers: { \"User-Agent\": UA } });\n await r0.text();\n let cookie = ck(r0);\n const lg = await ws(\"/WebServices.aspx/iniciarSesion\", { usr: EMAIL, pass: PASS }, cookie);\n cookie = lg.cookie;\n const sl = await ws(\"/WebServices.aspx/SET_ID_LOCAL_GLOBAL\", { ID_LOCAL: LOCAL }, cookie);\n cookie = sl.cookie;\n\n const r = await ws(\"/ws.aspx/OT_RETIRADAS_X_LOCAL_Traer_Periodo\",\n { FECHA_INICIO: desde, FECHA_TERMINO: hasta }, cookie);\n const arr = JSON.parse(JSON.parse(r.text).d);\n\n const sel = arr.filter((o: any) => {\n const n = String(o.nombre ?? \"\").toUpperCase();\n return OBJETIVO.some((t) => n.includes(t));\n }).slice(skip, skip + max);\n\n const out: any[] = [];\n for (const o of sel) {\n try {\n const pg = await fetch(`${BASE}/Pedido?x=${o.link_ot}`, {\n headers: { Cookie: cookie, \"User-Agent\": UA },\n });\n const html = await pg.text();\n const idOt = campo(html, \"ContentPlaceHolder1_lblId\");\n const idCli = campo(html, \"ContentPlaceHolder1_hfIDCliente\");\n\n const c = await ws(\"/WebServices.aspx/RetornaCarro\", {\n EDITABLE: \"0\",\n ID_USUARIO_ORDEN: idCli,\n SERVICIO_A_DOMICILIO: \"0\",\n OT: idOt,\n VALOR_DESPACHO: \"0\",\n TIPO_DESCUENTO: \"\",\n DESCUENTO_INGRESADO: \"\",\n }, cookie);\n\n let items: string[] = [];\n try {\n const d = JSON.parse(c.text).d ?? \"\";\n items = itemsDeTabla(String(d));\n } catch { }\n\n out.push({\n cliente: String(o.nombre).trim(),\n ot: o.ot,\n monto: String(o.monto_total ?? \"\").replace(/<[^>]*>/g, \"\").trim(),\n items: items.slice(0, 10),\n });\n } catch (e) {\n out.push({ cliente: o.nombre, ot: o.ot, error: String(e).slice(0, 70) });\n }\n }\n return new Response(JSON.stringify({ n: out.length, pedidos: out }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n}\n",[188],"ba14e7f9-17f1-4d9c-aceb-9d6ad3b4e1fe","cruce_ads.ts","513ad24e-a3cb-11f1-9788-1607ee4eb77e",22,["D",1788022957416],"import { blob } from \"https://esm.town/v/std/blob\";\n\nconst MESES = [\"2026-06\", \"2026-07\", \"2026-08\"];\n\nfunction norm(s: string): string {\n return String(s).toUpperCase()\n .normalize(\"NFD\").replace(/[\\u0300-\\u036f]/g, \"\")\n .replace(/[^A-Z\\s]/g, \" \").replace(/\\s+/g, \" \").trim();\n}\n\nexport default async function (req: Request): Promise {\n const leads: any[] = (await blob.getJSON(\"leads_ads\")) ?? [];\n if (!leads.length) return new Response(\"sin leads en blob\", { status: 400 });\n\n // ventas por cliente desde los blobs mensuales ya extraidos\n const ventas = new Map();\n for (const m of MESES) {\n let d: any = null;\n try { d = await blob.getJSON(\"el_\" + m); } catch { }\n if (!d?.cli) continue;\n for (const [n, v] of Object.entries(d.cli as Record)) {\n const k = norm(n);\n ventas.set(k, (ventas.get(k) ?? 0) + (v as number));\n }\n }\n\n const nombresVenta = [...ventas.keys()];\n const convertidos: any[] = [];\n\n for (const l of leads) {\n const ln = norm(l.nombre);\n if (!ln || ln.length < 5) continue;\n const partes = ln.split(\" \").filter(p => p.length > 2);\n if (partes.length < 2) continue;\n const hit = nombresVenta.find(nv => {\n const pv = nv.split(\" \").filter(p => p.length > 2);\n const comunes = partes.filter(p => pv.includes(p));\n return comunes.length >= 2;\n });\n if (hit) convertidos.push({ ...l, cliente_el: hit, facturado: ventas.get(hit)! });\n }\n\n const porAnuncio: Record = {};\n for (const l of leads) {\n const k = l.anuncio || \"(sin nombre)\";\n porAnuncio[k] ??= { leads: 0, convertidos: 0, facturado: 0 };\n porAnuncio[k].leads++;\n }\n for (const c of convertidos) {\n const k = c.anuncio || \"(sin nombre)\";\n porAnuncio[k].convertidos++;\n porAnuncio[k].facturado += c.facturado;\n }\n for (const k of Object.keys(porAnuncio)) {\n const a = porAnuncio[k];\n a.tasa = a.leads ? +(a.convertidos / a.leads * 100).toFixed(1) + \"%\" : \"0%\";\n a.ticket_prom = a.convertidos ? Math.round(a.facturado / a.convertidos) : 0;\n }\n\n return new Response(JSON.stringify({\n leads_de_anuncios: leads.length,\n clientes_en_easylaundry: ventas.size,\n convertidos: convertidos.length,\n tasa_global: +(convertidos.length / leads.length * 100).toFixed(1) + \"%\",\n facturacion_atribuida: convertidos.reduce((a, c) => a + c.facturado, 0),\n por_anuncio: porAnuncio,\n top: convertidos.sort((a, b) => b.facturado - a.facturado).slice(0, 12)\n .map(c => ({ nombre: c.nombre, tel: c.tel, anuncio: (c.anuncio || \"\").slice(0, 40),\n creado: c.creado, facturado: c.facturado })),\n }, null, 1), { headers: { \"Content-Type\": \"application/json\" } });\n}\n",[196],"c27a06b0-7194-41a9-bd00-647fafd1698a","bienvenida.ts",2,["D",1787417277854],"export default function(req: Request): Response {\n return new Response(HTML, { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } });\n}\nconst HTML = `\n\n\n\n\n¡Bienvenido al Club! — by Ladys\n\n\n

Diff · v24