[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_178":179,"_180":181},"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",11,"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_reconstructed.ts","latestPath","fileId","ac6a3b5a-69b0-11f1-a79d-1607ee4eb77e","name","fileType","content","","http","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","createdAt",["D",1781634339612],"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":174,"_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":175,"_79":176,"_81":177,"_83":25},"tree",[161,162,163],"files",[161,162,163],"counts",{"_151":61,"_152":141,"_153":61,"_154":155,"_156":157},"contents",[125,126,127],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":143,"_32":144,"_30":145,"_131":-5,"_41":42,"_40":146,"_133":120,"_38":147,"_13":148,"_33":36,"_34":149,"_24":25,"_137":-5,"_27":150},{"_43":139,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_133":120,"_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":120,"_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],"370681fa-21ad-4c18-bbde-7ceba56bfbeb",["D",1781634339612],1,[28],"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}",[144],"pulls","branches","forks","envVars",{"_158":61,"_160":61},"connections",{"_158":61,"_159":61},"count","unfilledCount","emptyCount",{"_43":143,"_32":144,"_30":145,"_131":-5,"_41":42,"_40":146,"_133":120,"_38":171,"_13":148,"_33":36,"_34":149,"_24":25,"_137":-5,"_165":172,"_27":173},{"_43":139,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_133":120,"_38":168,"_13":141,"_33":36,"_34":37,"_24":25,"_137":-5,"_165":169,"_27":170},{"_43":128,"_32":129,"_30":130,"_131":-5,"_41":42,"_40":132,"_133":120,"_38":164,"_13":135,"_33":36,"_34":136,"_24":25,"_137":-5,"_165":166,"_27":167},["D",1781626453560],"children",[],[129],["D",1781634339612],[],[28],["D",1781631882109],[],[144],["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":211,"_212":213,"_214":215,"_216":25,"_217":25,"_218":25,"_219":120,"_220":-5,"_221":-7,"_222":-7,"_223":61,"_224":25,"_225":25,"_226":-5,"_227":25,"_228":25,"_229":25,"_230":-5},"ENV",{"_182":183,"_184":185,"_186":85,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210},"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 · v11