1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900 |
- /**
- * 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: "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(
- "<a href='/stdGljRepository/main'>人材机库</a><i class='fa fa-angle-right fa-fw'></i>" + 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) && 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 (!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('<li>无引用数据</li>');
- }
- for (let libName in info) {
- htmlArr.push(`<li class="list-title">${libName}</li>`);
- const rations = info[libName];
- const rationList = rations.map(ration => {
- if (ration.rationRepId) {
- return `<li>
- <span>${ration.code}</span>
- <a target="_blank" href="/rationRepository/ration?repository=${ration.rationRepId}&locked=${locked}#${ration.code}">定位</a>
- </li>`;
- }
- return `<li><span>${ration.code}</span></li>`;
- });
- 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 += `<tr><td>${u.ID}</td><td>${u.username}</td> <td>${u.mobile}</td></tr>`;
- }
- $("#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.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;
- }
- }
- }
- 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 += `<p>编码“${code}”已存在</p>`;
- });
- $('#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 = "<span class='button add' id='addBtn_" + treeNode.tId + "' title='新增子节点' onfocus='this.blur();'></span>";
- 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();
- }
- };
|