123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455 |
- /**
- * 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:{},
- 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:[],
- usedTenderList:[],
- usedUnitPriceInfo:null,
- displayTypeMap:[
- {ID:'LABOUR',text:'人工'},
- {ID:'GENERAL_MATERIAL',text:'材料'},
- {ID:'GENERAL_MACHINE',text:'机械'},
- {ID:'MAIN_MATERIAL',text:'主材'},
- {ID:'EQUIPMENT',text:'设备'}
- ],
- 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);
- },
- 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]);
- 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);
- if(projectReadOnly){
- if(this.mixRatioSetting.view.lockColumns){
- this.mixRatioSetting.view.lockColumns = null;
- }
- disableSpread(this.mixRatioSpread);
- }
- },
- 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);
- },
- getUsedTenderInfo:function() {
- return "人材机单价的变化,将自动影响以下单位工程造价:<br>"+projectGljObject.usedTenderList.join("<br>");
- },
- 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:function () {
- let me = this, projectGLJ = projectObj.project.projectGLJ;
- for(let mix of me.mixRatioData){
- let m_key = gljOprObj.getIndex(mix, gljKeyArray);
- let t_index = gljOprObj.GLJSelection.indexOf(m_key);
- t_index != -1?gljOprObj.GLJSelection.splice(t_index,1):'';
- }
- projectGLJ.addMixRatio(gljOprObj.GLJSelection,function (mixRatios) {
- me.showMixRatioData();//这里添加的组成物的消耗量默认都是0,所以对父工料机的价格不会有影响,不用触发计算
- projectGLJ.loadData(function () {
- me.showProjectGljData();
- gljOprObj.showRationGLJSheetData();
- me.onUnitFileChange(me.selectedProjectGLJ);
- });
- });
- },
- 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||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);
- })
- },
- 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'){
- if (data.supply != 1) {// 如果为部分甲供则甲供数量需要可编辑,其它的都不能编辑
- return false;
- }
- }
- if(dataCode == 'materialCoe'){//三材类别为空时,三材系数应只读,不允许输入。
- if(data.materialType == undefined || data.materialType == null||data.materialType==''){
- 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.projectGljRowChang();
- }
- me.projectGljSheet.repaint();
- },
- 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();
- },
- 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 (!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,function (impactList) {
- me.refreshBySheetName(sheetName);
- 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 () {
- this.projectGljSpread.setActiveSheetIndex(0);
- let sel = this.projectGljSheet.getSelections()[0];
- let oldData = sel.row<this.projectGljSheetData.length?this.projectGljSheetData[sel.row]:"";
- 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(this.projectGljSheetData.length);
- sheetCommonObj.showData(this.projectGljSheet, this.projectGljSetting,this.projectGljSheetData);
- //this.projectGljSheet.setRowCount(this.projectGljSheetData.length);
- sel.row = oldData?_.findIndex(this.projectGljSheetData,{'id':oldData.id}):'';
- 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 oldNodeID = this.materialTree.selected?this.materialTree.selected.data.id:"";
- let gljList = projectObj.project.projectGLJ.datas.gljList;
- gljList = _.sortByAll(gljList, [ 'code']);
- this.createMaterialTree(gljList);
- this.materialTreeController.showTreeData();
- let newNode = this.materialTree.getNodeByID(oldNodeID);
- sel.row = newNode?newNode.serialNo():-1;
- 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]);
- },
- initSheetViews:function(){
- let me = projectGljObject;
- /* if(me.displayType == filterType.AMAE){
- $('#material_adjust').show();
- $('#adjustType').show();
- let adjustType = projectObj.project.projectInfo.property.gljAdjustType || 'priceInfo';
- $('#adjustType').val(adjustType);
- $('#project-glj-main').hide();
- $('#config_material').hide();
- }else*/
- if(me.displayType == filterType.AMAE || me.displayType == filterType.ZGCL || me.displayType == filterType.PBCL){
- $('#adjustType').hide();
- if(me.displayType == filterType.AMAE){
- let adjustType = projectObj.project.projectInfo.property.gljAdjustType || 'priceInfo';
- $('#adjustType').val(adjustType);
- $('#adjustType').show();
- }
- configMaterialObj.setNavLinkText(me.displayType);
- $('#material_adjust').hide();
- $('#project-glj-main').hide();
- $('#config_material').show();
- } else {
- $('#material_adjust').hide();
- $('#adjustType').hide();
- $('#config_material').hide();
- $('#project-glj-main').show();
- }
- },
- refreshViewsData:function(){
- let me = projectGljObject;
- if(me.displayType == filterType.AMAE) return materialAdjustObj.refreshSheetDatas();
- if(me.displayType == filterType.ZGCL || me.displayType == filterType.PBCL) return configMaterialObj.refreshSheetDatas();
- me.refreshDataSheet();
- },
- refreshDataSheet:function () {
- let me = projectGljObject;
- let quantityCol = _.findIndex(me.projectGljSetting.header,function (header) {
- return header.dataCode == 'quantity'|| header.dataCode == 'techQuantity' || header.dataCode =='subdivisionQuantity';
- });
- if(me.displayType == filterType.FBFX){//分部分项人材机,将“总消耗量”替换显示为“分部分项总消耗量”。
- me.projectGljSetting.header[quantityCol].dataCode = 'subdivisionQuantity';
- me.projectGljSheet.setValue(0, quantityCol, "分部分项总消耗量", GC.Spread.Sheets.SheetArea.colHeader);
- }else if(me.displayType == filterType.TECH) {//措施项目人材机,将“总消耗量”替换显示为“措施项目总消耗量”。
- me.projectGljSetting.header[quantityCol].dataCode = 'techQuantity';
- me.projectGljSheet.setValue(0, quantityCol, "措施项目总消耗量", GC.Spread.Sheets.SheetArea.colHeader);
- }else {
- me.projectGljSetting.header[quantityCol].dataCode = 'quantity';
- me.projectGljSheet.setValue(0, quantityCol, "总消耗量", GC.Spread.Sheets.SheetArea.colHeader);
- }
- 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:'m3',ParentID:-1,NextSiblingID:'SN'};
- let SN = {id:'SN',name:materialType[materialTypeMap.SN],code:'SN',unit:'t',ParentID:-1,NextSiblingID:'ST'};
- let ST = {id:'ST',name:materialType[materialTypeMap.ST],code:'SPT',unit:'m3',ParentID:-1,NextSiblingID:'SS'};
- let SS= {id:'SS',name:materialType[materialTypeMap.SS],code:'SPJS',unit:'m3',ParentID:-1,NextSiblingID:'-1'};
- let rootDatas= [GC,GJ,MC,SN,ST,SS];
- 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.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,
- 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,
- 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.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);
- }*/
- projectObj.project.projectGLJ.calcQuantity();
- me.refreshParentData(prow,prowData.id,sid);
- me.onUnitFileChange(recode);
- });
- },
- 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();
- //先查找使用了父项目工料机的定额工料机
- 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?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.calcNodesAndSave(updateNodes,function () {
- projectObj.mainController.refreshTreeNode(projectObj.project.mainTree.roots);
- installationFeeObj.calcInstallationFee();//计算安装增加费
- OVER_HEIGHT.reCalcOverHeightFee();
- });
- }
- 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);
- });
- }
- gljOprObj.refreshView();
- };
- if(dataCode=='basePrice'||dataCode=='marketPrice'){//修改市场价和修改定额价时需要重新记算很多受影响的树节点,现在改成与定字额工料机那里调相同的方法。
- 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= 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"));
- }
- 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) {
- //{"自行采购":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 = glj.quantity;
- break;
- case 3:
- supply_quantity = 0;
- break;
- }
- return supply_quantity
- },
- checkData : function(col,setting, value) {
- return sheetCommonObj.checkData(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;*/
- },
- getProjectGLJSelected:function () {
- let me = projectGljObject;
- let sheet = me.projectGljSpread.getActiveSheet();
- let selectedProjectGLJ = null;
- if(sheet.name() == 'projectGljSheet'){//projectGljSheet/materialSheet 工料机汇总和三材汇总表
- let sel = me.projectGljSheet.getSelections()[0];
- if(sel.row != -1 && me.projectGljSheetData.length>sel.row){
- selectedProjectGLJ = me.projectGljSheetData[sel.row]
- }
- }else if(sheet.name() == 'materialTreeSheet' ){
- if(me.materialTree.selected){
- selectedProjectGLJ = me.materialTree.selected.data;
- }
- }
- return selectedProjectGLJ;
- },
- 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);
- }
- },
- "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');
- }
- }
- }
- });
- },
- 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 = ' <ul class="nav flex-column">';
- for(let t of this.displayTypeMap){
- htmlString += '<li class="nav-item "><a class="nav-link pl-4" href="javascript:void(0)" id="'+t.ID+'">'+t.text+'</a></li>';
- }
- htmlString += '</ul>';
- $('#ALL').after(htmlString);
- }
- };
- 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();
- SlideResize.loadVerticalHeight(pojGljResizeEles.eleObj.module, pojGljResizeEles.eleObj, pojGljResizeEles.limit, function () {
- me.projectGljSpread?me.projectGljSpread.refresh():'';
- me.mixRatioSpread?me.mixRatioSpread.refresh():'';
- });
- }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 += '<option' + select + ' value="' + tmp.id + '">' + tmp.name + '</option>';
- }
- $("#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 += '<option value="' + tmp.ID + '">' + tmp.name + '</option>';
- otherFileData[tmp.ID] = tmp.unitPriceList;
- if (otherFileHtml !== '') {
- continue;
- }
- for (let unitPrice of tmp.unitPriceList) {
- otherFileHtml += '<option value="' + unitPrice.id + '">' + unitPrice.name + '</option>';
- }
- }
- $("#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 += '<option value="' + unitPrice.id + '">' + unitPrice.name + '</option>';
- }
- $("#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();
- });
- });
|