/** * Created by Mai on 2017/6/21. */ var projectObj = { project: null, mainSpread: null, mainController: null, gljSpreed:null, beforeMainTreeSelectedChange: function (pre) { /*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); if($('#linkComments').hasClass('active')){ subViewObj.loadComments(node); } gljOprObj.mainTreeSelectedChange = gljOprObj.selectedNodeId != node.getID(); gljOprObj.showDataIfRationSelect(node); if (activeSubSheetIsCalcProgram()) calcProgramObj.refreshCalcProgram(node, 3); //zhong 2017-9-1 特征及内容 if(pageCCOprObj.active){ pageCCOprObj.mainActiveCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];//mainSpread焦点单元格 pageCCOprObj.setCacheAndShow(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 && projectObj.project.withinBillsLocked(node)){ return false; } if(node.depth()<=1){//焦点行是树结构的第一/二层节点，灰显。 return false; } if(node.sourceType !== that.project.Bills.getSourceType()){//焦点行是定额/量价/工料机，灰显。 return false; }else { if(node.data.type == billType.FX || node.data.type == billType.BX){//是分项，或者补项灰显。 return false; } if(node.data.type == billType.FB&&node.nextSibling&&node.children.length>0){//焦点行是分部有后兄弟，有子项. if(node.children[0].data.type==billType.FX || node.children[0].data.type==billType.BX){ //焦点行子项是分项 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 && projectObj.project.withinBillsLocked(node)){ return false; } if(node.depth()==0){//焦点行是树结构的第一层节点，灰显。 return false; } if(node.sourceType !== that.project.Bills.getSourceType()) {//焦点行是定额/量价/工料机，灰显。 return false; }else { if(node.data.type == billType.FX || node.data.type == billType.BX){//是分项，灰显。 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||node.preSibling.children[0].data.type==billType.BX)){//焦点行是分部前兄弟有子项，子项是分项，灰显。 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 && projectObj.project.withinBillsLocked(node)){ 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 && projectObj.project.withinBillsLocked(node)){ return false; } if(node.data.type == billType.DXFY&&node.data.isAdd!==1){ return false; } } return true; } return false }; setButtonValid(projectObj.project.Ration.canAdd(selected), $('#insertRation')); 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 === 'contain') {//colSetting.data.field === 'quantity' 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; }, //根据列标段设置焦点单元格 setActiveCell(field, moveScroll){ projectObj.mainSpread.focus(true); let mainSheet = projectObj.mainSpread.getActiveSheet(); let fieldCol = colSettingObj.getColByField(field); if(fieldCol){ if(moveScroll){ mainSheet.showColumn(fieldCol, GC.Spread.Sheets.HorizontalPosition.left); } mainSheet.setActiveCell(projectObj.project.mainTree.selected.serialNo(), fieldCol); } }, //获取粘贴更改的单元格（粘贴时，跳过隐藏行） 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 (projectInfoObj.projectInfo.engineeringInfo.bill_lib.length === 0) { normalUpdate(node,value,stdCode === orgCode); } 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) { function sortItems(serialItems, items){ for(let item of items){ for(let serialItem of serialItems){ if(item.id === serialItem.id){ item.serialNo = serialItem.serialNo; } } } items.sort(function (a, b) { let rst = 0; if(a.serialNo > b.serialNo){ rst = 1; } else if(a.serialNo < b.serialNo){ rst = -1; } return rst; }); } function updateBeforeInsert(node, data) { node.data.name = data.name; if(node.data.type == billType.BX){//从清单库中找到标准清单的话，要把补项改成分项 node.data.type = billType.FX; } sortItems(data.items, data.itemCharacter); sortItems(data.jobs, data.jobContent); pageCCOprObj.setItemContentNode(node, data.jobContent, data.itemCharacter, node.data.name); pageCCOprObj.setCacheAndShow(node); } if (/\//.test(data.unit)) { let existB = projectObj.project.Bills.sameStdCodeBillsData(data.code); if (existB) { updateBeforeInsert(node, data); data.unit = existB.unit; project.Bills.replaceBills(node.source, data, formatCode); projectObj.mainController.refreshTreeNode([node], false); } else { ConfirmModal.stdBillsUnit.check(data, function (std) { updateBeforeInsert(node, data); project.Bills.replaceBills(node.source, std, formatCode); projectObj.mainController.refreshTreeNode([node], false); }, function () { projectObj.mainController.refreshTreeNode([node], false); }); } } else { updateBeforeInsert(node, data); project.Bills.replaceBills(node.source, data, formatCode); projectObj.mainController.refreshTreeNode([node], false); } } else { normalUpdate(node,value); } }); } } //分部分项、措施项目才匹配 let withinValidFixed = false; let matchFixedFlags = [fixedFlag.SUB_ENGINERRING, fixedFlag.MEASURE]; let rootNode = getRootFixedNode(node); if(rootNode && rootNode.data.flagsIndex && rootNode.data.flagsIndex.fixed && matchFixedFlags.includes(rootNode.data.flagsIndex.fixed.flag)){ withinValidFixed = true; } if(withinValidFixed && (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) 去掉全数字判断 07-31 zhang stdMatchCode = value; formatCode = project.Bills.newFormatCode(stdMatchCode); searchStdBillsAndUpdate(stdMatchCode, formatCode); return; } else if (value&&value.length === 12 ) {//&& /^[\d]+$/.test(value) 去掉全数字判断 07-31 zhang stdMatchCode = value.substr(0, 9); matchs = project.Bills.sameStdCode(stdMatchCode, node.data.code); if (matchs.indexOf(value) === -1) { searchStdBillsAndUpdate(stdMatchCode, value); return; } else { hintBox.infoBox("系统提示","已存在该编码的清单，是否继续？",2,function () { searchStdBillsAndUpdate(stdMatchCode, value); },function () { me.mainController.refreshTreeNode([node], false); },['确定','取消']); return; } } } normalUpdate(node,value); function normalUpdate(billnode,codeValue,onNeedCheck) {//在标准库中没有找到清单时改分项为补项再更新 let toBX = false; if(onNeedCheck!==true && 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方法中。 } }, 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' && value != '' && !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') { quantityEditObj.checkingAndUpdate(editingText,node); // 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 = ''; } if(value === node.data.calcBase){ return; } 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 value = info.sheet.getValue(info.row, info.col); if(fieldName === 'code' && node && calcTools.isRationItem(node) && isDef(node.data.code)&&isDef(value)){ if (isDef(node.data.prefix) && node.data.prefix !== rationPrefix.none){ value = value.replace(new RegExp(node.data.prefix), ''); }; info.sheet.setValue(info.row, info.col, value); } if(node&&fieldName =='quantity'&&(node.data.quantityEXP !==null||node.data.quantityEXP !==undefined)){ info.sheet.setValue(info.row, info.col, node.data.quantityEXP); } }, onCellDoubleClick: function (sender, info){ let project = projectObj.project; if(info.row && info.col){ 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; } } if(fieldName == 'code' && node){ projectObj.showBillOrRationLib(node) } } }, showBillOrRationLib(node){ let BILLS = projectObj.project.Bills; let code = node.data.code ? node.data.code : ''; if(node.sourceType == ModuleNames.bills){//当清单是“分部分项工程”、“措施项目工程”时，要展开清单规则节点 if(BILLS.isFXorBX(node)||(node.data.type == billType.BILL && BILLS.isMeasure(node))){//是分项或补项，是清单并且属于措施项目节点 if(billsLibObj.stdBillsTree === null){ billsLibObj.doAfterLoadBills = function () { this.locateAtBills(code); this.doAfterLoadBills = null; }; } else { billsLibObj.locateAtBills(code); } if(!$("#qd").is(":visible")) $('#stdBillsTab').click(); } } if(node.sourceType == ModuleNames.ration){ //在定额编码中双击，如果右侧定额库没有展开，则自动展开。 if(!rationLibObj.tree){ rationLibObj.doAfterGetRationTree = function () { this.locateAtRation(code); this.doAfterGetRationTree = null; }; } else { rationLibObj.locateAtRation(code); } if(!$("#de").is(":visible")) $('#stdRationTab').click(); } }, onColumnWidthChanged: function (sender, info) { // CSL,2018.07.25 if (info.colList.includes(4) || info.colList.includes(5)){ let items = projectObj.project.mainTree.items; let sheet = projectObj.mainSpread.getActiveSheet(); for (let i = 0; i < items.length; i++) { let need = false; if (items[i].data.itemCharacterText){ sheet.getCell(i, 4).wordWrap(true); need = true; } if (items[i].data.jobContentText){ sheet.getCell(i, 5).wordWrap(true); need = true; } if (need) sheet.autoFitRow(i); } } }, onClipboardPasting: function (sender, info){ let rIdx = info.sheet.getActiveRowIndex(); let node = projectObj.project.mainTree.items[rIdx]; if (!node.parent){ info.cancel = true; hintBox.infoBox('系统提示','大项费用不允许粘贴！', 1); return false; }; let colName = projectObj.project.projSetting.main_tree_col.cols[info.cellRange.col].data.field; if (colName == 'code'){ info.cancel = true; function getNodeType(node) { let t = null; if (calcTools.isRationItem(node)) t = 1 else if (calcTools.isBill(node)){ if (calcTools.isBill_FB(node)) t = 2 else if (calcTools.isBill_FX(node) || calcTools.isBill_BX(node)) t = 3 else if (calcTools.isBill_BILL(node)) t = 4; }; return t; }; function getPasteTextArr(info) { let copyText = info.pasteData.text.trim(); if (!copyText) return null; let rows = copyText.split('\r\n'); let rstArr = []; for (let row of rows) { row = row.trim(); row = row.split('\t'); rstArr.push(row); } return rstArr; }; function getPasteNodes(node, nodeType, count) { let nodesArr = []; let curNode = null; for (let i = rIdx; i < rIdx + count; i++) { curNode = projectObj.project.mainTree.items[i]; if (curNode && calcTools.isSameTypeNode(curNode, node)){ nodesArr.push(curNode); } else{ curNode = projectObj.project.mainTree.items[i - 1]; break; } }; if (nodesArr.length < count){ if (projectObj.project.mainTree.selected != curNode) projectObj.project.mainTree.selected = curNode; let add = count - nodesArr.length; for (let i = 0; i < add; i++) { switch (nodeType) { case 1: curNode = projectObj.project.Ration.addNewRationFast(rationType.ration); break; case 2: curNode = ProjectController.addFB(projectObj.project, projectObj.mainController); break; case 3: curNode = ProjectController.addFX(projectObj.project, projectObj.mainController); break; case 4: curNode = ProjectController.addBills(projectObj.project, projectObj.mainController); break; } if (!curNode){ hintBox.infoBox('系统提示','插入新结点出错，粘贴失败！', 1); return nodesArr; } else{ nodesArr.push(curNode); if (projectObj.project.mainTree.selected != curNode) projectObj.project.mainTree.selected = curNode; } } }; return nodesArr; }; function doPaste(nodes, nodeType, datas) { if (nodeType == 1){ // 批量粘贴定额有严重的异步问题，这里要和清单分开处理 let updateRationCodes = []; for (let i = 0; i < datas.length; i++) { let ptNode = nodes[i]; let code = datas[i][0]; // 编号去掉“换、借、补”等多余的字 code = code.replace(new RegExp(rationPrefix.complementary), ''); code = code.replace(new RegExp(rationPrefix.borrow), ''); // code = code.replace(new RegExp(rationPrefix.replace), ''); updateRationCodes.push({'node':ptNode, value:code}); } projectObj.project.Ration.updateRationCodes(updateRationCodes); } else { for (let i = 0; i < datas.length; i++) { let ptNode = nodes[i]; let code = datas[i][0]; if (!(ptNode.data && ptNode.data.code && ptNode.data.code.sameText(code))){ projectObj.updateCode(ptNode, code); }; } } projectObj.mainController.refreshTreeNode(nodes); }; let tagType = getNodeType(node); if (!tagType){ hintBox.infoBox('系统提示', '该树结点类型不支持从项目编码列粘贴！', 1); return false; }; let datas = getPasteTextArr(info); if (!datas) return; let pasteNodes = getPasteNodes(node, tagType, datas.length); doPaste(pasteNodes, tagType, datas); }; }, mainSpreadEditEnded: function (sender, info) { console.log('enterEDEnd'); let project = projectObj.project; let node = project.mainTree.items[info.row]; project.withinBillsLocked(node); 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]); sheetCommonObj.spreadDefaultStyle(this.mainSpread); this.mainSpread.getActiveSheet().selectionPolicy(GC.Spread.Sheets.SelectionPolicy.muliRange); this.mainSpread.getActiveSheet().name('mainSheet'); this.mainSpread.getActiveSheet().options.isProtected = true; } }, 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(!colSettingObj.getVisible('itemCharacterText')){ switchTznrHtml(true); } if(colSettingObj.getVisible('itemCharacterText')){ switchTznrHtml(false); } if (!err) { that.project.projectGLJ.calcQuantity(true);//计算分部分项和技术措施项目消耗量; gljCol.initGljCol(that.project.projSetting.glj_col?that.project.projSetting.glj_col.showAdjustPrice:false); subObj.initSubSpread();//初始化主界面下方的表格 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.data.field ==='remark'){ col.showHint = true; } // 综合单价、综合合价，小数部分应补0对齐。 CSL // 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); if(!projectReadOnly){ that.mainSpreadEscKey(that.mainSpread, that.mainSpreadEditStarting, that.mainSpreadEditEnded); sheetCommonObj.bindEnterKey(that.mainSpread, that.mainSpreadEnterKey); } setTimeout(function () { that.mainSpread.getActiveSheet().startEdit();//这两句需要挺多时间,而又需要在editend 事件前触发，而这些又不影响计算，所以这里用异步的方法 that.mainSpread.getActiveSheet().endEdit(); that.mainSpread.bind(GC.Spread.Sheets.Events.EditEnded, that.mainSpreadEditEnded); that.mainSpread.bind(GC.Spread.Sheets.Events.EditStarting, that.mainSpreadEditStarting); },100); that.mainSpread.bind(GC.Spread.Sheets.Events.SelectionChanged, that.amountAreaNumber);//选中统计专用，节点相关操作在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.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); that.mainSpread.bind(GC.Spread.Sheets.Events.ColumnWidthChanged, that.onColumnWidthChanged); that.mainSpread.bind(GC.Spread.Sheets.Events.ClipboardPasting, that.onClipboardPasting); //let loadOtherStartTime = +new Date(); if(!projectReadOnly){ 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(); if(projectReadOnly){ disableSpread(that.mainSpread); } $.bootstrapLoading.end(); } else { } }); }, //mainSpread有一些单元格进入编辑状态后，会动态改变值，公用的bindEscKey方法不适用 mainSpreadEscKey: function (workBook, editStarting = null, editEnded = null) { workBook.commandManager().register('myEsc', function () { let sheet = workBook.getActiveSheet(); if(editStarting){ sheet.unbind(GC.Spread.Sheets.Events.EditStarting); } if(editEnded){ sheet.unbind(GC.Spread.Sheets.Events.EditEnded); } let row = sheet.getActiveRowIndex(); let col = sheet.getActiveColumnIndex(); let orgV = sheet.getValue(row, col); let node = projectObj.project.mainTree.items[row]; let field = colSettingObj.getFieldByCol(col); //进入编辑状态后改变了单元格值的时候特殊处理 if(isDef(field) && field === 'code'){ 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){ orgV = node.data.prefix + orgV; } } else if(isDef(field) && field === 'quantity'){ orgV = isDef(node) && isDef(node.data.quantity) ? node.data.quantity : ''; } if(!isDef(orgV)){ orgV = ''; } if(sheet.isEditing()){ sheet.endEdit(); sheet.setValue(row, col, orgV); } if(editStarting){ sheet.bind(GC.Spread.Sheets.Events.EditStarting, editStarting); } if(editEnded){ sheet.bind(GC.Spread.Sheets.Events.EditEnded, editEnded); } }); workBook.commandManager().setShortcutKey(null, GC.Spread.Commands.Key.esc, false, false, false, false); workBook.commandManager().setShortcutKey('myEsc', GC.Spread.Commands.Key.esc, false, false, false, false); }, mainSpreadEnterKey: function () { let me = projectObj; let sheet = me.mainSpread.getActiveSheet(); let orgRow = sheet.getActiveRowIndex(); let orgCol = sheet.getActiveColumnIndex(); let orgField = colSettingObj.getFieldByCol(orgCol); let selected = me.project.mainTree.items[orgRow]; if(sheet.isEditing()){ sheet.endEdit(); } //正常情况，焦点应该是在下一行的同一列 let newRow = orgRow + 1, newCol = orgCol; //getColByField getVisible都不提出来，减少调用次数 if(selected){ //在分项/补项的编码单元格回车，焦点应跳动至本行的工程量单元格 if(orgField && orgField === 'code' && selected.sourceType === me.project.Bills.getSourceType() && [billType.FX, billType.BX].includes(selected.data.type)){ let quantityCol = colSettingObj.getColByField('quantity'); let quantityVisible = colSettingObj.getVisible('quantity'); if(quantityCol !== null && quantityVisible !== false){ newRow = orgRow; newCol = quantityCol; } } else if(orgField && orgField === 'quantity' && selected.sourceType === me.project.Bills.getSourceType() && [billType.FX, billType.BX].includes(selected.data.type)){ //在分项/补项的工程量单元格回车，如果其下有定额/量价/人材机，焦点应跳动至其下第一条定额/量价/人材机的工程量，如果是空行，则跳到至第一条定额xx的编码； if(selected.children.length !== 0 && !(isDef(selected.children[0].data.code) && selected.children[0].data.code.toString().trim() !== '')){ let codeCol = colSettingObj.getColByField('code'); let codeVisible = colSettingObj.getVisible('code'); newRow = orgRow + 1; if(codeCol !== null && codeVisible !== false){ newCol = codeCol; } } //如果其下没有定额/量价/人材机，则自动在其下插入一条定额空行，在其后自动插入一条分项空行，焦点跳动至定额空行的编码单元格。 else if(selected.children.length === 0){ //分项没有后兄弟，且没有锁定清单时在其后插入分项 if(!selected.nextSibling && !(projectInfoObj.projectInfo.property.lockBills && projectObj.project.withinBillsLocked(projectObj.project.mainTree.selected))){ ProjectController.addFX(me.project, me.mainController); //将焦点行设置成原本的行，以插入定额 me.mainController.setTreeSelected(me.project.mainTree.items[orgRow]); } //插入定额 me.project.Ration.addNewRation(null, rationType.ration, function () { newRow = sheet.getActiveRowIndex(); let codeCol = colSettingObj.getColByField('code'); let codeVisible = colSettingObj.getVisible('code'); if(codeCol !== null && codeVisible !== false){ newCol = codeCol; } sheet.setActiveCell(newRow, newCol); },true); } } //在定额/量价/人材机的编码单元格回车，焦点应跳动至本行的工程量单元格 else if(orgField && orgField === 'code' && selected.sourceType === me.project.Ration.getSourceType()){ let quantityCol = colSettingObj.getColByField('quantity'); let quantityVisible = colSettingObj.getVisible('quantity'); if(quantityCol !== null && quantityVisible !== false){ newRow = orgRow; newCol = quantityCol; } } //在定额/量价/人材机的工程量单元格回车 else if(orgField && orgField === 'quantity' && selected.sourceType === me.project.Ration.getSourceType()){ let nextSibling = selected.nextSibling; //如果其后有定额/量价/人材机(空行:编码为空不算)，焦点应跳动至下一行定额/量价/人材机的工程量，不需处理 //如果其后没有定额/量价/人材机(空行也没有)，则自动在其后插入一行定额空行，焦点跳动至定额空行的编码单元格 if(!nextSibling){ let codeCol = colSettingObj.getColByField('code'); let codeVisible = colSettingObj.getVisible('code'); me.project.Ration.addNewRation(null, rationType.ration, function () { newRow = sheet.getActiveRowIndex(); if(codeCol !== null && codeVisible !== false){ newCol = codeCol; } sheet.setActiveCell(newRow, newCol); }, true); } //如果其后有定额空行，焦点跳动至定额空行的编码单元格 else if(nextSibling && !(isDef(nextSibling.data.code) && nextSibling.data.code.toString().trim() !== '')) { let codeCol = colSettingObj.getColByField('code'); let codeVisible = colSettingObj.getVisible('code'); if(codeCol !== null && codeVisible !== false){ newRow = orgRow + 1; newCol = codeCol; } } } //在清单的编码单元格回车，如果清单是叶子节点，焦点跳动至本行的工程量单元格 else if(orgField && orgField === 'code' && selected.sourceType === me.project.Bills.getSourceType() && selected.data.type === billType.BILL && selected.source.children.length === 0){ let quantityCol = colSettingObj.getColByField('quantity'); let quantityVisible = colSettingObj.getVisible('quantity'); if(quantityCol && quantityVisible){ newRow = orgRow; newCol = quantityCol; } } } //设置焦点 sheet.setActiveCell(newRow, newCol); //触发表格事件 me.mainController.setTreeSelected(me.project.mainTree.items[newRow]);//SelectionChanged me.mainSpreadLeaveCell({type: 'LeaveCell'}, {sheet: sheet, sheetName: sheet.name(), cancel: false, row: orgRow, col: orgCol}); me.mainSpreadEnterCell({type: 'EnterCell'}, {sheet: sheet, sheetName: sheet.name(), cancel: false, row: newRow, col: newCol}); }, 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() && project.withinBillsLocked(project.mainTree.selected); //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()== true && project.withinBillsLocked(selected)) && 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; } } }, "spr1": '--------', "insertRation": { name: "插入定额", icon: 'fa-sign-in', disabled: function () { // var selected = project.mainTree.selected; // return project.Ration.addRationChecking(selected); // Vincent, 2018-01-02 // 工具栏要加按钮，且不能隐藏。菜单可以隐藏，两者又必须统一，所以启用新规则。怕以后又要改回来，所以保留。 CSL, 2018-01-02 return !project.Ration.canAdd(project.mainTree.selected); }, callback: function (key, opt) { project.Ration.addNewRation(null,rationType.ration,projectObj.selectColAndFocus,true); // ProjectController.addRation(project, controller, rationType.ration); }/*, visible: function(key, opt){ var selected = project.mainTree.selected; return canInsertRationNode(selected); }*/ }, "insertLJ": { name: "插入量价", icon: 'fa-sign-in', disabled: function () { // var selected = project.mainTree.selected; // return project.Ration.addRationChecking(selected); // Vincent, 2018-01-02 return !project.Ration.canAdd(project.mainTree.selected); }, callback: function (key, opt) { project.Ration.addNewRation(null,rationType.volumePrice,null,true); // 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 return !project.Ration.canAdd(project.mainTree.selected); }, 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; }*/ }, "spr2": '--------', "calc_installation_fee": { name: "计取安装费用", icon: 'fa-sign-in', disabled: function () { return false; }, callback: function (key, opt) { installationFeeObj.showCalcInstallSettingDiv(); }, visible: function(key, opt){ return projectObj.project.isInstall(); } }, "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});//弹出删除提示框; } } }, "calculateAll_RationContent": { name: '造价计算', icon: 'fa-calculator', callback: function () { project.calcProgram.calcAllNodesAndSave(); } }, "spr4":'--------', "copyBlock": { name: '复制整块', icon: 'fa-copy', disabled: function () { let selection = projectObj.mainSpread.getActiveSheet().getSelections()[0]; let firstNode = projectObj.project.mainTree.items[selection.row];//当多选的情况，用mainTree.selected判断不正确,要用第一个选中的节点 for(let i = 0;i< selection.rowCount;i++){ //多选的时候判断所有与第一个节点同级的节点 let temNode = projectObj.project.mainTree.items[selection.row + i]; if(firstNode.getParentID() == temNode.getParentID()){ if(BlockController.copyBtnDisable(temNode) == true){ return true; } } } return false; }, callback: function () { $.bootstrapLoading.start(); //let selected = project.mainTree.selected; let selections = projectObj.mainSpread.getActiveSheet().getSelections(); setTimeout(function () { BlockController.copyBlock(selections[0]); $.bootstrapLoading.end(); },100) } }, "pasteBlock": { name: '粘贴整块', icon: 'fa-paste', disabled: function (){ return BlockController.pasteBtnDisable(project.mainTree.selected); }, callback: function () { BlockController.pasteBlock(project.mainTree.selected); } }, "editEngineer": { name: '编辑工程内容', icon: 'fa-edit', visible: function(key, opt){ let selected = project.mainTree.selected; return selected.sourceType==ModuleNames.bills&&project.Bills.isEngineerEst(selected);//当焦点行是“专业工程暂估价”时，右键可见并有效。 }, callback: function () { let node = project.mainTree.selected;//project.Bills.getNodeByFlag(project.mainTree.selected,fixedFlag.ENGINEERING_ESITIMATE); if(node){ projectObj.editContent(node,'engineeringContent'); } } }, "editService": { name: '编辑服务内容', icon: 'fa-edit', visible: function(key, opt){ let selected = project.mainTree.selected; return selected.sourceType==ModuleNames.bills&&project.Bills.isTotalService(selected);//当焦点行是“总承包服务费”时，右键可见并有效。 }, callback: function () { let node = project.mainTree.selected;//project.Bills.getNodeByFlag(project.mainTree.selected,fixedFlag.TURN_KEY_CONTRACT); if(node){ projectObj.editContent(node,'serviceContent'); } } }, "editAccording": { name: '编辑签证及索赔依据', icon: 'fa-edit', visible: function(key, opt){ let selected = project.mainTree.selected; return selected.sourceType==ModuleNames.bills&&project.Bills.isClaimVisa(selected);//当焦点行是“签证及索赔计价”时，右键可见并有效。 }, callback: function () { let node = project.mainTree.selected;//project.Bills.getNodeByFlag(project.mainTree.selected,fixedFlag.CLAIM_VISA); if(node){ projectObj.editContent(node,'claimVisa'); } } } } }); }, // 计算node及node的所有父项 converseCalculateBills: function (node) { projectObj.project.calcProgram.calcAndSave(node); }, // 获取上次退出时的焦点位置 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]);//触发树节点选中事件 sheet.showRow(row, GC.Spread.Sheets.VerticalPosition.center); }, // 选中区域合计数字 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 maxCell = {row: selectedArea.row, col: selectedArea.col + selectedArea.colCount}; let maxCellX = sheet.getCellRect(maxCell.row, maxCell.col).x ? sheet.getCellRect(maxCell.row, maxCell.col).x : sheet.getCellRect(maxCell.row, maxCell.col - 1).x; let minCell = {row: selectedArea.row, col: selectedArea.col}; let minCellX = sheet.getCellRect(minCell.row, minCell.col).x ? sheet.getCellRect(minCell.row, minCell.col).x : sheet.getCellRect(minCell.row, minCell.col + 1).x; // 获取鼠标位置 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; x = maxCellX + baseWidth + inputWidth > canvasWidth ? minCellX - baseWidth - inputWidth : maxCellX + baseWidth; y = y + baseHeight > canvasHeight ? y - baseHeight : y; //test let testT = sheet.getParent().hitTest(x, y); //test 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, tree) { 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; tree?'':tree = this.project.mainTree; //中文字段名，由于同一节点中，中文字体大小和数字字体大小不同 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 === tree.selected){ style.backColor = colorSetting[mapping.SELECTED]['backColor']; } //大项费用加粗（数字与中文字符大小不一问题由字体造成，暂时不考虑分别设置大小） /* if(node.sourceType === this.project.Bills.getSourceType() && node.data.type === billType.DXFY){ style.font = 'bold 0.9rem Arial'; }*/ 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' ]; style.font = 'bold 0.9rem Arial'; return style; }, //设置节点style setNodesStyle: function (sheet, nodes,tree) { 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,tree).backColor); } } }); }, loadLockBillsButton:function () { if(projectInfoObj.projectInfo.property.lockBills == true){ //$("a[name='lockBills']").attr("data-original-title","解锁清单"); $("a[name='lockBills']").html(' 解锁清单'); }else { //$("a[name='lockBills']").attr("data-original-title","锁定清单"); $("a[name='lockBills']").html(' 锁定清单'); } }, editContent:function (node,fieldID) {//右键编辑工程内容、服务内容、签证及索赔依据 let infoText = "请输入"; switch (fieldID){ case "engineeringContent": infoText +='工程内容:'; break; case "serviceContent": infoText +='服务内容:'; break; case "claimVisa": infoText +='签证及索赔依据:'; break; } hintBox.valueBox(infoText, node.data[fieldID], function () { let newValue = hintBox.value; projectObj.updateNodeField(node,newValue,fieldID); }); }, ifItemCharHiden:function (setting) {//项目特征及内容列是否隐藏 let col = _.find(setting.cols,function (item) { return item.data.field == "itemCharacterText"; }) return !col.visible; }, //综合合价cellType getCommonTotalFeeCellType:function () { let type = 'bills'; var ns = GC.Spread.Sheets; function CommonTotalFeeCellType() { var init=false; } CommonTotalFeeCellType.prototype = new ns.CellTypes.Text(); CommonTotalFeeCellType.prototype.paint = function (ctx, value, x, y, w, h, style, options) { // if(value!=null){ // ctx.fillText(value,x+3+ctx.measureText(value).width,y+h-3); // ctx.fillText(value,x+w-3,y+h-3); GC.Spread.Sheets.CellTypes.Text.prototype.paint.apply(this, arguments); // } if(calcBaseView.editingCell && !projectReadOnly && calcBaseView.ifEdit(type, options.row)){ if(calcBaseView.editingCell.row==options.row&&calcBaseView.editingCell.col==options.col){ var image = document.getElementById('f_btn'),imageMagin = 3; var imageHeight = h-2*imageMagin; var imageWidth = w*2/(type=='bills'?7:20); var imageX = x + w - imageWidth- imageMagin, imageY = y + h / 2 - imageHeight / 2; ctx.save(); ctx.drawImage(image, imageX, imageY,imageWidth,imageHeight); ctx.beginPath(); ctx.arc(imageX+imageWidth/2,imageY+imageHeight/2,1,0,360,false); ctx.arc(imageX+imageWidth/2-4,imageY+imageHeight/2,1,0,360,false); ctx.arc(imageX+imageWidth/2+4,imageY+imageHeight/2,1,0,360,false); ctx.fillStyle="black";//填充颜色,默认是黑色 ctx.fill();//画实心圆 ctx.closePath(); ctx.restore(); } } }; CommonTotalFeeCellType.prototype.getHitInfo = function (x, y, cellStyle, cellRect, context) { return { x: x, y: y, row: context.row, col: context.col, cellStyle: cellStyle, cellRect: cellRect, sheetArea: context.sheetArea }; }; CommonTotalFeeCellType.prototype.processMouseDown = function (hitinfo) { let me=calcBaseView; me.pmLeave = false; if(me.editingCell==null){ var showSelectBtn = true; if(hitinfo.sheet.name()!='calc_detail'){ showSelectBtn=me.ifEdit(type, hitinfo.row); } if(showSelectBtn){ me.editingCell={ row:hitinfo.row, col:hitinfo.col } hitinfo.sheet.invalidateLayout(); hitinfo.sheet.repaint(); } }else if(hitinfo.row==me.editingCell.row){ var offset=hitinfo.cellRect.x+hitinfo.cellRect.width-6; var imageMagin=3; var imageHeight = hitinfo.cellRect.height-2*imageMagin; var imageWidth = hitinfo.cellRect.width*2/7; if(hitinfo.xoffset-imageWidth){ if(!projectReadOnly && me.ifEdit(type, hitinfo.row)){ calcBaseView.confirmBtn.attr('toggle', 'commonTotalFee'); changeCalcBaseFeeRate('commonTotalFee'); $('#tabCalcBase').tab('show'); calcBaseView.initCalctor(type); feeRateObject.showSelectModal(hitinfo); } } } }; CommonTotalFeeCellType.prototype.processMouseLeave = function (hitinfo) { if(!calcBaseView.pmLeave){ calcBaseView.editingCell=null; hitinfo.sheet.invalidateLayout(); hitinfo.sheet.repaint(); calcBaseView.pmLeave = true; } } return new CommonTotalFeeCellType(); }, selectColAndFocus :function (newNode,field = 'code') {//选中单元格并设置焦点 if(newNode){ projectObj.mainController.sheet.setSelection(newNode.serialNo(), colSettingObj.getColByField(field), 1, 1); // projectObj.mainSpread.focus(); } } }; // 点击合计框中的复制 $("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.calcNodesAndSave([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); } }); $('#insertRation').click(function () { // projectObj.project.Ration.addNewRation(null,rationType.ration); // 连续点工具栏的插入定额按钮，显示树结构画线有问题。 projectObj.project.Ration.addNewRationFast(rationType.ration,projectObj.selectColAndFocus); }); $('#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(); if(!projectReadOnly){ pageCCOprObj.refreshRuleTools(lockBills); } //$("[data-toggle='tooltip']").tooltip('hide'); bs 与 jqueryUI冲突 }); }); $('#ZLFB_btn').click(function () { zlfb_object.getSectionInfo(); }); //显示至.. 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); let showAdjustPrice = projectObj.project.projSetting.glj_col?projectObj.project.projSetting.glj_col.showAdjustPrice:false; showAdjustPrice === true ? $("#tab_poj-settings-6").show():$("#tab_poj-settings-6").hide(); projDisplayView.init(); calcOptions.init(); } }); //恢复默认列设置 $('#recColSetting').click(function () { let libID = projectObj.project.property.colLibID ? projectObj.project.property.colLibID : null; if(!libID){ alert('项目没有绑定标准列设置'); return; } $(this).addClass('disabled'); CommonAjax.post('/project/getDefaultColSetting', {libID: libID}, function (rstData) { if(!rstData || rstData.length === 0){ alert('标准列设置没有数据'); $('#recColSetting').removeClass('disabled'); return; } let sheet = colSettingObj.settingSpread.getActiveSheet(); SheetDataHelper.massOperationSheet(sheet, function () { for(let row = 0; row < sheet.getRowCount(); row++){ sheet.setValue(row, 0, rstData.main_tree_col.cols[row].visible); } }); $('#recColSetting').removeClass('disabled'); }, function () { $('#recColSetting').removeClass('disabled'); }); }); $('#property_ok').click(function () { let project = projectObj.project, projectID = project.ID(), properties = {}, options = {}, labourCoes = {}, rations = [], bills = [], mixDatas = { projectID: projectID, updateType: 'update', properties: properties, options: options, 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)){ let saveData = basicInfoView.toSaveDatas(basicInfoView.datas); projectObj.project.property.basicInformation = saveData; properties['property.basicInformation'] = saveData; } //工程特征 if(projFeatureView.toUpdate(projFeatureView.orgDatas, projFeatureView.datas)){ let saveData = projFeatureView.toSaveDatas(projFeatureView.datas); projectObj.project.property.projectFeature = saveData; properties['property.projectFeature'] = saveData; } //清单工程量精度 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(colSettingObj.dataChanged()){ colSettingObj.updateColSetting(); } //系统选项 if(optionsOprObj.needToSaveGeneralOpts()){ let v1 = optionsOprObj.rationQuanACToBillsQuan.prop('checked'), v2 = optionsOprObj.rationQuanACToRationUnit.prop('checked'); options.updateData = { rationQuanACToBillsQuan: v1, rationQuanACToRationUnit: v2 }; } 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.options.updateData || 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']); } if(mixDatas.options && mixDatas.options.updateData){ let v1 = mixDatas.options.updateData['rationQuanACToBillsQuan'], v2 = mixDatas.options.updateData['rationQuanACToRationUnit']; optionsOprObj.updateOptions(optionsOprObj.options, {type: optionsOprObj.optionsTypes.GENERALOPTS, opt: 'rationQuanACToBillsQuan', value: v1}); optionsOprObj.updateOptions(optionsOprObj.options, {type: optionsOprObj.optionsTypes.GENERALOPTS, opt: 'rationQuanACToRationUnit', value: v2}); } } }); } }); 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 && projectObj.project.withinBillsLocked(node)){ 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){ return false } else { return true } } //导入类型（09表、广联达） const uploadType = {lj: 'lj', gld: 'gld'}; let fileType = uploadType.lj; $('#uploadLj').click(function () { fileType = uploadType.lj; }); $('#uploadGld').click(function () { fileType = uploadType.gld; }); let importJson = null; //选择导入的excel文件 $('#customFile').change(function () { let file = $(this)[0]; let excelFile = file.files[0]; $('#uploadAlert').hide(); if(excelFile) { let xlsReg = /xls$/g; if(excelFile.name && xlsReg.test(excelFile.name)){ showUploadAlert(false, '请选择xlsx文件'); $(this).val(''); return; } $('.custom-file-label').text(`${file.files[0].name}`); $('#uploadAlert').hide(); $.bootstrapLoading.start(); $('#loadingPage').css('z-index', '2000'); //前端解析excel数据 if(importJson){ importJson = null; } let excelIo = new GC.Spread.Excel.IO(); let sDate = +new Date(); excelIo.open(excelFile, function (json) { importJson = json; console.log(json); //读取各个表及表名 importBills.setImportSheetsInfo(importJson.sheets); console.log(`解析Excel文件时间：${+new Date() - sDate}`); $.bootstrapLoading.end(); }, function (e) { $.bootstrapLoading.end(); alert(e.errorMessage); }); } }); //线上nginx请求体最大设置为100m //从excel导入清单 $('#importConfirm').click(function () { let me = this; $(me).addClass('disabled'); try{ $.bootstrapLoading.start(); $('#loadingPage').css('z-index', '2000'); let formData = new FormData(); let file = $('#customFile')[0]; if(file.files.length <= 0){ throw '未选择文件'; } let projectID = scUrlUtil.GetQueryString('project'); if(!projectID || projectID <= 0){ throw '项目数据出错'; } let sDate = +new Date(); 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); //选择的表及导入位置 let importSheetsInfo = importBills.getImportSheetsInfo(); if(importSheetsInfo.length === 0){ throw '请选择要导入的表'; } let importSheets = importBills.getImportSheets(importJson.sheets, importSheetsInfo, fileType); console.log(`importSheets`); console.log(importSheets); let invalidSheetsInfo = importSheets.invalidSheets.join('、'); //获取同类表的有效数据 let importBillsData = importBills.getImportData(importSheets.validSheets, projectID); if(!importBills.excelHasValidBills(importBillsData)){ throw 'excel无有效数据' } let compressData = LZString.compressToUTF16(JSON.stringify(importBillsData)); formData.append('compressData', compressData); let eDate = +new Date(); console.log(`解析excel数据时间：${eDate - sDate}`); $.ajax({ url: '/bills/import', type: 'POST', data: formData, cache: false, contentType: false, processData: false, success: function(response){ if (response.err === 0) { if(invalidSheetsInfo !== ''){ alert(`${invalidSheetsInfo}，导入失败。`); } // 成功则关闭窗体 $('#import').modal("hide"); //更新前端 doAfterImport(response.data); if($.bootstrapLoading.isLoading()){ $.bootstrapLoading.end(); } } else { const message = response.msg !== undefined ? response.msg : '上传失败!'; $.bootstrapLoading.end(); alert(message); } $(me).removeClass('disabled'); }, error: function(jqXHR){ alert(`与服务器通信发生错误${jqXHR.status} ${jqXHR.statusText}`); $.bootstrapLoading.end(); $(me).removeClass('disabled'); } }); } catch (err){ showUploadAlert(false, err); $(me).removeClass('disabled'); if($.bootstrapLoading.isLoading()){ $.bootstrapLoading.end(); } } }); 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 doAfterImportPosition(positionData){ 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 positionData.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 positionData.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(positionData.fixedBill){ let fixedNode = nodes['id_' + positionData.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(positionData.insert.bill.length > 0){ //设置flagsIndex for(let insertBill of positionData.insert.bill){ insertBill.flagsIndex = {}; if (insertBill.flags) { insertBill.flags.forEach(function (flag) { insertBill.flagsIndex[flag.fieldName] = flag; }); } } //插入清单节点 projectObj.project.Bills.tree.insertByDatas(positionData.insert.bill); //插入主树节点 let newNodes = projectObj.project.mainTree.insertByDatas(positionData.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); } } //导入后更新操作 function doAfterImport(resData){ if(resData && resData.length > 0){ for(let positionData of resData){ doAfterImportPosition(positionData); } //如果清单未锁定，导入后锁定清单 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(`请选择上传文件`); }); $('#import').on('hidden.bs.modal', function () { //恢复选择表高度 $('#uploadSheets').height(''); $('#uploadSheets').hide(); $('#uploadSheetsHead').hide(); }); /* $("#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():''; } } //项目为只读 if(projectReadOnly){ disableTools(); } }); //项目只读，处理不可操作的工具栏 function disableTools(){ //造价书按钮 $('#insertRation').remove(); $('#delete').remove(); $('#upLevel').remove(); $('#downLevel').remove(); $('#upMove').remove(); $('#downMove').remove(); $('#ZLFB_btn').remove(); $('#switchTznr').remove(); $('#importSpan').remove(); $('a[name="lockBills"]').remove(); //关于计算 $('#poj-settings-4').find('input').prop('disabled', 'disabled'); //小数位数 $('#poj-settings-decimal').find('input').prop('disabled', 'disabled'); //人工单价调整 $('#std_labour_coe_files').prop('disabled', 'disabled'); //呈现选项 $('#display-setting').find('input').prop('disabled', 'disabled'); $('#recColSetting').remove(); //项目属性确定 $('#property_ok').addClass('disabled'); //特征及内容 $('#add-rule').find('select').prop('disabled', 'disabled'); $('#use-to-current').addClass('disabled'); $('#use-to-all').addClass('disabled'); $('.bottom-tools').remove(); //导入 $('#importConfirm').addClass('disabled'); //选项 $('#generalOpts1').prop('disabled', 'disabled'); $('#generalOpts2').prop('disabled', 'disabled'); //补充库编辑器 $('#compleRationLib').addClass('disabled'); $('#compleGljLib').addClass('disabled') //库 $('#stdBillsGuidanceTab').addClass('disabled'); $('#stdBillsTab').addClass('disabled'); $('#stdRationTab').addClass('disabled'); //人材机汇总,选择其他、另存使用 $('a[data-target="#change-unitFile"]').remove(); $('a[data-target="#unitFile-save-as"]').remove(); //费率,选择其他、另存使用、重选标准、统一设置相同参数 $('a[data-target="#change-lv"]').remove(); $('a[data-target="#copy-lv"]').remove(); $('#standardSelect').prop('disabled', 'disabled'); $('#cascadeSet').prop('disabled', 'disabled'); //计算程序标准 $('#calcProgramFileSelect').prop('disabled', 'disabled'); //调价 $('#calcPriceOption').prop('disabled', 'disabled'); $('#gljPriceTenderCoe').prop('disabled', 'disabled'); $('#tenderGLJQuantity').prop('disabled', 'disabled'); $('#tenderRationQuantity').prop('disabled', 'disabled'); $('#tenderPrice').prop('disabled', 'disabled'); $('#cleanTender').prop('disabled', 'disabled'); } //项目只读，表格只读 function disableSpread(spread){ spread.unbind(GC.Spread.Sheets.Events.ButtonClicked); let sheetCount = spread.getSheetCount(); for(let i = 0; i < sheetCount; i++){ let sheet = spread.getSheet(i); sheet.unbind(GC.Spread.Sheets.Events.ButtonClicked); sheet.unbind(GC.Spread.Sheets.Events.EditStarting); sheet.unbind(GC.Spread.Sheets.Events.EditEnded); sheet.unbind(GC.Spread.Sheets.Events.RangeChanged); sheet.unbind(GC.Spread.Sheets.Events.ClipboardChanging); sheet.unbind(GC.Spread.Sheets.Events.ClipboardChanged); sheet.unbind(GC.Spread.Sheets.Events.CellDoubleClick); sheet.unbind(GC.Spread.Sheets.Events.CellClick); sheet.unbind(GC.Spread.Sheets.Events.ValueChanged); sheet.suspendPaint(); sheet.suspendEvent(); sheet.options.isProtected = true; let rowCount = sheet.getRowCount(); let colCount = sheet.getColumnCount(); for(let row = 0; row < rowCount; row++){ for(let col = 0; col < colCount; col++){ sheet.getCell(row, col).locked(true); } } sheet.resumePaint(); sheet.resumeEvent(); } } //根据触发改变计算基数、费率弹出框 function changeCalcBaseFeeRate(toggle) { if(toggle === 'calcBase'){ $('#calcBaseFeeRate').find('.modal-header').show(); $('#calcBaseFeeRate').find('.modal-title').text('计算基数选择').show(); $('#calcBaseFeeRate').find('.modal-body').find('button:first').hide(); $('#calcBaseFeeRate').find('.modal-body').find('ul:first').hide(); } else if(toggle === 'feeRate'){ $('#calcBaseFeeRate').find('.modal-header').show(); $('#calcBaseFeeRate').find('.modal-title').text('费率选择').show(); $('#calcBaseFeeRate').find('.modal-body').find('button:first').hide(); $('#calcBaseFeeRate').find('.modal-body').find('ul:first').hide(); } else if(toggle === 'commonTotalFee') { $('#calcBaseFeeRate').find('.modal-header').hide(); $('#calcBaseFeeRate').find('.modal-body').find('button:first').show(); $('#calcBaseFeeRate').find('.modal-body').find('ul:first').show(); } } //综合合价弹出计算基数费率确认 $('#calcBaseFeeRateConf').click(function () { let toggle = $(this).attr('toggle'); if(!toggle || toggle !== 'commonTotalFee'){ return } let needToSave = false; let validateFeeRate = feeRateObject.checkSelectedFeeRate(); let calcBaseValue = calcBaseView.getInputExpr() ? calcBaseView.getInputExpr() : ''; let selected = projectObj.project.mainTree.selected; if(calcBaseValue !== selected.data.calcBase){ needToSave = true; selected.data.userCalcBase = calcBaseValue; projectObj.project.calcBase.calculate(selected); } if(!projectObj.project.calcBase.success){ return; } if(validateFeeRate){ feeRateObject.submitFeeRateFromBill(); } else if(!validateFeeRate && needToSave) { projectObj.project.calcProgram.calcAndSave(selected); } });