YangHuCost/modules/reports/controllers/rpt_controller.js

/**
 * Created by Tony on 2017/3/13.
 */

const mongoose = require("mongoose");
const async = require("async");

const JV = require("../rpt_component/jpc_value_define");

let Template = mongoose.model('rpt_templates');
let rptTplDataFacade = require("../facade/rpt_tpl_data_facade");
let fsUtil = require("../../../public/fsUtil");
let pm_facade = require('../../../modules/pm/facade/pm_facade');

const rptTplFacade = require("../facade/rpt_template_facade");
const demoTemplateFacade = require("../facade/rpt_tpl_data_demo_facade");
const JpcEx = require("../rpt_component/jpc_ex");
const rptUtil = require("../util/rpt_util");
const rpt_xl_util = require("../util/rpt_excel_util");
const rpt_pdf_util = require("../util/rpt_pdf_util");
const rpt_svg_util = require("../util/rpt_svg_util");
const fs = require("fs");
const strUtil = require("../../../public/stringUtil");
const rptDataExtractor = require("../util/rpt_yanghu_data_util");
const { output } = require("pdfkit");

//统一回调函数
let callback = function(req, res, err, data){
    if(err){
        res.json({success: false, error: err, message: err});
    }
    else{
        //res.send({success: true, data: data});
        res.json({success:true, data: data});
    }
};

function setupCustomizeCfg(customizeCfg, rptTpl, defProperties) {
    let tmpObj = {};
    //1. 字体
    let newFonts = [];
    for (let font of defProperties.fonts) {
        let copyFont = {};
        copyFont.ID = font.ID;
        for (let fontProp of JV.FONT_PROPS) {
            copyFont[fontProp] = font[fontProp];
        }
        newFonts.push(copyFont);
        tmpObj[font.ID] = copyFont;
    }
    let private_setup_font = function (propStr, newFont) {
        if (tmpObj[propStr]) {
            tmpObj[propStr].Name = newFont.Name;
            tmpObj[propStr].FontHeight = String(newFont.FontHeight);
            tmpObj[propStr].FontBold = newFont.FontBold;
            tmpObj[propStr].FontItalic = newFont.FontItalic;
            tmpObj[propStr].FontUnderline = newFont.FontUnderline;
        }
    };
    for (let custFont of customizeCfg.fonts) {
        switch (custFont.CfgDispName) {
            case "表标题":
                private_setup_font("ReportTitle_Main", custFont);
                break;
            case "列标题":
                private_setup_font("HeaderColumn", custFont);
                private_setup_font("FooterColumn", custFont);
                break;
            case "正文内容":
                private_setup_font("Content", custFont);
                break;
            case "合计":
                private_setup_font("GrandTotal", custFont);
                private_setup_font("SectionTotal", custFont);
                break;
            case "表眉/表脚":
                private_setup_font("Header", custFont);
                private_setup_font("Footer", custFont);
                break;
        }
    }
    // 1.1 窄体
    if (tmpObj["Content_Narrow"]) {
        if (customizeCfg.isNarrow) {
            tmpObj["Content_Narrow"].Name = "Arial Narrow";
        } else {
            if (tmpObj["Content"]) {
                tmpObj["Content_Narrow"].Name = tmpObj["Content"].Name;
            } else {
                tmpObj["Content_Narrow"].Name = "宋体";
            }
        }
    }
    defProperties.fonts = newFonts;
    //2. 页边距
    rptTpl[JV.NODE_MAIN_INFO][JV.NODE_MARGINS][JV.PROP_LEFT] = customizeCfg.margins[JV.PROP_LEFT] / 10;
    rptTpl[JV.NODE_MAIN_INFO][JV.NODE_MARGINS][JV.PROP_RIGHT] = customizeCfg.margins[JV.PROP_RIGHT] / 10;
    rptTpl[JV.NODE_MAIN_INFO][JV.NODE_MARGINS][JV.PROP_TOP] = customizeCfg.margins[JV.PROP_TOP] / 10;
    rptTpl[JV.NODE_MAIN_INFO][JV.NODE_MARGINS][JV.PROP_BOTTOM] = customizeCfg.margins[JV.PROP_BOTTOM] / 10;
    //3. 边框竖线
    if (!(customizeCfg.showVerticalLine)) {
        let private_copy_border = function (src) {
            let rst = {};
            rst.Position = src.Position;
            rst.LineWeight = src.LineWeight;
            rst.DashStyle = src.DashStyle;
            rst.Color = src.Color;
            return rst;
        };
        let newStyles = [];
        for (let i =0 ; i < defProperties.styles.length; i++) {
            let style = defProperties.styles[i];
            newStyles.push(style);
            if (style.ID === "BORDER_ALL_AROUND") {
                let newStyle = {};
                newStyle.ID  = style.ID;
                newStyle.CfgDispName = style.CfgDispName;
                newStyle.border_style = [];
                for (let border of style.border_style) {
                    let newBorder = private_copy_border(border);
                    newStyle.border_style.push(newBorder);
                    if (border.Position === "Left" || border.Position === "Right") {
                        newBorder.LineWeight = 0;
                    }
                }
                newStyles[newStyles.length - 1] = newStyle;
            }
        }
        defProperties.styles = newStyles;
    }
    //4. 补0
    let private_Setup_Format = function(tabFields) {
        if (tabFields) {
            for (let tabField of tabFields) {
                if (tabField[JV.PROP_FORMAT]) {
                    tabField[JV.PROP_FORMAT] = tabField[JV.PROP_FORMAT].replace(new RegExp("#","gm"),"0");
                }
            }
        }
    };
    if (customizeCfg.fillZero) {
        if (rptTpl[JV.NODE_FLOW_INFO]) {
            if (rptTpl[JV.NODE_FLOW_INFO][JV.NODE_FLOW_CONTENT]) private_Setup_Format(rptTpl[JV.NODE_FLOW_INFO][JV.NODE_FLOW_CONTENT][JV.PROP_FLOW_FIELDS]);
            if (rptTpl[JV.NODE_FLOW_INFO][JV.NODE_FLOW_PAGE_SUM]) private_Setup_Format(rptTpl[JV.NODE_FLOW_INFO][JV.NODE_FLOW_PAGE_SUM][JV.PROP_SUM_FIELDS]);
            if (rptTpl[JV.NODE_FLOW_INFO][JV.NODE_FLOW_SEG_SUM]) private_Setup_Format(rptTpl[JV.NODE_FLOW_INFO][JV.NODE_FLOW_SEG_SUM][JV.PROP_SUM_FIELDS]);
            if (rptTpl[JV.NODE_FLOW_INFO][JV.NODE_FLOW_GROUP] && rptTpl[JV.NODE_FLOW_INFO][JV.NODE_FLOW_GROUP][JV.PROP_GROUP_LINES])
                private_Setup_Format(rptTpl[JV.NODE_FLOW_INFO][JV.NODE_FLOW_GROUP][JV.PROP_GROUP_LINES][JV.PROP_SUM_FIELDS]);
            if (rptTpl[JV.NODE_FLOW_INFO][JV.NODE_DISCRETE_INFO]) {
                for (let discrete of rptTpl[JV.NODE_FLOW_INFO][JV.NODE_DISCRETE_INFO]) {
                    private_Setup_Format(discrete[JV.PROP_DISCRETE_FIELDS]);
                }
            }
            if (rptTpl[JV.NODE_FLOW_INFO_EX]) {
                if (rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_CONTENT]) private_Setup_Format(rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_CONTENT][JV.PROP_FLOW_FIELDS]);
                if (rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_PAGE_SUM]) private_Setup_Format(rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_PAGE_SUM][JV.PROP_SUM_FIELDS]);
                if (rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_SEG_SUM]) private_Setup_Format(rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_SEG_SUM][JV.PROP_SUM_FIELDS]);
                if (rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_GROUP]) private_Setup_Format(rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_GROUP][JV.PROP_SUM_FIELDS]);
                if (rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_GROUP] && rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_GROUP][JV.PROP_GROUP_LINES])
                    private_Setup_Format(rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_GROUP][JV.PROP_GROUP_LINES][JV.PROP_SUM_FIELDS]);
                if (rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_DISCRETE_INFO]) {
                    for (let discrete of rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_DISCRETE_INFO]) {
                        private_Setup_Format(discrete[JV.PROP_DISCRETE_FIELDS]);
                    }
                }
            }
        } else if (rptTpl[JV.NODE_BILL_INFO]) {
            if (rptTpl[JV.NODE_BILL_INFO][JV.NODE_BILL_CONTENT]) private_Setup_Format(rptTpl[JV.NODE_BILL_INFO][JV.NODE_BILL_CONTENT][JV.PROP_BILL_FIELDS]);
            if (rptTpl[JV.NODE_BILL_INFO][JV.NODE_DISCRETE_INFO]) {
                for (let discrete of rptTpl[JV.NODE_BILL_INFO][JV.NODE_DISCRETE_INFO]) {
                    private_Setup_Format(discrete[JV.PROP_DISCRETE_FIELDS]);
                }
            }
        } else if (rptTpl[JV.NODE_CROSS_INFO]) {
            if (rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_CONTENT]) private_Setup_Format(rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_CONTENT][JV.TAB_CROSS_FIELDS]);
            if (rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW]) private_Setup_Format(rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW][JV.TAB_CROSS_FIELDS]);
            if (rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_COL]) private_Setup_Format(rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_COL][JV.TAB_CROSS_FIELDS]);
            if (rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_COL_SUM]) private_Setup_Format(rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_COL_SUM][JV.TAB_CROSS_FIELDS]);
            if (rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW_EXT]) private_Setup_Format(rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW_EXT][JV.TAB_CROSS_FIELDS]);
            if (rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW_SUM_EXT]) private_Setup_Format(rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW_SUM_EXT][JV.TAB_CROSS_FIELDS]);
            if (rptTpl[JV.NODE_CROSS_INFO][JV.NODE_DISCRETE_INFO]) {
                for (let discrete of rptTpl[JV.NODE_CROSS_INFO][JV.NODE_DISCRETE_INFO]) {
                    private_Setup_Format(discrete[JV.PROP_DISCRETE_FIELDS]);
                }
            }
        }
    }
}

