pm_controller.js 23 KB

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