report_controller.js 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563
  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 accountGroup = require('../const/account_group').group;
  8. const JpcEx = require('../reports/rpt_component/jpc_ex');
  9. const JV = require('../reports/rpt_component/jpc_value_define');
  10. const rpt_xl_util = require('../reports/util/rpt_excel_util');
  11. const rptDataExtractor = require('../reports/util/rpt_calculation_data_util');
  12. const fsUtil = require('../public/js/fsUtil');
  13. const fs = require('fs');
  14. module.exports = app => {
  15. class ReportController extends app.BaseController {
  16. /**
  17. * 报表显示页面
  18. *
  19. * @param {Object} ctx - egg全局context
  20. * @return {void}
  21. */
  22. async index(ctx) {
  23. try {
  24. const tender = ctx.tender;
  25. const stage = ctx.stage;
  26. // console.log(tender.data);
  27. // console.log(stage);
  28. let stage_id = -1;
  29. let stage_order = -1;
  30. let stage_times = -1;
  31. let stage_status = -1;
  32. const treeNodes = await ctx.service.rptTreeNode.getNodesByProjectId([-1, tender.data.project_id]);
  33. const custCfg = await ctx.service.rptCustomizeCfg.getCustomizeCfgByUserId('Administrator');
  34. const stageList = await ctx.service.stage.getValidStagesShort(tender.id);
  35. const prjAccList = await ctx.service.projectAccount.getAllAccountByProjectId(tender.data.project_id);
  36. const roleList = await ctx.service.signatureRole.getSignatureRolesByTenderId(tender.id);
  37. // console.log(maxStageAmt[0].maxAmt);
  38. if (stage !== null && stage !== undefined) {
  39. stage_id = stage.id;
  40. stage_order = stage.order;
  41. stage_times = stage.times;
  42. stage_status = stage.status;
  43. }
  44. for (const prjAcc of prjAccList) {
  45. prjAcc.account_group = accountGroup[prjAcc.account_group];
  46. }
  47. const renderData = {
  48. tender: tender.data,
  49. tenderInfo: tender.info,
  50. rpt_tpl_data: JSON.stringify(treeNodes),
  51. cust_cfg: JSON.stringify(custCfg),
  52. project_id: tender.data.project_id,
  53. tender_id: tender.id,
  54. stg_id: stage_id,
  55. stg_order: stage_order,
  56. stg_times: stage_times,
  57. stg_status: stage_status,
  58. stage_list: JSON.stringify(stageList),
  59. prj_account_list: JSON.stringify(prjAccList),
  60. role_list: JSON.stringify(roleList),
  61. tenderMenu,
  62. preUrl: '/tender/' + tender.id,
  63. measureType,
  64. // jsFiles: this.app.jsFiles.common.concat(this.app.jsFiles.ledger.explode),
  65. };
  66. await this.layout('report/index.ejs', renderData, 'report/rpt_all_popup.ejs');
  67. // await this.layout('report/index.ejs', renderData);
  68. } catch (err) {
  69. this.log(err);
  70. console.log(err);
  71. // ctx.redirect('/tender/' + ctx.tender.id);
  72. }
  73. }
  74. /**
  75. * 报表打印页面
  76. *
  77. * @param {Object} ctx - egg全局context
  78. * @return {void}
  79. */
  80. async showPrintPage(ctx) {
  81. try {
  82. // const params = JSON.parse(ctx.request.body.params);
  83. const pageSize = ctx.params.size;
  84. // console.log('pageSize: ' + pageSize);
  85. const renderData = {
  86. size: pageSize,
  87. // orientation: params.orientation,
  88. };
  89. if (pageSize === 'A3') {
  90. await ctx.render('report/rpt_printA3.ejs', renderData);
  91. } else {
  92. await ctx.render('report/rpt_print.ejs', renderData);
  93. }
  94. } catch (err) {
  95. this.log(err);
  96. console.log(err);
  97. }
  98. }
  99. /**
  100. * 获取报表数据
  101. *
  102. * @param {Object} ctx - egg全局context
  103. * @return {void}
  104. */
  105. async getReport(ctx) {
  106. try {
  107. // console.log('in getReport');
  108. const params = JSON.parse(ctx.request.body.params);
  109. // console.log(params);
  110. let rptTpl = await ctx.service.rptTpl.getTplById(params.rpt_tpl_id);
  111. if (!rptTpl || rptTpl.length !== 1) {
  112. throw '获取模板失败';
  113. }
  114. rptTpl = JSON.parse(rptTpl[0].rpt_content);
  115. // console.log('get the template!');
  116. const pageRst = await getAllPagesCommon(ctx, rptTpl, params, JV.PAGING_OPTION_NORMAL, JV.OUTPUT_TYPE_NORMAL);
  117. // console.log(pageRst);
  118. const roleRel = await ctx.service.roleRptRel.getRoleRptRelByDetailIds(params.tender_id, params.rpt_tpl_id);
  119. const stgAudit = await ctx.service.stageAudit.getStageAudit(params.stage_id, params.stage_times);
  120. encodeSignatureDataUri(roleRel, this.app.baseDir);
  121. ctx.body = { data: pageRst, signatureRelInfo: roleRel, stageAudit: stgAudit };
  122. // ctx.body = { data: { msg: 'test the network' } };
  123. ctx.status = 201;
  124. } catch (ex) {
  125. this.setMessage(ex.toString(), this.messageType.ERROR);
  126. }
  127. }
  128. /**
  129. * 获取多批次报表数据
  130. *
  131. * @param {Object} ctx - egg全局context
  132. * @return {void}
  133. */
  134. async getMultiReportsEx(ctx) {
  135. // 原则说明:把所有报表模板集中获取,统一filter,只读一次数据!
  136. const params = JSON.parse(ctx.request.body.params);
  137. const pageRstArr = await getMultiRptsCommon(ctx, params, JV.OUTPUT_TYPE_NORMAL);
  138. const roleRel = await ctx.service.roleRptRel.getRoleRptRelByDetailIds(params.tender_id, params.rpt_ids);
  139. encodeSignatureDataUri(roleRel, this.app.baseDir);
  140. // console.log(pageRstArr);
  141. ctx.body = { data: pageRstArr, signatureRelInfo: roleRel };
  142. ctx.status = 201;
  143. }
  144. async createExcelFilesEx(ctx) {
  145. const params = JSON.parse(ctx.request.body.params);
  146. const baseDir = this.app.baseDir;
  147. function getExcelByPageData(pageRst, rpt_name) {
  148. return new Promise(function(resolve, reject) {
  149. rpt_xl_util.exportExcel(pageRst, params.pageSize, rpt_name, params.isOneSheet, null, null, baseDir, (err, uuidName) => {
  150. if (err) return reject(err);
  151. const fileRst = { uuid: uuidName, reportName: rpt_name };
  152. resolve(fileRst);
  153. });
  154. });
  155. }
  156. const pageRstArr = await getMultiRptsCommon(ctx, params, JV.OUTPUT_TYPE_NORMAL);
  157. const runnableRst = [];
  158. for (let idx = 0; idx < pageRstArr.length; idx++) {
  159. runnableRst.push(getExcelByPageData(pageRstArr[idx], params.rpt_names[idx]));
  160. }
  161. const uuidRst = await Promise.all(runnableRst);
  162. ctx.body = { data: uuidRst };
  163. ctx.status = 201;
  164. }
  165. async getFileByUUID(ctx) {
  166. // console.log('downloading : ' + ctx.params.uuid);
  167. const uuid = ctx.params.uuid;
  168. const rptName = ctx.params.rptName;
  169. const suffix = '.' + ctx.params.suffix;
  170. function getUuidFile(filestream) {
  171. return new Promise(function(resolve, reject) {
  172. filestream.on('data', function(chunk) {
  173. resolve(chunk);
  174. });
  175. });
  176. }
  177. try {
  178. const rptNameURI = encodeURI(rptName);
  179. const filePath = this.app.baseDir + '/app/public/download/';
  180. const filestream = fs.createReadStream(filePath + uuid + suffix);
  181. const chunk = await getUuidFile(filestream);
  182. ctx.set({
  183. 'Content-Type': 'application/vnd.openxmlformats',
  184. 'Content-Disposition': 'attachment; filename="' + rptNameURI + suffix + "\"; filename*=utf-8''" + rptNameURI + suffix,
  185. 'Content-Length': chunk.length,
  186. });
  187. ctx.body = chunk;
  188. } catch (e) {
  189. console.log(e);
  190. }
  191. }
  192. }
  193. return ReportController;
  194. };
  195. async function getReportData(ctx, params, filters) {
  196. const rst = {};
  197. const runnableRst = [];
  198. const runnableKey = []; // 这个配合runnableRst用,未来考虑并行查询优化
  199. for (const filter of filters) {
  200. switch (filter) {
  201. case 'project' :
  202. runnableRst.push(ctx.service.project.getProjectById(params.project_id));
  203. runnableKey.push('project');
  204. break;
  205. case 'tender_info' :
  206. runnableRst.push(ctx.service.tenderInfo.getTenderInfo(params.tender_id));
  207. runnableKey.push('tender_info');
  208. break;
  209. case 'ledger' :
  210. runnableRst.push(ctx.service.ledger.getData(params.tender_id, 0));
  211. runnableKey.push('ledger');
  212. break;
  213. case 'stage_bills':
  214. runnableRst.push(ctx.service.stageBills.getLastestStageData(params.tender_id, params.stage_id));
  215. runnableKey.push('stage_bills');
  216. break;
  217. case 'stage_bills_final':
  218. runnableRst.push(ctx.service.stageBillsFinal.getFinalDataEx(params.tender_id, params.stage_order));
  219. runnableKey.push('stage_bills_final');
  220. break;
  221. case 'stage':
  222. runnableRst.push(ctx.service.stage.getStageById(params.stage_id));
  223. runnableKey.push('stage');
  224. break;
  225. case 'stage_pay':
  226. runnableRst.push(ctx.service.stagePay.getAuditorStageData(params.stage_id, params.stage_times, params.stage_order));
  227. runnableKey.push('stage_pay');
  228. break;
  229. default:
  230. break;
  231. }
  232. }
  233. const queryRst = await Promise.all(runnableRst);
  234. for (let idx = 0; idx < runnableKey.length; idx++) {
  235. rst[runnableKey[idx]] = queryRst[idx];
  236. // console.log(runnableKey[idx]);
  237. // if (rst[runnableKey[idx]] instanceof Array) console.log('is Array')
  238. // else console.log('is not Array');
  239. }
  240. return rst;
  241. }
  242. async function getAllPagesCommon(ctx, rptTpl, params, option, outputType) {
  243. // let rptTpl = null;
  244. const rptDataUtil = new rptDataExtractor();
  245. rptDataUtil.initialize(rptTpl);
  246. // console.log(rptTpl);
  247. const filter = rptDataUtil.getDataRequestFilter();
  248. // console.log(filter.tables);
  249. const rawDataObj = await getReportData(ctx, params, filter.tables);
  250. // console.log(rawDataObj);
  251. try {
  252. // console.log('before assemble');
  253. const tplData = rptDataUtil.assembleData(rawDataObj);
  254. // console.log(tplData);
  255. const printCom = JpcEx.createNew();
  256. if (params.pageSize) rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_PAGE_SIZE] = params.pageSize;
  257. if (params.orientation && (params.orientation !== 'null')) rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_ORIENTATION] = params.orientation;
  258. let defProperties = await ctx.service.rptPreDefineCfg.getCfgById('Administrator');
  259. // console.log('defProperties: ');
  260. // console.log(defProperties[0].defined_content);
  261. defProperties = JSON.parse(defProperties[0].defined_content);
  262. if (params.custCfg) {
  263. setupCustomizeCfg(params.custCfg, rptTpl, defProperties);
  264. } else {
  265. // setupCustomizeCfg(defProperties, rptTpl, defProperties);
  266. }
  267. const dftOption = params.option || JV.PAGING_OPTION_NORMAL;
  268. printCom.initialize(rptTpl);
  269. printCom.analyzeData(rptTpl, tplData, defProperties, dftOption, outputType);
  270. const maxPages = printCom.totalPages;
  271. let pageRst = null;
  272. if (maxPages > 0) {
  273. pageRst = printCom.outputAsSimpleJSONPageArray(rptTpl, tplData, 1, maxPages, defProperties, params.custCfg);
  274. } else {
  275. pageRst = printCom.outputAsPreviewPage(rptTpl, defProperties);
  276. }
  277. if (pageRst) {
  278. // fsUtil.writeObjToFile(pageRst, 'D:/GitHome/temp/testBuiltPageResult.jsp');
  279. } else {
  280. //
  281. }
  282. // console.log(pageRst);
  283. return pageRst;
  284. } catch (ex) {
  285. // console.log("报表数据异常: userId " + user_id + ", project id: " + prj_id);
  286. console.log(ex);
  287. }
  288. }
  289. async function getMultiRptsCommon(ctx, params, outputType) {
  290. for (let idx = 0; idx < params.rpt_ids.length; idx++) {
  291. params.rpt_ids[idx] = parseInt(params.rpt_ids[idx]); // 转换一下,以防万一
  292. }
  293. const rptTpls = await ctx.service.rptTpl.getTplById(params.rpt_ids);
  294. // console.log(rptTpls);
  295. for (let rtIdx = 0; rtIdx < rptTpls.length; rtIdx++) {
  296. rptTpls[rtIdx] = JSON.parse(rptTpls[rtIdx].rpt_content);
  297. }
  298. const rptDataUtil = new rptDataExtractor();
  299. const filterTables = [];
  300. if (rptTpls.length > 1) {
  301. rptTpls.sort(function(item1, item2) {
  302. const i1 = (item1._doc) ? item1._doc : item1;
  303. const i2 = (item2._doc) ? item2._doc : item2;
  304. const ID1 = params.rpt_ids.indexOf(i1[JV.PROP_ID]);
  305. const ID2 = params.rpt_ids.indexOf(i2[JV.PROP_ID]);
  306. return ID1 - ID2;
  307. });
  308. }
  309. for (const rptTpl of rptTpls) {
  310. rptDataUtil.initialize(rptTpl);
  311. const filter = rptDataUtil.getDataRequestFilter();
  312. // console.log(filter);
  313. for (const table of filter.tables) {
  314. if (filterTables.indexOf(table) < 0) {
  315. filterTables.push(table);
  316. }
  317. }
  318. }
  319. const rawDataObj = await getReportData(ctx, params, filterTables);
  320. try {
  321. const rptPageRstArray = [];
  322. // 1. 这里只用一份数据,根据实际应用情况,先备份
  323. const backupData = {};
  324. for (let filterIdx = 0; filterIdx < filterTables.length; filterIdx++) {
  325. backupData[filterTables[filterIdx]] = [];
  326. Object.assign(backupData[filterTables[filterIdx]], rawDataObj[filterTables[filterIdx]]);
  327. }
  328. // 2. 一个一个模板创建数据
  329. let defProperties = await ctx.service.rptPreDefineCfg.getCfgById('Administrator');
  330. // console.log('defProperties: ');
  331. // console.log(defProperties[0].defined_content);
  332. defProperties = JSON.parse(defProperties[0].defined_content);
  333. for (let tplIdx = 0; tplIdx < rptTpls.length; tplIdx++) {
  334. const rptTpl = (rptTpls[tplIdx]._doc) ? rptTpls[tplIdx]._doc : rptTpls[tplIdx];
  335. rptDataUtil.initialize(rptTpl);
  336. const tplData = rptDataUtil.assembleData(rawDataObj);
  337. const printCom = JpcEx.createNew();
  338. rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_PAGE_SIZE] = params.pageSize;
  339. if (params.pageSize) rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_PAGE_SIZE] = params.pageSize;
  340. if (params.orientation && (params.orientation !== 'null')) rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_ORIENTATION] = params.orientation;
  341. if (params.custCfg) setupCustomizeCfg(params.custCfg, rptTpl, defProperties);
  342. const dftOption = params.option || JV.PAGING_OPTION_NORMAL;
  343. printCom.initialize(rptTpl);
  344. printCom.analyzeData(rptTpl, tplData, defProperties, dftOption, outputType);
  345. const maxPages = printCom.totalPages;
  346. let pageRst = null;
  347. if (maxPages > 0) {
  348. pageRst = printCom.outputAsSimpleJSONPageArray(rptTpl, tplData, 1, maxPages, defProperties, params.custCfg);
  349. } else {
  350. pageRst = printCom.outputAsPreviewPage(rptTpl, defProperties);
  351. }
  352. rptPageRstArray.push(pageRst);
  353. // 注意:这里需要把备份数据assign回去!!!
  354. if (tplIdx < rptTpls.length - 1) {
  355. for (let filterIdx = 0; filterIdx < filterTables.length; filterIdx++) {
  356. backupData[filterTables[filterIdx]] = [];
  357. Object.assign(rawDataObj[filterTables[filterIdx]], backupData[filterTables[filterIdx]]);
  358. }
  359. }
  360. }
  361. return rptPageRstArray;
  362. } catch (ex) {
  363. console.log('报表数据异常(getMultiRptsCommon): project_id ' + params.project_id + ', tender_id: ' + params.tender_id + ', stage_id: ' + params.stage_id);
  364. console.log(ex);
  365. } finally {
  366. //
  367. }
  368. }
  369. function setupCustomizeCfg(customizeCfg, rptTpl, defProperties) {
  370. const tmpObj = {};
  371. // 1. 字体
  372. const newFonts = [];
  373. for (const font of defProperties.fonts) {
  374. const copyFont = {};
  375. copyFont.ID = font.ID;
  376. for (const fontProp of JV.FONT_PROPS) {
  377. copyFont[fontProp] = font[fontProp];
  378. }
  379. newFonts.push(copyFont);
  380. tmpObj[font.ID] = copyFont;
  381. }
  382. const private_setup_font = function(propStr, newFont) {
  383. if (tmpObj[propStr]) {
  384. tmpObj[propStr].Name = newFont.Name;
  385. tmpObj[propStr].FontHeight = String(newFont.FontHeight);
  386. tmpObj[propStr].FontBold = newFont.FontBold;
  387. tmpObj[propStr].FontItalic = newFont.FontItalic;
  388. tmpObj[propStr].FontUnderline = newFont.FontUnderline;
  389. }
  390. };
  391. for (const custFont of customizeCfg.fonts) {
  392. switch (custFont.CfgDispName) {
  393. case '表标题':
  394. private_setup_font('ReportTitle_Main', custFont);
  395. break;
  396. case '列标题':
  397. private_setup_font('HeaderColumn', custFont);
  398. private_setup_font('FooterColumn', custFont);
  399. break;
  400. case '正文内容':
  401. private_setup_font('Content', custFont);
  402. break;
  403. case '合计':
  404. private_setup_font('GrandTotal', custFont);
  405. private_setup_font('SectionTotal', custFont);
  406. break;
  407. case '表眉/表脚':
  408. private_setup_font('Header', custFont);
  409. private_setup_font('Footer', custFont);
  410. break;
  411. default:
  412. break;
  413. }
  414. }
  415. // 1.1 窄体
  416. if (tmpObj.Content_Narrow) {
  417. if (customizeCfg.isNarrow) {
  418. tmpObj.Content_Narrow.Name = 'Arial Narrow';
  419. } else {
  420. if (tmpObj.Content) {
  421. tmpObj.Content_Narrow.Name = tmpObj.Content.Name;
  422. } else {
  423. tmpObj.Content_Narrow.Name = '宋体';
  424. }
  425. }
  426. }
  427. defProperties.fonts = newFonts;
  428. // 2. 页边距
  429. rptTpl[JV.NODE_MAIN_INFO][JV.NODE_MARGINS][JV.PROP_LEFT] = customizeCfg.margins[JV.PROP_LEFT] / 10;
  430. rptTpl[JV.NODE_MAIN_INFO][JV.NODE_MARGINS][JV.PROP_RIGHT] = customizeCfg.margins[JV.PROP_RIGHT] / 10;
  431. rptTpl[JV.NODE_MAIN_INFO][JV.NODE_MARGINS][JV.PROP_TOP] = customizeCfg.margins[JV.PROP_TOP] / 10;
  432. rptTpl[JV.NODE_MAIN_INFO][JV.NODE_MARGINS][JV.PROP_BOTTOM] = customizeCfg.margins[JV.PROP_BOTTOM] / 10;
  433. // 3. 边框宽度
  434. if (customizeCfg.hasOwnProperty('borderThick')) {
  435. for (let i = 0; i < defProperties.styles.length; i++) {
  436. const style = defProperties.styles[i];
  437. if (style.ID === 'BORDER_ALL_AROUND') {
  438. for (const border of style.border_style) {
  439. border.LineWeight = customizeCfg.borderThick;
  440. }
  441. }
  442. }
  443. }
  444. // 4. 边框竖线
  445. if (!(customizeCfg.showVerticalLine)) {
  446. const private_copy_border = function(src) {
  447. const rst = {};
  448. rst.Position = src.Position;
  449. rst.LineWeight = src.LineWeight;
  450. rst.DashStyle = src.DashStyle;
  451. rst.Color = src.Color;
  452. return rst;
  453. };
  454. const newStyles = [];
  455. for (let i = 0; i < defProperties.styles.length; i++) {
  456. const style = defProperties.styles[i];
  457. newStyles.push(style);
  458. if (style.ID === 'BORDER_ALL_AROUND') {
  459. const newStyle = {};
  460. newStyle.ID = style.ID;
  461. newStyle.CfgDispName = style.CfgDispName;
  462. newStyle.border_style = [];
  463. for (const border of style.border_style) {
  464. const newBorder = private_copy_border(border);
  465. newStyle.border_style.push(newBorder);
  466. if (border.Position === 'Left' || border.Position === 'Right') {
  467. newBorder.LineWeight = 0;
  468. }
  469. }
  470. newStyles[newStyles.length - 1] = newStyle;
  471. }
  472. }
  473. defProperties.styles = newStyles;
  474. }
  475. // 5. 补0
  476. const private_Setup_Format = function(tabFields) {
  477. if (tabFields) {
  478. for (const tabField of tabFields) {
  479. if (tabField[JV.PROP_FORMAT]) {
  480. tabField[JV.PROP_FORMAT] = tabField[JV.PROP_FORMAT].replace(new RegExp('#', 'gm'), '0');
  481. }
  482. }
  483. }
  484. };
  485. if (customizeCfg.fillZero) {
  486. if (rptTpl[JV.NODE_FLOW_INFO]) {
  487. 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]);
  488. 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]);
  489. 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]);
  490. 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]);
  491. if (rptTpl[JV.NODE_FLOW_INFO][JV.NODE_DISCRETE_INFO]) {
  492. for (const discrete of rptTpl[JV.NODE_FLOW_INFO][JV.NODE_DISCRETE_INFO]) {
  493. private_Setup_Format(discrete[JV.PROP_DISCRETE_FIELDS]);
  494. }
  495. }
  496. if (rptTpl[JV.NODE_FLOW_INFO_EX]) {
  497. 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]);
  498. 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]);
  499. 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]);
  500. 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]);
  501. 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]);
  502. if (rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_DISCRETE_INFO]) {
  503. for (const discrete of rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_DISCRETE_INFO]) {
  504. private_Setup_Format(discrete[JV.PROP_DISCRETE_FIELDS]);
  505. }
  506. }
  507. }
  508. } else if (rptTpl[JV.NODE_BILL_INFO]) {
  509. 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]);
  510. if (rptTpl[JV.NODE_BILL_INFO][JV.NODE_DISCRETE_INFO]) {
  511. for (const discrete of rptTpl[JV.NODE_BILL_INFO][JV.NODE_DISCRETE_INFO]) {
  512. private_Setup_Format(discrete[JV.PROP_DISCRETE_FIELDS]);
  513. }
  514. }
  515. } else if (rptTpl[JV.NODE_CROSS_INFO]) {
  516. 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]);
  517. 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]);
  518. 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]);
  519. 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]);
  520. 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]);
  521. 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]);
  522. if (rptTpl[JV.NODE_CROSS_INFO][JV.NODE_DISCRETE_INFO]) {
  523. for (const discrete of rptTpl[JV.NODE_CROSS_INFO][JV.NODE_DISCRETE_INFO]) {
  524. private_Setup_Format(discrete[JV.PROP_DISCRETE_FIELDS]);
  525. }
  526. }
  527. }
  528. }
  529. }
  530. function encodeSignatureDataUri(roleRel, baseDir) {
  531. for (const singleRoleRel of roleRel) {
  532. const roleRelContent = JSON.parse(singleRoleRel.rel_content);
  533. for (const role of roleRelContent) {
  534. if (role.sign_path !== '') {
  535. const filePath = baseDir + '/app' + role.sign_path;
  536. const bData = fs.readFileSync(filePath);
  537. const base64Str = bData.toString('base64');
  538. const datauri = 'data:image/png;base64,' + base64Str;
  539. role.sign_pic = datauri;
  540. // fsUtil.writeObjToFile(datauri, 'D:/Temp/imageDataUri.txt');
  541. }
  542. }
  543. singleRoleRel.rel_content = JSON.stringify(roleRelContent);
  544. }
  545. }