function _combineData(destData, srcData) {
    // 备注：这里有一个前提条件，就是基于相同的报表模板
    for (let idx = 0; idx < destData[JV.DATA_DISCRETE_DATA].length; idx++) {
        destData[JV.DATA_DISCRETE_DATA][idx] = destData[JV.DATA_DISCRETE_DATA][idx].concat(srcData[JV.DATA_DISCRETE_DATA][idx]);
    }
    for (let idx = 0; idx < destData[JV.DATA_MASTER_DATA].length; idx++) {
        destData[JV.DATA_MASTER_DATA][idx] = destData[JV.DATA_MASTER_DATA][idx].concat(srcData[JV.DATA_MASTER_DATA][idx]);
    }
    for (let idx = 0; idx < destData[JV.DATA_MASTER_DATA_EX].length; idx++) {
        destData[JV.DATA_MASTER_DATA_EX][idx] = destData[JV.DATA_MASTER_DATA_EX][idx].concat(srcData[JV.DATA_MASTER_DATA_EX][idx]);
    }
    for (let idx = 0; idx < destData[JV.DATA_DETAIL_DATA].length; idx++) {
        destData[JV.DATA_DETAIL_DATA][idx] = destData[JV.DATA_DETAIL_DATA][idx].concat(srcData[JV.DATA_DETAIL_DATA][idx]);
    }
    for (let idx = 0; idx < destData[JV.DATA_DETAIL_DATA_EX].length; idx++) {
        destData[JV.DATA_DETAIL_DATA_EX][idx] = destData[JV.DATA_DETAIL_DATA_EX][idx].concat(srcData[JV.DATA_DETAIL_DATA_EX][idx]);
    }
}

function _createPntPageData(tplData, rptTpl, params, outputType, cb) {
    try {
        let printCom = JpcEx.createNew();
        if (params.pageSize) rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_PAGE_SIZE] = params.pageSize;
        if (params.orientation && (params.orientation !== 'null')) rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_ORIENTATION] = params.orientation;
        let defProperties = rptUtil.getReportDefaultCache();
        if (params.custCfg) setupCustomizeCfg(params.custCfg, rptTpl, defProperties);
        let dftOption = params.option||JV.PAGING_OPTION_NORMAL;
        printCom.initialize(rptTpl);
        printCom.analyzeData(rptTpl, tplData, defProperties, dftOption, outputType);
        let maxPages = printCom.totalPages;
        let pageRst = null;
        if (maxPages > 0) {
            pageRst = printCom.outputAsSimpleJSONPageArray(rptTpl, tplData, 1, maxPages, defProperties, params.custCfg);
        } else {
            pageRst = printCom.outputAsPreviewPage(rptTpl, defProperties);
        }
        if (pageRst) {
            // fsUtil.writeObjToFile(pageRst, "D:/GitHome/ConstructionCost/tmp/testBuiltPageResult.jsp");
            cb(null, pageRst);
        } else {
            cb('Have errors while on going...', null);
        }
    } catch(ex) {
        // console.log("报表数据异常： project id: " + prj_id);
        console.log(ex.toString());
        cb('Exception occurs while on going...', null);
    }
}

