pm_facade.js 56 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335
  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};//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. if(data.type == 'main'){
  947. return await exportMainData(userID,data.projectID);
  948. }else {
  949. return await exportTenderData(data);
  950. }
  951. }
  952. async function exportMainData(userID,projectID) {
  953. let result = {userID:userID,projects:[],type:'Project'};//type 备用属性,表示导出的类型,目前导出的都是整个建设项目
  954. let tenderIDs = [];
  955. let project = await projectModel.findOne({ID:projectID});
  956. if(!project) throw new Error("没有找到该建设项目:"+projectID);
  957. result['compilationID'] = project.compilation;
  958. result.projects.push(project);
  959. let subProjects = await projectModel.find({"$or": [{'ParentID':projectID}, {"property.rootProjectID": projectID}]});
  960. for(let s of subProjects){
  961. if(!s.deleteInfo || !s.deleteInfo.deleted){
  962. result.projects.push(s);
  963. if(s.projType =="Tender") tenderIDs.push(s.ID);
  964. }
  965. }
  966. let files = {unitFiles:await exportUnitFiles(projectID),feeRateFiles:await exportFeeRateFiles(projectID)};
  967. result.files = files;
  968. result = cipher.aesEncrypt(JSON.stringify(result));
  969. result +="|----|" +JSON.stringify(tenderIDs);
  970. return result;
  971. }
  972. async function exportUnitFiles(rootProjectID){
  973. let unitFiles = [];
  974. let files = await unitPriceFileModel.find({root_project_id:rootProjectID});
  975. for(let f of files){
  976. if(f.deleteInfo && f.deleteInfo.deleted == true) continue;
  977. let tem = {unitFile:f};
  978. tem.unitPrices = await unitPriceModel.find({unit_price_file_id:f.id});
  979. tem.mixRatios = await mixRatioModel.find({unit_price_file_id:f.id});
  980. tem.freights = await freightModel.find({unit_price_file_id:f.id});
  981. tem.originals = await originalModel.find({unit_price_file_id:f.id});
  982. unitFiles.push(tem);
  983. }
  984. return unitFiles;
  985. }
  986. async function exportFeeRateFiles(rootProjectID) {
  987. let feeRateFiles = [];
  988. let files = await feeRateFileModel.find({rootProjectID:rootProjectID});
  989. for(let f of files){
  990. if(f.deleteInfo && f.deleteInfo.deleted == true) continue;
  991. let tem = {feeRateFile:f};
  992. tem.feeRate = await feeRateModel.findOne({ID:f.feeRateID});
  993. feeRateFiles.push(tem);
  994. }
  995. return feeRateFiles;
  996. }
  997. async function exportTenderData(data){
  998. let result = {};
  999. let projectSetting = await projectSettingModel.findOne({"projectID": data.projectID}, '-_id');
  1000. if(projectSetting) result['projSetting'] = projectSetting;
  1001. result.bills = await billsModel.find({"projectID": data.projectID});
  1002. result.rations = await rationModel.find({'$or': [{projectID: data.projectID, deleteInfo: null}, {projectID: data.projectID, 'deleteInfo.deleted': {$in: [null, false]}}]});
  1003. result.projectGLJs = await gljListModel.find({'project_id':data.projectID});
  1004. result.installationFees = await installationFeeModel.find({projectID:data.projectID});
  1005. result.rationGLJs = await rationGLJModel.find({projectID:data.projectID});
  1006. result.rationCoes = await rationCoeModel.find({projectID:data.projectID});
  1007. result.quantityDetails = await quantityDetailModel.find({projectID:data.projectID});
  1008. result.rationInstallations = await rationInstallationModel.find({projectID:data.projectID});
  1009. result.rationTemplates = await rationTemplateModel.find({projectID:data.projectID});
  1010. result.calcProgramsFile = await calcProgramsModel.findOne({projectID:data.projectID});
  1011. result.labourCoes = await labourCoesModel.findOne({projectID:data.projectID});
  1012. return cipher.aesEncrypt(JSON.stringify(result));
  1013. }
  1014. async function importProject(data,req,fields) {
  1015. let result = {error:0};
  1016. let stringArr = data.split("|----|");
  1017. let datas = [];
  1018. for(let s of stringArr){
  1019. datas.push(JSON.parse(cipher.aesDecrypt(s)));
  1020. }
  1021. let mainData = datas.length > 0 ?datas[0]:null;
  1022. if(mainData){
  1023. if(mainData.compilationID != req.session.sessionCompilation._id){
  1024. result.error = 1;
  1025. result.msg = "编办不同,无法导入,请重新选择!";
  1026. }else {
  1027. let [projectIDMap,labourCoeFileIDMap,calcProgramFileIDMap] = await handleMainProjectDatas(mainData,JSON.parse(fields.updateData[0]),req.session.sessionUser.id);
  1028. if(datas.length > 1 ){
  1029. for(let i = 1;i<datas.length;i++){
  1030. await handleEachProject(datas[i],projectIDMap,labourCoeFileIDMap,calcProgramFileIDMap)
  1031. }
  1032. }
  1033. }
  1034. }
  1035. return result;
  1036. }
  1037. async function handleEachProject(data,projectIDMap,labourCoeFileIDMap,calcProgramFileIDMap){
  1038. let bills = [],rations = [],projectGLJs = [],rationGLJs=[],rationCoes=[],quantityDetails=[],rationInstallations=[],rationTemplates=[];
  1039. let newProjectSetting =null,newCalcProgramsFile = null,newLabourCoe = null;
  1040. let billsIDMap = {},projectGLJIDMap={},rationIDMap = {};
  1041. let newProjectID = projectIDMap[data.projSetting.projectID];
  1042. //生成新的清单;
  1043. if(data.bills && data.bills.length > 0){
  1044. for(let b of data.bills){
  1045. billsIDMap[b.ID] = uuidV1();
  1046. }
  1047. for(let b of data.bills){
  1048. delete b._id;
  1049. b = getCopyBillDatas(b,newProjectID,billsIDMap);
  1050. bills.push(b);
  1051. }
  1052. }
  1053. //生成项目工料机数据
  1054. if(data.projectGLJs && data.projectGLJs.length > 0){
  1055. let gljCount = await counter.counterDAO.getIDAfterCountSync(counter.moduleName.glj_list, data.projectGLJs.length);
  1056. for(let i = 0; i < data.projectGLJs.length; i++){
  1057. let d = data.projectGLJs[i];
  1058. delete d._id;
  1059. let newID = gljCount.sequence_value - (data.projectGLJs.length - 1) + i;
  1060. projectGLJIDMap[d.id] = newID;
  1061. d.project_id = newProjectID;
  1062. d.id = newID;
  1063. projectGLJs.push(d);
  1064. }
  1065. }
  1066. //生成新的定额
  1067. if(data.rations && data.rations.length > 0){
  1068. for(let r of data.rations){
  1069. rationIDMap[r.ID] = uuidV1();
  1070. }
  1071. for(let r of data.rations){
  1072. delete r._id;
  1073. r = getCopyRationData(r,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  1074. rations.push(r);
  1075. }
  1076. }
  1077. //生成定额下挂的定额工料机等等数据
  1078. if(data.rationGLJs && data.rationGLJs.length > 0) rationGLJs = setRationSubList(data.rationGLJs,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  1079. if(data.rationCoes && data.rationCoes.length > 0) rationCoes = setRationSubList(data.rationCoes,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  1080. if(data.quantityDetails && data.quantityDetails.length > 0) quantityDetails = setRationSubList(data.quantityDetails,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  1081. if(data.rationInstallations && data.rationInstallations.length > 0) rationInstallations = setRationSubList(data.rationInstallations,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  1082. if(data.rationTemplates && data.rationTemplates.length > 0) rationTemplates = setRationSubList(data.rationTemplates,newProjectID,billsIDMap,rationIDMap,projectGLJIDMap);
  1083. //生成projectSetting 文件
  1084. if(data.projSetting){
  1085. data.projSetting.projectID =newProjectID;
  1086. newProjectSetting = data.projSetting;
  1087. delete newProjectSetting._id;
  1088. }
  1089. //生成计算程序文件,系数文件
  1090. if(data.calcProgramsFile && calcProgramFileIDMap[data.calcProgramsFile.ID]){
  1091. data.calcProgramsFile.ID = calcProgramFileIDMap[data.calcProgramsFile.ID];
  1092. data.calcProgramsFile.projectID = newProjectID;
  1093. newCalcProgramsFile = data.calcProgramsFile;
  1094. delete newCalcProgramsFile._id;
  1095. }
  1096. if(data.labourCoes && labourCoeFileIDMap[data.labourCoes.ID]){
  1097. data.labourCoes.ID = labourCoeFileIDMap[data.labourCoes.ID];
  1098. data.labourCoes.projectID = newProjectID;
  1099. newLabourCoe = data.labourCoes;
  1100. delete newLabourCoe._id;
  1101. }
  1102. if(newProjectSetting) await projectSettingModel.create(newProjectSetting);
  1103. if(bills.length > 0) await insertMany(bills,billsModel);
  1104. if(rations.length > 0) await insertMany(rations,rationModel);
  1105. if(projectGLJs.length > 0) await insertMany(projectGLJs,gljListModel);
  1106. if(rationGLJs.length > 0) await insertMany(rationGLJs,rationGLJModel);
  1107. if(rationCoes.length > 0) await insertMany(rationCoes,rationCoeModel);
  1108. if(quantityDetails.length > 0) await insertMany(quantityDetails,quantityDetailModel);
  1109. if(rationInstallations.length > 0) await insertMany(rationInstallations,rationInstallationModel);
  1110. if(rationTemplates.length > 0) await insertMany(rationTemplates,rationTemplateModel);
  1111. if(newCalcProgramsFile) await calcProgramsModel.create(newCalcProgramsFile);
  1112. if(newLabourCoe) await labourCoesModel.create(newLabourCoe);
  1113. }
  1114. function setRationSubList(datas,newProjectID,billIDMap,rationIDMap,projectGLJIDMap) {
  1115. let arrs = [];
  1116. for(let d of datas){
  1117. delete d._id;
  1118. d = getCopyRationSubData(d,newProjectID,billIDMap,rationIDMap,projectGLJIDMap);
  1119. arrs.push(d);
  1120. }
  1121. return arrs;
  1122. }
  1123. async function handleMainProjectDatas(mainData,updateData,userID) {
  1124. let mainProjectID = -1;
  1125. let projectIDMap = {},feeRateFileIDMap={},unitPriceFileIDMap={},labourCoeFileIDMap={},calcProgramFileIDMap={};
  1126. let tasks = [];
  1127. //生成新的projectID
  1128. for(let p of mainData.projects){
  1129. let newProjectID = await getCounterID("projects");
  1130. projectIDMap[p.ID] = newProjectID;
  1131. if(p.projType == "Project") mainProjectID = newProjectID;
  1132. if(p.projType == "Tender"){
  1133. if(p.property.calcProgramFile) calcProgramFileIDMap[p.property.calcProgramFile.ID] = uuidV1();//新的计算程序文件ID
  1134. if(p.property.labourCoeFile) labourCoeFileIDMap[p.property.labourCoeFile.ID] = uuidV1();//新的人工调整系数文件ID
  1135. if(p.property.feeFile) feeRateFileIDMap[p.property.feeFile.id] = uuidV1();//新的费率文件ID
  1136. if(p.property.unitPriceFile) unitPriceFileIDMap[p.property.unitPriceFile.id] = await getCounterID("unit_price_file");//新的单价文件ID
  1137. }
  1138. }
  1139. if(mainProjectID == -1) throw new Error("文件里面没包含建设项目信息!");
  1140. //处理项目信息 ----- 费率文件,单价文件ID信息要重新生成----to do
  1141. for(let p of mainData.projects){
  1142. delete p._id;
  1143. delete p.__v;
  1144. p.ID = projectIDMap[p.ID];
  1145. if(p.ID == mainProjectID){//对于建设项目,要父和下一节点ID要使用前端传入的位置ID
  1146. p.ParentID = updateData.self.ParentID;
  1147. p.NextSiblingID = updateData.self.NextSiblingID;
  1148. if(updateData.update){//树节构中的上一节点的下一节点设置为本建设项目ID;
  1149. tasks.push({updateOne:{filter : updateData.update.query, update : {NextSiblingID:mainProjectID}}});
  1150. }
  1151. //查看是否重名;
  1152. let temp = await projectModel.findOne({userID:userID,ParentID:p.ParentID,name:p.name});
  1153. if(temp) p.name = p.name + '(' + moment(Date.now()).format('MM-DD HH:mm:ss') + '导入)';
  1154. }else {
  1155. p.ParentID = projectIDMap[p.ParentID];
  1156. p.NextSiblingID = projectIDMap[p.NextSiblingID];
  1157. }
  1158. p.userID =userID;
  1159. p.shareInfo=[];
  1160. if(p.projType == "Tender"){
  1161. if(p.property.calcProgramFile) p.property.calcProgramFile.ID = calcProgramFileIDMap[p.property.calcProgramFile.ID];
  1162. if(p.property.labourCoeFile) p.property.labourCoeFile.ID = labourCoeFileIDMap[p.property.labourCoeFile.ID];
  1163. if(p.property.feeFile) p.property.feeFile.id = feeRateFileIDMap[p.property.feeFile.id];
  1164. if(p.property.unitPriceFile) p.property.unitPriceFile.id = unitPriceFileIDMap[p.property.unitPriceFile.id];
  1165. p.property.rootProjectID = mainProjectID
  1166. }
  1167. tasks.push({insertOne: {document: p}})
  1168. }
  1169. //项目树节构数据生成:
  1170. await projectModel.bulkWrite(tasks);
  1171. //生成所有的费率文件
  1172. await importFeeRateFiles(mainData,projectIDMap,feeRateFileIDMap,userID);
  1173. //生成所有的单价文件
  1174. await importUnitPriceFiles(mainData,projectIDMap,unitPriceFileIDMap,userID);
  1175. return [projectIDMap,labourCoeFileIDMap,calcProgramFileIDMap]
  1176. }
  1177. async function importUnitPriceFiles(mainData,projectIDMap,unitPriceFileIDMap,userID) {
  1178. if(!mainData.files.unitFiles) return;
  1179. let unitFiles = [],unitPrices =[],mixRatios=[],freights=[],originals=[];
  1180. for(let f of mainData.files.unitFiles){
  1181. let file = f.unitFile,prices = f.unitPrices,mixs = f.mixRatios,fres = f.freights,ors = f.originals;
  1182. //生成单价文件
  1183. delete file._id;
  1184. file.id = unitPriceFileIDMap[file.id]?unitPriceFileIDMap[file.id]:await getCounterID("unit_price_file");
  1185. file.project_id = projectIDMap[file.project_id];
  1186. file.root_project_id = projectIDMap[file.root_project_id];
  1187. file.user_id = userID;
  1188. unitFiles.push(file);
  1189. //生成子数据
  1190. if(prices) await setSubList(prices,unitPrices,file.id,unitPriceModel);
  1191. if(mixs) await setSubList(mixs,mixRatios,file.id,mixRatioModel);
  1192. if(fres) await setSubList(fres,freights,file.id,freightModel,true);
  1193. if(ors) await setSubList(ors,originals,file.id,originalModel,true);
  1194. }
  1195. if(unitFiles.length > 0) await insertMany(unitFiles,unitPriceFileModel);
  1196. if(unitPrices.length > 0) await insertMany(unitPrices,unitPriceModel);
  1197. if(mixRatios.length > 0) await insertMany(mixRatios,mixRatioModel);
  1198. if(freights.length > 0) await insertMany(freights,freightModel);
  1199. if(originals.length > 0) await insertMany(originals,originalModel);
  1200. async function setSubList(oList,nList,fileID,model,UUID=false) {
  1201. for(let o of oList){
  1202. delete o._id;
  1203. o.unit_price_file_id = fileID;
  1204. UUID == true?o.ID = uuidV1():o.id = await getCounterID(model.modelName);
  1205. nList.push(o)
  1206. }
  1207. }
  1208. }
  1209. async function importFeeRateFiles(mainData,projectIDMap,feeRateFileIDMap,userID) {
  1210. let feeRateFiles = [], feeRates = [];
  1211. if(!mainData.files.feeRateFiles) return;
  1212. for(let f of mainData.files.feeRateFiles){
  1213. //生成费率记录
  1214. let rate = f.feeRate;
  1215. delete rate._id;
  1216. rate.ID = uuidV1();
  1217. feeRates.push(rate);
  1218. //生成费率文件记录
  1219. let file = f.feeRateFile;
  1220. delete file._id;
  1221. file.ID = feeRateFileIDMap[file.ID]?feeRateFileIDMap[file.ID]:uuidV1();
  1222. file.userID = userID;
  1223. file.rootProjectID = projectIDMap[file.rootProjectID];
  1224. file.feeRateID = rate.ID;
  1225. feeRateFiles.push(file);
  1226. }
  1227. if(feeRateFiles.length > 0) await insertMany(feeRateFiles,feeRateFileModel);
  1228. if(feeRates.length > 0) await insertMany(feeRates,feeRateModel);
  1229. }