/** * Created by zhang on 2018/3/13. */ projectGljObject={ showTag:'ration',//mixRatio/machine showMixRatioMark:'', displayType:filterType.ALL, mixRatioType: [gljType.CONCRETE, gljType.MORTAR, gljType.MIX_RATIO,gljType.MAIN_MATERIAL], machineType: [gljType.GENERAL_MACHINE], projectGljSetting:{ header: [ {headerName: "编码", headerWidth: 80, dataCode: "code", dataType: "String"}, {headerName: "名称", headerWidth: 160, dataCode: "name", dataType: "String"}, {headerName: "规格型号", headerWidth: 120, dataCode: "specs", hAlign: "left", dataType: "String"}, {headerName: "单位", headerWidth: 45, dataCode: "unit", hAlign: "center", dataType: "String"}, {headerName: "类型", headerWidth: 45, dataCode: "short_name", hAlign: "center", dataType: "String"}, {headerName: "总消耗量", headerWidth: 100, dataCode: "quantity", hAlign: "right", dataType: "Number",decimalField:'glj.quantity'}, {headerName: "定额价", headerWidth: 70, dataCode: "basePrice", hAlign: "right", dataType: "Number",decimalField:'glj.unitPrice',validator:"number"}, {headerName: "调整价", headerWidth: 70, dataCode: "adjustPrice", hAlign: "right", dataType: "Number",decimalField:"glj.unitPrice"}, {headerName: "市场价", headerWidth: 70, dataCode: "marketPrice", hAlign: "right", dataType: "Number",decimalField:"glj.unitPrice",validator:"number"}, {headerName: "是否暂估", headerWidth: 60, dataCode: "is_evaluate", hAlign: "center", dataType: "String",cellType:'checkBox'}, {headerName: "主要材料", headerWidth: 60, dataCode: "is_main_material", hAlign: "center", dataType: "String",cellType:'checkBox'}, {headerName: "供货方式", headerWidth: 80, dataCode: "supply", hAlign: "center", dataType: "String",cellType:'comboBox',editorValueType:true,options:supplyComboMap}, {headerName: "甲供数量", headerWidth: 100, dataCode: "supply_quantity", hAlign: "right", dataType: "Number",validator:"number"}, {headerName: "三材类别", headerWidth: 80, dataCode: "materialType", hAlign: "center", dataType: "String",cellType:'comboBox',editorValueType:true,options:materialComboMap}, {headerName: "三材系数", headerWidth: 100, dataCode: "materialCoe", hAlign: "right", dataType: "Number",validator:"number"},//,decimalField:'material' {headerName: "交货方式", headerWidth: 90, dataCode: "delivery", hAlign: "left", dataType: "String"}, {headerName: "送达地点", headerWidth: 100, dataCode: "delivery_address", hAlign: "left", dataType: "String"}, {headerName: "不调价", headerWidth: 55, dataCode: "is_adjust_price", dataType: "String",cellType: "checkBox"} ], view: { lockColumns: [0,1,2,3,4,5,7] } }, projectGljSpread:null, projectGljSheet:null, materialTreeSheet:null, projectGljSheetData:[], mixRatioSetting:{ header:[ {headerName: "编码", headerWidth: 120, dataCode: "code", dataType: "String"}, {headerName: "名称", headerWidth: 120, dataCode: "name", dataType: "String"}, {headerName: "单位", headerWidth: 120, dataCode: "unit", hAlign: "center", dataType: "String"}, {headerName: "类型", headerWidth: 120, dataCode: "short_name", hAlign: "center", dataType: "String"}, {headerName: "定额价", headerWidth: 120, dataCode: "basePrice", hAlign: "right", dataType: "Number",decimalField:'glj.unitPrice',validator:"number"}, {headerName: "调整价", headerWidth: 120, dataCode: "adjustPrice", hAlign: "right", dataType: "Number",decimalField:"glj.unitPrice"}, {headerName: "市场价", headerWidth: 120, dataCode: "marketPrice", hAlign: "right", dataType: "Number",decimalField:"glj.unitPrice",validator:"number"}, {headerName: "消耗量", headerWidth: 120, dataCode: "consumption", hAlign: "right", dataType: "Number",decimalField:"glj.quantity",validator:"number"} ], view: { lockColumns: [0,1,2,3,4,5,6] } }, materialTreeSetting:{ "emptyRows":0, "headRows":1, "headRowHeight":[21], "defaultRowHeight": 21, "treeCol": 0, "cols":[] }, materialSetting:{ header:[ {headerName: "编码", headerWidth: 200, dataCode: "code", dataType: "String"}, {headerName: "名称", headerWidth: 160, dataCode: "name", dataType: "String"}, {headerName: "规格型号", headerWidth: 120, dataCode: "specs", hAlign: "left", dataType: "String"}, {headerName: "单位", headerWidth: 45, dataCode: "unit", hAlign: "center", dataType: "String"}, {headerName: "定额价", headerWidth: 70, dataCode: "basePrice", hAlign: "right", dataType: "Number",decimalField:'glj.unitPrice',validator:"number"}, {headerName: "市场价", headerWidth: 70, dataCode: "marketPrice", hAlign: "right", dataType: "Number",decimalField:"glj.unitPrice",validator:"number"}, {headerName: "总消耗量", headerWidth: 100, dataCode: "quantity", hAlign: "right", dataType: "Number",decimalField:'glj.quantity'}, {headerName: "三材系数", headerWidth: 100, dataCode: "materialCoe", hAlign: "right", dataType: "Number",validator:"number"},//,decimalField:'material' {headerName: "三材量", headerWidth: 100, dataCode: "materialQuantity", hAlign: "right", dataType: "Number",decimalField:'glj.quantity'}, {headerName: "三材类别", headerWidth: 80, dataCode: "materialType", hAlign: "center", dataType: "String",cellType:'comboBox',editorValueType:true,options:materialComboMap} ], view: { lockColumns: [0,1,2,3,6,8] } }, mixRatioSpread:null, mixRatioSheet:null, mixRatioData:[], usedTenderList:[], usedUnitPriceInfo:null, initProjectGljSpread:function () { if(!this.projectGljSpread){ this.projectGljSpread = SheetDataHelper.createNewSpread($("#project_glj_sheet")[0],2); } this.projectGljSpread.bind(GC.Spread.Sheets.Events.RangeChanged, this.onProjectGljRangeChange); this.initProjectGljSheet(); this.initMaterialTreeSheet(); }, initProjectGljSheet:function () { this.projectGljSheet = this.projectGljSpread .getSheet(0); this.initSheet(this.projectGljSheet,this.projectGljSetting); this.projectGljSheet.bind(GC.Spread.Sheets.Events.SelectionChanged,this.onProjectGljSelectionChange); this.projectGljSheet.bind(GC.Spread.Sheets.Events.EditStarting,this.onProjectGljEditStarting); this.projectGljSheet.name('projectGljSheet'); }, initMixRatio:function () { let me = projectGljObject; if(me.mixRatioSpread==null){ me.initMixRatioSpread(); me.initRightClick(); } }, initMixRatioSpread:function () { this.mixRatioSpread = SheetDataHelper.createNewSpread($("#mix_ratio_sheet")[0]); this.mixRatioSheet = this.mixRatioSpread .getSheet(0); this.initSheet(this.mixRatioSheet,this.mixRatioSetting); this.mixRatioSheet.name('mixRatioSheet'); }, initMaterialTreeSheet:function () { this.materialTreeSheet = this.projectGljSpread.getSheet(1); this.materialTreeSetting = this.createMaterialTreeSheetSetting(); this.materialTree = cacheTree.createNew(this); this.materialTreeController = TREE_SHEET_CONTROLLER.createNew(this.materialTree, this.materialTreeSheet, this.materialTreeSetting); this.materialTreeController.bind(TREE_SHEET_CONTROLLER.eventName.treeSelectedChanged, this.onSelectionChange); this.materialTreeSheet.bind(GC.Spread.Sheets.Events.EditStarting,this.onProjectGljEditStarting); this.materialTreeSheet.bind(GC.Spread.Sheets.Events.ValueChanged, this.onProjectGLJValueChange); this.materialTreeSheet.name('materialTreeSheet'); }, createMaterialTreeSheetSetting:function () { return sheetCommonObj.transferToTreeSetting(this.materialSetting,this.materialTreeSetting); }, unitPriceFileInit:function() { let me = this; let projectGLJ = projectObj.project.projectGLJ; let data = projectGLJ.datas; me.usedTenderList = data.usedTenderList !== undefined ? data.usedTenderList : []; me.usedUnitPriceInfo = data.constData.usedUnitPriceInfo !== undefined ? data.constData.usedUnitPriceInfo : {}; $("#current-name").text(me.usedUnitPriceInfo.name); let usedCount = me.usedTenderList.length <= 0 ? 1 : me.usedTenderList.length; $("#used-project-count").text(usedCount); }, getUsedTenderInfo:function() { return projectGljObject.usedTenderList.join("
"); }, showMixRatioData:function () { let me = this,gljId = null,gljType = null; let sheet = me.projectGljSpread.getActiveSheet(); let oldSel = me.mixRatioSheet.getSelections()[0]; if(sheet.name() == 'projectGljSheet'){//projectGljSheet/materialSheet 工料机汇总和三材汇总表 let sel = me.projectGljSheet.getSelections()[0]; let srow = sel.row == -1?0:sel.row; if(me.projectGljSheetData.length>srow){ gljId = me.projectGljSheetData[srow].id; gljType = me.projectGljSheetData[srow].type; } }else if(sheet.name() == 'materialTreeSheet' ){ if(this.materialTree.selected){ gljId = this.materialTree.selected.data.id; gljType = this.materialTree.selected.data.type; } } if(compositionTypes.indexOf(gljType)==-1){//如果不是有组成物的类型,工料机id设置为空,组成物表设置为空 gljId = null } projectObj.project.projectGLJ.getRatioData(gljId,function (data) { if(gljId !== projectObj.project.projectGLJ.getRatioId){//两个id不一致说明不是最新的请求,不用往下执行。 return; } let rationList =[]; for(let glj of data){ rationList.push(me.getMixRatioSheetData(glj)) ; } me.mixRatioData = rationList; me.mixRatioSheet.setRowCount(0); sheetCommonObj.showData(me.mixRatioSheet, me.mixRatioSetting,me.mixRatioData); me.mixRatioSheet.setRowCount(me.mixRatioData.length); me.mixRatioSheet.setSelection(oldSel.row==-1?0:oldSel.row,oldSel.col,oldSel.rowCount,oldSel.colCount); }) }, getMixRatioSheetData:function (glj) { let data ={ id:glj.id, mix_ratio_id:glj.ratio_data.id, code:glj.code, name:glj.name, specs:glj.specs, unit:glj.unit, type:glj.type, short_name:projectObj.project.projectGLJ.getShortNameByID(glj.type), consumption:glj.ratio_data.consumption, unit_price:glj.unit_price }; gljOprObj.setGLJPrice(data,glj); return data; }, onProjectGljEditStarting:function (sender, args) { let me = projectGljObject; let row = args.row; let col = args.col; if(me.projectGljEditChecking(row,col)==false){ args.cancel = true; } }, projectGljEditChecking:function (row,col) {//return false表示不能编辑 let me = projectGljObject; let data = null, setting=null; let sheet = me.projectGljSpread.getActiveSheet(); if(sheet.name() == 'projectGljSheet'){ data = me.projectGljSheetData[row]; setting = me.projectGljSetting; }else if(sheet.name() == 'materialTreeSheet'){ data = me.materialTree.selected.data; setting = me.materialSetting; } let dataCode = setting.header[col].dataCode; let lockColumns = setting.view.lockColumns; if(lockColumns.indexOf(col)!= -1){ return false; } if(dataCode=='is_adjust_price'||dataCode=='is_evaluate'||dataCode=='is_main_material'){ return false; } if(dataCode=='basePrice'||dataCode=='marketPrice'||dataCode=='supply'){//有组成物时,市场单价、定额价、供货方式不能修改 if (data.ratio_data && data.ratio_data.length > 0){ return false; } if(dataCode=='basePrice'&&data.is_add!=1){//如果不是新增,定额价不可修改。 return false; } } if(dataCode == 'supply_quantity'){ if (data.supply != 1) {// 如果为部分甲供则甲供数量需要可编辑,其它的都不能编辑 return false; } } if(dataCode == 'materialCoe'){//三材类别为空时,三材系数应只读,不允许输入。 if(data.materialType == undefined || data.materialType == null){ return false; } } return true; }, onSelectionChange:function (){ let me = projectGljObject; me.showMixRatioData(); me.materialTreeSheet.repaint(); }, onProjectGljSelectionChange:function (sender, args) { let me = projectGljObject; let newSel = args.newSelections[0]; let oldSel = args.oldSelections?args.oldSelections[0]:{}; if(newSel.row != oldSel.row){ me.mixRatioSheet.getSelections()[0].row = -1; me.showMixRatioData(); } me.projectGljSheet.repaint(); }, onProjectGljRangeChange:function (sender,info) { let me = projectGljObject; let changeInfo=[]; let canChange = true; if(me.projectGljEditChecking(info.row,info.col) == false){ canChange = false; }else if (info.action == GC.Spread.Sheets.RangeChangedAction.clear) { info.newValue = null; me.onProjectGLJValueChange(sender,info); return ; } for(let c of info.changedCells){ let value= info.sheet.getCell(c.row, c.col).text(); changeInfo.push({row:c.row,col:c.col,value:value}); if(me.projectGljEditChecking(c.row,c.col)==false){//如果不能编辑 canChange = false; } if (canChange==true&&!me.checkData(c.col,me.projectGljSetting,value)) { alert('输入的数据类型不对,请重新输入!'); canChange = false; } } if(canChange == false){//恢复原来的值 info.sheetName =="materialTreeSheet"?me.showMaterialTreeData():me.showProjectGljData(); }else if(info.sheetName =="projectGljSheet"){ me.batchUpdatePrice(changeInfo); } }, batchUpdatePrice(changeInfo){ let projectGLJ = projectObj.project.projectGLJ; let me = projectGljObject; projectGLJ.batchUpdatePrice(changeInfo,function (impactList) { let selected = me.projectGljSheet.getSelections()[0]; me.showProjectGljData(); me.projectGljSheet.setSelection(selected.row,selected.col,selected.rowCount,selected.colCount); }); }, showProjectGljData:function () { this.projectGljSpread.setActiveSheetIndex(0); let sel = this.projectGljSheet.getSelections()[0]; let projectGljSheetData = []; let gljList = projectObj.project.projectGLJ.datas.gljList; gljList = this.filterProjectGLJ(gljList); gljList = sortProjectGLJ(gljList); for(let glj of gljList){ projectGljSheetData.push(this.getSheetDataByGLJ(glj)); } this.projectGljSheetData = projectGljSheetData; this.projectGljSheet.setRowCount(0); sheetCommonObj.showData(this.projectGljSheet, this.projectGljSetting,this.projectGljSheetData); this.projectGljSheet.setRowCount(this.projectGljSheetData.length); this.projectGljSheet.setSelection(sel.row==-1?0:sel.row,sel.col,sel.rowCount,sel.colCount); }, showMaterialTreeData:function () { this.projectGljSpread.setActiveSheetIndex(1); let sel = this.materialTreeSheet.getSelections()[0]; let gljList = projectObj.project.projectGLJ.datas.gljList; gljList = _.sortByAll(gljList, [ 'code']); this.createMaterialTree(gljList); this.materialTreeController.showTreeData(); this.materialTreeSheet.setSelection(sel.row==-1?0:sel.row,sel.col,sel.rowCount,sel.colCount); this.materialTreeController.setTreeSelected(this.materialTree.items[sel.row==-1?0:sel.row]); }, refreshDataSheet:function () { let me = projectGljObject; if(me.displayType == filterType.SCHZ){//三材汇总树节点 me.showMaterialTreeData(); }else { me.showProjectGljData(); me.showMixRatioData(); } }, createMaterialTree:function (gljList) { let me = projectGljObject; let q_decimal = getDecimal("glj.quantity"); let GC = {id:'GC',name:materialType[materialTypeMap.GC],code:'GC',unit:'t',ParentID:-1,NextSiblingID:'MC'}; let GJ = {id:'GJ',name:materialType[materialTypeMap.GJ],code:'GJ',unit:'t',ParentID:'GC',NextSiblingID:-1}; let MC = {id:'MC',name:materialType[materialTypeMap.MC],code:'MC',unit:'t',ParentID:-1,NextSiblingID:'SN'}; let SN = {id:'SN',name:materialType[materialTypeMap.SN],code:'SN',unit:'m3',ParentID:-1,NextSiblingID:'SZ'}; let SZ = {id:'SZ',name:materialType[materialTypeMap.SZ],code:'BZZ',unit:'千块',ParentID:-1,NextSiblingID:-1}; let rootDatas= [GC,GJ,MC,SN,SZ]; let parentMap = {}; let sumMap = {}; this.materialTree.nodes={},this.materialTree.selected = null,this.materialTree.roots = [],this.materialTree.items=[]; for(let r of rootDatas){ let baseNode = null; if(r.id == 'GJ'){ baseNode = createMaterialNode(r,parentMap['GC'],null);//钢筋的父节点为钢材 }else { baseNode = createMaterialNode(r,null,null); } parentMap[r.id] = baseNode; } for(let g of gljList){ if(g.quantity !== 0 && g.quantity !== '0'){ if(g.materialType){ let tem = me.getMaterialSheetDataByGLJ(g); if(tem.materialQuantity){ sumMap[g.materialType] = sumMap[g.materialType]?sumMap[g.materialType] + tem.materialQuantity:tem.materialQuantity; tem.materialQuantity = scMathUtil.roundToString(tem.materialQuantity,q_decimal);//转成string } if(g.materialType == materialTypeMap.GC){ //钢材的下一节点是钢筋 createMaterialNode(tem,parentMap['GC'],parentMap['GJ']); }else { createMaterialNode(tem,parentMap[materialTypeMap[g.materialType]]); } } } } for(let mkey in sumMap){ if(mkey == materialTypeMap.GC && sumMap[materialTypeMap.GJ]){//钢材汇总要加上钢筋的总量 parentMap['GC'].data.materialQuantity = scMathUtil.roundToString(sumMap[mkey]+sumMap[materialTypeMap.GJ],q_decimal); }else { parentMap[materialTypeMap[mkey]].data.materialQuantity = scMathUtil.roundToString(sumMap[mkey],q_decimal); } } this.materialTree.sortTreeItems(); function createMaterialNode(data,parent,next) { let newNode = me.materialTree.addNode(parent, next, data.id); newNode.data = data; return newNode; } }, getMaterialSheetDataByGLJ:function (glj) { let q_decimal = getDecimal("glj.quantity"); let m_decimal = getDecimal("material"); let p_decimal = getDecimal("glj.unitPrice"); let projectGLJ = projectObj.project.projectGLJ; let data ={ id:glj.id, code:glj.code, name:glj.name, specs:glj.specs, unit:glj.unit, type:glj.type, short_name:projectGLJ.getShortNameByID(glj.type), quantity:scMathUtil.roundToString(glj.quantity,q_decimal), supply:glj.supply, supply_quantity:glj.supply_quantity, materialType:glj.materialType, delivery:glj.delivery, delivery_address:glj.delivery_address, is_adjust_price:glj.is_adjust_price, ratio_data:glj.ratio_data, is_add:glj.unit_price.is_add, bgColour:'white' }; if(glj.materialCoe){ data.materialCoe = scMathUtil.roundForObj(glj.materialCoe,m_decimal); //data.materialCoe = scMathUtil.roundToString(glj.materialCoe,m_decimal); data.materialQuantity = scMathUtil.roundForObj(glj.materialCoe * glj.quantity,q_decimal);//还要做汇总,汇总完再转成string } gljOprObj.setGLJPrice(data,glj); data.basePrice = scMathUtil.roundToString(data.basePrice,p_decimal); data.marketPrice = scMathUtil.roundToString(data.marketPrice,p_decimal); return data; }, filterProjectGLJ:function (gljList) { let me = projectGljObject; if(gljList.length>0){ gljList = _.filter(gljList,function (item) { return me.displayTypeFilter(item); }); } return gljList; }, displayTypeFilter:function (item) { let me = this; if(item.quantity !== 0 && item.quantity !== '0'){//过滤掉消耗量为0的工料机 if(me.displayType == filterType.ALL){//所有工料机 return true; }else if(filterTypeArray.indexOf(me.displayType) != -1){//人工、材料、机械、主材、设备 let typeString = item.type+""; return typeString.startsWith(me.displayType); }else if(me.displayType == filterType.FBFX){//“分部分项总消耗量”≠0的工料机行 return item.subdivisionQuantity !== 0 && item.subdivisionQuantity !== '0'; }else if(me.displayType == filterType.TECH){//筛选“措施项目总消耗量”≠0的工料机行 return item.techQuantity !== 0 && item.techQuantity !== '0'; }else if(me.displayType == filterType.JGCL){//筛选“供货方式”=“完全甲供”或“部分甲供”的工料机行 return item.supply == supplyType.WQJG || item.supply == supplyType.BFJG; }else if(me.displayType == filterType.ZGCL){//筛选“是否暂估”=“是”的工料机行。 return item.is_evaluate == 1; }else if(me.displayType == filterType.ZYCL){//筛选“主要材料”=“是”的工料机行。 return item.is_main_material == 1; } } return false; }, getSheetDataByGLJ:function (glj) { let projectGLJ = projectObj.project.projectGLJ; let materialIdList = projectGLJ.datas.constData.materialIdList; let data ={ id:glj.id, code:glj.code, name:glj.name, specs:glj.specs, unit:glj.unit, type:glj.type, short_name:projectGLJ.getShortNameByID(glj.type), quantity:glj.quantity, supply:glj.supply, supply_quantity:glj.supply_quantity, materialType:glj.materialType, materialCoe:glj.materialCoe, delivery:glj.delivery, delivery_address:glj.delivery_address, is_adjust_price:glj.is_adjust_price, ratio_data:glj.ratio_data, is_add:glj.unit_price.is_add, bgColour:'white' }; gljOprObj.setGLJPrice(data,glj); data.is_main_material = glj.is_main_material == 1?1:0; //供货方式为完全甲供时设置甲供数量为总消耗量 if (data.supply == 2) { data.supply_quantity = glj.quantity; } // 只有材料才显示是否暂估 if (materialIdList.indexOf(glj.type) >= 0) { data.is_evaluate = glj.is_evaluate; } if(glj.materialCoe !== null && glj.materialCoe !==undefined){ data.materialCoe = scMathUtil.roundForObj(glj.materialCoe,getDecimal("material")); } //bgColour if(data.basePrice == data.marketPrice){//如果定额价等于市场价时,改底色。 优先度低于有组成物时的底色 data.bgColour = "#C4CAFB"; } if (notEditType.indexOf(glj.type) >= 0) { if (data.ratio_data && data.ratio_data.length > 0){//有组成物时 //设置底色 data.bgColour = "#E0E0E0"; } } return data; }, refreshProjectGljRow:function (row) { let me = projectGljObject; let rowData = me.projectGljSheetData[row]; let glj = projectObj.project.projectGLJ.getByID(rowData.id); let newRow = null; if(glj){ newRow = me.getSheetDataByGLJ(glj); } if(me.displayTypeFilter(newRow) == true){ me.projectGljSheetData[row] = newRow; sheetCommonObj.showRowData(this.projectGljSheet, this.projectGljSetting,row,this.projectGljSheetData); }else { me.projectGljSheetData.splice(row,1); me.projectGljSheet.deleteRows(row,1); me.showMixRatioData(); } //me.projectGljSheetData[row] = me.getSheetDataByGLJ(glj); }, initSheet: function (sheet,setting) { var me = this; sheetCommonObj.initSheet(sheet, setting, 30); sheet.bind(GC.Spread.Sheets.Events.ValueChanged, me.onSheetValueChange); }, onSheetValueChange:function (e,info) { let me = projectGljObject; if(info.sheetName=='projectGljSheet'){ me.onProjectGLJValueChange(e,info); }else if(info.sheetName == 'mixRatioSheet'){ me.onMixRatioValueChange(e,info); } }, onMixRatioValueChange:function (e,info){ let composition = projectObj.project.composition; let me = projectGljObject,row = info.row, col = info.col; let dataCode = me.mixRatioSetting.header[col].dataCode; let recode = me.mixRatioData[row]; let value = info.newValue; let parentSheet = me.projectGljSpread.getActiveSheet();//三材汇总表和工料机汇总表 if (!me.checkData(col,me.mixRatioSetting,value)) { alert('输入的数据类型不对,请重新输入!'); me.mixRatioSheet.setValue(row, col, info.oldValue); return false; } value = scMathUtil.roundToString(value,getDecimal("glj.quantity")); let [parentMarketPrice, parentBasePrice] = me.getCompositionSumPrice('modify', row, value); let updateData ={id: recode.mix_ratio_id, field: 'mix_ratio.' + dataCode, value: value, market_price: parentMarketPrice, base_price: parentBasePrice}; let prow = parentSheet.getActiveRowIndex();//取父机械或组成物的下标 let prowData = parentSheet.name() == 'projectGljSheet'?me.projectGljSheetData[prow]:me.materialTree.items[prow].data; composition.updateConsumption(updateData,recode,prowData.id,function (sid) { /* if(parentSheet.name() == 'projectGljSheet'){ 之前是单行刷新,父工料机与组成物对应的工料机分开刷,发现这样比整个刷新慢所以先整个刷新,当以后数据量大的时候再测试 me.refreshProjectGljRowByID(sid); }*/ me.refreshParentData(prow,prowData.id,sid); }); }, refreshParentData:function (row,pid,sid) { let me = this; let sheet = me.projectGljSpread.getActiveSheet(); let parantData = null; if(sheet.name() == 'projectGljSheet'){ me.showProjectGljData();// me.refreshProjectGljRow(row) 这里原来是分开刷新的,现在整个统一刷新,先留着 parantData = me.projectGljSheetData[row]; }else { me.showMaterialTreeData(); parantData = me.materialTree.items[row].data; } // 更新组成物缓存 projectObj.project.composition.loadData(); //先查找使用了父项目工料机的定额工料机 let updateNodes=[]; let ration_gljs = _.filter(projectObj.project.ration_glj.datas,{'projectGLJID':pid}); for(let rg of ration_gljs){ let node = projectObj.project.mainTree.getNodeByID(rg.rationID); if(node){ updateNodes.push(node); } } //或者是使用了父项目工料机的工料机类型的定额 let rations = _.filter(projectObj.project.Ration.datas,{'type':3,'projectGLJID':pid}); for(let r of rations){ let r_node = projectObj.project.mainTree.getNodeByID(r.ID); if(r_node){ r_node.data.marketUnitFee = parantData.marketPrice;//parentMarketPrice;//这里用显示的价格 updateNodes.push(r_node); } } if(sid){ let subRations = calcTools.getRationsByProjectGLJ(sid); updateNodes = updateNodes.concat(subRations); } if(updateNodes.length>0){ projectObj.project.calcProgram.calcRationsAndSave(updateNodes,function () { projectObj.mainController.refreshTreeNode(projectObj.project.mainTree.roots); }); } gljOprObj.refreshView(); }, deleteMixRatio:function (row) { let me = this, deleteRecode = me.mixRatioData[row]; let consumption = deleteRecode.consumption; let [parentMarketPrice, parentBasePrice] = me.getCompositionSumPrice('delete', row); let parentSheet = me.projectGljSpread.getActiveSheet();//三材汇总表和工料机汇总表 let prow= parentSheet.getActiveRowIndex();//取父机械或组成物的下标 let prowData = parentSheet.name() == 'projectGljSheet'?me.projectGljSheetData[prow]:me.materialTree.items[prow].data; let updateData = {id: deleteRecode.mix_ratio_id, field: 'mix_ratio.consumption' , value: 0, market_price: parentMarketPrice, base_price: parentBasePrice}; projectObj.project.composition.deleteComposition(updateData,deleteRecode,prowData.id,function () { me.refreshParentData(prow,prowData.id); me.mixRatioSheet.deleteRows(row,1); }); }, getCompositionSumPrice : function(scene, affectRow, newValue = 0) { let me = this; let parentMarketPrice = 0; let parentBasePrice = 0; for(let i = 0;i < me.mixRatioData.length;i++){ let ratio = me.mixRatioData[i]; let marketPrice = ratio.unit_price.marketPrice; let basePrice = ratio.unit_price.base_price; // 如果是删除则忽略即将被删除的行数据 if (scene === 'delete' && affectRow === i) { continue; } let consumption = i === affectRow ? newValue : ratio.consumption; parentMarketPrice += operationWithRound(consumption,marketPrice,"glj.unitPrice","*"); parentBasePrice += operationWithRound(consumption,basePrice,"glj.unitPrice","*"); } parentMarketPrice = parentMarketPrice.toDecimal(getDecimal("glj.unitPrice")); parentBasePrice = parentBasePrice.toDecimal(getDecimal("glj.unitPrice")); return [parentMarketPrice, parentBasePrice]; }, onProjectGLJValueChange:function (e,info) {//me.projectGljSetting let projectGLJ = projectObj.project.projectGLJ; let me = projectGljObject,row = info.row, col = info.col; let setting = info.sheetName =="materialTreeSheet"?me.materialSetting:me.projectGljSetting; let dataCode = setting.header[col].dataCode; let recode = info.sheetName =="materialTreeSheet"?me.materialTree.selected.data:me.projectGljSheetData[row]; let value = info.newValue; if(info.newValue === undefined ){ return; } if (value&&!me.checkData(col,setting,value)) { setTimeout(function () {//为了不与click事件冲突 alert('输入的数据类型不对,请重新输入!'); },200); info.sheetName =="materialTreeSheet"?me.materialTreeController.refreshTreeNode([me.materialTree.selected]):me.refreshProjectGljRow(row); return ; } let callback=function (impactList) { info.sheet.suspendPaint(); info.sheet.suspendEvent(); if(info.sheetName =="materialTreeSheet"){ me.showMaterialTreeData(); }else { me.refreshProjectGljRow(row); for(let g of impactList){ me.refreshProjectGljRowByID(g.id,row); } } info.sheet.resumeEvent(); info.sheet.resumePaint(); if (dataCode === 'supply' || dataCode === 'supply_quantity'){ // basePrice、marketPrice 有自己的计算代码,无需走这里重复计算 let rations = calcTools.getRationsByProjectGLJ(recode.id); projectObj.project.calcProgram.calcNodesAndSave(rations, function () { projectObj.mainController.refreshTreeNode(projectObj.project.mainTree.roots); }); } gljOprObj.refreshView(); }; if(dataCode=='basePrice'||dataCode=='marketPrice'){ value= scMathUtil.roundForObj(value,getDecimal('glj.unitPrice'));//修改市场价和修改定额价时需要重新记算很多受影响的树节点,现在改成与定字额工料机那里调相同的方法。 let editField = dataCode === 'basePrice'?"base_price":"market_price"; projectObj.project.projectGLJ.updatePrice(recode,editField,value,'pg',callback); }else { let extend = {}; // 如果是供货方式则需要处理数据 if (dataCode === 'supply') { extend.supply_quantity = me.getSupplyQuantity(value, recode.quantity); } if(dataCode === 'supply_quantity'){//修改数量需做4舍5入 value= value.toDecimal(getDecimal('glj.quantity')); } if(dataCode === 'is_evaluate'||dataCode === 'is_adjust_price'||dataCode === 'is_main_material'){ if(value == true){ value = 1; }else if(value == false){ value = 0; } } if(dataCode === 'materialType' && value == null){//删除三材类别时,清空三材系数 extend.materialCoe = null; } if(dataCode == 'materialCoe'){ value = scMathUtil.roundForObj(value,getDecimal("material")); } extend = Object.keys(extend).length > 0 ? JSON.stringify(extend) : ''; let updateData = {id: recode.id, field: dataCode, value: value, extend: extend}; projectGLJ.pGljUpdate(updateData,callback); }; }, refreshProjectGljRowByID:function (ID,row) {//row 可以不传,如果row 和 index 相等就不刷新 let me = this; let index = _.findIndex(me.projectGljSheetData, { 'id': ID}); if(index>=0&&index != row){ me.refreshProjectGljRow(index); } }, getSupplyQuantity : function(supplyType, quantity) { // 自行采购和甲定乙供则把甲供数量设置为0,其余情况则设置为当前总消耗量 let supplyQuantity = supplyType == 0 || supplyType == 3 ? 0 : quantity; supplyQuantity = parseFloat(supplyQuantity); return supplyQuantity; }, checkData : function(col,setting, value) { let result = true; let validator = setting.header[col].validator !== undefined ? setting.header[col].validator : null; if (validator === null) { return result; } switch (validator) { case 'number': let regular = /^\d+(\.\d+)?$/; result = regular.test(value); break; case 'boolean': let booleanValue = [true, false]; result = booleanValue.indexOf(value) >= 0; break; } return result; }, initRightClick : function() { let activeSheet = this.mixRatioSheet; let me = this; $.contextMenu({ selector: '#mix_ratio_sheet', build: function ($trigger, e) { me.rightClickTarget = SheetDataHelper.safeRightClickSelection($trigger, e, me.mixRatioSpread); return me.rightClickTarget.hitTestType === GC.Spread.Sheets.SheetArea.viewport || me.rightClickTarget.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader; }, items: { "deleteMixRatio": { name: "删除", icon: 'fa-trash-o', disabled: function () { return me.rightClickTarget.row === undefined; }, callback: function (key, opt) { let row = me.rightClickTarget.row; me.deleteMixRatio(row); } }, } }); }, changeFileCallback:function(){ projectGljObject.unitPriceFileInit(); projectGljObject.refreshDataSheet(); gljOprObj.refreshView(); projectObj.project.calcProgram.calcAllNodesAndSave(); if(socketObject.roomInfo){ let data ={ projectID:projectObj.project.ID(), oldRoom:socketObject.roomInfo.unitFile, newRoom:socketObject.getUnitFileRoomID(), name:'unitFile' }; socket.emit('changeNewRoom',data); socketObject.roomInfo.unitFile = socketObject.getUnitFileRoomID(); } }, calcPartASupplyFeeByProjectGLJs: function (projectGLJsArr) { for (let pGLJ of projectGLJsArr){ if (pGLJ.supply == supplyType.BFJG){ let rations = calcTools.getRationsByProjectGLJ(pGLJ.id); projectObj.project.calcProgram.calcNodesAndSave(rations, function () { projectObj.mainController.refreshTreeNode(projectObj.project.mainTree.roots); }); } }; } }; $(function () { let pojGljResizeEles = {}; pojGljResizeEles.id = '#project-glj-main'; pojGljResizeEles.resize = $('#project-glj-main').find('.resize'); pojGljResizeEles.nearElement = $('#project-glj-main').find('.top-content'); pojGljResizeEles.nearSpread = pojGljResizeEles.nearElement.children(".main-data-top"); pojGljResizeEles.farElement = $('#project-glj-main').find('.bottom-content'); pojGljResizeEles.farSpread = pojGljResizeEles.farElement.children().find(".main-data-bottom"); pojGljResizeEles.nav = pojGljResizeEles.farElement.children('ul.nav'); slideResize(pojGljResizeEles, {min: 170, max: 700}, 'height', function () { projectGljObject.projectGljSpread.refresh(); projectGljObject.mixRatioSpread?projectGljObject.mixRatioSpread.refresh():''; }); $('#tab_project_glj').on('shown.bs.tab', function (e) { sessionStorage.setItem('mainTab', '#tab_project_glj'); let me = projectGljObject; $(e.relatedTarget.hash).removeClass('active'); if(me.projectGljSpread==null){ me.initProjectGljSpread(); } me.unitPriceFileInit(); me.initMixRatio(); //projectObj.project.projectGLJ.calcQuantity(); 在工程量有更新的地方调用 me.refreshDataSheet(); loadSize(pojGljResizeEles, 'height', function () { me.projectGljSpread.refresh(); me.mixRatioSpread?me.mixRatioSpread.refresh():''; }); }); /* $('#ration_link').on('shown.bs.tab', function (e) { let me = projectGljObject; me.showTag='ration'; me.showProjectGljData(); }); $('#mix_ratio_link').on('shown.bs.tab', function (e) { let me = projectGljObject; me.showTag='mixRatio'; me.showProjectGljData(); me.initMixRatio(); }); $('#machine_ratio_link').on('shown.bs.tab', function (e) { let me = projectGljObject; me.showTag='machine'; me.showProjectGljData(); me.initMixRatio(); });*/ $('#pop-used-list').popover({ placement: "bottom", html: true, trigger: "hover | focus", content: projectGljObject.getUsedTenderInfo } ); // 单价文件切换弹框 $('#change-unitFile').on('shown.bs.modal', function () { let rootProjectID = projectInfoObj.projectInfo.property.rootProjectID; // 获取切换单价文件相关数据 $.ajax({ url: '/glj/get-project-info', type: 'post', data: {project_id: scUrlUtil.GetQueryString('project'),rootProjectID:rootProjectID}, dataType: 'json', success: function (response) { if (response.err === 1) { alert('数据传输错误!'); return false; } let data = response.data; $("#current-project-name").text(data.currentProjectName); // 本项目中的单价文件 if (data.self.length > 0) { let selfFileHtml = ''; for (let tmp of data.self) { let select = usedUnitPriceInfo === tmp.id ? ' selected="selected"' : ''; selfFileHtml += '' + tmp.name + ''; } $("#self-file").html(selfFileHtml); } // 其他建设项目数据 if (data.other.length > 0) { let otherProjectHtml = ''; let otherFileHtml = ''; for (let tmp of data.other) { otherProjectHtml += ''; otherFileData[tmp.ID] = tmp.unitPriceList; if (otherFileHtml !== '') { continue; } for (let unitPrice of tmp.unitPriceList) { otherFileHtml += ''; } } $("#other-project").html(otherProjectHtml); $("#other-file").html(otherFileHtml); } } }); }); // 单价文件切换确认 $("#change-file-confirm").click(function () { let type = $("input[name='change-type']:checked").val(); type = parseInt(type); let changeUnitPriceId = 0; if (type === 0) { // 从本项目中选择 changeUnitPriceId = $("#self-file").val(); } else { // 从其他项目中复制 changeUnitPriceId = $("#other-file").val(); } $('#change-unitFile').modal("hide"); let data = {project_id: scUrlUtil.GetQueryString('project'), change_id: changeUnitPriceId, type: type}; projectObj.project.projectGLJ.changeFile(data,function () { projectGljObject.changeFileCallback(); }) }); // 单价文件选项切换 $("input[name='change-type']").change(function () { let type = $(this).val(); type = parseInt(type); $("#change-unitFile .option").hide(); if (type === 0) { $(".option.select").show(); } else { $(".option.copy").show(); } }); $("#unitFile-save-as").on('shown.bs.modal', function () { // 获取当前建设项数据 $("#save-as-name").val(projectGljObject.usedUnitPriceInfo.name + '副本'); }); // 从其他建设项目中复制 选择建设项目 $("#other-project").change(function () { let projectId = $(this).val(); if (otherFileData[projectId] === undefined) { return false; } let otherFileHtml = ''; for (let unitPrice of otherFileData[projectId]) { otherFileHtml += ''; } $("#other-file").html(otherFileHtml); }); // 单价文件另存为操作 $("#save-as-confirm").click(function () { let name = $("#save-as-name").val(); if (name === '') { $("#save-as-tips").text('请填写单价文件名称').show(); return false; } let saveData = {name: name, project_id: scUrlUtil.GetQueryString('project')}; projectObj.project.projectGLJ.saveAs(saveData,function () { projectGljObject.changeFileCallback(); $("#unitFile-save-as").modal("hide"); }); }); $("#filterType").on("click","ul li a",function(){ let me = projectGljObject; me.displayType = filterType[this.id]; me.refreshDataSheet(); }); });