report_controller.js 25 KB

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