async function getAllPagesForOneRptCommonEx(user_id, rpt_params, outputType, cb) {
    //prj_ids, rpt_id, pageSize, orientation, customizeCfg
    rptTpl = await rptTplFacade.getRptTemplate(rpt_params.rpt_tpl_id);
    if (rptTpl) {
        let rptDataUtil = new rptDataExtractor();
        rptDataUtil.initialize((rptTpl._doc)?rptTpl._doc:rptTpl);
        let summaryRst = [];
        let filter = rptDataUtil.getDataRequestFilter(summaryRst);
        // 这里不考虑清单汇总及工料机汇总的情况了(有另外的分支处理，不会经过这里)
        // let multiRawData = await rptTplDataFacade.prepareMultiProjectData(user_id, rpt_params.prj_ids, filter);
        let multiRawData = await rptTplDataFacade.prepareMultiProjectDataEx(user_id, rpt_params.prj_ids, filter);
        try {
            if (multiRawData.length > 0) {
                // fsUtil.writeObjToFile(multiRawData, `D:/GitHome/YangHuCost/tmp/orgMultiRawData_${(new Date()).getTime()}.jsp`);
                //考虑到工料机的数据还需要再计算，所以还不能直接用，需要每个工程都处理一遍后，再合并
                let tplData = rptDataUtil.assembleData(multiRawData[0]);
                for (let idx = 1; idx < multiRawData.length; idx++) {
                    let tmpData = rptDataUtil.assembleData(multiRawData[idx]);
                    _combineData(tplData, tmpData);
                }
                _createPntPageData(tplData, rptTpl, rpt_params, outputType, cb);
            } else {
                cb('Have errors while on going...', null);
            }
        } catch(ex) {
            //
        }
    } else {
        cb('No report template was found!', null);
    }
}

async function getAllPagesCommon(user_id, prj_id, rpt_id, pageSize, orientation, customizeCfg, option, outputType, cb) {
    let rpt_params = {pageSize: pageSize, orientation: orientation, custCfg: customizeCfg, option: option, prj_ids: [prj_id], rpt_tpl_id: rpt_id};
    getAllPagesForOneRptCommonEx(user_id, rpt_params, outputType, cb);
}

async function getMultiRptsCommonEx(user_id, prj_ids_arr, rpt_ids, pageSize, orientation, customizeCfg, option, outputType, cb) {
    function getProjectPageData(rptTpl, prj_ids, multiRawData) {
        let rpt_params = {pageSize: pageSize, orientation: orientation, custCfg: customizeCfg, option: option, prj_ids: prj_ids};
        let util = new rptDataExtractor();
        util.initialize((rptTpl._doc)?rptTpl._doc:rptTpl);
        return new Promise(function(resolve, reject) {
            if (multiRawData.length > 0) {
                //考虑到工料机的数据还需要再计算，所以还不能直接用，需要每个工程都处理一遍后，再合并
                let tplData = util.assembleData(multiRawData[0]);
                for (let idx = 1; idx < multiRawData.length; idx++) {
                    let tmpData = util.assembleData(multiRawData[idx]);
                    _combineData(tplData, tmpData);
                }
                _createPntPageData(tplData, rptTpl, rpt_params, outputType, (err, pageRst)=>{
                    if (err) {
                        return reject('No data were found!');
                    } else {
                        resolve(pageRst);
                    }
                });
            } else {
                return reject('No data were found!');
            }
        });
    }
    try {
        for (let idx = 0; idx < rpt_ids.length; idx++) {
            rpt_ids[idx] = parseInt(rpt_ids[idx]); //转换一下，以防万一
        }
        let rptTpls = await rptTplFacade.getRptTemplates(rpt_ids);
        let filters = [];
        if (rptTpls.length > 1) {
            rptTpls.sort(function (item1, item2){
                let i1 = (item1._doc)?item1._doc:item1, i2 = (item2._doc)?item2._doc:item2;
                let ID1 = rpt_ids.indexOf(i1[JV.PROP_ID]), ID2 = rpt_ids.indexOf(i2[JV.PROP_ID]);
                return ID1 - ID2;
            });
        }
        let rptDataUtil = new rptDataExtractor();
        for (let rptTpl of rptTpls) {
            rptDataUtil.initialize((rptTpl._doc)?rptTpl._doc:rptTpl);
            filters.push(rptDataUtil.getDataRequestFilter()); // 这里不merge filter了，一个个独立
        }
        let parallelFunctions = [];
        for (let tplIdx = 0; tplIdx < rptTpls.length; tplIdx++) {
            // 不同的项目ID跟着报表模板走（大部分是只有一个项目，汇总类型的表会有多个）
            // let multiRawData = await rptTplDataFacade.prepareMultiProjectData(user_id, prj_ids_arr[tplIdx], filters[tplIdx]);
            let multiRawData = await rptTplDataFacade.prepareMultiProjectDataEx(user_id, prj_ids_arr[tplIdx], filters[tplIdx]);
            parallelFunctions.push(getProjectPageData(rptTpls[tplIdx], prj_ids_arr[tplIdx], multiRawData));
        }
        let rptPageRstArray = await Promise.all(parallelFunctions);
        cb(null, rptPageRstArray);
    } catch (ex) {
        console.log(ex.message);
        cb('Has exception!', null);
    }
}

