ledger_audit.js 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300
  1. 'use strict';
  2. /**
  3. *
  4. *
  5. * @author Mai
  6. * @date 2018/5/30
  7. * @version
  8. */
  9. const ckBillsSpread = window.location.pathname + '-billsSelect';
  10. function getTenderId() {
  11. return window.location.pathname.split('/')[2];
  12. }
  13. function checkTzMeasureType () {
  14. return tender.measure_type === measureType.tz.value;
  15. }
  16. $(document).ready(() => {
  17. autoFlashHeight();
  18. const ledgerSpread = SpreadJsObj.createNewSpread($('#ledger-spread')[0]);
  19. const treeSetting = {
  20. id: 'ledger_id',
  21. pid: 'ledger_pid',
  22. order: 'order',
  23. level: 'level',
  24. rootId: -1,
  25. keys: ['id', 'tender_id', 'ledger_id'],
  26. preUrl: '/ledger',
  27. autoExpand: 3,
  28. // markFoldKey: 'bills-fold',
  29. // markFoldSubKey: window.location.pathname.split('/')[2],
  30. markExpandKey: 'bills-expand',
  31. markExpandSubKey: window.location.pathname.split('/')[2],
  32. };
  33. if (checkTzMeasureType()) {
  34. treeSetting.calcFields = ['sgfh_tp', 'sjcl_tp', 'qtcl_tp', 'total_price'];
  35. } else {
  36. treeSetting.calcFields = ['deal_tp', 'sgfh_tp', 'sjcl_tp', 'qtcl_tp', 'total_price'];
  37. }
  38. const ledgerTree = createNewPathTree('fx', treeSetting);
  39. sjsSettingObj.setFxTreeStyle(ledgerSpreadSetting, sjsSettingObj.FxTreeStyle.jz);
  40. if (thousandth) sjsSettingObj.setTpThousandthFormat(ledgerSpreadSetting);
  41. SpreadJsObj.initSheet(ledgerSpread.getActiveSheet(), ledgerSpreadSetting);
  42. // 初始化 部位明细
  43. const pos = new PosData({
  44. id: 'id', ledgerId: 'lid',
  45. });
  46. const posSpread = SpreadJsObj.createNewSpread($('#pos-spread')[0]);
  47. const posSearch = $.posSearch({selector: '#pos-search', searchSpread: posSpread});
  48. $.subMenu({
  49. menu: '#sub-menu', miniMenu: '#sub-mini-menu', miniMenuList: '#mini-menu-list',
  50. toMenu: '#to-menu', toMiniMenu: '#to-mini-menu',
  51. key: 'menu.1.0.0',
  52. miniHint: '#sub-mini-hint', hintKey: 'menu.hint.1.0.1',
  53. callback: function (info) {
  54. if (info.mini) {
  55. $('.panel-title').addClass('fluid');
  56. $('#sub-menu').removeClass('panel-sidebar');
  57. } else {
  58. $('.panel-title').removeClass('fluid');
  59. $('#sub-menu').addClass('panel-sidebar');
  60. }
  61. autoFlashHeight();
  62. ledgerSpread.refresh();
  63. posSpread.refresh();
  64. }
  65. });
  66. const loadCurPosData = function () {
  67. const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
  68. SpreadJsObj.resetTopAndSelect(posSpread.getActiveSheet());
  69. if (node) {
  70. const posData = pos.ledgerPos[itemsPre + node.id] || [];
  71. SpreadJsObj.loadSheetData(posSpread.getActiveSheet(), 'data', posData);
  72. } else {
  73. SpreadJsObj.loadSheetData(posSpread.getActiveSheet(), 'data', []);
  74. }
  75. };
  76. // 台账模式加载部位明细数据
  77. if (checkTzMeasureType()) {
  78. $.divResizer({
  79. select: '#main-resize',
  80. callback: function () {
  81. ledgerSpread.refresh();
  82. let bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0;
  83. $(".sp-wrap").height(bcontent-30);
  84. posSpread.refresh();
  85. }
  86. });
  87. sjsSettingObj.setGridSelectStyle(posSpreadSetting);
  88. SpreadJsObj.initSheet(posSpread.getActiveSheet(), posSpreadSetting);
  89. }
  90. $.contextMenu({
  91. selector: '#ledger-spread',
  92. build: function ($trigger, e) {
  93. const target = SpreadJsObj.safeRightClickSelection($trigger, e, ledgerSpread);
  94. return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader;
  95. },
  96. items: {
  97. showLast: {
  98. name: '显示至最底层',
  99. callback: function (key, opt, menu, e) {
  100. const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
  101. setTimeout(() => {
  102. showWaitingView();
  103. ledgerTree.expandByCustom(x => {
  104. return x.expanded || (x.id === node.id) || (x.full_path.indexOf(node.ledger_id + '-') >= 0);
  105. });
  106. SpreadJsObj.refreshTreeRowVisible(ledgerSpread.getActiveSheet());
  107. closeWaitingView();
  108. }, 100);
  109. },
  110. },
  111. }
  112. });
  113. postData('/tender/' + getTenderId() + '/ledger/load', null, function (data) {
  114. ledgerTree.loadDatas(data.bills);
  115. treeCalc.calculateAll(ledgerTree);
  116. SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), 'tree', ledgerTree);
  117. SpreadJsObj.loadTopAndSelect(ledgerSpread.getActiveSheet(), ckBillsSpread);
  118. checkShowLast(data.bills.length);
  119. pos.loadDatas(data.pos);
  120. loadCurPosData();
  121. SpreadJsObj.resetTopAndSelect(posSpread.getActiveSheet());
  122. }, null, true);
  123. ledgerSpread.bind(spreadNS.Events.SelectionChanged, function (e, info) {
  124. loadCurPosData();
  125. SpreadJsObj.saveTopAndSelect(info.sheet, ckBillsSpread);
  126. posSearch.search($('#pos-keyword').val());
  127. });
  128. ledgerSpread.bind(spreadNS.Events.TopRowChanged, function (e, info) {
  129. SpreadJsObj.saveTopAndSelect(info.sheet, ckBillsSpread);
  130. });
  131. let dealBills, searchLedger;
  132. $.divResizer({
  133. select: '#right-spr',
  134. callback: function () {
  135. ledgerSpread.refresh();
  136. if (posSpread) {
  137. posSpread.refresh();
  138. }
  139. if (dealBills) {
  140. dealBills.spread.refresh();
  141. }
  142. }
  143. });
  144. // 展开收起 签约清单|清单意见
  145. $('a', '.side-menu').bind('click', function () {
  146. const tab = $(this), tabPanel = $(tab.attr('content'));
  147. const showSideTools = function (show) {
  148. const left = $('#left-view'), right = $('#right-view'), parent = left.parent();
  149. if (show) {
  150. right.show();
  151. autoFlashHeight();
  152. /**
  153. * right.show()后, parent被撑开成2倍left.height, 导致parent.width减少了10px
  154. * 第一次left.width调整后,parent的缩回left.height, 此时parent.width又增加了10px
  155. * 故需要通过最终的parent.width再计算一次left.width
  156. *
  157. * Q: 为什么不通过先计算left.width的宽度,以避免计算两次left.width?
  158. * A: 右侧工具栏不一定显示,当右侧工具栏显示过一次后,就必须使用parent和right来计算left.width
  159. *
  160. */
  161. // left.css('width', parent.width() - right.outerWidth());
  162. // left.css('width', parent.width() - right.outerWidth());
  163. const percent = 100 - right.outerWidth() /parent.width() * 100;
  164. left.css('width', percent + '%');
  165. } else {
  166. left.width(parent.width());
  167. right.hide();
  168. }
  169. };
  170. if (!tab.hasClass('active')) {
  171. $('a', '.side-menu').removeClass('active');
  172. tab.addClass('active');
  173. $('.tab-content .tab-pane').removeClass('active');
  174. tabPanel.addClass('active');
  175. showSideTools(tab.hasClass('active'));
  176. if (tab.attr('content') === '#deal-bills' && !dealBills) {
  177. dealBills = new DealBills($('#deal-bills-spread')[0], {
  178. cols: [
  179. {title: '清单编号', field: 'code', width: 85, formatter: '@', readOnly: true},
  180. {title: '名称', field: 'name', width: 150, formatter: '@', readOnly: true},
  181. {title: '单位', field: 'unit', width: 50, formatter: '@', readOnly: true},
  182. {title: '单价', field: 'unit_price', width: 50, readOnly: true},
  183. {title: '数量', field: 'quantity', width: 50, readOnly: true},
  184. {title: '金額', field: 'total_price', width: 50, readOnly: true},
  185. ],
  186. emptyRows: 0,
  187. headRows: 1,
  188. headRowHeight: [32],
  189. defaultRowHeight: 21,
  190. headerFont: '12px 微软雅黑',
  191. font: '12px 微软雅黑',
  192. headColWidth: [30],
  193. selectedBackColor: '#fffacd',
  194. });
  195. dealBills.loadData();
  196. } else if (tab.attr('content') === '#search' && !searchLedger) {
  197. if (!searchLedger) {
  198. searchLedger = $.billsSearch({
  199. selector: '#search',
  200. searchSpread: ledgerSpread,
  201. resultSpreadSetting: {
  202. cols: [
  203. {title: '项目节编号', field: 'code', hAlign: 0, width: 90, formatter: '@', readOnly: true},
  204. {title: '清单编号', field: 'b_code', hAlign: 0, width: 80, formatter: '@', readOnly: true},
  205. {title: '名称', field: 'name', width: 150, hAlign: 0, formatter: '@', readOnly: true},
  206. {title: '单位', field: 'unit', width: 50, hAlign: 1, formatter: '@', readOnly: true},
  207. {title: '单价', field: 'unit_price', hAlign: 2, width: 50, readOnly: true},
  208. {title: '数量', field: 'quantity', hAlign: 2, width: 50, readOnly: true},
  209. ],
  210. emptyRows: 0,
  211. headRows: 1,
  212. headRowHeight: [32],
  213. headColWidth: [30],
  214. defaultRowHeight: 21,
  215. headerFont: '12px 微软雅黑',
  216. font: '12px 微软雅黑',
  217. selectedBackColor: '#fffacd',
  218. },
  219. afterLocated: function () {
  220. loadCurPosData();
  221. }
  222. });
  223. }
  224. searchLedger.spread.refresh();
  225. }
  226. } else {
  227. tab.removeClass('active');
  228. tabPanel.removeClass('active');
  229. showSideTools(tab.hasClass('active'));
  230. }
  231. ledgerSpread.refresh();
  232. if (posSpread) {
  233. posSpread.refresh();
  234. }
  235. });
  236. class DealBills {
  237. constructor (obj, spreadSetting) {
  238. this.obj = obj;
  239. this.url = '/tender/' + getTenderId() + '/deal';
  240. this.spreadSetting = spreadSetting;
  241. this.spread = SpreadJsObj.createNewSpread(this.obj);
  242. SpreadJsObj.initSheet(this.spread.getActiveSheet(), this.spreadSetting);
  243. }
  244. loadData () {
  245. const self = this;
  246. postData(this.url+'/get-data', {}, function (data) {
  247. SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', data);
  248. });
  249. }
  250. }
  251. // 显示层次
  252. (function (select, sheet) {
  253. $(select).click(function () {
  254. if (!sheet.zh_tree) return;
  255. const tag = $(this).attr('tag');
  256. const tree = sheet.zh_tree;
  257. setTimeout(() => {
  258. showWaitingView();
  259. switch (tag) {
  260. case "1":
  261. case "2":
  262. case "3":
  263. case "4":
  264. case "5":
  265. tree.expandByLevel(parseInt(tag));
  266. SpreadJsObj.refreshTreeRowVisible(sheet);
  267. break;
  268. case "last":
  269. tree.expandByCustom(() => { return true; });
  270. SpreadJsObj.refreshTreeRowVisible(sheet);
  271. break;
  272. case "leafXmj":
  273. tree.expandToLeafXmj();
  274. SpreadJsObj.refreshTreeRowVisible(sheet);
  275. break;
  276. }
  277. closeWaitingView();
  278. }, 100);
  279. });
  280. })('a[name=showLevel]', ledgerSpread.getActiveSheet());
  281. });
  282. // texterea换行
  283. function auditCheck(i) {
  284. const opinion = $('textarea[name="opinion"]').eq(i).val().replace(/\r\n/g, '<br/>').replace(/\n/g, '<br/>').replace(/\s/g, ' ');
  285. $('textarea[name="opinion"]').eq(i).val(opinion);
  286. return true;
  287. }