/** * Created by zhang on 2018/3/13. */ let 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:{}, projectGljSpread:null, projectGljSheet:null, materialTreeSheet:null, projectGljSheetData:[], mixRatioSetting:{}, infoPriceSetting:{ header:[ {headerName: "材料名称", headerWidth: 320, dataCode: "name", dataType: "String"}, {headerName: "规格型号", headerWidth: 200, dataCode: "specs", hAlign: "left", dataType: "String"}, {headerName: "单位", headerWidth: 50, dataCode: "unit", dataType: "String",hAlign: "center"}, {headerName: "含税市场价", headerWidth: 100, dataCode: "taxPrice", hAlign: "right", dataType: "Number",validator:"number"}, {headerName: "不含税市场价", headerWidth: 100, dataCode: "noTaxPrice", hAlign: "right", dataType: "Number",validator:"number"}//,decimalField:"glj.unitPrice" ], view: { lockColumns: [0,1,2,3,4]//, //colHeaderHeight:30 } }, relatedRationSetting:{ header:[ {headerName: "编码", headerWidth: 100, dataCode: "code", dataType: "String"}, {headerName: "名称", headerWidth: 180, dataCode: "name", dataType: "String"}, {headerName: "单位", headerWidth: 50, dataCode: "unit", dataType: "String",hAlign: "center"}, {headerName: "工程量", headerWidth: 65, dataCode: "quantity", dataType: "Number", hAlign: "right",decimalField: "ration.quantity"}, {headerName: "单价", headerWidth: 65, dataCode: "feesIndex.common.unitFee", dataType: "Number", hAlign: "right",decimalField: "ration.unitPrice"} ], view: { lockColumns: [0,1,2,3,4]//, //colHeaderHeight:30 } }, 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: 160, dataCode: "specs", hAlign: "left", dataType: "String"}, {headerName: "单位", headerWidth: 45, dataCode: "unit", hAlign: "center", dataType: "String"}, {headerName: "定额价", headerWidth: 70, dataCode: "basePrice", hAlign: "right", dataType: "Number",validator:"number"},//,decimalField:'glj.unitPrice' {headerName: "市场价", headerWidth: 70, dataCode: "marketPrice", hAlign: "right", dataType: "Number",validator:"number"},//,decimalField:"glj.unitPrice" {headerName: "总消耗量", headerWidth: 70, dataCode: "quantity", hAlign: "right", dataType: "Number",decimalField:'glj.quantity'}, {headerName: "三材系数", headerWidth: 70, dataCode: "materialCoe", hAlign: "right", dataType: "Number",validator:"number"},//,decimalField:'material' {headerName: "三材量", headerWidth: 100, dataCode: "materialQuantity", hAlign: "right", dataType: "Number",decimalField:'glj.quantity'}, {headerName: "三材类别", headerWidth: 70, 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:[], subList:[],//定额工料机,添加组成物时临时保存组成物信息的位置 usedTenderList:[], usedUnitPriceInfo:null, displayTypeMap:[ {ID:'LABOUR',text:'人工'}, {ID:'GENERAL_MATERIAL',text:'材料'}, {ID:'GENERAL_MACHINE',text:'机械'}, {ID:'MAIN_MATERIAL',text:'主材'}, {ID:'EQUIPMENT',text:'设备'} ], initInfoPriceSpread:function(){ if(this.infoPriceSpread) return this.infoPriceSpread.refresh(); this.infoPriceSpread = SheetDataHelper.createNewSpread($("#info_price_sheet")[0]); sheetCommonObj.spreadDefaultStyle(this.infoPriceSpread); this.infoPriceSheet = this.infoPriceSpread .getSheet(0); this.initSheet(this.infoPriceSheet,this.infoPriceSetting); this.infoPriceSheet.bind(GC.Spread.Sheets.Events.TopRowChanged, _.debounce(this.onInfoTopRowChanged, 100)); this.infoPriceSheet.bind(GC.Spread.Sheets.Events.CellDoubleClick, this.onInfoPriceDoubleClick); this.infoPriceSheet.name('infoPriceSheet'); this.infoPriceSheet.setRowCount(0); this.getInfoPriceOptions(); if(projectReadOnly){ disableSpread(this.infoPriceSpread); }else{ this.initInfoPriceRightClick(); } }, initSpreads:function(){ if(this.projectGljSpread==null) this.initProjectGljSpread(); //if(materialAdjustObj.spread == null) materialAdjustObj.initSpread(); if(configMaterialObj.configSpread == null) configMaterialObj.initSpread(); }, initProjectGljSpread:function () { if(!this.projectGljSpread){ this.projectGljSpread = SheetDataHelper.createNewSpread($("#project_glj_sheet")[0],2); sheetCommonObj.spreadDefaultStyle(this.projectGljSpread); } this.projectGljSpread.bind(GC.Spread.Sheets.Events.RangeChanged, this.onProjectGljRangeChange); this.initProjectGljSheet(); this.initMaterialTreeSheet(); disableRightMenu("project_glj_sheet",this.projectGljSpread,this.rightClickCallback); //打开别人分享的项目,只读 if(projectReadOnly){ //锁定逻辑走disabledSpread里的 if(this.projectGljSetting.view.lockColumns){ this.projectGljSetting.view.lockColumns = null; } disableSpread(this.projectGljSpread); } }, 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'); //this.projectGljSheet.setRowHeight(0, 36, 1); this.projectGljSheet.options.frozenlineColor = '#ababab'; this.projectGljSheet.frozenColumnCount(this.projectGljSetting.frozenCols); }, initMixRatio:function () { let me = projectGljObject; if(me.mixRatioSpread==null){ me.initMixRatioSpread(); if(!projectReadOnly){ me.initRightClick(); } } }, initMixRatioSpread:function () { this.mixRatioSpread = SheetDataHelper.createNewSpread($("#mix_ratio_sheet")[0],2); sheetCommonObj.spreadDefaultStyle(this.mixRatioSpread); this.mixRatioSheet = this.mixRatioSpread .getSheet(0); this.initSheet(this.mixRatioSheet,this.mixRatioSetting); this.mixRatioSheet.name('mixRatioSheet'); this.mixRatioSheet.bind(GC.Spread.Sheets.Events.RangeChanged, this.onMixRatioRangeChange); this.initRelatedRationSheet(); if(projectReadOnly){ if(this.mixRatioSetting.view.lockColumns){ this.mixRatioSetting.view.lockColumns = null; } disableSpread(this.mixRatioSpread); } }, initRelatedRationSheet:function(){ this.relatedRationSheet = this.mixRatioSpread.getSheet(1); sheetCommonObj.initSheet(this.relatedRationSheet, this.relatedRationSetting, 30); this.relatedRationSheet.name('relatedRation'); this.relatedRationSheet.bind(GC.Spread.Sheets.Events.CellDoubleClick, this.onRelatedRationDoubleClick); //this.mixRatioSheet.bind(GC.Spread.Sheets.Events.RangeChanged, this.onMixRatioRangeChange); }, 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'); if(projectReadOnly && this.materialSetting.view.lockColumns){ if(this.materialSetting.view.lockColumns){ this.materialSetting.view.lockColumns = null; } } }, 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); $("#editUnitFile").attr("href",`/unitPrice/index/${me.usedUnitPriceInfo.id}`) }, getUsedTenderInfo:function() { return "人材机单价的变化,将自动影响以下单位工程造价:
"+projectGljObject.usedTenderList.join("
"); }, // 获取选中人材机,添加组成物时,分页查询语句的扩展 getQueryExtForMixRatio: function () { const extend = {}; if (!this.selectedProjectGLJ) { return extend; } if (this.selectedProjectGLJ.type === gljType.MAIN_MATERIAL) {//对于主材,只显示没有组成物并且除了自已的主材 extend['component.0'] = {$exists: false}; extend.gljType = gljType.MAIN_MATERIAL; } else if (_.includes(gljUtil.hasCompMaterial, this.selectedProjectGLJ.type)) {//混凝土、砂浆、配合比 extend.gljType = gljType.GENERAL_MATERIAL; } else if (_.includes(gljUtil.hasCompMachine, this.selectedProjectGLJ.type)) {//me.selectedProjectGLJ.type == gljType.GENERAL_MACHINE//机械中有组成物的类型 extend.gljType = {$in: gljUtil.machineComposition}; } return extend; }, filterLibGLJForMixRatio:function () { let me = this; if(me.selectedProjectGLJ){ let showTypes = []; if(me.selectedProjectGLJ.type == gljType.MAIN_MATERIAL){//对于主材,只显示没有组成物并且除了自已的主材 showTypes = [gljType.MAIN_MATERIAL]; }else if(_.includes(gljUtil.hasCompMaterial,me.selectedProjectGLJ.type)){//混凝土、砂浆、配合比 showTypes = [gljType.GENERAL_MATERIAL]; }else if(_.includes(gljUtil.hasCompMachine,me.selectedProjectGLJ.type)){//me.selectedProjectGLJ.type == gljType.GENERAL_MACHINE//机械中有组成物的类型 showTypes = gljUtil.machineComposition; } gljOprObj.gljLibSheetData = _.filter(gljOprObj.gljLibSheetData, function (item) { if(me.selectedProjectGLJ.type == gljType.MAIN_MATERIAL){ let p_index = gljOprObj.getIndex(me.selectedProjectGLJ,gljKeyArray); let i_index = gljOprObj.getIndex(item,gljLibKeyArray); return item.gljType == gljType.MAIN_MATERIAL &&item.component.length == 0 && p_index!=i_index }else { return _.includes(showTypes,item.gljType); } }); } }, addMixRatio:async function () { let me = this, projectGLJ = projectObj.project.projectGLJ; let tdatas = me.mixRatioData; if(me.subList.length > 0) tdatas = me.subList; for(let mix of tdatas){ let m_key = gljOprObj.getIndex(mix, gljKeyArray); let t_index = gljOprObj.GLJSelection.indexOf(m_key); t_index != -1?gljOprObj.GLJSelection.splice(t_index,1):''; } await me.addMixRatioFromLib(gljOprObj.GLJSelection,()=>{ me.showMixRatioData();//这里添加的组成物的消耗量默认都是0,所以对父工料机的价格不会有影响,不用触发计算 projectGLJ.loadData(function () { me.showProjectGljData(); gljOprObj.showRationGLJSheetData(); me.onUnitFileChange(me.selectedProjectGLJ); }); }); }, addMixRatioFromLib:async function(selections,callback){ let gljList = [],allGLJ = gljOprObj.AllRecode; let url = "/glj/add-ratio"; let result = null; if(selections.length == 0) { return; } try { for(let glj of allGLJ){ let i_key = gljUtil.getIndex(glj,gljLibKeyArray); if(_.includes(selections,i_key)){ let pglj = { glj_id: glj.ID, name: glj.name, code: glj.code, original_code: glj.code, unit: glj.unit, specs: glj.specs, base_price: glj.basePrice, market_price: glj.basePrice, shortName: glj.shortName, type: glj.gljType, model:glj.model, adjCoe: glj.adjCoe, from:'std', repositoryId:glj.repositoryId, materialType:glj.materialType, materialCoe:glj.materialCoe, grossWeightCoe:glj.grossWeightCoe, purchaseStorageRate:glj.purchaseStorageRate, offSiteTransportLossRate:glj.offSiteTransportLossRate, handlingLossRate:glj.handlingLossRate }; if(typeof projectObj !== 'undefined') pglj.project_id = projectObj.project.ID(); if (glj.hasOwnProperty("compilationId")) { pglj.from = "cpt"; if (glj.code.indexOf('-') != -1) {//这条工料机是用户通过修改名称、规格、型号等保存到补充工料机库的 pglj.original_code = glj.code.split('-')[0];//取-前的编号作为原始编号 } } gljList.push(pglj); } } gljList = _.sortByAll(gljList, ['type', 'code']); if(gljList.length == 0) return; let parentInfo ={}; if(typeof unitPriceObj !== 'undefined'){ url = "/unitPrice/addMixRatio"; pdata = unitPriceObj.getSelectedUnitPrice(); parentInfo = { unit_price_file_id:pdata.unit_price_file_id, connect_key:gljUtil.getIndex(pdata) }; }else{ parentInfo = { unit_price_file_id:projectObj.project.property.unitPriceFile.id, connect_key:gljOprObj.getIndex(projectGljObject.selectedProjectGLJ,gljKeyArray) }; } $.bootstrapLoading.start(); result= await ajaxPost(url,{gljList:gljList,parentInfo:parentInfo}) if(callback) callback(result); } catch (error) { alert(error); console.log(error); } $.bootstrapLoading.end(); return result; }, showMixRatioData:function () { let me = this,gljId = null,gljType = null; if(!$('#mixRatio-nav').hasClass('active')) return; me.mixRatioSpread.setActiveSheetIndex(0); if(!me.projectGljSpread) return; 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||sel.row == ""?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 ratioList =[]; for(let glj of data){ ratioList.push(me.getMixRatioSheetData(glj)) ; } ratioList = gljUtil.sortRationGLJ(ratioList); me.mixRatioData = ratioList; 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); }) }, showRelatedRationDatas:function(){ let me = this; if(!$('#ration-nav').hasClass('active')) return; me.mixRatioSpread.setActiveSheetIndex(1); let projectGLJData = me.getProjectGLJSelected(); let rationIDMap = {}; let rations = []; if(projectGLJData){ for(let rg of projectObj.project.ration_glj.datas){ if(rg.projectGLJID == projectGLJData.id) rationIDMap[rg.rationID] = true; } for(let r of projectObj.project.Ration.datas){ if(rationIDMap[r.ID] || (r.type == rationType.gljRation && r.projectGLJID== projectGLJData.id)){ rations.push(r); } } } this.relatedRationSheetData = rations; sheetCommonObj.showData(me.relatedRationSheet, me.relatedRationSetting,rations); me.relatedRationSheet.setRowCount(rations.length); }, showInforPriceData:function(datas){ let me = this; me.infoPriceData = datas; sheetCommonObj.showData(me.infoPriceSheet, me.infoPriceSetting,datas); me.infoPriceSheet.setRowCount(datas.length); }, 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, connect_key:glj.ratio_data.connect_key }; 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,isPaste=false) {//return false表示不能编辑 let me = projectGljObject; let data = null, setting=null; let sheet = me.projectGljSpread.getActiveSheet(); if(sheet.name() == 'projectGljSheet'){ if(row>=me.projectGljSheetData.length) return false; data = me.projectGljSheetData[row]; setting = me.projectGljSetting; }else if(sheet.name() == 'materialTreeSheet'){ data = me.materialTree.selected.data; setting = me.materialSetting; let notEditId= ['GC','GJ','MC','SN','SZ']; if(notEditId.indexOf(data.id)!= -1){ return false; } } let dataCode = setting.header[col].dataCode; let lockColumns = setting.view.lockColumns; if(lockColumns.indexOf(col)!= -1) return false; if(isPaste == false &&(dataCode=='is_adjust_price'||dataCode=='is_evaluate'||dataCode=='is_main_material'||dataCode == 'is_eval_material'||dataCode=='no_tax_eqp')){//除了粘贴,拖动填充等操作,其它的都不能编辑 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' && data.supply != 1) return false;// 如果为部分甲供则甲供数量需要可编辑,其它的都不能编辑 if(dataCode == 'materialCoe') {//三材类别为空时,三材系数应只读,不允许输入。 if (data.materialType == undefined || data.materialType == null || data.materialType == '') return false; } if(dataCode == 'taxRate') { //普通材料、商品混凝土、商品砂浆、机械组成物、主材、设备才能编辑 if(!_.includes([gljType.GENERAL_MATERIAL,gljType.COMMERCIAL_CONCRETE,gljType.COMMERCIAL_MORTAR,gljType.MACHINE_COMPOSITION,gljType.MAIN_MATERIAL,gljType.EQUIPMENT],data.type)){ return false } } return true; }, onSelectionChange:function (){ let me = projectGljObject; me.showMixRatioData(); me.materialTreeSheet.repaint(); }, onRelatedRationDoubleClick:function (sender,args) { let me = projectGljObject; let record = me.relatedRationSheetData[args.row]; $("#tab_zaojiashu").click(); locateObject.locateNode(record.ID); }, onInfoPriceDoubleClick:function name(sender,args) { projectGljObject.preApplyInfoPrice(args.row); }, onProjectGljSelectionChange:function (sender, args) { let me = projectGljObject; let newSel = args.newSelections[0]; let oldSel = args.oldSelections?args.oldSelections[0]:{}; me.projectGljSheet.suspendPaint(); me.projectGljSheet.suspendEvent(); if(newSel.row != oldSel.row){ let style = gljOprObj.getSelStyle(true,{}); me.projectGljSheet.setStyle(newSel.row, -1, style); let orow = oldSel.row==''||oldSel.row==-1?0:oldSel.row; if(me.projectGljSheetData[orow]){ style = gljOprObj.getSelStyle(false,{},me.projectGljSheetData[orow].bgColour); }else{ style.backColor = "White"; } me.projectGljSheet.setStyle(orow, -1, style); me.projectGljRowChang(); }else{ me.projectGljSheet.repaint(); } me.projectGljSheet.resumeEvent(); me.projectGljSheet.resumePaint(); }, projectGljRowChang:function(row){ let me = projectGljObject; let sel = me.mixRatioSheet.getSelections()[0]; sel.row = -1; sel.col = 0; sel.rowCount = 1; sel.colCount = 1; me.showMixRatioData(); me.showRelatedRationDatas(); }, rightClickCallback:function (row) { let me = projectGljObject; let sheet = me.projectGljSpread.getActiveSheet(); if(sheet.name() == 'projectGljSheet'){ me.projectGljRowChang(row); }else if(sheet.name() == 'materialTreeSheet'){ me.materialTreeController.setTreeSelected(me.materialTreeController.tree.items[row]); } }, onProjectGljRangeChange:function (sender,info) { let me = projectGljObject; let changeInfo=[]; let canChange = true; if(info.action == GC.Spread.Sheets.RangeChangedAction.clear){ if(me.projectGljEditChecking(info.row,info.col) == false){ canChange = false; }else { 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,true)==false){//如果不能编辑 canChange = false; break; } if (!me.checkData(c.col,me.projectGljSetting,value)) { alert('输入的数据类型不对,请重新输入!'); canChange = false; break; } } if(canChange == false){//恢复原来的值 info.sheetName =="materialTreeSheet"?me.showMaterialTreeData():me.showProjectGljData(); }else if(info.sheetName =="projectGljSheet"){ me.batchUpdateProjectGLJ(changeInfo,info.sheetName); } }, onMixRatioRangeChange:function (sender,info){ let me = projectGljObject; let canChange = true; let changeInfo=[]; /* if (info.action == GC.Spread.Sheets.RangeChangedAction.clear) { info.newValue = 0; me.onMixRatioValueChange(sender,info); info.sheet.getCell(info.row, info.col).text(0); return ; } */ for(let c of info.changedCells){ let value = info.sheet.getCell(c.row, c.col).text(); if(_.isEmpty(value)) value = 0; if (!me.checkData(c.col,me.mixRatioSetting,value)) { alert('输入的数据类型不对,请重新输入!'); canChange = false; break; }else { changeInfo.push({row:c.row,col:c.col,value:value}); } } if(canChange == false) me.showMixRatioData(); //数据类型不对 if(changeInfo.length > 0) me.batchUpdateConsumption(changeInfo); }, batchUpdateProjectGLJ:function(changeInfo,sheetName){ let projectGLJ = projectObj.project.projectGLJ; let me = projectGljObject; let propertyCells=[],priceCells=[]; let setting = sheetName =="materialTreeSheet"?me.materialSetting:me.projectGljSetting; for(let c of changeInfo){ c.dataCode = setting.header[c.col].dataCode; if(c.dataCode == 'basePrice'||c.dataCode=='marketPrice'){ priceCells.push(c); }else { propertyCells.push(c); } } me.batchUpdateGLJProperty(propertyCells,sheetName,function () { //价格属于单价文件表,如果与项目工料机的其它属性一起的话计算起来会比较复杂,同时出现价格与其它属性一起更新的情况也会比较少; projectGLJ.batchUpdatePrice(priceCells,sheetName); //me.refreshBySheetName(sheetName); 2020-07-27 改在projectGLJ里统一刷新了 //gljOprObj.refreshView(); }); }, refreshBySheetName:function (sheetName) { let me = projectGljObject; if(sheetName =="projectGljSheet"){ me.showProjectGljData(); }else if(sheetName =="materialTreeSheet"){ me.showMaterialTreeData(); } }, batchUpdateGLJProperty:function (changeInfo,sheetName,callback) { let me = projectGljObject,updateMap = {}; let projectGLJ = projectObj.project.projectGLJ; for(let c of changeInfo){ if(c.dataCode == 'is_evaluate') continue; //暂估,暂时跳过 let recode = sheetName =="materialTreeSheet"?me.materialTree.items[c.row].data:me.projectGljSheetData[c.row]; if(recode[c.dataCode] == c.value){ continue; } me.getUpdateData(recode.id,c.value,c.dataCode,recode.quantity,updateMap); } if(_.isEmpty(updateMap)){ callback?callback():''; return; } projectGLJ.batchUpdateGLJProperty(updateMap,callback); }, getUpdateData :function (id,value,dataCode,quantity,updateMap) { let me = projectGljObject; let supplyMap = {"自行采购":0,"部分甲供":1,"完全甲供":2,"甲定乙供":3}; let materialMap = {"钢材":1,"钢筋":2,"木材":3,"水泥":4,"商品砼":5,"商品砂浆":6}; let data = updateMap[id]?updateMap[id]:{}; //供货方式 和三材类型 粘贴和填充过来的数据,要做对应转换,因为这里value只是中文文本,并不是实际的值 // 如果是供货方式则需要处理数据 if (dataCode === 'supply') { if(supplyMap[value]!==undefined||supplyMap[value]!==null){ value = supplyMap[value]; } data.supply_quantity = me.getSupplyQuantity(value,quantity); } if(dataCode === 'supply_quantity'){//修改数量需做4舍5入 value = scMathUtil.roundForObj(value,getDecimal('glj.quantity')); } if(dataCode === 'is_evaluate'||dataCode === 'is_adjust_price'||dataCode === 'is_main_material'){ value = value? 1:0; } if(dataCode === 'materialType'){//三材类型要做对应转换,因为这里value只是中文文本,并不是实际的值 if(materialMap[value]!==undefined||materialMap[value]!==null){ value = materialMap[value]; } if(value == null || value==""){//删除三材类别时,清空三材系数 value = null; data.materialCoe = null; } } if(dataCode == 'materialCoe'){ value = scMathUtil.roundForObj(value,getDecimal("material")); } data[dataCode] = value ; updateMap[id] = data; }, batchUpdateConsumption:function(changeInfo){ let projectGLJ = projectObj.project.projectGLJ; let me = projectGljObject; let updateMap = {},updateData = [],parentBasePrice = 0,parentMarketPrice = 0; let parentKey = '',unit_price_file_id=null; for(let c of changeInfo){ let record = me.mixRatioData[c.row]; let value = scMathUtil.roundForObj(c.value,getDecimal("glj.quantity")); updateMap[record.mix_ratio_id] = {consumption: value,record:record }; updateData.push({type:'mix_ratio',query:{id:record.mix_ratio_id},doc:{consumption:value}}); parentKey = record.connect_key; unit_price_file_id = record.unit_price.unit_price_file_id; } for(let sub of me.mixRatioData){ let marketPrice = scMathUtil.roundForObj(sub.unit_price.market_price,getDecimal("process")); let basePrice = scMathUtil.roundForObj(sub.unit_price.base_price,getDecimal("process")); let consumption = updateMap[sub.mix_ratio_id]?updateMap[sub.mix_ratio_id].consumption:scMathUtil.roundForObj(sub.consumption,getDecimal("glj.quantity")); parentMarketPrice = scMathUtil.roundForObj(marketPrice*consumption + parentMarketPrice,getDecimal("process")); parentBasePrice = scMathUtil.roundForObj(basePrice*consumption + parentBasePrice,getDecimal("process")); } parentBasePrice = scMathUtil.roundForObj(parentBasePrice,getDecimal("glj.unitPrice")); parentMarketPrice = scMathUtil.roundForObj(parentMarketPrice,getDecimal("glj.unitPrice")); updateData.push({type:'parent',connect_key:parentKey,base_price:parentBasePrice,market_price:parentMarketPrice,unit_price_file_id:unit_price_file_id}); projectGLJ.batchUpdateConsumption(updateData,updateMap,function () { //更新人材机汇总表 let parentSheet = me.projectGljSpread.getActiveSheet();//三材汇总表和工料机汇总表 let prow = parentSheet.getActiveRowIndex();//取父机械或组成物的下标 let prowData = parentSheet.name() == 'projectGljSheet'?me.projectGljSheetData[prow]:me.materialTree.items[prow].data; me.refreshParentData(prow,prowData.id); me.onUnitFileChange(updateData); }); }, showProjectGljData:function () { if(!this.projectGljSpread) return; let me = this; this.projectGljSpread.setActiveSheetIndex(0); let sel = this.projectGljSheet.getSelections()[0]; let oldData = sel.row0){ 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, tenderQuantity:glj.tenderQuantity, 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', techQuantity:glj.techQuantity, subdivisionQuantity:glj.subdivisionQuantity, originPlace:glj.originPlace, vender:glj.vender, qualityGrace:glj.qualityGrace, brand:glj.brand, unitPriceID:glj.unit_price.id, priceFrom:glj.unit_price.priceFrom, remark:glj.remark }; 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 (materialIdList.indexOf(glj.type) >= 0||glj.type == gljType.MAIN_MATERIAL || glj.type == gljType.EQUIPMENT) data.is_eval_material = glj.is_eval_material ? glj.is_eval_material : 0; //类型是“设备”时有效 if(glj.type == gljType.EQUIPMENT) data.no_tax_eqp = glj.no_tax_eqp?glj.no_tax_eqp:0; 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 (gljUtil.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.showRelatedRationDatas(); } //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")); me.batchUpdateConsumption([{row:row,col:col,value}]); }, 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 = _.find(); //me.projectGljSheetData[row]; }else { me.showMaterialTreeData(); //parantData = me.materialTree.items[row].data; } let pglj = _.find(projectObj.project.projectGLJ.datas.gljList,{'id':pid}); parantData = pglj?me.getSheetDataByGLJ(pglj):null; //projectObj.project.projectGLJ.datas.gljList // 更新组成物缓存 projectObj.project.composition.loadData(); me.updateParentNodes(pid,parantData.marketPrice,sid); }, updateParentNodes:function(pid,marketPrice,sid){ //先查找使用了父项目工料机的定额工料机 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 = marketPrice;//parentMarketPrice;//这里用显示的价格 updateNodes.push(r_node); } } if(sid){ let subRations = calcTools.getRationsByProjectGLJ(sid); updateNodes = updateNodes.concat(subRations); } if(updateNodes.length>0){ projectObj.project.calcProgram.calcNodesAndSave(updateNodes,async function () { projectObj.mainController.refreshTreeNode(projectObj.project.mainTree.roots); installationFeeObj.calcInstallationFee();//计算安装增加费 await OVER_HEIGHT.reCalcOverHeightFee(); await itemIncreaseFeeObj.calcItemIncreaseFeeByNodes(updateNodes); }); } gljOprObj.refreshView(); }, onUnitFileChange:function (data) { projectObj.project.markUpdateProject({projectID:projectObj.project.ID(),'unitFileID':socketObject.getUnitFileRoomID()},"unitFile",function(){ //socket.emit('unitFileChangeNotify', JSON.stringify(data)); socket.emit('unitFileChangeNotify', {projectID:projectObj.project.ID(),userID:userID,'unitFileID':socketObject.getUnitFileRoomID()}); }); }, 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 () { _.remove(me.mixRatioData,{"mix_ratio_id":deleteRecode.mix_ratio_id}); me.refreshParentData(prow,prowData.id); me.mixRatioSheet.deleteRows(row,1); me.onUnitFileChange(deleteRecode); }); }, 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.market_price; 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)) { alert('输入的数据类型不对,请重新输入!'); 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); }); } }; if(dataCode=='basePrice'||dataCode=='marketPrice'){//修改市场价和修改定额价时需要重新记算很多受影响的树节点,现在改成与定字额工料机那里调相同的方法。 let editField = dataCode === 'basePrice'?"base_price":"market_price"; projectObj.project.projectGLJ.updatePrice(recode,editField,value,'pg',null,callback); }else { let extend = {}; // 如果是供货方式则需要处理数据 if (dataCode === 'supply') { extend.supply_quantity = me.getSupplyQuantity(value, recode.quantity); } if(dataCode === 'supply_quantity'){//修改数量需做4舍5入 value= scMathUtil.roundForObj(value,getDecimal('glj.quantity')); } if(dataCode === 'is_evaluate'||dataCode === 'is_adjust_price'||dataCode === 'is_main_material'||dataCode === 'no_tax_eqp'||dataCode == 'is_eval_material'){ value = value == true?1:0; if(dataCode === 'is_evaluate'|| dataCode == 'is_eval_material'){ configMaterialObj.updateConfigMaterial(dataCode,value,recode);//暂估材料,主要材料等新需求 return } } if(dataCode === 'materialType' && (value == null || value=="")){//删除三材类别时,清空三材系数 value = null; extend.materialCoe = null; } if(dataCode == 'materialCoe'){ value = scMathUtil.roundForObj(value,getDecimal("material")); } if(dataCode == 'taxRate') value = scMathUtil.roundToString(value,2); extend = Object.keys(extend).length > 0 ? JSON.stringify(extend) : ''; if(recode[dataCode] == value) return; 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; }, getSupplyQuantityByGlj:function (glj, tender) { //{"自行采购":0,"部分甲供":1,"完全甲供":2,"甲定乙供":3}; let supply_quantity = glj.supply_quantity; switch (glj.supply){ case 0: supply_quantity = 0; break; case 1: break; case 2: supply_quantity = tender ? glj.tenderQuantity : glj.quantity; break; case 3: supply_quantity = 0; break; } return supply_quantity }, checkData : function(col,setting, value) { return sheetCommonObj.checkData(col,setting, value); }, getProjectGLJSelected:function () { let me = this,data = null; let sheet = me.projectGljSpread.getActiveSheet(); if(sheet.name() == 'projectGljSheet'){//projectGljSheet/materialSheet 工料机汇总和三材汇总表 let sel = me.projectGljSheet.getSelections()[0]; let srow = sel.row == -1||sel.row == ""?0:sel.row; if(me.projectGljSheetData.length>srow){ data = me.projectGljSheetData[srow]; } }else if(sheet.name() == 'materialTreeSheet'){ if(this.materialTree.selected){ data = this.materialTree.selected.data; } } return data; }, initInfoPriceRightClick:function(){ let me = this; $.contextMenu({ selector: '#info_price_sheet', build: function ($trigger, e) { me.rightClickTarget = SheetDataHelper.safeRightClickSelection($trigger, e, me.infoPriceSpread); return me.rightClickTarget.hitTestType === GC.Spread.Sheets.SheetArea.viewport || me.rightClickTarget.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader; }, items: { "apply": { name: "确认套用(或双快速套用)", icon: 'fa-sign-in', disabled: function () { return me.rightClickTarget.row === undefined; }, callback: function (key, opt) { let row = me.rightClickTarget.row; me.preApplyInfoPrice(row); } } } }); }, 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); }, visible: function(key, opt){ if(!$('#mixRatio-nav').hasClass('active')) return false; return true; } }, "addMixRatio":{ name: '添加', icon: 'fa-sign-in', disabled: function () { let projectGLJ = projectGljObject.getProjectGLJSelected(); return !_.includes(compositionTypes,projectGLJ.type); }, callback: function (key, opt) { me.selectedProjectGLJ = projectGljObject.getProjectGLJSelected(); getGLJData('addMix', null, true, null); }, visible: function(key, opt){ if(!$('#mixRatio-nav').hasClass('active')) return false; return true; } } } }); }, changeFileCallback:function(){ projectGljObject.unitPriceFileInit(); projectGljObject.refreshViewsData(); gljOprObj.refreshView(); projectObj.project.calcProgram.calcAllNodesAndSave(calcAllType.catAll,function () { if(socketObject.roomInfo){ let data ={ projectID:projectObj.project.ID(), oldRoom:socketObject.roomInfo.unitFile, newRoom:socketObject.getUnitFileRoomID(), userID:userID, 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); }); } } }, checkUnitFileName:function (name,callback) { let projectGLJ = projectObj.project.projectGLJ; projectGLJ.checkUnitFileName(name,function (data) { if(data){ $("#save-as-tips").text('已存在同名单价文件').show(); $('#save-as-confirm').attr("disabled","disabled"); }else { $("#save-as-tips").hide(); $('#save-as-confirm').removeAttr("disabled"); if(callback) callback(); } }); }, initFilterTypeList:function () {//初始化人材机汇总工料机类型过滤列表 let htmlString = ' '; $('#ALL').after(htmlString); }, getInfoPriceOptions:async function(){ let options =await ajaxPost("/infoPrice/getOptions",{}); this.infoPriceOptions=options; this.createSelectOptions($("#info_area"),options.areas,true); let years = _.keysIn(options.periodMap); this.createSelectOptions($("#info_year"),_.sortBy(years)); }, createSelectOptions:function(ele,opts,isArea){ ele.empty(); let str = ``; for(let o of opts){ if(isArea == true){ str +=`` }else{ str +=`` } } ele.html(str); }, onInfoTopRowChanged:function(sender, args){ let me = projectGljObject; const bottomRow = args.sheet.getViewportBottomRow(1); if(me.infoPriceData >= me.infoPriceTotalSize) return; if(me.infoPriceData.length - bottomRow < 20 ){ if(projectGljObject.infoPriceLastLoadingRow == me.infoPriceData.length){//如果最后一行已经加载过了,就不用再加载了,不然会重复加载 return; } console.log(bottomRow); me.infoPriceLastLoadingRow = me.infoPriceData.length; me.searchInfoPrice(me.infoPriceData[me.infoPriceData.length - 1]._id) } }, searchInfoPrice:async function(objectID){ let year = $('#info_year').val(); let month = $('#info_month').val(); let areaID = $('#info_area').val(); let keyWord = $('#info_search_name').val(); let me = projectGljObject; try { if(year !="" && month!="" && areaID!="") { let condition = { period:year+"-"+month, areaID:areaID } let data ={condition:condition}; if(keyWord !="") data.keyWord = keyWord; if(objectID) data.lastID = objectID; let result = await ajaxPost("/infoPrice/getDataByCondition",data); if(objectID){//分页查询 sheetCommonObj.appendData(me.infoPriceSheet, me.infoPriceData.length, 0, me.infoPriceSetting, result.items); me.infoPriceData.splice(me.infoPriceData.length, 0, ...result.items); }else{ me.infoPriceTotalSize = result.totalSize; me.infoPriceLastLoadingRow = 0; me.showInforPriceData(result.items); } } } catch (error) { console.log(error) } }, preApplyInfoPrice:function (row) { let info = this.infoPriceData[row]; let projectGLJData = this.getProjectGLJSelected(); if (projectGLJData.ratio_data && projectGLJData.ratio_data.length > 0) return ; let marketPrice = this.getInfoMarketPrice(info); if(projectGLJData.unit == info.unit){ this.applyInfoPrice(projectGLJData,marketPrice,1); }else if(_.includes(["t","kg"],projectGLJData.unit)&&_.includes(["t","kg"],info.unit)){ //遇到t和kg之间的转换,默认处理:1t=1000kg,不弹换算窗口 let coeMap={"t":1,"kg":1000}; let coe = coeMap[info.unit]/coeMap[projectGLJData.unit]; this.applyInfoPrice(projectGLJData,marketPrice,coe); }else{//弹出单位转换窗口 $("#infoRow").val(row); $("#applyGLJName").text(projectGLJData.name); $("#applyGLJUnit").text(projectGLJData.unit); $("#infoPriceCoe").val(""); $("#applyInfoUnit").text(info.unit); $("#infoPriceCoeDiv").modal('show') } }, applyInfoPrice:function (projectGLJData,price,coe) { let priceFrom= me.getPriceFrom(); projectObj.project.projectGLJ.updatePrice(projectGLJData,"market_price",price*coe,'pg',{"priceFrom":priceFrom}); }, getPriceFrom:function(){ let area = ""; for(let o of this.infoPriceOptions.areas){ if(o.ID == $("#info_area").val()){ area = o.name; break; } } return `${area}信息价(${$("#info_year").val()}${$("#info_month").val()})`; }, getInfoMarketPrice:function (info) { let taxType = projectObj.project.property.taxType;//1: 一般计税 2: 简易计税 return gljUtil.getInfoMarketPrice(info,taxType); } }; function getProjectResizeEles() { let pojGljResizeEles = {}; pojGljResizeEles.eleObj = { module: 'projectGlj', resize: $('#projectGljResize'), top: $('#projectGljTop'), topSpread: $('#project_glj_sheet'), bottom: $('#projectGljBottom'), bottomSpread: $('#mix_ratio_sheet') }; pojGljResizeEles.limit = { min: 150, max: `$(window).height()-$('.header').height()-$('#projectGljToolsBar').height()-150-5`,//5: resize.height() notTopSpread: 0, notBottomSpread: 0, totalHeight: `$(window).height()-$('.header').height()-$('#projectGljToolsBar').height()-5` }; return pojGljResizeEles; } function getConficMaterialResizeEles() { let conficMaterialResizeEles = {}; conficMaterialResizeEles.eleObj = { module: 'conficMaterial', resize: $('#configMaterialResize'), top: $('#configMaterialTop'), topSpread: $('#config_material_sheet'), bottom: $('#configMaterialBottom'), bottomSpread: $('#related_sheet') }; conficMaterialResizeEles.limit = { min: 150, max: `$(window).height()-$('.header').height()-$('#projectGljToolsBar').height()-150-5`,//5: resize.height() notTopSpread: 0, notBottomSpread: 0, totalHeight: `$(window).height()-$('.header').height()-$('#projectGljToolsBar').height()-5`, bottomNav:`$('#configMaterialBottom ul').height() + $('#filterToolDiv').height()+10` }; return conficMaterialResizeEles; } function loadProjectGljSize() { if($('#project-glj-main').is(':visible')){ let me = projectGljObject; let pojGljResizeEles = getProjectResizeEles(); if(!$("#projectGljBottom").is(':visible')){ let total = $(window).height()-$('.header').height()-$('#projectGljToolsBar').height()+3; $("#projectGljTop").height(total); $("#project_glj_sheet").height(total); me.projectGljSpread?me.projectGljSpread.refresh():''; }else{ SlideResize.loadVerticalHeight(pojGljResizeEles.eleObj.module, pojGljResizeEles.eleObj, pojGljResizeEles.limit, function () { me.projectGljSpread?me.projectGljSpread.refresh():''; me.mixRatioSpread?me.mixRatioSpread.refresh():''; //信息价相关 $('#info_price_sheet').height($("#mix_ratio_sheet").height() - $("#infoToolDiv").height()); if($('#info_price_sheet').is(':visible')) me.initInfoPriceSpread(); }); } }else if($('#material_adjust').is(':visible')){ $('#material_adjust_sheet').height($(window).height()-$('.header').height()-$('#projectGljToolsBar').height()+3); if(materialAdjustObj.spread)materialAdjustObj.spread.refresh(); }else if($('#config_material').is(':visible')){ let configMaterialResizeEles = getConficMaterialResizeEles(); SlideResize.loadVerticalHeight(configMaterialResizeEles.eleObj.module, configMaterialResizeEles.eleObj, configMaterialResizeEles.limit, function () { configMaterialObj.configSpread? configMaterialObj.configSpread.refresh():''; configMaterialObj.relatedSpread? configMaterialObj.relatedSpread.refresh():''; /* me.mixRatioSpread?me.mixRatioSpread.refresh():'';*/ }); } } //从其他建设项目中复制中,建设项目的文件层次结构名称和顺序 function getFileHierarchyInfo(treeData){ let tree = idTree.createNew({id: 'ID', pid: 'ParentID', nid: 'NextSiblingID', rootId: -1}); tree.loadDatas(treeData); let items = tree.items; let rst = []; function getFileHierarchyName(node){ let nodeName = node.data.name; let name = []; while (node.parent){ name.push(node.parent.data.name ? node.parent.data.name : ''); node = node.parent; } name = name.reverse(); name.push(nodeName); return name.join('\\'); } for(let node of items){ if(node.children.length === 0 ){//project rst.push({ID: node.data.ID, fileHierarchyName: getFileHierarchyName(node)}) } } return rst; } $(function () { let pojGljResizeEles = getProjectResizeEles(); SlideResize.verticalSlide(pojGljResizeEles.eleObj, pojGljResizeEles.limit, function () { projectGljObject.projectGljSpread.refresh(); projectGljObject.mixRatioSpread?projectGljObject.mixRatioSpread.refresh():''; }); let tr = getConficMaterialResizeEles(); SlideResize.verticalSlide(tr.eleObj, tr.limit, function(){ configMaterialObj.configSpread? configMaterialObj.configSpread.refresh():''; configMaterialObj.relatedSpread? configMaterialObj.relatedSpread.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.initSpreads(); } me.unitPriceFileInit(); me.initMixRatio(); me.initSheetViews(); //projectObj.project.projectGLJ.calcQuantity(); 在工程量有更新的地方调用 me.refreshViewsData(); loadProjectGljSize(); }); /* $('#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').tooltip({ placement: "bottom", html: true, trigger: "hover | focus", title: projectGljObject.getUsedTenderInfo } ); // 单价文件切换弹框 $('#change-unitFile').on('shown.bs.modal', function () { let rootProjectID = projectObj.project.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; projectGljObject.changeInfo = 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); } // 其他建设项目数据 let newDataOther = []; if (data.other.length > 0) { //转换成按项目管理顺序,名称包含文件夹层次 let fileHierarchyDatas = getFileHierarchyInfo(data.treeData); for(let fileHierarchyData of fileHierarchyDatas){ let projData = _.find(data.other, {ID: fileHierarchyData.ID}); if(projData){ projData.name = fileHierarchyData.fileHierarchyName; newDataOther.push(projData); } } data.other = newDataOther; 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; $('#change-unitFile').modal("hide"); if (type === 0) { // 从本项目中选择 changeUnitPriceId = $("#self-file").val(); if(!changeUnitPriceId){ alert('单价文件不可为空'); return; } submitFileChange(changeUnitPriceId,type); } else { // 从其他项目中复制 changeUnitPriceId = $("#other-file").val(); let newName = $("#other-file").children("option:selected").text(); projectObj.project.projectGLJ.checkUnitFileName(newName,function (need_rename) { if(need_rename){ $("#rename-unitFile").modal({show:true}); $("#newUnitFileID").val(changeUnitPriceId); $("#newUnitFileName").val(newName); }else { submitFileChange(changeUnitPriceId,type); } }); } function submitFileChange(changeUnitPriceId,type) { 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 + '副本'); projectGljObject.checkUnitFileName(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-name').change(function () { projectGljObject.checkUnitFileName(this.value); }); $('#newUnitFileName').change(function () { let projectGLJ = projectObj.project.projectGLJ; projectGLJ.checkUnitFileName(this.value,function (data) { if(data){ $("#renameError_unitFile").text('已存在同名单价文件').show(); //$('#renameUnitFileConfirm').attr("disabled","disabled"); }else { $("#renameError_unitFile").hide(); // $('#renameUnitFileConfirm').removeAttr("disabled"); } }); }); $("#renameUnitFileConfirm").click(function () { let projectGLJ = projectObj.project.projectGLJ; let newName = $('#newUnitFileName').val(); let changeUnitPriceId = $('#newUnitFileID').val(); projectGLJ.checkUnitFileName(newName,function (data) { if(data){ $("#renameError_unitFile").text('已存在同名单价文件').show(); //$('#renameUnitFileConfirm').attr("disabled","disabled"); }else { $("#renameError_unitFile").hide(); $('#rename-unitFile').modal('hide'); // $('#renameUnitFileConfirm').removeAttr("disabled"); let data = {project_id: scUrlUtil.GetQueryString('project'), change_id: changeUnitPriceId, type: 1,newName:newName}; projectObj.project.projectGLJ.changeFile(data,function () { projectGljObject.changeFileCallback(); }) } }); }); // 单价文件另存为操作 $("#save-as-confirm").click(function () { let projectGLJ = projectObj.project.projectGLJ; let name = $("#save-as-name").val(); if (name === '') { $("#save-as-tips").text('请填写单价文件名称').show(); return false; } let saveData = {name: name, project_id: scUrlUtil.GetQueryString('project')}; projectGljObject.checkUnitFileName(name,function () { projectGLJ.saveAs(saveData,function () { projectGljObject.changeFileCallback(); $("#unitFile-save-as").modal("hide"); }); }); }); $("#filterType").on("click","ul li a",function(e){ let children = $('#filterType a'); for(let c of children){ $(c).removeClass('active'); } $(this).addClass('active'); let me = projectGljObject; me.displayType = filterType[this.id]; me.initSheetViews(); me.refreshViewsData(); loadProjectGljSize(); }); $("#mixRatio-nav").on('shown.bs.tab', function () { projectGljObject.mixRatioSpread.refresh(); projectGljObject.showMixRatioData(); }); $("#ration-nav").on('shown.bs.tab', function () { projectGljObject.mixRatioSpread.refresh(); projectGljObject.showRelatedRationDatas(); }); $("#info-nav").on('shown.bs.tab', function () { $('#info_price_sheet').height($("#mix_ratio_sheet").height() - $("#infoToolDiv").height()); projectGljObject.initInfoPriceSpread(); /* projectGljObject.showRelatedRationDatas(); */ }); $('#info_year').change(function () { let periodMap = projectGljObject.infoPriceOptions.periodMap; let year = $(this).val(); let month = $("#info_month").val(); let options = periodMap[year]; projectGljObject.createSelectOptions($("#info_month"),periodMap[year]); if(month !=""){ if(_.includes(options,month)){ $("#info_month").val(month); projectGljObject.searchInfoPrice(); } } }); $('#info_month').change(function () { projectGljObject.searchInfoPrice(); }); $('#info_area').change(function () { projectGljObject.searchInfoPrice(); }); $('#info_search_name').on('keypress', function (e) { if (e.keyCode === 13) { projectGljObject.searchInfoPrice(); } }); $('#info_search_btn').on('click', function (e) { projectGljObject.searchInfoPrice(); }); $('#infoPriceCoeConfirm').on('click', function (e) { let me = projectGljObject; let infoPriceCoe = $("#infoPriceCoe").val(); if(infoPriceCoe==="") return alert("请输入单位转换值!"); if(!(/^\d+(\.\d+)?$/.test(infoPriceCoe))) return alert("请输入数字!"); $("#infoPriceCoeDiv").modal('hide'); let pojectGLJData = me.getProjectGLJSelected(); let info=me.infoPriceData[parseInt($("#infoRow").val())]; let marketPrice = me.getInfoMarketPrice(info); me.applyInfoPrice(pojectGLJData,marketPrice,parseFloat(infoPriceCoe)); }); $('#muti_apply_info').on('click', function (e) { let year = $('#info_year').val(); let month = $('#info_month').val(); let areaID = $('#info_area').val(); if(year !="" && month!="" && areaID!=""){ $("#mutiApplyInfoPriceDiv").modal("show"); } }); $('#mutiApplyinfoPriceConfirm').on('click', function (e) { let typeMap= {}; let pgljMap = {}; let year = $('#info_year').val(); let month = $('#info_month').val(); let areaID = $('#info_area').val(); for(let e of $(".info_apply_type")){ if($(e).prop('checked') == true){ typeMap[$(e).val()] = true; } } for(let pglj of projectGljObject.projectGljSheetData){ if(pglj.ratio_data && pglj.ratio_data.length > 0) continue; //有组成物时跳过 let typeString = pglj.type +""; if(typeMap[typeString.charAt(0)]){ let index = gljUtil.getIndex(pglj,["name","specs","unit"]); let obj = {pgljID:pglj.id,unitPriceID:pglj.unitPriceID,fullIndex:gljUtil.getIndex(pglj)}; pgljMap[index]?pgljMap[index].push(obj):pgljMap[index]=[obj];//考虑到只用三个去匹配会有重复的工料机,所以这里用数组 } } if(_.isEmpty(pgljMap)) return; let condition = { period:year+"-"+month, areaID:areaID } let priceFrom = projectGljObject.getPriceFrom(); projectObj.project.projectGLJ.mutiApplyInfoPrice(pgljMap,condition,priceFrom); }); });