report_controller.js 55 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116
  1. 'use strict';
  2. /**
  3. * Created by Tony on 2019/7/5.
  4. */
  5. const tenderMenu = require('../../config/menu').tenderMenu;
  6. const measureType = require('../const/tender').measureType;
  7. const auditConst = require('../const/audit');
  8. const accountGroup = require('../const/account_group').group;
  9. const JpcEx = require('../reports/rpt_component/jpc_ex');
  10. const JV = require('../reports/rpt_component/jpc_value_define');
  11. const rpt_xl_util = require('../reports/util/rpt_excel_util');
  12. const rptDataExtractor = require('../reports/util/rpt_calculation_data_util');
  13. const fsUtil = require('../public/js/fsUtil');
  14. const fs = require('fs');
  15. const rptCronJob = require('../reports/util/rpt_tmp_file_sweep');
  16. const RPT_DEF_PROPERTIES = require('../const/report_defined_properties');
  17. const reportConst = require('../const/report');
  18. // const stringUtil = require('../public/js/string_util_light');
  19. const scheduleJob = require('node-schedule');
  20. module.exports = app => {
  21. class ReportController extends app.BaseController {
  22. /**
  23. * 报表显示页面
  24. *
  25. * @param {Object} ctx - egg全局context
  26. * @return {void}
  27. */
  28. async index(ctx) {
  29. try {
  30. const tender = ctx.tender;
  31. const stage = ctx.stage;
  32. // console.log(tender.data);
  33. // console.log(tender.info);
  34. let stage_id = -1;
  35. let stage_order = -1;
  36. let sorder = -1;
  37. let stage_times = -1;
  38. let stage_status = -1;
  39. const treeNodes = await ctx.service.rptTreeNode.getNodesByProjectId([-1, tender.data.project_id]);
  40. const custTreeNodes = await ctx.service.rptTreeNodeCust.getCustFoldersByUserId(this.ctx.session.sessionUser.accountId);
  41. const custCfg = await ctx.service.rptCustomizeCfg.getCustomizeCfgByUserId('Administrator');
  42. const stageList = await ctx.service.stage.getValidStagesShort(tender.id);
  43. const prjAccList = await ctx.service.projectAccount.getAllAccountByProjectId(tender.data.project_id);
  44. const roleList = await ctx.service.signatureRole.getSignatureRolesByTenderId(tender.id);
  45. const usedList = await ctx.service.signatureUsed.getSignatureUsedByTenderId(tender.id);
  46. // 分类列表
  47. const categoryData = await this.ctx.service.category.getAllCategory(this.ctx.session.sessionProject.id);
  48. // 获取用户权限
  49. const accountInfo = await this.ctx.service.projectAccount.getDataById(this.ctx.session.sessionUser.accountId);
  50. const userPermission = accountInfo !== undefined && accountInfo.permission !== '' ? JSON.parse(accountInfo.permission) : null;
  51. // 获取用户可查看的标段
  52. const tenderList = await this.ctx.service.tender.getList('', userPermission);
  53. for (const t of tenderList) {
  54. if (t.ledger_status === auditConst.ledger.status.checked) {
  55. t.lastStage = await this.ctx.service.stage.getLastestStage(t.id, true);
  56. // if (t.lastStage) {
  57. // await this.ctx.service.stage.checkStageGatherData(t.lastStage);
  58. // }
  59. }
  60. }
  61. // 获取汇总表,历史选择
  62. const cid = this.ctx.helper._.map(treeNodes, 'id');
  63. const customSelects = {};
  64. if (ctx.stage) {
  65. customSelects.audit_select = await ctx.service.rptCustomDefine.getCustomSelectByRpt(cid,
  66. reportConst.rptCustomType[JV.NODE_CUS_AUDIT_SELECT], ctx.tender.id, ctx.stage.id);
  67. customSelects.stageFlow = await ctx.service.stageAudit.getAuditGroupByListWithOwner(
  68. ctx.stage.stage_id, ctx.stage.stage_times);
  69. } else {
  70. customSelects.audit_select = [];
  71. }
  72. customSelects.gather_select = await ctx.service.rptCustomDefine.getCustomSelectByRpt(cid,
  73. reportConst.rptCustomType[JV.NODE_CUS_GATHER_SELECT], ctx.tender.id, -1);
  74. const dataSelects = {};
  75. dataSelects.material_select = await ctx.service.rptCustomDefine.getDataSelectByRpt(cid,
  76. reportConst.rptDataType[JV.NODE_CUS_MATERIAL_SELECT]);
  77. const materialList = await ctx.service.material.getValidMaterials(ctx.tender.id);
  78. // const allTpls = await ctx.service.rptTpl.getAllTplByIds(tmpRptIds);
  79. // for (const tpl of allTpls) {
  80. // const fName = tpl.id + '_' + tpl.rpt_tpl_name + '.js';
  81. // console.log('fName: ' + fName);
  82. // fsUtil.writeObjToFile(tpl, 'D:/Temp/计量临时/' + fName);
  83. // }
  84. // 完成历史任务,下一批
  85. // const filePath = 'D:/Temp/计量临时/';
  86. // const tplFiles = [];
  87. // fs.readdir(filePath, (err, files) => {
  88. // if (err) throw err;
  89. // files.forEach(file => {
  90. // const fPath = filePath + file;
  91. // // console.log('\'' + fPath + '\'');
  92. // tplFiles.push(fPath);
  93. // });
  94. // });
  95. //
  96. // setTimeout(function() {
  97. // console.log(tplFiles);
  98. // }, 2000);
  99. // 下一批
  100. // let cnt = 0;
  101. // for (const file of rptFiles) {
  102. // const tplObj = JSON.parse(fs.readFileSync(file, 'utf-8'));
  103. // const rst = await ctx.service.rptTpl.insertRptTpl(tplObj);
  104. // cnt++;
  105. // console.log(file);
  106. // }
  107. // console.log(cnt + ' 完成!');
  108. // console.log(maxStageAmt[0].maxAmt);
  109. // 备注:在报表界面初始化的时候,暂时不需要check stage,只有在点中某张表的时候才需要(签名交互需要)
  110. // if ((stage === null || stage === undefined) && stageList.length > 0) {
  111. // await ctx.service.stage.checkStage(stageList[stageList.length - 1].id);
  112. // stage = ctx.stage;
  113. // console.log(stage);
  114. // }
  115. if (stage !== null && stage !== undefined) {
  116. stage_id = stage.id;
  117. stage_order = stage.order;
  118. sorder = stage.curOrder;
  119. stage_times = stage.times;
  120. stage_status = stage.status;
  121. }
  122. for (const prjAcc of prjAccList) {
  123. prjAcc.account_group = accountGroup[prjAcc.account_group];
  124. }
  125. let rpt_tpl_items = '{ customize: { "isDftAll": true }, common: [] }';
  126. if (custTreeNodes.length > 0) {
  127. rpt_tpl_items = custTreeNodes[0].rpt_tpl_items;
  128. }
  129. const renderData = {
  130. tender: tender.data,
  131. tenderInfo: tender.info,
  132. rpt_tpl_data: JSON.stringify(treeNodes),
  133. cust_tpl_data: rpt_tpl_items,
  134. cust_cfg: JSON.stringify(custCfg),
  135. project_id: tender.data.project_id,
  136. tender_id: tender.id,
  137. tender_name: tender.data.name,
  138. stg_id: stage_id,
  139. stg_order: stage_order,
  140. cur_order: sorder,
  141. stg_times: stage_times,
  142. stg_status: stage_status,
  143. stage_list: JSON.stringify(stageList),
  144. prj_account_list: JSON.stringify(prjAccList),
  145. role_list: JSON.stringify(roleList),
  146. used_list: JSON.stringify(usedList),
  147. tenderMenu,
  148. preUrl: '/tender/' + tender.id,
  149. measureType,
  150. categoryData,
  151. tenderList,
  152. auditConst: auditConst.stage,
  153. ledgerAuditConst: auditConst.ledger,
  154. jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.report.main),
  155. customSelects,
  156. rptCustomType: reportConst.rptCustomType,
  157. materialList,
  158. dataSelects
  159. };
  160. await this.layout('report/index.ejs', renderData, 'report/rpt_all_popup.ejs');
  161. // await this.layout('report/index.ejs', renderData);
  162. // 在这里启动一个cron job,删除临时创建的excel文件
  163. if (!rptCronJob.started) {
  164. try {
  165. // console.log('rptCronJob.started: ' + rptCronJob.started);
  166. rptCronJob.started = true;
  167. rptCronJob.createJob(null, this.app.baseDir + '/app/public/download');
  168. } catch (ex) {
  169. rptCronJob.started = false;
  170. }
  171. }
  172. } catch (err) {
  173. this.log(err);
  174. console.log(err);
  175. // ctx.redirect('/tender/' + ctx.tender.id);
  176. }
  177. }
  178. /**
  179. * 报表打印页面
  180. *
  181. * @param {Object} ctx - egg全局context
  182. * @return {void}
  183. */
  184. async showPrintPage(ctx) {
  185. try {
  186. // const params = JSON.parse(ctx.request.body.params);
  187. const pageSize = ctx.params.size;
  188. // console.log('pageSize: ' + pageSize);
  189. const renderData = {
  190. size: pageSize,
  191. // orientation: params.orientation,
  192. };
  193. if (pageSize === 'A3') {
  194. await ctx.render('report/rpt_printA3.ejs', renderData);
  195. } else {
  196. await ctx.render('report/rpt_print.ejs', renderData);
  197. }
  198. } catch (err) {
  199. this.log(err);
  200. console.log(err);
  201. }
  202. }
  203. async _getReport(ctx, params) {
  204. // console.log('in getReport');
  205. // console.log(params);
  206. let rptTpl = await ctx.service.rptTpl.getTplById(params.rpt_tpl_id);
  207. if (!rptTpl || rptTpl.length !== 1) {
  208. throw '获取模板失败';
  209. }
  210. rptTpl = JSON.parse(rptTpl[0].rpt_content);
  211. // console.log('get the template!');
  212. const customSelect = rptTpl[JV.NODE_CUSTOM_DEFINE] && rptTpl[JV.NODE_CUSTOM_DEFINE][JV.NODE_CUS_AUDIT_SELECT].enable
  213. ? await ctx.service.rptCustomDefine.getCustomDefine(params.tender_id, params.stage_id, params.rpt_tpl_id)
  214. : await ctx.service.rptCustomDefine.getCustomDefine(params.tender_id, -1, params.rpt_tpl_id);
  215. const copyCustomSelect = this.ctx.helper.clone(customSelect);
  216. if (!params.gather_select && copyCustomSelect) {
  217. delete copyCustomSelect.gather_select;
  218. }
  219. const pageRst = await getAllPagesCommon(ctx, rptTpl, params, JV.PAGING_OPTION_NORMAL, JV.OUTPUT_TYPE_NORMAL, this.app.baseDir, copyCustomSelect);
  220. // console.log(pageRst);
  221. // const roleRel = (params.stage_status === 3) ? (await ctx.service.roleRptRel.getRoleRptRelByDetailIds(params.tender_id, params.rpt_tpl_id)) : [];
  222. const roleRel = await ctx.service.roleRptRel.getRoleRptRelByDetailIds(params.tender_id, params.rpt_tpl_id, params.stage_id); // 新需求中,允许在非审核状态下设置签名
  223. const stgAudit = await ctx.service.stageAudit.getStageAudit(params.stage_id, params.stage_times);
  224. const stgAuditForOrg = await ctx.service.stageAudit.getStageAudit(params.stage_id, 1);
  225. // console.log('after role stage!');
  226. // console.log(roleRel);
  227. await encodeSignatureDataUri(roleRel, this.app.baseDir);
  228. await encodeDummySignatureDataUri(pageRst, this.app.baseDir);
  229. const stageFlow = await ctx.service.stageAudit.getAuditGroupByListWithOwner(params.stage_id, params.stage_times);
  230. // console.log('encodeSignatureDataUri!');
  231. return {
  232. data: pageRst,
  233. signatureRelInfo: roleRel,
  234. stageAudit: stgAudit,
  235. stageAuditOrg: stgAuditForOrg,
  236. debugInfo: ctx.app.config.is_debug ? ctx.debugInfo : null,
  237. customDefine: rptTpl[JV.NODE_CUSTOM_DEFINE],
  238. stageFlow,
  239. customSelect,
  240. };
  241. }
  242. /**
  243. * 获取报表数据
  244. *
  245. * @param {Object} ctx - egg全局context
  246. * @return {void}
  247. */
  248. async getReport(ctx) {
  249. try {
  250. // console.log('in getReport');
  251. const params = JSON.parse(ctx.request.body.params);
  252. ctx.body = await this._getReport(ctx, params);
  253. // // console.log(params);
  254. // let rptTpl = await ctx.service.rptTpl.getTplById(params.rpt_tpl_id);
  255. // if (!rptTpl || rptTpl.length !== 1) {
  256. // throw '获取模板失败';
  257. // }
  258. // rptTpl = JSON.parse(rptTpl[0].rpt_content);
  259. // // console.log('get the template!');
  260. // const pageRst = await getAllPagesCommon(ctx, rptTpl, params, JV.PAGING_OPTION_NORMAL, JV.OUTPUT_TYPE_NORMAL, this.app.baseDir);
  261. // // console.log(pageRst);
  262. // // const roleRel = (params.stage_status === 3) ? (await ctx.service.roleRptRel.getRoleRptRelByDetailIds(params.tender_id, params.rpt_tpl_id)) : [];
  263. // const roleRel = await ctx.service.roleRptRel.getRoleRptRelByDetailIds(params.tender_id, params.rpt_tpl_id); // 新需求中,允许在非审核状态下设置签名
  264. // const stgAudit = await ctx.service.stageAudit.getStageAudit(params.stage_id, params.stage_times);
  265. // // console.log('after role stage!');
  266. // // console.log(roleRel);
  267. // await encodeSignatureDataUri(roleRel, this.app.baseDir);
  268. // await encodeDummySignatureDataUri(pageRst, this.app.baseDir);
  269. // const stageFlow = await ctx.service.stageAudit.getAuditGroupByListWithOwner(params.stage_id, params.stage_times);
  270. // const customSelect = await ctx.service.rptCustomDefine.getDataByCondition({
  271. // tid: params.tender_id, sid: params.stage_id, rid: params.rpt_tpl_id
  272. // });
  273. //
  274. // // console.log('encodeSignatureDataUri!');
  275. // ctx.body = {
  276. // data: pageRst,
  277. // signatureRelInfo: roleRel,
  278. // stageAudit: stgAudit,
  279. // debugInfo: ctx.app.config.is_debug ? ctx.debugInfo : null,
  280. // customDefine: rptTpl[JV.NODE_CUSTOM_DEFINE],
  281. // stageFlow,
  282. // customSelect,
  283. // };
  284. // // ctx.body = { data: { msg: 'test the network' } };
  285. ctx.status = 201;
  286. } catch (ex) {
  287. console.log(ex);
  288. this.setMessage(ex.toString(), this.messageType.ERROR);
  289. }
  290. }
  291. /**
  292. * 获取多批次报表数据
  293. *
  294. * @param {Object} ctx - egg全局context
  295. * @return {void}
  296. */
  297. async getMultiReportsEx(ctx) {
  298. // 原则说明:把所有报表模板集中获取,统一filter,只读一次数据!
  299. const params = JSON.parse(ctx.request.body.params);
  300. await this._saveCustomSelects(params);
  301. const pageRstArr = await getMultiRptsCommon(ctx, params, JV.OUTPUT_TYPE_NORMAL, this.app.baseDir);
  302. const stgAudit = await ctx.service.stageAudit.getStageAudit(params.stage_id, params.stage_times);
  303. const roleRel = (params.stage_status === 3) ? (await ctx.service.roleRptRel.getRoleRptRelByDetailIds(params.tender_id, params.rpt_ids, params.stage_id)) : [];
  304. // const roleRel = (params.stage_status === 3) ? (await ctx.service.roleRptRel.getRoleRptRelByDetailIds(params.tender_id, params.rpt_tpl_id)) : [];
  305. roleRel.sort(function(rr1, rr2) {
  306. return params.rpt_ids.indexOf(parseInt(rr1.rpt_id)) - params.rpt_ids.indexOf(parseInt(rr2.rpt_id));
  307. });
  308. // console.log('roleRel: ');
  309. // console.log(roleRel);
  310. await encodeSignatureDataUri(roleRel, this.app.baseDir);
  311. for (const pageRst of pageRstArr) {
  312. await encodeDummySignatureDataUri(pageRst, this.app.baseDir);
  313. }
  314. // console.log(pageRstArr);
  315. ctx.body = { data: pageRstArr, signatureRelInfo: roleRel, stageAudit: stgAudit };
  316. ctx.status = 201;
  317. }
  318. async _saveCustomSelects(params) {
  319. for (const [i, cs] of params.customSelect.entries()) {
  320. if (!cs) continue;
  321. cs.tender_id = params.tender_id;
  322. cs.stage_id = params.stage_id;
  323. cs.rpt_tpl_id = params.rpt_ids[i];
  324. await this.ctx.service.rptCustomDefine.saveCustomSelect(cs);
  325. }
  326. }
  327. async createExcelFilesEx(ctx) {
  328. const params = JSON.parse(ctx.request.body.params);
  329. await this._saveCustomSelects(params);
  330. const baseDir = this.app.baseDir;
  331. function getExcelByPageData(pageRst, rpt_name, innerRoleRel) {
  332. return new Promise(function(resolve, reject) {
  333. rpt_xl_util.exportExcel(pageRst, params.pageSize, rpt_name, params.isOneSheet, null, null, baseDir, innerRoleRel,
  334. (err, uuidName) => {
  335. if (err) return reject(err);
  336. const fileRst = { uuid: uuidName, reportName: rpt_name.replace(new RegExp('%', 'gm'), '_') };
  337. resolve(fileRst);
  338. }
  339. );
  340. });
  341. }
  342. const roleRelArr = (params.stage_status === 3) ? (await ctx.service.roleRptRel.getRoleRptRelByDetailIds(params.tender_id, params.rpt_ids, params.stage_id)) : [];
  343. // const roleRel = (params.stage_status === 3) ? (await ctx.service.roleRptRel.getRoleRptRelByDetailIds(params.tender_id, params.rpt_tpl_id)) : [];
  344. const pageRstArr = await getMultiRptsCommon(ctx, params, JV.OUTPUT_TYPE_NORMAL, this.app.baseDir);
  345. await this.ctx.helper.recursiveMkdirSync(this.app.baseDir + '/app/public/download');
  346. const runnableRst = [];
  347. for (let idx = 0; idx < pageRstArr.length; idx++) {
  348. let roleRel = null;
  349. for (const roleR of roleRelArr) {
  350. if (roleR.rpt_id === params.rpt_ids[idx]) {
  351. roleRel = JSON.parse(roleR.rel_content);
  352. break;
  353. }
  354. }
  355. // console.log('roleRel.rel_content: ' + roleRel.rel_content);
  356. // fsUtil.writeObjToFile(pageRstArr, 'D:/GitHome/temp/testBuiltPageResult.jsp');
  357. runnableRst.push(getExcelByPageData(pageRstArr[idx], params.rpt_names[idx], roleRel));
  358. }
  359. // fsUtil.writeObjToFile(pageRstArr, 'D:/GitHome/temp/计量导出pageArr.js');
  360. const uuidRst = await Promise.all(runnableRst);
  361. ctx.body = { data: uuidRst };
  362. ctx.status = 201;
  363. }
  364. async createExcelFilesInOneBookEx(ctx) {
  365. const params = JSON.parse(ctx.request.body.params);
  366. const baseDir = this.app.baseDir;
  367. function getExcelByPageData(pageRstArr, rpt_name, innerRoleRel) {
  368. return new Promise(function(resolve, reject) {
  369. rpt_xl_util.exportExcelInOneBook(pageRstArr, params.pageSize, rpt_name, baseDir, innerRoleRel,
  370. (err, uuidName) => {
  371. if (err) return reject(err);
  372. const fileRst = { uuid: uuidName, reportName: rpt_name };
  373. resolve(fileRst);
  374. }
  375. );
  376. });
  377. }
  378. const roleRelArr = (params.stage_status === 3) ? (await ctx.service.roleRptRel.getRoleRptRelByDetailIds(params.tender_id, params.rpt_ids, params.stage_id)) : [];
  379. const pageRstArr = await getMultiRptsCommon(ctx, params, JV.OUTPUT_TYPE_NORMAL, this.app.baseDir);
  380. await this.ctx.helper.recursiveMkdirSync(this.app.baseDir + '/app/public/download');
  381. const runnableRst = [];
  382. let rptRoleRelArr = [];
  383. const reAssignSignatureName = function(pageData, roleRel, rpt_name_key) {
  384. const keyMap = {};
  385. for (const pageItem of pageData.items) {
  386. for (const signCell of pageItem[JV.PROP_SIGNATURE_CELLS]) {
  387. if (!keyMap.hasOwnProperty(signCell.signature_name)) {
  388. keyMap[signCell.signature_name] = rpt_name_key + '_' + signCell.signature_name;
  389. }
  390. }
  391. }
  392. for (const pageItem of pageData.items) {
  393. for (const signCell of pageItem[JV.PROP_SIGNATURE_CELLS]) {
  394. if (keyMap.hasOwnProperty(signCell.signature_name)) {
  395. signCell.signature_name = keyMap[signCell.signature_name];
  396. }
  397. }
  398. }
  399. for (const roleSign of roleRel) {
  400. if (keyMap.hasOwnProperty(roleSign.signature_name)) {
  401. roleSign.signature_name = keyMap[roleSign.signature_name];
  402. }
  403. }
  404. // console.log('keyMap of : ' + rpt_name_key);
  405. // console.log(keyMap);
  406. };
  407. for (let idx = 0; idx < pageRstArr.length; idx++) {
  408. let roleRel = null;
  409. for (const roleR of roleRelArr) {
  410. if (roleR.rpt_id === params.rpt_ids[idx]) {
  411. roleRel = JSON.parse(roleR.rel_content);
  412. // 这里要做些电子签名的signature_name转换,以防重名
  413. reAssignSignatureName(pageRstArr[idx], roleRel, params.rpt_names[idx]);
  414. rptRoleRelArr = rptRoleRelArr.concat(roleRel);
  415. break;
  416. }
  417. }
  418. }
  419. runnableRst.push(getExcelByPageData(pageRstArr, params.rptName, rptRoleRelArr));
  420. const uuidRst = await Promise.all(runnableRst);
  421. ctx.body = { data: uuidRst };
  422. ctx.status = 201;
  423. }
  424. async getFileByUUID(ctx) {
  425. // console.log('downloading : ' + ctx.params.uuid);
  426. const uuid = ctx.params.uuid;
  427. const rptName = ctx.params.rptName;
  428. const suffix = '.' + ctx.params.suffix;
  429. try {
  430. const rptNameURI = encodeURI(rptName);
  431. const filePath = this.app.baseDir + '/app/public/download/';
  432. // console.log('filePath: ' + filePath);
  433. // await this.ctx.helper.recursiveMkdirSync(this.app.baseDir + '/app/public/download');
  434. ctx.set({
  435. 'Content-Type': 'application/vnd.openxmlformats',
  436. 'Content-Disposition': 'attachment; filename="' + rptNameURI + suffix + "\"; filename*=utf-8''" + rptNameURI + suffix,
  437. });
  438. ctx.body = await fs.readFileSync(filePath + uuid + suffix);
  439. } catch (e) {
  440. console.log(e);
  441. }
  442. }
  443. /**
  444. * 更新用户通用报表显示配置
  445. *
  446. * @param {Object} ctx - egg全局context
  447. * @return {void}
  448. */
  449. async updateCustNode(ctx) {
  450. const params = JSON.parse(ctx.request.body.params);
  451. // console.log(params);
  452. const custId = this.ctx.session.sessionUser.accountId;
  453. const newNodeItems = JSON.stringify(params.nodeItems);
  454. const rst = await ctx.service.rptTreeNodeCust.updateCustNode(custId, newNodeItems);
  455. // console.log(rst);
  456. ctx.body = { data: rst };
  457. // ctx.body = { data: { msg: 'test the network' } };
  458. ctx.status = 201;
  459. }
  460. async setCustomDefine(ctx) {
  461. try {
  462. const data = JSON.parse(ctx.request.body.data);
  463. await this.ctx.service.rptCustomDefine.saveCustomSelect(data);
  464. // const sid = data.gather_select ? -1 : data.stage_id;
  465. // const filter = {tid: data.tender_id, sid: sid, rid: data.rpt_tpl_id};
  466. // const count = await ctx.service.rptCustomDefine.count(filter);
  467. // const updateData = {};
  468. // if (data.audit_select) updateData.audit_select = JSON.stringify(data.audit_select);
  469. // if (data.gather_select) updateData.gather_select = JSON.stringify(data.gather_select);
  470. // if (count > 0) {
  471. // await ctx.service.rptCustomDefine.update(updateData, filter);
  472. // } else {
  473. // updateData.tid = data.tender_id;
  474. // updateData.sid = sid;
  475. // updateData.rid = data.rpt_tpl_id;
  476. // await ctx.service.rptCustomDefine.db.insert(ctx.service.rptCustomDefine.tableName, updateData);
  477. // }
  478. const result = await this._getReport(ctx, data);
  479. ctx.body = { err: 0, msg: '', data: result };
  480. } catch (err) {
  481. ctx.helper.log(err);
  482. ctx.body = this.ajaxErrorBody(err, '保存数据出错');
  483. }
  484. }
  485. }
  486. return ReportController;
  487. };
  488. async function checkStg(ctx, params) {
  489. if (ctx.stage === null || ctx.stage === undefined || parseInt(ctx.stage.id) !== parseInt(params.stage_id)) {
  490. await ctx.service.stage.checkStage(params.stage_id);
  491. if (ctx.stage) {
  492. params.stage_order = ctx.stage.curOrder;
  493. }
  494. }
  495. }
  496. /*
  497. async function getReportData(ctx, params, filters, memFieldKeys) {
  498. const rst = {};
  499. const runnableRst = [];
  500. const runnableKey = []; // 这个配合runnableRst用,未来考虑并行查询优化
  501. // console.log('params');
  502. // console.log(params);
  503. // console.log('memFieldKeys');
  504. // console.log(memFieldKeys);
  505. for (const filter of filters) {
  506. if (runnableKey.indexOf(filter) < 0) {
  507. switch (filter) {
  508. case 'project' :
  509. runnableRst.push(ctx.service.project.getProjectById(params.project_id));
  510. runnableKey.push('project');
  511. break;
  512. case 'tender_info' :
  513. runnableRst.push(ctx.service.tenderInfo.getTenderInfo(params.tender_id));
  514. runnableKey.push('tender_info');
  515. break;
  516. case 'ledger' :
  517. runnableRst.push(ctx.service.ledger.getData(params.tender_id, 0));
  518. runnableKey.push('ledger');
  519. break;
  520. case 'deal_bills' :
  521. // console.log('has push deal_bills! ' + params.tender_id);
  522. runnableRst.push(ctx.service.dealBills.getDataByTenderId(params.tender_id));
  523. runnableKey.push('deal_bills');
  524. break;
  525. case 'stage_bills':
  526. runnableRst.push(ctx.service.stageBills.getLastestStageData(params.tender_id, params.stage_id));
  527. runnableKey.push('stage_bills');
  528. break;
  529. case 'stage_bills_final':
  530. await checkStg(ctx, params);
  531. // const stage = ctx.stage;
  532. // runnableRst.push(ctx.service.stageBillsFinal.getFinalDataEx(params.tender_id, params.stage_order));
  533. runnableRst.push(ctx.service.stageBillsFinal.getFinalDataEx(params.tender_id, ctx.stage.order));
  534. runnableKey.push('stage_bills_final');
  535. break;
  536. case 'stage':
  537. runnableRst.push(ctx.service.stage.getStageById(params.stage_id));
  538. runnableKey.push('stage');
  539. break;
  540. case 'stage_pay':
  541. await checkStg(ctx, params);
  542. // const stage2 = ctx.stage;
  543. // runnableRst.push(ctx.service.stagePay.getAuditorStageData(params.stage_id, params.stage_times, params.stage_order));
  544. runnableRst.push(ctx.service.stagePay.getAuditorStageData(params.stage_id, ctx.stage.times, ctx.stage.order));
  545. runnableKey.push('stage_pay');
  546. break;
  547. case 'mem_stage_im_zl':
  548. // memFieldKeys[filter]
  549. runnableRst.push(ctx.service.reportMemory.getStageImZlData(params.tender_id, params.stage_id, memFieldKeys[filter]));
  550. runnableKey.push(filter);
  551. break;
  552. case 'mem_month_progress':
  553. runnableRst.push(ctx.service.reportMemory.getMonthProgress(params.tender_id, memFieldKeys[filter]));
  554. runnableKey.push(filter);
  555. break;
  556. case 'mem_stage_bills':
  557. runnableRst.push(ctx.service.reportMemory.getStageBillsData(params.tender_id, params.stage_id, memFieldKeys[filter]));
  558. runnableKey.push(filter);
  559. break;
  560. case 'mem_stage_pos':
  561. runnableRst.push(ctx.service.reportMemory.getStagePosData(params.tender_id, params.stage_id, memFieldKeys[filter]));
  562. runnableKey.push(filter);
  563. break;
  564. case 'mem_stage_bills_compare':
  565. runnableRst.push(ctx.service.reportMemory.getStagePosData(params.tender_id, params.stage_id, memFieldKeys[filter]));
  566. runnableKey.push(filter);
  567. break;
  568. case 'change':
  569. runnableRst.push(ctx.service.change.getListByStatus(params.tender_id, 3)); // 获取所有审核通过的变更主信息
  570. runnableKey.push('change');
  571. break;
  572. case 'change_audit_list':
  573. runnableRst.push(ctx.service.changeAuditList.getChangeAuditBills(params.tender_id)); // 获取所有审核通过的变更清单
  574. runnableKey.push('change_audit_list');
  575. break;
  576. default:
  577. break;
  578. }
  579. }
  580. }
  581. const queryRst = await Promise.all(runnableRst);
  582. for (let idx = 0; idx < runnableKey.length; idx++) {
  583. rst[runnableKey[idx]] = queryRst[idx];
  584. }
  585. for (const filter of filters) {
  586. switch (filter) {
  587. case 'mem_stage_im_tz':
  588. rst[filter] = await ctx.service.reportMemory.getStageImTzData(params.tender_id, params.stage_id, memFieldKeys[filter]);
  589. break;
  590. case 'mem_stage_im_tz_bills':
  591. rst[filter] = await ctx.service.reportMemory.getStageImTzBillsData(params.tender_id, params.stage_id, memFieldKeys[filter]);
  592. break;
  593. default:
  594. break;
  595. }
  596. }
  597. return rst;
  598. }
  599. */
  600. async function getAllPagesCommon(ctx, rptTpl, params, option, outputType, baseDir, customSelect) {
  601. const rptDataUtil = new rptDataExtractor();
  602. rptDataUtil.initialize(rptTpl);
  603. const filter = rptDataUtil.getDataRequestFilter();
  604. // console.log(filter.tables);
  605. const rawDataObj = await ctx.service.report.getReportData(params, filter.tables, filter.memFieldKeys,
  606. rptTpl[JV.NODE_CUSTOM_DEFINE], customSelect);
  607. await ctx.helper.saveBufferFile(JSON.stringify(rawDataObj, '', '\t'), ctx.app.baseDir + '/mem.json');
  608. // console.log(rawDataObj);
  609. try {
  610. const printCom = JpcEx.createNew();
  611. if (params.pageSize) rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_PAGE_SIZE] = params.pageSize;
  612. if (params.orientation && (params.orientation !== 'null')) rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_ORIENTATION] = params.orientation;
  613. // let defProperties = await ctx.service.rptPreDefineCfg.getCfgById('Administrator');
  614. // defProperties = JSON.parse(defProperties[0].defined_content);
  615. const defProperties = RPT_DEF_PROPERTIES;
  616. // console.log('defProperties: ');
  617. // console.log(defProperties);
  618. // console.log('before assemble');
  619. const tplData = rptDataUtil.assembleData(ctx, rawDataObj, baseDir, printCom, customSelect);
  620. // console.log(tplData);
  621. if (params.custCfg) {
  622. setupCustomizeCfg(params.custCfg, rptTpl, defProperties);
  623. } else {
  624. // setupCustomizeCfg(defProperties, rptTpl, defProperties);
  625. }
  626. const dftOption = params.option || JV.PAGING_OPTION_NORMAL;
  627. printCom.initialize(rptTpl);
  628. // ctx.helper
  629. printCom.analyzeData(ctx.helper, rptTpl, tplData, defProperties, dftOption, outputType, customSelect);
  630. // console.log(JSON.stringify(rptTpl));
  631. const maxPages = printCom.totalPages;
  632. let pageRst = null;
  633. if (maxPages > 0) {
  634. pageRst = printCom.outputAsSimpleJSONPageArray(ctx.helper, rptTpl, tplData, 1, maxPages, defProperties, params.custCfg, customSelect);
  635. } else {
  636. pageRst = printCom.outputAsPreviewPage(rptTpl, defProperties);
  637. }
  638. // fsUtil.writeObjToFile(pageRst, 'D:/GitHome/temp/计量testBuiltPageResult.jsp');
  639. // console.log(pageRst);
  640. return pageRst;
  641. } catch (ex) {
  642. console.log('报表数据异常, tender id: ' + params.tender_id);
  643. console.log(ex);
  644. }
  645. }
  646. async function getMultiRptsCommon(ctx, params, outputType, baseDir) {
  647. const needCustomTables = ['mem_gather_stage_bills', 'mem_gather_deal_bills', 'mem_gather_stage_pay', 'mem_gather_tender_info'];
  648. for (let idx = 0; idx < params.rpt_ids.length; idx++) {
  649. params.rpt_ids[idx] = parseInt(params.rpt_ids[idx]); // 转换一下,以防万一
  650. }
  651. const rptTpls = await ctx.service.rptTpl.getAllTplByIds(params.rpt_ids);
  652. rptTpls.sort(function(rpt1, rpt2) {
  653. return params.rpt_ids.indexOf(rpt1.id) - params.rpt_ids.indexOf(rpt2.id);
  654. });
  655. for (let rtIdx = 0; rtIdx < rptTpls.length; rtIdx++) {
  656. const id = rptTpls[rtIdx].id;
  657. rptTpls[rtIdx] = JSON.parse(rptTpls[rtIdx].rpt_content);
  658. rptTpls[rtIdx].id = id;
  659. }
  660. const rptDataUtil = new rptDataExtractor();
  661. const filterTables = [];
  662. const memFieldKeys = {};
  663. if (rptTpls.length > 1) {
  664. rptTpls.sort(function(item1, item2) {
  665. const i1 = (item1._doc) ? item1._doc : item1;
  666. const i2 = (item2._doc) ? item2._doc : item2;
  667. const ID1 = params.rpt_ids.indexOf(i1[JV.PROP_ID]);
  668. const ID2 = params.rpt_ids.indexOf(i2[JV.PROP_ID]);
  669. return ID1 - ID2;
  670. });
  671. }
  672. for (const rptTpl of rptTpls) {
  673. rptDataUtil.initialize(rptTpl);
  674. const filter = rptDataUtil.getDataRequestFilter();
  675. // console.log(filter);
  676. for (const table of filter.tables) {
  677. if (filterTables.indexOf(table) < 0 && needCustomTables.indexOf(table) < 0) {
  678. filterTables.push(table);
  679. }
  680. // memFieldKeys[table] = [];
  681. }
  682. for (const tableKeyProp in filter.memFieldKeys) {
  683. if (needCustomTables.indexOf(tableKeyProp) >= 0) continue;
  684. if (!memFieldKeys.hasOwnProperty(tableKeyProp)) {
  685. memFieldKeys[tableKeyProp] = [];
  686. }
  687. for (const mfKey of filter.memFieldKeys[tableKeyProp]) {
  688. if (memFieldKeys[tableKeyProp].indexOf(mfKey) < 0) {
  689. memFieldKeys[tableKeyProp].push(mfKey);
  690. }
  691. }
  692. }
  693. }
  694. const rawDataObj = await ctx.service.report.getReportData(params, filterTables, memFieldKeys, {}, {});
  695. try {
  696. const rptPageRstArray = [];
  697. // 1. 这里只用一份数据,根据实际应用情况,先备份
  698. // const backupData = {};
  699. // for (let filterIdx = 0; filterIdx < filterTables.length; filterIdx++) {
  700. // backupData[filterTables[filterIdx]] = [];
  701. // Object.assign(backupData[filterTables[filterIdx]], rawDataObj[filterTables[filterIdx]]);
  702. // }
  703. // 2. 一个一个模板创建数据
  704. // let defProperties = await ctx.service.rptPreDefineCfg.getCfgById('Administrator');
  705. // defProperties = JSON.parse(defProperties[0].defined_content);
  706. const defProperties = RPT_DEF_PROPERTIES;
  707. for (let tplIdx = 0; tplIdx < rptTpls.length; tplIdx++) {
  708. const rptTpl = (rptTpls[tplIdx]._doc) ? rptTpls[tplIdx]._doc : rptTpls[tplIdx];
  709. rptDataUtil.initialize(rptTpl);
  710. const customSelect = rptTpl[JV.NODE_CUSTOM_DEFINE] && rptTpl[JV.NODE_CUSTOM_DEFINE][JV.NODE_CUS_AUDIT_SELECT].enable
  711. ? await ctx.service.rptCustomDefine.getCustomDefine(params.tender_id, params.stage_id, rptTpl.id)
  712. : await ctx.service.rptCustomDefine.getCustomDefine(params.tender_id, -1, rptTpl.id);
  713. // 从汇总的rawDataObj中拷贝所需数据表至curRawDataObj,以供后续使用
  714. const curRawDataObj = {};
  715. const filter = rptDataUtil.getDataRequestFilter();
  716. for (const table of filter.tables) {
  717. curRawDataObj[table] = ctx.helper.clone(rawDataObj[table]);
  718. }
  719. // 如果是用户交互类型的表,则应该单独获取数据
  720. if (params.customSelect && params.customSelect[tplIdx]) {
  721. const cfTables = [], cmFieldKeys = [];
  722. const curFilter = rptDataUtil.getDataRequestFilter();
  723. for (const table of curFilter.tables) {
  724. if (needCustomTables.indexOf(table) >= 0) {
  725. cfTables.push(table);
  726. }
  727. }
  728. for (const tableKeyProp in filter.memFieldKeys) {
  729. if (needCustomTables.indexOf(tableKeyProp) < 0) continue;
  730. if (!cmFieldKeys.hasOwnProperty(tableKeyProp)) {
  731. cmFieldKeys[tableKeyProp] = [];
  732. }
  733. for (const mfKey of filter.memFieldKeys[tableKeyProp]) {
  734. if (cmFieldKeys[tableKeyProp].indexOf(mfKey) < 0) {
  735. cmFieldKeys[tableKeyProp].push(mfKey);
  736. }
  737. }
  738. }
  739. console.log(customSelect);
  740. const customRawDataObj = await ctx.service.report.getReportData(params, cfTables, cmFieldKeys,
  741. rptTpl[JV.NODE_CUSTOM_DEFINE], customSelect);
  742. console.log(customRawDataObj);
  743. for (const prop in customRawDataObj) {
  744. curRawDataObj[prop] = customRawDataObj[prop];
  745. }
  746. }
  747. const tplData = rptDataUtil.assembleData(ctx, curRawDataObj, baseDir, null, customSelect);
  748. const printCom = JpcEx.createNew();
  749. rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_PAGE_SIZE] = params.pageSize;
  750. if (params.pageSize) rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_PAGE_SIZE] = params.pageSize;
  751. if (params.orientation && (params.orientation !== 'null')) rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_ORIENTATION] = params.orientation;
  752. if (params.custCfg) setupCustomizeCfg(params.custCfg, rptTpl, defProperties);
  753. const dftOption = params.option || JV.PAGING_OPTION_NORMAL;
  754. printCom.initialize(rptTpl);
  755. // console.log(rptTpl);
  756. printCom.analyzeData(ctx.helper, rptTpl, tplData, defProperties, dftOption, outputType, customSelect);
  757. const maxPages = printCom.totalPages;
  758. let pageRst = null;
  759. // console.log(maxPages);
  760. if (maxPages > 0) {
  761. pageRst = printCom.outputAsSimpleJSONPageArray(ctx.helper, rptTpl, tplData, 1, maxPages, defProperties, params.custCfg, customSelect);
  762. } else {
  763. pageRst = printCom.outputAsPreviewPage(rptTpl, defProperties);
  764. }
  765. rptPageRstArray.push(pageRst);
  766. // 注意:这里需要把备份数据assign回去!!!
  767. // if (tplIdx < rptTpls.length - 1) {
  768. // for (let filterIdx = 0; filterIdx < filterTables.length; filterIdx++) {
  769. // backupData[filterTables[filterIdx]] = [];
  770. // Object.assign(rawDataObj[filterTables[filterIdx]], backupData[filterTables[filterIdx]]);
  771. // }
  772. // }
  773. }
  774. return rptPageRstArray;
  775. } catch (ex) {
  776. console.log('报表数据异常(getMultiRptsCommon): project_id ' + params.project_id + ', tender_id: ' + params.tender_id + ', stage_id: ' + params.stage_id);
  777. console.log(ex);
  778. } finally {
  779. //
  780. }
  781. }
  782. function setupCustomizeCfg(customizeCfg, rptTpl, defProperties) {
  783. const tmpObj = {};
  784. // 1. 字体
  785. const newFonts = [];
  786. for (const font of defProperties.fonts) {
  787. const copyFont = {};
  788. copyFont.ID = font.ID;
  789. for (const fontProp of JV.FONT_PROPS) {
  790. copyFont[fontProp] = font[fontProp];
  791. }
  792. newFonts.push(copyFont);
  793. tmpObj[font.ID] = copyFont;
  794. }
  795. const private_setup_font = function(propStr, newFont) {
  796. if (tmpObj[propStr]) {
  797. tmpObj[propStr].Name = newFont.Name;
  798. tmpObj[propStr].FontHeight = String(newFont.FontHeight);
  799. tmpObj[propStr].FontBold = newFont.FontBold;
  800. tmpObj[propStr].FontItalic = newFont.FontItalic;
  801. tmpObj[propStr].FontUnderline = newFont.FontUnderline;
  802. }
  803. };
  804. for (const custFont of customizeCfg.fonts) {
  805. switch (custFont.CfgDispName) {
  806. case '表标题':
  807. private_setup_font('ReportTitle_Main', custFont);
  808. break;
  809. case '列标题':
  810. private_setup_font('HeaderColumn', custFont);
  811. private_setup_font('FooterColumn', custFont);
  812. break;
  813. case '正文内容':
  814. private_setup_font('Content', custFont);
  815. break;
  816. case '合计':
  817. private_setup_font('GrandTotal', custFont);
  818. private_setup_font('SectionTotal', custFont);
  819. break;
  820. case '表眉/表脚':
  821. private_setup_font('Header', custFont);
  822. private_setup_font('Footer', custFont);
  823. break;
  824. default:
  825. break;
  826. }
  827. }
  828. // 1.1 窄体
  829. if (tmpObj.Content_Narrow) {
  830. if (customizeCfg.isNarrow) {
  831. tmpObj.Content_Narrow.Name = 'Arial Narrow';
  832. } else {
  833. if (tmpObj.Content) {
  834. tmpObj.Content_Narrow.Name = tmpObj.Content.Name;
  835. } else {
  836. tmpObj.Content_Narrow.Name = '宋体';
  837. }
  838. }
  839. }
  840. defProperties.fonts = newFonts;
  841. // 2. 页边距
  842. rptTpl[JV.NODE_MAIN_INFO][JV.NODE_MARGINS][JV.PROP_LEFT] = customizeCfg.margins[JV.PROP_LEFT] / 10;
  843. rptTpl[JV.NODE_MAIN_INFO][JV.NODE_MARGINS][JV.PROP_RIGHT] = customizeCfg.margins[JV.PROP_RIGHT] / 10;
  844. rptTpl[JV.NODE_MAIN_INFO][JV.NODE_MARGINS][JV.PROP_TOP] = customizeCfg.margins[JV.PROP_TOP] / 10;
  845. rptTpl[JV.NODE_MAIN_INFO][JV.NODE_MARGINS][JV.PROP_BOTTOM] = customizeCfg.margins[JV.PROP_BOTTOM] / 10;
  846. // 3. 边框宽度
  847. if (customizeCfg.hasOwnProperty('borderThick')) {
  848. for (let i = 0; i < defProperties.styles.length; i++) {
  849. const style = defProperties.styles[i];
  850. if (style.ID === 'BORDER_ALL_AROUND') {
  851. for (const border of style.border_style) {
  852. border.LineWeight = customizeCfg.borderThick;
  853. }
  854. }
  855. }
  856. }
  857. // 4. 边框竖线
  858. if (!(customizeCfg.showVerticalLine)) {
  859. const private_copy_border = function(src) {
  860. const rst = {};
  861. rst.Position = src.Position;
  862. rst.LineWeight = src.LineWeight;
  863. rst.DashStyle = src.DashStyle;
  864. rst.Color = src.Color;
  865. return rst;
  866. };
  867. const newStyles = [];
  868. for (let i = 0; i < defProperties.styles.length; i++) {
  869. const style = defProperties.styles[i];
  870. newStyles.push(style);
  871. if (style.ID === 'BORDER_ALL_AROUND') {
  872. const newStyle = {};
  873. newStyle.ID = style.ID;
  874. newStyle.CfgDispName = style.CfgDispName;
  875. newStyle.border_style = [];
  876. for (const border of style.border_style) {
  877. const newBorder = private_copy_border(border);
  878. newStyle.border_style.push(newBorder);
  879. if (border.Position === 'Left' || border.Position === 'Right') {
  880. newBorder.LineWeight = 0;
  881. }
  882. }
  883. newStyles[newStyles.length - 1] = newStyle;
  884. }
  885. }
  886. defProperties.styles = newStyles;
  887. }
  888. // 5. 补0
  889. const private_Setup_Format = function(tabFields) {
  890. if (tabFields) {
  891. for (const tabField of tabFields) {
  892. if (tabField[JV.PROP_FORMAT]) {
  893. tabField[JV.PROP_FORMAT] = tabField[JV.PROP_FORMAT].replace(new RegExp('#', 'gm'), '0');
  894. }
  895. }
  896. }
  897. };
  898. if (customizeCfg.fillZero) {
  899. if (rptTpl[JV.NODE_FLOW_INFO]) {
  900. if (rptTpl[JV.NODE_FLOW_INFO][JV.NODE_FLOW_CONTENT]) private_Setup_Format(rptTpl[JV.NODE_FLOW_INFO][JV.NODE_FLOW_CONTENT][JV.PROP_FLOW_FIELDS]);
  901. if (rptTpl[JV.NODE_FLOW_INFO][JV.NODE_FLOW_PAGE_SUM]) private_Setup_Format(rptTpl[JV.NODE_FLOW_INFO][JV.NODE_FLOW_PAGE_SUM][JV.PROP_SUM_FIELDS]);
  902. if (rptTpl[JV.NODE_FLOW_INFO][JV.NODE_FLOW_SEG_SUM]) private_Setup_Format(rptTpl[JV.NODE_FLOW_INFO][JV.NODE_FLOW_SEG_SUM][JV.PROP_SUM_FIELDS]);
  903. if (rptTpl[JV.NODE_FLOW_INFO][JV.NODE_FLOW_GROUP] && rptTpl[JV.NODE_FLOW_INFO][JV.NODE_FLOW_GROUP][JV.PROP_GROUP_LINES]) private_Setup_Format(rptTpl[JV.NODE_FLOW_INFO][JV.NODE_FLOW_GROUP][JV.PROP_GROUP_LINES][JV.PROP_SUM_FIELDS]);
  904. if (rptTpl[JV.NODE_FLOW_INFO][JV.NODE_DISCRETE_INFO]) {
  905. for (const discrete of rptTpl[JV.NODE_FLOW_INFO][JV.NODE_DISCRETE_INFO]) {
  906. private_Setup_Format(discrete[JV.PROP_DISCRETE_FIELDS]);
  907. }
  908. }
  909. if (rptTpl[JV.NODE_FLOW_INFO_EX]) {
  910. if (rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_CONTENT]) private_Setup_Format(rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_CONTENT][JV.PROP_FLOW_FIELDS]);
  911. if (rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_PAGE_SUM]) private_Setup_Format(rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_PAGE_SUM][JV.PROP_SUM_FIELDS]);
  912. if (rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_SEG_SUM]) private_Setup_Format(rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_SEG_SUM][JV.PROP_SUM_FIELDS]);
  913. if (rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_GROUP]) private_Setup_Format(rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_GROUP][JV.PROP_SUM_FIELDS]);
  914. if (rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_GROUP] && rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_GROUP][JV.PROP_GROUP_LINES]) private_Setup_Format(rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_GROUP][JV.PROP_GROUP_LINES][JV.PROP_SUM_FIELDS]);
  915. if (rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_DISCRETE_INFO]) {
  916. for (const discrete of rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_DISCRETE_INFO]) {
  917. private_Setup_Format(discrete[JV.PROP_DISCRETE_FIELDS]);
  918. }
  919. }
  920. }
  921. } else if (rptTpl[JV.NODE_BILL_INFO]) {
  922. if (rptTpl[JV.NODE_BILL_INFO][JV.NODE_BILL_CONTENT]) private_Setup_Format(rptTpl[JV.NODE_BILL_INFO][JV.NODE_BILL_CONTENT][JV.PROP_BILL_FIELDS]);
  923. if (rptTpl[JV.NODE_BILL_INFO][JV.NODE_DISCRETE_INFO]) {
  924. for (const discrete of rptTpl[JV.NODE_BILL_INFO][JV.NODE_DISCRETE_INFO]) {
  925. private_Setup_Format(discrete[JV.PROP_DISCRETE_FIELDS]);
  926. }
  927. }
  928. } else if (rptTpl[JV.NODE_CROSS_INFO]) {
  929. if (rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_CONTENT]) private_Setup_Format(rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_CONTENT][JV.TAB_CROSS_FIELDS]);
  930. if (rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW]) private_Setup_Format(rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW][JV.TAB_CROSS_FIELDS]);
  931. if (rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_COL]) private_Setup_Format(rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_COL][JV.TAB_CROSS_FIELDS]);
  932. if (rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_COL_SUM]) private_Setup_Format(rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_COL_SUM][JV.TAB_CROSS_FIELDS]);
  933. if (rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW_EXT]) private_Setup_Format(rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW_EXT][JV.TAB_CROSS_FIELDS]);
  934. if (rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW_SUM_EXT]) private_Setup_Format(rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW_SUM_EXT][JV.TAB_CROSS_FIELDS]);
  935. if (rptTpl[JV.NODE_CROSS_INFO][JV.NODE_DISCRETE_INFO]) {
  936. for (const discrete of rptTpl[JV.NODE_CROSS_INFO][JV.NODE_DISCRETE_INFO]) {
  937. private_Setup_Format(discrete[JV.PROP_DISCRETE_FIELDS]);
  938. }
  939. }
  940. }
  941. }
  942. }
  943. function isFileExisted(file) {
  944. return new Promise(function(resolve, reject) {
  945. fs.access(file, err => {
  946. if (err) {
  947. reject(false);
  948. } else {
  949. resolve(true);
  950. }
  951. });
  952. });
  953. }
  954. async function encodeSignatureDataUri(roleRel, baseDir) {
  955. if (roleRel) {
  956. for (const singleRoleRel of roleRel) {
  957. const roleRelContent = JSON.parse(singleRoleRel.rel_content);
  958. for (const role of roleRelContent) {
  959. // console.log(role);
  960. if (role.sign_path !== '') {
  961. const filePath = baseDir + '/app' + role.sign_path;
  962. try {
  963. const res = await isFileExisted(filePath);
  964. if (res) {
  965. const bData = fs.readFileSync(filePath);
  966. const base64Str = bData.toString('base64');
  967. const datauri = 'data:image/png;base64,' + base64Str;
  968. role.sign_pic = datauri;
  969. } else {
  970. console.log('文件不存在:' + filePath);
  971. }
  972. } catch (err) {
  973. console.error(err);
  974. }
  975. }
  976. }
  977. singleRoleRel.rel_content = JSON.stringify(roleRelContent);
  978. }
  979. }
  980. }
  981. async function encodeDummySignatureDataUri(pageRst, baseDir) {
  982. if (pageRst) {
  983. for (const page of pageRst.items) {
  984. for (const signature of page.signature_cells) {
  985. if (signature.signature_name === JV.SIGNATURE_NAME_DUMMY) {
  986. if (signature.path !== '') {
  987. const filePath = baseDir + '/app' + signature.path;
  988. try {
  989. const res = await isFileExisted(filePath);
  990. if (res) {
  991. const bData = fs.readFileSync(filePath);
  992. const base64Str = bData.toString('base64');
  993. const datauri = 'data:image/png;base64,' + base64Str;
  994. signature.pic = datauri;
  995. signature.path = '';
  996. } else {
  997. console.log('文件不存在:' + filePath);
  998. }
  999. } catch (err) {
  1000. console.error(err);
  1001. }
  1002. }
  1003. }
  1004. }
  1005. }
  1006. }
  1007. }
  1008. async function createDownloadJob(ctx, baseUuid) {
  1009. const params = JSON.parse(ctx.request.body.params);
  1010. const baseDir = this.app.baseDir;
  1011. function getExcelByPageData(pageRst, rpt_name, innerRoleRel) {
  1012. return new Promise(function(resolve, reject) {
  1013. rpt_xl_util.exportExcel(pageRst, params.pageSize, rpt_name, params.isOneSheet, null, null, baseDir, innerRoleRel,
  1014. (err, uuidName) => {
  1015. if (err) return reject(err);
  1016. const fileRst = { uuid: uuidName, reportName: rpt_name };
  1017. resolve(fileRst);
  1018. }
  1019. );
  1020. });
  1021. }
  1022. const roleRelArr = (params.stage_status === 3) ? (await ctx.service.roleRptRel.getRoleRptRelByDetailIds(params.tender_id, params.rpt_ids, params.stage_id)) : [];
  1023. const pageRstArr = await getMultiRptsCommon(ctx, params, JV.OUTPUT_TYPE_NORMAL, this.app.baseDir);
  1024. await this.ctx.helper.recursiveMkdirSync(this.app.baseDir + '/app/public/download');
  1025. const runnableRst = [];
  1026. for (let idx = 0; idx < pageRstArr.length; idx++) {
  1027. let roleRel = null;
  1028. for (const roleR of roleRelArr) {
  1029. if (roleR.rpt_id === params.rpt_ids[idx]) {
  1030. roleRel = JSON.parse(roleR.rel_content);
  1031. break;
  1032. }
  1033. }
  1034. // console.log('roleRel.rel_content: ' + roleRel.rel_content);
  1035. // fsUtil.writeObjToFile(pageRstArr, 'D:/GitHome/temp/testBuiltPageResult.jsp');
  1036. runnableRst.push(getExcelByPageData(pageRstArr[idx], params.rpt_names[idx], roleRel));
  1037. }
  1038. const uuidRst = await Promise.all(runnableRst);
  1039. /*
  1040. const params = JSON.parse(ctx.request.body.params);
  1041. await this._saveCustomSelects(params);
  1042. const baseDir = this.app.baseDir;
  1043. function getExcelByPageData(pageRst, rpt_name, innerRoleRel) {
  1044. return new Promise(function(resolve, reject) {
  1045. rpt_xl_util.exportExcel(pageRst, params.pageSize, rpt_name, params.isOneSheet, null, null, baseDir, innerRoleRel,
  1046. (err, uuidName) => {
  1047. if (err) return reject(err);
  1048. const fileRst = { uuid: uuidName, reportName: rpt_name };
  1049. resolve(fileRst);
  1050. }
  1051. );
  1052. });
  1053. }
  1054. const roleRelArr = (params.stage_status === 3) ? (await ctx.service.roleRptRel.getRoleRptRelByDetailIds(params.tender_id, params.rpt_ids, params.stage_id)) : [];
  1055. // const roleRel = (params.stage_status === 3) ? (await ctx.service.roleRptRel.getRoleRptRelByDetailIds(params.tender_id, params.rpt_tpl_id)) : [];
  1056. const pageRstArr = await getMultiRptsCommon(ctx, params, JV.OUTPUT_TYPE_NORMAL, this.app.baseDir);
  1057. await this.ctx.helper.recursiveMkdirSync(this.app.baseDir + '/app/public/download');
  1058. const runnableRst = [];
  1059. for (let idx = 0; idx < pageRstArr.length; idx++) {
  1060. let roleRel = null;
  1061. for (const roleR of roleRelArr) {
  1062. if (roleR.rpt_id === params.rpt_ids[idx]) {
  1063. roleRel = JSON.parse(roleR.rel_content);
  1064. break;
  1065. }
  1066. }
  1067. // console.log('roleRel.rel_content: ' + roleRel.rel_content);
  1068. // fsUtil.writeObjToFile(pageRstArr, 'D:/GitHome/temp/testBuiltPageResult.jsp');
  1069. runnableRst.push(getExcelByPageData(pageRstArr[idx], params.rpt_names[idx], roleRel));
  1070. }
  1071. // fsUtil.writeObjToFile(pageRstArr, 'D:/GitHome/temp/计量导出pageArr.js');
  1072. const uuidRst = await Promise.all(runnableRst);
  1073. ctx.body = { data: uuidRst };
  1074. ctx.status = 201;
  1075. //*/
  1076. }