pm_facade.js 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766
  1. /**
  2. * Created by zhang on 2018/4/17.
  3. */
  4. let mongoose = require('mongoose');
  5. let _ = require("lodash");
  6. let feeRate_facade = require('../../fee_rates/facade/fee_rates_facade');
  7. let logger = require("../../../logs/log_helper").logger;
  8. const uuidV1 = require('uuid/v1');
  9. let projectModel = mongoose.model('projects');
  10. let projectSettingModel = mongoose.model('proj_setting');
  11. let billsModel = mongoose.model('bills');
  12. let rationModel = mongoose.model('ration');
  13. let gljListModel = mongoose.model("glj_list");
  14. let calcProgramsModel = mongoose.model('calc_programs');
  15. let labourCoesModel = mongoose.model('labour_coes');
  16. let feeRateModel = mongoose.model('fee_rates');
  17. let feeRateFileModel = mongoose.model('fee_rate_file');
  18. let unitPriceFileModel = mongoose.model("unit_price_file");
  19. let mixRatioModel = mongoose.model("mix_ratio");
  20. let unitPriceModel = mongoose.model("unit_price");
  21. let installationFeeModel = mongoose.model("installation_fee");
  22. let rationGLJModel = mongoose.model('ration_glj');
  23. let rationCoeModel = mongoose.model('ration_coe');
  24. let rationInstallationModel = mongoose.model('ration_installation');
  25. let quantityDetailModel = mongoose.model('quantity_detail');
  26. let featureLibModel = mongoose.model("std_project_feature_lib");
  27. let scMathUtil = require('../../../public/scMathUtil').getUtil();
  28. import CounterModel from "../../glj/models/counter_model";
  29. import moment from 'moment';
  30. import billsFlags from '../../common/const/bills_fixed';
  31. const projectType = {
  32. folder: 'Folder',
  33. tender: 'Tender',
  34. project: 'Project',
  35. engineering: 'Engineering',
  36. };
  37. const notDeleted = [{deleteInfo: null}, {'deleteInfo.deleted': false}];
  38. module.exports={
  39. moveProject:moveProject,
  40. copyProject:copyProject,
  41. getSummaryInfo: getSummaryInfo,
  42. getSummaryInfoByTender: getSummaryInfoByTender,
  43. getConstructionProject: getConstructionProject,
  44. getFullPath: getFullPath,
  45. getProjectFeature:getProjectFeature,
  46. projectType: projectType,
  47. getPosterityProjects: getPosterityProjects,
  48. isShare: isShare,
  49. };
  50. //拷贝父级项目
  51. async function copyParent(){
  52. }
  53. async function copyProject(userID, compilationID,data,newProjectID = null) {
  54. let projectMap = data.projectMap;
  55. let originalID = projectMap['copy'].document.ID;
  56. if (!newProjectID) {
  57. newProjectID = await getCounterID("projects");
  58. }
  59. let newFeeName = null,newUnitName = null;
  60. let calcProgramFileID = uuidV1();//新的计算程序文件ID
  61. let labourCoeFileID = uuidV1();//新的人工调整系数文件ID
  62. let feeRateFileID = uuidV1();//新的费率文件ID
  63. let unitPriceFileID = await getCounterID("unit_price_file");//新的单价文件ID
  64. let originalProject = await projectModel.findOne({'ID':originalID});//查找最新的那项目信息,前端缓存的数据有可能不是最新的
  65. if(!originalProject){
  66. throw new Error('没有找到对应的项目,复制失败!');
  67. }
  68. let property = originalProject.property;
  69. if(projectMap['copy'].document.property){//更新项目属性信息
  70. setProperty(property,projectMap['copy'].document.property);
  71. }
  72. let originalProperty = _.cloneDeep(property);
  73. projectMap['copy'].document.property = property;
  74. logger.info("复制项目: 旧项目ID: "+originalID+ " ------- 新项目ID: "+newProjectID);
  75. //费率文件、单价文件重名检查
  76. let feeRate = await feeRateFileModel.findOne({rootProjectID:originalProperty.rootProjectID,name:originalProperty.feeFile.name,deleteInfo:null});
  77. if(feeRate){//存在重名的文件
  78. newFeeName = originalProperty.feeFile.name + '(' + moment(Date.now()).format('MM-DD HH:mm:ss') + '复制)';
  79. projectMap['copy'].document.property.feeFile.name = newFeeName;
  80. }
  81. let unitPriceFile = await unitPriceFileModel.findOne({root_project_id: originalProperty.rootProjectID,name:originalProperty.unitPriceFile.name,deleteInfo: null});
  82. if(unitPriceFile){//存在重名的文件
  83. newUnitName = originalProperty.unitPriceFile.name + '(' + moment(Date.now()).format('MM-DD HH:mm:ss') + '复制)';
  84. projectMap['copy'].document.property.unitPriceFile.name = newUnitName;
  85. }
  86. //更新项目的属性;
  87. projectMap['copy'].document.ID = newProjectID;
  88. if(projectMap['copy'].document.property.calcProgramFile){
  89. projectMap['copy'].document.property.calcProgramFile.ID = calcProgramFileID;
  90. }
  91. if(projectMap['copy'].document.property.labourCoeFile){
  92. projectMap['copy'].document.property.labourCoeFile.ID = labourCoeFileID;
  93. }
  94. if(projectMap['copy'].document.property.feeFile){
  95. projectMap['copy'].document.property.feeFile.id = feeRateFileID;
  96. }
  97. if(projectMap['copy'].document.property.unitPriceFile){
  98. projectMap['copy'].document.property.unitPriceFile.id = unitPriceFileID;
  99. }
  100. projectMap['copy'].document.userID = userID;
  101. projectMap['copy'].document.compilation = compilationID;
  102. projectMap['copy'].document.createDateTime = new Date();
  103. //清单、定额ID生成任务
  104. let IDtasks = [
  105. createIDsAndReturn(originalID,billsModel),
  106. createIDsAndReturn(originalID,rationModel),
  107. getProjectGLJIDAndReturn(originalID,newProjectID)
  108. ];
  109. let [billMap,rationMap,projectGLJMap] = await Promise.all(IDtasks);
  110. //所有复制任务异步处理,提升效率 复制清单,定额,4个文件,项目工料机, 定额工料机,人工系数,工程量明细,定额安装增加费,安装增加费
  111. let copyTasks = [
  112. createProject(projectMap),
  113. copyProjectSetting(originalID,newProjectID),
  114. copyBills(newProjectID,billMap),
  115. copyRations(newProjectID,billMap.uuidMaping,rationMap,projectGLJMap.IDMap),
  116. copyProjectGLJ(projectGLJMap.datas),
  117. copyInstallFee(originalID,newProjectID),
  118. copyRationSubList(originalID,newProjectID,billMap.uuidMaping,rationMap.uuidMaping,projectGLJMap.IDMap,rationGLJModel),
  119. copyRationSubList(originalID,newProjectID,billMap.uuidMaping,rationMap.uuidMaping,projectGLJMap.IDMap,rationCoeModel),
  120. copyRationSubList(originalID,newProjectID,billMap.uuidMaping,rationMap.uuidMaping,projectGLJMap.IDMap,quantityDetailModel),
  121. copyRationSubList(originalID,newProjectID,billMap.uuidMaping,rationMap.uuidMaping,projectGLJMap.IDMap,rationInstallationModel)
  122. ];
  123. if(originalProperty.calcProgramFile){
  124. copyTasks.push(commonCopy(newProjectID,originalProperty.calcProgramFile.ID,calcProgramFileID,calcProgramsModel));
  125. }
  126. if(originalProperty.labourCoeFile){
  127. copyTasks.push(commonCopy(newProjectID,originalProperty.labourCoeFile.ID,labourCoeFileID,labourCoesModel));
  128. }
  129. if(originalProperty.feeFile){
  130. copyTasks.push(copyFeeRate(originalProperty.rootProjectID,userID,originalProperty.feeFile.id,feeRateFileID,newFeeName));
  131. }
  132. if(originalProperty.unitPriceFile){
  133. copyTasks.push(copyUnitPriceFile(newProjectID,originalProperty.rootProjectID,userID,originalProperty.unitPriceFile.id,unitPriceFileID,newUnitName));
  134. }
  135. let p = await Promise.all(copyTasks);
  136. return p[0];
  137. }
  138. async function createIDsAndReturn(originalID,model) {
  139. let uuidMaping = {};//做ID映射
  140. let datas = [];
  141. let result = await model.find({"projectID": originalID}, '-_id');
  142. uuidMaping['-1'] = -1;
  143. //建立uuid-ID映射
  144. for(let d of result){
  145. uuidMaping[d.ID] = uuidV1();
  146. datas.push(d._doc);
  147. }
  148. return{uuidMaping:uuidMaping,datas:datas};
  149. }
  150. async function getProjectGLJIDAndReturn(originalID,newProjectID) {
  151. let IDMap = {};
  152. let datas = [];
  153. let result = await gljListModel.find({project_id:originalID}, '-_id');
  154. for(let d of result){
  155. let newID = await getCounterID("glj_list");
  156. IDMap[d.id] = newID;
  157. d._doc.project_id = newProjectID;
  158. d._doc.id = newID;
  159. datas.push(d._doc);
  160. }
  161. return{IDMap:IDMap,datas:datas};
  162. }
  163. async function createProject(projectMap) {//复制项目
  164. let tasks = [];
  165. if(projectMap['update']){//如果复制后存在前一个节点,则更新其NextSiblingID
  166. tasks.push({updateOne:{filter : projectMap['update'].query, update : {NextSiblingID:projectMap['copy'].document.ID}}});
  167. }
  168. tasks.push({insertOne: {document: projectMap['copy'].document}});//复制任务
  169. await projectModel.bulkWrite(tasks);
  170. return projectMap;
  171. }
  172. async function copyProjectSetting(originalID,newProjectID) {
  173. let result = null;
  174. let setting = await projectSettingModel.findOne({"projectID": originalID}, '-_id');
  175. if(setting){
  176. setting._doc.projectID =newProjectID;
  177. result = await projectSettingModel.create(setting._doc);
  178. }
  179. return result;
  180. }
  181. async function copyBills(newProjectID,billMap) {
  182. let uuidMaping = billMap.uuidMaping;//做ID映射
  183. for(let doc of billMap.datas){
  184. doc.projectID = newProjectID;
  185. doc.ID = uuidMaping[doc.ID] ? uuidMaping[doc.ID] : -1;
  186. doc.ParentID = uuidMaping[doc.ParentID] ? uuidMaping[doc.ParentID] : -1;
  187. doc.NextSiblingID = uuidMaping[doc.NextSiblingID] ? uuidMaping[doc.NextSiblingID] : -1;
  188. }
  189. await insertMany(billMap.datas,billsModel);
  190. return billMap.datas;
  191. }
  192. async function copyRations(newProjectID,billsIDMap,rationMap,projectGLJIDMap) {
  193. let uuidMaping = rationMap.uuidMaping;
  194. for(let doc of rationMap.datas){
  195. doc.projectID = newProjectID;
  196. doc.ID = uuidMaping[doc.ID] ? uuidMaping[doc.ID] : -1;
  197. if(doc.billsItemID){
  198. doc.billsItemID = billsIDMap[doc.billsItemID]?billsIDMap[doc.billsItemID]:-1;
  199. }
  200. //绑定定类型的工料机 项目工料机ID
  201. doc.type==3&&doc.projectGLJID&&projectGLJIDMap[doc.projectGLJID]?doc.projectGLJID = projectGLJIDMap[doc.projectGLJID]:'';
  202. }
  203. if(rationMap.datas.length > 0){
  204. await insertMany(rationMap.datas,rationModel);
  205. }
  206. return rationMap.datas;
  207. }
  208. async function copyProjectGLJ(gljList) {
  209. await insertMany(gljList,gljListModel);
  210. }
  211. async function commonCopy(newProjectID,oldID,newID,model) { //对于只需更新ID和projectID的文件的复制
  212. let result = null;
  213. let file = await model.findOne({"ID": oldID}, '-_id');
  214. if(file){
  215. file._doc.ID = newID;
  216. file._doc.projectID =newProjectID;
  217. result = await model.create(file._doc);
  218. }
  219. return result;
  220. }
  221. async function copyFeeRate(rootProjectID,userID,originalFeeRateFileID,feeRateFileID,newName) {//复制费率和费率文件
  222. let [feeRateFile,feeRate] =await feeRate_facade.getFeeRateByID(originalFeeRateFileID);
  223. let newFeeRateID = uuidV1();
  224. if(feeRate){
  225. feeRate._doc.ID = newFeeRateID;
  226. await feeRateModel.create(feeRate._doc);
  227. }
  228. if(feeRateFile){
  229. feeRateFile._doc.ID = feeRateFileID;
  230. newName?feeRateFile._doc.name = newName:'';
  231. feeRateFile._doc.userID = userID;
  232. feeRateFile._doc.rootProjectID = rootProjectID;
  233. feeRateFile._doc.feeRateID = newFeeRateID;
  234. await feeRateFileModel.create(feeRateFile._doc);
  235. }
  236. }
  237. async function copyUnitPriceFile(newProjectID,rootProjectID,userID,originaluUnitPriceFileID,unitPriceFileID,newName) {//复制单价文件、组成物
  238. let taskList = [
  239. copyFile(newProjectID,rootProjectID,userID,originaluUnitPriceFileID,unitPriceFileID,newName),
  240. copySubList(originaluUnitPriceFileID,unitPriceFileID,mixRatioModel),
  241. copySubList(originaluUnitPriceFileID,unitPriceFileID,unitPriceModel)
  242. ];
  243. return await Promise.all(taskList);
  244. async function copyFile(newProjectID,rootProjectID,userID,originaluUnitPriceFileID,unitPriceFileID,newName){
  245. let unitPriceFile = await unitPriceFileModel.findOne({id:originaluUnitPriceFileID}, '-_id');
  246. if(unitPriceFile){
  247. unitPriceFile._doc.id = unitPriceFileID;
  248. newName?unitPriceFile._doc.name = newName:'';
  249. unitPriceFile._doc.project_id = newProjectID;
  250. unitPriceFile._doc.user_id = userID;
  251. unitPriceFile._doc.root_project_id = rootProjectID
  252. }
  253. await unitPriceFileModel.create(unitPriceFile._doc);
  254. }
  255. async function copySubList(srcFID,newFID,model) {
  256. let mList = await model.find({unit_price_file_id: srcFID}, '-_id');
  257. let rList = [];
  258. for(let m of mList){
  259. m._doc.unit_price_file_id = newFID;
  260. m._doc.id = await getCounterID(model.modelName);
  261. rList.push(m._doc);
  262. }
  263. await insertMany(rList,model)
  264. }
  265. }
  266. async function copyInstallFee(originalPID,newProjectID) {
  267. let result = null;
  268. let installationFee = await installationFeeModel.find({projectID:originalPID}, '-_id');
  269. let newList = [];
  270. for(let i of installationFee ){
  271. i._doc.ID = uuidV1();
  272. i._doc.projectID = newProjectID;
  273. newList.push(i._doc);
  274. }
  275. if(newList.length >0){
  276. result = await installationFeeModel.insertMany(newList);
  277. }
  278. return result;
  279. }
  280. async function copyRationSubList(originalPID,newProjectID,billIDMap,rationIDMap,projectGLJIDMap,model) {// 定额工料机,附注条件,工程量明细,定额安装增加费
  281. let subList = await model.find({projectID:originalPID}, '-_id');
  282. let newList =[];
  283. for(let s of subList){
  284. s._doc.ID = uuidV1();
  285. s._doc.projectID = newProjectID;
  286. s._doc.rationID&&rationIDMap[s._doc.rationID]?s._doc.rationID = rationIDMap[s._doc.rationID]:'';
  287. s._doc.billID&&billIDMap[s._doc.billID]?s._doc.billID = billIDMap[s._doc.billID]:'';
  288. s._doc.billsItemID&&billIDMap[s._doc.billsItemID]?s._doc.billsItemID = billIDMap[s._doc.billsItemID]:'';
  289. s._doc.projectGLJID&&projectGLJIDMap[s._doc.projectGLJID]?s._doc.projectGLJID = projectGLJIDMap[s._doc.projectGLJID]:'';
  290. newList.push(s._doc);
  291. }
  292. await insertMany(newList,model);
  293. }
  294. async function moveProject(data) {
  295. data = JSON.parse(data);
  296. let projectMap = data.projectMap,feeRateMap = data.feeRateMap,unitPriceMap = data.unitPriceMap;
  297. let projectTasks = [],feeRateTask=[],feeRateFileTask=[],unitPriceTask=[],unitPriceFileTask=[],mixRatioTask=[];
  298. let feeUniqMap=[],priceUniqMap={};//费率、单价文件唯一映射表当移动多个项目时,任务有可能出现重复的情况
  299. if(!_.isEmpty(feeRateMap)&&data.rootProjectID){//如果费率有修改
  300. let feeRates =await feeRate_facade.getFeeRatesByProject(data.rootProjectID);//取目标建设项目的所有费率文件,重名检查
  301. for(let projectID in feeRateMap){
  302. let rename = feeRateMap[projectID].name;
  303. let feeRateID = feeRateMap[projectID].query.ID;
  304. let checkFee = _.find(feeRates,{'name':rename});
  305. let newID = feeRateID;
  306. if(checkFee){//说明费率名字已存在,需要重命名
  307. rename = feeUniqMap[feeRateID]?feeUniqMap[feeRateID].name:rename + '(' + new Date().Format('MM-dd hh:mm:ss') + '移动)';
  308. projectMap[projectID]['update']['property.feeFile.name'] = rename;
  309. if(feeRateMap[projectID].action == 'move'){
  310. feeRateMap[projectID].update.name = rename;
  311. }
  312. }
  313. if(feeRateMap[projectID].action == 'copy'){
  314. newID = feeUniqMap[feeRateID]?feeUniqMap[feeRateID].ID:uuidV1();
  315. feeRateMap[projectID].name = rename;
  316. feeRateMap[projectID].ID = newID;
  317. projectMap[projectID]['update']['property.feeFile.id'] = newID;
  318. }
  319. if(!feeUniqMap[feeRateID]){
  320. await generateFeeRateTask(feeRateMap[projectID],feeRateTask,feeRateFileTask);
  321. feeUniqMap[feeRateID] = {name:rename,ID:newID};
  322. }
  323. }
  324. }
  325. if(!_.isEmpty(unitPriceMap)&&data.rootProjectID) {//如果单价文件有修改
  326. let unitPriceFiles = await unitPriceFileModel.find({root_project_id: data.rootProjectID, deleteInfo: null});
  327. for(let projectID in unitPriceMap){
  328. let checkUn = _.find(unitPriceFiles,{'name':unitPriceMap[projectID].name});
  329. let rename = unitPriceMap[projectID].name;
  330. let unitPriceID = unitPriceMap[projectID].query.id;
  331. let newID = unitPriceID;
  332. if(checkUn){//重名检查
  333. rename = priceUniqMap[unitPriceID]?priceUniqMap[unitPriceID].name:rename + '(' + new Date().Format('MM-dd hh:mm:ss') + '移动)';
  334. projectMap[projectID]['update']['property.unitPriceFile.name'] = rename;
  335. if(unitPriceMap[projectID].action =='move'){
  336. unitPriceMap[projectID].update.name = rename;
  337. }
  338. }
  339. if(unitPriceMap[projectID].action =='copy'){
  340. newID = priceUniqMap[unitPriceID]?priceUniqMap[unitPriceID].id: await getCounterID("unit_price_file");
  341. unitPriceMap[projectID].name = rename;
  342. unitPriceMap[projectID].id = newID;
  343. projectMap[projectID]['update']['property.unitPriceFile.id'] = newID;
  344. }
  345. if(!priceUniqMap[unitPriceID]){
  346. await generateUnitPriceTask(unitPriceMap[projectID],projectID,data.user_id,unitPriceTask,unitPriceFileTask,mixRatioTask);
  347. priceUniqMap[unitPriceID] = {name:rename,id:newID};
  348. }
  349. }
  350. }
  351. if(!_.isEmpty(projectMap)){
  352. for(let projectID in projectMap){
  353. projectTasks.push({updateOne:{filter : projectMap[projectID].query, update : projectMap[projectID].update}});
  354. }
  355. }
  356. projectTasks.length>0?await projectModel.bulkWrite(projectTasks):'';
  357. feeRateTask.length>0?await feeRateModel.bulkWrite(feeRateTask):'';
  358. feeRateFileTask.length>0?await feeRateFileModel.bulkWrite(feeRateFileTask):'';
  359. unitPriceFileTask.length>0?await unitPriceFileModel.bulkWrite(unitPriceFileTask):'';
  360. unitPriceTask.length>0?await insertMany(unitPriceTask,unitPriceModel):'';
  361. mixRatioTask.length>0?await insertMany(mixRatioTask,mixRatioModel):'';
  362. return projectMap;
  363. }
  364. async function generateFeeRateTask(data,feeRateTask,feeRateFileTask) {
  365. if(data.action == 'move'){
  366. let task = {
  367. updateOne:{
  368. filter : data.query,
  369. update : data.update
  370. }
  371. };
  372. feeRateFileTask.push(task);
  373. }
  374. if(data.action == 'copy'){//copy 费率的时候用insertOne方法
  375. let [feeRateFile,feeRate] =await feeRate_facade.getFeeRateByID(data.query.ID);
  376. let newFeeRateID = uuidV1();
  377. let newFeeRate = {
  378. ID:newFeeRateID,
  379. rates:feeRate.rates
  380. };
  381. let newFeeRateFile = {
  382. ID:data.ID,
  383. rootProjectID:data.rootProjectID,
  384. userID:feeRateFile.userID,
  385. name:data.name,
  386. libID:feeRateFile.libID,
  387. libName:feeRateFile.libName,
  388. feeRateID:newFeeRateID
  389. };
  390. feeRateTask.push({insertOne :{document:newFeeRate}});
  391. feeRateFileTask.push({insertOne :{document:newFeeRateFile}});
  392. }
  393. }
  394. async function generateUnitPriceTask(data,projectID,user_id,unitPriceTask,unitPriceFileTask,mixRatioTask){
  395. if(data.action == 'move'){
  396. let task = {
  397. updateOne:{
  398. filter : data.query,
  399. update : data.update
  400. }
  401. };
  402. unitPriceFileTask.push(task);
  403. }
  404. if(data.action == 'copy'){
  405. let newUnitFile = {
  406. id:data.id,
  407. name: data.name,
  408. project_id:projectID,
  409. user_id:user_id,
  410. root_project_id: data.rootProjectID
  411. };
  412. unitPriceFileTask.push({insertOne :{document:newUnitFile}});
  413. let mixRatios = await mixRatioModel.find({unit_price_file_id: data.query.id});
  414. mixRatios = JSON.stringify(mixRatios);
  415. mixRatios = JSON.parse(mixRatios);
  416. for(let m of mixRatios){
  417. delete m._id; // 删除原有id信息
  418. delete m.id;
  419. m.unit_price_file_id = data.id;
  420. m.id = await getCounterID('mix_ratio');
  421. mixRatioTask.push(m);
  422. }
  423. let unitPrices = await unitPriceModel.find({unit_price_file_id: data.query.id});//unit_price_file_id
  424. unitPrices = JSON.stringify(unitPrices);
  425. unitPrices = JSON.parse(unitPrices);
  426. for(let u of unitPrices){
  427. delete u._id; // 删除原有id信息
  428. delete u.id;
  429. u.unit_price_file_id = data.id;
  430. u.id = await getCounterID('unit_price');
  431. unitPriceTask.push(u);
  432. }
  433. }
  434. }
  435. async function getCounterID(collectionName){
  436. let counterModel = new CounterModel();
  437. return await counterModel.getId(collectionName);
  438. }
  439. async function insertMany(datas,model) {
  440. while (datas.length>1000){//因为mongoose限制了批量插入的条数为1000.所以超出限制后需要分批插入
  441. let newList = datas.splice(0,1000);//一次插入1000条
  442. await model.insertMany(newList);
  443. }
  444. await model.insertMany(datas);
  445. }
  446. function setProperty(Obj,updateData) {
  447. for(let ukey in updateData){
  448. if(_.isObject(updateData[ukey]) && _.isObject(Obj[ukey])){
  449. setProperty(Obj[ukey],updateData[ukey]);
  450. }else {
  451. Obj[ukey] = updateData[ukey];
  452. }
  453. }
  454. }
  455. function isDef(v){
  456. return typeof v !== 'undefined' && v !== null;
  457. }
  458. function getCommonTotalFee(bills) {
  459. if(!isDef(bills)){
  460. return 0;
  461. }
  462. if(!isDef(bills.fees) || bills.fees.length <= 0){
  463. return 0;
  464. }
  465. for(let fee of bills.fees){
  466. if(isDef(fee.fieldName) && fee.fieldName === 'common'){
  467. return isDef(fee.totalFee) ? fee.totalFee : 0;
  468. }
  469. }
  470. return 0;
  471. }
  472. function summarizeToParent(parent, child) {
  473. const decimal = -2;
  474. parent.engineeringCost = scMathUtil.roundTo(parseFloat(parent.engineeringCost) + parseFloat(child.engineeringCost), decimal);
  475. parent.subEngineering = scMathUtil.roundTo(parseFloat(parent.subEngineering) + parseFloat(child.subEngineering), decimal);
  476. parent.measure = scMathUtil.roundTo(parseFloat(parent.measure) + parseFloat(child.measure), decimal);
  477. parent.safetyConstruction = scMathUtil.roundTo(parseFloat(parent.safetyConstruction) + parseFloat(child.safetyConstruction), decimal);
  478. parent.other = scMathUtil.roundTo(parseFloat(parent.other) + parseFloat(child.other), decimal);
  479. parent.charge = scMathUtil.roundTo(parseFloat(parent.charge) + parseFloat(child.charge), decimal);
  480. parent.tax = scMathUtil.roundTo(parseFloat(parent.tax) + parseFloat(child.tax), decimal);
  481. }
  482. function getBuildingArea(projFeature){
  483. if(!projFeature || projFeature.length === 0){
  484. return null;
  485. }
  486. for(let f of projFeature){
  487. if(f.key === 'buildingArea'){
  488. return f.value;
  489. }
  490. }
  491. return null;
  492. }
  493. //根据单位工程ID获取汇总信息
  494. //@param {Number}tenderID {String}summaryType @return {Object}
  495. async function getSummaryInfoByTender(tenderID, summaryType) {
  496. const notDeleted = [{deleteInfo: null}, {'deleteInfo.deleted': false}];
  497. let tender = await projectModel.findOne({ID: tenderID, $or: notDeleted});
  498. let parentName;
  499. let summaryList = [];
  500. if(!tender){
  501. return null;
  502. }
  503. let engineering = await projectModel.findOne({ID: tender.ParentID, $or: notDeleted});
  504. if(!engineering){
  505. return null;
  506. }
  507. let project = await projectModel.findOne({ID: engineering.ParentID, $or: notDeleted});
  508. if(!project){
  509. return null;
  510. }
  511. let summaryInfo = await getSummaryInfo([project.ID]);
  512. if(summaryType === projectType.engineering){
  513. parentName = engineering.name ? engineering.name : '';
  514. let tenders = await projectModel.find({ParentID: engineering.ID, $or: notDeleted});
  515. for(let t of tenders){
  516. if(summaryInfo[t.ID]){
  517. summaryInfo[t.ID]['name'] = t.name ? t.name : '';
  518. summaryList.push(summaryInfo[t.ID]);
  519. }
  520. }
  521. }
  522. else {
  523. parentName = project.name ? project.name : '';
  524. let engs = await projectModel.find({ParentID: project.ID, $or: notDeleted});
  525. for(let e of engs){
  526. if(summaryInfo[e.ID]){
  527. summaryInfo[e.ID]['name'] = e.name ? e.name : '';
  528. summaryList.push(summaryInfo[e.ID]);
  529. }
  530. }
  531. }
  532. return {parent: {name: parentName}, subList: summaryList};
  533. }
  534. async function getSummaryInfo(projectIDs){
  535. //ID与汇总信息映射
  536. let IDMapping = {};
  537. //固定清单类别与汇总金额字段映射
  538. let flagFieldMapping = {};
  539. flagFieldMapping[billsFlags.ENGINEERINGCOST] = 'engineeringCost';
  540. flagFieldMapping[billsFlags.SUB_ENGINERRING] = 'subEngineering';
  541. flagFieldMapping[billsFlags.MEASURE] = 'measure';
  542. flagFieldMapping[billsFlags.SAFETY_CONSTRUCTION] = 'safetyConstruction';
  543. flagFieldMapping[billsFlags.OTHER] = 'other';
  544. flagFieldMapping[billsFlags.CHARGE] = 'charge';
  545. flagFieldMapping[billsFlags.TAX] = 'tax';
  546. let projects = await projectModel.find({ID: {$in : projectIDs}, projType: projectType.project, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]});
  547. //设置建设项目的总建筑面积
  548. for(let project of projects){
  549. let grossArea = '';
  550. if(project.property && project.property.basicInformation){
  551. for(let basicInfo of project.property.basicInformation){
  552. if(basicInfo.key === 'basicInfo'){
  553. for(let k of basicInfo.items){
  554. if(k.key === 'grossArea'){
  555. grossArea = k.value;
  556. }
  557. }
  558. }
  559. }
  560. }
  561. IDMapping[project.ID] = {engineeringCost: 0, subEngineering: 0, measure: 0, safetyConstruction: 0, other: 0, charge: 0, tax: 0, rate: 0, buildingArea: grossArea, perCost: ''};
  562. }
  563. //单项工程
  564. let engineerings = await projectModel.find({ParentID: {$in : projectIDs}, projType: projectType.engineering, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]});
  565. //单位工程
  566. let tenders = [];
  567. let engIDs = [];
  568. for(let eng of engineerings){
  569. engIDs.push(eng.ID);
  570. IDMapping[eng.ID] = {engineeringCost: 0, subEngineering: 0, measure: 0, safetyConstruction: 0, other: 0, charge: 0, tax: 0, rate: 0, buildingArea: '', perCost: ''};
  571. }
  572. if(engIDs.length > 0){
  573. tenders = await projectModel.find({ParentID: {$in : engIDs}, projType: projectType.tender, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]});
  574. }
  575. let tenderIDs = [];
  576. if(tenders.length > 0){
  577. for(let tender of tenders){
  578. tenderIDs.push(tender.ID);
  579. IDMapping[tender.ID] = {engineeringCost: 0, subEngineering: 0, measure: 0, safetyConstruction: 0, other: 0, charge: 0, tax: 0, rate: 0, buildingArea: '', perCost: '',changeMark:tender.changeMark,property:tender.property};
  580. let buildingArea = getBuildingArea(tender.property.projectFeature);
  581. if(buildingArea){
  582. IDMapping[tender.ID]['buildingArea'] = buildingArea;
  583. }
  584. }
  585. //需要获取的清单固定类别综合合价:工程造价、分部分项、措施项目、安全文明施工专项、规费、其他项目、税金
  586. let needFlags = [billsFlags.ENGINEERINGCOST, billsFlags.SUB_ENGINERRING, billsFlags.MEASURE,
  587. billsFlags.SAFETY_CONSTRUCTION, billsFlags.CHARGE, billsFlags.OTHER, billsFlags.TAX];
  588. //获取单位工程汇总金额需要用到的所有清单
  589. let allBills = await billsModel.find({projectID: {$in: tenderIDs}, 'flags.flag': {$in: needFlags}, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]},
  590. '-_id projectID fees flags');
  591. //进行单位工程级别的汇总
  592. for(let bills of allBills){
  593. let billsFlag = bills.flags[0]['flag'];
  594. let costField = flagFieldMapping[billsFlag];
  595. IDMapping[bills.projectID][costField] = getCommonTotalFee(bills);
  596. }
  597. //进行单项工程级别的汇总
  598. for(let tender of tenders){
  599. summarizeToParent(IDMapping[tender.ParentID], IDMapping[tender.ID]);
  600. }
  601. //进行建设项目级别的汇总
  602. for(let eng of engineerings){
  603. summarizeToParent(IDMapping[eng.ParentID], IDMapping[eng.ID]);
  604. }
  605. //占造价比例、单方造价
  606. const rateDecimal = -2;
  607. const perCostDecimal = -2;
  608. for(let tender of tenders){
  609. let tenderInfo = IDMapping[tender.ID];
  610. let engInfo = IDMapping[tender.ParentID];
  611. tenderInfo.rate = engInfo.engineeringCost == 0 ? 0 : scMathUtil.roundTo(tenderInfo.engineeringCost * 100 / engInfo.engineeringCost, rateDecimal);
  612. //单方造价
  613. tenderInfo.perCost = tenderInfo.buildingArea.toString().trim() === '' || tenderInfo.buildingArea == 0 ?
  614. tenderInfo.buildingArea.toString().trim() : scMathUtil.roundTo(tenderInfo.engineeringCost / tenderInfo.buildingArea, perCostDecimal);
  615. }
  616. for(let eng of engineerings){
  617. let engInfo = IDMapping[eng.ID];
  618. let projInfo = IDMapping[eng.ParentID];
  619. engInfo.rate = !isDef(projInfo) || projInfo.engineeringCost == 0 ? 0 : scMathUtil.roundTo(engInfo.engineeringCost * 100 / projInfo.engineeringCost, rateDecimal);
  620. }
  621. //建设项目占造价比例及单方造价
  622. for(let project of projects){
  623. let projectInfo = IDMapping[project.ID];
  624. projectInfo.rate = 100;
  625. projectInfo.perCost = projectInfo.buildingArea.toString().trim() === '' || projectInfo.buildingArea == 0 ?
  626. projectInfo.buildingArea.toString().trim() : scMathUtil.roundTo(projectInfo.engineeringCost / projectInfo.buildingArea, perCostDecimal);
  627. }
  628. }
  629. return IDMapping;
  630. }
  631. //根据项目ID获取所属建设项目
  632. //@param {Number}projectID @return {Object}
  633. async function getConstructionProject(projectID){
  634. function returnProject(project){
  635. if(!project || project.projType === projectType.folder){
  636. return null;
  637. }
  638. if(project.projType === projectType.project){
  639. return project;
  640. }
  641. }
  642. let project = await projectModel.findOne({ID: projectID, $or: notDeleted});
  643. let returnV = returnProject(project);
  644. if(returnV !== undefined){
  645. return returnV;
  646. }
  647. let parent = await projectModel.findOne({ID: project.ParentID, $or: notDeleted});
  648. returnV = returnProject(parent);
  649. if(returnV !== undefined){
  650. return returnV;
  651. }
  652. let grandParent = await projectModel.findOne({ID: parent.ParentID, $or: notDeleted});
  653. returnV = returnProject(grandParent);
  654. return returnV !== undefined ? returnV : null;
  655. }
  656. //获取单位工程完整目录结构
  657. //@param {Number}projectID @return {Arry}
  658. async function getFullPath(projectID) {
  659. let fullPath = [];
  660. let project = await projectModel.findOne({ID: projectID, $or: notDeleted}, '-_id ParentID name');
  661. if(project){
  662. fullPath.push(project.name);
  663. await getParent(project.ParentID);
  664. }
  665. fullPath = fullPath.reverse();
  666. return fullPath;
  667. async function getParent(ParentID) {
  668. if(ParentID != -1){
  669. let parent = await projectModel.findOne({ID: ParentID, $or: notDeleted}, '-_id ParentID name');
  670. if(parent){
  671. fullPath.push(parent.name);
  672. await getParent(parent.ParentID);
  673. }
  674. }
  675. }
  676. }
  677. async function getProjectFeature(libID,feeStandardName){
  678. let lib = await featureLibModel.findOne({'ID':libID})
  679. if(lib){
  680. let eng = _.find(lib.feature,{'key':'engineering'})
  681. if(eng) eng.value = feeStandardName;
  682. return lib.feature;
  683. }else {
  684. return [];
  685. }
  686. }
  687. //获取文件下所有子项目
  688. async function getPosterityProjects(projectIDs) {
  689. let rst = [];
  690. async function getProjects(IDs) {
  691. if (IDs.length > 0) {
  692. let newIDs = [];
  693. let projs = await projectModel.find({ParentID: {$in: IDs}, $or: notDeleted}, '-_id -property');
  694. for (let proj of projs) {
  695. rst.push(proj);
  696. newIDs.push(proj.ID);
  697. }
  698. await getProjects(newIDs);
  699. }
  700. }
  701. await getProjects(projectIDs);
  702. return rst;
  703. }
  704. //打开的单位工程是否是被分享的
  705. async function isShare(userId, project){
  706. //判断是否是打开分享的项目,属于分享文件的子项也算
  707. while (project) {
  708. for(let shareData of project.shareInfo){
  709. if(shareData.userID === userId){
  710. return true;
  711. }
  712. }
  713. project = await projectModel.findOne({ID: project.ParentID}, '-_id shareInfo ID ParentID');
  714. }
  715. return false;
  716. }