import HTMLtoDOCX from 'html-to-docx'; import puppeteer from 'puppeteer'; import * as cheerio from 'cheerio'; import ExcelJS from 'exceljs'; // Convert HTML to DOCX Buffer export const convertToDocx = async (htmlContent, title) => { // html-to-docx expects a string and options const fileBuffer = await HTMLtoDOCX(htmlContent, null, { table: { row: { cantSplit: true } }, footer: true, pageNumber: true, title: title }); return fileBuffer; }; // Convert HTML to PDF Buffer — rasterizes Three.js canvases via Puppeteer element screenshots export const convertToPdf = async (htmlContent) => { const browser = await puppeteer.launch({ headless: 'new', args: ['--no-sandbox', '--disable-setuid-sandbox', '--enable-webgl', '--use-gl=swiftshader'] }); try { const page = await browser.newPage(); await page.setViewport({ width: 1280, height: 1800, deviceScaleFactor: 2 }); // Load page — wait for network idle so importmaps + CDN scripts resolve await page.setContent(htmlContent, { waitUntil: 'networkidle0', timeout: 30000 }); // Check if page has any Three.js canvases const hasThreeCanvases = await page.evaluate( () => document.querySelectorAll('canvas[data-threejs]').length > 0 ); if (hasThreeCanvases) { // Give Three.js time to initialise and render its first frame console.log('PDF export: Three.js canvases detected — waiting for render...'); await new Promise(r => setTimeout(r, 4000)); // Get all canvas element handles const canvasHandles = await page.$$('canvas[data-threejs]'); let rasterized = 0; for (const canvasHandle of canvasHandles) { try { // Take a screenshot of just this element using Puppeteer's compositor capture // This works regardless of preserveDrawingBuffer since it captures screen pixels const screenshotBuf = await canvasHandle.screenshot({ type: 'png' }); const base64 = screenshotBuf.toString('base64'); const dataUrl = `data:image/png;base64,${base64}`; // Replace canvas with in the page DOM await page.evaluate((canvas, src) => { const img = document.createElement('img'); img.src = src; img.style.width = Math.min(canvas.offsetWidth, 700) + 'px'; img.style.maxWidth = '100%'; img.style.height = 'auto'; img.style.display = 'block'; img.style.margin = '0 auto'; img.style.borderRadius = '4px'; img.style.border = '1px solid #d0d8e8'; img.alt = '3D Perspective View (rendered for PDF)'; canvas.parentNode.replaceChild(img, canvas); }, canvasHandle, dataUrl); rasterized++; } catch (canvasErr) { console.warn('PDF export: could not screenshot canvas, hiding it:', canvasErr.message); // Gracefully replace with a text note await page.evaluate((canvas) => { canvas.style.display = 'none'; const note = document.createElement('div'); note.style.cssText = 'padding:16px;text-align:center;font-size:11px;color:#718096;font-family:Arial;border:1px dashed #e2e8f0;border-radius:4px;margin:8px auto;max-width:700px'; note.textContent = '[ 3D Perspective View — open this document in a browser for an interactive view ]'; canvas.parentNode.insertBefore(note, canvas); }, canvasHandle); } } console.log(`PDF export: rasterized ${rasterized}/${canvasHandles.length} Three.js canvas(es)`); } // Hide any remaining canvases that weren't tagged (safety net) await page.evaluate(() => { document.querySelectorAll('canvas:not(img)').forEach(c => { if (!c.getAttribute('data-threejs')) return; c.style.display = 'none'; }); }); const pdfBuffer = await page.pdf({ format: 'A4', printBackground: true, margin: { top: '15px', bottom: '20px', left: '15px', right: '15px' } }); return pdfBuffer; } finally { await browser.close(); } }; // NEW: Convert to XLSX using ExcelJS export const convertToXlsx = async (htmlContent, title) => { const $ = cheerio.load(htmlContent); const table = $('table').first(); if (table.length === 0) { throw new Error("No table found to convert."); } const workbook = new ExcelJS.Workbook(); const worksheet = workbook.addWorksheet(title.substring(0, 30) || 'Sheet 1'); // Excel limits sheet names to 31 chars // Parse Headers (th) const headerRow = []; table.find('tr').first().find('th').each((i, el) => { headerRow.push($(el).text().trim()); }); // If no TH, try first row TD if(headerRow.length === 0) { table.find('tr').first().find('td').each((i, el) => { headerRow.push($(el).text().trim()); }); } // Add Header Row with Styling const header = worksheet.addRow(headerRow); header.eachCell((cell) => { cell.font = { bold: true, color: { argb: 'FFFFFFFF' } }; cell.fill = { type: 'pattern', pattern: 'solid', fgColor: { argb: 'FF2E7D32' } }; // Emerald Green }); // Parse Data Rows table.find('tr').each((i, row) => { // Skip header row if we already parsed it if ($(row).find('th').length > 0) return; const rowData = []; $(row).find('td').each((j, col) => { // Handle basic numbers vs strings const text = $(col).text().trim(); const num = parseFloat(text.replace(/,/g, '')); // Simple check for currency/numbers rowData.push(!isNaN(num) && text.match(/\d/) ? num : text); }); if (rowData.length > 0) { worksheet.addRow(rowData); } }); // Auto-width columns (basic estimation) worksheet.columns.forEach(column => { column.width = 20; }); // Write to buffer const buffer = await workbook.xlsx.writeBuffer(); return buffer; };