revise_gcl_compare.js 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231
  1. 'use strict';
  2. /**
  3. *
  4. *
  5. * @author Mai
  6. * @date 2020/10/28
  7. * @version
  8. */
  9. const showTools = function (show) {
  10. const left = $('#left-view'), right = $('#right-view'), parent = left.parent();
  11. if (show) {
  12. right.show();
  13. autoFlashHeight();
  14. /**
  15. * right.show()后, parent被撑开成2倍left.height, 导致parent.width减少了10px
  16. * 第一次left.width调整后,parent的缩回left.height, 此时parent.width又增加了10px
  17. * 故需要通过最终的parent.width再计算一次left.width
  18. *
  19. * Q: 为什么不通过先计算left.width的宽度,以避免计算两次left.width?
  20. * A: 右侧工具栏不一定显示,当右侧工具栏显示过一次后,就必须使用parent和right来计算left.width
  21. *
  22. */
  23. //left.css('width', parent.width() - right.outerWidth());
  24. //left.css('width', parent.width() - right.outerWidth());
  25. const percent = 100 - right.outerWidth() /parent.width() * 100;
  26. left.css('width', percent + '%');
  27. } else {
  28. right.hide();
  29. left.css('width', '100%');
  30. }
  31. };
  32. $(document).ready(() => {
  33. let compareTag = $('input[name=compareTag]:checked').val();
  34. showTools(true);
  35. autoFlashHeight();
  36. const gclSpread = SpreadJsObj.createNewSpread($('#gcl-spread')[0]);
  37. const gclSpreadSetting = {
  38. cols: [
  39. {title: '清单编号', colSpan: '1', rowSpan: '2', field: 'b_code', hAlign: 0, width: 120, formatter: '@'},
  40. {title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 230, formatter: '@'},
  41. {title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 60, formatter: '@', cellType: 'unit'},
  42. {title: '单价', colSpan: '1', rowSpan: '2', field: 'unit_price', hAlign: 2, width: 80, type: 'Number'},
  43. {title: '签约清单|数量', colSpan: '2|1', rowSpan: '1|1', field: 'deal_bills_qty', hAlign: 2, width: 80, type: 'Number'},
  44. {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'deal_bills_tp', hAlign: 2, width: 80, type: 'Number'},
  45. {title: '台账修订|数量', colSpan: '2|1', rowSpan: '1|1', field: 'new_quantity', hAlign: 2, width: 80, type: 'Number'},
  46. {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'new_total_price', hAlign: 2, width: 80, type: 'Number'},
  47. {title: '台账|数量', colSpan: '2|1', rowSpan: '1|1', field: 'org_quantity', hAlign: 2, width: 80, type: 'Number'},
  48. {title: '|金额', colSpan: '|1', rowSpan: '|1', field: 'org_total_price', hAlign: 2, width: 80, type: 'Number'},
  49. ],
  50. emptyRows: 0,
  51. headRows: 2,
  52. headRowHeight: [25, 25],
  53. headColWidth: [30],
  54. defaultRowHeight: 21,
  55. headerFont: '12px 微软雅黑',
  56. font: '12px 微软雅黑',
  57. readOnly: true,
  58. localCache: {
  59. key: 'ledger-gather-gcl',
  60. colWidth: true,
  61. },
  62. getColor: function (sheet, data, row, col, defaultColor) {
  63. if (!data) return '#ffffff';
  64. // if ((col.field === 'deal_bills_qty' || col.field === 'deal_bills_tp') && data.deal_differ_qty)
  65. // return '#f8d7da';
  66. // if ((col.field === 'org_quantity' || col.field === 'org_total_price') && data.differ_qty)
  67. // return '#f8d7da';
  68. if (compareTag === 'deal' && data.deal_differ_qty) return '#f8d7da';
  69. if (compareTag === 'org' && data.differ_qty) return '#f8d7da';
  70. return data.differ ? '#FFE699' : '#ffffff';
  71. }
  72. };
  73. if (thousandth) sjsSettingObj.setTpThousandthFormat(gclSpreadSetting);
  74. SpreadJsObj.initSheet(gclSpread.getActiveSheet(), gclSpreadSetting);
  75. const gclSheet = gclSpread.getActiveSheet();
  76. const leafXmjSpread = SpreadJsObj.createNewSpread($('#leaf-xmj-spread')[0]);
  77. const leafXmjSpreadSetting = {
  78. cols: [
  79. {title: '项目节编号', colSpan: '1', rowSpan: '2', field: 'code', hAlign: 0, width: 120, formatter: '@'},
  80. {title: '修订台账|数量', colSpan: '1', rowSpan: '1|1', field: 'new_quantity', hAlign: 2, width: 80, type: 'Number'},
  81. {title: '原台账|数量', colSpan: '1', rowSpan: '1|1', field: 'org_quantity', hAlign: 2, width: 80, type: 'Number'},
  82. {title: '单位工程', colSpan: '1', rowSpan: '2', field: 'dwgc', hAlign: 0, width: 100, formatter: '@'},
  83. {title: '分部工程', colSpan: '1', rowSpan: '2', field: 'fbgc', hAlign: 0, width: 100, formatter: '@'},
  84. {title: '分项工程', colSpan: '1', rowSpan: '2', field: 'fxgc', hAlign: 0, width: 100, formatter: '@'},
  85. {title: '细目', colSpan: '1', rowSpan: '2', field: 'jldy', hAlign: 0, width: 100, formatter: '@'},
  86. {title: '计量单元', colSpan: '1', rowSpan: '2', field: 'bwmx', hAlign: 0, width: 100, formatter: '@'},
  87. {title: '图册号', colSpan: '1', rowSpan: '2', field: 'drawing_code', hAlign: 0, width: 120, formatter: '@'},
  88. ],
  89. emptyRows: 0,
  90. headRows: 1,
  91. headRowHeight: [25, 25],
  92. headColWidth: [30],
  93. defaultRowHeight: 21,
  94. headerFont: '12px 微软雅黑',
  95. font: '12px 微软雅黑',
  96. readOnly: true,
  97. localCache: {
  98. key: 'ledger-gather-leafXmj',
  99. colWidth: true,
  100. },
  101. };
  102. if (!isTz) leafXmjSpreadSetting.cols.splice(1, 2);
  103. if (thousandth) sjsSettingObj.setTpThousandthFormat(leafXmjSpreadSetting);
  104. SpreadJsObj.initSheet(leafXmjSpread.getActiveSheet(), leafXmjSpreadSetting);
  105. const leafXmjSheet = leafXmjSpread.getActiveSheet();
  106. let gclData = [];
  107. // 获取项目节数据
  108. function loadLeafXmjData(iGclRow) {
  109. const gcl = gclData[iGclRow];
  110. SpreadJsObj.resetTopAndSelect(leafXmjSheet);
  111. if (gcl) {
  112. SpreadJsObj.loadSheetData(leafXmjSheet, SpreadJsObj.DataType.Data, gcl.leafXmjs);
  113. } else {
  114. SpreadJsObj.loadSheetData(leafXmjSheet, SpreadJsObj.DataType.Data, []);
  115. }
  116. }
  117. // 切换清单行,读取所属项目节数据
  118. gclSpread.getActiveSheet().bind(spreadNS.Events.SelectionChanged, function (e, info) {
  119. const iNewRow = info.newSelections[0].row;
  120. if (!info.oldSelections || iNewRow !== info.oldSelections[0].row) {
  121. loadLeafXmjData(iNewRow);
  122. }
  123. });
  124. function generateChapterHtml(data) {
  125. const html = [];
  126. if (data) {
  127. for (const d of data) {
  128. if (['1000', '1100', '1200', '1300'].indexOf(d.code) >= 0) {
  129. if (checkZero(d.total_price) && checkZero(d.deal_bills_tp)) {
  130. continue;
  131. }
  132. }
  133. html.push('<tr>');
  134. if (d.code) {
  135. html.push('<td>', d.code, '</td>');
  136. html.push('<td>', d.name, '</td>');
  137. } else {
  138. html.push('<td colspan="2">', d.name, '</td>');
  139. }
  140. html.push('<td class="text-right">', d.deal_bills_tp ? d.deal_bills_tp : '', '</td>');
  141. html.push('<td class="text-right">', d.new_total_price ? d.new_total_price : '', '</td>');
  142. html.push('<td class="text-right">', d.org_total_price ? d.org_total_price : '', '</td>');
  143. html.push('</tr>');
  144. }
  145. }
  146. $('#chapter-list').html(html.join(''));
  147. }
  148. postData('load', {filter: 'bills;pos;reviseBills;revisePos;dealBills;spec'}, function (data) {
  149. const setting = {
  150. tree: {
  151. id: 'ledger_id',
  152. pid: 'ledger_pid',
  153. order: 'order',
  154. level: 'level',
  155. rootId: -1,
  156. keys: ['id', 'tender_id', 'ledger_id'],
  157. stageId: 'id',
  158. },
  159. pos: { id: 'id', ledgerId: 'lid' },
  160. billsFields: ['quantity', 'total_price'],
  161. posFields: ['quantity'],
  162. chapterFields: ['total_price'],
  163. };
  164. gclCompareModel.init(gclData, chapter, data.spec);
  165. setting.prefix = 'new_';
  166. gclCompareModel.gatherLedgerData(data.reviseBills, data.revisePos, setting);
  167. setting.prefix = 'org_';
  168. gclCompareModel.gatherLedgerData(data.bills, data.pos, setting);
  169. gclCompareModel.gatherDealBills(data.dealBills);
  170. gclCompareModel.checkDiffer();
  171. SpreadJsObj.loadSheetData(gclSheet, SpreadJsObj.DataType.Data, gclData);
  172. loadLeafXmjData(0);
  173. const chapterData = gclCompareModel.chapterData();
  174. generateChapterHtml(chapterData);
  175. }, null, true);
  176. // 展开收起附件
  177. $('a', '.right-nav').bind('click', function () {
  178. const tab = $(this), tabPanel = $(tab.attr('content'));
  179. if (!tab.hasClass('active')) {
  180. $('a', '.side-menu').removeClass('active');
  181. $('.tab-content .tab-select-show').removeClass('active');
  182. tab.addClass('active');
  183. tabPanel.addClass('active');
  184. showTools(tab.hasClass('active'));
  185. } else {
  186. tab.removeClass('active');
  187. tabPanel.removeClass('active');
  188. showTools(tab.hasClass('active'));
  189. }
  190. gclSpread.refresh();
  191. leafXmjSpread.refresh();
  192. });
  193. $.subMenu({
  194. menu: '#sub-menu', miniMenu: '#sub-mini-menu', miniMenuList: '#mini-menu-list',
  195. toMenu: '#to-menu', toMiniMenu: '#to-mini-menu',
  196. key: 'menu.1.0.0',
  197. miniHint: '#sub-mini-hint', hintKey: 'menu.hint.1.0.1',
  198. callback: function (info) {
  199. if (info.mini) {
  200. $('.panel-title').addClass('fluid');
  201. $('#sub-menu').removeClass('panel-sidebar');
  202. } else {
  203. $('.panel-title').removeClass('fluid');
  204. $('#sub-menu').addClass('panel-sidebar');
  205. }
  206. autoFlashHeight();
  207. gclSpread.refresh();
  208. leafXmjSpread.refresh();
  209. }
  210. });
  211. $.divResizer({
  212. select: '#main-resize',
  213. callback: function () {
  214. gclSpread.refresh();
  215. let bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0;
  216. $(".sp-wrap").height(bcontent-30);
  217. leafXmjSpread.refresh();
  218. }
  219. });
  220. $('input[name=compareTag]').change(() => {
  221. compareTag = $('input[name=compareTag]:checked').val();
  222. SpreadJsObj.reLoadSheetData(gclSheet);
  223. });
  224. });