ConstructionCost/web/building_saas/main/js/views/project_view.js

/**
 * Created by Mai on 2017/6/21.
 */

var projectObj = {
    project: null,
    mainSpread: null,
    mainController: null,
    gljSpreed:null,
    beforeMainTreeSelectedChange: function (node) {
        /*if (node) {
            subViewObj.saveComments(node);
        }*/
    },
    treeSelectedChanged: function (node) {
        let project = projectObj.project;
        subViewObj.loadComments(node);
        gljOprObj.showDataIfRationSelect(node);

        // CSL.2017.07.25
        if (activeSubSheetIs(subSheetIndex.ssiCalcProgram)) {
            calcProgramObj.showData(node);
        };
        //zhong 2017-9-1 特征及内容
        if(pageCCOprObj.active){
            pageCCOprObj.mainActiveCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];//mainSpread焦点单元格
            if(node.sourceType === project.Bills.getSourceType()){
                pageCCOprObj.setCacheAndShow(node);
            }
            else{
                pageCCOprObj.clearData();
            }
        }
    },
    refreshBaseActn: function (tree) {
        let setButtonValid = function (valid, btn) {
            if (valid) {
                btn.removeClass('disabled');
            } else {
                btn.addClass('disabled');
            }
        };
        let selected = tree.selected, that = projectObj;
        let canUpLevel = function (node) {
            if (selected && selected.depth() > 0 && selected.canUpLevel()) {
                if (selected.sourceType === that.project.Bills.getSourceType()) {
                    return (!selected.nextSibling) || (selected.children.length === 0) || (selected.source.children.length > 0);
                } else {
                    return false;
                }
            } else {
                return false;
            }
        };
        let canDownLevel = function (node) {
            if (selected && selected.depth() > 0 && selected.canDownLevel()) {
                if (selected.sourceType === that.project.Bills.getSourceType()) {
                    return (selected.preSibling.children.length === 0) || (selected.preSibling.source.children.length > 0);
                } else {
                    return false;
                }
            } else {
                return false;
            }
        };
        let canDelete = function (node) {
            if (selected) {
                if (selected.sourceType === that.project.Bills.getSourceType()) {
                    return !(selected.data.flagsIndex && selected.data.flagsIndex.fixed && selected.data.flagsIndex.fixed.flag > 0);
                } else {
                    return true;
                }
            } else {
                return false;
            }
        };
        setButtonValid(canUpLevel(selected), $('#upLevel'));
        setButtonValid(canDownLevel(selected), $('#downLevel'));
        setButtonValid(selected && (selected.depth() > 0) && selected.canUpMove(), $('#upMove'));
        setButtonValid(selected && (selected.depth() > 0) && selected.canDownMove(), $('#downMove'));
        setButtonValid(canDelete(selected), $('#delete'));
    },
    checkCommonField: function (editingText, colSetting) {
        let value;
        if (colSetting.data.decimal) {
            value = Number(editingText);
            if (number_util.isNumber(value)) {
                if (colSetting.data.decimal) {
                    value = value.toDecimal(colSetting.data.decimal);
                }
            } else {
                value = null;
                alert('当前输入的数据类型不正确，请重新输入。');
            }
        } else {
            value = editingText;
        }
        return value;
    },
    checkFormulaValidField: function (editingText, colSetting) {
        let value = Number(editingText);
        if (!value) {
            try {
                let exp = new Expression('');
                exp.Expression(editingText);
                value = Number(exp.Evaluate());
            } catch (error) {
                value = null;
            }
        }
        if (value!=undefined||value!=null) {
            if (colSetting.data.decimal) {
                value = value.toDecimal(colSetting.data.decimal);   
            }
        } else if (editingText && editingText !== '') {
            value = null;
            alert('当前输入的数据类型不正确，请重新输入。');
        }
        return value;
    },
    checkSpreadEditingText: function (editingText, colSetting) {
        if (colSetting.data.field === 'quantity') {
            return this.checkFormulaValidField(editingText, colSetting);
        }
        else if (colSetting.data.field === 'programID') {
            return this.project.calcProgram.compiledTemplateMaps[editingText];
        }
        else if (colSetting.data.field === 'subType') {
            if (typeof(editingText) !== "number")
                return volumePriceMaps[editingText]
            else
                return editingText;
        }
        else {
            return this.checkCommonField(editingText, colSetting);
        }
    },
    /*updateAndReCalculate: function (node, fieldName, value) {
        let project = projectObj.project, calc = new BillsCalcHelper(project), nodes = [];
        let getNodes = function (node) {
            let cur = node, nodes = [];
            while (cur) {
                nodes.push(cur);
                cur = cur.parent;
            }
            return nodes;
        }
        if (value) {
            value = value.toDecimal(projectObj.project.Decimal.common.quantity);
        }
        if (node.sourceType === projectObj.project.Bills.getSourceType()) {
            calcFees.setFee(node.data, fieldName, value);
            calc.calcNode(node, true);
            nodes = getNodes(node);
            project.Bills.updateNodes(nodes, true);
        }
        else if (node.sourceType === projectObj.project.VolumePrice.getSourceType()) {
            project.beginUpdate('VolumePrice_QuantityChange');
            project.VolumePrice.updateField(node.source, fieldName, value, false);
            calc.calcNode(node.parent, true);
            nodes = getNodes(node.parent);
            project.Bills.updateNodes(nodes, false);
            project.endUpdate();
            nodes.push(node);
        }
        else if (node.sourceType === projectObj.project.Ration.getSourceType()) {
            project.beginUpdate('Ration_QuantityChange');
            calcFees.setFee(node.data, fieldName, value);
            node.data.gljList = project.ration_glj.getGljArrByRation(node.data.ID);
            // calcProgram.calculate的传参必须是cacheNode类型，故无法将计算放在Ration模块中。
            project.calcProgram.calculate(node);
            project.Ration.updateRation(node.source, false);    // 加入待存储队列
            calc.calcNode(node.parent, true);       //
            nodes = getNodes(node.parent);
            project.Bills.updateNodes(nodes, false);
            project.endUpdate();
            nodes.push(node);
        }
        this.mainController.refreshTreeNode(nodes, false);
        calc = null;
    },*/
    updateBillsCode: function (node, value) {
        let project = projectObj.project;
        let stdMatchCode, formatCode, matchs;
        let searchStdBillsAndUpdate = function (stdCode, formatCode) {
            let orgCode = node.data.code.substr(0, 9);
            if (stdCode === orgCode || projectInfoObj.projectInfo.engineeringInfo.bill_lib.length === 0) {
                project.Bills.updateField(node.source, 'code', formatCode, true);
                projectObj.mainController.refreshTreeNode([node], false);
            } else if (projectInfoObj.projectInfo.engineeringInfo.bill_lib.length > 0) {
                let libId = projectInfoObj.projectInfo.engineeringInfo.bill_lib[0].id;
                CommonAjax.post('/stdBillsEditor/getStdBillsByCode', {userId: userID, billsLibId: libId, code: stdCode}, function (data) {
                    if (data) {
                        data.itemCharacter = pageCCOprObj.safeItemCharater(data.itemCharacter);
                        if (/\//.test(data.unit)) {
                            ConfirmModal.stdBillsUnit.check(data, function (std) {
                                project.Bills.replaceBills(node.source, std, formatCode);
                                projectObj.mainController.refreshTreeNode([node], false);
                            }, function () {
                                projectObj.mainController.refreshTreeNode([node], false);
                            });
                        } else {
                            project.Bills.replaceBills(node.source, data, formatCode);
                            projectObj.mainController.refreshTreeNode([node], false);
                        }
                    } else {
                        project.Bills.updateField(node.source, 'code', formatCode, true);
                        projectObj.mainController.refreshTreeNode([node], false);
                    }
                });
            }
        }
        if (value.length === 9 && /^[\d]+$/.test(value)) {
            stdMatchCode = value;
            formatCode = project.Bills.newFormatCode(stdMatchCode);
            searchStdBillsAndUpdate(stdMatchCode, formatCode);
        } else if (value.length === 12 && /^[\d]+$/.test(value)) {
            stdMatchCode = value.substr(0, 9);
            matchs = project.Bills.sameStdCode(stdMatchCode, node.data.code);
            if (matchs.indexOf(value) === -1) {
                searchStdBillsAndUpdate(stdMatchCode, value);
            } else if (confirm('已存在该编码的清单，是否继续？')) {
                formatCode = project.Bills.newFormatCode(stdMatchCode, node.data.code);
                searchStdBillsAndUpdate(stdMatchCode, formatCode);
            }
        } else {
            project.Bills.updateField(node.source, 'code', value, true);
            this.mainController.refreshTreeNode([node], false);
        } 
    },
    updateRationCode: function (node, value) {
        if (/[\w]{2}[\d]{4}/.test(value)) {
            if (projectInfoObj.projectInfo.engineeringInfo.ration_lib.length === 0) {
                alert('当前项目无定额库，请添加定额库。');
                this.mainController.refreshTreeNode([node], false);
            } else {
                let libId = projectInfoObj.projectInfo.engineeringInfo.ration_lib[0].id;
                CommonAjax.postRationLib('/rationRepository/api/matchRation', {user_id: userID, rationLibId: libId, code: value}, function (data) {
                    if (data) {
                        projectObj.project.Ration.replaceRation(node.source, data);
                        projectObj.project.ration_glj.addRationGLJ(node.source, data);
                    } else {
                        alert('当前库中找不到定额"' + value + '"');
                    }
                    projectObj.mainController.refreshTreeNode([node], false);
                });
            }
        } else {
            alert('输入的定额编码有误，请检查。');
            this.mainController.refreshTreeNode([node], false);
        }
    },
    updateCode: function (node, value) {
        let project = projectObj.project;
        if (node.sourceType === project.Bills.getSourceType()) {
            this.updateBillsCode(node, value);   // 新清单不适合实时计算，下面套什么还不能确定，无数量计算也无意义
        } else if (node.sourceType === project.Ration.getSourceType()) {
            this.updateRationCode(node, value);  // 新套定额适合实时计算
            // 这里因异步问题暂时缺少工料机价格。该过程移到：ration_glj.js的refreshAfterSave方法中。
            /*project.calcProgram.calculate(node);
            project.calcProgram.saveNode(node);
            if (activeSubSheetIs(subSheetIndex.ssiCalcProgram)) {
                calcProgramObj.showData(node, false);
            };*/
        }
    },
    updateCellValue: function (node, value, colSetting) {
        let project = projectObj.project, fieldName = colSetting.data.field;
        if(node.sourceType==project.ration_glj.getSourceType()){
            project.ration_glj.updateFromMainSpread(value,node,fieldName);
        }if(node.sourceType==ModuleNames.ration&&node.data.type==rationType.gljRation){
            gljOprObj.updateRationTypeGLJ(value,node,fieldName);
        } else if (value !== calcFees.getFee(node.data, fieldName)||fieldName == 'quantity') {//工程量需要进行转换，所以做特殊处理
            if (fieldName === 'code' && !project.calcProgram.isVolumePrice(node)) {
                projectObj.updateCode(node, value);
            }
            else if(fieldName ==='feeRate'){
                project.FeeRate.updateFeeRateFromBills(value,node,fieldName);
            }
            else if (fieldName === 'quantity' || fieldName === 'marketUnitFee' || fieldName === 'programID' ||
                fieldName === 'subType' || fieldName === 'calcBase' || fieldName === 'feesIndex.common.unitFee'){
                if (fieldName === 'quantity') {
                   if (value) {
                       value = project.quantity_detail.autoTransformQuantity(value,node);
                       value = scMathUtil.roundForObj(value,decimalObj.decimal(fieldName,node));
                       if(value==node.data[fieldName]){
                           projectObj.mainController.refreshTreeNode([node]);
                           return;
                       }
                   };
                   if(project.quantity_detail.quantityEditChecking(value,node,fieldName)){
                       node.data.isFromDetail=0;
                       project.quantity_detail.cleanQuantityDetail(node,true);
                   }else {
                       projectObj.mainController.refreshTreeNode([node]);
                       return;
                   }
                }
                else if (fieldName === 'marketUnitFee' || fieldName === 'feesIndex.common.unitFee') {
                    if (value) {value = parseFloat(value).toDecimal(decimalObj.decimal("unitPrice", node))};
                }
                else if (fieldName === 'calcBase') {
                    //zhong
                    if(value){
                        node.data.userCalcBase = value;
                        project.calcBase.calculate(node);
                        if(!project.calcBase.success){
                            let activeCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];
                            projectObj.mainSpread.getActiveSheet().setValue(activeCell.row, activeCell.col, node.data.calcBase? node.data.calcBase: '');
                        }
                    }
                    return;
                   // if (value) {value = parseFloat(value).toDecimal(decimalObj.decimal("totalPrice", node))};
                };
                node.changed = true;
                if (fieldName == 'feesIndex.common.unitFee'){
                    project.calcProgram.initFeeField(node, 'common');
                    node.data.feesIndex.common.unitFee = value;
                }
                else node.data[fieldName] = value;
                project.calcProgram.calculate(node);
                project.calcProgram.saveNode(node);
                gljOprObj.showRationGLJSheetData();
            }
            else {
                if (node.sourceType === project.Bills.getSourceType()) {
                    project.Bills.updateField(node.source, fieldName, value, true);
                }
                else if (node.sourceType === project.Ration.getSourceType()) {
                    project.Ration.updateField(node.source, fieldName, value, true);
                };

                if (colSetting.data.wordWrap) {
                    this.mainSpread.getActiveSheet().autoFitRow(node.serialNo());
                }
                projectObj.mainController.refreshTreeNode([node]);
            }
        } else if(value==null && fieldName ==='feeRate'){
            project.FeeRate.cleanFeeRateID(node);
        } else {
            projectObj.mainController.refreshTreeNode([node], false);
        }
    },
    mainSpreadLeaveCell: function (sender, info) {
        let colSetting = projectObj.mainController.setting.cols[info.col];
        projectObj.lastCol = colSetting;
    },
    mainSpreadEnterCell: function (sender, info) {
        let colSetting = projectObj.mainController.setting.cols[info.col];
        if(colSetting.data.field === 'unit' || projectObj.lastCol.data.field === 'unit'||colSetting.data.field ==='subType'|| projectObj.lastCol.data.field === 'subType'){
            info.sheet.repaint();
        }
    },
    mainSpreadEditEnded: function (sender, info) {
        let project = projectObj.project;
        let node = project.mainTree.items[info.row];
        let colSetting = projectObj.mainController.setting.cols[info.col];
        let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
        // 检查输入类型等
        let value = projectObj.checkSpreadEditingText(info.editingText, colSetting);
        projectObj.updateCellValue(node, value, colSetting);

        // 自动行高
        const autoHeight = project.property.displaySetting.autoHeight;
        if (autoHeight) {
            projectObj.mainSpread.getActiveSheet().autoFitRow(info.row);
        }
    },
    mainSpreadRangeChanged: function (sender, info) {
        let project = projectObj.project, setting = projectObj.mainController.setting;
        if (info.changedCells.length > 0) {
            for (let changedCell of info.changedCells) {
                let cell = info.sheet.getCell(changedCell.row, changedCell.col);
                let node = project.mainTree.items[changedCell.row];
                let colSetting = setting.cols[changedCell.col];
                let value = projectObj.checkSpreadEditingText(cell.text(), colSetting);

                projectObj.updateCellValue(node, value, colSetting);
            }
        }
    },
    checkMainSpread: function () {
        if (!this.mainSpread) {
            this.mainSpread = SheetDataHelper.createNewSpread($('#billsSpread')[0]);
            this.mainSpread.getActiveSheet().selectionPolicy(GC.Spread.Sheets.SelectionPolicy.muliRange);
        }
    },
    refreshMainSpread: function () {
        if (this.mainSpread) {
            this.mainSpread.refresh();
        }
    },
    loadProjectData: function () {
        var that = this;
        this.project = PROJECT.createNew(scUrlUtil.GetQueryString('project'), userID);
        this.project.loadDatas(function (err) {

            if (!err) {
                that.project.property = projectInfoObj.projectInfo.property;
                //that.project.calcProgram.compileAllTemps();
                that.project.calcBase.init(that.project);
                that.project.calcFields = JSON.parse(JSON.stringify(feeType));
                // that.project.initCalcFields();
                let str = JSON.stringify(that.project.projSetting.main_tree_col);
                that.project.projSetting.mainGridSetting = JSON.parse(str);
                that.project.projSetting.mainGridSetting.frozenCols = 4;
                TREE_SHEET_HELPER.initSetting($('#billsSpread')[0], that.project.projSetting.mainGridSetting);
                const autoHeight = that.project.property.displaySetting !== undefined ?
                    that.project.property.displaySetting.autoHeight : false;
                that.project.projSetting.mainGridSetting.cols.forEach(function (col) {
                    // for test.  后端没有绑定，暂时写死用于测试。
/*                    if (col.data.field == '' && col.head.titleNames[0] == "取费专业") {
                        col.data.field = 'programID';
                        col.data.getText = 'getText.calcProgramName';
                        col.data.cellType = 'cellType.calcProgramName';
                    };*/

                    col.data.splitFields = col.data.field.split('.');
                    if (col.data.getText && Object.prototype.toString.apply(col.data.getText) === "[object String]") {
                        col.data.getText = MainTreeCol.getEvent(col.data.getText);
                    }
                    if (col.readOnly && Object.prototype.toString.apply(col.readOnly) === "[object String]") {
                        col.readOnly = MainTreeCol.getEvent(col.readOnly);
                    }
                    if (col.data.cellType && Object.prototype.toString.apply(col.data.cellType) === "[object String]") {
                        let getCellType = MainTreeCol.getEvent(col.data.cellType);
                        col.data.cellType = getCellType;
                    }
                    // if (col.data.digit && Object.prototype.toString.apply(col.data.digit) === "[object String]") {
                    //     col.data.decimal = that.project.getDecimal(col.data.digit);
                    //     col.data.formatter = MainTreeCol.getNumberFormatter(col.data.decimal);
                    // }
                    if (col.data.field === 'code') {
                        col.data.formatter = '@';
                    }

                    // 根据配置设置自动行高
                    if (col.data.field === 'name' || col.data.field === 'itemCharacterText' ||
                        col.data.field === 'jobContentText' || col.data.field === 'adjustState') {
                        if (!autoHeight) {
                            col.showHint = true;
                            col.data.wordWrap = false;
                        } else {
                            col.showHint = false;
                            col.data.wordWrap = true;
                        }
                    }

                    // for test digit. CSLAAAAA
                    if (col.data.field.hasSubStr("totalFee"))
                       col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.totalPrice, false)
                    else if (col.data.field.hasSubStr("unitFee"))
                        col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.unitPrice, false)
                    else if (col.data.field == "quantity")
                        col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.quantity, false);
                });

                that.mainController = TREE_SHEET_CONTROLLER.createNew(that.project.mainTree, that.mainSpread.getActiveSheet(), that.project.projSetting.mainGridSetting);
                that.mainController.showTreeData();
                that.mainController.bind('refreshBaseActn', that.refreshBaseActn);
                that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.beforeTreeSelectedChange, that.beforeMainTreeSelectedChange);
                that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.treeSelectedChanged, that.treeSelectedChanged);

                that.mainSpread.bind(GC.Spread.Sheets.Events.LeaveCell, that.mainSpreadLeaveCell);
                that.mainSpread.bind(GC.Spread.Sheets.Events.EnterCell, that.mainSpreadEnterCell);
                that.mainSpread.bind(GC.Spread.Sheets.Events.EditEnded, that.mainSpreadEditEnded);
                that.mainSpread.bind(GC.Spread.Sheets.Events.RangeChanged, that.mainSpreadRangeChanged);
                that.mainSpread.bind(GC.Spread.Sheets.Events.SelectionChanged, that.amountAreaNumber);
                that.loadMainSpreadContextMenu();
                that.loadFocusLocation();
            }
            else {

            }
        });

    },
    loadMainSpreadContextMenu: function () {
        var project = this.project, spread = this.mainSpread, controller = this.mainController;
        $.contextMenu({
            selector: '#billsSpread',
            build: function ($trigger, e) {
                var target = SheetDataHelper.safeRightClickSelection($trigger, e, spread);
                controller.setTreeSelected(controller.tree.items[target.row]);
                return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
            },
            items: {
                "insertBills": {
                    name: "插入清单",
                    icon: 'fa-sign-in',
                    disabled: function () {
                        return project.mainTree.selected ? project.mainTree.selected.sourceType !== project.Bills.getSourceType() : false;
                    },
                    callback: function (key, opt) {
                        ProjectController.addBills(project, controller);
                    }
                },
                "insertRation": {
                    name: "插入定额",
                    icon: 'fa-sign-in',
                    disabled: function () {
                        var selected = project.mainTree.selected;
                        if (selected) {
                            if (            // CSL, 2017-11-28
                                selected.sourceType === project.Ration.getSourceType() ||
                                (selected.sourceType === project.Bills.getSourceType() && selected.source.children.length === 0)
                               ) return false
                            else return true
                        } else return true
                    },
                    callback: function (key, opt) {
                        ProjectController.addRation(project, controller, rationType.ration);
                    }
                },
                "insertLJ": {
                    name: "插入量价",
                    icon: 'fa-sign-in',
                    disabled: function () {
                        var selected = project.mainTree.selected;
                        if (selected) {
                            if (            // CSL, 2017-11-28
                            selected.sourceType === project.Ration.getSourceType() ||
                            (selected.sourceType === project.Bills.getSourceType() && selected.source.children.length === 0)
                            ) return false
                            else return true
                        } else return true
                    },
                    callback: function (key, opt) {
                        ProjectController.addRation(project, controller, rationType.volumePrice);
                    }
                },
                "insertGLJ": {
                    name: "插入工料机",
                    icon: 'fa-sign-in',
                    disabled: function () {
                        var selected = project.mainTree.selected;
                        var readOnly = MainTreeCol.readOnly;
                        return readOnly.billsParent(selected)||(readOnly.bills(selected)&&!readOnly.forCalcBase(selected))||readOnly.glj(selected);
                    },
                    callback: function (key, opt) {
                        getGLJData('insert');// ProjectController.addRation(project, controller, rationType.volumePrice);
                    }
                },
                "spr1": '--------',
                "delete": {
                    name: '删除',
                    icon: 'fa-remove',
                    disabled: function () {
                        var selected = project.mainTree.selected;
                        return !selected;
                    },
                    callback: function () {
                        var selected = controller.tree.selected, parent = selected.parent;
                        if (selected) {
                            if (selected.sourceType === project.Bills.getSourceType()) {
                                project.Bills.deleteBills(selected.source);
                                controller.delete();
                            } else if (selected.sourceType === project.Ration.getSourceType()) {
                                project.Ration.delete(selected.source);
                                controller.delete();
                            };
                            projectObj.converseCalculateBills(parent);
                        }
                    }
                },
                "spr2":'--------',
                "calculateAll_RationContent": {
                    name: '造价计算',
                    callback: function () {
                        let changedNodes = project.calcProgram.calcAllNodes();
                        project.calcProgram.saveNodes(changedNodes);
                    }
                }
            }
        });
    },
    // 计算node及node的所有父项
    converseCalculateBills: function (node) {
/*        if (node) {
            let calc = new BillsCalcHelper(this.project);
            calc.calcNode(node, true);
            let cur = node, nodes = [];
            while (cur) {
                nodes.push(cur);
                cur = cur.parent;
            }
            this.mainController.refreshTreeNode(nodes, false);
            this.project.Bills.updateNodes(nodes, true);
            calc = null;
        }*/
        projectObj.project.calcProgram.calculate(node);
        projectObj.project.calcProgram.saveNode(node);
    },
    // 计算全部清单
