/**
* 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.data.type == 4){//安装增加费生成的定额
return '安';
}
} 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 calcTools.uiNodeQty(node)?calcTools.uiNodeQty(node):null;
}
},
// 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(!isDef(node)){
return '';
}
let rst = '';
if(node.sourceType === projectObj.project.Ration.getSourceType() && node.data.type === rationType.ration
&& isDef(node.data.code) && isDef(node.data.prefix) && node.data.prefix !== ''){
rst = node.data.prefix + node.data.code.replace(new RegExp(node.data.prefix, 'g'), '');
}
else
rst = isDef(node.data.code) ? node.data.code : '';
if (node.data.adjustState && rst != '')
rst = rst + rationPrefix.replace;
return rst;
},
marketPrice:function (node) {
if((node.sourceType === projectObj.project.Ration.getSourceType()&&node.data.type!=rationType.ration)||node.sourceType==projectObj.project.ration_glj.getSourceType()){
return calcTools.uiGLJPrice(node.data.marketUnitFee);
}
},
feeRate:function (node) {
if(node.data.feeRateID){
let rate = projectObj.project.FeeRate.getFeeRateByID(node.data.feeRateID);
if (rate) return rate.rate;
}
return node.data.feeRate;
}
},
readOnly: {
// Vincent, 2018-01-09
subType: function (node) {
if (calcTools.isVolumePrice(node)) return false;
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() ||
(calcTools.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 !(calcTools.isLeafBill(node) && !calcTools.isBill_DXFY(node) && !calcTools.isCalcBaseBill(node) && !calcTools.isInheritFrom(node, [fixedFlag.SUB_ENGINERRING, fixedFlag.MEASURE]));
},
//根据节点、父节点类型判断是否可用计算基数
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 calcTools.isRationItem(node);
},
isSubcontract: function (node) {
return !calcTools.isRationCategory(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) {
let readOnly = true;
let Bills = projectObj.project.Bills;
//只有当选中节点是清单，并且不属于“分部分项工程”或“技术措施项目”，并且是叶子清单且没有定额/量价/工料机时，费率列才可编辑
if(MainTreeCol.readOnly.bills(node)){
if(!Bills.isFBFX(node)&&!Bills.isTechMeasure(node)&&node.children.length<=0){//不属于“分部分项工程”或“技术措施项目”，并且是叶子清单且没有定额/量价/工料机
readOnly = false;
}
}
return readOnly;
},
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) {
let Bills = projectObj.project.Bills;
if(MainTreeCol.readOnly.glj(node)|| (node.sourceType === projectObj.project.Ration.getSourceType()&&node.data.type===rationType.gljRation)){//是主材或者设备、或者是工料机类型的定额
return true;
}
if(Bills.isTopThreeNode(node)){//是大项1、2、3项的编号设置为只读
return true;
}
return false;
},
forName:function (node) {
if(projectObj.project.Bills.isTopThreeNode(node)){//是大项1、2、3项的编号设置为只读
return true;
}
return false;
},
forUnit:function (node) {
if(MainTreeCol.readOnly.bills(node)&&(node.data.type==billType.DXFY||node.data.type==billType.FB)){//在大项费用、分部行，计量单位只读。
return true;
}else {
return calcTools.isRationItem(node);
}
},
forContentCharacter: function (node) {
return !MainTreeCol.readOnly.bills(node) || (node.data.type !== billType.BILL && node.data.type !== billType.FX);
},
forRuleText: function (node) {
if(MainTreeCol.readOnly.bills(node)){
if(node.data.type === billType.FX || (node.data.type === billType.BILL && node.source.children.length === 0)){
return false;
}
}
return true;
}
},
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();
},
quantity:function (node) {
if(!MainTreeCol.readOnly.forQuantity(node)){
return quantityEditObj.getQuantityEditCellType();
}
},
calcBase: function () {
return calcBaseView.getCalcBaseCellType('bills');
},
// CSL, 2017-11-28
calcProgramName: function (node) {
if (
node.sourceType === projectObj.project.Ration.getSourceType() ||
(calcTools.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;
}
}
}
},
isSubcontract: function (node){
if (calcTools.isRationCategory(node))
return new GC.Spread.Sheets.CellTypes.CheckBox();
},
isEstimate:function (node) {
//只对分项、补项、材料(包括混凝土等)、主材、设备有效
if(MainTreeCol.readOnly.glj(node)||(calcTools.isGljRation(node)&&projectObj.project.projectGLJ.isEstimateType(node.data.subType))||(MainTreeCol.readOnly.bills(node)&&(node.data.type == billType.BX||node.data.type == billType.FX))){
return new GC.Spread.Sheets.CellTypes.CheckBox();
}
},
commonTotalFee: function () {
return projectObj.getCommonTotalFeeCellType();
}
},
editChecking:function(node){
if(node.sourceType==projectObj.project.Bills.getSourceType()&&projectObj.project.isBillsLocked()&&projectObj.project.withinBillsLocked(node)){
return true;
}
if(gljOprObj.isInstallationNode(node)){//如果是通过安装增加费自动生成的，都是只读类型
return true;
}
return false;
},
setAutoHeight:function (cell,node) {//设置自动行高
cell.wordWrap(MainTreeCol.needAutoFit(node));
},
setAutoFitRow:function (sheet,node) {
if(MainTreeCol.needAutoFit(node)){
sheet.autoFitRow(node.serialNo());
}
},
needAutoFit:function (node) {
let displaySetting = projectObj.project.property.displaySetting;
let billsAutoH = displaySetting && displaySetting.billsAutoHeight?displaySetting.billsAutoHeight:false;
let rationAutoH = displaySetting && displaySetting.rationAutoHeight?displaySetting.rationAutoHeight:false;
if(node.sourceType === projectObj.project.Bills.getSourceType()&&billsAutoH == true){
return true;
}
if(node.sourceType !== projectObj.project.Bills.getSourceType()&& rationAutoH == true){
return true;
}
return false;
},
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';
}
;
}
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.suspendPaint();
sheet.suspendEvent();
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, 240, 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]).hAlign(col.head.hAlign[i]).vAlign(col.head.vAlign[i]);
//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);
});
sheet.resumeEvent();
sheet.resumePaint();
},
initSettingSpread: function () {
this.settingSpread = SheetDataHelper.createNewSpread($('#col_setting_spread')[0], {sheetCount: 1});
sheetCommonObj.spreadDefaultStyle(this.settingSpread);
this.settingSpread.options.showScrollTip = GC.Spread.Sheets.ShowScrollTip.vertical;
this.settingSpread.bind(GC.Spread.Sheets.Events.ButtonClicked, function (sender, args) {
if(args.sheet.isEditing()){
args.sheet.endEdit(true);
}
});
this.loadSetting(this.settingSpread.getActiveSheet(), projectObj.project.projSetting.main_tree_col);
},
dataChanged: function () {
let sheet = this.settingSpread.getActiveSheet();
for(let row = 0; row < sheet.getRowCount(); row++){
let orgData = projectObj.project.projSetting.main_tree_col.cols[row].visible;
let newData = sheet.getValue(row, 0);
if(orgData != newData){
return true;
}
}
return false;
},
updateColSetting: function (skipSetValue = false) {
let mainSheet = projectObj.mainSpread.getActiveSheet();
if(!skipSetValue){
let sheet = this.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.massOperationSheet(mainSheet, function () {
SheetDataHelper.refreshColumnVisible(projectObj.project.projSetting.mainGridSetting, mainSheet);
//左右滚动条到最左边
mainSheet.showColumn(projectObj.project.projSetting.mainGridSetting.frozenCols, GC.Spread.Sheets.HorizontalPosition.left);
});
//refresh nodes to autoFitRow
projectObj.mainController.refreshTreeNode(projectObj.project.mainTree.roots, true);
if(!skipSetValue){
//列设置将项目特征和工作内容都取消打钩后，更新快速列设置
if(!this.getVisible('itemCharacterText')){
switchTznrHtml(true);
}
if(this.getVisible('itemCharacterText')){
switchTznrHtml(false);
}
}
//别人分享过来的项目，打开时，“显示特征”按钮应有效，不影响数据的修改
if(!projectReadOnly){
projectObj.project.pushNow('editColSetting', projectObj.project.projSetting.moduleName, {
projectID: projectObj.project.ID(),
main_tree_col: projectObj.project.projSetting.main_tree_col
});
}
},
setVisible: function (field, visible) {
let mainTreeCols = projectObj.project.projSetting.main_tree_col.cols;
for(let colSetting of mainTreeCols){
if(colSetting.data.field === field){
colSetting.visible = visible;
break;
}
}
let mainGridCols = projectObj.project.projSetting.mainGridSetting.cols;
for(let colSetting of mainGridCols){
if(colSetting.data.field === field){
colSetting.visible = visible;
break;
}
}
},
getVisible: function(field){
let cols = projectObj.project.projSetting.main_tree_col.cols;
for(let colSetting of cols){
if(colSetting.data.field === field){
return colSetting.visible;
}
}
return false;
},
getColByField: function (field) {
let cols = projectObj.project.projSetting.main_tree_col.cols;
for(let i = 0; i < cols.length; i++){
let colSetting = cols[i];
if(colSetting.data.field === field){
return i;
}
}
return null;
},
getFieldByCol: function (col) {
let cols = projectObj.project.projSetting.main_tree_col.cols;
let colSetting = cols[col];
return colSetting ? colSetting.data.field : null;
}
};
function switchTznrHtml(show) {
if(show){
$('#switchTznr').html(' 显示特征');
}
else {
$('#switchTznr').html(' 隐藏特征');
}
}
$('#switchTznr').click(function () {
let me = colSettingObj;
let cur = $(this).text();
if(cur.includes('显示特征')){
switchTznrHtml(false);
me.setVisible('itemCharacterText', true);
me.updateColSetting(true);
}
else {
switchTznrHtml(true);
me.setVisible('itemCharacterText', false);
me.updateColSetting(true);
}
let mainSheet = projectObj.mainSpread.getActiveSheet();
mainSheet.showRow(mainSheet.getActiveRowIndex(), GC.Spread.Sheets.VerticalPosition.center);
});
$('#poj-set').on('shown.bs.modal', function (e) {
if (!colSettingObj.settingSpread) {
colSettingObj.initSettingSpread();
if(projectReadOnly){
disableSpread(colSettingObj.settingSpread);
}
}
if($('#tab_display_setting').hasClass('active')){
let sheet = colSettingObj.settingSpread.getActiveSheet();
SheetDataHelper.massOperationSheet(sheet, function () {
for(let row = 0; row < sheet.getRowCount(); row++){
let orgData = projectObj.project.projSetting.main_tree_col.cols[row].visible;
sheet.setValue(row, 0, orgData);
}
});
}
});
$('#poj-set').on('hidden.bs.modal', function (e) {
if (colSettingObj.settingSpread) {
//恢复
let sheet = colSettingObj.settingSpread.getActiveSheet();
SheetDataHelper.massOperationSheet(sheet, function () {
for(let row = 0; row < sheet.getRowCount(); row++){
let orgData = projectObj.project.projSetting.main_tree_col.cols[row].visible;
sheet.setValue(row, 0, orgData);
}
});
}
});
$('#tab_display_setting').on('shown.bs.tab', function () {
if(colSettingObj.settingSpread){
colSettingObj.settingSpread.refresh();
}
});