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(!node){
                return false;
            }
            if(node.depth()<=1){//焦点行是树结构的第一/二层节点，灰显。
                return false;
            }
            if(node.sourceType !== that.project.Bills.getSourceType()){//焦点行是定额/量价/工料机，灰显。
                return false;
            }else {
                if(node.data.type == billType.FX){//是分项，灰显。
                    return false;
                }
                if(node.data.type == billType.FB&&node.nextSibling&&node.children.length>0){//焦点行是分部有后兄弟，有子项.
                     if(node.children[0].data.type==billType.FX){ //焦点行子项是分项
                         return false;
                     }
                }
                if(node.data.type == billType.BILL &&node.nextSibling){//焦点行是清单有后兄弟
                    if(node.data.calcBase&&node.data.calcBase!=""){//有基数计算
                        return false;
                    }
                    if(node.children.length>0&&node.children[0].sourceType !== that.project.Bills.getSourceType()){//有子项,并且子项不是清单
                        return false;
                    }
                }
            }
            return true;
        };
        let canDownLevel = function (node) {
            if(!node){
                return false;
            }
            if(node.depth()==0){//焦点行是树结构的第一层节点，灰显。
                return false;
            }
            if(node.sourceType !== that.project.Bills.getSourceType()) {//焦点行是定额/量价/工料机，灰显。
                return false;
            }else {
                if(node.data.type == billType.FX){//是分项，灰显。
                    return false;
                }
                if(!node.preSibling){//无前兄弟，灰显
                    return false;
                }else if(node.preSibling.data.calcBase&&node.preSibling.data.calcBase!=""){//前兄弟有基数计算
                    return false
                }
                if(node.preSibling.children.length>0){//前兄弟有子项，子项是分项，灰显。
                    if(node.data.type==billType.FB&&node.preSibling.children[0].data.type==billType.FX){//焦点行是分部前兄弟有子项，子项是分项，灰显。
                        return false;
                    }
                    if(node.data.type==billType.BILL&&node.preSibling.children[0].sourceType !== that.project.Bills.getSourceType()){//焦点行是清单，子项不是清单
                        return false
                    }
                }
            }
            return true;
        };
        let canUpMove = function (node) {
            if(node&&node.preSibling){//有前兄弟
                if(node.sourceType==that.project.Bills.getSourceType()&&node.data.type == billType.DXFY&&node.data.isAdd!==1){
                    return false;
                }
                return true
            }
            return false
        };
        let canDownMove = function (node) {
            if(node&&node.nextSibling){
                if(node.sourceType==that.project.Bills.getSourceType()&&node.data.type == billType.DXFY&&node.data.isAdd!==1){
                    return false;
                }
                return true;
            }
            return false
        };
        
        setButtonValid(ifCanDelete(), $('#delete'));
        setButtonValid(canUpLevel(selected), $('#upLevel'));
        setButtonValid(canDownLevel(selected), $('#downLevel'));
        setButtonValid(canUpMove(selected) , $('#upMove'));
        setButtonValid(canDownMove(selected), $('#downMove'));
    },
    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'||colSetting.data.field === 'contain') {
            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);
        }
    },
    updateBillsCode: function (node, value) {
        let project = projectObj.project;
        let stdMatchCode, formatCode, matchs;
        let searchStdBillsAndUpdate = function (stdCode, formatCode) {
            let orgCode = node.data.code?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(node.data.type==billType.FX||node.data.type==billType.BILL){
            if (value&&value.length === 9 && /^[\d]+$/.test(value)) {
                stdMatchCode = value;
                formatCode = project.Bills.newFormatCode(stdMatchCode);
                searchStdBillsAndUpdate(stdMatchCode, formatCode);
                return;
            } else if (value&&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);
                    return;
                }
            }
        }
        project.Bills.updateField(node.source, 'code', value, true);
        this.mainController.refreshTreeNode([node], false);

    },
    updateRationCode: function (node, 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.post('/complementaryRation/api/getRationItem', {user_id: userID, rationRepId: 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);
            });
        }
    },
    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.calcAndSave(node);
            if (activeSubSheetIs(subSheetIndex.ssiCalcProgram)) {
                calcProgramObj.showData(node, false);
            };*/
        }
    },
    updateCellValue: function (node, value, colSetting,editingText) {
        let project = projectObj.project, fieldName = colSetting.data.field;
        if(node.sourceType==project.ration_glj.getSourceType()){
            project.ration_glj.updateFromMainSpread(value,node,fieldName);
        }
        else if(nodeTools.isGljRation(node)){
            gljOprObj.updateRationTypeGLJ(value,node,fieldName);
        }
        else if (value !== calcFees.getFee(node.data, fieldName)||fieldName == 'quantity') {//工程量需要进行转换，所以做特殊处理
            if (fieldName === 'code' && !nodeTools.isVolumePrice(node)) {
                projectObj.updateCode(node, value);
            }
            else if(fieldName ==='feeRate'){
                project.FeeRate.updateFeeRateFromBills(value,node,fieldName);
            }
            else if(fieldName ==='contain'){//编辑含量
                project.Ration.updateContain(value,node);
            }
            else if (fieldName === 'quantity' || fieldName === 'marketUnitFee' || fieldName === 'programID' ||
                fieldName === 'subType' || fieldName === 'calcBase'){
                if (fieldName === 'quantity') {
                    project.quantity_detail.editMainTreeNodeQuantity(value,node,fieldName,editingText);
                    return;
                }
                else if (fieldName === 'marketUnitFee') {
                    if (value) {value = parseFloat(value).toDecimal(decimalObj.decimal("unitPrice", node))};
                }
                else if (fieldName === 'calcBase') {
                    //zhong
                    if(value === undefined ||value === null || value.toString().trim() === ''){
                        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))};
                };

                if(fieldName !== 'calcBase'){
                    node.data[fieldName] = value;
                    node.changed = true;
                }

                project.calcProgram.calcAndSave(node);
                gljOprObj.showRationGLJSheetData();
            }
            else if (node.sourceType === project.Bills.getSourceType()&&fieldName === 'unit'){//修改清单单位的时候清单工程量要重新4舍5入
                node.data[fieldName] = value;
                node.changed = true;
                if(node.data.quantity){
                    node.data.quantity =scMathUtil.roundForObj(node.data.quantity,getDecimal("quantity",node));
                }
                project.calcProgram.calcAndSave(node);
            }
            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();
        }
    },
    mainSpreadEditStarting: function (sender, info) {
        let project = projectObj.project;
        let node = project.mainTree.items[info.row];
        if(isDef(node) && node.sourceType === project.Ration.getSourceType() && isDef(node.data.code) && isDef(node.data.from) && node.data.from === 'cpt'){
            let orgV = info.sheet.getValue(info.row, info.col);
            let newV = orgV.replace(new RegExp('补'), '');
            info.sheet.setValue(info.row, info.col, newV);
        }
    },
    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,info.editingText);

        // 自动行高
        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);
        let startTime = +new Date();
        console.log("开始加载-----"+startTime);
        this.project.loadDatas(function (err) {
            if (!err) {
                that.project.projectGLJ.calcQuantity();//计算分部分项和技术措施项目消耗量;
                that.project.property = projectInfoObj.projectInfo.property;
                //that.project.calcProgram.compileAllTemps();
                that.project.calcBase.init(that.project);
                that.project.calcFields = JSON.parse(JSON.stringify(cpFeeTypes));
                // 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;
                        }
                    }
                    if(col.data.field ==='quantity'){
                        col.showHint = true;
                    }

                    // 综合单价、综合合价，小数部分应补0对齐。  CSLAAAAA
                    if (col.data.field.hasSubStr("common")){
                        if (col.data.field.hasSubStr("totalFee"))
                            col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.totalPrice, true)
                        else if (col.data.field.hasSubStr("unitFee"))
                            col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.unitPrice, true)
                    }

                });

                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.EditStarting, that.mainSpreadEditStarting);
                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();
                let endTime = +new Date();
                console.log("加载完成-----"+endTime);
                console.log(`时间——${endTime - startTime}`);
            }
            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: {
                "insertRootBill": {
                    name: "插入大项费用",
                    icon: 'fa-sign-in',
                    disabled: function () {
                        //return project.mainTree.selected ? project.mainTree.selected.sourceType !== project.Bills.getSourceType() : false;
                    },
                    callback: function (key, opt) {
                        ProjectController.addRootBill(project, controller);
                    },
                    visible: function(key, opt){
                        return project.mainTree.selected&&project.mainTree.selected.parent==null;
                    }
                },
                "insertFB": {
                    name: "插入分部",
                    icon: 'fa-sign-in',
                    disabled: function () {
                        let selected = project.mainTree.selected;
                        if(selected&&selected.sourceType==project.Bills.getSourceType()){
                            if(selected.data.type==billType.FB){
                                return false;
                            }
                            if(isFlag(selected.data)&&selected.data.flagsIndex.fixed.flag==fixedFlag.SUB_ENGINERRING){//焦点行是分部分项工程
                                if(selected.children.length>0){
                                   return selected.children[0].data.type==billType.FX;//焦点行是分部分项工程，且子项是分项
                                }else {
                                    return false
                                }
                            }
                        }
                        return true;//除了清单，其它类型都只读
                    },
                    callback: function (key, opt) {
                        ProjectController.addFB(project, controller);
                    },
                    visible: function(key, opt){
                        if(project.mainTree.selected){
                            return project.Bills.isFBFX(project.mainTree.selected );//不属于分部分项的话隐藏
                        }else {
                            return false;
                        }
                    }
                },
                "insertFX": {
                    name: "插入分项",
                    icon: 'fa-sign-in',
                    disabled: function () {
                        let selected = project.mainTree.selected;
                        if(selected&&selected.sourceType==project.Bills.getSourceType()){
                            if(selected.data.type==billType.FX){//焦点行是分项，有效显示
                                return false
                            }
                            if(selected.data.type==billType.FB){//点行是分部，
                                if(selected.children.length>0){//且有子项，子项是分部，灰显。
                                    return selected.children[0].data.type == billType.FB
                                }else {
                                    return false;
                                }
                            }
                            if(isFlag(selected.data)&&selected.data.flagsIndex.fixed.flag==fixedFlag.SUB_ENGINERRING){//焦点行是分部分项工程
                                if(selected.children.length>0){
                                    return selected.children[0].data.type==billType.FB;//焦点行是分部分项工程，且子项是分部时灰显
                                }else {
                                    return false
                                }
                            }
                        }
                        return true;//除了清单，其它类型都只读
                    },
                    callback: function (key, opt) {
                        ProjectController.addFX(project, controller);
                    },
                    visible: function(key, opt){
                        if(project.mainTree.selected){
                            return project.Bills.isFBFX(project.mainTree.selected );//不属于分部分项的话隐藏
                        }else {
                            return false;
                        }
                    }
                },
                "insertBills": {
                    name: "插入清单",
                    icon: 'fa-sign-in',
                    disabled: function () {
                        return project.mainTree.selected ? project.mainTree.selected.sourceType !== project.Bills.getSourceType() : false;
                    },
                    callback: function (key, opt) {
                        if(project.mainTree.selected.data.type == billType.DXFY){
                            if(project.mainTree.selected.data.calcBase&&project.mainTree.selected.data.calcBase!=""){
                                alert("当前有基数计算不能插入子项。");
                                return;
                            }
                        }
                        ProjectController.addBills(project, controller);
                    },
                     visible: function(key, opt){
                         if(project.mainTree.selected){
                             return  project.Bills.isFBFX(project.mainTree.selected)==true?false:true;
                         }else {
                             return false;
                         }
                     }
                },
                "insertRation": {
                    name: "插入定额",
                    icon: 'fa-sign-in',
                    disabled: function () {
                        var selected = project.mainTree.selected;
                        return project.Ration.addRationChecking(selected);  // Vincent, 2018-01-02
                    },
                    callback: function (key, opt) {
                        ProjectController.addRation(project, controller, rationType.ration);
                    },
                    visible: function(key, opt){
                        var selected = project.mainTree.selected;
                        if(selected){
                            if(selected.sourceType == ModuleNames.bills&&selected.data.type == billType.DXFY){
                                return false
                            }else {
                                return true
                            }
                        }
                       return false;
                    }
                },
                "insertLJ": {
                    name: "插入量价",
                    icon: 'fa-sign-in',
                    disabled: function () {
                        var selected = project.mainTree.selected;
                        return project.Ration.addRationChecking(selected);  // Vincent, 2018-01-02
                    },
                    callback: function (key, opt) {
                        ProjectController.addRation(project, controller, rationType.volumePrice);
                    },
                    visible: function(key, opt){
                        var selected = project.mainTree.selected;
                        if(selected){
                            if(selected.sourceType == ModuleNames.bills&&selected.data.type == billType.DXFY){
                                return false
                            }else {
                                return true
                            }
                        }
                       return false;
                    }
                },
                "insertGLJ": {
                    name: "插入工料机",
                    icon: 'fa-sign-in',
                    disabled: function () {
                        var selected = project.mainTree.selected;
                        return project.Ration.addRationChecking(selected);  // Vincent, 2018-01-02
                    },
                    callback: function (key, opt) {
                        var selected = project.mainTree.selected;
                        if(selected.sourceType == ModuleNames.bills){
                            if(selected.data.type == billType.FX||selected.data.type ==billType.BILL){
                                if(selected.data.calcBase&&selected.data.calcBase!=""){
                                    alert("当前有基数计算不能插入子项。");
                                    return;
                                }
                            }
                        }
                        getGLJData('insert');// ProjectController.addRation(project, controller, rationType.volumePrice);
                    },
                    visible: function(key, opt){
                        var selected = project.mainTree.selected;
                        if(selected){
                            if(selected.sourceType == ModuleNames.bills&&selected.data.type == billType.DXFY){
                                return false;
                            }else {
                                return true;
                            }
                        }
                        return false;
                    }
                },
                "ZLFB": {
                    name: "整理分部",
                    icon: 'fa-sign-in',
                    disabled: function () {
                       return false;
                    },
                    callback: function (key, opt) {
                        zlfb_object.getSectionInfo();
                    },
                    visible: function(key, opt){
                        return true;
                    }
                },
                "spr1": '--------',
                "delete": {
                    name: '删除',
                    icon: 'fa-remove',
                    disabled: function () {
                        return !ifCanDelete();
                    },
                    callback: function () {
                        $("#delete_row").modal({show:true});//弹出删除提示框;
                    }
                },
                "spr2":'--------',
                "calculateAll_RationContent": {
                    name: '造价计算',
                    callback: function () {
                        $.bootstrapLoading.start();
                        project.calcProgram.calcAllNodesAndSave();
                    }
                }
            }
        });
    },
    // 计算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.calcAndSave(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;
        let counter = 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).text();
                if (!regular.test(value)) {
                    continue;
                }
                counter++;
                // 获取当前数据小数位数
                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 && counter > 1) {
            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);
        };
 },

    //根据节点获取行style(颜色、字体加粗)
    getNodeColorStyle: function (node, colSetting) {
        let colorSetting = optionsOprObj.getOption(optionsOprObj.optionsTypes.COLOROPTS);
        let mapping = {DEFAULT: 'DEFAULT', DXFY: 'DXFY', FB: 'FB', UNLEAFBILL: 'UNLEAFBILL',
            FX: 'FX', UNCBBILL: 'UNCBBILL', CBBILL: 'CBBILL', ZCSB: 'ZCSB'};
        let styleMap = null;
        //中文字段名，由于同一节点中，中文字体大小和数字字体大小不同
        let stringFields = [
            'code',
            'subType',
            'name',
            'unit',
            'itemCharacterText',
            'jobContentText',
            'adjustState',
            'calcBase',
            'programID',
            'ruleText'
        ];
        if(!isDef(node)){
            return null;
        }
        //清单大类
        if(node.sourceType === this.project.Bills.getSourceType()){
            //大项费用
            //大项费用
            if(node.data.type === billType.DXFY){
                styleMap = mapping.DXFY;
            }
            //分部
            if(node.data.type === billType.FB){
                styleMap = mapping.FB;
            }
            //分项
            else if(node.data.type === billType.FX){
                styleMap = mapping.FX;
            }
            //清单
            else if(node.data.type === billType.BILL){
                //非叶子节点的清单
                if(node.source.children.length > 0){
                    styleMap = mapping.UNLEAFBILL;
                }
                //未使用基数计算的叶子节点的清单
                else if(node.source.children.length === 0 && (!isDef(node.data.calcBase) || node.data.calcBase === '')){
                    styleMap = mapping.UNCBBILL;
                }
                //使用基数计算的叶子节点的清单
                else if(node.source.children.length === 0 && isDef(node.data.calcBase && node.data.calcBaseValue !== '')){
                    styleMap = mapping.CBBILL;
                }
            }
        }
        //定额下的主材、设备
        else if(node.sourceType === this.project.ration_glj.getSourceType()){
            styleMap = mapping.ZCSB;
        }
        else {
            styleMap = mapping.DEFAULT;
        }
        let styleSetting = colorSetting[styleMap];
        let defaultSetting = colorSetting[mapping.DEFAULT];
        if(!isDef(styleSetting)){
            return null;
        }
        let style = new GC.Spread.Sheets.Style();
        //设置style属性
        for(let attr in styleSetting){
            if(attr !== 'stringFont' && attr !== 'numFont'){
                style[attr] = styleSetting[attr] === 'default' || !isDef(styleSetting[attr]) ? defaultSetting[attr] : styleSetting[attr];
            }
            //暂时不开放字体设置，开放的话只能每个单元格进入此方法
           /* else {
                if(stringFields.indexOf(colSetting.data.field) > 0){
                    style.font = styleSetting.stringFont === 'default' || !isDef(styleSetting.stringFont) ? defaultSetting.stringFont : styleSetting.stringFont;
                }
                else {
                    style.font = styleSetting.numFont === 'default' || !isDef(styleSetting.numFont) ? defaultSetting.numFont : styleSetting.numFont;
                }
            }*/
        }
        style.borderLeft = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
        style.borderTop = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
        style.borderRight = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
        style.borderBottom = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
        return style;
    },
    //大项费用则字体加粗，String 15px, Number 13px
    getBoldFontStyle: function (node, colSetting) {
        if(node.sourceType !== this.project.Bills.getSourceType() || node.data.type !== billType.DXFY){
            return null;
        }
        let style = new GC.Spread.Sheets.Style();
        //备注暂无字段
        let stringFields = [
            'code',
            'subType',
            'name',
            'unit',
            'itemCharacterText',
            'jobContentText',
            'adjustState',
            'calcBase',
            'programID',
            'ruleText'
        ];
        if(stringFields.indexOf(colSetting.data.field) > 0){
            style.font = 'bold 15px Arial';
        }
        else {
            style.font = 'bold 13px Arial';
        }
        return style;
    }
    
};
// 点击合计框中的复制
$("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 () {
    $("#delete_row").modal({show:true});//弹出删除提示框;
});

