gcl_gather_compare.js 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506
  1. 'use strict';
  2. /**
  3. *
  4. * 清单汇总对比(需使用 decimal.min.js, zh_calc.js, path_tree.js, lodash.js)
  5. *
  6. * @author Mai
  7. * @date 2020/10/28
  8. * @version
  9. */
  10. const gclCompareModel = (function () {
  11. const leafXmjs = [], mergeChar = ';';
  12. let gclList, gclChapter, otherChapter, gclChapterFilter;
  13. let ledgerSetting, gsTree;
  14. function gatherfields(obj, src, fields, prefix = '') {
  15. if (obj && src) {
  16. for (const f of fields) {
  17. obj[prefix + f] = ZhCalc.add(obj[prefix + f], src[f]);
  18. }
  19. }
  20. }
  21. /**
  22. * 新建 清单汇总节点
  23. * @param node - 最底层 工程量清单节点
  24. * @returns {obj}
  25. */
  26. function newGclNode(node) {
  27. const gcl = {
  28. b_code: node.b_code,
  29. name: node.name,
  30. unit: node.unit,
  31. unit_price: node.unit_price,
  32. leafXmjs: [],
  33. };
  34. gclList.push(gcl);
  35. return gcl;
  36. }
  37. /**
  38. * 获取清单汇总节点
  39. *
  40. * @param node - 最底层清单节点
  41. * @returns {*}
  42. */
  43. function getGclNode(node) {
  44. const gcl = gclList.find(function (g) {
  45. return g.b_code === node.b_code &&
  46. (g.name || node.name ? g.name === node.name : true) &&
  47. (g.unit || node.unit ? g.unit === node.unit : true) &&
  48. checkZero(ZhCalc.sub(g.unit_price, node.unit_price));
  49. });
  50. if (gcl) {
  51. return gcl
  52. } else {
  53. return newGclNode(node);
  54. }
  55. }
  56. /**
  57. * 检查 text 是否是Peg
  58. * e.g. K123+000(true) Kab+123(false) K123.234+234(false) K12+324.234(true)
  59. *
  60. * @param text
  61. * @returns {*}
  62. * @constructor
  63. */
  64. function CheckPeg(text) {
  65. const pegReg = /[a-zA-Z]*[kK][0-9]+[++][0-9]{3}([.][0-9]+)?/;
  66. return pegReg.test(text);
  67. }
  68. /**
  69. * 获取 桩号节点
  70. * @param node - 检索起始节点
  71. * @returns {*}
  72. */
  73. function getPegNode (node) {
  74. if (node) {
  75. if (CheckPeg(node.name)) {
  76. return node;
  77. } else {
  78. const parent = gsTree.getParent(node);
  79. return parent ? getPegNode(parent) : null;
  80. }
  81. }
  82. }
  83. /**
  84. * 获取节点的第N层父节点
  85. *
  86. * @param node - 节点(检索起点)
  87. * @param level - 第N层
  88. * @returns {*}
  89. */
  90. function getNodeByLevel(node, level) {
  91. let cur = node;
  92. while (cur && cur.level > level) {
  93. cur = gsTree.getParent(cur);
  94. }
  95. return cur;
  96. }
  97. /**
  98. * 获取 单位工程
  99. *
  100. * @param xmj - 计量单元(最底层项目节)
  101. * @returns {string}
  102. */
  103. function getDwgc(peg, xmj) {
  104. if (peg) {
  105. return peg.name;
  106. } else {
  107. const node = getNodeByLevel(xmj, 2);
  108. return node ? node.name : '';
  109. }
  110. }
  111. /**
  112. * 获取 分部工程
  113. *
  114. * @param peg - 桩号节点
  115. * @param xmj - 计量单元(最底层项目节)
  116. * @returns {string}
  117. */
  118. function getFbgc(peg, xmj) {
  119. if (peg && peg.id !== xmj.id) {
  120. const node = getNodeByLevel(xmj, peg.level + 1);
  121. return node ? node.name : '';
  122. } else {
  123. const node = getNodeByLevel(xmj, 3);
  124. return node ? node.name : '';
  125. }
  126. }
  127. /**
  128. * 获取 分项工程
  129. *
  130. * @param peg - 桩号节点
  131. * @param xmj - 计量单元(最底层项目节)
  132. * @returns {string}
  133. */
  134. function getFxgc(peg, xmj) {
  135. if (!peg) {
  136. const node = getNodeByLevel(xmj, 4);
  137. return node ? node.name : '';
  138. } else if (peg.id === xmj.id) {
  139. if (xmj.level > 4) {
  140. let value = '';
  141. for (let level = 4; level < xmj.level; level++) {
  142. const node = getNodeByLevel(xmj, level);
  143. value = value === '' ? node.name : value + mergeChar + node.name;
  144. }
  145. return value;
  146. } else {
  147. return '';
  148. }
  149. } else {
  150. if (peg.level + 2 < xmj.level) {
  151. let value = '';
  152. for (let level = peg.level + 2; level < xmj.level; level++) {
  153. const node = getNodeByLevel(xmj, level);
  154. value = value === '' ? node.name : value + mergeChar + node.name;
  155. }
  156. return value;
  157. } else {
  158. return '';
  159. }
  160. }
  161. }
  162. /**
  163. * 新建 最底层项目节 缓存数据
  164. * @param leafXmj
  165. * @returns {{id, code: *|string[], jldy, fbgc: string, fxgc: string, dwgc: string, bwmx: string, drawing_code: string}}
  166. */
  167. function newCacheLeafXmj(leafXmj) {
  168. const peg = getPegNode(leafXmj);
  169. const cacheLX = {
  170. id: leafXmj.id,
  171. code: leafXmj.code,
  172. jldy: leafXmj.name,
  173. fbgc: getFbgc(peg, leafXmj),
  174. fxgc: getFxgc(peg, leafXmj),
  175. dwgc: getDwgc(peg, leafXmj),
  176. drawing_code: leafXmj.drawing_code,
  177. };
  178. leafXmjs.push(cacheLX);
  179. return cacheLX;
  180. }
  181. /**
  182. * 获取缓存的最底层项目节数据
  183. *
  184. * @param leafXmj - 最底层项目节
  185. * @returns {*}
  186. */
  187. function getCacheLeafXmj(leafXmj) {
  188. const cacheLX = leafXmjs.find(function (lx) {
  189. return lx.id === leafXmj.id;
  190. });
  191. if (!cacheLX) {
  192. return newCacheLeafXmj(leafXmj);
  193. } else {
  194. return cacheLX;
  195. }
  196. }
  197. /**
  198. * 汇总节点
  199. * @param node - 最底层 工程量清单 节点
  200. * @param leafXmj - 所属 最底层 项目节
  201. */
  202. function loadGatherGclNode(node, leafXmj, gsPos) {
  203. const gcl = getGclNode(node);
  204. gatherfields(gcl, node, ledgerSetting.billsFields, ledgerSetting.prefix);
  205. const cacheLeafXmj = getCacheLeafXmj(leafXmj);
  206. const posRange = gsPos.getLedgerPos(node.id);
  207. const detail = posRange && posRange.length > 0 ? posRange : [node];
  208. for (const d of detail) {
  209. const lx = gcl.leafXmjs.find(x => {return x.id === leafXmj.id && (x.mx_id === d.id || x.gcl_id === d.id)});
  210. if (lx) {
  211. gatherfields(lx, d, ledgerSetting.posFields, ledgerSetting.prefix);
  212. } else {
  213. const dx = _.assign({}, cacheLeafXmj);
  214. gatherfields(dx, d, ledgerSetting.posFields, ledgerSetting.prefix);
  215. dx.gcl_id = node.id;
  216. if (d.name !== node.name) {
  217. dx.bwmx = d.name;
  218. dx.mx_id = d.id;
  219. }
  220. if (d.drawing_code) {
  221. dx.drawing_code = d.drawing_code;
  222. }
  223. gcl.leafXmjs.push(dx);
  224. }
  225. }
  226. }
  227. /**
  228. * (递归)汇总树节点
  229. * @param nodes - 汇总节点列表
  230. * @param leafXmj - 汇总节点所属的底层项目节
  231. */
  232. function recursiveGatherGclData(nodes, leafXmj, gsPos) {
  233. for (const node of nodes) {
  234. if (node.b_code) {
  235. if (node.children.length > 0) {
  236. recursiveGatherGclData(node.children, leafXmj, gsPos);
  237. } else {
  238. loadGatherGclNode(node, leafXmj, gsPos);
  239. }
  240. } else if (node.children.length > 0) {
  241. recursiveGatherGclData(node.children, node, gsPos);
  242. }
  243. }
  244. }
  245. function _getCalcChapter(chapter, option) {
  246. gclChapter = [];
  247. otherChapter = [];
  248. gclChapterFilter = [];
  249. let serialNo = 1;
  250. for (const c of chapter) {
  251. const cc = { code: c.code, name: c.name, cType: 1 };
  252. cc.serialNo = serialNo++;
  253. cc.filter = '^[^0-9]*' + c.code.substr(0, c.code.length - 2) + '[0-9]{2}(-|$)';
  254. gclChapter.push(cc);
  255. }
  256. gclChapter.push({ name: '未计入章节清单合计', cType: 21, serialNo: serialNo+1 });
  257. otherChapter.hj = { name: '合计(C=A+B+Z)', cType: 41, serialNo: serialNo+5, deal_bills_tp: option.zlj.deal_bills_tp };
  258. gclChapterFilter.push({node_type: option.jrg.value});
  259. gclChapterFilter.push({field: 'name', part: option.jrg.text});
  260. const zlChapter = {
  261. name: '暂列金额(Z)', cType: 32, serialNo: serialNo+4,
  262. deal_bills_tp: option.zlj.deal_bills_tp, match: [], matchPath: []
  263. };
  264. zlChapter.match.push({node_type: option.zlj.value});
  265. zlChapter.match.push({field: 'name', part: option.zlj.text});
  266. otherChapter.zlj = zlChapter;
  267. otherChapter.qd = { name: '清单小计(A)', cType: 11, serialNo: serialNo+2 };
  268. otherChapter.fqd = { name: '非清单项费用(B)', cType: 31, serialNo: serialNo+3 };
  269. return[gclChapter, otherChapter, gclChapterFilter];
  270. }
  271. function _gatherChapterFields(chapter, data, fields) {
  272. for (const f of fields) {
  273. chapter[f] = ZhCalc.add(chapter[f], data[f]);
  274. }
  275. }
  276. function _getGclChapter(chapter, data) {
  277. for (const c of chapter) {
  278. if (c.filter) {
  279. const reg = new RegExp(c.filter);
  280. if (reg.test(data.b_code)) {
  281. return c;
  282. }
  283. } else {
  284. return c;
  285. }
  286. }
  287. }
  288. function _checkFilter(d, filter) {
  289. for (const f of filter) {
  290. if (f.node_type && f.node_type === d.node_type) return true;
  291. if (f.field) {
  292. if (f.part && d[f.field] && d[f.field].indexOf(f.part) >= 0) return true;
  293. if (f.all && d[f.all] && d[f.all] === f.all) return true;
  294. }
  295. }
  296. return false;
  297. }
  298. function _gatherChapter() {
  299. const chapterFilterPath = [];
  300. const checkFilterPath = function (data, filterPath) {
  301. for (const fp of filterPath) {
  302. if (data.full_path.indexOf(fp + '-') === 0 || data.full_path === fp) return true;
  303. }
  304. return false;
  305. };
  306. for (const d of gsTree.nodes) {
  307. if (_checkFilter(d, gclChapterFilter)) chapterFilterPath.push(d.full_path);
  308. if (_checkFilter(d, otherChapter.zlj.match)) otherChapter.zlj.matchPath.push(d.full_path);
  309. if (d.children && d.children.length > 0) continue;
  310. if (checkFilterPath(d,otherChapter.zlj.matchPath)) {
  311. gatherfields(otherChapter.zlj, d, ledgerSetting.chapterFields, ledgerSetting.prefix);
  312. gatherfields(otherChapter.hj, d, ledgerSetting.chapterFields, ledgerSetting.prefix);
  313. } else {
  314. gatherfields(otherChapter.hj, d, ledgerSetting.chapterFields, ledgerSetting.prefix);
  315. if (d.b_code) {
  316. gatherfields(otherChapter.qd, d, ledgerSetting.chapterFields, ledgerSetting.prefix);
  317. }
  318. if (!d.b_code || d.b_code === '') {
  319. gatherfields(otherChapter.fqd, d, ledgerSetting.chapterFields, ledgerSetting.prefix);
  320. }
  321. if (d.b_code) {
  322. const c = checkFilterPath(d, chapterFilterPath)
  323. ? gclChapter.find(x => { return x.cType === 21})
  324. : _getGclChapter(gclChapter, d);
  325. gatherfields(c, d, ledgerSetting.chapterFields, ledgerSetting.prefix);
  326. }
  327. }
  328. }
  329. }
  330. function init (gclData, chapter, option) {
  331. gclList = gclData;
  332. [gclChapter, otherChapter, gclChapterFilter] = _getCalcChapter(chapter, option);
  333. }
  334. /**
  335. *
  336. * @param bills - 项目节+清单数据
  337. * @param pos - 计量单元数据
  338. * @param setting 配置
  339. * e.g.
  340. * {
  341. * tree: {
  342. * id: 'ledger_id',
  343. * pid: 'ledger_pid',
  344. * order: 'order',
  345. * level: 'level',
  346. * rootId: -1,
  347. * keys: ['id', 'tender_id', 'ledger_id'],
  348. * stageId: 'id',
  349. * },
  350. * pos: { id: 'id', ledgerId: 'lid', },
  351. * billsFields: ['quantity', 'total_price', 'deal_qty', 'deal_tp'],
  352. * posFields: ['quantity'],
  353. * chapterFields: [new_total_price],
  354. * prefix: 'org' // 'new'
  355. * }
  356. */
  357. function gatherLedgerData(bills, pos, setting) {
  358. ledgerSetting = setting;
  359. try {
  360. if (leafXmjs.length > 0) leafXmjs.length = 0;
  361. gsTree = createNewPathTree('ledger', setting.tree);
  362. gsTree.loadDatas(bills);
  363. const gsPos = new PosData(setting.pos);
  364. gsPos.loadDatas(pos);
  365. recursiveGatherGclData(gsTree.children, null, gsPos);
  366. _gatherChapter();
  367. } catch(err) {
  368. console.log(err);
  369. }
  370. ledgerSetting = null;
  371. }
  372. function gatherReviseLedgerData(bills, pos, setting, price, decimal) {
  373. ledgerSetting = setting;
  374. try {
  375. if (leafXmjs.length > 0) leafXmjs.length = 0;
  376. gsTree = createNewPathTree('revise', setting.tree);
  377. gsTree.loadRevisePrice(price, decimal);
  378. gsTree.loadDatas(bills);
  379. const gsPos = new PosData(setting.pos);
  380. gsPos.loadDatas(pos);
  381. recursiveGatherGclData(gsTree.children, null, gsPos);
  382. _gatherChapter();
  383. } catch(err) {
  384. console.log(err);
  385. }
  386. ledgerSetting = null;
  387. }
  388. function compareCode(str1, str2, symbol = '-') {
  389. if (!str1) {
  390. return 1;
  391. } else if (!str2) {
  392. return -1;
  393. }
  394. function compareSubCode(code1, code2) {
  395. if (numReg.test(code1)) {
  396. if (numReg.test(code2)) {
  397. return parseInt(code1) - parseInt(code2);
  398. } else {
  399. return -1
  400. }
  401. } else {
  402. if (numReg.test(code2)) {
  403. return 1;
  404. } else {
  405. return code1 === code2 ? 0 : (code1 < code2 ? -1 : 1); //code1.localeCompare(code2);
  406. }
  407. }
  408. }
  409. const numReg = /^[0-9]+$/;
  410. const aCodes = str1.split(symbol), bCodes = str2.split(symbol);
  411. for (let i = 0, iLength = Math.min(aCodes.length, bCodes.length); i < iLength; ++i) {
  412. const iCompare = compareSubCode(aCodes[i], bCodes[i]);
  413. if (iCompare !== 0) {
  414. return iCompare;
  415. }
  416. }
  417. return aCodes.length - bCodes.length;
  418. }
  419. /**
  420. *
  421. * @param data {Array} - 签约清单数据
  422. * @returns <void>
  423. */
  424. function gatherDealBills(data) {
  425. if (data instanceof Array && data.length > 0) {
  426. for (const node of data) {
  427. node.b_code = node.code;
  428. const gcl = getGclNode(node);
  429. if (!node.quantity || !node.unit_price) continue;
  430. gcl.deal_bills_qty = ZhCalc.add(gcl.deal_bills_qty, node.quantity || 0);
  431. gcl.deal_bills_tp = ZhCalc.add(gcl.deal_bills_tp, node.total_price || 0);
  432. otherChapter.hj.deal_bills_tp = ZhCalc.add(otherChapter.hj.deal_bills_tp, node.total_price);
  433. otherChapter.qd.deal_bills_tp = ZhCalc.add(otherChapter.qd.deal_bills_tp, node.total_price);
  434. const c = _getGclChapter(gclChapter, node);
  435. c.deal_bills_tp = ZhCalc.add(c.deal_bills_tp, node.total_price);
  436. }
  437. }
  438. }
  439. /**
  440. * 检查汇总完的工程量清单中,同编号 & 不同名称/单位/单价 的清单并标记
  441. */
  442. function checkDiffer() {
  443. gclList.sort((a, b) => {
  444. const iCode = compareCode(a.b_code, b.b_code);
  445. return iCode ? iCode : (a.unit_price - b.unit_price);
  446. });
  447. for (const gcl of gclList) {
  448. gcl.differ = false;
  449. }
  450. for (const [i, gcl] of gclList.entries()) {
  451. gcl.differ_qty = ZhCalc.sub(gcl.new_quantity, gcl.org_quantity, 6);
  452. gcl.deal_differ_qty = ZhCalc.sub(gcl.new_quantity, gcl.deal_bills_qty, 6);
  453. if (i === gclList.length - 1) continue;
  454. const next = gclList[i+1];
  455. if (gcl.b_code === next.b_code) {
  456. if (gcl.name !== next.name || gcl.unit !== next.unit || !checkZero(gcl.unit_price - next.unit_price)) {
  457. gcl.differ = true;
  458. next.differ = true;
  459. }
  460. }
  461. }
  462. }
  463. function chapterData () {
  464. return gclChapter.concat([otherChapter.qd, otherChapter.fqd, otherChapter.zlj, otherChapter.hj]);
  465. }
  466. return {
  467. init,
  468. gatherLedgerData, gatherReviseLedgerData, gatherDealBills, checkDiffer,
  469. chapterData
  470. };
  471. })();