sum_load.js 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447
  1. 'use strict';
  2. /**
  3. *
  4. *
  5. * @author Mai
  6. * @date
  7. * @version
  8. */
  9. const Ledger = require('../lib/ledger');
  10. class loadGclBaseTree {
  11. /**
  12. * 构造函数
  13. * @param {Array} tempData - 清单模板数据
  14. */
  15. constructor (ctx, setting) {
  16. this.ctx = ctx;
  17. this.parent = setting.parent;
  18. this.defaultData = setting.defaultData;
  19. // 常量
  20. this.splitChar = '-';
  21. // 索引
  22. // 以code为索引
  23. this.items = [];
  24. // 缓存
  25. this.keyNodeId = setting.maxId ? setting.maxId + 1 : 1;
  26. }
  27. /**
  28. * 根据 编号 查找 父项项目节
  29. * @param {String} code - 子项编号
  30. * @returns {*}
  31. */
  32. findNode(node, parent, check) {
  33. parent = parent || this.parent;
  34. if (!parent.children) return null;
  35. for (const child of parent.children) {
  36. const checkLeaf = (child.is_leaf && node.is_leaf) || (!child.is_leaf && !node.is_leaf);
  37. if (child.b_code === node.b_code && child.name === node.name && child.unit === node.unit
  38. && checkLeaf && (!check || check(child, node))) {
  39. return child;
  40. }
  41. }
  42. return null;
  43. }
  44. /**
  45. * 添加 树节点 并完善该节点的树结构
  46. * @param {Object} node - 添加节点
  47. * @param {Object} parent - 父项
  48. * @returns {*}
  49. */
  50. addNode(source, parent, check) {
  51. parent = parent ? parent : this.parent;
  52. let node = this.findNode(source, parent, check);
  53. if (!node) {
  54. if (!parent.children) parent.children = [];
  55. node = {
  56. id: this.ctx.app.uuid.v4(),
  57. tender_id: this.ctx.tender.id,
  58. ledger_id: this.keyNodeId,
  59. ledger_pid: parent.ledger_id,
  60. level: parent.level +1,
  61. full_path: parent.full_path + '-' + this.keyNodeId,
  62. order: parent.children.length + 1,
  63. children: [],
  64. b_code: source.b_code,
  65. name: source.name,
  66. unit: source.unit,
  67. sgfh_qty: 0,
  68. qtcl_qty: 0,
  69. sjcl_qyt: 0,
  70. quantity: 0,
  71. is_leaf: source.is_leaf,
  72. };
  73. this.keyNodeId += 1;
  74. parent.children.push(node);
  75. this.items.push(node);
  76. }
  77. return node;
  78. }
  79. gather(source, parent) {}
  80. getUpdateData() {}
  81. recursiveCalculate(dealBills, node) {
  82. if (node.children && node.children.length > 0) {
  83. for (const child of node.children) {
  84. this.recursiveCalculate(dealBills, child);
  85. }
  86. } else {
  87. const p = this.ctx.helper.findPrecision(this.ctx.tender.info.precision, node.unit);
  88. node.sgfh_qty = this.ctx.helper.round(node.sgfh_qty, p.value);
  89. node.sjcl_qty = this.ctx.helper.round(node.sjcl_qty, p.value);
  90. node.qtcl_qty = this.ctx.helper.round(node.qtcl_qty, p.value);
  91. node.quantity = this.ctx.helper.round(node.quantity, p.value);
  92. if (!node.unit_price) {
  93. const db = dealBills.find(x => { return x.b_code === node.b_code && x.name === node.name && x.unit === node.unit });
  94. if (!db) return;
  95. node.unit_price = db.unit_price;
  96. }
  97. node.sgfh_tp = this.ctx.helper.mul(node.sgfh_qty, node.unit_price, this.ctx.tender.info.decimal.tp);
  98. node.sjcl_tp = this.ctx.helper.mul(node.sjcl_qty, node.unit_price, this.ctx.tender.info.decimal.tp);
  99. node.qtcl_tp = this.ctx.helper.mul(node.qtcl_qty, node.unit_price, this.ctx.tender.info.decimal.tp);
  100. node.total_price = this.ctx.helper.mul(node.quantity, node.unit_price, this.ctx.tender.info.decimal.tp);
  101. }
  102. }
  103. calculateAll(dealBills) {
  104. this.recursiveCalculate(dealBills, this.parent);
  105. }
  106. }
  107. class loadLedgerGclTree extends loadGclBaseTree {
  108. gather(source, parent) {
  109. const node = this.addNode(source, parent);
  110. node.sgfh_qty = this.ctx.helper.add(node.sgfh_qty, source.sgfh_qty);
  111. node.qtcl_qty = this.ctx.helper.add(node.qtcl_qty, source.qtcl_qty);
  112. node.sjcl_qty = this.ctx.helper.add(node.sjcl_qty, source.sjcl_qty);
  113. node.quantity = this.ctx.helper.add(node.quantity, source.quantity);
  114. return node;
  115. }
  116. getUpdateData() {
  117. const update = [];
  118. if (this.items.length > 0) update.push({id: this.parent.id, ledger_id: this.parent.ledger_id, is_leaf: 0});
  119. const create = [];
  120. for (const i of this.items) {
  121. create.push({
  122. id: i.id, tender_id: i.tender_id, ledger_id: i.ledger_id, ledger_pid: i.ledger_pid,
  123. level: i.level, order: i.order, full_path: i.full_path, is_leaf: !i.children || i.children.length === 0,
  124. b_code: i.b_code, name: i.name, unit: i.unit,
  125. sgfh_qty: i.sgfh_qty, sjcl_qty: i.sjcl_qty, qtcl_qty: i.qtcl_qty, quantity: i.quantity,
  126. })
  127. }
  128. return {update, create};
  129. }
  130. }
  131. class updateReviseGclTree extends loadGclBaseTree {
  132. constructor (ctx, setting) {
  133. super(ctx, setting);
  134. this.baseNodes = [];
  135. this.errors = [];
  136. }
  137. loadBase(datas) {
  138. datas.sort((x, y) => { return x.level === y.level ? x.order - y.order : x.level - y.level; });
  139. const Index = {};
  140. for (const d of datas) {
  141. const parent = this.parent.ledger_id === d.ledger_pid ? this.parent : Index[d.ledger_pid];
  142. if (!parent) continue;
  143. if (!parent.children) parent.children = [];
  144. const baseNode = {
  145. id: d.id,
  146. ledger_id: d.ledger_id,
  147. ledger_pid: d.ledger_pid,
  148. level: d.level,
  149. is_leaf: d.is_leaf,
  150. full_path: d.full_path,
  151. b_code: d.b_code,
  152. name: d.name,
  153. unit: d.unit,
  154. unit_price: d.unit_price,
  155. org_sgfh_qty: d.sgfh_qty || 0,
  156. org_sjcl_qty: d.sjcl_qty || 0,
  157. org_qtcl_qty: d.qtcl_qty || 0,
  158. org_qty: d.quantity || 0,
  159. org_order: d.order,
  160. sgfh_qty: 0,
  161. sjcl_qty: 0,
  162. qtcl_qty: 0,
  163. quantity: 0,
  164. };
  165. parent.children.push(baseNode);
  166. Index[baseNode.ledger_id] = baseNode;
  167. this.baseNodes.push(baseNode);
  168. }
  169. }
  170. gather(source, parent) {
  171. const node = this.addNode(source, parent);
  172. node.sgfh_qty = this.ctx.helper.add(node.sgfh_qty, source.sgfh_qty);
  173. node.qtcl_qty = this.ctx.helper.add(node.qtcl_qty, source.qtcl_qty);
  174. node.sjcl_qty = this.ctx.helper.add(node.sjcl_qty, source.sjcl_qty);
  175. node.quantity = this.ctx.helper.add(node.quantity, source.quantity);
  176. return node;
  177. }
  178. getUpdateData() {
  179. const result = {update: [], errors: [], create: []};
  180. if (this.baseNodes.length === 0) {
  181. if (this.items.length > 0) result.update.push({id: this.parent.id, ledger_id: this.parent.ledger_id, is_leaf: 0});
  182. } else {
  183. for (const bn of this.baseNodes) {
  184. if (bn.children && bn.children.length > 0) continue;
  185. if (bn.sjcl_qty < bn.org_sjcl_qty || bn.qtcl_qty < bn.org_qtcl_qty || bn.sgfh_qty < bn.org_sgfh_qty) {
  186. result.errors.push({
  187. ledger_id: bn.ledger_id,
  188. b_code: bn.b_code, name: bn.name, unit: bn.unit,
  189. sgfh_qty: bn.sgfh_qty, sjcl_qty: bn.sjcl_qty, qtcl_qty: bn.qtcl_qty, qty: bn.quantity, type: 'less',
  190. });
  191. } else if (bn.sjcl_qty !== bn.org_sjcl_qty || bn.qtcl_qty !== bn.org_qtcl_qty || bn.sgfh_qty !== bn.org_sgfh_qty) {
  192. result.update.push({
  193. id: bn.id, ledger_id: bn.ledger_id, sgfh_qty: bn.sgfh_qty, sjcl_qty: bn.sjcl_qty, qtcl_qty: bn.qtcl_qty, quantity: bn.quantity
  194. })
  195. }
  196. }
  197. }
  198. for (const i of this.items) {
  199. result.create.push({
  200. id: i.id, tender_id: i.tender_id, ledger_id: i.ledger_id, ledger_pid: i.ledger_pid,
  201. level: i.level, order: i.order, full_path: i.full_path, is_leaf: !i.children || i.children.length === 0,
  202. b_code: i.b_code, name: i.name, unit: i.unit,
  203. sgfh_qty: i.sgfh_qty, sjcl_qty: i.sjcl_qty, qtcl_qty: i.qtcl_qty, quantity: i.quantity,
  204. })
  205. }
  206. return result;
  207. }
  208. }
  209. class gatherStageGclTree extends loadGclBaseTree {
  210. constructor (ctx, setting) {
  211. super(ctx, setting);
  212. this.baseNodes = [];
  213. }
  214. loadBase(datas) {
  215. datas.sort((x, y) => { return x.level === y.level ? x.order - y.order : x.level - y.level; });
  216. const Index = {};
  217. for (const d of datas) {
  218. const parent = this.parent.ledger_id === d.ledger_pid ? this.parent : Index[d.ledger_pid];
  219. if (!parent) continue;
  220. if (!parent.children) parent.children = [];
  221. const baseNode = {
  222. id: d.id,
  223. ledger_id: d.ledger_id,
  224. ledger_pid: d.ledger_pid,
  225. level: d.level,
  226. is_leaf: d.is_leaf,
  227. full_path: d.full_path,
  228. b_code: d.b_code,
  229. name: d.name,
  230. unit: d.unit,
  231. unit_price: d.unit_price,
  232. org_contract_qty: d.contract_qty || 0,
  233. org_contract_tp: d.contract_tp || 0,
  234. org_order: d.order,
  235. contract_qty: 0,
  236. contract_tp: 0,
  237. is_tp: d.is_tp,
  238. };
  239. parent.children.push(baseNode);
  240. Index[baseNode.ledger_id] = baseNode;
  241. this.baseNodes.push(baseNode);
  242. }
  243. }
  244. _gatherChange(node, source) {
  245. if (!source.change_detail || source.change_detail.length === 0) return;
  246. if (!node.change_detail) node.change_detail = [];
  247. for (const cd of source.change_detail) {
  248. if (!cd.qty) continue;
  249. let ncd = node.change_detail.find(x => { return x.cid === cd.cid; });
  250. if (!ncd) {
  251. ncd = { cid: cd.cid, c_code: cd.c_code };
  252. node.change_detail.push(ncd);
  253. }
  254. ncd.qty = this.ctx.helper.add(ncd.qty, cd.qty);
  255. }
  256. }
  257. gather(source, parent) {
  258. parent = parent ? parent : this.parent;
  259. const node = this.addNode(source, parent, function (node, source) {
  260. return (source.is_tp && node.is_tp) || (!source.is_tp && !node.is_tp);
  261. });
  262. if (node.is_tp) {
  263. node.contract_tp = this.ctx.helper.add(node.contract_tp, source.contract_tp);
  264. } else {
  265. node.contract_qty = this.ctx.helper.add(node.contract_qty, source.contract_qty);
  266. node.contract_tp = this.ctx.helper.mul(node.unit_price, node.contract_qty, this.ctx.tender.info.decimal.tp);
  267. }
  268. this._gatherChange(node, source);
  269. return node;
  270. }
  271. getUpdateData() {
  272. const result = {update: [], errors: []};
  273. for (const bn of this.baseNodes) {
  274. if (bn.contract_qty !== bn.org_contract_qty || bn.contract_tp !== bn.org_contract_tp) {
  275. result.update.push({lid: bn.id, contract_qty: bn.contract_qty, contract_tp: bn.contract_tp });
  276. }
  277. if (bn.change_detail && bn.change_detail.length > 0) {
  278. for (const cd of bn.change_detail) {
  279. result.errors.push({
  280. ledger_id: bn.ledger_id,
  281. b_code: bn.b_code, name: bn.name, unit: bn.unit,
  282. c_code: cd.c_code, qty: cd.qty, type: 'qc',
  283. });
  284. }
  285. }
  286. }
  287. for (const i of this.items) {
  288. result.errors.push({ b_code: i.b_code, name: i.name, unit: i.unit, qty: i.contract_qty, type: 'miss' });
  289. if (i.change_detail && i.change_detail.length > 0) {
  290. for (const cd of i.change_detail) {
  291. result.errors.push({
  292. b_code: i.b_code, name: i.name, unit: i.unit,
  293. c_code: cd.c_code, qty: cd.qty, type: 'miss-qc',
  294. });
  295. }
  296. }
  297. }
  298. return result;
  299. }
  300. }
  301. class sumLoad {
  302. constructor (ctx) {
  303. this.ctx = ctx;
  304. }
  305. recusiveLoadGatherGcl(node, parent) {
  306. const cur = node.b_code ? this.loadTree.gather(node, parent) : parent;
  307. if (!node.children || node.children.length === 0) return;
  308. for (const child of node.children) {
  309. this.recusiveLoadGatherGcl(child, cur);
  310. }
  311. }
  312. async loadGatherGcl(select, maxId, tenders, defaultData) {
  313. this.loadTree = new loadLedgerGclTree(this.ctx, {
  314. parent: select, maxId, type: 'ledger', defaultData,
  315. });
  316. for (const tender of tenders) {
  317. const billsData = await this.ctx.service.ledger.getData(tender.tid);
  318. const billsTree = new Ledger.billsTree(this.ctx, {
  319. id: 'ledger_id',
  320. pid: 'ledger_pid',
  321. order: 'order',
  322. level: 'level',
  323. rootId: -1,
  324. keys: ['id', 'tender_id', 'ledger_id'],
  325. stageId: 'id',
  326. });
  327. billsTree.loadDatas(billsData);
  328. for (const top of billsTree.children) {
  329. if ([1].indexOf(top.node_type) < 0) continue;
  330. this.recusiveLoadGatherGcl(top, null);
  331. }
  332. }
  333. const dealBills = await this.ctx.service.dealBills.getAllDataByCondition({ tid: this.ctx.tender.id });
  334. this.loadTree.calculateAll(dealBills);
  335. return this.loadTree;
  336. }
  337. async updateGatherGcl(select, maxId, tenders, defaultData) {
  338. this.loadTree = new updateReviseGclTree(this.ctx, {
  339. parent: select, maxId, type: 'ledger', defaultData,
  340. });
  341. const posterity = await this.ctx.service.reviseBills.getPosterityByParentId(this.ctx.tender.id, select.ledger_id);
  342. this.loadTree.loadBase(posterity);
  343. for (const tender of tenders) {
  344. const billsData = await this.ctx.service.ledger.getData(tender.tid);
  345. const billsTree = new Ledger.billsTree(this.ctx, {
  346. id: 'ledger_id',
  347. pid: 'ledger_pid',
  348. order: 'order',
  349. level: 'level',
  350. rootId: -1,
  351. keys: ['id', 'tender_id', 'ledger_id'],
  352. stageId: 'id',
  353. });
  354. billsTree.loadDatas(billsData);
  355. for (const top of billsTree.children) {
  356. if ([1].indexOf(top.node_type) < 0) continue;
  357. this.recusiveLoadGatherGcl(top, null);
  358. }
  359. }
  360. const dealBills = await this.ctx.service.dealBills.getAllDataByCondition({ tid: this.ctx.tender.id });
  361. this.loadTree.calculateAll(dealBills);
  362. return this.loadTree;
  363. }
  364. _loadCurStageAndChange(billsData, curStageBills, curStageChange) {
  365. const billsIndex = {};
  366. for (const b of billsData) {
  367. billsIndex[b.id] = b;
  368. }
  369. for (const csb of curStageBills) {
  370. const b = billsIndex[csb.lid];
  371. if (!b) continue;
  372. b.contract_qty = csb.contract_qty;
  373. b.contract_tp = csb.contract_tp;
  374. }
  375. for (const csc of curStageChange) {
  376. if (!csc.qty) continue;
  377. const b = billsIndex[csc.lid];
  378. if (!b) continue;
  379. if (!b.change_detail) b.change_detail = [];
  380. let c = b.change_detail.find(x => { return x.cid === csc.cid });
  381. if (!c) {
  382. c = { cid: csc.cid };
  383. b.change_detail.push(c);
  384. }
  385. c.qty = this.ctx.helper.add(c.qty, csc.qty);
  386. }
  387. }
  388. async stageGatherGcl(select, maxId, tenders, defaultData) {
  389. this.loadTree = new gatherStageGclTree(this.ctx, {
  390. parent: select, maxId, type: 'ledger', defaultData,
  391. });
  392. const posterity = await this.ctx.service.ledger.getPosterityByParentId(this.ctx.tender.id, select.ledger_id);
  393. this.loadTree.loadBase(posterity);
  394. for (const tender of tenders) {
  395. if (!tender.stage) continue;
  396. const billsData = await this.ctx.service.ledger.getData(tender.tid);
  397. const stage = await this.ctx.service.stage.getDataByCondition({tid: tender.tid, order: tender.stage});
  398. if (!stage) throw '选择的期不存在';
  399. const curStageData = await this.ctx.service.stageBills.getLastestStageData(tender.tid, stage.id);
  400. const curStageChange = await this.ctx.service.stageChangeFinal.getSumLoadFinalData(stage.id);
  401. this._loadCurStageAndChange(billsData, curStageData, curStageChange);
  402. const billsTree = new Ledger.billsTree(this.ctx, {
  403. id: 'ledger_id',
  404. pid: 'ledger_pid',
  405. order: 'order',
  406. level: 'level',
  407. rootId: -1,
  408. keys: ['id', 'tender_id', 'ledger_id'],
  409. stageId: 'id',
  410. });
  411. billsTree.loadDatas(billsData);
  412. for (const top of billsTree.children) {
  413. if ([1].indexOf(top.node_type) < 0) continue;
  414. this.recusiveLoadGatherGcl(top, null);
  415. }
  416. }
  417. return this.loadTree;
  418. }
  419. }
  420. module.exports = sumLoad;