pm_controller.js 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528
  1. /**
  2. * Created by Mai on 2017/1/18.
  3. */
  4. import UnitPriceFileModel from "../../glj/models/unit_price_file_model";
  5. import moment from 'moment';
  6. let mongoose = require('mongoose');
  7. let ProjectsData = require('../models/project_model').project;
  8. let labourCoe = require('../../main/facade/labour_coe_facade');
  9. let projType = require('../models/project_model').projType;
  10. let fileType = require('../models/project_model').fileType;
  11. const engineering = require("../../common/const/engineering");
  12. let EngineeringLibModel = require("../../users/models/engineering_lib_model");
  13. let fee_rate_facade = require("../../fee_rates/facade/fee_rates_facade");
  14. let billsModel = require('../../main/models/bills').model;
  15. let rationsModel = require('../../main/models/ration').model;
  16. let projectModel = mongoose.model('projects');
  17. let unitPriceFileModel = mongoose.model('unit_price_file');
  18. let feeRateFileModel = mongoose.model('fee_rate_file');
  19. let asyncTool = require('async');
  20. let pm_facade = require('../facade/pm_facade');
  21. const userModel = mongoose.model('user');
  22. //统一回调函数
  23. let callback = function(req, res, err, message, data){
  24. res.json({error: err, message: message, data: data});
  25. };
  26. module.exports = {
  27. checkRight: function (req, res) {
  28. if(typeof req.body.data === 'object'){
  29. req.body.data = JSON.stringify(req.body.data);
  30. }
  31. let data = JSON.parse(req.body.data);
  32. if (data.user_id) {
  33. return data.user_id === req.session.sessionUser.id;
  34. } else {
  35. return false;
  36. }
  37. },
  38. checkProjectRight: function (userId, projectId, callback) {
  39. ProjectsData.getProject(projectId).then(function (result) {
  40. /**
  41. * result._doc.userID(Number): MongoDB
  42. * userId(String): Session.userID
  43. */
  44. if (result._doc.userID == userId && result._doc.projType === projType.tender) {
  45. callback(true);
  46. } else {
  47. callback(false);
  48. }
  49. }).catch(function (err) {
  50. callback(false);
  51. });
  52. },
  53. getProjects: async function(req, res){
  54. await ProjectsData.getUserProjects(req.session.sessionUser.id, req.session.sessionCompilation._id, function(err, message, projects){
  55. if (projects) {
  56. callback(req, res, err, message, projects);
  57. } else {
  58. callback(req, res, err, message, null);
  59. }
  60. });
  61. },
  62. updateProjects: async function (req, res) {
  63. let data = JSON.parse(req.body.data);
  64. await ProjectsData.updateUserProjects(req.session.sessionUser.id, req.session.sessionCompilation._id, data.updateData, function (err, message, data) {
  65. if (err === 0) {
  66. callback(req, res, err, message, data);
  67. } else {
  68. callback(req, res, err, message, null);
  69. }
  70. });
  71. },
  72. // CSL, 2017-12-14 该方法用于项目属性:提交保存混合型数据,这些数据来自不同的表,包括projects.property、ration、bills、labour_coes.
  73. updateMixDatas: function(req, res){
  74. let datas = JSON.parse(req.body.data).mixDataArr;
  75. let functions = [];
  76. function updateFunc(model, cod, doc) {
  77. return function (cb) {
  78. model.update(cod, doc, cb);
  79. }
  80. };
  81. function updateLC(){
  82. return function (cb) {
  83. datas.labourCoes.updateData.projectID = datas.projectID;
  84. labourCoe.save(datas.labourCoes.updateData, cb);
  85. }
  86. };
  87. // 项目属性
  88. if (Object.keys(datas.properties).length > 0){
  89. functions.push(updateFunc(projectModel, {ID: datas.projectID}, datas.properties));
  90. };
  91. // 人工系数
  92. if (datas.labourCoes&&datas.labourCoes.updateData){
  93. functions.push(updateLC());
  94. };
  95. // 清单:每文档doc只存储一条清单,每条清单都必须定位一次文档,无法合并处理
  96. if (datas.bills.length > 0){
  97. for (let bill of datas.bills){
  98. functions.push(updateFunc(billsModel, {projectID: datas.projectID, ID: bill.ID, deleteInfo: null}, bill));
  99. };
  100. };
  101. // 定额:每文档doc只存储一条定额,每条定额都必须定位一次文档,无法合并处理
  102. if (datas.rations.length > 0){
  103. for (let ration of datas.rations){
  104. functions.push(updateFunc(rationsModel, {projectID: datas.projectID, ID: ration.ID, deleteInfo: null}, ration));
  105. };
  106. };
  107. asyncTool.parallel(functions, function(err, result){
  108. {
  109. if (!err) {
  110. res.json({error: 0, message: err, data: result});
  111. } else {
  112. res.json({error: 1, message: err, data: null});
  113. }
  114. }
  115. });
  116. },
  117. updateFiles: async function(req, res){
  118. let data = JSON.parse(req.body.data);
  119. let updateDatas = data.updateDatas;
  120. await ProjectsData.udpateUserFiles(req.session.sessionUser.id, updateDatas, function (err, message, data) {
  121. callback(req, res, err, message, data);
  122. });
  123. },
  124. /* copyProjects: function (req, res) {
  125. let data = JSON.parse(req.body.data);
  126. ProjectsData.copyUserProjects(req.session.sessionUser.id, req.session.sessionCompilation._id, data.updateData, function (err, message, data) {
  127. if (err === 0) {
  128. callback(req, res, err, message, data);
  129. } else {
  130. callback(req, res, err, message, null);
  131. }
  132. });
  133. },*/
  134. rename: function (req, res) {
  135. let data = JSON.parse(req.body.data);
  136. ProjectsData.rename(req.session.sessionUser.id, req.session.sessionCompilation._id, data, function (err, message) {
  137. callback(req, res, err, message, null);
  138. });
  139. },
  140. getProject: function(req, res){
  141. let data = JSON.parse(req.body.data);
  142. ProjectsData.getUserProject(req.session.sessionUser.id, data.proj_id, async function(err, message, data){
  143. if (err === 0) {
  144. let engineeringLibModel = new EngineeringLibModel();
  145. let engineeringInfo = data !== null && data.property.engineering_id !== undefined ?
  146. await engineeringLibModel.getEngineering(data.property.engineering_id) : null;
  147. let strData = JSON.stringify(data);
  148. let projInfo = JSON.parse(strData);
  149. if (engineeringInfo !== null) {
  150. projInfo.engineeringInfo = engineeringInfo;
  151. }
  152. callback(req, res, err, message, projInfo);
  153. } else {
  154. callback(req, res, err, message, null);
  155. }
  156. });
  157. },
  158. beforeOpenProject: function (req, res) {
  159. let data = JSON.parse(req.body.data);
  160. ProjectsData.beforeOpenProject(req.session.sessionUser.id, data.proj_id, data.updateData, function (err, message, data) {
  161. callback(req, res, err, message, data);
  162. });
  163. },
  164. getNewProjectID: function (req, res) {
  165. let data = JSON.parse(req.body.data);
  166. ProjectsData.getNewProjectID(data.count, function (err, message, data) {
  167. callback(req, res, err, message, data);
  168. });
  169. },
  170. // 项目管理首页
  171. index: async function(request, response) {
  172. // 获取编办信息
  173. let sessionCompilation = request.session.sessionCompilation;
  174. if (sessionCompilation === undefined) {
  175. return response.redirect('/logout');
  176. }
  177. // 清单计价
  178. let billValuation = sessionCompilation.bill_valuation !== undefined ?
  179. sessionCompilation.bill_valuation : [];
  180. // 获取标准库数据
  181. let engineeringLibModel = new EngineeringLibModel();
  182. billValuation = await engineeringLibModel.getLib(billValuation);
  183. // 定额计价
  184. let rationValuation = sessionCompilation.ration_valuation !== undefined ?
  185. sessionCompilation.ration_valuation : [];
  186. rationValuation = await engineeringLibModel.getLib(rationValuation);
  187. let renderData = {
  188. userAccount: request.session.userAccount,
  189. userID: request.session.sessionUser.id,
  190. compilationData: JSON.stringify(sessionCompilation),
  191. billValuation: JSON.stringify(billValuation),
  192. rationValuation: JSON.stringify(rationValuation),
  193. engineeringList: JSON.stringify(engineering.List),
  194. versionName: sessionCompilation.name + '免费版'
  195. };
  196. response.render('building_saas/pm/html/project-management.html', renderData);
  197. },
  198. // 获取单价文件列表
  199. getUnitFileList: async function(request, response) {
  200. let data = request.body.data;
  201. try {
  202. data = JSON.parse(data);
  203. let projectId = data.parentID !== undefined ? data.parentID : 0;
  204. if (isNaN(projectId) && projectId <= 0) {
  205. throw {msg: 'id数据有误!', err: 1};
  206. }
  207. /*// 获取对应建设项目下所有的单位工程id
  208. let idList = await ProjectsData.getTenderByProjectId(projectId);
  209. if (idList.length <= 0) {
  210. throw {msg: '不存在对应单位工程', err: 0};
  211. }*/
  212. // 获取对应的单价文件
  213. let unitPriceFileModel = new UnitPriceFileModel();
  214. let unitPriceFileData = await unitPriceFileModel.getDataByRootProject(projectId);
  215. if (unitPriceFileData === null) {
  216. throw {msg: '不存在对应单价文件', err: 0};
  217. }
  218. // 整理数据
  219. let unitPriceFileList = [];
  220. for (let unitPriceFile of unitPriceFileData) {
  221. let tmp = {
  222. name: unitPriceFile.name,
  223. id: unitPriceFile.id
  224. };
  225. unitPriceFileList.push(tmp);
  226. }
  227. callback(request, response, 0, '', unitPriceFileList);
  228. } catch (error) {
  229. console.log(error);
  230. let responseData = error.err === 1 ? null : [];
  231. callback(request, response, error.err, error.msg, responseData);
  232. }
  233. },
  234. getFeeRateFileList:async function(request, response) {
  235. let data = request.body.data;
  236. try {
  237. data = JSON.parse(data);
  238. let projectId = data.parentID !== undefined ? data.parentID : 0;
  239. if (isNaN(projectId) && projectId <= 0) {
  240. throw {msg: 'id数据有误!', err: 1};
  241. }
  242. // 获取对应建设项目下所有的单位工程id
  243. let feeRateFileList = await fee_rate_facade.getFeeRatesByProject(projectId);
  244. callback(request, response, 0, '',feeRateFileList );
  245. } catch (error) {
  246. console.log(error);
  247. let responseData = error.err === 1 ? null : [];
  248. callback(request, response, error.err, error.msg, responseData);
  249. }
  250. },
  251. getGCDatas: async function(request, response) {
  252. let userID = request.session.sessionUser.id;
  253. let compilatoinId = request.session.sessionCompilation._id;
  254. let rst = [];
  255. let _projs = Object.create(null), _engs = Object.create(null), prefix = 'ID_';
  256. try{
  257. let gc_unitPriceFiles = await ProjectsData.getGCFiles(fileType.unitPriceFile, userID);
  258. let gc_feeRateFiles = await ProjectsData.getGCFiles(fileType.feeRateFile, userID);
  259. let gc_tenderFiles = await ProjectsData.getGCFiles(projType.tender, userID);
  260. for(let i = 0, len = gc_unitPriceFiles.length; i < len; i++){
  261. let gc_uf = gc_unitPriceFiles[i];
  262. let theProj = _projs[prefix + gc_uf.root_project_id] || null;
  263. if(!theProj){
  264. let tempProj = await ProjectsData.getProjectsByIds(userID, compilatoinId, [gc_uf.root_project_id]);
  265. if(tempProj.length > 0 && tempProj[0].projType !== projType.folder){
  266. theProj = _projs[prefix + gc_uf.root_project_id] = tempProj[0]._doc;
  267. buildProj(theProj);
  268. }
  269. }
  270. if(theProj){
  271. theProj.unitPriceFiles.push(gc_uf);
  272. }
  273. }
  274. for(let i = 0, len = gc_feeRateFiles.length; i < len; i++){
  275. let gc_ff = gc_feeRateFiles[i];
  276. let theProj = _projs[prefix + gc_ff.rootProjectID] || null;
  277. if(!theProj){
  278. let tempProj = await ProjectsData.getProjectsByIds(userID, compilatoinId, [gc_ff.rootProjectID]);
  279. if(tempProj.length > 0 && tempProj[0].projType !== projType.folder){
  280. theProj = _projs[prefix + gc_ff.rootProjectID] = tempProj[0]._doc;
  281. buildProj(theProj);
  282. }
  283. }
  284. if(theProj) {
  285. theProj.feeRateFiles.push(gc_ff);
  286. }
  287. }
  288. if(gc_tenderFiles.length > 0){
  289. for(let i = 0, len = gc_tenderFiles.length; i < len; i++){
  290. let gc_t = gc_tenderFiles[i];
  291. let theEng = _engs[prefix + gc_t.ParentID] || null;
  292. if(!theEng){
  293. let tempEngs = await ProjectsData.getProjectsByIds(userID, compilatoinId, [gc_t.ParentID]);
  294. if(tempEngs.length > 0 && tempEngs[0].projType === projType.engineering){
  295. theEng = _engs[prefix + gc_t.ParentID] = tempEngs[0]._doc;
  296. theEng.children = [];
  297. }
  298. }
  299. if(theEng) {
  300. theEng.children.push(gc_t);
  301. let theProj = _projs[prefix + theEng.ParentID] || null;
  302. if(!theProj){
  303. let tempProj = await ProjectsData.getProjectsByIds(userID, compilatoinId, [theEng.ParentID]);
  304. if(tempProj.length > 0 && tempProj[0].projType === projType.project){
  305. theProj = _projs[prefix + theEng.ParentID] = tempProj[0]._doc;
  306. buildProj(theProj);
  307. }
  308. }
  309. if(theProj) {
  310. let isExist = false;
  311. for(let j = 0, jLen = theProj.children.length; j < jLen; j++){
  312. if(theProj.children[j].ID === theEng.ID){
  313. isExist = true;
  314. break;
  315. }
  316. }
  317. if(!isExist){
  318. theProj.children.push(theEng);
  319. }
  320. }
  321. }
  322. }
  323. }
  324. for(let i in _projs){
  325. rst.push(_projs[i]);
  326. }
  327. function buildProj(proj){
  328. proj.children = [];
  329. proj.unitPriceFiles = [];
  330. proj.feeRateFiles = [];
  331. }
  332. callback(request, response, 0, 'success', rst);
  333. }
  334. catch (error){
  335. callback(request, response, true, error, null);
  336. }
  337. },
  338. recGC: function(request, response){
  339. let userID = request.session.sessionUser.id;
  340. let data = JSON.parse(request.body.data);
  341. let nodes = data.nodes;
  342. ProjectsData.recGC(userID, nodes, function (err, msg, data) {
  343. callback(request, response, err, msg, data);
  344. });
  345. },
  346. delGC: async function(request, response){
  347. let data = JSON.parse(request.body.data);
  348. let delDatas = data.delDatas;
  349. let bulkProjs = [], bulkUFs = [], bulkFFs = [];
  350. try{
  351. for(let data of delDatas){
  352. if(data.updateType === 'Project'){
  353. bulkProjs.push({updateOne: {filter: {ID: data.ID}, update: {'deleteInfo.completeDeleted': true}}});
  354. }
  355. else if(data.updateType === fileType.unitPriceFile){
  356. bulkUFs.push({updateOne: {filter: {id: data.ID}, update: {'deleteInfo.completeDeleted': true}}});
  357. }
  358. else{
  359. bulkFFs.push({updateOne: {filter: {ID: data.ID}, update: {'deleteInfo.completeDeleted': true}}});
  360. }
  361. }
  362. if(bulkProjs.length > 0){
  363. await projectModel.bulkWrite(bulkProjs);
  364. }
  365. if(bulkUFs.length > 0){
  366. await unitPriceFileModel.bulkWrite(bulkUFs);
  367. }
  368. if(bulkFFs.length > 0){
  369. await feeRateFileModel.bulkWrite(bulkFFs);
  370. }
  371. callback(request, response, 0, 'success', null);
  372. } catch(err){
  373. callback(request, response, 1, err, null);
  374. }
  375. },
  376. moveProject:async function(req,res){
  377. let result={
  378. error:0
  379. };
  380. try {
  381. let data = req.body.data;
  382. let rdata= await pm_facade.moveProject(data);
  383. result.data= rdata;
  384. }catch (err){
  385. console.log(err);
  386. result.error=1;
  387. result.message = err.message;
  388. }
  389. res.json(result);
  390. },
  391. copyProjects:async function (req, res) {
  392. let result={
  393. error:0
  394. };
  395. try {
  396. let data = JSON.parse(req.body.data);
  397. result.data = await pm_facade.copyProject(req.session.sessionUser.id, req.session.sessionCompilation._id,data);
  398. }catch (err){
  399. console.log(err);
  400. result.error=1;
  401. result.message = err.message;
  402. }
  403. res.json(result);
  404. },
  405. projectShareInfo: async function(req, res){
  406. try{
  407. let data = JSON.parse(req.body.data);
  408. let shareInfo = await projectModel.findOne({ID: data.projectID, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]}, '-_id shareInfo');
  409. callback(req, res, 0, 'success', shareInfo);
  410. }
  411. catch (err){
  412. callback(req, res, 1, err, null);
  413. }
  414. },
  415. share: async function(req, res){
  416. try{
  417. let data = JSON.parse(req.body.data);
  418. //添加分享
  419. let shareData = {userID: data.userID, allowCopy: data.allowCopy, shareDate: moment(Date.now()).format('YYYY-MM-DD HH:mm:ss')};
  420. if(data.type === 'create'){
  421. await projectModel.update({ID: data.projectID, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]}, {$addToSet: {shareInfo: shareData}});
  422. }
  423. //取消分享
  424. else {
  425. await projectModel.update({ID: data.projectID, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}]}, {$pull: {shareInfo: {userID: data.userID}}});
  426. }
  427. callback(req, res, 0, 'success', null);
  428. }
  429. catch (err){
  430. callback(req, res, 1, err, null);
  431. }
  432. },
  433. getShareProjects: async function (req, res) {
  434. try {
  435. let userID = req.session.sessionUser.id;
  436. let rst = {receive: [], share: []}//接收的、由我分享的
  437. let shareProjects = await projectModel.find({userID: userID, $or: [{deleteInfo: null}, {'deleteInfo.deleted': false}], 'shareInfo.0': {$exists: true}});
  438. //项目类型为分享给别人
  439. let shareToUserIDs = [];
  440. for(let proj of shareProjects){
  441. proj._doc.shareType = 'shareTo';
  442. for(let shareToUser of proj.shareInfo){
  443. shareToUserIDs.push(shareToUser.userID);
  444. }
  445. }
  446. shareToUserIDs = Array.from(new Set(shareToUserIDs));
  447. let shareToObjIDs = [];
  448. for(let userID of shareToUserIDs){
  449. shareToObjIDs.push(mongoose.Types.ObjectId(userID));
  450. }
  451. let shareToUsers = await userModel.find({_id: {$in: shareToObjIDs}});
  452. for(let shareToUser of shareToUsers){
  453. for(let proj of shareProjects){
  454. for(let user of proj.shareInfo){
  455. if(user.userID === shareToUser._id.toString()){
  456. user._doc.company = shareToUser.company;
  457. user._doc.email = shareToUser.email;
  458. user._doc.name = shareToUser.real_name;
  459. user._doc.mobile = shareToUser.mobile;
  460. }
  461. }
  462. }
  463. }
  464. rst.share = shareProjects;
  465. let receiveProjects = await projectModel.find({$or: [{deleteInfo: null}, {'deleteInfo.deleted': false}], 'shareInfo.userID': userID});
  466. //设置原项目用户信息
  467. if(receiveProjects.length > 0){
  468. let orgUserIDs = [];
  469. for(let proj of receiveProjects){
  470. orgUserIDs.push(proj.userID);
  471. }
  472. orgUserIDs = Array.from(new Set(orgUserIDs));
  473. let userObjIDs = [];
  474. for(let uID of orgUserIDs){
  475. userObjIDs.push(mongoose.Types.ObjectId(uID));
  476. }
  477. let orgUsersInfo = await userModel.find({_id: {$in : userObjIDs}});
  478. for(let proj of receiveProjects){
  479. //设置项目类型为来自别人分享
  480. proj._doc.shareType = 'receive';
  481. for(let userData of orgUsersInfo){
  482. if(proj.userID == userData._id.toString()){
  483. let userInfo = {name: userData.real_name, mobile: userData.mobile, company: userData.company, email: userData.email};
  484. proj._doc.userInfo = userInfo;
  485. }
  486. }
  487. }
  488. }
  489. rst.receive = receiveProjects;
  490. callback(req, res, 0, 'success', rst);
  491. }
  492. catch (err){
  493. callback(req, res, 1, err, null);
  494. }
  495. },
  496. getProjectsByQuery: async function (req, res) {
  497. try{
  498. let data = JSON.parse(req.body.data);
  499. let query = data.query;
  500. let options = data.options;
  501. let projects = await projectModel.find(query, options);
  502. callback(req, res, 0, 'success', projects);
  503. }
  504. catch (err){
  505. callback(req, res, 1, err, null);
  506. }
  507. }
  508. };