$('#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();
        controller.refreshTreeNode([orgParent]);
        projectObj.project.calcProgram.calcBillsAndSave([selected,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();
        controller.refreshTreeNode([selected.parent]);
        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;
        reCalcRations = 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(properties);

    if(calcOptions.updateChecking(properties)){
        reCalcRations = true;
    }

    // 人工系数
    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;
        });
    }
});

$('#delete_row').on('shown.bs.modal', function (e) {
    var controller = projectObj.mainController, project = projectObj.project;
    var selected = controller.tree.selected, parent = selected.parent;
    var showinfo = "确认要删除当前选中行吗？";
    var showN = false;
    var cancelText = "否";
    if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length>0){//选中的是分部，并且有子项
        if(isSingleSelect()||selectionChecking()){
            showinfo = "是否删除其下的子项？";
            showN = true;
            cancelText = "取消";
        }
    }
    $('#delete_showinfo').text(showinfo);
    showN==true? $('#deleteN').show():$('#deleteN').hide();
    $('#deleteCancel').text(cancelText);

    function selectionChecking() {
        let selection = projectObj.mainSpread.getActiveSheet().getSelections()[0];
        let mainTreeMap = {};
        for(let i =0;i<selection.rowCount;i++){
            let tem_node = controller.tree.items[selection.row+i];
            if(i==0){//第一个直接添加;
                mainTreeMap[tem_node.getID()] = tem_node;
            }else {
                project.Bills.setNodeToMap(tem_node,mainTreeMap);
            }
        }
        let nodes = changeMapToArray(mainTreeMap);
        if(nodes.length==1){
            return true
        }
        return false;
    }
});

