gljClassTree.js 18 KB

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