rpt_gather_memory.js 55 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080
  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. const times = zone.split(' - ');
  257. if (times.length !== 2) throw '选择的汇总周期无效';
  258. const beginTime = moment(times[0], 'YYYY-MM-DD');
  259. const endTime = moment(times[1], 'YYYY-MM-DD');
  260. const stages = await this._getValidStages(tender.id), validStages = [];
  261. for (const stage of stages) {
  262. if (stage.status !== auditConst.stage.status.checked) continue;
  263. const finalAudit = this.ctx.service.stageAudit.getLastestAuditor(stage.id, stage.times, stage.status);
  264. if (!finalAudit) continue;
  265. const sTime = moment(finalAudit.end_time);
  266. if (sTime.isBetween(beginTime, endTime, null, '[]')) {
  267. validStages.push(stage);
  268. }
  269. }
  270. return validStages;
  271. }
  272. /**
  273. * 台账数据
  274. */
  275. async _gatherStagesData(completeData, tender, stages) {
  276. const resultPos = this.resultPos;
  277. const helper = this.ctx.helper;
  278. completeData.id = tender.id;
  279. completeData.name = tender.name;
  280. /**
  281. * 汇总并合并 相关数据
  282. * @param {Array} index - 主数据
  283. * @param {Array[]}rela - 相关数据 {data, fields, prefix, relaId}
  284. */
  285. const sumAssignRelaData = function (index, rela) {
  286. const loadFields = function (datas, fields, prefix, relaId) {
  287. for (const d of datas) {
  288. const key = indexPre + d[relaId];
  289. const m = index[key];
  290. if (m) {
  291. for (const f of fields) {
  292. if (d[f] !== undefined) {
  293. m[prefix + f] = helper.add(m[prefix + f], d[f]);
  294. }
  295. }
  296. }
  297. }
  298. };
  299. for (const r of rela) {
  300. loadFields(r.data, r.fields, r.prefix, r.relaId);
  301. }
  302. };
  303. const billsTree = new Ledger.billsTree(this.ctx, {
  304. id: 'ledger_id',
  305. pid: 'ledger_pid',
  306. order: 'order',
  307. level: 'level',
  308. rootId: -1,
  309. keys: ['id', 'tender_id', 'ledger_id'],
  310. stageId: 'id',
  311. calcFields: ['deal_tp', 'total_price', 'contract_tp', 'qc_tp', 'gather_tp'],
  312. calc: function (node) {
  313. if (node.children && node.children.length === 0) {
  314. node.gather_qty = helper.add(node.contract_qty, node.qc_qty);
  315. }
  316. node.gather_tp = helper.add(node.contract_tp, node.qc_tp);
  317. }
  318. });
  319. const billsData = await this.ctx.service.ledger.getData(tender.id);
  320. const dgnData = await this.ctx.service.stageBillsDgn.getDgnData(tender.id);
  321. for (const d of dgnData) {
  322. const l = this.ctx.helper._.find(billsData, {id: d.id});
  323. this.ctx.helper._.assignIn(l, d);
  324. }
  325. const pos = new Ledger.pos({
  326. id: 'id', ledgerId: 'lid',
  327. calc: function (node) {
  328. node.gather_qty = helper.add(node.contract_qty, node.qc_qty);
  329. },
  330. });
  331. const posData = await this.ctx.service.pos.getAllDataByCondition({ where: { tid: tender.id} });
  332. let billsIndexData = {};
  333. for (const bd of billsData) {
  334. billsIndexData[indexPre + bd.id] = bd;
  335. }
  336. let posIndexData = {};
  337. for (const p of posData) {
  338. posIndexData[indexPre + p.id] = p;
  339. }
  340. for (const stage of stages) {
  341. await this.ctx.service.stage.doCheckStage(stage);
  342. const curStage = stage.readOnly
  343. ? await this.ctx.service.stageBills.getAuditorStageData2(tender.id, stage.id, stage.curTimes, stage.curOrder)
  344. : await this.ctx.service.stageBills.getLastestStageData2(tender.id, stage.id);
  345. const bpcStage = await this.ctx.service.stageBillsPc.getAllDataByCondition({ where: { sid: stage.id } });
  346. sumAssignRelaData(billsIndexData, [
  347. {data: curStage, fields: ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp'], prefix: '', relaId: 'lid'},
  348. { data: bpcStage, fields: ['contract_pc_tp', 'qc_pc_tp', 'pc_tp'], prefix: '', relaId: 'lid' },
  349. ]);
  350. const curStagePos = stage.readOnly
  351. ? await this.ctx.service.stagePos.getAuditorStageData2(tender.id, stage.id, stage.curTimes, stage.curOrder)
  352. : await this.ctx.service.stagePos.getLastestStageData2(tender.id, stage.id);
  353. sumAssignRelaData(posIndexData, [
  354. {data: curStagePos, fields: ['contract_qty', 'qc_qty'], prefix: '', relaId: 'pid'},
  355. ]);
  356. }
  357. billsTree.loadDatas(billsData);
  358. billsTree.calculateAll();
  359. pos.loadDatas(posData);
  360. pos.calculateAll();
  361. this.resultTree.loadGatherTree(billsTree, function (gatherNode, sourceNode) {
  362. gatherUtils.gatherZone(tender, gatherNode, sourceNode, completeData.prefix, helper);
  363. }, function (gatherNode, sourceNode) {
  364. const posRange = pos.getLedgerPos(sourceNode.id);
  365. if (!posRange || posRange.length === 0) return;
  366. resultPos.loadGatherPos(gatherNode.id, posRange, (gatherPos, sourcePos) => {
  367. gatherUtils.gatherZonePos(tender, gatherPos, sourcePos, completeData.prefix, helper);
  368. });
  369. });
  370. }
  371. async _gatherZoneData(tender, completeData, zone) {
  372. const stages = await this._getTimeZoneStages(tender, zone);
  373. await this._gatherStagesData(completeData, tender, stages);
  374. }
  375. async _gatherIndexZoneData(tender, completeData, stageZone) {
  376. const stages = await this._getOrderZoneStages(tender, stageZone);
  377. await this._gatherStagesData(completeData, tender, stages);
  378. }
  379. async _gatherCheckedZoneData(tender, completeData, zone) {
  380. const stages = await this._getCheckedZoneStages(tender, zone);
  381. await this._gatherStagesData(completeData, tender, stages);
  382. }
  383. async _gatherStageData(completeData, tender, stage, hasPre) {
  384. const helper = this.ctx.helper;
  385. const resultPos = this.resultPos;
  386. completeData.id = tender.id;
  387. completeData.name = tender.name;
  388. const billsTree = new Ledger.billsTree(this.ctx, {
  389. id: 'ledger_id',
  390. pid: 'ledger_pid',
  391. order: 'order',
  392. level: 'level',
  393. rootId: -1,
  394. keys: ['id', 'tender_id', 'ledger_id'],
  395. stageId: 'id',
  396. 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'],
  397. calc: function (node) {
  398. if (node.children && node.children.length === 0) {
  399. node.pre_gather_qty = helper.add(node.pre_contract_qty, node.pre_qc_qty);
  400. node.gather_qty = helper.add(node.contract_qty, node.qc_qty);
  401. node.end_contract_qty = helper.add(node.pre_contract_qty, node.contract_qty);
  402. node.end_qc_qty = helper.add(node.pre_qc_qty, node.qc_qty);
  403. node.end_gather_qty = helper.add(node.pre_gather_qty, node.gather_qty);
  404. }
  405. node.pre_gather_tp = helper.add(node.pre_contract_tp, node.pre_qc_tp);
  406. node.gather_tp = helper.sum([node.contract_tp, node.qc_tp, node.pc_tp]);
  407. node.end_contract_tp = helper.sum([node.pre_contract_tp, node.contract_tp, node.contract_pc_tp]);
  408. node.end_qc_tp = helper.sum([node.pre_qc_tp, node.qc_tp, node.qc_pc_tp]);
  409. node.end_gather_tp = helper.add(node.pre_gather_tp, node.gather_tp);
  410. }
  411. });
  412. const billsData = await this.ctx.service.ledger.getData(tender.id);
  413. const dgnData = await this.ctx.service.stageBillsDgn.getDgnData(tender.id);
  414. for (const d of dgnData) {
  415. const l = this.ctx.helper._.find(billsData, {id: d.id});
  416. this.ctx.helper._.assignIn(l, d);
  417. }
  418. const pos = new Ledger.pos({
  419. id: 'id', ledgerId: 'lid',
  420. calc: function (node) {
  421. node.pre_gather_qty = helper.add(node.pre_contract_qty, node.pre_qc_qty);
  422. node.gather_qty = helper.add(node.contract_qty, node.qc_qty);
  423. node.end_contract_qty = helper.add(node.pre_contract_qty, node.contract_qty);
  424. node.end_qc_qty = helper.add(node.pre_qc_qty, node.qc_qty);
  425. node.end_gather_qty = helper.add(node.pre_gather_qty, node.gather_qty);
  426. },
  427. });
  428. const posData = await this.ctx.service.pos.getPosData({ tid: tender.id });
  429. if (stage) {
  430. await this.ctx.service.stage.doCheckStage(stage);
  431. const curStage = stage.readOnly
  432. ? await this.ctx.service.stageBills.getAuditorStageData2(tender.id, stage.id, stage.curTimes, stage.curOrder)
  433. : await this.ctx.service.stageBills.getLastestStageData2(tender.id, stage.id);
  434. const preStage = hasPre && stage.order > 1 ? await this.ctx.service.stageBillsFinal.getFinalData(tender, stage.order - 1) : [];
  435. const bpcStage = await this.ctx.service.stageBillsPc.getAllDataByCondition({ where: { sid: stage.id } });
  436. this.ctx.helper.assignRelaData(billsData, [
  437. { data: curStage, fields: ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp'], prefix: '', relaId: 'lid' },
  438. { data: preStage, fields: ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp'], prefix: 'pre_', relaId: 'lid' },
  439. { data: bpcStage, fields: ['contract_pc_tp', 'qc_pc_tp', 'pc_tp'], prefix: '', relaId: 'lid' },
  440. ]);
  441. const curStagePos = stage.readOnly
  442. ? await this.ctx.service.stagePos.getAuditorStageData2(tender.id, stage.id, stage.curTimes, stage.curOrder)
  443. : await this.ctx.service.stagePos.getLastestStageData2(tender.id, stage.id);
  444. const preStagePos = hasPre && stage.order > 1 ? await this.ctx.service.stagePosFinal.getFinalData(tender, stage.order - 1) : [];
  445. this.ctx.helper.assignRelaData(posData, [
  446. { data: curStagePos, fields: ['contract_qty', 'qc_qty'], prefix: '', relaId: 'pid' },
  447. { data: preStagePos, fields: ['contract_qty', 'qc_qty'], prefix: 'pre_', relaId: 'pid' },
  448. ]);
  449. }
  450. billsTree.loadDatas(billsData);
  451. billsTree.calculateAll();
  452. pos.loadDatas(posData);
  453. pos.calculateAll();
  454. this.resultTree.loadGatherTree(billsTree, function (gatherNode, sourceNode) {
  455. gatherUtils.gatherStage(tender, gatherNode, sourceNode, completeData.prefix, helper);
  456. }, function (gatherNode, sourceNode) {
  457. const posRange = pos.getLedgerPos(sourceNode.id);
  458. if (!posRange || posRange.length === 0) return;
  459. resultPos.loadGatherPos(gatherNode.id, posRange, (gatherPos, sourcePos) => {
  460. gatherUtils.gatherStagePos(tender, gatherPos, sourcePos, completeData.prefix, helper);
  461. });
  462. });
  463. }
  464. async _gatherMonthData(tender, completeData, month, hasPre) {
  465. const stages = await this._getValidStages(tender.id);
  466. const stage = this.ctx.helper._.find(stages, {s_time: month});
  467. await this._gatherStageData(completeData, tender, stage, hasPre);
  468. }
  469. async _gatherIndexData(tender, completeData, index, hasPre) {
  470. const stages = await this._getValidStages(tender.id);
  471. const stage = this.ctx.helper._.find(stages, {order: index});
  472. await this._gatherStageData(completeData, tender, stage, hasPre);
  473. }
  474. async _gatherFinalData(tender, completeData, hasPre) {
  475. const stages = await this._getValidStages(tender.id);
  476. await this._gatherStageData(completeData, tender, stages[0], hasPre);
  477. }
  478. async _gatherCheckedFinalData(tender, completeData, hasPre) {
  479. const stages = await this._getCheckedStages(tender.id);
  480. await this._gatherStageData(completeData, tender, stages[0], hasPre);
  481. }
  482. async _loadGatherLedger(tender) {
  483. const billsTree = new Ledger.billsTree(this.ctx, {
  484. id: 'ledger_id',
  485. pid: 'ledger_pid',
  486. order: 'order',
  487. level: 'level',
  488. rootId: -1,
  489. keys: ['id', 'tender_id', 'ledger_id'],
  490. stageId: 'id',
  491. calcFields: ['deal_tp', 'total_price'],
  492. });
  493. const billsData = await this.ctx.service.ledger.getData(tender.id);
  494. billsTree.loadDatas(billsData);
  495. billsTree.calculateAll();
  496. return billsTree;
  497. }
  498. async _loadGatherPos(tender) {
  499. const pos = new Ledger.pos({ id: 'id', ledgerId: 'lid' });
  500. const posData = await this.ctx.service.pos.getAllDataByCondition({ where: { tid: tender.id } });
  501. pos.loadDatas(posData);
  502. return pos;
  503. }
  504. async _gatherLedgerData(tender, completeData) {
  505. const resultPos = this.resultPos;
  506. const helper = this.ctx.helper;
  507. const billsTree = await this._loadGatherLedger(tender);
  508. const pos = await this._loadGatherPos(tender);
  509. this.resultTree.loadGatherTree(billsTree, function (gatherNode, sourceNode) {
  510. gatherUtils.gatherLedger(tender, gatherNode, sourceNode, completeData.prefix, helper);
  511. }, function (gatherNode, sourceNode) {
  512. const posRange = pos.getLedgerPos(sourceNode.id);
  513. if (!posRange || posRange.length === 0) return;
  514. resultPos.loadGatherPos(posRange, (gatherPos, sourcePos) => {
  515. gatherUtils.gatherPos(gatherPos, sourcePos, completeData.prefix, helper);
  516. });
  517. });
  518. }
  519. async _gatherSpecialData(tender, sKey) {
  520. const resultPos = this.resultPos;
  521. const helper = this.ctx.helper;
  522. const billsTree = await this._loadGatherLedger(tender);
  523. const pos = await this._loadGatherPos(tender);
  524. this.resultTree.loadGatherTree(billsTree, function (gatherNode, sourceNode) {
  525. gatherUtils.gatherSpecial(gatherNode, sourceNode, 'ts_' + sKey + '_', helper);
  526. }, function (gatherNode, sourceNode) {
  527. const posRange = pos.getLedgerPos(sourceNode.id);
  528. if (!posRange || posRange.length === 0) return;
  529. resultPos.loadGatherPos(gatherNode.id, posRange, (gatherPos, sourcePos) => {
  530. gatherUtils.gatherSpecialPos(gatherPos, sourcePos, 'ts_' + sKey + '_', helper);
  531. });
  532. });
  533. }
  534. async _doGatherStageData(memFieldKeys, gsDefine, gsCustom) {
  535. if (this.resultTree || this.resultPos) return;
  536. if (!gsDefine || !gsDefine.enable) return;
  537. if (!gsCustom || !gsCustom.tenders || gsCustom.tenders.length === 0) return;
  538. this.resultTree = new Ledger.gatherTree(this.ctx, {
  539. id: 'id',
  540. pid: 'pid',
  541. order: 'order',
  542. level: 'level',
  543. rootId: -1
  544. });
  545. this.resultPos = new Ledger.gatherPos({ id: 'id', ledgerId: 'lid' });
  546. const gsSetting = JSON.parse(gsDefine.setting);
  547. let commonIndex = 0;
  548. const completeDatas = [];
  549. for (const t of gsCustom.tenders) {
  550. const specialKey = this._checkSpecialTender(t, gsSetting.special);
  551. const tender = await this.ctx.service.tender.getCheckTender(t.tid);
  552. if (specialKey === '') {
  553. const completeData = {
  554. prefix: 't_' + commonIndex + '_',
  555. };
  556. completeDatas.push(completeData);
  557. switch (gsSetting.type) {
  558. case 'month':
  559. await this._gatherMonthData(tender, completeData, gsCustom.month, gsSetting.hasPre);
  560. break;
  561. case 'zone':
  562. await this._gatherZoneData(tender, completeData, gsCustom.zone);
  563. break;
  564. case 'final':
  565. await this._gatherFinalData(tender, completeData, gsSetting.hasPre);
  566. break;
  567. case 'checked-final':
  568. await this._gatherCheckedFinalData(tender, completeData, gsSetting.hasPre);
  569. break;
  570. case 'ledger':
  571. await this._gatherLedgerData(tender, completeData);
  572. break;
  573. case 'stage':
  574. await this._gatherIndexData(tender, completeData, gsCustom.stage, gsSetting.hasPre);
  575. break;
  576. case 'stage-zone':
  577. await this._gatherIndexZoneData(tender, completeData, gsCustom.stage_zone);
  578. break;
  579. case 'checked-zone':
  580. await this._gatherCheckedZoneData(tender, completeData, gsCustom.check_zone);
  581. break;
  582. }
  583. commonIndex++;
  584. } else {
  585. await this._gatherSpecialData(tender, specialKey);
  586. }
  587. }
  588. this.resultTree.resortChildrenDefault();
  589. gatherUtils.completeGatherData(this.resultTree.nodes, completeDatas);
  590. gatherUtils.completeGatherData(this.resultPos.datas, completeDatas);
  591. }
  592. async getGatherStageBills(memFieldKeys, gsDefine, gsCustom) {
  593. await this._doGatherStageData(memFieldKeys, gsDefine, gsCustom);
  594. return this.resultTree ? this.resultTree.getDefaultDatas() : [];
  595. }
  596. async getGatherStagePos(memFieldKeys, gsDefine, gsCustom) {
  597. await this._doGatherStageData(memFieldKeys, gsDefine, gsCustom);
  598. return this.resultPos ? this.resultPos.getDatas() : [];
  599. }
  600. /**
  601. * 标段信息
  602. */
  603. async _getBaseTenderInfo(tender) {
  604. const info = {
  605. id: tender.id,
  606. name: tender.name,
  607. deal_tp: tender.deal_tp,
  608. tp: tender.total_price
  609. };
  610. const deal_bills_sum = await this.ctx.service.dealBills.getSum(tender.id);
  611. info.deal_bills_tp = deal_bills_sum ? deal_bills_sum.total_price : 0;
  612. if (tender.ledger_status === auditConst.ledger.status.uncheck || tender.ledger_status === auditConst.ledger.status.checkNo) {
  613. const sum = await this.ctx.service.ledger.addUp({tender_id: tender.id/*, is_leaf: true*/});
  614. info.tp = sum.total_price;
  615. info.deal_tp = sum.deal_tp;
  616. }
  617. info.deal_info = tender.info.deal_info;
  618. info.construction_unit = tender.info.construction_unit;
  619. info.tech_param = tender.info.tech_param;
  620. info.deal_param = tender.info.deal_param;
  621. info.pay_account = tender.info.pay_account;
  622. info.deal_param.contractPriceWithoutZL = this.ctx.helper.sub(info.deal_param.contractPrice,
  623. info.deal_param.zanLiePrice);
  624. info.bid_info = tender.info.bid_info;
  625. return info;
  626. }
  627. async _getStageTenderInfo(stage, info) {
  628. if (stage) {
  629. const helper = this.ctx.helper;
  630. await this.ctx.service.stage.doCheckStage(stage);
  631. await this.ctx.service.stage.checkStageGatherData(stage, this.ctx.session.sessionUser.is_admin);
  632. info.pre_contract_tp = stage.pre_contract_tp;
  633. info.pre_qc_tp = stage.pre_qc_tp;
  634. info.pre_gather_tp = helper.add(info.pre_contract_tp, info.pre_qc_tp);
  635. info.contract_tp = stage.contract_tp;
  636. info.qc_tp = stage.qc_tp;
  637. info.gather_tp = helper.add(info.contract_tp, info.qc_tp);
  638. info.end_contract_tp = helper.add(info.pre_contract_tp, info.contract_tp);
  639. info.end_qc_tp = helper.add(info.pre_qc_tp, info.qc_tp);
  640. info.end_gather_tp = helper.add(info.pre_gather_tp, info.gather_tp);
  641. info.yf_tp = stage.yf_tp;
  642. info.pre_yf_tp = stage.pre_yf_tp;
  643. info.end_yf_tp = helper.add(stage.yf_tp, stage.pre_yf_tp);
  644. info.sf_tp = stage.sf_tp;
  645. info.pre_sf_tp = stage.pre_sf_tp;
  646. info.end_sf_tp = helper.add(stage.sf_tp, stage.pre_sf_tp);
  647. }
  648. }
  649. async _getStagesTenderInfo(stages, info) {
  650. const helper = this.ctx.helper;
  651. for (const stage of stages) {
  652. await this.ctx.service.stage.doCheckStage(stage);
  653. await this.ctx.service.stage.checkStageGatherData(stage, this.ctx.session.sessionUser.is_admin);
  654. info.contract_tp = helper.add(info.contract_tp, stage.contract_tp);
  655. info.qc_tp = helper.add(info.qc_tp, stage.qc_tp);
  656. info.yf_tp = helper.add(info.yf_tp, stage.yf_tp);
  657. }
  658. info.gather_tp = helper.add(info.contract_tp, info.qc_tp);
  659. }
  660. async _gatherMonthTenderInfo(tender, index, month, hasPre) {
  661. const info = await this._getBaseTenderInfo(tender);
  662. const stages = await this._getValidStages(tender.id);
  663. const stage = this.ctx.helper._.find(stages, {s_time: month});
  664. await this._getStageTenderInfo(stage, info);
  665. this.resultTenderInfo.push(info);
  666. }
  667. async _gatherOrderTenderInfo(tender, index, order, hasPre) {
  668. const info = await this._getBaseTenderInfo(tender);
  669. const stages = await this._getValidStages(tender.id);
  670. const stage = this.ctx.helper._.find(stages, {order: order});
  671. await this._getStageTenderInfo(stage, info);
  672. this.resultTenderInfo.push(info);
  673. }
  674. async _gatherZoneTenderInfo(tender, index, zone) {
  675. const info = await this._getBaseTenderInfo(tender);
  676. const stages = await this._getTimeZoneStages(tender, zone);
  677. await this._getStagesTenderInfo(stages, info);
  678. this.resultTenderInfo.push(info);
  679. }
  680. async _gatherOrderZoneTenderInfo(tender, index, stageZone) {
  681. const info = await this._getBaseTenderInfo(tender);
  682. const stages = await this._getOrderZoneStages(tender, stageZone);
  683. await this._getStagesTenderInfo(stages, info);
  684. this.resultTenderInfo.push(info);
  685. }
  686. async _gatherFinalTenderInfo(tender, index, hasPre) {
  687. const info = await this._getBaseTenderInfo(tender);
  688. const stages = await this._getValidStages(tender.id);
  689. await this._getStageTenderInfo(stages[0], info);
  690. this.resultTenderInfo.push(info);
  691. }
  692. async _gatherCheckedFinalTenderInfo(tender, index, hasPre) {
  693. const info = await this._getBaseTenderInfo(tender);
  694. const stages = await this._getCheckedStages(tender.id);
  695. await this._getStageTenderInfo(stages[0], info);
  696. this.resultTenderInfo.push(info);
  697. }
  698. async _gatherLedgerTenderInfo(tender, index) {
  699. const info = await this._getBaseTenderInfo(tender);
  700. this.resultTenderInfo.push(info);
  701. }
  702. async _gatherSpecialTenderInfo(tender, sKey) {
  703. const info = await this._getBaseTenderInfo(tender);
  704. info.spec = sKey;
  705. this.resultTenderInfo.push(info);
  706. }
  707. async getGatherTenderInfo(memFieldKeys, gsDefine, gsCustom) {
  708. if (!gsDefine || !gsDefine.enable) return [];
  709. if (!gsCustom || !gsCustom.tenders || gsCustom.tenders.length === 0) return [];
  710. this.resultTenderInfo = [];
  711. const gsSetting = JSON.parse(gsDefine.setting);
  712. let commonIndex = 0;
  713. for (const t of gsCustom.tenders) {
  714. const specialKey = this._checkSpecialTender(t, gsSetting.special);
  715. const tender = await this.ctx.service.tender.getCheckTender(t.tid);
  716. if (specialKey === '') {
  717. switch (gsSetting.type) {
  718. case 'month':
  719. await this._gatherMonthTenderInfo(tender, commonIndex, gsCustom.month, gsSetting.hasPre);
  720. break;
  721. case 'zone':
  722. await this._gatherZoneTenderInfo(tender, commonIndex, gsCustom.zone);
  723. break;
  724. case 'final':
  725. await this._gatherFinalTenderInfo(tender, commonIndex, gsSetting.hasPre);
  726. break;
  727. case 'checked-final':
  728. await this._gatherCheckedFinalTenderInfo(tender, commonIndex, gsSetting.hasPre);
  729. break;
  730. case 'ledger':
  731. await this._gatherLedgerTenderInfo(tender, commonIndex);
  732. break;
  733. case 'stage':
  734. await this._gatherOrderTenderInfo(tender, commonIndex, gsCustom.stage, gsSetting.hasPre);
  735. break;
  736. case 'stage-zone':
  737. await this._gatherOrderZoneTenderInfo(tender, commonIndex, gsCustom.stage_zone);
  738. break;
  739. }
  740. commonIndex++;
  741. } else {
  742. await this._gatherSpecialTenderInfo(tender, specialKey);
  743. }
  744. }
  745. return this.resultTenderInfo;
  746. }
  747. /**
  748. * 合同支付
  749. */
  750. _gatherPayRecord(dealPay, fun) {
  751. let rdp;
  752. if (dealPay.ptype !== payConst.payType.normal) {
  753. rdp = this.ctx.helper._.find(this.resultDealPay, {ptype: dealPay.ptype});
  754. } else {
  755. rdp = this.ctx.helper._.find(this.resultDealPay, {
  756. name: dealPay.name,
  757. minus: dealPay.minus ? true : false,
  758. is_yf: dealPay.is_yf ? true : false,
  759. });
  760. }
  761. if (!rdp) {
  762. rdp = {
  763. ptype: dealPay.ptype,
  764. name: dealPay.name,
  765. minus: dealPay.minus ? true : false,
  766. is_yf: dealPay.is_yf ? true : false,
  767. };
  768. this.resultDealPay.push(rdp);
  769. }
  770. if (fun) fun(rdp, dealPay);
  771. }
  772. async _checkStagePayCalc(tender, stage, dealPay) {
  773. if (!stage.readOnly) {
  774. // 计算 本期金额
  775. const payCalculator = new PayCalculator(this.ctx, stage, tender.info);
  776. await payCalculator.calculateAll(dealPay);
  777. }
  778. }
  779. async _gatherStagePay(completeData, tender, stage, hasPre) {
  780. if (stage) {
  781. completeData.id = tender.id;
  782. completeData.name = tender.name;
  783. const helper = this.ctx.helper;
  784. await this.ctx.service.stage.doCheckStage(stage);
  785. const dealPay = await this.ctx.service.stagePay.getStagePays(stage);
  786. await this._checkStagePayCalc(tender, stage, dealPay);
  787. for (const dp of dealPay) {
  788. dp.end_tp = helper.add(dp.pre_tp, dp.tp);
  789. this._gatherPayRecord(dp, function (gatherData, sourceData) {
  790. gatherData[completeData.prefix + 'id'] = tender.id;
  791. gatherData[completeData.prefix + 'name'] = tender.name;
  792. gatherData[completeData.prefix + 'tp'] = helper.add(gatherData[completeData.prefix + 'tp'], sourceData.tp);
  793. gatherData[completeData.prefix + 'pre_tp'] = helper.add(gatherData[completeData.prefix + 'pre_tp'], sourceData.pre_tp);
  794. gatherData[completeData.prefix + 'end_tp'] = helper.add(gatherData[completeData.prefix + 'end_tp'], sourceData.end_tp);
  795. gatherData['s_' + 'tp'] = helper.add(gatherData['s_' + 'tp'], sourceData.tp);
  796. gatherData['s_' + 'pre_tp'] = helper.add(gatherData['s_' + 'pre_tp'], sourceData.pre_tp);
  797. gatherData['s_' + 'end_tp'] = helper.add(gatherData['s_' + 'end_tp'], sourceData.end_tp);
  798. });
  799. }
  800. }
  801. }
  802. async _gatherStagesPay(completeData, tender, stages) {
  803. const helper = this.ctx.helper;
  804. completeData.id = tender.id;
  805. completeData.name = tender.name;
  806. for (const stage of stages) {
  807. await this.ctx.service.stage.doCheckStage(stage);
  808. const dealPay = await this.ctx.service.stagePay.getStagePays(stage);
  809. await this._checkStagePayCalc(tender, stage, dealPay);
  810. for (const dp of dealPay) {
  811. dp.end_tp = helper.add(dp.pre_tp, dp.tp);
  812. this._gatherPayRecord(dp, function (gatherData, sourceData) {
  813. gatherData[completeData.prefix + 'id'] = tender.id;
  814. gatherData[completeData.prefix + 'name'] = tender.name;
  815. gatherData[completeData.prefix + 'tp'] = helper.add(gatherData[completeData.prefix + 'tp'], sourceData.tp);
  816. gatherData['s_' + 'tp'] = helper.add(gatherData['s_' + 'tp'], sourceData.tp);
  817. });
  818. }
  819. }
  820. }
  821. async _gatherMonthStagePay(sTender, completeData, month, hasPre) {
  822. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  823. const stages = await this._getValidStages(tender.id);
  824. const stage = this.ctx.helper._.find(stages, {s_time: month});
  825. await this._gatherStagePay(completeData, tender, stage, hasPre);
  826. }
  827. async _gatherOrderStagePay(sTender, completeData, order, hasPre) {
  828. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  829. const stages = await this._getValidStages(tender.id);
  830. const stage = this.ctx.helper._.find(stages, {order: order});
  831. await this._gatherStagePay(completeData, tender, stage, hasPre);
  832. }
  833. async _gatherZoneStagePay(sTender, completeData, zone) {
  834. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  835. const stages = await this._getTimeZoneStages(tender, zone);
  836. await this._gatherStagesPay(completeData, tender, stages);
  837. }
  838. async _gatherOrderZoneStagePay(sTender, completeData, stageZone) {
  839. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  840. const stages = await this._getOrderZoneStages(tender, stageZone)
  841. await this._gatherStagesPay(completeData, tender, stages);
  842. }
  843. async _gatherFinalStagePay(sTender, completeData, hasPre) {
  844. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  845. const stages = await this._getValidStages(tender.id);
  846. await this._gatherStagePay(completeData, tender, stages[0], hasPre);
  847. }
  848. async _gatherCheckedFinalStagePay(sTender, completeData, hasPre) {
  849. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  850. const stages = await this._getCheckedStages(tender.id);
  851. await this._gatherStagePay(completeData, tender, stages[0], hasPre);
  852. }
  853. async getGatherStagePay(memFieldKeys, gsDefine, gsCustom) {
  854. if (!gsDefine || !gsDefine.enable) return [];
  855. if (!gsCustom || !gsCustom.tenders || gsCustom.tenders.length === 0) return [];
  856. this.resultTenderInfo = [];
  857. const gsSetting = JSON.parse(gsDefine.setting);
  858. let commonIndex = 0;
  859. const completeDatas = [];
  860. for (const tender of gsCustom.tenders) {
  861. const specialKey = this._checkSpecialTender(tender, gsSetting.special);
  862. if (specialKey === '') {
  863. const completeData = {
  864. prefix: 't_' + commonIndex + '_',
  865. };
  866. completeDatas.push(completeData);
  867. switch (gsSetting.type) {
  868. case 'month':
  869. await this._gatherMonthStagePay(tender, completeData, gsCustom.month, gsSetting.hasPre);
  870. break;
  871. case 'zone':
  872. await this._gatherZoneStagePay(tender, completeData, gsCustom.zone);
  873. break;
  874. case 'final':
  875. await this._gatherFinalStagePay(tender, completeData, gsSetting.hasPre);
  876. break;
  877. case 'checked-final':
  878. await this._gatherCheckedFinalStagePay(tender, completeData, gsSetting.hasPre);
  879. break;
  880. case 'stage':
  881. await this._gatherOrderStagePay(tender, completeData, gsCustom.stage, gsSetting.hasPre);
  882. break;
  883. case 'stage-zone':
  884. await this._gatherOrderZoneStagePay(tender, completeData, gsCustom.stage_zone);
  885. break;
  886. }
  887. commonIndex++;
  888. }
  889. // 合同支付,只有在每一期中有数据,故特殊标段直接不汇总合同支付
  890. }
  891. gatherUtils.completeGatherData(this.resultDealPay, completeDatas);
  892. return this.resultDealPay;
  893. }
  894. /**
  895. * 签约清单
  896. */
  897. async _gatherDealBills(tender, fun) {
  898. const dealBills = await this.ctx.service.dealBills.getAllDataByCondition({
  899. where: { tender_id: tender.id }
  900. });
  901. for (const db of dealBills) {
  902. let rdb = this.ctx.helper._.find(this.resultDealBills, {
  903. code: db.code,
  904. name: db.name,
  905. unit: db.unit,
  906. unit_price: db.unit_price ? db.unit_price: 0,
  907. });
  908. if (!rdb) {
  909. rdb = {
  910. code: db.code,
  911. name: db.name,
  912. unit: db.unit,
  913. unit_price: db.unit_price ? db.unit_price: 0,
  914. };
  915. this.resultDealBills.push(rdb);
  916. }
  917. if (fun) fun(rdb, db);
  918. }
  919. }
  920. async _gatherCommonDealBills(sTender, completeData) {
  921. const self = this;
  922. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  923. completeData.id = tender.id;
  924. completeData.name = tender.name;
  925. await this._gatherDealBills(tender, function (gatherData, sourceData) {
  926. gatherData[completeData.prefix + 'id'] = tender.id;
  927. gatherData[completeData.prefix + 'name'] = tender.name;
  928. gatherData[completeData.prefix + 'qty'] = sourceData.quantity;
  929. gatherData[completeData.prefix + 'tp'] = sourceData.total_price;
  930. gatherData['s_' + 'qty'] = self.ctx.helper.add(gatherData['s_' + 'qty'], sourceData.quantity);
  931. gatherData['s_' + 'tp'] = self.ctx.helper.add(gatherData['s_' + 'tp'], sourceData.total_price);
  932. });
  933. }
  934. async _gatherSpecialDealBills(sTender, sKey) {
  935. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  936. await this._gatherDealBills(tender, function (gatherData, sourceData) {
  937. const prefix = 'ts_' + sKey + '_';
  938. gatherData[prefix + 'qty'] = sourceData.quantity;
  939. gatherData[prefix + 'tp'] = sourceData.total_price;
  940. });
  941. }
  942. async getGatherDealBills(memFieldKeys, gsDefine, gsCustom) {
  943. if (!gsDefine || !gsDefine.enable) return [];
  944. if (!gsCustom || !gsCustom.tenders || gsCustom.tenders.length === 0) return [];
  945. this.resultTenderInfo = [];
  946. const gsSetting = JSON.parse(gsDefine.setting);
  947. let commonIndex = 0;
  948. const completeDatas = [];
  949. for (const tender of gsCustom.tenders) {
  950. const specialKey = this._checkSpecialTender(tender, gsSetting.special);
  951. if (specialKey === '') {
  952. const completeData = {
  953. prefix: 't_' + commonIndex + '_',
  954. };
  955. completeDatas.push(completeData);
  956. await this._gatherCommonDealBills(tender, completeData);
  957. commonIndex++;
  958. } else {
  959. await this._gatherSpecialDealBills(tender, specialKey);
  960. }
  961. }
  962. gatherUtils.completeGatherData(this.resultDealBills, completeDatas);
  963. return this.resultDealBills;
  964. }
  965. }
  966. return RptGatherMemory;
  967. };