report_archive_controller.js 43 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867
  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 childUuids = params.childUuids;
  197. const splitArcPages = params.splitArcPages;
  198. const reportName = params.reportName;
  199. const userId = ctx.session.sessionUser.accountId;
  200. const content = params.content;
  201. const orgArchiveList = await ctx.service.rptArchiveEncryption.getPrjStgArchiveEncryption(prjId, stgId);
  202. if (orgArchiveList.length > 0) {
  203. const contentArr = JSON.parse(orgArchiveList[0].content);
  204. let hasArchive = false;
  205. for (const item of contentArr) {
  206. if (item.rpt_id === rptId) {
  207. // 考虑到报表模板的稳定性,只保留一项来记录位置就足够了,都不考虑用uuid了
  208. if (item.uuid === uuid) {
  209. // 最后打脸了,还真的要考虑不同的uuid,不早说,TNND
  210. item.encryption = content;
  211. item.total_page = ttlPgs;
  212. item.user_id = userId;
  213. item.report_name = reportName;
  214. item.childUuids = childUuids;
  215. item.splitArcPages = splitArcPages;
  216. hasArchive = true;
  217. break;
  218. }
  219. }
  220. }
  221. if (!hasArchive) {
  222. // 表示有新的要加
  223. contentArr.push({ rpt_id: rptId, uuid, total_page: ttlPgs, encryption: content, user_id: userId, report_name: reportName, childUuids, splitArcPages });
  224. } else {
  225. //
  226. }
  227. const updatedRst = await ctx.service.rptArchiveEncryption.updateArchiveEncryption(orgArchiveList[0].id, prjId, stgId, contentArr);
  228. // console.log(updatedRst);
  229. ctx.body = { err: 0, msg: '', data: { addedRst: contentArr } };
  230. } else {
  231. // 需要增加
  232. const archiveArr = [];
  233. archiveArr.push({ rpt_id: rptId, uuid, total_page: ttlPgs, encryption: content, user_id: userId, report_name: reportName, childUuids, splitArcPages });
  234. const addedRst = await ctx.service.rptArchiveEncryption.createArchiveEncryption(prjId, stgId, archiveArr);
  235. // console.log(addedRst);
  236. ctx.body = { err: 0, msg: '', data: { addedRst: archiveArr } };
  237. }
  238. }
  239. async _updateArchiveCommon(ctx, prjId, stgId, rptId, parentUuidName, childUuids) {
  240. const updateDate = new Date();
  241. const montStr = (updateDate.getMonth() + 1) < 10 ? ('0' + (updateDate.getMonth() + 1)) : (updateDate.getMonth() + 1);
  242. const dateStr = (updateDate.getDate()) < 10 ? ('0' + updateDate.getDate()) : (updateDate.getDate());
  243. let hrStr = '' + updateDate.getHours();
  244. if (hrStr.length === 1) hrStr = '0' + hrStr;
  245. let minStr = '' + updateDate.getMinutes();
  246. if (minStr.length === 1) minStr = '0' + minStr;
  247. let secStr = '' + updateDate.getSeconds();
  248. if (secStr.length === 1) secStr = '0' + secStr;
  249. const dtStr = `${updateDate.getFullYear()}-${montStr}-${dateStr} ${hrStr}:${minStr}:${secStr}`;
  250. let rst = null;
  251. const fileName = parentUuidName + '.PDF';
  252. const orgArchiveList = await ctx.service.rptArchive.getPrjStgArchive(prjId, stgId);
  253. if (orgArchiveList.length > 0) {
  254. const contentArr = JSON.parse(orgArchiveList[0].content);
  255. let hasArchive = false;
  256. for (const item of contentArr) {
  257. if (item.rpt_id === rptId) {
  258. hasArchive = true;
  259. let updateRmIdx = -1;
  260. for (let idx = 0; idx < item.items.length; idx++) {
  261. if (parentUuidName === item.items[idx].uuid) {
  262. // 这里的判断是否是update archive逻辑(是否存在相同uuid的item)
  263. updateRmIdx = idx;
  264. break;
  265. }
  266. }
  267. if (updateRmIdx < 0 && item.items.length >= MAX_ARCHIVE) {
  268. updateRmIdx = 0;
  269. for (let idx = 1; idx < item.items.length; idx++) {
  270. if (item.items[updateRmIdx].updateDate_time > item.items[idx].updateDate_time) {
  271. updateRmIdx = idx;
  272. }
  273. }
  274. }
  275. if (updateRmIdx >= 0) {
  276. // 删除oss文件
  277. await ctx.app.signPdfOss.delete(`archive/${item.items[updateRmIdx].uuid}.PDF`);
  278. // 以及删除子oss文件
  279. if (item.items[updateRmIdx].childUuids && item.items[updateRmIdx].childUuids.length > 0) {
  280. for (const childUuid of item.items[updateRmIdx].childUuids) {
  281. let uuid = '';
  282. if (typeof childUuid === 'string') {
  283. uuid = childUuid;
  284. } else {
  285. uuid = childUuid.uuid;
  286. }
  287. await ctx.app.signPdfOss.delete(`archive/${uuid}.PDF`);
  288. }
  289. }
  290. item.items.splice(updateRmIdx, 1);
  291. }
  292. const newItem = { uuid: parentUuidName, updateDate_time: dtStr, childUuids };
  293. item.items.push(newItem);
  294. break;
  295. }
  296. }
  297. if (!hasArchive) {
  298. // 表示有新的模板需要添加
  299. contentArr.push({ rpt_id: rptId, items: [{ uuid: parentUuidName, updateDate_time: dtStr, childUuids }] });
  300. }
  301. const updatedRst = await ctx.service.rptArchive.updateArchive(orgArchiveList[0].id, prjId, stgId, contentArr);
  302. // console.log(updatedRst);
  303. rst = { err: 0, msg: parentUuidName, data: { uuid: parentUuidName, fileName, updateDate, updatedRst: contentArr } };
  304. } else {
  305. // 需要增加
  306. const archiveArr = [];
  307. archiveArr.push({ rpt_id: rptId, items: [{ uuid: parentUuidName, updateDate_time: dtStr, childUuids }] });
  308. const addedRst = await ctx.service.rptArchive.createArchive(prjId, stgId, archiveArr);
  309. rst = { err: 0, msg: parentUuidName, data: { uuid: parentUuidName, fileName, updateDate, updatedRst: archiveArr } };
  310. }
  311. return rst;
  312. }
  313. async addParentChildrenArchiveReports(ctx) {
  314. // 接收多个子母PDF
  315. let stream;
  316. try {
  317. const prjId = ctx.params.prjId;
  318. const stgId = ctx.params.stgId;
  319. const rptId = ctx.params.rptId;
  320. // const childAmt = parseInt(ctx.params.childAmt); // 子分页数量
  321. const childInfo = ctx.params.splitInfo.split(';'); // 这个参数带比较多的信息,包含分割指标的:1. 名称 2. ID 3. 内容
  322. const splitArcPages = JSON.parse(childInfo[0]);
  323. // console.log(splitArcPages);
  324. const childAmt = splitArcPages.length;
  325. const splitFieldObj = JSON.parse(childInfo[1]);
  326. const ttlPages = parseInt(childInfo[2]); // 总页数
  327. // console.log(splitFieldObj);
  328. const parentUuid = uuidV1();
  329. const childUuids = [];
  330. // const newUuidName = uuidV1();
  331. const parts = ctx.multipart({ autoFields: true });
  332. stream = await parts();
  333. let index = 0;
  334. while (stream !== undefined) {
  335. /*
  336. // 测试保存文件
  337. await ctx.helper.saveStreamFile(stream, path.join(this.app.baseDir, 'app/public/upload/', stream.filename));
  338. await sendToWormhole(stream);
  339. //*/
  340. let fileName = parentUuid + '.PDF';
  341. if (index > 0) {
  342. const cUuid = uuidV1();
  343. const startPage = splitArcPages[index - 1];
  344. // const endPage = splitArcPages[index - 1];
  345. let endPage = ttlPages;
  346. if (index < splitArcPages.length) {
  347. endPage = splitArcPages[index] - 1;
  348. }
  349. childUuids.push({ uuid: cUuid, totalPages: (endPage - startPage + 1), startPage, endPage, splitKeyValue: splitFieldObj.splitPageValues[index - 1] });
  350. fileName = cUuid + '.PDF';
  351. }
  352. const oss_result = await ctx.app.signPdfOss.put('archive/' + fileName, stream);
  353. if (!(oss_result && oss_result.url && oss_result.res.status === 200)) {
  354. throw '上传文件失败';
  355. }
  356. await sendToWormhole(stream);
  357. ++index;
  358. if (index <= childAmt) {
  359. stream = await parts();
  360. } else {
  361. stream = undefined;
  362. }
  363. // stream = await parts();
  364. }
  365. const body = await this._updateArchiveCommon(ctx, prjId, stgId, rptId, parentUuid, childUuids);
  366. ctx.body = body;
  367. } catch (error) {
  368. ctx.helper.log(error);
  369. // 失败需要消耗掉stream 以防卡死
  370. if (stream) {
  371. await sendToWormhole(stream);
  372. }
  373. ctx.body = this.ajaxErrorBody(error, '上传附件失败,请重试');
  374. }
  375. }
  376. async addReportArchive(ctx) {
  377. try {
  378. const stream = await ctx.getFileStream();
  379. const prjId = ctx.params.prjId;
  380. const stgId = ctx.params.stgId;
  381. const rptId = ctx.params.rptId;
  382. const newUuidName = uuidV1();
  383. const fileName = newUuidName + '.PDF';
  384. const oss_result = await ctx.app.signPdfOss.put('archive/' + fileName, stream);
  385. if (!(oss_result && oss_result.url && oss_result.res.status === 200)) {
  386. throw '上传文件失败';
  387. }
  388. const body = await this._updateArchiveCommon(ctx, prjId, stgId, rptId, newUuidName, []);
  389. ctx.body = body;
  390. } catch (err) {
  391. this.log(err);
  392. ctx.body = { err: 1, msg: err.toString(), data: null };
  393. }
  394. }
  395. async updateReportArchiveEncryption(ctx) {
  396. // 在add方法中已经处理
  397. await this.addReportArchiveEncryption(ctx);
  398. }
  399. async updateReportArchive(ctx) {
  400. try {
  401. const stream = await ctx.getFileStream();
  402. const prjId = ctx.params.prjId;
  403. const stgId = ctx.params.stgId;
  404. const rptId = ctx.params.rptId;
  405. const orgUuidName = ctx.params.orgName;
  406. const fileName = orgUuidName + '.PDF';
  407. console.log('updating fileName: ' + fileName);
  408. // await ctx.helper.saveStreamFile(stream, path.join(this.app.baseDir, 'app', 'public/archive', fileName));
  409. const oss_result = await ctx.app.signPdfOss.put('archive/' + fileName, stream);
  410. if (!(oss_result && oss_result.url && oss_result.res.status === 200)) {
  411. throw '上传文件失败';
  412. }
  413. // 判断是否存在已签名文档,存在则删除文档并删除签名记录
  414. const pdfMsg = await ctx.curl(signConst.path.oss + '/sign/' + orgUuidName + '.PDF');
  415. if (pdfMsg && pdfMsg.status === 200) {
  416. const oss_reuslt = await ctx.app.signPdfOss.delete('archive/sign/' + fileName);
  417. if (oss_reuslt && oss_reuslt.res && oss_reuslt.res.status === 204) {
  418. const delSign_result = await ctx.service.netcasignLog.removeSign(orgUuidName);
  419. } else {
  420. throw '删除已签文档失败';
  421. }
  422. }
  423. const body = await this._updateArchiveCommon(ctx, prjId, stgId, rptId, orgUuidName, []);
  424. ctx.body = body;
  425. } catch (err) {
  426. this.log(err);
  427. ctx.body = { err: 1, msg: err.toString(), data: null };
  428. }
  429. }
  430. async _removeReportArchiveEncryption(ctx) {
  431. let rst = null;
  432. try {
  433. const prjId = ctx.params.prjId;
  434. const stgId = ctx.params.stgId;
  435. const rptId = parseInt(ctx.params.rptId);
  436. const uuid = ctx.params.orgName;
  437. const orgArchiveList = await ctx.service.rptArchiveEncryption.getPrjStgArchiveEncryption(prjId, stgId);
  438. if (orgArchiveList.length > 0) {
  439. const contentArr = JSON.parse(orgArchiveList[0].content);
  440. for (let idx = contentArr.length - 1; idx >= 0; idx--) {
  441. if (contentArr[idx].rpt_id === rptId && contentArr[idx].uuid === uuid) {
  442. contentArr.splice(idx, 1);
  443. break;
  444. }
  445. }
  446. // const updatedRst = await ctx.service.rptArchive.updateArchive(prjId, stgId, contentArr);
  447. rst = await ctx.service.rptArchiveEncryption.updateArchiveEncryption(orgArchiveList[0].id, prjId, stgId, contentArr);
  448. }
  449. } catch (err) {
  450. this.log(err);
  451. }
  452. return rst;
  453. }
  454. async removeReportArchiveEncryption(ctx) {
  455. try {
  456. const rst = await this._removeReportArchiveEncryption(ctx);
  457. if (rst) {
  458. ctx.body = { err: 0, msg: '', data: { updatedRst: rst } };
  459. } else {
  460. ctx.body = { err: 0, msg: '', data: { updatedRst: null } };
  461. }
  462. } catch (err) {
  463. this.log(err);
  464. ctx.body = { err: 1, msg: err.toString(), data: null };
  465. }
  466. }
  467. async _removeReportArchive(ctx) {
  468. let rst = null;
  469. try {
  470. const prjId = ctx.params.prjId;
  471. const stgId = ctx.params.stgId;
  472. const rptId = ctx.params.rptId;
  473. const orgUuidName = ctx.params.orgName;
  474. // const fileName = orgUuidName + '.PDF';
  475. const orgArchiveList = await ctx.service.rptArchive.getPrjStgArchive(prjId, stgId);
  476. if (orgArchiveList.length > 0) {
  477. const contentArr = JSON.parse(orgArchiveList[0].content);
  478. for (let idx = contentArr.length - 1; idx >= 0; idx--) {
  479. const item = contentArr[idx];
  480. if (item.rpt_id === rptId) {
  481. if (item.items && item.items.length > 0) {
  482. for (const subIdx in item.items) {
  483. if (item.items[subIdx].uuid === orgUuidName) {
  484. if (item.items[subIdx].childUuids && item.items[subIdx].childUuids.length > 0) {
  485. // 如果有子分页,也得删除!
  486. for (const childUuid of item.items[subIdx].childUuids) {
  487. let childUuidName = '';
  488. if (typeof childUuid === 'string') {
  489. childUuidName = childUuid;
  490. } else {
  491. childUuidName = childUuid.uuid;
  492. }
  493. if (!childUuidName.includes('.PDF')) childUuidName = childUuidName + '.PDF';
  494. await ctx.app.signPdfOss.delete(`archive/${childUuidName}`);
  495. }
  496. }
  497. item.items.splice(subIdx, 1);
  498. break;
  499. }
  500. }
  501. if (item.items.length === 0) {
  502. contentArr.splice(idx, 1);
  503. }
  504. }
  505. break;
  506. }
  507. }
  508. rst = await ctx.service.rptArchive.updateArchive(orgArchiveList[0].id, prjId, stgId, contentArr);
  509. }
  510. } catch (err) {
  511. this.log(err);
  512. }
  513. return rst;
  514. }
  515. async removeReportArchive(ctx) {
  516. try {
  517. const orgUuidName = ctx.params.orgName;
  518. const fileName = orgUuidName + '.PDF';
  519. // console.log(ctx.params);
  520. console.log('removing fileName: ' + fileName);
  521. // const fullName = path.join(this.app.baseDir, 'app', 'public/archive', fileName);
  522. const oss_sign_result = await ctx.app.signPdfOss.delete(`archive/sign/${fileName}`);
  523. if (oss_sign_result && oss_sign_result.res && oss_sign_result.res.status === 204) {
  524. // console.log('删除归档的签名信息成功!');
  525. const oss_result = await ctx.app.signPdfOss.delete(`archive/${fileName}`);
  526. if (!(oss_result && oss_result.res.status === 204)) {
  527. throw '删除归档文件失败';
  528. }
  529. } else {
  530. throw '删除归档签名文件失败';
  531. }
  532. // 还有加密签名信息
  533. const archiveSignRemovedRst = await this._removeReportArchiveEncryption(ctx);
  534. // console.log(archiveSignRemovedRst);
  535. const archiveRemovedRst = await this._removeReportArchive(ctx);
  536. if (archiveRemovedRst) {
  537. ctx.body = { err: 0, msg: orgUuidName, data: { fileName, updatedRst: archiveRemovedRst } };
  538. } else {
  539. ctx.body = { err: 0, msg: orgUuidName, data: { fileName, updatedRst: null } };
  540. }
  541. } catch (err) {
  542. this.log(err);
  543. ctx.body = { err: 1, msg: err.toString(), data: null };
  544. }
  545. }
  546. async addMultiReportArchive(ctx, params) {
  547. // 暂时不支持
  548. }
  549. async getArchivedFileByUUID(ctx) {
  550. // console.log('downloading : ' + ctx.params.uuid);
  551. const uuid = ctx.params.uuid;
  552. const rptName = ctx.params.rptName;
  553. const suffix = '.PDF';
  554. try {
  555. const rptNameURI = encodeURI(rptName);
  556. const filePath = this.app.baseDir + '/app/public/archive/';
  557. // console.log('filePath: ' + filePath);
  558. // await this.ctx.helper.recursiveMkdirSync(this.app.baseDir + '/app/public/download');
  559. ctx.set({
  560. 'Content-Type': 'application/vnd.openxmlformats',
  561. 'Content-Disposition': 'attachment; filename="' + rptNameURI + suffix + "\"; filename*=utf-8''" + rptNameURI + suffix,
  562. });
  563. ctx.body = await fs.readFileSync(filePath + uuid + suffix);
  564. } catch (e) {
  565. console.log(e);
  566. }
  567. }
  568. async pdfShow(ctx) {
  569. // const renderData = {
  570. // can_netcasign: ctx.session.sessionProject.page_show.openNetCaSign === 1,
  571. // };
  572. await ctx.render('report/archive_pdf.ejs');
  573. }
  574. /*
  575. * 网证通电子签名页,(和归档报表页高度相似)
  576. */
  577. async signReport(ctx) {
  578. const tender = ctx.tender;
  579. const stage = ctx.stage;
  580. let stage_id = -1;
  581. let stage_order = -1;
  582. let stage_times = -1;
  583. let stage_status = -1;
  584. const treeNodes = await ctx.service.rptTreeNode.getNodesByProjectId([-1, tender.data.project_id]);
  585. const custTreeNodes = await ctx.service.rptTreeNodeCust.getCustFoldersByUserId(this.ctx.session.sessionUser.accountId);
  586. const stageList = await ctx.service.stage.getValidStagesShort(tender.id);
  587. //
  588. // 。。。
  589. let archiveList = [];
  590. let archiveEncryptionList = [];
  591. // console.log('tender.data.project_id: ' + tender.data.project_id);
  592. if (stage) {
  593. // console.log('ctx.stage.id: ' + ctx.stage.id);
  594. const archives = await ctx.service.rptArchive.getPrjStgArchive(tender.data.project_id, ctx.stage.id);
  595. const archiveEncryptions = await ctx.service.rptArchiveEncryption.getPrjStgArchiveEncryption(tender.data.project_id, ctx.stage.id);
  596. stage_id = stage.id;
  597. stage_order = stage.order;
  598. stage_times = stage.times;
  599. stage_status = stage.status;
  600. if (archives.length > 0) {
  601. archiveList = JSON.parse(archives[0].content);
  602. }
  603. console.log('2:', archiveEncryptions, ctx.stage.id);
  604. if (archiveEncryptions.length > 0) {
  605. archiveEncryptionList = JSON.parse(archiveEncryptions[0].content);
  606. }
  607. } else if (stageList.length > 0 && stageList[0].status === auditConst.stage.status.checked) {
  608. // console.log('stageList[0].id: ' + stageList[0].id);
  609. // const archives = await ctx.service.rptArchive.getPrjStgArchive(tender.data.project_id, stageList[stageList.length - 1].id);
  610. let archives = [];
  611. for (let sidx = stageList.length - 1; sidx >= 0; sidx--) {
  612. if (stageList[sidx].status === 3) {
  613. archives = await ctx.service.rptArchive.getPrjStgArchive(tender.data.project_id, stageList[sidx].id);
  614. ctx.stage = stageList[sidx]; // 为了sub menu用
  615. break;
  616. }
  617. }
  618. ctx.stage = ctx.stage ? ctx.stage : stageList[stageList.length - 1];
  619. const archiveEncryptions = await ctx.service.rptArchiveEncryption.getPrjStgArchiveEncryption(tender.data.project_id, ctx.stage.id);
  620. // stage_id = stageList[0].id;
  621. // stage_order = stageList[0].order;
  622. // stage_times = stageList[0].times;
  623. // stage_status = stageList[0].status;
  624. if (archives && archives.length > 0) {
  625. archiveList = JSON.parse(archives[0].content);
  626. }
  627. if (archiveEncryptions && archiveEncryptions.length > 0) {
  628. archiveEncryptionList = JSON.parse(archiveEncryptions[0].content);
  629. }
  630. }
  631. let rpt_tpl_items = '{ customize: [], common: [] }';
  632. if (custTreeNodes.length > 0) {
  633. rpt_tpl_items = custTreeNodes[0].rpt_tpl_items;
  634. }
  635. // 获取ukey绑定数据
  636. const netcaSignData = await ctx.service.netcasign.getDataByCondition({ uid: ctx.session.sessionUser.accountId });
  637. // 获取已签名数据
  638. const signLogList = await ctx.service.netcasignLog.getLogList(ctx.tender.id);
  639. const renderData = {
  640. tender: tender.data,
  641. rpt_tpl_data: JSON.stringify(treeNodes),
  642. cust_tpl_data: rpt_tpl_items,
  643. project_id: tender.data.project_id,
  644. tender_id: tender.id,
  645. stg_id: stage_id,
  646. stg_order: stage_order,
  647. stg_times: stage_times,
  648. stg_status: stage_status,
  649. stage_list: JSON.stringify(stageList),
  650. tenderMenu,
  651. measureType,
  652. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.report.main),
  653. stages: stageList,
  654. auditConst: auditConst.stage,
  655. archiveList,
  656. archiveEncryptionList,
  657. netcaSignData,
  658. can_netcasign: ctx.session.sessionProject.page_show.openNetCaSign === 1,
  659. ossPath: signConst.path.oss,
  660. signLogList,
  661. };
  662. await this.layout('report/index_sign.ejs', renderData, 'report/index_sign_modal.ejs');
  663. }
  664. /**
  665. * 网证通电子签名接口
  666. *
  667. * @param {object} ctx - egg全局变量
  668. * @return {void}
  669. */
  670. async signPost(ctx) {
  671. const response = {
  672. err: 0,
  673. msg: '',
  674. };
  675. try {
  676. const data = JSON.parse(ctx.request.body.data);
  677. let signData;
  678. const netcaSignApi = signConst.path.api;
  679. switch (data.type) {
  680. case 'getPdfBase64':
  681. const pdfResult = await ctx.app.signPdfOss.get(data.path);
  682. if (pdfResult.res.status !== 200) {
  683. throw '该文件不存在';
  684. }
  685. response.data = Buffer.from(pdfResult.content, 'binary').toString('base64');
  686. break;
  687. case 'pdfIsExist':
  688. const pdfMsg = await ctx.app.signPdfOss.head('archive/sign/' + data.uuid + '.PDF');
  689. response.data = pdfMsg.res.status === 200;
  690. break;
  691. // 获取摘要值
  692. case 'assemblyDigest':
  693. const postData = {
  694. requestJson: JSON.stringify(data.requestJson),
  695. };
  696. const result = await ctx.helper.sendMoreRequest(netcaSignApi + '/assemblyDigest', postData, 'POST');
  697. response.data = result;
  698. break;
  699. // 生成签名pdf
  700. case 'assemblyPdf':
  701. const postData2 = {
  702. requestJson: JSON.stringify(data.requestJson),
  703. };
  704. const result3 = await this.roundNetcaSign(ctx, postData2);
  705. // const result2 = await ctx.helper.sendMoreRequest(netcaSignApi + '/assemblyPdf', postData2, 'POST');
  706. // 上传到oss
  707. // console.log(result3);
  708. if (result3.code === 0) {
  709. // const result3 = await ctx.helper.sendMoreRequest(netcaSignApi + result2.data);
  710. const oss_result = await ctx.app.signPdfOss.put('archive/sign/' + data.requestJson.fileName + '.PDF', result3.data);
  711. if (oss_result && oss_result.res && oss_result.res.status === 200) {
  712. if (data.end) {
  713. const versionId = oss_result.res.headers['x-oss-version-id'];
  714. // 记录签名和保存
  715. await ctx.service.netcasignLog.add(data.requestJson.fileName, data.role, ctx.session.sessionUser.accountId, versionId);
  716. const signLogList = await ctx.service.netcasignLog.getLogList(ctx.tender.id);
  717. response.data = signLogList;
  718. } else {
  719. // next page
  720. }
  721. } else {
  722. throw '上传文件失败';
  723. }
  724. } else {
  725. throw result3.msg;
  726. }
  727. break;
  728. // 移除签名和已签移除pdf
  729. case 'removeSign':
  730. const oss_reuslt = await ctx.app.signPdfOss.delete('archive/sign/' + data.uuid + '.PDF');
  731. if (oss_reuslt && oss_reuslt.res && oss_reuslt.res.status === 204) {
  732. const delSign_result = await ctx.service.netcasignLog.removeSign(data.uuid);
  733. const signLogList = await ctx.service.netcasignLog.getLogList(ctx.tender.id);
  734. response.data = signLogList;
  735. } else {
  736. throw '删除文件失败';
  737. }
  738. break;
  739. default:throw '参数有误';
  740. }
  741. } catch (error) {
  742. response.err = 1;
  743. response.msg = error.toString();
  744. const data = JSON.parse(ctx.request.body.data);
  745. if (data && data.type === 'pdfIsExist') {
  746. response.err = 0;
  747. response.data = false;
  748. }
  749. }
  750. ctx.body = response;
  751. }
  752. /**
  753. * 网证通电子签名报表上传
  754. *
  755. * @param {object} ctx - egg全局变量
  756. * @return {void}
  757. */
  758. async signFile(ctx) {
  759. const stream = await ctx.getFileStream();
  760. try {
  761. const uuid = stream.fields.uuid;
  762. const role = stream.fields.role;
  763. const oss_result = await ctx.app.signPdfOss.put('archive/sign/' + uuid + '.PDF', stream);
  764. if (!(oss_result && oss_result.url && oss_result.res.status === 200)) {
  765. throw '上传文件失败';
  766. }
  767. const versionId = oss_result.res.headers['x-oss-version-id'];
  768. // 记录签名和保存
  769. await ctx.service.netcasignLog.add(uuid, role, ctx.session.sessionUser.accountId, versionId);
  770. const signLogList = await ctx.service.netcasignLog.getLogList(ctx.tender.id);
  771. ctx.body = { err: 0, msg: '', data: signLogList };
  772. } catch (err) {
  773. // 必须将上传的文件流消费掉,要不然浏览器响应会卡死
  774. await sendToWormhole(stream);
  775. this.log(err);
  776. ctx.body = { err: 1, msg: err.toString(), data: null };
  777. }
  778. }
  779. async roundNetcaSign(ctx, postData2, round = 3) {
  780. let response = {
  781. code: 0,
  782. data: '',
  783. };
  784. // 无法获取到result3,因为result2生成的pdf已损坏,请重复获取result2,直到获取成功或尝试3次失败后报错为止
  785. try {
  786. const netcaSignApi = signConst.path.api;
  787. const result2 = await ctx.helper.sendMoreRequest(netcaSignApi + '/assemblyPdf', postData2, 'POST');
  788. if (result2.code === 0) {
  789. const result3 = await ctx.curl(netcaSignApi + result2.data, {
  790. timeout: 300000, // 超时 5分钟中
  791. });
  792. if (result3) {
  793. response.data = result3.data;
  794. } else {
  795. if (round > 0) {
  796. round = round - 1;
  797. response = await this.roundNetcaSign(ctx, postData2, round);
  798. } else {
  799. throw 'pdf获取失败,网证通接口无法生成pdf';
  800. }
  801. }
  802. }
  803. } catch (error) {
  804. response.code = 1;
  805. response.msg = error;
  806. }
  807. return response;
  808. }
  809. async sendFileMsg(ctx) {
  810. try {
  811. if (this.ctx.session.sessionUser.accountId !== ctx.tender.data.user_id) throw '您无权操作';
  812. const needFileMsg = await this.ctx.service.specMsg.tenderNeedMsg(this.ctx.session.sessionProject.id, this.ctx.tender.id, pushOperate.report.file);
  813. if (!needFileMsg) throw '该标段暂不可进行该操作';
  814. const waitingMsg = await this.ctx.service.specMsg.getDataByCondition({ tid: this.ctx.tender.id, timing: pushOperate.report.file, status: [0, 1] });
  815. if (waitingMsg) throw '上一次归档完成,未执行完毕,请稍后再试';
  816. const data = JSON.parse(ctx.request.body.data);
  817. const stage = await this.ctx.service.stage.getDataById(data.sid);
  818. await this.ctx.service.specMsg.addReportMsg(null, this.ctx.session.sessionProject.id, this.ctx.tender.data, stage, pushOperate.report.file);
  819. ctx.body = { err: 0, msg: '提交成功,稍后将同步至档案系统', data: null };
  820. } catch (err) {
  821. this.ctx.log(err);
  822. this.ctx.ajaxErrorBody(err, '操作失败');
  823. }
  824. }
  825. }
  826. return ReportArchiveController;
  827. };