IMS系统报表系统设计完全指南

/* 报表系统架构 */
class ReportSystem {
    constructor() {
        this.designer = new ReportDesigner();
        this.engine = new ReportEngine();
        this.renderer = new ReportRenderer();
    }

    /* 生成报表 */
    async generateReport(config) {
        // 1. 获取数据源
        const data = await this.engine.fetchData(config.dataSource);

        // 2. 数据处理与计算
        const processedData = this.engine.processData(data, config.transforms);

        // 3. 渲染报表
        return await this.renderer.render(config.template, processedData);
    }
}

/* 数据源配置 */
class DataSourceConfig {
    constructor(type, config) {
        this.type = type;  // sql/api/function
        this.config = config;
    }

    /* SQL 数据源 */
    static sql(sql, params = {}) {
        return new DataSourceConfig('sql', { sql, params });
    }

    /* API 数据源 */
    static api(url, method = 'GET') {
        return new DataSourceConfig('api', { url, method });
    }

    /* 函数数据源 */
    static function(fn) {
        return new DataSourceConfig('function', { fn });
    }
}

/* 数据源执行器 */
class DataSourceExecutor {
    async execute(dataSource) {
        switch (dataSource.type) {
            case 'sql':
                return await executeSQL(dataSource.config);
            case 'api':
                return await fetchAPI(dataSource.config);
            case 'function':
                return await dataSource.config.fn();
        }
    }
}

/* 图表类型枚举 */
const CHART_TYPES = {
    LINE: 'line',           // 折线图
    BAR: 'bar',            // 柱状图
    PIE: 'pie',            // 饼图
    GAUGE: 'gauge',         // 仪表盘
    SCATTER: 'scatter',     // 散点图
    HEATMAP: 'heatmap',     // 热力图
    TREEMAP: 'treemap',     // 树图
    RADAR: 'radar'          // 雷达图
};

/* 图表配置 */
class ChartConfig {
    constructor(type, data, options = {}) {
        this.type = type;
        this.data = data;
        this.title = options.title || '';
        this.xAxis = options.xAxis || {};
        this.yAxis = options.yAxis || {};
        this.legend = options.legend !== false;
        this.tooltip = options.tooltip !== false;
        this.colors = options.colors || getDefaultColors();
    }
}

/* 图表渲染器 */
class ChartRenderer {
    render(container, config) {
        const chartLib = getChartLibrary();  // ECharts/Chart.js
        const chart = chartLib.init(container);
        chart.setOption(this.convertToEchartsOption(config));
        return chart;
    }

    convertToEchartsOption(config) {
        return {
            title: { text: config.title },
            tooltip: { trigger: 'axis' },
            legend: { show: config.legend },
            xAxis: config.xAxis,
            yAxis: config.yAxis,
            series: [this.convertDataToSeries(config)],
            color: config.colors
        };
    }
}

/* 报表导出器 */
class ReportExporter {
    /* 导出为 PDF */
    async exportToPDF(report, options = {}) {
        const html = this.renderToHTML(report);
        const pdf = await html2pdf(html, {
            margin: options.margin || 10,
            filename: options.filename || 'report.pdf',
            image: options.imageType || 'jpeg',
            html2canvas: { scale: 2 },
            jsPDF: { unit: 'mm', format: 'a4', orientation: 'portrait' }
        });
        return pdf;
    }

    /* 导出为 Excel */
    async exportToExcel(report, options = {}) {
        const workbook = new ExcelJS Workbook();
        const worksheet = workbook.addWorksheet(report.title || 'Sheet1');

        // 写入表头
        const headers = report.columns.map(c => c.label);
        worksheet.addRow(headers);

        // 写入数据
        report.data.forEach(row => {
            const values = report.columns.map(col => row[col.key]);
            worksheet.addRow(values);
        });

        const buffer = await workbook.xlsx.writeBuffer();
        return blob(buffer, 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
    }

    /* 导出为 CSV */
    async exportToCSV(report) {
        const headers = report.columns.map(c => c.label).join(',');
        const rows = report.data.map(row =>
            report.columns.map(col => escapeCSV(row[col.key])).join(',')
        );
        return blob([headers, ...rows].join('\n'), 'text/csv');
    }
}