¡Bienvenido al Club!

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_299":300,"_301":302},"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",34,"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","el_fichas.ts","latestPath","fileId","c5fa8d26-a331-11f1-9171-1607ee4eb77e","name","fileType","http","content","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 \"JOAQUIN MORALES\", \"CLAUDIO MORALES\", \"LORENA FONZO\", \"CECILIA MILLA\",\n \"PAULINA LETELIER\", \"PATRICIA PERALTA\", \"CECILIA VEGA\", \"BARBARA LOPEZ\",\n \"LORENA COSTAS\", \"LIZETH AGUAS\",\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","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 \"ESTEFANIA ANDRADE\",\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","createdAt",["D",1788383104842],"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":295,"_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":296,"_81":297,"_83":298,"_85":25},"tree",[242,243,244,245,246,247,248,249,250,251,252,253,254],"files",[242,243,244,245,246,247,248,249,250,251,252,253,254],"counts",{"_232":63,"_233":147,"_234":63,"_235":236,"_237":238},"contents",[127,128,129,130,131,132,133,134,135,136,137,138,139],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":227,"_32":228,"_30":57,"_143":-5,"_41":42,"_40":156,"_145":59,"_38":229,"_13":147,"_33":34,"_35":230,"_24":25,"_149":-5,"_27":231},{"_43":220,"_32":221,"_30":222,"_143":-5,"_41":42,"_40":223,"_145":59,"_38":224,"_13":63,"_33":34,"_35":225,"_24":25,"_149":-5,"_27":226},{"_43":213,"_32":214,"_30":215,"_143":-5,"_41":42,"_40":216,"_145":59,"_38":217,"_13":147,"_33":34,"_35":218,"_24":25,"_149":-5,"_27":219},{"_43":206,"_32":207,"_30":208,"_143":-5,"_41":42,"_40":209,"_145":25,"_38":210,"_13":185,"_33":34,"_35":211,"_24":25,"_149":-5,"_27":212},{"_43":202,"_32":28,"_30":31,"_143":-5,"_41":42,"_40":14,"_145":25,"_38":203,"_13":204,"_33":34,"_35":37,"_24":25,"_149":-5,"_27":205},{"_43":195,"_32":196,"_30":197,"_143":-5,"_41":42,"_40":198,"_145":25,"_38":199,"_13":63,"_33":34,"_35":200,"_24":25,"_149":-5,"_27":201},{"_43":188,"_32":189,"_30":190,"_143":-5,"_41":42,"_40":191,"_145":59,"_38":192,"_13":63,"_33":34,"_35":193,"_24":25,"_149":-5,"_27":194},{"_43":180,"_32":181,"_30":182,"_143":-5,"_41":42,"_40":183,"_145":59,"_38":184,"_13":185,"_33":34,"_35":186,"_24":25,"_149":-5,"_27":187},{"_43":173,"_32":174,"_30":175,"_143":-5,"_41":42,"_40":176,"_145":59,"_38":177,"_13":63,"_33":34,"_35":178,"_24":25,"_149":-5,"_27":179},{"_43":166,"_32":167,"_30":168,"_143":-5,"_41":42,"_40":169,"_145":59,"_38":170,"_13":63,"_33":34,"_35":171,"_24":25,"_149":-5,"_27":172},{"_43":159,"_32":160,"_30":161,"_143":-5,"_41":42,"_40":162,"_145":59,"_38":163,"_13":63,"_33":34,"_35":164,"_24":25,"_149":-5,"_27":165},{"_43":151,"_32":152,"_30":153,"_143":-5,"_41":42,"_40":154,"_145":59,"_38":155,"_13":156,"_33":34,"_35":157,"_24":25,"_149":-5,"_27":158},{"_43":140,"_32":141,"_30":142,"_143":-5,"_41":42,"_40":144,"_145":59,"_38":146,"_13":147,"_33":34,"_35":148,"_24":25,"_149":-5,"_27":150},"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",[141],"b9e1b63e-2d89-4844-9cf1-b577af60accb","restantes.ts","ed79803c-a57f-11f1-b44c-1607ee4eb77e",25,["D",1788210610253],2,"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\"];\n\nexport default async function (req: Request): Promise {\n const u = new URL(req.url);\n const desde = Number(u.searchParams.get(\"desde\") ?? 0);\n const hasta = Number(u.searchParams.get(\"hasta\") ?? 200);\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 act = v.filter((x) => x > 0).length;\n if (!act) continue;\n const tot = v.reduce((a, b) => a + b, 0);\n filas.push([n, v[0], v[1], v[2], tot, Math.round(tot / act), act]);\n }\n filas.sort((a, b) => a[5] - b[5]);\n\n const trozo = filas.slice(desde, hasta);\n const csv = trozo.map((f) => f.join(\"|\")).join(\"\\n\");\n\n return new Response(JSON.stringify({\n total_clientes: filas.length,\n mostrando: `${desde}-${Math.min(hasta, filas.length)}`,\n csv,\n }), { headers: { \"Content-Type\": \"application/json\" } });\n}\n",[152],"a18c0492-0cfe-43f5-b038-af3870f7bd26","publico_meta.ts","04a4bf3a-a66e-11f1-885f-1607ee4eb77e",33,["D",1788312687944],"import { blob } from \"https://esm.town/v/std/blob\";\nimport { DEFAULT_LOCATION_ID, getToken } from \"../ghl.ts\";\n\nconst BASE = \"https://services.leadconnectorhq.com\";\nconst MESES = [\"2026-06\", \"2026-07\", \"2026-08\"];\n\nfunction norm(s: string): string {\n return String(s).toUpperCase().normalize(\"NFD\").replace(/[\\u0300-\\u036f]/g, \"\")\n .replace(/[^A-Z\\s]/g, \" \").replace(/\\s+/g, \" \").trim();\n}\n\n/**\n * Publicos personalizados para Meta.\n * ?tipo=todos -> todos los contactos con telefono o correo\n * ?tipo=top -> solo clientes de alto valor (semilla para Lookalike)\n */\nexport default async function (req: Request): Promise {\n const tipo = new URL(req.url).searchParams.get(\"tipo\") ?? \"todos\";\n const min = Number(new URL(req.url).searchParams.get(\"min\") ?? 50000);\n\n // ── clientes de alto valor desde EasyLaundry (blobs ya extraidos)\n const gasto = new Map();\n if (tipo === \"top\") {\n const acum: Record = {};\n for (let i = 0; i < MESES.length; i++) {\n let d: any = null;\n try { d = await blob.getJSON(\"el_\" + MESES[i]); } catch {}\n if (!d?.cli) continue;\n for (const [n, v] of Object.entries(d.cli as Record)) {\n const k = norm(n);\n acum[k] ??= [0, 0, 0];\n acum[k][i] = v as number;\n }\n }\n for (const [k, v] of Object.entries(acum)) {\n const act = v.filter((x) => x > 0).length;\n if (!act) continue;\n const prom = v.reduce((a, b) => a + b, 0) / act;\n if (prom >= min) gasto.set(k, Math.round(prom));\n }\n }\n\n // ── contactos de GHL\n const tok = getToken(DEFAULT_LOCATION_ID);\n const H = { Authorization: `Bearer ${tok}`, Version: \"2021-07-28\", Accept: \"application/json\" };\n const filas: string[] = [];\n const vistos = new Set();\n let sid: string | null = null, sat: number | null = null;\n\n for (let p = 0; p < 14; p++) {\n let url = `${BASE}/contacts/?locationId=${DEFAULT_LOCATION_ID}&limit=100`;\n if (sid && sat) url += `&startAfterId=${sid}&startAfter=${sat}`;\n const r = await fetch(url, { headers: H });\n if (!r.ok) break;\n const cs = (await r.json()).contacts ?? [];\n if (!cs.length) break;\n\n for (const c of cs) {\n const tel = String(c.phone ?? \"\").replace(/[^\\d+]/g, \"\");\n const mailRaw = String(c.email ?? \"\").toLowerCase().trim();\n const mail = mailRaw.includes(\"@\") && !mailRaw.startsWith(\"sincorreo\") ? mailRaw : \"\";\n if (!tel && !mail) continue;\n const clave = tel || mail;\n if (vistos.has(clave)) continue;\n\n const nom = String(c.firstName ?? \"\").toLowerCase().trim();\n const ape = String(c.lastName ?? \"\").toLowerCase().trim();\n\n if (tipo === \"top\") {\n const completo = norm(`${c.firstName ?? \"\"} ${c.lastName ?? \"\"}`);\n const partes = completo.split(\" \").filter((x) => x.length > 2);\n if (partes.length < 2) continue;\n let hit = false;\n for (const k of gasto.keys()) {\n const pv = k.split(\" \").filter((x) => x.length > 2);\n if (partes.filter((x) => pv.includes(x)).length >= 2) { hit = true; break; }\n }\n if (!hit) continue;\n }\n\n vistos.add(clave);\n filas.push([tel, mail, nom, ape, \"concon\", \"valparaiso\", \"CL\"].join(\",\"));\n }\n const u = cs[cs.length - 1];\n sid = u.id; sat = new Date(u.dateAdded).getTime();\n }\n\n const csv = \"phone,email,fn,ln,ct,st,country\\n\" + filas.join(\"\\n\");\n return new Response(csv, {\n headers: {\n \"Content-Type\": \"text/csv; charset=utf-8\",\n \"Content-Disposition\": `attachment; filename=\"ladys-publico-${tipo}.csv\"`,\n \"X-Filas\": String(filas.length),\n },\n });\n}\n",[160],"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",[167],"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",[174],"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",[181],"96fe095e-fce5-4063-8e9e-6f5e4576fe64","el_pago.ts","7a56a9e8-a62b-11f1-8798-1607ee4eb77e",32,["D",1788284109125],"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\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}\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 { text: await r.text(), cookie: ck(r, cookie) };\n}\n\nexport default async function (req: Request): Promise {\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 // ultimas OTs para ubicar la de Alejandra\n const r = await ws(\"/ws.aspx/OT_RETIRADAS_X_LOCAL_Traer_Periodo\",\n { FECHA_INICIO: \"2026-08-28\", FECHA_TERMINO: \"2026-09-01\" }, cookie);\n let arr: any[] = [];\n try { const j = JSON.parse(r.text); arr = j.d === \"\" ? [] : JSON.parse(j.d); } catch {}\n\n const ale = arr.filter((o: any) =>\n String(o.nombre ?? \"\").toUpperCase().includes(\"ALEJANDRA MORA\"));\n\n // abrir la pagina de pedido para ver los campos de pago y descuento\n let campos: string[] = [];\n let opciones: any = {};\n if (ale.length) {\n const pg = await fetch(`${BASE}/Pedido?x=${ale[0].link_ot}`, {\n headers: { Cookie: cookie, \"User-Agent\": UA },\n });\n const html = await pg.text();\n // ids relacionados a pago y descuento\n for (const m of html.matchAll(/id=\"([^\"]*(?:[Pp]ago|PAGO|[Dd]escuento|DESCUENTO|[Aa]bono|[Tt]otal|Medio)[^\"]*)\"/g)) {\n if (!campos.includes(m[1])) campos.push(m[1]);\n }\n // selects con sus opciones\n for (const s of html.matchAll(/]*id=\"([^\"]+)\"[^>]*>([\\s\\S]*?)<\\/select>/g)) {\n const id = s[1];\n if (!/pago|Pago|descuento|Descuento|medio|Medio/i.test(id)) continue;\n opciones[id] = [...s[2].matchAll(/]*value=\"([^\"]*)\"[^>]*>([^<]*) `${o[1]}=${o[2].trim()}`);\n }\n }\n\n return new Response(JSON.stringify({\n ots_alejandra: ale.map((o: any) => ({\n ot: o.ot, fecha: o.fecha ?? o.fecha_ingreso,\n monto: String(o.monto_total ?? \"\").replace(/<[^>]*>/g, \"\").trim(),\n estado: String(o.estado ?? \"\").replace(/<[^>]*>/g, \"\").trim(),\n link: o.link_ot,\n })),\n campos_pago: campos.slice(0, 30),\n selects: opciones,\n }, null, 1), { headers: { \"Content-Type\": \"application/json\" } });\n}\n",[189],"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",[196],"20fb6340-01a6-4012-af3e-043b260fa70d",["D",1788383104842],6,[28],"3e74049f-bd16-41e0-b497-8dbbb066d2e5","el_detalle.ts","08096806-a33a-11f1-9812-1607ee4eb77e",29,["D",1788224023454],"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\",\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",[207],"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",[214],"46e725fb-1f3f-4f95-a201-4f5bcf4d0089","candidatos.ts","ea1b21ee-a5a1-11f1-9ff9-1607ee4eb77e",30,["D",1788225026091],"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\", \"PABLO CLIENTE\",\n \"JOVEN MOTO\"];\nconst B2B = [\"ULTRATUG\", \"AFIM\", \"MD CARS\", \"GLIEWE\", \"CARDINAL\", \"SPA\", \"E.I.R.L\", \"EIRL\",\n \"LTDA\", \"HOTEL\", \"COSMETICA\", \"FISIOMAS\", \"QUINTA COSTA\", \"GUDFUD\", \"TRIMAR\",\n \"RESTAURANTE\", \"BOUTIQUE\"];\n\n// ya contactados, socios, o descartados\nconst YA = [\n \"ALEJANDRA MORA\", \"JOANNA CELLA\", \"FERNANDO BERNDT\", \"SARA GALAZ\",\n \"CARLA VIVANCO\", \"MIREYA QUITRAL\", \"MIGUEL ZARATE\", \"MANCILLA ALVEAR\",\n \"MANUEL SILVA\", \"PABLO PRADINES\", \"CATA DANIELS\", \"SERGIO MANRIQUEZ\",\n \"PAOLA DUARTE\", \"DANIELA RIVAS\", \"ANDREA ILABACA\", \"MARIA PIA OLIVA\",\n \"CHRISTIAN LENIZ\", \"MARIO HERRERA\", \"SERGIO CANALES\", \"ANTONELLA\",\n \"ANDREA SANTANA\", \"SEBASTIAN ASTETE\", \"MANUELA HEWSTONE\", \"GONZALO CONTRERAS\",\n \"JAQUELINE ZAVALA\", \"INTI\",\n];\n\nexport default async function (req: Request): Promise {\n const min = Number(new URL(req.url).searchParams.get(\"min\") ?? 50000);\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 (B2B.some((b) => n.includes(b))) continue;\n if (YA.some((y) => n.includes(y))) continue;\n\n const v = MESES.map((m) => mm[m] ?? 0);\n const act = v.filter((x) => x > 0).length;\n if (!act) continue;\n if (v[2] === 0 && v[1] === 0) continue; // sin actividad reciente\n const tot = v.reduce((a, b) => a + b, 0);\n const prom = Math.round(tot / act);\n if (prom < min) continue;\n\n let plan = \"\";\n if (prom >= 170000) plan = \"TOTAL\";\n else if (prom >= 95000) plan = \"DOMICILIO\";\n else if (prom >= 75000) plan = \"HOGAR BASICO\";\n else plan = \"ESENCIAL\";\n\n // score: constancia + monto + tendencia\n const score = act * 20 + Math.min(prom / 2000, 50) + (v[2] >= v[0] ? 15 : 0);\n\n filas.push({ n, jun: v[0], jul: v[1], ago: v[2], tot, prom, act, plan, score: Math.round(score) });\n }\n\n filas.sort((a, b) => b.score - a.score);\n return new Response(JSON.stringify({\n total: filas.length,\n filas: filas.map((f) => `${f.n}|${f.jun}|${f.jul}|${f.ago}|${f.prom}|${f.act}|${f.plan}|${f.score}`),\n }), { headers: { \"Content-Type\": \"application/json\" } });\n}\n",[221],"c27a06b0-7194-41a9-bd00-647fafd1698a","bienvenida.ts",["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 · v34