rpt_gather_memory.js 55 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081
  1. 'use strict';
  2. /**
  3. *
  4. *
  5. * @author Mai
  6. * @date
  7. * @version
  8. */
  9. const Ledger = require('../lib/ledger');
  10. const PayCalculator = require('../lib/pay_calc');
  11. const auditConst = require('../const/audit');
  12. const payConst = require('../const/deal_pay');
  13. const moment = require('moment');
  14. const indexPre = 'id_';
  15. const normalPrefix = 't_', sumPrefix = 's_', specPrefix = 'ts_';
  16. const gatherUtils = {
  17. completeGatherData: function (datas, completeDatas) {
  18. for (const data of datas) {
  19. for (const cd of completeDatas) {
  20. data[cd.prefix + 'id'] = cd.id;
  21. data[cd.prefix + 'name'] = cd.name;
  22. data[cd.prefix + 'category'] = cd.category;
  23. }
  24. }
  25. },
  26. gatherStage: function (tender, gatherNode, sourceNode, prefix, helper) {
  27. gatherNode[prefix + 'id'] = tender.id;
  28. gatherNode[prefix + 'name'] = tender.name;
  29. gatherNode[prefix + 'category'] = tender.category;
  30. gatherNode[prefix + "qty"] = helper.add(gatherNode[prefix + "qty"], sourceNode.quantity);
  31. gatherNode[prefix + "tp"] = helper.add(gatherNode[prefix + "tp"], sourceNode.total_price);
  32. gatherNode[prefix + "dgn_qty1"] = helper.add(gatherNode[prefix + "dgn_qty1"], sourceNode.dgn_qty1);
  33. gatherNode[prefix + "dgn_qty2"] = helper.add(gatherNode[prefix + "dgn_qty2"], sourceNode.dgn_qty2);
  34. gatherNode[prefix + "contract_qty"] = helper.add(gatherNode[prefix + "contract_qty"], sourceNode.contract_qty);
  35. gatherNode[prefix + "contract_tp"] = helper.add(gatherNode[prefix + "contract_tp"], sourceNode.contract_tp);
  36. gatherNode[prefix + "qc_qty"] = helper.add(gatherNode[prefix + "qc_qty"], sourceNode.qc_qty);
  37. gatherNode[prefix + "qc_tp"] = helper.add(gatherNode[prefix + "qc_tp"], sourceNode.qc_tp);
  38. gatherNode[prefix + "gather_qty"] = helper.add(gatherNode[prefix + "gather_qty"], sourceNode.gather_qty);
  39. gatherNode[prefix + "gather_tp"] = helper.add(gatherNode[prefix + "gather_tp"], sourceNode.gather_tp);
  40. gatherNode[prefix + 'pc_tp'] = helper.add(gatherNode[prefix + 'pc_tp'], sourceNode.pc_tp);
  41. gatherNode[prefix + "pre_contract_qty"] = helper.add(gatherNode[prefix + "pre_contract_qty"], sourceNode.pre_contract_qty);
  42. gatherNode[prefix + "pre_contract_tp"] = helper.add(gatherNode[prefix + "pre_contract_tp"], sourceNode.pre_contract_tp);
  43. gatherNode[prefix + "pre_qc_qty"] = helper.add(gatherNode[prefix + "pre_qc_qty"], sourceNode.pre_qc_qty);
  44. gatherNode[prefix + "pre_qc_tp"] = helper.add(gatherNode[prefix + "pre_qc_tp"], sourceNode.pre_qc_tp);
  45. gatherNode[prefix + "pre_gather_qty"] = helper.add(gatherNode[prefix + "pre_gather_qty"], sourceNode.pre_gather_qty);
  46. gatherNode[prefix + "pre_gather_tp"] = helper.add(gatherNode[prefix + "pre_gather_tp"], sourceNode.pre_gather_tp);
  47. gatherNode[prefix + "end_contract_qty"] = helper.add(gatherNode[prefix + "end_contract_qty"], sourceNode.end_contract_qty);
  48. gatherNode[prefix + "end_contract_tp"] = helper.add(gatherNode[prefix + "end_contract_tp"], sourceNode.end_contract_tp);
  49. gatherNode[prefix + "end_qc_qty"] = helper.add(gatherNode[prefix + "end_qc_qty"], sourceNode.end_qc_qty);
  50. gatherNode[prefix + "end_qc_tp"] = helper.add(gatherNode[prefix + "end_qc_tp"], sourceNode.end_qc_tp);
  51. gatherNode[prefix + "end_gather_qty"] = helper.add(gatherNode[prefix + "end_gather_qty"], sourceNode.end_gather_qty);
  52. gatherNode[prefix + "end_gather_tp"] = helper.add(gatherNode[prefix + "end_gather_tp"], sourceNode.end_gather_tp);
  53. gatherNode[prefix + "deal_dgn_qty1"] = helper.add(gatherNode[prefix + "deal_dgn_qty1"], sourceNode.deal_dgn_qty1);
  54. gatherNode[prefix + "deal_dgn_qty2"] = helper.add(gatherNode[prefix + "deal_dgn_qty2"], sourceNode.deal_dgn_qty2);
  55. gatherNode[prefix + "c_dgn_qty1"] = helper.add(gatherNode[prefix + "c_dgn_qty1"], sourceNode.c_dgn_qty1);
  56. gatherNode[prefix + "c_dgn_qty2"] = helper.add(gatherNode[prefix + "c_dgn_qty2"], sourceNode.c_dgn_qty2);
  57. gatherNode.s_qty = helper.add(gatherNode.s_qty, sourceNode.quantity);
  58. gatherNode.s_tp = helper.add(gatherNode.s_tp, sourceNode.total_price);
  59. gatherNode.s_dgn_qty1 = helper.add(gatherNode.s_dgn_qty1, sourceNode.dgn_qty1);
  60. gatherNode.s_dgn_qty2 = helper.add(gatherNode.s_dgn_qty2, sourceNode.dgn_qty2);
  61. gatherNode.s_contract_qty = helper.add(gatherNode.s_contract_qty, sourceNode.contract_qty);
  62. gatherNode.s_contract_tp = helper.add(gatherNode.s_contract_tp, sourceNode.contract_tp);
  63. gatherNode.s_qc_qty = helper.add(gatherNode.s_qc_qty, sourceNode.qc_qty);
  64. gatherNode.s_qc_tp = helper.add(gatherNode.s_qc_tp, sourceNode.qc_tp);
  65. gatherNode.s_gather_qty = helper.add(gatherNode.s_gather_qty, sourceNode.gather_qty);
  66. gatherNode.s_gather_tp = helper.add(gatherNode.s_gather_tp, sourceNode.gather_tp);
  67. gatherNode.s_pc_tp = helper.add(gatherNode.s_pc_tp, sourceNode.pc_tp);
  68. gatherNode.s_pre_contract_qty = helper.add(gatherNode.s_pre_contract_qty, sourceNode.pre_contract_qty);
  69. gatherNode.s_pre_contract_tp = helper.add(gatherNode.s_pre_contract_tp, sourceNode.pre_contract_tp);
  70. gatherNode.s_pre_qc_qty = helper.add(gatherNode.s_pre_qc_qty, sourceNode.pre_qc_qty);
  71. gatherNode.s_pre_qc_tp = helper.add(gatherNode.s_pre_qc_tp, sourceNode.pre_qc_tp);
  72. gatherNode.s_pre_gather_qty = helper.add(gatherNode.s_pre_gather_qty, sourceNode.pre_gather_qty);
  73. gatherNode.s_pre_gather_tp = helper.add(gatherNode.s_pre_gather_tp, sourceNode.pre_gather_tp);
  74. gatherNode.s_end_contract_qty = helper.add(gatherNode.s_end_contract_qty, sourceNode.end_contract_qty);
  75. gatherNode.s_end_contract_tp = helper.add(gatherNode.s_end_contract_tp, sourceNode.end_contract_tp);
  76. gatherNode.s_end_qc_qty = helper.add(gatherNode.s_end_qc_qty, sourceNode.end_qc_qty);
  77. gatherNode.s_end_qc_tp = helper.add(gatherNode.s_end_qc_tp, sourceNode.end_qc_tp);
  78. gatherNode.s_end_gather_qty = helper.add(gatherNode.s_end_gather_qty, sourceNode.end_gather_qty);
  79. gatherNode.s_end_gather_tp = helper.add(gatherNode.s_end_gather_tp, sourceNode.end_gather_tp);
  80. gatherNode.s_deal_dgn_qty1 = helper.add(gatherNode.s_deal_dgn_qty1, sourceNode.deal_dgn_qty1);
  81. gatherNode.s_deal_dgn_qty2 = helper.add(gatherNode.s_deal_dgn_qty2, sourceNode.deal_dgn_qty2);
  82. gatherNode.s_c_dgn_qty1 = helper.add(gatherNode.s_c_dgn_qty1, sourceNode.c_dgn_qty1);
  83. gatherNode.s_c_dgn_qty2 = helper.add(gatherNode.s_c_dgn_qty2, sourceNode.c_dgn_qty2);
  84. },
  85. gatherZone: function (tender, gatherNode, sourceNode, prefix, helper) {
  86. gatherNode[prefix + 'id'] = tender.id;
  87. gatherNode[prefix + 'name'] = tender.name;
  88. gatherNode[prefix + 'category'] = tender.category;
  89. gatherNode[prefix + "qty"] = helper.add(gatherNode[prefix + "qty"], sourceNode.quantity);
  90. gatherNode[prefix + "tp"] = helper.add(gatherNode[prefix + "tp"], sourceNode.total_price);
  91. gatherNode[prefix + "dgn_qty1"] = helper.add(gatherNode[prefix + "dgn_qty1"], sourceNode.dgn_qty1);
  92. gatherNode[prefix + "dgn_qty2"] = helper.add(gatherNode[prefix + "dgn_qty2"], sourceNode.dgn_qty2);
  93. gatherNode[prefix + "contract_qty"] = helper.add(gatherNode[prefix + "contract_qty"], sourceNode.contract_qty);
  94. gatherNode[prefix + "contract_tp"] = helper.add(gatherNode[prefix + "contract_tp"], sourceNode.contract_tp);
  95. gatherNode[prefix + "qc_qty"] = helper.add(gatherNode[prefix + "qc_qty"], sourceNode.qc_qty);
  96. gatherNode[prefix + "qc_tp"] = helper.add(gatherNode[prefix + "qc_tp"], sourceNode.qc_tp);
  97. gatherNode[prefix + "gather_qty"] = helper.add(gatherNode[prefix + "gather_qty"], sourceNode.gather_qty);
  98. gatherNode[prefix + "gather_tp"] = helper.add(gatherNode[prefix + "gather_tp"], sourceNode.gather_tp);
  99. gatherNode[prefix + 'pc_tp'] = helper.add(gatherNode[prefix + 'pc_tp'], sourceNode.pc_tp);
  100. gatherNode[prefix + "deal_dgn_qty1"] = helper.add(gatherNode[prefix + "deal_dgn_qty1"], sourceNode.deal_dgn_qty1);
  101. gatherNode[prefix + "deal_dgn_qty2"] = helper.add(gatherNode[prefix + "deal_dgn_qty2"], sourceNode.deal_dgn_qty2);
  102. gatherNode[prefix + "c_dgn_qty1"] = helper.add(gatherNode[prefix + "c_dgn_qty1"], sourceNode.c_dgn_qty1);
  103. gatherNode[prefix + "c_dgn_qty2"] = helper.add(gatherNode[prefix + "c_dgn_qty2"], sourceNode.c_dgn_qty2);
  104. gatherNode.s_qty = helper.add(gatherNode.s_qty, sourceNode.quantity);
  105. gatherNode.s_tp = helper.add(gatherNode.s_tp, sourceNode.total_price);
  106. gatherNode.s_contract_qty = helper.add(gatherNode.s_contract_qty, sourceNode.contract_qty);
  107. gatherNode.s_contract_tp = helper.add(gatherNode.s_contract_tp, sourceNode.contract_tp);
  108. gatherNode.s_qc_qty = helper.add(gatherNode.s_qc_qty, sourceNode.qc_qty);
  109. gatherNode.s_qc_tp = helper.add(gatherNode.s_qc_tp, sourceNode.qc_tp);
  110. gatherNode.s_gather_qty = helper.add(gatherNode.s_gather_qty, sourceNode.gather_qty);
  111. gatherNode.s_gather_tp = helper.add(gatherNode.s_gather_tp, sourceNode.gather_tp);
  112. gatherNode.s_pc_tp = helper.add(gatherNode.s_pc_tp, sourceNode.pc_tp);
  113. },
  114. gatherLedger: function (tender, gatherNode, sourceNode, prefix, helper) {
  115. gatherNode[prefix + 'id'] = tender.id;
  116. gatherNode[prefix + 'name'] = tender.name;
  117. gatherNode[prefix + 'category'] = tender.category;
  118. gatherNode[prefix + "qty"] = helper.add(gatherNode[prefix + "qty"], sourceNode.quantity);
  119. gatherNode[prefix + "tp"] = helper.add(gatherNode[prefix + "tp"], sourceNode.total_price);
  120. gatherNode[prefix + "dgn_qty1"] = helper.add(gatherNode[prefix + "dgn_qty1"], sourceNode.dgn_qty1);
  121. gatherNode[prefix + "dgn_qty2"] = helper.add(gatherNode[prefix + "dgn_qty2"], sourceNode.dgn_qty2);
  122. gatherNode.s_qty = helper.add(gatherNode.s_qty, sourceNode.quantity);
  123. gatherNode.s_tp = helper.add(gatherNode.s_tp, sourceNode.total_price);
  124. },
  125. gatherSpecial: function (gatherNode, sourceNode, prefix, helper) {
  126. gatherNode[prefix + "qty"] = helper.add(gatherNode[prefix + "qty"], sourceNode.quantity);
  127. gatherNode[prefix + "tp"] = helper.add(gatherNode[prefix + "tp"], sourceNode.total_price);
  128. gatherNode[prefix + "dgn_qty1"] = helper.add(gatherNode[prefix + "dgn_qty1"], sourceNode.dgn_qty1);
  129. gatherNode[prefix + "dgn_qty2"] = helper.add(gatherNode[prefix + "dgn_qty2"], sourceNode.dgn_qty2);
  130. },
  131. gatherStagePos: function (tender, gatherNode, sourceNode, prefix, helper) {
  132. gatherNode[prefix + 'id'] = tender.id;
  133. gatherNode[prefix + 'name'] = tender.name;
  134. gatherNode[prefix + 'category'] = tender.category;
  135. gatherNode[prefix + "qty"] = helper.add(gatherNode[prefix + "qty"], sourceNode.quantity);
  136. gatherNode[prefix + "contract_qty"] = helper.add(gatherNode[prefix + "contract_qty"], sourceNode.contract_qty);
  137. gatherNode[prefix + "qc_qty"] = helper.add(gatherNode[prefix + "qc_qty"], sourceNode.qc_qty);
  138. gatherNode[prefix + "gather_qty"] = helper.add(gatherNode[prefix + "gather_qty"], sourceNode.gather_qty);
  139. gatherNode[prefix + "pre_contract_qty"] = helper.add(gatherNode[prefix + "pre_contract_qty"], sourceNode.pre_contract_qty);
  140. gatherNode[prefix + "pre_qc_qty"] = helper.add(gatherNode[prefix + "pre_qc_qty"], sourceNode.pre_qc_qty);
  141. gatherNode[prefix + "pre_gather_qty"] = helper.add(gatherNode[prefix + "pre_gather_qty"], sourceNode.pre_gather_qty);
  142. gatherNode[prefix + "end_contract_qty"] = helper.add(gatherNode[prefix + "end_contract_qty"], sourceNode.end_contract_qty);
  143. gatherNode[prefix + "end_qc_qty"] = helper.add(gatherNode[prefix + "end_qc_qty"], sourceNode.end_qc_qty);
  144. gatherNode[prefix + "end_gather_qty"] = helper.add(gatherNode[prefix + "end_gather_qty"], sourceNode.end_gather_qty);
  145. gatherNode.s_qty = helper.add(gatherNode.s_qty, sourceNode.quantity);
  146. gatherNode.s_contract_qty = helper.add(gatherNode.s_contract_qty, sourceNode.contract_qty);
  147. gatherNode.s_qc_qty = helper.add(gatherNode.s_qc_qty, sourceNode.qc_qty);
  148. gatherNode.s_gather_qty = helper.add(gatherNode.s_gather_qty, sourceNode.gather_qty);
  149. gatherNode.s_pre_contract_qty = helper.add(gatherNode.s_pre_contract_qty, sourceNode.pre_contract_qty);
  150. gatherNode.s_pre_qc_qty = helper.add(gatherNode.s_pre_qc_qty, sourceNode.pre_qc_qty);
  151. gatherNode.s_pre_gather_qty = helper.add(gatherNode.s_pre_gather_qty, sourceNode.pre_gather_qty);
  152. gatherNode.s_end_contract_qty = helper.add(gatherNode.s_end_contract_qty, sourceNode.end_contract_qty);
  153. gatherNode.s_end_qc_qty = helper.add(gatherNode.s_end_qc_qty, sourceNode.end_qc_qty);
  154. gatherNode.s_end_gather_qty = helper.add(gatherNode.s_end_gather_qty, sourceNode.end_gather_qty);
  155. },
  156. gatherZonePos: function (tender, gatherNode, sourceNode, prefix, helper) {
  157. gatherNode[prefix + 'id'] = tender.id;
  158. gatherNode[prefix + 'name'] = tender.name;
  159. gatherNode[prefix + 'category'] = tender.category;
  160. gatherNode[prefix + "qty"] = helper.add(gatherNode[prefix + "qty"], sourceNode.quantity);
  161. gatherNode[prefix + "contract_qty"] = helper.add(gatherNode[prefix + "contract_qty"], sourceNode.contract_qty);
  162. gatherNode[prefix + "qc_qty"] = helper.add(gatherNode[prefix + "qc_qty"], sourceNode.qc_qty);
  163. gatherNode[prefix + "gather_qty"] = helper.add(gatherNode[prefix + "gather_qty"], sourceNode.gather_qty);
  164. gatherNode.s_qty = helper.add(gatherNode.s_qty, sourceNode.quantity);
  165. gatherNode.s_contract_qty = helper.add(gatherNode.s_contract_qty, sourceNode.contract_qty);
  166. gatherNode.s_qc_qty = helper.add(gatherNode.s_qc_qty, sourceNode.qc_qty);
  167. gatherNode.s_gather_qty = helper.add(gatherNode.s_gather_qty, sourceNode.gather_qty);
  168. },
  169. gatherPos: function (tender, gatherNode, sourceNode, prefix, helper) {
  170. gatherNode[prefix + 'id'] = tender.id;
  171. gatherNode[prefix + 'name'] = tender.name;
  172. gatherNode[prefix + 'category'] = tender.category;
  173. gatherNode[prefix + "qty"] = helper.add(gatherNode[prefix + "qty"], sourceNode.quantity);
  174. gatherNode.s_qty = helper.add(gatherNode.s_qty, sourceNode.quantity);
  175. },
  176. gatherSpecialPos: function (gatherNode, sourceNode, prefix, helper) {
  177. gatherNode[prefix + "qty"] = helper.add(gatherNode[prefix + "qty"], sourceNode.quantity);
  178. },
  179. };
  180. module.exports = app => {
  181. class RptGatherMemory extends app.BaseService {
  182. /**
  183. * 构造函数
  184. *
  185. * @param {Object} ctx - egg全局context
  186. * @return {void}
  187. */
  188. constructor(ctx) {
  189. super(ctx);
  190. this.resultTree = null;
  191. this.resultPos = null;
  192. this.resultTenderInfo = [];
  193. this.resultDealPay = [];
  194. this.resultDealBills = [];
  195. }
  196. async _getValidStages(tenderId) {
  197. const stages = await this.db.select(this.ctx.service.stage.tableName, {
  198. where: { tid: tenderId },
  199. orders: [['order', 'desc']],
  200. });
  201. if (stages.length !== 0) {
  202. const lastStage = stages[0];
  203. if (lastStage.status === auditConst.stage.status.uncheck && lastStage.user_id !== this.ctx.session.sessionUser.accountId) {
  204. stages.splice(0, 1);
  205. }
  206. }
  207. return stages;
  208. }
  209. async _getCheckedStages(tenderId) {
  210. const stages = await this.db.select(this.ctx.service.stage.tableName, {
  211. where: { tid: tenderId },
  212. orders: [['order', 'desc']],
  213. });
  214. if (stages.length !== 0) {
  215. const lastStage = stages[0];
  216. if (lastStage.status !== auditConst.stage.status.checked) {
  217. stages.splice(0, 1);
  218. }
  219. }
  220. return stages;
  221. }
  222. _checkSpecialTender(tender, special) {
  223. if (special) {
  224. for (const spec of special) {
  225. if (tender[spec.key] === true) return spec.key;
  226. }
  227. }
  228. return '';
  229. }
  230. async _getTimeZoneStages(tender, zone) {
  231. const times = zone.split(' - ');
  232. if (times.length !== 2) throw '选择的汇总周期无效';
  233. const beginTime = moment(times[0], 'YYYY-MM');
  234. const endTime = moment(times[1], 'YYYY-MM');
  235. const stages = await this._getValidStages(tender.id), validStages = [];
  236. for (const stage of stages) {
  237. const sTime = moment(stage.s_time, 'YYYY-MM');
  238. if (sTime.isBetween(beginTime, endTime, null, '[]')) {
  239. validStages.push(stage);
  240. }
  241. }
  242. return validStages;
  243. }
  244. async _getOrderZoneStages (tender, zone) {
  245. let [iBegin, iEnd] = zone.split(':');
  246. iBegin = this.ctx.helper._.toInteger(iBegin) || 0;
  247. iEnd = this.ctx.helper._.toInteger(iEnd) || 0;
  248. const stages = await this._getValidStages(tender.id), validStages = [];
  249. for (const stage of stages) {
  250. if (stage.order < iBegin || stage.order > iEnd) continue;
  251. validStages.push(stage);
  252. }
  253. return validStages;
  254. }
  255. async _getCheckedZoneStages(tender, zone) {
  256. console.log(zone);
  257. const times = zone.split(' - ');
  258. if (times.length !== 2) throw '选择的汇总周期无效';
  259. const beginTime = moment(times[0], 'YYYY-MM-DD');
  260. const endTime = moment(times[1], 'YYYY-MM-DD');
  261. const stages = await this._getValidStages(tender.id), validStages = [];
  262. for (const stage of stages) {
  263. if (stage.status !== auditConst.stage.status.checked) continue;
  264. const finalAudit = this.ctx.service.stageAudit.getLastestAuditor(stage.id, stage.times, stage.status);
  265. if (!finalAudit) continue;
  266. const sTime = moment(finalAudit.end_time);
  267. if (sTime.isBetween(beginTime, endTime, null, '[]')) {
  268. validStages.push(stage);
  269. }
  270. }
  271. return validStages;
  272. }
  273. /**
  274. * 台账数据
  275. */
  276. async _gatherStagesData(completeData, tender, stages) {
  277. const resultPos = this.resultPos;
  278. const helper = this.ctx.helper;
  279. completeData.id = tender.id;
  280. completeData.name = tender.name;
  281. /**
  282. * 汇总并合并 相关数据
  283. * @param {Array} index - 主数据
  284. * @param {Array[]}rela - 相关数据 {data, fields, prefix, relaId}
  285. */
  286. const sumAssignRelaData = function (index, rela) {
  287. const loadFields = function (datas, fields, prefix, relaId) {
  288. for (const d of datas) {
  289. const key = indexPre + d[relaId];
  290. const m = index[key];
  291. if (m) {
  292. for (const f of fields) {
  293. if (d[f] !== undefined) {
  294. m[prefix + f] = helper.add(m[prefix + f], d[f]);
  295. }
  296. }
  297. }
  298. }
  299. };
  300. for (const r of rela) {
  301. loadFields(r.data, r.fields, r.prefix, r.relaId);
  302. }
  303. };
  304. const billsTree = new Ledger.billsTree(this.ctx, {
  305. id: 'ledger_id',
  306. pid: 'ledger_pid',
  307. order: 'order',
  308. level: 'level',
  309. rootId: -1,
  310. keys: ['id', 'tender_id', 'ledger_id'],
  311. stageId: 'id',
  312. calcFields: ['deal_tp', 'total_price', 'contract_tp', 'qc_tp', 'gather_tp'],
  313. calc: function (node) {
  314. if (node.children && node.children.length === 0) {
  315. node.gather_qty = helper.add(node.contract_qty, node.qc_qty);
  316. }
  317. node.gather_tp = helper.add(node.contract_tp, node.qc_tp);
  318. }
  319. });
  320. const billsData = await this.ctx.service.ledger.getData(tender.id);
  321. const dgnData = await this.ctx.service.stageBillsDgn.getDgnData(tender.id);
  322. for (const d of dgnData) {
  323. const l = this.ctx.helper._.find(billsData, {id: d.id});
  324. this.ctx.helper._.assignIn(l, d);
  325. }
  326. const pos = new Ledger.pos({
  327. id: 'id', ledgerId: 'lid',
  328. calc: function (node) {
  329. node.gather_qty = helper.add(node.contract_qty, node.qc_qty);
  330. },
  331. });
  332. const posData = await this.ctx.service.pos.getAllDataByCondition({ where: { tid: tender.id} });
  333. let billsIndexData = {};
  334. for (const bd of billsData) {
  335. billsIndexData[indexPre + bd.id] = bd;
  336. }
  337. let posIndexData = {};
  338. for (const p of posData) {
  339. posIndexData[indexPre + p.id] = p;
  340. }
  341. for (const stage of stages) {
  342. await this.ctx.service.stage.doCheckStage(stage);
  343. const curStage = stage.readOnly
  344. ? await this.ctx.service.stageBills.getAuditorStageData2(tender.id, stage.id, stage.curTimes, stage.curOrder)
  345. : await this.ctx.service.stageBills.getLastestStageData2(tender.id, stage.id);
  346. const bpcStage = await this.ctx.service.stageBillsPc.getAllDataByCondition({ where: { sid: stage.id } });
  347. sumAssignRelaData(billsIndexData, [
  348. {data: curStage, fields: ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp'], prefix: '', relaId: 'lid'},
  349. { data: bpcStage, fields: ['contract_pc_tp', 'qc_pc_tp', 'pc_tp'], prefix: '', relaId: 'lid' },
  350. ]);
  351. const curStagePos = stage.readOnly
  352. ? await this.ctx.service.stagePos.getAuditorStageData2(tender.id, stage.id, stage.curTimes, stage.curOrder)
  353. : await this.ctx.service.stagePos.getLastestStageData2(tender.id, stage.id);
  354. sumAssignRelaData(posIndexData, [
  355. {data: curStagePos, fields: ['contract_qty', 'qc_qty'], prefix: '', relaId: 'pid'},
  356. ]);
  357. }
  358. billsTree.loadDatas(billsData);
  359. billsTree.calculateAll();
  360. pos.loadDatas(posData);
  361. pos.calculateAll();
  362. this.resultTree.loadGatherTree(billsTree, function (gatherNode, sourceNode) {
  363. gatherUtils.gatherZone(tender, gatherNode, sourceNode, completeData.prefix, helper);
  364. }, function (gatherNode, sourceNode) {
  365. const posRange = pos.getLedgerPos(sourceNode.id);
  366. if (!posRange || posRange.length === 0) return;
  367. resultPos.loadGatherPos(gatherNode.id, posRange, (gatherPos, sourcePos) => {
  368. gatherUtils.gatherZonePos(tender, gatherPos, sourcePos, completeData.prefix, helper);
  369. });
  370. });
  371. }
  372. async _gatherZoneData(tender, completeData, zone) {
  373. const stages = await this._getTimeZoneStages(tender, zone);
  374. await this._gatherStagesData(completeData, tender, stages);
  375. }
  376. async _gatherIndexZoneData(tender, completeData, stageZone) {
  377. const stages = await this._getOrderZoneStages(tender, stageZone);
  378. await this._gatherStagesData(completeData, tender, stages);
  379. }
  380. async _gatherCheckedZoneData(tender, completeData, zone) {
  381. const stages = await this._getCheckedZoneStages(tender, zone);
  382. await this._gatherStagesData(completeData, tender, stages);
  383. }
  384. async _gatherStageData(completeData, tender, stage, hasPre) {
  385. const helper = this.ctx.helper;
  386. const resultPos = this.resultPos;
  387. completeData.id = tender.id;
  388. completeData.name = tender.name;
  389. const billsTree = new Ledger.billsTree(this.ctx, {
  390. id: 'ledger_id',
  391. pid: 'ledger_pid',
  392. order: 'order',
  393. level: 'level',
  394. rootId: -1,
  395. keys: ['id', 'tender_id', 'ledger_id'],
  396. stageId: 'id',
  397. calcFields: ['deal_tp', 'total_price', 'contract_tp', 'qc_tp', 'contract_pc_tp', 'qc_pc_tp', 'pc_tp', 'gather_tp', 'pre_contract_tp', 'pre_qc_tp', 'pre_gather_tp'],
  398. calc: function (node) {
  399. if (node.children && node.children.length === 0) {
  400. node.pre_gather_qty = helper.add(node.pre_contract_qty, node.pre_qc_qty);
  401. node.gather_qty = helper.add(node.contract_qty, node.qc_qty);
  402. node.end_contract_qty = helper.add(node.pre_contract_qty, node.contract_qty);
  403. node.end_qc_qty = helper.add(node.pre_qc_qty, node.qc_qty);
  404. node.end_gather_qty = helper.add(node.pre_gather_qty, node.gather_qty);
  405. }
  406. node.pre_gather_tp = helper.add(node.pre_contract_tp, node.pre_qc_tp);
  407. node.gather_tp = helper.sum([node.contract_tp, node.qc_tp, node.pc_tp]);
  408. node.end_contract_tp = helper.sum([node.pre_contract_tp, node.contract_tp, node.contract_pc_tp]);
  409. node.end_qc_tp = helper.sum([node.pre_qc_tp, node.qc_tp, node.qc_pc_tp]);
  410. node.end_gather_tp = helper.add(node.pre_gather_tp, node.gather_tp);
  411. }
  412. });
  413. const billsData = await this.ctx.service.ledger.getData(tender.id);
  414. const dgnData = await this.ctx.service.stageBillsDgn.getDgnData(tender.id);
  415. for (const d of dgnData) {
  416. const l = this.ctx.helper._.find(billsData, {id: d.id});
  417. this.ctx.helper._.assignIn(l, d);
  418. }
  419. const pos = new Ledger.pos({
  420. id: 'id', ledgerId: 'lid',
  421. calc: function (node) {
  422. node.pre_gather_qty = helper.add(node.pre_contract_qty, node.pre_qc_qty);
  423. node.gather_qty = helper.add(node.contract_qty, node.qc_qty);
  424. node.end_contract_qty = helper.add(node.pre_contract_qty, node.contract_qty);
  425. node.end_qc_qty = helper.add(node.pre_qc_qty, node.qc_qty);
  426. node.end_gather_qty = helper.add(node.pre_gather_qty, node.gather_qty);
  427. },
  428. });
  429. const posData = await this.ctx.service.pos.getPosData({ tid: tender.id });
  430. if (stage) {
  431. await this.ctx.service.stage.doCheckStage(stage);
  432. const curStage = stage.readOnly
  433. ? await this.ctx.service.stageBills.getAuditorStageData2(tender.id, stage.id, stage.curTimes, stage.curOrder)
  434. : await this.ctx.service.stageBills.getLastestStageData2(tender.id, stage.id);
  435. const preStage = hasPre && stage.order > 1 ? await this.ctx.service.stageBillsFinal.getFinalData(tender, stage.order - 1) : [];
  436. const bpcStage = await this.ctx.service.stageBillsPc.getAllDataByCondition({ where: { sid: stage.id } });
  437. this.ctx.helper.assignRelaData(billsData, [
  438. { data: curStage, fields: ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp'], prefix: '', relaId: 'lid' },
  439. { data: preStage, fields: ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp'], prefix: 'pre_', relaId: 'lid' },
  440. { data: bpcStage, fields: ['contract_pc_tp', 'qc_pc_tp', 'pc_tp'], prefix: '', relaId: 'lid' },
  441. ]);
  442. const curStagePos = stage.readOnly
  443. ? await this.ctx.service.stagePos.getAuditorStageData2(tender.id, stage.id, stage.curTimes, stage.curOrder)
  444. : await this.ctx.service.stagePos.getLastestStageData2(tender.id, stage.id);
  445. const preStagePos = hasPre && stage.order > 1 ? await this.ctx.service.stagePosFinal.getFinalData(tender, stage.order - 1) : [];
  446. this.ctx.helper.assignRelaData(posData, [
  447. { data: curStagePos, fields: ['contract_qty', 'qc_qty'], prefix: '', relaId: 'pid' },
  448. { data: preStagePos, fields: ['contract_qty', 'qc_qty'], prefix: 'pre_', relaId: 'pid' },
  449. ]);
  450. }
  451. billsTree.loadDatas(billsData);
  452. billsTree.calculateAll();
  453. pos.loadDatas(posData);
  454. pos.calculateAll();
  455. this.resultTree.loadGatherTree(billsTree, function (gatherNode, sourceNode) {
  456. gatherUtils.gatherStage(tender, gatherNode, sourceNode, completeData.prefix, helper);
  457. }, function (gatherNode, sourceNode) {
  458. const posRange = pos.getLedgerPos(sourceNode.id);
  459. if (!posRange || posRange.length === 0) return;
  460. resultPos.loadGatherPos(gatherNode.id, posRange, (gatherPos, sourcePos) => {
  461. gatherUtils.gatherStagePos(tender, gatherPos, sourcePos, completeData.prefix, helper);
  462. });
  463. });
  464. }
  465. async _gatherMonthData(tender, completeData, month, hasPre) {
  466. const stages = await this._getValidStages(tender.id);
  467. const stage = this.ctx.helper._.find(stages, {s_time: month});
  468. await this._gatherStageData(completeData, tender, stage, hasPre);
  469. }
  470. async _gatherIndexData(tender, completeData, index, hasPre) {
  471. const stages = await this._getValidStages(tender.id);
  472. const stage = this.ctx.helper._.find(stages, {order: index});
  473. await this._gatherStageData(completeData, tender, stage, hasPre);
  474. }
  475. async _gatherFinalData(tender, completeData, hasPre) {
  476. const stages = await this._getValidStages(tender.id);
  477. await this._gatherStageData(completeData, tender, stages[0], hasPre);
  478. }
  479. async _gatherCheckedFinalData(tender, completeData, hasPre) {
  480. const stages = await this._getCheckedStages(tender.id);
  481. await this._gatherStageData(completeData, tender, stages[0], hasPre);
  482. }
  483. async _loadGatherLedger(tender) {
  484. const billsTree = new Ledger.billsTree(this.ctx, {
  485. id: 'ledger_id',
  486. pid: 'ledger_pid',
  487. order: 'order',
  488. level: 'level',
  489. rootId: -1,
  490. keys: ['id', 'tender_id', 'ledger_id'],
  491. stageId: 'id',
  492. calcFields: ['deal_tp', 'total_price'],
  493. });
  494. const billsData = await this.ctx.service.ledger.getData(tender.id);
  495. billsTree.loadDatas(billsData);
  496. billsTree.calculateAll();
  497. return billsTree;
  498. }
  499. async _loadGatherPos(tender) {
  500. const pos = new Ledger.pos({ id: 'id', ledgerId: 'lid' });
  501. const posData = await this.ctx.service.pos.getAllDataByCondition({ where: { tid: tender.id } });
  502. pos.loadDatas(posData);
  503. return pos;
  504. }
  505. async _gatherLedgerData(tender, completeData) {
  506. const resultPos = this.resultPos;
  507. const helper = this.ctx.helper;
  508. const billsTree = await this._loadGatherLedger(tender);
  509. const pos = await this._loadGatherPos(tender);
  510. this.resultTree.loadGatherTree(billsTree, function (gatherNode, sourceNode) {
  511. gatherUtils.gatherLedger(tender, gatherNode, sourceNode, completeData.prefix, helper);
  512. }, function (gatherNode, sourceNode) {
  513. const posRange = pos.getLedgerPos(sourceNode.id);
  514. if (!posRange || posRange.length === 0) return;
  515. resultPos.loadGatherPos(posRange, (gatherPos, sourcePos) => {
  516. gatherUtils.gatherPos(gatherPos, sourcePos, completeData.prefix, helper);
  517. });
  518. });
  519. }
  520. async _gatherSpecialData(tender, sKey) {
  521. const resultPos = this.resultPos;
  522. const helper = this.ctx.helper;
  523. const billsTree = await this._loadGatherLedger(tender);
  524. const pos = await this._loadGatherPos(tender);
  525. this.resultTree.loadGatherTree(billsTree, function (gatherNode, sourceNode) {
  526. gatherUtils.gatherSpecial(gatherNode, sourceNode, 'ts_' + sKey + '_', helper);
  527. }, function (gatherNode, sourceNode) {
  528. const posRange = pos.getLedgerPos(sourceNode.id);
  529. if (!posRange || posRange.length === 0) return;
  530. resultPos.loadGatherPos(gatherNode.id, posRange, (gatherPos, sourcePos) => {
  531. gatherUtils.gatherSpecialPos(gatherPos, sourcePos, 'ts_' + sKey + '_', helper);
  532. });
  533. });
  534. }
  535. async _doGatherStageData(memFieldKeys, gsDefine, gsCustom) {
  536. if (this.resultTree || this.resultPos) return;
  537. if (!gsDefine || !gsDefine.enable) return;
  538. if (!gsCustom || !gsCustom.tenders || gsCustom.tenders.length === 0) return;
  539. this.resultTree = new Ledger.gatherTree(this.ctx, {
  540. id: 'id',
  541. pid: 'pid',
  542. order: 'order',
  543. level: 'level',
  544. rootId: -1
  545. });
  546. this.resultPos = new Ledger.gatherPos({ id: 'id', ledgerId: 'lid' });
  547. const gsSetting = JSON.parse(gsDefine.setting);
  548. let commonIndex = 0;
  549. const completeDatas = [];
  550. for (const t of gsCustom.tenders) {
  551. const specialKey = this._checkSpecialTender(t, gsSetting.special);
  552. const tender = await this.ctx.service.tender.getCheckTender(t.tid);
  553. if (specialKey === '') {
  554. const completeData = {
  555. prefix: 't_' + commonIndex + '_',
  556. };
  557. completeDatas.push(completeData);
  558. switch (gsSetting.type) {
  559. case 'month':
  560. await this._gatherMonthData(tender, completeData, gsCustom.month, gsSetting.hasPre);
  561. break;
  562. case 'zone':
  563. await this._gatherZoneData(tender, completeData, gsCustom.zone);
  564. break;
  565. case 'final':
  566. await this._gatherFinalData(tender, completeData, gsSetting.hasPre);
  567. break;
  568. case 'checked-final':
  569. await this._gatherCheckedFinalData(tender, completeData, gsSetting.hasPre);
  570. break;
  571. case 'ledger':
  572. await this._gatherLedgerData(tender, completeData);
  573. break;
  574. case 'stage':
  575. await this._gatherIndexData(tender, completeData, gsCustom.stage, gsSetting.hasPre);
  576. break;
  577. case 'stage-zone':
  578. await this._gatherIndexZoneData(tender, completeData, gsCustom.stage_zone);
  579. break;
  580. case 'checked-zone':
  581. await this._gatherCheckedZoneData(tender, completeData, gsCustom.checked_zone);
  582. break;
  583. }
  584. commonIndex++;
  585. } else {
  586. await this._gatherSpecialData(tender, specialKey);
  587. }
  588. }
  589. this.resultTree.resortChildrenDefault();
  590. gatherUtils.completeGatherData(this.resultTree.nodes, completeDatas);
  591. gatherUtils.completeGatherData(this.resultPos.datas, completeDatas);
  592. }
  593. async getGatherStageBills(memFieldKeys, gsDefine, gsCustom) {
  594. await this._doGatherStageData(memFieldKeys, gsDefine, gsCustom);
  595. return this.resultTree ? this.resultTree.getDefaultDatas() : [];
  596. }
  597. async getGatherStagePos(memFieldKeys, gsDefine, gsCustom) {
  598. await this._doGatherStageData(memFieldKeys, gsDefine, gsCustom);
  599. return this.resultPos ? this.resultPos.getDatas() : [];
  600. }
  601. /**
  602. * 标段信息
  603. */
  604. async _getBaseTenderInfo(tender) {
  605. const info = {
  606. id: tender.id,
  607. name: tender.name,
  608. deal_tp: tender.deal_tp,
  609. tp: tender.total_price
  610. };
  611. const deal_bills_sum = await this.ctx.service.dealBills.getSum(tender.id);
  612. info.deal_bills_tp = deal_bills_sum ? deal_bills_sum.total_price : 0;
  613. if (tender.ledger_status === auditConst.ledger.status.uncheck || tender.ledger_status === auditConst.ledger.status.checkNo) {
  614. const sum = await this.ctx.service.ledger.addUp({tender_id: tender.id/*, is_leaf: true*/});
  615. info.tp = sum.total_price;
  616. info.deal_tp = sum.deal_tp;
  617. }
  618. info.deal_info = tender.info.deal_info;
  619. info.construction_unit = tender.info.construction_unit;
  620. info.tech_param = tender.info.tech_param;
  621. info.deal_param = tender.info.deal_param;
  622. info.pay_account = tender.info.pay_account;
  623. info.deal_param.contractPriceWithoutZL = this.ctx.helper.sub(info.deal_param.contractPrice,
  624. info.deal_param.zanLiePrice);
  625. info.bid_info = tender.info.bid_info;
  626. return info;
  627. }
  628. async _getStageTenderInfo(stage, info) {
  629. if (stage) {
  630. const helper = this.ctx.helper;
  631. await this.ctx.service.stage.doCheckStage(stage);
  632. await this.ctx.service.stage.checkStageGatherData(stage, this.ctx.session.sessionUser.is_admin);
  633. info.pre_contract_tp = stage.pre_contract_tp;
  634. info.pre_qc_tp = stage.pre_qc_tp;
  635. info.pre_gather_tp = helper.add(info.pre_contract_tp, info.pre_qc_tp);
  636. info.contract_tp = stage.contract_tp;
  637. info.qc_tp = stage.qc_tp;
  638. info.gather_tp = helper.add(info.contract_tp, info.qc_tp);
  639. info.end_contract_tp = helper.add(info.pre_contract_tp, info.contract_tp);
  640. info.end_qc_tp = helper.add(info.pre_qc_tp, info.qc_tp);
  641. info.end_gather_tp = helper.add(info.pre_gather_tp, info.gather_tp);
  642. info.yf_tp = stage.yf_tp;
  643. info.pre_yf_tp = stage.pre_yf_tp;
  644. info.end_yf_tp = helper.add(stage.yf_tp, stage.pre_yf_tp);
  645. info.sf_tp = stage.sf_tp;
  646. info.pre_sf_tp = stage.pre_sf_tp;
  647. info.end_sf_tp = helper.add(stage.sf_tp, stage.pre_sf_tp);
  648. }
  649. }
  650. async _getStagesTenderInfo(stages, info) {
  651. const helper = this.ctx.helper;
  652. for (const stage of stages) {
  653. await this.ctx.service.stage.doCheckStage(stage);
  654. await this.ctx.service.stage.checkStageGatherData(stage, this.ctx.session.sessionUser.is_admin);
  655. info.contract_tp = helper.add(info.contract_tp, stage.contract_tp);
  656. info.qc_tp = helper.add(info.qc_tp, stage.qc_tp);
  657. info.yf_tp = helper.add(info.yf_tp, stage.yf_tp);
  658. }
  659. info.gather_tp = helper.add(info.contract_tp, info.qc_tp);
  660. }
  661. async _gatherMonthTenderInfo(tender, index, month, hasPre) {
  662. const info = await this._getBaseTenderInfo(tender);
  663. const stages = await this._getValidStages(tender.id);
  664. const stage = this.ctx.helper._.find(stages, {s_time: month});
  665. await this._getStageTenderInfo(stage, info);
  666. this.resultTenderInfo.push(info);
  667. }
  668. async _gatherOrderTenderInfo(tender, index, order, hasPre) {
  669. const info = await this._getBaseTenderInfo(tender);
  670. const stages = await this._getValidStages(tender.id);
  671. const stage = this.ctx.helper._.find(stages, {order: order});
  672. await this._getStageTenderInfo(stage, info);
  673. this.resultTenderInfo.push(info);
  674. }
  675. async _gatherZoneTenderInfo(tender, index, zone) {
  676. const info = await this._getBaseTenderInfo(tender);
  677. const stages = await this._getTimeZoneStages(tender, zone);
  678. await this._getStagesTenderInfo(stages, info);
  679. this.resultTenderInfo.push(info);
  680. }
  681. async _gatherOrderZoneTenderInfo(tender, index, stageZone) {
  682. const info = await this._getBaseTenderInfo(tender);
  683. const stages = await this._getOrderZoneStages(tender, stageZone);
  684. await this._getStagesTenderInfo(stages, info);
  685. this.resultTenderInfo.push(info);
  686. }
  687. async _gatherFinalTenderInfo(tender, index, hasPre) {
  688. const info = await this._getBaseTenderInfo(tender);
  689. const stages = await this._getValidStages(tender.id);
  690. await this._getStageTenderInfo(stages[0], info);
  691. this.resultTenderInfo.push(info);
  692. }
  693. async _gatherCheckedFinalTenderInfo(tender, index, hasPre) {
  694. const info = await this._getBaseTenderInfo(tender);
  695. const stages = await this._getCheckedStages(tender.id);
  696. await this._getStageTenderInfo(stages[0], info);
  697. this.resultTenderInfo.push(info);
  698. }
  699. async _gatherLedgerTenderInfo(tender, index) {
  700. const info = await this._getBaseTenderInfo(tender);
  701. this.resultTenderInfo.push(info);
  702. }
  703. async _gatherSpecialTenderInfo(tender, sKey) {
  704. const info = await this._getBaseTenderInfo(tender);
  705. info.spec = sKey;
  706. this.resultTenderInfo.push(info);
  707. }
  708. async getGatherTenderInfo(memFieldKeys, gsDefine, gsCustom) {
  709. if (!gsDefine || !gsDefine.enable) return [];
  710. if (!gsCustom || !gsCustom.tenders || gsCustom.tenders.length === 0) return [];
  711. this.resultTenderInfo = [];
  712. const gsSetting = JSON.parse(gsDefine.setting);
  713. let commonIndex = 0;
  714. for (const t of gsCustom.tenders) {
  715. const specialKey = this._checkSpecialTender(t, gsSetting.special);
  716. const tender = await this.ctx.service.tender.getCheckTender(t.tid);
  717. if (specialKey === '') {
  718. switch (gsSetting.type) {
  719. case 'month':
  720. await this._gatherMonthTenderInfo(tender, commonIndex, gsCustom.month, gsSetting.hasPre);
  721. break;
  722. case 'zone':
  723. await this._gatherZoneTenderInfo(tender, commonIndex, gsCustom.zone);
  724. break;
  725. case 'final':
  726. await this._gatherFinalTenderInfo(tender, commonIndex, gsSetting.hasPre);
  727. break;
  728. case 'checked-final':
  729. await this._gatherCheckedFinalTenderInfo(tender, commonIndex, gsSetting.hasPre);
  730. break;
  731. case 'ledger':
  732. await this._gatherLedgerTenderInfo(tender, commonIndex);
  733. break;
  734. case 'stage':
  735. await this._gatherOrderTenderInfo(tender, commonIndex, gsCustom.stage, gsSetting.hasPre);
  736. break;
  737. case 'stage-zone':
  738. await this._gatherOrderZoneTenderInfo(tender, commonIndex, gsCustom.stage_zone);
  739. break;
  740. }
  741. commonIndex++;
  742. } else {
  743. await this._gatherSpecialTenderInfo(tender, specialKey);
  744. }
  745. }
  746. return this.resultTenderInfo;
  747. }
  748. /**
  749. * 合同支付
  750. */
  751. _gatherPayRecord(dealPay, fun) {
  752. let rdp;
  753. if (dealPay.ptype !== payConst.payType.normal) {
  754. rdp = this.ctx.helper._.find(this.resultDealPay, {ptype: dealPay.ptype});
  755. } else {
  756. rdp = this.ctx.helper._.find(this.resultDealPay, {
  757. name: dealPay.name,
  758. minus: dealPay.minus ? true : false,
  759. is_yf: dealPay.is_yf ? true : false,
  760. });
  761. }
  762. if (!rdp) {
  763. rdp = {
  764. ptype: dealPay.ptype,
  765. name: dealPay.name,
  766. minus: dealPay.minus ? true : false,
  767. is_yf: dealPay.is_yf ? true : false,
  768. };
  769. this.resultDealPay.push(rdp);
  770. }
  771. if (fun) fun(rdp, dealPay);
  772. }
  773. async _checkStagePayCalc(tender, stage, dealPay) {
  774. if (!stage.readOnly) {
  775. // 计算 本期金额
  776. const payCalculator = new PayCalculator(this.ctx, stage, tender.info);
  777. await payCalculator.calculateAll(dealPay);
  778. }
  779. }
  780. async _gatherStagePay(completeData, tender, stage, hasPre) {
  781. if (stage) {
  782. completeData.id = tender.id;
  783. completeData.name = tender.name;
  784. const helper = this.ctx.helper;
  785. await this.ctx.service.stage.doCheckStage(stage);
  786. const dealPay = await this.ctx.service.stagePay.getStagePays(stage);
  787. await this._checkStagePayCalc(tender, stage, dealPay);
  788. for (const dp of dealPay) {
  789. dp.end_tp = helper.add(dp.pre_tp, dp.tp);
  790. this._gatherPayRecord(dp, function (gatherData, sourceData) {
  791. gatherData[completeData.prefix + 'id'] = tender.id;
  792. gatherData[completeData.prefix + 'name'] = tender.name;
  793. gatherData[completeData.prefix + 'tp'] = helper.add(gatherData[completeData.prefix + 'tp'], sourceData.tp);
  794. gatherData[completeData.prefix + 'pre_tp'] = helper.add(gatherData[completeData.prefix + 'pre_tp'], sourceData.pre_tp);
  795. gatherData[completeData.prefix + 'end_tp'] = helper.add(gatherData[completeData.prefix + 'end_tp'], sourceData.end_tp);
  796. gatherData['s_' + 'tp'] = helper.add(gatherData['s_' + 'tp'], sourceData.tp);
  797. gatherData['s_' + 'pre_tp'] = helper.add(gatherData['s_' + 'pre_tp'], sourceData.pre_tp);
  798. gatherData['s_' + 'end_tp'] = helper.add(gatherData['s_' + 'end_tp'], sourceData.end_tp);
  799. });
  800. }
  801. }
  802. }
  803. async _gatherStagesPay(completeData, tender, stages) {
  804. const helper = this.ctx.helper;
  805. completeData.id = tender.id;
  806. completeData.name = tender.name;
  807. for (const stage of stages) {
  808. await this.ctx.service.stage.doCheckStage(stage);
  809. const dealPay = await this.ctx.service.stagePay.getStagePays(stage);
  810. await this._checkStagePayCalc(tender, stage, dealPay);
  811. for (const dp of dealPay) {
  812. dp.end_tp = helper.add(dp.pre_tp, dp.tp);
  813. this._gatherPayRecord(dp, function (gatherData, sourceData) {
  814. gatherData[completeData.prefix + 'id'] = tender.id;
  815. gatherData[completeData.prefix + 'name'] = tender.name;
  816. gatherData[completeData.prefix + 'tp'] = helper.add(gatherData[completeData.prefix + 'tp'], sourceData.tp);
  817. gatherData['s_' + 'tp'] = helper.add(gatherData['s_' + 'tp'], sourceData.tp);
  818. });
  819. }
  820. }
  821. }
  822. async _gatherMonthStagePay(sTender, completeData, month, hasPre) {
  823. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  824. const stages = await this._getValidStages(tender.id);
  825. const stage = this.ctx.helper._.find(stages, {s_time: month});
  826. await this._gatherStagePay(completeData, tender, stage, hasPre);
  827. }
  828. async _gatherOrderStagePay(sTender, completeData, order, hasPre) {
  829. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  830. const stages = await this._getValidStages(tender.id);
  831. const stage = this.ctx.helper._.find(stages, {order: order});
  832. await this._gatherStagePay(completeData, tender, stage, hasPre);
  833. }
  834. async _gatherZoneStagePay(sTender, completeData, zone) {
  835. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  836. const stages = await this._getTimeZoneStages(tender, zone);
  837. await this._gatherStagesPay(completeData, tender, stages);
  838. }
  839. async _gatherOrderZoneStagePay(sTender, completeData, stageZone) {
  840. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  841. const stages = await this._getOrderZoneStages(tender, stageZone)
  842. await this._gatherStagesPay(completeData, tender, stages);
  843. }
  844. async _gatherFinalStagePay(sTender, completeData, hasPre) {
  845. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  846. const stages = await this._getValidStages(tender.id);
  847. await this._gatherStagePay(completeData, tender, stages[0], hasPre);
  848. }
  849. async _gatherCheckedFinalStagePay(sTender, completeData, hasPre) {
  850. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  851. const stages = await this._getCheckedStages(tender.id);
  852. await this._gatherStagePay(completeData, tender, stages[0], hasPre);
  853. }
  854. async getGatherStagePay(memFieldKeys, gsDefine, gsCustom) {
  855. if (!gsDefine || !gsDefine.enable) return [];
  856. if (!gsCustom || !gsCustom.tenders || gsCustom.tenders.length === 0) return [];
  857. this.resultTenderInfo = [];
  858. const gsSetting = JSON.parse(gsDefine.setting);
  859. let commonIndex = 0;
  860. const completeDatas = [];
  861. for (const tender of gsCustom.tenders) {
  862. const specialKey = this._checkSpecialTender(tender, gsSetting.special);
  863. if (specialKey === '') {
  864. const completeData = {
  865. prefix: 't_' + commonIndex + '_',
  866. };
  867. completeDatas.push(completeData);
  868. switch (gsSetting.type) {
  869. case 'month':
  870. await this._gatherMonthStagePay(tender, completeData, gsCustom.month, gsSetting.hasPre);
  871. break;
  872. case 'zone':
  873. await this._gatherZoneStagePay(tender, completeData, gsCustom.zone);
  874. break;
  875. case 'final':
  876. await this._gatherFinalStagePay(tender, completeData, gsSetting.hasPre);
  877. break;
  878. case 'checked-final':
  879. await this._gatherCheckedFinalStagePay(tender, completeData, gsSetting.hasPre);
  880. break;
  881. case 'stage':
  882. await this._gatherOrderStagePay(tender, completeData, gsCustom.stage, gsSetting.hasPre);
  883. break;
  884. case 'stage-zone':
  885. await this._gatherOrderZoneStagePay(tender, completeData, gsCustom.stage_zone);
  886. break;
  887. }
  888. commonIndex++;
  889. }
  890. // 合同支付,只有在每一期中有数据,故特殊标段直接不汇总合同支付
  891. }
  892. gatherUtils.completeGatherData(this.resultDealPay, completeDatas);
  893. return this.resultDealPay;
  894. }
  895. /**
  896. * 签约清单
  897. */
  898. async _gatherDealBills(tender, fun) {
  899. const dealBills = await this.ctx.service.dealBills.getAllDataByCondition({
  900. where: { tender_id: tender.id }
  901. });
  902. for (const db of dealBills) {
  903. let rdb = this.ctx.helper._.find(this.resultDealBills, {
  904. code: db.code,
  905. name: db.name,
  906. unit: db.unit,
  907. unit_price: db.unit_price ? db.unit_price: 0,
  908. });
  909. if (!rdb) {
  910. rdb = {
  911. code: db.code,
  912. name: db.name,
  913. unit: db.unit,
  914. unit_price: db.unit_price ? db.unit_price: 0,
  915. };
  916. this.resultDealBills.push(rdb);
  917. }
  918. if (fun) fun(rdb, db);
  919. }
  920. }
  921. async _gatherCommonDealBills(sTender, completeData) {
  922. const self = this;
  923. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  924. completeData.id = tender.id;
  925. completeData.name = tender.name;
  926. await this._gatherDealBills(tender, function (gatherData, sourceData) {
  927. gatherData[completeData.prefix + 'id'] = tender.id;
  928. gatherData[completeData.prefix + 'name'] = tender.name;
  929. gatherData[completeData.prefix + 'qty'] = sourceData.quantity;
  930. gatherData[completeData.prefix + 'tp'] = sourceData.total_price;
  931. gatherData['s_' + 'qty'] = self.ctx.helper.add(gatherData['s_' + 'qty'], sourceData.quantity);
  932. gatherData['s_' + 'tp'] = self.ctx.helper.add(gatherData['s_' + 'tp'], sourceData.total_price);
  933. });
  934. }
  935. async _gatherSpecialDealBills(sTender, sKey) {
  936. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  937. await this._gatherDealBills(tender, function (gatherData, sourceData) {
  938. const prefix = 'ts_' + sKey + '_';
  939. gatherData[prefix + 'qty'] = sourceData.quantity;
  940. gatherData[prefix + 'tp'] = sourceData.total_price;
  941. });
  942. }
  943. async getGatherDealBills(memFieldKeys, gsDefine, gsCustom) {
  944. if (!gsDefine || !gsDefine.enable) return [];
  945. if (!gsCustom || !gsCustom.tenders || gsCustom.tenders.length === 0) return [];
  946. this.resultTenderInfo = [];
  947. const gsSetting = JSON.parse(gsDefine.setting);
  948. let commonIndex = 0;
  949. const completeDatas = [];
  950. for (const tender of gsCustom.tenders) {
  951. const specialKey = this._checkSpecialTender(tender, gsSetting.special);
  952. if (specialKey === '') {
  953. const completeData = {
  954. prefix: 't_' + commonIndex + '_',
  955. };
  956. completeDatas.push(completeData);
  957. await this._gatherCommonDealBills(tender, completeData);
  958. commonIndex++;
  959. } else {
  960. await this._gatherSpecialDealBills(tender, specialKey);
  961. }
  962. }
  963. gatherUtils.completeGatherData(this.resultDealBills, completeDatas);
  964. return this.resultDealBills;
  965. }
  966. }
  967. return RptGatherMemory;
  968. };