setting_controller.js 47 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153
  1. 'use strict';
  2. /**
  3. *
  4. *
  5. * @author Mai
  6. * @date
  7. * @version
  8. */
  9. const officeList = require('../const/cld_office').list;
  10. const settingConst = require('../const/setting.js');
  11. const settingMenu = require('../../config/menu').settingMenu;
  12. const accountGroup = require('../const/account_group').group;
  13. const permission = require('../const/account_permission').permission;
  14. const projectLog = require('../const/project_log');
  15. const imType = require('../const/tender').imType;
  16. const S2b = require('../lib/s2b');
  17. const measureType = require('../const/tender').measureType;
  18. const sendToWormhole = require('stream-wormhole');
  19. const path = require('path');
  20. module.exports = app => {
  21. class SettingController extends app.BaseController {
  22. /**
  23. * 构造函数
  24. *
  25. * @param {Object} ctx - egg全局context
  26. * @return {void}
  27. */
  28. constructor(ctx) {
  29. super(ctx);
  30. ctx.subMenu = settingMenu;
  31. }
  32. async _checkMenu(pid) {
  33. const ctx = this.ctx;
  34. await this.ctx.service.s2bProj.refreshSessionS2b(pid);
  35. ctx.subMenu.s2b.display = !!ctx.session.sessionProject.gxby || !!ctx.session.sessionProject.dagl;
  36. // this.ctx.subMenu.s2b.display = false;
  37. }
  38. /**
  39. * 项目信息页面(Get)
  40. *
  41. * @param {Object} ctx - egg全局变量
  42. * @return {void}
  43. */
  44. async info(ctx) {
  45. try {
  46. // 获取项目数据
  47. const projectId = ctx.session.sessionProject.id;
  48. await this._checkMenu(projectId);
  49. const projectData = await ctx.service.project.getDataById(projectId);
  50. if (projectData === null) {
  51. throw '没有对应的项目数据';
  52. }
  53. // 获取销售人员数据
  54. const salesmanData = await ctx.service.manager.getDataById(projectData.manager_id);
  55. // 数据规则
  56. const rule = ctx.service.project.rule('saveInfo');
  57. const jsValidator = await this.jsValidator.convert(rule).build();
  58. const officeName = officeList[salesmanData.office];
  59. const date = new Date(projectData.create_time * 1000);// 如果date为10位不需要乘1000
  60. const Y = date.getFullYear() + '-';
  61. const M = (date.getMonth() + 1 < 10 ? '0' + (date.getMonth() + 1) : date.getMonth() + 1) + '-';
  62. const D = (date.getDate() < 10 ? '0' + (date.getDate()) : date.getDate()) + ' ';
  63. const h = (date.getHours() < 10 ? '0' + date.getHours() : date.getHours()) + ':';
  64. const m = (date.getMinutes() < 10 ? '0' + date.getMinutes() : date.getMinutes()) + ':';
  65. const s = (date.getSeconds() < 10 ? '0' + date.getSeconds() : date.getSeconds());
  66. const dateStr = Y + M + D + h + m + s;
  67. const renderData = {
  68. projectData,
  69. salesmanData,
  70. officeName,
  71. officeList,
  72. jsValidator,
  73. dateStr,
  74. };
  75. await this.layout('setting/info.ejs', renderData);
  76. } catch (error) {
  77. console.log(error);
  78. ctx.redirect('/dashboard');
  79. }
  80. }
  81. /**
  82. * 项目设置 -- 账号设置(Get)
  83. * @param ctx
  84. * @return {Promise<void>}
  85. */
  86. async user(ctx) {
  87. try {
  88. // 获取项目数据
  89. const projectId = ctx.session.sessionProject.id;
  90. await this._checkMenu(projectId);
  91. const projectData = await ctx.service.project.getDataById(projectId);
  92. if (projectData === null) {
  93. throw '没有对应的项目数据';
  94. }
  95. if (ctx.session.sessionUser.is_admin === 0) {
  96. throw '没有访问权限';
  97. }
  98. let keyword = '';
  99. if (ctx.query.keyword) {
  100. keyword = ctx.query.keyword;
  101. }
  102. let company = '';
  103. if (ctx.query.company) {
  104. company = ctx.query.company;
  105. }
  106. const page = ctx.page;
  107. const pageSize = ctx.pageSize;
  108. // 过滤数据
  109. ctx.service.projectAccount.searchFilter(ctx.request.query, projectId);
  110. ctx.sort = ['id', 'desc'];
  111. const total = await ctx.service.projectAccount.getCountWithBuilder();
  112. // 获取数据规则
  113. // const rule = ctx.service.projectAccount.rule('updateUser');
  114. // const frontRule = ctx.helper.validateConvert(rule);
  115. // const total = await ctx.service.projectAccount.count({ project_id: projectId });
  116. // 获取项目用户列表
  117. // const accountData = await ctx.service.projectAccount.getAllDataByCondition({
  118. // where: { project_id: projectId },
  119. // columns: ['id', 'account', 'name', 'company', 'role', 'mobile', 'auth_mobile', 'telephone', 'enable', 'is_admin', 'account_group'],
  120. // limit: (app.config.pageSize * (page - 1)),
  121. // offset: app.config.pageSize,
  122. // });
  123. // const columns = ['id', 'account', 'name', 'company', 'role', 'mobile', 'auth_mobile', 'telephone', 'enable', 'is_admin', 'account_group', 'bind'];
  124. // const accountData = await ctx.service.projectAccount.getListByProjectId(columns, projectId);
  125. const accountData = await ctx.service.projectAccount.getListWithBuilder();
  126. // 获取账号个数
  127. const user_total = await ctx.service.projectAccount.count({ project_id: projectId });
  128. // 分页相关
  129. const pageInfo = {
  130. page,
  131. pageSizeSelect: 1,
  132. pageSize,
  133. total_num: total,
  134. total: Math.ceil(total / pageSize),
  135. queryData: JSON.stringify(ctx.urlInfo.query),
  136. };
  137. const unitList = await ctx.service.constructionUnit.getAllDataByCondition({ where: { pid: projectId } });
  138. const renderData = {
  139. projectData,
  140. accountData,
  141. accountGroup,
  142. permission,
  143. pageInfo,
  144. keyword,
  145. user_total,
  146. unitList,
  147. company,
  148. // rule: JSON.stringify(frontRule),
  149. };
  150. await this.layout('setting/user.ejs', renderData, 'setting/user_modal.ejs');
  151. } catch (error) {
  152. console.log(error);
  153. ctx.redirect('/dashboard');
  154. }
  155. }
  156. /**
  157. * 项目设置 -- 账号解绑设置(Post)
  158. * @param ctx
  159. * @return {Promise<void>}
  160. */
  161. async userUnbind(ctx) {
  162. const projectData = ctx.session.sessionProject;
  163. try {
  164. if (projectData.id === undefined) {
  165. throw '不存在对应的项目数据';
  166. }
  167. if (ctx.session.sessionUser.is_admin === 0) {
  168. throw '非管理员无权解绑账号';
  169. }
  170. const accountId = parseInt(ctx.request.body.id);
  171. const result = await ctx.service.projectAccount.update({ bind: 0 }, { id: accountId });
  172. if (!result) {
  173. throw '解绑失败';
  174. }
  175. this.setMessage('解绑成功', this.messageType.SUCCESS);
  176. } catch (error) {
  177. console.log(error);
  178. this.setMessage(error.toString(), this.messageType.ERROR);
  179. }
  180. ctx.redirect(ctx.request.header.referer);
  181. }
  182. /**
  183. * 项目权限 -- 账号设置(Get)
  184. * @param ctx
  185. * @return {Promise<void>}
  186. */
  187. async userPermissionSet(ctx) {
  188. try {
  189. // 获取项目数据
  190. const projectId = ctx.session.sessionProject.id;
  191. const projectData = await ctx.service.project.getDataById(projectId);
  192. if (projectData === null) {
  193. throw '没有对应的项目数据';
  194. }
  195. if (ctx.session.sessionUser.is_admin === 0) {
  196. throw '没有访问权限';
  197. }
  198. let keyword = '';
  199. if (ctx.query.keyword) {
  200. keyword = ctx.query.keyword;
  201. }
  202. let company = '';
  203. if (ctx.query.company) {
  204. company = ctx.query.company;
  205. }
  206. // 获取数据规则
  207. const page = ctx.page;
  208. const pageSize = ctx.pageSize;
  209. const columns = ['id', 'account', 'name', 'company', 'role', 'mobile', 'auth_mobile', 'telephone', 'enable', 'is_admin', 'bind', 'account_group', 'permission', 'cooperation'];
  210. // 过滤数据
  211. ctx.service.projectAccount.searchFilter(ctx.request.query, projectId, columns);
  212. ctx.sort = ['id', 'desc'];
  213. const total = await ctx.service.projectAccount.getCountWithBuilder();
  214. const accountData = await ctx.service.projectAccount.getListWithBuilder();
  215. // 获取账号个数
  216. const user_total = await ctx.service.projectAccount.count({ project_id: projectId });
  217. // 分页相关
  218. const pageInfo = {
  219. page,
  220. pageSizeSelect: 1,
  221. pageSize,
  222. total_num: total,
  223. total: Math.ceil(total / pageSize),
  224. queryData: JSON.stringify(ctx.urlInfo.query),
  225. };
  226. const unitList = await ctx.service.constructionUnit.getAllDataByCondition({ where: { pid: projectId } });
  227. const renderData = {
  228. projectData,
  229. accountData,
  230. accountGroup,
  231. permission,
  232. keyword,
  233. permissionStr: JSON.stringify(permission),
  234. pageInfo,
  235. user_total,
  236. unitList,
  237. company,
  238. // rule: JSON.stringify(frontRule),
  239. };
  240. await this.layout('setting/user_permission.ejs', renderData, 'setting/user_permission_modal.ejs');
  241. } catch (error) {
  242. console.log(error);
  243. ctx.redirect('/dashboard');
  244. }
  245. }
  246. /**
  247. * 项目权限 -- 参建单位(Get)
  248. * @param ctx
  249. * @return {Promise<void>}
  250. */
  251. async userUnit(ctx) {
  252. try {
  253. // 获取项目数据
  254. const projectId = ctx.session.sessionProject.id;
  255. const projectData = await ctx.service.project.getDataById(projectId);
  256. if (projectData === null) {
  257. throw '没有对应的项目数据';
  258. }
  259. if (ctx.session.sessionUser.is_admin === 0) {
  260. throw '没有访问权限';
  261. }
  262. const unitList = await ctx.service.constructionUnit.getAllDataByCondition({ where: { pid: projectId } });
  263. for (const u of unitList) {
  264. const accountList = await ctx.service.projectAccount.getAllDataByCondition({ where: { project_id: projectId, company: u.name } });
  265. u.account_num = accountList.length;
  266. }
  267. // 获取账号个数
  268. const user_total = await ctx.service.projectAccount.count({ project_id: projectId });
  269. const renderData = {
  270. projectData,
  271. accountGroup,
  272. unitList,
  273. user_total,
  274. fujianOssPath: ctx.app.config.fujianOssPath,
  275. };
  276. await this.layout('setting/user_unit.ejs', renderData, 'setting/user_unit_modal.ejs');
  277. } catch (error) {
  278. console.log(error);
  279. ctx.redirect('/dashboard');
  280. }
  281. }
  282. /**
  283. * 项目设置 -- 单位新增设置(Post)
  284. * @param ctx
  285. * @return {Promise<void>}
  286. */
  287. async userUnitAdd(ctx) {
  288. const projectData = ctx.session.sessionProject;
  289. try {
  290. // 验证数据
  291. if (projectData.id === undefined) {
  292. throw '不存在对应的项目数据';
  293. }
  294. // 获取验证规则
  295. const rule = ctx.service.constructionUnit.rule('add');
  296. ctx.validate(rule);
  297. ctx.request.body.pid = projectData.id;
  298. const result = await ctx.service.constructionUnit.save(ctx.request.body);
  299. if (!result) {
  300. throw '保存单位失败';
  301. }
  302. this.setMessage('保存单位成功', this.messageType.SUCCESS);
  303. ctx.redirect('/' + ctx.controllerName + '/user/unit');
  304. } catch (error) {
  305. console.log(error);
  306. this.setMessage(error.toString(), this.messageType.ERROR);
  307. ctx.redirect(ctx.request.header.referer);
  308. }
  309. }
  310. /**
  311. * 项目设置 -- 单位编辑(Post)
  312. * @param ctx
  313. * @return {Promise<void>}
  314. */
  315. async userUnitSave(ctx) {
  316. const projectData = ctx.session.sessionProject;
  317. const responseData = {
  318. err: 0, msg: '', data: null,
  319. };
  320. try {
  321. // 验证数据
  322. if (projectData.id === undefined) {
  323. throw '不存在对应的项目数据';
  324. }
  325. const data = JSON.parse(ctx.request.body.data);
  326. switch (data.type) {
  327. case 'update':
  328. const post_data = {
  329. pid: projectData.id,
  330. id: data.id,
  331. };
  332. post_data[data.val_name] = data.val;
  333. if (data.name) post_data.name = data.name;
  334. const result = await ctx.service.constructionUnit.save(post_data);
  335. if (!result) {
  336. throw '保存单位失败';
  337. }
  338. if (post_data.name) {
  339. const accountList = await ctx.service.projectAccount.getAllDataByCondition({ where: { project_id: projectData.id, company: post_data.name } });
  340. responseData.data = { account_num: accountList.length };
  341. }
  342. break;
  343. case 'delete':
  344. const accountList = await ctx.service.projectAccount.getAllDataByCondition({ where: { project_id: projectData.id, company: data.name } });
  345. if (accountList.length > 0) {
  346. throw '该单位下还存在账号,无法删除';
  347. }
  348. await ctx.service.constructionUnit.del(data.id);
  349. break;
  350. case 'del-sign':
  351. const info = await ctx.service.constructionUnit.getDataById(data.id);
  352. if (info.sign_path) {
  353. await ctx.app.fujianOss.delete(ctx.app.config.fujianOssFolder + info.sign_path);
  354. }
  355. await ctx.service.constructionUnit.update({ sign_path: null }, { id: info.id });
  356. break;
  357. default:
  358. break;
  359. }
  360. ctx.body = responseData;
  361. } catch (err) {
  362. this.log(err);
  363. ctx.body = { err: 1, msg: err.toString(), data: null };
  364. }
  365. }
  366. async userUnitUpload(ctx) {
  367. const responseData = {
  368. err: 0, msg: '', data: null,
  369. };
  370. try {
  371. const stream = await ctx.getFileStream();
  372. const create_time = Date.parse(new Date()) / 1000;
  373. const fileInfo = path.parse(stream.filename);
  374. const filepath = `app/public/upload/sign/unit/qianzhang_${create_time + fileInfo.ext}`;
  375. await ctx.app.fujianOss.put(ctx.app.config.fujianOssFolder + filepath, stream);
  376. await sendToWormhole(stream);
  377. const result = await ctx.service.constructionUnit.update({ sign_path: filepath }, { id: stream.fields.id });
  378. if (result) {
  379. responseData.data = { sign_path: filepath };
  380. } else {
  381. throw '添加数据库失败';
  382. }
  383. } catch (err) {
  384. this.log(err);
  385. responseData.err = 1;
  386. responseData.msg = err;
  387. }
  388. ctx.body = responseData;
  389. }
  390. /**
  391. * 项目设置 -- 账号启用和停用设置(Post)
  392. * @param ctx
  393. * @return {Promise<void>}
  394. */
  395. async userSwitch(ctx) {
  396. const responseData = {
  397. err: 0, msg: '', data: null,
  398. };
  399. try {
  400. // 获取项目数据
  401. const projectId = ctx.session.sessionProject.id;
  402. const projectData = await ctx.service.project.getDataById(projectId);
  403. if (projectData === null) {
  404. throw '没有对应的项目数据';
  405. }
  406. if (ctx.session.sessionUser.is_admin === 0) {
  407. throw '没有访问权限';
  408. }
  409. const data = JSON.parse(ctx.request.body.data);
  410. const result = await ctx.service.projectAccount.update(data, { id: data.id });
  411. if (!result) {
  412. throw '提交数据失败';
  413. }
  414. } catch (err) {
  415. this.log(err);
  416. responseData.err = 1;
  417. responseData.msg = err;
  418. }
  419. ctx.body = responseData;
  420. }
  421. /**
  422. * 项目设置 -- 账号添加(Post)
  423. * @param ctx
  424. * @return {Promise<void>}
  425. */
  426. async addUser(ctx) {
  427. const projectData = ctx.session.sessionProject;
  428. try {
  429. // 验证数据
  430. if (projectData.id === undefined) {
  431. throw '不存在对应的项目数据';
  432. }
  433. // 获取验证规则
  434. const rule = ctx.service.projectAccount.rule('add');
  435. ctx.validate(rule);
  436. ctx.request.body.project_id = projectData.id;
  437. const result = await ctx.service.projectAccount.save(ctx.request.body);
  438. if (!result) {
  439. throw '保存账号数据失败';
  440. }
  441. this.setMessage('保存账号数据成功', this.messageType.SUCCESS);
  442. ctx.redirect('/' + ctx.controllerName + '/user');
  443. } catch (error) {
  444. console.log(error);
  445. this.setMessage(error.toString(), this.messageType.ERROR);
  446. ctx.redirect(ctx.request.header.referer);
  447. }
  448. }
  449. /**
  450. * 项目设置 -- 账号编辑(Post)
  451. * @param ctx
  452. * @return {Promise<void>}
  453. */
  454. async updateUser(ctx) {
  455. const projectData = ctx.session.sessionProject;
  456. try {
  457. // 验证数据
  458. if (projectData.id === undefined) {
  459. throw '不存在对应的项目数据';
  460. }
  461. // 获取验证规则
  462. const rule = ctx.service.projectAccount.rule('modify');
  463. ctx.validate(rule);
  464. const result = await ctx.service.projectAccount.save(ctx.request.body);
  465. if (!result) {
  466. throw '保存账号数据失败';
  467. }
  468. this.setMessage('保存账号数据成功', this.messageType.SUCCESS);
  469. ctx.redirect(ctx.request.header.referer);
  470. } catch (error) {
  471. console.log(error);
  472. this.setMessage(error.toString(), this.messageType.ERROR);
  473. ctx.redirect(ctx.request.header.referer);
  474. }
  475. }
  476. async resetUserPassword(ctx) {
  477. try {
  478. // 获取项目数据
  479. const projectId = ctx.session.sessionProject.id;
  480. const projectData = await ctx.service.project.getDataById(projectId);
  481. if (projectData === null) {
  482. throw '没有对应的项目数据';
  483. }
  484. if (ctx.session.sessionUser.is_admin === 0) {
  485. throw '没有访问权限';
  486. }
  487. const accountId = parseInt(ctx.request.body.id);
  488. let password = ctx.request.body.reset_password;
  489. password = password.toString();
  490. const account = ctx.request.body.account !== undefined ? ctx.request.body.account : '';
  491. if (isNaN(accountId) || accountId <= 0 || password.length < 6) {
  492. throw '参数错误';
  493. }
  494. // 判断新密码的强度
  495. const reg = /^(?![0-9]+$)(?![a-zA-Z]+$).{6,16}$/;
  496. if (!reg.test(password)) {
  497. throw '请设置至少包含数字和字母的新密码';
  498. }
  499. const result = await ctx.service.projectAccount.resetPassword(accountId, password, account);
  500. if (!result) {
  501. throw '重置密码失败!';
  502. }
  503. this.setMessage('保存账号数据成功', this.messageType.SUCCESS);
  504. ctx.redirect(ctx.request.header.referer);
  505. } catch (error) {
  506. console.log(error);
  507. this.setMessage(error.toString(), this.messageType.ERROR);
  508. ctx.redirect(ctx.request.header.referer);
  509. }
  510. }
  511. /**
  512. * 项目设置 -- 账号权限编辑(Post)
  513. * @param ctx
  514. * @return {Promise<void>}
  515. */
  516. async permission(ctx) {
  517. const projectData = ctx.session.sessionProject;
  518. try {
  519. // 验证数据
  520. if (projectData.id === undefined) {
  521. throw '不存在对应的项目数据';
  522. }
  523. const accountId = parseInt(ctx.request.body.id);
  524. const accountInfo = await ctx.service.projectAccount.getDataById(accountId);
  525. if (accountInfo === null) {
  526. throw '不存在该客户';
  527. }
  528. const result = await ctx.service.projectAccount.permissionSave(accountId, ctx.request.body);
  529. if (!result) {
  530. throw '修改权限失败!';
  531. }
  532. this.setMessage('保存账号数据成功', this.messageType.SUCCESS);
  533. ctx.redirect(ctx.request.header.referer);
  534. } catch (error) {
  535. console.log(error);
  536. this.setMessage(error.toString(), this.messageType.ERROR);
  537. ctx.redirect(ctx.request.header.referer);
  538. }
  539. }
  540. /**
  541. * 项目设置 -- 自定义标段分类(Get)
  542. *
  543. * @param ctx
  544. * @return {Promise<void>}
  545. */
  546. async category(ctx) {
  547. try {
  548. // 获取项目数据
  549. const projectId = ctx.session.sessionProject.id;
  550. await this._checkMenu(projectId);
  551. const projectData = await ctx.service.project.getDataById(projectId);
  552. if (projectData === null) {
  553. throw '没有对应的项目数据';
  554. }
  555. if (ctx.session.sessionUser.is_admin === 0) {
  556. throw '没有访问权限';
  557. }
  558. const categoryData = await ctx.service.category.getAllCategory(projectId);
  559. const tenderData = await ctx.service.tender.getList('', null, 1);
  560. const renderData = {
  561. projectData,
  562. categoryType: settingConst.cType,
  563. categoryData,
  564. tenderData,
  565. };
  566. await this.layout('setting/category.ejs', renderData, 'setting/category_modal.ejs');
  567. } catch (error) {
  568. console.log(error);
  569. ctx.redirect('/dashboard');
  570. }
  571. }
  572. /**
  573. * 新增分类(Ajax)
  574. *
  575. * @param ctx
  576. * @return {Promise<void>}
  577. */
  578. async addCategory(ctx) {
  579. try {
  580. const projectId = ctx.session.sessionProject.id;
  581. const responseData = {
  582. err: 0, msg: '', data: null,
  583. };
  584. const data = JSON.parse(ctx.request.body.data);
  585. if (!data.name) {
  586. throw '提交数据错误';
  587. }
  588. responseData.data = await ctx.service.category.addCategory(projectId, data.name, settingConst.cType.key.dropDown);
  589. ctx.body = responseData;
  590. } catch (err) {
  591. this.log(err);
  592. ctx.body = { err: 1, msg: err.toString(), data: null };
  593. }
  594. }
  595. /**
  596. * 编辑分类(Ajax)
  597. *
  598. * @param ctx
  599. * @return {Promise<void>}
  600. */
  601. async updateCategory(ctx) {
  602. try {
  603. const projectId = ctx.session.sessionProject.id;
  604. const responseData = { err: 0, msg: '', data: null };
  605. const data = JSON.parse(ctx.request.body.data);
  606. if (!data.id) {
  607. throw '提交数据错误';
  608. }
  609. if (data.name) {
  610. const count = await ctx.service.category.count({ pid: projectId, name: data.name });
  611. if (count >= 1) {
  612. throw '存在同名类别';
  613. }
  614. }
  615. const result = await ctx.service.category.update(data, { id: data.id });
  616. if (!result) {
  617. throw '提交数据失败';
  618. }
  619. responseData.data = await ctx.service.category.getCategory(data.id);
  620. ctx.body = responseData;
  621. } catch (err) {
  622. this.log(err);
  623. ctx.body = { err: 1, msg: err.toString(), data: null };
  624. }
  625. }
  626. async setCategoryValue(ctx) {
  627. try {
  628. const responseData = { err: 0, msg: '', data: {} };
  629. const data = JSON.parse(ctx.request.body.data);
  630. if (!data.id) {
  631. throw '提交数据错误';
  632. }
  633. await ctx.service.categoryValue.setCategoryValue(data.id, data.updateValue);
  634. responseData.data.category = await ctx.service.category.getCategory(data.id);
  635. responseData.data.tenders = await ctx.service.tender.getList('', null, 1);
  636. ctx.body = responseData;
  637. } catch (err) {
  638. this.log(err);
  639. ctx.body = { err: 1, msg: err instanceof String ? err : '提交数据失败', data: null };
  640. }
  641. }
  642. /**
  643. * 删除分类(Ajax)
  644. *
  645. * @param ctx
  646. * @return {Promise<void>}
  647. */
  648. async deleteCategory(ctx) {
  649. try {
  650. const projectId = ctx.session.sessionProject.id;
  651. const responseData = {
  652. err: 0, msg: '', data: null,
  653. };
  654. const data = JSON.parse(ctx.request.body.data);
  655. if (!data.id) {
  656. throw '提交数据错误';
  657. }
  658. await ctx.service.category.deleteCategory(projectId, data.id);
  659. ctx.body = responseData;
  660. } catch (err) {
  661. this.log(err);
  662. ctx.body = { err: 1, msg: err.toString(), data: null };
  663. }
  664. }
  665. /**
  666. * 调整分类层次排序(Ajax)
  667. *
  668. * @param ctx
  669. * @return {Promise<void>}
  670. */
  671. async resetCategoryLevel(ctx) {
  672. try {
  673. const projectId = ctx.session.sessionProject.id;
  674. const responseData = {
  675. err: 0, msg: '', data: null,
  676. };
  677. const data = JSON.parse(ctx.request.body.data);
  678. await ctx.service.category.resetCategoryLevel(data);
  679. responseData.data = await ctx.service.category.getAllCategory(projectId);
  680. ctx.body = responseData;
  681. } catch (err) {
  682. this.log(err);
  683. ctx.body = { err: 1, msg: err.toString(), data: null };
  684. }
  685. }
  686. /** update porject info
  687. * @author wangfeng
  688. * @date 2018-10-12 15:48:05
  689. * @param ctx
  690. * @return {Promise<void>}
  691. */
  692. async updateinfo(ctx) {
  693. try {
  694. const projectId = ctx.params.id;
  695. const responseData = {
  696. err: 0, msg: '', data: null,
  697. };
  698. const conditionData = {
  699. id: projectId,
  700. };
  701. const data = ctx.request.body;
  702. const result = await ctx.service.project.update(data, conditionData);
  703. if (!result) {
  704. throw '提交数据失败';
  705. }
  706. ctx.redirect('/setting/info');
  707. } catch (err) {
  708. this.log(err);
  709. ctx.body = { err: 1, msg: err.toString(), data: null };
  710. }
  711. }
  712. /**
  713. * 检测账户是否存在
  714. *
  715. * @param {Object} ctx -egg全局变量
  716. * @return {void}
  717. */
  718. async accountExist(ctx) {
  719. const projectData = ctx.session.sessionProject;
  720. const responseData = {
  721. err: 0, msg: '', data: null,
  722. };
  723. try {
  724. const data = JSON.parse(ctx.request.body.data);
  725. const account = data.account;
  726. if (projectData.id === undefined) {
  727. throw '不存在对应项目';
  728. }
  729. responseData.data = await ctx.service.projectAccount.isAccountExist(account, projectData.id);
  730. ctx.body = responseData;
  731. } catch (error) {
  732. ctx.body = { err: 1, msg: error.toString(), data: null };
  733. }
  734. }
  735. /**
  736. * 显示设置(Get)
  737. * @param {Object} ctx -egg全局变量
  738. * @return {void}
  739. */
  740. async show(ctx) {
  741. try {
  742. // 获取项目数据
  743. const projectId = ctx.session.sessionProject.id;
  744. await this._checkMenu(projectId);
  745. const projectData = await ctx.service.project.getDataById(projectId);
  746. if (!projectData) {
  747. throw '没有对应的项目数据';
  748. }
  749. if (ctx.session.sessionUser.is_admin === 0) {
  750. throw '没有访问权限';
  751. }
  752. const showList = await ctx.service.settingShow.getList(projectData.page_path);
  753. const sjsRela = await ctx.service.project.getSjsRela(projectId);
  754. const renderData = { projectData, showList, sjsRela };
  755. await this.layout('setting/show.ejs', renderData);
  756. } catch (error) {
  757. this.log(error);
  758. ctx.redirect('/dashboard');
  759. }
  760. }
  761. /**
  762. * 更新显示设置列表
  763. * @param {Object} ctx -egg全局变量
  764. * @return {void}
  765. */
  766. async showListUpdate(ctx) {
  767. try {
  768. // 获取项目id
  769. const projectId = ctx.session.sessionProject.id;
  770. const { data } = ctx.request.body;
  771. const { id } = JSON.parse(data);
  772. const result = await ctx.service.settingShow.setDefaultLabel(id, projectId);
  773. const responseData = { err: 0, msg: '', data: result };
  774. ctx.body = responseData;
  775. } catch (error) {
  776. this.log(error);
  777. ctx.body = { err: 1, msg: error.toString(), data: null };
  778. }
  779. }
  780. async showSjsUpdate(ctx) {
  781. try {
  782. const projectId = ctx.session.sessionProject.id;
  783. const data = JSON.parse(ctx.request.body.data);
  784. const result = await ctx.service.project.updateSjsRela(projectId, data.sub, data.field, data.key, data.value);
  785. ctx.body = { err: 0, msg: '', data: result };
  786. } catch (err) {
  787. this.log(err);
  788. this.ajaxErrorBody(error, '保存数据失败');
  789. }
  790. }
  791. async logs(ctx) {
  792. try {
  793. // 获取项目数据
  794. const projectId = ctx.session.sessionProject.id;
  795. await this._checkMenu(projectId);
  796. const projectData = await ctx.service.project.getDataById(projectId);
  797. if (projectData === null) {
  798. throw '没有对应的项目数据';
  799. }
  800. if (ctx.session.sessionUser.is_admin === 0) {
  801. throw '没有访问权限';
  802. }
  803. const settingType = ctx.params.type ? parseInt(ctx.params.type) : 0;
  804. const logs = await ctx.service.projectLog.getLogs(projectId, settingType);
  805. const renderData = {
  806. projectData,
  807. officeList,
  808. projectLog,
  809. settingType,
  810. logs,
  811. };
  812. await this.layout('setting/logs.ejs', renderData);
  813. } catch (error) {
  814. console.log(error);
  815. ctx.redirect('/dashboard');
  816. }
  817. }
  818. async fun(ctx) {
  819. try {
  820. const projectId = ctx.session.sessionProject.id;
  821. await this._checkMenu(projectId);
  822. const projectData = await ctx.service.project.getDataById(projectId);
  823. const funRela = await ctx.service.project.getFunRela(projectId);
  824. if (projectData === null) {
  825. throw '没有对应的项目数据';
  826. }
  827. if (ctx.session.sessionUser.is_admin === 0) {
  828. throw '没有访问权限';
  829. }
  830. await this.layout('setting/fun.ejs', {
  831. projectData,
  832. funRela,
  833. imType,
  834. })
  835. } catch (error) {
  836. ctx.helper.log(error);
  837. ctx.redirect('/dashboard');
  838. }
  839. }
  840. /**
  841. * 保存功能设置相关
  842. * @param ctx
  843. * @returns {Promise<void>}
  844. */
  845. async updateFun(ctx) {
  846. try {
  847. const projectId = ctx.session.sessionProject.id;
  848. const projectData = await ctx.service.project.getDataById(projectId);
  849. if (projectData === null) {
  850. throw '没有对应的项目数据';
  851. }
  852. if (ctx.session.sessionUser.is_admin === 0) {
  853. throw '没有访问权限';
  854. }
  855. const data = JSON.parse(ctx.request.body.data);
  856. if (data) ctx.request.body = data;
  857. const rule = ctx.service.project.rule('fun');
  858. ctx.validate(rule);
  859. const result = await ctx.service.project.updateFunRela(projectId, ctx.request.body);
  860. if (!result) throw '保存数据失败';
  861. this.ctx.session.sessionProject.page_show.openChangeProject = data.openChangeProject ? 1 : 0;
  862. this.ctx.session.sessionProject.page_show.openChangeApply = data.openChangeApply ? 1 : 0;
  863. this.ctx.session.sessionProject.page_show.openChangePlan = data.openChangePlan ? 1 : 0;
  864. this.ctx.session.sessionProject.page_show.openMaterialTax = data.openMaterialTax ? 1 : 0;
  865. this.ctx.session.sessionProject.page_show.openMaterialChecklist = data.openMaterialChecklist ? 1 : 0;
  866. const result2 = await ctx.service.project.updatePageshow(projectId);
  867. if (!result2) throw '保存数据失败';
  868. ctx.body = { err: 0, msg: '', data: null };
  869. } catch (error) {
  870. ctx.helper.log(error);
  871. this.ajaxErrorBody(error, '保存数据失败');
  872. }
  873. }
  874. async s2b (ctx) {
  875. try {
  876. const projectId = ctx.session.sessionProject.id;
  877. await this._checkMenu(projectId);
  878. const projectData = await ctx.service.project.getDataById(projectId);
  879. if (projectData === null) throw '没有对应的项目数据';
  880. if (ctx.session.sessionUser.is_admin === 0) throw '没有访问权限';
  881. const tenders = await ctx.service.tender.getAllDataByCondition({ where: { project_id: projectId } });
  882. for (const t of tenders) {
  883. t.measure_type_str = t.measure_type === measureType.tz.value ? measureType.tz.title : measureType.gcl.title;
  884. const stages = await ctx.service.stage.getAllDataByCondition({ where: { tid: t.id } });
  885. t.stage_count_str = `第${stages.length || 0}期`;
  886. const user = await ctx.service.projectAccount.getAccountInfoById(t.user_id);
  887. t.user_str = user.name + '-' + user.company;
  888. t.show_time = stages.length > 0 ? stages[stages.length - 1].cache_time_r || stages[stages.length - 1].in_time : t.create_time;
  889. }
  890. await this.layout('setting/s2b.ejs', {
  891. projectData,
  892. tenders,
  893. })
  894. } catch (error) {
  895. ctx.helper.log(error);
  896. ctx.redirect('/dashboard');
  897. }
  898. }
  899. async s2bUpdate(ctx) {
  900. try {
  901. const projectId = ctx.session.sessionProject.id;
  902. const projectData = await ctx.service.project.getDataById(projectId);
  903. if (projectData === null) throw '没有对应的项目数据';
  904. if (ctx.session.sessionUser.is_admin === 0) throw '没有访问权限';
  905. const data = JSON.parse(ctx.request.body.data);
  906. if (!data.tid) throw '提交数据错误';
  907. const updateData = {};
  908. if (data.gxby_limit !== undefined) updateData.s2b_gxby_limit = data.gxby_limit;
  909. if (data.gxby_check !== undefined) updateData.s2b_gxby_check = data.gxby_check;
  910. if (data.dagl_limit !== undefined) updateData.s2b_dagl_limit = data.dagl_limit;
  911. if (data.dagl_check !== undefined) updateData.s2b_dagl_check = data.dagl_check;
  912. await ctx.service.tender.saveApiRela(data.tid, updateData);
  913. ctx.body = { err: 0, msg: '', data: null };
  914. } catch (error) {
  915. ctx.helper.log(error);
  916. this.ajaxErrorBody(error, '保存数据失败');
  917. }
  918. }
  919. async s2bUpdateStatus(ctx) {
  920. try {
  921. const projectId = ctx.session.sessionProject.id;
  922. const projectData = await ctx.service.project.getDataById(projectId);
  923. if (projectData === null) throw '没有对应的项目数据';
  924. if (ctx.session.sessionUser.is_admin === 0) throw '没有访问权限';
  925. const data = JSON.parse(ctx.request.body.data);
  926. if (!data.type || data.status === undefined) throw '提交数据错误';
  927. const responseData = { err: 0, msg: '', data: null };
  928. switch (data.type) {
  929. case 'gxby':
  930. responseData.data = await this.ctx.service.s2bProj.updateGxbyStatus(projectId, data.status, data.limit, data.ratio);
  931. break;
  932. case 'dagl':
  933. responseData.data = await this.ctx.service.s2bProj.updateDaglStatus(projectId, data.status, data.limit, data.ratio);
  934. break;
  935. default: throw '提交数据错误';
  936. }
  937. ctx.body = responseData;
  938. } catch (error) {
  939. console.log(error);
  940. ctx.helper.log(error);
  941. this.ajaxErrorBody(error, '保存数据失败');
  942. }
  943. }
  944. async dataCollect(ctx) {
  945. try {
  946. const projectId = ctx.session.sessionProject.id;
  947. await this._checkMenu(projectId);
  948. const projectData = await ctx.service.project.getDataById(projectId);
  949. if (projectData === null) throw '没有对应的项目数据';
  950. projectData.data_collect_pages = projectData.data_collect_pages ? projectData.data_collect_pages.split(',') : [];
  951. if (ctx.session.sessionUser.is_admin === 0) throw '没有访问权限';
  952. const dataCollectAudits = await ctx.service.datacollectAudit.getList(projectId);
  953. // 获取所有项目参与者
  954. const accountList = await ctx.service.projectAccount.getAllDataByCondition({
  955. where: { project_id: ctx.session.sessionProject.id, enable: 1 },
  956. columns: ['id', 'name', 'company', 'role', 'enable', 'is_admin', 'account_group', 'mobile'],
  957. });
  958. const accountGroupList = accountGroup.map((item, idx) => {
  959. const groupList = accountList.filter(item => item.account_group === idx);
  960. return { groupName: item, groupList };
  961. });
  962. const categoryData = await ctx.service.category.getAllCategory(ctx.session.sessionProject.id);
  963. const tenders = await ctx.service.tender.getList('', null, 1);
  964. const dcTenders = await ctx.service.datacollectTender.getList(projectId);
  965. await this.layout('setting/datacollect.ejs', {
  966. projectData,
  967. dataCollectAudits,
  968. accountList,
  969. accountGroup: accountGroupList,
  970. categoryData,
  971. tenders,
  972. dcTenders,
  973. }, 'setting/datacollect_modal.ejs');
  974. } catch (error) {
  975. ctx.helper.log(error);
  976. ctx.redirect('/dashboard');
  977. }
  978. }
  979. async dataCollectSave(ctx) {
  980. try {
  981. if (ctx.session.sessionUser.is_admin === 0) throw '没有设置权限';
  982. const projectId = ctx.session.sessionProject.id;
  983. const responseData = {
  984. err: 0, msg: '', data: null,
  985. };
  986. const data = JSON.parse(ctx.request.body.data);
  987. if (!data.type) {
  988. throw '提交数据错误';
  989. }
  990. switch (data.type) {
  991. case 'show':
  992. responseData.data = await ctx.service.project.update({ data_collect: data.data_collect, data_collect_pages: data.data_collect_pages.join(',') }, { id: projectId });
  993. ctx.session.sessionProject.dataCollect = data.data_collect;
  994. ctx.session.sessionProject.showDataCollect = data.data_collect ? 1 : 0;
  995. break;
  996. case 'add-audit':
  997. // 判断该用户的组是否已加入到表中,已加入则提示无需添加
  998. const auditInfo = await ctx.service.datacollectAudit.getDataByCondition({ pid: projectId, uid: data.id });
  999. if (auditInfo) {
  1000. throw '该用户已存在权限中,无需重复添加';
  1001. }
  1002. const accountInfo = await ctx.service.projectAccount.getDataById(data.id);
  1003. const groupInfo = await ctx.service.datacollectAudit.getGroupInfo(projectId, accountInfo.account_group);
  1004. if (groupInfo) {
  1005. throw '该用户所在单位已存在权限中,无需单独添加';
  1006. }
  1007. await ctx.service.datacollectAudit.saveAudit(projectId, accountInfo.account_group, data.id);
  1008. responseData.data = await ctx.service.datacollectAudit.getList(projectId);
  1009. break;
  1010. case 'add-group':
  1011. const groupInfo2 = await ctx.service.datacollectAudit.getGroupInfo(projectId, data.id);
  1012. if (groupInfo2) {
  1013. throw '该单位已存在权限中,无需重复添加';
  1014. }
  1015. await ctx.service.datacollectAudit.saveGroup(projectId, data.id);
  1016. responseData.data = await ctx.service.datacollectAudit.getList(projectId);
  1017. break;
  1018. case 'del-audit':
  1019. const auditInfo2 = await ctx.service.datacollectAudit.getDataById(data.id);
  1020. if (!auditInfo2) {
  1021. throw '该用户已不存在权限中,移除失败';
  1022. }
  1023. await ctx.service.datacollectAudit.delAudit(data.id);
  1024. responseData.data = await ctx.service.datacollectAudit.getList(projectId);
  1025. break;
  1026. case 'del-group':
  1027. const groupInfo3 = await ctx.service.datacollectAudit.getDataById(data.id);
  1028. if (!groupInfo3) {
  1029. throw '该单位已不存在权限中,移除失败';
  1030. }
  1031. await ctx.service.datacollectAudit.delAudit(data.id);
  1032. responseData.data = await ctx.service.datacollectAudit.getList(projectId);
  1033. break;
  1034. case 'tender':
  1035. if (ctx.session.sessionProject.page_show.addDataCollect !== parseInt(data.add_datacollect)) {
  1036. ctx.session.sessionProject.page_show.addDataCollect = parseInt(data.add_datacollect);
  1037. await ctx.service.project.updatePageshow(projectId);
  1038. }
  1039. await ctx.service.datacollectTender.updateList(projectId, data.tids);
  1040. responseData.data = {
  1041. dcTenders: await ctx.service.datacollectTender.getList(projectId),
  1042. addDatacollect: ctx.session.sessionProject.page_show.addDataCollect,
  1043. };
  1044. break;
  1045. default: throw '参数有误';
  1046. }
  1047. ctx.body = responseData;
  1048. } catch (err) {
  1049. this.log(err);
  1050. ctx.body = { err: 1, msg: err.toString(), data: null };
  1051. }
  1052. }
  1053. }
  1054. return SettingController;
  1055. };