/** * Created by Mai on 2017/6/21. */ var projectObj = { project: null, mainSpread: null, mainController: null, gljSpreed:null, beforeMainTreeSelectedChange: function (node) { /*if (node) { subViewObj.saveComments(node); }*/ }, treeSelectedChanged: function (node) { let project = projectObj.project; subViewObj.loadComments(node); gljOprObj.showDataIfRationSelect(node); // CSL.2017.07.25 if (activeSubSheetIs(subSheetIndex.ssiCalcProgram)) { calcProgramObj.showData(node); }; //zhong 2017-9-1 特征及内容 if(pageCCOprObj.active){ pageCCOprObj.mainActiveCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];//mainSpread焦点单元格 if(node.sourceType === project.Bills.getSourceType()){ pageCCOprObj.setCacheAndShow(node); } else{ pageCCOprObj.clearData(); } } }, refreshBaseActn: function (tree) { let setButtonValid = function (valid, btn) { if (valid) { btn.removeClass('disabled'); } else { btn.addClass('disabled'); } }; let selected = tree.selected, that = projectObj; let canUpLevel = function (node) { if (selected && selected.depth() > 0 && selected.canUpLevel()) { if (selected.sourceType === that.project.Bills.getSourceType()) { return (!selected.nextSibling) || (selected.children.length === 0) || (selected.source.children.length > 0); } else { return false; } } else { return false; } }; let canDownLevel = function (node) { if (selected && selected.depth() > 0 && selected.canDownLevel()) { if (selected.sourceType === that.project.Bills.getSourceType()) { return (selected.preSibling.children.length === 0) || (selected.preSibling.source.children.length > 0); } else { return false; } } else { return false; } }; let canDelete = function (node) { if (selected) { if (selected.sourceType === that.project.Bills.getSourceType()) { if(selected.data.type == billType.DXFY&&selected.data.isAdd!=1){//如果 return false; } }if(selected.sourceType === that.project.ration_glj.getSourceType()){ return false; } return true; } else { return false; } }; setButtonValid(canUpLevel(selected), $('#upLevel')); setButtonValid(canDownLevel(selected), $('#downLevel')); setButtonValid(selected && (selected.depth() > 0) && selected.canUpMove(), $('#upMove')); setButtonValid(selected && (selected.depth() > 0) && selected.canDownMove(), $('#downMove')); setButtonValid(canDelete(selected), $('#delete')); }, checkCommonField: function (editingText, colSetting) { let value; if (colSetting.data.decimal) { value = Number(editingText); if (number_util.isNumber(value)) { if (colSetting.data.decimal) { value = value.toDecimal(colSetting.data.decimal); } } else { value = null; alert('当前输入的数据类型不正确，请重新输入。'); } } else { value = editingText; } return value; }, checkFormulaValidField: function (editingText, colSetting) { let value = Number(editingText); if (!value) { try { let exp = new Expression(''); exp.Expression(editingText); value = Number(exp.Evaluate()); } catch (error) { value = null; } } if (value!=undefined||value!=null) { if (colSetting.data.decimal) { value = value.toDecimal(colSetting.data.decimal); } } else if (editingText && editingText !== '') { value = null; alert('当前输入的数据类型不正确，请重新输入。'); } return value; }, checkSpreadEditingText: function (editingText, colSetting) { if (colSetting.data.field === 'quantity'||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); } }, /*updateAndReCalculate: function (node, fieldName, value) { let project = projectObj.project, calc = new BillsCalcHelper(project), nodes = []; let getNodes = function (node) { let cur = node, nodes = []; while (cur) { nodes.push(cur); cur = cur.parent; } return nodes; } if (value) { value = value.toDecimal(projectObj.project.Decimal.common.quantity); } if (node.sourceType === projectObj.project.Bills.getSourceType()) { calcFees.setFee(node.data, fieldName, value); calc.calcNode(node, true); nodes = getNodes(node); project.Bills.updateNodes(nodes, true); } else if (node.sourceType === projectObj.project.VolumePrice.getSourceType()) { project.beginUpdate('VolumePrice_QuantityChange'); project.VolumePrice.updateField(node.source, fieldName, value, false); calc.calcNode(node.parent, true); nodes = getNodes(node.parent); project.Bills.updateNodes(nodes, false); project.endUpdate(); nodes.push(node); } else if (node.sourceType === projectObj.project.Ration.getSourceType()) { project.beginUpdate('Ration_QuantityChange'); calcFees.setFee(node.data, fieldName, value); node.data.gljList = project.ration_glj.getGljArrByRation(node.data.ID); // calcProgram.calculate的传参必须是cacheNode类型，故无法将计算放在Ration模块中。 project.calcProgram.calculate(node); project.Ration.updateRation(node.source, false); // 加入待存储队列 calc.calcNode(node.parent, true); // nodes = getNodes(node.parent); project.Bills.updateNodes(nodes, false); project.endUpdate(); nodes.push(node); } this.mainController.refreshTreeNode(nodes, false); calc = null; },*/ updateBillsCode: function (node, value) { let project = projectObj.project; let stdMatchCode, formatCode, matchs; let searchStdBillsAndUpdate = function (stdCode, formatCode) { let orgCode = node.data.code.substr(0, 9); if (stdCode === orgCode || projectInfoObj.projectInfo.engineeringInfo.bill_lib.length === 0) { project.Bills.updateField(node.source, 'code', formatCode, true); projectObj.mainController.refreshTreeNode([node], false); } else if (projectInfoObj.projectInfo.engineeringInfo.bill_lib.length > 0) { let libId = projectInfoObj.projectInfo.engineeringInfo.bill_lib[0].id; CommonAjax.post('/stdBillsEditor/getStdBillsByCode', {userId: userID, billsLibId: libId, code: stdCode}, function (data) { if (data) { data.itemCharacter = pageCCOprObj.safeItemCharater(data.itemCharacter); if (/\//.test(data.unit)) { ConfirmModal.stdBillsUnit.check(data, function (std) { project.Bills.replaceBills(node.source, std, formatCode); projectObj.mainController.refreshTreeNode([node], false); }, function () { projectObj.mainController.refreshTreeNode([node], false); }); } else { project.Bills.replaceBills(node.source, data, formatCode); projectObj.mainController.refreshTreeNode([node], false); } } else { project.Bills.updateField(node.source, 'code', formatCode, true); projectObj.mainController.refreshTreeNode([node], false); } }); } } if (value&&value.length === 9 && /^[\d]+$/.test(value)) { stdMatchCode = value; formatCode = project.Bills.newFormatCode(stdMatchCode); searchStdBillsAndUpdate(stdMatchCode, formatCode); } 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); } } else { 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) { let project = projectObj.project, fieldName = colSetting.data.field; if(node.sourceType==project.ration_glj.getSourceType()){ project.ration_glj.updateFromMainSpread(value,node,fieldName); }else if(treeNodeTools.isGljRation(node)){ gljOprObj.updateRationTypeGLJ(value,node,fieldName); } else if (value !== calcFees.getFee(node.data, fieldName)||fieldName == 'quantity') {//工程量需要进行转换，所以做特殊处理 if (fieldName === 'code' && !treeNodeTools.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' || fieldName === 'feesIndex.common.unitFee'){ if (fieldName === 'quantity') { project.quantity_detail.editMainTreeNodeQuantity(value,node,fieldName); 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.mainSpread.getActiveSheet().setValue(activeCell.row, activeCell.col, node.data.calcBase? node.data.calcBase: ''); return; } // if (value) {value = parseFloat(value).toDecimal(decimalObj.decimal("totalPrice", node))}; }; node.changed = true; if (fieldName == 'feesIndex.common.unitFee'){ treeNodeTools.initFeeField(node, 'common'); node.data.feesIndex.common.unitFee = value; } else if(fieldName !== 'calcBase'){ node.data[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, 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); // 自动行高 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; } // for test digit. CSLAAAAA if (col.data.field.hasSubStr("totalFee")) col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.totalPrice, false) else if (col.data.field.hasSubStr("unitFee")) col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.unitPrice, false) else if (col.data.field == "quantity") col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.quantity, false); }); that.mainController = TREE_SHEET_CONTROLLER.createNew(that.project.mainTree, that.mainSpread.getActiveSheet(), that.project.projSetting.mainGridSetting); that.mainController.showTreeData(); that.mainController.bind('refreshBaseActn', that.refreshBaseActn); that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.beforeTreeSelectedChange, that.beforeMainTreeSelectedChange); that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.treeSelectedChanged, that.treeSelectedChanged); that.mainSpread.bind(GC.Spread.Sheets.Events.LeaveCell, that.mainSpreadLeaveCell); that.mainSpread.bind(GC.Spread.Sheets.Events.EnterCell, that.mainSpreadEnterCell); that.mainSpread.bind(GC.Spread.Sheets.Events.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); } 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); cbTools.refreshFormulaNodes(); }, 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.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); cbTools.refreshFormulaNodes(); }, visible: function(key, opt){ return project.Bills.isFBFX(project.mainTree.selected );//不属于分部分项的话隐藏 } }, "insertFX": { name: "插入分项", icon: 'fa-sign-in', disabled: function () { let selected = project.mainTree.selected; if(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); cbTools.refreshFormulaNodes(); }, visible: function(key, opt){ return project.Bills.isFBFX(project.mainTree.selected );//不属于分部分项的话隐藏 } }, "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); cbTools.refreshFormulaNodes(); }, visible: function(key, opt){ return project.Bills.isFBFX(project.mainTree.selected)==true?false:true;//不属于分部分项的话隐藏 } }, "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); cbTools.refreshFormulaNodes(); }, visible: function(key, opt){ var selected = project.mainTree.selected; if(selected.sourceType == ModuleNames.bills&&selected.data.type == billType.DXFY){ return false }else { return true } } }, "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); cbTools.refreshFormulaNodes(); }, visible: function(key, opt){ var selected = project.mainTree.selected; if(selected.sourceType == ModuleNames.bills&&selected.data.type == billType.DXFY){ return false }else { return true } } }, "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); cbTools.refreshFormulaNodes(); }, visible: function(key, opt){ var selected = project.mainTree.selected; if(selected.sourceType == ModuleNames.bills&&selected.data.type == billType.DXFY){ return false }else { return true } } }, "spr1": '--------', "delete": { name: '删除', icon: 'fa-remove', disabled: function () { var selected = project.mainTree.selected; return !selected; }, callback: function () { var selected = controller.tree.selected, parent = selected.parent; if (selected) { if (selected.sourceType === project.Bills.getSourceType()) { if (cbTools.isUsedByFormula(selected)){ alert('该清单行被其它公式结点引用，不允许删除！'); return; }; project.Bills.deleteBills(selected.source); controller.delete(); } else if (selected.sourceType === project.Ration.getSourceType()) { project.Ration.delete(selected.source); controller.delete(); }; projectObj.converseCalculateBills(parent); cbTools.refreshFormulaNodes(); } } }, "spr2":'--------', "calculateAll_RationContent": { name: '造价计算', callback: function () { $.bootstrapLoading.start(); let changedNodes = project.calcProgram.calcAllNodes(); project.calcProgram.saveNodes(changedNodes); $.bootstrapLoading.end(); } } } }); }, // 计算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.css({ position: "absolute", border: "1px #C0C0C0 solid", background: "#fff", boxShadow: "1px 2px 5px rgba(0,0,0,0.4)", }); div.children("p").css({ textAlign: "center", padding: 8, marginBottom: 2, }); div.children("p").first().css({ borderBottom: "1px #C0C0C0 solid" }); const totalString = total.toFixed(max); // input长度 const inputWidth = totalString.length * 8; // 计算是否会超出显示范围 const baseWidth = 48; const baseHeight = 81; const canvasWidth = $("#billsSpreadvp_vp").width(); const canvasHeight = $("#billsSpreadvp_vp").height(); x = x + baseWidth + inputWidth > canvasWidth ? x - baseWidth - inputWidth : x; y = y + baseHeight > canvasHeight ? y - baseHeight : y; div.css({ left: x, top: y, }); div.children().children("#total").width(inputWidth).val(totalString); $("body").append(div); // 用于判断是否要关闭窗体 setTimeout(function() { isTotalShowing = true; }, 200); }; } }; // 点击合计框中的复制 $("body").on("click", "#total-tips a", function() { const totalElement = $(this).parent().siblings("p").find("#total"); totalElement.select(); document.execCommand("Copy"); $(this).text("已复制"); }); // 合计框点击其他位置关闭 let isTotalShowing = false; $("body").on("click", function(e) { if (isTotalShowing && !$(e.target).is("#total-tips") && !$(e.target).is("#total-tips p") && !$(e.target).is("#total-tips p a")) { $("#total-tips").remove(); isTotalShowing = false; } }); $('#insert').click(function () { var controller = projectObj.mainController, project = projectObj.project; var selected = controller.tree.selected; if (!selected || selected.sourceType === project.Bills.getSourceType()) { ProjectController.addBills(project, controller); } else if (selected.sourceType === project.Ration.getSourceType()) { ProjectController.addRation(project, controller, selected.data.type); }; cbTools.refreshFormulaNodes(); }); $('#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(); projectObj.converseCalculateBills(orgParent); } }); $('#downLevel').click(function () { var controller = projectObj.mainController, project = projectObj.project; var selected = controller.tree.selected; if (selected && selected.sourceType === project.Bills.getSourceType()) { project.Bills.downLevelBills(selected.source); controller.downLevel(); projectObj.converseCalculateBills(selected.parent); } }); $('#upMove').click(function () { var controller = projectObj.mainController, project = projectObj.project; var selected = controller.tree.selected, pre = selected.preSibling, preSerialNo; if (selected.sourceType === project.Bills.getSourceType()) { project.Bills.upMoveBills(selected.source); controller.upMove(); } else if (selected.sourceType === project.Ration.getSourceType()) { project.Ration.changePos(selected.source, selected.preSibling.source); controller.upMove(); }; }); $('#downMove').click(function () { var controller = projectObj.mainController, project = projectObj.project; var selected = controller.tree.selected, next, nextSerialNo; if (selected) { if (selected.sourceType === project.Bills.getSourceType()) { project.Bills.downMoveBills(selected.source); controller.downMove(); } else if (selected.sourceType === project.Ration.getSourceType()) { project.Ration.changePos(selected.source, selected.nextSibling.source); controller.downMove(); }; } }); $('#poj-set').on('show.bs.modal', function () { let setCalcFlag = function (obj, val, curFlag) { obj.val(val); if (val === curFlag) { obj.attr('checked', true); } else { obj.removeAttr('checked'); } } if (projectObj.project) { // let mode = projectObj.project.projSetting.billsCalcMode; // let settingConst = projectObj.project.projSetting.settingConst; let ft = projectObj.project.property.billsCalcMode ? projectObj.project.property.billsCalcMode : leafBillGetFeeType.rationContent; setCalcFlag($('#rationContent'), leafBillGetFeeType.rationContent, ft); setCalcFlag($('#rationPriceConverse'), leafBillGetFeeType.rationPriceConverse, ft); setCalcFlag($('#rationPrice'), leafBillGetFeeType.rationPrice, ft); setCalcFlag($('#billsPrice'), leafBillGetFeeType.billsPrice, ft); // mode = projectObj.project.projSetting.zanguCalcType; let zg = projectObj.project.property.zanguCalcMode ? projectObj.project.property.zanguCalcMode : zanguCalcType.common; setCalcFlag($('#zangu_common'), zanguCalcType.common, zg); setCalcFlag($('#zangu_gatherMaterial'), zanguCalcType.gatherMaterial, zg); } }); $('#property_ok').click(function () { let project = projectObj.project, projectID = project.ID(), properties = {}, labourCoes = {}, rations = [], bills = [], mixDatas = { projectID: projectID, updateType: 'update', properties: properties, labourCoes: labourCoes, rations: rations, bills: bills }, reCalcBills= false, reCalcRations= false; let b = parseInt($("input[name='calcFlag']:checked").val()); if (b !== project.property.billsCalcMode) { properties['property.billsCalcMode'] = b; project.property.billsCalcMode = b; reCalcBills = true; }; let zg = parseInt($("input[name='zangu']:checked").val()); if (zg !== project.property.zanguCalcMode) { properties['property.zanguCalcMode'] = zg; project.property.zanguCalcMode = zg; reCalcBills = true; }; //基本信息 if(basicInfoView.toUpdate(basicInfoView.orgDatas, basicInfoView.datas)){ properties['property.basicInformation'] = basicInfoView.toSaveDatas(basicInfoView.datas); } //工程特征 if(projFeatureView.toUpdate(projFeatureView.orgDatas, projFeatureView.datas)){ properties['property.projectFeature'] = projFeatureView.toSaveDatas(projFeatureView.datas); } //清单工程量精度 let newBillsDecimalDatas = billsDecimalView.toBillsDecimalDatas(billsDecimalView.cache); if(billsDecimalView.toUpdate(billsQuanDecimal.datas, newBillsDecimalDatas)){ billsQuanDecimal.datas = newBillsDecimalDatas; reCalcBills = true; properties['property.billsQuantityDecimal'] = newBillsDecimalDatas; } //小数位数 let updateDecimal = m_getDecimalData($('input', '#poj-settings-decimal')); if(toUpdateDecimal(decimalObj, updateDecimal)) { let frChanged = decimalObj.feeRate != updateDecimal.feeRate; setDecimal(decimalObj, updateDecimal); if (frChanged) { project.calcProgram.compileAllTemps() } reCalcRations = true; reCalcBills = true; properties['property.decimal'] = updateDecimal; } // 呈现选项 projDisplayView.updateChecking(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){ showinfo = "是否删除其下的子项？"; showN = true; cancelText = "取消"; } $('#delete_showinfo').text(showinfo); showN==true? $('#deleteN').show():$('#deleteN').hide(); $('#deleteCancel').text(cancelText); }); $('#deleteY').click(function () { //正常删除，级联删除子项 let controller = projectObj.mainController, project = projectObj.project; let selected = controller.tree.selected, parent = selected.parent; if (selected) { if (selected.sourceType === project.Bills.getSourceType()) { if (cbTools.isUsedByFormula(selected)){ alert('该清单行被其它公式结点引用，不允许删除！'); return; } project.Bills.deleteBills(selected.source); controller.delete(); } else if (selected.sourceType === project.Ration.getSourceType()) { project.Ration.delete(selected.source); controller.delete(); }else if(selected.sourceType==ModuleNames.ration_glj){ project.ration_glj.updataOrdelete(selected.source); } if(parent){ projectObj.converseCalculateBills(parent); }else { //删除的是大项费用要重新计算工程造价节点 let roots = controller.tree.roots; for(let root of roots){ if(project.Bills.isEngineeringCost(root)==true){ project.calcProgram.calcAndSave(root); break; } } } } cbTools.refreshFormulaNodes(); }); $('#deleteN').click(function () {//不删除子项 let controller = projectObj.mainController, project = projectObj.project; let selected = controller.tree.selected, parent = selected.parent; let updateData = {}; 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); } });