/** * Created by Zhong on 2017/8/14. */ $(document).ready(function () { let moduleName = 'stdGLj'; function refreshALlWorkBook() { if (gljClassTreeObj.workBook) { gljClassTreeObj.workBook.refresh(); } if (repositoryGljObj.workBook) { repositoryGljObj.workBook.refresh(); } if (gljComponentOprObj.workBook) { gljComponentOprObj.workBook.refresh(); } } SlideResize.loadHorizonWidth(moduleName, [$('#slideResizeLeft'), $('#slideResizeRight')], [$('#leftContent'), $('#midContent'), $('#rightContent')], function () { refreshALlWorkBook(); }); //章节树与人材机表 let leftElesObj = {}; leftElesObj.module = moduleName; leftElesObj.resize = $('#slideResizeLeft'); leftElesObj.parent = $('#dataRow'); leftElesObj.left = $('#leftContent'); leftElesObj.right = $('#midContent'); SlideResize.horizontalSlide(leftElesObj, {min: 200, max: `$('#dataRow').width() - $('#rightContent').width() - 200`}, function () { refreshALlWorkBook(); }); //人材机表与人材机组成物表 let rightElesObj = {}; rightElesObj.module = moduleName; rightElesObj.resize = $('#slideResizeRight'); rightElesObj.parent = $('#dataRow'); rightElesObj.left = $('#midContent'); rightElesObj.right = $('#rightContent'); SlideResize.horizontalSlide(rightElesObj, {min: 200, max: `$('#dataRow').width() - $('#leftContent').width() - 200`}, function () { refreshALlWorkBook(); }); }); const digital = { basePrice: -2, consumeAmt: -3 }; let pageOprObj = { gljLibName : null, gljLibId: null, initPage : function(container, containerComponent, containerC) { let me = this, gljLibId = getQueryString("gljLibId");//获取定额库参数 me.gljLibId = gljLibId; //生成人材机表格列头 repositoryGljObj.setting.header = repositoryGljObj.initHeaders(priceProperties); //生成列映射 sheetCommonObj.initColMapping(repositoryGljObj, repositoryGljObj.setting.header); //生成单价列下标数组 repositoryGljObj.initPriceCols(priceProperties, repositoryGljObj.colMapping); repositoryGljObj.getGljLib(gljLibId, function () { repositoryGljObj.buildSheet(container); gljComponentOprObj.buildSheet(containerComponent); componentOprObj.buildSheet(containerC); //获得定额库中引用此工料机库中的,所有被定额所套的工料机的ID //repositoryGljObj.getRationGljIds(gljLibId); repositoryGljObj.getGljDistType(function () { repositoryGljObj.currentRepositoryId = parseInt(gljLibId); /* repositoryGljObj.getGljTree(gljLibId, function () { repositoryGljObj.getGljItems(gljLibId); });*/ repositoryGljObj.getGljItems(gljLibId, function () { gljClassTreeObj.getGljClassTree(gljLibId); }) }); }); } }; let repositoryGljObj = { colMapping: null, treeObj : null, workBook: null, gljCurTypeId: -1, currentRepositoryId: -1, currentCache: null, parentNodeIds: {}, gljList: [], //materialType: ['钢材', '木材', '水泥', '钢筋', '标准砖'],//三材类型:钢材1、钢筋101、木材2、水泥3、标准砖4 materialType: {textArr: ['钢材', '钢筋', '木材', '水泥', '标准砖'], comboItems: [{text: '钢材', value: 1}, {text: '钢筋', value: 2},{text: '木材', value: 3},//三材类型:钢材1、钢筋101、木材2、水泥3、标准砖4 {text: '水泥', value: 4}, {text: '标准砖', value: 5}]}, materialTypeIdx: {'1': '钢材', '2': '钢筋', '3': '木材', '4': '水泥', '5': '标准砖'}, machineModel: {textArr: ['特', '大', '中', '小'], comboItems: [{text: '特', value: 1}, {text: '大', value: 2},{text: '中', value: 3}, {text: '小', value: 4}]}, machineModelIdx: {'1': '特', '2': '大', '3': '中', '4': '小'}, distTypeTree: null,//add setting: { owner: "glj", header:[ {headerName:"编码",headerWidth:80,dataCode:"code", dataType: "String", formatter: "@", hAlign: "left", vAlign: "center"}, {headerName:"名称",headerWidth:160,dataCode:"name", dataType: "String", formatter: "@", hAlign: "left", vAlign: "center"}, {headerName:"规格型号",headerWidth:120,dataCode:"specs", dataType: "String", formatter: "@", hAlign: "left", vAlign: "center"}, {headerName:"单位",headerWidth:60,dataCode:"unit", dataType: "String", hAlign: "center", vAlign: "center"}, {headerName:"定额价",headerWidth:80,dataCode:"basePrice", dataType: "Number", formatter: "0.00", hAlign: "right", vAlign: "center"}, {headerName:"类型",headerWidth:90,dataCode:"gljType", dataType: "String", hAlign: "center", vAlign: "center"}, {headerName:"调整系数",headerWidth:60,dataCode:"adjCoe", dataType: "Number", hAlign: "center", vAlign: "center"}, {headerName:"三材类别",headerWidth:90,dataCode:"materialType", dataType: "String", hAlign: "center", vAlign: "center"}, {headerName:"三材系数",headerWidth:60,dataCode:"materialCoe", dataType: "Number", hAlign: "center", vAlign: "center"}, {headerName:"机型",headerWidth:60,dataCode:"model", dataType: "Number", hAlign: "center", vAlign: "center"}, ], view:{ comboBox:[ {row:-1,col:3,rowCount:-1,colCount:1} ], lockedCells:[ ] } }, //根据费用定额的单价属性获取人材机的单价属性 getPriceProperty: function (priceProperties) { let priceProperty = {}; for(let priceProp of priceProperties){ priceProperty[priceProp.price.dataCode] = 0; } return priceProperty; }, //根据单价字段获取消耗量字段 getConsumeAmtField: function (consumeAmtProperties, priceField) { if(!consumeAmtProperties || consumeAmtProperties.length === 0){ return 'consumeAmt'; } for(let consumeAmtProp of consumeAmtProperties){ if(consumeAmtProp.consumeAmt.refPrice === priceField){ return consumeAmtProp.consumeAmt.dataCode; } } return 'consumeAmt'; }, //初始单价相关的列(单价列、单价属性列) initPriceCols: function (priceProperties, colMapping) { let priceCols = [], pricePropertyCols = []; if(!priceProperties || priceProperties.length === 0){ priceCols.push(colMapping.fieldToCol['basePrice']); } for(let priceProp of priceProperties){ pricePropertyCols.push(colMapping.fieldToCol[priceProp.price.dataCode]); priceCols.push(colMapping.fieldToCol[priceProp.price.dataCode]); } this.priceCols = priceCols; this.pricePropertyCols = pricePropertyCols; }, getPriceFields: function () { let rst = []; for(let priceCol of this.priceCols){ rst.push(this.colMapping.colToField[priceCol]); } return rst; }, //获取更新定额价的人材机价格(人材机只有一个单价取basePrice, 人材机有多个单价,取第一个单价) getRationGljPrice: function (glj) { if(glj.priceProperty){ let keys = Object.keys(glj.priceProperty); if(keys.length > 0){ return glj.priceProperty[keys[0]]; } } return glj.basePrice; }, //生成列头(多单价) initHeaders: function (priceProperties) { let headers = [ {headerName:"编码",headerWidth:80,dataCode:"code", dataType: "String", formatter: "@", hAlign: "left", vAlign: "center"}, {headerName:"名称",headerWidth:160,dataCode:"name", dataType: "String", formatter: "@", hAlign: "left", vAlign: "center"}, {headerName:"规格型号",headerWidth:120,dataCode:"specs", dataType: "String", formatter: "@", hAlign: "left", vAlign: "center"}, {headerName:"单位",headerWidth:60,dataCode:"unit", dataType: "String", hAlign: "center", vAlign: "center"}, {headerName:"类型",headerWidth:90,dataCode:"gljType", dataType: "String", hAlign: "center", vAlign: "center"}, ]; //生成单价列 if(!priceProperties || priceProperties.length === 0){ headers.push({headerName:"定额价",headerWidth:80,dataCode:"basePrice", dataType: "Number", formatter: "0.00", hAlign: "right", vAlign: "center"}); } else { for(let priceProp of priceProperties){ let colData = { headerName: priceProp.price.dataName, headerWidth: 100, dataCode: priceProp.price.dataCode, dataType: 'Number', formatter: '0.00', hAlign: 'right', vAlign: 'center' }; headers.push(colData); } } let tailHeaders = [ {headerName:"调整系数",headerWidth:60,dataCode:"adjCoe", dataType: "Number", hAlign: "center", vAlign: "center"}, {headerName:"三材类别",headerWidth:90,dataCode:"materialType", dataType: "String", hAlign: "center", vAlign: "center"}, {headerName:"三材系数",headerWidth:60,dataCode:"materialCoe", dataType: "Number", hAlign: "center", vAlign: "center"}, {headerName:"机型",headerWidth:60,dataCode:"model", dataType: "Number", hAlign: "center", vAlign: "center"} ]; headers = headers.concat(tailHeaders); return headers; }, //工料机单价赋初始值(没有单价属性,则单价字段为basePrice,否则单价字段为单价属性对象中的属性) initPrice: function (glj) { if(!priceProperties || priceProperties.length === 0){ glj.basePrice = glj.basePrice && !isNaN(parseFloat(glj.basePrice)) ? scMathUtil.roundTo(parseFloat(glj.basePrice), -2) : 0; } else { if(!glj.priceProperty){ glj.priceProperty = {}; } for(let priceProp of priceProperties){ let gljPrice = glj['priceProperty'][priceProp.price.dataCode]; gljPrice = gljPrice && !isNaN(parseFloat(gljPrice)) ? scMathUtil.roundTo(parseFloat(gljPrice), -2) : 0; } } }, //人材机单价是否变化 isGljPriceChange: function (glj, newPrice) { //多单价,与人材机单价属性比较 if(typeof newPrice === 'object'){ return !_.isEqual(glj.priceProperty, newPrice); } return !_.isEqual(glj.basePrice, newPrice); }, //粘贴数据含有单价 pasteIncludesPrice: function (pasteObj) { let me = repositoryGljObj; for(let priceCol of me.priceCols){ let priceField = me.colMapping.colToField[priceCol]; if(typeof pasteObj[priceField] !== 'undefined'){ return true; } } return false; }, //获取人材机价格 getPrice: function (glj, col) { let me = repositoryGljObj; if(!priceProperties || priceProperties.length === 0){ return glj.basePrice; } return glj.priceProperty[me.colMapping.colToField[col]]; }, //工料机价格是否相同 priceIsEqual: function (gljA, gljB) { if(!priceProperties || priceProperties.length === 0){ return gljA.basePrice === gljB.basePrice; } return _.isEqual(gljA.priceProperty, gljB.priceProperty); }, setGljPrice: function (glj, newPrice, col) { if(!priceProperties || priceProperties.length === 0){ glj.basePrice = newPrice; } else { glj.priceProperty[this.colMapping.colToField[col]] = newPrice; } }, setUnitCombo: function (sheet, headers) { let me = this; sheet.suspendPaint(); sheet.suspendEvent(); let combo = sheetCommonObj.getDynamicCombo(); combo.items(rationAndGljUnits).itemHeight(10).editable(true); let unitCol = me.colMapping.fieldToCol['unit']; if(unitCol){ sheet.getRange(-1, unitCol, -1, 1).cellType(combo); } sheet.resumePaint(); sheet.resumeEvent(); }, getComboData: function (gljDistType) { let me = this; let distType; let distTypeTree = { prefix : 'gljType', distTypes: {}, comboDatas: [], distTypesArr: [] }; gljDistType.forEach(function (typeData) { let typeObj = { data: typeData, children: [], parent: null }; distTypeTree.distTypes[distTypeTree.prefix + typeData.ID] = typeObj; distTypeTree.distTypesArr.push(typeObj); }); gljDistType.forEach(function (typeData) { distType = distTypeTree.distTypes[distTypeTree.prefix + typeData.ID]; let parent = distTypeTree.distTypes[distTypeTree.prefix + typeData.ParentID]; if(parent){ distType.parent = parent; parent.children.push(distType); } }); distTypeTree.distTypesArr.forEach(function (distTypeObj) { if(allowGljType.includes(distTypeObj.data.ID)){ distTypeTree.comboDatas.push({text: distTypeObj.data.fullName, value: distTypeObj.data.ID}); } }); return distTypeTree; }, getGljDistType: function (callback) { let me = this; $.ajax({ type: 'post', url: "api/getGljDistType", dataType: 'json', success: function (result) { if(!result.error && callback){ me.distTypeTree = me.getComboData(result.data); console.log(me.distTypeTree); callback(); } } }) }, getGljLib: function (libId, callback) { let me = repositoryGljObj; $.ajax({ type: 'post', url: 'api/getGljLib', data: {libId: libId}, dataType: 'json', success: function (result) { if(!result.error){ if(result.data.length > 0){ me.rationLibs = result.data[0].rationLibs; $(".navbar-text").append( "人材机库"+result.data[0].dispName ); pageOprObj.gljLibName = result.data[0].dispName; } callback(); } } }) }, getGljTree: function(gljLibId, callback) { let me = this; $.ajax({ type:"POST", url:"api/getGljTree", data:{"gljLibId": gljLibId}, dataType:"json", cache:false, timeout:20000, success:function(result,textStatus,status){ if(status.status == 200) { zTreeHelper.createTree(result.data, gljSetting, "repositoryTree", me); zTreeHelper.createTree(result.data, componentSetting, "componentTree", componentOprObj); if (result.data && result.data.length > 0) { me.gljCurTypeId = result.data[0].ID; } else { //重新创建库? gljTypeTreeOprObj.addRootNode(); } callback(); } }, error:function(err){ alert(err.responseJSON.error); } }) }, getGljItems: function(repId, callback) { let me = this; $.ajax({ type:"POST", url:"api/getGljItems", data:{"repositoryId": repId}, dataType:"json", cache:false, timeout:20000, success:function(result){ if(!result.error) { me.gljList = result.data; me.workBook.getSheet(0).setRowCount(result.data.length); me.sortGlj(); me.currentGlj = me.gljList.length > 0 ? me.gljList[0] : null;//初始 if(callback){ callback(); } } }, error:function(err){ alert(err.responseJSON.error); } }) }, showGljItems: function(data, type) { let me = repositoryGljObj; if (me.workBook) { let cacheSection = data; me.sortGljDeep(cacheSection); sheetCommonObj.cleanData(me.workBook.getSheet(0), me.setting, -1); sheetsOprObj.showData(me, me.workBook.getSheet(0), me.setting, cacheSection, me.distTypeTree, me.materialTypeIdx, me.machineModelIdx); let gljTypeCol = me.colMapping.fieldToCol['gljType'], materialTypeCol = me.colMapping.fieldToCol['materialType'], modelCol = me.colMapping.fieldToCol['model']; sheetCommonObj.setDynamicCombo(me.workBook.getActiveSheet(), 0, gljTypeCol, me.workBook.getActiveSheet().getRowCount(), me.distTypeTree.comboDatas, 10, 'text'); sheetCommonObj.setDynamicCombo(me.workBook.getActiveSheet(), 0, materialTypeCol, me.workBook.getActiveSheet().getRowCount(), me.materialType.comboItems, false, 'text'); sheetCommonObj.setDynamicCombo(me.workBook.getActiveSheet(), 0, modelCol, me.workBook.getActiveSheet().getRowCount(), me.machineModel.comboItems, false, 'text'); cacheSection = null; let selRow = me.workBook.getActiveSheet().getSelections()[0].row; me.initSel(selRow); } }, bindEnterKey: function () { let me = this; let sheet = me.workBook.getActiveSheet(); me.workBook.commandManager().register("myEnter", function(){ let orgRow = sheet.getActiveRowIndex(); let orgCol = sheet.getActiveColumnIndex(); if(sheet.isEditing()){ sheet.endEdit(); } let codeCol = me.colMapping.fieldToCol['code']; let code = sheet.getValue(orgRow, codeCol); let newRow, newCol; if(!me.currentCache[orgRow] && code !== undefined && code !== null && orgCol !== me.setting.header.length - 1){ newRow = orgRow; newCol = orgCol + 1; sheet.setActiveCell(newRow, newCol); } else{ newRow = orgRow + 1; newCol = me.currentCache[orgRow + 1] ? orgCol : 0; sheet.setActiveCell(newRow, newCol); } //触发事件 me.onLeaveCell({type: 'LeaveCell'}, {sheet: sheet, sheetName: sheet.name(), cancel: false, row: orgRow, col: orgCol}); me.onEnterCell({type: 'EnterCell'}, {sheet: sheet, sheetName: sheet.name(), cancel: false, row: newRow, col: newCol}); let newSels = [{row: newRow, rowCount: 1, col: newCol, colCount: 1}]; let oldSels = [{row: orgRow, rowCount: 1, col: orgRow, colCount: 1}]; me.onSelectionChanged({type: 'SelectionChanged'}, {sheet: sheet, sheetName: sheet.name(), newSelections: newSels, oldSelections: oldSels}); }); me.workBook.commandManager().setShortcutKey(null, GC.Spread.Commands.Key.enter, false, false, false, false); me.workBook.commandManager().setShortcutKey("myEnter", GC.Spread.Commands.Key.enter, false, false, false, false); }, buildSheet: function(container) { let me = repositoryGljObj; me.workBook = sheetCommonObj.buildSheet(container, me.setting, 30, me); sheetCommonObj.bindEscKey(me.workBook, [{sheet: me.workBook.getSheet(0), editStarting: me.onCellEditStart, editEnded: me.onCellEditEnd}]); me.bindEnterKey(); me.repositoryGljDelOpr(); me.onContextmenuOpr(); me.setUnitCombo(me.workBook.getActiveSheet(), me.setting.header); me.workBook.bind(GC.Spread.Sheets.Events.ClipboardPasting, me.onClipboardPasting); me.workBook.bind(GC.Spread.Sheets.Events.ClipboardPasted, me.onClipboardPasted); if(priceProperties && priceProperties.length > 0){ me.workBook.getSheet(0).frozenColumnCount(5); } me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.EditStarting, me.onCellEditStart); me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.EditEnded, me.onCellEditEnd); me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.EnterCell, me.onEnterCell); me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.LeaveCell, me.onLeaveCell); me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.SelectionChanged, me.onSelectionChanged); }, isDef: function (v) { return v !== undefined && v !== null; }, //成为了组成物 isComponent: function (gljId, gljList) { //暂时只需要判断主材(可成为主材的组成物)、机械组成物(可成为机械台班的组成物,但是机械组成物可能引用了普通材料) let gljTypes = [302, 4]; for(let i = 0, len = gljList.length; i < len; i++){ let gljComponent = gljList[i].component; if(gljTypes.includes(gljList[i].gljType) && this.isDef(gljComponent) && gljComponent.length > 0){ for(let j = 0, jLen = gljComponent.length; j < jLen; j++){ if(gljComponent[j].ID === gljId){ return true; } } } } return false; }, getCurrentComponent: function (gljComponent, sort = false) { let me = repositoryGljObj, rst = [], IDCodeMapping = {}; for(let i = 0; i < gljComponent.length; i++){ let obj = {}; for(let j = 0; j < me.gljList.length; j++){ let specs = me.gljList[j].specs ? ' ' + me.gljList[j].specs : ''; if(gljComponent[i].ID == me.gljList[j].ID){ obj.ID = me.gljList[j].ID; obj.code = me.gljList[j].code; obj.name = me.gljList[j].name + specs; obj.unit = me.gljList[j].unit; obj.basePrice = me.gljList[j].basePrice; obj.priceProperty = me.gljList[j].priceProperty ? me.gljList[j].priceProperty : {}; obj.consumeAmt = gljComponent[i].consumeAmt; obj.consumeAmtProperty = gljComponent[i].consumeAmtProperty ? gljComponent[i].consumeAmtProperty : {}; rst.push(obj); IDCodeMapping[obj.ID] = obj.code; } } } if(sort){ rst.sort(function (a, b) { let r = 0; if(a.code > b.code) r = 1; else if(a.code < b.code) r = -1; return r; }); gljComponent.sort(function (a, b) { let aV = IDCodeMapping[a.ID], bV = IDCodeMapping[b.ID]; if (aV > bV) { return 1; } else if (aV < bV) { return -1; } return 0; }); } return rst; }, //获得引用了组成物id为componentId的工料机,和重新变化组成物数组、重新计算单价 getUpdateGljs: function (rObj, isDelete) { let me = repositoryGljObj, that = gljComponentOprObj, rst = {updateArr: [], updateBasePrcArr: []}; //改变单价,以便reCalGljBasePrc方法可行 if(!isDelete){ for(let i = 0; i < me.gljList.length; i++){ if(me.gljList[i].ID === rObj.ID){ me.gljList[i].basePrice = rObj.basePrice; me.gljList[i].priceProperty = rObj.priceProperty ? rObj.priceProperty : {}; break; } } } for(let i = 0; i < me.gljList.length; i++){ let thisComponent = me.gljList[i].component, isChange = false; for(let j = 0; j < thisComponent.length; j++){ if(thisComponent[j].ID === rObj.ID){ //删除 isChange = true; if(isDelete){ thisComponent.splice(j--, 1); } else { break; } } } if(isChange){//引用了此组成物 rst.updateArr.push(me.gljList[i]); } } return rst; }, reshowGljBasePrc: function (glj) { let me = repositoryGljObj; let cacheSection = me.currentCache; let sheet = me.workBook.getActiveSheet(); let row = _.findIndex(cacheSection, {ID: glj.ID}); sheet.suspendEvent(); sheet.suspendPaint(); for(let priceCol of me.priceCols){ sheet.setValue(row, priceCol, glj[me.colMapping.colToField[priceCol]]); } sheet.resumeEvent(); sheet.resumePaint(); }, reSetGljBasePrc: function (gljs) { let me = repositoryGljObj; let cacheSection = me.currentCache; let sheet = me.workBook.getSheet(0); let basePriceCol = me.colMapping.fieldToCol['basePrice']; sheet.suspendPaint(); sheet.suspendEvent(); for(let i = 0; i < cacheSection.length; i++){ for(let glj of gljs){ if(glj.ID === cacheSection[i].ID){ for(let priceCol of me.priceCols){ sheet.setValue(i, priceCol, glj[me.colMapping.colToField[priceCol]]); } //sheet.setValue(i, basePriceCol, glj.basePrice); } } } sheet.resumePaint(); sheet.resumeEvent(); }, initSel: function (row) { let me = repositoryGljObj, that = gljComponentOprObj; sheetCommonObj.cleanData(that.workBook.getSheet(0), that.setting, -1); //sheetCommonObj.cleanSheet(that.workBook.getSheet(0), that.setting, -1); me.workBook.focus(true); me.currentComponent = []; that.workBook.getSheet(0).setRowCount(10); if(row < me.currentCache.length){ //标记当前工料机 me.currentGlj = me.currentCache[row]; if(allowComponent.includes(me.currentCache[row].gljType)){ //展示数据 if(me.currentGlj.component.length > 0){ me.currentComponent = me.getCurrentComponent(me.currentGlj.component, true); if(me.currentComponent.length > 0){ sheetsOprObj.showData(that, that.workBook.getSheet(0), that.setting, me.currentComponent); } } } } else{ me.currentGlj = null; } }, onSelectionChanged: function (sender, info) { let me = repositoryGljObj, that = gljComponentOprObj; //混凝土202、砂浆203、配合比204、机械3 if(info.oldSelections.length === 0 && info.newSelections.length > 0 || info.oldSelections[0].row !== info.newSelections[0].row){ let row = info.newSelections[0].row; me.initSel(row); } }, onLeaveCell: function (sender, args) { let me = repositoryGljObj; me.lastCell = {row: args.row, col: args.col}; }, onEnterCell: function (sender, args) { let me = repositoryGljObj; let thisDataCode = me.setting.header[args.col].dataCode, lastDataCode = me.setting.header[me.lastCell.col].dataCode; if(thisDataCode === 'unit'|| lastDataCode === 'unit' || thisDataCode === 'gljType' || lastDataCode === 'gljType' || thisDataCode === 'materialType' || lastDataCode === 'materialType' || thisDataCode === 'model' || lastDataCode === 'model'){ let rects = []; rects.push(args.sheet.getCellRect(args.row, args.col)); if(me.lastCell){ rects.push(args.sheet.getCellRect(me.lastCell.row, me.lastCell.col)); } for(let rect of rects){ args.sheet.repaint(rect); } //args.sheet.repaint(); } me.cellRowIdx = args.row; let isHasData = false; if(me.addGljObj){ for(let i=0; i 0 || updateGljs.updateBasePrcArr.length > 0){ for(let i = 0; i < updateGljs.updateArr.length; i++){ updateArr.push(updateGljs.updateArr[i]); } for(let i = 0; i < updateGljs.updateBasePrcArr.length; i++){ updateArr.push(updateGljs.updateBasePrcArr[i]); } } } sheetCommonObj.cleanData(that.workBook.getSheet(0), that.setting, 5); rObj.component = me.currentGlj.component; updateArr.push(rObj); me.mixUpdateRequest(updateArr, [], []); }); $('.typeClose').unbind('click'); $('.typeClose').bind('click', function () { args.sheet.setValue(args.row, args.col, _.find(me.distTypeTree.comboDatas, {value: me.currentGlj.gljType}).text); }); return; } else if(rObj.adjCoe !== me.currentEditingGlj.adjCoe){//修改调整系数,整数控制 if(isNaN(rObj.adjCoe) || rObj.adjCoe % 1 !== 0){ args.sheet.setValue(args.row, args.col, me.currentEditingGlj.adjCoe ? me.currentEditingGlj.adjCoe : ''); alert('调整系数只能输入整数!'); return; } } else if(rObj.materialCoe !== me.currentEditingGlj.materialCoe){ if(isNaN(rObj.materialCoe)){ args.sheet.setValue(args.row, args.col, me.currentEditingGlj.materialCoe ? me.currentEditingGlj.materialCoe : ''); alert('三材系数只能输入数值!'); return; } rObj.materialCoe = scMathUtil.roundTo(parseFloat(rObj.materialCoe), -5); } else if(!me.priceIsEqual(rObj, me.currentEditingGlj)){//修改了单价,可修改单价的必为可成为组成物的 let rObjPrice = me.getPrice(rObj, args.col), editingGljPrice = me.getPrice(me.currentEditingGlj, args.col); //寻找所有引用了此组成物的工料机,并从组成物中删去此工料机,并重算单价 if(isNaN(parseFloat(rObjPrice))){ alert('单价只能输入数值!'); args.sheet.setValue(args.row, args.col, editingGljPrice ? editingGljPrice : 0); return; } me.setGljPrice(rObj, scMathUtil.roundTo(parseFloat(rObjPrice), -2), args.col); let updateGljs = me.getUpdateGljs(rObj); if(updateGljs.updateArr.length > 0 || updateGljs.updateBasePrcArr.length > 0){ for(let i = 0; i < updateGljs.updateArr.length; i++){ updateArr.push(updateGljs.updateArr[i]); } for(let i = 0; i < updateGljs.updateBasePrcArr.length; i++){ updateArr.push(updateGljs.updateBasePrcArr[i]); } } } rObj.component = me.currentGlj.component; updateArr.push(rObj); } else{ if(me.setting.header[args.col].dataCode === 'gljType'){ let distTypeVal = me.distTypeTree.distTypes[me.distTypeTree.prefix + me.currentEditingGlj[me.setting.header[args.col].dataCode]].data.fullName; args.sheet.setValue(args.row, args.col, distTypeVal); } else{ args.sheet.setValue(args.row, args.col, me.currentEditingGlj[me.setting.header[args.col].dataCode]); } } } if(!me.priceIsEqual(rObj, me.currentEditingGlj)){ console.log('df'); //update basePrice of ration when editting basePrice of glj let gljType = -1; let gljTypeParent = me.distTypeTree.distTypes[me.distTypeTree.prefix + me.currentEditingGlj.gljType].parent; if(gljTypeParent && gljTypeParent.data.ID <=3){ gljType = gljTypeParent.data.ID; } if(!gljTypeParent && me.currentEditingGlj.gljType <= 3){ gljType = me.currentEditingGlj.gljType; } let gljBasePrcObj = {gljId: me.currentEditingGlj.ID, gljType: gljType, basePrice: me.getRationGljPrice(rObj)}; if(gljBasePrcObj.gljType !== -1){ updateBasePrcArr.push(gljBasePrcObj); if(me.rationLibs.length > 0){//重算定额单价 me.updateRationBasePrcRq(updateBasePrcArr); } } } } //新增 else { if(typeof rObj.code !== 'undefined'){ me.addGljObj = rObj; let isCanSav = true; if(!rObj.code || !rObj.name || !rObj.gljType){ isCanSav = false; } if(isCanSav){ me.addGljObj = null; rObj.component = []; //rObj.basePrice = !isNaN(parseFloat(rObj.basePrice)) && (rObj.basePrice && typeof rObj.basePrice !== 'undefined') ? scMathUtil.roundTo(parseFloat(rObj.basePrice), -2) : 0; me.initPrice(rObj); addArr.push(rObj); } } } if(!me.parentNodeIds["_pNodeId_" + me.gljCurTypeId]){ rObj.gljClass = me.gljCurTypeId; } if(updateArr.length >0 || addArr.length >0){ me.currentEditingGlj = null; me.mixUpdateRequest(updateArr, addArr, []); } }, delGljs: function (sels) { let me = repositoryGljObj; let sheet = me.workBook.getSheet(0), updateArr = [], removeArr = [], removeIDs = [], removeNames = [], updateBasePrcArr = [],//删除基价单位后重新计算 canUpdate = false, cacheSection = me.currentCache, updateBackups = []; if(sels.length > 0 && cacheSection.length > 0){ for(let i = 0; i < sels.length; i++){ if(sels[i].colCount === me.setting.header.length){ for(let j = 0; j < sels[i].rowCount; j++){ if(sels[i].row + j < cacheSection.length){ removeArr.push(cacheSection[sels[i].row + j]); removeIDs.push(cacheSection[sels[i].row + j].ID); removeNames.push(cacheSection[sels[i].row + j].name); //删除后重新计算引用了此工料机的定额单价 updateBasePrcArr.push({gljId: cacheSection[sels[i].row + j].ID, gljType: cacheSection[sels[i].row + j].gljType, basePrice: 0, delete: 1}); } } } else{ let maxCol = sels[i].col + sels[i].colCount - 1; let cantNullDataCode = ['code', 'name', 'gljType']; for(let j = 0; j < sels[i].rowCount; j++){ if(sels[i].row + j < cacheSection.length){ let updateObj = cacheSection[sels[i].row + j]; for(let col = sels[i].col; col <= maxCol; col++){ let dataCode = me.setting.header[col].dataCode; if(cantNullDataCode.includes(dataCode)){ $('#alertText').text(me.setting.header[col].headerName + "不可为空!"); $('#codeAlert').modal('show'); return false; } else { canUpdate = true; break; } } } } } } if(canUpdate){ //删除警告 let upAlertText = '确认删除选中字段?'; $('#alertGljTxt').text(upAlertText); $('#gljAlert').modal('show'); $('#aleConfBtn').unbind('click'); //确认 $('#aleConfBtn').bind('click', function () { for(let i = 0; i < sels.length; i++) { let maxCol = sels[i].col + sels[i].colCount - 1; for (let j = 0; j < sels[i].rowCount; j++) { if (sels[i].row + j < cacheSection.length) { let updateObj = cacheSection[sels[i].row + j]; for (let col = sels[i].col; col <= maxCol; col++) { let dataCode = me.setting.header[col].dataCode; if (me.priceCols.includes(col)) { me.setGljPrice(updateObj, 0, col); updateBasePrcArr.push({ gljId: updateObj.ID, gljType: updateObj.gljType, basePrice: 0 }); } else { if (dataCode === 'materialType') { updateObj['materialCoe'] = null; } updateObj[dataCode] = ''; } } updateArr.push(updateObj); } } } me.mixUpdateRequest(updateArr, [], []); if(updateBasePrcArr.length > 0 && me.rationLibs.length > 0){ me.updateRationBasePrcRq(updateBasePrcArr); } }); } if(removeArr.length > 0){ $.bootstrapLoading.start(); CommonAjax.post('/stdGljRepository/api/isUsed', {gljIds: removeIDs}, function (rstData) { $.bootstrapLoading.end(); //存在被引用的人材机(标准/补充定额库) if(rstData.isUsed){ $('#gljAlert').find('.modal-body h5').text('已有定额引用了当前人材机,不可删除。'); $('#gljAlert').modal('show'); $('#aleConfBtn').unbind('click'); $('#aleConfBtn').bind('click', function () { $('#gljAlert').modal('hide'); me.workBook.focus(true) }); } else { $('#gljAlert').find('.modal-body h5').text(`确定要删除人材机 “${removeNames.join(',')}” 吗? `); setTimeout(function () { $('#gljAlert').modal('show'); }, 200); //确认 $('#aleConfBtn').unbind('click'); $('#aleConfBtn').bind('click', function () { for(let removeD of removeArr){ let updateGljs = me.getUpdateGljs(removeD, true); if(updateGljs.updateArr.length > 0){ for(let i = 0; i < updateGljs.updateArr.length; i++){ updateArr.push(updateGljs.updateArr[i]); } } } me.mixUpdateRequest(updateArr, [], removeIDs); /* if(updateBasePrcArr.length > 0 && me.rationLibs.length > 0){ me.updateRationBasePrcRq(updateBasePrcArr); me.workBook.focus(true); }*/ }); } }, function () { $.bootstrapLoading.end(); $('#gljAlert').find('.modal-body h5').text('查询引用错误,不可删除。'); $('#gljAlert').modal('show'); $('#aleConfBtn').unbind('click'); $('#aleConfBtn').bind('click', function () { $('#gljAlert').modal('hide'); me.workBook.focus(true); }); }); } } }, //删除人材机前需要判断人材机是否有被引用,被引用了则不可删除 repositoryGljDelOpr: function () { let me = repositoryGljObj; me.workBook.commandManager().register('repositoryGljDel', function () { let sels = me.workBook.getActiveSheet().getSelections(); me.delGljs(sels); }); me.workBook.commandManager().setShortcutKey(null, GC.Spread.Commands.Key.del, false, false, false, false); me.workBook.commandManager().setShortcutKey('repositoryGljDel', GC.Spread.Commands.Key.del, false, false, false, false); }, onContextmenuOpr: function () { let me = repositoryGljObj; $.contextMenu({ selector: '#GLJListSheet', build: function($triggerElement, e){ //控制允许右键菜单在哪个位置出现 let sheet = me.workBook.getSheet(0); let offset = $("#GLJListSheet").offset(), x = e.pageX - offset.left, y = e.pageY - offset.top; let target = sheet.hitTest(x, y); let sel = sheet.getSelections()[0]; if(sel.row === -1){ sel.row = 0; } if(sel.col === -1){ sel.col = 0; } if(target.hitTestType === 3 && typeof target.row !== 'undefined' && typeof target.col !== 'undefined'){//在表格内 me.initSel(target.row); if(sel.row > target.row || sel.row + sel.rowCount - 1 < target.row || sel.col > target.col || sel.col + sel.colCount - 1 < target.col ){ sheet.setActiveCell(target.row, target.col); } return { callback: function(){}, items: { "delete": { name: "删除", disabled: function () { return !(me.currentCache && me.currentCache[target.row]); }, icon: "fa-remove", callback: function (key, opt) { let curSel = _.cloneDeep(sheet.getSelections()[0]); curSel.colCount = me.setting.header.length; me.delGljs([curSel]); }} } }; } else{ return false; } } }); }, validUpdateObj: function (pasteObj, rowIdx) { let rst = {updateGlj: [], updateBasePrcArr: []}, backUpObj = {}, me = repositoryGljObj, that = gljComponentOprObj, tempObj = me.currentCache[rowIdx], reCalBasePrc = false, isValid = true, materialTypeValid = true; //备份原始数据 for(let atr in tempObj){ backUpObj[atr] = tempObj[atr]; } if(typeof pasteObj.code !== 'undefined'){ if(pasteObj.code.trim().length !== 0){ let isExist = false; for(let i = 0; i < me.gljList.length; i++){ if(me.gljList[i].code === pasteObj.code){ isExist = true; break; } } if(!isExist){ tempObj.code = pasteObj.code; } else isValid = false; } else isValid = false; } if(typeof pasteObj.name !== 'undefined'){ if(pasteObj.name.trim().length === 0) isValid = false; else tempObj.name = pasteObj.name; } if(typeof pasteObj.specs !== 'undefined'){ tempObj.specs = pasteObj.specs; } if(typeof pasteObj.unit !== 'undefined'){ tempObj.unit = pasteObj.unit; } if(typeof pasteObj.gljType !== 'undefined'){ let isExsit = false; for(let i = 0; i < me.distTypeTree.comboDatas.length; i++){ if(pasteObj.gljType === me.distTypeTree.comboDatas[i].text){ pasteObj.gljType = me.distTypeTree.comboDatas[i].value; isExsit = true; //调整系数 if(pasteObj.gljType !== 1 && pasteObj.gljType !== 303){ tempObj.adjCoe = null; } else if((pasteObj.gljType === 1 || pasteObj.gljType === 303) && typeof pasteObj.adjCoe !== 'undefined' && !isNaN(pasteObj.adjCoe) && pasteObj.adjCoe % 1 === 0) { tempObj.adjCoe = pasteObj.adjCoe; } if(pasteObj.gljType !== 301 && tempObj.gljType === 301){ tempObj.model = null; } if(componentType.includes(tempObj.gljType) && //!(tempObj.gljType === 302 && pasteObj.gljType === 303) && !(tempObj.gljType === 303 && pasteObj.gljType === 302)){//修改了原本是组成物的工料机 !(machineComponent.includes(tempObj.gljType) && machineComponent.includes(pasteObj.gljType)) && !(materialComponent.includes(tempObj.gljType) && materialComponent.includes(pasteObj.gljType))){//修改了原本是组成物的工料机 //寻找所有引用了此组成物的工料机,并从组成物中删去此工料机,并重算单价 let updateGljs = me.getUpdateGljs(tempObj, true); if(updateGljs.updateArr.length > 0 || updateGljs.updateBasePrcArr.length > 0){ for(let i = 0; i < updateGljs.updateArr.length; i++){ rst.updateGlj.push(updateGljs.updateArr[i]); } for(let i = 0; i < updateGljs.updateBasePrcArr.length; i++){ rst.updateBasePrcArr.push(updateGljs.updateBasePrcArr[i]); } } } tempObj.component = tempObj.gljType === pasteObj.gljType ? tempObj.component : []; /*if(me.allowComponent.indexOf(tempObj.gljType) !== -1){//更改成可含组成物的工料机类型,定额价设置为零 tempObj.basePrice = tempObj.gljType === me.distTypeTree.comboDatas[i].value ? tempObj.basePrice : 0; }*/ tempObj.gljType = pasteObj.gljType; tempObj.shortName = me.distTypeTree.distTypes[me.distTypeTree.prefix + tempObj.gljType].data.shortName; break; } } if(!isExsit) { isValid = false; } } if(typeof pasteObj.adjCoe !== 'undefined' && typeof pasteObj.gljType === 'undefined'){ if(tempObj.gljType && (tempObj.gljType === 1 || tempObj.gljType === 303) && typeof pasteObj.adjCoe !== 'undefined' && !isNaN(pasteObj.adjCoe) && pasteObj.adjCoe % 1 === 0) { tempObj.adjCoe = pasteObj.adjCoe; } else { isValid = false; } } //单价相关 if(me.pasteIncludesPrice(pasteObj)){ if(!priceProperties || priceProperties.length === 0){ pasteObj.basePrice = pasteObj.basePrice && !isNaN(parseFloat(pasteObj.basePrice)) ? scMathUtil.roundTo(parseFloat(pasteObj.basePrice), -2) : me.currentCache[rowIdx].basePrice; if(pasteObj.basePrice !== me.currentCache[rowIdx].basePrice){ reCalBasePrc = true; tempObj.basePrice = pasteObj.basePrice; } } else { //多单价粘贴 let pastePriceProperty = {}; let priceFields = me.getPriceFields(); for(let priceField of priceFields){ if(typeof pasteObj[priceField] !== 'undefined' && pasteObj[priceField] && !isNaN(parseFloat(pasteObj[priceField]))){ pastePriceProperty[priceField] = scMathUtil.roundTo(parseFloat(pasteObj[priceField]), -2); } } if(!me.priceIsEqual(tempObj, pasteObj)){ reCalBasePrc = true; //更新人材机单价 for(let priceField in pastePriceProperty){ tempObj.priceProperty[priceField] = pastePriceProperty[priceField]; } } } let updateGljs = me.getUpdateGljs(tempObj, false); if(updateGljs.updateArr.length > 0 || updateGljs.updateBasePrcArr.length > 0){ for(let i = 0; i < updateGljs.updateArr.length; i++){ rst.updateGlj.push(updateGljs.updateArr[i]); } for(let i = 0; i < updateGljs.updateBasePrcArr.length; i++){ rst.updateBasePrcArr.push(updateGljs.updateBasePrcArr[i]); } } } if(typeof pasteObj.materialType !== 'undefined'){ if(!me.materialType.textArr.includes(pasteObj.materialType)){ isValid = false; materialTypeValid = false; } else { me.materialType.comboItems.forEach(function (item) { if(item.text === pasteObj.materialType){ tempObj.materialType = item.value; } }); } } if(typeof pasteObj.materialCoe !== 'undefined'){ if(isNaN(pasteObj.materialCoe) || (!tempObj.materialType && (!pasteObj.materialType || !me.materialType.textArr.includes(pasteObj.materialType)))){ tempObj.materialType = ''; tempObj.materialCoe = null; isValid = false; } else{ tempObj.materialCoe = pasteObj.materialCoe !== '' ? scMathUtil.roundTo(parseFloat(pasteObj.materialCoe), -5) : null; } } if(typeof pasteObj.model !== 'undefined'){ if(!me.machineModel.textArr.includes(pasteObj.model)){ isValid = false; } else { let existsModel = false; if((typeof pasteObj.gljType !== 'undefined' && pasteObj.gljType === 301) || (tempObj.gljType && tempObj.gljType === 301)){ me.machineModel.comboItems.forEach(function (item) { if(item.text === pasteObj.model){ tempObj.model = item.value; existsModel = true; } }); if(!existsModel){ isValid = false; } } else { isValid = false; } } } if(isValid){ rst.updateGlj.push(tempObj); if(reCalBasePrc){ //重新计算定额基价对象 let newReObj = {gljId: tempObj.ID, gljType: tempObj.gljType, basePrice: me.getRationGljPrice(tempObj)}; rst.updateBasePrcArr.push(newReObj); } } else { for(let attr in backUpObj){ tempObj[attr] = backUpObj[attr]; } } return rst; }, //粘贴的数据是否是可添加的数据,只有含有编号,名称,类型才可添加 isValidObj: function(pasteObj) { let me = repositoryGljObj; if(!(pasteObj.code && typeof pasteObj.code !== 'undefined') || !(pasteObj.name && typeof pasteObj.name !== 'undefined') || !(pasteObj.gljType && typeof pasteObj.gljType !== 'undefined')){ return false; } if(pasteObj.gljType && typeof pasteObj.gljType !== 'undefined'){ let isExist = false; for(let i = 0; i < me.distTypeTree.comboDatas.length; i++){ if(me.distTypeTree.comboDatas[i].text === pasteObj.gljType){ isExist = true; pasteObj.gljType = me.distTypeTree.comboDatas[i].value; pasteObj.shortName = me.distTypeTree.distTypes[me.distTypeTree.prefix + pasteObj.gljType].data.shortName; break; } } if(!isExist){ return false; } } if(pasteObj.code && typeof pasteObj.code !== 'undefined'){ for(let i = 0; i < me.gljList.length; i++){ if(me.gljList[i].code === pasteObj.code){ return false; } } } if(pasteObj.adjCoe && typeof pasteObj.adjCoe !== 'undefined'){ if(isNaN(pasteObj.adjCoe) || pasteObj.adjCoe % 1 !== 0){ return false; } } if(pasteObj.materialType){ if(!me.materialType.textArr.includes(pasteObj.materialType)){ return false; } else { me.materialType.comboItems.forEach(function (item) { if(item.text === pasteObj.materialType){ pasteObj.materialType = item.value; } }); } } if(pasteObj.materialCoe){ if(isNaN(pasteObj.materialCoe) || !pasteObj.materialType){ return false; } } if(typeof pasteObj.model !== 'undefined' && pasteObj.model){ if(!me.machineModel.textArr.includes(pasteObj.model) || pasteObj.gljType !== 301){ return false; } me.machineModel.comboItems.forEach(function (item) { if(item.text === pasteObj.model){ pasteObj.model = item.value; } }); } if(!priceProperties || priceProperties.length === 0){ pasteObj.basePrice = !isNaN(parseFloat(pasteObj.basePrice)) && (pasteObj.basePrice && typeof pasteObj.basePrice !== 'undefined') ? parseFloat(pasteObj.basePrice) : 0; } else { let pastePriceProperty = {}; let priceFields = me.getPriceFields(); for(let priceField of priceFields){ if(typeof pasteObj[priceField] !== 'undefined' && pasteObj[priceField] && !isNaN(parseFloat(pasteObj[priceField]))){ pastePriceProperty[priceField] = scMathUtil.roundTo(parseFloat(pasteObj[priceField]), -2); } else { pastePriceProperty[priceField] = 0; } } pasteObj.priceProperty = pastePriceProperty; } //pasteObj.basePrice = !isNaN(parseFloat(pasteObj.basePrice)) && (pasteObj.basePrice && typeof pasteObj.basePrice !== 'undefined') ? parseFloat(pasteObj.basePrice) : 0; if(!me.parentNodeIds["_pNodeId_" + me.gljCurTypeId]){ pasteObj.gljClass = me.gljCurTypeId; } return true; }, canPasted: function (info) { let rst = true; let me = repositoryGljObj; if(me.gljCurTypeId < 0){ return false; } //粘贴的最大列下标不超过总列数 if(info.cellRange.col + info.cellRange.colCount - 1 > me.setting.header.length - 1){ return false; } if(info.cellRange.row < me.currentCache.length){ if(info.cellRange.col === 0){ return false; } } return rst; }, onClipboardPasting: function(sender, args) { let me = repositoryGljObj; //复制的列数超过正确的列数,不可复制 if(me.prevent){ args.cancel = true; return; } if(!me.canPasted(args)){ args.cancel = true; } }, onClipboardPasted: function(e, info) { $.bootstrapLoading.start(); let me = repositoryGljObj; let updateArr = [], addArr = []; let items = sheetCommonObj.analyzePasteData(me.setting, info); let beginRow = info.cellRange.row, endRow = info.cellRange.row + info.cellRange.rowCount - 1, maxRow = me.currentCache.length - 1, updateBasePrcArr = [], updateCount, resumeArr = []; if(endRow <= maxRow){ //updateItems = items; for(let i = 0; i < items.length; i++){ let updateObj = me.validUpdateObj(items[i], info.cellRange.row + i); if(updateObj && typeof updateObj.updateGlj !== 'undefined' && updateObj.updateGlj.length > 0){ //updateArr = updateObj.updateGlj; updateArr = updateArr.concat(updateObj.updateGlj); if(typeof updateObj.updateBasePrcArr !== 'undefined'){ //updateBasePrcArr = updateObj.updateBasePrc; updateBasePrcArr = updateBasePrcArr.concat(updateObj.updateBasePrcArr); } } } } else if(beginRow <= maxRow && endRow > maxRow){ updateCount = maxRow - beginRow + 1; for(let i = 0; i < updateCount; i++){ let updateObj = me.validUpdateObj(items[i], info.cellRange.row + i); if(updateObj && typeof updateObj.updateGlj !== 'undefined'){ updateArr = updateArr.concat(updateObj.updateGlj); if(typeof updateObj.updateBasePrcArr !== 'undefined'){ updateBasePrcArr = updateBasePrcArr.concat(updateObj.updateBasePrcArr); } } } //if(info.cellRange.colCount >= me.setting.header.length - 4 && info.cellRange.colCount <= me.setting.header.length){ //[code, ..., gljType] if(info.cellRange.colCount >= 5 && info.cellRange.colCount <= me.setting.header.length){ for(let i = updateCount ; i < items.length; i++){ if(me.isValidObj(items[i])){ items[i].component = []; addArr.push(items[i]); } } } } else{ //if(info.cellRange.colCount >= me.setting.header.length - 4 && info.cellRange.colCount <= me.setting.header.length && info.cellRange.col + info.cellRange.colCount - 1 >= 5){ //粘贴的的最大列至少要等于工料机类型列,因为工料机类型必须有效才可新增 if(info.cellRange.colCount >= 5 && info.cellRange.colCount <= me.setting.header.length && info.cellRange.col + info.cellRange.colCount - 1 >= me.colMapping.fieldToCol['gljType']){ for(let i = 0; i < items.length; i++){ if(me.isValidObj(items[i])){ items[i].component = []; addArr.push(items[i]); } } } } //repaint for(let i = 0; i < info.cellRange.rowCount; i++){ resumeArr.push(info.cellRange.row + i); } if(resumeArr.length > 0){ info.sheet.suspendPaint(); for(let i = 0; i < resumeArr.length ; i++){ if(resumeArr[i] < me.currentCache.length){ for(let col = 0; col < me.setting.header.length; col++){ let dCode = me.setting.header[col].dataCode; if(me.priceCols.includes(col)){ let price = me.getPrice(me.currentCache[resumeArr[i]], col); info.sheet.setValue(resumeArr[i], col, price ? price : 0); } else if(dCode === 'gljType'){ let gljType = me.currentCache[resumeArr[i]][dCode]; info.sheet.setValue(resumeArr[i], col, me.distTypeTree.distTypes["gljType" + gljType].data.fullName); } else if(dCode === 'materialType'){ info.sheet.setValue(resumeArr[i], col, me.currentCache[resumeArr[i]][dCode] ? me.materialTypeIdx[me.currentCache[resumeArr[i]][dCode]]: ''); } else if(dCode === 'model'){ info.sheet.setValue(resumeArr[i], col, me.currentCache[resumeArr[i]][dCode] ? me.machineModelIdx[me.currentCache[resumeArr[i]][dCode]]: ''); } else{ info.sheet.setValue(resumeArr[i], col, me.currentCache[resumeArr[i]][dCode]); } } } else{ for(let col = 0; col < me.setting.header.length; col++){ info.sheet.setValue(resumeArr[i], col, ''); } } } info.sheet.resumePaint(); } if (updateArr.length > 0 || addArr.length > 0) { me.mixUpdateRequest(updateArr, addArr, []); } else { $.bootstrapLoading.end(); } if(updateBasePrcArr.length > 0 && me.rationLibs.length > 0){ me.updateRationBasePrcRq(updateBasePrcArr); } }, updateRationBasePrcRq: function (basePrcArr, workBook, callback) { let me = this; me.prevent = true; if (!$.bootstrapLoading.isLoading()) { $.bootstrapLoading.start(); } $.ajax({ type: 'post', url: 'api/updateRationBasePrc', data:{basePrcArr: JSON.stringify(basePrcArr)}, dataType: 'json', success: function (result) { if(result.error){ alert("计算定额基价失败"); } if(workBook){ workBook.focus(true); } else { me.workBook.focus(true); } me.prevent = false; if(callback){ callback(); } if ($.bootstrapLoading.isLoading()) { $.bootstrapLoading.end(); } } }); }, mixUpdateRequest: function(updateArr, addArr, removeIds) { let me = repositoryGljObj; if(updateArr.length > 0){ me.saveInString(updateArr) } if(addArr.length > 0){ me.saveInString(addArr); } $.ajax({ type:"POST", url:"api/mixUpdateGljItems", data:{"repositoryId": me.currentRepositoryId, "lastOpr": userAccount, "updateItems": JSON.stringify(updateArr), "addItems": JSON.stringify(addArr), "removeIds": JSON.stringify(removeIds)}, dataType:"json", cache:false, timeout:50000, success:function(result){ if (result.error) { alert(result.message); } else { me.updateCache(addArr, updateArr, removeIds, result); //me.sortGlj(); if(me.currentOprParent === 1){ me.currentCache = me.getParentCache(me.parentNodeIds["_pNodeId_" + me.gljCurTypeId]); } else{ me.currentCache = me.getCache(); } me.showGljItems(me.currentCache, me.gljCurTypeId); //getCurrentGlj let row = me.workBook.getSheet(0).getSelections()[0].row; me.currentGlj = row < me.currentCache.length ? me.currentCache[row] : null; me.currentComponent = me.currentGlj ? me.getCurrentComponent(me.currentGlj.component) : []; sheetCommonObj.cleanData(gljComponentOprObj.workBook.getSheet(0), gljComponentOprObj.setting, -1); sheetsOprObj.showData(gljComponentOprObj, gljComponentOprObj.workBook.getSheet(0), gljComponentOprObj.setting, me.currentComponent); } if ($.bootstrapLoading.isLoading()) { $.bootstrapLoading.end(); } }, error:function(err){ if ($.bootstrapLoading.isLoading()) { $.bootstrapLoading.end(); } console.log(err); alert("保存失败"); } }); }, saveInString: function (datas) { for(let i = 0, len = datas.length; i < len; i++){ let data = datas[i]; if(_exist(data, 'basePrice')){ data['basePrice'] = data['basePrice'].toString(); } if(_exist(data, 'component')){ for(let j = 0, jLen = data['component'].length; j < jLen; j++){ let comGljObj = data['component'][j]; if(_exist(comGljObj, 'consumeAmt')){ comGljObj['consumeAmt'] = comGljObj['consumeAmt'].toString(); } } } } function _exist(data, attr){ return data && data[attr] !== undefined && data[attr]; } }, getParentCache: function (nodes) { let me = repositoryGljObj, rst = []; for(let i = 0; i < me.gljList.length; i++){ if(nodes.indexOf(me.gljList[i].gljClass) !== -1){ rst.push(me.gljList[i]); } } rst.sort(function (a, b) { let rst = 0; if(a.code > b.code) rst = 1; else if(a.code < b.code)rst = -1; return rst; }); return rst; }, getCache: function() { let me = this, rst = []; for (let i = 0; i < me.gljList.length; i++) { if (me.gljList[i].gljClass == me.gljCurTypeId) { rst.push(me.gljList[i]); } } return rst; }, updateCache: function(addArr, updateArr, removeIds, result) { let me = this, cacheSection = me.gljList; if (addArr.length > 0) { me.gljList = me.gljList.concat(addArr); cacheSection = me.gljList; } for (let i = removeIds.length - 1; i >= 0; i--) { for (let j = cacheSection.length - 1; j >= 0 ; j--) { if (cacheSection[j]["ID"] == removeIds[i]) { cacheSection.splice(j,1); } } } if (result && result.data && result.data.ops && result.data.ops.length > 0) { for (let i = 0; i < result.data.ops.length; i++) { for (let j = 0; j < cacheSection.length; j++) { if (cacheSection[j]['code'] == result.data.ops[i]['code']) { cacheSection[j]["ID"] = result.data.ops[i]["ID"]; } } } } for (let i = 0; i < updateArr.length; i++) { for (let j = 0; j < cacheSection.length; j++) { if (updateArr[i]["ID"] && cacheSection[j]["ID"]) { if (cacheSection[j]["ID"] == updateArr[i]["ID"]) { cacheSection[j] = updateArr[i]; } } else { if (cacheSection[j]['code'] == updateArr[i]['code']) { cacheSection[j] = updateArr[i]; } } } } }, updateParentNodeIds: function (nodes, caller) { let private_build_parentNodeIds = function(pNodeId, nodesArr){ let rst = []; for (let i = 0; i < nodesArr.length; i++) { if (nodesArr[i].children.length > 0) { rst = rst.concat(private_build_parentNodeIds(nodesArr[i].data.ID, nodesArr[i].children)); } else { rst.push(nodesArr[i].data.ID); } } if (pNodeId && rst.length > 0) { caller.parentNodeIds["_pNodeId_" + pNodeId] = rst; } return rst; }; if (caller.parentNodeIds) { private_build_parentNodeIds(null, nodes); } }, sortGljDeep: function (datas) { function recurCompare(a, b, index){ if (a[index] && !b[index]) { return 1; } else if (!a[index] && b[index]) { return -1; } else if (a[index] && b[index]) { let aV = a[index], bV = b[index]; if (!isNaN(aV) && !isNaN(bV)) { aV = parseFloat(a[index]); bV = parseFloat(b[index]); } if (aV > bV) { return 1; } else if (aV < bV) { return -1; } else { return recurCompare(a, b, index + 1); } } return 0; } /* if(this.currentOprParent){ datas.sort(function (a, b) { let rst = 0; if(a.code > b.code){ rst = 1; } else if(a.code < b.code){ rst = -1; } return rst; }); } else {*/ //排序符号- datas.sort(function (a, b) { let aArr = a.code.split('-'), bArr = b.code.split('-'); return recurCompare(aArr, bArr, 0); }); // } }, //工料机排序 sortGlj: function() { let me = this; me.gljList.sort(function(a, b){ let rst = 0; if (a.code > b.code) rst = 1 else if (a.code < b.code) rst = -1; return rst; }); } } let gljTypeTreeOprObj = { onClick: function(event,treeId,treeNode) { let me = repositoryGljObj, that = gljComponentOprObj, gljTypeId = treeNode.ID; me.gljCurTypeId = treeNode.ID; me.addGljObj = null; sheetCommonObj.cleanSheet(that.workBook.getSheet(0), that.setting, 10); if (me.parentNodeIds["_pNodeId_" + treeNode.ID]) { me.currentOprParent = 1; me.currentCache = me.getParentCache(me.parentNodeIds["_pNodeId_" + treeNode.ID]); me.workBook.getSheet(0).setRowCount(me.currentCache.length); } else { me.currentOprParent = 0; me.currentCache = me.getCache(); } me.showGljItems(me.currentCache, gljTypeId); }, beforeRename: function(treeId, treeNode, newName, isCancel) { if (newName.length == 0) { return false; } return true; }, onRename : function(e, treeId, treeNode, isCancel) { let nodes = []; nodes.push(treeNode); gljTypeTreeOprObj.updateNodes(nodes); }, onBeforeRemove: function(treeId, treeNode){ let me = this; if (treeNode.ParentID == -1 && treeNode.isFirstNode) { alert("不允许删除全部!"); return false; } if (!confirm("您确定要删除此节点及所有子节点的数据?删除后不可恢复!")) { return false; } let nodeIds = [], preNode = treeNode.getPreNode(), preNodeId = -1; if (preNode) { preNodeId = preNode.ID; } private_fetchAllSubItems = function(pItem){ nodeIds.push(pItem.ID); if (pItem.items && pItem.items.length > 0) { for (let i = 0; i < pItem.items.length; i++) { private_fetchAllSubItems(pItem.items[i]); } } }; nodeIds.push(treeNode.ID); for (let i = 0; i < treeNode.items.length; i++) { private_fetchAllSubItems(treeNode.items[i]); } $.ajax({ type:"POST", url:"api/deleteGljNodes", data:{"repId": pageOprObj.gljLibId, "lastOpr": userAccount, "nodes": JSON.stringify(nodeIds), "preNodeId": preNodeId, "preNodeNextId": treeNode.NextSiblingID}, dataType:"json", cache:false, timeout:5000, success:function(result,textStatus,status){ let pNode = treeNode.getParentNode(); if (pNode && pNode.items && pNode.items.length == 1) { pNode.isParent = false; } }, error:function(){ } }); return true; }, onRemove: function(e, treeId, treeNode){ let me = repositoryGljObj, pNode = me.treeObj.getNodeByTId(treeNode.parentTId); if (pNode && pNode.items && pNode.items.length == 0) { pNode.isParent = false; me.treeObj.refresh(); } }, updateNodes: function(nodes){ if (nodes && nodes.length > 0) { let reqData = [] for (let i = 0; i < nodes.length; i++) { let node = {}; node.repositoryId = nodes[i].repositoryId; node.ID = nodes[i].ID; node.ParentID = nodes[i].ParentID; node.NextSiblingID = nodes[i].NextSiblingID; node.Name = nodes[i].Name; reqData.push(node); } $.ajax({ type:"POST", url:"api/updateGljNodes", data:{"repId": pageOprObj.gljLibId, "lastOpr": userAccount, "nodes": JSON.stringify(reqData)}, dataType:"json", cache:false, timeout:5000, success:function(result,textStatus,status){ console.log(status + ' : ' + result); }, error:function(){ } }) } }, addRootNode: function() { let me = repositoryGljObj, rawNode = {ParentID: -1, NextSiblingID: -1, Name: "所有"}, lastNodeId = -1; if (me.treeObj) { let rootNodes = me.treeObj.getNodes(); if (rootNodes.length == 0) { gljTypeTreeOprObj.addNewNode(rawNode, lastNodeId, function(err, rst){ if (!(err)) { let newNodes = [], isSilent = false; newNodes.push({ repositoryId: rst.data.repositoryId, ID: rst.data.ID, ParentID: rst.data.ParentID, NextSiblingID:-1, Name:"所有",isParent:false, items:[]}); me.treeObj.addNodes(null, -1, newNodes, isSilent); } }); } } }, addNewNode : function(rawNode, lastNodeId, callback){ $.ajax({ type:"POST", url:"api/createNewGljTypeNode", data:{"lastOpr": userAccount, "repositoryId": repositoryGljObj.currentRepositoryId,"lastNodeId": lastNodeId, "rawNodeData": JSON.stringify(rawNode)}, dataType:"json", cache:false, timeout:1000, success: function(result,textStatus,status){ callback(false, result); }, error:function(err){ callback(err); } }) }, addHoverDom: function(treeId, treeNode) { if(typeof treeNode.doing !== 'undefined' && treeNode.doing){ return false; } hoverOpr(); function hoverOpr(){ let me = repositoryGljObj, sObj = $("#" + treeNode.tId + "_span"); if (treeNode.editNameFlag || $("#addBtn_"+treeNode.tId).length>0) return; let addStr = ""; sObj.after(addStr); let btn = $("#addBtn_"+treeNode.tId); if (btn) btn.bind("click", function(){ treeNode.doing = true; let rawNode = {ParentID: treeNode.ID, NextSiblingID: -1, Name: "新增子节点"}, lastNodeId = -1; if (treeNode.items.length > 0) { lastNodeId = treeNode.items[treeNode.items.length - 1].ID; } gljTypeTreeOprObj.addNewNode(rawNode, lastNodeId, function(err, rst){ if (!(err)) { let newNodes = [], isSilent = false; if(treeNode.items.length > 0){ treeNode.items[treeNode.items.length - 1].NextSiblingID = rst.data.ID; } newNodes.push({ repositoryId: rst.data.repositoryId, ID: rst.data.ID, ParentID: rst.data.ParentID, NextSiblingID:-1, Name:"新增子节点",isParent:false, items:[]}); treeNode.isParent = true; if (me.treeObj) { me.treeObj.addNodes(treeNode, -1, newNodes, isSilent); } else { me.treeObj = $.fn.zTree.init($("#rationChapterTree"), gljSetting, newNodes); } treeNode.doing = false; hoverOpr(); } }); }); } }, removeHoverDom: function(treeId, treeNode) { $("#addBtn_"+treeNode.tId).unbind().remove(); } };