123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523 |
- /**
- * Created by Zhong on 2018/1/16.
- */
- let gljClassTreeObj = {
- 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: [30],
- emptyRows: 0,
- treeCol: 0
- },
- tree: {
- id: 'ID',
- pid: 'ParentID',
- nid: 'NextSiblingID',
- rootId: -1
- },
- options: {
- tabStripVisible: false,
- allowContextMenu: 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($('#gljClassSpread')[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 = gljClassTreeObj;
- 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 = gljClassTreeObj;
- if(info.oldSelections.length === 0 && info.newSelections.length > 0 || info.oldSelections[0].row !== info.newSelections[0].row){
- let row = info.newSelections[0].row;
- let node = me.cache[row];
- me.initSelection(node);
- }
- else {
- me.refreshBtn(null);
- }
- },
- onEditEnded: function (sender, args) {
- let me = gljClassTreeObj;
- 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.gljClassTreeAjax(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 = gljClassTreeObj;
- 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.gljClassTreeAjax(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 : '');
- }
- });
- }
- },
- getGljClassTree: function (gljLibId, callback) {
- let me = gljClassTreeObj;
- let re = repositoryGljObj;
- let url = 'api/getGljTree';
- let postData = {gljLibId: gljLibId};
- let sucFunc = function (rstData) {
- zTreeHelper.createTree(rstData, componentSetting, "componentTree", componentOprObj);
- let rootNode = componentOprObj.treeObj.getNodes()[0];
- if(rootNode && rootNode.isParent && rootNode.isFirstNode){
- componentOprObj.rootNode = rootNode;
- }
- if (rstData && rstData.length > 0) {
- me.gljCurTypeId = rstData[0].ID;
- }
- //init
- me.buildSheet();
- me.initTree(rstData);
- me.cache = me.tree.items;
- re.updateParentNodeIds(me.cache, re);
- me.bindBtn();
- me.initController(me.tree, me.sheet, me.setting.sheet);
- me.controller.showTreeData();
- me.sheet.setFormatter(-1, 0, '@');
- me.initSelection(me.tree.selected);
- if(callback){
- callback();
- }
- };
- 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();
- });
- $('#delConfirm').click(function () {
- if(me.canRemoveClass){
- me.remove(me.tree.selected);
- }
- $('#delAlert').modal('hide');
- });
- me.removeBtn.click(function () {
- //当前分类下无子项且无工料机数据,才允许删除
- let classNode = me.cache[me.workBook.getActiveSheet().getActiveRowIndex()];
- if(!classNode){
- return;
- }
- let className = me.isDef(classNode.data.Name) ? classNode.data.Name : '';
- let classGljs = repositoryGljObj.currentCache;
- if(classNode.children.length > 0 || (classGljs && classGljs.length > 0)){
- me.canRemoveClass = false;
- $('#delAlert').find('.modal-body h5').text('当前分类下有数据,不可删除。');
- }
- else {
- me.canRemoveClass = true;
- $('#delAlert').find('.modal-body h5').text(`确认要删除分类 “${className}”吗?`);
- }
- $('#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 = this;
- let re = repositoryGljObj;
- me.insertBtn.addClass('disabled');
- let postData = [];
- let newID = me.tree.newNodeID();
- if(!me.isDef(newID)){
- return;
- }
- 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.gljClassTreeAjax(postData, function (rstData) {
- me.controller.insert();
- me.refreshBtn(me.tree.selected);
- //fresh tools
- re.updateParentNodeIds(me.cache, re);
- me.initSelection(me.tree.selected);
- });
- }
- },
- remove: function (selected) {
- let me = this;
- let re = repositoryGljObj;
- 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.gljClassTreeAjax(postData, function (rstData) {
- me.controller.delete();
- me.refreshBtn(me.tree.selected);
- re.updateParentNodeIds(me.cache, re);
- me.initSelection(me.tree.selected);
- me.workBook.getActiveSheet().setActiveCell(me.tree.selected ? me.tree.selected.serialNo() : 0, 0);
- });
- }
- },
- upLevel: function (selected) {
- let me = this;
- let re = repositoryGljObj;
- 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.gljClassTreeAjax(postData, function (rstData) {
- me.controller.upLevel();
- me.refreshBtn(me.tree.selected);
- re.updateParentNodeIds(me.cache, re);
- });
- }
- },
- downLevel: function (selected) {
- let me = this;
- let re = repositoryGljObj;
- 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.gljClassTreeAjax(postData, function (rstData) {
- me.controller.downLevel();
- me.refreshBtn(me.tree.selected);
- re.updateParentNodeIds(me.cache, re);
- });
- }
- },
- 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.gljClassTreeAjax(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.gljClassTreeAjax(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.repositoryId = pageOprObj.gljLibId;
- 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.deleted = true;
- }
- return updateObj;
- },
- gljClassTreeAjax: function (postData, scFunc, errFunc) {
- CommonAjax.post('api/updateNodes', {updateData: postData, lastOpr: userAccount}, scFunc, errFunc);
- },
- //模仿默认点击
- initSelection: function (node) {
- let me = this,
- re = repositoryGljObj,
- that = gljComponentOprObj;
- me.refreshBtn(node);
- if(!re.isDef(node)){
- return;
- }
- let gljTypeId = node.data.ID;
- re.gljCurTypeId = node.data.ID;
- re.addGljObj = null;
- sheetCommonObj.cleanSheet(that.workBook.getSheet(0), that.setting, 10);
- if (re.parentNodeIds["_pNodeId_" + gljTypeId]) {
- re.currentOprParent = 1;
- re.currentCache = re.getParentCache(re.parentNodeIds["_pNodeId_" + gljTypeId]);
- re.workBook.getSheet(0).setRowCount(re.currentCache.length);
- } else {
- re.currentOprParent = 0;
- re.currentCache = re.getCache();
- }
- re.showGljItems(re.currentCache, gljTypeId);
- me.workBook.focus(true);
- }
- }
|