async function getMultiRptsCommon(user_id, prj_id, rpt_ids, pageSize, orientation, customizeCfg, option, outputType, cb) {
    for (let idx = 0; idx < rpt_ids.length; idx++) {
        rpt_ids[idx] = parseInt(rpt_ids[idx]); //转换一下，以防万一
    }
    let rptTpls = await rptTplFacade.getRptTemplates(rpt_ids);
    
    let rptDataUtil = new rptDataExtractor();
    let filters = [];
    if (rptTpls.length > 1) {
        rptTpls.sort(function (item1, item2){
            let i1 = (item1._doc)?item1._doc:item1, i2 = (item2._doc)?item2._doc:item2;
            let ID1 = rpt_ids.indexOf(i1[JV.PROP_ID]), ID2 = rpt_ids.indexOf(i2[JV.PROP_ID]);
            return ID1 - ID2;
        });
    }
    for (let rptTpl of rptTpls) {
        rptDataUtil.initialize((rptTpl._doc)?rptTpl._doc:rptTpl);
        let filter = rptDataUtil.getDataRequestFilter();
        for (let dtlFilter of filter) {
            if (filters.indexOf(dtlFilter) < 0) {
                filters.push(dtlFilter);
            }
        }
    }
    
    // for (let dtlPrjIds of prj_ids_arr) {
    if (rptTpls) {
        //正常应该根据报表模板定义的数据类型来请求数据
        rptTplDataFacade.prepareProjectData(user_id, prj_id, filters, function (err, msg, rawDataObj) {
            if (!err) {
                try {
                    let rptPageRstArray = [];
                    //1. 这里只用一份数据，根据实际应用情况，只需要保留copy三样数据： bills, ration, ration_glj, projectGLJ
                    let savedBillsData = [], savedRationData = [], savedGljData = [], savedPrjGljData = [], savedFeeRateData = [];
                    if (rpt_ids.length > 1) {
                        for (let dtlData of rawDataObj.prjData) {
                            if (dtlData.moduleName === 'bills') {
                                // Object.assign(savedBillsData, dtlData.data);
                                savedBillsData = JSON.stringify(dtlData.data);
                            } else if (dtlData.moduleName === 'ration') {
                                // Object.assign(savedRationData, dtlData.data);
                                savedRationData = JSON.stringify(dtlData.data);
                            } else if (dtlData.moduleName === 'ration_glj') {
                                // Object.assign(savedGljData, dtlData.data);
                                savedGljData = JSON.stringify(dtlData.data);
                            } else if (dtlData.moduleName === 'feeRate') {
                                Object.assign(savedFeeRateData, dtlData.data._doc.rates);
                            } else if (dtlData.moduleName === 'projectGLJ') {
                                // Object.assign(savedPrjGljData, dtlData.data.gljList);
                                savedPrjGljData = JSON.stringify(dtlData.data.gljList);
                            }
                            // 备注：经测试，feeRate目前只能用assign方式来保存，用JSON方式会报错
                        }
                    }
                    //2. 一个一个模板创建数据
                    for (let tplIdx = 0; tplIdx < rptTpls.length; tplIdx++) {
                        // console.log('tplIdx: ' + tplIdx);
                        let rptTpl = (rptTpls[tplIdx]._doc)?rptTpls[tplIdx]._doc:rptTpls[tplIdx];
                        rptDataUtil.initialize(rptTpl);
                        let tplData = rptDataUtil.assembleData(rawDataObj);
                        let printCom = JpcEx.createNew();
                        rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_PAGE_SIZE] = pageSize;

                        if (pageSize) rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_PAGE_SIZE] = pageSize;
                        if (orientation && (orientation !== 'null')) rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_ORIENTATION] = orientation;
                        let defProperties = rptUtil.getReportDefaultCache();
                        if (customizeCfg) setupCustomizeCfg(customizeCfg, rptTpl, defProperties);
                        let dftOption = option||JV.PAGING_OPTION_NORMAL;

                        printCom.initialize(rptTpl);
                        printCom.analyzeData(rptTpl, tplData, defProperties, dftOption, outputType);
                        let maxPages = printCom.totalPages;
                        let pageRst = null;
                        if (maxPages > 0) {
                            pageRst = printCom.outputAsSimpleJSONPageArray(rptTpl, tplData, 1, maxPages, defProperties, customizeCfg);
                        } else {
                            pageRst = printCom.outputAsPreviewPage(rptTpl, defProperties);
                        }
                        rptPageRstArray.push(pageRst);
                        //注意：这里需要把清单、定额、工料机数据assign回去!!!
                        if (rpt_ids.length > 1) {
                            for (let dtlData of rawDataObj.prjData) {
                                if (dtlData.moduleName === 'bills' && savedBillsData.length > 0) {
                                    // Object.assign(dtlData.data, savedBillsData);
                                    dtlData.data = JSON.parse(savedBillsData);
                                } else if (dtlData.moduleName === 'ration' && savedRationData.length > 0) {
                                    // Object.assign(dtlData.data, savedRationData);
                                    dtlData.data = JSON.parse(savedRationData);
                                } else if (dtlData.moduleName === 'ration_glj' && savedGljData.length > 0) {
                                    // Object.assign(dtlData.data, savedGljData);
                                    dtlData.data = JSON.parse(savedGljData);
                                } else if (dtlData.moduleName === 'feeRate' && savedFeeRateData.length > 0) {
                                    Object.assign(dtlData.data._doc.rates, savedFeeRateData);
                                    // 备注：经测试，feeRate目前只能用assign方式来回滚，用JSON方式会报错
                                } else if (dtlData.moduleName === 'projectGLJ' && savedPrjGljData.length > 0) {
                                    // Object.assign(dtlData.data.gljList, savedPrjGljData);
                                    dtlData.data.gljList = JSON.parse(savedPrjGljData);
                                }
                            }
                        }
                    }
                    cb(null, rptPageRstArray);
                } catch (ex) {
                    console.log("报表数据异常（getMultiRptsCommon）： userId " + user_id + ", project id: " + prj_id);
                    console.log(ex.toString());
                    cb('Exception occurs while on going...', null);
                } finally {
                }
            } else {
                cb('No report data were found!', null);
            }
        })
    }
}

async function getBillsSummaryReportPages(req, user_id, prjIds, rpt_id, pageSize, orientation, customizeCfg, option, outputType, cb) {
    let rptTpl = null;
    let summaryRawDataRst = await rptTplDataFacade.getBudgetSummayDatas(prjIds, req.session.sessionUser.id, req.session.sessionCompilation._id, req.session.sessionCompilation.overWriteUrl);
    rptTpl = await rptTplFacade.getRptTemplate(rpt_id);
    let rptDataUtil = new rptDataExtractor();
    rptDataUtil.initialize((rptTpl._doc)?rptTpl._doc:rptTpl);
    try {
        let tplData = rptDataUtil.assembleData(summaryRawDataRst);
        // fsUtil.writeObjToFile(summaryRawDataRst, "D:/GitHome/Temp/billsSummaryRawDataRstRawData.jsp");
        let printCom = JpcEx.createNew();
        if (pageSize) rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_PAGE_SIZE] = pageSize;
        //console.log("orientation: " + (orientation === 'null'));
        if (orientation && (orientation !== 'null')) rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_ORIENTATION] = orientation;
        let defProperties = rptUtil.getReportDefaultCache();
        if (customizeCfg) setupCustomizeCfg(customizeCfg, rptTpl, defProperties);
        let dftOption = option||JV.PAGING_OPTION_NORMAL;
        printCom.initialize(rptTpl);
        printCom.analyzeData(rptTpl, tplData, defProperties, dftOption, outputType);
        let maxPages = printCom.totalPages;
        let pageRst = null;
        if (maxPages > 0) {
            pageRst = printCom.outputAsSimpleJSONPageArray(rptTpl, tplData, 1, maxPages, defProperties, customizeCfg);
        } else {
            pageRst = printCom.outputAsPreviewPage(rptTpl, defProperties);
        }
        if (pageRst) {
            cb(null, pageRst);
        } else {
            cb('Have errors while on going...', null);
        }
    } catch (ex) {
        console.log("报表数据异常： userId " + user_id + ", project id: " + JSON.stringify(prjIds));
        console.log(ex.message);
        cb('Exception occurs while on going...', null);
    }
}

