report.js 7.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159
  1. 'use strict';
  2. /**
  3. *
  4. *
  5. * @author Mai
  6. * @date
  7. * @version
  8. */
  9. module.exports = app => {
  10. class Report extends app.BaseService {
  11. /**
  12. * 构造函数
  13. *
  14. * @param {Object} ctx - egg全局context
  15. * @return {void}
  16. */
  17. constructor(ctx) {
  18. super(ctx);
  19. }
  20. async checkStg(ctx, params) {
  21. if (ctx.stage === null || ctx.stage === undefined || parseInt(ctx.stage.id) !== parseInt(params.stage_id)) {
  22. await ctx.service.stage.checkStage(params.stage_id);
  23. if (ctx.stage) {
  24. params.stage_order = ctx.stage.curOrder;
  25. }
  26. }
  27. }
  28. async getReportData(params, filters, memFieldKeys) {
  29. const service = this.ctx.service;
  30. const rst = {};
  31. const runnableRst = [];
  32. const runnableKey = []; // 这个配合runnableRst用,未来考虑并行查询优化
  33. for (const filter of filters) {
  34. if (runnableKey.indexOf(filter) < 0) {
  35. switch (filter) {
  36. case 'project' :
  37. runnableRst.push(service.project.getProjectById(params.project_id));
  38. runnableKey.push(filter);
  39. break;
  40. case 'tender_info' :
  41. runnableRst.push(service.tenderInfo.getTenderInfo(params.tender_id));
  42. runnableKey.push(filter);
  43. break;
  44. case 'deal_bills' :
  45. runnableRst.push(service.dealBills.getDataByTenderId(params.tender_id));
  46. runnableKey.push('deal_bills');
  47. break;
  48. case 'ledger' :
  49. runnableRst.push(service.ledger.getData(params.tender_id, 0));
  50. runnableKey.push(filter);
  51. break;
  52. case 'stage_bills':
  53. runnableRst.push(service.stageBills.getLastestStageData(params.tender_id, params.stage_id));
  54. runnableKey.push(filter);
  55. break;
  56. case 'stage_bills_final':
  57. await this.checkStg(this.ctx, params);
  58. runnableRst.push(service.stageBillsFinal.getFinalDataEx(params.tender_id, params.stage_order));
  59. runnableKey.push(filter);
  60. break;
  61. case 'stage':
  62. runnableRst.push(service.stage.getStageById(params.stage_id));
  63. runnableKey.push(filter);
  64. break;
  65. case 'stage_pay':
  66. await this.checkStg(this.ctx, params);
  67. runnableRst.push(service.stagePay.getAuditorStageData(params.stage_id, params.stage_times, params.stage_order));
  68. runnableKey.push(filter);
  69. break;
  70. case 'mem_stage_im_zl':
  71. runnableRst.push(service.reportMemory.getStageImZlData(params.tender_id, params.stage_id, memFieldKeys[filter]));
  72. runnableKey.push(filter);
  73. break;
  74. case 'mem_month_progress':
  75. runnableRst.push(service.reportMemory.getMonthProgress(params.tender_id, memFieldKeys[filter]));
  76. runnableKey.push(filter);
  77. break;
  78. case 'mem_stage_bills':
  79. runnableRst.push(service.reportMemory.getStageBillsData(params.tender_id, params.stage_id, memFieldKeys[filter]));
  80. runnableKey.push(filter);
  81. break;
  82. case 'mem_stage_pos':
  83. runnableRst.push(service.reportMemory.getStagePosData(params.tender_id, params.stage_id, memFieldKeys[filter]));
  84. runnableKey.push(filter);
  85. break;
  86. case 'mem_stage_pos_compare':
  87. runnableRst.push(service.reportMemory.getStagePosCompareData(params.tender_id, params.stage_id, memFieldKeys[filter]));
  88. runnableKey.push(filter);
  89. break;
  90. case 'mem_stage_bills_compare':
  91. runnableRst.push(service.reportMemory.getStageBillsCompareData(params.tender_id, params.stage_id, memFieldKeys[filter]));
  92. runnableKey.push(filter);
  93. break;
  94. case 'mem_stage_pay':
  95. runnableRst.push(service.reportMemory.getStagePayData(params.tender_id, params.stage_id, memFieldKeys[filter]));
  96. runnableKey.push(filter);
  97. break;
  98. case 'change':
  99. runnableRst.push(service.change.getListByStatus(params.tender_id, 3)); // 获取所有审核通过的变更主信息
  100. runnableKey.push(filter);
  101. break;
  102. case 'change_audit_list':
  103. runnableRst.push(service.changeAuditList.getChangeAuditBills(params.tender_id)); // 获取所有审核通过的变更清单
  104. runnableKey.push(filter);
  105. break;
  106. case 'mem_stage_jgcl':
  107. runnableRst.push(service.reportMemory.getStageJgcl(params.tender_id, params.stage_id, memFieldKeys[filter]));
  108. runnableKey.push(filter);
  109. break;
  110. case 'mem_stage_bonus':
  111. runnableRst.push(service.reportMemory.getStageBonus(params.tender_id, params.stage_id, memFieldKeys[filter]));
  112. runnableKey.push(filter);
  113. break;
  114. case 'mem_stage_other':
  115. case 'mem_stage_other':
  116. runnableRst.push(service.reportMemory.getStageOther(params.tender_id, params.stage_id, memFieldKeys[filter]));
  117. runnableKey.push(filter);
  118. break;
  119. default:
  120. break;
  121. }
  122. }
  123. }
  124. const queryRst = await Promise.all(runnableRst);
  125. for (let idx = 0; idx < runnableKey.length; idx++) {
  126. rst[runnableKey[idx]] = queryRst[idx];
  127. }
  128. for (const filter of filters) {
  129. switch (filter) {
  130. case 'mem_stage_im_tz':
  131. rst[filter] = await service.reportMemory.getStageImTzData(params.tender_id, params.stage_id, memFieldKeys[filter]);
  132. break;
  133. case 'mem_stage_im_tz_bills':
  134. rst[filter] = await service.reportMemory.getStageImTzBillsData(params.tender_id, params.stage_id, memFieldKeys[filter]);
  135. break;
  136. case 'mem_union_data':
  137. rst[filter] = [];
  138. break;
  139. case 'mem_change':
  140. rst[filter] = await service.reportMemory.getChangeData(params.tender_id, params.stage_id, memFieldKeys[filter]);
  141. break;
  142. case 'mem_change_bills':
  143. rst[filter] = await service.reportMemory.getChangeBillsData(params.tender_id, params.stage_id, memFieldKeys[filter]);
  144. break;
  145. default:
  146. break;
  147. }
  148. }
  149. return rst;
  150. }
  151. }
  152. return Report;
  153. };