ledger_audit.js 12 KB

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