sub_proj_controller.js 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460
  1. 'use strict';
  2. /**
  3. *
  4. *
  5. * @author Mai
  6. * @date
  7. * @version
  8. */
  9. const auditConst = require('../const/audit');
  10. const accountGroup = require('../const/account_group').group;
  11. const sendToWormhole = require('stream-wormhole');
  12. const path = require('path');
  13. module.exports = app => {
  14. class SubProjController extends app.BaseController {
  15. /**
  16. * 概算投资
  17. *
  18. * @param ctx
  19. * @returns {Promise<void>}
  20. */
  21. async index(ctx) {
  22. try {
  23. const renderData = {
  24. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.subProject.list),
  25. auditConst,
  26. };
  27. renderData.budgetStd = await ctx.service.budgetStd.getDataByProjectId(ctx.session.sessionProject.id);
  28. renderData.projectList = await ctx.service.subProject.getSubProject(ctx.session.sessionProject.id, ctx.session.sessionUser.accountId, ctx.session.sessionUser.is_admin);
  29. for (const p of renderData.projectList) {
  30. p.tender_count = await ctx.service.tender.count({ spid: p.id });
  31. p.contract_count = await ctx.service.contract.count({ spid: p.id });
  32. p.file_count = await ctx.service.file.count({ spid: p.id, is_deleted: 0 });
  33. }
  34. renderData.tenderList = await ctx.service.tender.getManageTenderList(ctx.session.sessionProject.id);
  35. const accountList = await ctx.service.projectAccount.getAllDataByCondition({
  36. columns: ['id', 'name', 'company', 'role', 'enable', 'is_admin', 'account_group', 'mobile'],
  37. where: { project_id: ctx.session.sessionProject.id }
  38. });
  39. renderData.accountList = accountList;
  40. const unitList = await ctx.service.constructionUnit.getAllDataByCondition({ where: { pid: ctx.session.sessionProject.id } });
  41. renderData.accountGroup = unitList.map(item => {
  42. const groupList = accountList.filter(item1 => item1.company === item.name);
  43. return { groupName: item.name, groupList };
  44. }).filter(x => { return x.groupList.length > 0; });
  45. renderData.permissionConst = ctx.service.subProjPermission.PermissionConst;
  46. renderData.companys = await this.ctx.service.constructionUnit.getAllDataByCondition({ where: { pid: ctx.session.sessionProject.id } });
  47. renderData.templates = await this.ctx.service.filingTemplateList.getAllTemplate(ctx.session.sessionProject.id);
  48. await this.layout('sub_proj/index.ejs', renderData, 'sub_proj/modal.ejs');
  49. } catch (err) {
  50. console.log(err);
  51. ctx.log(err);
  52. ctx.session.postError = err.toString();
  53. ctx.redirect(this.menu.menu.dashboard.url);
  54. }
  55. }
  56. async addFolder(ctx) {
  57. try {
  58. const data = JSON.parse(ctx.request.body.data);
  59. if (!data.name || data.name.length > 100) throw '文件夹名称有误';
  60. const result = await ctx.service.subProject.addFolder(data);
  61. ctx.body = { err: 0, msg: '', data: result };
  62. } catch (err) {
  63. ctx.log(err);
  64. ctx.ajaxErrorBody(err, '新建文件夹失败');
  65. }
  66. }
  67. async addProj(ctx) {
  68. try {
  69. const data = JSON.parse(ctx.request.body.data);
  70. if (!data.name || data.name.length > 100) throw '项目名称有误';
  71. const result = await ctx.service.subProject.addSubProject(data);
  72. ctx.body = { err: 0, msg: '', data: result };
  73. } catch (err) {
  74. ctx.log(err);
  75. ctx.ajaxErrorBody(err, '新建项目失败');
  76. }
  77. }
  78. async dragTo(ctx) {
  79. try {
  80. const data = JSON.parse(ctx.request.body.data);
  81. if (!data.drag_id || !data.drop_id) throw '提交数据错误';
  82. const result = await ctx.service.subProject.dragTo(data);
  83. ctx.body = { err: 0, msg: '', data: result };
  84. } catch (err) {
  85. ctx.log(err);
  86. ctx.ajaxErrorBody(err, '调整所属文件夹失败');
  87. }
  88. }
  89. async move(ctx) {
  90. try {
  91. const data = JSON.parse(ctx.request.body.data);
  92. if (!data.id || !data.type) throw '提交数据错误';
  93. const result = await ctx.service.subProject.move(data);
  94. ctx.body = { err: 0, msg: '', data: result };
  95. } catch (err) {
  96. ctx.log(err);
  97. ctx.ajaxErrorBody(err, '调整所属文件夹失败');
  98. }
  99. }
  100. async del(ctx) {
  101. try {
  102. const data = JSON.parse(ctx.request.body.data);
  103. if (!data.id) throw '参数有误';
  104. const result = await ctx.service.subProject.del(data.id);
  105. ctx.body = { err: 0, msg: '', data: result };
  106. } catch(err) {
  107. ctx.log(err);
  108. ctx.ajaxErrorBody(err, '删除项目失败');
  109. }
  110. }
  111. async save(ctx) {
  112. try {
  113. const data = JSON.parse(ctx.request.body.data);
  114. if (!data.id) throw '参数有误';
  115. let result = null;
  116. if (data.name !== undefined) {
  117. if (!data.name || data.name.length > 100) throw '项目名称有误';
  118. result = await ctx.service.subProject.save({ id: data.id, name: data.name });
  119. } else if (data.rela_tender !== undefined) {
  120. result = await ctx.service.subProject.setRelaTender({ id: data.id, rela_tender: data.rela_tender });
  121. } else if (data.std_id !== undefined) {
  122. result = await ctx.service.subProject.setBudgetStd({ id: data.id, std_id: data.std_id });
  123. } else if (data.management !== undefined) {
  124. result = await ctx.service.subProject.setManagement({ id: data.id, management: data.management, filingTemplate: data.filingTemplate });
  125. }
  126. ctx.body = { err: 0, msg: '', data: { update: [result] } };
  127. } catch(err) {
  128. ctx.log(err);
  129. ctx.ajaxErrorBody(err, '保存数据失败');
  130. }
  131. }
  132. async refresh(ctx) {
  133. try {
  134. const data = JSON.parse(ctx.request.body.data);
  135. if (!data.id) throw '参数有误';
  136. const result = await ctx.service.subProject.refreshManagementPermission({ id: data.id });
  137. ctx.body = { err: 0, msg: '', data: result };
  138. } catch(err) {
  139. ctx.log(err);
  140. ctx.ajaxErrorBody(err, '保存数据失败');
  141. }
  142. }
  143. async rela(ctx) {
  144. try {
  145. const id = ctx.query.id;
  146. const projectList = await ctx.service.subProject.getSubProject(this.ctx.session.sessionProject.id, this.ctx.session.sessionUser.accountId, true);
  147. const otherProj = projectList.filter(x => { return x.id !== id || !x.rela_tender || x.is_folder });
  148. const _ = ctx.helper._;
  149. const otherRela = _.map(_.map(otherProj, 'rela_tender').join(',').split(','), _.toInteger);
  150. const tenderList = await ctx.service.tender.getList4Select('stage');
  151. ctx.body = {
  152. err: 0,
  153. msg: '',
  154. data: tenderList.filter(x => { return otherRela.indexOf(x.id) === -1})
  155. .map(y => { return {id: y.id, name: y.name, lastStageOrder: y.lastStage.order, lastStageStatus: auditConst.stage.statusString[y.lastStage.status], category: y.category}}),
  156. };
  157. } catch (err) {
  158. ctx.log(err);
  159. ctx.postError(err, '获取数据失败');
  160. }
  161. }
  162. async saveRela(ctx) {
  163. try {
  164. const data = JSON.parse(ctx.request.body.data);
  165. if (!data.id || data.rela_tender === undefined) throw '参数有误';
  166. const permission = ctx.session.sessionUser.is_admin
  167. ? ctx.service.subProjPermission.adminPermission
  168. : await ctx.service.subProjPermission.getSubProjectUserPermission(data.id, ctx.session.sessionUser.accountId);
  169. if (!permission || permission.manage_permission.indexOf(ctx.service.subProjPermission.PermissionConst.manage.rela.value) < 0) throw '您无权进行该操作';
  170. const result = await ctx.service.subProject.setRelaTender({ id: data.id, rela_tender: data.rela_tender || '' });
  171. ctx.body = { err: 0, msg: '', data: { update: [result] } };
  172. } catch(err) {
  173. ctx.log(err);
  174. ctx.ajaxErrorBody(err, '保存数据失败');
  175. }
  176. }
  177. async member(ctx) {
  178. try {
  179. const data = JSON.parse(ctx.request.body.data);
  180. const member = await ctx.service.subProjPermission.getPermission(data.id);
  181. ctx.body = { err: 0, msg: '', data: member };
  182. } catch (err) {
  183. ctx.log(err);
  184. ctx.ajaxErrorBody(err, '查询项目成员失败');
  185. }
  186. }
  187. async memberSave(ctx) {
  188. try {
  189. const data = JSON.parse(ctx.request.body.data);
  190. if (!data.id) throw '参数有误';
  191. await ctx.service.subProjPermission.savePermission(data.id, data.member);
  192. ctx.body = { err: 0, msg: '', data: '' };
  193. } catch (err) {
  194. ctx.log(err);
  195. ctx.ajaxErrorBody(err, '保存数据失败');
  196. }
  197. }
  198. async info(ctx) {
  199. try {
  200. const info = await this.ctx.service.subProjInfo.getInfo(ctx.subProject.id);
  201. info.lx_tp = await this.ctx.service.budgetGu.getSumTp(ctx.subProject.budget_id);
  202. info.cb_tp = await this.ctx.service.budgetGai.getSumTp(ctx.subProject.budget_id);
  203. info.sgt_tp = await this.ctx.service.budgetYu.getSumTp(ctx.subProject.budget_id);
  204. info.zbys_tp = await this.ctx.service.budgetZb.getSumTp(ctx.subProject.budget_id);
  205. const renderData = {
  206. info,
  207. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.subProject.info),
  208. };
  209. await this.layout('sub_proj/info.ejs', renderData);
  210. } catch (err) {
  211. ctx.log(err);
  212. }
  213. }
  214. async dataIndex(ctx) {
  215. try {
  216. const info = await this.ctx.service.subProjInfo.getInfo(ctx.subProject.id);
  217. const renderData = {
  218. info,
  219. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.subProject.data),
  220. };
  221. await this.layout('sub_proj/data_index.ejs', renderData);
  222. } catch (err) {
  223. ctx.log(err);
  224. }
  225. }
  226. async saveInfo(ctx) {
  227. try {
  228. const data = JSON.parse(ctx.request.body.data);
  229. const result = await ctx.service.subProjInfo.saveInfo(ctx.subProject.id, data);
  230. ctx.body = { err: 0, msg: '', data: result };
  231. } catch(err) {
  232. ctx.log(err);
  233. }
  234. }
  235. async progress(ctx) {
  236. try {
  237. const fileReferenceList = await ctx.service.subProject.getFileReference(ctx.subProject, ctx.service.subProject.FileReferenceType.info_progress);
  238. const renderData = {
  239. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.subProject.progress),
  240. fileReferenceList,
  241. };
  242. await this.layout('sub_proj/progress.ejs', renderData, 'sub_proj/progress_modal.ejs');
  243. } catch (err) {
  244. ctx.log(err);
  245. ctx.postError(err, '查看阶段进度')
  246. }
  247. }
  248. async load(ctx) {
  249. try {
  250. const data = JSON.parse(ctx.request.body.data);
  251. const filter = data.filter.split(';');
  252. const result = {};
  253. for (const f of filter) {
  254. switch(f) {
  255. case 'progress':
  256. result[f] = await ctx.service.subProjProgress.getData(ctx.subProject);
  257. break;
  258. case 'progress_file':
  259. result[f] = await ctx.service.subProjFile.getData(ctx.subProject.id, 'progress');
  260. break;
  261. case 'push':
  262. result[f] = await ctx.service.subProjPush.getData(ctx.subProject.id);
  263. break;
  264. case 'push_file':
  265. result[f] = await ctx.service.subProjFile.getData(ctx.subProject.id, 'push');
  266. break;
  267. default:
  268. continue;
  269. }
  270. }
  271. ctx.body = { err: 0, msg: '', data: result };
  272. } catch(err) {
  273. ctx.log(err);
  274. ctx.ajaxErrorBody(err, '获取阶段进度数据有误');
  275. }
  276. }
  277. async _progressBase(subProj, type, data) {
  278. if (isNaN(data.id) || data.id <= 0) throw '数据错误';
  279. if (type !== 'add') {
  280. if (isNaN(data.count) || data.count <= 0) data.count = 1;
  281. }
  282. switch (type) {
  283. case 'add':
  284. return await this.ctx.service.subProjProgress.addProgressNode(subProj.id, data.id, data.count);
  285. case 'delete':
  286. return await this.ctx.service.subProjProgress.delete(subProj.id, data.id, data.count);
  287. case 'up-move':
  288. return await this.ctx.service.subProjProgress.upMoveNode(subProj.id, data.id, data.count);
  289. case 'down-move':
  290. return await this.ctx.service.subProjProgress.downMoveNode(subProj.id, data.id, data.count);
  291. case 'up-level':
  292. return await this.ctx.service.subProjProgress.upLevelNode(subProj.id, data.id, data.count);
  293. case 'down-level':
  294. return await this.ctx.service.subProjProgress.downLevelNode(subProj.id, data.id, data.count);
  295. }
  296. }
  297. async progressUpdate(ctx) {
  298. try {
  299. const data = JSON.parse(ctx.request.body.data);
  300. if (!data.postType || !data.postData) throw '数据错误';
  301. const responseData = { err: 0, msg: '', data: {} };
  302. switch (data.postType) {
  303. case 'add':
  304. case 'delete':
  305. case 'up-move':
  306. case 'down-move':
  307. case 'up-level':
  308. case 'down-level':
  309. responseData.data = await this._progressBase(ctx.subProject, data.postType, data.postData);
  310. break;
  311. case 'update':
  312. responseData.data = await this.ctx.service.subProjProgress.updateInfos(ctx.subProject.id, data.postData);
  313. break;
  314. case 'add-std':
  315. responseData.data = await this.ctx.service.subProjProgress.addStdNode(ctx.subProject, data.postData.id, data.postData.stdData);
  316. break;
  317. default:
  318. throw '未知操作';
  319. }
  320. ctx.body = responseData;
  321. } catch (err) {
  322. this.log(err);
  323. ctx.body = this.ajaxErrorBody(err, '数据错误');
  324. }
  325. }
  326. async push(ctx) {
  327. try {
  328. const renderData = {
  329. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.subProject.push),
  330. };
  331. await this.layout('sub_proj/push.ejs', renderData, 'sub_proj/push_modal.ejs');
  332. } catch (err) {
  333. ctx.log(err);
  334. }
  335. }
  336. async pushUpdate(ctx) {
  337. try {
  338. const data = JSON.parse(ctx.request.body.data);
  339. const result = await ctx.service.subProjPush.updateDatas(data);
  340. ctx.body = { err: 0, msg: '', data: result };
  341. } catch (error) {
  342. ctx.helper.log(error);
  343. ctx.body = this.ajaxErrorBody(error, '提交数据失败,请重试');
  344. }
  345. }
  346. /**
  347. * 上传附件
  348. * @param {Object} ctx - egg全局变量
  349. * @return {void}
  350. */
  351. async uploadFile(ctx) {
  352. let stream;
  353. try {
  354. const parts = ctx.multipart({autoFields: true});
  355. let index = 0;
  356. const create_time = Date.parse(new Date()) / 1000;
  357. let stream = await parts();
  358. const user = await ctx.service.projectAccount.getDataById(ctx.session.sessionUser.accountId);
  359. const rela_id = parts.field.rela_id;
  360. const uploadfiles = [];
  361. while (stream !== undefined) {
  362. if (!stream.filename) throw '未发现上传文件!';
  363. const fileInfo = path.parse(stream.filename);
  364. const filepath = `sp/progress/${ctx.subProject.id}/${ctx.moment().format('YYYYMMDD')}/${create_time + '_' + index + fileInfo.ext}`;
  365. // 保存文件
  366. await ctx.app.fujianOss.put(ctx.app.config.fujianOssFolder + filepath, stream);
  367. await sendToWormhole(stream);
  368. // 插入到stage_pay对应的附件列表中
  369. uploadfiles.push({
  370. rela_id,
  371. filename: fileInfo.name,
  372. fileext: fileInfo.ext,
  373. filesize: Array.isArray(parts.field.size) ? parts.field.size[index] : parts.field.size,
  374. filepath,
  375. });
  376. ++index;
  377. if (Array.isArray(parts.field.size) && index < parts.field.size.length) {
  378. stream = await parts();
  379. } else {
  380. stream = undefined;
  381. }
  382. }
  383. const result = await ctx.service.subProjFile.addFiles(ctx.subProject.id, ctx.request.url.split('/')[3], uploadfiles, user);
  384. ctx.body = {err: 0, msg: '', data: result};
  385. } catch (error) {
  386. ctx.log(error);
  387. // 失败需要消耗掉stream 以防卡死
  388. if (stream) await sendToWormhole(stream);
  389. ctx.body = this.ajaxErrorBody(error, '上传附件失败,请重试');
  390. }
  391. }
  392. async deleteFile(ctx) {
  393. try{
  394. const data = JSON.parse(ctx.request.body.data);
  395. if (!data) throw '缺少参数';
  396. const result = await ctx.service.subProjFile.delFiles(data);
  397. ctx.body = { err: 0, msg: '', data: result };
  398. } catch(error) {
  399. this.log(error);
  400. ctx.ajaxErrorBody(error, '删除附件失败');
  401. }
  402. }
  403. async noPermission(ctx) {
  404. ctx.controllerName = ctx.params.block;
  405. await this.layout('sub_proj/no_permission.ejs');
  406. }
  407. /**
  408. * 保存列设置
  409. * @param ctx
  410. * @returns {Promise<void>}
  411. */
  412. async colSet(ctx) {
  413. try {
  414. const colType = ctx.request.body.col_type;
  415. const colSet = JSON.parse(ctx.request.body.col_set);
  416. await ctx.service.projectColSet.setProjectColSet(ctx.subProject.project_id, ctx.subProject.id, colType, colSet);
  417. ctx.redirect(ctx.request.header.referer);
  418. } catch (err) {
  419. ctx.redirect(ctx.request.header.referer);
  420. }
  421. }
  422. }
  423. return SubProjController;
  424. };