pm_facade.js 56 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336
  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. //根据单位工程ID获取汇总信息
  631. //@param {Number}tenderID {String}summaryType @return {Object}
  632. async function getSummaryInfoByTender(tenderID, summaryType) {
  633. const notDeleted = [{deleteInfo: null}, {'deleteInfo.deleted': false}];
  634. let tender = await projectModel.findOne({ID: tenderID, $or: notDeleted});
  635. let parentName;
  636. let summaryList = [];
  637. if(!tender){
  638. return null;
  639. }
  640. let project = await projectModel.findOne({ID: tender.ParentID, $or: notDeleted});
  641. if(!project){
  642. return null;
  643. }
  644. let summaryInfo = await getSummaryInfo([project.ID]);
  645. //已经没有单项工程这一层
  646. if(summaryType === projectType.engineering){
  647. /*parentName = engineering.name ? engineering.name : '';
  648. let tenders = await projectModel.find({ParentID: engineering.ID, $or: notDeleted});
  649. for(let t of tenders){
  650. if(summaryInfo[t.ID]){
  651. summaryInfo[t.ID]['name'] = t.name ? t.name : '';
  652. summaryList.push(summaryInfo[t.ID]);
  653. }
  654. }*/
  655. }
  656. else {
  657. parentName = project.name ? project.name : '';
  658. let tenders = await projectModel.find({ParentID: project.ID, $or: notDeleted});
  659. for(let t of tenders){
  660. if(summaryInfo[t.ID]){
  661. summaryInfo[t.ID]['name'] = t.name ? t.name : '';
  662. summaryList.push(summaryInfo[t.ID]);
  663. }
  664. }
  665. }
  666. return {parent: {name: parentName}, subList: summaryList};
  667. }
  668. //获取单位工程的各标段费用信息(不进行汇总)
  669. async function getTendersFeeInfo(tenders) {
  670. let IDMapping = {};
  671. //固定清单类别与汇总金额字段映射
  672. let flagFieldMapping = {};
  673. flagFieldMapping[billsFlags.TOTAL_COST] = 'totalCost';
  674. let tenderIDs = [];
  675. if(tenders.length > 0){
  676. for(let tender of tenders){
  677. tenderIDs.push(tender.ID);
  678. IDMapping[tender.ID] = {totalCost: 0};
  679. }
  680. //需要获取的清单固定类别综合合价:总造价
  681. let needFlags = [billsFlags.TOTAL_COST];
  682. //获取单位工程汇总金额需要用到的所有清单
  683. let allBills = await billsModel.find({projectID: {$in: tenderIDs}, 'flags.flag': {$in: needFlags}, $or: notDeleted},
  684. '-_id projectID fees flags');
  685. //进行单位工程级别的汇总
  686. for(let bills of allBills){
  687. let billsFlag = bills.flags[0]['flag'];
  688. let costField = flagFieldMapping[billsFlag];
  689. IDMapping[bills.projectID][costField] = getCommonTotalFee(bills);
  690. }
  691. }
  692. return IDMapping;
  693. }
  694. //@param {Array}projectIDs(建设项目ID) @return {Object}
  695. async function getSummaryInfo(projectIDs){
  696. //ID与汇总信息映射
  697. let IDMapping = {};
  698. //固定清单类别与汇总金额字段映射
  699. let flagFieldMapping = {};
  700. flagFieldMapping[billsFlags.TOTAL_COST] = 'totalCost';
  701. let projects = await projectModel.find({ID: {$in : projectIDs}, projType: projectType.project, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]});
  702. //设置建设项目的总建筑面积
  703. for(let project of projects){
  704. IDMapping[project.ID] = {totalCost: 0};
  705. }
  706. //单位工程
  707. let tenders = [];
  708. if(projectIDs.length > 0){
  709. tenders = await projectModel.find({ParentID: {$in : projectIDs}, projType: projectType.tender, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]});
  710. }
  711. let tenderIDs = [];
  712. if(tenders.length > 0){
  713. for(let tender of tenders){
  714. tenderIDs.push(tender.ID);
  715. IDMapping[tender.ID] = {totalCost: 0, changeMark:tender.changeMark};//property:tender.property
  716. }
  717. //需要获取的清单固定类别综合合价:总造价
  718. let needFlags = [billsFlags.TOTAL_COST];
  719. //获取单位工程汇总金额需要用到的所有清单
  720. let allBills = await billsModel.find({projectID: {$in: tenderIDs}, 'flags.flag': {$in: needFlags}, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]},
  721. '-_id projectID fees flags');
  722. //进行单位工程级别的汇总
  723. for(let bills of allBills){
  724. let billsFlag = bills.flags[0]['flag'];
  725. let costField = flagFieldMapping[billsFlag];
  726. IDMapping[bills.projectID][costField] = getCommonTotalFee(bills);
  727. }
  728. //进行建设项目级别的汇总
  729. for(let tender of tenders){
  730. summarizeToParent(IDMapping[tender.ParentID], IDMapping[tender.ID]);
  731. }
  732. }
  733. return IDMapping;
  734. }
  735. //根据项目ID获取所属建设项目
  736. //@param {Number}projectID @return {Object}
  737. async function getConstructionProject(projectID){
  738. function returnProject(project){
  739. if(!project || project.projType === projectType.folder){
  740. return null;
  741. }
  742. if(project.projType === projectType.project){
  743. return project;
  744. }
  745. }
  746. let project = await projectModel.findOne({ID: projectID, $or: notDeleted});
  747. let returnV = returnProject(project);
  748. if(returnV !== undefined){
  749. return returnV;
  750. }
  751. let parent = await projectModel.findOne({ID: project.ParentID, $or: notDeleted});
  752. returnV = returnProject(parent);
  753. if(returnV !== undefined){
  754. return returnV;
  755. }
  756. let grandParent = await projectModel.findOne({ID: parent.ParentID, $or: notDeleted});
  757. returnV = returnProject(grandParent);
  758. return returnV !== undefined ? returnV : null;
  759. }
  760. //获取单位工程完整目录结构
  761. //@param {Number}projectID @return {Arry}
  762. async function getFullPath(projectID) {
  763. let fullPath = [];
  764. let project = await projectModel.findOne({ID: projectID, $or: notDeleted}, '-_id ParentID name');
  765. if(project){
  766. fullPath.push(project.name);
  767. await getParent(project.ParentID);
  768. }
  769. fullPath = fullPath.reverse();
  770. return fullPath;
  771. async function getParent(ParentID) {
  772. if(ParentID != -1){
  773. let parent = await projectModel.findOne({ID: ParentID, $or: notDeleted}, '-_id ParentID name');
  774. if(parent){
  775. fullPath.push(parent.name);
  776. await getParent(parent.ParentID);
  777. }
  778. }
  779. }
  780. }
  781. //@param {String}libID(工程特征库ID) {Object}assign(需要赋值的key-value)
  782. async function getProjectFeature(libID, assign) {
  783. let lib = await featureLibModel.findOne({'ID':libID});
  784. if (lib) {
  785. for (let key in assign) {
  786. let obj = _.find(lib.feature, {key: key});
  787. if (obj) {
  788. obj.value = assign[key];
  789. }
  790. }
  791. return lib.feature;
  792. } else {
  793. return [];
  794. }
  795. }
  796. //获取累进区间数据
  797. async function getProgressiveInterval(libID) {
  798. let lib = await progressiveModel.findOne({ID: libID});
  799. return lib ? lib.data : [];
  800. }
  801. //获取projectIDs文件下所有子项目(不包括projectIDs本身)
  802. async function getPosterityProjects(projectIDs) {
  803. let rst = [];
  804. async function getProjects(IDs) {
  805. if (IDs.length > 0) {
  806. let newIDs = [];
  807. let projs = await projectModel.find({ParentID: {$in: IDs}, $or: notDeleted}, '-_id');
  808. for (let proj of projs) {
  809. rst.push(proj);
  810. newIDs.push(proj.ID);
  811. }
  812. await getProjects(newIDs);
  813. }
  814. }
  815. await getProjects(projectIDs);
  816. return rst;
  817. }
  818. //根据项目获得分享信息(分享层级不一定在项目级)(以最新为准)
  819. //@param {String}userId {Object}tender @return {Object} || {null}
  820. async function getShareInfo(userId, project) {
  821. //与该用户相关的分享
  822. let shareList = [];
  823. while (project) {
  824. for(let shareData of project.shareInfo){
  825. if(shareData.userID === userId){
  826. shareList.push(shareData);
  827. break;
  828. }
  829. }
  830. project = await projectModel.findOne({ID: project.ParentID}, '-_id shareInfo ID ParentID');
  831. }
  832. //获取最新分享
  833. shareList.sort(function (a, b) {
  834. let aV = Date.parse(a.shareDate),
  835. bV = Date.parse(b.shareDate);
  836. if (aV > bV) {
  837. return -1;
  838. } else if (aV < bV) {
  839. return 1;
  840. }
  841. return 0;
  842. });
  843. return shareList[0] || null;
  844. }
  845. //打开的单位工程是否是被分享的.
  846. async function isShare(userId, project){
  847. //判断是否是打开分享的项目,属于分享文件的子项也算
  848. while (project) {
  849. for(let shareData of project.shareInfo){
  850. if(shareData.userID === userId){
  851. return true;
  852. }
  853. }
  854. project = await projectModel.findOne({ID: project.ParentID}, '-_id shareInfo ID ParentID');
  855. }
  856. return false;
  857. }
  858. //用户是否第一次进入费用定额
  859. async function isFirst(userId, compilationId) {
  860. let userData = await userModel.findOne({_id: mongoose.Types.ObjectId(userId)}, '-_id used_list');
  861. let isFirst = false;
  862. if (userData) {
  863. isFirst = !_.find(userData.used_list, function (o) {
  864. return o.compilationId === compilationId;
  865. });;
  866. }
  867. return isFirst;
  868. }
  869. //用户第一次进入费用定额的数据准备
  870. async function prepareInitialData(userId, compilation, example) {
  871. let first = await isFirst(userId, compilation);
  872. if (first) {
  873. await updateUsedList(userId, compilation);
  874. let prepareTask = [
  875. copyCompleRationSection(userId, compilation),
  876. copyCompleGljSection(userId, compilation)
  877. ];
  878. if (example && example.length > 0) {
  879. prepareTask.push(copyExample(userId, compilation, example));
  880. }
  881. await Promise.all(prepareTask);
  882. }
  883. }
  884. async function updateUsedList(userId, compilation) {
  885. await userModel.update({_id: mongoose.Types.ObjectId(userId)}, {$push: {used_list: {compilationId: compilation}}});
  886. }
  887. //拷贝补充定额章节树
  888. async function copyCompleRationSection(userId, compilationId) {
  889. await sectionTreeDao.copyDataFromTemplate(userId, compilationId);
  890. }
  891. /*
  892. * 解决问题:
  893. * 发布了编办之后,才设置了人材机库模板,导致已登录的用户不存在人材机库的分类树
  894. * 为该编办下,人材机分类模板为空的用户,拷贝模板数据
  895. * */
  896. async function copyForSectionError(compilation) {
  897. let users = await userModel.find({}, '_id');
  898. for (let user of users) {
  899. let userId = user._id.toString();
  900. let existCount = await compleGljSectionModel.find({userId}).count();
  901. if (existCount === 0) {
  902. await copyCompleGljSection(userId, compilation);
  903. }
  904. }
  905. }
  906. //拷贝补充人材机分类树
  907. async function copyCompleGljSection(userId, compilationId) {
  908. let templateData = await compleGljSectionTModel.find({compilationId: compilationId});
  909. if (templateData.length > 0) {
  910. let insertDatas = [],
  911. uuidMapping = {};
  912. //将ID替换成UUID
  913. for (let temData of templateData) {
  914. uuidMapping[temData.ID] = uuidV1();
  915. }
  916. for(let temData of templateData) {
  917. let insertD = {
  918. userId: userId,
  919. compilationId: compilationId,
  920. Name: temData.Name,
  921. ID: uuidMapping[temData.ID],
  922. ParentID: uuidMapping[temData.ParentID] || -1,
  923. NextSiblingID: uuidMapping[temData.NextSiblingID] || -1,
  924. };
  925. insertDatas.push(insertD);
  926. }
  927. //插入数据
  928. await compleGljSectionModel.insertMany(insertDatas);
  929. }
  930. }
  931. async function changeFile(datas,userID,fileID,name,from,type){//from 费率或单价文件,type从单前建设项目还是从其它建设项目中复制
  932. let projectIDs = [],newFile = {id:fileID,name:name};//计录从其它项目中复制的文件,选中多个的时候只需复制一次
  933. let projectUpdateType = from == "feeRateFile"?"feeRate":"unitFile";
  934. for(let d of datas){
  935. let tem_file = from == "feeRateFile"? await feeRate_facade.changeFeeRateFile(d, newFile,type,userID):await glj_facade.changeUnitFile(d, newFile,type,userID);
  936. if(type == 1 && tem_file){//从建设项目复制时,只有第一次需要复制,剩下的就相当于使用同个建设项目的情况了
  937. let newID = from == "feeRateFile"?tem_file.ID:tem_file.id;
  938. newFile = {id:newID,name:tem_file.name};
  939. type = 0;
  940. }
  941. projectIDs.push({ID:d.projectID})
  942. }
  943. await project_facade.markProjectsToChange(projectIDs,projectUpdateType)//项目标记为待刷新状态
  944. }
  945. async function exportProject(userID,data){//导出建设项目
  946. console.log(data);
  947. if(data.type == 'main'){
  948. return await exportMainData(userID,data.projectID);
  949. }else {
  950. return await exportTenderData(data);
  951. }
  952. }
  953. async function exportMainData(userID,projectID) {
  954. let result = {userID:userID,projects:[],type:'Project'};//type 备用属性,表示导出的类型,目前导出的都是整个建设项目
  955. let tenderIDs = [];
  956. let project = await projectModel.findOne({ID:projectID});
  957. if(!project) throw new Error("没有找到该建设项目:"+projectID);
  958. result['compilationID'] = project.compilation;
  959. result.projects.push(project);
  960. let subProjects = await projectModel.find({"$or": [{'ParentID':projectID}, {"property.rootProjectID": projectID}]});
  961. for(let s of subProjects){
  962. if(!s.deleteInfo || !s.deleteInfo.deleted){
  963. result.projects.push(s);
  964. if(s.projType =="Tender") tenderIDs.push(s.ID);
  965. }
  966. }
  967. let files = {unitFiles:await exportUnitFiles(projectID),feeRateFiles:await exportFeeRateFiles(projectID)};
  968. result.files = files;
  969. result = cipher.aesEncrypt(JSON.stringify(result));
  970. result +="|----|" +JSON.stringify(tenderIDs);
  971. return result;
  972. }
  973. async function exportUnitFiles(rootProjectID){
  974. let unitFiles = [];
  975. let files = await unitPriceFileModel.find({root_project_id:rootProjectID});
  976. for(let f of files){
  977. if(f.deleteInfo && f.deleteInfo.deleted == true) continue;
  978. let tem = {unitFile:f};
  979. tem.unitPrices = await unitPriceModel.find({unit_price_file_id:f.id});
  980. tem.mixRatios = await mixRatioModel.find({unit_price_file_id:f.id});
  981. tem.freights = await freightModel.find({unit_price_file_id:f.id});
  982. tem.originals = await originalModel.find({unit_price_file_id:f.id});
  983. unitFiles.push(tem);
  984. }
  985. return unitFiles;
  986. }
  987. async function exportFeeRateFiles(rootProjectID) {
  988. let feeRateFiles = [];
  989. let files = await feeRateFileModel.find({rootProjectID:rootProjectID});
  990. for(let f of files){
  991. if(f.deleteInfo && f.deleteInfo.deleted == true) continue;
  992. let tem = {feeRateFile:f};
  993. tem.feeRate = await feeRateModel.findOne({ID:f.feeRateID});
  994. feeRateFiles.push(tem);
  995. }
  996. return feeRateFiles;
  997. }
  998. async function exportTenderData(data){
  999. let result = {};
  1000. let projectSetting = await projectSettingModel.findOne({"projectID": data.projectID}, '-_id');
  1001. if(projectSetting) result['projSetting'] = projectSetting;
  1002. result.bills = await billsModel.find({"projectID": data.projectID});
  1003. result.rations = await rationModel.find({'$or': [{projectID: data.projectID, deleteInfo: null}, {projectID: data.projectID, 'deleteInfo.deleted': {$in: [null, false]}}]});
  1004. result.projectGLJs = await gljListModel.find({'project_id':data.projectID});
  1005. result.installationFees = await installationFeeModel.find({projectID:data.projectID});
  1006. result.rationGLJs = await rationGLJModel.find({projectID:data.projectID});
  1007. result.rationCoes = await rationCoeModel.find({projectID:data.projectID});
  1008. result.quantityDetails = await quantityDetailModel.find({projectID:data.projectID});
  1009. result.rationInstallations = await rationInstallationModel.find({projectID:data.projectID});
  1010. result.rationTemplates = await rationTemplateModel.find({projectID:data.projectID});
  1011. result.calcProgramsFile = await calcProgramsModel.findOne({projectID:data.projectID});
  1012. result.labourCoes = await labourCoesModel.findOne({projectID:data.projectID});
  1013. return cipher.aesEncrypt(JSON.stringify(result));
  1014. }
  1015. async function importProject(data,req,fields) {
  1016. let result = {error:0};
  1017. let stringArr = data.split("|----|");
  1018. let datas = [];
  1019. for(let s of stringArr){
  1020. datas.push(JSON.parse(cipher.aesDecrypt(s)));
  1021. }
  1022. let mainData = datas.length > 0 ?datas[0]:null;
  1023. if(mainData){
  1024. if(mainData.compilationID != req.session.sessionCompilation._id){
  1025. result.error = 1;
  1026. result.msg = "编办不同,无法导入,请重新选择!";
  1027. }else {
  1028. let [projectIDMap,labourCoeFileIDMap,calcProgramFileIDMap] = await handleMainProjectDatas(mainData,JSON.parse(fields.updateData[0]),req.session.sessionUser.id);
  1029. if(datas.length > 1 ){
  1030. for(let i = 1;i<datas.length;i++){
  1031. await handleEachProject(datas[i],projectIDMap,labourCoeFileIDMap,calcProgramFileIDMap)
  1032. }
  1033. }
  1034. }
  1035. }
  1036. return result;
  1037. }
  1038. async function handleEachProject(data,projectIDMap,labourCoeFileIDMap,calcProgramFileIDMap){
  1039. let bills = [],rations = [],projectGLJs = [],rationGLJs=[],rationCoes=[],quantityDetails=[],rationInstallations=[],rationTemplates=[];
  1040. let newProjectSetting =null,newCalcProgramsFile = null,newLabourCoe = null;
  1041. let billsIDMap = {},projectGLJIDMap={},rationIDMap = {};
  1042. let newProjectID = projectIDMap[data.projSetting.projectID];
  1043. //生成新的清单;
  1044. if(data.bills && data.bills.length > 0){
  1045. for(let b of data.bills){
  1046. billsIDMap[b.ID] = uuidV1();
  1047. }
  1048. for(let b of data.bills){
  1049. delete b._id;
  1050. b = getCopyBillDatas(b,newProjectID,billsIDMap);
  1051. bills.push(b);
  1052. }
  1053. }
  1054. //生成项目工料机数据
  1055. if(data.projectGLJs && data.projectGLJs.length > 0){
  1056. let gljCount = await counter.counterDAO.getIDAfterCountSync(counter.moduleName.glj_list, data.projectGLJs.length);
  1057. for(let i = 0; i < data.projectGLJs.length; i++){
  1058. let d = data.projectGLJs[i];
  1059. delete d._id;
  1060. let newID = gljCount.sequence_value - (data.projectGLJs.length - 1) + i;
  1061. projectGLJIDMap[d.id] = newID;
  1062. d.project_id = newProjectID;
  1063. d.id = newID;
  1064. projectGLJs.push(d);
  1065. }
  1066. }
  1067. //生成新的定额
  1068. if(data.rations && data.rations.length > 0){
  1069. for(let r of data.rations){
  1070. rationIDMap[r.ID] = uuidV1();
  1071. }
  1072. for(let r of data.rations){
  1073. delete r._id;
  1074. r = getCopyRationData(r,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  1075. rations.push(r);
  1076. }
  1077. }
  1078. //生成定额下挂的定额工料机等等数据
  1079. if(data.rationGLJs && data.rationGLJs.length > 0) rationGLJs = setRationSubList(data.rationGLJs,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  1080. if(data.rationCoes && data.rationCoes.length > 0) rationCoes = setRationSubList(data.rationCoes,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  1081. if(data.quantityDetails && data.quantityDetails.length > 0) quantityDetails = setRationSubList(data.quantityDetails,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  1082. if(data.rationInstallations && data.rationInstallations.length > 0) rationInstallations = setRationSubList(data.rationInstallations,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  1083. if(data.rationTemplates && data.rationTemplates.length > 0) rationTemplates = setRationSubList(data.rationTemplates,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  1084. //生成projectSetting 文件
  1085. if(data.projSetting){
  1086. data.projSetting.projectID =newProjectID;
  1087. newProjectSetting = data.projSetting;
  1088. delete newProjectSetting._id;
  1089. }
  1090. //生成计算程序文件,系数文件
  1091. if(data.calcProgramsFile && calcProgramFileIDMap[data.calcProgramsFile.ID]){
  1092. data.calcProgramsFile.ID = calcProgramFileIDMap[data.calcProgramsFile.ID];
  1093. data.calcProgramsFile.projectID = newProjectID;
  1094. newCalcProgramsFile = data.calcProgramsFile;
  1095. delete newCalcProgramsFile._id;
  1096. }
  1097. if(data.labourCoes && labourCoeFileIDMap[data.labourCoes.ID]){
  1098. data.labourCoes.ID = labourCoeFileIDMap[data.labourCoes.ID];
  1099. data.labourCoes.projectID = newProjectID;
  1100. newLabourCoe = data.labourCoes;
  1101. delete newLabourCoe._id;
  1102. }
  1103. if(newProjectSetting) await projectSettingModel.create(newProjectSetting);
  1104. if(bills.length > 0) await insertMany(bills,billsModel);
  1105. if(rations.length > 0) await insertMany(rations,rationModel);
  1106. if(projectGLJs.length > 0) await insertMany(projectGLJs,gljListModel);
  1107. if(rationGLJs.length > 0) await insertMany(rationGLJs,rationGLJModel);
  1108. if(rationCoes.length > 0) await insertMany(rationCoes,rationCoeModel);
  1109. if(quantityDetails.length > 0) await insertMany(quantityDetails,quantityDetailModel);
  1110. if(rationInstallations.length > 0) await insertMany(rationInstallations,rationInstallationModel);
  1111. if(rationTemplates.length > 0) await insertMany(rationTemplates,rationTemplateModel);
  1112. if(newCalcProgramsFile) await calcProgramsModel.create(newCalcProgramsFile);
  1113. if(newLabourCoe) await labourCoesModel.create(newLabourCoe);
  1114. }
  1115. function setRationSubList(datas,newProjectID,billIDMap,rationIDMap,projectGLJIDMap) {
  1116. let arrs = [];
  1117. for(let d of datas){
  1118. delete d._id;
  1119. d = getCopyRationSubData(d,newProjectID,billIDMap,rationIDMap,projectGLJIDMap);
  1120. arrs.push(d);
  1121. }
  1122. return arrs;
  1123. }
  1124. async function handleMainProjectDatas(mainData,updateData,userID) {
  1125. let mainProjectID = -1;
  1126. let projectIDMap = {},feeRateFileIDMap={},unitPriceFileIDMap={},labourCoeFileIDMap={},calcProgramFileIDMap={};
  1127. let tasks = [];
  1128. //生成新的projectID
  1129. for(let p of mainData.projects){
  1130. let newProjectID = await getCounterID("projects");
  1131. projectIDMap[p.ID] = newProjectID;
  1132. if(p.projType == "Project") mainProjectID = newProjectID;
  1133. if(p.projType == "Tender"){
  1134. if(p.property.calcProgramFile) calcProgramFileIDMap[p.property.calcProgramFile.ID] = uuidV1();//新的计算程序文件ID
  1135. if(p.property.labourCoeFile) labourCoeFileIDMap[p.property.labourCoeFile.ID] = uuidV1();//新的人工调整系数文件ID
  1136. if(p.property.feeFile) feeRateFileIDMap[p.property.feeFile.id] = uuidV1();//新的费率文件ID
  1137. if(p.property.unitPriceFile) unitPriceFileIDMap[p.property.unitPriceFile.id] = await getCounterID("unit_price_file");//新的单价文件ID
  1138. }
  1139. }
  1140. if(mainProjectID == -1) throw new Error("文件里面没包含建设项目信息!");
  1141. //处理项目信息 ----- 费率文件,单价文件ID信息要重新生成----to do
  1142. for(let p of mainData.projects){
  1143. delete p._id;
  1144. delete p.__v;
  1145. p.ID = projectIDMap[p.ID];
  1146. if(p.ID == mainProjectID){//对于建设项目,要父和下一节点ID要使用前端传入的位置ID
  1147. p.ParentID = updateData.self.ParentID;
  1148. p.NextSiblingID = updateData.self.NextSiblingID;
  1149. if(updateData.update){//树节构中的上一节点的下一节点设置为本建设项目ID;
  1150. tasks.push({updateOne:{filter : updateData.update.query, update : {NextSiblingID:mainProjectID}}});
  1151. }
  1152. //查看是否重名;
  1153. let temp = await projectModel.findOne({userID:userID,ParentID:p.ParentID,name:p.name});
  1154. if(temp) p.name = p.name + '(' + moment(Date.now()).format('MM-DD HH:mm:ss') + '导入)';
  1155. }else {
  1156. p.ParentID = projectIDMap[p.ParentID];
  1157. p.NextSiblingID = projectIDMap[p.NextSiblingID];
  1158. }
  1159. p.userID =userID;
  1160. p.shareInfo=[];
  1161. if(p.projType == "Tender"){
  1162. if(p.property.calcProgramFile) p.property.calcProgramFile.ID = calcProgramFileIDMap[p.property.calcProgramFile.ID];
  1163. if(p.property.labourCoeFile) p.property.labourCoeFile.ID = labourCoeFileIDMap[p.property.labourCoeFile.ID];
  1164. if(p.property.feeFile) p.property.feeFile.id = feeRateFileIDMap[p.property.feeFile.id];
  1165. if(p.property.unitPriceFile) p.property.unitPriceFile.id = unitPriceFileIDMap[p.property.unitPriceFile.id];
  1166. p.property.rootProjectID = mainProjectID
  1167. }
  1168. tasks.push({insertOne: {document: p}})
  1169. }
  1170. //项目树节构数据生成:
  1171. await projectModel.bulkWrite(tasks);
  1172. //生成所有的费率文件
  1173. await importFeeRateFiles(mainData,projectIDMap,feeRateFileIDMap,userID);
  1174. //生成所有的单价文件
  1175. await importUnitPriceFiles(mainData,projectIDMap,unitPriceFileIDMap,userID);
  1176. return [projectIDMap,labourCoeFileIDMap,calcProgramFileIDMap]
  1177. }
  1178. async function importUnitPriceFiles(mainData,projectIDMap,unitPriceFileIDMap,userID) {
  1179. if(!mainData.files.unitFiles) return;
  1180. let unitFiles = [],unitPrices =[],mixRatios=[],freights=[],originals=[];
  1181. for(let f of mainData.files.unitFiles){
  1182. let file = f.unitFile,prices = f.unitPrices,mixs = f.mixRatios,fres = f.freights,ors = f.originals;
  1183. //生成单价文件
  1184. delete file._id;
  1185. file.id = unitPriceFileIDMap[file.id]?unitPriceFileIDMap[file.id]:await getCounterID("unit_price_file");
  1186. file.project_id = projectIDMap[file.project_id];
  1187. file.root_project_id = projectIDMap[file.root_project_id];
  1188. file.user_id = userID;
  1189. unitFiles.push(file);
  1190. //生成子数据
  1191. if(prices) await setSubList(prices,unitPrices,file.id,unitPriceModel);
  1192. if(mixs) await setSubList(mixs,mixRatios,file.id,mixRatioModel);
  1193. if(fres) await setSubList(fres,freights,file.id,freightModel,true);
  1194. if(ors) await setSubList(ors,originals,file.id,originalModel,true);
  1195. }
  1196. if(unitFiles.length > 0) await insertMany(unitFiles,unitPriceFileModel);
  1197. if(unitPrices.length > 0) await insertMany(unitPrices,unitPriceModel);
  1198. if(mixRatios.length > 0) await insertMany(mixRatios,mixRatioModel);
  1199. if(freights.length > 0) await insertMany(freights,freightModel);
  1200. if(originals.length > 0) await insertMany(originals,originalModel);
  1201. async function setSubList(oList,nList,fileID,model,UUID=false) {
  1202. for(let o of oList){
  1203. delete o._id;
  1204. o.unit_price_file_id = fileID;
  1205. UUID == true?o.ID = uuidV1():o.id = await getCounterID(model.modelName);
  1206. nList.push(o)
  1207. }
  1208. }
  1209. }
  1210. async function importFeeRateFiles(mainData,projectIDMap,feeRateFileIDMap,userID) {
  1211. let feeRateFiles = [], feeRates = [];
  1212. if(!mainData.files.feeRateFiles) return;
  1213. for(let f of mainData.files.feeRateFiles){
  1214. //生成费率记录
  1215. let rate = f.feeRate;
  1216. delete rate._id;
  1217. rate.ID = uuidV1();
  1218. feeRates.push(rate);
  1219. //生成费率文件记录
  1220. let file = f.feeRateFile;
  1221. delete file._id;
  1222. file.ID = feeRateFileIDMap[file.ID]?feeRateFileIDMap[file.ID]:uuidV1();
  1223. file.userID = userID;
  1224. file.rootProjectID = projectIDMap[file.rootProjectID];
  1225. file.feeRateID = rate.ID;
  1226. feeRateFiles.push(file);
  1227. }
  1228. if(feeRateFiles.length > 0) await insertMany(feeRateFiles,feeRateFileModel);
  1229. if(feeRates.length > 0) await insertMany(feeRates,feeRateModel);
  1230. }