rpt_gather_memory.js 42 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859
  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. }
  23. }
  24. },
  25. gatherStage: function (tender, gatherNode, sourceNode, prefix, helper) {
  26. gatherNode[prefix + 'id'] = tender.id;
  27. gatherNode[prefix + 'name'] = tender.name;
  28. gatherNode[prefix + "qty"] = helper.add(gatherNode[prefix + "qty"], sourceNode.quantity);
  29. gatherNode[prefix + "tp"] = helper.add(gatherNode[prefix + "tp"], sourceNode.total_price);
  30. gatherNode[prefix + "dgn_qty1"] = helper.add(gatherNode[prefix + "dgn_qty1"], sourceNode.dgn_qty1);
  31. gatherNode[prefix + "dgn_qty2"] = helper.add(gatherNode[prefix + "dgn_qty2"], sourceNode.dgn_qty2);
  32. gatherNode[prefix + "contract_qty"] = helper.add(gatherNode[prefix + "contract_qty"], sourceNode.contract_qty);
  33. gatherNode[prefix + "contract_tp"] = helper.add(gatherNode[prefix + "contract_tp"], sourceNode.contract_tp);
  34. gatherNode[prefix + "qc_qty"] = helper.add(gatherNode[prefix + "qc_qty"], sourceNode.qc_qty);
  35. gatherNode[prefix + "qc_tp"] = helper.add(gatherNode[prefix + "qc_tp"], sourceNode.qc_tp);
  36. gatherNode[prefix + "gather_qty"] = helper.add(gatherNode[prefix + "gather_qty"], sourceNode.gather_qty);
  37. gatherNode[prefix + "gather_tp"] = helper.add(gatherNode[prefix + "gather_tp"], sourceNode.gather_tp);
  38. gatherNode[prefix + "pre_contract_qty"] = helper.add(gatherNode[prefix + "pre_contract_qty"], sourceNode.pre_contract_qty);
  39. gatherNode[prefix + "pre_contract_tp"] = helper.add(gatherNode[prefix + "pre_contract_tp"], sourceNode.pre_contract_tp);
  40. gatherNode[prefix + "pre_qc_qty"] = helper.add(gatherNode[prefix + "pre_qc_qty"], sourceNode.pre_qc_qty);
  41. gatherNode[prefix + "pre_qc_tp"] = helper.add(gatherNode[prefix + "pre_qc_tp"], sourceNode.pre_qc_tp);
  42. gatherNode[prefix + "pre_gather_qty"] = helper.add(gatherNode[prefix + "pre_gather_qty"], sourceNode.pre_gather_qty);
  43. gatherNode[prefix + "pre_gather_tp"] = helper.add(gatherNode[prefix + "pre_gather_tp"], sourceNode.pre_gather_tp);
  44. gatherNode[prefix + "end_contract_qty"] = helper.add(gatherNode[prefix + "end_contract_qty"], sourceNode.end_contract_qty);
  45. gatherNode[prefix + "end_contract_tp"] = helper.add(gatherNode[prefix + "end_contract_tp"], sourceNode.end_contract_tp);
  46. gatherNode[prefix + "end_qc_qty"] = helper.add(gatherNode[prefix + "end_qc_qty"], sourceNode.end_qc_qty);
  47. gatherNode[prefix + "end_qc_tp"] = helper.add(gatherNode[prefix + "end_qc_tp"], sourceNode.end_qc_tp);
  48. gatherNode[prefix + "end_gather_qty"] = helper.add(gatherNode[prefix + "end_gather_qty"], sourceNode.end_gather_qty);
  49. gatherNode[prefix + "end_gather_tp"] = helper.add(gatherNode[prefix + "end_gather_tp"], sourceNode.end_gather_tp);
  50. gatherNode[prefix + "deal_dgn_qty1"] = helper.add(gatherNode[prefix + "deal_dgn_qty1"], sourceNode.deal_dgn_qty1);
  51. gatherNode[prefix + "deal_dgn_qty2"] = helper.add(gatherNode[prefix + "deal_dgn_qty2"], sourceNode.deal_dgn_qty2);
  52. gatherNode[prefix + "c_dgn_qty1"] = helper.add(gatherNode[prefix + "c_dgn_qty1"], sourceNode.c_dgn_qty1);
  53. gatherNode[prefix + "c_dgn_qty2"] = helper.add(gatherNode[prefix + "c_dgn_qty2"], sourceNode.c_dgn_qty2);
  54. gatherNode['s_' + "qty"] = helper.add(gatherNode['s_' + "qty"], sourceNode.quantity);
  55. gatherNode['s_' + "tp"] = helper.add(gatherNode['s_' + "tp"], sourceNode.total_price);
  56. gatherNode['s_' + "dgn_qty1"] = helper.add(gatherNode['s_' + "dgn_qty1"], sourceNode.dgn_qty1);
  57. gatherNode['s_' + "dgn_qty2"] = helper.add(gatherNode['s_' + "dgn_qty2"], sourceNode.dgn_qty2);
  58. gatherNode['s_' + "contract_qty"] = helper.add(gatherNode['s_' + "contract_qty"], sourceNode.contract_qty);
  59. gatherNode['s_' + "contract_tp"] = helper.add(gatherNode['s_' + "contract_tp"], sourceNode.contract_tp);
  60. gatherNode['s_' + "qc_qty"] = helper.add(gatherNode['s_' + "qc_qty"], sourceNode.qc_qty);
  61. gatherNode['s_' + "qc_tp"] = helper.add(gatherNode['s_' + "qc_tp"], sourceNode.qc_tp);
  62. gatherNode['s_' + "gather_qty"] = helper.add(gatherNode['s_' + "gather_qty"], sourceNode.gather_qty);
  63. gatherNode['s_' + "gather_tp"] = helper.add(gatherNode['s_' + "gather_tp"], sourceNode.gather_tp);
  64. gatherNode['s_' + "pre_contract_qty"] = helper.add(gatherNode['s_' + "pre_contract_qty"], sourceNode.pre_contract_qty);
  65. gatherNode['s_' + "pre_contract_tp"] = helper.add(gatherNode['s_' + "pre_contract_tp"], sourceNode.pre_contract_tp);
  66. gatherNode['s_' + "pre_qc_qty"] = helper.add(gatherNode['s_' + "pre_qc_qty"], sourceNode.pre_qc_qty);
  67. gatherNode['s_' + "pre_qc_tp"] = helper.add(gatherNode['s_' + "pre_qc_tp"], sourceNode.pre_qc_tp);
  68. gatherNode['s_' + "pre_gather_qty"] = helper.add(gatherNode['s_' + "pre_gather_qty"], sourceNode.pre_gather_qty);
  69. gatherNode['s_' + "pre_gather_tp"] = helper.add(gatherNode['s_' + "pre_gather_tp"], sourceNode.pre_gather_tp);
  70. gatherNode['s_' + "end_contract_qty"] = helper.add(gatherNode['s_' + "end_contract_qty"], sourceNode.end_contract_qty);
  71. gatherNode['s_' + "end_contract_tp"] = helper.add(gatherNode['s_' + "end_contract_tp"], sourceNode.end_contract_tp);
  72. gatherNode['s_' + "end_qc_qty"] = helper.add(gatherNode['s_' + "end_qc_qty"], sourceNode.end_qc_qty);
  73. gatherNode['s_' + "end_qc_tp"] = helper.add(gatherNode['s_' + "end_qc_tp"], sourceNode.end_qc_tp);
  74. gatherNode['s_' + "end_gather_qty"] = helper.add(gatherNode['s_' + "end_gather_qty"], sourceNode.end_gather_qty);
  75. gatherNode['s_' + "end_gather_tp"] = helper.add(gatherNode['s_' + "end_gather_tp"], sourceNode.end_gather_tp);
  76. gatherNode['s_' + "deal_dgn_qty1"] = helper.add(gatherNode['s_' + "deal_dgn_qty1"], sourceNode.deal_dgn_qty1);
  77. gatherNode['s_' + "deal_dgn_qty2"] = helper.add(gatherNode['s_' + "deal_dgn_qty2"], sourceNode.deal_dgn_qty2);
  78. gatherNode['s_' + "c_dgn_qty1"] = helper.add(gatherNode['s_' + "c_dgn_qty1"], sourceNode.c_dgn_qty1);
  79. gatherNode['s_' + "c_dgn_qty2"] = helper.add(gatherNode['s_' + "c_dgn_qty2"], sourceNode.c_dgn_qty2);
  80. },
  81. gatherZone: function (tender, gatherNode, sourceNode, prefix, helper) {
  82. gatherNode[prefix + 'id'] = tender.id;
  83. gatherNode[prefix + 'name'] = tender.name;
  84. gatherNode[prefix + "qty"] = helper.add(gatherNode[prefix + "qty"], sourceNode.quantity);
  85. gatherNode[prefix + "tp"] = helper.add(gatherNode[prefix + "tp"], sourceNode.total_price);
  86. gatherNode[prefix + "dgn_qty1"] = helper.add(gatherNode[prefix + "dgn_qty1"], sourceNode.dgn_qty1);
  87. gatherNode[prefix + "dgn_qty2"] = helper.add(gatherNode[prefix + "dgn_qty2"], sourceNode.dgn_qty2);
  88. gatherNode[prefix + "contract_qty"] = helper.add(gatherNode[prefix + "contract_qty"], sourceNode.contract_qty);
  89. gatherNode[prefix + "contract_tp"] = helper.add(gatherNode[prefix + "contract_tp"], sourceNode.contract_tp);
  90. gatherNode[prefix + "qc_qty"] = helper.add(gatherNode[prefix + "qc_qty"], sourceNode.qc_qty);
  91. gatherNode[prefix + "qc_tp"] = helper.add(gatherNode[prefix + "qc_tp"], sourceNode.qc_tp);
  92. gatherNode[prefix + "gather_qty"] = helper.add(gatherNode[prefix + "gather_qty"], sourceNode.gather_qty);
  93. gatherNode[prefix + "gather_tp"] = helper.add(gatherNode[prefix + "gather_tp"], sourceNode.gather_tp);
  94. gatherNode[prefix + "deal_dgn_qty1"] = helper.add(gatherNode[prefix + "deal_dgn_qty1"], sourceNode.deal_dgn_qty1);
  95. gatherNode[prefix + "deal_dgn_qty2"] = helper.add(gatherNode[prefix + "deal_dgn_qty2"], sourceNode.deal_dgn_qty2);
  96. gatherNode[prefix + "c_dgn_qty1"] = helper.add(gatherNode[prefix + "c_dgn_qty1"], sourceNode.c_dgn_qty1);
  97. gatherNode[prefix + "c_dgn_qty2"] = helper.add(gatherNode[prefix + "c_dgn_qty2"], sourceNode.c_dgn_qty2);
  98. gatherNode['s_' + "qty"] = helper.add(gatherNode['s_' + "qty"], sourceNode.quantity);
  99. gatherNode['s_' + "tp"] = helper.add(gatherNode['s_' + "tp"], sourceNode.total_price);
  100. gatherNode['s_' + "contract_qty"] = helper.add(gatherNode['s_' + "contract_qty"], sourceNode.contract_qty);
  101. gatherNode['s_' + "contract_tp"] = helper.add(gatherNode['s_' + "contract_tp"], sourceNode.contract_tp);
  102. gatherNode['s_' + "qc_qty"] = helper.add(gatherNode['s_' + "qc_qty"], sourceNode.qc_qty);
  103. gatherNode['s_' + "qc_tp"] = helper.add(gatherNode['s_' + "qc_tp"], sourceNode.qc_tp);
  104. gatherNode['s_' + "gather_qty"] = helper.add(gatherNode['s_' + "gather_qty"], sourceNode.gather_qty);
  105. gatherNode['s_' + "gather_tp"] = helper.add(gatherNode['s_' + "gather_tp"], sourceNode.gather_tp);
  106. },
  107. gatherLedger: function (tender, gatherNode, sourceNode, prefix, helper) {
  108. gatherNode[prefix + 'id'] = tender.id;
  109. gatherNode[prefix + 'name'] = tender.name;
  110. gatherNode[prefix + "qty"] = helper.add(gatherNode[prefix + "qty"], sourceNode.quantity);
  111. gatherNode[prefix + "tp"] = helper.add(gatherNode[prefix + "tp"], sourceNode.total_price);
  112. gatherNode[prefix + "dgn_qty1"] = helper.add(gatherNode[prefix + "dgn_qty1"], sourceNode.dgn_qty1);
  113. gatherNode[prefix + "dgn_qty2"] = helper.add(gatherNode[prefix + "dgn_qty2"], sourceNode.dgn_qty2);
  114. gatherNode['s_' + "qty"] = helper.add(gatherNode['s_' + "qty"], sourceNode.quantity);
  115. gatherNode['s_' + "tp"] = helper.add(gatherNode['s_' + "tp"], sourceNode.total_price);
  116. },
  117. gatherSpecial: function (gatherNode, sourceNode, prefix, helper) {
  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. },
  123. };
  124. module.exports = app => {
  125. class RptGatherMemory extends app.BaseService {
  126. /**
  127. * 构造函数
  128. *
  129. * @param {Object} ctx - egg全局context
  130. * @return {void}
  131. */
  132. constructor(ctx) {
  133. super(ctx);
  134. this.resultTree = new Ledger.gatherTree(ctx, {
  135. id: 'id',
  136. pid: 'pid',
  137. order: 'order',
  138. level: 'level',
  139. rootId: -1
  140. });
  141. this.resultTenderInfo = [];
  142. this.resultDealPay = [];
  143. this.resultDealBills = [];
  144. }
  145. async _getValidStages(tenderId) {
  146. const stages = await this.db.select(this.ctx.service.stage.tableName, {
  147. where: { tid: tenderId },
  148. orders: [['order', 'desc']],
  149. });
  150. if (stages.length !== 0) {
  151. const lastStage = stages[0];
  152. if (lastStage.status === auditConst.stage.status.uncheck && lastStage.user_id !== this.ctx.session.sessionUser.accountId) {
  153. stages.splice(0, 1);
  154. }
  155. }
  156. return stages;
  157. }
  158. async _getCheckedStages(tenderId) {
  159. const stages = await this.db.select(this.ctx.service.stage.tableName, {
  160. where: { tid: tenderId },
  161. orders: [['order', 'desc']],
  162. });
  163. if (stages.length !== 0) {
  164. const lastStage = stages[0];
  165. if (lastStage.status !== auditConst.stage.status.checked) {
  166. stages.splice(0, 1);
  167. }
  168. }
  169. return stages;
  170. }
  171. _checkSpecialTender(tender, special) {
  172. if (special) {
  173. for (const spec of special) {
  174. if (tender[spec.key] === true) return spec.key;
  175. }
  176. }
  177. return '';
  178. }
  179. /**
  180. * 台账数据
  181. */
  182. async _gatherStageData(completeData, tender, stage, hasPre) {
  183. const helper = this.ctx.helper;
  184. completeData.id = tender.id;
  185. completeData.name = tender.name;
  186. const billsTree = new Ledger.billsTree(this.ctx, {
  187. id: 'ledger_id',
  188. pid: 'ledger_pid',
  189. order: 'order',
  190. level: 'level',
  191. rootId: -1,
  192. keys: ['id', 'tender_id', 'ledger_id'],
  193. stageId: 'id',
  194. calcFields: ['deal_tp', 'total_price', 'contract_tp', 'qc_tp', 'gather_tp', 'pre_contract_tp', 'pre_qc_tp', 'pre_gather_tp'],
  195. calc: function (node) {
  196. if (node.children && node.children.length === 0) {
  197. node.pre_gather_qty = helper.add(node.pre_contract_qty, node.pre_qc_qty);
  198. node.gather_qty = helper.add(node.contract_qty, node.qc_qty);
  199. node.end_contract_qty = helper.add(node.pre_contract_qty, node.contract_qty);
  200. node.end_qc_qty = helper.add(node.pre_qc_qty, node.qc_qty);
  201. node.end_gather_qty = helper.add(node.pre_gather_qty, node.gather_qty);
  202. }
  203. node.pre_gather_tp = helper.add(node.pre_contract_tp, node.pre_qc_tp);
  204. node.gather_tp = helper.add(node.contract_tp, node.qc_tp);
  205. node.end_contract_tp = helper.add(node.pre_contract_tp, node.contract_tp);
  206. node.end_qc_tp = helper.add(node.pre_qc_tp, node.qc_tp);
  207. node.end_gather_tp = helper.add(node.pre_gather_tp, node.gather_tp);
  208. }
  209. });
  210. const billsData = await this.ctx.service.ledger.getData(tender.id);
  211. const dgnData = await this.ctx.service.stageBillsDgn.getDgnData(tender.id);
  212. for (const d of dgnData) {
  213. const l = this.ctx.helper._.find(billsData, {id: d.id});
  214. this.ctx.helper._.assignIn(l, d);
  215. }
  216. if (stage) {
  217. await this.ctx.service.stage.doCheckStage(stage);
  218. if (stage.readOnly) {
  219. const curStage = await this.ctx.service.stageBills.getAuditorStageData(tender.id,
  220. stage.id, stage.curTimes, stage.curOrder);
  221. this.ctx.helper.assignRelaData(billsData, [
  222. {data: curStage, fields: ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp'], prefix: '', relaId: 'lid'}
  223. ]);
  224. } else {
  225. const curStage = await this.ctx.service.stageBills.getLastestStageData(tender.id, stage.id);
  226. this.ctx.helper.assignRelaData(billsData, [
  227. {data: curStage, fields: ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp'], prefix: '', relaId: 'lid'}
  228. ]);
  229. }
  230. if (hasPre) {
  231. const preStage = stage.order > 1 ? await this.ctx.service.stageBillsFinal.getFinalData(tender, stage.order - 1) : [];
  232. this.ctx.helper.assignRelaData(billsData, [
  233. {data: preStage, fields: ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp'], prefix: 'pre_', relaId: 'lid'}
  234. ]);
  235. }
  236. }
  237. billsTree.loadDatas(billsData);
  238. billsTree.calculateAll();
  239. this.resultTree.loadGatherTree(billsTree, function (gatherNode, sourceNode) {
  240. gatherUtils.gatherStage(tender, gatherNode, sourceNode, completeData.prefix, helper);
  241. });
  242. }
  243. async _gatherMonthData(sTender, completeData, month, hasPre) {
  244. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  245. const stages = await this._getValidStages(tender.id);
  246. const stage = this.ctx.helper._.find(stages, {s_time: month});
  247. await this._gatherStageData(completeData, tender, stage, hasPre);
  248. }
  249. async _gatherZoneData(sTender, completeData, zone) {
  250. const helper = this.ctx.helper;
  251. /**
  252. * 汇总并合并 相关数据
  253. * @param {Array} index - 主数据
  254. * @param {Array[]}rela - 相关数据 {data, fields, prefix, relaId}
  255. */
  256. const sumAssignRelaData = function (index, rela) {
  257. const loadFields = function (datas, fields, prefix, relaId) {
  258. for (const d of datas) {
  259. const key = indexPre + d[relaId];
  260. const m = index[key];
  261. if (m) {
  262. for (const f of fields) {
  263. if (d[f] !== undefined) {
  264. m[prefix + f] = helper.add(m[prefix + f], d[f]);
  265. }
  266. }
  267. }
  268. }
  269. };
  270. for (const r of rela) {
  271. loadFields(r.data, r.fields, r.prefix, r.relaId);
  272. }
  273. };
  274. const billsTree = new Ledger.billsTree(this.ctx, {
  275. id: 'ledger_id',
  276. pid: 'ledger_pid',
  277. order: 'order',
  278. level: 'level',
  279. rootId: -1,
  280. keys: ['id', 'tender_id', 'ledger_id'],
  281. stageId: 'id',
  282. calcFields: ['deal_tp', 'total_price', 'contract_tp', 'qc_tp', 'gather_tp'],
  283. calc: function (node) {
  284. if (node.children && node.children.length === 0) {
  285. node.gather_qty = helper.add(node.contract_qty, node.qc_qty);
  286. }
  287. node.gather_tp = helper.add(node.contract_tp, node.qc_tp);
  288. }
  289. });
  290. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  291. completeData.id = tender.id;
  292. completeData.name = tender.name;
  293. const billsData = await this.ctx.service.ledger.getData(tender.id);
  294. const dgnData = await this.ctx.service.stageBillsDgn.getDgnData(tender.id);
  295. for (const d of dgnData) {
  296. const l = this.ctx.helper._.find(billsData, {id: d.id});
  297. this.ctx.helper._.assignIn(l, d);
  298. }
  299. let billsIndexData = {};
  300. for (const bd of billsData) {
  301. billsIndexData[indexPre + bd.id] = bd;
  302. }
  303. const times = zone.split(' - ');
  304. if (times.length !== 2) throw '选择的汇总周期无效';
  305. const beginTime = moment(times[0], 'YYYY-MM');
  306. const endTime = moment(times[1], 'YYYY-MM');
  307. const stages = await this._getValidStages(tender.id);
  308. for (const stage of stages) {
  309. const sTime = moment(stage.s_time, 'YYYY-MM');
  310. if (sTime.isBetween(beginTime, endTime, null, '[]')) {
  311. await this.ctx.service.stage.doCheckStage(stage);
  312. if (stage.readOnly) {
  313. const curStage = await this.ctx.service.stageBills.getAuditorStageData(tender.id,
  314. stage.id, stage.curTimes, stage.curOrder);
  315. sumAssignRelaData(billsIndexData, [
  316. {data: curStage, fields: ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp'], prefix: '', relaId: 'lid'}
  317. ]);
  318. } else {
  319. const curStage = await this.ctx.service.stageBills.getLastestStageData(tender.id, stage.id);
  320. sumAssignRelaData(billsIndexData, [
  321. {data: curStage, fields: ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp'], prefix: '', relaId: 'lid'}
  322. ]);
  323. }
  324. }
  325. }
  326. billsTree.loadDatas(billsData);
  327. billsTree.calculateAll();
  328. this.resultTree.loadGatherTree(billsTree, function (gatherNode, sourceNode) {
  329. gatherUtils.gatherZone(gatherNode, sourceNode, completeData.prefix, helper);
  330. });
  331. }
  332. async _gatherFinalData(sTender, completeData, hasPre) {
  333. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  334. const stages = await this._getValidStages(tender.id);
  335. await this._gatherStageData(completeData, tender, stages[0], hasPre);
  336. }
  337. async _gatherCheckedFinalData(sTender, completeData, hasPre) {
  338. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  339. const stages = await this._getCheckedStages(tender.id);
  340. await this._gatherStageData(completeData, tender, stages[0], hasPre);
  341. }
  342. async _gatherLedgerData(sTender, completeData) {
  343. const helper = this.ctx.helper;
  344. const billsTree = new Ledger.billsTree(this.ctx, {
  345. id: 'ledger_id',
  346. pid: 'ledger_pid',
  347. order: 'order',
  348. level: 'level',
  349. rootId: -1,
  350. keys: ['id', 'tender_id', 'ledger_id'],
  351. stageId: 'id',
  352. calcFields: ['deal_tp', 'total_price'],
  353. });
  354. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  355. const billsData = await this.ctx.service.ledger.getData(tender.id);
  356. billsTree.loadDatas(billsData);
  357. billsTree.calculateAll();
  358. this.resultTree.loadGatherTree(billsTree, function (gatherNode, sourceNode) {
  359. gatherUtils.gatherLedger(tender, gatherNode, sourceNode, completeData.prefix, helper);
  360. })
  361. }
  362. async _gatherSpecialData(sTender, sKey) {
  363. const helper = this.ctx.helper;
  364. const billsTree = new Ledger.billsTree(this.ctx, {
  365. id: 'ledger_id',
  366. pid: 'ledger_pid',
  367. order: 'order',
  368. level: 'level',
  369. rootId: -1,
  370. keys: ['id', 'tender_id', 'ledger_id'],
  371. stageId: 'id',
  372. calcFields: ['deal_tp', 'total_price'],
  373. });
  374. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  375. const billsData = await this.ctx.service.ledger.getData(tender.id);
  376. billsTree.loadDatas(billsData);
  377. billsTree.calculateAll();
  378. this.resultTree.loadGatherTree(billsTree, function (gatherNode, sourceNode) {
  379. gatherUtils.gatherSpecial(gatherNode, sourceNode, 'ts_' + sKey + '_', helper);
  380. })
  381. }
  382. async getGatherStageBills(memFieldKeys, gsDefine, gsCustom) {
  383. if (!gsDefine || !gsDefine.enable) return [];
  384. if (!gsCustom || !gsCustom.tenders || gsCustom.tenders.length === 0) return [];
  385. const gsSetting = JSON.parse(gsDefine.setting);
  386. let commonIndex = 0;
  387. const completeDatas = [];
  388. for (const tender of gsCustom.tenders) {
  389. const specialKey = this._checkSpecialTender(tender, gsSetting.special);
  390. if (specialKey === '') {
  391. const completeData = {
  392. prefix: 't_' + commonIndex + '_',
  393. };
  394. completeDatas.push(completeData);
  395. switch (gsSetting.type) {
  396. case 'month':
  397. await this._gatherMonthData(tender, completeData, gsCustom.month, gsSetting.hasPre);
  398. break;
  399. case 'zone':
  400. await this._gatherZoneData(tender, completeData, gsCustom.zone);
  401. break;
  402. case 'final':
  403. await this._gatherFinalData(tender, completeData, gsSetting.hasPre);
  404. break;
  405. case 'checked-final':
  406. await this._gatherCheckedFinalData(tender, completeData, gsSetting.hasPre);
  407. break;
  408. case 'ledger':
  409. await this._gatherLedgerData(tender, completeData);
  410. break;
  411. }
  412. commonIndex++;
  413. } else {
  414. await this._gatherSpecialData(tender, specialKey);
  415. }
  416. }
  417. this.resultTree.generateSortNodes();
  418. gatherUtils.completeGatherData(this.resultTree.nodes, completeDatas);
  419. return this.resultTree.getDefaultDatas();
  420. }
  421. /**
  422. * 标段信息
  423. */
  424. async _getBaseTenderInfo(tender) {
  425. const info = {
  426. id: tender.id,
  427. name: tender.name,
  428. deal_tp: tender.deal_tp,
  429. tp: tender.total_price
  430. };
  431. const deal_bills_sum = await this.ctx.service.dealBills.getSum(tender.id);
  432. info.deal_bills_tp = deal_bills_sum ? deal_bills_sum.total_price : 0;
  433. if (tender.ledger_status === auditConst.ledger.status.uncheck || tender.ledger_status === auditConst.ledger.status.checkNo) {
  434. const sum = await this.ctx.service.ledger.addUp({tender_id: tender.id/*, is_leaf: true*/});
  435. info.tp = sum.total_price;
  436. info.deal_tp = sum.deal_tp;
  437. }
  438. info.deal_info = tender.info.deal_info;
  439. info.construction_unit = tender.info.construction_unit;
  440. info.tech_param = tender.info.tech_param;
  441. info.deal_param = tender.info.deal_param;
  442. info.pay_account = tender.info.pay_account;
  443. info.deal_param.contractPriceWithoutZL = this.ctx.helper.sub(info.deal_param.contractPrice,
  444. info.deal_param.zanLiePrice);
  445. info.bid_info = tender.info.bid_info;
  446. return info;
  447. }
  448. async _getStageTenderInfo(stage, info) {
  449. if (stage) {
  450. const helper = this.ctx.helper;
  451. await this.ctx.service.stage.doCheckStage(stage);
  452. await this.ctx.service.stage.checkStageGatherData(stage);
  453. info.pre_contract_tp = stage.pre_contract_tp;
  454. info.pre_qc_tp = stage.pre_qc_tp;
  455. info.pre_gather_tp = helper.add(info.pre_contract_tp, info.pre_qc_tp);
  456. info.contract_tp = stage.contract_tp;
  457. info.qc_tp = stage.qc_tp;
  458. info.gather_tp = helper.add(info.contract_tp, info.qc_tp);
  459. info.end_contract_tp = helper.add(info.pre_contract_tp, info.contract_tp);
  460. info.end_qc_tp = helper.add(info.pre_qc_tp, info.qc_tp);
  461. info.end_gather_tp = helper.add(info.pre_gather_tp, info.gather_tp);
  462. info.yf_tp = stage.yf_tp;
  463. info.pre_yf_tp = stage.pre_yf_tp;
  464. info.end_yf_tp = helper.add(stage.yf_tp, stage.pre_yf_tp);
  465. }
  466. }
  467. async _gatherMonthTenderInfo(sTender, index, month, hasPre) {
  468. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  469. const info = await this._getBaseTenderInfo(tender);
  470. const stages = await this._getValidStages(tender.id);
  471. const stage = this.ctx.helper._.find(stages, {s_time: month});
  472. await this._getStageTenderInfo(stage, info);
  473. this.resultTenderInfo.push(info);
  474. }
  475. async _gatherZoneTenderInfo(sTender, index, zone) {
  476. const helper = this.ctx.helper;
  477. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  478. const info = await this._getBaseTenderInfo(tender);
  479. const times = zone.split(' - ');
  480. if (times.length !== 2) throw '选择的汇总周期无效';
  481. const beginTime = moment(times[0], 'YYYY-MM');
  482. const endTime = moment(times[1], 'YYYY-MM');
  483. const stages = await this._getValidStages(tender.id, true);
  484. for (const stage of stages) {
  485. const sTime = moment(stage.s_time, 'YYYY-MM');
  486. if (sTime.isBetween(beginTime, endTime, null, '[]')) {
  487. await this.ctx.service.stage.doCheckStage(stage);
  488. await this.ctx.service.stage.checkStageGatherData(stage);
  489. info.contract_tp = helper.add(info.contract_tp, stage.contract_tp);
  490. info.qc_tp = helper.add(info.qc_tp, stage.qc_tp);
  491. info.yf_tp = helper.add(info.yf_tp, stage.yf_tp);
  492. }
  493. }
  494. info.gather_tp = helper.add(info.contract_tp, info.qc_tp);
  495. this.resultTenderInfo.push(info);
  496. }
  497. async _gatherFinalTenderInfo(sTender, index, hasPre) {
  498. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  499. const info = await this._getBaseTenderInfo(tender);
  500. const stages = await this._getValidStages(tender.id);
  501. await this._getStageTenderInfo(stages[0], info);
  502. this.resultTenderInfo.push(info);
  503. }
  504. async _gatherCheckedFinalTenderInfo(sTender, index, hasPre) {
  505. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  506. const info = await this._getBaseTenderInfo(tender);
  507. const stages = await this._getCheckedStages(tender.id);
  508. await this._getStageTenderInfo(stages[0], info);
  509. this.resultTenderInfo.push(info);
  510. }
  511. async _gatherLedgerTenderInfo(sTender, index) {
  512. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  513. const info = await this._getBaseTenderInfo(tender);
  514. this.resultTenderInfo.push(info);
  515. }
  516. async _gatherSpecialTenderInfo(sTender, sKey) {
  517. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  518. const info = await this._getBaseTenderInfo(tender);
  519. info.spec = sKey;
  520. this.resultTenderInfo.push(info);
  521. }
  522. async getGatherTenderInfo(memFieldKeys, gsDefine, gsCustom) {
  523. if (!gsDefine || !gsDefine.enable) return [];
  524. if (!gsCustom || !gsCustom.tenders || gsCustom.tenders.length === 0) return [];
  525. this.resultTenderInfo = [];
  526. const gsSetting = JSON.parse(gsDefine.setting);
  527. let commonIndex = 0;
  528. for (const tender of gsCustom.tenders) {
  529. const specialKey = this._checkSpecialTender(tender, gsSetting.special);
  530. if (specialKey === '') {
  531. switch (gsSetting.type) {
  532. case 'month':
  533. await this._gatherMonthTenderInfo(tender, commonIndex, gsCustom.month, gsSetting.hasPre);
  534. break;
  535. case 'zone':
  536. await this._gatherZoneTenderInfo(tender, commonIndex, gsCustom.zone);
  537. break;
  538. case 'final':
  539. await this._gatherFinalTenderInfo(tender, commonIndex, gsSetting.hasPre);
  540. break;
  541. case 'checked-final':
  542. await this._gatherCheckedFinalTenderInfo(tender, commonIndex, gsSetting.hasPre);
  543. break;
  544. case 'ledger':
  545. await this._gatherLedgerTenderInfo(tender, commonIndex);
  546. break;
  547. }
  548. commonIndex++;
  549. } else {
  550. await this._gatherSpecialTenderInfo(tender, specialKey);
  551. }
  552. }
  553. return this.resultTenderInfo;
  554. }
  555. /**
  556. * 合同支付
  557. */
  558. _gatherPayRecord(dealPay, fun) {
  559. let rdp;
  560. if (dealPay.ptype !== payConst.payType.normal) {
  561. rdp = this.ctx.helper._.find(this.resultDealPay, {ptype: dealPay.ptype});
  562. } else {
  563. rdp = this.ctx.helper._.find(this.resultDealPay, {
  564. name: dealPay.name,
  565. minus: dealPay.minus ? true : false,
  566. is_yf: dealPay.is_yf ? true : false,
  567. });
  568. }
  569. if (!rdp) {
  570. rdp = {
  571. ptype: dealPay.ptype,
  572. name: dealPay.name,
  573. minus: dealPay.minus ? true : false,
  574. is_yf: dealPay.is_yf ? true : false,
  575. };
  576. this.resultDealPay.push(rdp);
  577. }
  578. if (fun) fun(rdp, dealPay);
  579. }
  580. async _checkStagePayCalc(tender, stage, dealPay) {
  581. if (!stage.readOnly) {
  582. // 计算 本期金额
  583. const payCalculator = new PayCalculator(this.ctx, stage, tender.info);
  584. await payCalculator.calculateAll(dealPay);
  585. }
  586. }
  587. async _gatherStagePay(completeData, tender, stage, hasPre) {
  588. if (stage) {
  589. completeData.id = tender.id;
  590. completeData.name = tender.name;
  591. const helper = this.ctx.helper;
  592. await this.ctx.service.stage.doCheckStage(stage);
  593. const dealPay = await this.ctx.service.stagePay.getStagePays(stage);
  594. await this._checkStagePayCalc(tender, stage, dealPay);
  595. for (const dp of dealPay) {
  596. dp.end_tp = helper.add(dp.pre_tp, dp.tp);
  597. this._gatherPayRecord(dp, function (gatherData, sourceData) {
  598. gatherData[completeData.prefix + 'id'] = tender.id;
  599. gatherData[completeData.prefix + 'name'] = tender.name;
  600. gatherData[completeData.prefix + 'tp'] = helper.add(gatherData[completeData.prefix + 'tp'], sourceData.tp);
  601. gatherData[completeData.prefix + 'pre_tp'] = helper.add(gatherData[completeData.prefix + 'pre_tp'], sourceData.pre_tp);
  602. gatherData[completeData.prefix + 'end_tp'] = helper.add(gatherData[completeData.prefix + 'end_tp'], sourceData.end_tp);
  603. gatherData['s_' + 'tp'] = helper.add(gatherData['s_' + 'tp'], sourceData.tp);
  604. gatherData['s_' + 'pre_tp'] = helper.add(gatherData['s_' + 'pre_tp'], sourceData.pre_tp);
  605. gatherData['s_' + 'end_tp'] = helper.add(gatherData['s_' + 'end_tp'], sourceData.end_tp);
  606. });
  607. }
  608. }
  609. }
  610. async _gatherMonthStagePay(sTender, completeData, month, hasPre) {
  611. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  612. const stages = await this._getValidStages(tender.id);
  613. const stage = this.ctx.helper._.find(stages, {s_time: month});
  614. await this._gatherStagePay(completeData, tender, stage, hasPre);
  615. }
  616. async _gatherZoneStagePay(sTender, completeData, zone) {
  617. const helper = this.ctx.helper;
  618. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  619. completeData.id = tender.id;
  620. completeData.name = tender.name;
  621. const stages = await this._getValidStages(tender.id);
  622. const times = zone.split(' - ');
  623. if (times.length !== 2) throw '选择的汇总周期无效';
  624. const beginTime = moment(times[0], 'YYYY-MM');
  625. const endTime = moment(times[1], 'YYYY-MM');
  626. for (const stage of stages) {
  627. const sTime = moment(stage.s_time, 'YYYY-MM');
  628. if (sTime.isBetween(beginTime, endTime, null, '[]')) {
  629. await this.ctx.service.stage.doCheckStage(stage);
  630. const dealPay = await this.ctx.service.stagePay.getStagePays(stage);
  631. await this._checkStagePayCalc(tender, stage, dealPay);
  632. for (const dp of dealPay) {
  633. dp.end_tp = helper.add(dp.pre_tp, dp.tp);
  634. this._gatherPayRecord(dp, function (gatherData, sourceData) {
  635. gatherData[completeData.prefix + 'id'] = tender.id;
  636. gatherData[completeData.prefix + 'name'] = tender.name;
  637. gatherData[completeData.prefix + 'tp'] = helper.add(gatherData[completeData.prefix + 'tp'], sourceData.tp);
  638. gatherData['s_' + 'tp'] = helper.add(gatherData['s_' + 'tp'], sourceData.tp);
  639. });
  640. }
  641. }
  642. }
  643. }
  644. async _gatherFinalStagePay(sTender, completeData, hasPre) {
  645. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  646. const stages = await this._getValidStages(tender.id);
  647. await this._gatherStagePay(completeData, tender, stages[0], hasPre);
  648. }
  649. async _gatherCheckedFinalStagePay(sTender, completeData, hasPre) {
  650. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  651. const stages = await this._getCheckedStages(tender.id);
  652. await this._gatherStagePay(completeData, tender, stages[0], hasPre);
  653. }
  654. async getGatherStagePay(memFieldKeys, gsDefine, gsCustom) {
  655. if (!gsDefine || !gsDefine.enable) return [];
  656. if (!gsCustom || !gsCustom.tenders || gsCustom.tenders.length === 0) return [];
  657. this.resultTenderInfo = [];
  658. const gsSetting = JSON.parse(gsDefine.setting);
  659. let commonIndex = 0;
  660. const completeDatas = [];
  661. for (const tender of gsCustom.tenders) {
  662. const specialKey = this._checkSpecialTender(tender, gsSetting.special);
  663. if (specialKey === '') {
  664. const completeData = {
  665. prefix: 't_' + commonIndex + '_',
  666. };
  667. completeDatas.push(completeData);
  668. switch (gsSetting.type) {
  669. case 'month':
  670. await this._gatherMonthStagePay(tender, completeData, gsCustom.month, gsSetting.hasPre);
  671. break;
  672. case 'zone':
  673. await this._gatherZoneStagePay(tender, completeData, gsCustom.zone);
  674. break;
  675. case 'final':
  676. await this._gatherFinalStagePay(tender, completeData, gsSetting.hasPre);
  677. break;
  678. case 'checked-final':
  679. await this._gatherCheckedFinalStagePay(tender, completeData, gsSetting.hasPre);
  680. break;
  681. }
  682. commonIndex++;
  683. }
  684. // 合同支付,只有在每一期中有数据,故特殊标段直接不汇总合同支付
  685. }
  686. gatherUtils.completeGatherData(this.resultDealPay, completeDatas);
  687. return this.resultDealPay;
  688. }
  689. /**
  690. * 签约清单
  691. */
  692. async _gatherDealBills(tender, fun) {
  693. const dealBills = await this.ctx.service.dealBills.getAllDataByCondition({
  694. where: { tender_id: tender.id }
  695. });
  696. for (const db of dealBills) {
  697. let rdb = this.ctx.helper._.find(this.resultDealBills, {
  698. code: db.code,
  699. name: db.name,
  700. unit: db.unit,
  701. unit_price: db.unit_price ? db.unit_price: 0,
  702. });
  703. if (!rdb) {
  704. rdb = {
  705. code: db.code,
  706. name: db.name,
  707. unit: db.unit,
  708. unit_price: db.unit_price ? db.unit_price: 0,
  709. };
  710. this.resultDealBills.push(rdb);
  711. }
  712. if (fun) fun(rdb, db);
  713. }
  714. }
  715. async _gatherCommonDealBills(sTender, completeData) {
  716. const self = this;
  717. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  718. completeData.id = tender.id;
  719. completeData.name = tender.name;
  720. await this._gatherDealBills(tender, function (gatherData, sourceData) {
  721. gatherData[completeData.prefix + 'id'] = tender.id;
  722. gatherData[completeData.prefix + 'name'] = tender.name;
  723. gatherData[completeData.prefix + 'qty'] = sourceData.quantity;
  724. gatherData[completeData.prefix + 'tp'] = sourceData.total_price;
  725. gatherData['s_' + 'qty'] = self.ctx.helper.add(gatherData['s_' + 'qty'], sourceData.quantity);
  726. gatherData['s_' + 'tp'] = self.ctx.helper.add(gatherData['s_' + 'tp'], sourceData.total_price);
  727. });
  728. }
  729. async _gatherSpecialDealBills(sTender, sKey) {
  730. const tender = await this.ctx.service.tender.getCheckTender(sTender.tid);
  731. await this._gatherDealBills(tender, function (gatherData, sourceData) {
  732. const prefix = 'ts_' + sKey + '_';
  733. gatherData[prefix + 'qty'] = sourceData.quantity;
  734. gatherData[prefix + 'tp'] = sourceData.total_price;
  735. });
  736. }
  737. async getGatherDealBills(memFieldKeys, gsDefine, gsCustom) {
  738. if (!gsDefine || !gsDefine.enable) return [];
  739. if (!gsCustom || !gsCustom.tenders || gsCustom.tenders.length === 0) return [];
  740. this.resultTenderInfo = [];
  741. const gsSetting = JSON.parse(gsDefine.setting);
  742. let commonIndex = 0;
  743. const completeDatas = [];
  744. for (const tender of gsCustom.tenders) {
  745. const specialKey = this._checkSpecialTender(tender, gsSetting.special);
  746. if (specialKey === '') {
  747. const completeData = {
  748. prefix: 't_' + commonIndex + '_',
  749. };
  750. completeDatas.push(completeData);
  751. await this._gatherCommonDealBills(tender, completeData);
  752. commonIndex++;
  753. } else {
  754. await this._gatherSpecialDealBills(tender, specialKey);
  755. }
  756. }
  757. gatherUtils.completeGatherData(this.resultDealBills, completeDatas);
  758. return this.resultDealBills;
  759. }
  760. }
  761. return RptGatherMemory;
  762. };