report_archive_controller.js 44 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878
  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 fileName = orgUuidName + '.PDF';
  416. console.log('updating fileName: ' + fileName);
  417. // await ctx.helper.saveStreamFile(stream, path.join(this.app.baseDir, 'app', 'public/archive', fileName));
  418. const oss_result = await ctx.app.signPdfOss.put('archive/' + fileName, stream);
  419. if (!(oss_result && oss_result.url && oss_result.res.status === 200)) {
  420. throw '上传文件失败';
  421. }
  422. // 判断是否存在已签名文档,存在则删除文档并删除签名记录
  423. const pdfMsg = await ctx.curl(signConst.path.oss + '/sign/' + orgUuidName + '.PDF');
  424. if (pdfMsg && pdfMsg.status === 200) {
  425. const oss_reuslt = await ctx.app.signPdfOss.delete('archive/sign/' + fileName);
  426. if (oss_reuslt && oss_reuslt.res && oss_reuslt.res.status === 204) {
  427. const delSign_result = await ctx.service.netcasignLog.removeSign(orgUuidName);
  428. } else {
  429. throw '删除已签文档失败';
  430. }
  431. }
  432. const newUuidName = uuidV1();
  433. // const body = await this._updateArchiveCommon(ctx, prjId, stgId, rptId, orgUuidName, []);
  434. const body = await this._updateArchiveCommon(ctx, prjId, stgId, rptId, newUuidName, []); // 只管用新的uuid,此方法中会自动删除最旧的那个记录及相关PDF文档
  435. ctx.body = body;
  436. } catch (err) {
  437. this.log(err);
  438. ctx.body = { err: 1, msg: err.toString(), data: null };
  439. }
  440. }
  441. async _removeReportArchiveEncryption(ctx) {
  442. let rst = null;
  443. try {
  444. const prjId = ctx.params.prjId;
  445. const stgId = ctx.params.stgId;
  446. const rptId = parseInt(ctx.params.rptId);
  447. const uuid = ctx.params.orgName;
  448. const orgArchiveList = await ctx.service.rptArchiveEncryption.getPrjStgArchiveEncryption(prjId, stgId);
  449. if (orgArchiveList.length > 0) {
  450. const contentArr = JSON.parse(orgArchiveList[0].content);
  451. for (let idx = contentArr.length - 1; idx >= 0; idx--) {
  452. if (contentArr[idx].rpt_id === rptId && contentArr[idx].uuid === uuid) {
  453. contentArr.splice(idx, 1);
  454. break;
  455. }
  456. }
  457. // const updatedRst = await ctx.service.rptArchive.updateArchive(prjId, stgId, contentArr);
  458. rst = await ctx.service.rptArchiveEncryption.updateArchiveEncryption(orgArchiveList[0].id, prjId, stgId, contentArr);
  459. }
  460. } catch (err) {
  461. this.log(err);
  462. }
  463. return rst;
  464. }
  465. async removeReportArchiveEncryption(ctx) {
  466. try {
  467. const rst = await this._removeReportArchiveEncryption(ctx);
  468. if (rst) {
  469. ctx.body = { err: 0, msg: '', data: { updatedRst: rst } };
  470. } else {
  471. ctx.body = { err: 0, msg: '', data: { updatedRst: null } };
  472. }
  473. } catch (err) {
  474. this.log(err);
  475. ctx.body = { err: 1, msg: err.toString(), data: null };
  476. }
  477. }
  478. async _removeReportArchive(ctx) {
  479. let rst = null;
  480. try {
  481. const prjId = ctx.params.prjId;
  482. const stgId = ctx.params.stgId;
  483. const rptId = ctx.params.rptId;
  484. const orgUuidName = ctx.params.orgName;
  485. // const fileName = orgUuidName + '.PDF';
  486. const orgArchiveList = await ctx.service.rptArchive.getPrjStgArchive(prjId, stgId);
  487. if (orgArchiveList.length > 0) {
  488. const contentArr = JSON.parse(orgArchiveList[0].content);
  489. for (let idx = contentArr.length - 1; idx >= 0; idx--) {
  490. const item = contentArr[idx];
  491. if (item.rpt_id === rptId) {
  492. if (item.items && item.items.length > 0) {
  493. for (const subIdx in item.items) {
  494. if (item.items[subIdx].uuid === orgUuidName) {
  495. if (item.items[subIdx].childUuids && item.items[subIdx].childUuids.length > 0) {
  496. // 如果有子分页,也得删除!
  497. for (const childUuid of item.items[subIdx].childUuids) {
  498. let childUuidName = '';
  499. if (typeof childUuid === 'string') {
  500. childUuidName = childUuid;
  501. } else {
  502. childUuidName = childUuid.uuid;
  503. }
  504. if (!childUuidName.includes('.PDF')) childUuidName = childUuidName + '.PDF';
  505. await ctx.app.signPdfOss.delete(`archive/${childUuidName}`);
  506. }
  507. }
  508. item.items.splice(subIdx, 1);
  509. break;
  510. }
  511. }
  512. if (item.items.length === 0) {
  513. contentArr.splice(idx, 1);
  514. }
  515. }
  516. break;
  517. }
  518. }
  519. rst = await ctx.service.rptArchive.updateArchive(orgArchiveList[0].id, prjId, stgId, contentArr);
  520. }
  521. } catch (err) {
  522. this.log(err);
  523. }
  524. return rst;
  525. }
  526. async removeReportArchive(ctx) {
  527. try {
  528. const orgUuidName = ctx.params.orgName;
  529. const fileName = orgUuidName + '.PDF';
  530. // console.log(ctx.params);
  531. console.log('removing fileName: ' + fileName);
  532. // const fullName = path.join(this.app.baseDir, 'app', 'public/archive', fileName);
  533. const oss_sign_result = await ctx.app.signPdfOss.delete(`archive/sign/${fileName}`);
  534. if (oss_sign_result && oss_sign_result.res && oss_sign_result.res.status === 204) {
  535. // console.log('删除归档的签名信息成功!');
  536. const oss_result = await ctx.app.signPdfOss.delete(`archive/${fileName}`);
  537. if (!(oss_result && oss_result.res.status === 204)) {
  538. throw '删除归档文件失败';
  539. }
  540. } else {
  541. throw '删除归档签名文件失败';
  542. }
  543. // 还有加密签名信息
  544. const archiveSignRemovedRst = await this._removeReportArchiveEncryption(ctx);
  545. // console.log(archiveSignRemovedRst);
  546. const archiveRemovedRst = await this._removeReportArchive(ctx);
  547. if (archiveRemovedRst) {
  548. ctx.body = { err: 0, msg: orgUuidName, data: { fileName, updatedRst: archiveRemovedRst } };
  549. } else {
  550. ctx.body = { err: 0, msg: orgUuidName, data: { fileName, updatedRst: null } };
  551. }
  552. } catch (err) {
  553. this.log(err);
  554. ctx.body = { err: 1, msg: err.toString(), data: null };
  555. }
  556. }
  557. async addMultiReportArchive(ctx, params) {
  558. // 暂时不支持
  559. }
  560. async getArchivedFileByUUID(ctx) {
  561. // console.log('downloading : ' + ctx.params.uuid);
  562. const uuid = ctx.params.uuid;
  563. const rptName = ctx.params.rptName;
  564. const suffix = '.PDF';
  565. try {
  566. const rptNameURI = encodeURI(rptName);
  567. const filePath = this.app.baseDir + '/app/public/archive/';
  568. // console.log('filePath: ' + filePath);
  569. // await this.ctx.helper.recursiveMkdirSync(this.app.baseDir + '/app/public/download');
  570. ctx.set({
  571. 'Content-Type': 'application/vnd.openxmlformats',
  572. 'Content-Disposition': 'attachment; filename="' + rptNameURI + suffix + "\"; filename*=utf-8''" + rptNameURI + suffix,
  573. });
  574. ctx.body = await fs.readFileSync(filePath + uuid + suffix);
  575. } catch (e) {
  576. console.log(e);
  577. }
  578. }
  579. async pdfShow(ctx) {
  580. // const renderData = {
  581. // can_netcasign: ctx.session.sessionProject.page_show.openNetCaSign === 1,
  582. // };
  583. await ctx.render('report/archive_pdf.ejs');
  584. }
  585. /*
  586. * 网证通电子签名页,(和归档报表页高度相似)
  587. */
  588. async signReport(ctx) {
  589. const tender = ctx.tender;
  590. const stage = ctx.stage;
  591. let stage_id = -1;
  592. let stage_order = -1;
  593. let stage_times = -1;
  594. let stage_status = -1;
  595. const treeNodes = await ctx.service.rptTreeNode.getNodesByProjectId([-1, tender.data.project_id]);
  596. const custTreeNodes = await ctx.service.rptTreeNodeCust.getCustFoldersByUserId(this.ctx.session.sessionUser.accountId);
  597. const stageList = await ctx.service.stage.getValidStagesShort(tender.id);
  598. //
  599. // 。。。
  600. let archiveList = [];
  601. let archiveEncryptionList = [];
  602. // console.log('tender.data.project_id: ' + tender.data.project_id);
  603. if (stage) {
  604. // console.log('ctx.stage.id: ' + ctx.stage.id);
  605. const archives = await ctx.service.rptArchive.getPrjStgArchive(tender.data.project_id, ctx.stage.id);
  606. const archiveEncryptions = await ctx.service.rptArchiveEncryption.getPrjStgArchiveEncryption(tender.data.project_id, ctx.stage.id);
  607. stage_id = stage.id;
  608. stage_order = stage.order;
  609. stage_times = stage.times;
  610. stage_status = stage.status;
  611. if (archives.length > 0) {
  612. archiveList = JSON.parse(archives[0].content);
  613. }
  614. console.log('2:', archiveEncryptions, ctx.stage.id);
  615. if (archiveEncryptions.length > 0) {
  616. archiveEncryptionList = JSON.parse(archiveEncryptions[0].content);
  617. }
  618. } else if (stageList.length > 0 && stageList[0].status === auditConst.stage.status.checked) {
  619. // console.log('stageList[0].id: ' + stageList[0].id);
  620. // const archives = await ctx.service.rptArchive.getPrjStgArchive(tender.data.project_id, stageList[stageList.length - 1].id);
  621. let archives = [];
  622. for (let sidx = stageList.length - 1; sidx >= 0; sidx--) {
  623. if (stageList[sidx].status === 3) {
  624. archives = await ctx.service.rptArchive.getPrjStgArchive(tender.data.project_id, stageList[sidx].id);
  625. ctx.stage = stageList[sidx]; // 为了sub menu用
  626. break;
  627. }
  628. }
  629. ctx.stage = ctx.stage ? ctx.stage : stageList[stageList.length - 1];
  630. const archiveEncryptions = await ctx.service.rptArchiveEncryption.getPrjStgArchiveEncryption(tender.data.project_id, ctx.stage.id);
  631. // stage_id = stageList[0].id;
  632. // stage_order = stageList[0].order;
  633. // stage_times = stageList[0].times;
  634. // stage_status = stageList[0].status;
  635. if (archives && archives.length > 0) {
  636. archiveList = JSON.parse(archives[0].content);
  637. }
  638. if (archiveEncryptions && archiveEncryptions.length > 0) {
  639. archiveEncryptionList = JSON.parse(archiveEncryptions[0].content);
  640. }
  641. }
  642. let rpt_tpl_items = '{ customize: [], common: [] }';
  643. if (custTreeNodes.length > 0) {
  644. rpt_tpl_items = custTreeNodes[0].rpt_tpl_items;
  645. }
  646. // 获取ukey绑定数据
  647. const netcaSignData = await ctx.service.netcasign.getDataByCondition({ uid: ctx.session.sessionUser.accountId });
  648. // 获取已签名数据
  649. const signLogList = await ctx.service.netcasignLog.getLogList(ctx.tender.id);
  650. const renderData = {
  651. tender: tender.data,
  652. rpt_tpl_data: JSON.stringify(treeNodes),
  653. cust_tpl_data: rpt_tpl_items,
  654. project_id: tender.data.project_id,
  655. tender_id: tender.id,
  656. stg_id: stage_id,
  657. stg_order: stage_order,
  658. stg_times: stage_times,
  659. stg_status: stage_status,
  660. stage_list: JSON.stringify(stageList),
  661. tenderMenu,
  662. measureType,
  663. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.report.main),
  664. stages: stageList,
  665. auditConst: auditConst.stage,
  666. archiveList,
  667. archiveEncryptionList,
  668. netcaSignData,
  669. can_netcasign: ctx.session.sessionProject.page_show.openNetCaSign === 1,
  670. ossPath: signConst.path.oss,
  671. signLogList,
  672. };
  673. await this.layout('report/index_sign.ejs', renderData, 'report/index_sign_modal.ejs');
  674. }
  675. /**
  676. * 网证通电子签名接口
  677. *
  678. * @param {object} ctx - egg全局变量
  679. * @return {void}
  680. */
  681. async signPost(ctx) {
  682. const response = {
  683. err: 0,
  684. msg: '',
  685. };
  686. try {
  687. const data = JSON.parse(ctx.request.body.data);
  688. let signData;
  689. const netcaSignApi = signConst.path.api;
  690. switch (data.type) {
  691. case 'getPdfBase64':
  692. const pdfResult = await ctx.app.signPdfOss.get(data.path);
  693. if (pdfResult.res.status !== 200) {
  694. throw '该文件不存在';
  695. }
  696. response.data = Buffer.from(pdfResult.content, 'binary').toString('base64');
  697. break;
  698. case 'pdfIsExist':
  699. const pdfMsg = await ctx.app.signPdfOss.head('archive/sign/' + data.uuid + '.PDF');
  700. response.data = pdfMsg.res.status === 200;
  701. break;
  702. // 获取摘要值
  703. case 'assemblyDigest':
  704. const postData = {
  705. requestJson: JSON.stringify(data.requestJson),
  706. };
  707. const result = await ctx.helper.sendMoreRequest(netcaSignApi + '/assemblyDigest', postData, 'POST');
  708. response.data = result;
  709. break;
  710. // 生成签名pdf
  711. case 'assemblyPdf':
  712. const postData2 = {
  713. requestJson: JSON.stringify(data.requestJson),
  714. };
  715. const result3 = await this.roundNetcaSign(ctx, postData2);
  716. // const result2 = await ctx.helper.sendMoreRequest(netcaSignApi + '/assemblyPdf', postData2, 'POST');
  717. // 上传到oss
  718. // console.log(result3);
  719. if (result3.code === 0) {
  720. // const result3 = await ctx.helper.sendMoreRequest(netcaSignApi + result2.data);
  721. const oss_result = await ctx.app.signPdfOss.put('archive/sign/' + data.requestJson.fileName + '.PDF', result3.data);
  722. if (oss_result && oss_result.res && oss_result.res.status === 200) {
  723. if (data.end) {
  724. const versionId = oss_result.res.headers['x-oss-version-id'];
  725. // 记录签名和保存
  726. await ctx.service.netcasignLog.add(data.requestJson.fileName, data.role, ctx.session.sessionUser.accountId, versionId);
  727. const signLogList = await ctx.service.netcasignLog.getLogList(ctx.tender.id);
  728. response.data = signLogList;
  729. } else {
  730. // next page
  731. }
  732. } else {
  733. throw '上传文件失败';
  734. }
  735. } else {
  736. throw result3.msg;
  737. }
  738. break;
  739. // 移除签名和已签移除pdf
  740. case 'removeSign':
  741. const oss_reuslt = await ctx.app.signPdfOss.delete('archive/sign/' + data.uuid + '.PDF');
  742. if (oss_reuslt && oss_reuslt.res && oss_reuslt.res.status === 204) {
  743. const delSign_result = await ctx.service.netcasignLog.removeSign(data.uuid);
  744. const signLogList = await ctx.service.netcasignLog.getLogList(ctx.tender.id);
  745. response.data = signLogList;
  746. } else {
  747. throw '删除文件失败';
  748. }
  749. break;
  750. default:throw '参数有误';
  751. }
  752. } catch (error) {
  753. response.err = 1;
  754. response.msg = error.toString();
  755. const data = JSON.parse(ctx.request.body.data);
  756. if (data && data.type === 'pdfIsExist') {
  757. response.err = 0;
  758. response.data = false;
  759. }
  760. }
  761. ctx.body = response;
  762. }
  763. /**
  764. * 网证通电子签名报表上传
  765. *
  766. * @param {object} ctx - egg全局变量
  767. * @return {void}
  768. */
  769. async signFile(ctx) {
  770. const stream = await ctx.getFileStream();
  771. try {
  772. const uuid = stream.fields.uuid;
  773. const role = stream.fields.role;
  774. const oss_result = await ctx.app.signPdfOss.put('archive/sign/' + uuid + '.PDF', stream);
  775. if (!(oss_result && oss_result.url && oss_result.res.status === 200)) {
  776. throw '上传文件失败';
  777. }
  778. const versionId = oss_result.res.headers['x-oss-version-id'];
  779. // 记录签名和保存
  780. await ctx.service.netcasignLog.add(uuid, role, ctx.session.sessionUser.accountId, versionId);
  781. const signLogList = await ctx.service.netcasignLog.getLogList(ctx.tender.id);
  782. ctx.body = { err: 0, msg: '', data: signLogList };
  783. } catch (err) {
  784. // 必须将上传的文件流消费掉,要不然浏览器响应会卡死
  785. await sendToWormhole(stream);
  786. this.log(err);
  787. ctx.body = { err: 1, msg: err.toString(), data: null };
  788. }
  789. }
  790. async roundNetcaSign(ctx, postData2, round = 3) {
  791. let response = {
  792. code: 0,
  793. data: '',
  794. };
  795. // 无法获取到result3,因为result2生成的pdf已损坏,请重复获取result2,直到获取成功或尝试3次失败后报错为止
  796. try {
  797. const netcaSignApi = signConst.path.api;
  798. const result2 = await ctx.helper.sendMoreRequest(netcaSignApi + '/assemblyPdf', postData2, 'POST');
  799. if (result2.code === 0) {
  800. const result3 = await ctx.curl(netcaSignApi + result2.data, {
  801. timeout: 300000, // 超时 5分钟中
  802. });
  803. if (result3) {
  804. response.data = result3.data;
  805. } else {
  806. if (round > 0) {
  807. round = round - 1;
  808. response = await this.roundNetcaSign(ctx, postData2, round);
  809. } else {
  810. throw 'pdf获取失败,网证通接口无法生成pdf';
  811. }
  812. }
  813. }
  814. } catch (error) {
  815. response.code = 1;
  816. response.msg = error;
  817. }
  818. return response;
  819. }
  820. async sendFileMsg(ctx) {
  821. try {
  822. if (this.ctx.session.sessionUser.accountId !== ctx.tender.data.user_id) throw '您无权操作';
  823. const needFileMsg = await this.ctx.service.specMsg.tenderNeedMsg(this.ctx.session.sessionProject.id, this.ctx.tender.id, pushOperate.report.file);
  824. if (!needFileMsg) throw '该标段暂不可进行该操作';
  825. const waitingMsg = await this.ctx.service.specMsg.getDataByCondition({ tid: this.ctx.tender.id, timing: pushOperate.report.file, status: [0, 1] });
  826. if (waitingMsg) throw '上一次归档完成,未执行完毕,请稍后再试';
  827. const data = JSON.parse(ctx.request.body.data);
  828. const stage = await this.ctx.service.stage.getDataById(data.sid);
  829. await this.ctx.service.specMsg.addReportMsg(null, this.ctx.session.sessionProject.id, this.ctx.tender.data, stage, pushOperate.report.file);
  830. ctx.body = { err: 0, msg: '提交成功,稍后将同步至档案系统', data: null };
  831. } catch (err) {
  832. this.ctx.log(err);
  833. this.ctx.ajaxErrorBody(err, '操作失败');
  834. }
  835. }
  836. }
  837. return ReportArchiveController;
  838. };