/**
* 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);
}*/
},
// CSL, 2018-02-09 用于测试显示。使用示例：projectObj.testDisplay(‘总额’, 100);
testDisplay: function (caption, value) {
let c = '';
if (caption) c = caption + ': ';
let s = ` ${c}${value}`;
$('#testDisplay').html(s);
},
treeSelectedChanged: function (node) {
let project = projectObj.project;
let mainSheet = projectObj.mainController.sheet;
//设置选中行底色和恢复前选中行底色
let refreshNodes = [node];
if(!project.mainTree.preSelected){
refreshNodes.push(project.mainTree.items[0]);
}
else {
refreshNodes.push(project.mainTree.preSelected);
}
project.mainTree.preSelected = node;
projectObj.setNodesStyle(projectObj.mainController.sheet, refreshNodes);
subViewObj.loadComments(node);
gljOprObj.showDataIfRationSelect(node);
if (activeSubSheetIs(subSheetIndex.ssiCalcProgram)) {
calcProgramObj.showData(node);
}
//zhong 2017-9-1 特征及内容
if(pageCCOprObj.active){
pageCCOprObj.mainActiveCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];//mainSpread焦点单元格
pageCCOprObj.setCacheAndShow(node);
}
// for test interface. CSLAAAAA
// projectObj.testDisplay('前四项累计值排除当前选中项' + projectObj.project.calcProgram.getBeforeTaxTotalFee([node]));
// 基数
// node.data.isSubcontract = true;
// node.data.gljList = project.ration_glj.getGljArrByRation(node.data);
// let bname = '甲供定额基价材料费';
// projectObj.testDisplay(bname, rationCalcBases[bname](node));
},
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(projectObj.project.isBillsLocked()== true){
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(projectObj.project.isBillsLocked()== true){
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()){
if(projectObj.project.isBillsLocked()== true){
return false;
}
if(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()){
if(projectObj.project.isBillsLocked()== true){
return false;
}
if(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'));
setButtonValid(!projectObj.project.isBillsLocked(), $('#ZLFB_btn'));
},
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);
}
},
getVisibleRows: function (sRow, count) {
let rst = [];
let nodes = projectObj.project.mainTree.items;
for(let i = sRow, len = nodes.length; i < len; i++){
if(count <= 0){
break;
}
if(nodes[i].visible){
rst.push(i);
count--;
}
}
return rst;
},
//获取粘贴更改的单元格（粘贴时，跳过隐藏行）
checkSpreadChangedCells: function (info) {
let rst = {refreshRows: [], changedCells: []};
//获取显示行号
let vRows = projectObj.getVisibleRows(info.row, info.rowCount);
let vCount = vRows.length;
let lastRow = null, count = 0;
for(let cell of info.changedCells){
cell.text = info.sheet.getCell(cell.row, cell.col).text();
if(cell.row !== lastRow){
count++;
lastRow = cell.row;
}
if(count <= vCount){
if(vRows[count - 1] !== cell.row){
rst.refreshRows.push(cell.row);
}
rst.changedCells.push({row: vRows[count - 1], col: cell.col, text: cell.text});
}
else {
rst.refreshRows.push(cell.row);
}
}
rst.refreshRows = Array.from(new Set(rst.refreshRows));
return rst;
},
updateBillsCode: function (node, value) {
let project = projectObj.project,me = this;
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) {
normalUpdate(node,value);
} 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);
node.data.name = data.name;
if(node.data.type == billType.BX){//从清单库中找到标准清单的话，要把补项改成分项
node.data.type = billType.FX;
}
pageCCOprObj.setItemContentNode(node, data.jobContent, data.itemCharacter, node.data.name);
if (/\//.test(data.unit)) {
let existB = projectObj.project.Bills.sameStdCodeBillsData(data.code);
if (existB) {
data.unit = existB.unit;
//
project.Bills.replaceBills(node.source, data, formatCode);
projectObj.mainController.refreshTreeNode([node], false);
} else {
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 {
normalUpdate(node,value);
}
});
}
}
if(node.data.type==billType.FX||node.data.type==billType.BX||(node.data.type==billType.BILL&&node.source.children.length==0)){//是分项、补项或者叶子清单的情况下才需要查找替换
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);
return;
} else {
if (confirm('已存在该编码的清单，是否继续？')) {
// formatCode = project.Bills.newFormatCode(stdMatchCode, node.data.code);
searchStdBillsAndUpdate(stdMatchCode, value);
return;
}else {
this.mainController.refreshTreeNode([node], false);
return;
}
}
}
}
normalUpdate(node,value);
function normalUpdate(billnode,codeValue) {//在标准库中没有找到清单时改分项为补项再更新
let toBX = false;
if(billnode.data.type == billType.FX){
billnode.data.type = billType.BX;
toBX = true;
}
project.Bills.updateField(billnode.source, 'code', codeValue, toBX);
me.mainController.refreshTreeNode([billnode], false);
}
},
updateRationCode: function (node, value) {
if(!isDef(node.data.code) && (!isDef(value) || value.toString().trim() == '')){
return;
}
if (projectInfoObj.projectInfo.engineeringInfo.ration_lib.length === 0) {
alert('当前项目无定额库，请添加定额库。');
this.mainController.refreshTreeNode([node], false);
} else {
let libId = parseInt($('#stdRationLibSelect').val());
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()) {
if(value && typeof(value) == 'string'){//小写转换成大写
value = value.toUpperCase();
}
project.Ration.updateRationCodes([{'node':node,value:value}]);
// this.updateRationCode(node, value); // 新套定额适合实时计算
// 这里因异步问题暂时缺少工料机价格。该过程移到：ration_glj.js的refreshAfterSave方法中。
/*project.calcProgram.calcAndSave(node);
if (activeSubSheetIs(subSheetIndex.ssiCalcProgram)) {
calcProgramObj.showData(node, false);
};*/
}
},
updateNodeField : function (node,value,filedID,callback) {
if(node.data[filedID] == value){
return;
}
let data = {
type:node.sourceType,
data:{
ID:node.data.ID
}
};
data.data[filedID] = value;
$.bootstrapLoading.start();
projectObj.project.updateNodes([data],function () {
node.data[filedID] = value;
if(callback){
callback();
}
$.bootstrapLoading.end();
})
},
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(fieldName === 'remark'){
projectObj.updateNodeField(node,value,'remark');
} else if(calcTools.isGljRation(node)){
gljOprObj.updateRationTypeGLJ(value,node,fieldName,editingText);
} else if (value !== calcFees.getFee(node.data, fieldName)||fieldName == 'quantity') {//工程量需要进行转换，所以做特殊处理
if (fieldName === 'code' && !calcTools.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 === 'feesIndex.common.unitFee' || fieldName === 'programID' ||
fieldName === 'subType' || fieldName === 'calcBase' || fieldName === 'isSubcontract'){
if (fieldName === 'quantity') {
project.quantity_detail.editMainTreeNodeQuantity(value,node,fieldName,editingText);
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 === 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.mainController.refreshTreeNode([node]);
return;
}
// if (value) {value = parseFloat(value).toDecimal(decimalObj.decimal("totalPrice", node))};
};
//计算基数赋值要经过解析和标准化，已在calculate里赋值
if(fieldName !== 'calcBase'){
calcTools.setFieldValue(node, fieldName, value);
};
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, false);
}
else if (node.sourceType === project.Ration.getSourceType()) {
project.Ration.updateField(node.source, fieldName, value);
};
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;
projectObj.lastCell = {row: info.row, col: info.col};
},
//repaint 动态下拉框
mainSpreadEnterCell: function (sender, info) {
let colSetting = projectObj.mainController.setting.cols[info.col];
if(colSetting.data.field === 'unit' || (projectObj.lastCol&&projectObj.lastCol.data.field === 'unit')||colSetting.data.field ==='subType'
|| (projectObj.lastCol&&projectObj.lastCol.data.field === 'subType') || colSetting.data.field === 'programID' ||(projectObj.lastCol&&projectObj.lastCol.data.field === 'programID')){
let rects = [];
rects.push(info.sheet.getCellRect(info.row, info.col));
if(projectObj.lastCell){
rects.push(info.sheet.getCellRect(projectObj.lastCell.row, projectObj.lastCell.col));
}
for(let rect of rects){
info.sheet.repaint(rect);
}
}
},
mainSpreadEditStarting: function (sender, info) {
let project = projectObj.project;
let node = project.mainTree.items[info.row];
let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
let orgV = info.sheet.getValue(info.row, info.col);
let newV;
if(node && node.sourceType === projectObj.project.Ration.getSourceType() && node.data.type === rationType.ration
&& isDef(node.data.code) && isDef(node.data.prefix) && node.data.prefix !== rationPrefix.none && fieldName === 'code'){
if(node.data.prefix === rationPrefix.complementary){
newV = orgV.replace(new RegExp('补'), '');
}
if(node.data.prefix === rationPrefix.borrow){
newV = orgV.replace(new RegExp('借'), '');
}
info.sheet.setValue(info.row, info.col, newV);
}
},
onCellDoubleClick: function (sender, info){
let project = projectObj.project;
let node = project.mainTree.items[info.row];
let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
if(fieldName == 'marketUnitFee'){
if(gljOprObj.hasComposition(node.data,true)){
alert("当前人材机的市场价由组成物计算得出，不可直接修改。");
return;
}
}
},
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);
}
},
msClipboardChanged: function (sender, info) {
let colSettings = projectObj.mainController.setting.cols;
let cDatas = sheetCommonObj.getTableData(info.sheet, colSettings);
sheetCommonObj.copyTextToClipboard(cDatas);
return;
},
mainSpreadRangeChanged: function (sender, info) {
let project = projectObj.project, setting = projectObj.mainController.setting;
let changedObj = projectObj.checkSpreadChangedCells(info);
let refreshNodes = [];
for(let row of changedObj.refreshRows){
refreshNodes.push(project.mainTree.items[row]);
}
let updateRationCodes = [];//更新定额编码时要用同步的方式
if(changedObj.changedCells.length > 0){
for (let changedCell of changedObj.changedCells) {
let node = project.mainTree.items[changedCell.row];
let colSetting = setting.cols[changedCell.col];
let value = projectObj.checkSpreadEditingText(changedCell.text, colSetting)
if(colSetting.data.field=='code'&& node.sourceType == project.Ration.getSourceType()&&node.data.type==rationType.ration){//如果是更新定额的编码
updateRationCodes.push({'node':node,value:value});
}else {
projectObj.updateCellValue(node, value, colSetting,changedCell.text);
}
}
}
if(updateRationCodes.length>0){
project.Ration.updateRationCodes(updateRationCodes);
}
if(refreshNodes.length > 0){
projectObj.mainController.refreshTreeNode(refreshNodes);
}
},
checkMainSpread: function () {
if (!this.mainSpread) {
this.mainSpread = SheetDataHelper.createNewSpread($('#billsSpread')[0]);
this.mainSpread.getActiveSheet().selectionPolicy(GC.Spread.Sheets.SelectionPolicy.muliRange);
this.mainSpread.getActiveSheet().name('mainSheet');
}
},
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);
$.bootstrapLoading.start();
this.project.loadDatas(function (err) {
let mTime = +new Date();
console.log(`get data时间——${mTime - startTime}`);
if (!err) {
that.project.projectGLJ.calcQuantity(true);//计算分部分项和技术措施项目消耗量;
let quantityTime = +new Date();
console.log(`计算quantity时间——${quantityTime - mTime}`);
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);
that.project.projSetting.mainGridSetting.setAutoFitRow = MainTreeCol.getEvent("setAutoFitRow");
that.project.projSetting.mainGridSetting.cols.forEach(function (col) {
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 = '@';
}
col.setAutoHeight = MainTreeCol.getEvent("setAutoHeight");
col.editChecking = MainTreeCol.getEvent("editChecking");
// 根据配置设置自动行高,在这里先做个标记，然后对每个单元格单独配置
if (col.data.field === 'name' || col.data.field === 'itemCharacterText' ||
col.data.field === 'jobContentText' || col.data.field === 'adjustState') {
col.data.autoHeight = true;
col.showHint = 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)
// }
});
let startShowTime = +new Date();
that.mainController = TREE_SHEET_CONTROLLER.createNew(that.project.mainTree, that.mainSpread.getActiveSheet(), that.project.projSetting.mainGridSetting);
that.mainController.showTreeData();
let endShowTime = +new Date();
console.log(`show data时间——${endShowTime - startShowTime}`);
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);
setTimeout(function () {
that.mainSpread.getActiveSheet().startEdit();//这两句需要挺多时间,而又需要在editend 事件前触发，而这些又不影响计算，所以这里用异步的方法
that.mainSpread.getActiveSheet().endEdit();
that.mainSpread.bind(GC.Spread.Sheets.Events.EditEnded, that.mainSpreadEditEnded);
},100);
that.mainSpread.bind(GC.Spread.Sheets.Events.SelectionChanged, that.amountAreaNumber);
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.RangeChanged, that.mainSpreadRangeChanged);
that.mainSpread.bind(GC.Spread.Sheets.Events.ClipboardChanged, that.msClipboardChanged);
that.mainSpread.bind(GC.Spread.Sheets.Events.ButtonClicked, that.onButtonClick);
that.mainSpread.bind(GC.Spread.Sheets.Events.CellDoubleClick, that.onCellDoubleClick);
//let loadOtherStartTime = +new Date();
that.loadMainSpreadContextMenu();
that.loadFocusLocation();
socketObject.connect();//连接socket服务器
let endTime = +new Date();
console.log(`其它时间——${endTime - endShowTime}`);
console.log("加载完成-----"+endTime);
console.log(`时间——${endTime - startTime}`);
that.project.projectMarkChecking();//是否需要重新进行造价计算
installationFeeObj.engineeringTypeChecking();//检查是否安装工程
autoFlashHeight();
projectObj.refreshMainSpread();
//定位到会话中的选项
let mainTabFocus = sessionStorage.getItem('mainTab') ? sessionStorage.getItem('mainTab') : '#tab_zaojiashu';
$(`${mainTabFocus}`).click();
$.bootstrapLoading.end();
}
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 projectObj.project.isBillsLocked();
//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(projectObj.project.isBillsLocked()== false&&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 ||selected.children[0].data.type==billType.BX;//焦点行是分部分项工程，且子项是分项或补项
}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(projectObj.project.isBillsLocked()== false&& selected&&selected.sourceType==project.Bills.getSourceType()){
if(selected.data.type==billType.FX||selected.data.type==billType.BX){//焦点行是分项，有效显示
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 () {
let selected = project.mainTree.selected;
if(projectObj.project.isBillsLocked()== false && selected && selected.sourceType === project.Bills.getSourceType()){
return false
}
return true;
},
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) {
project.Ration.addNewRation(null,rationType.ration);
// ProjectController.addRation(project, controller, rationType.ration);
},
visible: function(key, opt){
var selected = project.mainTree.selected;
if(selected){
return canInsertRationNode(selected);
}
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) {
project.Ration.addNewRation(null,rationType.volumePrice);
// ProjectController.addRation(project, controller, rationType.volumePrice);
},
visible: function(key, opt){
var selected = project.mainTree.selected;
if(selected){
return canInsertRationNode(selected);
}
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){
return canInsertRationNode(selected);
}
return false;
}
},
"calc_installation_fee": {
name: "计取安装费用",
icon: 'fa-sign-in',
disabled: function () {
return false;
},
callback: function (key, opt) {
installationFeeObj.showCalcInstallSettingDiv();
},
visible: function(key, opt){
let engineering = projectInfoObj.projectInfo.property.engineering;
return engineering==engineeringType.BUILD_IN;
}
},
"spr1": '--------',
"delete": {
name: '删除',
icon: 'fa-remove',
disabled: function () {
return !ifCanDelete();
},
callback: function () {
var selected = project.mainTree.selected;
if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length<=0){//选中的是分部，并且没有子项，直接删除
project.Bills.deleteSelectedNode();
}else {
$("#delete_row").modal({show:true});//弹出删除提示框;
}
}
},
"spr2":'--------',
"calculateAll_RationContent": {
name: '造价计算',
callback: function () {
project.calcProgram.calcAllNodesAndSave();
}
},
"spr2":'--------',
"copyBlock": {
name: '复制整块',
icon: 'fa-copy',
disabled: function () {
let selection = projectObj.mainSpread.getActiveSheet().getSelections()[0];
let firstNode = projectObj.project.mainTree.items[selection.row];//当多选的情况，用mainTree.selected判断不正确,要用第一个选中的节点
return BlockController.copyBtnDisable(firstNode);
},
callback: function () {
$.bootstrapLoading.start();
//let selected = project.mainTree.selected;
let selections = projectObj.mainSpread.getActiveSheet().getSelections();
setTimeout(function () {
BlockController.copyBlock(selections[0]);
$.bootstrapLoading.end();
},100)
}
},
"spr2":'--------',
"pasteBlock": {
name: '粘贴整块',
icon: 'fa-paste',
disabled: function (){
return BlockController.pasteBtnDisable(project.mainTree.selected);
},
callback: function () {
BlockController.pasteBlock(project.mainTree.selected);
}
}
}
});
},
// 计算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 = 0;
col = 0;
}
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.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);
};
},
onButtonClick: function (e, info) {
let colSetting = projectObj.mainController.setting.cols[info.col];
let node = projectObj.project.mainTree.items[info.row];
let fieldName = colSetting.data.field;
if(fieldName == "isSubcontract"){
projectObj.onSubcontractClick(node);
}else if(fieldName == "isEstimate"){
projectObj.onIsEstimateClick(node,info);
}
},
onIsEstimateClick: function(node,info){
let checkboxValue = info.sheet.getCell(info.row, info.col).value();
let cell = info.sheet.getCell(info.row, info.col), newval = 0;
if (checkboxValue) {
newval = 0;
cell.value(newval);
} else {
newval = 1;
cell.value(newval);
}
if(MainTreeCol.readOnly.bills(node)){
projectObj.updateNodeField(node,newval,'isEstimate');
}else if(node.data.projectGLJID){//更新的是定额类型的工料机或者是显示在造价书页面的主材、设备
console.log(node);
let updateData = {id: node.data.projectGLJID, field: 'is_evaluate', value: newval};
projectObj.project.projectGLJ.pGljUpdate(updateData);
}
},
onSubcontractClick:function (node) {//点击分包费checkbox
if (node.data.isSubcontract) node.data.isSubcontract = false;
else node.data.isSubcontract = true;
node.changed = true;
projectObj.project.calcProgram.calcAndSave(node);
},
//根据节点获取行style(颜色、字体加粗)
getNodeColorStyle: function (sheet, node, colSetting = null) {
let colorSetting = optionsOprObj.getOption(optionsOprObj.optionsTypes.COLOROPTS);
let mapping = {DEFAULT: 'DEFAULT', SELECTED: 'SELECTED', DXFY: 'DXFY', FB: 'FB', UNLEAFBILL: 'UNLEAFBILL',
FX: 'FX', BX: 'BX', UNCBBILL: 'UNCBBILL', CBBILL: 'CBBILL', ZCSB: 'ZCSB'};
let styleMap = null;
//中文字段名，由于同一节点中，中文字体大小和数字字体大小不同
if(colorSetting == null){
return 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.BX){
styleMap = mapping.BX;
}
//清单
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;
}
}*/
}
//选中行-替换底色
if(node === this.project.mainTree.selected){
style.backColor = colorSetting[mapping.SELECTED]['backColor'];
}
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) {
let style = new GC.Spread.Sheets.Style();
if(node.sourceType !== this.project.Bills.getSourceType() || node.data.type !== billType.DXFY){
return null
}
//备注暂无字段
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;
},
//设置节点style
setNodesStyle: function (sheet, nodes) {
let me = this;
TREE_SHEET_HELPER.massOperationSheet(sheet, function () {
for(let node of nodes){
if(node && node.serialNo()!= -1){
sheet.getRange(node.serialNo(), -1, 1, -1).backColor(me.getNodeColorStyle(sheet, node).backColor);
}
}
});
},
loadLockBillsButton:function () {
if(projectInfoObj.projectInfo.property.lockBills == true){
$("a[name='lockBills']").prop("title","解锁清单");
$("a[name='lockBills']").html(' 解锁清单');
}else {
$("a[name='lockBills']").prop("title","锁定清单");
$("a[name='lockBills']").html(' 锁定清单');
}
}
};
// 点击合计框中的复制
$("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 () {
let project = projectObj.project;
let selected = project.mainTree.selected;
if(isSingleSelect()&&selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length<=0){//选中的是分部，并且没有子项，直接删除
project.Bills.deleteSelectedNode();
}else {
$("#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();
};
}
});
$("a[name='lockBills']").click(function () {
let lockBills = projectInfoObj.projectInfo.property.lockBills;
lockBills = !lockBills;
projectObj.project.updateLockBills(lockBills,function () {
var controller = projectObj.mainController, project = projectObj.project;
var selected = controller.tree.selected;
let nodes = _.filter(project.mainTree.items,{'sourceType':ModuleNames.bills});
controller.refreshTreeNode(nodes);
projectObj.mainController.setTreeSelected(selected);//触发树节点选中事件
projectObj.loadLockBillsButton();
pageCCOprObj.refreshRuleTools(lockBills);
});
});
$('#ZLFB_btn').click(function () {
zlfb_object.getSectionInfo();
});
//工料机库
$('#compleGljLib').click(function () {
let newTab = window.open('about:blank');
let newHref = '/complementaryGlj';
CommonAjax.get(newHref, [], function () {
newTab.location.href = newHref;
});
});
//显示至..
let displayLevel = function(nodes, depth, type){
let refreshNodes = [];
function getExpandedController(){
if(type === 'DXFY' || type === 'FB'){
if(type === 'FB'){
projectObj.project.mainTree.items[0].setExpanded(true);
refreshNodes.push(projectObj.project.mainTree.items[0]);
}
return function expandedControl(nodes, depth){
let bType = type === 'FB' ? billType.FB : billType.DXFY;
for(let node of nodes){
let nodeDepth = node.depth();
if(nodeDepth <= depth){
let expanded = nodeDepth === depth && !node.children[0] || nodeDepth < depth && node.children[0] && node.children[0].data.type === bType ? true : false;
node.setExpanded(expanded);
refreshNodes.push(node);
if(nodeDepth < depth){
expandedControl(node.children, depth);
}
}
}
}
}
else if(type === 'FX' || type === 'ZM' || type === 'ZD'){
return function expandedControl(nodes){
for(let node of nodes){
if(type !== 'FX' || node.sourceType === projectObj.project.Bills.getSourceType()){
let expanded = true;
if(type === 'FX'){
expanded = !node.children[0] || node.children[0] && node.children[0].sourceType === projectObj.project.Bills.getSourceType() ? true : false;
}
else if(type === 'ZM'){
expanded = !node.children[0] || node.children[0] && node.children[0].sourceType !== projectObj.project.ration_glj.getSourceType() ? true : false;
}
node.setExpanded(expanded);
refreshNodes.push(node);
expandedControl(node.children);
}
}
}
}
}
getExpandedController()(nodes, depth);
let sheet = projectObj.mainSpread.getActiveSheet();
TREE_SHEET_HELPER.massOperationSheet(sheet, function () {
TREE_SHEET_HELPER.refreshNodesVisible(refreshNodes, projectObj.mainSpread.getActiveSheet(), true)
});
};
$('#displayDXFY').click(function () {
displayLevel(projectObj.project.mainTree.items, 0, 'DXFY')
});
//显示至一级分部
$('#displayFB1').click(function () {
displayLevel(projectObj.project.mainTree.items[0].children, 1, 'FB');
});
//二级分部
$('#displayFB2').click(function () {
displayLevel(projectObj.project.mainTree.items[0].children, 2, 'FB');
});
//三级分部
$('#displayFB3').click(function () {
displayLevel(projectObj.project.mainTree.items[0].children, 3, 'FB');
});
//四级分部
$('#displayFB4').click(function () {
displayLevel(projectObj.project.mainTree.items[0].children, 4, 'FB');
});
//分项
$('#displayFX').click(function () {
displayLevel(projectObj.project.mainTree.items, null, 'FX');
});
//子目
$('#displayZM').click(function () {
displayLevel(projectObj.project.mainTree.items, null, 'ZM');
});
//最底层
$('#displayZD').click(function () {
displayLevel(projectObj.project.mainTree.roots, null, 'ZD');
});
$('#poj-set').on('show.bs.modal', function () {
let setCalcFlag = function (obj, val, curFlag) {
obj.val(val);
if (val === curFlag) {
obj.prop('checked', true);
} else {
obj.prop('checked', false);
}
}
if (projectObj.project) {
let ft = projectObj.project.property.billsCalcMode ? projectObj.project.property.billsCalcMode : leafBillGetFeeType.rationContent;
let zg = projectObj.project.property.zanguCalcMode ? projectObj.project.property.zanguCalcMode : zanguCalcType.common;
setCalcFlag($('#rationContent'), leafBillGetFeeType.rationContent, ft);
setCalcFlag($('#rationPriceConverse'), leafBillGetFeeType.rationPriceConverse, ft);
setCalcFlag($('#rationPrice'), leafBillGetFeeType.rationPrice, ft);
setCalcFlag($('#billsPrice'), leafBillGetFeeType.billsPrice, ft);
setCalcFlag($('#zangu_common'), zanguCalcType.common, zg);
setCalcFlag($('#zangu_gatherMaterial'), zanguCalcType.gatherMaterial, zg);
projDisplayView.init();
calcOptions.init();
}
});
$('#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 = calcTools.cutNodeForSave(node);
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;
}
function needToReload(mixDatas){
if(Object.keys(mixDatas.labourCoes).length > 0){
return true;
}
if(Object.keys(mixDatas.properties).length > 0){
if(mixDatas.properties.hasOwnProperty('property.billsCalcMode') ||
mixDatas.properties.hasOwnProperty('property.zanguCalcMode') ||
mixDatas.properties.hasOwnProperty('property.calcOptions')||
mixDatas.properties.hasOwnProperty('property.billsQuantityDecimal')||
mixDatas.properties.hasOwnProperty('property.decimal')||
mixDatas.properties.hasOwnProperty('property.displaySetting')){
return true;
}
}
return false;
}
if(hasMixData()){
CommonAjax.post('/pm/api/updateMixDatas', {user_id: userID, mixDataArr: mixDatas}, function (rstData) {
//需要重载页面
if(needToReload(mixDatas)){
window.location.href = '/main?project=' + projectID;
}
else{
if(mixDatas.properties.hasOwnProperty('property.basicInformation')){
basicInfoView.orgDatas = basicInfoView.toViewDatas(mixDatas.properties['property.basicInformation']);
}
if(mixDatas.properties.hasOwnProperty('property.projectFeature')){
projFeatureView.orgDatas = projFeatureView.toViewDatas(mixDatas.properties['property.projectFeature']);
}
}
});
}
});
function testShow() {
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').html(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;i0){//选中的是分部，并且有子项
if(isSingleSelect()||selectionChecking()){
showinfo = "
";
showN = true;
cancelText = "取消";
}
}
$('#delete_showinfo').html(showinfo);
showN==true? $('#deleteN').show():$('#deleteN').hide();
$('#deleteCancel').text(cancelText);
function selectionChecking() {
let selection = projectObj.mainSpread.getActiveSheet().getSelections()[0];
let mainTreeMap = {}, nodes = [];
for(let i =0;i0&&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(projectObj.project.isBillsLocked()== true){
return false;
}
if(projectObj.project.Bills.hasFlags(node)){
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 0){
$('.custom-file-label').text(`${file.files[0].name} 准备导入上传`);
$('#uploadAlert').hide();
}
else{
$('.custom-file-label').text(`请选择上传文件`);
}
});
//从excel导入清单
$('#uploadConfirm').click(function () {
let me = this;
$(me).addClass('disabled');
try{
let formData = new FormData();
let file = $('#customFile')[0];
if(file.files.length <= 0){
throw '未选择文件';
}
formData.append('file', file.files[0]);
let projectID = scUrlUtil.GetQueryString('project');
if(!projectID || projectID <= 0){
throw '项目数据出错';
}
formData.append('projectID', projectID);
//要去匹配的清单库（第一个）
let matchBillLibId = projectInfoObj.projectInfo.engineeringInfo.bill_lib.length > 0 ? projectInfoObj.projectInfo.engineeringInfo.bill_lib[0].id : null;
formData.append('billsLibId', matchBillLibId);
$.ajax({
url: '/bills/upload',
type: 'POST',
data: formData,
cache: false,
contentType: false,
processData: false,
beforeSend: function() {
$.bootstrapLoading.start();
},
success: function(response){
if (response.err === 0) {
const message = response.msg !== undefined ? response.msg : '';
if (message !== '') {
alert(message);
}
// 成功则关闭窗体
$('#import').modal("hide");
//更新前端
doAfterImport(response.data);
} else {
const message = response.msg !== undefined ? response.msg : '上传失败!';
$.bootstrapLoading.end();
alert(message);
}
$(me).removeClass('disabled');
},
error: function(){
alert("与服务器通信发生错误");
$.bootstrapLoading.end();
$(me).removeClass('disabled');
}
});
}
catch (err){
//alert(err);
showUploadAlert(false, err);
$(me).removeClass('disabled');
}
});
function showUploadAlert(success, msg){
if(!success){
$('#uploadAlert').removeClass('alert-success');
$('#uploadAlert').addClass('alert-danger');
}
else{
$('#uploadAlert').removeClass('alert-danger');
$('#uploadAlert').addClass('alert-success');
}
$('#uploadAlert').text(msg);
$('#uploadAlert').show();
}
//导入后更新操作
function doAfterImport(resData){
if(resData){
let nodes = projectObj.project.mainTree.nodes;
let bills_datas = projectObj.project.Bills.datas;
let ration_datas = projectObj.project.Ration.datas;
let quantity_detail_datas = projectObj.project.quantity_detail.datas;
let ration_glj_datas = projectObj.project.ration_glj.datas;
let ration_coe_datas = projectObj.project.ration_coe.datas;
let ration_install_datas = projectObj.project.ration_installation.datas;
let delNodes = [];
for(let billID of resData.remove.bill){
if(nodes['id_' + billID]){
delNodes.push(nodes['id_' + billID]);
}
//清除清单数据
_.remove(bills_datas, {ID: billID});
//清除清单工程量明细数据
_.remove(quantity_detail_datas, {billID: billID});
}
for(let rationID of resData.remove.ration){
//清除定额数据
_.remove(ration_datas, {ID: rationID});
//清除定额下的相关数据
_.remove(ration_glj_datas, {rationID: rationID});
_.remove(ration_coe_datas, {rationID: rationID});
_.remove(ration_install_datas, {rationID: rationID});
_.remove(quantity_detail_datas, {rationID: rationID});
}
//删除节点
if(delNodes.length > 0){
//通过固定清单获得删除节点的起始行索引
let beginRow = null;
if(resData.fixedBill){
let fixedNode = nodes['id_' + resData.fixedBill.ID];
if(fixedNode){
beginRow = projectObj.project.mainTree.items.indexOf(fixedNode) + 1;
}
}
//删除主树节点
projectObj.mainController.m_delete(delNodes, beginRow);
//删除清单树节点
let delIdNodes = [];
for(let delNode of delNodes){
delIdNodes.push(delNode.source);
}
projectObj.project.Bills.tree.m_delete(delIdNodes);
}
if(resData.insert.bill.length > 0){
//设置flagsIndex
for(let insertBill of resData.insert.bill){
insertBill.flagsIndex = {};
if (insertBill.flags) {
insertBill.flags.forEach(function (flag) {
insertBill.flagsIndex[flag.fieldName] = flag;
});
}
}
//插入清单节点
projectObj.project.Bills.tree.insertByDatas(resData.insert.bill);
//插入主树节点
let newNodes = projectObj.project.mainTree.insertByDatas(resData.insert.bill);
for(let node of newNodes){
node.source = projectObj.project.Bills.tree.nodes['id_' + node.getID()];
node.data = node.source.data;
node.sourceType = projectObj.project.Bills.getSourceType();
}
ProjectController.syncDisplayNewNodes(projectObj.mainController, newNodes);
}
//如果清单未锁定，导入后锁定清单
if(!projectInfoObj.projectInfo.property.lockBills){
$("a[name='lockBills']").click();
}
$.bootstrapLoading.end();
//重算
projectObj.project.calcProgram.calcAllNodesAndSave(calcAllType.catAll, function () {
projectObj.project.projectGLJ.loadData(function () {
$.bootstrapLoading.end();
});
});
}
}
//下载导入清单示例文件
$('#uploadExample').click(function () {
window.location.href = '/bills/downloadExamp'
});
$(function () {
//清空导入清单选择文件
$('#import').on('show.bs.modal', function(){
$('#customFile').val('');
$('#uploadAlert').hide();
$('.custom-file-label').text(`请选择上传文件`);
});
$("#billsSpread").mouseover(function(){
spreadAutoFocus(projectObj.mainSpread,subSpread);
});
$("#subSpread").mouseover(function(){
spreadAutoFocus(subSpread,projectObj.mainSpread);
});
$("#paste_confirm").click(function (){
let selected = projectObj.project.mainTree.selected;
let blockData = BlockController.getBlockData();
let position = $("input[name='pastePositionRadio']:checked").val();
BlockController.confirmPaste(blockData,selected,position);
$("#pastePosition").modal("hide");
});
function spreadAutoFocus(spread,relateSpread) {
if(relateSpread&&relateSpread.getActiveSheet().isEditing()){//关联的spread不在编辑状态的情况下，才自动获得焦点;
return;
}else {
spread?spread.focus():'';
}
}
});