pm_facade.js 38 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940
  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. };
  30. let mongoose = require('mongoose');
  31. let _ = require("lodash");
  32. let feeRate_facade = require('../../fee_rates/facade/fee_rates_facade');
  33. let glj_facade = require('../../glj/facade/glj_facade');
  34. let project_facade = require('../../main/facade/project_facade');
  35. let logger = require("../../../logs/log_helper").logger;
  36. const uuidV1 = require('uuid/v1');
  37. let projectModel = mongoose.model('projects');
  38. let projectSettingModel = mongoose.model('proj_setting');
  39. let billsModel = mongoose.model('bills');
  40. let rationModel = mongoose.model('ration');
  41. let gljListModel = mongoose.model("glj_list");
  42. let calcProgramsModel = mongoose.model('calc_programs');
  43. let labourCoesModel = mongoose.model('labour_coes');
  44. let feeRateModel = mongoose.model('fee_rates');
  45. let feeRateFileModel = mongoose.model('fee_rate_file');
  46. let unitPriceFileModel = mongoose.model("unit_price_file");
  47. let mixRatioModel = mongoose.model("mix_ratio");
  48. let unitPriceModel = mongoose.model("unit_price");
  49. let installationFeeModel = mongoose.model("installation_fee");
  50. let rationGLJModel = mongoose.model('ration_glj');
  51. let rationCoeModel = mongoose.model('ration_coe');
  52. let rationInstallationModel = mongoose.model('ration_installation');
  53. let quantityDetailModel = mongoose.model('quantity_detail');
  54. let rationTemplateModel = mongoose.model('ration_template');
  55. let userModel = mongoose.model('user');
  56. let compleGljSectionModel = mongoose.model('complementary_glj_section');
  57. let compleGljSectionTModel = mongoose.model('complementary_glj_section_templates');
  58. let progressiveModel = mongoose.model('std_progressive_lib');
  59. let featureLibModel = mongoose.model("std_project_feature_lib");
  60. let scMathUtil = require('../../../public/scMathUtil').getUtil();
  61. let counter = require('../../../public/counter/counter');
  62. import SectionTreeDao from '../../complementary_ration_lib/models/sectionTreeModel';
  63. let sectionTreeDao = new SectionTreeDao();
  64. import CounterModel from "../../glj/models/counter_model";
  65. import moment from 'moment';
  66. import billsFlags from '../../common/const/bills_fixed';
  67. const notDeleted = [{deleteInfo: null}, {'deleteInfo.deleted': false}];
  68. //拷贝例题项目
  69. //@param {String}userID {Array}projIDs拷贝的例题项目ID(建设项目、文件夹)@return {Boolean}
  70. async function copyExample(userID, compilation, projIDs){
  71. let allProjs = [],
  72. IDMapping = {},
  73. projMapping = {};
  74. //例题项目不可为单项工程、单位工程、只能是建设项目、文件夹,否则不自动新建例题项目(这里不报错,让用户没有感觉)
  75. let parentExample = await projectModel.find({ID: {$in: projIDs}, $or: notDeleted});
  76. if (parentExample.length === 0) {
  77. return false;
  78. }
  79. allProjs = allProjs.concat(parentExample);
  80. for (let i = 0; i < parentExample.length; i++) {
  81. let data = parentExample[i];
  82. if (data.projType === projectType.tender || data.projType === projectType.engineering) {
  83. return false;
  84. }
  85. //设置成顶节点,最后一个节点设置成末节
  86. data.ParentID = -1;
  87. if (i === parentExample.length - 1) {
  88. data.NextSiblingID = -1;
  89. }
  90. }
  91. //获取所有的子项目
  92. let posterityProjs = await getPosterityProjects(projIDs);
  93. allProjs = allProjs.concat(posterityProjs);
  94. let projCounter = await counter.counterDAO.getIDAfterCountSync(counter.moduleName.project, allProjs.length);
  95. //旧ID与新ID映射
  96. for (let i = 0; i < allProjs.length; i++) {
  97. let data = allProjs[i];
  98. let newID = projCounter.sequence_value - (allProjs.length - 1) + i;
  99. IDMapping[data.ID] = newID;
  100. projMapping[newID] = data;
  101. }
  102. //return;
  103. //设置新的树结构数据
  104. let newDate = new Date(),
  105. parentBulks = [];
  106. for (let data of allProjs) {
  107. let orgID = data.ID;
  108. data.ID = IDMapping[data.ID];
  109. data.ParentID = IDMapping[data.ParentID] ? IDMapping[data.ParentID] : -1;
  110. data.NextSiblingID = IDMapping[data.NextSiblingID] ? IDMapping[data.NextSiblingID] : -1;
  111. data.createDateTime = newDate;
  112. data.userID = userID;
  113. data.compilation = compilation;
  114. data.shareInfo = [];
  115. if (data.projType !== projectType.tender) {
  116. let newData = _.cloneDeep(data._doc);
  117. delete newData._id;
  118. // await projectModel.create(newData);
  119. parentBulks.push({insertOne: {document: newData}});
  120. } else {
  121. //拷贝单位工程
  122. let rootProjectID = projMapping[data.ParentID].ParentID;
  123. let projectMap = {
  124. copy: {
  125. document: {userID: userID, ID: orgID, NextSiblingID: data.NextSiblingID, ParentID: data.ParentID, name: data.name, shareInfo: [],
  126. compilation: compilation, fileVer: data.fileVer, projType: data.projType, property: {rootProjectID: rootProjectID}}
  127. }
  128. };
  129. await copyProject(userID, compilation, {projectMap}, data.ID);
  130. }
  131. }
  132. //最末顶层项目(兼容测试时已存在有项目,正常用户第一次进费用定额,该费用定额不存在项目)
  133. let lastProj = await projectModel.findOne({userID: userID, compilation: compilation, ParentID: -1, NextSiblingID: -1, $or: notDeleted});
  134. if (lastProj) {
  135. parentBulks.push({updateOne: {filter: {ID: lastProj.ID}, update: {$set: {NextSiblingID: parentExample[0].ID}}}});
  136. }
  137. //拷贝父级文件
  138. await projectModel.bulkWrite(parentBulks);
  139. return true;
  140. }
  141. async function copyProject(userID, compilationID,data,newProjectID = null) {
  142. let projectMap = data.projectMap;
  143. let originalID = projectMap['copy'].document.ID;
  144. if (!newProjectID) {
  145. newProjectID = await getCounterID("projects");
  146. }
  147. let newFeeName = null,newUnitName = null;
  148. let calcProgramFileID = uuidV1();//新的计算程序文件ID
  149. let labourCoeFileID = uuidV1();//新的人工调整系数文件ID
  150. let feeRateFileID = uuidV1();//新的费率文件ID
  151. let unitPriceFileID = await getCounterID("unit_price_file");//新的单价文件ID
  152. let originalProject = await projectModel.findOne({'ID':originalID});//查找最新的那项目信息,前端缓存的数据有可能不是最新的
  153. if(!originalProject){
  154. throw new Error('没有找到对应的项目,复制失败!');
  155. }
  156. let property = originalProject.property;
  157. if(projectMap['copy'].document.property){//更新项目属性信息
  158. setProperty(property,projectMap['copy'].document.property);
  159. }
  160. let originalProperty = _.cloneDeep(property);
  161. projectMap['copy'].document.property = property;
  162. logger.info("复制项目: 旧项目ID: "+originalID+ " ------- 新项目ID: "+newProjectID);
  163. //费率文件、单价文件重名检查
  164. let feeRate = await feeRateFileModel.findOne({rootProjectID:originalProperty.rootProjectID,name:originalProperty.feeFile.name,deleteInfo:null});
  165. if(feeRate){//存在重名的文件
  166. newFeeName = originalProperty.feeFile.name + '(' + moment(Date.now()).format('MM-DD HH:mm:ss') + '复制)';
  167. projectMap['copy'].document.property.feeFile.name = newFeeName;
  168. }
  169. let unitPriceFile = await unitPriceFileModel.findOne({root_project_id: originalProperty.rootProjectID,name:originalProperty.unitPriceFile.name,deleteInfo: null});
  170. if(unitPriceFile){//存在重名的文件
  171. newUnitName = originalProperty.unitPriceFile.name + '(' + moment(Date.now()).format('MM-DD HH:mm:ss') + '复制)';
  172. projectMap['copy'].document.property.unitPriceFile.name = newUnitName;
  173. }
  174. //更新项目的属性;
  175. projectMap['copy'].document.ID = newProjectID;
  176. if(projectMap['copy'].document.property.calcProgramFile){
  177. projectMap['copy'].document.property.calcProgramFile.ID = calcProgramFileID;
  178. }
  179. if(projectMap['copy'].document.property.labourCoeFile){
  180. projectMap['copy'].document.property.labourCoeFile.ID = labourCoeFileID;
  181. }
  182. if(projectMap['copy'].document.property.feeFile){
  183. projectMap['copy'].document.property.feeFile.id = feeRateFileID;
  184. }
  185. if(projectMap['copy'].document.property.unitPriceFile){
  186. projectMap['copy'].document.property.unitPriceFile.id = unitPriceFileID;
  187. }
  188. projectMap['copy'].document.userID = userID;
  189. projectMap['copy'].document.compilation = compilationID;
  190. projectMap['copy'].document.createDateTime = new Date();
  191. //清单、定额ID生成任务
  192. let IDtasks = [
  193. createIDsAndReturn(originalID,billsModel),
  194. createIDsAndReturn(originalID,rationModel),
  195. getProjectGLJIDAndReturn(originalID,newProjectID)
  196. ];
  197. let [billMap,rationMap,projectGLJMap] = await Promise.all(IDtasks);
  198. //所有复制任务异步处理,提升效率 复制清单,定额,4个文件,项目工料机, 定额工料机,人工系数,工程量明细,定额安装增加费,安装增加费
  199. let copyTasks = [
  200. createProject(projectMap),
  201. copyProjectSetting(originalID,newProjectID),
  202. copyBills(newProjectID,billMap),
  203. copyRations(newProjectID,billMap.uuidMaping,rationMap,projectGLJMap.IDMap),
  204. copyProjectGLJ(projectGLJMap.datas),
  205. copyInstallFee(originalID,newProjectID),
  206. copyRationSubList(originalID,newProjectID,billMap.uuidMaping,rationMap.uuidMaping,projectGLJMap.IDMap,rationGLJModel),
  207. copyRationSubList(originalID,newProjectID,billMap.uuidMaping,rationMap.uuidMaping,projectGLJMap.IDMap,rationCoeModel),
  208. copyRationSubList(originalID,newProjectID,billMap.uuidMaping,rationMap.uuidMaping,projectGLJMap.IDMap,quantityDetailModel),
  209. copyRationSubList(originalID,newProjectID,billMap.uuidMaping,rationMap.uuidMaping,projectGLJMap.IDMap,rationInstallationModel),
  210. copyRationSubList(originalID,newProjectID,billMap.uuidMaping,rationMap.uuidMaping,projectGLJMap.IDMap,rationTemplateModel)
  211. ];
  212. if(originalProperty.calcProgramFile){
  213. copyTasks.push(commonCopy(newProjectID,originalProperty.calcProgramFile.ID,calcProgramFileID,calcProgramsModel));
  214. }
  215. if(originalProperty.labourCoeFile){
  216. copyTasks.push(commonCopy(newProjectID,originalProperty.labourCoeFile.ID,labourCoeFileID,labourCoesModel));
  217. }
  218. if(originalProperty.feeFile){
  219. copyTasks.push(copyFeeRate(originalProperty.rootProjectID,userID,originalProperty.feeFile.id,feeRateFileID,newFeeName));
  220. }
  221. if(originalProperty.unitPriceFile){
  222. copyTasks.push(copyUnitPriceFile(newProjectID,originalProperty.rootProjectID,userID,originalProperty.unitPriceFile.id,unitPriceFileID,newUnitName));
  223. }
  224. let p = await Promise.all(copyTasks);
  225. return p[0];
  226. }
  227. async function createIDsAndReturn(originalID,model) {
  228. let uuidMaping = {};//做ID映射
  229. let datas = [];
  230. let result = await model.find({"projectID": originalID}, '-_id');
  231. uuidMaping['-1'] = -1;
  232. //建立uuid-ID映射
  233. for(let d of result){
  234. uuidMaping[d.ID] = uuidV1();
  235. datas.push(d._doc);
  236. }
  237. return{uuidMaping:uuidMaping,datas:datas};
  238. }
  239. async function getProjectGLJIDAndReturn(originalID,newProjectID) {
  240. let IDMap = {};
  241. let datas = [];
  242. let result = await gljListModel.find({project_id:originalID}, '-_id');
  243. let gljCount = await counter.counterDAO.getIDAfterCountSync(counter.moduleName.glj_list, result.length);
  244. for(let i = 0; i < result.length; i++){
  245. let d = result[i];
  246. let newID = gljCount.sequence_value - (result.length - 1) + i;
  247. //let newID = await getCounterID("glj_list");
  248. IDMap[d.id] = newID;
  249. d._doc.project_id = newProjectID;
  250. d._doc.id = newID;
  251. datas.push(d._doc);
  252. }
  253. return{IDMap:IDMap,datas:datas};
  254. }
  255. async function createProject(projectMap) {//复制项目
  256. let tasks = [];
  257. if(projectMap['update']){//如果复制后存在前一个节点,则更新其NextSiblingID
  258. tasks.push({updateOne:{filter : projectMap['update'].query, update : {NextSiblingID:projectMap['copy'].document.ID}}});
  259. }
  260. tasks.push({insertOne: {document: projectMap['copy'].document}});//复制任务
  261. await projectModel.bulkWrite(tasks);
  262. return projectMap;
  263. }
  264. async function copyProjectSetting(originalID,newProjectID) {
  265. let result = null;
  266. let setting = await projectSettingModel.findOne({"projectID": originalID}, '-_id');
  267. if(setting){
  268. setting._doc.projectID =newProjectID;
  269. result = await projectSettingModel.create(setting._doc);
  270. }
  271. return result;
  272. }
  273. async function copyBills(newProjectID,billMap) {
  274. let uuidMaping = billMap.uuidMaping;//做ID映射
  275. for(let doc of billMap.datas){
  276. doc.projectID = newProjectID;
  277. doc.ID = uuidMaping[doc.ID] ? uuidMaping[doc.ID] : -1;
  278. doc.ParentID = uuidMaping[doc.ParentID] ? uuidMaping[doc.ParentID] : -1;
  279. doc.NextSiblingID = uuidMaping[doc.NextSiblingID] ? uuidMaping[doc.NextSiblingID] : -1;
  280. }
  281. await insertMany(billMap.datas,billsModel);
  282. return billMap.datas;
  283. }
  284. async function copyRations(newProjectID,billsIDMap,rationMap,projectGLJIDMap) {
  285. let uuidMaping = rationMap.uuidMaping;
  286. for(let doc of rationMap.datas){
  287. doc.projectID = newProjectID;
  288. doc.ID = uuidMaping[doc.ID] ? uuidMaping[doc.ID] : -1;
  289. if(doc.billsItemID){
  290. doc.billsItemID = billsIDMap[doc.billsItemID]?billsIDMap[doc.billsItemID]:-1;
  291. }
  292. if(doc.referenceRationID) doc.referenceRationID = uuidMaping[doc.referenceRationID]?uuidMaping[doc.referenceRationID]:undefined;
  293. //绑定定类型的工料机 项目工料机ID
  294. doc.type==3&&doc.projectGLJID&&projectGLJIDMap[doc.projectGLJID]?doc.projectGLJID = projectGLJIDMap[doc.projectGLJID]:'';
  295. }
  296. if(rationMap.datas.length > 0){
  297. await insertMany(rationMap.datas,rationModel);
  298. }
  299. return rationMap.datas;
  300. }
  301. async function copyProjectGLJ(gljList) {
  302. await insertMany(gljList,gljListModel);
  303. }
  304. async function commonCopy(newProjectID,oldID,newID,model) { //对于只需更新ID和projectID的文件的复制
  305. let result = null;
  306. let file = await model.findOne({"ID": oldID}, '-_id');
  307. if(file){
  308. file._doc.ID = newID;
  309. file._doc.projectID =newProjectID;
  310. result = await model.create(file._doc);
  311. }
  312. return result;
  313. }
  314. async function copyFeeRate(rootProjectID,userID,originalFeeRateFileID,feeRateFileID,newName) {//复制费率和费率文件
  315. let [feeRateFile,feeRate] =await feeRate_facade.getFeeRateByID(originalFeeRateFileID);
  316. let newFeeRateID = uuidV1();
  317. if(feeRate){
  318. feeRate._doc.ID = newFeeRateID;
  319. await feeRateModel.create(feeRate._doc);
  320. }
  321. if(feeRateFile){
  322. feeRateFile._doc.ID = feeRateFileID;
  323. newName?feeRateFile._doc.name = newName:'';
  324. feeRateFile._doc.userID = userID;
  325. feeRateFile._doc.rootProjectID = rootProjectID;
  326. feeRateFile._doc.feeRateID = newFeeRateID;
  327. await feeRateFileModel.create(feeRateFile._doc);
  328. }
  329. }
  330. async function copyUnitPriceFile(newProjectID,rootProjectID,userID,originaluUnitPriceFileID,unitPriceFileID,newName) {//复制单价文件、组成物
  331. let taskList = [
  332. copyFile(newProjectID,rootProjectID,userID,originaluUnitPriceFileID,unitPriceFileID,newName),
  333. copySubList(originaluUnitPriceFileID,unitPriceFileID,mixRatioModel),
  334. copySubList(originaluUnitPriceFileID,unitPriceFileID,unitPriceModel)
  335. ];
  336. return await Promise.all(taskList);
  337. async function copyFile(newProjectID,rootProjectID,userID,originaluUnitPriceFileID,unitPriceFileID,newName){
  338. let unitPriceFile = await unitPriceFileModel.findOne({id:originaluUnitPriceFileID}, '-_id');
  339. if(unitPriceFile){
  340. unitPriceFile._doc.id = unitPriceFileID;
  341. newName?unitPriceFile._doc.name = newName:'';
  342. unitPriceFile._doc.project_id = newProjectID;
  343. unitPriceFile._doc.user_id = userID;
  344. unitPriceFile._doc.root_project_id = rootProjectID
  345. }
  346. await unitPriceFileModel.create(unitPriceFile._doc);
  347. }
  348. async function copySubList(srcFID,newFID,model) {
  349. let mList = await model.find({unit_price_file_id: srcFID}, '-_id');
  350. let rList = [];
  351. for(let m of mList){
  352. m._doc.unit_price_file_id = newFID;
  353. m._doc.id = await getCounterID(model.modelName);
  354. rList.push(m._doc);
  355. }
  356. await insertMany(rList,model)
  357. }
  358. }
  359. async function copyInstallFee(originalPID,newProjectID) {
  360. let result = null;
  361. let installationFee = await installationFeeModel.find({projectID:originalPID}, '-_id');
  362. let newList = [];
  363. for(let i of installationFee ){
  364. i._doc.ID = uuidV1();
  365. i._doc.projectID = newProjectID;
  366. newList.push(i._doc);
  367. }
  368. if(newList.length >0){
  369. result = await installationFeeModel.insertMany(newList);
  370. }
  371. return result;
  372. }
  373. async function copyRationSubList(originalPID,newProjectID,billIDMap,rationIDMap,projectGLJIDMap,model) {// 定额工料机,附注条件,工程量明细,定额安装增加费
  374. let subList = await model.find({projectID:originalPID}, '-_id');
  375. let newList =[];
  376. for(let s of subList){
  377. s._doc.ID = uuidV1();
  378. s._doc.projectID = newProjectID;
  379. s._doc.rationID&&rationIDMap[s._doc.rationID]?s._doc.rationID = rationIDMap[s._doc.rationID]:'';
  380. s._doc.billID&&billIDMap[s._doc.billID]?s._doc.billID = billIDMap[s._doc.billID]:'';
  381. s._doc.billsItemID&&billIDMap[s._doc.billsItemID]?s._doc.billsItemID = billIDMap[s._doc.billsItemID]:'';
  382. s._doc.projectGLJID&&projectGLJIDMap[s._doc.projectGLJID]?s._doc.projectGLJID = projectGLJIDMap[s._doc.projectGLJID]:'';
  383. if(s._doc.templateList && s._doc.templateList.length > 0 ){
  384. for(let t of s._doc.templateList){
  385. if(t.billID && billIDMap[t.billID]) t.billID = billIDMap[t.billID];
  386. if(t.fxID && billIDMap[t.fxID]) t.fxID = billIDMap[t.fxID];
  387. }
  388. }
  389. newList.push(s._doc);
  390. }
  391. await insertMany(newList,model);
  392. }
  393. async function moveProject(data) {
  394. data = JSON.parse(data);
  395. let projectMap = data.projectMap,feeRateMap = data.feeRateMap,unitPriceMap = data.unitPriceMap;
  396. let projectTasks = [],feeRateTask=[],feeRateFileTask=[],unitPriceTask=[],unitPriceFileTask=[],mixRatioTask=[];
  397. let feeUniqMap=[],priceUniqMap={};//费率、单价文件唯一映射表当移动多个项目时,任务有可能出现重复的情况
  398. if(!_.isEmpty(feeRateMap)&&data.rootProjectID){//如果费率有修改
  399. let feeRates =await feeRate_facade.getFeeRatesByProject(data.rootProjectID);//取目标建设项目的所有费率文件,重名检查
  400. for(let projectID in feeRateMap){
  401. let rename = feeRateMap[projectID].name;
  402. let feeRateID = feeRateMap[projectID].query.ID;
  403. let checkFee = _.find(feeRates,{'name':rename});
  404. let newID = feeRateID;
  405. if(checkFee){//说明费率名字已存在,需要重命名
  406. rename = feeUniqMap[feeRateID]?feeUniqMap[feeRateID].name:rename + '(' + new Date().Format('MM-dd hh:mm:ss') + '移动)';
  407. projectMap[projectID]['update']['property.feeFile.name'] = rename;
  408. if(feeRateMap[projectID].action == 'move'){
  409. feeRateMap[projectID].update.name = rename;
  410. }
  411. }
  412. if(feeRateMap[projectID].action == 'copy'){
  413. newID = feeUniqMap[feeRateID]?feeUniqMap[feeRateID].ID:uuidV1();
  414. feeRateMap[projectID].name = rename;
  415. feeRateMap[projectID].ID = newID;
  416. projectMap[projectID]['update']['property.feeFile.id'] = newID;
  417. }
  418. if(!feeUniqMap[feeRateID]){
  419. await generateFeeRateTask(feeRateMap[projectID],feeRateTask,feeRateFileTask);
  420. feeUniqMap[feeRateID] = {name:rename,ID:newID};
  421. }
  422. }
  423. }
  424. if(!_.isEmpty(unitPriceMap)&&data.rootProjectID) {//如果单价文件有修改
  425. let unitPriceFiles = await unitPriceFileModel.find({root_project_id: data.rootProjectID, deleteInfo: null});
  426. for(let projectID in unitPriceMap){
  427. let checkUn = _.find(unitPriceFiles,{'name':unitPriceMap[projectID].name});
  428. let rename = unitPriceMap[projectID].name;
  429. let unitPriceID = unitPriceMap[projectID].query.id;
  430. let newID = unitPriceID;
  431. if(checkUn){//重名检查
  432. rename = priceUniqMap[unitPriceID]?priceUniqMap[unitPriceID].name:rename + '(' + new Date().Format('MM-dd hh:mm:ss') + '移动)';
  433. projectMap[projectID]['update']['property.unitPriceFile.name'] = rename;
  434. if(unitPriceMap[projectID].action =='move'){
  435. unitPriceMap[projectID].update.name = rename;
  436. }
  437. }
  438. if(unitPriceMap[projectID].action =='copy'){
  439. newID = priceUniqMap[unitPriceID]?priceUniqMap[unitPriceID].id: await getCounterID("unit_price_file");
  440. unitPriceMap[projectID].name = rename;
  441. unitPriceMap[projectID].id = newID;
  442. projectMap[projectID]['update']['property.unitPriceFile.id'] = newID;
  443. }
  444. if(!priceUniqMap[unitPriceID]){
  445. await generateUnitPriceTask(unitPriceMap[projectID],projectID,data.user_id,unitPriceTask,unitPriceFileTask,mixRatioTask);
  446. priceUniqMap[unitPriceID] = {name:rename,id:newID};
  447. }
  448. }
  449. }
  450. if(!_.isEmpty(projectMap)){
  451. for(let projectID in projectMap){
  452. projectTasks.push({updateOne:{filter : projectMap[projectID].query, update : projectMap[projectID].update}});
  453. }
  454. }
  455. projectTasks.length>0?await projectModel.bulkWrite(projectTasks):'';
  456. feeRateTask.length>0?await feeRateModel.bulkWrite(feeRateTask):'';
  457. feeRateFileTask.length>0?await feeRateFileModel.bulkWrite(feeRateFileTask):'';
  458. unitPriceFileTask.length>0?await unitPriceFileModel.bulkWrite(unitPriceFileTask):'';
  459. unitPriceTask.length>0?await insertMany(unitPriceTask,unitPriceModel):'';
  460. mixRatioTask.length>0?await insertMany(mixRatioTask,mixRatioModel):'';
  461. return projectMap;
  462. }
  463. async function generateFeeRateTask(data,feeRateTask,feeRateFileTask) {
  464. if(data.action == 'move'){
  465. let task = {
  466. updateOne:{
  467. filter : data.query,
  468. update : data.update
  469. }
  470. };
  471. feeRateFileTask.push(task);
  472. }
  473. if(data.action == 'copy'){//copy 费率的时候用insertOne方法
  474. let [feeRateFile,feeRate] =await feeRate_facade.getFeeRateByID(data.query.ID);
  475. let newFeeRateID = uuidV1();
  476. let newFeeRate = {
  477. ID:newFeeRateID,
  478. rates:feeRate.rates
  479. };
  480. let newFeeRateFile = {
  481. ID:data.ID,
  482. rootProjectID:data.rootProjectID,
  483. userID:feeRateFile.userID,
  484. name:data.name,
  485. libID:feeRateFile.libID,
  486. libName:feeRateFile.libName,
  487. feeRateID:newFeeRateID
  488. };
  489. feeRateTask.push({insertOne :{document:newFeeRate}});
  490. feeRateFileTask.push({insertOne :{document:newFeeRateFile}});
  491. }
  492. }
  493. async function generateUnitPriceTask(data,projectID,user_id,unitPriceTask,unitPriceFileTask,mixRatioTask){
  494. if(data.action == 'move'){
  495. let task = {
  496. updateOne:{
  497. filter : data.query,
  498. update : data.update
  499. }
  500. };
  501. unitPriceFileTask.push(task);
  502. }
  503. if(data.action == 'copy'){
  504. let newUnitFile = {
  505. id:data.id,
  506. name: data.name,
  507. project_id:projectID,
  508. user_id:user_id,
  509. root_project_id: data.rootProjectID
  510. };
  511. unitPriceFileTask.push({insertOne :{document:newUnitFile}});
  512. let mixRatios = await mixRatioModel.find({unit_price_file_id: data.query.id});
  513. mixRatios = JSON.stringify(mixRatios);
  514. mixRatios = JSON.parse(mixRatios);
  515. for(let m of mixRatios){
  516. delete m._id; // 删除原有id信息
  517. delete m.id;
  518. m.unit_price_file_id = data.id;
  519. m.id = await getCounterID('mix_ratio');
  520. mixRatioTask.push(m);
  521. }
  522. let unitPrices = await unitPriceModel.find({unit_price_file_id: data.query.id});//unit_price_file_id
  523. unitPrices = JSON.stringify(unitPrices);
  524. unitPrices = JSON.parse(unitPrices);
  525. for(let u of unitPrices){
  526. delete u._id; // 删除原有id信息
  527. delete u.id;
  528. u.unit_price_file_id = data.id;
  529. u.id = await getCounterID('unit_price');
  530. unitPriceTask.push(u);
  531. }
  532. }
  533. }
  534. async function getCounterID(collectionName){
  535. let counterModel = new CounterModel();
  536. return await counterModel.getId(collectionName);
  537. }
  538. async function insertMany(datas,model) {
  539. while (datas.length>1000){//因为mongoose限制了批量插入的条数为1000.所以超出限制后需要分批插入
  540. let newList = datas.splice(0,1000);//一次插入1000条
  541. await model.insertMany(newList);
  542. }
  543. await model.insertMany(datas);
  544. }
  545. function setProperty(Obj,updateData) {
  546. for(let ukey in updateData){
  547. if(_.isObject(updateData[ukey]) && _.isObject(Obj[ukey])){
  548. setProperty(Obj[ukey],updateData[ukey]);
  549. }else {
  550. Obj[ukey] = updateData[ukey];
  551. }
  552. }
  553. }
  554. function isDef(v){
  555. return typeof v !== 'undefined' && v !== null;
  556. }
  557. function getCommonTotalFee(bills) {
  558. if(!isDef(bills)){
  559. return 0;
  560. }
  561. if(!isDef(bills.fees) || bills.fees.length <= 0){
  562. return 0;
  563. }
  564. for(let fee of bills.fees){
  565. if(isDef(fee.fieldName) && fee.fieldName === 'common'){
  566. return isDef(fee.totalFee) ? fee.totalFee : 0;
  567. }
  568. }
  569. return 0;
  570. }
  571. function summarizeToParent(parent, child) {
  572. const decimal = -2;
  573. let costFields = ['totalCost'];
  574. for (let field of costFields) {
  575. parent[field] = scMathUtil.roundTo(parseFloat(parent[field]) + parseFloat(child[field]), decimal);
  576. }
  577. }
  578. function getBuildingArea(projFeature){
  579. if(!projFeature || projFeature.length === 0){
  580. return null;
  581. }
  582. for(let f of projFeature){
  583. if(f.key === 'buildingArea'){
  584. return f.value;
  585. }
  586. }
  587. return null;
  588. }
  589. //根据单位工程ID获取汇总信息
  590. //@param {Number}tenderID {String}summaryType @return {Object}
  591. async function getSummaryInfoByTender(tenderID, summaryType) {
  592. const notDeleted = [{deleteInfo: null}, {'deleteInfo.deleted': false}];
  593. let tender = await projectModel.findOne({ID: tenderID, $or: notDeleted});
  594. let parentName;
  595. let summaryList = [];
  596. if(!tender){
  597. return null;
  598. }
  599. let project = await projectModel.findOne({ID: tender.ParentID, $or: notDeleted});
  600. if(!project){
  601. return null;
  602. }
  603. let summaryInfo = await getSummaryInfo([project.ID]);
  604. //已经没有单项工程这一层
  605. if(summaryType === projectType.engineering){
  606. /*parentName = engineering.name ? engineering.name : '';
  607. let tenders = await projectModel.find({ParentID: engineering.ID, $or: notDeleted});
  608. for(let t of tenders){
  609. if(summaryInfo[t.ID]){
  610. summaryInfo[t.ID]['name'] = t.name ? t.name : '';
  611. summaryList.push(summaryInfo[t.ID]);
  612. }
  613. }*/
  614. }
  615. else {
  616. parentName = project.name ? project.name : '';
  617. let tenders = await projectModel.find({ParentID: project.ID, $or: notDeleted});
  618. for(let t of tenders){
  619. if(summaryInfo[t.ID]){
  620. summaryInfo[t.ID]['name'] = t.name ? t.name : '';
  621. summaryList.push(summaryInfo[t.ID]);
  622. }
  623. }
  624. }
  625. return {parent: {name: parentName}, subList: summaryList};
  626. }
  627. //获取单位工程的各标段费用信息(不进行汇总)
  628. async function getTendersFeeInfo(tenders) {
  629. let IDMapping = {};
  630. //固定清单类别与汇总金额字段映射
  631. let flagFieldMapping = {};
  632. flagFieldMapping[billsFlags.TOTAL_COST] = 'totalCost';
  633. let tenderIDs = [];
  634. if(tenders.length > 0){
  635. for(let tender of tenders){
  636. tenderIDs.push(tender.ID);
  637. IDMapping[tender.ID] = {totalCost: 0};
  638. }
  639. //需要获取的清单固定类别综合合价:总造价
  640. let needFlags = [billsFlags.TOTAL_COST];
  641. //获取单位工程汇总金额需要用到的所有清单
  642. let allBills = await billsModel.find({projectID: {$in: tenderIDs}, 'flags.flag': {$in: needFlags}, $or: notDeleted},
  643. '-_id projectID fees flags');
  644. //进行单位工程级别的汇总
  645. for(let bills of allBills){
  646. let billsFlag = bills.flags[0]['flag'];
  647. let costField = flagFieldMapping[billsFlag];
  648. IDMapping[bills.projectID][costField] = getCommonTotalFee(bills);
  649. }
  650. }
  651. return IDMapping;
  652. }
  653. //@param {Array}projectIDs(建设项目ID) @return {Object}
  654. async function getSummaryInfo(projectIDs){
  655. //ID与汇总信息映射
  656. let IDMapping = {};
  657. //固定清单类别与汇总金额字段映射
  658. let flagFieldMapping = {};
  659. flagFieldMapping[billsFlags.TOTAL_COST] = 'totalCost';
  660. let projects = await projectModel.find({ID: {$in : projectIDs}, projType: projectType.project, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]});
  661. //设置建设项目的总建筑面积
  662. for(let project of projects){
  663. IDMapping[project.ID] = {totalCost: 0};
  664. }
  665. //单位工程
  666. let tenders = [];
  667. if(projectIDs.length > 0){
  668. tenders = await projectModel.find({ParentID: {$in : projectIDs}, projType: projectType.tender, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]});
  669. }
  670. let tenderIDs = [];
  671. if(tenders.length > 0){
  672. for(let tender of tenders){
  673. tenderIDs.push(tender.ID);
  674. IDMapping[tender.ID] = {totalCost: 0, changeMark:tender.changeMark};//property:tender.property
  675. }
  676. //需要获取的清单固定类别综合合价:总造价
  677. let needFlags = [billsFlags.TOTAL_COST];
  678. //获取单位工程汇总金额需要用到的所有清单
  679. let allBills = await billsModel.find({projectID: {$in: tenderIDs}, 'flags.flag': {$in: needFlags}, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]},
  680. '-_id projectID fees flags');
  681. //进行单位工程级别的汇总
  682. for(let bills of allBills){
  683. let billsFlag = bills.flags[0]['flag'];
  684. let costField = flagFieldMapping[billsFlag];
  685. IDMapping[bills.projectID][costField] = getCommonTotalFee(bills);
  686. }
  687. //进行建设项目级别的汇总
  688. for(let tender of tenders){
  689. summarizeToParent(IDMapping[tender.ParentID], IDMapping[tender.ID]);
  690. }
  691. }
  692. return IDMapping;
  693. }
  694. //根据项目ID获取所属建设项目
  695. //@param {Number}projectID @return {Object}
  696. async function getConstructionProject(projectID){
  697. function returnProject(project){
  698. if(!project || project.projType === projectType.folder){
  699. return null;
  700. }
  701. if(project.projType === projectType.project){
  702. return project;
  703. }
  704. }
  705. let project = await projectModel.findOne({ID: projectID, $or: notDeleted});
  706. let returnV = returnProject(project);
  707. if(returnV !== undefined){
  708. return returnV;
  709. }
  710. let parent = await projectModel.findOne({ID: project.ParentID, $or: notDeleted});
  711. returnV = returnProject(parent);
  712. if(returnV !== undefined){
  713. return returnV;
  714. }
  715. let grandParent = await projectModel.findOne({ID: parent.ParentID, $or: notDeleted});
  716. returnV = returnProject(grandParent);
  717. return returnV !== undefined ? returnV : null;
  718. }
  719. //获取单位工程完整目录结构
  720. //@param {Number}projectID @return {Arry}
  721. async function getFullPath(projectID) {
  722. let fullPath = [];
  723. let project = await projectModel.findOne({ID: projectID, $or: notDeleted}, '-_id ParentID name');
  724. if(project){
  725. fullPath.push(project.name);
  726. await getParent(project.ParentID);
  727. }
  728. fullPath = fullPath.reverse();
  729. return fullPath;
  730. async function getParent(ParentID) {
  731. if(ParentID != -1){
  732. let parent = await projectModel.findOne({ID: ParentID, $or: notDeleted}, '-_id ParentID name');
  733. if(parent){
  734. fullPath.push(parent.name);
  735. await getParent(parent.ParentID);
  736. }
  737. }
  738. }
  739. }
  740. async function getProjectFeature(libID,feeStandardName){
  741. let lib = await featureLibModel.findOne({'ID':libID})
  742. if(lib){
  743. let eng = _.find(lib.feature,{'key':'engineering'})
  744. if(eng) eng.value = feeStandardName;
  745. return lib.feature;
  746. }else {
  747. return [];
  748. }
  749. }
  750. //获取累进区间数据
  751. async function getProgressiveInterval(libID) {
  752. let lib = await progressiveModel.findOne({ID: libID});
  753. return lib ? lib.data : [];
  754. }
  755. //获取projectIDs文件下所有子项目(不包括projectIDs本身)
  756. async function getPosterityProjects(projectIDs) {
  757. let rst = [];
  758. async function getProjects(IDs) {
  759. if (IDs.length > 0) {
  760. let newIDs = [];
  761. let projs = await projectModel.find({ParentID: {$in: IDs}, $or: notDeleted}, '-_id');
  762. for (let proj of projs) {
  763. rst.push(proj);
  764. newIDs.push(proj.ID);
  765. }
  766. await getProjects(newIDs);
  767. }
  768. }
  769. await getProjects(projectIDs);
  770. return rst;
  771. }
  772. //根据项目获得分享信息(分享层级不一定在项目级)(以最新为准)
  773. //@param {String}userId {Object}tender @return {Object} || {null}
  774. async function getShareInfo(userId, project) {
  775. //与该用户相关的分享
  776. let shareList = [];
  777. while (project) {
  778. for(let shareData of project.shareInfo){
  779. if(shareData.userID === userId){
  780. shareList.push(shareData);
  781. break;
  782. }
  783. }
  784. project = await projectModel.findOne({ID: project.ParentID}, '-_id shareInfo ID ParentID');
  785. }
  786. //获取最新分享
  787. shareList.sort(function (a, b) {
  788. let aV = Date.parse(a.shareDate),
  789. bV = Date.parse(b.shareDate);
  790. if (aV > bV) {
  791. return -1;
  792. } else if (aV < bV) {
  793. return 1;
  794. }
  795. return 0;
  796. });
  797. return shareList[0] || null;
  798. }
  799. //打开的单位工程是否是被分享的.
  800. async function isShare(userId, project){
  801. //判断是否是打开分享的项目,属于分享文件的子项也算
  802. while (project) {
  803. for(let shareData of project.shareInfo){
  804. if(shareData.userID === userId){
  805. return true;
  806. }
  807. }
  808. project = await projectModel.findOne({ID: project.ParentID}, '-_id shareInfo ID ParentID');
  809. }
  810. return false;
  811. }
  812. //用户是否第一次进入费用定额
  813. async function isFirst(userId, compilationId) {
  814. let userData = await userModel.findOne({_id: mongoose.Types.ObjectId(userId)}, '-_id used_list');
  815. let isFirst = false;
  816. if (userData) {
  817. isFirst = !_.find(userData.used_list, function (o) {
  818. return o.compilationId === compilationId;
  819. });;
  820. }
  821. return isFirst;
  822. }
  823. //用户第一次进入费用定额的数据准备
  824. async function prepareInitialData(userId, compilation, example) {
  825. let first = await isFirst(userId, compilation);
  826. if (first) {
  827. await updateUsedList(userId, compilation);
  828. let prepareTask = [
  829. copyCompleRationSection(userId, compilation),
  830. copyCompleGljSection(userId, compilation)
  831. ];
  832. if (example && example.length > 0) {
  833. prepareTask.push(copyExample(userId, compilation, example));
  834. }
  835. await Promise.all(prepareTask);
  836. }
  837. }
  838. async function updateUsedList(userId, compilation) {
  839. await userModel.update({_id: mongoose.Types.ObjectId(userId)}, {$push: {used_list: {compilationId: compilation}}});
  840. }
  841. //拷贝补充定额章节树
  842. async function copyCompleRationSection(userId, compilationId) {
  843. await sectionTreeDao.copyDataFromTemplate(userId, compilationId);
  844. }
  845. //拷贝补充人材机分类树
  846. async function copyCompleGljSection(userId, compilationId) {
  847. let templateData = await compleGljSectionTModel.find({compilationId: compilationId});
  848. if (templateData.length > 0) {
  849. let insertDatas = [],
  850. uuidMapping = {};
  851. //将ID替换成UUID
  852. for (let temData of templateData) {
  853. uuidMapping[temData.ID] = uuidV1();
  854. }
  855. for(let temData of templateData) {
  856. let insertD = {
  857. userId: userId,
  858. compilationId: compilationId,
  859. Name: temData.Name,
  860. ID: uuidMapping[temData.ID],
  861. ParentID: uuidMapping[temData.ParentID] || -1,
  862. NextSiblingID: uuidMapping[temData.NextSiblingID] || -1,
  863. };
  864. insertDatas.push(insertD);
  865. }
  866. //插入数据
  867. await compleGljSectionModel.insertMany(insertDatas);
  868. }
  869. }
  870. async function changeFile(datas,userID,fileID,name,from,type){//from 费率或单价文件,type从单前建设项目还是从其它建设项目中复制
  871. let projectIDs = [],newFile = {id:fileID,name:name};//计录从其它项目中复制的文件,选中多个的时候只需复制一次
  872. let projectUpdateType = from == "feeRateFile"?"feeRate":"unitFile";
  873. for(let d of datas){
  874. let tem_file = from == "feeRateFile"? await feeRate_facade.changeFeeRateFile(d, newFile,type,userID):await glj_facade.changeUnitFile(d, newFile,type,userID);
  875. if(type == 1 && tem_file){//从建设项目复制时,只有第一次需要复制,剩下的就相当于使用同个建设项目的情况了
  876. let newID = from == "feeRateFile"?tem_file.ID:tem_file.id;
  877. newFile = {id:newID,name:tem_file.name};
  878. type = 0;
  879. }
  880. projectIDs.push({ID:d.projectID})
  881. }
  882. await project_facade.markProjectsToChange(projectIDs,projectUpdateType)//项目标记为待刷新状态
  883. }