gljClassTree.js 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526
  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. if (locked) {
  198. return;
  199. }
  200. let me = this;
  201. me.insertBtn.removeClass('disabled');
  202. me.removeBtn.removeClass('disabled');
  203. me.upLevelBtn.removeClass('disabled');
  204. me.downLevelBtn.removeClass('disabled');
  205. me.downMoveBtn.removeClass('disabled');
  206. me.upMoveBtn.removeClass('disabled');
  207. if (!me.isDef(selected)) {
  208. me.removeBtn.addClass('disabled');
  209. me.upLevelBtn.addClass('disabled');
  210. me.downLevelBtn.addClass('disabled');
  211. me.downMoveBtn.addClass('disabled');
  212. me.upMoveBtn.addClass('disabled');
  213. }
  214. else {
  215. if (!me.isDef(selected.preSibling)) {
  216. me.downLevelBtn.addClass('disabled');
  217. me.upMoveBtn.addClass('disabled');
  218. }
  219. if (!me.isDef(selected.nextSibling)) {
  220. me.downMoveBtn.addClass('disabled');
  221. }
  222. if (!me.isDef(selected.parent)) {
  223. me.upLevelBtn.addClass('disabled');
  224. }
  225. }
  226. },
  227. bindBtn: function () {
  228. let me = this;
  229. me.insertBtn.click(function () {
  230. me.insert();
  231. });
  232. $('#delConfirm').click(function () {
  233. if (me.canRemoveClass) {
  234. me.remove(me.tree.selected);
  235. }
  236. $('#delAlert').modal('hide');
  237. });
  238. me.removeBtn.click(function () {
  239. //当前分类下无子项且无工料机数据,才允许删除
  240. let classNode = me.cache[me.workBook.getActiveSheet().getActiveRowIndex()];
  241. if (!classNode) {
  242. return;
  243. }
  244. let className = me.isDef(classNode.data.Name) ? classNode.data.Name : '';
  245. let classGljs = repositoryGljObj.currentCache;
  246. if (classNode.children.length > 0 || (classGljs && classGljs.length > 0)) {
  247. me.canRemoveClass = false;
  248. $('#delAlert').find('.modal-body h5').text('当前分类下有数据,不可删除。');
  249. }
  250. else {
  251. me.canRemoveClass = true;
  252. $('#delAlert').find('.modal-body h5').text(`确认要删除分类 “${className}”吗?`);
  253. }
  254. $('#delAlert').modal('show');
  255. });
  256. me.upLevelBtn.click(function () {
  257. me.upLevel(me.tree.selected);
  258. });
  259. me.downLevelBtn.click(function () {
  260. me.downLevel(me.tree.selected);
  261. });
  262. me.downMoveBtn.click(function () {
  263. me.downMove(me.tree.selected);
  264. });
  265. me.upMoveBtn.click(function () {
  266. me.upMove(me.tree.selected);
  267. });
  268. },
  269. insert: function () {
  270. let me = this;
  271. let re = repositoryGljObj;
  272. me.insertBtn.addClass('disabled');
  273. let postData = [];
  274. let newID = me.tree.newNodeID();
  275. if (!me.isDef(newID)) {
  276. return;
  277. }
  278. let selected = me.tree.selected;
  279. let insertObj = me.getUpdateObj(me.updateType.new, newID, -1, -1, '', null);
  280. if (me.isDef(selected)) {
  281. let updateObj = me.getUpdateObj(me.updateType.update, selected.getID(), newID, null, null, null);
  282. postData.push(updateObj);
  283. insertObj.updateData.ParentID = selected.getParentID();
  284. if (me.isDef(selected.nextSibling)) {
  285. insertObj.updateData.NextSiblingID = selected.getNextSiblingID();
  286. }
  287. }
  288. postData.push(insertObj);
  289. if (postData.length > 0) {
  290. //ajax
  291. me.gljClassTreeAjax(postData, function (rstData) {
  292. me.controller.insert();
  293. me.refreshBtn(me.tree.selected);
  294. //fresh tools
  295. re.updateParentNodeIds(me.cache, re);
  296. me.initSelection(me.tree.selected);
  297. });
  298. }
  299. },
  300. remove: function (selected) {
  301. let me = this;
  302. let re = repositoryGljObj;
  303. me.removeBtn.addClass('disabled');
  304. let postData = [], IDs = [];
  305. if (!selected) {
  306. return;
  307. }
  308. getDelIds(selected);
  309. function getDelIds(node) {
  310. if (me.isDef(node)) {
  311. IDs.push(node.getID());
  312. if (node.children.length > 0) {
  313. for (let i = 0, len = node.children.length; i < len; i++) {
  314. getDelIds(node.children[i]);
  315. }
  316. }
  317. }
  318. }
  319. if (me.isDef(selected.preSibling)) {
  320. let updateObj = me.getUpdateObj(me.updateType.update, selected.preSibling.getID(), selected.getNextSiblingID(), null, null, null);
  321. postData.push(updateObj);
  322. }
  323. if (IDs.length > 0) {
  324. for (let i = 0, len = IDs.length; i < len; i++) {
  325. let delObj = me.getUpdateObj(me.updateType.update, IDs[i], null, null, null, true);
  326. postData.push(delObj);
  327. }
  328. }
  329. if (postData.length > 0) {
  330. //ajax
  331. me.gljClassTreeAjax(postData, function (rstData) {
  332. me.controller.delete();
  333. me.refreshBtn(me.tree.selected);
  334. re.updateParentNodeIds(me.cache, re);
  335. me.initSelection(me.tree.selected);
  336. me.workBook.getActiveSheet().setActiveCell(me.tree.selected ? me.tree.selected.serialNo() : 0, 0);
  337. });
  338. }
  339. },
  340. upLevel: function (selected) {
  341. let me = this;
  342. let re = repositoryGljObj;
  343. me.upLevelBtn.addClass('disabled');
  344. let postData = [];
  345. if (!me.isDef(selected)) {
  346. return;
  347. }
  348. if (!me.isDef(selected.parent)) {
  349. return;
  350. }
  351. if (me.isDef(selected.preSibling)) {
  352. let updateObj = me.getUpdateObj(me.updateType.update, selected.preSibling.getID(), -1, null, null, null);
  353. postData.push(updateObj);
  354. }
  355. let updateObj = me.getUpdateObj(me.updateType.update, selected.getID(), selected.parent.getNextSiblingID(), selected.parent.getParentID(), null, null);
  356. postData.push(updateObj);
  357. let updateParent = me.getUpdateObj(me.updateType.update, selected.getParentID(), selected.getID(), null, null, null);
  358. postData.push(updateParent);
  359. let nextIDs = [];
  360. getNext(selected);
  361. function getNext(node) {
  362. if (me.isDef(node.nextSibling)) {
  363. nextIDs.push(node.getNextSiblingID());
  364. getNext(node.nextSibling);
  365. }
  366. }
  367. for (let i = 0, len = nextIDs.length; i < len; i++) {
  368. postData.push(me.getUpdateObj(me.updateType.update, nextIDs[i], null, selected.getID(), null, null));
  369. }
  370. if (postData.length > 0) {
  371. //ajax
  372. me.gljClassTreeAjax(postData, function (rstData) {
  373. me.controller.upLevel();
  374. me.refreshBtn(me.tree.selected);
  375. re.updateParentNodeIds(me.cache, re);
  376. });
  377. }
  378. },
  379. downLevel: function (selected) {
  380. let me = this;
  381. let re = repositoryGljObj;
  382. me.downLevelBtn.addClass('disabled');
  383. let postData = [];
  384. if (!me.isDef(selected)) {
  385. return;
  386. }
  387. if (!me.isDef(selected.preSibling)) {
  388. return;
  389. }
  390. let updatePre = me.getUpdateObj(me.updateType.update, selected.preSibling.getID(), selected.getNextSiblingID(), null, null, null);
  391. postData.push(updatePre);
  392. if (selected.preSibling.children.length > 0) {
  393. let updateObj = me.getUpdateObj(me.updateType.update, selected.preSibling.children[selected.preSibling.children.length - 1].getID(), selected.getID(), null, null, null);
  394. postData.push(updateObj);
  395. }
  396. let updateObj = me.getUpdateObj(me.updateType.update, selected.getID(), -1, selected.preSibling.getID(), null, null);
  397. postData.push(updateObj);
  398. if (postData.length > 0) {
  399. //ajax
  400. me.gljClassTreeAjax(postData, function (rstData) {
  401. me.controller.downLevel();
  402. me.refreshBtn(me.tree.selected);
  403. re.updateParentNodeIds(me.cache, re);
  404. });
  405. }
  406. },
  407. upMove: function (selected) {
  408. let me = this;
  409. me.upMoveBtn.addClass('disabled');
  410. let postData = [];
  411. if (!me.isDef(selected)) {
  412. return;
  413. }
  414. if (!me.isDef(selected.preSibling)) {
  415. return;
  416. }
  417. let updateObj = me.getUpdateObj(me.updateType.update, selected.getID(), selected.preSibling.getID(), null, null, null);
  418. postData.push(updateObj);
  419. let updatePre = me.getUpdateObj(me.updateType.update, selected.preSibling.getID(), selected.getNextSiblingID(), null, null, null);
  420. postData.push(updatePre);
  421. if (me.isDef(selected.preSibling.preSibling)) {
  422. let updatePrepre = me.getUpdateObj(me.updateType.update, selected.preSibling.preSibling.getID(), selected.getID(), null, null, null);
  423. postData.push(updatePrepre);
  424. }
  425. if (postData.length > 0) {
  426. //ajax
  427. me.gljClassTreeAjax(postData, function (rstData) {
  428. me.controller.upMove();
  429. me.refreshBtn(me.tree.selected);
  430. });
  431. }
  432. },
  433. downMove: function (selected) {
  434. let me = this;
  435. me.downMoveBtn.addClass('disabled');
  436. let postData = [];
  437. if (!me.isDef(selected)) {
  438. return;
  439. }
  440. if (!me.isDef(selected.nextSibling)) {
  441. return;
  442. }
  443. if (me.isDef(selected.preSibling)) {
  444. let updatePre = me.getUpdateObj(me.updateType.update, selected.preSibling.getID(), selected.getNextSiblingID(), null, null, null);
  445. postData.push(updatePre);
  446. }
  447. let updateObj = me.getUpdateObj(me.updateType.update, selected.getID(), selected.nextSibling.getNextSiblingID(), null, null, null);
  448. postData.push(updateObj);
  449. let updateNext = me.getUpdateObj(me.updateType.update, selected.getNextSiblingID(), selected.getID(), null, null, null);
  450. postData.push(updateNext);
  451. if (postData.length > 0) {
  452. //ajax
  453. me.gljClassTreeAjax(postData, function (rstData) {
  454. me.controller.downMove();
  455. me.refreshBtn(me.tree.selected);
  456. });
  457. }
  458. },
  459. getUpdateObj: function (updateType, id, nid, pid, name, deleted) {
  460. let updateObj = Object.create(null);
  461. updateObj.updateType = '';
  462. updateObj.updateData = Object.create(null);
  463. updateObj.updateData.repositoryId = pageOprObj.gljLibId;
  464. if (this.isDef(updateType)) {
  465. updateObj.updateType = updateType;
  466. }
  467. if (this.isDef(id)) {
  468. updateObj.updateData.ID = id;
  469. }
  470. if (this.isDef(nid)) {
  471. updateObj.updateData.NextSiblingID = nid;
  472. }
  473. if (this.isDef(pid)) {
  474. updateObj.updateData.ParentID = pid;
  475. }
  476. if (this.isDef(name)) {
  477. updateObj.updateData.Name = name;
  478. }
  479. if (this.isDef(deleted)) {
  480. updateObj.updateData.deleted = true;
  481. }
  482. return updateObj;
  483. },
  484. gljClassTreeAjax: function (postData, scFunc, errFunc) {
  485. CommonAjax.post('api/updateNodes', { updateData: postData, lastOpr: userAccount }, scFunc, errFunc);
  486. },
  487. //模仿默认点击
  488. initSelection: function (node) {
  489. let me = this,
  490. re = repositoryGljObj,
  491. that = gljComponentOprObj;
  492. me.refreshBtn(node);
  493. if (!re.isDef(node)) {
  494. return;
  495. }
  496. let gljTypeId = node.data.ID;
  497. re.gljCurTypeId = node.data.ID;
  498. re.addGljObj = null;
  499. sheetCommonObj.cleanSheet(that.workBook.getSheet(0), that.setting, 10);
  500. if (re.parentNodeIds["_pNodeId_" + gljTypeId]) {
  501. re.currentOprParent = 1;
  502. re.currentCache = re.getParentCache(re.parentNodeIds["_pNodeId_" + gljTypeId]);
  503. re.workBook.getSheet(0).setRowCount(re.currentCache.length);
  504. } else {
  505. re.currentOprParent = 0;
  506. re.currentCache = re.getCache();
  507. }
  508. re.showGljItems(re.currentCache, gljTypeId);
  509. me.workBook.focus(true);
  510. }
  511. }