bills.js 7.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173
  1. /**
  2. * Created by Mai on 2017/4/17.
  3. */
  4. $(document).ready(function () {
  5. var tempType = 3;
  6. var FormatUpdateData = function (data) {
  7. var updateData = {};
  8. updateData['user_id'] = userID;
  9. updateData['tempType'] = tempType;
  10. updateData['updateData'] = data;
  11. return updateData;
  12. };
  13. var RefreshBaseActn = function (tree) {
  14. var showButton = function (show, btn) {
  15. if (show) {
  16. btn.show();
  17. } else {
  18. btn.hide();
  19. }
  20. };
  21. showButton(tree.selected && tree.selected.canUpLevel(), $('#upLevel'));
  22. showButton(tree.selected && tree.selected.canDownLevel(), $('#downLevel'));
  23. showButton(tree.selected && tree.selected.canUpMove(), $('#upMove'));
  24. showButton(tree.selected && tree.selected.canDownMove(), $('#downMove'));
  25. showButton(tree.selected ? true : false, $('#delete'));
  26. }
  27. var RefreshBillsData = function (datas) {
  28. datas.forEach(function (data) {
  29. var node = tree.findNode(data.data.ID);
  30. if (node) {
  31. $.extend(true, node.data, data.data);
  32. }
  33. });
  34. };
  35. <<<<<<< HEAD
  36. var bills;
  37. var tree = idTree.createInit({id: 'ID', pid: 'ParentID', nid: 'NextSiblingID', rootId: -1});
  38. =======
  39. var tree = idTree.createNew({id: 'ID', pid: 'ParentID', nid: 'NextSiblingID', rootId: -1, autoUpdate: true});
  40. >>>>>>> bc0f5d2858a5b09273a8d6ed5620a4deb05293b2
  41. var billsSpread = new GC.Spread.Sheets.Workbook($('#billsSpread')[0], { sheetCount: 1 });
  42. var controller = TREE_SHEET_CONTROLLER.createInit(tree, billsSpread.getActiveSheet(), TEMPLATE_BILLS_SETTING);
  43. GC.Spread.Common.CultureManager.culture("zh-cn");
  44. billsSpread.options.tabStripVisible = false;
  45. billsSpread.options.scrollbarMaxAlign = true;
  46. billsSpread.options.cutCopyIndicatorVisible = false;
  47. billsSpread.options.allowCopyPasteExcelStyle = false;
  48. controller.bind('refreshBaseActn', RefreshBaseActn);
  49. billsSpread.bind(GC.Spread.Sheets.Events.EditEnded, function (sender, info) {
  50. var node = controller.tree.items[info.row];
  51. var fieldName = controller.setting.cols[info.col].data.field;
  52. var data = {type: 'update', data: {ID: node.getID()}};
  53. data.data[fieldName] = info.editingText;
  54. var updateData = FormatUpdateData([data]);
  55. CommonAjax.post('/template/bills/api/updateBillsTemplate', updateData, function (data) {
  56. node.data[fieldName] = info.editingText;
  57. controller.refreshTreeNode([node], false);
  58. }, function () {
  59. controller.refreshTreeNode([node], false);
  60. });
  61. });
  62. billsSpread.bind(GC.Spread.Sheets.Events.ClipboardPasting, function (sender, args) {
  63. console.log("ClipboardPasting");
  64. });
  65. billsSpread.bind(GC.Spread.Sheets.Events.ClipboardPasted, function (e, info) {
  66. console.log("ClipboardPasted");
  67. var node, iRow, iCol, curRow, curCol, datas = [], data, fieldName, updateData;
  68. for (iRow = 0; iRow < info.cellRange.rowCount; iRow ++) {
  69. curRow = info.cellRange.row + iRow;
  70. node = controller.tree.items[curRow];
  71. if (node) {
  72. data = {type: 'update', data: {ID: node.getID()}};
  73. for (iCol = 0; iCol < info.cellRange.colCount; iCol++) {
  74. curCol = info.cellRange.col + iCol;
  75. fieldName = controller.setting.cols[curCol].data.field;
  76. data.data[fieldName] = info.sheet.getText(curRow, curCol);
  77. }
  78. datas.push(data);
  79. }
  80. };
  81. CommonAjax.post('/template/bills/api/updateBillsTemplate', FormatUpdateData(datas), function (data) {
  82. RefreshBillsData(data);
  83. controller.showTreeData();
  84. }, function () {
  85. controller.showTreeData();
  86. });
  87. });
  88. CommonAjax.post('/template/bills/api/getBillsTemplate', {tempType: tempType}, function (data) {
  89. var bills = data;
  90. tree.loadDatas(bills);
  91. controller.showTreeData();
  92. RefreshBaseActn(tree);
  93. }, function () {
  94. controller.showTreeData();
  95. RefreshBaseActn(tree);
  96. });
  97. $('#insert').click(function () {
  98. CommonAjax.post('/template/bills/api/getNewBillsTemplateID', {count: 1}, function (data) {
  99. var selected = controller.tree.selected, updateData;
  100. controller.tree.maxNodeID(data.lowID - 1);
  101. controller.tree.rangeNodeID(data.highID);
  102. if (selected) {
  103. updateData = FormatUpdateData(controller.tree.getInsertData(selected.getParentID(), selected.getNextSiblingID()));
  104. } else {
  105. updateData = FormatUpdateData(controller.tree.getInsertData());
  106. }
  107. if (updateData.updateData.length > 0) {
  108. CommonAjax.post('/template/bills/api/updateBillsTemplate', updateData, function (data) {
  109. controller.insert();
  110. controller.showTreeData();
  111. });
  112. } else {
  113. alert('新增节点失败, 请重试.');
  114. }
  115. });
  116. });
  117. $('#delete').click(function () {
  118. var selected = controller.tree.selected, updateData;
  119. if (selected) {
  120. updateData = FormatUpdateData(controller.tree.getDeleteData(selected));
  121. CommonAjax.post('/template/bills/api/updateBillsTemplate', updateData, function (data) {
  122. controller.delete();
  123. controller.showTreeData();
  124. });
  125. }
  126. });
  127. $('#upLevel').click(function () {
  128. var selected = controller.tree.selected, updateData;
  129. if (selected) {
  130. updateData = FormatUpdateData(selected.getUpLevelData());
  131. CommonAjax.post('/template/bills/api/updateBillsTemplate', updateData, function (data) {
  132. controller.upLevel();
  133. controller.showTreeData();
  134. });
  135. }
  136. });
  137. $('#downLevel').click(function () {
  138. var selected = controller.tree.selected, updateData;
  139. if (selected) {
  140. updateData = FormatUpdateData(selected.getDownLevelData());
  141. CommonAjax.post('/template/bills/api/updateBillsTemplate', updateData, function (data) {
  142. controller.downLevel();
  143. controller.showTreeData();
  144. });
  145. }
  146. });
  147. $('#upMove').click(function () {
  148. var selected = controller.tree.selected, updateData;
  149. if (selected) {
  150. updateData = FormatUpdateData(selected.getUpMoveData());
  151. CommonAjax.post('/template/bills/api/updateBillsTemplate', updateData, function (data) {
  152. controller.upMove();
  153. controller.showTreeData();
  154. });
  155. }
  156. });
  157. $('#downMove').click(function () {
  158. var selected = controller.tree.selected, updateData;
  159. if (selected) {
  160. updateData = FormatUpdateData(selected.getDownMoveData());
  161. CommonAjax.post('/template/bills/api/updateBillsTemplate', updateData, function (data) {
  162. controller.downMove();
  163. controller.showTreeData();
  164. });
  165. }
  166. });
  167. });