function getSummaryComboPages(req, user_id, prjIds, billsSummaryRpt_ids, gljSummaryRpt_ids, pageSize, orientation, customizeCfg, option, outputType, cb) {
    let pageRstArr = [];
    let pri_setup_rpt_tpl_data = function (rptTpl, summaryRawDataRst) {
        let rptDataUtil = new rptDataExtractor();
        rptDataUtil.initialize((rptTpl._doc)?rptTpl._doc:rptTpl);
        try {
            let tplData = rptDataUtil.assembleData(summaryRawDataRst);
            let printCom = JpcEx.createNew();
            if (pageSize) rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_PAGE_SIZE] = pageSize;
            if (orientation && (orientation !== 'null')) rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_ORIENTATION] = orientation;
            let defProperties = rptUtil.getReportDefaultCache();
            if (customizeCfg) setupCustomizeCfg(customizeCfg, rptTpl, defProperties);
            let dftOption = option||JV.PAGING_OPTION_NORMAL;
            printCom.initialize(rptTpl);
            printCom.analyzeData(rptTpl, tplData, defProperties, dftOption, outputType);
            let maxPages = printCom.totalPages;
            let pageRst = null;
            if (maxPages > 0) {
                pageRst = printCom.outputAsSimpleJSONPageArray(rptTpl, tplData, 1, maxPages, defProperties, customizeCfg);
            } else {
                pageRst = printCom.outputAsPreviewPage(rptTpl, defProperties);
            }
            pageRstArr.push(pageRst);
        } catch (ex) {
            console.log("Summary报表数据异常： userId " + user_id + ", project ids: " + prjIds);
            console.log(ex.message);
        }
    };

    let billRpts = [], gljRpts = [];
    rptTplFacade.getRptTemplates(billsSummaryRpt_ids.concat(gljSummaryRpt_ids)).then(function(rptTpls) {
        if (rptTpls && rptTpls.length > 0) {
            for (let rptTpl of rptTpls) {
                if (billsSummaryRpt_ids.indexOf(rptTpl.ID) >= 0) {
                    billRpts.push(rptTpl);
                } else if (gljSummaryRpt_ids.indexOf(rptTpl.ID) >= 0) {
                    gljRpts.push(rptTpl);
                }
            }
        }
        if (billRpts.length > 0) {
            rptTplDataFacade.getBudgetSummayDatas(prjIds, req.session.sessionUser.id, req.session.sessionCompilation._id, req.session.sessionCompilation.overWriteUrl).then(function(summaryRawDataRst) {
                // let savedBillsData = [];
                try {
                    // Object.assign(savedBillsData, summaryRawDataRst.SummaryAuditDetail);
                    for (let idx = 0; idx < billRpts.length; idx++) {
                        pri_setup_rpt_tpl_data(billRpts[idx], summaryRawDataRst);
                        // if (idx < billRpts.length - 1) {
                        //     Object.assign(summaryRawDataRst.SummaryAuditDetail, savedBillsData);
                        // }
                    }
                    if (gljRpts && gljRpts.length > 0) {
                        rptTplDataFacade.getGLJSummayDatas(prjIds).then(function(summaryRawDataRst) {
                            // let savedBillsData = [];
                            // Object.assign(savedBillsData, summaryRawDataRst.SummaryAuditDetail);
                            for (let idx = 0; idx < gljRpts.length; idx++) {
                                pri_setup_rpt_tpl_data(gljRpts[idx], summaryRawDataRst);
                                // if (idx < gljRpts.length - 1) {
                                //     Object.assign(summaryRawDataRst.SummaryAuditDetail, savedBillsData);
                                // }
                            }
                            cb(null, pageRstArr);
                        });
                    } else {
                        cb(null, pageRstArr);
                    }
                } catch (ex) {
                    console.log(ex);
                    cb(null, pageRstArr);
                }
            });
        } else if (gljRpts.length > 0) {
            rptTplDataFacade.getGLJSummayDatas(prjIds).then(function(summaryRawDataRst) {
                // let savedBillsData = [];
                // Object.assign(savedBillsData, summaryRawDataRst.SummaryAuditDetail);
                // 养护工料机汇总不用考虑back up问题。模板需要自觉一点，不要修改数据！！！
                for (let idx = 0; idx < gljRpts.length; idx++) {
                    pri_setup_rpt_tpl_data(gljRpts[idx], summaryRawDataRst);
                    if (idx < gljRpts.length - 1) {
                        // Object.assign(summaryRawDataRst.SummaryAuditDetail, savedBillsData);
                    }
                }
                cb(null, pageRstArr);
            });
        }
    });
}

async function getGljSummaryReportPages(user_id, prjIds, rpt_id, pageSize, orientation, customizeCfg, option, outputType, compilationName, cb) {
    let summaryRawDataRst = await rptTplDataFacade.getGLJSummayDatas(prjIds, compilationName);
    let rptTpl = await rptTplFacade.getRptTemplate(rpt_id);
    let rptDataUtil = new rptDataExtractor();
    rptDataUtil.initialize((rptTpl._doc)?rptTpl._doc:rptTpl);
    try {
        // fsUtil.writeObjToFile(summaryRawDataRst, "D:/GitHome/temp/gljSummaryRawDataRstRawData.jsp");
        let tplData = rptDataUtil.assembleData(summaryRawDataRst);
        let printCom = JpcEx.createNew();
        if (pageSize) rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_PAGE_SIZE] = pageSize;
        //console.log("orientation: " + (orientation === 'null'));
        if (orientation && (orientation !== 'null')) rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_ORIENTATION] = orientation;
        let defProperties = rptUtil.getReportDefaultCache();
        if (customizeCfg) setupCustomizeCfg(customizeCfg, rptTpl, defProperties);
        let dftOption = option||JV.PAGING_OPTION_NORMAL;
        printCom.initialize(rptTpl);
        printCom.analyzeData(rptTpl, tplData, defProperties, dftOption, outputType);
        let maxPages = printCom.totalPages;
        let pageRst = null;
        if (maxPages > 0) {
            pageRst = printCom.outputAsSimpleJSONPageArray(rptTpl, tplData, 1, maxPages, defProperties, customizeCfg);
        } else {
            pageRst = printCom.outputAsPreviewPage(rptTpl, defProperties);
        }
        if (pageRst) {
            cb(null, pageRst);
        } else {
            cb('Have errors while on going...', null);
        }
    } catch (ex) {
        // console.log("报表数据异常： userId " + user_id + ", project id: " + prj_id);
        console.log(ex);
        cb('Exception occurs while on going...', null);
    }
}

