facades.js 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308
  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 _ = require('lodash');
  22. module.exports = {
  23. getComBillsLibInfo,
  24. getBillsGuideLibs,
  25. initBillsGuideLib,
  26. updateBillsGuideLib,
  27. getLibWithBills,
  28. getItemsBybills,
  29. updateItems,
  30. testItems
  31. };
  32. async function getCompilationList(req) {
  33. let compilationModel = new CompilationModel();
  34. return await compilationModel.getPermissionCompilationList(req);
  35. }
  36. async function getComBillsLibInfo(req) {
  37. let rst = { compilationList: [], billsLibs: [] };
  38. let compilationList = await getCompilationList(req);
  39. if (compilationList.length <= 0) {
  40. throw '没有数据';
  41. }
  42. else {
  43. for (let compilation of compilationList) {
  44. rst.compilationList.push({ _id: compilation._id, name: compilation.name });
  45. }
  46. rst.billsLibs = await billsLibModel.find({ deleted: false }, '-_id billsLibId billsLibName');
  47. return rst;
  48. }
  49. }
  50. async function getBillsGuideLibs(findData) {
  51. return await billsGuideLibModel.find(findData);
  52. }
  53. //拷贝工作内容并转化为树结构,形成项目指引数据
  54. async function genGuidanceItems(guidanceLibId, billsLibId) {
  55. let bills = await stdBillsModel.find({ billsLibId: billsLibId, deleted: false, 'jobs.0': { $exists: true } });
  56. //设置工作内容数据
  57. let jobIds = [];
  58. let totalJobs = [];
  59. for (let bill of bills) {
  60. for (let job of bill.jobs) {
  61. jobIds.push(job.id);
  62. }
  63. }
  64. jobIds = Array.from(new Set(jobIds));
  65. if (jobIds.length > 0) {
  66. totalJobs = await stdBillsJobsModel.find({ deleted: false, id: { $in: jobIds } });
  67. }
  68. if (totalJobs.length > 0) {
  69. let jobIdIndex = {};//id索引
  70. for (let job of totalJobs) {
  71. jobIdIndex[job.id] = job;
  72. }
  73. let insertArr = [];
  74. for (let bill of bills) {
  75. //排序后根据serialNo转换成NextSiblingID,倒序
  76. bill.jobs.sort(function (a, b) {
  77. let rst = 0;
  78. if (a.serialNo > b.serialNo) {
  79. rst = -1;
  80. }
  81. else if (a.serialNo < b.serialNo) {
  82. rst = 1;
  83. }
  84. return rst;
  85. });
  86. let jobNoIndex = {};//下标索引
  87. for (let i = 0; i < bill.jobs.length; i++) {
  88. let newItem = {
  89. libID: guidanceLibId, ID: uuidV1(), ParentID: -1, NextSiblingID: jobNoIndex[i - 1] ? jobNoIndex[i - 1]['ID'] : -1,
  90. name: jobIdIndex[bill.jobs[i]['id']]['content'], type: 0, billsID: bill.ID
  91. };
  92. jobNoIndex[i] = newItem;
  93. insertArr.push({ insertOne: { document: newItem } });
  94. }
  95. }
  96. await billsGuideItemsModel.bulkWrite(insertArr);
  97. }
  98. }
  99. async function initBillsGuideLib(updateData) {
  100. await billsGuideLibModel.create(updateData);
  101. await genGuidanceItems(updateData.ID, updateData.billsLibId);
  102. }
  103. async function updateBillsGuideLib(data) {
  104. if (data.updateType === 'delete') {
  105. //删除所有条目
  106. await billsGuideLibModel.remove(data.findData);
  107. await billsGuideItemsModel.remove({ libID: data.findData.ID });
  108. }
  109. else {
  110. await billsGuideLibModel.update(data.findData, { $set: data.updateData });
  111. await engLibModel.update({ 'billsGuidance_lib.id': data.findData.ID }, { $set: { 'billsGuidance_lib.$.name': data.updateData.name } }, { multi: true });
  112. }
  113. }
  114. async function getLibWithBills(libID) {
  115. let guidanceLib = await getBillsGuideLibs({ ID: libID });
  116. if (guidanceLib.length === 0) {
  117. throw '不存在此指引库!';
  118. }
  119. let billsLib = await stdBillsLibModel.findOne({ billsLibId: guidanceLib[0].billsLibId });
  120. if (!billsLib) {
  121. throw '引用的清单规则库不存在!';
  122. }
  123. let bills = await stdBillsModel.find({ billsLibId: billsLib.billsLibId }, '-_id code name ID NextSiblingID ParentID jobs items comment');
  124. return { guidanceLib: guidanceLib[0], bills };
  125. }
  126. function getAttrs(field, datas) {
  127. let rst = [];
  128. for (let data of datas) {
  129. if (data[field]) {
  130. rst.push(data[field]);
  131. }
  132. }
  133. return rst;
  134. }
  135. //定额项目指所引用定额是否被删除
  136. function rationAllExist(rationItems, stdRationIdx) {
  137. for (let item of rationItems) {
  138. if (!stdRationIdx[item.rationID]) {
  139. return false;
  140. }
  141. }
  142. return true;
  143. }
  144. //将同层树结构转为顺序数组
  145. function chainToArr(nodes) {
  146. let rst = [];
  147. let tempIdx = {};
  148. let nodeIdx = {};
  149. //建索引
  150. for (let node of nodes) {
  151. tempIdx[node.ID] = { ID: node.ID, NextSiblingID: node.NextSiblingID, preSibling: null, nextSibling: null };
  152. nodeIdx[node.ID] = node;
  153. }
  154. //建链
  155. for (let i in tempIdx) {
  156. let temp = tempIdx[i];
  157. if (temp.NextSiblingID != -1) {
  158. let next = tempIdx[temp.NextSiblingID];
  159. temp.nextSibling = next;
  160. next.preSibling = temp;
  161. }
  162. }
  163. let firstNode = null;
  164. for (let i in tempIdx) {
  165. if (!tempIdx[i].preSibling) {
  166. firstNode = tempIdx[i];
  167. break;
  168. }
  169. }
  170. //获得顺序队列
  171. while (firstNode) {
  172. rst.push(nodeIdx[firstNode.ID]);
  173. firstNode = firstNode.nextSibling;
  174. }
  175. return rst;
  176. }
  177. async function getItemsBybills(guidanceLibID, billsID) {
  178. const type = { job: 0, ration: 1 };
  179. let items = await billsGuideItemsModel.find({ libID: guidanceLibID, billsID: billsID, deleted: false });
  180. let rationItems = _.filter(items, { type: type.ration });
  181. let rationIds = getAttrs('rationID', rationItems);
  182. let stdRations = await stdRationModel.find({ ID: { $in: rationIds }, $or: [{ isDeleted: null }, { isDeleted: false }] });
  183. let stdRationIndex = {};
  184. for (let stdRation of stdRations) {
  185. stdRationIndex[stdRation.ID] = stdRation;
  186. }
  187. //判断定额完整性
  188. if (!rationAllExist(rationItems, stdRationIndex)) {
  189. //建定额链, 排序后再清除不存在的定额,保证顺序正确性
  190. rationItems = chainToArr(rationItems);
  191. //清除已被删除的定额
  192. let removeIds = [];
  193. _.remove(rationItems, function (item) {
  194. if (!stdRationIndex[item.rationID]) {
  195. removeIds.push(item.ID);
  196. return true;
  197. }
  198. return false;
  199. });
  200. _.remove(items, function (item) {
  201. return removeIds.includes(item.ID);
  202. });
  203. await billsGuideItemsModel.remove({ ID: { $in: removeIds } });
  204. //重组树结构
  205. let bulkArr = [];
  206. for (let i = 0, len = rationItems.length; i < len; i++) {
  207. rationItems[i].NextSiblingID = rationItems[i + 1] ? rationItems[i + 1].ID : -1;
  208. bulkArr.push({ updateOne: { filter: { ID: rationItems[i].ID }, update: { $set: { NextSiblingID: rationItems[i].NextSiblingID } } } });
  209. }
  210. await billsGuideItemsModel.bulkWrite(bulkArr);
  211. }
  212. return items;
  213. }
  214. async function updateItems(updateDatas) {
  215. let bulkArr = [];
  216. for (let updateData of updateDatas) {
  217. if (updateData.updateType === 'create') {
  218. bulkArr.push({ insertOne: { document: updateData.updateData } });
  219. }
  220. else if (updateData.updateType === 'update') {
  221. bulkArr.push({ updateOne: { filter: updateData.findData, update: { $set: updateData.updateData } } });
  222. }
  223. else {
  224. bulkArr.push({ deleteOne: { filter: updateData.findData } });
  225. }
  226. }
  227. if (bulkArr.length > 0) {
  228. await billsGuideItemsModel.bulkWrite(bulkArr);
  229. }
  230. }
  231. async function testItems(libID) {
  232. let items = await billsGuideItemsModel.find({ libID: libID });
  233. //删除垃圾数据
  234. let delBulk = [];
  235. let itemsMapping = {};
  236. for (let item of items) {
  237. itemsMapping[item.ID] = true;
  238. }
  239. for (let item of items) {
  240. if (item.ParentID != -1 && !itemsMapping[item.ParentID]) {
  241. delBulk.push({
  242. deleteOne: {
  243. filter: { ID: item.ID }
  244. }
  245. });
  246. }
  247. }
  248. if (delBulk.length > 0) {
  249. console.log(`delBulk.length`);
  250. console.log(delBulk.length);
  251. await billsGuideItemsModel.bulkWrite(delBulk);
  252. }
  253. /* //查找同层节点含有相同NextSiblingID的节点
  254. let rst = [];
  255. let billsGroup = {};
  256. for(let item of items){
  257. if(!billsGroup[item.billsID]){
  258. billsGroup[item.billsID] = [item];
  259. }
  260. else {
  261. billsGroup[item.billsID].push(item);
  262. }
  263. }
  264. for(let bGroup in billsGroup){
  265. let group = billsGroup[bGroup];
  266. let parentGroup = {};
  267. for(let gItem of group){
  268. if(!parentGroup[gItem.ParentID]){
  269. parentGroup[gItem.ParentID] = [gItem]
  270. }
  271. else {
  272. parentGroup[gItem.ParentID].push(gItem);
  273. }
  274. }
  275. for(let pGroup in parentGroup){
  276. let pGroupData = parentGroup[pGroup];
  277. let nextGroup = {};
  278. for(let nItem of pGroupData){
  279. let sameNext = _.filter(pGroupData, {NextSiblingID: nItem.NextSiblingID});
  280. if(sameNext.length > 1){
  281. console.log(`sameNext`);
  282. console.log(sameNext);
  283. if(!nextGroup[nItem.ParentID + nItem.NextSiblingID]){
  284. rst.push({NextSiblingID: nItem.NextSiblingID, ParentID: nItem.ParentID});
  285. nextGroup[nItem.ParentID + nItem.NextSiblingID] = 1;
  286. }
  287. }
  288. }
  289. }
  290. }*/
  291. return delBulk.length;
  292. }