页面历史

/**
 * 当是导出excel时，将城市的参数值设为所有城市，这样导出的数据才是全部城市的数据
 * */
function main(spreadsheetReport) {
    if (spreadsheetReport.exportMenu) {
        spreadsheetReport.exportMenu.onCloseUp.unsubscribe(spreadsheetReport.doExportMenuCloseUp, spreadsheetReport);
    }
    //重写doExportMenuCloseUp方法，添加标示
    spreadsheetReport.doExportMenuCloseUp_old0224 = spreadsheetReport.doExportMenuCloseUp;
    spreadsheetReport.doExportMenuCloseUp = function(exportType) {
            //debugger;
            this.exportZhi = "EXCEL2007";
            this.doExportMenuCloseUp_old0224(exportType);
        }
        //重新注册新的事件
    if (spreadsheetReport.exportMenu) {
        spreadsheetReport.exportMenu.onCloseUp.subscribe(spreadsheetReport.doExportMenuCloseUp, spreadsheetReport);
    }
    //重写buildParamsInfo，组合参数
    spreadsheetReport._old_buildParamsInfo = spreadsheetReport.buildParamsInfo;
    spreadsheetReport.buildParamsInfo = function(fromButton) {
        //debugger;
        if (!this.params) return null;
        var ps = this._old_buildParamsInfo(fromButton);
        if (!ps) return;
        for (var i = 0; i < ps.length; i++) {
            //拼参数值，将多个参数传给服务端
            if (this.exportZhi == "EXCEL2007" && ps[i].name == "发货城市") {
                var id = ps[i].id;
                var parameterPanelId = this.paramPanelObj.clientId;
                var a = this.paramPanelObj.getParamStandbyValue(id, parameterPanelId);
                var val = "";
                var disVal = "";
                for (var j = 0; j < a.length; j++) {
                    val += "," + a[j][0];
                    disVal += "," + a[j][1];
                };
                val = val.substring(1);
                disVal = disVal.substring(1);
                ps[i] = {
                    id: ps[i].id,
                    name: ps[i].name,
                    value: val,
                    displayValue: disVal
                }
            }
        }
        this.exportZhi = null;
        return ps;
    }
}

/**
*执行逻辑：
* 1，根据城市参数，将每个城市创建一个sheet，并且获取其在原始报表中的起始/结束行
* 2，原始报表sheet内容copy到目标城市所在sheet，并删除初目标城市之外的数据
*/
function main(spreadsheetReport) {
    spreadsheetReport.cacheable = false;
	//判断导出类型是否为Excel
    if (spreadsheetReport.outputType != "EXCEL2007") return;
    var cells = spreadsheetReport.workbook.worksheets.get(0).cells;
    var sourWorkbook = spreadsheetReport.workbook.worksheets.get(0);
    var rows = cells.rows.count;
    var columns = cells.getMaxDataColumn();
    var paras = spreadsheetReport.getParameterDisplayValue("发货城市");
    //logger.debug("参数：" + paras);
    var vals = paras.split(",");
    var worksheets = spreadsheetReport.workbook.worksheets;
    if (vals.length > 0) {
        for (var i = 0; i < vals.length; i++) {
            var target_worksheet = worksheets.add(vals[i].replace('\'', '').replace('\'', ''));
            var startRowNum = 0;
            var endRowNum = 0;
            var arr = new Array();
            for (var j = 0; j < rows; j++) {
                for (var k = 0; k < columns; k++) {
                    if(endRowNum > 0){
                        break;
                    }
                    var cell2 = worksheets.get(0).cells.getCell(j, k);
                    if (!cell2.getValue()) {
                        continue;
                    }
                    if (cell2.getValue()) {
                        var val = cell2.getValue();
                        var val2 = vals[i];
                        for (var n = 0; n < vals.length; n++) {
                            if (arr.length <1 && val == vals[n]) {
                                //所有分组的起始位置,便于拿到第一个分组的起始位置;
                                arr.push(j);
                                break;
                            }
                        }
                        //获取指定城市名的起始行
                        if ((val == val2)) {
                            startRowNum = j;
                            var cell = spreadsheetReport.sheets[0].getCell(j, k);
                            var range = worksheets.get(0).cells.get(cell.getCellPosition()).mergedRange;
                            if (range && range.getRowCount() > 1) {
                                endRowNum = j + range.getRowCount();
                            } else {
                                endRowNum = j + 1;
                            }
                            break;
                        }
                        
                    }
                }
            }
   //