pm_facade.js 57 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354
  1. /**
  2. * Created by zhang on 2018/4/17.
  3. */
  4. const projectType = {
  5. folder: 'Folder',
  6. tender: 'Tender',
  7. project: 'Project',
  8. engineering: 'Engineering',
  9. };
  10. //先导出后require可以解决循环引用问题
  11. module.exports={
  12. moveProject:moveProject,
  13. copyProject:copyProject,
  14. copyExample: copyExample,
  15. getSummaryInfo: getSummaryInfo,
  16. getSummaryInfoByTender: getSummaryInfoByTender,
  17. getTendersFeeInfo: getTendersFeeInfo,
  18. getConstructionProject: getConstructionProject,
  19. getFullPath: getFullPath,
  20. getProjectFeature:getProjectFeature,
  21. getProgressiveInterval: getProgressiveInterval,
  22. projectType: projectType,
  23. getPosterityProjects: getPosterityProjects,
  24. isShare: isShare,
  25. isFirst: isFirst,
  26. getShareInfo: getShareInfo,
  27. prepareInitialData: prepareInitialData,
  28. changeFile:changeFile,
  29. copyForSectionError: copyForSectionError,
  30. exportProject:exportProject,
  31. importProject:importProject
  32. };
  33. let mongoose = require('mongoose');
  34. let _ = require("lodash");
  35. let feeRate_facade = require('../../fee_rates/facade/fee_rates_facade');
  36. let glj_facade = require('../../glj/facade/glj_facade');
  37. let project_facade = require('../../main/facade/project_facade');
  38. let logger = require("../../../logs/log_helper").logger;
  39. const uuidV1 = require('uuid/v1');
  40. let projectModel = mongoose.model('projects');
  41. let projectSettingModel = mongoose.model('proj_setting');
  42. let billsModel = mongoose.model('bills');
  43. let rationModel = mongoose.model('ration');
  44. let gljListModel = mongoose.model("glj_list");
  45. let calcProgramsModel = mongoose.model('calc_programs');
  46. let labourCoesModel = mongoose.model('labour_coes');
  47. let feeRateModel = mongoose.model('fee_rates');
  48. let feeRateFileModel = mongoose.model('fee_rate_file');
  49. let unitPriceFileModel = mongoose.model("unit_price_file");
  50. let mixRatioModel = mongoose.model("mix_ratio");
  51. let freightModel = mongoose.model("freight_calc");
  52. let originalModel = mongoose.model("original_calc");
  53. let unitPriceModel = mongoose.model("unit_price");
  54. let installationFeeModel = mongoose.model("installation_fee");
  55. let rationGLJModel = mongoose.model('ration_glj');
  56. let rationCoeModel = mongoose.model('ration_coe');
  57. let rationInstallationModel = mongoose.model('ration_installation');
  58. let quantityDetailModel = mongoose.model('quantity_detail');
  59. let rationTemplateModel = mongoose.model('ration_template');
  60. let userModel = mongoose.model('user');
  61. let compleGljSectionModel = mongoose.model('complementary_glj_section');
  62. let compleGljSectionTModel = mongoose.model('complementary_glj_section_templates');
  63. let progressiveModel = mongoose.model('std_progressive_lib');
  64. let featureLibModel = mongoose.model("std_project_feature_lib");
  65. let scMathUtil = require('../../../public/scMathUtil').getUtil();
  66. let counter = require('../../../public/counter/counter');
  67. import SectionTreeDao from '../../complementary_ration_lib/models/sectionTreeModel';
  68. let sectionTreeDao = new SectionTreeDao();
  69. import CounterModel from "../../glj/models/counter_model";
  70. import moment from 'moment';
  71. import billsFlags from '../../common/const/bills_fixed';
  72. const notDeleted = [{deleteInfo: null}, {'deleteInfo.deleted': false}];
  73. let cipher = require('../../../public/cipher');
  74. //拷贝例题项目
  75. //@param {String}userID {Array}projIDs拷贝的例题项目ID(建设项目、文件夹)@return {Boolean}
  76. async function copyExample(userID, compilation, projIDs){
  77. let allProjs = [],
  78. IDMapping = {},
  79. projMapping = {};
  80. //例题项目不可为单项工程、单位工程、只能是建设项目、文件夹,否则不自动新建例题项目(这里不报错,让用户没有感觉)
  81. let parentExample = await projectModel.find({ID: {$in: projIDs}, $or: notDeleted});
  82. if (parentExample.length === 0) {
  83. return false;
  84. }
  85. allProjs = allProjs.concat(parentExample);
  86. for (let i = 0; i < parentExample.length; i++) {
  87. let data = parentExample[i];
  88. if (data.projType === projectType.tender || data.projType === projectType.engineering) {
  89. return false;
  90. }
  91. //设置成顶节点,最后一个节点设置成末节
  92. data.ParentID = -1;
  93. if (i === parentExample.length - 1) {
  94. data.NextSiblingID = -1;
  95. }
  96. }
  97. //获取所有的子项目
  98. let posterityProjs = await getPosterityProjects(projIDs);
  99. allProjs = allProjs.concat(posterityProjs);
  100. let projCounter = await counter.counterDAO.getIDAfterCountSync(counter.moduleName.project, allProjs.length);
  101. //旧ID与新ID映射
  102. for (let i = 0; i < allProjs.length; i++) {
  103. let data = allProjs[i];
  104. let newID = projCounter.sequence_value - (allProjs.length - 1) + i;
  105. IDMapping[data.ID] = newID;
  106. projMapping[newID] = data;
  107. }
  108. //return;
  109. //设置新的树结构数据
  110. let newDate = new Date(),
  111. parentBulks = [];
  112. for (let data of allProjs) {
  113. let orgID = data.ID;
  114. data.ID = IDMapping[data.ID];
  115. data.ParentID = IDMapping[data.ParentID] ? IDMapping[data.ParentID] : -1;
  116. data.NextSiblingID = IDMapping[data.NextSiblingID] ? IDMapping[data.NextSiblingID] : -1;
  117. data.createDateTime = newDate;
  118. data.userID = userID;
  119. data.compilation = compilation;
  120. data.shareInfo = [];
  121. if (data.projType !== projectType.tender) {
  122. let newData = _.cloneDeep(data._doc);
  123. delete newData._id;
  124. // await projectModel.create(newData);
  125. parentBulks.push({insertOne: {document: newData}});
  126. } else {
  127. //拷贝单位工程
  128. let rootProjectID = projMapping[data.ParentID].ParentID;
  129. let projectMap = {
  130. copy: {
  131. document: {userID: userID, ID: orgID, NextSiblingID: data.NextSiblingID, ParentID: data.ParentID, name: data.name, shareInfo: [],
  132. compilation: compilation, fileVer: data.fileVer, projType: data.projType, property: {rootProjectID: rootProjectID}}
  133. }
  134. };
  135. await copyProject(userID, compilation, {projectMap}, data.ID);
  136. }
  137. }
  138. //最末顶层项目(兼容测试时已存在有项目,正常用户第一次进费用定额,该费用定额不存在项目)
  139. let lastProj = await projectModel.findOne({userID: userID, compilation: compilation, ParentID: -1, NextSiblingID: -1, $or: notDeleted});
  140. if (lastProj) {
  141. parentBulks.push({updateOne: {filter: {ID: lastProj.ID}, update: {$set: {NextSiblingID: parentExample[0].ID}}}});
  142. }
  143. //拷贝父级文件
  144. await projectModel.bulkWrite(parentBulks);
  145. return true;
  146. }
  147. async function copyProject(userID, compilationID,data,newProjectID = null) {
  148. let projectMap = data.projectMap;
  149. let originalID = projectMap['copy'].document.ID;
  150. if (!newProjectID) {
  151. newProjectID = await getCounterID("projects");
  152. }
  153. let newFeeName = null,newUnitName = null;
  154. let calcProgramFileID = uuidV1();//新的计算程序文件ID
  155. let labourCoeFileID = uuidV1();//新的人工调整系数文件ID
  156. let feeRateFileID = uuidV1();//新的费率文件ID
  157. let unitPriceFileID = await getCounterID("unit_price_file");//新的单价文件ID
  158. let originalProject = await projectModel.findOne({'ID':originalID});//查找最新的那项目信息,前端缓存的数据有可能不是最新的
  159. if(!originalProject){
  160. throw new Error('没有找到对应的项目,复制失败!');
  161. }
  162. let property = originalProject.property;
  163. if(projectMap['copy'].document.property){//更新项目属性信息
  164. setProperty(property,projectMap['copy'].document.property);
  165. }
  166. let originalProperty = _.cloneDeep(property);
  167. projectMap['copy'].document.property = property;
  168. logger.info("复制项目: 旧项目ID: "+originalID+ " ------- 新项目ID: "+newProjectID);
  169. //费率文件、单价文件重名检查
  170. let feeRate = await feeRateFileModel.findOne({rootProjectID:originalProperty.rootProjectID,name:originalProperty.feeFile.name,deleteInfo:null});
  171. if(feeRate){//存在重名的文件
  172. newFeeName = originalProperty.feeFile.name + '(' + moment(Date.now()).format('MM-DD HH:mm:ss') + '复制)';
  173. projectMap['copy'].document.property.feeFile.name = newFeeName;
  174. }
  175. let unitPriceFile = await unitPriceFileModel.findOne({root_project_id: originalProperty.rootProjectID,name:originalProperty.unitPriceFile.name,deleteInfo: null});
  176. if(unitPriceFile){//存在重名的文件
  177. newUnitName = originalProperty.unitPriceFile.name + '(' + moment(Date.now()).format('MM-DD HH:mm:ss') + '复制)';
  178. projectMap['copy'].document.property.unitPriceFile.name = newUnitName;
  179. }
  180. //更新项目的属性;
  181. projectMap['copy'].document.ID = newProjectID;
  182. if(projectMap['copy'].document.property.calcProgramFile){
  183. projectMap['copy'].document.property.calcProgramFile.ID = calcProgramFileID;
  184. }
  185. if(projectMap['copy'].document.property.labourCoeFile){
  186. projectMap['copy'].document.property.labourCoeFile.ID = labourCoeFileID;
  187. }
  188. if(projectMap['copy'].document.property.feeFile){
  189. projectMap['copy'].document.property.feeFile.id = feeRateFileID;
  190. }
  191. if(projectMap['copy'].document.property.unitPriceFile){
  192. projectMap['copy'].document.property.unitPriceFile.id = unitPriceFileID;
  193. }
  194. projectMap['copy'].document.userID = userID;
  195. projectMap['copy'].document.compilation = compilationID;
  196. projectMap['copy'].document.createDateTime = new Date();
  197. //清单、定额ID生成任务
  198. let IDtasks = [
  199. createIDsAndReturn(originalID,billsModel),
  200. createIDsAndReturn(originalID,rationModel),
  201. getProjectGLJIDAndReturn(originalID,newProjectID)
  202. ];
  203. let [billMap,rationMap,projectGLJMap] = await Promise.all(IDtasks);
  204. //所有复制任务异步处理,提升效率 复制清单,定额,4个文件,项目工料机, 定额工料机,人工系数,工程量明细,定额安装增加费,安装增加费
  205. let copyTasks = [
  206. createProject(projectMap),
  207. copyProjectSetting(originalID,newProjectID),
  208. copyBills(newProjectID,billMap),
  209. copyRations(newProjectID,billMap.uuidMaping,rationMap,projectGLJMap.IDMap),
  210. copyProjectGLJ(projectGLJMap.datas),
  211. copyInstallFee(originalID,newProjectID),
  212. copyRationSubList(originalID,newProjectID,billMap.uuidMaping,rationMap.uuidMaping,projectGLJMap.IDMap,rationGLJModel),
  213. copyRationSubList(originalID,newProjectID,billMap.uuidMaping,rationMap.uuidMaping,projectGLJMap.IDMap,rationCoeModel),
  214. copyRationSubList(originalID,newProjectID,billMap.uuidMaping,rationMap.uuidMaping,projectGLJMap.IDMap,quantityDetailModel),
  215. copyRationSubList(originalID,newProjectID,billMap.uuidMaping,rationMap.uuidMaping,projectGLJMap.IDMap,rationInstallationModel),
  216. copyRationSubList(originalID,newProjectID,billMap.uuidMaping,rationMap.uuidMaping,projectGLJMap.IDMap,rationTemplateModel)
  217. ];
  218. if(originalProperty.calcProgramFile){
  219. copyTasks.push(commonCopy(newProjectID,originalProperty.calcProgramFile.ID,calcProgramFileID,calcProgramsModel));
  220. }
  221. if(originalProperty.labourCoeFile){
  222. copyTasks.push(commonCopy(newProjectID,originalProperty.labourCoeFile.ID,labourCoeFileID,labourCoesModel));
  223. }
  224. if(originalProperty.feeFile){
  225. copyTasks.push(copyFeeRate(originalProperty.rootProjectID,userID,originalProperty.feeFile.id,feeRateFileID,newFeeName));
  226. }
  227. if(originalProperty.unitPriceFile){
  228. copyTasks.push(copyUnitPriceFile(newProjectID,originalProperty.rootProjectID,userID,originalProperty.unitPriceFile.id,unitPriceFileID,newUnitName));
  229. }
  230. let p = await Promise.all(copyTasks);
  231. return p[0];
  232. }
  233. async function createIDsAndReturn(originalID,model) {
  234. let uuidMaping = {};//做ID映射
  235. let datas = [];
  236. let result = await model.find({"projectID": originalID}, '-_id');
  237. uuidMaping['-1'] = -1;
  238. //建立uuid-ID映射
  239. for(let d of result){
  240. uuidMaping[d.ID] = uuidV1();
  241. datas.push(d._doc);
  242. }
  243. return{uuidMaping:uuidMaping,datas:datas};
  244. }
  245. async function getProjectGLJIDAndReturn(originalID,newProjectID) {
  246. let IDMap = {};
  247. let datas = [];
  248. let result = await gljListModel.find({project_id:originalID}, '-_id');
  249. let gljCount = await counter.counterDAO.getIDAfterCountSync(counter.moduleName.glj_list, result.length);
  250. for(let i = 0; i < result.length; i++){
  251. let d = result[i];
  252. let newID = gljCount.sequence_value - (result.length - 1) + i;
  253. //let newID = await getCounterID("glj_list");
  254. IDMap[d.id] = newID;
  255. d._doc.project_id = newProjectID;
  256. d._doc.id = newID;
  257. datas.push(d._doc);
  258. }
  259. return{IDMap:IDMap,datas:datas};
  260. }
  261. async function createProject(projectMap) {//复制项目
  262. let tasks = [];
  263. if(projectMap['update']){//如果复制后存在前一个节点,则更新其NextSiblingID
  264. tasks.push({updateOne:{filter : projectMap['update'].query, update : {NextSiblingID:projectMap['copy'].document.ID}}});
  265. }
  266. tasks.push({insertOne: {document: projectMap['copy'].document}});//复制任务
  267. await projectModel.bulkWrite(tasks);
  268. return projectMap;
  269. }
  270. async function copyProjectSetting(originalID,newProjectID) {
  271. let result = null;
  272. let setting = await projectSettingModel.findOne({"projectID": originalID}, '-_id');
  273. if(setting){
  274. setting._doc.projectID =newProjectID;
  275. result = await projectSettingModel.create(setting._doc);
  276. }
  277. return result;
  278. }
  279. async function copyBills(newProjectID,billMap) {
  280. let uuidMaping = billMap.uuidMaping;//做ID映射
  281. for(let doc of billMap.datas){
  282. doc = getCopyBillDatas(doc,newProjectID,uuidMaping)
  283. }
  284. await insertMany(billMap.datas,billsModel);
  285. return billMap.datas;
  286. }
  287. function getCopyBillDatas(doc,newProjectID,uuidMaping) {
  288. doc.projectID = newProjectID;
  289. doc.ID = uuidMaping[doc.ID] ? uuidMaping[doc.ID] : -1;
  290. doc.ParentID = uuidMaping[doc.ParentID] ? uuidMaping[doc.ParentID] : -1;
  291. doc.NextSiblingID = uuidMaping[doc.NextSiblingID] ? uuidMaping[doc.NextSiblingID] : -1;
  292. //对于有基数计算的节点,需要替换计算基数中引用的ID为新的ID
  293. if(doc.calcBase && doc.calcBase != ""){
  294. let idArr = scMathUtil.getFIDArr(doc.calcBase);
  295. for(let re of idArr){
  296. let oID = re.substr(1);//去掉开头的@字符
  297. if(!uuidMaping[oID]) continue;
  298. doc.calcBase = doc.calcBase.replace(new RegExp(oID, "g"),uuidMaping[oID]);
  299. }
  300. }
  301. return doc;
  302. }
  303. async function copyRations(newProjectID,billsIDMap,rationMap,projectGLJIDMap) {
  304. let uuidMaping = rationMap.uuidMaping;
  305. for(let doc of rationMap.datas){
  306. doc = getCopyRationData(doc,newProjectID,billsIDMap,uuidMaping,projectGLJIDMap);
  307. }
  308. if(rationMap.datas.length > 0){
  309. await insertMany(rationMap.datas,rationModel);
  310. }
  311. return rationMap.datas;
  312. }
  313. function getCopyRationData(doc,newProjectID,billsIDMap,uuidMaping,projectGLJIDMap){
  314. doc.projectID = newProjectID;
  315. doc.ID = uuidMaping[doc.ID] ? uuidMaping[doc.ID] : -1;
  316. if(doc.billsItemID){
  317. doc.billsItemID = billsIDMap[doc.billsItemID]?billsIDMap[doc.billsItemID]:-1;
  318. }
  319. if(doc.referenceRationID) doc.referenceRationID = uuidMaping[doc.referenceRationID]?uuidMaping[doc.referenceRationID]:undefined;
  320. //绑定定类型的工料机 项目工料机ID
  321. doc.type==3&&doc.projectGLJID&&projectGLJIDMap[doc.projectGLJID]?doc.projectGLJID = projectGLJIDMap[doc.projectGLJID]:'';
  322. return doc;
  323. }
  324. async function copyProjectGLJ(gljList) {
  325. await insertMany(gljList,gljListModel);
  326. }
  327. async function commonCopy(newProjectID,oldID,newID,model) { //对于只需更新ID和projectID的文件的复制
  328. let result = null;
  329. let file = await model.findOne({"ID": oldID}, '-_id');
  330. if(file){
  331. file._doc.ID = newID;
  332. file._doc.projectID =newProjectID;
  333. result = await model.create(file._doc);
  334. }
  335. return result;
  336. }
  337. async function copyFeeRate(rootProjectID,userID,originalFeeRateFileID,feeRateFileID,newName) {//复制费率和费率文件
  338. let [feeRateFile,feeRate] =await feeRate_facade.getFeeRateByID(originalFeeRateFileID);
  339. let newFeeRateID = uuidV1();
  340. if(feeRate){
  341. feeRate._doc.ID = newFeeRateID;
  342. await feeRateModel.create(feeRate._doc);
  343. }
  344. if(feeRateFile){
  345. feeRateFile._doc.ID = feeRateFileID;
  346. newName?feeRateFile._doc.name = newName:'';
  347. feeRateFile._doc.userID = userID;
  348. feeRateFile._doc.rootProjectID = rootProjectID;
  349. feeRateFile._doc.feeRateID = newFeeRateID;
  350. await feeRateFileModel.create(feeRateFile._doc);
  351. }
  352. }
  353. async function copyUnitPriceFile(newProjectID,rootProjectID,userID,originaluUnitPriceFileID,unitPriceFileID,newName) {//复制单价文件、组成物
  354. let taskList = [
  355. copyFile(newProjectID,rootProjectID,userID,originaluUnitPriceFileID,unitPriceFileID,newName),
  356. copySubList(originaluUnitPriceFileID,unitPriceFileID,mixRatioModel),
  357. copySubList(originaluUnitPriceFileID,unitPriceFileID,freightModel,true),
  358. copySubList(originaluUnitPriceFileID,unitPriceFileID,originalModel,true),
  359. copySubList(originaluUnitPriceFileID,unitPriceFileID,unitPriceModel)
  360. ];
  361. return await Promise.all(taskList);
  362. async function copyFile(newProjectID,rootProjectID,userID,originaluUnitPriceFileID,unitPriceFileID,newName){
  363. let unitPriceFile = await unitPriceFileModel.findOne({id:originaluUnitPriceFileID}, '-_id');
  364. if(unitPriceFile){
  365. unitPriceFile._doc.id = unitPriceFileID;
  366. newName?unitPriceFile._doc.name = newName:'';
  367. unitPriceFile._doc.project_id = newProjectID;
  368. unitPriceFile._doc.user_id = userID;
  369. unitPriceFile._doc.root_project_id = rootProjectID
  370. }
  371. await unitPriceFileModel.create(unitPriceFile._doc);
  372. }
  373. async function copySubList(srcFID,newFID,model,UUID=false) {
  374. let mList = await model.find({unit_price_file_id: srcFID}, '-_id');
  375. let rList = [];
  376. for(let m of mList){
  377. m._doc.unit_price_file_id = newFID;
  378. UUID == true?m._doc.ID = uuidV1():m._doc.id = await getCounterID(model.modelName);
  379. rList.push(m._doc);
  380. }
  381. await insertMany(rList,model)
  382. }
  383. }
  384. async function copyInstallFee(originalPID,newProjectID) {
  385. let result = null;
  386. let installationFee = await installationFeeModel.find({projectID:originalPID}, '-_id');
  387. let newList = [];
  388. for(let i of installationFee ){
  389. i._doc.ID = uuidV1();
  390. i._doc.projectID = newProjectID;
  391. newList.push(i._doc);
  392. }
  393. if(newList.length >0){
  394. result = await installationFeeModel.insertMany(newList);
  395. }
  396. return result;
  397. }
  398. async function copyRationSubList(originalPID,newProjectID,billIDMap,rationIDMap,projectGLJIDMap,model) {// 定额工料机,附注条件,工程量明细,定额安装增加费
  399. let subList = await model.find({projectID:originalPID}, '-_id');
  400. let newList =[];
  401. for(let s of subList){
  402. s._doc = getCopyRationSubData(s._doc,newProjectID,billIDMap,rationIDMap,projectGLJIDMap);
  403. /* s._doc.ID = uuidV1();
  404. s._doc.projectID = newProjectID;
  405. s._doc.rationID&&rationIDMap[s._doc.rationID]?s._doc.rationID = rationIDMap[s._doc.rationID]:'';
  406. s._doc.billID&&billIDMap[s._doc.billID]?s._doc.billID = billIDMap[s._doc.billID]:'';
  407. s._doc.billsItemID&&billIDMap[s._doc.billsItemID]?s._doc.billsItemID = billIDMap[s._doc.billsItemID]:'';
  408. s._doc.projectGLJID&&projectGLJIDMap[s._doc.projectGLJID]?s._doc.projectGLJID = projectGLJIDMap[s._doc.projectGLJID]:'';
  409. if(s._doc.templateList && s._doc.templateList.length > 0 ){
  410. for(let t of s._doc.templateList){
  411. if(t.billID && billIDMap[t.billID]) t.billID = billIDMap[t.billID];
  412. if(t.fxID && billIDMap[t.fxID]) t.fxID = billIDMap[t.fxID];
  413. }
  414. }*/
  415. newList.push(s._doc);
  416. }
  417. await insertMany(newList,model);
  418. }
  419. function getCopyRationSubData(doc,newProjectID,billIDMap,rationIDMap,projectGLJIDMap){
  420. doc.ID = uuidV1();
  421. doc.projectID = newProjectID;
  422. doc.rationID&&rationIDMap[doc.rationID]?doc.rationID = rationIDMap[doc.rationID]:'';
  423. doc.billID&&billIDMap[doc.billID]?doc.billID = billIDMap[doc.billID]:'';
  424. doc.billsItemID&&billIDMap[doc.billsItemID]?doc.billsItemID = billIDMap[doc.billsItemID]:'';
  425. doc.projectGLJID&&projectGLJIDMap[doc.projectGLJID]?doc.projectGLJID = projectGLJIDMap[doc.projectGLJID]:'';
  426. if(doc.templateList && doc.templateList.length > 0 ){
  427. for(let t of doc.templateList){
  428. if(t.billID && billIDMap[t.billID]) t.billID = billIDMap[t.billID];
  429. if(t.fxID && billIDMap[t.fxID]) t.fxID = billIDMap[t.fxID];
  430. }
  431. }
  432. return doc;
  433. }
  434. async function moveProject(data) {
  435. data = JSON.parse(data);
  436. let projectMap = data.projectMap,feeRateMap = data.feeRateMap,unitPriceMap = data.unitPriceMap;
  437. let projectTasks = [],feeRateTask=[],feeRateFileTask=[],unitPriceTask=[],unitPriceFileTask=[],mixRatioTask=[];
  438. let feeUniqMap=[],priceUniqMap={};//费率、单价文件唯一映射表当移动多个项目时,任务有可能出现重复的情况
  439. if(!_.isEmpty(feeRateMap)&&data.rootProjectID){//如果费率有修改
  440. let feeRates =await feeRate_facade.getFeeRatesByProject(data.rootProjectID);//取目标建设项目的所有费率文件,重名检查
  441. for(let projectID in feeRateMap){
  442. let rename = feeRateMap[projectID].name;
  443. let feeRateID = feeRateMap[projectID].query.ID;
  444. let checkFee = _.find(feeRates,{'name':rename});
  445. let newID = feeRateID;
  446. if(checkFee){//说明费率名字已存在,需要重命名
  447. rename = feeUniqMap[feeRateID]?feeUniqMap[feeRateID].name:rename + '(' + new Date().Format('MM-dd hh:mm:ss') + '移动)';
  448. projectMap[projectID]['update']['property.feeFile.name'] = rename;
  449. if(feeRateMap[projectID].action == 'move'){
  450. feeRateMap[projectID].update.name = rename;
  451. }
  452. }
  453. if(feeRateMap[projectID].action == 'copy'){
  454. newID = feeUniqMap[feeRateID]?feeUniqMap[feeRateID].ID:uuidV1();
  455. feeRateMap[projectID].name = rename;
  456. feeRateMap[projectID].ID = newID;
  457. projectMap[projectID]['update']['property.feeFile.id'] = newID;
  458. }
  459. if(!feeUniqMap[feeRateID]){
  460. await generateFeeRateTask(feeRateMap[projectID],feeRateTask,feeRateFileTask);
  461. feeUniqMap[feeRateID] = {name:rename,ID:newID};
  462. }
  463. }
  464. }
  465. if(!_.isEmpty(unitPriceMap)&&data.rootProjectID) {//如果单价文件有修改
  466. let unitPriceFiles = await unitPriceFileModel.find({root_project_id: data.rootProjectID, deleteInfo: null});
  467. for(let projectID in unitPriceMap){
  468. let checkUn = _.find(unitPriceFiles,{'name':unitPriceMap[projectID].name});
  469. let rename = unitPriceMap[projectID].name;
  470. let unitPriceID = unitPriceMap[projectID].query.id;
  471. let newID = unitPriceID;
  472. if(checkUn){//重名检查
  473. rename = priceUniqMap[unitPriceID]?priceUniqMap[unitPriceID].name:rename + '(' + new Date().Format('MM-dd hh:mm:ss') + '移动)';
  474. projectMap[projectID]['update']['property.unitPriceFile.name'] = rename;
  475. if(unitPriceMap[projectID].action =='move'){
  476. unitPriceMap[projectID].update.name = rename;
  477. }
  478. }
  479. if(unitPriceMap[projectID].action =='copy'){
  480. newID = priceUniqMap[unitPriceID]?priceUniqMap[unitPriceID].id: await getCounterID("unit_price_file");
  481. unitPriceMap[projectID].name = rename;
  482. unitPriceMap[projectID].id = newID;
  483. projectMap[projectID]['update']['property.unitPriceFile.id'] = newID;
  484. }
  485. if(!priceUniqMap[unitPriceID]){
  486. await generateUnitPriceTask(unitPriceMap[projectID],projectID,data.user_id,unitPriceTask,unitPriceFileTask,mixRatioTask);
  487. priceUniqMap[unitPriceID] = {name:rename,id:newID};
  488. }
  489. }
  490. }
  491. if(!_.isEmpty(projectMap)){
  492. for(let projectID in projectMap){
  493. projectTasks.push({updateOne:{filter : projectMap[projectID].query, update : projectMap[projectID].update}});
  494. }
  495. }
  496. projectTasks.length>0?await projectModel.bulkWrite(projectTasks):'';
  497. feeRateTask.length>0?await feeRateModel.bulkWrite(feeRateTask):'';
  498. feeRateFileTask.length>0?await feeRateFileModel.bulkWrite(feeRateFileTask):'';
  499. unitPriceFileTask.length>0?await unitPriceFileModel.bulkWrite(unitPriceFileTask):'';
  500. unitPriceTask.length>0?await insertMany(unitPriceTask,unitPriceModel):'';
  501. mixRatioTask.length>0?await insertMany(mixRatioTask,mixRatioModel):'';
  502. return projectMap;
  503. }
  504. async function generateFeeRateTask(data,feeRateTask,feeRateFileTask) {
  505. if(data.action == 'move'){
  506. let task = {
  507. updateOne:{
  508. filter : data.query,
  509. update : data.update
  510. }
  511. };
  512. feeRateFileTask.push(task);
  513. }
  514. if(data.action == 'copy'){//copy 费率的时候用insertOne方法
  515. let [feeRateFile,feeRate] =await feeRate_facade.getFeeRateByID(data.query.ID);
  516. let newFeeRateID = uuidV1();
  517. let newFeeRate = {
  518. ID:newFeeRateID,
  519. rates:feeRate.rates
  520. };
  521. let newFeeRateFile = {
  522. ID:data.ID,
  523. rootProjectID:data.rootProjectID,
  524. userID:feeRateFile.userID,
  525. name:data.name,
  526. libID:feeRateFile.libID,
  527. libName:feeRateFile.libName,
  528. feeRateID:newFeeRateID
  529. };
  530. feeRateTask.push({insertOne :{document:newFeeRate}});
  531. feeRateFileTask.push({insertOne :{document:newFeeRateFile}});
  532. }
  533. }
  534. async function generateUnitPriceTask(data,projectID,user_id,unitPriceTask,unitPriceFileTask,mixRatioTask){
  535. if(data.action == 'move'){
  536. let task = {
  537. updateOne:{
  538. filter : data.query,
  539. update : data.update
  540. }
  541. };
  542. unitPriceFileTask.push(task);
  543. }
  544. if(data.action == 'copy'){
  545. let newUnitFile = {
  546. id:data.id,
  547. name: data.name,
  548. project_id:projectID,
  549. user_id:user_id,
  550. root_project_id: data.rootProjectID
  551. };
  552. unitPriceFileTask.push({insertOne :{document:newUnitFile}});
  553. let mixRatios = await mixRatioModel.find({unit_price_file_id: data.query.id});
  554. mixRatios = JSON.stringify(mixRatios);
  555. mixRatios = JSON.parse(mixRatios);
  556. for(let m of mixRatios){
  557. delete m._id; // 删除原有id信息
  558. delete m.id;
  559. m.unit_price_file_id = data.id;
  560. m.id = await getCounterID('mix_ratio');
  561. mixRatioTask.push(m);
  562. }
  563. let unitPrices = await unitPriceModel.find({unit_price_file_id: data.query.id});//unit_price_file_id
  564. unitPrices = JSON.stringify(unitPrices);
  565. unitPrices = JSON.parse(unitPrices);
  566. for(let u of unitPrices){
  567. delete u._id; // 删除原有id信息
  568. delete u.id;
  569. u.unit_price_file_id = data.id;
  570. u.id = await getCounterID('unit_price');
  571. unitPriceTask.push(u);
  572. }
  573. }
  574. }
  575. async function getCounterID(collectionName){
  576. let counterModel = new CounterModel();
  577. return await counterModel.getId(collectionName);
  578. }
  579. async function insertMany(datas,model) {
  580. while (datas.length>1000){//因为mongoose限制了批量插入的条数为1000.所以超出限制后需要分批插入
  581. let newList = datas.splice(0,1000);//一次插入1000条
  582. await model.insertMany(newList);
  583. }
  584. await model.insertMany(datas);
  585. }
  586. function setProperty(Obj,updateData) {
  587. for(let ukey in updateData){
  588. if(_.isObject(updateData[ukey]) && _.isObject(Obj[ukey])){
  589. setProperty(Obj[ukey],updateData[ukey]);
  590. }else {
  591. Obj[ukey] = updateData[ukey];
  592. }
  593. }
  594. }
  595. function isDef(v){
  596. return typeof v !== 'undefined' && v !== null;
  597. }
  598. function getCommonTotalFee(bills) {
  599. if(!isDef(bills)){
  600. return 0;
  601. }
  602. if(!isDef(bills.fees) || bills.fees.length <= 0){
  603. return 0;
  604. }
  605. for(let fee of bills.fees){
  606. if(isDef(fee.fieldName) && fee.fieldName === 'common'){
  607. return isDef(fee.totalFee) ? fee.totalFee : 0;
  608. }
  609. }
  610. return 0;
  611. }
  612. function summarizeToParent(parent, child) {
  613. const decimal = -2;
  614. let costFields = ['totalCost'];
  615. for (let field of costFields) {
  616. parent[field] = scMathUtil.roundTo(parseFloat(parent[field]) + parseFloat(child[field]), decimal);
  617. }
  618. }
  619. function getBuildingArea(projFeature){
  620. if(!projFeature || projFeature.length === 0){
  621. return null;
  622. }
  623. for(let f of projFeature){
  624. if(f.key === 'buildingArea'){
  625. return f.value;
  626. }
  627. }
  628. return null;
  629. }
  630. // 根据树结构数据排序
  631. function getSortedDataByTree(data) {
  632. // NextSiblingID-数据映射
  633. const mapping = {};
  634. data.forEach(item => {
  635. // 错误数据兼容处理
  636. // 由于之前的导入建设项目,会导致最后的一个项目的NextSiblingID为空,为非正确的-1
  637. // 因此把项目中NextSibling为空的数据设置为NextSiblingID为-1
  638. if (!item.NextSiblingID) {
  639. item.NextSiblingID = -1;
  640. }
  641. mapping[item.NextSiblingID] = item;
  642. });
  643. let lastItem = data.find(item => +item.NextSiblingID === -1);
  644. if (!lastItem) {
  645. return data;
  646. }
  647. const rst = [lastItem];
  648. let preItem = mapping[lastItem.ID];
  649. while (preItem) {
  650. rst.unshift(preItem);
  651. preItem = mapping[preItem.ID];
  652. }
  653. // 根据树结构排序形成的新数组与旧数组项数不同,说明树结构数据有问题(断链),则返回原本数据。
  654. return rst.length === data.length ? rst : data;
  655. }
  656. //根据单位工程ID获取汇总信息
  657. //@param {Number}tenderID {String}summaryType @return {Object}
  658. async function getSummaryInfoByTender(tenderID, summaryType) {
  659. const notDeleted = [{deleteInfo: null}, {'deleteInfo.deleted': false}];
  660. let tender = await projectModel.findOne({ID: tenderID, $or: notDeleted});
  661. let parentName;
  662. let summaryList = [];
  663. if(!tender){
  664. return null;
  665. }
  666. let project = await projectModel.findOne({ID: tender.ParentID, $or: notDeleted});
  667. if(!project){
  668. return null;
  669. }
  670. let summaryInfo = await getSummaryInfo([project.ID]);
  671. // 汇总到建设项目层(没有单项工程层了)
  672. if (summaryType === projectType.project) {
  673. parentName = project.name ? project.name : '';
  674. let tenders = await projectModel.find({ParentID: project.ID, $or: notDeleted}).lean();
  675. tenders = getSortedDataByTree(tenders);
  676. for(let t of tenders){
  677. if(summaryInfo[t.ID]){
  678. summaryInfo[t.ID]['name'] = t.name ? t.name : '';
  679. summaryList.push(summaryInfo[t.ID]);
  680. }
  681. }
  682. }
  683. return {parent: {name: parentName}, subList: summaryList};
  684. }
  685. //获取单位工程的各标段费用信息(不进行汇总)
  686. async function getTendersFeeInfo(tenders) {
  687. let IDMapping = {};
  688. //固定清单类别与汇总金额字段映射
  689. let flagFieldMapping = {};
  690. flagFieldMapping[billsFlags.TOTAL_COST] = 'totalCost';
  691. let tenderIDs = [];
  692. if(tenders.length > 0){
  693. for(let tender of tenders){
  694. tenderIDs.push(tender.ID);
  695. IDMapping[tender.ID] = {totalCost: 0};
  696. }
  697. //需要获取的清单固定类别综合合价:总造价
  698. let needFlags = [billsFlags.TOTAL_COST];
  699. //获取单位工程汇总金额需要用到的所有清单
  700. let allBills = await billsModel.find({projectID: {$in: tenderIDs}, 'flags.flag': {$in: needFlags}, $or: notDeleted},
  701. '-_id projectID fees flags');
  702. //进行单位工程级别的汇总
  703. for(let bills of allBills){
  704. let billsFlag = bills.flags[0]['flag'];
  705. let costField = flagFieldMapping[billsFlag];
  706. IDMapping[bills.projectID][costField] = getCommonTotalFee(bills);
  707. }
  708. }
  709. return IDMapping;
  710. }
  711. //@param {Array}projectIDs(建设项目ID) @return {Object}
  712. async function getSummaryInfo(projectIDs){
  713. //ID与汇总信息映射
  714. let IDMapping = {};
  715. //固定清单类别与汇总金额字段映射
  716. let flagFieldMapping = {};
  717. flagFieldMapping[billsFlags.TOTAL_COST] = 'totalCost';
  718. let projects = await projectModel.find({ID: {$in : projectIDs}, projType: projectType.project, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]});
  719. //设置建设项目的总建筑面积
  720. for(let project of projects){
  721. IDMapping[project.ID] = {totalCost: 0};
  722. }
  723. //单位工程
  724. let tenders = [];
  725. if(projectIDs.length > 0){
  726. tenders = await projectModel.find({ParentID: {$in : projectIDs}, projType: projectType.tender, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]});
  727. }
  728. let tenderIDs = [];
  729. if(tenders.length > 0){
  730. for(let tender of tenders){
  731. tenderIDs.push(tender.ID);
  732. IDMapping[tender.ID] = {totalCost: 0, changeMark:tender.changeMark,property:tender.property};//property:tender.property
  733. }
  734. //需要获取的清单固定类别综合合价:总造价
  735. let needFlags = [billsFlags.TOTAL_COST];
  736. //获取单位工程汇总金额需要用到的所有清单
  737. let allBills = await billsModel.find({projectID: {$in: tenderIDs}, 'flags.flag': {$in: needFlags}, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]},
  738. '-_id projectID fees flags');
  739. //进行单位工程级别的汇总
  740. for(let bills of allBills){
  741. let billsFlag = bills.flags[0]['flag'];
  742. let costField = flagFieldMapping[billsFlag];
  743. IDMapping[bills.projectID][costField] = getCommonTotalFee(bills);
  744. }
  745. //进行建设项目级别的汇总
  746. for(let tender of tenders){
  747. summarizeToParent(IDMapping[tender.ParentID], IDMapping[tender.ID]);
  748. }
  749. }
  750. return IDMapping;
  751. }
  752. //根据项目ID获取所属建设项目
  753. //@param {Number}projectID @return {Object}
  754. async function getConstructionProject(projectID){
  755. function returnProject(project){
  756. if(!project || project.projType === projectType.folder){
  757. return null;
  758. }
  759. if(project.projType === projectType.project){
  760. return project;
  761. }
  762. }
  763. let project = await projectModel.findOne({ID: projectID, $or: notDeleted});
  764. let returnV = returnProject(project);
  765. if(returnV !== undefined){
  766. return returnV;
  767. }
  768. let parent = await projectModel.findOne({ID: project.ParentID, $or: notDeleted});
  769. returnV = returnProject(parent);
  770. if(returnV !== undefined){
  771. return returnV;
  772. }
  773. let grandParent = await projectModel.findOne({ID: parent.ParentID, $or: notDeleted});
  774. returnV = returnProject(grandParent);
  775. return returnV !== undefined ? returnV : null;
  776. }
  777. //获取单位工程完整目录结构
  778. //@param {Number}projectID @return {Arry}
  779. async function getFullPath(projectID) {
  780. let fullPath = [];
  781. let project = await projectModel.findOne({ID: projectID, $or: notDeleted}, '-_id ParentID name');
  782. if(project){
  783. fullPath.push(project.name);
  784. await getParent(project.ParentID);
  785. }
  786. fullPath = fullPath.reverse();
  787. return fullPath;
  788. async function getParent(ParentID) {
  789. if(ParentID != -1){
  790. let parent = await projectModel.findOne({ID: ParentID, $or: notDeleted}, '-_id ParentID name');
  791. if(parent){
  792. fullPath.push(parent.name);
  793. await getParent(parent.ParentID);
  794. }
  795. }
  796. }
  797. }
  798. //@param {String}libID(工程特征库ID) {Object}assign(需要赋值的key-value)
  799. async function getProjectFeature(libID, assign) {
  800. let lib = await featureLibModel.findOne({'ID':libID});
  801. if (lib) {
  802. for (let key in assign) {
  803. let obj = _.find(lib.feature, {key: key});
  804. if (obj) {
  805. obj.value = assign[key];
  806. }
  807. }
  808. return lib.feature;
  809. } else {
  810. return [];
  811. }
  812. }
  813. //获取累进区间数据
  814. async function getProgressiveInterval(libID) {
  815. let lib = await progressiveModel.findOne({ID: libID});
  816. return lib ? lib.data : [];
  817. }
  818. //获取projectIDs文件下所有子项目(不包括projectIDs本身)
  819. async function getPosterityProjects(projectIDs) {
  820. let rst = [];
  821. async function getProjects(IDs) {
  822. if (IDs.length > 0) {
  823. let newIDs = [];
  824. let projs = await projectModel.find({ParentID: {$in: IDs}, $or: notDeleted}, '-_id');
  825. for (let proj of projs) {
  826. rst.push(proj);
  827. newIDs.push(proj.ID);
  828. }
  829. await getProjects(newIDs);
  830. }
  831. }
  832. await getProjects(projectIDs);
  833. return rst;
  834. }
  835. //根据项目获得分享信息(分享层级不一定在项目级)(以最新为准)
  836. //@param {String}userId {Object}tender @return {Object} || {null}
  837. async function getShareInfo(userId, project) {
  838. //与该用户相关的分享
  839. let shareList = [];
  840. while (project) {
  841. for(let shareData of project.shareInfo){
  842. if(shareData.userID === userId){
  843. shareList.push(shareData);
  844. break;
  845. }
  846. }
  847. project = await projectModel.findOne({ID: project.ParentID}, '-_id shareInfo ID ParentID');
  848. }
  849. //获取最新分享
  850. shareList.sort(function (a, b) {
  851. let aV = Date.parse(a.shareDate),
  852. bV = Date.parse(b.shareDate);
  853. if (aV > bV) {
  854. return -1;
  855. } else if (aV < bV) {
  856. return 1;
  857. }
  858. return 0;
  859. });
  860. return shareList[0] || null;
  861. }
  862. //打开的单位工程是否是被分享的.
  863. async function isShare(userId, project){
  864. //判断是否是打开分享的项目,属于分享文件的子项也算
  865. while (project) {
  866. for(let shareData of project.shareInfo){
  867. if(shareData.userID === userId){
  868. return true;
  869. }
  870. }
  871. project = await projectModel.findOne({ID: project.ParentID}, '-_id shareInfo ID ParentID');
  872. }
  873. return false;
  874. }
  875. //用户是否第一次进入费用定额
  876. async function isFirst(userId, compilationId) {
  877. let userData = await userModel.findOne({_id: mongoose.Types.ObjectId(userId)}, '-_id used_list');
  878. let isFirst = false;
  879. if (userData) {
  880. isFirst = !_.find(userData.used_list, function (o) {
  881. return o.compilationId === compilationId;
  882. });;
  883. }
  884. return isFirst;
  885. }
  886. //用户第一次进入费用定额的数据准备
  887. async function prepareInitialData(userId, compilation, example) {
  888. let first = await isFirst(userId, compilation);
  889. if (first) {
  890. await updateUsedList(userId, compilation);
  891. let prepareTask = [
  892. copyCompleRationSection(userId, compilation),
  893. copyCompleGljSection(userId, compilation)
  894. ];
  895. if (example && example.length > 0) {
  896. prepareTask.push(copyExample(userId, compilation, example));
  897. }
  898. await Promise.all(prepareTask);
  899. }
  900. }
  901. async function updateUsedList(userId, compilation) {
  902. await userModel.update({_id: mongoose.Types.ObjectId(userId)}, {$push: {used_list: {compilationId: compilation}}});
  903. }
  904. //拷贝补充定额章节树
  905. async function copyCompleRationSection(userId, compilationId) {
  906. await sectionTreeDao.copyDataFromTemplate(userId, compilationId);
  907. }
  908. /*
  909. * 解决问题:
  910. * 发布了编办之后,才设置了人材机库模板,导致已登录的用户不存在人材机库的分类树
  911. * 为该编办下,人材机分类模板为空的用户,拷贝模板数据
  912. * */
  913. async function copyForSectionError(compilation) {
  914. let users = await userModel.find({}, '_id');
  915. for (let user of users) {
  916. let userId = user._id.toString();
  917. let existCount = await compleGljSectionModel.find({userId}).count();
  918. if (existCount === 0) {
  919. await copyCompleGljSection(userId, compilation);
  920. }
  921. }
  922. }
  923. //拷贝补充人材机分类树
  924. async function copyCompleGljSection(userId, compilationId) {
  925. let templateData = await compleGljSectionTModel.find({compilationId: compilationId});
  926. if (templateData.length > 0) {
  927. let insertDatas = [],
  928. uuidMapping = {};
  929. //将ID替换成UUID
  930. for (let temData of templateData) {
  931. uuidMapping[temData.ID] = uuidV1();
  932. }
  933. for(let temData of templateData) {
  934. let insertD = {
  935. userId: userId,
  936. compilationId: compilationId,
  937. Name: temData.Name,
  938. ID: uuidMapping[temData.ID],
  939. ParentID: uuidMapping[temData.ParentID] || -1,
  940. NextSiblingID: uuidMapping[temData.NextSiblingID] || -1,
  941. };
  942. insertDatas.push(insertD);
  943. }
  944. //插入数据
  945. await compleGljSectionModel.insertMany(insertDatas);
  946. }
  947. }
  948. async function changeFile(datas,userID,fileID,name,from,type){//from 费率或单价文件,type从单前建设项目还是从其它建设项目中复制
  949. let projectIDs = [],newFile = {id:fileID,name:name};//计录从其它项目中复制的文件,选中多个的时候只需复制一次
  950. let projectUpdateType = from == "feeRateFile"?"feeRate":"unitFile";
  951. for(let d of datas){
  952. let tem_file = from == "feeRateFile"? await feeRate_facade.changeFeeRateFile(d, newFile,type,userID):await glj_facade.changeUnitFile(d, newFile,type,userID);
  953. if(type == 1 && tem_file){//从建设项目复制时,只有第一次需要复制,剩下的就相当于使用同个建设项目的情况了
  954. let newID = from == "feeRateFile"?tem_file.ID:tem_file.id;
  955. newFile = {id:newID,name:tem_file.name};
  956. type = 0;
  957. }
  958. projectIDs.push({ID:d.projectID})
  959. }
  960. await project_facade.markProjectsToChange(projectIDs,projectUpdateType)//项目标记为待刷新状态
  961. }
  962. async function exportProject(userID,data){//导出建设项目
  963. if(data.type == 'main'){
  964. return await exportMainData(userID,data.projectID);
  965. }else {
  966. return await exportTenderData(data);
  967. }
  968. }
  969. async function exportMainData(userID,projectID) {
  970. let result = {userID:userID,projects:[],type:'Project'};//type 备用属性,表示导出的类型,目前导出的都是整个建设项目
  971. let tenderIDs = [];
  972. let project = await projectModel.findOne({ID:projectID});
  973. if(!project) throw new Error("没有找到该建设项目:"+projectID);
  974. result['compilationID'] = project.compilation;
  975. result.projects.push(project);
  976. let subProjects = await projectModel.find({"$or": [{'ParentID':projectID}, {"property.rootProjectID": projectID}]});
  977. for(let s of subProjects){
  978. if(!s.deleteInfo || !s.deleteInfo.deleted){
  979. result.projects.push(s);
  980. if(s.projType =="Tender") tenderIDs.push(s.ID);
  981. }
  982. }
  983. let files = {unitFiles:await exportUnitFiles(projectID),feeRateFiles:await exportFeeRateFiles(projectID)};
  984. result.files = files;
  985. result = cipher.aesEncrypt(JSON.stringify(result));
  986. result +="|----|" +JSON.stringify(tenderIDs);
  987. return result;
  988. }
  989. async function exportUnitFiles(rootProjectID){
  990. let unitFiles = [];
  991. let files = await unitPriceFileModel.find({root_project_id:rootProjectID});
  992. for(let f of files){
  993. if(f.deleteInfo && f.deleteInfo.deleted == true) continue;
  994. let tem = {unitFile:f};
  995. tem.unitPrices = await unitPriceModel.find({unit_price_file_id:f.id});
  996. tem.mixRatios = await mixRatioModel.find({unit_price_file_id:f.id});
  997. tem.freights = await freightModel.find({unit_price_file_id:f.id});
  998. tem.originals = await originalModel.find({unit_price_file_id:f.id});
  999. unitFiles.push(tem);
  1000. }
  1001. return unitFiles;
  1002. }
  1003. async function exportFeeRateFiles(rootProjectID) {
  1004. let feeRateFiles = [];
  1005. let files = await feeRateFileModel.find({rootProjectID:rootProjectID});
  1006. for(let f of files){
  1007. if(f.deleteInfo && f.deleteInfo.deleted == true) continue;
  1008. let tem = {feeRateFile:f};
  1009. tem.feeRate = await feeRateModel.findOne({ID:f.feeRateID});
  1010. feeRateFiles.push(tem);
  1011. }
  1012. return feeRateFiles;
  1013. }
  1014. async function exportTenderData(data){
  1015. let result = {};
  1016. let projectSetting = await projectSettingModel.findOne({"projectID": data.projectID}, '-_id');
  1017. if(projectSetting) result['projSetting'] = projectSetting;
  1018. result.bills = await billsModel.find({"projectID": data.projectID});
  1019. result.rations = await rationModel.find({'$or': [{projectID: data.projectID, deleteInfo: null}, {projectID: data.projectID, 'deleteInfo.deleted': {$in: [null, false]}}]});
  1020. result.projectGLJs = await gljListModel.find({'project_id':data.projectID});
  1021. result.installationFees = await installationFeeModel.find({projectID:data.projectID});
  1022. result.rationGLJs = await rationGLJModel.find({projectID:data.projectID});
  1023. result.rationCoes = await rationCoeModel.find({projectID:data.projectID});
  1024. result.quantityDetails = await quantityDetailModel.find({projectID:data.projectID});
  1025. result.rationInstallations = await rationInstallationModel.find({projectID:data.projectID});
  1026. result.rationTemplates = await rationTemplateModel.find({projectID:data.projectID});
  1027. result.calcProgramsFile = await calcProgramsModel.findOne({projectID:data.projectID});
  1028. result.labourCoes = await labourCoesModel.findOne({projectID:data.projectID});
  1029. return cipher.aesEncrypt(JSON.stringify(result));
  1030. }
  1031. async function importProject(data,req,fields) {
  1032. let result = {error:0};
  1033. let stringArr = data.split("|----|");
  1034. let datas = [];
  1035. for(let s of stringArr){
  1036. datas.push(JSON.parse(cipher.aesDecrypt(s)));
  1037. }
  1038. let mainData = datas.length > 0 ?datas[0]:null;
  1039. if(mainData){
  1040. if(mainData.compilationID != req.session.sessionCompilation._id){
  1041. result.error = 1;
  1042. result.msg = "编办不同,无法导入,请重新选择!";
  1043. }else {
  1044. let [projectIDMap,labourCoeFileIDMap,calcProgramFileIDMap] = await handleMainProjectDatas(mainData,JSON.parse(fields.updateData[0]),req.session.sessionUser.id);
  1045. if(datas.length > 1 ){
  1046. for(let i = 1;i<datas.length;i++){
  1047. await handleEachProject(datas[i],projectIDMap,labourCoeFileIDMap,calcProgramFileIDMap)
  1048. }
  1049. }
  1050. }
  1051. }
  1052. return result;
  1053. }
  1054. async function handleEachProject(data,projectIDMap,labourCoeFileIDMap,calcProgramFileIDMap){
  1055. let bills = [],rations = [],projectGLJs = [],rationGLJs=[],rationCoes=[],quantityDetails=[],rationInstallations=[],rationTemplates=[];
  1056. let newProjectSetting =null,newCalcProgramsFile = null,newLabourCoe = null;
  1057. let billsIDMap = {},projectGLJIDMap={},rationIDMap = {};
  1058. let newProjectID = projectIDMap[data.projSetting.projectID];
  1059. //生成新的清单;
  1060. if(data.bills && data.bills.length > 0){
  1061. for(let b of data.bills){
  1062. billsIDMap[b.ID] = uuidV1();
  1063. }
  1064. for(let b of data.bills){
  1065. delete b._id;
  1066. b = getCopyBillDatas(b,newProjectID,billsIDMap);
  1067. bills.push(b);
  1068. }
  1069. }
  1070. //生成项目工料机数据
  1071. if(data.projectGLJs && data.projectGLJs.length > 0){
  1072. let gljCount = await counter.counterDAO.getIDAfterCountSync(counter.moduleName.glj_list, data.projectGLJs.length);
  1073. for(let i = 0; i < data.projectGLJs.length; i++){
  1074. let d = data.projectGLJs[i];
  1075. delete d._id;
  1076. let newID = gljCount.sequence_value - (data.projectGLJs.length - 1) + i;
  1077. projectGLJIDMap[d.id] = newID;
  1078. d.project_id = newProjectID;
  1079. d.id = newID;
  1080. projectGLJs.push(d);
  1081. }
  1082. }
  1083. //生成新的定额
  1084. if(data.rations && data.rations.length > 0){
  1085. for(let r of data.rations){
  1086. rationIDMap[r.ID] = uuidV1();
  1087. }
  1088. for(let r of data.rations){
  1089. delete r._id;
  1090. r = getCopyRationData(r,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  1091. rations.push(r);
  1092. }
  1093. }
  1094. //生成定额下挂的定额工料机等等数据
  1095. if(data.rationGLJs && data.rationGLJs.length > 0) rationGLJs = setRationSubList(data.rationGLJs,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  1096. if(data.rationCoes && data.rationCoes.length > 0) rationCoes = setRationSubList(data.rationCoes,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  1097. if(data.quantityDetails && data.quantityDetails.length > 0) quantityDetails = setRationSubList(data.quantityDetails,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  1098. if(data.rationInstallations && data.rationInstallations.length > 0) rationInstallations = setRationSubList(data.rationInstallations,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  1099. if(data.rationTemplates && data.rationTemplates.length > 0) rationTemplates = setRationSubList(data.rationTemplates,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  1100. //生成projectSetting 文件
  1101. if(data.projSetting){
  1102. data.projSetting.projectID =newProjectID;
  1103. newProjectSetting = data.projSetting;
  1104. delete newProjectSetting._id;
  1105. }
  1106. //生成计算程序文件,系数文件
  1107. if(data.calcProgramsFile && calcProgramFileIDMap[data.calcProgramsFile.ID]){
  1108. data.calcProgramsFile.ID = calcProgramFileIDMap[data.calcProgramsFile.ID];
  1109. data.calcProgramsFile.projectID = newProjectID;
  1110. newCalcProgramsFile = data.calcProgramsFile;
  1111. delete newCalcProgramsFile._id;
  1112. }
  1113. if(data.labourCoes && labourCoeFileIDMap[data.labourCoes.ID]){
  1114. data.labourCoes.ID = labourCoeFileIDMap[data.labourCoes.ID];
  1115. data.labourCoes.projectID = newProjectID;
  1116. newLabourCoe = data.labourCoes;
  1117. delete newLabourCoe._id;
  1118. }
  1119. if(newProjectSetting) await projectSettingModel.create(newProjectSetting);
  1120. if(bills.length > 0) await insertMany(bills,billsModel);
  1121. if(rations.length > 0) await insertMany(rations,rationModel);
  1122. if(projectGLJs.length > 0) await insertMany(projectGLJs,gljListModel);
  1123. if(rationGLJs.length > 0) await insertMany(rationGLJs,rationGLJModel);
  1124. if(rationCoes.length > 0) await insertMany(rationCoes,rationCoeModel);
  1125. if(quantityDetails.length > 0) await insertMany(quantityDetails,quantityDetailModel);
  1126. if(rationInstallations.length > 0) await insertMany(rationInstallations,rationInstallationModel);
  1127. if(rationTemplates.length > 0) await insertMany(rationTemplates,rationTemplateModel);
  1128. if(newCalcProgramsFile) await calcProgramsModel.create(newCalcProgramsFile);
  1129. if(newLabourCoe) await labourCoesModel.create(newLabourCoe);
  1130. }
  1131. function setRationSubList(datas,newProjectID,billIDMap,rationIDMap,projectGLJIDMap) {
  1132. let arrs = [];
  1133. for(let d of datas){
  1134. delete d._id;
  1135. d = getCopyRationSubData(d,newProjectID,billIDMap,rationIDMap,projectGLJIDMap);
  1136. arrs.push(d);
  1137. }
  1138. return arrs;
  1139. }
  1140. async function handleMainProjectDatas(mainData,updateData,userID) {
  1141. let mainProjectID = -1;
  1142. let projectIDMap = {},feeRateFileIDMap={},unitPriceFileIDMap={},labourCoeFileIDMap={},calcProgramFileIDMap={};
  1143. let tasks = [];
  1144. projectIDMap[-1] = -1;//最后一个项目的nextID为-1的情况
  1145. //生成新的projectID
  1146. for(let p of mainData.projects){
  1147. let newProjectID = await getCounterID("projects");
  1148. projectIDMap[p.ID] = newProjectID;
  1149. if(p.projType == "Project") mainProjectID = newProjectID;
  1150. if(p.projType == "Tender"){
  1151. if(p.property.calcProgramFile) calcProgramFileIDMap[p.property.calcProgramFile.ID] = uuidV1();//新的计算程序文件ID
  1152. if(p.property.labourCoeFile) labourCoeFileIDMap[p.property.labourCoeFile.ID] = uuidV1();//新的人工调整系数文件ID
  1153. if(p.property.feeFile) feeRateFileIDMap[p.property.feeFile.id] = uuidV1();//新的费率文件ID
  1154. if(p.property.unitPriceFile) unitPriceFileIDMap[p.property.unitPriceFile.id] = await getCounterID("unit_price_file");//新的单价文件ID
  1155. }
  1156. }
  1157. if(mainProjectID == -1) throw new Error("文件里面没包含建设项目信息!");
  1158. //处理项目信息 ----- 费率文件,单价文件ID信息要重新生成----to do
  1159. for(let p of mainData.projects){
  1160. delete p._id;
  1161. delete p.__v;
  1162. p.ID = projectIDMap[p.ID];
  1163. if(p.ID == mainProjectID){//对于建设项目,要父和下一节点ID要使用前端传入的位置ID
  1164. p.ParentID = updateData.self.ParentID;
  1165. p.NextSiblingID = updateData.self.NextSiblingID;
  1166. if(updateData.update){//树节构中的上一节点的下一节点设置为本建设项目ID;
  1167. tasks.push({updateOne:{filter : updateData.update.query, update : {NextSiblingID:mainProjectID}}});
  1168. }
  1169. //查看是否重名;
  1170. let temp = await projectModel.findOne({userID:userID,ParentID:p.ParentID,name:p.name});
  1171. if(temp) p.name = p.name + '(' + moment(Date.now()).format('MM-DD HH:mm:ss') + '导入)';
  1172. }else {
  1173. p.ParentID = projectIDMap[p.ParentID];
  1174. p.NextSiblingID = projectIDMap[p.NextSiblingID];
  1175. }
  1176. p.userID =userID;
  1177. p.shareInfo=[];
  1178. if(p.projType == "Tender"){
  1179. if(p.property.calcProgramFile) p.property.calcProgramFile.ID = calcProgramFileIDMap[p.property.calcProgramFile.ID];
  1180. if(p.property.labourCoeFile) p.property.labourCoeFile.ID = labourCoeFileIDMap[p.property.labourCoeFile.ID];
  1181. if(p.property.feeFile) p.property.feeFile.id = feeRateFileIDMap[p.property.feeFile.id];
  1182. if(p.property.unitPriceFile) p.property.unitPriceFile.id = unitPriceFileIDMap[p.property.unitPriceFile.id];
  1183. p.property.rootProjectID = mainProjectID
  1184. }
  1185. tasks.push({insertOne: {document: p}})
  1186. }
  1187. //项目树节构数据生成:
  1188. await projectModel.bulkWrite(tasks);
  1189. //生成所有的费率文件
  1190. await importFeeRateFiles(mainData,projectIDMap,feeRateFileIDMap,userID);
  1191. //生成所有的单价文件
  1192. await importUnitPriceFiles(mainData,projectIDMap,unitPriceFileIDMap,userID);
  1193. return [projectIDMap,labourCoeFileIDMap,calcProgramFileIDMap]
  1194. }
  1195. async function importUnitPriceFiles(mainData,projectIDMap,unitPriceFileIDMap,userID) {
  1196. if(!mainData.files.unitFiles) return;
  1197. let unitFiles = [],unitPrices =[],mixRatios=[],freights=[],originals=[];
  1198. for(let f of mainData.files.unitFiles){
  1199. let file = f.unitFile,prices = f.unitPrices,mixs = f.mixRatios,fres = f.freights,ors = f.originals;
  1200. //生成单价文件
  1201. delete file._id;
  1202. file.id = unitPriceFileIDMap[file.id]?unitPriceFileIDMap[file.id]:await getCounterID("unit_price_file");
  1203. file.project_id = projectIDMap[file.project_id];
  1204. file.root_project_id = projectIDMap[file.root_project_id];
  1205. file.user_id = userID;
  1206. unitFiles.push(file);
  1207. //生成子数据
  1208. if(prices) await setSubList(prices,unitPrices,file.id,unitPriceModel);
  1209. if(mixs) await setSubList(mixs,mixRatios,file.id,mixRatioModel);
  1210. if(fres) await setSubList(fres,freights,file.id,freightModel,true);
  1211. if(ors) await setSubList(ors,originals,file.id,originalModel,true);
  1212. }
  1213. if(unitFiles.length > 0) await insertMany(unitFiles,unitPriceFileModel);
  1214. if(unitPrices.length > 0) await insertMany(unitPrices,unitPriceModel);
  1215. if(mixRatios.length > 0) await insertMany(mixRatios,mixRatioModel);
  1216. if(freights.length > 0) await insertMany(freights,freightModel);
  1217. if(originals.length > 0) await insertMany(originals,originalModel);
  1218. async function setSubList(oList,nList,fileID,model,UUID=false) {
  1219. for(let o of oList){
  1220. delete o._id;
  1221. o.unit_price_file_id = fileID;
  1222. UUID == true?o.ID = uuidV1():o.id = await getCounterID(model.modelName);
  1223. nList.push(o)
  1224. }
  1225. }
  1226. }
  1227. async function importFeeRateFiles(mainData,projectIDMap,feeRateFileIDMap,userID) {
  1228. let feeRateFiles = [], feeRates = [];
  1229. if(!mainData.files.feeRateFiles) return;
  1230. for(let f of mainData.files.feeRateFiles){
  1231. //生成费率记录
  1232. let rate = f.feeRate;
  1233. delete rate._id;
  1234. rate.ID = uuidV1();
  1235. feeRates.push(rate);
  1236. //生成费率文件记录
  1237. let file = f.feeRateFile;
  1238. delete file._id;
  1239. file.ID = feeRateFileIDMap[file.ID]?feeRateFileIDMap[file.ID]:uuidV1();
  1240. file.userID = userID;
  1241. file.rootProjectID = projectIDMap[file.rootProjectID];
  1242. file.feeRateID = rate.ID;
  1243. feeRateFiles.push(file);
  1244. }
  1245. if(feeRateFiles.length > 0) await insertMany(feeRateFiles,feeRateFileModel);
  1246. if(feeRates.length > 0) await insertMany(feeRates,feeRateModel);
  1247. }