payment_controller.js 46 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875
  1. 'use strict';
  2. const accountGroup = require('../const/account_group').group;
  3. const JV = require('../reports/rpt_component/jpc_value_define');
  4. const shenpiConst = require('../const/shenpi');
  5. const auditConst = require('../const/audit').stage;
  6. const paymentConst = require('../const/payment');
  7. module.exports = app => {
  8. class PaymentController extends app.BaseController {
  9. /**
  10. * 构造函数
  11. *
  12. * @param {Object} ctx - egg全局变量
  13. * @return {void}
  14. */
  15. constructor(ctx) {
  16. super(ctx);
  17. ctx.showProject = true;
  18. // ctx.showTitle = true;
  19. }
  20. /**
  21. * 支付审批列表页
  22. *
  23. * @param {Object} ctx - egg全局页面
  24. * @return {void}
  25. */
  26. async index(ctx) {
  27. try {
  28. const auditPermission = await this.ctx.service.paymentPermissionAudit.getOnePermission(ctx.session.sessionUser.is_admin, ctx.session.sessionUser.accountId);
  29. if (!auditPermission) {
  30. throw '权限不足';
  31. }
  32. // 列表读取及目录读取
  33. const renderData = {
  34. auditPermission,
  35. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.payment.index),
  36. };
  37. if (ctx.session.sessionUser.is_admin) {
  38. const projectId = ctx.session.sessionProject.id;
  39. const permissionAudits = await ctx.service.paymentPermissionAudit.getList(projectId);
  40. // 获取所有项目参与者
  41. const accountList = await ctx.service.projectAccount.getAllDataByCondition({
  42. where: { project_id: ctx.session.sessionProject.id, enable: 1 },
  43. columns: ['id', 'name', 'company', 'role', 'enable', 'is_admin', 'account_group', 'mobile'],
  44. });
  45. const accountGroupList = accountGroup.map((item, idx) => {
  46. const groupList = accountList.filter(item => item.account_group === idx);
  47. return { groupName: item, groupList };
  48. });
  49. renderData.permissionAudits = permissionAudits;
  50. renderData.accountList = accountList;
  51. renderData.accountGroup = accountGroupList;
  52. }
  53. await this.layout('payment/index.ejs', renderData, 'payment/modal.ejs');
  54. } catch (err) {
  55. console.log(err);
  56. this.log(err);
  57. ctx.session.postError = err.toString();
  58. ctx.redirect(this.menu.menu.dashboard.url);
  59. }
  60. }
  61. async listLoad(ctx) {
  62. const responseData = {
  63. err: 0, msg: '', data: {},
  64. };
  65. const auditPermission = await this.ctx.service.paymentPermissionAudit.getOnePermission(ctx.session.sessionUser.is_admin, ctx.session.sessionUser.accountId);
  66. if (!auditPermission) {
  67. throw '权限不足';
  68. }
  69. // 先获取你创建的标段及参与的标段
  70. const tenderList = await ctx.service.paymentTender.getList(ctx.session.sessionUser.accountId, auditPermission);
  71. // 获取你创建的目录及对应目录下的所有目录
  72. const folderList = await ctx.service.paymentFolder.getList(ctx.session.sessionUser.accountId, tenderList, auditPermission);
  73. if (tenderList.length > 0) {
  74. for (const t of tenderList) {
  75. t.have_notice = await ctx.service.paymentDetail.haveNotice2Tender(t.id, ctx.session.sessionUser.accountId);
  76. t.have_detail = await ctx.service.paymentDetail.haveDetail2Tender(t.id);
  77. }
  78. }
  79. responseData.data.folderList = ctx.helper._.orderBy(folderList, ['in_time'], ['asc']);
  80. responseData.data.tenderList = ctx.helper._.orderBy(tenderList, ['in_time'], ['asc']);
  81. ctx.body = responseData;
  82. }
  83. async permissionSave(ctx) {
  84. try {
  85. if (ctx.session.sessionUser.is_admin === 0) throw '没有设置权限';
  86. const projectId = ctx.session.sessionProject.id;
  87. const responseData = {
  88. err: 0, msg: '', data: null,
  89. };
  90. const data = JSON.parse(ctx.request.body.data);
  91. if (!data.type) {
  92. throw '提交数据错误';
  93. }
  94. let uids;
  95. let result = false;
  96. let auditList = [];
  97. switch (data.type) {
  98. case 'add-audit':
  99. // 判断用户是单个还是数组
  100. uids = data.id instanceof Array ? data.id : [data.id];
  101. // 判断该用户的组是否已加入到表中,已加入则提示无需添加
  102. auditList = await ctx.service.paymentPermissionAudit.getAllDataByCondition({ where: { pid: projectId, uid: uids } });
  103. const addAidList = ctx.helper._.difference(uids, ctx.helper._.map(auditList, 'uid'));
  104. if (addAidList.length === 0) {
  105. throw '用户已存在权限中,无需重复添加';
  106. }
  107. const accountList = await ctx.service.projectAccount.getAllDataByCondition({ where: { id: addAidList } });
  108. await ctx.service.paymentPermissionAudit.saveAudits(projectId, accountList);
  109. responseData.data = await ctx.service.paymentPermissionAudit.getList(projectId);
  110. break;
  111. case 'del-audit':
  112. uids = data.id instanceof Array ? data.id : [data.id];
  113. auditList = await ctx.service.paymentPermissionAudit.getAllDataByCondition({ where: { id: uids } });
  114. if (auditList.length !== uids.length) {
  115. throw '该用户已不存在权限中,移除失败';
  116. }
  117. await ctx.service.paymentPermissionAudit.delAudit(uids);
  118. responseData.data = await ctx.service.paymentPermissionAudit.getList(projectId);
  119. break;
  120. case 'save-permission-one':
  121. result = await ctx.service.paymentPermissionAudit.updateOnePermission(data.updateData);
  122. if (!result) {
  123. throw '修改权限失败';
  124. }
  125. break;
  126. // case 'save-permission-all':
  127. // result = await ctx.service.paymentPermissionAudit.updateAllPermission(projectId, data.permission_type, data.value);
  128. // if (!result) {
  129. // throw '修改权限失败';
  130. // }
  131. // responseData.data = await ctx.service.paymentPermissionAudit.getList(projectId);
  132. // break;
  133. default: throw '参数有误';
  134. }
  135. ctx.body = responseData;
  136. } catch (err) {
  137. this.log(err);
  138. ctx.body = { err: 1, msg: err.toString(), data: null };
  139. }
  140. }
  141. async save(ctx) {
  142. try {
  143. const projectId = ctx.session.sessionProject.id;
  144. const auditPermission = await this.ctx.service.paymentPermissionAudit.getOnePermission(ctx.session.sessionUser.is_admin, ctx.session.sessionUser.accountId);
  145. if (!auditPermission) {
  146. throw '权限不足';
  147. }
  148. const responseData = {
  149. err: 0, msg: '', data: {},
  150. };
  151. const data = JSON.parse(ctx.request.body.data);
  152. if (!data.type) {
  153. throw '提交数据错误';
  154. }
  155. if (!auditPermission.admin) {
  156. throw '您没有权限操作此功能';
  157. }
  158. let type = '';
  159. switch (data.type) {
  160. case 'add-folder':
  161. await ctx.service.paymentFolder.addFolder(projectId, ctx.session.sessionUser.accountId, data.parentId, data.name);
  162. break;
  163. case 'add-tender':
  164. await ctx.service.paymentTender.addTender(projectId, ctx.session.sessionUser.accountId, data.folderId, data.name);
  165. break;
  166. case 'edit-name':
  167. type = data.postData.type;
  168. const updateData = {
  169. name: data.postData.name,
  170. };
  171. const conditionData = {
  172. id: data.postData.id,
  173. };
  174. if (type === 'tender') {
  175. const tenderInfo = await ctx.service.paymentTender.getDataById(conditionData.id);
  176. if (!tenderInfo) throw '标段不存在';
  177. if (tenderInfo.uid !== ctx.session.sessionUser.accountId && !ctx.session.sessionUser.is_admin) {
  178. throw '您没有权限重命名此标段';
  179. }
  180. await ctx.service.paymentTender.update(updateData, conditionData);
  181. } else {
  182. const folderInfo = await ctx.service.paymentFolder.getDataById(conditionData.id);
  183. if (!folderInfo) throw '目录不存在';
  184. if (folderInfo.uid !== ctx.session.sessionUser.accountId && !ctx.session.sessionUser.is_admin) {
  185. throw '您没有权限重命名此目录';
  186. }
  187. await ctx.service.paymentFolder.update(updateData, conditionData);
  188. }
  189. break;
  190. case 'del':
  191. type = data.postData.type;
  192. if (type === 'tender') {
  193. await ctx.service.paymentTender.deleteTender(data.postData.id);
  194. } else {
  195. await ctx.service.paymentFolder.deleteFolder(data.postData.id);
  196. }
  197. break;
  198. case 'mode-setting':
  199. if (!ctx.session.sessionUser.is_admin) {
  200. throw '您无权操作';
  201. }
  202. const projectInfo = await ctx.service.project.getDataById(ctx.session.sessionProject.id);
  203. const modes = projectInfo.payment_setting ? JSON.parse(projectInfo.payment_setting) : ctx.helper._.cloneDeep(paymentConst.setting_modes);
  204. const checked = data.checked;
  205. if (modes[data.mode_type]) {
  206. const detailCount = await ctx.service.paymentDetail.getCountByPidType(ctx.session.sessionProject.id, modes[data.mode_type].value);
  207. if (detailCount > 0 && !checked) {
  208. throw '已存在对应模块的详情,无法关闭该模块';
  209. }
  210. const mode = modes[data.mode_type];
  211. if (mode.checked === checked) {
  212. throw '已选中该模块,无须重复选中';
  213. }
  214. mode.checked = checked;
  215. } else if (paymentConst.setting_modes[data.mode_type]) {
  216. modes[data.mode_type] = ctx.helper._.cloneDeep(paymentConst.setting_modes[data.mode_type]);
  217. modes[data.mode_type].checked = checked;
  218. } else {
  219. throw '该模块不存在';
  220. }
  221. await ctx.service.project.defaultUpdate({ id: ctx.session.sessionProject.id, payment_setting: JSON.stringify(modes) });
  222. break;
  223. default: throw '参数有误';
  224. }
  225. // 先获取你创建的标段及参与的标段
  226. const tenderList = await ctx.service.paymentTender.getList(ctx.session.sessionUser.accountId, auditPermission);
  227. // 获取你创建的目录及对应目录下的所有目录
  228. const folderList = await ctx.service.paymentFolder.getList(ctx.session.sessionUser.accountId, tenderList, auditPermission);
  229. responseData.data.folderList = ctx.helper._.orderBy(folderList, ['in_time'], ['asc']);
  230. responseData.data.tenderList = ctx.helper._.orderBy(tenderList, ['in_time'], ['asc']);
  231. ctx.body = responseData;
  232. } catch (err) {
  233. this.log(err);
  234. ctx.body = { err: 1, msg: err.toString(), data: null };
  235. }
  236. }
  237. async setting(ctx) {
  238. try {
  239. if (!ctx.session.sessionUser.is_admin) {
  240. throw '您无权打开此页';
  241. }
  242. const projectInfo = await ctx.service.project.getDataById(ctx.session.sessionProject.id);
  243. const modes = projectInfo.payment_setting ? JSON.parse(projectInfo.payment_setting) : ctx.helper._.cloneDeep(paymentConst.setting_modes);
  244. for (const m in modes) {
  245. const detailCount = await ctx.service.paymentDetail.getCountByPidType(ctx.session.sessionProject.id, modes[m].value);
  246. modes[m].can_check = !detailCount && modes[m].value !== 1;
  247. }
  248. const renderData = {
  249. setting_modes: paymentConst.setting_modes,
  250. modes,
  251. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.payment.setting),
  252. };
  253. await this.layout('payment/setting.ejs', renderData);
  254. } catch (err) {
  255. console.log(err);
  256. this.log(err);
  257. ctx.session.postError = err.toString();
  258. ctx.redirect('/payment');
  259. }
  260. }
  261. /**
  262. * 获取审批界面所需的 原报、审批人数据等
  263. * @param ctx
  264. * @return {Promise<void>}
  265. * @private
  266. */
  267. async _getDetailAuditViewData(ctx) {
  268. const times = ctx.detail.status === auditConst.status.checkNo ? ctx.detail.times - 1 : ctx.detail.times;
  269. ctx.detail.user = await ctx.service.projectAccount.getAccountInfoById(ctx.detail.uid);
  270. ctx.detail.auditHistory = [];
  271. if (times >= 1) {
  272. for (let i = 1; i <= times; i++) {
  273. ctx.detail.auditHistory.push(await ctx.service.paymentDetailAudit.getAuditors(ctx.detail.id, i));
  274. }
  275. }
  276. // 获取审批流程中左边列表
  277. ctx.detail.auditors2 = ctx.detail.status === auditConst.status.checkNo && ctx.detail.uid !== ctx.session.sessionUser.accountId ?
  278. await ctx.service.paymentDetailAudit.getAuditorsWithOwner(ctx.detail.id, times) :
  279. await ctx.service.paymentDetailAudit.getAuditorsWithOwner(ctx.detail.id, ctx.detail.times);
  280. if (ctx.detail.status === auditConst.status.uncheck || ctx.detail.status === auditConst.status.checkNo) {
  281. ctx.detail.auditorList = await ctx.service.paymentDetailAudit.getAuditors(ctx.detail.id, ctx.detail.times);
  282. }
  283. // 是否已验证手机短信
  284. const pa = await ctx.service.projectAccount.getDataById(ctx.session.sessionUser.accountId);
  285. ctx.detail.authMobile = pa.auth_mobile;
  286. }
  287. /**
  288. * 支付表单页面
  289. *
  290. * @param {Object} ctx - egg全局页面
  291. * @return {void}
  292. */
  293. async detail(ctx) {
  294. try {
  295. await this._getDetailAuditViewData(ctx);
  296. const renderData = {
  297. trInfo: ctx.trInfo,
  298. paymentConst,
  299. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.payment.detail),
  300. auditConst,
  301. shenpiConst,
  302. preUrl: '/payment/' + ctx.tender.id + '/detail/' + ctx.detail.id,
  303. OSS_PATH: ctx.app.config.fujianOssPath,
  304. };
  305. renderData.nextDetail = await ctx.service.paymentDetail.getDataByCondition({ tr_id: ctx.trInfo.id, order: ctx.detail.order + 1 });
  306. let report_json = JSON.parse(ctx.detail.report_json);
  307. const content = [];
  308. // 获取当前报表人
  309. const rptAudit = await ctx.service.paymentRptAudit.getDataByCondition({ td_id: ctx.detail.id, uid: ctx.session.sessionUser.accountId });
  310. if (report_json.items[0].interact_cells.length > 0) {
  311. for (const [i, cell] of report_json.items[0].interact_cells.entries()) {
  312. const push_item = {
  313. type: paymentConst.rpt_dataType[cell.DataType],
  314. value: cell.Prefix ? ctx.helper._.replace(cell.Value, cell.Prefix, '') : cell.Value,
  315. label: cell.Label,
  316. index: i,
  317. };
  318. const thisControl = paymentConst.rpt_control[cell.control] ? cell.control : 'content';
  319. const oneShowContent = ctx.helper._.find(content, { control: thisControl });
  320. if (oneShowContent) {
  321. oneShowContent.items.push(push_item);
  322. } else {
  323. content.push({
  324. control: thisControl,
  325. title: paymentConst.rpt_control[thisControl],
  326. items: [push_item],
  327. });
  328. }
  329. }
  330. if (rptAudit && ((ctx.detail.status !== auditConst.status.checkNo && ctx.detail.status !== auditConst.status.checked) ||
  331. (ctx.detail.status === auditConst.status.checked && !renderData.nextDetail) ||
  332. (ctx.detail.status === auditConst.status.checkNo && ctx.detail.uid === ctx.session.sessionUser.accountId))) {
  333. // 获取个人签字,单位章,个人章地址
  334. const userInfo = await ctx.service.projectAccount.getDataById(ctx.session.sessionUser.accountId);
  335. const stampPathList = userInfo.stamp_path ? userInfo.stamp_path.split('!;!') : [];
  336. const companyInfo = userInfo.company ? await ctx.service.constructionUnit.getDataByCondition({ pid: ctx.session.sessionProject.id, name: userInfo.company }) : {};
  337. if (rptAudit.signature_msg) {
  338. const sign_msg = JSON.parse(rptAudit.signature_msg);
  339. report_json = await ctx.service.paymentDetail.signOneSignatureData(report_json, rptAudit.signature_name, sign_msg);
  340. rptAudit.signature_msg = sign_msg;
  341. } else {
  342. rptAudit.signature_msg = paymentConst.signature_msg;
  343. rptAudit.signature_msg.sign_path = userInfo.sign_path ? userInfo.sign_path : '';
  344. }
  345. renderData.signPath = userInfo.sign_path ? userInfo.sign_path : '';
  346. renderData.stampPathList = stampPathList;
  347. renderData.currentStamp = rptAudit && rptAudit.signature_msg.stamp_path ? rptAudit.signature_msg.stamp_path : (stampPathList.length > 0 ? stampPathList[0] : '');
  348. renderData.companyStamp = companyInfo && companyInfo.sign_path ? companyInfo.sign_path : '';
  349. }
  350. }
  351. renderData.rptAudit = rptAudit;
  352. renderData.content = content;
  353. renderData.report_json = report_json;
  354. if ((ctx.detail.status === auditConst.status.uncheck || ctx.detail.status === auditConst.status.checkNo) && ctx.session.sessionUser.accountId === ctx.detail.uid) {
  355. // data.accountGroup = accountGroup;
  356. // 获取所有项目参与者
  357. const accountList = await ctx.service.projectAccount.getAllDataByCondition({
  358. where: { project_id: ctx.session.sessionProject.id, enable: 1 },
  359. columns: ['id', 'name', 'company', 'role', 'enable', 'is_admin', 'account_group', 'mobile'],
  360. });
  361. renderData.accountList = accountList;
  362. renderData.accountGroup = accountGroup.map((item, idx) => {
  363. const groupList = accountList.filter(item => item.account_group === idx);
  364. return { groupName: item, groupList };
  365. });
  366. }
  367. await this.layout('payment/detail.ejs', renderData, 'payment/detail_modal.ejs');
  368. } catch (err) {
  369. console.log(err);
  370. this.log(err);
  371. ctx.session.postError = err.toString();
  372. if (ctx.detail.tender_id && ctx.detail.tr_id) {
  373. ctx.redirect('/payment' + ctx.detail.tender_id + '/list/' + ctx.detail.tr_id);
  374. }
  375. ctx.redirect(this.menu.menu.dashboard.url);
  376. }
  377. }
  378. async detailSave(ctx) {
  379. try {
  380. const data = JSON.parse(ctx.request.body.data);
  381. if (!data.type) {
  382. throw '提交数据错误';
  383. }
  384. // 检查权限等
  385. if (ctx.detail.uid !== ctx.session.sessionUser.accountId && data.type !== 'update_sign') {
  386. throw '您无权操作';
  387. }
  388. if (data.type !== 'update_sign' && ctx.detail.status !== auditConst.status.uncheck && ctx.detail.status !== auditConst.status.checkNo) {
  389. throw '您无权操作';
  390. }
  391. const responseData = {
  392. err: 0, msg: '', data: {},
  393. };
  394. switch (data.type) {
  395. case 'update_rpt':
  396. responseData.data = await ctx.service.paymentDetail.updateReportJson(ctx.detail.id, data.report_json);
  397. break;
  398. case 'update_sign':
  399. if (ctx.detail.status === auditConst.status.checked) {
  400. // 判断是否存在下一期,是则无法签章
  401. const detailMsg = await ctx.service.paymentDetail.getDataByCondition({ tr_id: ctx.detail.tr_id, order: ctx.detail.order + 1 });
  402. if (detailMsg) {
  403. throw '您无法操作签字/签章';
  404. }
  405. }
  406. responseData.data = await ctx.service.paymentRptAudit.updateSignatureMsg(ctx.detail.id, ctx.session.sessionUser.accountId, data.signature_msg);
  407. break;
  408. case 'add_audit':
  409. const auditorId = this.app._.toInteger(data.auditorId);
  410. if (isNaN(auditorId) || auditorId <= 0) {
  411. throw '参数错误';
  412. }
  413. ctx.detail.auditorList = await ctx.service.paymentDetailAudit.getAuditors(ctx.detail.id, ctx.detail.times);
  414. // 检查审核人是否已存在
  415. const exist = this.app._.find(ctx.detail.auditorList, { aid: auditorId });
  416. if (exist) {
  417. throw '该审核人已存在,请勿重复添加';
  418. }
  419. const shenpiInfo = await ctx.service.paymentShenpiAudit.getDataByCondition({ tr_id: ctx.trInfo.id, sp_status: shenpiConst.sp_status.gdzs });
  420. const is_gdzs = shenpiInfo && ctx.trinfo.sp_status === shenpiConst.sp_status.gdzs ? 1 : 0;
  421. const result = await ctx.service.paymentDetailAudit.addAuditor(ctx.detail.id, auditorId, ctx.detail.times, is_gdzs);
  422. if (!result) {
  423. throw '添加审核人失败';
  424. }
  425. responseData.data = await ctx.service.paymentDetailAudit.getAuditorsWithOwner(ctx.detail.id, ctx.detail.times);
  426. break;
  427. case 'del_audit':
  428. const auditorId2 = data.auditorId instanceof Number ? data.auditorId : this.app._.toNumber(data.auditorId);
  429. if (isNaN(auditorId2) || auditorId2 <= 0) {
  430. throw '参数错误';
  431. }
  432. const result2 = await ctx.service.paymentDetailAudit.deleteAuditor(ctx.detail.id, auditorId2, ctx.detail.times);
  433. if (!result2) {
  434. throw '移除审核人失败';
  435. }
  436. responseData.data = await ctx.service.paymentDetailAudit.getAuditors(ctx.detail.id, ctx.detail.times);
  437. break;
  438. case 'follow_rpt_audit':
  439. if (ctx.trInfo.shenpi_status === shenpiConst.sp_status.gdspl) {
  440. throw '当前表单已设置为固定审批流,无法同步';
  441. }
  442. const result3 = await ctx.service.paymentDetailAudit.followAuditByRptAudit(ctx.detail);
  443. if (!result3) {
  444. throw '同步表单角色失败';
  445. }
  446. responseData.data = await ctx.service.paymentDetailAudit.getAuditorsWithOwner(ctx.detail.id, ctx.detail.times);
  447. break;
  448. default: throw '参数有误';
  449. }
  450. ctx.body = responseData;
  451. } catch (err) {
  452. this.log(err);
  453. ctx.body = { err: 1, msg: err.toString(), data: null };
  454. }
  455. }
  456. async deleteDetail(ctx) {
  457. try {
  458. const detail_id = ctx.request.body.detail_id;
  459. const detailInfo = await ctx.service.paymentDetail.getDataById(detail_id);
  460. if (!detailInfo) {
  461. throw '所选报表表单详情已删除';
  462. }
  463. // 获取最新的期数
  464. const detail_highOrder = await ctx.service.paymentDetail.count({
  465. tr_id: detailInfo.tr_id,
  466. });
  467. if (!(ctx.session.sessionUser.is_admin || ((detailInfo.status === auditConst.status.uncheck || detailInfo.status === auditConst.status.checkNo) && detailInfo.uid === ctx.session.sessionUser.accountId)) || detail_highOrder !== detailInfo.order) {
  468. throw '您无权删除所选报表表单详情';
  469. }
  470. const result = await ctx.service.paymentDetail.deleteDetail(detail_id);
  471. if (!result) {
  472. throw '删除报表表单详情失败,请重试';
  473. }
  474. ctx.redirect('/payment/' + ctx.tender.id + '/list/' + detailInfo.tr_id);
  475. } catch (err) {
  476. this.log(err);
  477. ctx.session.postError = err.toString();
  478. ctx.redirect(ctx.request.header.referer);
  479. }
  480. }
  481. /**
  482. * 期审批流程(Get)
  483. * @param ctx
  484. * @return {Promise<void>}
  485. */
  486. async detailAuditors(ctx) {
  487. try {
  488. const responseData = {
  489. err: 0, msg: '', data: {},
  490. };
  491. const order = JSON.parse(ctx.request.body.data).order;
  492. const tr_id = ctx.params.trid;
  493. const detailInfo = await ctx.service.paymentDetail.getDataByCondition({ tr_id, order });
  494. // 获取审批流程中右边列表
  495. const auditHistory = [];
  496. const times = detailInfo.status === auditConst.status.checkNo ? detailInfo.times - 1 : detailInfo.times;
  497. if (times >= 1) {
  498. for (let i = 1; i <= times; i++) {
  499. auditHistory.push(await ctx.service.paymentDetailAudit.getAuditors(detailInfo.id, i));
  500. }
  501. }
  502. responseData.data.auditHistory = auditHistory;
  503. // 获取审批流程中左边列表
  504. responseData.data.auditors = await ctx.service.paymentDetailAudit.getAuditorsWithOwner(detailInfo.id, times);
  505. responseData.data.user = await ctx.service.projectAccount.getAccountInfoById(detailInfo.uid);
  506. ctx.body = responseData;
  507. } catch (error) {
  508. this.log(error);
  509. ctx.body = { err: 1, msg: error.toString(), data: null };
  510. }
  511. }
  512. async _returnRptProjectList(ctx, formProcess = false) {
  513. // 获取报表表单列表
  514. if (ctx.payment.auditPermission.view_all || ctx.tender.uid === ctx.session.sessionUser.accountId || formProcess) {
  515. const rptProject = await ctx.service.rptTreeNode.getDataByCondition({ pid: ctx.session.sessionProject.id, name: '01.支付审批报表' });
  516. const rptProjectList = [];
  517. const newRptList = rptProject && rptProject.items ? JSON.parse(rptProject.items) : [];
  518. ctx.rptListNum = 0;
  519. await this.getNewRptProjectList(ctx, newRptList, rptProjectList, 1);
  520. const tenderRptList = await ctx.service.paymentTenderRpt.getProcessList(ctx.tender.id);
  521. if (tenderRptList === -1) {
  522. throw '未配置表单设置,请联系管理员处理';
  523. }
  524. return await ctx.service.paymentTenderRpt.checkAndUpdateList(tenderRptList, rptProjectList, formProcess);
  525. }
  526. return await ctx.service.paymentTenderRpt.getList(ctx.tender.id, ctx.session.sessionUser.accountId);
  527. }
  528. // 循环获取到到rptProject
  529. async getNewRptProjectList(ctx, newRptList, rptProjectList, level = 1) {
  530. if (newRptList.length > 0) {
  531. for (const r of newRptList) {
  532. r.level = level;
  533. r.index = ctx.rptListNum;
  534. ctx.rptListNum = ctx.rptListNum + 1;
  535. rptProjectList.push(r);
  536. if (r.items && r.items.length > 0) {
  537. await this.getNewRptProjectList(ctx, r.items, rptProjectList, level + 1);
  538. }
  539. }
  540. }
  541. }
  542. async process(ctx) {
  543. try {
  544. if (!ctx.payment.auditPermission || !ctx.payment.auditPermission.admin || !(ctx.session.sessionUser.is_admin || ctx.tender.uid === ctx.session.sessionUser.accountId)) {
  545. throw '权限不足';
  546. }
  547. let [tenderRptList, rptProjectList] = await this._returnRptProjectList(ctx, true);
  548. tenderRptList = ctx.helper._.filter(tenderRptList, { type: 0, is_del: 0 });
  549. // for (const tr of tenderRptList) {
  550. // if (tr.status === shenpiConst.sp_status.gdspl) {
  551. // tr.auditList = await ctx.service.paymentShenpiAudit.getAuditList(ctx.tender.id, tr.id, tr.sp_status);
  552. // } else if (tr.status === shenpiConst.sp_status.gdzs) {
  553. // tr.audit = await ctx.service.paymentShenpiAudit.getAudit(ctx.tender.id, tr.id, tr.sp_status);
  554. // }
  555. // }
  556. // 获取所有项目参与者
  557. const accountList = await ctx.service.projectAccount.getAllDataByCondition({
  558. where: { project_id: ctx.session.sessionProject.id, enable: 1 },
  559. columns: ['id', 'name', 'company', 'role', 'enable', 'is_admin', 'account_group', 'mobile'],
  560. });
  561. const accountGroupList = accountGroup.map((item, idx) => {
  562. const groupList = accountList.filter(item => item.account_group === idx);
  563. return { groupName: item, groupList };
  564. });
  565. const renderData = {
  566. tender: ctx.tender,
  567. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.payment.process),
  568. rptProjectList,
  569. tenderRptList,
  570. shenpi: shenpiConst,
  571. accountList,
  572. accountGroup: accountGroupList,
  573. };
  574. await this.layout('payment/process.ejs', renderData, 'payment/process_modal.ejs');
  575. } catch (err) {
  576. console.log(err);
  577. this.log(err);
  578. ctx.session.postError = err.toString();
  579. ctx.redirect(this.request && this.request.headers && this.request.headers.referer ? this.request.headers.referer : '/payment');
  580. }
  581. }
  582. async processSave(ctx) {
  583. try {
  584. if (!ctx.payment.auditPermission || !ctx.payment.auditPermission.admin) {
  585. throw '权限不足';
  586. }
  587. const responseData = {
  588. err: 0, msg: '', data: {},
  589. };
  590. const data = JSON.parse(ctx.request.body.data);
  591. if (!data.type) {
  592. throw '提交数据错误';
  593. }
  594. switch (data.type) {
  595. case 'add-rpt':
  596. responseData.data = await ctx.service.paymentTenderRpt.setRpt(ctx.tender.id, data.rpt_list);
  597. break;
  598. case 'change-status':
  599. responseData.data = await ctx.service.paymentTenderRpt.setStatus(data.tr_id, data.status);
  600. break;
  601. case 'get-audits':
  602. responseData.data = await ctx.service.paymentShenpiAudit.getShenpiAudit(data.tr_id, data.status);
  603. break;
  604. case 'add-audit':
  605. responseData.data = await ctx.service.paymentShenpiAudit.addAudit(data);
  606. break;
  607. case 'del-audit':
  608. responseData.data = await ctx.service.paymentShenpiAudit.removeAudit(data);
  609. break;
  610. case 'update-report':
  611. responseData.data = await ctx.service.paymentTenderRpt.updateReport(data);
  612. break;
  613. default: throw '参数有误';
  614. }
  615. ctx.body = responseData;
  616. } catch (err) {
  617. this.log(err);
  618. ctx.body = { err: 1, msg: err.toString(), data: null };
  619. }
  620. }
  621. async rptList(ctx) {
  622. try {
  623. const tenderRptList = await this._returnRptProjectList(ctx);
  624. if (tenderRptList === -1) {
  625. throw '未配置表单设置,请联系管理员处理';
  626. }
  627. if (tenderRptList.length === 0) {
  628. throw '未配置表单设置,请联系管理员处理';
  629. }
  630. for (const tr of tenderRptList) {
  631. tr.have_notice = await ctx.service.paymentDetail.haveNotice2TenderRpt(tr.id, ctx.session.sessionUser.accountId);
  632. }
  633. const trid = ctx.params.trid ? parseInt(ctx.params.trid) : 0;
  634. const trInfo = trid ? ctx.helper._.find(tenderRptList, { id: trid }) : tenderRptList[0];
  635. if (!trInfo) {
  636. throw '该模块已关闭或未进行表单审批设置';
  637. }
  638. // 获取列表
  639. const trDetailList = await ctx.service.paymentDetail.getValidDetails(trInfo.id);
  640. const accountList = await ctx.service.projectAccount.getAllDataByCondition({
  641. where: { project_id: ctx.session.sessionProject.id, enable: 1 },
  642. columns: ['id', 'name', 'company', 'role', 'enable', 'is_admin', 'account_group', 'mobile'],
  643. });
  644. for (const s of trDetailList) {
  645. // s.curAuditor = null;
  646. // 根据期状态返回展示用户
  647. s.curAuditor = await ctx.service.paymentDetailAudit.getAuditorByStatus(s.id, s.status, s.times);
  648. const userInfo = ctx.helper._.find(accountList, { id: s.uid });
  649. s.user_name = userInfo ? userInfo.name : '';
  650. }
  651. const renderData = {
  652. tender: ctx.tender,
  653. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.payment.list),
  654. tenderRptList,
  655. trInfo,
  656. trDetailList,
  657. rptMsg: null,
  658. auditConst,
  659. accountGroup: [],
  660. accountList: [],
  661. paymentConst,
  662. preUrl: '/payment/' + ctx.tender.id + '/list/' + trInfo.id,
  663. };
  664. // 获取报表信息,新增时及设置报表角色时使用
  665. if (trInfo.uid === ctx.session.sessionUser.accountId && trInfo.is_del === 0 && trInfo.rpt_id) {
  666. const rptTpl = await ctx.service.rptTpl.getDataById(trInfo.rpt_id);
  667. if (rptTpl) {
  668. const pageRst = await ctx.service.jpcReport.getAllPreviewPagesCommon(rptTpl, 'A4');
  669. renderData.rptMsg = pageRst.items[0];
  670. // 判断与原有的报表审批人列表是否有区别
  671. let difference = false;
  672. let auditDifference = false;
  673. let needChange = false;
  674. if (trInfo.report_items_json) {
  675. const report_items_json = JSON.parse(trInfo.report_items_json);
  676. const items = ['cells', 'signature_audit_cells', 'signature_cells', 'signature_date_cells', 'interact_cells'];
  677. for (const item of items) {
  678. if (!difference && report_items_json[item] &&
  679. !ctx.helper._.isEmpty(ctx.helper._.differenceWith(JSON.parse(JSON.stringify(renderData.rptMsg[item])), report_items_json[item], ctx.helper._.isEqual))) {
  680. // 因为interact_cells里存在undefind值,必须先用JSON.parse和JSON.stringify转义才能对比
  681. difference = true;
  682. needChange = true;
  683. if (item === 'signature_audit_cells') {
  684. auditDifference = true;
  685. }
  686. break;
  687. }
  688. }
  689. } else {
  690. difference = true;
  691. }
  692. if (difference) {
  693. // 删除rpt_audit重新配置
  694. const updateData = {
  695. id: trInfo.id,
  696. report_items_json: JSON.stringify(ctx.helper._.cloneDeep(renderData.rptMsg)),
  697. };
  698. // 删除rpt_audit重新配置
  699. if (auditDifference) {
  700. updateData.rpt_audit = null;
  701. trInfo.rpt_audit = null;
  702. }
  703. if (needChange) {
  704. updateData.is_change = 1;
  705. trInfo.is_change = 1;
  706. }
  707. await ctx.service.paymentTenderRpt.defaultUpdate(updateData);
  708. trInfo.report_items_json = renderData.rptMsg;
  709. }
  710. if (trInfo.rpt_audit) {
  711. trInfo.rpt_audit = JSON.parse(trInfo.rpt_audit);
  712. const prjAccList = await ctx.service.projectAccount.getAllAccountByProjectId(ctx.session.sessionProject.id);
  713. for (const audit of trInfo.rpt_audit) {
  714. if (audit.uid) {
  715. const info = ctx.helper._.find(prjAccList, { id: audit.uid });
  716. audit.name = info.name;
  717. }
  718. }
  719. } else {
  720. trInfo.rpt_audit = [];
  721. for (const sc of renderData.rptMsg.signature_cells) {
  722. trInfo.rpt_audit.push({
  723. uid: null,
  724. rpt_name: sc.signature_name,
  725. });
  726. }
  727. }
  728. renderData.trInfo = trInfo;
  729. }
  730. if (renderData.rptMsg) {
  731. // 获取所有项目参与者
  732. const accountList = await ctx.service.projectAccount.getAllDataByCondition({
  733. where: { project_id: ctx.session.sessionProject.id, enable: 1 },
  734. columns: ['id', 'name', 'company', 'role', 'enable', 'is_admin', 'account_group', 'mobile'],
  735. });
  736. const accountGroupList = accountGroup.map((item, idx) => {
  737. const groupList = accountList.filter(item => item.account_group === idx);
  738. return { groupName: item, groupList };
  739. });
  740. renderData.accountList = accountList;
  741. renderData.accountGroup = accountGroupList;
  742. }
  743. }
  744. await this.layout('payment/list.ejs', renderData, 'payment/list_modal.ejs');
  745. } catch (err) {
  746. console.log(err);
  747. this.log(err);
  748. ctx.session.postError = err.toString();
  749. ctx.redirect(this.request && this.request.headers && this.request.headers.referer ? this.request.headers.referer : '/payment');
  750. }
  751. }
  752. async rptSave(ctx) {
  753. try {
  754. const tr_id = ctx.params.trid;
  755. if (!tr_id) {
  756. throw '参数有误';
  757. }
  758. const trInfo = await ctx.service.paymentTenderRpt.getDataById(tr_id);
  759. if (!trInfo) {
  760. throw '标段报表不存在';
  761. }
  762. if (ctx.session.sessionUser.accountId !== trInfo.uid) {
  763. throw '权限不足';
  764. }
  765. const responseData = {
  766. err: 0, msg: '', data: {},
  767. };
  768. const data = JSON.parse(ctx.request.body.data);
  769. if (!data.type) {
  770. throw '提交数据错误';
  771. }
  772. switch (data.type) {
  773. case 'rpt_audit':
  774. responseData.data = await ctx.service.paymentTenderRpt.updateRptAudit(trInfo, data.rpt_audit);
  775. break;
  776. case 'add-detail':
  777. responseData.data = await ctx.service.paymentDetail.addDetail(trInfo, data.code, data.s_time);
  778. break;
  779. default: throw '参数有误';
  780. }
  781. ctx.body = responseData;
  782. } catch (err) {
  783. this.log(err);
  784. ctx.body = { err: 1, msg: err.toString(), data: null };
  785. }
  786. }
  787. /**
  788. * 上报和重新上报
  789. * @param ctx
  790. * @return {Promise<void>}
  791. */
  792. async startAudit(ctx) {
  793. try {
  794. if (ctx.detail.uid !== ctx.session.sessionUser.accountId) {
  795. throw '您无权上报报表表单详情数据';
  796. }
  797. if (ctx.detail.status === auditConst.status.checking || ctx.detail.status === auditConst.status.checked) {
  798. throw '该报表表单详情数据当前无法上报';
  799. }
  800. await ctx.service.paymentDetailAudit.start(ctx.detail.id, ctx.detail.times);
  801. ctx.redirect(ctx.request.header.referer);
  802. } catch (err) {
  803. this.log(err);
  804. ctx.session.postError = err.toString();
  805. ctx.redirect(ctx.request.header.referer);
  806. }
  807. }
  808. /**
  809. * 审批
  810. * @param ctx
  811. * @return {Promise<void>}
  812. */
  813. async checkAudit(ctx) {
  814. try {
  815. if (!ctx.detail || ctx.detail.status !== auditConst.status.checking) {
  816. throw '当前报表表单详情数据有误';
  817. }
  818. if (!ctx.detail.curAuditor || ctx.detail.curAuditor.aid !== ctx.session.sessionUser.accountId) {
  819. throw '您无权进行该操作';
  820. }
  821. const data = {
  822. checkType: parseInt(ctx.request.body.checkType),
  823. opinion: ctx.request.body.opinion,
  824. };
  825. if (!data.checkType || isNaN(data.checkType)) {
  826. throw '提交数据错误';
  827. }
  828. if (data.checkType === auditConst.status.checkNo) {
  829. if (!data.checkType || isNaN(data.checkType)) {
  830. throw '提交数据错误';
  831. }
  832. }
  833. await ctx.service.paymentDetailAudit.check(ctx.detail.id, data, ctx.detail.times);
  834. ctx.redirect(ctx.request.header.referer);
  835. } catch (err) {
  836. this.log(err);
  837. ctx.session.postError = err.toString();
  838. ctx.redirect(ctx.request.header.referer);
  839. }
  840. }
  841. }
  842. return PaymentController;
  843. };