/*    calculateAll: function () {
        let calc = new BillsCalcHelper(this.project);
        calc.calcAll();
        this.mainController.showTreeData();
        this.project.Bills.updateAll();
        calc = null;
    }*/
    // 获取上次退出时的焦点位置
    loadFocusLocation: function() {
        const projectId = scUrlUtil.GetQueryString('project');
        let row = getLocalCache('lastRow:' + projectId);
        let col = getLocalCache('lastCol:' + projectId);
        if (row !== null && col !== null) {
            row = parseInt(row);
            col = parseInt(col);
            const sheet = this.mainSpread.getActiveSheet();
            sheet.setSelection(row, col, 1, 1);
            this.mainController.setTreeSelected(this.mainController.tree.items[row]);//触发树节点选中事件
        }
    },
    // 选中区域合计数字
    amountAreaNumber: function(e, info) {
        if (info.newSelections === undefined || info.newSelections.length <= 0) {
            return false;
        }
        const selectedArea = info.newSelections[0];
        const sheet = info.sheet;
        if (selectedArea.colCount <= 1 && selectedArea.rowCount <= 1) {
            return false;
        }
        // 获取鼠标位置
        let x = window.event.clientX;
        let y = window.event.clientY;

        // 匹配数字或小数
        const regular = /^([0-9]+[.]{1}[0-9]+)$|^([1-9]{1}\d+)$/;
        // 小数点最高位数
        let max = 0;
        let total = 0;
        for (let col = selectedArea.col; col < (selectedArea.colCount + selectedArea.col); col++) {
            for (let row = selectedArea.row; row < (selectedArea.rowCount + selectedArea.row); row++) {
                const value = sheet.getCell(row, col).value();
                if (!regular.test(value)) {
                    continue;
                }
                // 获取当前数据小数位数
                let pointPosition = value.toString().indexOf(".");
                pointPosition = pointPosition < 0 ? pointPosition : pointPosition + 1;
                const current = pointPosition > 0 ? value.toString().substring(pointPosition, value.toString().length).length : 0;
                max = current > max ? current : max;
                total += parseFloat(value);
            }
        }
        // 如果不为0则悬浮显示
        if (total > 0) {
            const div = $('<div id="total-tips"><p>合计: <input type="text" id="total" readonly="readonly" style="border: none;"/></p><p><a href="javascript:void(0);">复制</a></p></div>');
            div.css({
                position: "absolute",
                border: "1px #C0C0C0 solid",
                background: "#fff",
                boxShadow: "1px 2px 5px rgba(0,0,0,0.4)",
            });
            div.children("p").css({
                textAlign: "center",
                padding: 8,
                marginBottom: 2,
            });
            div.children("p").first().css({
                borderBottom: "1px #C0C0C0 solid"
            });
            const totalString = total.toFixed(max);
            // input长度
            const inputWidth = totalString.length * 8;
            // 计算是否会超出显示范围
            const baseWidth = 48;
            const baseHeight = 81;
            const canvasWidth = $("#billsSpreadvp_vp").width();
            const canvasHeight = $("#billsSpreadvp_vp").height();
            x = x + baseWidth + inputWidth > canvasWidth ? x - baseWidth - inputWidth : x;
            y = y + baseHeight > canvasHeight ? y - baseHeight : y;
            div.css({
                left: x,
                top: y,
            });

            div.children().children("#total").width(inputWidth).val(totalString);
            $("body").append(div);
            // 用于判断是否要关闭窗体
            setTimeout(function() {
                isTotalShowing = true;
            }, 200);
        };
    }
};
// 点击合计框中的复制
$("body").on("click", "#total-tips a", function() {
    const totalElement = $(this).parent().siblings("p").find("#total");
    totalElement.select();
    document.execCommand("Copy");
    $(this).text("已复制");
});
// 合计框点击其他位置关闭
let isTotalShowing = false;
$("body").on("click",  function(e) {
    if (isTotalShowing && !$(e.target).is("#total-tips") && !$(e.target).is("#total-tips p") && !$(e.target).is("#total-tips p a")) {
        $("#total-tips").remove();
        isTotalShowing = false;
    }
});

