/** * Created by Zhong on 2017/12/18. */ let pageOprObj = { rationLibName : null, rationLibId : null, gljLibId: null, initPage : function() { let me = this, rationLibId = getQueryString("repository"); me.getRationLibInfo(rationLibId, function (rstData) { if(rstData.length > 0){ me.rationLibName = rstData[0].dispName; me.gljLibId = rstData[0].gljLib; if(!me.gljLibId || typeof me.gljLibId === 'undefined' || me.gljLibId == -1){ alert("没有引用工料机库!"); window.location.href = "/rationRepository/main"; } if (me.rationLibName) { var html = $("#rationname")[0].outerHTML; html = html.replace("XXX定额库", me.rationLibName); $("#rationname")[0].outerHTML = html; me.rationLibId = rationLibId; sectionTreeObj.getSectionTree(rationLibId); //job jobContentOprObj.radiosChange(jobContentOprObj.radios, jobContentOprObj.tableAll, jobContentOprObj.tablePartial); $('#addConBtn').click(jobContentOprObj.bindAddConBtn()); $('#updateConBtn').click(jobContentOprObj.bindUpdateConBtn()); jobContentOprObj.bindAllEvents($('#txtareaAll')); //fz annotationOprObj.radiosChange(annotationOprObj.radios, annotationOprObj.fzTableAll, annotationOprObj.fzTablePartial); $('#fzAddConBtn').click(annotationOprObj.bindAddConBtn()); $('#fzUpdateConBtn').click(annotationOprObj.bindUpdateConBtn()); annotationOprObj.bindAllEvents($('#fzTxtareaAll')); } } }); }, getRationLibInfo: function (rationLibId, callback) { CommonAjax.post('api/getRationLib', {libId: rationLibId}, callback); } } let sectionTreeObj = { cache: null,//ref to tree.items tree: null, controller: null, workBook: null, sheet: null, updateType: {new: 'new', update: 'update'}, insertBtn: $('#tree_Insert'), removeBtn: $('#tree_remove'), upLevelBtn: $('#tree_upLevel'), downLevelBtn: $('#tree_downLevel'), downMoveBtn: $('#tree_downMove'), upMoveBtn: $('#tree_upMove'), setting: { sheet: { cols:[ { head: { titleNames: ['名称'], spanCols: [1], spanRows: [2], vAlign: [1, 1], hAlign: [1, 1], font: 'Arial' }, data: { field: 'name', vAlign: 1, hAlign: 0, font: 'Arial' }, width: 400 } ], headRows: 1, headRowHeight: [47], emptyRows: 0, treeCol: 0 }, tree: { id: 'ID', pid: 'ParentID', nid: 'NextSiblingID', rootId: -1 }, options: { tabStripVisible: false, allowCopyPasteExcelStyle : false, allowExtendPasteRange: false, allowUserDragDrop : false, allowUserDragFill: false, scrollbarMaxAlign : true } }, isDef: function (v) { return v !== undefined && v !== null; }, isFunc: function (v) { return this.isDef(v) && typeof v === 'function'; }, //sheet things setOptions: function (workbook, opts) { for(let opt in opts){ workbook.options[opt] = opts[opt]; } }, renderFunc: function (sheet, func) { sheet.suspendPaint(); sheet.suspendEvent(); if(this.isFunc(func)){ func(); } sheet.resumePaint(); sheet.resumeEvent(); }, buildSheet: function () { if(!this.isDef(this.workBook)){ this.workBook = new GC.Spread.Sheets.Workbook($('#sectionSpread')[0], {sheetCount: 1}); this.sheet = this.workBook.getActiveSheet(); this.setOptions(this.workBook, this.setting.options); this.sheet.options.clipBoardOptions = GC.Spread.Sheets.ClipboardPasteOptions.values; this.bindEvents(this.sheet); } }, bindEvents: function (sheet) { let me = sectionTreeObj; const Events = GC.Spread.Sheets.Events; sheet.bind(Events.SelectionChanged, me.onSelectionChanged); sheet.bind(Events.EditEnded, me.onEditEnded); sheet.bind(Events.ClipboardPasted, me.onClipboardPasted); }, onSelectionChanged: function (sender, info) { let me = sectionTreeObj; if(info.oldSelections.length === 0 && info.newSelections.length > 0 || info.oldSelections[0].row !== info.newSelections[0].row){ let row = info.newSelections[0].row; let section = me.cache[row]; me.initSelection(section); } else { me.refreshBtn(null); } }, onEditEnded: function (sender, args) { let me = sectionTreeObj; let postData = []; let v = me.isDef(args.editingText) ? args.editingText.toString().trim() : ''; let node = me.cache[args.row]; if(me.isDef(node) && node.data.name !== v){ let updateObj = me.getUpdateObj(me.updateType.update, node.getID(), null, null, v, null); postData.push(updateObj); //ajax //update me.sectionTreeAjax(postData, function (rstData) { node.data.name = v; }, function () { args.sheet.setValue(args.row, args.col, node.data.name ? node.data.name : ''); }); } }, onClipboardPasted: function (sender, info) { let me = sectionTreeObj; let items = sheetCommonObj.analyzePasteData({header: [{dataCode: 'name'}]}, info); let postData = []; let frontData = []; for(let i = 0, len = items.length; i < len; i++){ let row = info.cellRange.row + i; let node = me.cache[row]; if(me.isDef(node) && me.isDef(items[i].name) && node.data.name !== items[i].name){ let updateObj = me.getUpdateObj(me.updateType.update, node.getID(), null, null, items[i].name, null); postData.push(updateObj); frontData.push({row: row, name: items[i].name}); node.data.name = items[i].name; } } if(postData.length > 0){ //ajax me.sectionTreeAjax(postData, function (rstData) { for(let i = 0, len = frontData.length; i < len; i++){ let node = me.cache[frontData[i]['row']]; if(me.isDef(node)){ node.data.name = frontData[i]['name']; } } }, function () { for(let i = 0, len = frontData.length; i < len; i++){ let node = me.cache[frontData[i]['row']]; me.sheet.setValue(frontData[i]['row'], 0, me.isDef(node) ? node.data.name : ''); } }); } }, getSectionTree: function (repId) { let me = sectionTreeObj; let url = 'api/getRationTree'; let postData = {rationLibId: repId}; let sucFunc = function (rstData) { if(rstData.length > 0){ storageUtil.setSessionCache("RationGrp","repositoryID",rstData[0].rationRepId); } //init me.buildSheet(); me.initTree(rstData); me.cache = me.tree.items; me.bindBtn(); me.initController(me.tree, me.sheet, me.setting.sheet); me.controller.showTreeData(); me.sheet.setFormatter(-1, 0, '@'); me.initSelection(me.tree.selected); explanatoryOprObj.bindEvents($('#explanationShow'), $('#ruleTextShow')); }; let errFunc = function () { }; CommonAjax.post(url, postData, sucFunc, errFunc); }, initTree: function (datas) { this.tree = idTree.createNew(this.setting.tree); this.tree.loadDatas(datas); this.tree.selected = this.tree.items.length > 0 ? this.tree.items[0] : null; }, initController: function (tree, sheet, setting) { this.controller = TREE_SHEET_CONTROLLER.createNew(tree, sheet, setting); }, refreshBtn: function (selected) { let me = this; me.insertBtn.removeClass('disabled'); me.removeBtn.removeClass('disabled'); me.upLevelBtn.removeClass('disabled'); me.downLevelBtn.removeClass('disabled'); me.downMoveBtn.removeClass('disabled'); me.upMoveBtn.removeClass('disabled'); if(!me.isDef(selected)){ me.removeBtn.addClass('disabled'); me.upLevelBtn.addClass('disabled'); me.downLevelBtn.addClass('disabled'); me.downMoveBtn.addClass('disabled'); me.upMoveBtn.addClass('disabled'); } else { if(!me.isDef(selected.preSibling)){ me.downLevelBtn.addClass('disabled'); me.upMoveBtn.addClass('disabled'); } if(!me.isDef(selected.nextSibling)){ me.downMoveBtn.addClass('disabled'); } if(!me.isDef(selected.parent)){ me.upLevelBtn.addClass('disabled'); } } }, bindBtn: function () { let me = this; me.insertBtn.click(function () { me.insert(); }); me.removeBtn.click(function () { me.remove(me.tree.selected); }); me.upLevelBtn.click(function () { me.upLevel(me.tree.selected); }); me.downLevelBtn.click(function () { me.downLevel(me.tree.selected); }); me.downMoveBtn.click(function () { me.downMove(me.tree.selected); }); me.upMoveBtn.click(function () { me.upMove(me.tree.selected); }); }, insert: function () { let me = this; me.insertBtn.addClass('disabled'); let postData = []; CommonAjax.post('api/getNewRationTreeID', {}, function (newID) { if(!me.isDef(newID)){ return; } me.tree.maxNodeID(newID - 1); let selected = me.tree.selected; let insertObj = me.getUpdateObj(me.updateType.new, newID, -1, -1, '', null); if(me.isDef(selected)) { let updateObj = me.getUpdateObj(me.updateType.update, selected.getID(), newID, null, null, null); postData.push(updateObj); insertObj.updateData.ParentID = selected.getParentID(); if(me.isDef(selected.nextSibling)){ insertObj.updateData.NextSiblingID = selected.getNextSiblingID(); } } postData.push(insertObj); if(postData.length > 0){ //ajax me.sectionTreeAjax(postData, function (rstData) { me.controller.insert(); me.refreshBtn(me.tree.selected); //fresh tools me.initTools(me.tree.selected); }); } }); }, remove: function (selected) { let me = this; me.removeBtn.addClass('disabled'); let postData = [], IDs = []; if(!selected){ return; } getDelIds(selected); function getDelIds(node){ if(me.isDef(node)){ IDs.push(node.getID()); if(node.children.length > 0){ for(let i = 0, len = node.children.length; i < len; i++){ getDelIds(node.children[i]); } } } } if(me.isDef(selected.preSibling)){ let updateObj = me.getUpdateObj(me.updateType.update, selected.preSibling.getID(), selected.getNextSiblingID(), null, null, null); postData.push(updateObj); } if(IDs.length > 0){ for(let i = 0, len = IDs.length; i < len; i++){ let delObj = me.getUpdateObj(me.updateType.update, IDs[i], null, null, null, true); postData.push(delObj); } } if(postData.length > 0){ //ajax me.sectionTreeAjax(postData, function (rstData) { me.controller.delete(); me.refreshBtn(me.tree.selected); me.initTools(me.tree.selected); }); } }, upLevel: function (selected) { let me = this; me.upLevelBtn.addClass('disabled'); let postData = []; if(!me.isDef(selected)){ return; } if(!me.isDef(selected.parent)){ return; } if(me.isDef(selected.preSibling)){ let updateObj = me.getUpdateObj(me.updateType.update, selected.preSibling.getID(), -1, null, null, null); postData.push(updateObj); } let updateObj = me.getUpdateObj(me.updateType.update, selected.getID(), selected.parent.getNextSiblingID(), selected.parent.getParentID(), null, null); postData.push(updateObj); let updateParent = me.getUpdateObj(me.updateType.update, selected.getParentID(), selected.getID(), null, null, null); postData.push(updateParent); let nextIDs = []; getNext(selected); function getNext(node){ if(me.isDef(node.nextSibling)){ nextIDs.push(node.getNextSiblingID()); getNext(node.nextSibling); } } for(let i = 0, len = nextIDs.length; i < len; i++){ postData.push(me.getUpdateObj(me.updateType.update, nextIDs[i], null, selected.getID(), null, null)); } if(postData.length > 0){ //ajax me.sectionTreeAjax(postData, function (rstData) { me.controller.upLevel(); me.refreshBtn(me.tree.selected); }); } }, downLevel: function (selected) { let me = this; me.downLevelBtn.addClass('disabled'); let postData = []; if(!me.isDef(selected)){ return; } if(!me.isDef(selected.preSibling)){ return; } let updatePre = me.getUpdateObj(me.updateType.update, selected.preSibling.getID(), selected.getNextSiblingID(), null, null, null); postData.push(updatePre); if(selected.preSibling.children.length > 0){ let updateObj = me.getUpdateObj(me.updateType.update, selected.preSibling.children[selected.preSibling.children.length - 1].getID(), selected.getID(), null, null, null); postData.push(updateObj); } let updateObj = me.getUpdateObj(me.updateType.update, selected.getID(), -1, selected.preSibling.getID(), null, null); postData.push(updateObj); if(postData.length > 0){ //ajax me.sectionTreeAjax(postData, function (rstData) { me.controller.downLevel(); me.refreshBtn(me.tree.selected); }); } }, upMove: function (selected) { let me = this; me.upMoveBtn.addClass('disabled'); let postData = []; if(!me.isDef(selected)){ return; } if(!me.isDef(selected.preSibling)){ return; } let updateObj = me.getUpdateObj(me.updateType.update, selected.getID(), selected.preSibling.getID(), null, null, null); postData.push(updateObj); let updatePre = me.getUpdateObj(me.updateType.update, selected.preSibling.getID(), selected.getNextSiblingID(), null, null, null); postData.push(updatePre); if(me.isDef(selected.preSibling.preSibling)){ let updatePrepre = me.getUpdateObj(me.updateType.update, selected.preSibling.preSibling.getID(), selected.getID(), null, null, null); postData.push(updatePrepre); } if(postData.length > 0){ //ajax me.sectionTreeAjax(postData, function (rstData) { me.controller.upMove(); me.refreshBtn(me.tree.selected); }); } }, downMove: function (selected) { let me = this; me.downMoveBtn.addClass('disabled'); let postData = []; if(!me.isDef(selected)){ return; } if(!me.isDef(selected.nextSibling)){ return; } if(me.isDef(selected.preSibling)){ let updatePre = me.getUpdateObj(me.updateType.update, selected.preSibling.getID(), selected.getNextSiblingID(), null, null, null); postData.push(updatePre); } let updateObj = me.getUpdateObj(me.updateType.update, selected.getID(), selected.nextSibling.getNextSiblingID(), null, null, null); postData.push(updateObj); let updateNext = me.getUpdateObj(me.updateType.update, selected.getNextSiblingID(), selected.getID(), null, null, null); postData.push(updateNext); if(postData.length > 0){ //ajax me.sectionTreeAjax(postData, function (rstData) { me.controller.downMove(); me.refreshBtn(me.tree.selected); }); } }, getUpdateObj: function (updateType, id, nid, pid, name, deleted) { let updateObj = Object.create(null); updateObj.updateType = ''; updateObj.updateData = Object.create(null); updateObj.updateData.rationRepId = pageOprObj.rationLibId; if(this.isDef(updateType)){ updateObj.updateType = updateType; } if(this.isDef(id)){ updateObj.updateData.ID = id; } if(this.isDef(nid)){ updateObj.updateData.NextSiblingID = nid; } if(this.isDef(pid)){ updateObj.updateData.ParentID = pid; } if(this.isDef(name)){ updateObj.updateData.name = name; } if(this.isDef(deleted)){ updateObj.updateData.isDeleted = true; } return updateObj; }, sectionTreeAjax: function (postData, scFunc, errFunc) { CommonAjax.post('api/updateNodes', {updateData: postData, lastOpr: userAccount}, scFunc, errFunc); }, initTools: function (node) { if(this.isDef(node)){ explanatoryOprObj.setAttribute(explanatoryOprObj.currentTreeNode ? explanatoryOprObj.currentTreeNode : node, node, node.data.explanation, node.data.ruleText); explanatoryOprObj.clickUpdate($('#explanationShow'), $('#ruleTextShow')); explanatoryOprObj.showText($('#explanationShow'), $('#ruleTextShow'), node.data.explanation, node.data.ruleText); //job jobContentOprObj.currentSituation = typeof node.data.jobContentSituation !== 'undefined'? node.data.jobContentSituation : jobContentOprObj.situations.NONE; jobContentOprObj.setAttribute(jobContentOprObj.currentTreeNode ? jobContentOprObj.currentTreeNode : node, node); jobContentOprObj.clickUpdate($('#txtareaAll')); //fz annotationOprObj.currentSituation = typeof node.data.annotationSituation !== 'undefined'? node.data.annotationSituation : annotationOprObj.situations.NONE; annotationOprObj.clickUpdate($('#fzTxtareaAll')); } }, //模仿默认点击 initSelection: function (node) { let me = this; if(!me.isDef(node)){ return; } me.initTools(node); me.refreshBtn(node); if(!me.isDef(node.children) || node.children.length === 0){ rationOprObj.canRations = true; rationOprObj.workBook.getSheet(0).clearSelection(); rationOprObj.getRationItems(node.data.ID); rationOprObj.setCombo(rationOprObj.workBook.getSheet(0), 'dynamic'); } else { rationOprObj.canRations = false; rationOprObj.currentSectionId = node.data.ID; rationOprObj.workBook.getSheet(0).setRowCount(30); rationOprObj.setCombo(rationOprObj.workBook.getSheet(0), null); jobContentOprObj.setRadiosDisabled(true, jobContentOprObj.radios); jobContentOprObj.hideTable($('#tableAll'), $('#tablePartial')); annotationOprObj.setRadiosDisabled(true, annotationOprObj.radios); annotationOprObj.hideTable($('#fzTableAll'), $('#fzTablePartial')); sheetCommonObj.cleanSheet(rationOprObj.workBook.getSheet(0), rationOprObj.setting, -1); sheetCommonObj.cleanSheet(rationGLJOprObj.sheet, rationGLJOprObj.setting, -1); sheetCommonObj.cleanSheet(rationAssistOprObj.sheet, rationAssistOprObj.setting, -1); sheetCommonObj.cleanSheet(rationCoeOprObj.sheet, rationCoeOprObj.setting, -1); sheetCommonObj.cleanSheet(rationInstObj.sheet, rationInstObj.setting, -1); rationGLJOprObj.sheet.getParent().focus(false); } me.workBook.focus(true); } };