ledger_bwtz.js 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238
  1. 'use strict';
  2. /**
  3. *
  4. *
  5. * @author Mai
  6. * @date
  7. * @version
  8. */
  9. $(document).ready(() => {
  10. let xmjSearch;
  11. autoFlashHeight();
  12. const xmjSpread = SpreadJsObj.createNewSpread($('#xmj-spread')[0]);
  13. const xmjSheet = xmjSpread.getActiveSheet();
  14. sjsSettingObj.setFxTreeStyle(xmjSpreadSetting, sjsSettingObj.FxTreeStyle.jz);
  15. if (thousandth) sjsSettingObj.setTpThousandthFormat(xmjSpreadSetting);
  16. SpreadJsObj.initSheet(xmjSheet, xmjSpreadSetting);
  17. const unitSpread = SpreadJsObj.createNewSpread($('#unit-spread')[0]);
  18. const unitSheet = unitSpread.getActiveSheet();
  19. if (thousandth) sjsSettingObj.setTpThousandthFormat(xmjSpreadSetting);
  20. SpreadJsObj.initSheet(unitSheet, unitSpreadSetting);
  21. const unitTreeObj = {
  22. loadCurUnitData: function () {
  23. const node = SpreadJsObj.getSelectObject(xmjSheet);
  24. SpreadJsObj.resetTopAndSelect(unitSheet);
  25. if (node && node.unitTree) {
  26. SpreadJsObj.loadSheetData(unitSheet, SpreadJsObj.DataType.Tree, node.unitTree);
  27. } else {
  28. SpreadJsObj.initSheet(unitSheet, unitSpreadSetting);
  29. }
  30. SpreadJsObj.resetTopAndSelect(unitSheet);
  31. }
  32. };
  33. xmjSpread.bind(spreadNS.Events.SelectionChanged, function (e, info) {
  34. unitTreeObj.loadCurUnitData();
  35. });
  36. postData(window.location.pathname + '/load', {}, function (result) {
  37. const setting = {
  38. id: 'ledger_id',
  39. pid: 'ledger_pid',
  40. order: 'order',
  41. level: 'level',
  42. rootId: -1,
  43. fullPath: 'full_path',
  44. };
  45. const xmjTree = createNewPathTree('base', setting);
  46. xmjTree.loadDatas(result);
  47. for (const n of xmjTree.nodes) {
  48. if (n.unitTreeData) {
  49. n.unitTree = createNewPathTree('base', setting);
  50. n.unitTree.loadDatas(n.unitTreeData);
  51. }
  52. }
  53. console.log(xmjTree);
  54. SpreadJsObj.loadSheetData(xmjSheet, SpreadJsObj.DataType.Tree, xmjTree);
  55. unitTreeObj.loadCurUnitData();
  56. });
  57. $.subMenu({
  58. menu: '#sub-menu', miniMenu: '#sub-mini-menu', miniMenuList: '#mini-menu-list',
  59. toMenu: '#to-menu', toMiniMenu: '#to-mini-menu',
  60. key: 'menu.1.0.0',
  61. miniHint: '#sub-mini-hint', hintKey: 'menu.hint.1.0.1',
  62. callback: function (info) {
  63. if (info.mini) {
  64. $('.panel-title').addClass('fluid');
  65. $('#sub-menu').removeClass('panel-sidebar');
  66. } else {
  67. $('.panel-title').removeClass('fluid');
  68. $('#sub-menu').addClass('panel-sidebar');
  69. }
  70. autoFlashHeight();
  71. xmjSpread.refresh();
  72. unitSpread.refresh();
  73. }
  74. });
  75. // 加载上下窗口resizer
  76. $.divResizer({
  77. select: '#main-resize',
  78. callback: function () {
  79. xmjSpread.refresh();
  80. let bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0;
  81. $(".sp-wrap").height(bcontent-30);
  82. unitSpread.refresh();
  83. }
  84. });
  85. $.divResizer({
  86. select: '#right-spr',
  87. callback: function () {
  88. xmjSpread.refresh();
  89. unitSpread.refresh();
  90. if (xmjSearch) {
  91. xmjSearch.spread.refresh();
  92. }
  93. }
  94. });
  95. $('a', '.side-menu').bind('click', function (e) {
  96. e.preventDefault();
  97. const tab = $(this), tabPanel = $(tab.attr('content'));
  98. const showSideTools = function (show) {
  99. const left = $('#left-view'), right = $('#right-view'), parent = left.parent();
  100. if (show) {
  101. right.show();
  102. autoFlashHeight();
  103. /**
  104. * right.show()后, parent被撑开成2倍left.height, 导致parent.width减少了10px
  105. * 第一次left.width调整后,parent的缩回left.height, 此时parent.width又增加了10px
  106. * 故需要通过最终的parent.width再计算一次left.width
  107. *
  108. * Q: 为什么不通过先计算left.width的宽度,以避免计算两次left.width?
  109. * A: 右侧工具栏不一定显示,当右侧工具栏显示过一次后,就必须使用parent和right来计算left.width
  110. *
  111. */
  112. //left.css('width', parent.width() - right.outerWidth());
  113. //left.css('width', parent.width() - right.outerWidth());
  114. const percent = 100 - right.outerWidth() /parent.width() * 100;
  115. left.css('width', percent + '%');
  116. } else {
  117. left.width(parent.width());
  118. right.hide();
  119. }
  120. };
  121. // 展开工具栏、切换标签
  122. if (!tab.hasClass('active')) {
  123. const close = $('.active', '#side-menu').length === 0;
  124. $('a', '#side-menu').removeClass('active');
  125. tab.addClass('active');
  126. $('.tab-content .tab-pane').removeClass('active');
  127. tabPanel.addClass('active');
  128. showSideTools(tab.hasClass('active'));
  129. if (tab.attr('content') === '#search' && !xmjSearch) {
  130. if (!xmjSearch) {
  131. xmjSearch = $.billsSearch({
  132. selector: '#search',
  133. searchSpread: xmjSpread,
  134. searchRangeStr: '项目节编号/名称',
  135. resultSpreadSetting: {
  136. cols: [
  137. {title: '项目节编号', field: 'code', hAlign: 0, width: 120, formatter: '@', readOnly: true},
  138. {title: '名称', field: 'name', width: 150, hAlign: 0, formatter: '@', readOnly: true},
  139. {title: '单位', field: 'unit', width: 50, hAlign: 1, formatter: '@', readOnly: true},
  140. {title: '台账金额', field: 'total_price', hAlign: 2, width: 80, readOnly: true},
  141. ],
  142. emptyRows: 0,
  143. headRows: 1,
  144. headRowHeight: [32],
  145. headColWidth: [30],
  146. defaultRowHeight: 21,
  147. headerFont: '12px 微软雅黑',
  148. font: '12px 微软雅黑',
  149. selectedBackColor: '#fffacd',
  150. },
  151. afterLocated: function () {
  152. unitTreeObj.loadCurUnitData();
  153. }
  154. });
  155. }
  156. xmjSearch.spread.refresh();
  157. }
  158. } else { // 收起工具栏
  159. tab.removeClass('active');
  160. tabPanel.removeClass('active');
  161. showSideTools(tab.hasClass('active'));
  162. }
  163. xmjSpread.refresh();
  164. unitSpread.refresh();
  165. });
  166. // 显示层次
  167. (function (select, sheet) {
  168. $(select).click(function () {
  169. const tag = $(this).attr('tag');
  170. const tree = sheet.zh_tree;
  171. if (!tree) return;
  172. switch (tag) {
  173. case "1":
  174. case "2":
  175. case "3":
  176. case "4":
  177. case "5":
  178. tree.expandByLevel(parseInt(tag));
  179. SpreadJsObj.refreshTreeRowVisible(sheet);
  180. break;
  181. case "last":
  182. tree.expandByCustom(() => { return true; });
  183. SpreadJsObj.refreshTreeRowVisible(sheet);
  184. break;
  185. }
  186. });
  187. })('a[name=showLevel]', xmjSheet);
  188. $('#exportBwtz').click(function () {
  189. const data = [];
  190. const setting = {
  191. cols: [
  192. {title: '项目节编号', colSpan: '1', rowSpan: '2', field: 'code', hAlign: 0, width: 100, formatter: '@'},
  193. {title: '清单编号', colSpan: '1', rowSpan: '2', field: 'b_code', hAlign: 0, width: 70, formatter: '@'},
  194. {title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 300, formatter: '@'},
  195. {title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 60, formatter: '@'},
  196. {title: '单价', colSpan: '1', rowSpan: '2', field: 'unit_price', hAlign: 2, width: 80, type: 'Number'},
  197. {title: '台账|数量', colSpan: '2|1', rowSpan: '1|1', field: 'quantity', hAlign: 2, width: 80, type: 'Number'},
  198. {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'total_price', hAlign: 2, width: 80, type: 'Number'},
  199. {title: '图(册)号', colSpan: '1', rowSpan: '2', field: 'drawing_code', hAlign: 0, width: 100, formatter: '@'},
  200. {title: '备注', colSpan: '1', rowSpan: '2', field: 'memo', hAlign: 0, width: 100, formatter: '@'},
  201. ],
  202. headRows: 2,
  203. headRowHeight: [25, 25],
  204. defaultRowHeight: 21,
  205. headerFont: 'bold 10px 微软雅黑',
  206. font: '10px 微软雅黑'
  207. };
  208. if (!xmjSheet.zh_tree) return;
  209. for (const node of xmjSheet.zh_tree.nodes) {
  210. data.push({
  211. code: node.code, b_code: node.b_code, name: node.name, unit: node.unit,
  212. unit_price: node.unit_price, quantity: node.quantity, total_price: node.total_price,
  213. drawing_code: node.drawing_code, memo: node.memo
  214. });
  215. if (node.unitTree) {
  216. for (const unitNode of node.unitTree.nodes) {
  217. data.push({
  218. code: unitNode.code, b_code: unitNode.b_code,
  219. name: unitNode.pos_name ? unitNode.pos_name : unitNode.name, unit: unitNode.unit,
  220. unit_price: unitNode.unit_price, quantity: unitNode.quantity, total_price: unitNode.total_price,
  221. drawing_code: unitNode.drawing_code_merge, memo: unitNode.memo_merge
  222. });
  223. }
  224. }
  225. }
  226. SpreadExcelObj.exportSimpleXlsxSheet(setting, data, $('.sidebar-title').attr('data-original-title') + "-部位台账.xlsx");
  227. });
  228. });