rpt_gather_memory.js 61 KB

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