facades.js 11 KB

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