project_facade.js 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486
  1. /**
  2. * Created by zhang on 2018/1/26.
  3. */
  4. module.exports = {
  5. markUpdateProject:markUpdateProject,
  6. removeProjectMark:removeProjectMark,
  7. updateNodes:updateNodes,
  8. calcInstallationFee:calcInstallationFee,
  9. saveProperty: saveProperty,
  10. getDefaultColSetting: getDefaultColSetting,
  11. markProjectsToChange:markProjectsToChange,
  12. getSEIProjects:getSEIProjects,
  13. loadSEIProjectData:loadSEIProjectData,
  14. setSEILibData:setSEILibData,
  15. getIndexReportData:getIndexReportData
  16. };
  17. let mongoose = require('mongoose');
  18. let logger = require("../../../logs/log_helper").logger;
  19. let projectsModel = mongoose.model('projects');
  20. let async_n = require("async");
  21. let _ = require('lodash');
  22. let ration_model = require('../models/ration');
  23. let bill_model = require('../models/bills');
  24. let consts = require('../models/project_consts');
  25. let projectConsts = consts.projectConst;
  26. let ration_glj_model = mongoose.model('ration_glj');
  27. let rationTemplateModel = mongoose.model('ration_template');
  28. let project_glj_model = mongoose.model('glj_list');
  29. let ration_glj_facade = require("../../ration_glj/facade/ration_glj_facade");
  30. const uuidV1 = require('uuid/v1');
  31. const gljUtil = require('../../../public/gljUtil');
  32. let stdColSettingModel = mongoose.model('std_main_col_lib');
  33. import GLJListModel from "../../glj/models/glj_list_model";
  34. let economicLib = mongoose.model('std_economic_lib');
  35. let engineerFeatureLib = mongoose.model('std_engineer_feature_lib');
  36. let engineerInfoLib = mongoose.model('std_engineer_info_lib');
  37. let mainQuantityLib = mongoose.model('std_main_quantity_lib');
  38. let materialLib = mongoose.model('std_material_lib');
  39. import fixedFlag from '../../common/const/bills_fixed';
  40. const scMathUtil = require('../../../public/scMathUtil').getUtil();
  41. async function calcInstallationFee(data) {
  42. let result={};
  43. let billTasks = generateTasks(data.bills,data.useID);
  44. let rationTasks = generateTasks(data.ration,data.useID);
  45. if(billTasks.length>0){
  46. await bill_model.model.bulkWrite(billTasks);
  47. }
  48. console.log(rationTasks);
  49. if(rationTasks.length>0){
  50. await ration_model.model.bulkWrite(rationTasks);
  51. }
  52. //如果删除定额,需要删除对应的工料机
  53. if(data.ration.delete.length>0){
  54. let rationIDS = _.map(data.ration.delete,'ID');
  55. await ration_glj_model.deleteMany({projectID: data.ration.delete[0].projectID, rationID: {"$in": rationIDS}});//删除定额工料机
  56. }
  57. let rationGLJTasks = [];
  58. let updateList = [];
  59. if(data.ration.update.length>0){//如果有需要更新的定额工料机
  60. for(let ur of data.ration.update){
  61. for(let g of ur.glj){
  62. let gTasks = {
  63. updateOne:{
  64. filter:{
  65. ID:g.ID,
  66. projectID:g.projectID
  67. },
  68. update :{
  69. quantity:g.quantity,
  70. rationItemQuantity:g.rationItemQuantity
  71. }
  72. }
  73. };
  74. rationGLJTasks.push(gTasks);
  75. updateList.push(g);
  76. }
  77. }
  78. }
  79. if(rationGLJTasks.length>0){
  80. await ration_glj_model.bulkWrite(rationGLJTasks);
  81. }
  82. let newGljList = [];
  83. if(data.ration.add.length>0){//新增的安装子目要增加对应的工料机
  84. for(let nr of data.ration.add){
  85. for(let tkey in nr.glj){
  86. newGljList.push(await addInstallationGLJ(nr.glj[tkey]));
  87. }
  88. }
  89. }
  90. if(newGljList.length>0){
  91. await ration_glj_model.insertMany(newGljList);
  92. }
  93. result.update = updateList;
  94. result.add = newGljList;
  95. return result;
  96. }
  97. async function addInstallationGLJ(glj) {
  98. glj.ID = uuidV1();
  99. let info = await ration_glj_facade.getInfoFromProjectGLJ(glj);
  100. let newRecode = ration_glj_facade.createNewRecord(info);
  101. return newRecode;
  102. }
  103. function generateTasks(data,userID) {
  104. let tasks=[];
  105. let deleteInfo={deleted: true, deleteDateTime: new Date(), deleteBy: userID};
  106. if(data.delete && data.delete.length > 0){
  107. for(let bd of data.delete){
  108. //原先是假删除,现在改成真删除
  109. let task = {
  110. deleteOne:{
  111. filter:{
  112. ID:bd.ID,
  113. projectID:bd.projectID
  114. }
  115. }
  116. };
  117. /* let task={
  118. updateOne:{
  119. filter:{
  120. ID:bd.ID,
  121. projectID:bd.projectID
  122. },
  123. update :{
  124. deleteInfo:deleteInfo
  125. }
  126. }
  127. };*/
  128. tasks.push(task);
  129. }
  130. }
  131. if(data.add && data.add.length > 0){
  132. for(let n_data of data.add){
  133. let task = {
  134. insertOne :{
  135. document:n_data
  136. }
  137. };
  138. tasks.push(task);
  139. }
  140. }
  141. return tasks;
  142. }
  143. async function updateNodes(datas){
  144. let nodeGroups = _.groupBy(datas,'type');
  145. let rationTasks = [];
  146. let billTasks = [];
  147. let rationGLJTasks = [];
  148. let projectGLJTasks = [];
  149. let projectTasks = [];
  150. let rationTemplateTasks = [];
  151. let asyncTasks = [];
  152. for(let type in nodeGroups){
  153. for(let node of nodeGroups[type]){
  154. if(type == projectConsts.BILLS){
  155. billTasks.push(getTask(node));
  156. }else if(type == projectConsts.RATION){
  157. rationTasks.push(getTask(node));
  158. }else if(type == projectConsts.RATION_GLJ){
  159. rationGLJTasks.push(getTask(node));
  160. }else if(type == projectConsts.PROJECTGLJ){
  161. projectGLJTasks.push(getTask(node,'id'));
  162. }else if(type == projectConsts.PROJECT){
  163. projectTasks.push(getTask(node));
  164. }else if(type == projectConsts.RATION_TEMPLATE){
  165. rationTemplateTasks.push(getTask(node))
  166. }
  167. }
  168. }
  169. rationTasks.length>0?asyncTasks.push(ration_model.model.bulkWrite(rationTasks)):'';
  170. billTasks.length>0?asyncTasks.push(bill_model.model.bulkWrite(billTasks)):"";
  171. rationGLJTasks.length>0?asyncTasks.push(ration_glj_model.bulkWrite(rationGLJTasks)):"";
  172. projectGLJTasks.length>0?asyncTasks.push(project_glj_model.bulkWrite(projectGLJTasks)):"";
  173. projectTasks.length>0?asyncTasks.push(projectsModel.bulkWrite(projectTasks)):"";
  174. rationTemplateTasks.length>0?asyncTasks.push(rationTemplateModel.bulkWrite(rationTemplateTasks)):"";
  175. return asyncTasks.length>0?await Promise.all(asyncTasks):"";
  176. function getTask(node,idFiled = 'ID') {
  177. let task={
  178. updateOne:{
  179. filter:{},
  180. update :_.cloneDeep(node.data)
  181. }
  182. };
  183. task.updateOne.filter[idFiled] = node.data[idFiled];//现在复制项目也重新生成一个新的ID了,所以ID是唯一的
  184. delete task.updateOne.update[idFiled];//防止误操作
  185. return task;
  186. }
  187. }
  188. /*function updateNodes(datas,callback) {
  189. let tasks = [];
  190. for(let node of datas){
  191. tasks.push(updateOne(node))
  192. }
  193. async_n.parallel(tasks, function(err, results) {
  194. if (!err){
  195. callback(0, '', results);
  196. }
  197. else{
  198. console.log(err);
  199. callback(1, 'save project failed'+err.message, null);
  200. }
  201. });
  202. function updateOne(node) {
  203. if(node.type == projectConsts.BILLS){
  204. return function (asCallback) {
  205. bill_model.model.findOneAndUpdate({projectID: node.data.projectID, ID: node.data.ID,deleteInfo: null}, node.data,{new: true}, asCallback);
  206. }
  207. }else if(node.type ==projectConsts.RATION){
  208. return function (asCallback) {
  209. ration_model.model.findOneAndUpdate({projectID: node.data.projectID, ID: node.data.ID,deleteInfo: null}, node.data,{new: true}, asCallback);
  210. }
  211. }
  212. }
  213. }*/
  214. //data = {feeRateID:111111,projectID:1245}; type = feeRate
  215. async function markUpdateProject(data,type) {
  216. let query = {deleteInfo:null};
  217. if(type=="feeRate"){//更改了费率
  218. query['property.feeFile.id'] = data.feeRateID;
  219. }
  220. if(type=="unitFile"){//更改了单价文件
  221. query['property.unitPriceFile.id'] = data.unitFileID;//unitPriceFile
  222. }
  223. let projects = await projectsModel.find(query);
  224. return await markProjectsToChange(projects,type,data.projectID);
  225. }
  226. async function markProjectsToChange(projects,type,extProjectID){
  227. let tasks=[];
  228. for(let p of projects){
  229. if(extProjectID && p.ID===extProjectID) continue;//排除当前项目
  230. tasks.push(generateMarkTask(type,p.ID));
  231. }
  232. return tasks.length>0 ? await projectsModel.bulkWrite(tasks):null;
  233. }
  234. async function removeProjectMark(projectID) {
  235. return await projectsModel.findOneAndUpdate({ID:projectID},{"$unset":{"changeMark":1}});
  236. }
  237. function generateMarkTask(value,projectID) {
  238. let task = {
  239. updateOne:{
  240. filter:{
  241. ID:projectID
  242. },
  243. update:{
  244. changeMark:value
  245. }
  246. }
  247. };
  248. return task
  249. }
  250. // {projectID: 5, propertyName: 'aaa', propertyValue: 1}
  251. function saveProperty(data, callback){
  252. let obj = {};
  253. let pn = 'property.' + data.propertyName;
  254. obj[pn] = data.propertyValue;
  255. projectsModel.update({"ID": data.projectID}, obj, function (err) {
  256. if (err) {
  257. logger.err(pn + ' save error: ' + err);
  258. callback(err, null)
  259. } else {
  260. logger.info(pn + ' saved.');
  261. callback('', null);
  262. }}
  263. );
  264. }
  265. async function getDefaultColSetting(libID){
  266. return await stdColSettingModel.findOne({ID: libID, deleted: false}, '-_id main_tree_col');
  267. }
  268. function sortChildren(lists) {
  269. let IDMap ={},nextMap = {}, firstNode = null,newList=[];
  270. for(let l of lists){
  271. if(l.children&&l.children.length > 0) l.children = sortChildren(l.children);//递规排序
  272. IDMap[l.ID] = l;
  273. if(l.NextSiblingID!=-1) nextMap[l.NextSiblingID] = l;
  274. }
  275. for(let t of lists){
  276. if(!nextMap[t.ID]){ //如果在下一节点映射没找到,则是第一个节点
  277. firstNode = t;
  278. break;
  279. }
  280. }
  281. if(firstNode){
  282. newList.push(firstNode);
  283. delete IDMap[firstNode.ID];
  284. setNext(firstNode,newList);
  285. }
  286. //容错处理,如果链断了的情况,直接添加到后面
  287. for(let key in IDMap){
  288. if(IDMap[key]) newList.push(IDMap[key])
  289. }
  290. return newList;
  291. function setNext(node,array) {
  292. if(node.NextSiblingID != -1){
  293. let next = IDMap[node.NextSiblingID];
  294. if(next){
  295. array.push(next);
  296. delete IDMap[next.ID];
  297. setNext(next,array);
  298. }
  299. }
  300. }
  301. }
  302. async function getSEIProjects(projectID) {
  303. let project = await projectsModel.findOne({ID:projectID});
  304. if(!project) throw new Error(`找不到建设项目:${projectID}`);
  305. let tem_e = await projectsModel.find({ParentID:project.ID});
  306. let engineers = [];
  307. for(let e of tem_e){
  308. if(!e.deleteInfo || !e.deleteInfo.deleted){
  309. let tenders = await projectsModel.find({ParentID:e.ID});
  310. let children = [];
  311. for(let t of tenders){
  312. if(!t.deleteInfo || !t.deleteInfo.deleted){
  313. children.push(t);
  314. }
  315. }
  316. e._doc.children = children;
  317. engineers.push(e);
  318. }
  319. }
  320. engineers = sortChildren(engineers);
  321. project._doc.children = engineers;
  322. return project;
  323. }
  324. async function loadSEIProjectData(projectID) {
  325. let gljListModel = new GLJListModel();
  326. let [gljList, mixRatioConnectData,mixRatioMap,unitPriceMap] = await gljListModel.getListByProjectId(projectID);
  327. let rations = await ration_model.getDataSync(projectID);
  328. let bills = await bill_model.getDataSync(projectID);
  329. let ration_gljs = await ration_glj_model.find({projectID:projectID});
  330. let projectGLJs = {
  331. gljList : gljList,
  332. mixRatioConnectData:mixRatioConnectData,
  333. mixRatioMap:mixRatioMap,
  334. unitPriceMap:unitPriceMap
  335. };
  336. return{bills:bills,rations:rations,ration_gljs:ration_gljs,projectGLJs:projectGLJs}
  337. }
  338. async function setSEILibData(property){
  339. if(property.engineerInfoLibID){//工程信息指标
  340. let engineerInfo = await engineerInfoLib.findOne({'ID':property.engineerInfoLibID});
  341. if(engineerInfo) property.engineerInfos = engineerInfo.info;
  342. }
  343. if(property.engineerFeatureLibID){//工程特征指标
  344. let engineerFeature = await engineerFeatureLib.findOne({'ID':property.engineerFeatureLibID});
  345. if(engineerFeature) property.engineerFeatures = engineerFeature.features;
  346. }
  347. if(property.materialLibID){//主要工料指标
  348. let material = await materialLib.findOne({'ID':property.materialLibID});
  349. if(material) property.materials = material.materials;
  350. }
  351. if(property.mainQuantityLibID){//主要工程量指标
  352. let mainQuantity = await mainQuantityLib.findOne({'ID':property.mainQuantityLibID});
  353. if(mainQuantity) property.mainQuantities = mainQuantity.index;
  354. }
  355. if(property.economicLibID){//主要工程量指标
  356. let economic = await economicLib.findOne({'ID':property.economicLibID});
  357. if(economic) property.economics = economic.index;
  358. }
  359. }
  360. async function getIndexReportData(projectID,keyArr) {
  361. let project = await projectsModel.findOne({ID:projectID});
  362. let bills = await bill_model.getDataSync(projectID);
  363. let result = {};
  364. for(let key of keyArr){
  365. switch (key) {
  366. case 'ProjectCostFields':
  367. result[key] =getEngineerCostData(project.property,bills);
  368. break;
  369. case 'ProjectEcoFields':
  370. result[key] = getEconomicDatas(project.property,bills);
  371. break;
  372. case 'ProjectLabMaterialFields':
  373. result[key] = await getMainMaterialDatas(projectID,project.property);
  374. break;
  375. case 'ProjectQtyFields':
  376. result[key] = await getQuantityDatas(project.property,bills);
  377. break;
  378. case 'ProjectInfoFields':
  379. result[key] = getEngineerInfoData(project.property.engineerInfos);
  380. break;
  381. case 'ProjectFeatureFields':
  382. result[key] = getEngineerFeaturesDatas(project.property.engineerFeatures);
  383. break;
  384. }
  385. }
  386. return result
  387. }
  388. function getEngineerInfoData(engineerInfos) {
  389. let datas = [];
  390. for(let info of engineerInfos){
  391. let d = {
  392. name:info.dispName,
  393. value:info.value
  394. };
  395. datas.push(d);
  396. }
  397. return datas;
  398. }
  399. function getEngineerFeaturesDatas(engineerFeatures) {
  400. let datas = [];
  401. if (engineerFeatures !== null && engineerFeatures !== undefined) {
  402. for(let f of engineerFeatures){
  403. let tem = {
  404. ID:f.ID,
  405. name:f.name,
  406. value:f.value,
  407. ParentID:f.ParentID
  408. }
  409. datas.push(tem);
  410. }
  411. }
  412. return datas;
  413. }
  414. function getQuantityDatas(property,bills) {
  415. return gljUtil.getQuantityDatas(property.engineerFeatures,property.mainQuantities,bills,fixedFlag,_,scMathUtil,property.decimal)
  416. }
  417. function getEconomicDatas(property,bills) {
  418. return gljUtil.getEconomicDatas(property.engineerFeatures,property.economics,bills,fixedFlag,_,scMathUtil,property.decimal)
  419. }
  420. function getEngineerCostData(property,bills){
  421. let datas = [];
  422. let priceIndex = gljUtil.getEngineerCostData(property,bills,fixedFlag,scMathUtil);
  423. for(let c of priceIndex.children){
  424. let tem = {
  425. name:c.name,
  426. cost:parseFloat(c.attrs[0].value),
  427. unitCost:parseFloat(c.attrs[1].value),
  428. per:parseFloat(c.attrs[2].value)
  429. };
  430. datas.push(tem);
  431. }
  432. return datas;
  433. }
  434. async function getMainMaterialDatas(projectID,property) {
  435. let gljListModel = new GLJListModel();
  436. let [gljList, mixRatioConnectData,mixRatioMap,unitPriceMap] = await gljListModel.getListByProjectId(projectID, property.unitPriceFile?property.unitPriceFile.id:null);
  437. gljList = JSON.parse(JSON.stringify(gljList));
  438. await calcProjectGLJQuantity(projectID,{gljList:gljList,mixRatioMap:mixRatioMap},property);
  439. return gljUtil.getMainMaterialDatas(property.engineerFeatures,property.materials,{gljList:gljList},property.calcOptions,property.decimal,false,_,scMathUtil)
  440. }
  441. async function calcProjectGLJQuantity(projectID,projectGLJDatas,property){
  442. let q_decimal = property.decimal.glj.quantity;
  443. let rationGLJDatas = await ration_glj_model.find({'projectID':projectID});
  444. let rationDatas = await ration_model.model.find({'projectID':projectID});
  445. gljUtil.calcProjectGLJQuantity(projectGLJDatas,rationGLJDatas,rationDatas,[],q_decimal)
  446. }