bills_pos_convert.js 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410
  1. 'use strict';
  2. /**
  3. *
  4. *
  5. * @author Mai
  6. * @date
  7. * @version
  8. */
  9. const Ledger = require('./ledger');
  10. const splitChar = '-';
  11. const mergeChar = ';';
  12. class BillsPosConvert {
  13. constructor(ctx) {
  14. const self = this;
  15. this.ctx = ctx;
  16. this._ = this.ctx.helper._;
  17. this.tpFields = ['total_price', 'contract_tp', 'qc_tp', 'gather_tp',
  18. 'pre_contract_tp', 'pre_qc_tp', 'pre_gather_tp', 'end_contract_tp', 'end_qc_tp'];
  19. this.baseCalcFields = ['quantity', 'contract_qty', 'qc_qty', 'gather_qty',
  20. 'pre_contract_qty', 'pre_qc_qty', 'pre_gather_qty', 'end_contract_qty', 'end_qc_qty', 'end_gather_qty'];
  21. // mainData
  22. this.bpcTree = new Ledger.billsTree(this.ctx, {
  23. id: 'ledger_id',
  24. pid: 'ledger_pid',
  25. order: 'order',
  26. level: 'level',
  27. rootId: -1,
  28. keys: ['id', 'tender_id', 'ledger_id'],
  29. stageId: 'id',
  30. updateFields: ['contract_qty', 'contract_tp', 'qc_qty', 'qc_tp'],
  31. calcFields: [],
  32. });
  33. this.bpcPos = new Ledger.pos({
  34. id: 'id', ledgerId: 'lid',
  35. updateFields: ['contract_qty', 'qc_qty'],
  36. });
  37. this.bpcChange = [];
  38. // reusltData
  39. this.resultTreeSetting = {
  40. id: 'ledger_id',
  41. pid: 'ledger_pid',
  42. order: 'order',
  43. level: 'level',
  44. rootId: -1,
  45. fullPath: 'full_path',
  46. };
  47. this.resultTree = new Ledger.filterTree(this.ctx, this.resultTreeSetting);
  48. }
  49. // 加载基础数据
  50. _loadLedgerData (ledger) {
  51. const self = this;
  52. // 加载树结构数据
  53. this.bpcTree.loadDatas(ledger);
  54. }
  55. _loadPosData(pos) {
  56. this.bpcPos.loadDatas(pos);
  57. }
  58. loadData (ledger, pos, change) {
  59. this._loadLedgerData(ledger);
  60. this._loadPosData(pos);
  61. this.bpcChange = change;
  62. }
  63. _convertXmj(data) {
  64. const xmj = this.resultTree.addData(data, ['ledger_id', 'ledger_pid', 'order', 'level', 'tender_id', 'full_path',
  65. 'code', 'name', 'unit', 'dgn_qty1', 'dgn_qty2', 'drawing_code', 'postil', 'memo', 'gxby_status', 'dagl_status', 'gxby_url', 'dagl_url',
  66. 'ex_memo1', 'ex_memo2', 'ex_memo3']);
  67. return xmj;
  68. }
  69. // v1
  70. _loadField(node, data, fields) {
  71. for (const prop in data) {
  72. if (fields.indexOf(prop) >= 0) node[prop] = data[prop];
  73. }
  74. }
  75. // v2
  76. _loadPosCalcFields(node, data) {
  77. const tpDecimal = this.ctx.tender.info.decimal.tp;
  78. node.quantity = this.ctx.helper.add(node.quantity, data.quantity);
  79. node.total_price = this.ctx.helper.add(node.total_price, this.ctx.helper.mul(node.unit_price, data.quantity, tpDecimal));
  80. node.contract_qty = this.ctx.helper.add(node.contract_qty, data.contract_qty);
  81. node.contract_tp = this.ctx.helper.add(node.contract_tp, this.ctx.helper.mul(node.unit_price, data.contract_qty, tpDecimal));
  82. node.qc_qty = this.ctx.helper.add(node.qc_qty, data.qc_qty);
  83. node.qc_tp = this.ctx.helper.add(node.qc_tp, this.ctx.helper.mul(node.unit_price, data.qc_qty, tpDecimal));
  84. node.gather_qty = this.ctx.helper.add(node.gather_qty, data.gather_qty);
  85. node.pre_contract_qty = this.ctx.helper.add(node.pre_contract_qty, data.pre_contract_qty);
  86. node.pre_contract_tp = this.ctx.helper.add(node.pre_contract_tp, this.ctx.helper.mul(node.unit_price, data.pre_contract_qty, tpDecimal));
  87. node.pre_qc_qty = this.ctx.helper.add(node.pre_qc_qty, data.pre_qc_qty);
  88. node.pre_qc_tp = this.ctx.helper.add(node.pre_qc_tp, this.ctx.helper.mul(node.unit_price, data.pre_qc_qty, tpDecimal));
  89. node.pre_gather_qty = this.ctx.helper.add(node.pre_gather_qty, data.pre_gather_qty);
  90. node.real_qty = this.ctx.helper.add(node.real_qty, data.real_qty);
  91. node.minus_qc_qty = this.ctx.helper.add(node.minus_qc_qty, data.minus_qc_qty);
  92. node.pre_minus_qc_qty = this.ctx.helper.add(node.pre_minus_qc_qty, data.pre_minus_qc_qty);
  93. }
  94. _loadBillsCalcFields(node, data) {
  95. node.quantity = this.ctx.helper.add(node.quantity, data.quantity);
  96. node.total_price = this.ctx.helper.add(node.total_price, data.total_price);
  97. node.contract_qty = this.ctx.helper.add(node.contract_qty, data.contract_qty);
  98. node.contract_tp = this.ctx.helper.add(node.contract_tp, data.contract_tp);
  99. node.qc_qty = this.ctx.helper.add(node.qc_qty, data.qc_qty);
  100. node.qc_tp = this.ctx.helper.add(node.qc_tp, data.qc_tp);
  101. node.gather_qty = this.ctx.helper.add(node.gather_qty, data.gather_qty);
  102. node.pre_contract_qty = this.ctx.helper.add(node.pre_contract_qty, data.pre_contract_qty);
  103. node.pre_contract_tp = this.ctx.helper.add(node.pre_contract_tp, data.pre_contract_tp);
  104. node.pre_qc_qty = this.ctx.helper.add(node.pre_qc_qty, data.pre_qc_qty);
  105. node.pre_qc_tp = this.ctx.helper.add(node.pre_qc_tp, data.pre_qc_tp);
  106. node.pre_gather_qty = this.ctx.helper.add(node.pre_gather_qty, data.pre_gather_qty);
  107. node.minus_qc_qty = this.ctx.helper.add(node.minus_qc_qty, data.minus_qc_qty);
  108. node.pre_minus_qc_qty = this.ctx.helper.add(node.pre_minus_qc_qty, data.pre_minus_qc_qty);
  109. }
  110. _convertGcl(node, xmj) {
  111. if (!xmj) return;
  112. if (!xmj.unitTree) {
  113. xmj.unitTree = new Ledger.filterGatherTree(this.ctx, this.resultTreeSetting);
  114. }
  115. const pos = this.bpcPos.getLedgerPos(node.id);
  116. if (pos && pos.length > 0) {
  117. for (const p of pos) {
  118. const posUnit = xmj.unitTree.addNode({pos_name: p.name,
  119. b_code: null, name: '', unit: null, unit_price: null,
  120. gxby_status: p.gxby_status, dagl_status: p.dagl_status, gxby_url: p.gxby_url, dagl_url: p.dagl_url});
  121. if (p.drawing_code && posUnit.drawing_code.indexOf(p.drawing_code) < 0)
  122. posUnit.drawing_code.push(p.drawing_code);
  123. if (p.memo) posUnit.memo.push(p.memo);
  124. if (p.postil) posUnit.postil.push(p.postil);
  125. if (p.ex_memo1) posUnit.ex_memo1.push(p.ex_memo1);
  126. if (p.ex_memo2) posUnit.ex_memo2.push(p.ex_memo2);
  127. if (p.ex_memo3) posUnit.ex_memo3.push(p.ex_memo3);
  128. const gclUnit = xmj.unitTree.addNode({pos_name: '',
  129. b_code: node.b_code, name: node.name, unit: node.unit, unit_price: node.unit_price
  130. }, posUnit);
  131. if (node.drawing_code && gclUnit.drawing_code.indexOf(node.drawing_code) < 0)
  132. gclUnit.drawing_code.push(node.drawing_code);
  133. if (node.memo) gclUnit.memo.push(node.memo);
  134. if (node.postil) gclUnit.postil.push(node.postil);
  135. if (node.ex_memo1) gclUnit.ex_memo1.push(node.ex_memo1);
  136. if (node.ex_memo2) gclUnit.ex_memo2.push(node.ex_memo2);
  137. if (node.ex_memo3) gclUnit.ex_memo3.push(node.ex_memo3);
  138. //loadField(gclUnit, p, baseCalcFields);
  139. this._loadPosCalcFields(gclUnit, p);
  140. if (!gclUnit.changes) gclUnit.changes = [];
  141. for (const c of this.bpcChange) {
  142. if (c.lid === node.id && c.pid === p.id && c.qty && c.qty !== 0) {
  143. gclUnit.changes.push(c);
  144. }
  145. }
  146. }
  147. } else {
  148. const unit = xmj.unitTree.addNode({
  149. pos_name: '',
  150. b_code: node.b_code, name: node.name, unit: node.unit, unit_price: node.unit_price,
  151. });
  152. if (node.drawing_code && unit.drawing_code.indexOf(node.drawing_code) < 0)
  153. unit.drawing_code.push(node.drawing_code);
  154. if (node.memo) unit.memo.push(node.memo);
  155. if (node.postil) unit.postil.push(node.postil);
  156. if (node.ex_memo1) unit.ex_memo1.push(node.ex_memo1);
  157. if (node.ex_memo2) unit.ex_memo2.push(node.ex_memo2);
  158. if (node.ex_memo3) unit.ex_memo3.push(node.ex_memo3);
  159. this._loadBillsCalcFields(unit, node);
  160. if (!unit.changes) unit.changes = [];
  161. for (const c of this.bpcChange) {
  162. if (c.lid === node.id && c.pid == -1 && c.qty && c.qty !== 0) {
  163. unit.changes.push(c);
  164. }
  165. }
  166. }
  167. }
  168. _recursiveConvertNode(nodes, xmj = null) {
  169. if (!nodes || !nodes instanceof Array || nodes.length === 0) return;
  170. for (const node of nodes) {
  171. if (node.b_code && node.b_code !== '') {
  172. if (!node.children || node.children.length === 0) {
  173. this._convertGcl(node, xmj);
  174. }
  175. this._recursiveConvertNode(node.children, xmj);
  176. } else {
  177. const curXmj = this._convertXmj(node);
  178. this._recursiveConvertNode(node.children, curXmj);
  179. if (!node.children || node.children.length === 0) {
  180. this._loadField(curXmj, node, this.tpFields);
  181. }
  182. }
  183. }
  184. }
  185. _calculateChild(child) {
  186. const tpDecimal = this.ctx.tender.info.decimal.tp;
  187. child.gather_qty = this.ctx.helper.add(child.contract_qty, child.qc_qty);
  188. child.pre_gather_qty = this.ctx.helper.add(child.pre_contract_qty, child.pre_qc_qty);
  189. child.end_contract_qty = this.ctx.helper.add(child.contract_qty, child.pre_contract_qty);
  190. child.end_qc_qty = this.ctx.helper.add(child.qc_qty, child.pre_qc_qty);
  191. child.end_gather_qty = this.ctx.helper.add(child.gather_qty, child.pre_gather_qty);
  192. child.estimate_qty = !this.ctx.helper.checkZero(child.real_qty)
  193. ? this.ctx.helper.sub(this.ctx.helper.sub(child.real_qty, child.quantity), child.end_qc_qty)
  194. : null;
  195. // v1
  196. // child.total_price = this.ctx.helper.mul(child.unit_price, child.quantity, tpDecimal);
  197. // child.contract_tp = this.ctx.helper.mul(child.unit_price, child.contract_qty, tpDecimal);
  198. // child.qc_tp = this.ctx.helper.mul(child.unit_price, child.qc_qty, tpDecimal);
  199. // child.gather_tp = this.ctx.helper.mul(child.unit_price, child.gather_qty, tpDecimal);
  200. // child.pre_contract_tp = this.ctx.helper.mul(child.unit_price, child.pre_contract_qty, tpDecimal);
  201. // child.pre_qc_tp = this.ctx.helper.mul(child.unit_price, child.pre_qc_qty, tpDecimal);
  202. // child.pre_gather_tp = this.ctx.helper.mul(child.unit_price, child.pre_gather_qty, tpDecimal);
  203. // child.end_contract_tp = this.ctx.helper.mul(child.unit_price, child.end_contract_qty, tpDecimal);
  204. // child.end_qc_tp = this.ctx.helper.mul(child.unit_price, child.end_qc_qty, tpDecimal);
  205. // child.end_gather_tp = this.ctx.helper.mul(child.unit_price, child.end_gather_qty, tpDecimal);
  206. // v2
  207. child.gather_tp = this.ctx.helper.add(child.contract_tp, child.qc_tp);
  208. child.pre_gather_tp = this.ctx.helper.add(child.pre_contract_tp, child.pre_qc_tp);
  209. child.end_contract_tp = this.ctx.helper.add(child.pre_contract_tp, child.contract_tp);
  210. child.end_qc_tp = this.ctx.helper.add(child.pre_qc_tp, child.qc_tp);
  211. child.end_gather_tp = this.ctx.helper.add(child.end_contract_tp, child.end_qc_tp);
  212. child.final_tp = this.ctx.helper.add(child.total_price, child.end_qc_tp);
  213. child.end_gather_percent = this.ctx.helper.mul(this.ctx.helper.div(child.end_gather_tp, child.final_tp, 4), 100);
  214. child.real_tp = this.ctx.helper.mul(child.real_qty, child.unit_price, tpDecimal);
  215. child.estimate_tp = this.ctx.helper.mul(child.estimate_qty, child.unit_price, tpDecimal);
  216. child.bgl_code = this.ctx.helper._.uniq(this.ctx.helper._.map(child.changes, 'c_code')).join(';');
  217. // 1#台账相关
  218. child.end_minus_qc_qty = this.ctx.helper.add(child.pre_minus_qc_qty, child.minus_qc_qty); // 1#台账 台账+负变更
  219. child.end_1_qty = this.ctx.helper.add(child.end_minus_qc_qty, child.quantity); // 1#台账 台账+负变更
  220. child.end_1_tp = this.ctx.helper.mul(child.unit_price, child.end_1_qty, tpDecimal);
  221. child.end_final_1_tp = this.ctx.helper.add(child.end_qc_tp, child.end_1_tp);
  222. child.end_gather_1_percent = this.ctx.helper.mul(this.ctx.helper.div(child.end_gather_tp, child.end_final_1_tp, 4), 100);
  223. }
  224. _calculateNode(node, children) {
  225. for (const child of children) {
  226. node.total_price = this.ctx.helper.add(node.total_price, child.total_price);
  227. node.contract_tp = this.ctx.helper.add(node.contract_tp, child.contract_tp);
  228. node.qc_tp = this.ctx.helper.add(node.qc_tp, child.qc_tp);
  229. node.gather_tp = this.ctx.helper.add(node.gather_tp, child.gather_tp);
  230. node.pre_contract_tp = this.ctx.helper.add(node.pre_contract_tp, child.pre_contract_tp);
  231. node.pre_qc_tp = this.ctx.helper.add(node.pre_qc_tp, child.pre_qc_tp);
  232. node.pre_gather_tp = this.ctx.helper.add(node.pre_gather_tp, child.pre_gather_tp);
  233. node.end_contract_tp = this.ctx.helper.add(node.end_contract_tp, child.end_contract_tp);
  234. node.end_qc_tp = this.ctx.helper.add(node.end_qc_tp, child.end_qc_tp);
  235. node.end_gather_tp = this.ctx.helper.add(node.end_gather_tp, child.end_gather_tp);
  236. node.real_tp = this.ctx.helper.add(node.real_tp, child.real_tp);
  237. node.estimate_tp = this.ctx.helper.add(node.estimate_tp, child.estimate_tp);
  238. node.end_1_tp = this.ctx.helper.add(node.end_1_tp, child.end_1_tp);
  239. }
  240. if (node.dgn_qty1)
  241. node.dgn_price = this.ctx.helper.div(node.total_price, node.dgn_qty1, this.ctx.tender.info.decimal.up);
  242. node.final_tp = this.ctx.helper.add(node.total_price, node.end_qc_tp);
  243. node.end_gather_percent = this.ctx.helper.mul(this.ctx.helper.div(node.end_gather_tp, node.final_tp, 4), 100);
  244. node.end_final_1_tp = this.ctx.helper.add(node.end_qc_tp, node.end_1_tp);
  245. node.end_gather_1_percent = this.ctx.helper.mul(this.ctx.helper.div(node.end_gather_tp, node.end_final_1_tp, 4), 100);
  246. }
  247. _recursiveCalcUnitNodes(nodes) {
  248. if (!nodes || !nodes instanceof Array || nodes.length === 0) return;
  249. for (const node of nodes) {
  250. this._recursiveCalcUnitNodes(node.children);
  251. if (node.children && node.children.length > 0) {
  252. this._calculateNode(node, node.children);
  253. } else {
  254. this._calculateChild(node);
  255. }
  256. if (node.drawing_code && node.drawing_code.length > 0)
  257. node.drawing_code_merge = node.drawing_code.join(mergeChar);
  258. if (node.memo && node.memo.length > 0)
  259. node.memo_merge = node.memo.join(mergeChar);
  260. if (node.ex_memo1 && node.ex_memo1.length > 0)
  261. node.ex_memo1_merge = node.ex_memo1.join(mergeChar);
  262. if (node.ex_memo2 && node.ex_memo2.length > 0)
  263. node.ex_memo2_merge = node.ex_memo2.join(mergeChar);
  264. if (node.ex_memo3 && node.ex_memo3.length > 0)
  265. node.ex_memo3_merge = node.ex_memo3.join(mergeChar);
  266. if (node.postil && node.postil.length > 0)
  267. node.postil_merge = node.postil.join(mergeChar);
  268. }
  269. }
  270. _recursiveCalculateAndSort(nodes) {
  271. const self = this;
  272. if (!nodes || !nodes instanceof Array || nodes.length === 0) return;
  273. for (const node of nodes) {
  274. this._recursiveCalculateAndSort(node.children);
  275. if (node.unitTree) {
  276. node.unitTree.sortTreeNodeCustom(function (a, b) {
  277. if (a.b_code && a.b_code !== '') {
  278. return b.b_code && b.b_code !== '' ? self.ctx.helper.compareCode(a.b_code, b.b_code) : 1;
  279. } else {
  280. return b.b_code && b.b_code !== '' ? -1 : a.order - b.order;
  281. }
  282. });
  283. this._recursiveCalcUnitNodes(node.unitTree.children);
  284. this._calculateNode(node, node.unitTree.children, this.tpFields);
  285. } else if (node.children && node.children.length > 0) {
  286. this._calculateNode(node, node.children, this.tpFields);
  287. } else {
  288. this._calculateChild(node);
  289. }
  290. }
  291. }
  292. _calculateAndSortResult() {
  293. this.resultTree.sortTreeNode();
  294. this._recursiveCalculateAndSort(this.resultTree.children);
  295. }
  296. _generateCodeByWbsCode(wbsCode) {
  297. let needUpdate = false;
  298. for (const node of this.resultTree.nodes) {
  299. if (!node.unitTree) continue;
  300. let xmj = wbsCode.find(function (x) {
  301. return x.xmj_code === node.code;
  302. });
  303. for (const unit of node.unitTree.nodes) {
  304. if (!unit.pos_name || unit.pos_name === '') continue;
  305. if (!xmj) {
  306. xmj = {xmj_code: node.code, pos: []};
  307. wbsCode.push(xmj);
  308. needUpdate = true;
  309. }
  310. let index = xmj.pos.indexOf(unit.pos_name);
  311. if (index < 0) {
  312. unit.code = xmj.xmj_code + splitChar + (xmj.pos.length + 1);
  313. xmj.pos.push(unit.pos_name);
  314. needUpdate = true;
  315. } else {
  316. unit.code = xmj.xmj_code + splitChar + (index + 1);
  317. }
  318. }
  319. }
  320. return needUpdate;
  321. }
  322. _getResultData(filterFun) {
  323. const result = this.resultTree.getDefaultDatas(filterFun);
  324. for (const r of result) {
  325. if (r.unitTree) {
  326. r.unitTreeData = r.unitTree.getDefaultDatas(filterFun);
  327. delete r.unitTree;
  328. }
  329. }
  330. return result;
  331. }
  332. // 转换数据
  333. convert(filter) {
  334. this._recursiveConvertNode(this.bpcTree.children);
  335. this._calculateAndSortResult();
  336. this._generateCodeByWbsCode([]);
  337. switch (filter) {
  338. case 'cur':
  339. return this._getResultData(function (node) {
  340. for (const field of ['contract_tp', 'qc_tp', 'gather_tp']) {
  341. if (node[field]) {
  342. return false;
  343. }
  344. }
  345. return true;
  346. });
  347. case 'end':
  348. return this._getResultData(function (node) {
  349. for (const field of ['end_contract_tp', 'end_qc_tp', 'end_gather_tp']) {
  350. if (node[field]) {
  351. return false;
  352. }
  353. }
  354. return true;
  355. });
  356. default:
  357. return this._getResultData();
  358. }
  359. }
  360. /**
  361. * 转换数据,会根据wbsCodeHis生成计量单元的code
  362. * 如果计量单元在wbsCodeHis中没有历史,则会更新传入的wbsCodeHis,并返回[result, true], 反之返回[result, false]
  363. * @param wbsCodeHis
  364. * @returns {*[]}
  365. */
  366. convertByWbsCode(wbsCodeHis) {
  367. this._recursiveConvertNode(this.bpcTree.children);
  368. this._calculateAndSortResult();
  369. const needUpdate = this._generateCodeByWbsCode(wbsCodeHis);
  370. return [this._getResultData(), needUpdate];
  371. }
  372. }
  373. module.exports = BillsPosConvert;