/** * Created by Zhong on 2017/12/18. */ let pageOprObj = { refreshAllBooks: function () { if (sectionTreeObj.workBook) { sectionTreeObj.workBook.refresh(); } if (rationOprObj.workBook) { rationOprObj.workBook.refresh(); } if (coeOprObj.workBook) { coeOprObj.workBook.refresh(); } else { pageObj.initPage(); } if (gljAdjOprObj.workBook) { gljAdjOprObj.workBook.refresh(); } if (rationGLJOprObj.sheet.getParent()) { rationGLJOprObj.sheet.getParent().refresh(); } }, rationLibName : null, rationLibId : null, gljLibId: gljLibId, initPage : function() { let me = this; sectionTreeObj.getSectionTree(); //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')); gljSelOprObj.getGljClassTree(gljLibId, function () { gljSelOprObj.getSelGljItems(gljLibId); }); }, getRationLibInfo: function (rationLibId, callback) { CommonAjax.post('api/getRationLib', {rationRepId: 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'), type: {std: 'std', complementary: 'complementary'}, 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: { allowContextMenu: false, 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}); sheetCommonObj.spreadDefaultStyle(this.workBook); sheetCommonObj.bindEscKey(this.workBook, [{sheet: this.workBook.getSheet(0), editStarting: this.onEditStarting, editEnded: this.onEditEnded}]); this.sheet = this.workBook.getSheet(0); this.bindEvents(this.sheet); this.setOptions(this.workBook, this.setting.options); this.sheet.options.clipBoardOptions = GC.Spread.Sheets.ClipboardPasteOptions.values; } }, bindEvents: function (sheet) { let me = sectionTreeObj; const Events = GC.Spread.Sheets.Events; sheet.bind(Events.SelectionChanging, me.onSelectionChanging); sheet.bind(Events.EditEnded, me.onEditEnded); sheet.bind(Events.EditStarting, me.onEditStarting); sheet.bind(Events.ClipboardPasting, me.onClipboardPasting); sheet.bind(Events.ClipboardPasted, me.onClipboardPasted); }, onSelectionChanging: 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); } }, onEditStarting: function (sender, args) { }, 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, {ID: node.getID(), name: v}); 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 : ''); }); } }, onClipboardPasting: function (sender, info) { }, 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, {ID: node.getID(), name: items[i].name}); 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 : ''); } }); } }, loadRateWidth: function () { if (this.workBook) { sheetCommonObj.setColumnWidthByRate($('#sectionSpread').width() - 65, this.workBook, [{rateWidth: 1}]);//65: 列头宽度和垂直滚动条宽度和 } }, getSectionTree: function () { let me = sectionTreeObj; let url = 'api/getRationTree'; //type: 0-补充库 1-标准库 let postData = {type: 0}; 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.setColor(me.cache); me.sheet.setFormatter(-1, 0, '@'); me.initSelection(me.tree.selected); me.loadRateWidth(); //explanatoryOprObj.bindEvents($('#explanationShow'), $('#ruleTextShow')); }; let errFunc = function () { }; CommonAjax.post(url, postData, sucFunc, errFunc); }, setColor: function (nodes) { let me = this; me.renderFunc(me.sheet, function () { for(let i = 0, len = nodes.length; i < len; i++){ if(nodes[i].data.type === me.type.complementary){ me.sheet.getCell(i, 0).foreColor('gray'); } } }); }, 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(); }); $('#delConfirm').click(function () { if(me.canRemoveSection){ me.remove(me.tree.selected); } else { $('#delAlert').modal('hide'); } }); me.removeBtn.click(function () { //不可删除有子节点或有定额数据的节点 let section = me.cache[me.workBook.getActiveSheet().getActiveRowIndex()]; if(!section){ return; } let sectionName = me.isDef(section.data.name) ? section.data.name : ''; let sectionRations = rationOprObj.currentRations[`_SEC_ID_${section.data.ID}`]; if(section.children.length > 0 || (sectionRations && sectionRations.length > 0)){ me.canRemoveSection = false; $('#delAlert').find('.modal-body h5').text('当前节点下有数据,不可删除。'); } else { me.canRemoveSection = true; $('#delAlert').find('.modal-body h5').text(`确认要删除章节 “${sectionName}”吗?`); } $('#delAlert').modal('show'); }); 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 = sectionTreeObj; me.insertBtn.addClass('disabled'); let postData = [], newID = uuid.v1(); let selected = me.tree.selected; let insertObj = me.getUpdateObj(me.updateType.new, {ID: newID, NextSiblingID: -1, ParentID: -1, name: ''}); if(me.isDef(selected)) { let updateObj = me.getUpdateObj(me.updateType.update, {ID: selected.getID(), NextSiblingID: newID}); 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.insertByID(newID); me.refreshBtn(me.tree.selected); //fresh tools me.initTools(me.tree.selected); me.workBook.focus(); me.initSelection(me.tree.selected); }); } }, remove: function (selected) { let me = this; me.removeBtn.addClass('disabled'); let postData = [], IDs = [], deleteObj = { deleted: true, deleteDateTime: new Date(), deleteBy: userID }; 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, {ID: selected.preSibling.getID(), NextSiblingID: selected.getNextSiblingID()}); postData.push(updateObj); } if(IDs.length > 0){ for(let i = 0, len = IDs.length; i < len; i++){ let delObj = me.getUpdateObj(me.updateType.update, {ID: IDs[i], deleteInfo: deleteObj}); postData.push(delObj); } } if(postData.length > 0){ //ajax me.sectionTreeAjax(postData, function (rstData) { $('#delAlert').modal('hide'); me.removeRationsCodes(rationOprObj.currentRations["_SEC_ID_" + selected.data.ID]); me.controller.delete(); me.refreshBtn(me.tree.selected); me.initTools(me.tree.selected); me.initSelection(me.tree.selected); me.workBook.focus(); }); } }, removeRationsCodes: function (rations) { for(let ration of rations){ rationOprObj.rationsCodes.splice(rationOprObj.rationsCodes.indexOf(ration.code), 1); } }, upLevel: function (selected) { let me = this; me.upLevelBtn.addClass('disabled'); let postData = [], parent = selected.parent; if(!me.isDef(parent)){ return; } //更新父节点 postData.push(me.getUpdateObj(me.updateType.update, {ID: parent.getID(), NextSiblingID: selected.getID()})); //更新前节点 if(me.isDef(selected.preSibling)){ postData.push(me.getUpdateObj(me.updateType.update, {ID: selected.preSibling.getID(), NextSiblingID: -1})); } //更新选中节点的后兄弟节点 let nextIDs = []; getNext(selected); function getNext(node){ if(me.isDef(node.nextSibling)){ nextIDs.push(node.getNextSiblingID()); getNext(node.nextSibling); } } for(let nextID of nextIDs){ postData.push(me.getUpdateObj(me.updateType.update, {ID: nextID, ParentID: selected.getID()})); } //更新选中节点 postData.push(me.getUpdateObj(me.updateType.update, {ID: selected.getID(), NextSiblingID: parent.getNextSiblingID(), ParentID: parent.getParentID()})); if(postData.length > 0){ //ajax me.sectionTreeAjax(postData, function (rstData) { me.controller.upLevel(); me.refreshBtn(me.tree.selected); me.workBook.focus(); }); } }, downLevel: function (selected) { let me = this; me.downLevelBtn.addClass('disabled'); let postData = [], preSibling = selected.preSibling; if(!me.isDef(preSibling)){ return; } //更新前节点 postData.push(me.getUpdateObj(me.updateType.update, {ID: preSibling.getID(), NextSiblingID: selected.getNextSiblingID()})); //更新前节点最末子节点 if(preSibling.children.length > 0){ postData.push(me.getUpdateObj(me.updateType.update, {ID: preSibling.children[preSibling.children.length - 1].getID(), NextSiblingID: selected.getID()})); } //更新选中节点 postData.push(me.getUpdateObj(me.updateType.update, {ID: selected.getID(), NextSiblingID: -1, ParentID: preSibling.getID()})); if(postData.length > 0){ //ajax me.sectionTreeAjax(postData, function (rstData) { me.controller.downLevel(); me.refreshBtn(me.tree.selected); me.workBook.focus(); }); } }, 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, {ID: selected.getID(), NextSiblingID: selected.preSibling.getID()}); postData.push(updateObj); let updatePre = me.getUpdateObj(me.updateType.update, {ID: selected.preSibling.getID(), NextSiblingID: selected.getNextSiblingID()}); postData.push(updatePre); if(me.isDef(selected.preSibling.preSibling)){ let updatePrepre = me.getUpdateObj(me.updateType.update, {ID: selected.preSibling.preSibling.getID(), NextSiblingID: selected.getID()}); postData.push(updatePrepre); } if(postData.length > 0){ //ajax me.sectionTreeAjax(postData, function (rstData) { me.controller.upMove(); me.refreshBtn(me.tree.selected); me.workBook.focus(); }); } }, 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, {ID: selected.preSibling.getID(), NextSiblingID: selected.getNextSiblingID()}); postData.push(updatePre); } let updateObj = me.getUpdateObj(me.updateType.update, {ID: selected.getID(), NextSiblingID: selected.nextSibling.getNextSiblingID()}); postData.push(updateObj); let updateNext = me.getUpdateObj(me.updateType.update, {ID: selected.getNextSiblingID(), NextSiblingID: selected.getID()}); postData.push(updateNext); if(postData.length > 0){ //ajax me.sectionTreeAjax(postData, function (rstData) { me.controller.downMove(); me.refreshBtn(me.tree.selected); me.workBook.focus(); }); } }, getUpdateObj: function (updateType, updateData) { 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(updateData)){ for(let attr in updateData){ updateObj.updateData[attr] = updateData[attr]; } } return updateObj; }, sectionTreeAjax: function (postData, scFunc, errFunc) { CommonAjax.post('api/updateRationSection', {updateData: postData}, 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) { node.tree.selected = node ? node : null; let me = this; if(!me.isDef(node)){ sheetCommonObj.cleanSheet(rationOprObj.workBook.getActiveSheet(), rationOprObj.setting, -1); sheetCommonObj.cleanSheet(rationGLJOprObj.sheet, rationGLJOprObj.setting, -1); sheetCommonObj.cleanSheet(rationCoeOprObj.sheet, rationCoeOprObj.setting, -1); sheetCommonObj.cleanSheet(rationAssistOprObj.sheet, rationAssistOprObj.setting, -1); sheetCommonObj.cleanSheet(rationInstObj.sheet, rationInstObj.setting, -1); return; } me.workBook.getActiveSheet().setActiveCell(node.serialNo(), 0); 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, function () { rationOprObj.workBook.getActiveSheet().setActiveCell(0, 0); rationOprObj.rationSelInit(0, true); }); 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(rationCoeOprObj.sheet, rationCoeOprObj.setting, -1); sheetCommonObj.cleanSheet(rationAssistOprObj.sheet, rationAssistOprObj.setting, -1); sheetCommonObj.cleanSheet(rationInstObj.sheet, rationInstObj.setting, -1); } //rationGLJOprObj.sheet.getParent().focus(false); me.workBook.focus(true); } };