[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_165":166,"_167":168},"routes/_app.x.$handle.$name",{"_95":94,"_32":45,"_103":85,"_27":35,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":25,"_117":118,"_119":120,"_121":-5,"_122":-5,"_123":124},"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":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":25},"version",5,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":36,"_34":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":20,"_34":35},"deleted",false,"deletedHere","path","fetchtest.ts","latestPath","fileId","254ea0fe-69a9-11f1-aa0a-1607ee4eb77e","name","fileType","content","","http","export default async function handler(req: Request): Promise {\n const url = new URL(req.url).searchParams.get('url');\n if (!url) return new Response('missing');\n const r = await fetch(url, {redirect:'follow'});\n const ab = await r.arrayBuffer();\n return Response.json({status:r.status, contentType:r.headers.get('content-type'), len:ab.byteLength, first:Array.from(new Uint8Array(ab.slice(0,16)))});\n}","createdAt",["D",1781631067002],"branchVersion","branchId","8d518513-718f-4e97-9bf5-1af3c982cee2","id","da10129f-9c11-4112-b4b2-0a26b41d8dc2","esfuerzo_comercial_excel_updater",["D",1781612571402],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Genera Excel actualizado con SheetJS para Revisiones renta COL","imageUrl","019c294d-f0eb-70cc-8df6-0cedd5a9f689","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019c294d-f0eb-70cc-8df6-10c4077f7c37","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":25},"branch",{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"isOwned",13,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Brunooo","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzM5RDhzc3E2Yk05T25GVEZOM2N6VzBEWHVCTiJ9","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":161,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":162,"_79":163,"_81":164,"_83":25},"tree",[152,153],"files",[152,153],"counts",{"_142":61,"_143":140,"_144":61,"_145":146,"_147":148},"contents",[125,126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":138,"_32":28,"_30":31,"_130":-5,"_41":42,"_40":14,"_132":25,"_38":139,"_13":140,"_33":36,"_34":37,"_24":25,"_136":-5,"_27":141},{"_43":127,"_32":128,"_30":129,"_130":-5,"_41":42,"_40":131,"_132":120,"_38":133,"_13":134,"_33":36,"_34":135,"_24":25,"_136":-5,"_27":137},"c55c1897-ef24-4da4-acf9-70a861ade4c3","main.ts","62102b78-697e-11f1-9082-1607ee4eb77e","parentId",3,"latest",["D",1781626453560],2,"import * as XLSX from \"https://cdn.sheetjs.com/xlsx-latest/package/xlsx.mjs\";\n\n// ─── DATOS DE LAS 3 FILAS NUEVAS (52 columnas, extraídas de Esf. Comercial (Offices) + PDFs) ───\n\nconst REGUS_ROW: (string | number | null)[] = [\n \"M\",\"Secondary\",\"MSecondary\",400091,\"MARTINEZ VILLERGAS, 49\",\"94019096\",\"REGUS ESP028\",\n \"Offices\",\"1\",\"Apr-26\",\"Apr-26\",\"Mar-30\",\"Mar-30\",4,1,4,1,2.0,36000,\"4%\",\"4%\",\n null,1125,17.8,19982,null,0.2,null,1125,0,0,0,0,16.0,18000,16.5,18563,15.8,17719,\n null,\"-9.9%\",\"-3.0%\",\"1.6%\",null,null,0.0,0.9,\"4%\",null,1125,16.0,18000\n];\n\nconst NEPTUNE_ROW: (string | number | null)[] = [\n \"M\",\"CBD\",\"MCBD\",400047,\"CASTELLANA, 52\",\"94020634\",\"NEPTUNE NORTH SPAIN\",\n \"Offices\",\"2\",\"May-26\",\"Mar-26\",\"Nov-29\",\"May-33\",4,1,7,3,4.0,141056,\"10%\",\"5%\",\n null,\"-\",\"-\",\"-\",null,0.4,null,928,0,0,0,0,38.0,35264,35.5,32944,35.5,32944,\n null,\"-\",\"7.0%\",\"7.0%\",null,null,0.1,1.5,\"10%\",null,null,null,null\n];\n\nconst NASH21_ROW: (string | number | null)[] = [\n \"M\",\"CBD\",\"MCBD\",400171,\"DON RAMÓN DE LA CRUZ, 84\",\"94020633\",\"NASH21 WORLDWIDE\",\n \"Offices\",\"Ground floor (mod. 2 & 3)\",\"Mar-26\",\"Mar-26\",\"Mar-29\",\"Mar-31\",3,1,5,1,0.0,0,\"0%\",\"0%\",\n null,477,27.5,13105,null,0.2,null,477,0,0,0,0,31.0,14772,27.0,12866,30.2,14373,\n null,\"12.7%\",\"14.8%\",\"2.8%\",null,null,0.0,0.5,\"0%\",null,477,31.0,14772\n];\n\n// ─── BUSCAR FILA POR NOMBRE DEL ARRENDATARIO ──────────────────────────────────\nfunction findRowByTenant(ws: any, search: string): number {\n const range = XLSX.utils.decode_range(ws['!ref'] || 'A1:A1');\n for (let r = range.s.r; r <= range.e.r; r++) {\n for (const col of [5, 6, 7, 8]) {\n const cell = ws[XLSX.utils.encode_cell({r, c: col})];\n if (cell && String(cell.v ?? '').toUpperCase().includes(search.toUpperCase())) {\n return r;\n }\n }\n }\n return -1;\n}\n\n// ─── INSERTAR FILA NUEVA DESPUÉS DE UNA FILA EXISTENTE ────────────────────────\nfunction insertRowAfter(ws: any, afterRow: number, rowData: (string | number | null)[]): void {\n const range = XLSX.utils.decode_range(ws['!ref'] || 'A1:A1');\n const insertAt = afterRow + 1;\n\n // 1. Desplazar todas las filas desde insertAt hacia abajo\n for (let r = range.e.r; r >= insertAt; r--) {\n for (let c = range.s.c; c <= range.e.c; c++) {\n const src = XLSX.utils.encode_cell({r, c});\n const dst = XLSX.utils.encode_cell({r: r + 1, c});\n if (ws[src]) {\n ws[dst] = {...ws[src]};\n } else {\n delete ws[dst];\n }\n }\n }\n\n // 2. Limpiar la fila en la posición de inserción\n for (let c = range.s.c; c <= range.e.c; c++) {\n delete ws[XLSX.utils.encode_cell({r: insertAt, c})];\n }\n\n // 3. Ajustar alturas de fila (!rows)\n if (ws['!rows'] && Array.isArray(ws['!rows'])) {\n const tplRowProp = ws['!rows'][afterRow] ? {...ws['!rows'][afterRow]} : {};\n ws['!rows'].splice(insertAt, 0, tplRowProp);\n }\n\n // 4. Ajustar celdas combinadas (!merges)\n if (ws['!merges'] && Array.isArray(ws['!merges'])) {\n ws['!merges'] = ws['!merges'].map((m: any) => {\n if (m.s.r >= insertAt) return {s: {r: m.s.r + 1, c: m.s.c}, e: {r: m.e.r + 1, c: m.e.c}};\n if (m.e.r >= insertAt) return {s: m.s, e: {r: m.e.r + 1, c: m.e.c}};\n return m;\n });\n }\n\n // 5. Escribir datos de la fila nueva, copiando el estilo de la fila de plantilla\n rowData.forEach((val, c) => {\n if (val === null || val === undefined) return;\n const addr = XLSX.utils.encode_cell({r: insertAt, c});\n const tplAddr = XLSX.utils.encode_cell({r: afterRow, c});\n const tplCell = ws[tplAddr];\n\n const cell: any = {v: val, w: String(val), t: typeof val === 'number' ? 'n' : 's'};\n if (tplCell?.s) cell.s = {...tplCell.s};\n ws[addr] = cell;\n });\n\n // 6. Actualizar rango de la hoja\n range.e.r += 1;\n ws['!ref'] = XLSX.utils.encode_range(range);\n}\n\n// ─── HANDLER PRINCIPAL ────────────────────────────────────────────────────────\nexport default async function handler(req: Request): Promise {\n\n // ── GET: Formulario de subida ─────────────────────────────────────────────\n if (req.method === 'GET') {\n const html = `\n\n\n \n Actualizar Excel – Revisiones Renta COL 0326\n \n\n\n

📊 Actualizar Excel — Revisiones Renta COL 0326

Sube el Excel original. El procesador añade las 3 filas en la hoja \"Esf. Comercial\" preservando todo el formato, fórmulas y estilos del archivo original.

\n\n

RENEWALREGUS ESP028, S.L. — Martínez Villergas, 49 · UE 225079 · 1.125 m² · 16 €/m²/mes · Apr-26 → Mar-30

NEW LETTINGNEPTUNE NORTH SPAIN S.L.U. — Castellana, 52 · UE 225041 · 928 m² · 38 €/m²/mes · May-26 → May-33

RE-LETNASH21 WORLDWIDE, S.L. — Don Ramón de la Cruz, 84 · UE 225142 · 477 m² · 31 €/m²/mes · Mar-26 → Mar-31

\n\n

⚠️ Nota: En \"Esf. Comercial (Offices)\" y \"Mov 2026\" estos contratos ya existen y son correctos. Solo se modificará la hoja \"Esf. Comercial\".

\n\n \n

\n\n`;\n return new Response(html, {headers: {'Content-Type': 'text/html; charset=utf-8'}});\n }\n\n // ── POST: Procesar Excel ──────────────────────────────────────────────────\n if (req.method === 'POST') {\n try {\n const fd = await req.formData();\n const file = fd.get('excel') as File;\n if (!file) return new Response('No se proporcionó archivo.', {status: 400});\n\n const buf = await file.arrayBuffer();\n const wb = XLSX.read(new Uint8Array(buf), {\n type: 'array',\n cellStyles: true,\n cellNF: true,\n cellFormula: true,\n cellDates: true,\n sheetStubs: true\n });\n\n const SHEET = 'Esf. Comercial';\n if (!wb.SheetNames.includes(SHEET)) {\n return new Response(`Error: hoja \"${SHEET}\" no encontrada. Hojas disponibles: ${wb.SheetNames.join(', ')}`, {status: 400});\n }\n\n const ws = wb.Sheets[SHEET];\n const log: string[] = [];\n\n // Buscar filas de referencia (de abajo a arriba para insertar en orden)\n const autoregRow = findRowByTenant(ws, 'AUTOREGULACI'); // RE-LET → NASH21 después\n const sorecoRow = findRowByTenant(ws, 'SORECO'); // NEW LETTING → NEPTUNE después\n const salvatRow = findRowByTenant(ws, 'SALVAT'); // RENEWAL → REGUS después\n\n // Insertar de abajo hacia arriba para no desplazar las filas siguientes\n if (autoregRow > 0) {\n insertRowAfter(ws, autoregRow, NASH21_ROW);\n log.push(`✅ NASH21 insertado (fila ${autoregRow + 2}, RE-LET SURFACES)`);\n } else {\n log.push('⚠️ ASOC. AUTOREGULACIÓN no encontrada → NASH21 no insertado');\n }\n\n if (sorecoRow > 0) {\n insertRowAfter(ws, sorecoRow, NEPTUNE_ROW);\n log.push(`✅ NEPTUNE NORTH SPAIN insertado (fila ${sorecoRow + 2}, NEW LETTINGS)`);\n } else {\n log.push('⚠️ SORECO AUDIT no encontrado → NEPTUNE no insertado');\n }\n\n if (salvatRow > 0) {\n insertRowAfter(ws, salvatRow, REGUS_ROW);\n log.push(`✅ REGUS ESP028 insertado (fila ${salvatRow + 2}, RENEWALS)`);\n } else {\n log.push('⚠️ EDITORIAL SALVAT no encontrado → REGUS no insertado');\n }\n\n const outBuf = XLSX.write(wb, {type: 'array', bookType: 'xlsx', cellStyles: true});\n const outName = file.name.replace(/\\.(xlsx|xls)$/i, '_ACTUALIZADO.xlsx');\n\n return new Response(outBuf, {\n status: 200,\n headers: {\n 'Content-Type': 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',\n 'Content-Disposition': `attachment; filename=\"${outName}\"`,\n 'X-Log': log.join(' | '),\n 'Access-Control-Allow-Origin': '*'\n }\n });\n\n } catch (e: any) {\n return new Response(`Error: ${e.message}\\n${e.stack}`, {status: 500});\n }\n }\n\n return new Response('Method not allowed', {status: 405});\n}\n","label",[128],"7d2980df-6f59-4f9b-a666-e6e2f9c9bacd",["D",1781631067002],1,[28],"pulls","branches","forks","envVars",{"_149":61,"_151":61},"connections",{"_149":61,"_150":61},"count","unfilledCount","emptyCount",{"_43":138,"_32":28,"_30":31,"_130":-5,"_41":42,"_40":14,"_132":25,"_38":158,"_13":140,"_33":36,"_34":37,"_24":25,"_136":-5,"_155":159,"_27":160},{"_43":127,"_32":128,"_30":129,"_130":-5,"_41":42,"_40":131,"_132":120,"_38":154,"_13":134,"_33":36,"_34":135,"_24":25,"_136":-5,"_155":156,"_27":157},["D",1781626453560],"children",[],[128],["D",1781631067002],[],[28],["D",1781612571402],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":25},{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"ctx",{"_77":-5,"_122":198,"_199":200,"_201":202,"_203":25,"_204":25,"_205":25,"_206":120,"_207":-5,"_208":-7,"_209":-7,"_210":61,"_211":25,"_212":25,"_213":-5,"_214":25,"_215":25,"_216":25,"_217":-5},"ENV",{"_169":170,"_171":172,"_173":85,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197},"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"]

Diff · v5