payment_controller.js 66 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268
  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. const moment = require('moment');
  8. const path = require('path');
  9. const sendToWormhole = require('stream-wormhole');
  10. const fs = require('fs');
  11. module.exports = app => {
  12. class PaymentController extends app.BaseController {
  13. /**
  14. * 构造函数
  15. *
  16. * @param {Object} ctx - egg全局变量
  17. * @return {void}
  18. */
  19. constructor(ctx) {
  20. super(ctx);
  21. ctx.showProject = true;
  22. // ctx.showTitle = true;
  23. }
  24. /**
  25. * 支付审批列表页
  26. *
  27. * @param {Object} ctx - egg全局页面
  28. * @return {void}
  29. */
  30. async index(ctx) {
  31. try {
  32. const auditPermission = await this.ctx.service.paymentPermissionAudit.getOnePermission(ctx.session.sessionUser.is_admin, ctx.session.sessionUser.accountId);
  33. if (!auditPermission) {
  34. throw '权限不足';
  35. }
  36. // 列表读取及目录读取
  37. const renderData = {
  38. auditPermission,
  39. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.payment.index),
  40. };
  41. if (ctx.session.sessionUser.is_admin) {
  42. const projectId = ctx.session.sessionProject.id;
  43. const permissionAudits = await ctx.service.paymentPermissionAudit.getList(projectId);
  44. // 获取所有项目参与者
  45. const accountList = await ctx.service.projectAccount.getAllDataByCondition({
  46. where: { project_id: ctx.session.sessionProject.id, enable: 1 },
  47. columns: ['id', 'name', 'company', 'role', 'enable', 'is_admin', 'account_group', 'mobile'],
  48. });
  49. const unitList = await ctx.service.constructionUnit.getAllDataByCondition({ where: { pid: projectId } });
  50. const accountGroupList = unitList.map(item => {
  51. const groupList = accountList.filter(item1 => item1.company === item.name);
  52. return { groupName: item.name, groupList };
  53. });
  54. // const accountGroupList = accountGroup.map((item, idx) => {
  55. // const groupList = accountList.filter(item => item.account_group === idx);
  56. // return { groupName: item, groupList };
  57. // });
  58. renderData.permissionAudits = permissionAudits;
  59. renderData.accountList = accountList;
  60. renderData.accountGroup = accountGroupList;
  61. }
  62. await this.layout('payment/index.ejs', renderData, 'payment/modal.ejs');
  63. } catch (err) {
  64. console.log(err);
  65. this.log(err);
  66. ctx.session.postError = err.toString();
  67. ctx.redirect(this.menu.menu.dashboard.url);
  68. }
  69. }
  70. async listLoad(ctx) {
  71. const responseData = {
  72. err: 0, msg: '', data: {},
  73. };
  74. const auditPermission = await this.ctx.service.paymentPermissionAudit.getOnePermission(ctx.session.sessionUser.is_admin, ctx.session.sessionUser.accountId);
  75. if (!auditPermission) {
  76. throw '权限不足';
  77. }
  78. // 先获取你创建的标段及参与的标段
  79. const tenderList = await ctx.service.paymentTender.getList(ctx.session.sessionUser.accountId, auditPermission);
  80. // 获取你创建的目录及对应目录下的所有目录
  81. const folderList = await ctx.service.paymentFolder.getList(ctx.session.sessionUser.accountId, tenderList, auditPermission);
  82. if (tenderList.length > 0) {
  83. for (const t of tenderList) {
  84. t.have_notice = await ctx.service.paymentDetail.haveNotice2Tender(t.id, ctx.session.sessionUser.accountId);
  85. t.have_detail = await ctx.service.paymentDetail.haveDetail2Tender(t.id);
  86. }
  87. }
  88. responseData.data.folderList = ctx.helper._.orderBy(folderList, ['in_time'], ['asc']);
  89. responseData.data.tenderList = ctx.helper._.orderBy(tenderList, ['in_time'], ['asc']);
  90. ctx.body = responseData;
  91. }
  92. async permissionSave(ctx) {
  93. try {
  94. if (ctx.session.sessionUser.is_admin === 0) throw '没有设置权限';
  95. const projectId = ctx.session.sessionProject.id;
  96. const responseData = {
  97. err: 0, msg: '', data: null,
  98. };
  99. const data = JSON.parse(ctx.request.body.data);
  100. if (!data.type) {
  101. throw '提交数据错误';
  102. }
  103. let uids;
  104. let result = false;
  105. let auditList = [];
  106. switch (data.type) {
  107. case 'add-audit':
  108. // 判断用户是单个还是数组
  109. uids = data.id instanceof Array ? data.id : [data.id];
  110. // 判断该用户的组是否已加入到表中,已加入则提示无需添加
  111. auditList = await ctx.service.paymentPermissionAudit.getAllDataByCondition({ where: { pid: projectId, uid: uids } });
  112. const addAidList = ctx.helper._.difference(uids, ctx.helper._.map(auditList, 'uid'));
  113. if (addAidList.length === 0) {
  114. throw '用户已存在权限中,无需重复添加';
  115. }
  116. const accountList = await ctx.service.projectAccount.getAllDataByCondition({ where: { id: addAidList } });
  117. await ctx.service.paymentPermissionAudit.saveAudits(projectId, accountList);
  118. responseData.data = await ctx.service.paymentPermissionAudit.getList(projectId);
  119. break;
  120. case 'del-audit':
  121. uids = data.id instanceof Array ? data.id : [data.id];
  122. auditList = await ctx.service.paymentPermissionAudit.getAllDataByCondition({ where: { id: uids } });
  123. if (auditList.length !== uids.length) {
  124. throw '该用户已不存在权限中,移除失败';
  125. }
  126. await ctx.service.paymentPermissionAudit.delAudit(uids);
  127. responseData.data = await ctx.service.paymentPermissionAudit.getList(projectId);
  128. break;
  129. case 'save-permission-one':
  130. result = await ctx.service.paymentPermissionAudit.updateOnePermission(data.updateData);
  131. if (!result) {
  132. throw '修改权限失败';
  133. }
  134. break;
  135. // case 'save-permission-all':
  136. // result = await ctx.service.paymentPermissionAudit.updateAllPermission(projectId, data.permission_type, data.value);
  137. // if (!result) {
  138. // throw '修改权限失败';
  139. // }
  140. // responseData.data = await ctx.service.paymentPermissionAudit.getList(projectId);
  141. // break;
  142. default: throw '参数有误';
  143. }
  144. ctx.body = responseData;
  145. } catch (err) {
  146. this.log(err);
  147. ctx.body = { err: 1, msg: err.toString(), data: null };
  148. }
  149. }
  150. async save(ctx) {
  151. try {
  152. const projectId = ctx.session.sessionProject.id;
  153. const auditPermission = await this.ctx.service.paymentPermissionAudit.getOnePermission(ctx.session.sessionUser.is_admin, ctx.session.sessionUser.accountId);
  154. if (!auditPermission) {
  155. throw '权限不足';
  156. }
  157. const responseData = {
  158. err: 0, msg: '', data: {},
  159. };
  160. const data = JSON.parse(ctx.request.body.data);
  161. if (!data.type) {
  162. throw '提交数据错误';
  163. }
  164. if (!auditPermission.admin) {
  165. throw '您没有权限操作此功能';
  166. }
  167. let type = '';
  168. switch (data.type) {
  169. case 'add-folder':
  170. await ctx.service.paymentFolder.addFolder(projectId, ctx.session.sessionUser.accountId, data.parentId, data.name);
  171. break;
  172. case 'add-tender':
  173. await ctx.service.paymentTender.addTender(projectId, ctx.session.sessionUser.accountId, data.folderId, data.name);
  174. break;
  175. case 'edit-name':
  176. type = data.postData.type;
  177. const updateData = {
  178. name: data.postData.name,
  179. };
  180. const conditionData = {
  181. id: data.postData.id,
  182. };
  183. if (type === 'tender') {
  184. const tenderInfo = await ctx.service.paymentTender.getDataById(conditionData.id);
  185. if (!tenderInfo) throw '标段不存在';
  186. if (tenderInfo.uid !== ctx.session.sessionUser.accountId && !ctx.session.sessionUser.is_admin) {
  187. throw '您没有权限重命名此标段';
  188. }
  189. await ctx.service.paymentTender.update(updateData, conditionData);
  190. } else {
  191. const folderInfo = await ctx.service.paymentFolder.getDataById(conditionData.id);
  192. if (!folderInfo) throw '文件夹不存在';
  193. if (folderInfo.uid !== ctx.session.sessionUser.accountId && !ctx.session.sessionUser.is_admin) {
  194. throw '您没有权限重命名此文件夹';
  195. }
  196. await ctx.service.paymentFolder.update(updateData, conditionData);
  197. }
  198. break;
  199. case 'del':
  200. type = data.postData.type;
  201. if (type === 'tender') {
  202. await ctx.service.paymentTender.deleteTender(data.postData.id);
  203. } else {
  204. await ctx.service.paymentFolder.deleteFolder(data.postData.id);
  205. }
  206. break;
  207. case 'mode-setting':
  208. if (!ctx.session.sessionUser.is_admin) {
  209. throw '您无权操作';
  210. }
  211. const projectInfo = await ctx.service.project.getDataById(ctx.session.sessionProject.id);
  212. const modes = projectInfo.payment_setting ? JSON.parse(projectInfo.payment_setting) : ctx.helper._.cloneDeep(paymentConst.setting_modes);
  213. const checked = data.checked;
  214. if (modes[data.mode_type]) {
  215. const detailCount = await ctx.service.paymentDetail.getCountByPidType(ctx.session.sessionProject.id, modes[data.mode_type].value);
  216. if (detailCount > 0 && !checked) {
  217. throw '已存在对应模块的详情,无法关闭该模块';
  218. }
  219. const mode = modes[data.mode_type];
  220. if (mode.checked === checked) {
  221. throw '已选中该模块,无须重复选中';
  222. }
  223. mode.checked = checked;
  224. } else if (paymentConst.setting_modes[data.mode_type]) {
  225. modes[data.mode_type] = ctx.helper._.cloneDeep(paymentConst.setting_modes[data.mode_type]);
  226. modes[data.mode_type].checked = checked;
  227. } else {
  228. throw '该模块不存在';
  229. }
  230. await ctx.service.project.defaultUpdate({ id: ctx.session.sessionProject.id, payment_setting: JSON.stringify(modes) });
  231. break;
  232. default: throw '参数有误';
  233. }
  234. // 先获取你创建的标段及参与的标段
  235. const tenderList = await ctx.service.paymentTender.getList(ctx.session.sessionUser.accountId, auditPermission);
  236. // 获取你创建的目录及对应目录下的所有目录
  237. const folderList = await ctx.service.paymentFolder.getList(ctx.session.sessionUser.accountId, tenderList, auditPermission);
  238. responseData.data.folderList = ctx.helper._.orderBy(folderList, ['in_time'], ['asc']);
  239. responseData.data.tenderList = ctx.helper._.orderBy(tenderList, ['in_time'], ['asc']);
  240. ctx.body = responseData;
  241. } catch (err) {
  242. this.log(err);
  243. ctx.body = { err: 1, msg: err.toString(), data: null };
  244. }
  245. }
  246. async setting(ctx) {
  247. try {
  248. if (!ctx.session.sessionUser.is_admin) {
  249. throw '您无权打开此页';
  250. }
  251. const projectInfo = await ctx.service.project.getDataById(ctx.session.sessionProject.id);
  252. const modes = projectInfo.payment_setting ? JSON.parse(projectInfo.payment_setting) : ctx.helper._.cloneDeep(paymentConst.setting_modes);
  253. for (const m in modes) {
  254. const detailCount = await ctx.service.paymentDetail.getCountByPidType(ctx.session.sessionProject.id, modes[m].value);
  255. modes[m].can_check = !detailCount;
  256. }
  257. const renderData = {
  258. setting_modes: paymentConst.setting_modes,
  259. modes,
  260. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.payment.setting),
  261. };
  262. await this.layout('payment/setting.ejs', renderData);
  263. } catch (err) {
  264. console.log(err);
  265. this.log(err);
  266. ctx.session.postError = err.toString();
  267. ctx.redirect('/payment');
  268. }
  269. }
  270. /**
  271. * 获取审批界面所需的 原报、审批人数据等
  272. * @param ctx
  273. * @return {Promise<void>}
  274. * @private
  275. */
  276. async _getDetailAuditViewData(ctx) {
  277. const times = ctx.detail.status === auditConst.status.checkNo ? ctx.detail.times - 1 : ctx.detail.times;
  278. ctx.detail.user = await ctx.service.projectAccount.getAccountInfoById(ctx.detail.uid);
  279. ctx.detail.auditHistory = [];
  280. if (times >= 1) {
  281. for (let i = 1; i <= times; i++) {
  282. ctx.detail.auditHistory.push(await ctx.service.paymentDetailAudit.getAuditors(ctx.detail.id, i));
  283. }
  284. }
  285. // 获取审批流程中左边列表
  286. ctx.detail.auditors2 = ctx.detail.status === auditConst.status.checkNo && ctx.detail.uid !== ctx.session.sessionUser.accountId ?
  287. await ctx.service.paymentDetailAudit.getAuditorsWithOwner(ctx.detail.id, times) :
  288. await ctx.service.paymentDetailAudit.getAuditorsWithOwner(ctx.detail.id, ctx.detail.times);
  289. if (ctx.detail.status === auditConst.status.uncheck || ctx.detail.status === auditConst.status.checkNo) {
  290. ctx.detail.auditorList = await ctx.service.paymentDetailAudit.getAuditors(ctx.detail.id, ctx.detail.times);
  291. }
  292. // 是否已验证手机短信
  293. const pa = await ctx.service.projectAccount.getDataById(ctx.session.sessionUser.accountId);
  294. ctx.detail.authMobile = pa.auth_mobile;
  295. }
  296. /**
  297. * 支付表单页面
  298. *
  299. * @param {Object} ctx - egg全局页面
  300. * @return {void}
  301. */
  302. async detail(ctx) {
  303. try {
  304. await this._getDetailAuditViewData(ctx);
  305. // 报表信息实时更新
  306. if (ctx.trInfo.uid === ctx.session.sessionUser.accountId && ctx.trInfo.is_del === 0 && ctx.trInfo.rpt_id &&
  307. (ctx.detail.status === auditConst.status.uncheck || ctx.detail.status === auditConst.status.checkNo)) {
  308. const rptTpl = await ctx.service.rptTpl.getDataById(ctx.trInfo.rpt_id);
  309. if (rptTpl) {
  310. const pageRst = await ctx.service.jpcReport.getAllPreviewPagesCommon(rptTpl, 'A4');
  311. const rptMsg = pageRst.items[0];
  312. // 判断与原有的报表审批人列表是否有区别
  313. let difference = false;
  314. let auditDifference = false;
  315. let needChange = false;
  316. if (ctx.trInfo.report_items_json) {
  317. const report_items_json = JSON.parse(ctx.trInfo.report_items_json);
  318. const items = ['cells', 'signature_audit_cells', 'signature_cells', 'signature_date_cells', 'interact_cells'];
  319. for (const item of items) {
  320. if (report_items_json[item] &&
  321. !ctx.helper._.isEmpty(ctx.helper._.differenceWith(JSON.parse(JSON.stringify(rptMsg[item])), report_items_json[item], ctx.helper._.isEqual))) {
  322. // 因为interact_cells里存在undefind值,必须先用JSON.parse和JSON.stringify转义才能对比
  323. difference = true;
  324. needChange = true;
  325. if (item === 'signature_cells') {
  326. auditDifference = true;
  327. }
  328. // break;
  329. }
  330. }
  331. } else {
  332. difference = true;
  333. }
  334. if (difference) {
  335. // 删除rpt_audit重新配置
  336. const updateData = {
  337. id: ctx.trInfo.id,
  338. report_items_json: JSON.stringify(ctx.helper._.cloneDeep(rptMsg)),
  339. };
  340. // 删除rpt_audit重新配置
  341. if (auditDifference) {
  342. updateData.rpt_audit = null;
  343. ctx.trInfo.rpt_audit = null;
  344. }
  345. if (needChange) {
  346. updateData.is_change = 1;
  347. ctx.trInfo.is_change = 1;
  348. }
  349. await ctx.service.paymentTenderRpt.defaultUpdate(updateData);
  350. ctx.trInfo.report_items_json = rptMsg;
  351. }
  352. }
  353. }
  354. const auditIdList = ctx.helper._.map(ctx.detail.auditors, 'aid');
  355. const rptAuditIdList = ctx.helper._.map(ctx.detail.rptAudits, 'uid');
  356. const uidList = ctx.helper._.uniq([...auditIdList, ...rptAuditIdList]);
  357. // 获取附件列表
  358. const attList = await ctx.service.paymentDetailAtt.getPaymentDetailAttachment(ctx.detail.id, 'desc');
  359. const renderData = {
  360. trInfo: ctx.trInfo,
  361. paymentConst,
  362. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.payment.detail),
  363. auditConst,
  364. shenpiConst,
  365. attList,
  366. moment,
  367. whiteList: ctx.app.config.multipart.whitelist,
  368. uidList,
  369. preUrl: '/payment/' + ctx.paymentTender.id + '/detail/' + ctx.detail.id,
  370. OSS_PATH: ctx.app.config.fujianOssPath,
  371. };
  372. renderData.nextDetail = await ctx.service.paymentDetail.getDataByCondition({ tr_id: ctx.trInfo.id, order: ctx.detail.order + 1 });
  373. let report_json = JSON.parse(ctx.detail.report_json);
  374. const content = [];
  375. // 获取当前报表人
  376. const rptAudit = await ctx.service.paymentRptAudit.getDataByCondition({ td_id: ctx.detail.id, uid: ctx.session.sessionUser.accountId });
  377. if (report_json && report_json.items[0].interact_cells.length > 0) {
  378. for (const [i, cell] of report_json.items[0].interact_cells.entries()) {
  379. cell.index = i;
  380. }
  381. const numberList = ctx.helper._.filter(report_json.items[0].interact_cells, { DataType: 'intact_type_number' });
  382. for (const [i, cell] of report_json.items[0].interact_cells.entries()) {
  383. if (cell.Label.indexOf('大写') !== -1 && cell.link === undefined) {
  384. if (numberList.length > 0) {
  385. const numberInfo = ctx.helper._.find(ctx.helper._.orderBy(numberList, ['index'], ['desc']), function(item) {
  386. return item.index < i;
  387. });
  388. cell.link = numberInfo ? numberInfo.index : '';
  389. } else {
  390. cell.link = '';
  391. }
  392. }
  393. const push_item = {
  394. type: paymentConst.rpt_dataType[cell.DataType],
  395. value: cell.Prefix ? ctx.helper._.replace(cell.Value, cell.Prefix, '') : cell.Value,
  396. label: cell.Label,
  397. index: i,
  398. };
  399. if (cell.link !== undefined) push_item.link = cell.link;
  400. const thisBandName = paymentConst.rpt_band_name[cell.BandName] ? cell.BandName : 'content';
  401. const oneShowContent = ctx.helper._.find(content, { BandName: thisBandName });
  402. if (oneShowContent) {
  403. oneShowContent.items.push(push_item);
  404. } else {
  405. content.push({
  406. BandName: thisBandName,
  407. title: paymentConst.rpt_band_name[thisBandName],
  408. items: [push_item],
  409. });
  410. }
  411. }
  412. renderData.numberList = numberList;
  413. if (rptAudit && ((ctx.detail.status !== auditConst.status.checkNo && ctx.detail.status !== auditConst.status.checked) ||
  414. (ctx.detail.status === auditConst.status.checked && !renderData.nextDetail) ||
  415. (ctx.detail.status === auditConst.status.checkNo && ctx.detail.uid === ctx.session.sessionUser.accountId))) {
  416. // 获取个人签字,单位章,个人章地址
  417. const userInfo = await ctx.service.projectAccount.getDataById(ctx.session.sessionUser.accountId);
  418. const stampPathList = userInfo.stamp_path ? userInfo.stamp_path.split('!;!') : [];
  419. const companyInfo = userInfo.company ? await ctx.service.constructionUnit.getDataByCondition({ pid: ctx.session.sessionProject.id, name: userInfo.company }) : {};
  420. if (rptAudit.signature_msg) {
  421. const sign_msg = JSON.parse(rptAudit.signature_msg);
  422. report_json = await ctx.service.paymentDetail.signOneSignatureData(report_json, rptAudit.signature_name, sign_msg);
  423. rptAudit.signature_msg = sign_msg;
  424. } else {
  425. rptAudit.signature_msg = paymentConst.signature_msg;
  426. rptAudit.signature_msg.sign_path = userInfo.sign_path ? userInfo.sign_path : '';
  427. }
  428. renderData.signPath = userInfo.sign_path ? userInfo.sign_path : '';
  429. renderData.stampPathList = stampPathList;
  430. renderData.currentStamp = rptAudit && rptAudit.signature_msg.stamp_path ? rptAudit.signature_msg.stamp_path : (stampPathList.length > 0 ? stampPathList[0] : '');
  431. renderData.companyStamp = companyInfo && companyInfo.sign_path ? companyInfo.sign_path : '';
  432. }
  433. }
  434. renderData.rptAudit = rptAudit;
  435. renderData.content = content;
  436. renderData.report_json = report_json;
  437. if ((ctx.detail.status === auditConst.status.uncheck || ctx.detail.status === auditConst.status.checkNo) && ctx.session.sessionUser.accountId === ctx.detail.uid) {
  438. // data.accountGroup = accountGroup;
  439. // 获取所有项目参与者
  440. const accountList = await ctx.service.projectAccount.getAllDataByCondition({
  441. where: { project_id: ctx.session.sessionProject.id, enable: 1 },
  442. columns: ['id', 'name', 'company', 'role', 'enable', 'is_admin', 'account_group', 'mobile'],
  443. });
  444. renderData.accountList = accountList;
  445. const unitList = await ctx.service.constructionUnit.getAllDataByCondition({ where: { pid: ctx.session.sessionProject.id } });
  446. const accountGroupList = unitList.map(item => {
  447. const groupList = accountList.filter(item1 => item1.company === item.name);
  448. return { groupName: item.name, groupList };
  449. });
  450. renderData.accountGroup = accountGroupList;
  451. }
  452. await this.layout('payment/detail.ejs', renderData, 'payment/detail_modal.ejs');
  453. } catch (err) {
  454. console.log(err);
  455. this.log(err);
  456. ctx.session.postError = err.toString();
  457. if (ctx.detail.tender_id && ctx.detail.tr_id) {
  458. ctx.redirect('/payment' + ctx.detail.tender_id + '/list/' + ctx.detail.tr_id);
  459. }
  460. ctx.redirect(this.menu.menu.dashboard.url);
  461. }
  462. }
  463. async detailSave(ctx) {
  464. try {
  465. const data = JSON.parse(ctx.request.body.data);
  466. if (!data.type) {
  467. throw '提交数据错误';
  468. }
  469. // 检查权限等
  470. if (ctx.detail.uid !== ctx.session.sessionUser.accountId && data.type !== 'update_sign') {
  471. throw '您无权操作';
  472. }
  473. if (data.type !== 'update_sign' && ctx.detail.status !== auditConst.status.uncheck && ctx.detail.status !== auditConst.status.checkNo) {
  474. throw '您无权操作';
  475. }
  476. const responseData = {
  477. err: 0, msg: '', data: {},
  478. };
  479. switch (data.type) {
  480. case 'update_rpt':
  481. responseData.data = await ctx.service.paymentDetail.updateReportJson(ctx.detail.id, data.report_json);
  482. break;
  483. case 'update_sign':
  484. if (ctx.detail.status === auditConst.status.checked) {
  485. // 判断是否存在下一期,是则无法签章
  486. const detailMsg = await ctx.service.paymentDetail.getDataByCondition({ tr_id: ctx.detail.tr_id, order: ctx.detail.order + 1 });
  487. if (detailMsg) {
  488. throw '您无法操作签字/签章';
  489. }
  490. }
  491. responseData.data = await ctx.service.paymentRptAudit.updateSignatureMsg(ctx.detail.id, ctx.session.sessionUser.accountId, data.signature_msg);
  492. break;
  493. case 'add_audit':
  494. const auditorId = this.app._.toInteger(data.auditorId);
  495. if (isNaN(auditorId) || auditorId <= 0) {
  496. throw '参数错误';
  497. }
  498. ctx.detail.auditorList = await ctx.service.paymentDetailAudit.getAuditors(ctx.detail.id, ctx.detail.times);
  499. // 检查审核人是否已存在
  500. const exist = this.app._.find(ctx.detail.auditorList, { aid: auditorId });
  501. if (exist) {
  502. throw '该审核人已存在,请勿重复添加';
  503. }
  504. const shenpiInfo = await ctx.service.paymentShenpiAudit.getDataByCondition({ tr_id: ctx.trInfo.id, sp_status: shenpiConst.sp_status.gdzs });
  505. const is_gdzs = shenpiInfo && ctx.trInfo.sp_status === shenpiConst.sp_status.gdzs ? 1 : 0;
  506. const result = await ctx.service.paymentDetailAudit.addAuditor(ctx.detail.id, auditorId, ctx.detail.times, is_gdzs);
  507. if (!result) {
  508. throw '添加审核人失败';
  509. }
  510. responseData.data = await ctx.service.paymentDetailAudit.getAuditorsWithOwner(ctx.detail.id, ctx.detail.times);
  511. break;
  512. case 'del_audit':
  513. const auditorId2 = data.auditorId instanceof Number ? data.auditorId : this.app._.toNumber(data.auditorId);
  514. if (isNaN(auditorId2) || auditorId2 <= 0) {
  515. throw '参数错误';
  516. }
  517. const result2 = await ctx.service.paymentDetailAudit.deleteAuditor(ctx.detail.id, auditorId2, ctx.detail.times);
  518. if (!result2) {
  519. throw '移除审核人失败';
  520. }
  521. responseData.data = await ctx.service.paymentDetailAudit.getAuditors(ctx.detail.id, ctx.detail.times);
  522. break;
  523. case 'follow_rpt_audit':
  524. if (ctx.trInfo.shenpi_status === shenpiConst.sp_status.gdspl) {
  525. throw '当前表单已设置为固定审批流,无法同步';
  526. }
  527. const result3 = await ctx.service.paymentDetailAudit.followAuditByRptAudit(ctx.detail);
  528. if (!result3) {
  529. throw '同步表单角色失败';
  530. }
  531. responseData.data = await ctx.service.paymentDetailAudit.getAuditorsWithOwner(ctx.detail.id, ctx.detail.times);
  532. break;
  533. default: throw '参数有误';
  534. }
  535. ctx.body = responseData;
  536. } catch (err) {
  537. this.log(err);
  538. ctx.body = { err: 1, msg: err.toString(), data: null };
  539. }
  540. }
  541. async deleteDetail(ctx) {
  542. try {
  543. const detail_id = ctx.request.body.detail_id;
  544. const detailInfo = await ctx.service.paymentDetail.getDataById(detail_id);
  545. if (!detailInfo) {
  546. throw '所选报表表单详情已删除';
  547. }
  548. // 获取最新的期数
  549. const detail_highOrder = await ctx.service.paymentDetail.count({
  550. tr_id: detailInfo.tr_id,
  551. });
  552. 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) {
  553. throw '您无权删除所选报表表单详情';
  554. }
  555. const result = await ctx.service.paymentDetail.deleteDetail(detail_id);
  556. if (!result) {
  557. throw '删除报表表单详情失败,请重试';
  558. }
  559. ctx.redirect('/payment/' + ctx.paymentTender.id + '/list/' + detailInfo.tr_id);
  560. } catch (err) {
  561. this.log(err);
  562. ctx.session.postError = err.toString();
  563. ctx.redirect(ctx.request.header.referer);
  564. }
  565. }
  566. /**
  567. * 期审批流程(Get)
  568. * @param ctx
  569. * @return {Promise<void>}
  570. */
  571. async detailAuditors(ctx) {
  572. try {
  573. const responseData = {
  574. err: 0, msg: '', data: {},
  575. };
  576. const order = JSON.parse(ctx.request.body.data).order;
  577. const tr_id = ctx.params.trid;
  578. const detailInfo = await ctx.service.paymentDetail.getDataByCondition({ tr_id, order });
  579. // 获取审批流程中右边列表
  580. const auditHistory = [];
  581. const times = detailInfo.status === auditConst.status.checkNo ? detailInfo.times - 1 : detailInfo.times;
  582. if (times >= 1) {
  583. for (let i = 1; i <= times; i++) {
  584. auditHistory.push(await ctx.service.paymentDetailAudit.getAuditors(detailInfo.id, i));
  585. }
  586. }
  587. responseData.data.auditHistory = auditHistory;
  588. // 获取审批流程中左边列表
  589. responseData.data.auditors = await ctx.service.paymentDetailAudit.getAuditorsWithOwner(detailInfo.id, times);
  590. responseData.data.user = await ctx.service.projectAccount.getAccountInfoById(detailInfo.uid);
  591. ctx.body = responseData;
  592. } catch (error) {
  593. this.log(error);
  594. ctx.body = { err: 1, msg: error.toString(), data: null };
  595. }
  596. }
  597. async _returnRptProjectList(ctx, formProcess = false) {
  598. // 获取报表表单列表
  599. if (ctx.payment.auditPermission.view_all || ctx.paymentTender.uid === ctx.session.sessionUser.accountId || formProcess) {
  600. const rptProject = await ctx.service.rptTreeNode.getDataByCondition({ pid: ctx.session.sessionProject.id, name: '01.支付审批报表' });
  601. const rptProjectList = [];
  602. const newRptList = rptProject && rptProject.items ? JSON.parse(rptProject.items) : [];
  603. ctx.rptListNum = 0;
  604. await this.getNewRptProjectList(ctx, newRptList, rptProjectList, 1);
  605. const tenderRptList = await ctx.service.paymentTenderRpt.getProcessList(ctx.paymentTender.id);
  606. if (tenderRptList === -1) {
  607. throw '未配置表单设置,请联系管理员处理';
  608. }
  609. return await ctx.service.paymentTenderRpt.checkAndUpdateList(tenderRptList, rptProjectList, formProcess);
  610. }
  611. return await ctx.service.paymentTenderRpt.getList(ctx.paymentTender.id, ctx.session.sessionUser.accountId);
  612. }
  613. // 循环获取到到rptProject
  614. async getNewRptProjectList(ctx, newRptList, rptProjectList, level = 1) {
  615. if (newRptList.length > 0) {
  616. for (const r of newRptList) {
  617. r.level = level;
  618. r.index = ctx.rptListNum;
  619. ctx.rptListNum = ctx.rptListNum + 1;
  620. rptProjectList.push(r);
  621. if (r.items && r.items.length > 0) {
  622. await this.getNewRptProjectList(ctx, r.items, rptProjectList, level + 1);
  623. }
  624. }
  625. }
  626. }
  627. async process(ctx) {
  628. try {
  629. if (!ctx.payment.auditPermission || !ctx.payment.auditPermission.admin || !(ctx.session.sessionUser.is_admin || ctx.paymentTender.uid === ctx.session.sessionUser.accountId)) {
  630. throw '权限不足';
  631. }
  632. let [tenderRptList, rptProjectList] = await this._returnRptProjectList(ctx, true);
  633. const safeRpt = tenderRptList.find(x => { return x.type === 1 });
  634. tenderRptList = ctx.helper._.filter(tenderRptList, { type: 0, is_del: 0 });
  635. // for (const tr of tenderRptList) {
  636. // if (tr.status === shenpiConst.sp_status.gdspl) {
  637. // tr.auditList = await ctx.service.paymentShenpiAudit.getAuditList(ctx.tender.id, tr.id, tr.sp_status);
  638. // } else if (tr.status === shenpiConst.sp_status.gdzs) {
  639. // tr.audit = await ctx.service.paymentShenpiAudit.getAudit(ctx.tender.id, tr.id, tr.sp_status);
  640. // }
  641. // }
  642. // 获取所有项目参与者
  643. const accountList = await ctx.service.projectAccount.getAllDataByCondition({
  644. where: { project_id: ctx.session.sessionProject.id, enable: 1 },
  645. columns: ['id', 'name', 'company', 'role', 'enable', 'is_admin', 'account_group', 'mobile'],
  646. });
  647. const unitList = await ctx.service.constructionUnit.getAllDataByCondition({ where: { pid: ctx.session.sessionProject.id } });
  648. const accountGroupList = unitList.map(item => {
  649. const groupList = accountList.filter(item1 => item1.company === item.name);
  650. return { groupName: item.name, groupList };
  651. });
  652. const renderData = {
  653. tender: ctx.paymentTender,
  654. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.payment.process),
  655. safeRpt,
  656. rptProjectList,
  657. tenderRptList,
  658. shenpi: shenpiConst,
  659. accountList,
  660. accountGroup: accountGroupList,
  661. };
  662. await this.layout('payment/process.ejs', renderData, 'payment/process_modal.ejs');
  663. } catch (err) {
  664. console.log(err);
  665. this.log(err);
  666. ctx.session.postError = err.toString();
  667. ctx.redirect(this.request && this.request.headers && this.request.headers.referer ? this.request.headers.referer : '/payment');
  668. }
  669. }
  670. async processSave(ctx) {
  671. try {
  672. if (!ctx.payment.auditPermission || !ctx.payment.auditPermission.admin) {
  673. throw '权限不足';
  674. }
  675. const responseData = {
  676. err: 0, msg: '', data: {},
  677. };
  678. const data = JSON.parse(ctx.request.body.data);
  679. if (!data.type) {
  680. throw '提交数据错误';
  681. }
  682. switch (data.type) {
  683. case 'add-rpt':
  684. responseData.data = await ctx.service.paymentTenderRpt.setRpt(ctx.paymentTender.id, data.rpt_list);
  685. break;
  686. case 'change-status':
  687. responseData.data = await ctx.service.paymentTenderRpt.setStatus(data.tr_id, data.status);
  688. break;
  689. case 'get-audits':
  690. responseData.data = await ctx.service.paymentShenpiAudit.getShenpiAudit(data.tr_id, data.status);
  691. break;
  692. case 'add-audit':
  693. responseData.data = await ctx.service.paymentShenpiAudit.addAudit(data);
  694. break;
  695. case 'del-audit':
  696. responseData.data = await ctx.service.paymentShenpiAudit.removeAudit(data);
  697. break;
  698. case 'update-report':
  699. responseData.data = await ctx.service.paymentTenderRpt.updateReport(data);
  700. break;
  701. default: throw '参数有误';
  702. }
  703. ctx.body = responseData;
  704. } catch (err) {
  705. this.log(err);
  706. ctx.body = { err: 1, msg: err.toString(), data: null };
  707. }
  708. }
  709. async rptList(ctx) {
  710. try {
  711. const tenderRptList = await this._returnRptProjectList(ctx);
  712. if (tenderRptList === -1) {
  713. throw '未配置表单设置,请联系管理员处理';
  714. }
  715. if (tenderRptList.length === 0) {
  716. throw '未配置表单设置,请联系管理员处理';
  717. }
  718. for (const tr of tenderRptList) {
  719. tr.have_notice = await ctx.service.paymentDetail.haveNotice2TenderRpt(tr.id, ctx.session.sessionUser.accountId);
  720. }
  721. const trid = ctx.params.trid ? parseInt(ctx.params.trid) : 0;
  722. const trInfo = trid ? ctx.helper._.find(tenderRptList, { id: trid }) : tenderRptList[0];
  723. if (!trInfo) {
  724. throw '该模块已关闭或未进行表单审批设置';
  725. }
  726. // 获取列表
  727. const trDetailList = await ctx.service.paymentDetail.getValidDetails(trInfo.id);
  728. const accountList = await ctx.service.projectAccount.getAllDataByCondition({
  729. where: { project_id: ctx.session.sessionProject.id, enable: 1 },
  730. columns: ['id', 'name', 'company', 'role', 'enable', 'is_admin', 'account_group', 'mobile'],
  731. });
  732. if (trDetailList.length > 0) {
  733. for (const s of trDetailList) {
  734. // s.curAuditor = null;
  735. // 根据期状态返回展示用户
  736. s.curAuditor = await ctx.service.paymentDetailAudit.getAuditorByStatus(s.id, s.status, s.times);
  737. const userInfo = ctx.helper._.find(accountList, { id: s.uid });
  738. s.user_name = userInfo ? userInfo.name : '';
  739. }
  740. trDetailList[0].emptySign = await ctx.service.paymentRptAudit.haveEmptySign(trDetailList[0].id);
  741. }
  742. const renderData = {
  743. tender: ctx.paymentTender,
  744. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.payment.list),
  745. tenderRptList,
  746. trInfo,
  747. trDetailList,
  748. rptMsg: null,
  749. auditConst,
  750. accountGroup: [],
  751. accountList: [],
  752. paymentConst,
  753. preUrl: '/payment/' + ctx.paymentTender.id + '/list/' + trInfo.id,
  754. };
  755. // 获取报表信息,新增时及设置报表角色时使用
  756. if (trInfo.uid === ctx.session.sessionUser.accountId && trInfo.is_del === 0 && trInfo.rpt_id) {
  757. const rptTpl = await ctx.service.rptTpl.getDataById(trInfo.rpt_id);
  758. if (rptTpl) {
  759. const pageRst = await ctx.service.jpcReport.getAllPreviewPagesCommon(rptTpl, 'A4');
  760. renderData.rptMsg = pageRst.items[0];
  761. // 判断与原有的报表审批人列表是否有区别
  762. let difference = false;
  763. let auditDifference = false;
  764. let needChange = false;
  765. if (trInfo.report_items_json) {
  766. const report_items_json = JSON.parse(trInfo.report_items_json);
  767. const items = ['cells', 'signature_audit_cells', 'signature_cells', 'signature_date_cells', 'interact_cells'];
  768. for (const item of items) {
  769. if (report_items_json[item] &&
  770. !ctx.helper._.isEmpty(ctx.helper._.differenceWith(JSON.parse(JSON.stringify(renderData.rptMsg[item])), report_items_json[item], ctx.helper._.isEqual))) {
  771. // 因为interact_cells里存在undefind值,必须先用JSON.parse和JSON.stringify转义才能对比
  772. difference = true;
  773. needChange = true;
  774. if (item === 'signature_cells') {
  775. auditDifference = true;
  776. }
  777. // break;
  778. }
  779. }
  780. } else {
  781. difference = true;
  782. }
  783. if (difference) {
  784. // 删除rpt_audit重新配置
  785. const updateData = {
  786. id: trInfo.id,
  787. report_items_json: JSON.stringify(ctx.helper._.cloneDeep(renderData.rptMsg)),
  788. };
  789. // 删除rpt_audit重新配置
  790. if (auditDifference) {
  791. updateData.rpt_audit = null;
  792. trInfo.rpt_audit = null;
  793. }
  794. if (needChange) {
  795. updateData.is_change = 1;
  796. trInfo.is_change = 1;
  797. }
  798. await ctx.service.paymentTenderRpt.defaultUpdate(updateData);
  799. trInfo.report_items_json = renderData.rptMsg;
  800. }
  801. if (trInfo.rpt_audit) {
  802. trInfo.rpt_audit = JSON.parse(trInfo.rpt_audit);
  803. const prjAccList = await ctx.service.projectAccount.getAllAccountByProjectId(ctx.session.sessionProject.id);
  804. for (const audit of trInfo.rpt_audit) {
  805. if (audit.uid) {
  806. const info = ctx.helper._.find(prjAccList, { id: audit.uid });
  807. audit.name = info.name;
  808. }
  809. }
  810. } else {
  811. trInfo.rpt_audit = [];
  812. for (const sc of renderData.rptMsg.signature_cells) {
  813. trInfo.rpt_audit.push({
  814. uid: null,
  815. rpt_name: sc.signature_name,
  816. });
  817. }
  818. }
  819. renderData.trInfo = trInfo;
  820. }
  821. if (renderData.rptMsg) {
  822. // 获取所有项目参与者
  823. const accountList = await ctx.service.projectAccount.getAllDataByCondition({
  824. where: { project_id: ctx.session.sessionProject.id, enable: 1 },
  825. columns: ['id', 'name', 'company', 'role', 'enable', 'is_admin', 'account_group', 'mobile'],
  826. });
  827. const unitList = await ctx.service.constructionUnit.getAllDataByCondition({ where: { pid: ctx.session.sessionProject.id } });
  828. const accountGroupList = unitList.map(item => {
  829. const groupList = accountList.filter(item1 => item1.company === item.name);
  830. return { groupName: item.name, groupList };
  831. });
  832. renderData.accountList = accountList;
  833. renderData.accountGroup = accountGroupList;
  834. }
  835. }
  836. await this.layout('payment/list.ejs', renderData, 'payment/list_modal.ejs');
  837. } catch (err) {
  838. console.log(err);
  839. this.log(err);
  840. ctx.session.postError = err.toString();
  841. ctx.redirect(this.request && this.request.headers && this.request.headers.referer ? this.request.headers.referer : '/payment');
  842. }
  843. }
  844. async rptSave(ctx) {
  845. try {
  846. const tr_id = ctx.params.trid;
  847. if (!tr_id) {
  848. throw '参数有误';
  849. }
  850. const trInfo = await ctx.service.paymentTenderRpt.getDataById(tr_id);
  851. if (!trInfo) {
  852. throw '标段报表不存在';
  853. }
  854. if (ctx.session.sessionUser.accountId !== trInfo.uid) {
  855. throw '权限不足';
  856. }
  857. const responseData = {
  858. err: 0, msg: '', data: {},
  859. };
  860. const data = JSON.parse(ctx.request.body.data);
  861. if (!data.type) {
  862. throw '提交数据错误';
  863. }
  864. switch (data.type) {
  865. case 'rpt_audit':
  866. responseData.data = await ctx.service.paymentTenderRpt.updateRptAudit(trInfo, data.rpt_audit);
  867. break;
  868. case 'add-detail':
  869. responseData.data = await ctx.service.paymentDetail.addDetail(trInfo, data.code, data.s_time);
  870. break;
  871. default: throw '参数有误';
  872. }
  873. ctx.body = responseData;
  874. } catch (err) {
  875. this.log(err);
  876. ctx.body = { err: 1, msg: err.toString(), data: null };
  877. }
  878. }
  879. /**
  880. * 上报和重新上报
  881. * @param ctx
  882. * @return {Promise<void>}
  883. */
  884. async startAudit(ctx) {
  885. try {
  886. if (ctx.detail.uid !== ctx.session.sessionUser.accountId) {
  887. throw '您无权上报报表表单详情数据';
  888. }
  889. if (ctx.detail.status === auditConst.status.checking || ctx.detail.status === auditConst.status.checked) {
  890. throw '该报表表单详情数据当前无法上报';
  891. }
  892. await ctx.service.paymentDetailAudit.start(ctx.detail.id, ctx.detail.times);
  893. ctx.redirect(ctx.request.header.referer);
  894. } catch (err) {
  895. this.log(err);
  896. ctx.session.postError = err.toString();
  897. ctx.redirect(ctx.request.header.referer);
  898. }
  899. }
  900. /**
  901. * 审批
  902. * @param ctx
  903. * @return {Promise<void>}
  904. */
  905. async checkAudit(ctx) {
  906. try {
  907. if (!ctx.detail || ctx.detail.status !== auditConst.status.checking) {
  908. throw '当前报表表单详情数据有误';
  909. }
  910. if (!ctx.detail.curAuditor || ctx.detail.curAuditor.aid !== ctx.session.sessionUser.accountId) {
  911. throw '您无权进行该操作';
  912. }
  913. const data = {
  914. checkType: parseInt(ctx.request.body.checkType),
  915. opinion: ctx.request.body.opinion,
  916. };
  917. if (!data.checkType || isNaN(data.checkType)) {
  918. throw '提交数据错误';
  919. }
  920. if (data.checkType === auditConst.status.checkNo) {
  921. if (!data.checkType || isNaN(data.checkType)) {
  922. throw '提交数据错误';
  923. }
  924. }
  925. await ctx.service.paymentDetailAudit.check(ctx.detail.id, data, ctx.detail.times);
  926. ctx.redirect(ctx.request.header.referer);
  927. } catch (err) {
  928. this.log(err);
  929. ctx.session.postError = err.toString();
  930. ctx.redirect(ctx.request.header.referer);
  931. }
  932. }
  933. /**
  934. * 上传附件
  935. * @param {Object} ctx - egg全局变量
  936. * @return {void}
  937. */
  938. async uploadDetailFile(ctx) {
  939. const responseData = {
  940. err: 0,
  941. msg: '',
  942. data: [],
  943. };
  944. let stream;
  945. try {
  946. const parts = ctx.multipart({ autoFields: true });
  947. const files = [];
  948. let index = 0;
  949. const extra_upload = ctx.detail.status === auditConst.status.checked;
  950. const original_data = {
  951. tender_id: ctx.paymentTender.id,
  952. tr_id: ctx.trInfo.id,
  953. td_id: ctx.detail.id,
  954. }
  955. while ((stream = await parts()) !== undefined) {
  956. // 判断用户是否选择上传文件
  957. if (!stream.filename) {
  958. throw '请选择上传的文件!';
  959. }
  960. const fileInfo = path.parse(stream.filename);
  961. const create_time = Date.parse(new Date()) / 1000;
  962. const filepath = `app/public/upload/payment/${original_data.tender_id}/detail/fujian_${create_time + index.toString() + fileInfo.ext}`;
  963. await ctx.app.fujianOss.put(ctx.app.config.fujianOssFolder + filepath, stream);
  964. await sendToWormhole(stream);
  965. // 保存数据到att表
  966. const fileData = {
  967. upload_time: new Date(),
  968. filename: fileInfo.name,
  969. fileext: fileInfo.ext,
  970. filesize: Array.isArray(parts.field.size) ? parts.field.size[index] : parts.field.size,
  971. filepath,
  972. extra_upload,
  973. };
  974. const result = await ctx.service.paymentDetailAtt.save(original_data, fileData, ctx.session.sessionUser.accountId);
  975. if (!result) {
  976. throw '导入数据库保存失败';
  977. }
  978. fileData.uid = ctx.session.sessionUser.accountId;
  979. fileData.id = result.insertId;
  980. fileData.orginpath = ctx.app.config.fujianOssPath + filepath;
  981. delete fileData.filepath;
  982. if (!ctx.helper.canPreview(fileData.fileext)) {
  983. fileData.filepath = `/payment/${original_data.tender_id}/detail/${original_data.td_id}/file/${fileData.id}/download`;
  984. } else {
  985. fileData.filepath = ctx.app.config.fujianOssPath + filepath;
  986. }
  987. files.push(fileData);
  988. ++index;
  989. }
  990. responseData.data = files;
  991. } catch (err) {
  992. this.log(err);
  993. // 失败需要消耗掉stream 以防卡死
  994. if (stream) {
  995. await sendToWormhole(stream);
  996. }
  997. this.setMessage(err.toString(), this.messageType.ERROR);
  998. }
  999. ctx.body = responseData;
  1000. }
  1001. /**
  1002. * 下载附件
  1003. * @param {Object} ctx - egg全局变量
  1004. * @return {void}
  1005. */
  1006. async downloadDetailFile(ctx) {
  1007. const id = ctx.params.fid;
  1008. if (id) {
  1009. try {
  1010. const fileInfo = await ctx.service.paymentDetailAtt.getDataById(id);
  1011. if (fileInfo !== undefined && fileInfo !== '') {
  1012. // 解决中文无法下载问题
  1013. const userAgent = (ctx.request.header['user-agent'] || '').toLowerCase();
  1014. let disposition = '';
  1015. if (userAgent.indexOf('msie') >= 0 || userAgent.indexOf('chrome') >= 0) {
  1016. disposition = 'attachment; filename=' + encodeURIComponent(fileInfo.filename + fileInfo.fileext);
  1017. } else if (userAgent.indexOf('firefox') >= 0) {
  1018. disposition = 'attachment; filename*="utf8\'\'' + encodeURIComponent(fileInfo.filename + fileInfo.fileext) + '"';
  1019. } else {
  1020. /* safari等其他非主流浏览器只能自求多福了 */
  1021. disposition = 'attachment; filename=' + new Buffer(fileInfo.filename + fileInfo.fileext).toString('binary');
  1022. }
  1023. ctx.response.set({
  1024. 'Content-Type': 'application/octet-stream',
  1025. 'Content-Disposition': disposition,
  1026. 'Content-Length': fileInfo.filesize,
  1027. });
  1028. // ctx.body = await fs.createReadStream(fileName);
  1029. ctx.body = await ctx.helper.ossFileGet(fileInfo.filepath);
  1030. } else {
  1031. throw '不存在该文件';
  1032. }
  1033. } catch (err) {
  1034. this.log(err);
  1035. this.setMessage(err.toString(), this.messageType.ERROR);
  1036. }
  1037. }
  1038. }
  1039. /**
  1040. * 删除附件
  1041. * @param {Object} ctx - egg全局变量
  1042. * @return {void}
  1043. */
  1044. async deleteDetailFile(ctx) {
  1045. const responseData = {
  1046. err: 0,
  1047. msg: '',
  1048. data: '',
  1049. };
  1050. try {
  1051. const data = JSON.parse(ctx.request.body.data);
  1052. const fileInfo = await ctx.service.paymentDetailAtt.getDataById(data.id);
  1053. if (!fileInfo || !Object.keys(fileInfo).length) {
  1054. throw '该文件不存在';
  1055. }
  1056. if (!fileInfo.extra_upload && ctx.detail.status === auditConst.status.checked) {
  1057. throw '无权限删除';
  1058. }
  1059. if (fileInfo !== undefined && fileInfo !== '') {
  1060. // 先删除文件
  1061. await ctx.app.fujianOss.delete(ctx.app.config.fujianOssFolder + fileInfo.filepath);
  1062. // 再删除数据库
  1063. await ctx.service.paymentDetailAtt.deleteById(data.id);
  1064. responseData.data = '';
  1065. } else {
  1066. throw '不存在该文件';
  1067. }
  1068. } catch (err) {
  1069. responseData.err = 1;
  1070. responseData.msg = err;
  1071. }
  1072. ctx.body = responseData;
  1073. }
  1074. async safeBills(ctx) {
  1075. try {
  1076. await this._getDetailAuditViewData(ctx);
  1077. const auditIdList = ctx.helper._.map(ctx.detail.auditors, 'aid');
  1078. const rptAuditIdList = ctx.helper._.map(ctx.detail.rptAudits, 'uid');
  1079. const uidList = ctx.helper._.uniq([...auditIdList, ...rptAuditIdList]);
  1080. // 获取附件列表
  1081. const attList = await ctx.service.paymentDetailAtt.getPaymentDetailAttachment(ctx.detail.id, 'desc');
  1082. const stdBills = await ctx.service.stdGclList.getSafeGcl();
  1083. const renderData = {
  1084. trInfo: ctx.trInfo,
  1085. paymentConst,
  1086. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.payment.safe),
  1087. auditConst,
  1088. shenpiConst,
  1089. attList,
  1090. moment,
  1091. whiteList: ctx.app.config.multipart.whitelist,
  1092. uidList,
  1093. preUrl: '/payment/' + ctx.paymentTender.id + '/detail/' + ctx.detail.id,
  1094. OSS_PATH: ctx.app.config.fujianOssPath,
  1095. stdBills,
  1096. };
  1097. renderData.nextDetail = await ctx.service.paymentDetail.getDataByCondition({ tr_id: ctx.trInfo.id, order: ctx.detail.order + 1 });
  1098. const content = [];
  1099. renderData.content = content;
  1100. if ((ctx.detail.status === auditConst.status.uncheck || ctx.detail.status === auditConst.status.checkNo) && ctx.session.sessionUser.accountId === ctx.detail.uid) {
  1101. // 获取所有项目参与者
  1102. const accountList = await ctx.service.projectAccount.getAllDataByCondition({
  1103. where: { project_id: ctx.session.sessionProject.id, enable: 1 },
  1104. columns: ['id', 'name', 'company', 'role', 'enable', 'is_admin', 'account_group', 'mobile'],
  1105. });
  1106. renderData.accountList = accountList;
  1107. const unitList = await ctx.service.constructionUnit.getAllDataByCondition({ where: { pid: ctx.session.sessionProject.id } });
  1108. const accountGroupList = unitList.map(item => {
  1109. const groupList = accountList.filter(item1 => item1.company === item.name);
  1110. return { groupName: item.name, groupList };
  1111. });
  1112. renderData.accountGroup = accountGroupList;
  1113. }
  1114. await this.layout('payment_safe/index.ejs', renderData, 'payment_safe/modal.ejs');
  1115. } catch (err) {
  1116. this.log(err);
  1117. this.ctx.postError(err, '读取安全生产费错误');
  1118. if (ctx.detail.tender_id && ctx.detail.tr_id) {
  1119. ctx.redirect('/payment' + ctx.detail.tender_id + '/list');
  1120. } else {
  1121. ctx.redirect(this.menu.menu.dashboard.url);
  1122. }
  1123. }
  1124. }
  1125. async safeCompare(ctx) {
  1126. try {
  1127. const renderData = {
  1128. trInfo: ctx.trInfo,
  1129. paymentConst,
  1130. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.payment.compare),
  1131. auditConst,
  1132. };
  1133. await this.layout('payment_safe/compare.ejs', renderData);
  1134. } catch (err) {
  1135. this.log(err);
  1136. this.ctx.postError(err, '读取安全生产费错误');
  1137. if (ctx.detail.tender_id && ctx.detail.tr_id) {
  1138. ctx.redirect('/payment' + ctx.detail.tender_id + '/list');
  1139. } else {
  1140. ctx.redirect(this.menu.menu.dashboard.url);
  1141. }
  1142. }
  1143. }
  1144. async safeLoad(ctx) {
  1145. try {
  1146. const data = JSON.parse(ctx.request.body.data);
  1147. const filter = data.filter.split(';');
  1148. const responseData = { err: 0, msg: '', data: {}, hpack: [] };
  1149. for (const f of filter) {
  1150. switch (f) {
  1151. case 'bills':
  1152. responseData.data.bills = ctx.detail.readOnly
  1153. ? await ctx.service.paymentSafeBills.getReadData(ctx.detail)
  1154. : await ctx.service.paymentSafeBills.getEditData(ctx.detail);
  1155. break;
  1156. case 'billsCompare':
  1157. responseData.data[f] = await ctx.service.paymentSafeBills.getCompareData(ctx.detail);
  1158. break;
  1159. case 'auditFlow':
  1160. responseData.data[f] = await ctx.service.paymentDetailAudit.getViewFlow(ctx.detail);
  1161. break;
  1162. default:
  1163. responseData.data[f] = [];
  1164. break;
  1165. }
  1166. }
  1167. ctx.body = responseData;
  1168. } catch (err) {
  1169. this.log(err);
  1170. ctx.body = { err: 1, msg: err.toString(), data: null };
  1171. }
  1172. }
  1173. async _billsBase(detail, type, data) {
  1174. if (isNaN(data.id) || data.id <= 0) throw '数据错误';
  1175. if (type !== 'add') {
  1176. if (isNaN(data.count) || data.count <= 0) data.count = 1;
  1177. }
  1178. switch (type) {
  1179. case 'add':
  1180. return await this.ctx.service.paymentSafeBills.addSafeBillsNode(detail, data.id, data.count);
  1181. case 'delete':
  1182. return await this.ctx.service.paymentSafeBills.delete(detail.id, data.id, data.count);
  1183. case 'up-move':
  1184. return await this.ctx.service.paymentSafeBills.upMoveNode(detail.id, data.id, data.count);
  1185. case 'down-move':
  1186. return await this.ctx.service.paymentSafeBills.downMoveNode(detail.id, data.id, data.count);
  1187. case 'up-level':
  1188. return await this.ctx.service.paymentSafeBills.upLevelNode(detail.id, data.id, data.count);
  1189. case 'down-level':
  1190. return await this.ctx.service.paymentSafeBills.downLevelNode(detail.id, data.id, data.count);
  1191. }
  1192. }
  1193. async safeUpdate(ctx) {
  1194. try {
  1195. const data = JSON.parse(ctx.request.body.data);
  1196. if (!data.postType || !data.postData) throw '数据错误';
  1197. const responseData = { err: 0, msg: '', data: {} };
  1198. switch (data.postType) {
  1199. case 'add':
  1200. case 'delete':
  1201. case 'up-move':
  1202. case 'down-move':
  1203. case 'up-level':
  1204. case 'down-level':
  1205. responseData.data = await this._billsBase(ctx.detail, data.postType, data.postData);
  1206. break;
  1207. case 'update':
  1208. responseData.data = await this.ctx.service.paymentSafeBills.updateCalc(ctx.detail, data.postData);
  1209. break;
  1210. case 'add-std':
  1211. responseData.data = await this.ctx.service.paymentSafeBills.addStdNodeWithParent(ctx.detail, data.postData.id, data.postData.stdData);
  1212. break;
  1213. default:
  1214. throw '未知操作';
  1215. }
  1216. ctx.body = responseData;
  1217. } catch (err) {
  1218. this.log(err);
  1219. ctx.body = this.ajaxErrorBody(err, '数据错误');
  1220. }
  1221. }
  1222. }
  1223. return PaymentController;
  1224. };