/** * Created by Mai on 2017/7/25. */ let MainTreeCol = { getText: { subType: function (node) { if (node.sourceType === projectObj.project.Bills.getSourceType()) { return billText[node.data.type]; // CSL, 2017-11-29 } else if (node.sourceType === projectObj.project.Ration.getSourceType()) { if (node.data.type == 1 || node.data.type == undefined) // 兼容旧定额 return '定' else if (node.data.type == 2) { // 量价 return volumePriceMaps[node.data.subType]; } else if (node.data.type == 3) { // 工料机定额 return projectObj.project.projectGLJ.getShortNameByID(node.data.subType);//工料机名字缩写 } } else if (node.sourceType === projectObj.project.ration_glj.getSourceType()) { return projectObj.project.projectGLJ.getShortNameByID(node.data.subType);//工料机名字缩写 } }, quantity:function (node) { if(node.sourceType === projectObj.project.ration_glj.getSourceType()){ return gljOprObj.getTotalQuantity(node.data); }else { return parseFloatPlus(node.data["quantity"]).toDecimal(decimalObj.decimal("quantity", node)); } }, // CSL, 2017-11-28 calcProgramName: function (node) { let programID = node.data.programID; if (!programID) return else return projectObj.project.calcProgram.compiledTemplateMaps[programID]; }, calcBase: function (node) { if (node.data.calcBase && node.data.calcBase != ""){ return cbParser.toFExpr(node.data.calcBase); } }, code: function (node) { if(node.sourceType === projectObj.project.Ration.getSourceType() && isDef(node.data.code) && isDef(node.data.from) && node.data.from === 'cpt'){ return '补' + node.data.code.replace(new RegExp('补'), ''); } else { return isDef(node.data.code) ? node.data.code : ''; } } }, readOnly: { // Vincent, 2018-01-09 subType: function (node) { if(MainTreeCol.readOnly.bills(node)){ return true; } if(MainTreeCol.readOnly.ration(node)){ return true; } if(MainTreeCol.readOnly.non_editSubType(node)){ return true; }else if(gljOprObj.hasComposition(node.data,node.sourceType === ModuleNames.ration)){ return true; } return false; }, calcProgramName: function (node) { if ( node.sourceType === projectObj.project.Ration.getSourceType() || (treeNodeTools.isLeafBill(node) && projectObj.project.property.billsCalcMode === leafBillGetFeeType.billsPrice) ) return false else return true; }, non_editSubType: function (node) { return node.data.subType != 201 && node.data.subType != 4 && node.data.subType != 5 }, commonUnitFee: function (node) { return !treeNodeTools.isNullBill(node); }, //根据节点、父节点类型判断是否可用计算基数 calcBaseType: function (node) { function isDef(v) { return v !== undefined && v !== null; } function isFlag(v) { return this.isDef(v.flagsIndex) && this.isDef(v.flagsIndex.fixed); } let calcBase = projectObj.project.calcBase; let parent = node.parent; if (isFlag(node.data) && (node.data.flagsIndex.fixed.flag === calcBase.fixedFlag.SUB_ENGINERRING || node.data.flagsIndex.fixed.flag === calcBase.fixedFlag.CONSTRUCTION_TECH)) { return true; } else if (isFlag(node.data) && node.data.flagsIndex.fixed.flag === calcBase.fixedFlag.CONSTRUCTION_ORGANIZATION) { return false; } else { if (!parent) { return false; } else { return this.calcBaseType(parent); } } }, bills: function (node) { return node.sourceType === projectObj.project.Bills.getSourceType(); }, ration: function (node) { return treeNodeTools.isRation(node); }, glj: function (node) { return node.sourceType == projectObj.project.ration_glj.getSourceType(); }, volumePrice: function (node) { return (node.data.type == rationType.volumePrice || node.data.type == rationType.gljRation); }, non_bills: function (node) { return node.sourceType !== projectObj.project.Bills.getSourceType(); }, non_ration: function (node) { return node.sourceType !== projectObj.project.Ration.getSourceType(); }, non_volumePrice: function (node) { return !(node.data.type == rationType.volumePrice || node.data.type == rationType.gljRation); }, billsParent: function (node) { return node.sourceType === projectObj.project.Bills.getSourceType() && node.source.children.length > 0; }, leafBillsWithDetail: function (node) { return (!MainTreeCol.readOnly.billsParent(node)) && (node.children.length > 0); }, forCalcBase: function (node) { // to do according to billsParentType return MainTreeCol.readOnly.billsParent(node) || MainTreeCol.readOnly.non_bills(node) || MainTreeCol.readOnly.leafBillsWithDetail(node) || MainTreeCol.readOnly.calcBaseType(node); }, forUnitFee: function (node) { return MainTreeCol.readOnly.ration(node) || MainTreeCol.readOnly.billsParent(node) || MainTreeCol.readOnly.leafBillsWithDetail(node); }, forTotalFee: function (node) { return MainTreeCol.readOnly.non_bills(node) || MainTreeCol.readOnly.billsParent(node) || (MainTreeCol.readOnly.leafBillsWithDetail(node)); }, forQuantifyDetail: function (node) { return !(node.sourceType == ModuleNames.ration || !MainTreeCol.readOnly.billsParent(node)); }, forFeeRate: function (node) { return MainTreeCol.readOnly.non_bills(node) || MainTreeCol.readOnly.billsParent(node) || MainTreeCol.readOnly.leafBillsWithDetail(node) }, forQuantity: function (node) { if(node.sourceType === projectObj.project.Bills.getSourceType()){ if(node.data.type==billType.DXFY||node.data.type==billType.FB||(node.data.type==billType.BILL&&MainTreeCol.readOnly.billsParent(node))){//大项费用、分部、清单父项行,工程量只读。 return true; } }else if(MainTreeCol.readOnly.glj(node)){ return true; } return false; }, forMarketPrice: function (node) { return MainTreeCol.readOnly.bills(node) || (node.sourceType === ModuleNames.ration && node.data.type == rationType.ration) || gljOprObj.marketPriceReadOnly(node); }, forContain:function (node) { return MainTreeCol.readOnly.non_ration(node)&&!MainTreeCol.readOnly.glj(node); }, forCode:function (node) { return MainTreeCol.readOnly.glj(node)|| (node.sourceType === projectObj.project.Ration.getSourceType()&&node.data.type===rationType.gljRation); }, forUnit:function (node) { if(MainTreeCol.readOnly.bills(node)&&(node.data.type==billType.DXFY||node.data.type==billType.FB)){//在大项费用、分部行,计量单位只读。 return true; }else { return treeNodeTools.isRation(node); } } }, cellType: { unit: function () { //let combo = new GC.Spread.Sheets.CellTypes.ComboBox(); let dynamicCombo = sheetCommonObj.getDynamicCombo(true); dynamicCombo.itemHeight(10).items(['m', 'm2', 'm3', 'km', 't', 'kg', '台班', '工日', '昼夜', '元', '项', '处', '个', '件', '根', '组', '系统', '台', '套', '株', '丛', '缸', '支', '只', '块', '座', '对', '份', '樘', '攒', '榀']).editable(true); return dynamicCombo; }, units: function () { this.unit; }, feeRate: function () { return feeRateObject.getFeeRateEditCellType(); }, calcBase: function () { return calcBaseView.getCalcBaseCellType(); }, // CSL, 2017-11-28 calcProgramName: function (node) { if ( node.sourceType === projectObj.project.Ration.getSourceType() || (treeNodeTools.isLeafBill(node) && projectObj.project.property.billsCalcMode === leafBillGetFeeType.billsPrice) ) { // var names = new GC.Spread.Sheets.CellTypes.ComboBox(); var names = sheetCommonObj.getDynamicCombo(); names.items(projectObj.project.calcProgram.compiledTemplateNames); return names; } }, // Vincent, 2018-01-09 subType: function (node) { if(node.sourceType!=projectObj.project.Bills.getSourceType()){ let VPType = sheetCommonObj.getDynamicCombo(); if(node.sourceType == projectObj.project.Ration.getSourceType()){//是定额类型 if(node.data.type == rationType.volumePrice){ VPType.itemHeight(5).items(["人工", "材料", "机械", "主材", "设备"]) return VPType; }else if(node.data.type == rationType.gljRation){ if(!MainTreeCol.readOnly.non_editSubType(node)&&gljOprObj.hasComposition(node.data,true)==false){ VPType.itemHeight(3).items(["材料", "主材", "设备"]); return VPType; } } }else if(node.sourceType === projectObj.project.ration_glj.getSourceType()){//是工料机类型 if(!MainTreeCol.readOnly.non_editSubType(node)&&gljOprObj.hasComposition(node.data)==false){ VPType.itemHeight(3).items(["材料", "主材", "设备"]); return VPType; } } } }, }, getEvent: function (eventName) { let names = eventName.split('.'); let event = this; for (let name of names) { if (event[name]) { event = event[name]; } else { return null; } } if (event && Object.prototype.toString.apply(event) !== "[object Function]") { return null; } else { return event; } }, getNumberFormatter: function (digit, align) { // CSL, 2017-11-30 扩展:小数点是否对齐。 if (align) { switch (digit) { case 1: return '0.0'; case 2: return '0.00'; case 3: return '0.000'; case 4: return '0.0000'; case 5: return '0.00000'; case 6: return '0.000000'; default: return '0.00'; } ; } else { switch (digit) { case 1: return '0.#'; case 2: return '0.##'; case 3: return '0.###'; case 4: return '0.####'; case 5: return '0.#####'; case 6: return '0.######'; default: return '0.##'; } ; } } }; let colSettingObj = { settingSpread: null, checkBox: new GC.Spread.Sheets.CellTypes.CheckBox(), loadSetting: function (sheet, setting) { sheet.setRowCount(setting.cols.length); sheet.setColumnCount(setting.headRows, GC.Spread.Sheets.SheetArea.rowHeader); sheet.setColumnCount(1); sheet.getRange(-1, 0, -1, 1).cellType(this.checkBox).hAlign(GC.Spread.Sheets.HorizontalAlign.center); sheet.getCell(0, 0, GC.Spread.Sheets.SheetArea.colHeader).value('显示'); sheet.setColumnWidth(0, 100); sheet.setColumnWidth(0, 150, GC.Spread.Sheets.SheetArea.rowHeader); setting.cols.forEach(function (col, index) { let i, iCol = 0, cell; for (i = 0; i < col.head.spanCols.length; i++) { if (col.head.spanCols[i] !== 0) { cell = sheet.getCell(index, iCol, GC.Spread.Sheets.SheetArea.rowHeader); cell.value(col.head.titleNames[i]).font(col.head.font).hAlign(col.head.hAlign[i]).vAlign(col.head.vAlign[i]); } if (col.head.spanCols[i] > 1 || col.head.spanRows[i] > 1) { sheet.addSpan(index, iCol, col.head.spanRows[i], col.head.spanCols[i], GC.Spread.Sheets.SheetArea.rowHeader); } iCol += col.head.spanRows[i]; } ; let colWidth = sheet.getColumnWidth(index, GC.Spread.Sheets.SheetArea.rowHeader); colWidth = colWidth > col.width ? colWidth : col.width; //sheet.setColumnWidth(index, colWidth, GC.Spread.Sheets.SheetArea.rowHeader); cell = sheet.getCell(index, 0).value(col.visible); sheet.autoFitRow(index); }); }, initSettingSpread: function () { this.settingSpread = SheetDataHelper.createNewSpread($('#col_setting_spread')[0], {sheetCount: 1}); this.settingSpread.options.showScrollTip = GC.Spread.Sheets.ShowScrollTip.vertical; this.loadSetting(this.settingSpread.getActiveSheet(), projectObj.project.projSetting.main_tree_col); } }; $('#column').on('shown.bs.modal', function () { if (!colSettingObj.settingSpread) { colSettingObj.initSettingSpread(); } }); $('#column').on('hide.bs.modal', function () { let sheet = colSettingObj.settingSpread.getActiveSheet(); for (let iRow = 0; iRow < sheet.getRowCount(); iRow++) { projectObj.project.projSetting.main_tree_col.cols[iRow].visible = sheet.getValue(iRow, 0); projectObj.project.projSetting.mainGridSetting.cols[iRow].visible = sheet.getValue(iRow, 0); } SheetDataHelper.refreshColumnVisible(projectObj.project.projSetting.mainGridSetting, projectObj.mainSpread.getActiveSheet()); projectObj.project.pushNow('editColSetting', projectObj.project.projSetting.moduleName, { projectID: projectObj.project.ID(), main_tree_col: projectObj.project.projSetting.main_tree_col }); });