module.exports = {
    getReportAllPages: async function (req, res) {
        let params = JSON.parse(req.body.params);
        let user_id = req.session.sessionUser.id;
        if (!params.hasOwnProperty('prj_ids')) {
            params.prj_ids = [params.prj_id];
        }
        // console.log(params);
        getAllPagesForOneRptCommonEx(user_id, params, JV.OUTPUT_TYPE_NORMAL, function (err, pageRst) {
            callback(req, res, err, pageRst);
        });
    },
    getMultiReportsEx: function (req, res) {
        //原则说明：把所有报表模板集中获取，统一filter，只读一次数据！
        let params = JSON.parse(req.body.params),
            prj_id = params.prj_id,
            rpt_ids = params.rpt_ids,
            prj_ids_arr = params.prj_ids_arr,
            //--以下是汇总类数据----------
            rpt_bill_tpl_ids = params.rpt_bill_tpl_ids,
            rpt_glj_tpl_ids = params.rpt_glj_tpl_ids,
            prjIds = params.prjIds,
            //------------
            pageSize = params.pageSize,
            orientation = params.orientation,
            customizeCfg = params.custCfg,
            option = params.option;
        let user_id = req.session.sessionUser.id;
        let dftOption = option||JV.PAGING_OPTION_NORMAL;
        if (rpt_ids && rpt_ids.length > 0) {
            getMultiRptsCommonEx(user_id, prj_ids_arr, rpt_ids, pageSize, orientation, customizeCfg, dftOption, JV.OUTPUT_TYPE_PDF, function (err, rptPageRstArray) {
            // getMultiRptsCommon(user_id, prj_id, rpt_ids, pageSize, orientation, customizeCfg, dftOption, JV.OUTPUT_TYPE_PDF, function (err, rptPageRstArray) {
                if (err) {
                    callback(req, res, '数据有误', null);
                } else {
                    if ((rpt_bill_tpl_ids && rpt_bill_tpl_ids.length > 0) || (rpt_glj_tpl_ids && rpt_glj_tpl_ids.length > 0)) {
                        getSummaryComboPages(req, user_id, prjIds, rpt_bill_tpl_ids, rpt_glj_tpl_ids, pageSize, orientation, customizeCfg, option, JV.OUTPUT_TYPE_NORMAL, function (err, rptSumPageRstArray) {
                            callback(req, res, err, rptSumPageRstArray.concat(rptPageRstArray));
                        });
                    } else {
                        callback(req, res, err, rptPageRstArray);
                    }
                }
            });
        } else if ((rpt_bill_tpl_ids && rpt_bill_tpl_ids.length > 0) || (rpt_glj_tpl_ids && rpt_glj_tpl_ids.length > 0)) {
            getSummaryComboPages(req, user_id, prjIds, rpt_bill_tpl_ids, rpt_glj_tpl_ids, pageSize, orientation, customizeCfg, option, JV.OUTPUT_TYPE_NORMAL, function (err, rptSumPageRstArray) {
                callback(req, res, err, rptSumPageRstArray);
            });
        }
    },

    getBillSummaryReportPages: async function (req, res) {
        let params = JSON.parse(req.body.params),
            rpt_id = params.rpt_tpl_id,
            prjIds = params.prjIds,
            pageSize = params.pageSize,
            orientation = params.orientation,
            customizeCfg = params.custCfg
        ;
        let user_id = req.session.sessionUser.id;
        getBillsSummaryReportPages(req, user_id, prjIds, rpt_id, pageSize, orientation, customizeCfg, null, JV.OUTPUT_TYPE_NORMAL, function (err, pageRst) {
            callback(req, res, err, pageRst);
        });
    },

    getGljSummaryReportPages: function (req, res) {
        let params = JSON.parse(req.body.params),
            rpt_id = params.rpt_tpl_id,
            prjIds = params.prjIds,
            pageSize = params.pageSize,
            orientation = params.orientation,
            customizeCfg = params.custCfg
        ;
        let user_id = req.session.sessionUser.id;
        const compilationName = req.session.sessionCompilation.name;
        getGljSummaryReportPages(user_id, prjIds, rpt_id, pageSize, orientation, customizeCfg, null, JV.OUTPUT_TYPE_NORMAL, compilationName, function (err, pageRst) {
            callback(req, res, err, pageRst);
        });
    },

    createExcelFilesInOneBookEx: function (req, res) {
        //采用了优化策略
        let params = JSON.parse(req.body.params),
            prj_id = params.prj_id,
            rpt_ids = params.rpt_ids,
            prj_ids_arr = params.prj_ids_arr,
            //--以下是汇总类数据----------
            rpt_bill_tpl_ids = params.rpt_bill_tpl_ids,
            rpt_glj_tpl_ids = params.rpt_glj_tpl_ids,
            prjIds = params.prjIds,
            //------------
            rptName = params.rptName,
            pageSize = params.pageSize,
            orientation = params.orientation,
            customizeCfg = params.custCfg,
            option = params.option;
        let user_id = req.session.sessionUser.id;
        let dftOption = option||JV.PAGING_OPTION_NORMAL;

        if (rpt_ids && rpt_ids.length > 0) {
            getMultiRptsCommonEx(user_id, prj_ids_arr, rpt_ids, pageSize, orientation, customizeCfg, dftOption, JV.OUTPUT_TYPE_PDF, function (err, rptPageRstArray) {
            // getMultiRptsCommon(user_id, prj_id, rpt_ids, pageSize, orientation, customizeCfg, dftOption, JV.OUTPUT_TYPE_NORMAL, function (err, rptPageRstArray) {
                if(err){
                    console.log(`导出Excel错误(生成数据过程错误), userId: ${user_id}, prjId: ${prj_id}`);
                    console.log(err);
                    callback(req, res, '数据有误', null);
                } else {
                    if ((rpt_bill_tpl_ids && rpt_bill_tpl_ids.length > 0) || (rpt_glj_tpl_ids && rpt_glj_tpl_ids.length > 0)) {
                        getSummaryComboPages(req, user_id, prjIds, rpt_bill_tpl_ids, rpt_glj_tpl_ids, pageSize, orientation, customizeCfg, option, JV.OUTPUT_TYPE_NORMAL, function (err, rptSumPageRstArray) {
                            rpt_xl_util.exportExcelInOneBook(rptPageRstArray.concat(rptSumPageRstArray), pageSize, rptName, function(uuidName){
                                let fileRst = {uuid: uuidName, reportName: rptName};
                                callback(req, res, err, fileRst);
                            });
                        });
                    } else {
                        rpt_xl_util.exportExcelInOneBook(rptPageRstArray, pageSize, rptName, function(uuidName){
                            let fileRst = {uuid: uuidName, reportName: rptName};
                            callback(req, res, err, fileRst);
                        });
                    }
                }
            });
        } else if ((rpt_bill_tpl_ids && rpt_bill_tpl_ids.length > 0) || (rpt_glj_tpl_ids && rpt_glj_tpl_ids.length > 0)) {
            getSummaryComboPages(req, user_id, prjIds, rpt_bill_tpl_ids, rpt_glj_tpl_ids, pageSize, orientation, customizeCfg, option, JV.OUTPUT_TYPE_NORMAL, function (err, rptPageRstArray) {
                rpt_xl_util.exportExcelInOneBook(rptPageRstArray, pageSize, rptName, function(uuidName){
                    let fileRst = {uuid: uuidName, reportName: rptName};
                    callback(req, res, err, fileRst);
                });
            });
        }
    },

    createExcelFilesEx: function (req, res) {
        let params = JSON.parse(req.body.params),
            prj_id = params.prj_id,
            rpt_ids = params.rpt_ids,
            prj_ids_arr = params.prj_ids_arr,
            //--以下是汇总类数据----------
            rpt_bill_tpl_ids = params.rpt_bill_tpl_ids,
            rpt_glj_tpl_ids = params.rpt_glj_tpl_ids,
            prjIds = params.prjIds,
            sum_rpt_names = params.sum_rpt_names,
            //------------
            rpt_names = params.rpt_names,
            pageSize = params.pageSize,
            orientation = params.orientation,
            isOneSheet = params.isOneSheet,
            customizeCfg = params.custCfg,
            option = params.option;
        let user_id = req.session.sessionUser.id;
        let dftOption = option||JV.PAGING_OPTION_NORMAL;
        let pri_Add_Parallel_Functions = function (parallelFunctions, rptPageRstArray, paraRptNames, err) {
            for (let idx = 0; idx < rptPageRstArray.length; idx++) {
                parallelFunctions.push((function (pageRst, rpt_name) {
                    return function (cb) {
                        rpt_xl_util.exportExcel(pageRst, pageSize, rpt_name, isOneSheet, null, null, function(uuidName){
                            let fileRst = {uuid: uuidName, reportName: rpt_name};
                            cb(err, fileRst);
                        })
                    };
                })(rptPageRstArray[idx], paraRptNames[idx]));
            }
        };
        let pri_Run_Parallel_Functions = function (parallelFunctions) {
            async.parallel(parallelFunctions, function (err, fileRstArray) {
                if (err) {
                    console.log(`导出Excel错误(生成数据过程错误), userId: ${user_id}, prjId: ${prj_id}`);
                    console.log(err);
                    callback(req, res, '数据导出错误', null);
                } else {
                    // console.log(err);
                    callback(req, res, err, fileRstArray);
                }
            });
        };
        if (rpt_ids && rpt_ids.length > 0) {
            getMultiRptsCommonEx(user_id, prj_ids_arr, rpt_ids, pageSize, orientation, customizeCfg, dftOption, JV.OUTPUT_TYPE_PDF, function (err, rptPageRstArray) {
            // getMultiRptsCommon(user_id, prj_id, rpt_ids, pageSize, orientation, customizeCfg, dftOption, JV.OUTPUT_TYPE_NORMAL, function (err, rptPageRstArray) {
                if (err) {
                    console.log(`导出Excel错误(生成数据过程错误), userId: ${user_id}, prjId: ${prj_id}`);
                    console.log(err);
                    callback(req, res, '数据生成错误', null);
                } else {
                    if ((rpt_bill_tpl_ids && rpt_bill_tpl_ids.length > 0) || (rpt_glj_tpl_ids && rpt_glj_tpl_ids.length > 0)) {
                        getSummaryComboPages(req, user_id, prjIds, rpt_bill_tpl_ids, rpt_glj_tpl_ids, pageSize, orientation, customizeCfg, option, JV.OUTPUT_TYPE_NORMAL, function (err, rptSumPageRstArray) {
                            let parallelFunctions = [];
                            pri_Add_Parallel_Functions(parallelFunctions, rptPageRstArray, rpt_names, err);
                            pri_Add_Parallel_Functions(parallelFunctions, rptSumPageRstArray, sum_rpt_names, err);
                            pri_Run_Parallel_Functions(parallelFunctions);
                        });
                    } else {
                        let parallelFunctions = [];
                        pri_Add_Parallel_Functions(parallelFunctions, rptPageRstArray, rpt_names, err);
                        pri_Run_Parallel_Functions(parallelFunctions);
                    }
                }
            });
        } else if ((rpt_bill_tpl_ids && rpt_bill_tpl_ids.length > 0) || (rpt_glj_tpl_ids && rpt_glj_tpl_ids.length > 0)) {
            // console.log('rpt_bill_tpl_ids:');
            // console.log(rpt_bill_tpl_ids);
            // console.log('rpt_glj_tpl_ids:');
            // console.log(rpt_glj_tpl_ids);
            getSummaryComboPages(req, user_id, prjIds, rpt_bill_tpl_ids, rpt_glj_tpl_ids, pageSize, orientation, customizeCfg, option, JV.OUTPUT_TYPE_NORMAL, function (err, rptSumPageRstArray) {
                let parallelFunctions = [];
                pri_Add_Parallel_Functions(parallelFunctions, rptSumPageRstArray, sum_rpt_names, err);
                pri_Run_Parallel_Functions(parallelFunctions);
            });
        }
    },
    getFileByUUID: function (req, res) {
        let uuid = req.params.uuid,
            rptName = req.params.rptName,
            suffix = "." + req.params.suffix
        ;
        // let user_id = req.session.sessionUser.id; //未来要校验user id
        try {
            res.setHeader('Content-Type', 'application/vnd.openxmlformats');
            let rptNameURI = encodeURI(rptName);
            res.setHeader("Content-Disposition", "attachment; filename=\"" + rptNameURI + suffix + "\"; filename*=utf-8''" + rptNameURI + suffix );
            let filestream = fs.createReadStream(__dirname.slice(0, __dirname.length - 28) + '/tmp/' + uuid + suffix);
            filestream.on('data', function(chunk) {
                res.write(chunk);
            });
            filestream.on('end', function() {
                res.end();
            });
        } catch (e) {
            console.log(e);
        }
    },
    getExcel: function(req, res) {
        let prj_id = req.params.prj_id,
            rpt_id = req.params.rpt_id,
            pageSize = req.params.size,
            orientation = req.params.orientation,
            rptName = req.params.rptName,
            isOneSheet = req.params.isOneSheet,
            option = req.params.option
        ;
        let customizeCfg = null;
        let user_id = req.session.sessionUser.id;
        let dftOption = option||JV.PAGING_OPTION_NORMAL;
        getAllPagesCommon(user_id, prj_id, rpt_id, pageSize, orientation, customizeCfg, dftOption, JV.OUTPUT_TYPE_EXCEL, function(err, pageRst){
            try {
                rpt_xl_util.exportExcel(pageRst, pageSize, rptName, isOneSheet, null, null, function(uuidName){
                    res.setHeader('Content-Type', 'application/vnd.openxmlformats');
                    let rptNameURI = encodeURI(rptName);
                    res.setHeader("Content-Disposition", "attachment; filename=\"" + rptNameURI + ".xlsx\"; filename*=utf-8''" + rptNameURI + '.xlsx' );
                    let filestream = fs.createReadStream(__dirname.slice(0, __dirname.length - 28) + '/tmp/' + uuidName + '.xlsx');
                    filestream.on('data', function(chunk) {
                        res.write(chunk);
                    });
                    filestream.on('end', function() {
                        res.end();
                    });
                });
            } catch (e) {
                console.log(e);
            }
        })
    },
    getExcelInOneBook: function (req, res) {
        let prj_id = req.params.prj_id,
            rpt_ids = req.params.rpt_ids.split(','),
            pageSize = req.params.size,
            rptName = req.params.rptName,
            option = req.params.option;
        let user_id = req.session.sessionUser.id;
        let parallelFunctions = [];
        let dftOption = option||JV.PAGING_OPTION_NORMAL;
        for (let id of rpt_ids) {
            parallelFunctions.push((function (rpt_id) {
                return function (cb) {
                    getAllPagesCommon(user_id, prj_id, rpt_id, pageSize, null, null, dftOption, JV.OUTPUT_TYPE_EXCEL, function (err, pageRst) {
                        if(err){
                            cb(err);
                        }
                        else{
                            cb(null, pageRst);
                        }
                    })
                }
            })(parseInt(id)));
        }
        async.parallel(parallelFunctions, function (err, pageRstArray) {
            if (err) {
                callback(req, res, '数据有误', null);
            } else {
                rpt_xl_util.exportExcelInOneBook(pageRstArray, pageSize, rptName, function(tmpFilePath){
                    res.setHeader('Content-Type', 'application/vnd.openxmlformats');
                    let rptNameURI = encodeURI(rptName);
                    res.setHeader("Content-Disposition", "attachment; filename=\"" + rptNameURI + ".xlsx\"; filename*=utf-8''" + rptNameURI + '.xlsx');
                    let filestream = fs.createReadStream(__dirname.slice(0, __dirname.length - 28) + '/tmp/' + tmpFilePath + '.xlsx');
                    filestream.on('data', function(chunk) {
                        res.write(chunk);
                    });
                    filestream.on('end', function() {
                        res.end();
                    });
                });
            }
        })
    },
    createPdfFilesEx: function (req, res) {
        let params = JSON.parse(req.body.params),
            prj_id = params.prj_id,
            prj_ids_arr = params.prj_ids_arr,
            rpt_ids = params.rpt_ids,
            rpt_names = params.rpt_names,
            //--以下是汇总类数据----------
            rpt_bill_tpl_ids = params.rpt_bill_tpl_ids,
            rpt_glj_tpl_ids = params.rpt_glj_tpl_ids,
            prjIds = params.prjIds,
            sum_rpt_names = params.sum_rpt_names,
            //------------
            pageSize = params.pageSize,
            orientation = params.orientation,
            customizeCfg = params.custCfg,
            option = params.option;
        let user_id = req.session.sessionUser.id;
        let dftOption = option||JV.PAGING_OPTION_NORMAL;
        console.log('start!');
        let pri_Add_Parallel_Functions = function (parallelFunctions, rptPageRstArray, paraRptNames, err) {
            for (let idx = 0; idx < rptPageRstArray.length; idx++) {
                parallelFunctions.push((function (pageRst, rpt_name) {
                    return function (cb) {
                        rpt_pdf_util.export_pdf_file(pageRst, pageSize, rpt_name, function(uuidName){
                            let fileRst = {uuid: uuidName, reportName: rpt_name};
                            cb(err, fileRst);
                        })
                    };
                })(rptPageRstArray[idx], paraRptNames[idx]));
            }
        };
        let pri_Run_Parallel_Functions = function (parallelFunctions) {
            async.parallel(parallelFunctions, function (err, fileRstArray) {
                if (err) {
                    console.log('导出PDF错误（生成数据过程错误）, userId: ' + user_id + ', prjId' + prj_id);
                    callback(req, res, '数据导出错误', null);
                } else {
                    // console.log(err);
                    callback(req, res, err, fileRstArray);
                }
            });
        };
        if (rpt_ids && rpt_ids.length > 0) {
            console.log(0);
            getMultiRptsCommon(user_id, prj_id, rpt_ids, pageSize, orientation, customizeCfg, dftOption, JV.OUTPUT_TYPE_PDF, function (err, rptPageRstArray) {
                if (err) {
                    console.log('导出Excel错误(生成数据过程错误), userId: ' + user_id + ', prjId' + prj_id);
                    console.log(err);
                    callback(req, res, '数据生成错误', null);
                } else {
                    if ((rpt_bill_tpl_ids && rpt_bill_tpl_ids.length > 0) || (rpt_glj_tpl_ids && rpt_glj_tpl_ids.length > 0)) {
                        console.log(1);
                        getSummaryComboPages(req, user_id, prjIds, rpt_bill_tpl_ids, rpt_glj_tpl_ids, pageSize, orientation, customizeCfg, option, JV.OUTPUT_TYPE_NORMAL, function (err, rptSumPageRstArray) {
                            let parallelFunctions = [];
                            console.log(2);
                            pri_Add_Parallel_Functions(parallelFunctions, rptPageRstArray, rpt_names, err);
                            pri_Add_Parallel_Functions(parallelFunctions, rptSumPageRstArray, sum_rpt_names, err);
                            pri_Run_Parallel_Functions(parallelFunctions);
                        });
                    } else {
                        console.log(3);
                        let parallelFunctions = [];
                        pri_Add_Parallel_Functions(parallelFunctions, rptPageRstArray, rpt_names, err);
                        pri_Run_Parallel_Functions(parallelFunctions);
                    }
                }
            });
        } else if ((rpt_bill_tpl_ids && rpt_bill_tpl_ids.length > 0) || (rpt_glj_tpl_ids && rpt_glj_tpl_ids.length > 0)) {
            console.log(10);
            getSummaryComboPages(req, user_id, prjIds, rpt_bill_tpl_ids, rpt_glj_tpl_ids, pageSize, orientation, customizeCfg, option, JV.OUTPUT_TYPE_NORMAL, function (err, rptSumPageRstArray) {
                let parallelFunctions = [];
                pri_Add_Parallel_Functions(parallelFunctions, rptSumPageRstArray, sum_rpt_names, err);
                pri_Run_Parallel_Functions(parallelFunctions);
            });
        }
    },
    getPDF:function (req, res) {
        let prj_id = req.params.prj_id,
            rpt_id = req.params.rpt_id,
            pageSize = req.params.size,
            orientation = req.params.orientation,
            rptName = req.params.rptName
        ;
        let user_id = req.session.sessionUser.id;
        getAllPagesCommon(user_id, prj_id, rpt_id, pageSize, orientation, null, JV.PAGING_OPTION_NORMAL, JV.OUTPUT_TYPE_PDF, function(err, pageRst){
            rpt_pdf_util.export_pdf_file(pageRst, pageSize, rptName,function (uuidName) {
                res.setHeader('Content-Type', 'application/vnd.openxmlformats');
                // res.setHeader("Content-Disposition", "attachment; filename=" + strUtil.getPinYinCamelChars(rptName) + ".pdf");
                let rptNameURI = encodeURI(rptName);
                res.setHeader("Content-Disposition", "attachment; filename=\"" + rptNameURI + ".pdf\"; filename*=utf-8''" + rptNameURI + ".pdf" );

                let filestream = fs.createReadStream(__dirname.slice(0, __dirname.length - 28) + '/tmp/' + uuidName + '.pdf');
                filestream.on('data', function(chunk) {
                    res.write(chunk);
                });
                filestream.on('end', function() {
                    res.end();
                });
            })

        })

    }

};