pm_facade.js 56 KB

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