facades.js 10 KB

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