facades.js 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469
  1. 'use strict';
  2. /**
  3. *
  4. *
  5. * @author Zhong
  6. * @date 2018/6/1
  7. * @version
  8. */
  9. import mongoose from 'mongoose';
  10. import CompilationModel from "../../users/models/compilation_model";
  11. import moment from 'moment';
  12. const uuidV1 = require('uuid/v1');
  13. const billsLibModel = mongoose.model('std_bills_lib_list');
  14. const billsGuideLibModel = mongoose.model('std_billsGuidance_lib');
  15. const billsGuideItemsModel = mongoose.model('std_billsGuidance_items');
  16. const stdBillsLibModel = mongoose.model('std_bills_lib_list');
  17. const stdBillsModel = mongoose.model('std_bills_lib_bills');
  18. const stdBillsJobsModel = mongoose.model('std_bills_lib_jobContent');
  19. const stdRationModel = mongoose.model('std_ration_lib_ration_items');
  20. const engLibModel = mongoose.model('engineering_lib');
  21. const compilationModel = mongoose.model('compilation');
  22. const _ = require('lodash');
  23. const zhLibID = 'cf851660-3534-11ec-9641-2da8021b8e4e';
  24. const cqLibID = '90c51220-a740-11e8-a354-ab5db7d42428';
  25. module.exports = {
  26. handleCopyItems,
  27. getComBillsLibInfo,
  28. getBillsGuideLibs,
  29. initBillsGuideLib,
  30. updateBillsGuideLib,
  31. getLibWithBills,
  32. getItemsBybills,
  33. updateItems,
  34. testItems
  35. };
  36. function setChildren(bill, parentMap) {
  37. let children = parentMap[bill.ID];
  38. if (children) {
  39. for (let c of children) {
  40. setChildren(c, parentMap);
  41. }
  42. bill.children = children;
  43. } else {
  44. bill.children = [];
  45. }
  46. }
  47. function sortChildren(lists) {
  48. let IDMap = {},
  49. nextMap = {},
  50. firstNode = null,
  51. newList = [];
  52. for (let l of lists) {
  53. if (l.children && l.children.length > 0) l.children = sortChildren(l.children); //递规排序
  54. IDMap[l.ID] = l;
  55. if (l.NextSiblingID != -1) nextMap[l.NextSiblingID] = l;
  56. }
  57. for (let t of lists) {
  58. if (!nextMap[t.ID]) { //如果在下一节点映射没找到,则是第一个节点
  59. firstNode = t;
  60. break;
  61. }
  62. }
  63. if (firstNode) {
  64. newList.push(firstNode);
  65. delete IDMap[firstNode.ID];
  66. setNext(firstNode, newList);
  67. }
  68. //容错处理,如果链断了的情况,直接添加到后面
  69. for (let key in IDMap) {
  70. if (IDMap[key]) newList.push(IDMap[key])
  71. }
  72. return newList;
  73. function setNext(node, array) {
  74. if (node.NextSiblingID != -1) {
  75. let next = IDMap[node.NextSiblingID];
  76. if (next) {
  77. array.push(next);
  78. delete IDMap[next.ID];
  79. setNext(next, array);
  80. }
  81. }
  82. }
  83. }
  84. function getItemFromChildren(children, allItems) {
  85. for (let i = 0; i < children.length; i++) {
  86. const cur = children[i];
  87. const next = children[i + 1];
  88. cur.NextSiblingID = next && next.ID || -1;
  89. allItems.push(cur);
  90. if (cur.children && cur.children.length) {
  91. getItemFromChildren(cur.children, allItems);
  92. }
  93. }
  94. }
  95. function resetTreeData(billsList) {
  96. const idMapping = {};
  97. idMapping['-1'] = -1;
  98. // 建立新ID-旧ID映射
  99. billsList.forEach(bills => idMapping[bills.ID] = uuidV1());
  100. billsList.forEach(function (bills) {
  101. bills.ID = idMapping[bills.ID] ? idMapping[bills.ID] : -1;
  102. bills.ParentID = idMapping[bills.ParentID] ? idMapping[bills.ParentID] : -1;
  103. bills.NextSiblingID = idMapping[bills.NextSiblingID] ? idMapping[bills.NextSiblingID] : -1;
  104. });
  105. }
  106. // 从某库中根据清单编号拷贝工艺
  107. async function handleCopyItems(sourceGuideLibID, sourceBillsLibID, targetGuideLibID, targetBillsLibID) {
  108. const sourceBills = await stdBillsModel.find({ billsLibId: sourceBillsLibID, deleted: false }, '-_id ID code').lean();
  109. const targetBills = await stdBillsModel.find({ billsLibId: targetBillsLibID, deleted: false }, '-_id ID code').lean();
  110. const sourceItems = await billsGuideItemsModel.find({ libID: sourceGuideLibID, type: 0, deleted: false }, '-_id').lean(); // 过滤掉定额项
  111. const targetCodeIDMap = {};
  112. targetBills.forEach(bills => targetCodeIDMap[bills.code] = bills.ID);
  113. const toDeleteIDList = [];
  114. const insertBulks = [];
  115. sourceBills.forEach(bills => {
  116. const matchedItems = sourceItems.filter(item => item.billsID === bills.ID);
  117. // 重新将断缺的树结构数据整理好
  118. if (matchedItems.length) {
  119. const parentMap = {};
  120. matchedItems.forEach(item => {
  121. (parentMap[item.ParentID] || (parentMap[item.ParentID] = [])).push(item);
  122. });
  123. const roots = parentMap['-1'];
  124. roots.forEach(root => setChildren(root, parentMap));
  125. const sorted = sortChildren(roots);
  126. const newItems = [];
  127. getItemFromChildren(sorted, newItems);
  128. resetTreeData(newItems);
  129. const targetBillsID = targetCodeIDMap[bills.code];
  130. if (targetBillsID) {
  131. toDeleteIDList.push(targetBillsID);
  132. newItems.forEach(newItem => {
  133. newItem.libID = targetGuideLibID;
  134. newItem.billsID = targetBillsID;
  135. insertBulks.push({
  136. insertOne: { document: newItem }
  137. });
  138. })
  139. }
  140. }
  141. });
  142. if (toDeleteIDList.length) {
  143. await billsGuideItemsModel.remove({ libID: targetGuideLibID, billsID: { $in : toDeleteIDList } });
  144. }
  145. if (insertBulks.length) {
  146. await billsGuideItemsModel.bulkWrite(insertBulks);
  147. }
  148. }
  149. async function getCompilationList() {
  150. let compilationModel = new CompilationModel();
  151. return await compilationModel.getCompilationList();
  152. }
  153. async function getComBillsLibInfo() {
  154. let rst = {compilationList: [], billsLibs: []};
  155. let compilationList = await getCompilationList();
  156. if(compilationList.length <= 0){
  157. throw '没有数据';
  158. }
  159. else{
  160. for(let compilation of compilationList){
  161. rst.compilationList.push({_id: compilation._id, name: compilation.name});
  162. }
  163. rst.billsLibs = await billsLibModel.find({deleted: false}, '-_id billsLibId billsLibName');
  164. return rst;
  165. }
  166. }
  167. async function getBillsGuideLibs(findData, isTemporary) {
  168. if (isTemporary) {
  169. const libs = await billsGuideLibModel.find({ ID: { $in: [zhLibID, cqLibID] } }).lean();
  170. return libs;
  171. }
  172. return await billsGuideLibModel.find(findData);
  173. }
  174. // 如果是“重庆费用定额(2018)”,则默认叶子清单的项目指引窗口只有一条数据,取清单名称。
  175. async function genGuidanceItems_cq18(guidanceLibId, billsLibId) {
  176. let bills = await stdBillsModel.find({billsLibId: billsLibId, deleted: false, 'jobs.0': {$exists: true}});
  177. let insertArr = [];
  178. for(let bill of bills){
  179. let newItem = {
  180. libID: guidanceLibId,
  181. ID: uuidV1(), ParentID: -1,
  182. NextSiblingID: -1,
  183. name: bill.name,
  184. type: 0,
  185. billsID: bill.ID
  186. };
  187. insertArr.push({insertOne: {document: newItem}});
  188. }
  189. await billsGuideItemsModel.bulkWrite(insertArr);
  190. }
  191. //拷贝工作内容并转化为树结构,形成项目指引数据
  192. async function genGuidanceItems(guidanceLibId, billsLibId){
  193. let bills = await stdBillsModel.find({billsLibId: billsLibId, deleted: false, 'jobs.0': {$exists: true}});
  194. //设置工作内容数据
  195. let jobIds = [];
  196. let totalJobs = [];
  197. for(let bill of bills){
  198. for(let job of bill.jobs){
  199. jobIds.push(job.id);
  200. }
  201. }
  202. jobIds = Array.from(new Set(jobIds));
  203. if(jobIds.length > 0){
  204. totalJobs = await stdBillsJobsModel.find({deleted: false, id: {$in: jobIds}});
  205. }
  206. if(totalJobs.length > 0){
  207. let jobIdIndex = {};//id索引
  208. for(let job of totalJobs){
  209. jobIdIndex[job.id] = job;
  210. }
  211. let insertArr = [];
  212. for(let bill of bills){
  213. //排序后根据serialNo转换成NextSiblingID,倒序
  214. bill.jobs.sort(function (a, b) {
  215. let rst = 0;
  216. if(a.serialNo > b.serialNo){
  217. rst = -1;
  218. }
  219. else if(a.serialNo < b.serialNo){
  220. rst = 1;
  221. }
  222. return rst;
  223. });
  224. let jobNoIndex = {};//下标索引
  225. for(let i = 0; i < bill.jobs.length; i++){
  226. let newItem = {libID: guidanceLibId, ID: uuidV1(), ParentID: -1, NextSiblingID: jobNoIndex[i - 1] ? jobNoIndex[i - 1]['ID'] : -1,
  227. name: jobIdIndex[bill.jobs[i]['id']]['content'], type: 0, billsID: bill.ID};
  228. jobNoIndex[i] = newItem;
  229. insertArr.push({insertOne: {document: newItem}});
  230. }
  231. }
  232. await billsGuideItemsModel.bulkWrite(insertArr);
  233. }
  234. }
  235. async function initBillsGuideLib(updateData){
  236. await billsGuideLibModel.create(updateData);
  237. let compilation = await compilationModel.findOne({_id: mongoose.Types.ObjectId(updateData.compilationId)});
  238. if (compilation &&
  239. compilation.overWriteUrl &&
  240. compilation.overWriteUrl === '/web/over_write/js/chongqing_2018.js') {
  241. await genGuidanceItems_cq18(updateData.ID, updateData.billsLibId);
  242. } else {
  243. await genGuidanceItems(updateData.ID, updateData.billsLibId);
  244. }
  245. }
  246. async function updateBillsGuideLib(data) {
  247. if(data.updateType === 'delete'){
  248. //删除所有条目
  249. await billsGuideLibModel.remove(data.findData);
  250. await billsGuideItemsModel.remove({libID: data.findData.ID});
  251. }
  252. else {
  253. await billsGuideLibModel.update(data.findData, {$set: data.updateData});
  254. await engLibModel.update({'billsGuidance_lib.id': data.findData.ID}, {$set: {'billsGuidance_lib.$.name': data.updateData.name}}, {multi: true});
  255. }
  256. }
  257. async function getLibWithBills(libID){
  258. let guidanceLib = await getBillsGuideLibs({ID: libID});
  259. if(guidanceLib.length === 0){
  260. throw '不存在此指引库!';
  261. }
  262. let billsLib = await stdBillsLibModel.findOne({billsLibId: guidanceLib[0].billsLibId});
  263. if(!billsLib){
  264. throw '引用的清单规则库不存在!';
  265. }
  266. let bills = await stdBillsModel.find({billsLibId: billsLib.billsLibId}, '-_id code name ID NextSiblingID ParentID jobs items comment').lean();
  267. const guideItems = await billsGuideItemsModel.find({ libID: guidanceLib[0].ID }, '-_id billsID').lean();
  268. const billsMap = {};
  269. for (const item of guideItems) {
  270. billsMap[item.billsID] = true;
  271. }
  272. for (const item of bills) {
  273. if (billsMap[item.ID]) {
  274. item.hasGuide = true;
  275. }
  276. }
  277. return {guidanceLib: guidanceLib[0], bills};
  278. }
  279. function getAttrs(field, datas){
  280. let rst = [];
  281. for(let data of datas){
  282. if(data[field]){
  283. rst.push(data[field]);
  284. }
  285. }
  286. return rst;
  287. }
  288. //定额项目指所引用定额是否被删除
  289. function rationAllExist(rationItems, stdRationIdx) {
  290. for(let item of rationItems){
  291. if(!stdRationIdx[item.rationID]){
  292. return false;
  293. }
  294. }
  295. return true;
  296. }
  297. //将同层树结构转为顺序数组
  298. function chainToArr(nodes){
  299. let rst = [];
  300. let tempIdx = {};
  301. let nodeIdx = {};
  302. //建索引
  303. for(let node of nodes){
  304. tempIdx[node.ID] = {ID: node.ID, NextSiblingID: node.NextSiblingID, preSibling: null, nextSibling: null};
  305. nodeIdx[node.ID] = node;
  306. }
  307. //建链
  308. for(let i in tempIdx){
  309. let temp = tempIdx[i];
  310. if(temp.NextSiblingID != -1){
  311. let next = tempIdx[temp.NextSiblingID];
  312. temp.nextSibling = next;
  313. next.preSibling = temp;
  314. }
  315. }
  316. let firstNode = null;
  317. for(let i in tempIdx){
  318. if(!tempIdx[i].preSibling){
  319. firstNode = tempIdx[i];
  320. break;
  321. }
  322. }
  323. //获得顺序队列
  324. while(firstNode){
  325. rst.push(nodeIdx[firstNode.ID]);
  326. firstNode = firstNode.nextSibling;
  327. }
  328. return rst;
  329. }
  330. async function getItemsBybills(guidanceLibID, billsID){
  331. const type = {job: 0, ration: 1};
  332. let items = await billsGuideItemsModel.find({libID: guidanceLibID, billsID: billsID, deleted: false});
  333. let rationItems = _.filter(items, {type: type.ration});
  334. let rationIds = getAttrs('rationID', rationItems);
  335. let stdRations = await stdRationModel.find({ID: {$in: rationIds}, $or: [{isDeleted: null}, {isDeleted: false}]});
  336. let stdRationIndex = {};
  337. for(let stdRation of stdRations){
  338. stdRationIndex[stdRation.ID] = stdRation;
  339. }
  340. //判断定额完整性
  341. if(!rationAllExist(rationItems, stdRationIndex)){
  342. //建定额链, 排序后再清除不存在的定额,保证顺序正确性
  343. rationItems = chainToArr(rationItems);
  344. //清除已被删除的定额
  345. let removeIds = [];
  346. _.remove(rationItems, function (item) {
  347. if(!stdRationIndex[item.rationID]){
  348. removeIds.push(item.ID);
  349. return true;
  350. }
  351. return false;
  352. });
  353. _.remove(items, function (item) {
  354. return removeIds.includes(item.ID);
  355. });
  356. await billsGuideItemsModel.remove({ID: {$in: removeIds}});
  357. //重组树结构
  358. let bulkArr = [];
  359. for(let i = 0, len = rationItems.length; i < len; i++){
  360. rationItems[i].NextSiblingID = rationItems[i + 1] ? rationItems[i + 1].ID : -1;
  361. bulkArr.push({updateOne: {filter: {ID: rationItems[i].ID}, update: {$set: {NextSiblingID: rationItems[i].NextSiblingID}}}});
  362. }
  363. await billsGuideItemsModel.bulkWrite(bulkArr);
  364. }
  365. return items;
  366. }
  367. async function updateItems(updateDatas) {
  368. let bulkArr = [];
  369. for(let updateData of updateDatas){
  370. if(updateData.updateType === 'create'){
  371. bulkArr.push({insertOne: {document: updateData.updateData}});
  372. }
  373. else if(updateData.updateType === 'update'){
  374. bulkArr.push({updateOne: {filter: updateData.findData, update: {$set: updateData.updateData}}});
  375. }
  376. else{
  377. bulkArr.push({deleteOne: {filter: updateData.findData}});
  378. }
  379. }
  380. if(bulkArr.length > 0){
  381. await billsGuideItemsModel.bulkWrite(bulkArr);
  382. }
  383. }
  384. async function testItems(libID) {
  385. let items = await billsGuideItemsModel.find({libID: libID});
  386. //删除垃圾数据
  387. let delBulk = [];
  388. let itemsMapping = {};
  389. for(let item of items){
  390. itemsMapping[item.ID] = true;
  391. }
  392. for(let item of items){
  393. if(item.ParentID != -1 && !itemsMapping[item.ParentID]){
  394. delBulk.push({
  395. deleteOne: {
  396. filter: {ID: item.ID}
  397. }
  398. });
  399. }
  400. }
  401. if(delBulk.length > 0){
  402. console.log(`delBulk.length`);
  403. console.log(delBulk.length);
  404. await billsGuideItemsModel.bulkWrite(delBulk);
  405. }
  406. /* //查找同层节点含有相同NextSiblingID的节点
  407. let rst = [];
  408. let billsGroup = {};
  409. for(let item of items){
  410. if(!billsGroup[item.billsID]){
  411. billsGroup[item.billsID] = [item];
  412. }
  413. else {
  414. billsGroup[item.billsID].push(item);
  415. }
  416. }
  417. for(let bGroup in billsGroup){
  418. let group = billsGroup[bGroup];
  419. let parentGroup = {};
  420. for(let gItem of group){
  421. if(!parentGroup[gItem.ParentID]){
  422. parentGroup[gItem.ParentID] = [gItem]
  423. }
  424. else {
  425. parentGroup[gItem.ParentID].push(gItem);
  426. }
  427. }
  428. for(let pGroup in parentGroup){
  429. let pGroupData = parentGroup[pGroup];
  430. let nextGroup = {};
  431. for(let nItem of pGroupData){
  432. let sameNext = _.filter(pGroupData, {NextSiblingID: nItem.NextSiblingID});
  433. if(sameNext.length > 1){
  434. console.log(`sameNext`);
  435. console.log(sameNext);
  436. if(!nextGroup[nItem.ParentID + nItem.NextSiblingID]){
  437. rst.push({NextSiblingID: nItem.NextSiblingID, ParentID: nItem.ParentID});
  438. nextGroup[nItem.ParentID + nItem.NextSiblingID] = 1;
  439. }
  440. }
  441. }
  442. }
  443. }*/
  444. return delBulk.length;
  445. }