report_archive_controller.js 44 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879
  1. 'use strict';
  2. /**
  3. * Created by Tony on 2021/3/31.
  4. */
  5. const path = require('path');
  6. const uuidV1 = require('uuid').v1;
  7. const fs = require('fs');
  8. const MAX_ARCHIVE = 3;
  9. const tenderMenu = require('../../config/menu').tenderMenu;
  10. const measureType = require('../const/tender').measureType;
  11. const fsUtil = require('../public/js/fsUtil');
  12. const auditConst = require('../const/audit');
  13. const signConst = require('../const/sign');
  14. const shenpiConst = require('../const/shenpi');
  15. const accountGroup = require('../const/account_group').group;
  16. const sendToWormhole = require('stream-wormhole');
  17. const pushOperate = require('../const/spec_3f').pushOperate;
  18. module.exports = app => {
  19. class ReportArchiveController extends app.BaseController {
  20. /**
  21. * 获取审批界面所需的 原报、审批人数据等
  22. * @param ctx
  23. * @return {Promise<void>}
  24. * @private
  25. */
  26. async _getStageAuditViewData(ctx) {
  27. if (!ctx.stage) return;
  28. await ctx.service.stage.loadStageAuditViewData(ctx.stage);
  29. }
  30. async index(ctx) {
  31. await this._getStageAuditViewData(ctx);
  32. const tender = ctx.tender;
  33. const stage = ctx.stage;
  34. let stage_id = -1;
  35. let stage_order = -1;
  36. let stage_times = -1;
  37. let stage_status = -1;
  38. const treeNodes = await ctx.service.rptTreeNode.getNodesByProjectId([-1, tender.data.project_id]);
  39. const custTreeNodes = await ctx.service.rptTreeNodeCust.getCustFoldersByUserId(this.ctx.session.sessionUser.accountId);
  40. const stageList = await ctx.service.stage.getValidStagesShort(tender.id);
  41. const isAdmin = ctx.session.sessionUser.is_admin;
  42. //
  43. // 。。。
  44. let archiveList = [];
  45. let archiveEncryptionList = [];
  46. // console.log('tender.data.project_id: ' + tender.data.project_id);
  47. if (stage) {
  48. // console.log('ctx.stage.id: ' + ctx.stage.id);
  49. const archives = await ctx.service.rptArchive.getPrjStgArchive(tender.data.project_id, ctx.stage.id);
  50. const archiveEncryptions = await ctx.service.rptArchiveEncryption.getPrjStgArchiveEncryption(tender.data.project_id, ctx.stage.id);
  51. stage_id = stage.id;
  52. stage_order = stage.order;
  53. stage_times = stage.times;
  54. stage_status = stage.status;
  55. if (archives.length > 0) {
  56. archiveList = JSON.parse(archives[0].content);
  57. }
  58. if (archiveEncryptions.length > 0) {
  59. archiveEncryptionList = JSON.parse(archiveEncryptions[0].content);
  60. }
  61. } else if (stageList.length > 0 && stageList[0].status === auditConst.stage.status.checked) {
  62. // console.log('stageList[0].id: ' + stageList[0].id);
  63. let archives = [];
  64. for (let sidx = stageList.length - 1; sidx >= 0; sidx--) {
  65. if (stageList[sidx].status === 3) {
  66. archives = await ctx.service.rptArchive.getPrjStgArchive(tender.data.project_id, stageList[sidx].id);
  67. ctx.stage = stageList[sidx]; // 为了sub menu用
  68. break;
  69. }
  70. }
  71. ctx.stage = ctx.stage ? ctx.stage : stageList[stageList.length - 1];
  72. // const archives = await ctx.service.rptArchive.getPrjStgArchive(tender.data.project_id, stageList[stageList.length - 1].id);
  73. const archiveEncryptions = await ctx.service.rptArchiveEncryption.getPrjStgArchiveEncryption(tender.data.project_id, ctx.stage.id);
  74. // stage_id = stageList[0].id;
  75. // stage_order = stageList[0].order;
  76. // stage_times = stageList[0].times;
  77. // stage_status = stageList[0].status;
  78. if (archives && archives.length > 0) {
  79. archiveList = JSON.parse(archives[0].content);
  80. }
  81. if (archiveEncryptions && archiveEncryptions.length > 0) {
  82. archiveEncryptionList = JSON.parse(archiveEncryptions[0].content);
  83. }
  84. }
  85. let rpt_tpl_items = '{ customize: [], common: [] }';
  86. if (custTreeNodes.length > 0) {
  87. rpt_tpl_items = custTreeNodes[0].rpt_tpl_items;
  88. }
  89. // 获取用户权限
  90. const accountInfo = await this.ctx.service.projectAccount.getDataById(this.ctx.session.sessionUser.accountId);
  91. // 获取所有项目参与者
  92. const accountList = await ctx.service.projectAccount.getAllDataByCondition({
  93. where: { project_id: ctx.session.sessionProject.id, enable: 1 },
  94. columns: ['id', 'name', 'company', 'role', 'enable', 'is_admin', 'account_group', 'mobile'],
  95. });
  96. const newAccountGroup = accountGroup.map((item, idx) => {
  97. const groupList = accountList.filter(item => item.account_group === idx);
  98. return { groupName: item, groupList };
  99. });
  100. const needFileMsg = await this.ctx.service.specMsg.tenderNeedMsg(this.ctx.session.sessionProject.id, this.ctx.tender.id, pushOperate.report.file);
  101. //
  102. const renderData = {
  103. tender: tender.data,
  104. rpt_tpl_data: JSON.stringify(treeNodes),
  105. cust_tpl_data: rpt_tpl_items,
  106. project_id: tender.data.project_id,
  107. tender_id: tender.id,
  108. stg_id: stage_id,
  109. stg_order: stage_order,
  110. stg_times: stage_times,
  111. stg_status: stage_status,
  112. stage_list: stageList.length > 0 && stageList[0].status === auditConst.stage.status.checked ? JSON.stringify(stageList) : JSON.stringify([]),
  113. tenderMenu,
  114. measureType,
  115. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.report.main),
  116. stages: stageList,
  117. auditConst: auditConst.stage,
  118. archiveList,
  119. archiveEncryptionList,
  120. can_netcasign: false,
  121. ossPath: signConst.path.oss,
  122. shenpiConst,
  123. preUrl: '/tender/' + ctx.tender.id + '/measure/stage/' + ctx.params.order,
  124. authMobile: accountInfo.auth_mobile,
  125. accountGroup: newAccountGroup,
  126. accountList,
  127. isAdmin,
  128. needFileMsg,
  129. auditType: auditConst.auditType,
  130. };
  131. if (stage_id === -1) {
  132. await this.layout('report/index_archive.ejs', renderData, 'report/archive_popup.ejs');
  133. } else {
  134. await this.layout('report/index_archive.ejs', renderData, 'report/stage_archive_modal.ejs');
  135. }
  136. }
  137. async getReportArchive(ctx) {
  138. const params = JSON.parse(ctx.request.body.params);
  139. // ctx.body = await this._getReport(ctx, params);
  140. const archives = await ctx.service.rptArchive.getPrjStgArchive(params.prjId, params.stgId);
  141. const archiveEncryptions = await ctx.service.rptArchiveEncryption.getPrjStgArchiveEncryption(params.prjId, params.stgId);
  142. let archiveList = [];
  143. let archiveEncryptionList = [];
  144. if (archives.length > 0) {
  145. archiveList = JSON.parse(archives[0].content);
  146. }
  147. if (archiveEncryptions.length > 0) {
  148. archiveEncryptionList = JSON.parse(archiveEncryptions[0].content);
  149. }
  150. const lastAuditor = await ctx.service.stageAudit.getLastestAuditor(params.stgId, params.stgTimes, auditConst.stage.status.checked);
  151. ctx.body = {
  152. data: archiveList,
  153. encryptionData: archiveEncryptionList,
  154. lastAuditor,
  155. };
  156. }
  157. async _updateReportArchiveAdhocInfo(ctx, params) {
  158. const userId = ctx.session.sessionUser.accountId;
  159. const prjId = params.prjId;
  160. const stgId = params.stgId;
  161. const rptId = params.rptId;
  162. const ttlPgs = params.ttlPgs;
  163. const uuid = params.uuid;
  164. const reportName = params.reportName;
  165. const reportAreas = params.signatureAreas;
  166. // 这里要更新zh_rpt_archive表的相关数据
  167. const orgArchiveList = await ctx.service.rptArchive.getPrjStgArchive(prjId, stgId);
  168. if (orgArchiveList.length > 0) {
  169. const contentArr = JSON.parse(orgArchiveList[0].content);
  170. for (const item of contentArr) {
  171. if (parseInt(item.rpt_id) === parseInt(rptId)) {
  172. for (const rptItem of item.items) {
  173. if (rptItem.uuid === uuid) {
  174. rptItem.uid = userId;
  175. rptItem.reportName = reportName;
  176. rptItem.ttl_pages = ttlPgs;
  177. rptItem.signature_area = reportAreas;
  178. break;
  179. }
  180. }
  181. break;
  182. }
  183. }
  184. const updatedRst = await ctx.service.rptArchive.updateArchive(orgArchiveList[0].id, prjId, stgId, contentArr);
  185. } else {
  186. // 正常情况下不可能的分支
  187. }
  188. }
  189. async addReportArchiveEncryption(ctx) {
  190. const params = JSON.parse(ctx.request.body.params);
  191. const prjId = params.prjId;
  192. const stgId = params.stgId;
  193. const rptId = params.rptId;
  194. const ttlPgs = params.ttlPgs;
  195. const uuid = params.uuid;
  196. const removeUuid = params.removeUuid;
  197. const childUuids = params.childUuids;
  198. const splitArcPages = params.splitArcPages;
  199. const reportName = params.reportName;
  200. const userId = ctx.session.sessionUser.accountId;
  201. const content = params.content;
  202. const orgArchiveList = await ctx.service.rptArchiveEncryption.getPrjStgArchiveEncryption(prjId, stgId);
  203. if (orgArchiveList.length > 0) {
  204. const contentArr = JSON.parse(orgArchiveList[0].content);
  205. let hasArchive = false;
  206. for (const item of contentArr) {
  207. if (item.rpt_id === rptId) {
  208. // 考虑到报表模板的稳定性,只保留一项来记录位置就足够了,都不考虑用uuid了
  209. if (item.uuid === uuid) {
  210. // 最后打脸了,还真的要考虑不同的uuid,不早说,TNND
  211. item.encryption = content;
  212. item.total_page = ttlPgs;
  213. item.user_id = userId;
  214. item.report_name = reportName;
  215. item.childUuids = childUuids;
  216. item.splitArcPages = splitArcPages;
  217. hasArchive = true;
  218. break;
  219. }
  220. }
  221. }
  222. if (!hasArchive) {
  223. // 表示有新的要加, 有加有减
  224. for (let idx = contentArr.length - 1; idx >= 0; idx--) {
  225. if (contentArr[idx].uuid === removeUuid) {
  226. contentArr.splice(idx, 1);
  227. break;
  228. }
  229. }
  230. contentArr.push({ rpt_id: rptId, uuid, total_page: ttlPgs, encryption: content, user_id: userId, report_name: reportName, childUuids, splitArcPages });
  231. } else {
  232. //
  233. }
  234. const updatedRst = await ctx.service.rptArchiveEncryption.updateArchiveEncryption(orgArchiveList[0].id, prjId, stgId, contentArr);
  235. // console.log(updatedRst);
  236. ctx.body = { err: 0, msg: '', data: { addedRst: contentArr } };
  237. } else {
  238. // 需要增加
  239. const archiveArr = [];
  240. archiveArr.push({ rpt_id: rptId, uuid, total_page: ttlPgs, encryption: content, user_id: userId, report_name: reportName, childUuids, splitArcPages });
  241. const addedRst = await ctx.service.rptArchiveEncryption.createArchiveEncryption(prjId, stgId, archiveArr);
  242. // console.log(addedRst);
  243. ctx.body = { err: 0, msg: '', data: { addedRst: archiveArr } };
  244. }
  245. }
  246. async _updateArchiveCommon(ctx, prjId, stgId, rptId, parentUuidName, childUuids) {
  247. const updateDate = new Date();
  248. const montStr = (updateDate.getMonth() + 1) < 10 ? ('0' + (updateDate.getMonth() + 1)) : (updateDate.getMonth() + 1);
  249. const dateStr = (updateDate.getDate()) < 10 ? ('0' + updateDate.getDate()) : (updateDate.getDate());
  250. let hrStr = '' + updateDate.getHours();
  251. if (hrStr.length === 1) hrStr = '0' + hrStr;
  252. let minStr = '' + updateDate.getMinutes();
  253. if (minStr.length === 1) minStr = '0' + minStr;
  254. let secStr = '' + updateDate.getSeconds();
  255. if (secStr.length === 1) secStr = '0' + secStr;
  256. const dtStr = `${updateDate.getFullYear()}-${montStr}-${dateStr} ${hrStr}:${minStr}:${secStr}`;
  257. let rst = null;
  258. const fileName = parentUuidName + '.PDF';
  259. let removeUuid = ''; // 因这里把增删功能做在一起,有可能要删除一个旧的uuid,需要返回,给加密处理用
  260. const orgArchiveList = await ctx.service.rptArchive.getPrjStgArchive(prjId, stgId);
  261. if (orgArchiveList.length > 0) {
  262. const contentArr = JSON.parse(orgArchiveList[0].content);
  263. let hasArchive = false;
  264. for (const item of contentArr) {
  265. if (item.rpt_id === rptId) {
  266. hasArchive = true;
  267. let updateRmIdx = -1;
  268. for (let idx = 0; idx < item.items.length; idx++) {
  269. if (parentUuidName === item.items[idx].uuid) {
  270. // 这里的判断是否是update archive逻辑(是否存在相同uuid的item)
  271. updateRmIdx = idx;
  272. break;
  273. }
  274. }
  275. if (updateRmIdx < 0 && item.items.length >= MAX_ARCHIVE) {
  276. updateRmIdx = 0;
  277. for (let idx = 1; idx < item.items.length; idx++) {
  278. if (item.items[updateRmIdx].updateDate_time > item.items[idx].updateDate_time) {
  279. updateRmIdx = idx;
  280. }
  281. }
  282. }
  283. if (updateRmIdx >= 0) {
  284. // 删除oss文件
  285. removeUuid = item.items[updateRmIdx].uuid;
  286. await ctx.app.signPdfOss.delete(`archive/${item.items[updateRmIdx].uuid}.PDF`);
  287. // 以及删除子oss文件
  288. if (item.items[updateRmIdx].childUuids && item.items[updateRmIdx].childUuids.length > 0) {
  289. for (const childUuid of item.items[updateRmIdx].childUuids) {
  290. let uuid = '';
  291. if (typeof childUuid === 'string') {
  292. uuid = childUuid;
  293. } else {
  294. uuid = childUuid.uuid;
  295. }
  296. await ctx.app.signPdfOss.delete(`archive/${uuid}.PDF`);
  297. }
  298. }
  299. item.items.splice(updateRmIdx, 1);
  300. }
  301. const newItem = { uuid: parentUuidName, updateDate_time: dtStr, childUuids };
  302. item.items.push(newItem);
  303. break;
  304. }
  305. }
  306. if (!hasArchive) {
  307. // 表示有新的模板需要添加
  308. contentArr.push({ rpt_id: rptId, items: [{ uuid: parentUuidName, updateDate_time: dtStr, childUuids }] });
  309. }
  310. const updatedRst = await ctx.service.rptArchive.updateArchive(orgArchiveList[0].id, prjId, stgId, contentArr);
  311. // console.log(updatedRst);
  312. rst = { err: 0, msg: parentUuidName, data: { uuid: parentUuidName, childUuids, removeUuid, fileName, updateDate, updatedRst: contentArr } };
  313. } else {
  314. // 需要增加
  315. const archiveArr = [];
  316. archiveArr.push({ rpt_id: rptId, items: [{ uuid: parentUuidName, updateDate_time: dtStr, childUuids }] });
  317. const addedRst = await ctx.service.rptArchive.createArchive(prjId, stgId, archiveArr);
  318. rst = { err: 0, msg: parentUuidName, data: { uuid: parentUuidName, childUuids, removeUuid, fileName, updateDate, updatedRst: archiveArr } };
  319. }
  320. return rst;
  321. }
  322. async addParentChildrenArchiveReports(ctx) {
  323. // 接收多个子母PDF
  324. let stream;
  325. try {
  326. const prjId = ctx.params.prjId;
  327. const stgId = ctx.params.stgId;
  328. const rptId = ctx.params.rptId;
  329. // const childAmt = parseInt(ctx.params.childAmt); // 子分页数量
  330. const childInfo = ctx.params.splitInfo.split(';'); // 这个参数带比较多的信息,包含分割指标的:1. 名称 2. ID 3. 内容
  331. const splitArcPages = JSON.parse(childInfo[0]);
  332. // console.log(splitArcPages);
  333. const childAmt = splitArcPages.length;
  334. const splitFieldObj = JSON.parse(childInfo[1]);
  335. const ttlPages = parseInt(childInfo[2]); // 总页数
  336. // console.log(splitFieldObj);
  337. const parentUuid = uuidV1();
  338. const childUuids = [];
  339. // const newUuidName = uuidV1();
  340. const parts = ctx.multipart({ autoFields: true });
  341. stream = await parts();
  342. let index = 0;
  343. while (stream !== undefined) {
  344. /*
  345. // 测试保存文件
  346. await ctx.helper.saveStreamFile(stream, path.join(this.app.baseDir, 'app/public/upload/', stream.filename));
  347. await sendToWormhole(stream);
  348. //*/
  349. let fileName = parentUuid + '.PDF';
  350. if (index > 0) {
  351. const cUuid = uuidV1();
  352. const startPage = splitArcPages[index - 1];
  353. // const endPage = splitArcPages[index - 1];
  354. let endPage = ttlPages;
  355. if (index < splitArcPages.length) {
  356. endPage = splitArcPages[index] - 1;
  357. }
  358. childUuids.push({ uuid: cUuid, totalPages: (endPage - startPage + 1), startPage, endPage, splitKeyValue: splitFieldObj.splitPageValues[index - 1] });
  359. fileName = cUuid + '.PDF';
  360. }
  361. const oss_result = await ctx.app.signPdfOss.put('archive/' + fileName, stream);
  362. if (!(oss_result && oss_result.url && oss_result.res.status === 200)) {
  363. throw '上传文件失败';
  364. }
  365. await sendToWormhole(stream);
  366. ++index;
  367. if (index <= childAmt) {
  368. stream = await parts();
  369. } else {
  370. stream = undefined;
  371. }
  372. // stream = await parts();
  373. }
  374. const body = await this._updateArchiveCommon(ctx, prjId, stgId, rptId, parentUuid, childUuids);
  375. ctx.body = body;
  376. } catch (error) {
  377. ctx.helper.log(error);
  378. // 失败需要消耗掉stream 以防卡死
  379. if (stream) {
  380. await sendToWormhole(stream);
  381. }
  382. ctx.body = this.ajaxErrorBody(error, '上传附件失败,请重试');
  383. }
  384. }
  385. async addReportArchive(ctx) {
  386. try {
  387. const stream = await ctx.getFileStream();
  388. const prjId = ctx.params.prjId;
  389. const stgId = ctx.params.stgId;
  390. const rptId = ctx.params.rptId;
  391. const newUuidName = uuidV1();
  392. const fileName = newUuidName + '.PDF';
  393. const oss_result = await ctx.app.signPdfOss.put('archive/' + fileName, stream);
  394. if (!(oss_result && oss_result.url && oss_result.res.status === 200)) {
  395. throw '上传文件失败';
  396. }
  397. const body = await this._updateArchiveCommon(ctx, prjId, stgId, rptId, newUuidName, []);
  398. ctx.body = body;
  399. } catch (err) {
  400. this.log(err);
  401. ctx.body = { err: 1, msg: err.toString(), data: null };
  402. }
  403. }
  404. async updateReportArchiveEncryption(ctx) {
  405. // 在add方法中已经处理
  406. await this.addReportArchiveEncryption(ctx);
  407. }
  408. async updateReportArchive(ctx) {
  409. try {
  410. const stream = await ctx.getFileStream();
  411. const prjId = ctx.params.prjId;
  412. const stgId = ctx.params.stgId;
  413. const rptId = ctx.params.rptId;
  414. const orgUuidName = ctx.params.orgName;
  415. const orgFileName = orgUuidName + '.PDF';
  416. const newUuidName = uuidV1();
  417. const fileName = newUuidName + '.PDF'; // 要用新的uuid!!!
  418. console.log('updating fileName: ' + fileName);
  419. // await ctx.helper.saveStreamFile(stream, path.join(this.app.baseDir, 'app', 'public/archive', fileName));
  420. const oss_result = await ctx.app.signPdfOss.put('archive/' + fileName, stream);
  421. if (!(oss_result && oss_result.url && oss_result.res.status === 200)) {
  422. throw '上传文件失败';
  423. }
  424. // 判断是否存在已签名文档,存在则删除文档并删除签名记录
  425. const pdfMsg = await ctx.curl(signConst.path.oss + '/sign/' + orgUuidName + '.PDF');
  426. if (pdfMsg && pdfMsg.status === 200) {
  427. const oss_reuslt = await ctx.app.signPdfOss.delete('archive/sign/' + orgFileName);
  428. if (oss_reuslt && oss_reuslt.res && oss_reuslt.res.status === 204) {
  429. const delSign_result = await ctx.service.netcasignLog.removeSign(orgUuidName);
  430. } else {
  431. throw '删除已签文档失败';
  432. }
  433. }
  434. // const body = await this._updateArchiveCommon(ctx, prjId, stgId, rptId, orgUuidName, []);
  435. const body = await this._updateArchiveCommon(ctx, prjId, stgId, rptId, newUuidName, []); // 只管用新的uuid,此方法中会自动删除最旧的那个记录及相关PDF文档
  436. ctx.body = body;
  437. } catch (err) {
  438. this.log(err);
  439. ctx.body = { err: 1, msg: err.toString(), data: null };
  440. }
  441. }
  442. async _removeReportArchiveEncryption(ctx) {
  443. let rst = null;
  444. try {
  445. const prjId = ctx.params.prjId;
  446. const stgId = ctx.params.stgId;
  447. const rptId = parseInt(ctx.params.rptId);
  448. const uuid = ctx.params.orgName;
  449. const orgArchiveList = await ctx.service.rptArchiveEncryption.getPrjStgArchiveEncryption(prjId, stgId);
  450. if (orgArchiveList.length > 0) {
  451. const contentArr = JSON.parse(orgArchiveList[0].content);
  452. for (let idx = contentArr.length - 1; idx >= 0; idx--) {
  453. if (contentArr[idx].rpt_id === rptId && contentArr[idx].uuid === uuid) {
  454. contentArr.splice(idx, 1);
  455. break;
  456. }
  457. }
  458. // const updatedRst = await ctx.service.rptArchive.updateArchive(prjId, stgId, contentArr);
  459. rst = await ctx.service.rptArchiveEncryption.updateArchiveEncryption(orgArchiveList[0].id, prjId, stgId, contentArr);
  460. }
  461. } catch (err) {
  462. this.log(err);
  463. }
  464. return rst;
  465. }
  466. async removeReportArchiveEncryption(ctx) {
  467. try {
  468. const rst = await this._removeReportArchiveEncryption(ctx);
  469. if (rst) {
  470. ctx.body = { err: 0, msg: '', data: { updatedRst: rst } };
  471. } else {
  472. ctx.body = { err: 0, msg: '', data: { updatedRst: null } };
  473. }
  474. } catch (err) {
  475. this.log(err);
  476. ctx.body = { err: 1, msg: err.toString(), data: null };
  477. }
  478. }
  479. async _removeReportArchive(ctx) {
  480. let rst = null;
  481. try {
  482. const prjId = ctx.params.prjId;
  483. const stgId = ctx.params.stgId;
  484. const rptId = ctx.params.rptId;
  485. const orgUuidName = ctx.params.orgName;
  486. // const fileName = orgUuidName + '.PDF';
  487. const orgArchiveList = await ctx.service.rptArchive.getPrjStgArchive(prjId, stgId);
  488. if (orgArchiveList.length > 0) {
  489. const contentArr = JSON.parse(orgArchiveList[0].content);
  490. for (let idx = contentArr.length - 1; idx >= 0; idx--) {
  491. const item = contentArr[idx];
  492. if (item.rpt_id === rptId) {
  493. if (item.items && item.items.length > 0) {
  494. for (const subIdx in item.items) {
  495. if (item.items[subIdx].uuid === orgUuidName) {
  496. if (item.items[subIdx].childUuids && item.items[subIdx].childUuids.length > 0) {
  497. // 如果有子分页,也得删除!
  498. for (const childUuid of item.items[subIdx].childUuids) {
  499. let childUuidName = '';
  500. if (typeof childUuid === 'string') {
  501. childUuidName = childUuid;
  502. } else {
  503. childUuidName = childUuid.uuid;
  504. }
  505. if (!childUuidName.includes('.PDF')) childUuidName = childUuidName + '.PDF';
  506. await ctx.app.signPdfOss.delete(`archive/${childUuidName}`);
  507. }
  508. }
  509. item.items.splice(subIdx, 1);
  510. break;
  511. }
  512. }
  513. if (item.items.length === 0) {
  514. contentArr.splice(idx, 1);
  515. }
  516. }
  517. break;
  518. }
  519. }
  520. rst = await ctx.service.rptArchive.updateArchive(orgArchiveList[0].id, prjId, stgId, contentArr);
  521. }
  522. } catch (err) {
  523. this.log(err);
  524. }
  525. return rst;
  526. }
  527. async removeReportArchive(ctx) {
  528. try {
  529. const orgUuidName = ctx.params.orgName;
  530. const fileName = orgUuidName + '.PDF';
  531. // console.log(ctx.params);
  532. console.log('removing fileName: ' + fileName);
  533. // const fullName = path.join(this.app.baseDir, 'app', 'public/archive', fileName);
  534. const oss_sign_result = await ctx.app.signPdfOss.delete(`archive/sign/${fileName}`);
  535. if (oss_sign_result && oss_sign_result.res && oss_sign_result.res.status === 204) {
  536. // console.log('删除归档的签名信息成功!');
  537. const oss_result = await ctx.app.signPdfOss.delete(`archive/${fileName}`);
  538. if (!(oss_result && oss_result.res.status === 204)) {
  539. throw '删除归档文件失败';
  540. }
  541. } else {
  542. throw '删除归档签名文件失败';
  543. }
  544. // 还有加密签名信息
  545. const archiveSignRemovedRst = await this._removeReportArchiveEncryption(ctx);
  546. // console.log(archiveSignRemovedRst);
  547. const archiveRemovedRst = await this._removeReportArchive(ctx);
  548. if (archiveRemovedRst) {
  549. ctx.body = { err: 0, msg: orgUuidName, data: { fileName, updatedRst: archiveRemovedRst } };
  550. } else {
  551. ctx.body = { err: 0, msg: orgUuidName, data: { fileName, updatedRst: null } };
  552. }
  553. } catch (err) {
  554. this.log(err);
  555. ctx.body = { err: 1, msg: err.toString(), data: null };
  556. }
  557. }
  558. async addMultiReportArchive(ctx, params) {
  559. // 暂时不支持
  560. }
  561. async getArchivedFileByUUID(ctx) {
  562. // console.log('downloading : ' + ctx.params.uuid);
  563. const uuid = ctx.params.uuid;
  564. const rptName = ctx.params.rptName;
  565. const suffix = '.PDF';
  566. try {
  567. const rptNameURI = encodeURI(rptName);
  568. const filePath = this.app.baseDir + '/app/public/archive/';
  569. // console.log('filePath: ' + filePath);
  570. // await this.ctx.helper.recursiveMkdirSync(this.app.baseDir + '/app/public/download');
  571. ctx.set({
  572. 'Content-Type': 'application/vnd.openxmlformats',
  573. 'Content-Disposition': 'attachment; filename="' + rptNameURI + suffix + "\"; filename*=utf-8''" + rptNameURI + suffix,
  574. });
  575. ctx.body = await fs.readFileSync(filePath + uuid + suffix);
  576. } catch (e) {
  577. console.log(e);
  578. }
  579. }
  580. async pdfShow(ctx) {
  581. // const renderData = {
  582. // can_netcasign: ctx.session.sessionProject.page_show.openNetCaSign === 1,
  583. // };
  584. await ctx.render('report/archive_pdf.ejs');
  585. }
  586. /*
  587. * 网证通电子签名页,(和归档报表页高度相似)
  588. */
  589. async signReport(ctx) {
  590. const tender = ctx.tender;
  591. const stage = ctx.stage;
  592. let stage_id = -1;
  593. let stage_order = -1;
  594. let stage_times = -1;
  595. let stage_status = -1;
  596. const treeNodes = await ctx.service.rptTreeNode.getNodesByProjectId([-1, tender.data.project_id]);
  597. const custTreeNodes = await ctx.service.rptTreeNodeCust.getCustFoldersByUserId(this.ctx.session.sessionUser.accountId);
  598. const stageList = await ctx.service.stage.getValidStagesShort(tender.id);
  599. //
  600. // 。。。
  601. let archiveList = [];
  602. let archiveEncryptionList = [];
  603. // console.log('tender.data.project_id: ' + tender.data.project_id);
  604. if (stage) {
  605. // console.log('ctx.stage.id: ' + ctx.stage.id);
  606. const archives = await ctx.service.rptArchive.getPrjStgArchive(tender.data.project_id, ctx.stage.id);
  607. const archiveEncryptions = await ctx.service.rptArchiveEncryption.getPrjStgArchiveEncryption(tender.data.project_id, ctx.stage.id);
  608. stage_id = stage.id;
  609. stage_order = stage.order;
  610. stage_times = stage.times;
  611. stage_status = stage.status;
  612. if (archives.length > 0) {
  613. archiveList = JSON.parse(archives[0].content);
  614. }
  615. console.log('2:', archiveEncryptions, ctx.stage.id);
  616. if (archiveEncryptions.length > 0) {
  617. archiveEncryptionList = JSON.parse(archiveEncryptions[0].content);
  618. }
  619. } else if (stageList.length > 0 && stageList[0].status === auditConst.stage.status.checked) {
  620. // console.log('stageList[0].id: ' + stageList[0].id);
  621. // const archives = await ctx.service.rptArchive.getPrjStgArchive(tender.data.project_id, stageList[stageList.length - 1].id);
  622. let archives = [];
  623. for (let sidx = stageList.length - 1; sidx >= 0; sidx--) {
  624. if (stageList[sidx].status === 3) {
  625. archives = await ctx.service.rptArchive.getPrjStgArchive(tender.data.project_id, stageList[sidx].id);
  626. ctx.stage = stageList[sidx]; // 为了sub menu用
  627. break;
  628. }
  629. }
  630. ctx.stage = ctx.stage ? ctx.stage : stageList[stageList.length - 1];
  631. const archiveEncryptions = await ctx.service.rptArchiveEncryption.getPrjStgArchiveEncryption(tender.data.project_id, ctx.stage.id);
  632. // stage_id = stageList[0].id;
  633. // stage_order = stageList[0].order;
  634. // stage_times = stageList[0].times;
  635. // stage_status = stageList[0].status;
  636. if (archives && archives.length > 0) {
  637. archiveList = JSON.parse(archives[0].content);
  638. }
  639. if (archiveEncryptions && archiveEncryptions.length > 0) {
  640. archiveEncryptionList = JSON.parse(archiveEncryptions[0].content);
  641. }
  642. }
  643. let rpt_tpl_items = '{ customize: [], common: [] }';
  644. if (custTreeNodes.length > 0) {
  645. rpt_tpl_items = custTreeNodes[0].rpt_tpl_items;
  646. }
  647. // 获取ukey绑定数据
  648. const netcaSignData = await ctx.service.netcasign.getDataByCondition({ uid: ctx.session.sessionUser.accountId });
  649. // 获取已签名数据
  650. const signLogList = await ctx.service.netcasignLog.getLogList(ctx.tender.id);
  651. const renderData = {
  652. tender: tender.data,
  653. rpt_tpl_data: JSON.stringify(treeNodes),
  654. cust_tpl_data: rpt_tpl_items,
  655. project_id: tender.data.project_id,
  656. tender_id: tender.id,
  657. stg_id: stage_id,
  658. stg_order: stage_order,
  659. stg_times: stage_times,
  660. stg_status: stage_status,
  661. stage_list: JSON.stringify(stageList),
  662. tenderMenu,
  663. measureType,
  664. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.report.main),
  665. stages: stageList,
  666. auditConst: auditConst.stage,
  667. archiveList,
  668. archiveEncryptionList,
  669. netcaSignData,
  670. can_netcasign: ctx.session.sessionProject.page_show.openNetCaSign === 1,
  671. ossPath: signConst.path.oss,
  672. signLogList,
  673. };
  674. await this.layout('report/index_sign.ejs', renderData, 'report/index_sign_modal.ejs');
  675. }
  676. /**
  677. * 网证通电子签名接口
  678. *
  679. * @param {object} ctx - egg全局变量
  680. * @return {void}
  681. */
  682. async signPost(ctx) {
  683. const response = {
  684. err: 0,
  685. msg: '',
  686. };
  687. try {
  688. const data = JSON.parse(ctx.request.body.data);
  689. let signData;
  690. const netcaSignApi = signConst.path.api;
  691. switch (data.type) {
  692. case 'getPdfBase64':
  693. const pdfResult = await ctx.app.signPdfOss.get(data.path);
  694. if (pdfResult.res.status !== 200) {
  695. throw '该文件不存在';
  696. }
  697. response.data = Buffer.from(pdfResult.content, 'binary').toString('base64');
  698. break;
  699. case 'pdfIsExist':
  700. const pdfMsg = await ctx.app.signPdfOss.head('archive/sign/' + data.uuid + '.PDF');
  701. response.data = pdfMsg.res.status === 200;
  702. break;
  703. // 获取摘要值
  704. case 'assemblyDigest':
  705. const postData = {
  706. requestJson: JSON.stringify(data.requestJson),
  707. };
  708. const result = await ctx.helper.sendMoreRequest(netcaSignApi + '/assemblyDigest', postData, 'POST');
  709. response.data = result;
  710. break;
  711. // 生成签名pdf
  712. case 'assemblyPdf':
  713. const postData2 = {
  714. requestJson: JSON.stringify(data.requestJson),
  715. };
  716. const result3 = await this.roundNetcaSign(ctx, postData2);
  717. // const result2 = await ctx.helper.sendMoreRequest(netcaSignApi + '/assemblyPdf', postData2, 'POST');
  718. // 上传到oss
  719. // console.log(result3);
  720. if (result3.code === 0) {
  721. // const result3 = await ctx.helper.sendMoreRequest(netcaSignApi + result2.data);
  722. const oss_result = await ctx.app.signPdfOss.put('archive/sign/' + data.requestJson.fileName + '.PDF', result3.data);
  723. if (oss_result && oss_result.res && oss_result.res.status === 200) {
  724. if (data.end) {
  725. const versionId = oss_result.res.headers['x-oss-version-id'];
  726. // 记录签名和保存
  727. await ctx.service.netcasignLog.add(data.requestJson.fileName, data.role, ctx.session.sessionUser.accountId, versionId);
  728. const signLogList = await ctx.service.netcasignLog.getLogList(ctx.tender.id);
  729. response.data = signLogList;
  730. } else {
  731. // next page
  732. }
  733. } else {
  734. throw '上传文件失败';
  735. }
  736. } else {
  737. throw result3.msg;
  738. }
  739. break;
  740. // 移除签名和已签移除pdf
  741. case 'removeSign':
  742. const oss_reuslt = await ctx.app.signPdfOss.delete('archive/sign/' + data.uuid + '.PDF');
  743. if (oss_reuslt && oss_reuslt.res && oss_reuslt.res.status === 204) {
  744. const delSign_result = await ctx.service.netcasignLog.removeSign(data.uuid);
  745. const signLogList = await ctx.service.netcasignLog.getLogList(ctx.tender.id);
  746. response.data = signLogList;
  747. } else {
  748. throw '删除文件失败';
  749. }
  750. break;
  751. default:throw '参数有误';
  752. }
  753. } catch (error) {
  754. response.err = 1;
  755. response.msg = error.toString();
  756. const data = JSON.parse(ctx.request.body.data);
  757. if (data && data.type === 'pdfIsExist') {
  758. response.err = 0;
  759. response.data = false;
  760. }
  761. }
  762. ctx.body = response;
  763. }
  764. /**
  765. * 网证通电子签名报表上传
  766. *
  767. * @param {object} ctx - egg全局变量
  768. * @return {void}
  769. */
  770. async signFile(ctx) {
  771. const stream = await ctx.getFileStream();
  772. try {
  773. const uuid = stream.fields.uuid;
  774. const role = stream.fields.role;
  775. const oss_result = await ctx.app.signPdfOss.put('archive/sign/' + uuid + '.PDF', stream);
  776. if (!(oss_result && oss_result.url && oss_result.res.status === 200)) {
  777. throw '上传文件失败';
  778. }
  779. const versionId = oss_result.res.headers['x-oss-version-id'];
  780. // 记录签名和保存
  781. await ctx.service.netcasignLog.add(uuid, role, ctx.session.sessionUser.accountId, versionId);
  782. const signLogList = await ctx.service.netcasignLog.getLogList(ctx.tender.id);
  783. ctx.body = { err: 0, msg: '', data: signLogList };
  784. } catch (err) {
  785. // 必须将上传的文件流消费掉,要不然浏览器响应会卡死
  786. await sendToWormhole(stream);
  787. this.log(err);
  788. ctx.body = { err: 1, msg: err.toString(), data: null };
  789. }
  790. }
  791. async roundNetcaSign(ctx, postData2, round = 3) {
  792. let response = {
  793. code: 0,
  794. data: '',
  795. };
  796. // 无法获取到result3,因为result2生成的pdf已损坏,请重复获取result2,直到获取成功或尝试3次失败后报错为止
  797. try {
  798. const netcaSignApi = signConst.path.api;
  799. const result2 = await ctx.helper.sendMoreRequest(netcaSignApi + '/assemblyPdf', postData2, 'POST');
  800. if (result2.code === 0) {
  801. const result3 = await ctx.curl(netcaSignApi + result2.data, {
  802. timeout: 300000, // 超时 5分钟中
  803. });
  804. if (result3) {
  805. response.data = result3.data;
  806. } else {
  807. if (round > 0) {
  808. round = round - 1;
  809. response = await this.roundNetcaSign(ctx, postData2, round);
  810. } else {
  811. throw 'pdf获取失败,网证通接口无法生成pdf';
  812. }
  813. }
  814. }
  815. } catch (error) {
  816. response.code = 1;
  817. response.msg = error;
  818. }
  819. return response;
  820. }
  821. async sendFileMsg(ctx) {
  822. try {
  823. if (this.ctx.session.sessionUser.accountId !== ctx.tender.data.user_id) throw '您无权操作';
  824. const needFileMsg = await this.ctx.service.specMsg.tenderNeedMsg(this.ctx.session.sessionProject.id, this.ctx.tender.id, pushOperate.report.file);
  825. if (!needFileMsg) throw '该标段暂不可进行该操作';
  826. const waitingMsg = await this.ctx.service.specMsg.getDataByCondition({ tid: this.ctx.tender.id, timing: pushOperate.report.file, status: [0, 1] });
  827. if (waitingMsg) throw '上一次归档完成,未执行完毕,请稍后再试';
  828. const data = JSON.parse(ctx.request.body.data);
  829. const stage = await this.ctx.service.stage.getDataById(data.sid);
  830. await this.ctx.service.specMsg.addReportMsg(null, this.ctx.session.sessionProject.id, this.ctx.tender.data, stage, pushOperate.report.file);
  831. ctx.body = { err: 0, msg: '提交成功,稍后将同步至档案系统', data: null };
  832. } catch (err) {
  833. this.ctx.log(err);
  834. this.ctx.ajaxErrorBody(err, '操作失败');
  835. }
  836. }
  837. }
  838. return ReportArchiveController;
  839. };