$('#insert').click(function () {
    var controller = projectObj.mainController, project = projectObj.project;
    var selected = controller.tree.selected;

    if (!selected || selected.sourceType === project.Bills.getSourceType()) {
        ProjectController.addBills(project, controller);
    } else if (selected.sourceType === project.Ration.getSourceType()) {
        ProjectController.addRation(project, controller, selected.data.type);
    }
});
$('#delete').click(function () {
    var controller = projectObj.mainController, project = projectObj.project;
    var selected = controller.tree.selected, parent = selected.parent;

    if (selected) {
        if (selected.sourceType === project.Bills.getSourceType()) {
            project.Bills.deleteBills(selected.source);
            controller.delete();
        } else if (selected.sourceType === project.Ration.getSourceType()) {
            project.Ration.delete(selected.source);
            controller.delete();
        }else if(selected.sourceType==ModuleNames.ration_glj){
            project.ration_glj.updataOrdelete(selected.source);
        };
        projectObj.converseCalculateBills(parent);
    }
});
$('#upLevel').click(function () {
    var controller = projectObj.mainController, project = projectObj.project;
    var selected = controller.tree.selected, orgParent = selected.parent;

    if (selected && selected.sourceType === project.Bills.getSourceType()) {
        project.Bills.upLevelBills(selected.source);
        controller.upLevel();
        projectObj.converseCalculateBills(orgParent);
    }
});
$('#downLevel').click(function () {
    var controller = projectObj.mainController, project = projectObj.project;
    var selected = controller.tree.selected;
    if (selected && selected.sourceType === project.Bills.getSourceType()) {
        project.Bills.downLevelBills(selected.source);
        controller.downLevel();       
        projectObj.converseCalculateBills(selected.parent);
    }
});
$('#upMove').click(function () {
    var controller = projectObj.mainController, project = projectObj.project;
    var selected = controller.tree.selected, pre = selected.preSibling, preSerialNo;

    if (selected.sourceType === project.Bills.getSourceType()) {
        project.Bills.upMoveBills(selected.source);
        controller.upMove();
    } else if (selected.sourceType === project.Ration.getSourceType()) {
        project.Ration.changePos(selected.source, selected.preSibling.source);
        controller.upMove();
    };
});
$('#downMove').click(function () {
    var controller = projectObj.mainController, project = projectObj.project;
    var selected = controller.tree.selected, next, nextSerialNo;

    if (selected) {
        if (selected.sourceType === project.Bills.getSourceType()) {
            project.Bills.downMoveBills(selected.source);
            controller.downMove();
        } else if (selected.sourceType === project.Ration.getSourceType()) {
            project.Ration.changePos(selected.source, selected.nextSibling.source);
            controller.downMove();
        };
    }
});

