gljClassTree.js 19 KB

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