gljClassTree.js 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502
  1. /**
  2. * Created by Zhong on 2018/1/16.
  3. */
  4. let gljClassTreeObj = {
  5. cache: null,//ref to tree.items
  6. tree: null,
  7. controller: null,
  8. workBook: null,
  9. sheet: null,
  10. updateType: {new: 'new', update: 'update'},
  11. insertBtn: $('#tree_Insert'),
  12. removeBtn: $('#tree_remove'),
  13. upLevelBtn: $('#tree_upLevel'),
  14. downLevelBtn: $('#tree_downLevel'),
  15. downMoveBtn: $('#tree_downMove'),
  16. upMoveBtn: $('#tree_upMove'),
  17. setting: {
  18. sheet: {
  19. cols:[
  20. {
  21. head: {
  22. titleNames: ['名称'],
  23. spanCols: [1],
  24. spanRows: [2],
  25. vAlign: [1, 1],
  26. hAlign: [1, 1],
  27. font: 'Arial'
  28. },
  29. data: {
  30. field: 'Name',
  31. vAlign: 1,
  32. hAlign: 0,
  33. font: 'Arial'
  34. },
  35. width: 400
  36. }
  37. ],
  38. headRows: 1,
  39. headRowHeight: [30],
  40. emptyRows: 0,
  41. treeCol: 0
  42. },
  43. tree: {
  44. id: 'ID',
  45. pid: 'ParentID',
  46. nid: 'NextSiblingID',
  47. rootId: -1
  48. },
  49. options: {
  50. tabStripVisible: false,
  51. allowContextMenu: false,
  52. allowCopyPasteExcelStyle : false,
  53. allowExtendPasteRange: false,
  54. allowUserDragDrop : false,
  55. allowUserDragFill: false,
  56. scrollbarMaxAlign : true
  57. }
  58. },
  59. isDef: function (v) {
  60. return v !== undefined && v !== null;
  61. },
  62. isFunc: function (v) {
  63. return this.isDef(v) && typeof v === 'function';
  64. },
  65. //sheet things
  66. setOptions: function (workbook, opts) {
  67. for(let opt in opts){
  68. workbook.options[opt] = opts[opt];
  69. }
  70. },
  71. renderFunc: function (sheet, func) {
  72. sheet.suspendPaint();
  73. sheet.suspendEvent();
  74. if(this.isFunc(func)){
  75. func();
  76. }
  77. sheet.resumePaint();
  78. sheet.resumeEvent();
  79. },
  80. buildSheet: function () {
  81. if(!this.isDef(this.workBook)){
  82. this.workBook = new GC.Spread.Sheets.Workbook($('#gljClassSpread')[0], {sheetCount: 1});
  83. this.sheet = this.workBook.getActiveSheet();
  84. this.setOptions(this.workBook, this.setting.options);
  85. this.sheet.options.clipBoardOptions = GC.Spread.Sheets.ClipboardPasteOptions.values;
  86. this.bindEvents(this.sheet);
  87. }
  88. },
  89. bindEvents: function (sheet) {
  90. let me = gljClassTreeObj;
  91. const Events = GC.Spread.Sheets.Events;
  92. sheet.bind(Events.SelectionChanged, me.onSelectionChanged);
  93. sheet.bind(Events.EditEnded, me.onEditEnded);
  94. sheet.bind(Events.ClipboardPasted, me.onClipboardPasted);
  95. },
  96. onSelectionChanged: function (sender, info) {
  97. let me = gljClassTreeObj;
  98. if(info.oldSelections.length === 0 && info.newSelections.length > 0 || info.oldSelections[0].row !== info.newSelections[0].row){
  99. let row = info.newSelections[0].row;
  100. let node = me.cache[row];
  101. me.initSelection(node);
  102. }
  103. else {
  104. me.refreshBtn(null);
  105. }
  106. },
  107. onEditEnded: function (sender, args) {
  108. let me = gljClassTreeObj;
  109. let postData = [];
  110. let v = me.isDef(args.editingText) ? args.editingText.toString().trim() : '';
  111. let node = me.cache[args.row];
  112. if(me.isDef(node) && node.data.Name !== v){
  113. let updateObj = me.getUpdateObj(me.updateType.update, node.getID(), null, null, v, null);
  114. postData.push(updateObj);
  115. //ajax
  116. //update
  117. me.gljClassTreeAjax(postData, function (rstData) {
  118. node.data.Name = v;
  119. }, function () {
  120. args.sheet.setValue(args.row, args.col, node.data.Name ? node.data.Name : '');
  121. });
  122. }
  123. },
  124. onClipboardPasted: function (sender, info) {
  125. let me = gljClassTreeObj;
  126. let items = sheetCommonObj.analyzePasteData({header: [{dataCode: 'Name'}]}, info);
  127. let postData = [];
  128. let frontData = [];
  129. for(let i = 0, len = items.length; i < len; i++){
  130. let row = info.cellRange.row + i;
  131. let node = me.cache[row];
  132. if(me.isDef(node) && me.isDef(items[i].Name) && node.data.Name !== items[i].Name){
  133. let updateObj = me.getUpdateObj(me.updateType.update, node.getID(), null, null, items[i].Name, null);
  134. postData.push(updateObj);
  135. frontData.push({row: row, Name: items[i].Name});
  136. node.data.Name = items[i].Name;
  137. }
  138. }
  139. if(postData.length > 0){
  140. //ajax
  141. me.gljClassTreeAjax(postData, function (rstData) {
  142. for(let i = 0, len = frontData.length; i < len; i++){
  143. let node = me.cache[frontData[i]['row']];
  144. if(me.isDef(node)){
  145. node.data.Name = frontData[i]['Name'];
  146. }
  147. }
  148. }, function () {
  149. for(let i = 0, len = frontData.length; i < len; i++){
  150. let node = me.cache[frontData[i]['row']];
  151. me.sheet.setValue(frontData[i]['row'], 0, me.isDef(node) ? node.data.Name : '');
  152. }
  153. });
  154. }
  155. },
  156. getGljClassTree: function (gljLibId, callback) {
  157. let me = gljClassTreeObj;
  158. let re = repositoryGljObj;
  159. let url = 'api/getGljTree';
  160. let postData = {gljLibId: gljLibId};
  161. let sucFunc = function (rstData) {
  162. zTreeHelper.createTree(rstData, componentSetting, "componentTree", componentOprObj);
  163. let rootNode = componentOprObj.treeObj.getNodes()[0];
  164. if(rootNode && rootNode.isParent && rootNode.isFirstNode){
  165. componentOprObj.rootNode = rootNode;
  166. }
  167. if (rstData && rstData.length > 0) {
  168. me.gljCurTypeId = rstData[0].ID;
  169. }
  170. //init
  171. me.buildSheet();
  172. me.initTree(rstData);
  173. me.cache = me.tree.items;
  174. re.updateParentNodeIds(me.cache, re);
  175. me.bindBtn();
  176. me.initController(me.tree, me.sheet, me.setting.sheet);
  177. me.controller.showTreeData();
  178. me.sheet.setFormatter(-1, 0, '@');
  179. me.initSelection(me.tree.selected);
  180. if(callback){
  181. callback();
  182. }
  183. };
  184. let errFunc = function () {
  185. };
  186. CommonAjax.post(url, postData, sucFunc, errFunc);
  187. },
  188. initTree: function (datas) {
  189. this.tree = idTree.createNew(this.setting.tree);
  190. this.tree.loadDatas(datas);
  191. this.tree.selected = this.tree.items.length > 0 ? this.tree.items[0] : null;
  192. },
  193. initController: function (tree, sheet, setting) {
  194. this.controller = TREE_SHEET_CONTROLLER.createNew(tree, sheet, setting);
  195. },
  196. refreshBtn: function (selected) {
  197. let me = this;
  198. me.insertBtn.removeClass('disabled');
  199. me.removeBtn.removeClass('disabled');
  200. me.upLevelBtn.removeClass('disabled');
  201. me.downLevelBtn.removeClass('disabled');
  202. me.downMoveBtn.removeClass('disabled');
  203. me.upMoveBtn.removeClass('disabled');
  204. if(!me.isDef(selected)){
  205. me.removeBtn.addClass('disabled');
  206. me.upLevelBtn.addClass('disabled');
  207. me.downLevelBtn.addClass('disabled');
  208. me.downMoveBtn.addClass('disabled');
  209. me.upMoveBtn.addClass('disabled');
  210. }
  211. else {
  212. if(!me.isDef(selected.preSibling)){
  213. me.downLevelBtn.addClass('disabled');
  214. me.upMoveBtn.addClass('disabled');
  215. }
  216. if(!me.isDef(selected.nextSibling)){
  217. me.downMoveBtn.addClass('disabled');
  218. }
  219. if(!me.isDef(selected.parent)){
  220. me.upLevelBtn.addClass('disabled');
  221. }
  222. }
  223. },
  224. bindBtn: function () {
  225. let me = this;
  226. me.insertBtn.click(function () {
  227. me.insert();
  228. });
  229. me.removeBtn.click(function () {
  230. me.remove(me.tree.selected);
  231. });
  232. me.upLevelBtn.click(function () {
  233. me.upLevel(me.tree.selected);
  234. });
  235. me.downLevelBtn.click(function () {
  236. me.downLevel(me.tree.selected);
  237. });
  238. me.downMoveBtn.click(function () {
  239. me.downMove(me.tree.selected);
  240. });
  241. me.upMoveBtn.click(function () {
  242. me.upMove(me.tree.selected);
  243. });
  244. },
  245. insert: function () {
  246. let me = this;
  247. let re = repositoryGljObj;
  248. me.insertBtn.addClass('disabled');
  249. let postData = [];
  250. let newID = me.tree.newNodeID();
  251. if(!me.isDef(newID)){
  252. return;
  253. }
  254. let selected = me.tree.selected;
  255. let insertObj = me.getUpdateObj(me.updateType.new, newID, -1, -1, '', null);
  256. if(me.isDef(selected)) {
  257. let updateObj = me.getUpdateObj(me.updateType.update, selected.getID(), newID, null, null, null);
  258. postData.push(updateObj);
  259. insertObj.updateData.ParentID = selected.getParentID();
  260. if(me.isDef(selected.nextSibling)){
  261. insertObj.updateData.NextSiblingID = selected.getNextSiblingID();
  262. }
  263. }
  264. postData.push(insertObj);
  265. if(postData.length > 0){
  266. //ajax
  267. me.gljClassTreeAjax(postData, function (rstData) {
  268. me.controller.insert();
  269. me.refreshBtn(me.tree.selected);
  270. //fresh tools
  271. me.initTools(me.tree.selected);
  272. re.updateParentNodeIds(me.cache, re);
  273. });
  274. }
  275. },
  276. remove: function (selected) {
  277. let me = this;
  278. let re = repositoryGljObj;
  279. me.removeBtn.addClass('disabled');
  280. let postData = [], IDs = [];
  281. if(!selected){
  282. return;
  283. }
  284. getDelIds(selected);
  285. function getDelIds(node){
  286. if(me.isDef(node)){
  287. IDs.push(node.getID());
  288. if(node.children.length > 0){
  289. for(let i = 0, len = node.children.length; i < len; i++){
  290. getDelIds(node.children[i]);
  291. }
  292. }
  293. }
  294. }
  295. if(me.isDef(selected.preSibling)){
  296. let updateObj = me.getUpdateObj(me.updateType.update, selected.preSibling.getID(), selected.getNextSiblingID(), null, null, null);
  297. postData.push(updateObj);
  298. }
  299. if(IDs.length > 0){
  300. for(let i = 0, len = IDs.length; i < len; i++){
  301. let delObj = me.getUpdateObj(me.updateType.update, IDs[i], null, null, null, true);
  302. postData.push(delObj);
  303. }
  304. }
  305. if(postData.length > 0){
  306. //ajax
  307. me.gljClassTreeAjax(postData, function (rstData) {
  308. me.controller.delete();
  309. me.refreshBtn(me.tree.selected);
  310. me.initTools(me.tree.selected);
  311. re.updateParentNodeIds(me.cache, re);
  312. });
  313. }
  314. },
  315. upLevel: function (selected) {
  316. let me = this;
  317. let re = repositoryGljObj;
  318. me.upLevelBtn.addClass('disabled');
  319. let postData = [];
  320. if(!me.isDef(selected)){
  321. return;
  322. }
  323. if(!me.isDef(selected.parent)){
  324. return;
  325. }
  326. if(me.isDef(selected.preSibling)){
  327. let updateObj = me.getUpdateObj(me.updateType.update, selected.preSibling.getID(), -1, null, null, null);
  328. postData.push(updateObj);
  329. }
  330. let updateObj = me.getUpdateObj(me.updateType.update, selected.getID(), selected.parent.getNextSiblingID(), selected.parent.getParentID(), null, null);
  331. postData.push(updateObj);
  332. let updateParent = me.getUpdateObj(me.updateType.update, selected.getParentID(), selected.getID(), null, null, null);
  333. postData.push(updateParent);
  334. let nextIDs = [];
  335. getNext(selected);
  336. function getNext(node){
  337. if(me.isDef(node.nextSibling)){
  338. nextIDs.push(node.getNextSiblingID());
  339. getNext(node.nextSibling);
  340. }
  341. }
  342. for(let i = 0, len = nextIDs.length; i < len; i++){
  343. postData.push(me.getUpdateObj(me.updateType.update, nextIDs[i], null, selected.getID(), null, null));
  344. }
  345. if(postData.length > 0){
  346. //ajax
  347. me.gljClassTreeAjax(postData, function (rstData) {
  348. me.controller.upLevel();
  349. me.refreshBtn(me.tree.selected);
  350. re.updateParentNodeIds(me.cache, re);
  351. });
  352. }
  353. },
  354. downLevel: function (selected) {
  355. let me = this;
  356. let re = repositoryGljObj;
  357. me.downLevelBtn.addClass('disabled');
  358. let postData = [];
  359. if(!me.isDef(selected)){
  360. return;
  361. }
  362. if(!me.isDef(selected.preSibling)){
  363. return;
  364. }
  365. let updatePre = me.getUpdateObj(me.updateType.update, selected.preSibling.getID(), selected.getNextSiblingID(), null, null, null);
  366. postData.push(updatePre);
  367. if(selected.preSibling.children.length > 0){
  368. let updateObj = me.getUpdateObj(me.updateType.update, selected.preSibling.children[selected.preSibling.children.length - 1].getID(), selected.getID(), null, null, null);
  369. postData.push(updateObj);
  370. }
  371. let updateObj = me.getUpdateObj(me.updateType.update, selected.getID(), -1, selected.preSibling.getID(), null, null);
  372. postData.push(updateObj);
  373. if(postData.length > 0){
  374. //ajax
  375. me.gljClassTreeAjax(postData, function (rstData) {
  376. me.controller.downLevel();
  377. me.refreshBtn(me.tree.selected);
  378. re.updateParentNodeIds(me.cache, re);
  379. });
  380. }
  381. },
  382. upMove: function (selected) {
  383. let me = this;
  384. me.upMoveBtn.addClass('disabled');
  385. let postData = [];
  386. if(!me.isDef(selected)){
  387. return;
  388. }
  389. if(!me.isDef(selected.preSibling)){
  390. return;
  391. }
  392. let updateObj = me.getUpdateObj(me.updateType.update, selected.getID(), selected.preSibling.getID(), null, null, null);
  393. postData.push(updateObj);
  394. let updatePre = me.getUpdateObj(me.updateType.update, selected.preSibling.getID(), selected.getNextSiblingID(), null, null, null);
  395. postData.push(updatePre);
  396. if(me.isDef(selected.preSibling.preSibling)){
  397. let updatePrepre = me.getUpdateObj(me.updateType.update, selected.preSibling.preSibling.getID(), selected.getID(), null, null, null);
  398. postData.push(updatePrepre);
  399. }
  400. if(postData.length > 0){
  401. //ajax
  402. me.gljClassTreeAjax(postData, function (rstData) {
  403. me.controller.upMove();
  404. me.refreshBtn(me.tree.selected);
  405. });
  406. }
  407. },
  408. downMove: function (selected) {
  409. let me = this;
  410. me.downMoveBtn.addClass('disabled');
  411. let postData = [];
  412. if(!me.isDef(selected)){
  413. return;
  414. }
  415. if(!me.isDef(selected.nextSibling)){
  416. return;
  417. }
  418. if(me.isDef(selected.preSibling)){
  419. let updatePre = me.getUpdateObj(me.updateType.update, selected.preSibling.getID(), selected.getNextSiblingID(), null, null, null);
  420. postData.push(updatePre);
  421. }
  422. let updateObj = me.getUpdateObj(me.updateType.update, selected.getID(), selected.nextSibling.getNextSiblingID(), null, null, null);
  423. postData.push(updateObj);
  424. let updateNext = me.getUpdateObj(me.updateType.update, selected.getNextSiblingID(), selected.getID(), null, null, null);
  425. postData.push(updateNext);
  426. if(postData.length > 0){
  427. //ajax
  428. me.gljClassTreeAjax(postData, function (rstData) {
  429. me.controller.downMove();
  430. me.refreshBtn(me.tree.selected);
  431. });
  432. }
  433. },
  434. getUpdateObj: function (updateType, id, nid, pid, name, deleted) {
  435. let updateObj = Object.create(null);
  436. updateObj.updateType = '';
  437. updateObj.updateData = Object.create(null);
  438. updateObj.updateData.repositoryId = pageOprObj.gljLibId;
  439. if(this.isDef(updateType)){
  440. updateObj.updateType = updateType;
  441. }
  442. if(this.isDef(id)){
  443. updateObj.updateData.ID = id;
  444. }
  445. if(this.isDef(nid)){
  446. updateObj.updateData.NextSiblingID = nid;
  447. }
  448. if(this.isDef(pid)){
  449. updateObj.updateData.ParentID = pid;
  450. }
  451. if(this.isDef(name)){
  452. updateObj.updateData.Name = name;
  453. }
  454. if(this.isDef(deleted)){
  455. updateObj.updateData.deleted = true;
  456. }
  457. return updateObj;
  458. },
  459. gljClassTreeAjax: function (postData, scFunc, errFunc) {
  460. CommonAjax.post('api/updateNodes', {updateData: postData, lastOpr: userAccount}, scFunc, errFunc);
  461. },
  462. //模仿默认点击
  463. initSelection: function (node) {
  464. let me = this,
  465. re = repositoryGljObj,
  466. that = gljComponentOprObj;
  467. if(!re.isDef(node)){
  468. return;
  469. }
  470. me.refreshBtn(node);
  471. let gljTypeId = node.data.ID;
  472. re.gljCurTypeId = node.data.ID;
  473. re.addGljObj = null;
  474. sheetCommonObj.cleanSheet(that.workBook.getSheet(0), that.setting, 10);
  475. if (re.parentNodeIds["_pNodeId_" + gljTypeId]) {
  476. re.currentOprParent = 1;
  477. re.currentCache = re.getParentCache(re.parentNodeIds["_pNodeId_" + gljTypeId]);
  478. re.workBook.getSheet(0).setRowCount(re.currentCache.length);
  479. } else {
  480. re.currentOprParent = 0;
  481. re.currentCache = re.getCache();
  482. }
  483. re.showGljItems(re.currentCache, gljTypeId);
  484. me.workBook.focus(true);
  485. }
  486. }