[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_189":190,"_191":192},"routes/_app.x.$handle.$name",{"_94":93,"_32":45,"_102":84,"_27":35,"_13":14,"_103":-5,"_11":104,"_105":106,"_107":108,"_109":110,"_111":112,"_20":-5,"_113":-5,"_114":-5,"_115":25,"_116":117,"_118":119,"_120":-5,"_121":-5,"_122":123},"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",13,"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","generate_template_3sheets.ts","latestPath","fileId","72072dc2-6a16-11f1-be8c-1607ee4eb77e","name","fileType","content","","http","import ExcelJS from \"npm:exceljs\";\n\nconst filename = \"Plantilla Revisiones renta COL 0326 - 3 hojas.xlsx\";\n\nconst movHeaders = [\n \"Movimiento\", \"Nº U.E.\", \"Cebe\", \"Inmueble\", \"Fecha Inicio\", \"Fecha Firma\", \"Contrato actual\",\n \"Arrendatario actual\", \"Superficie SR\", \"Renta año 1\", \"Renta año 2\", \"Renta año 3\", \"Renta año 4\",\n \"Renta año 5\", \"Renta año 6\", \"Renta año 7\", \"Renta año 8\", \"Renta año 9\", \"Renta año 10\",\n \"€/m²/mes actual\", \"Carencia (meses)\", \"BO\", \"Fin\", \"Uso\", \"Planta\", \"Superficie SR anterior\",\n \"€/m²/mes anterior\", \"Contrato anterior\", \"Previous Tenant\", \"Expiry Date\", \"Months\", \"Observaciones\", \"PDF origen\", \"REVISAR\"\n];\n\nconst esfHeaders = [\n \"Segment\", \"Location\", \"Submarket\", \"Cebe\", \"Asset\", \"Contract\", \"Tenant\", \"Use\", \"Floor\",\n \"Initial Date\", \"Signat. Date\", \"BO Date\", \"Expiry Date\", \"BO months\", \"Expiry years\", \"Void months\",\n \"Void mensual\", \"Void anualizado\", \"% s/ BO\", \"% s/ Expiry\", \"Previous sq m\", \"Previous Rent €/m²/month\",\n \"Previous Annual Rent\", \"Signed sq m\", \"Signed Rent Year 1\", \"Signed Rent Year 2\", \"Signed Rent Year 3\",\n \"Signed Rent Year 4\", \"Signed Rent €/m²/month\", \"Signed Rent mensual\", \"Signed Annual Rent\", \"Budget 2026 €/m²\",\n \"Board 2026 €/m²\", \"ERV 12/25 €/m²\", \"Renta Signed vs prev.\", \"Renta Signed vs Budget\", \"Renta Signed vs ERV 12/25\",\n \"Carencia €m\", \"Ingreso hasta BO\", \"Carencia / Ingreso\", \"Current sq m\", \"Current Rent 2026\", \"Nº U.E.\",\n \"Tipo operación\", \"PDF origen\", \"Observaciones / REVISAR\"\n];\n\nconst blocks = [\n {name: \"RENEWALS\", fill: \"FF70AD47\", rows: 12},\n {name: \"NEW LETTINGS\", fill: \"FFFFC000\", rows: 12},\n {name: \"RE-LET SURFACES\", fill: \"FF9E7CC1\", rows: 12}\n];\n\nfunction setColWidths(ws: ExcelJS.Worksheet, widths: number[]) {\n widths.forEach((w, i) => ws.getColumn(i + 1).width = w);\n}\n\nfunction border(cell: ExcelJS.Cell) {\n cell.border = {\n top: { style: \"thin\", color: { argb: \"FFD9D9D9\" } },\n left: { style: \"thin\", color: { argb: \"FFD9D9D9\" } },\n bottom: { style: \"thin\", color: { argb: \"FFD9D9D9\" } },\n right: { style: \"thin\", color: { argb: \"FFD9D9D9\" } }\n };\n}\n\nfunction formatHeader(row: ExcelJS.Row, color = \"FF1F4E78\") {\n row.height = 34;\n row.eachCell((cell) => {\n cell.font = { bold: true, color: { argb: \"FFFFFFFF\" }, size: 9 };\n cell.fill = { type: \"pattern\", pattern: \"solid\", fgColor: { argb: color } };\n cell.alignment = { vertical: \"middle\", horizontal: \"center\", wrapText: true };\n border(cell);\n });\n}\n\nfunction formatInputRow(row: ExcelJS.Row) {\n row.height = 21;\n row.eachCell({ includeEmpty: true }, (cell) => {\n cell.alignment = { vertical: \"middle\", wrapText: true };\n border(cell);\n cell.font = { size: 9 };\n });\n}\n\nfunction title(ws: ExcelJS.Worksheet, text: string, month = \"03.26\") {\n ws.mergeCells(\"A1:H1\");\n ws.getCell(\"A1\").value = text;\n ws.getCell(\"A1\").font = { bold: true, size: 16, color: { argb: \"FFFFFFFF\" } };\n ws.getCell(\"A1\").fill = { type: \"pattern\", pattern: \"solid\", fgColor: { argb: \"FF17365D\" } };\n ws.getCell(\"A1\").alignment = { vertical: \"middle\" };\n ws.getCell(\"I1\").value = month;\n ws.getCell(\"I1\").font = { bold: true, size: 14, color: { argb: \"FF17365D\" } };\n ws.getRow(1).height = 26;\n}\n\nfunction addMov(wb: ExcelJS.Workbook) {\n const ws = wb.addWorksheet(\"Mov 2026\", { views: [{ state: \"frozen\", ySplit: 7 }] });\n title(ws, \"Mov 2026\");\n ws.getCell(\"A3\").value = \"Leyenda movimiento\";\n ws.getCell(\"A3\").font = { bold: true };\n ws.getCell(\"A4\").value = \"RL\"; ws.getCell(\"B4\").value = \"Re-Lettings\";\n ws.getCell(\"A5\").value = \"A\"; ws.getCell(\"B5\").value = \"Altas\";\n ws.getCell(\"A6\").value = \"R\"; ws.getCell(\"B6\").value = \"Renovaciones\";\n [\"A4\", \"A5\", \"A6\"].forEach(a => { ws.getCell(a).font = { bold: true }; ws.getCell(a).fill = { type: \"pattern\", pattern: \"solid\", fgColor: { argb: \"FFD9EAD3\" } }; });\n const header = ws.getRow(8);\n movHeaders.forEach((h, i) => header.getCell(i + 1).value = h);\n formatHeader(header, \"FF1F4E78\");\n for (let r = 9; r <= 108; r++) {\n const row = ws.getRow(r);\n for (let c = 1; c <= movHeaders.length; c++) row.getCell(c).value = null;\n formatInputRow(row);\n }\n ws.autoFilter = { from: { row: 8, column: 1 }, to: { row: 8, column: movHeaders.length } };\n ws.getColumn(1).dataValidation = { type: \"list\", allowBlank: true, formulae: ['\"RL,A,R\"'] } as any;\n ws.getColumn(24).dataValidation = { type: \"list\", allowBlank: true, formulae: ['\"Offices,Retail,Parking,Storage,Viviendas,Other\"'] } as any;\n [5, 6, 22, 23, 30].forEach(c => ws.getColumn(c).numFmt = \"dd/mm/yyyy\");\n [9,10,11,12,13,14,15,16,17,18,19,20,21,26,27,31].forEach(c => ws.getColumn(c).numFmt = \"#,##0.00\");\n setColWidths(ws, [12,12,10,28,13,13,16,32,14,14,14,14,14,14,14,14,14,14,14,14,14,13,13,14,18,16,16,16,28,13,10,42,22,22]);\n ws.getRow(8).commit();\n return ws;\n}\n\nfunction addEsf(wb: ExcelJS.Workbook, name: string, officesOnly = false) {\n const ws = wb.addWorksheet(name, { views: [{ state: \"frozen\", ySplit: 6 }] });\n title(ws, \"COMMERCIAL EFFORT (sq m)\");\n ws.getCell(\"A3\").value = officesOnly ? \"Vista específica de oficinas. Mantener solo Use = Offices.\" : \"Plantilla con bloques RENEWALS / NEW LETTINGS / RE-LET SURFACES.\";\n ws.getCell(\"A3\").font = { italic: true, color: { argb: \"FF666666\" } };\n const headerRow = ws.getRow(6);\n esfHeaders.forEach((h, i) => headerRow.getCell(i + 1).value = h);\n formatHeader(headerRow, \"FF4472C4\");\n let rowNum = 7;\n for (const block of blocks) {\n const br = ws.getRow(rowNum++);\n br.getCell(1).value = block.name;\n ws.mergeCells(br.number, 1, br.number, esfHeaders.length);\n br.height = 22;\n br.getCell(1).font = { bold: true, color: { argb: \"FFFFFFFF\" }, size: 11 };\n br.getCell(1).fill = { type: \"pattern\", pattern: \"solid\", fgColor: { argb: block.fill } };\n br.getCell(1).alignment = { vertical: \"middle\" };\n for (let i = 0; i < block.rows; i++) {\n const r = ws.getRow(rowNum++);\n for (let c = 1; c <= esfHeaders.length; c++) r.getCell(c).value = null;\n // fórmulas suaves: no dependen de hojas auxiliares\n r.getCell(15).value = { formula: `IF(AND(M${r.number}<>\"\",J${r.number}<>\"\"),(M${r.number}-J${r.number})/365,\"\")` } as any; // expiry years aprox si hay fechas reales\n r.getCell(31).value = { formula: `IF(AND(X${r.number}<>\"\",AC${r.number}<>\"\"),X${r.number}*AC${r.number}*12,IF(AD${r.number}<>\"\",AD${r.number}*12,\"\"))` } as any;\n formatInputRow(r);\n }\n const tr = ws.getRow(rowNum++);\n tr.getCell(1).value = `TOTAL ${block.name}`;\n ws.mergeCells(tr.number, 1, tr.number, 23);\n tr.getCell(24).value = { formula: `SUM(X${tr.number - block.rows}:X${tr.number - 1})` } as any;\n tr.getCell(30).value = { formula: `SUM(AD${tr.number - block.rows}:AD${tr.number - 1})` } as any;\n tr.getCell(31).value = { formula: `SUM(AE${tr.number - block.rows}:AE${tr.number - 1})` } as any;\n tr.eachCell({ includeEmpty: true }, (cell) => {\n cell.font = { bold: true, size: 9 };\n cell.fill = { type: \"pattern\", pattern: \"solid\", fgColor: { argb: \"FFD9EAD3\" } };\n border(cell);\n });\n rowNum++;\n }\n ws.autoFilter = { from: { row: 6, column: 1 }, to: { row: 6, column: esfHeaders.length } };\n ws.getColumn(8).dataValidation = { type: \"list\", allowBlank: true, formulae: ['\"Offices,Retail,Parking,Storage,Viviendas,Other\"'] } as any;\n ws.getColumn(44).dataValidation = { type: \"list\", allowBlank: true, formulae: ['\"Renewal,New Letting,Re-let Surface,Novación,Alta,Prórroga,REVISAR\"'] } as any;\n [10,11,12,13].forEach(c => ws.getColumn(c).numFmt = \"mmm-yy\");\n [14,15,16,17,18,21,22,23,24,25,26,27,28,29,30,31,32,33,34,38,39,40,41,42].forEach(c => ws.getColumn(c).numFmt = \"#,##0.00\");\n setColWidths(ws, [10,13,14,10,28,16,32,12,18,12,12,12,12,10,12,10,14,14,10,10,14,14,16,14,14,14,14,14,14,14,16,14,14,14,14,14,16,13,16,13,14,14,12,16,22,44]);\n return ws;\n}\n\nexport default async function handler(req: Request): Promise {\n const wb = new ExcelJS.Workbook();\n wb.creator = \"Colonial AI Lab\";\n wb.created = new Date();\n wb.modified = new Date();\n wb.properties.date1904 = false;\n\n addMov(wb);\n addEsf(wb, \"Esf. Comercial\", false);\n addEsf(wb, \"Esf. Comercial (Offices)\", true);\n\n const buf = await wb.xlsx.writeBuffer();\n return new Response(buf, {\n headers: {\n \"Content-Type\": \"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet\",\n \"Content-Disposition\": `attachment; filename=\"${filename}\"`,\n \"Cache-Control\": \"no-store\"\n }\n });\n}\n","createdAt",["D",1781678038152],"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",{"_94":93,"_101":97},"org",{"_94":93,"_95":-5,"_96":97,"_18":55,"_98":99,"_100":25},"branch",{"_13":14,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"isOwned","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":185,"_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":186,"_79":187,"_81":188,"_83":25},"tree",[168,169,170,171],"files",[168,169,170,171],"counts",{"_158":61,"_159":141,"_160":61,"_161":162,"_163":164},"contents",[124,125,126,127],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":150,"_32":151,"_30":152,"_131":-5,"_41":42,"_40":153,"_133":119,"_38":154,"_13":155,"_33":36,"_34":156,"_24":25,"_137":-5,"_27":157},{"_43":143,"_32":144,"_30":145,"_131":-5,"_41":42,"_40":146,"_133":119,"_38":147,"_13":141,"_33":36,"_34":148,"_24":25,"_137":-5,"_27":149},{"_43":139,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_133":119,"_38":140,"_13":141,"_33":36,"_34":37,"_24":25,"_137":-5,"_27":142},{"_43":128,"_32":129,"_30":130,"_131":-5,"_41":42,"_40":132,"_133":119,"_38":134,"_13":135,"_33":36,"_34":136,"_24":25,"_137":-5,"_27":138},"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",[129],"a1825591-8afe-42af-9b18-0b43d8c87380",["D",1781678038152],1,[28],"370681fa-21ad-4c18-bbde-7ceba56bfbeb","generate_reconstructed.ts","ac6a3b5a-69b0-11f1-a79d-1607ee4eb77e",11,["D",1781634339612],"import ExcelJS from \"npm:exceljs\";\n\nconst ops = [\n {\n block: \"RENEWALS\", tipo: \"Novación modificativa / prórroga\", pdf: \"0326 - Preparador Regus.pdf\",\n ue: \"225079\", contract: \"94019096\", tenant: \"REGUS ESP028, S.L.\", asset: \"MARTÍNEZ VILLERGAS, 49\", localidad: \"Madrid\",\n use: \"Offices\", floor: \"1\", superficie: 1125, rentUnit: 16.00, rentMonthly: 18000.00, annualRent: 216000.00,\n initial: \"01/04/2026\", economic: \"01/06/2026\", signat: \"12/03/2026\", boDate: \"31/03/2030\", expiry: \"31/03/2030\",\n boMonths: 48, voidMonths: 2, gastosUnit: 5.50, gastosMonthly: 6187.50, luzUnit: 1.90, luzMonthly: 2137.50,\n gastosTotal: 8325.00, fianza: 39965.14, aval: 0, parkingSpaces: \"\", parkingRent: \"\", refcat: \"4373101VK4747C0001EB\",\n review: \"REVISAR: comentarios de cesión societaria/desimplantación; mantener trazabilidad legal.\"\n },\n {\n block: \"NEW LETTINGS\", tipo: \"Alta de contrato\", pdf: \"0326 - Preparador Neptune.pdf\",\n ue: \"225041\", contract: \"\", tenant: \"NEPTUNE NORTH SPAIN S.L.U.\", asset: \"CASTELLANA, 52\", localidad: \"Madrid\",\n use: \"Offices\", floor: \"2\", superficie: 928, rentUnit: 38.00, rentMonthly: 35264.00, annualRent: 423168.00,\n initial: \"04/05/2026\", economic: \"04/09/2026\", signat: \"04/02/2026\", boDate: \"\", expiry: \"04/05/2033\",\n boMonths: 42, voidMonths: 4, gastosUnit: 7.90, gastosMonthly: 9001.60, luzUnit: 2.00, luzMonthly: 1856.00,\n gastosTotal: 10947.60, fianza: 71248.00, aval: 213744.00, parkingSpaces: 2, parkingRent: 360.00, refcat: \"1766807VK4716F0001JK\",\n review: \"REVISAR: contrato no informado; discrepancia gastos oficinas: 928 x 7,90 = 7.331,20 pero PDF muestra 9.001,60. Incluye 2 plazas parking a 180 €/plaza/mes y contribución obra 30.000 €.\"\n },\n {\n block: \"RE-LET SURFACES\", tipo: \"Alta de contrato\", pdf: \"0326 - Preparador Nash21.pdf\",\n ue: \"225142\", contract: \"\", tenant: \"NASH21 WORLDWIDE, S.L.\", asset: \"DON RAMÓN DE LA CRUZ, 84\", localidad: \"Madrid\",\n use: \"Offices\", floor: \"Ground floor (módulos 2 y 3)\", superficie: 476.52, rentUnit: 31.00, rentMonthly: 14772.12, annualRent: 177265.44,\n initial: \"23/03/2026\", economic: \"23/03/2026\", signat: \"24/02/2026\", boDate: \"23/03/2029\", expiry: \"23/03/2031\",\n boMonths: 36, voidMonths: 0, gastosUnit: 6.00, gastosMonthly: 2859.12, luzUnit: 1.50, luzMonthly: 714.78,\n gastosTotal: 3573.90, fianza: 29544.24, aval: 88632.72, parkingSpaces: \"\", parkingRent: \"\", refcat: \"3056301VK4735E0001DM\",\n review: \"REVISAR: contrato no informado. BO al final del tercer año con preaviso 6 meses.\"\n }\n];\n\nconst movHeaders = [\"PDF\", \"Tipo operación\", \"Nº U.E.\", \"Contrato\", \"Arrendatario\", \"Inmueble\", \"Localidad\", \"Objeto / Comentarios\", \"Uso\", \"Planta\", \"Superficie\", \"Renta €/m²/mes\", \"Renta mensual\", \"Renta anual\", \"Plazas parking\", \"Renta parking mensual\", \"Carencia meses\", \"Obligado cumplimiento meses\", \"Fecha vigencia contrato\", \"Fecha vigencia económica\", \"Fecha BO\", \"Fecha vencimiento\", \"Gastos €/m²/mes\", \"Gastos mensuales\", \"Luz €/m²/mes\", \"Luz mensual\", \"Gastos total mensual\", \"Fianza\", \"Aval\", \"Referencia catastral\", \"REVISAR\"];\nconst esfHeaders = [\"Asset\", \"Contract\", \"Tenant\", \"Use\", \"Floor\", \"Initial Date\", \"Signat. Date\", \"BO Date\", \"Expiry Date\", \"BO months\", \"Expiry years\", \"Void months\", \"Signed sq m\", \"Signed Rent €/m²/month\", \"Signed Rent mensual\", \"Annual Rent\", \"Parking spaces\", \"Parking rent mensual\", \"Service charges €/m²\", \"Service charges mensual\", \"Light €/m²\", \"Light mensual\", \"Total expenses mensual\", \"Deposit\", \"Bank guarantee\", \"Nº U.E.\", \"Type\", \"Comments / REVISAR\"];\n\nfunction fmtDate(s: string) {\n if (!s) return \"\";\n const [d,m,y] = s.split(\"/\").map(Number);\n return new Date(y, m - 1, d);\n}\nfunction monthYear(s: string) {\n const dt = fmtDate(s); if (!dt) return \"\";\n return dt.toLocaleString(\"en-US\", {month:\"short\", year:\"2-digit\"}).replace(\" \", \"-\");\n}\n\nfunction styleHeader(row: any, fill = \"1F4E78\") {\n row.eachCell((cell: any) => {\n cell.font = {bold: true, color: {argb: \"FFFFFFFF\"}};\n cell.fill = {type: \"pattern\", pattern: \"solid\", fgColor: {argb: fill}};\n cell.alignment = {vertical: \"middle\", horizontal: \"center\", wrapText: true};\n cell.border = {top:{style:\"thin\"}, left:{style:\"thin\"}, bottom:{style:\"thin\"}, right:{style:\"thin\"}};\n });\n}\nfunction styleTable(ws: any) {\n ws.eachRow((row: any, n: number) => {\n row.eachCell((cell: any) => {\n cell.border = {top:{style:\"thin\", color:{argb:\"FFD9E2F3\"}}, left:{style:\"thin\", color:{argb:\"FFD9E2F3\"}}, bottom:{style:\"thin\", color:{argb:\"FFD9E2F3\"}}, right:{style:\"thin\", color:{argb:\"FFD9E2F3\"}}};\n cell.alignment = {vertical: \"middle\", wrapText: true};\n });\n });\n}\nfunction addTitle(ws: any, title: string, subtitle?: string) {\n ws.mergeCells(\"A1:H1\");\n const c = ws.getCell(\"A1\"); c.value = title; c.font = {bold:true, size:16, color:{argb:\"FFFFFFFF\"}}; c.fill = {type:\"pattern\", pattern:\"solid\", fgColor:{argb:\"FF17365D\"}}; c.alignment={vertical:\"middle\"};\n ws.getRow(1).height = 24;\n if (subtitle) { ws.mergeCells(\"A2:H2\"); ws.getCell(\"A2\").value = subtitle; ws.getCell(\"A2\").font = {italic:true, color:{argb:\"FF666666\"}}; }\n}\nfunction addMovSheet(wb: any) {\n const ws = wb.addWorksheet(\"Mov 2026\", {views:[{state:\"frozen\", ySplit:4}]});\n addTitle(ws, \"Mov 2026\", \"Reconstrucción generada por AI a partir de PDFs de preparador 0326\");\n const h = ws.addRow(movHeaders); styleHeader(h);\n ops.forEach(o => ws.addRow([o.pdf,o.tipo,o.ue,o.contract,o.tenant,o.asset,o.localidad,o.tipo,o.use,o.floor,o.superficie,o.rentUnit,o.rentMonthly,o.annualRent,o.parkingSpaces,o.parkingRent,o.voidMonths,o.boMonths,fmtDate(o.initial),fmtDate(o.economic),fmtDate(o.boDate),fmtDate(o.expiry),o.gastosUnit,o.gastosMonthly,o.luzUnit,o.luzMonthly,o.gastosTotal,o.fianza,o.aval,o.refcat,o.review]));\n ws.columns = movHeaders.map((h,i)=>({width: i===30?55: Math.min(Math.max(String(h).length+4, 12), 26)}));\n [11,12,13,14,16,23,24,25,26,27,28,29].forEach(i=>ws.getColumn(i).numFmt = '#,##0.00');\n [19,20,21,22].forEach(i=>ws.getColumn(i).numFmt = 'dd/mm/yyyy');\n styleTable(ws); ws.autoFilter = {from:\"A3\", to:\"AE3\"};\n}\nfunction addEsfSheet(wb: any, name: string, officesOnly = false) {\n const ws = wb.addWorksheet(name, {views:[{state:\"frozen\", ySplit:5}]});\n addTitle(ws, \"COMMERCIAL EFFORT (sq m)\", name + \" · 03.26 · Archivo reconstruido (no sustituye al libro maestro original)\");\n ws.addRow([]);\n const h = ws.addRow(esfHeaders); styleHeader(h, \"4472C4\");\n const blocks = [\"RENEWALS\", \"NEW LETTINGS\", \"RE-LET SURFACES\"];\n blocks.forEach(block => {\n const br = ws.addRow([block]); ws.mergeCells(`A${br.number}:AB${br.number}`); br.getCell(1).font={bold:true,color:{argb:\"FFFFFFFF\"}}; br.getCell(1).fill={type:\"pattern\",pattern:\"solid\",fgColor:{argb:block===\"RENEWALS\"?\"FF70AD47\":block===\"NEW LETTINGS\"?\"FFF4B183\":\"FF9E7CC1\"}};\n ops.filter(o => o.block === block && (!officesOnly || /^Office/i.test(o.use))).forEach(o => ws.addRow([o.asset,o.contract,o.tenant,o.use,o.floor,monthYear(o.initial),monthYear(o.signat),monthYear(o.boDate),monthYear(o.expiry),o.boMonths, o.expiry ? Math.round((fmtDate(o.expiry).getTime()-fmtDate(o.initial).getTime())/31557600000*10)/10 : \"\", o.voidMonths,o.superficie,o.rentUnit,o.rentMonthly,o.annualRent,o.parkingSpaces,o.parkingRent,o.gastosUnit,o.gastosMonthly,o.luzUnit,o.luzMonthly,o.gastosTotal,o.fianza,o.aval,o.ue,o.tipo,o.review]));\n const tr = ws.addRow([`TOTAL ${block}`]); tr.font={bold:true}; tr.fill={type:\"pattern\",pattern:\"solid\",fgColor:{argb:\"FFD9EAD3\"}};\n });\n ws.columns = esfHeaders.map((h,i)=>({width: i===27?58: Math.min(Math.max(String(h).length+3, 11), 25)}));\n [13,14,15,16,18,19,20,21,22,23,24,25].forEach(i=>ws.getColumn(i).numFmt = '#,##0.00');\n styleTable(ws); ws.autoFilter = {from:\"A4\", to:\"AB4\"};\n}\nfunction addSummary(wb: any) {\n const ws = wb.addWorksheet(\"Resumen AI\");\n addTitle(ws, \"Resumen de generación AI\", \"Copia reconstruida por limitación técnica de acceso binario al workbook original\");\n ws.addRow([]);\n const h=ws.addRow([\"Concepto\", \"Valor\"]); styleHeader(h, \"7030A0\");\n [[\"PDFs procesados\",3],[\"Operaciones detectadas\",3],[\"Hojas operativas generadas\",\"Mov 2026, Esf. Comercial, Esf. Comercial (Offices)\"],[\"Advertencia\",\"Este archivo es una reconstrucción aproximada; no preserva fórmulas/formatos exactos del libro maestro original.\"],[\"REVISAR NEPTUNE\",\"Discrepancia de gastos oficinas: unitario 7,90 €/m² no cuadra con total 9.001,60 €/mes.\"],[\"REVISAR contratos\",\"NASH21 y NEPTUNE no informan número de contrato en PDF.\"]].forEach(r=>ws.addRow(r));\n ws.columns=[{width:28},{width:100}]; styleTable(ws);\n}\n\nexport default async function handler(req: Request): Promise {\n const wb = new ExcelJS.Workbook();\n wb.creator = \"Colonial AI Lab\"; wb.created = new Date();\n addSummary(wb); addMovSheet(wb); addEsfSheet(wb, \"Esf. Comercial\"); addEsfSheet(wb, \"Esf. Comercial (Offices)\", true);\n const buffer = await wb.xlsx.writeBuffer();\n return new Response(buffer, {headers:{\"Content-Type\":\"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet\",\"Content-Disposition\":\"attachment; filename=\\\"Copia de Revisiones renta COL 0326 (2) - generado AI.xlsx\\\"\",\"Cache-Control\":\"no-store\"}});\n}\n",[144],"22758a27-5567-4fd1-a5ee-01d652b01206","fetchtest.ts","254ea0fe-69a9-11f1-aa0a-1607ee4eb77e",9,["D",1781631882109],5,"export default async function handler(req: Request): Promise {\n const urls = [\n \"https://liquidlab1.sharepoint.com/:x:/r/sites/LiquidLab/Shared%20Documents/Esfuerzo%20comercial/Copia%20de%20Revisiones%20renta%20COL%200326%20(2).xlsx?d=w5c3f4221006b495d901571193a9bc73d&download=1\",\n \"https://liquidlab1.sharepoint.com/:x:/r/sites/LiquidLab/Shared%20Documents/Esfuerzo%20comercial/Copia%20de%20Revisiones%20renta%20COL%200326%20(2).xlsx?d=w5c3f4221006b495d901571193a9bc73d&csf=1&web=0&e=hvi7Hd\",\n \"https://liquidlab1.sharepoint.com/sites/LiquidLab/Shared%20Documents/Esfuerzo%20comercial/Copia%20de%20Revisiones%20renta%20COL%200326%20(2).xlsx?download=1\"\n ];\n const out=[];\n for (const url of urls) {\n const r = await fetch(url, {redirect:\"follow\"});\n const ab=await r.arrayBuffer();\n out.push({url, status:r.status, finalUrl:r.url, contentType:r.headers.get(\"content-type\"), len:ab.byteLength, first:Array.from(new Uint8Array(ab.slice(0,8))), txt:new TextDecoder().decode(ab.slice(0,60))});\n }\n return Response.json(out);\n}",[151],"pulls","branches","forks","envVars",{"_165":61,"_167":61},"connections",{"_165":61,"_166":61},"count","unfilledCount","emptyCount",{"_43":150,"_32":151,"_30":152,"_131":-5,"_41":42,"_40":153,"_133":119,"_38":182,"_13":155,"_33":36,"_34":156,"_24":25,"_137":-5,"_173":183,"_27":184},{"_43":143,"_32":144,"_30":145,"_131":-5,"_41":42,"_40":146,"_133":119,"_38":179,"_13":141,"_33":36,"_34":148,"_24":25,"_137":-5,"_173":180,"_27":181},{"_43":139,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_133":119,"_38":176,"_13":141,"_33":36,"_34":37,"_24":25,"_137":-5,"_173":177,"_27":178},{"_43":128,"_32":129,"_30":130,"_131":-5,"_41":42,"_40":132,"_133":119,"_38":172,"_13":135,"_33":36,"_34":136,"_24":25,"_137":-5,"_173":174,"_27":175},["D",1781626453560],"children",[],[129],["D",1781678038152],[],[28],["D",1781634339612],[],[144],["D",1781631882109],[],[151],["D",1781612571402],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":55,"_98":99,"_100":25},{"_13":14,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"ctx",{"_77":-5,"_121":222,"_223":224,"_225":226,"_227":25,"_228":25,"_229":25,"_230":119,"_231":-5,"_232":-7,"_233":-7,"_234":61,"_235":25,"_236":25,"_237":-5,"_238":25,"_239":25,"_240":25,"_241":-5},"ENV",{"_193":194,"_195":196,"_197":84,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221},"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 · v13