/** * Created by Zhong on 2017/8/14. */ const locked = lockUtil.getLocked(); $(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: 375, max: `$('#dataRow').width() - $('#rightContent').width() - 375`, }, 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 () { let resizeRate = (SlideResize.resizeWidth * 100) / $("#midContent").width(), sheetRate = 100 - resizeRate; $("#slideResizeLeft").css("width", `${resizeRate}%`); $("#GLJListSheet").css("width", `${sheetRate}%`); refreshALlWorkBook(); } ); $("#gljSearch").keydown(function (event) { if (event.keyCode === 13) { $(this).blur(); const gljCode = $(this).val(); if (gljCode) { repositoryGljObj.locateGlj(gljCode); // sectionTreeObj.locateToSection(rationCode); } } }); }); 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.getGljItems(gljLibId, function () { gljClassTreeObj.getGljClassTree(gljLibId, function () { const spreads = [ gljClassTreeObj.workBook, repositoryGljObj.workBook, gljComponentOprObj.workBook, ]; const $range = $(document.body); lockUtil.lockSpreadsAndTools(spreads, $range, locked); }); }); }); }); }, }; let repositoryGljObj = { colMapping: null, treeObj: null, workBook: null, gljCurTypeId: -1, currentRepositoryId: -1, currentCache: null, parentNodeIds: {}, gljList: [], feeDataCode: [ "grossWeightCoe", "purchaseStorageRate", "offSiteTransportLossRate", "handlingLossRate", ], 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", }, ], view: { comboBox: [{ row: -1, col: 3, rowCount: -1, colCount: 1 }], lockedCells: [], }, }, locateGlj: function (gljCode) { const glj = repositoryGljObj.gljList.find((glj) => glj.code === gljCode); if (!glj) { alert(`不存在人材机${gljCode}`); } const gljClassNode = gljClassTreeObj.cache.find((node) => node.data.ID === glj.gljClass) || gljClassTreeObj.cache[0]; if (!gljClassNode) { alert("无法定位到分类节点"); } const gljClassRow = gljClassTreeObj.cache.indexOf(gljClassNode); const classSheet = gljClassTreeObj.workBook.getSheet(0); classSheet.showRow(gljClassRow, GC.Spread.Sheets.VerticalPosition.center); classSheet.setActiveCell(gljClassRow, 0); gljClassTreeObj.initSelection(gljClassNode); const theGlj = repositoryGljObj.currentCache.find( (item) => item.code === gljCode ); if (!theGlj) { alert(`不存在人材机${gljCode}`); } const sheet = repositoryGljObj.workBook.getSheet(0); const gljRow = repositoryGljObj.currentCache.indexOf(theGlj); sheet.showRow(gljRow, GC.Spread.Sheets.VerticalPosition.center); sheet.setActiveCell(gljRow, 0); }, //根据费用定额的单价属性获取人材机的单价属性 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: 90, dataCode: "taxRate", dataType: "Number", hAlign: "center", vAlign: "center", }, { headerName: "损耗率", headerWidth: 90, dataCode: "lossRate", dataType: "Number", hAlign: "center", vAlign: "center", }, { headerName: "毛重系数", headerWidth: 90, dataCode: "grossWeightCoe", dataType: "Number", hAlign: "center", vAlign: "center", }, { headerName: "采购保管费率", headerWidth: 90, dataCode: "purchaseStorageRate", dataType: "Number", hAlign: "center", vAlign: "center", }, { headerName: "场外运输损耗率", headerWidth: 100, dataCode: "offSiteTransportLossRate", dataType: "Number", hAlign: "center", vAlign: "center", }, { headerName: "每增一次装卸损耗率", headerWidth: 100, dataCode: "handlingLossRate", 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(); } }, }); }, //获取工料机类型大类 getParentType: function (type) { return parseInt(type.toString()[0]); }, 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 ); let gljTypeCol = me.colMapping.fieldToCol["gljType"]; sheetCommonObj.setDynamicCombo( me.workBook.getActiveSheet(), 0, gljTypeCol, me.workBook.getActiveSheet().getRowCount(), me.distTypeTree.comboDatas, 10, "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" ) { 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 < me.setting.header.length; i++) { if (me.addGljObj[me.setting.header[i].dataCode]) { isHasData = true; break; } } } if (isHasData) { if (me.editingRowIdx !== me.cellRowIdx) { let focusToCol; function getFocusToCol(me) { if (!me.addGljObj.code) { $("#alertGljTxt").text("编号不能为空，继续增加人材机?"); return me.colMapping.fieldToCol["code"]; } else if (!me.addGljObj.name) { $("#alertGljTxt").text("名称不能为空，继续增加人材机?"); return me.colMapping.fieldToCol["name"]; } else if (!me.addGljObj.gljType) { $("#alertGljTxt").text("类型不能为空，继续增加人材机?"); return me.colMapping.fieldToCol["gljType"]; } else { return -1; } } focusToCol = getFocusToCol(me); if (focusToCol !== -1) { $("#gljAlertBtn").click(); $("#aleConfBtn").unbind("click"); $("#aleConfBtn").bind("click", function () { me.workBook.getSheet(0).setActiveCell(me.editingRowIdx, focusToCol); me.workBook.focus(true); }); $("#gljAleClose").click(function () { me.workBook.getSheet(0).setActiveCell(me.editingRowIdx, focusToCol); me.workBook.focus(true); }); $("#aleCanceBtn").unbind("click"); $("#aleCanceBtn").bind("click", function () { me.addGljObj = null; args.sheet.suspendEvent(); args.sheet.suspendPaint(); for (let col = 0; col < me.setting.header.length; col++) { if (col === 0) { me.workBook .getSheet(0) .getCell(me.editingRowIdx, 0) .formatter("@"); } me.workBook.getSheet(0).getCell(me.editingRowIdx, col).value(""); } me.workBook.getSheet(0).setActiveCell(me.editingRowIdx, 0); me.workBook.focus(true); args.sheet.resumeEvent(); args.sheet.resumePaint(); }); } } } }, onCellEditStart: function (sender, args) { let me = repositoryGljObj; me.orgCode = me.workBook .getSheet(0) .getValue(args.row, me.colMapping.fieldToCol["code"]); let rObj = sheetsOprObj.combineRowData( me.workBook.getSheet(0), me.setting, args.row, me ); if (me.prevent) { args.cancel = true; return; } me.currentEditingGlj = rObj; if (args.row < me.currentCache.length) { let dataCode = me.setting.header[args.col].dataCode; me.currentGlj = me.currentCache[args.row]; if ( dataCode === "code" || (me.feeDataCode.includes(dataCode) && me.getParentType(me.currentGlj.gljType) !== 2) ) { //费率数据列只有材料能用 args.cancel = true; } else { rObj.ID = me.currentGlj.ID; rObj.gljClass = me.currentGlj.gljClass; } } else { me.currentGlj = null; } }, dataChanged: function (objA, objB, col) { let me = repositoryGljObj; if (me.priceCols.includes(col)) { if (!priceProperties || priceProperties.length === 0) { return objA.basePrice !== objB.basePrice; } else { return ( objA.priceProperty[me.colMapping.colToField[col]] !== objB.priceProperty[me.colMapping.colToField[col]] ); } } return ( objA[me.colMapping.colToField[col]] !== objB[[me.colMapping.colToField[col]]] ); }, onCellEditEnd: function (sender, args) { let me = repositoryGljObj, that = gljComponentOprObj, updateArr = [], addArr = [], updateBasePrcArr = []; // 输入编号、名称、规格时，如果输入回车符或粘贴回车符，提交时应转换为空格。 let deESCFields = ["code", "name", "specs"]; let dataCode = me.setting.header[args.col].dataCode; if (deESCFields.includes(dataCode)) { args.editingText = me.isDef(args.editingText) ? args.editingText.toString().replace(/[\r\n]/g, " ") : ""; args.sheet.setValue(args.row, args.col, args.editingText); } let rObj = sheetsOprObj.combineRowData( me.workBook.getSheet(0), me.setting, args.row, me ); me.editingRowIdx = args.row; //rObj.basePrice = rObj.basePrice ? rObj.basePrice : 0; me.initPrice(rObj); //更新 if ( me.currentEditingGlj["ID"] !== null && me.currentEditingGlj["ID"] !== undefined && me.currentGlj ) { rObj["ID"] = me.currentEditingGlj["ID"]; rObj.gljClass = me.currentEditingGlj.gljClass; if (me.dataChanged(me.currentEditingGlj, rObj, args.col)) { if ( rObj.code && rObj.name && rObj.gljType && rObj.code.toString().trim().length !== 0 && rObj.name.toString().trim().length !== 0 && rObj.gljType.toString().trim().length !== 0 ) { if (rObj.gljType !== me.currentEditingGlj.gljType) { //修改了工料机类型 if (!$("#typeAlert").is(":visible")) { $("#typeAlert").modal("show"); } $("#typeConfirm").unbind("click"); $("#typeConfirm").bind("click", function () { $("#typeAlert").modal("hide"); if (me.currentGlj) { me.currentGlj.component = []; } //工料机类型不为材料时，情况费率数据 if ( me.getParentType(me.currentEditingGlj.gljType) === 2 && me.getParentType(rObj.gljType) !== 2 ) { for (let feeCode of me.feeDataCode) { if (me.currentEditingGlj[feeCode]) { rObj[feeCode] = null; } } } if ( componentType.includes(me.currentEditingGlj.gljType) && !( machineComponent.includes(me.currentEditingGlj.gljType) && machineComponent.includes(rObj.gljType) ) && !( materialComponent.includes(me.currentEditingGlj.gljType) && materialComponent.includes(rObj.gljType) ) ) { //修改了原本是组成物的工料机 //寻找所有引用了此组成物的工料机,并从组成物中删去此工料机,并重算单价 let updateGljs = me.getUpdateGljs(rObj, true); 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]); } } } 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 ( (me.feeDataCode.includes(dataCode) || dataCode === "lossRate") && rObj[dataCode] !== me.currentEditingGlj[dataCode] ) { if (isNaN(rObj[dataCode])) { args.sheet.setValue( args.row, args.col, me.currentEditingGlj[dataCode] ? me.currentEditingGlj[dataCode] : "" ); alert(`${me.setting.header[args.col].headerName}只能输入数值！`); return; } } else if (rObj.taxRate !== me.currentEditingGlj.taxRate) { if (isNaN(rObj.taxRate)) { args.sheet.setValue( args.row, args.col, me.currentEditingGlj.taxRate || "" ); alert("税率只能输入数值！"); return; } rObj.taxRate = scMathUtil.roundTo(parseFloat(rObj.taxRate), -2); } 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 (dataCode === "gljType") { let distTypeVal = me.distTypeTree.distTypes[ me.distTypeTree.prefix + me.currentEditingGlj[dataCode] ].data.fullName; args.sheet.setValue(args.row, args.col, distTypeVal); } else { args.sheet.setValue( args.row, args.col, me.currentEditingGlj[dataCode] ); } } } if (!me.priceIsEqual(rObj, me.currentEditingGlj)) { //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 = []; 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 { 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 () { if (locked) { return; } 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 ( locked || !(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]); }, }, getReference: { name: "查找引用", disabled: function () { return !(me.currentCache && me.currentCache[target.row]); }, icon: "fa-search", callback: function () { const glj = me.currentCache[target.row]; me.getReference(glj); }, }, getUsedInfo: { name: "查找用户使用情况", disabled: function () { return !(me.currentCache && me.currentCache[target.row]); }, icon: "fa-search", callback: function () { const glj = me.currentCache[target.row]; me.getUsedInfo(glj); }, }, }, }; } else { return false; } }, }); }, getReference: function (glj) { const $info = $("#info"); const $infoBody = $("#infoBody"); $.bootstrapLoading.start(); CommonAjax.post( "/stdGljRepository/api/getReference", { repositoryId: glj.repositoryId, gljId: glj.ID }, function (info) { const htmlArr = []; if (!info || !Object.keys(info).length) { htmlArr.push("
  • 无引用数据
    • "); } for (let libName in info) { htmlArr.push(`
  • ${libName}
    • `); const rations = info[libName]; const rationList = rations.map((ration) => { if (ration.rationRepId) { return `
  • ${ration.code} 定位
    • `; } return `
  • ${ration.code}
    • `; }); htmlArr.push(...rationList); } $infoBody.html(htmlArr.join("")); $info.modal("show"); $.bootstrapLoading.end(); }, function () { $.bootstrapLoading.end(); } ); }, getUsedInfo: function (glj) { $.bootstrapLoading.start(); $("#usedInfo").modal("show"); CommonAjax.post( "/stdGljRepository/api/getUsedInfo", { repositoryId: glj.repositoryId, gljId: glj.ID }, function (info) { $("#usedTotal").html(`共${info.length}项记录`); let htmlString = ""; for (let u of info) { htmlString += `${u.ID}${u.username} ${u.mobile}`; } $("#userInfoShowArea").html(htmlString); $.bootstrapLoading.end(); }, function () { $.bootstrapLoading.end(); } ); }, validUpdateObj: function (pasteObj, rowIdx) { let rst = { updateGlj: [], updateBasePrcArr: [] }, backUpObj = {}, me = repositoryGljObj, that = gljComponentOprObj, tempObj = me.currentCache[rowIdx], reCalBasePrc = false, isValid = 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.lossRate !== "undefined" && !isNaN(pasteObj.lossRate)) { tempObj.lossRate = pasteObj.lossRate; } if (typeof pasteObj.taxRate !== "undefined" && !isNaN(pasteObj.taxRate)) { tempObj.taxRate = pasteObj.taxRate; } 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 ( me.getParentType(pasteObj.gljType) !== 2 && me.getParentType(tempObj.gljType) === 2 ) { for (let feeCode of me.feeDataCode) { tempObj[feeCode] = null; } } if ( componentType.includes(tempObj.gljType) && !( 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 : []; tempObj.gljType = pasteObj.gljType; tempObj.shortName = me.distTypeTree.distTypes[ me.distTypeTree.prefix + tempObj.gljType ].data.shortName; break; } } if (!isExsit) { isValid = false; } } for (let feeCode of me.feeDataCode) { if ( typeof pasteObj[feeCode] !== "undefined" && !isNaN(pasteObj[feeCode]) ) { if ( (typeof pasteObj.gljType !== "undefined" && me.getParentType(pasteObj.gljType) === 2) || (tempObj.gljType && me.getParentType(tempObj.gljType) === 2) ) { tempObj[feeCode] = pasteObj[feeCode]; } 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 (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 (typeof pasteObj.lossRate !== "undefined" && isNaN(pasteObj[feeCode])) { return false; } for (let feeCode of me.feeDataCode) { if ( typeof pasteObj[feeCode] !== "undefined" && (isNaN(pasteObj[feeCode]) || me.getParentType(pasteObj.gljType) !== 2) ) { return false; } } 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) { 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 = updateArr.concat(updateObj.updateGlj); if (typeof updateObj.updateBasePrcArr !== "undefined") { 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 ); } } } //[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 >= 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 { 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) { const codeMap = {}; const uniqueCodeAddArr = []; addArr.forEach((item) => { if (!codeMap[item.code]) { codeMap[item.code] = 1; uniqueCodeAddArr.push(item); } }); addArr = uniqueCodeAddArr; 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 { const failCodes = result.data.failCode; if (failCodes && failCodes.length) { let failText = ""; failCodes.forEach((code) => { failText += `

    编码“${code}”已存在

    `; }); $("#alertText").html(failText); $("#codeAlert").modal("show"); } const insertData = result.data.insertData; me.updateCache(insertData, updateArr, removeIds); //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 (insertData, updateArr, removeIds) { let me = this, cacheSection = me.gljList; if (insertData && insertData.length > 0) { me.gljList = me.gljList.concat(insertData); 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); } } } 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; } //排序符号- 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(); }, };