function changeMapToArray(map) {
    let newArray = [];
    for(let key in map){
        newArray.push(map[key]);
    }
    return newArray;
}


$('#deleteY').click(function () { //正常删除，级联删除子项
    let project = projectObj.project;
    if(isSingleSelect()){
        project.Bills.deleteSelectedNode();
    }else {
        project.Bills.deleteSelectedNodes();
    }
});

$('#deleteN').click(function () {//不删除子项
    let controller = projectObj.mainController, project = projectObj.project;
    let selected = controller.tree.selected, parent = selected.parent;
    if(selected){
        let preNode = selected.preSibling;
        let nextNode = selected.nextSibling;
        if(preNode){//有前兄弟
            if(preNode.children.length>0&&preNode.children[0].data.type != selected.children[0].data.type){//并且前兄弟子项和焦点行子项类别不同。
                alert("删除分部会导致分部和分项同级，不允许该操作！");
                return;
            }
        }else if(nextNode){
            if(nextNode.data.type != selected.children[0].data.type){
                alert("删除分部会导致分部和分项同级，不允许该操作！ ");
                return;
            }
        }
        project.Bills.singleDeleteBills(selected,controller);
    }
});

function isSingleSelect() {//是否选中造价书中的单行
    let selections = projectObj.mainSpread.getActiveSheet().getSelections();
    if (selections[0].rowCount == 1) {
        return true;
    }
    return false;
}
function ifCanDelete() {
    let selections = projectObj.mainSpread.getActiveSheet().getSelections();
    let tree = projectObj.project.mainTree;
    let selected = projectObj.project.mainTree.selected;
    if(selections[0].rowCount==1){//选中单行
        return canDelete(selected);
    }else {
       return canDelete_m(selections[0]);
    }

    function canDelete(node,m_selection) {
        if (node) {
            if (node.sourceType === projectObj.project.Bills.getSourceType()) {
                if(node.data.type == billType.DXFY&&node.data.isAdd!=1){
                    return false;
                }
            }
            if(m_selection!=true&&node.sourceType === projectObj.project.ration_glj.getSourceType()){//多选的时候不做这一项判断
                return false;
            }
            return true;
        } else {
            return false;
        }
    };

    function canDelete_m(selection) {
        for(let i =0;i<selection.rowCount;i++){
            if(tree.items[selection.row+i]==undefined||tree.items[selection.row+i]==null){
                return false;
            }
            if(i==0&&tree.items[selection.row].sourceType === projectObj.project.ration_glj.getSourceType()){
                return false
            }
            if(canDelete(tree.items[selection.row+i],true)==false){
                return false
            }
        }
        return true
    };
}