facades.js 16 KB

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