$('#poj-set').on('show.bs.modal', function () {
    let setCalcFlag = function (obj, val, curFlag) {
        obj.val(val);
        if (val === curFlag) {
            obj.attr('checked', true);
        } else {
            obj.removeAttr('checked');
        }
    }
    if (projectObj.project) {
        // let mode = projectObj.project.projSetting.billsCalcMode;
        // let settingConst = projectObj.project.projSetting.settingConst;
        let ft = projectObj.project.property.billsCalcMode ? projectObj.project.property.billsCalcMode : leafBillGetFeeType.rationContent;
        setCalcFlag($('#rationContent'), leafBillGetFeeType.rationContent, ft);
        setCalcFlag($('#rationPriceConverse'), leafBillGetFeeType.rationPriceConverse, ft);
        setCalcFlag($('#rationPrice'), leafBillGetFeeType.rationPrice, ft);
        setCalcFlag($('#billsPrice'), leafBillGetFeeType.billsPrice, ft);

        // mode = projectObj.project.projSetting.zanguCalcType;
        let zg = projectObj.project.property.zanguCalcMode ? projectObj.project.property.zanguCalcMode : zanguCalcType.common;
        setCalcFlag($('#zangu_common'), zanguCalcType.common, zg);
        setCalcFlag($('#zangu_gatherMaterial'), zanguCalcType.gatherMaterial, zg);
    }
});
$('#property_ok').click(function () {
    let project = projectObj.project,
        projectID = project.ID(),

        properties = {},
        labourCoes = {},
        rations = [],
        bills = [],

        mixDatas = {
            projectID: projectID,
            updateType: 'update',
            properties: properties,
            labourCoes: labourCoes,
            rations: rations,
            bills: bills
        },

        reCalcBills= false,
        reCalcRations= false;

    let b = parseInt($("input[name='calcFlag']:checked").val());
    if (b !== project.property.billsCalcMode) {
        properties['property.billsCalcMode'] = b;
        project.property.billsCalcMode = b;
        reCalcBills = true;
    };

    let zg = parseInt($("input[name='zangu']:checked").val());
    if (zg !== project.property.zanguCalcMode) {
        properties['property.zanguCalcMode'] = zg;
        project.property.zanguCalcMode = zg;
        reCalcBills = true;
    };

    //基本信息
    if(basicInfoView.toUpdate(basicInfoView.orgDatas, basicInfoView.datas)){
        properties['property.basicInformation'] = basicInfoView.toSaveDatas(basicInfoView.datas);
    }
    //工程特征
    if(projFeatureView.toUpdate(projFeatureView.orgDatas, projFeatureView.datas)){
        properties['property.projectFeature'] = projFeatureView.toSaveDatas(projFeatureView.datas);
    }
    //清单工程量精度
    let newBillsDecimalDatas = billsDecimalView.toBillsDecimalDatas(billsDecimalView.cache);
    if(billsDecimalView.toUpdate(billsQuanDecimal.datas, newBillsDecimalDatas)){
        billsQuanDecimal.datas = newBillsDecimalDatas;
        reCalcBills = true;
        properties['property.billsQuantityDecimal'] = newBillsDecimalDatas;
    }
    //小数位数
    let updateDecimal = m_getDecimalData($('input', '#poj-settings-decimal'));
    if(toUpdateDecimal(decimalObj, updateDecimal)) {
        let frChanged = decimalObj.feeRate != updateDecimal.feeRate;
        setDecimal(decimalObj, updateDecimal);
        if (frChanged) {
            project.calcProgram.compileAllTemps()
        }
        reCalcRations = true;
        reCalcBills = true;
        properties['property.decimal'] = updateDecimal;
    }
    // 呈现选项
    projDisplayView.updateChecking(projectID, properties);

    // 人工系数
    if (labourCoeView.needSave()){
        let libID = $("#std_labour_coe_files").children("option:selected").val();
        let libName = $("#std_labour_coe_files").children("option:selected").text();

        labourCoes.updateData = {libID: libID, libName: libName, newItemArr: labourCoeView.needUpdateDatas};
        project.labourCoe.refreshData(labourCoes.updateData);  // 全编译所用到的人工系数来自project.labourCoe，所以必须先刷新project.labourCoe
        project.calcProgram.compileAllTemps();
        reCalcRations = true;
        reCalcBills = true;
    };
    // 重新计算树节点
    let changedNodes = [];
    if (reCalcRations)    // 定额动，全部计算。
        changedNodes = project.calcProgram.calcAllNodes(calcAllType.catAll)
    else if (reCalcBills)  // 清单动，可以只计算清单。
        changedNodes = project.calcProgram.calcAllNodes(calcAllType.catBills);
    if (changedNodes.length > 0) {
        for (let node of changedNodes){
            let data = {
                // projectID: projectID,
                ID: node.data.ID,
                quantity: node.data.quantity,
                calcBase: node.data.calcBase,
                calcBaseValue: node.data.calcBaseValue,
                marketUnitFee: node.data.marketUnitFee,
                marketTotalFee: node.data.marketTotalFee,
                fees: node.data.fees,
                feeRate: node.data.feeRate,
                feeRateID: node.data.feeRateID
            };
            if (node.sourceType == 'ration'){
                rations.push(data);
            }
            else if (node.sourceType == 'bills'){
                bills.push(data);
            };
        };
    };

    // for test.
/*    console.log(mixDatas);
    return; */
    function hasMixData() {
        return Object.keys(mixDatas.properties).length > 0 ||
            mixDatas.labourCoes.updateData || mixDatas.rations.length > 0 || mixDatas.bills.length > 0;
    }

    if(hasMixData()){
        CommonAjax.post('/pm/api/updateMixDatas', {user_id: userID, mixDataArr: mixDatas}, function (rstData) {
/*            if (changedNodes.length > 0) {
                for (let node of changedNodes){delete node.changed};
            };
            if (mixDatas.labourCoes.updateData) labourCoeView.refresh();*/
            window.location.href = '/main?project=' + projectID;
        });
    }
});