jpc_flow_tab.js 102 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735
  1. 'use strict';
  2. const JV = require('./jpc_value_define');
  3. const JE = require('./jpc_rte');
  4. const JpcFieldHelper = require('./helper/jpc_helper_field');
  5. const JpcBandHelper = require('./helper/jpc_helper_band');
  6. const JpcBand = require('./jpc_band');
  7. const JpcFlowTabHelper = require('./helper/jpc_helper_flow_tab');
  8. const JpcCommonHelper = require('./helper/jpc_helper_common');
  9. const JpcDiscreteHelper = require('./helper/jpc_helper_discrete');
  10. const JpcTextHelper = require('./helper/jpc_helper_text');
  11. const JpcCommonOutputHelper = require('./helper/jpc_helper_common_output');
  12. const JpcAreaHelper = require('./helper/jpc_helper_area');
  13. const fsUtil = require('../public/fsUtil');
  14. const strUtil = require('../public/stringUtil');
  15. const fontWidthMap = require('./helper/jpc_helper_font_width');
  16. const bc = require('../../lib/base_calc.js');
  17. const SEG_PAGE_SPLIT_STR = '`';
  18. const PAGESIZE_THRESHOLD = 2000; // 报表页码的上限值
  19. const JpcFlowTabSrv = function() {};
  20. JpcFlowTabSrv.prototype.createNew = function() {
  21. // grpPageInfo :{"segGrpRecStartIdx": 0, "insertedGrpRecAmt": 0, "preAddPageGrpInfo": null}; //纯属解释参数grpPageInfo结构
  22. // valueIdx: [isFollowMode, type(normal, auto-height, group), valueIndex, sub-value-index(自动行高特有), total-value-amount(自动行高特有)] //解释 dispValueIdxLst 数据构造
  23. function private_addPageValue(ValuedIdxLst, sortedSequence, grpSequenceInfo, startRecIdx, maxRecPerPage, page_seg_map, segIdx, pageIdx, grpPageInfo, isFollow, segAutoHeightInfo, prePageLeftAutoHeightRecAmt) {
  24. let vIdx = [];
  25. const vFirstIdx = [];
  26. let preAmt = 0;
  27. let insertedGrpAmt = 0;
  28. let grp_lines = 0;
  29. let hasPrePageGrp = false;
  30. const followMode = (isFollow) ? JV.TYPE_FOLLOW_MODE : -1;
  31. let nextPageAutoHeightRecAmt = 0;
  32. if (grpSequenceInfo && grpPageInfo) {
  33. if (grpPageInfo[JV.PROP_PRE_ADD_GRP_REC_INFO].length > 0) {
  34. for (const grpLineIdx of grpPageInfo[JV.PROP_PRE_ADD_GRP_REC_INFO]) {
  35. // vIdx.push([followMode, JV.DISPLAY_VAL_TYPE_GROUP, grpPageInfo[JV.PROP_SEG_GRP_IDX], grpLineIdx]);
  36. vFirstIdx.push([followMode, JV.DISPLAY_VAL_TYPE_GROUP, grpPageInfo[JV.PROP_SEG_GRP_IDX], grpLineIdx]);
  37. }
  38. grpPageInfo[JV.PROP_SEG_GRP_IDX]++;
  39. }
  40. preAmt = grpPageInfo[JV.PROP_PRE_ADD_GRP_REC_INFO].length;
  41. grpPageInfo[JV.PROP_PRE_ADD_GRP_REC_INFO] = [];
  42. grp_lines = grpPageInfo[JV.PROP_GRP_LINES];
  43. }
  44. let autoHeightAmt = 0;
  45. const private_addAutoHeightPageValue = function(vi) {
  46. let couldBreak = false;
  47. let startIdx = 0;
  48. let ttlValAmt = 0;
  49. if (segAutoHeightInfo[segIdx].length > startRecIdx + vi) {
  50. ttlValAmt = segAutoHeightInfo[segIdx][startRecIdx + vi];
  51. }
  52. if (prePageLeftAutoHeightRecAmt > 0 && vi === 0) {
  53. startIdx = prePageLeftAutoHeightRecAmt;
  54. }
  55. for (let subValIdx = startIdx; subValIdx < ttlValAmt; subValIdx++) {
  56. vIdx.push([followMode, JV.DISPLAY_VAL_TYPE_AUTO_HEIGHT, sortedSequence[startRecIdx + vi], subValIdx, ttlValAmt]);
  57. autoHeightAmt++;
  58. if (autoHeightAmt >= maxRecPerPage) {
  59. nextPageAutoHeightRecAmt = (subValIdx + 1) % ttlValAmt;
  60. couldBreak = true;
  61. break;
  62. }
  63. }
  64. return couldBreak;
  65. };
  66. const private_inner_add_grp_rec = function(vi) {
  67. let hasFullGrp = true;
  68. let couldBreak = false;
  69. for (let i = 0; i < grp_lines; i++) {
  70. if (vIdx.length >= maxRecPerPage) {
  71. if (grp_lines === 1) {
  72. hasPrePageGrp = true; // 在此情况下,说明最后一条记录应该是group,但是不够正常空间,那么就硬塞这1条数据!
  73. vIdx.push([followMode, JV.DISPLAY_VAL_TYPE_GROUP, grpPageInfo[JV.PROP_SEG_GRP_IDX], i]);
  74. } else {
  75. for (let j = i; j < grp_lines; j++) {
  76. grpPageInfo[JV.PROP_PRE_ADD_GRP_REC_INFO].push(j);
  77. }
  78. // 准备要跳出去了
  79. hasFullGrp = false;
  80. }
  81. break;
  82. } else {
  83. vIdx.push([followMode, JV.DISPLAY_VAL_TYPE_GROUP, grpPageInfo[JV.PROP_SEG_GRP_IDX], i]);
  84. }
  85. }
  86. // 3. 进位下一个group信息所在位置
  87. if (hasFullGrp) {
  88. grpPageInfo[JV.PROP_INSERTED_GRP_REC]++;
  89. insertedGrpAmt++;
  90. grpPageInfo[JV.PROP_SEG_GRP_IDX]++;
  91. } else {
  92. couldBreak = true;
  93. }
  94. return couldBreak;
  95. };
  96. const private_normal_add_rec = function(vi) {
  97. let couldBreak = false;
  98. if (segAutoHeightInfo && segAutoHeightInfo.length > 0) {
  99. if (segAutoHeightInfo[segIdx].length > startRecIdx + vi) {
  100. couldBreak = private_addAutoHeightPageValue(vi);
  101. // if (couldBreak) break;
  102. } else if (vIdx.length < maxRecPerPage) {
  103. vIdx.push([followMode, JV.DISPLAY_VAL_TYPE_NORMAL, JV.BLANK_VALUE_INDEX]);
  104. }
  105. } else {
  106. if (sortedSequence.length > startRecIdx + vi) {
  107. vIdx.push([followMode, JV.DISPLAY_VAL_TYPE_NORMAL, sortedSequence[startRecIdx + vi]]);
  108. } else {
  109. vIdx.push([followMode, JV.DISPLAY_VAL_TYPE_NORMAL, JV.BLANK_VALUE_INDEX]);
  110. }
  111. }
  112. return couldBreak;
  113. };
  114. for (let vi = 0; (vi + insertedGrpAmt * grp_lines) < maxRecPerPage - preAmt; vi++) {
  115. if (grpSequenceInfo && grpPageInfo) {
  116. if ((startRecIdx + vi) === grpSequenceInfo[grpPageInfo[JV.PROP_SEG_GRP_IDX]]) {
  117. // 表示这里要插入grouping信息!
  118. let couldBreak = false;
  119. // 1. 首先push正常的记录(要考虑自动行高调整的分支)
  120. if (segAutoHeightInfo && segAutoHeightInfo.length > 0) {
  121. couldBreak = private_addAutoHeightPageValue(vi);
  122. } else {
  123. vIdx.push([followMode, JV.DISPLAY_VAL_TYPE_NORMAL, sortedSequence[startRecIdx + vi]]);
  124. }
  125. // 2. 然后就要push grouping记录了
  126. if (private_inner_add_grp_rec(vi)) break;
  127. if (couldBreak) break;
  128. } else {
  129. // 备注: 在有group的情况下,如果grpPageInfo[JV.PROP_SEG_GRP_IDX] 范围大于 grpSequenceInfo.length,则表示已经到最后了,不要再加空白数据了
  130. // !!!但这是在有ex数据的情况下!!!
  131. if (grpPageInfo[JV.PROP_SEG_GRP_IDX] < grpSequenceInfo.length) {
  132. if (private_normal_add_rec(vi)) break;
  133. } else {
  134. // 还得判断是否是普通的流水数据情况,这里可以用isFollow来进行判断,暂时不需要特意加新参数(以后如isFollow的意义有变化则需要调整)
  135. if (!isFollow) {
  136. if (private_normal_add_rec(vi)) break;
  137. } else {
  138. break;
  139. }
  140. }
  141. }
  142. } else {
  143. if (private_normal_add_rec(vi)) break;
  144. }
  145. }
  146. if (vFirstIdx.length > 0) {
  147. vIdx = vIdx.concat(vFirstIdx);
  148. // 备注: 在一开始就加grp的情况下,这些数据应该放在后面才对
  149. }
  150. page_seg_map.push([pageIdx, segIdx]);
  151. ValuedIdxLst.push(vIdx);
  152. return nextPageAutoHeightRecAmt;
  153. }
  154. const JpcFlowTabResult = {};
  155. JpcFlowTabResult.initialize = function(isEx) {
  156. const me = this;
  157. me.isEx = isEx;
  158. me.paging_option = JV.PAGING_OPTION_NORMAL;
  159. me.segments = [];
  160. me.dispValueIdxLst = [];
  161. me.page_seg_map = [];
  162. me.disp_fields_idx = [];
  163. me.disp_fields_ex_idx = [];
  164. me.seg_sum_fields_idx = [];
  165. me.seg_sum_tab_fields = [];
  166. me.page_sum_fields_idx = [];
  167. me.page_sum_tab_fields = [];
  168. me.auto_height_fields_idx = [];// 那些被标记为判断自动行高的指标集合
  169. me.auto_height_info = [];
  170. me.group_check_fields = [];
  171. me.group_sum_fields = [];
  172. me.group_sum_values = null;
  173. me.group_node_info = null; // 记录在哪个seg及到哪条记录后有group sum信息
  174. me.group_lines_amt = 0; // 每group一次占用多少行,计算page信息会用到
  175. me.pageStatusLst = [];
  176. me.groupSumValLst = [];
  177. me.segSumValLst = [];
  178. me.pageSumValLst = [];
  179. me.multiCols = 1;
  180. me.pagesAmt = 0;
  181. me.signatureRst = [];
  182. me.signatureDateRst = [];
  183. me.signatureAuditRst = [];
  184. me.interactRst = [];
  185. me.hasBreakFlowArr = [];
  186. };
  187. JpcFlowTabResult.sorting = function(rptTpl, dataObj, dataSeq, $CURRENT_RPT) {
  188. const me = this;
  189. const FLOW_NODE_STR = me.isEx ? JV.NODE_FLOW_INFO_EX : JV.NODE_FLOW_INFO;
  190. if (rptTpl[FLOW_NODE_STR][JV.NODE_FLOW_SEG_SUM]) JpcFieldHelper.findAndPutDataFieldIdx(rptTpl, rptTpl[FLOW_NODE_STR][JV.NODE_FLOW_SEG_SUM][JV.PROP_SUM_FIELDS], me.seg_sum_tab_fields, me.seg_sum_fields_idx, me.isEx);
  191. if (rptTpl[FLOW_NODE_STR][JV.NODE_FLOW_PAGE_SUM]) JpcFieldHelper.findAndPutDataFieldIdx(rptTpl, rptTpl[FLOW_NODE_STR][JV.NODE_FLOW_PAGE_SUM][JV.PROP_SUM_FIELDS], me.page_sum_tab_fields, me.page_sum_fields_idx, me.isEx);
  192. if (rptTpl[FLOW_NODE_STR][JV.NODE_FLOW_GROUP]) {
  193. JpcFieldHelper.findAndPutDataFieldIdx(rptTpl, rptTpl[FLOW_NODE_STR][JV.NODE_FLOW_GROUP][JV.PROP_GROUP_FIELDS], me.group_check_fields, null, me.isEx);
  194. if (rptTpl[FLOW_NODE_STR][JV.NODE_FLOW_GROUP][JV.PROP_GROUP_LINES]) {
  195. for (const grpLine of rptTpl[FLOW_NODE_STR][JV.NODE_FLOW_GROUP][JV.PROP_GROUP_LINES]) {
  196. if (grpLine[JV.PROP_GROUP_SUM_KEYS] && grpLine[JV.PROP_GROUP_SUM_KEYS].length > 0) {
  197. JpcFieldHelper.findAndPutDataFieldIdx(rptTpl, grpLine[JV.PROP_GROUP_SUM_KEYS], me.group_sum_fields, null, me.isEx);
  198. }
  199. }
  200. }
  201. for (const grp_sum_f of me.group_sum_fields) {
  202. grp_sum_f[JV.PROP_SUM_KEY] = 'grp_sum_key_' + grp_sum_f[JV.PROP_FIELD_ID];
  203. }
  204. }
  205. JpcFieldHelper.findAutoHeightFieldIdx(rptTpl, rptTpl[FLOW_NODE_STR][JV.NODE_FLOW_CONTENT][JV.PROP_FLOW_FIELDS], me.auto_height_fields_idx, me.isEx);
  206. for (let si = 0; si < dataSeq.length; si++) {
  207. me.segments.push(dataSeq[si].slice(0));
  208. }
  209. // pre-sum the data(for seg sum display)
  210. // 考虑到实际会有离散指标的汇总,这些离散指标数据是通过计算式后得来的,这种情况下,不适宜在sorting阶段进行汇总统计,现挪到preSetupPages阶段处理
  211. };
  212. JpcFlowTabResult.sumSeg = function(dataObj, $CURRENT_RPT) {
  213. const me = this;
  214. const data_details = me.isEx ? dataObj[JV.DATA_DETAIL_DATA_EX] : dataObj[JV.DATA_DETAIL_DATA];
  215. const data_fields = [];
  216. for (let i = 0; i < me.seg_sum_fields_idx.length; i++) {
  217. if (typeof (me.seg_sum_fields_idx[i]) === 'object') {
  218. const exField = JE.F(me.seg_sum_fields_idx[i][JV.PROP_ID], $CURRENT_RPT);
  219. if (exField) {
  220. data_fields.push(exField[JV.PROP_AD_HOC_DATA]);
  221. } else {
  222. data_fields.push(null);
  223. }
  224. } else {
  225. const data_field = data_details[me.seg_sum_fields_idx[i]];
  226. data_fields.push(data_field);
  227. }
  228. }
  229. for (let i = 0; i < me.segments.length; i++) { // seg level
  230. if (me.segments[i].length > 0) {
  231. const rowGrandTotal = [];
  232. for (let di = 0; di < data_fields.length; di++) {
  233. rowGrandTotal.push(0.0);
  234. let precisionAmt = 4;
  235. const sum_field = JE.F(me.seg_sum_tab_fields[di][JV.PROP_FIELD_ID], $CURRENT_RPT);
  236. if (sum_field[JV.PROP_PRECISION] && sum_field[JV.PROP_PRECISION].type === 'fixed') {
  237. precisionAmt = sum_field[JV.PROP_FIXED_PRECISION_AMT];
  238. } else {
  239. const flowF = me.seg_sum_tab_fields[di];
  240. if (flowF && !strUtil.isEmptyString(flowF[JV.PROP_FORMAT])) {
  241. const idx = flowF[JV.PROP_FORMAT].indexOf('.');
  242. if (idx >= 0) {
  243. precisionAmt = flowF[JV.PROP_FORMAT].length - idx - 1;
  244. }
  245. }
  246. }
  247. // for (let j = 0; j < me.segments[i].length; j++) {
  248. // // 3. start to sum
  249. // // rowGrandTotal[di] = rowGrandTotal[di] + 1.0 * JpcFieldHelper.getValue(data_fields[di], me.segments[i][j]);
  250. // const sv = JpcFieldHelper.getValue(data_fields[di], me.segments[i][j]);
  251. // if (sv) {
  252. // rowGrandTotal[di] = rowGrandTotal[di] + parseFloat(parseFloat(sv).toFixed(precisionAmt));
  253. // }
  254. // }
  255. for (let j = 0; j < me.segments[i].length; j++) {
  256. let sv = JpcFieldHelper.getValue(data_fields[di], me.segments[i][j]);
  257. if (sv) {
  258. if (typeof sv === 'string') sv = parseFloat(sv);
  259. rowGrandTotal[di] = bc.add(rowGrandTotal[di] ? rowGrandTotal[di] : 0, sv ? sv : 0);
  260. }
  261. }
  262. }
  263. me.segSumValLst.push(rowGrandTotal);
  264. }
  265. }
  266. };
  267. JpcFlowTabResult.sumUpGrp = function(rptTpl, $CURRENT_RPT, dataObj, segIdx, preGrpIdx, nexGrpIdx) {
  268. const me = this;
  269. const segDataIdx = me.segments[segIdx];
  270. for (let j = 0; j < me.group_sum_fields.length; j++) {
  271. const sum_field = JE.F(me.group_sum_fields[j][JV.PROP_FIELD_ID], $CURRENT_RPT);
  272. if (sum_field) {
  273. let data_field = null;
  274. if (sum_field[JV.PROP_AD_HOC_DATA]) {
  275. data_field = sum_field[JV.PROP_AD_HOC_DATA];
  276. } else {
  277. data_field = dataObj[sum_field.DataNodeName][sum_field.DataSeq];
  278. }
  279. let sumV = 0;
  280. let precisionAmt = 4;
  281. for (let si = preGrpIdx; si <= nexGrpIdx; si++) {
  282. if (sum_field[JV.PROP_PRECISION] && sum_field[JV.PROP_PRECISION].type === 'fixed') {
  283. precisionAmt = sum_field[JV.PROP_FIXED_PRECISION_AMT];
  284. } else {
  285. const flowF = me.group_sum_fields[j]; // 调整后,me.group_sum_fields[j]就是group lines下数组SumKey_S的元素值,无需再找
  286. if (flowF && !strUtil.isEmptyString(flowF[JV.PROP_FORMAT])) {
  287. const idx = flowF[JV.PROP_FORMAT].indexOf('.');
  288. if (idx >= 0) {
  289. precisionAmt = flowF[JV.PROP_FORMAT].length - idx - 1;
  290. }
  291. }
  292. }
  293. // sumV += parseFloat(JpcFieldHelper.getValue(data_field, segDataIdx[si]));
  294. let sv = JpcFieldHelper.getValue(data_field, segDataIdx[si]);
  295. if (sv) {
  296. if (typeof sv === 'string') sv = parseFloat(sv);
  297. sumV = bc.add(sumV, sv ? sv : 0);
  298. }
  299. // sumV += parseFloat(parseFloat(JpcFieldHelper.getValue(data_field, segDataIdx[si])).toFixed(precisionAmt));
  300. }
  301. // me.group_sum_values[segIdx][j].push(sumV);
  302. me.group_sum_values[segIdx][me.group_sum_fields[j][JV.PROP_SUM_KEY]].push(sumV);
  303. }
  304. }
  305. me.group_node_info[segIdx].push(nexGrpIdx);
  306. };
  307. JpcFlowTabResult.setupGroupingData = function(rptTpl, dataObj, $CURRENT_RPT) {
  308. const me = this;
  309. if (me.group_check_fields.length > 0 && me.group_sum_fields.length > 0) {
  310. me.group_sum_values = [];
  311. me.group_node_info = [];
  312. const CURRENT_FLOW_INFO = (me.isEx) ? JV.NODE_FLOW_INFO_EX : JV.NODE_FLOW_INFO;
  313. me.group_lines_amt = rptTpl[CURRENT_FLOW_INFO][JV.NODE_FLOW_GROUP][JV.PROP_GROUP_LINES].length;
  314. let preGrpIdx = 0;
  315. let nexGrpIdx = 0;
  316. for (let segIdx = 0; segIdx < me.segments.length; segIdx++) {
  317. const segDataIdx = me.segments[segIdx];
  318. // me.group_sum_values.push([]);
  319. me.group_sum_values.push({});
  320. me.group_node_info.push([]);
  321. for (let j = 0; j < me.group_sum_fields.length; j++) {
  322. // me.group_sum_values[segIdx].push([]);
  323. me.group_sum_values[segIdx][me.group_sum_fields[j][JV.PROP_SUM_KEY]] = [];
  324. // me.group_node_info[segIdx].push([]);
  325. }
  326. for (let di = 0; di < segDataIdx.length; di++) {
  327. let hasDiff = false;
  328. if (di >= 1) {
  329. for (let i = 0; i < me.group_check_fields.length; i++) {
  330. const grp_field = JE.F(me.group_check_fields[i][JV.PROP_FIELD_ID], $CURRENT_RPT);
  331. if (grp_field) {
  332. let data_field = null;
  333. if (grp_field[JV.PROP_AD_HOC_DATA]) {
  334. data_field = grp_field[JV.PROP_AD_HOC_DATA];
  335. } else {
  336. data_field = dataObj[grp_field.DataNodeName][grp_field.DataSeq];
  337. }
  338. const v1 = JpcFieldHelper.getValue(data_field, segDataIdx[di]);
  339. const v2 = JpcFieldHelper.getValue(data_field, segDataIdx[di - 1]);
  340. if (v1 !== v2) {
  341. hasDiff = true;
  342. break;
  343. }
  344. }
  345. }
  346. }
  347. if (hasDiff) {
  348. // then sum up the fields
  349. me.sumUpGrp(rptTpl, $CURRENT_RPT, dataObj, segIdx, preGrpIdx, nexGrpIdx);
  350. nexGrpIdx = di;
  351. preGrpIdx = di;
  352. if (di === segDataIdx.length - 1) {
  353. me.sumUpGrp(rptTpl, $CURRENT_RPT, dataObj, segIdx, preGrpIdx, nexGrpIdx);
  354. }
  355. } else if (di === segDataIdx.length - 1) {
  356. me.sumUpGrp(rptTpl, $CURRENT_RPT, dataObj, segIdx, preGrpIdx, di);
  357. } else {
  358. nexGrpIdx = di;
  359. }
  360. }
  361. }
  362. }
  363. };
  364. JpcFlowTabResult.setupAutoHeightData = function(bands, segIdx, rptTpl, dataObj, $CURRENT_RPT, defProperties, outputType) {
  365. const me = this;
  366. if (me.auto_height_fields_idx.length > 0) {
  367. const CURRENT_FLOW_INFO = (me.isEx) ? JV.NODE_FLOW_INFO_EX : JV.NODE_FLOW_INFO;
  368. const band = bands[rptTpl[CURRENT_FLOW_INFO][JV.NODE_FLOW_CONTENT][JV.PROP_BAND_NAME]];
  369. const data_details = me.isEx ? dataObj[JV.DATA_DETAIL_DATA_EX] : dataObj[JV.DATA_DETAIL_DATA];
  370. const tab_fields = rptTpl[CURRENT_FLOW_INFO][JV.NODE_FLOW_CONTENT][JV.PROP_FLOW_FIELDS];
  371. const adHocAutoHeightStyleStr = [];
  372. const reg1 = new RegExp('\n\r', 'g');
  373. const reg2 = new RegExp('\r\n', 'g');
  374. const reg3 = new RegExp('\n', 'g');
  375. const reg4 = new RegExp('\r', 'g');
  376. const reg5 = new RegExp('\t', 'g');
  377. const fonts = defProperties.fonts;
  378. const fontCache = {};
  379. const private_get_font = function(fontKey) {
  380. let rst = null;
  381. if (fontCache[fontKey]) {
  382. rst = fontCache[fontKey];
  383. } else {
  384. for (let i = 0; i < fonts.length; i++) {
  385. if (fonts[i][JV.PROP_ID] === fontKey) {
  386. fontCache[fontKey] = fonts[i];
  387. rst = fonts[i];
  388. break;
  389. }
  390. }
  391. }
  392. return rst;
  393. };
  394. const private_get_max_lines_of_the_record = function(theRecIdx) {
  395. let rst = 1;
  396. let maxAmt = 1;
  397. for (let loop = 0; loop < me.auto_height_fields_idx.length; loop++) {
  398. /*
  399. let data_field = null;
  400. let tab_field = me.auto_height_fields_idx[loop][1];
  401. if (me.auto_height_fields_idx[loop][0] !== JV.BLANK_FIELD_INDEX) {
  402. data_field = data_details[me.auto_height_fields_idx[loop][0]];
  403. }
  404. /*/
  405. const tab_field = me.auto_height_fields_idx[loop][1];
  406. let data_field = null;
  407. const map_data_field = JE.F(tab_field[JV.PROP_FIELD_ID], $CURRENT_RPT);
  408. if (me.auto_height_fields_idx[loop][0] !== JV.BLANK_FIELD_INDEX && (typeof me.auto_height_fields_idx[loop][0] !== 'object')) {
  409. data_field = data_details[me.auto_height_fields_idx[loop][0]];
  410. } else {
  411. if (map_data_field) {
  412. data_field = map_data_field[JV.PROP_AD_HOC_DATA];
  413. }
  414. }
  415. // */
  416. if (data_field) {
  417. let value = JpcFieldHelper.getValue(data_field, theRecIdx);
  418. const area = JpcAreaHelper.outputArea(tab_field[JV.PROP_AREA], band, 1, 1, 0, 1, 0, 1, 0, false, false);
  419. if (value !== null && value !== undefined) {
  420. if (typeof value === 'string') {
  421. value = value.replace('\t', '');
  422. value = value.replace(reg1, '|').replace(reg2, '|').replace(reg3, '|').replace(reg4, '|').replace(reg5, '');
  423. } else {
  424. value = '' + value;
  425. }
  426. } else {
  427. value = '';
  428. }
  429. JpcFieldHelper.setValue(data_field, theRecIdx, value);
  430. const values = value.split('|');
  431. // if (values.length > rst) rst = values.length; // 考虑到紧凑输出,不能那么快设置rst
  432. const font = private_get_font(tab_field[JV.PROP_FONT]);
  433. let chkFontName = '宋体';
  434. let chkFontHeight = 12;
  435. if (font) {
  436. chkFontName = font[JV.FONT_PROPS[0]];
  437. chkFontHeight = parseFloat(font[JV.FONT_PROPS[JV.FONT_PROP_IDX_HEIGHT]]);
  438. }
  439. let hasSplitStr = false;
  440. let splitStrArr = [];
  441. let accAmt = 0;
  442. const chnW = fontWidthMap.getFontWidth(chkFontName, chkFontHeight, '宽');
  443. const otherW = fontWidthMap.getFontWidth(chkFontName, chkFontHeight, '窄');
  444. for (let i = 0; i < values.length; i++) {
  445. const amt = JpcCommonHelper.getStringLinesInArea(area, values[i], chnW, otherW);
  446. accAmt += amt;
  447. if (amt > 1) {
  448. hasSplitStr = true;
  449. splitStrArr.push(i);
  450. }
  451. }
  452. // if (accAmt > rst) rst = accAmt;
  453. if (rst > 3) {
  454. // 新优化,计算实际能显示完的真正行数
  455. const rowHeight = JpcFlowTabHelper.getRowHeight(bands, rptTpl, me.isEx);
  456. const tmpFV = ((chkFontHeight + JV.CLOSE_OUTPUT_ROW_BUFFER) * accAmt) / rowHeight;
  457. let tmpAmt = Math.floor(tmpFV);
  458. if (Math.ceil(tmpFV) > tmpAmt) {
  459. tmpAmt++;
  460. }
  461. // rst = tmpAmt;
  462. if (maxAmt < tmpAmt) maxAmt = tmpAmt;
  463. } else {
  464. if (maxAmt < accAmt) maxAmt = accAmt;
  465. }
  466. // if (hasSplitStr && outputType !== JV.OUTPUT_TYPE_EXCEL) {
  467. if (hasSplitStr) {
  468. let newValArr = [];
  469. for (let i = 0; i < values.length; i++) {
  470. if (splitStrArr.indexOf(i) < 0) {
  471. newValArr.push(values[i]);
  472. } else {
  473. newValArr = newValArr.concat(JpcCommonHelper.splitString(area, values[i], chnW, otherW));
  474. }
  475. }
  476. JpcFieldHelper.setValue(data_field, theRecIdx, newValArr.join('|'));
  477. splitStrArr = [];
  478. newValArr = [];
  479. }
  480. // 备注: 如果outputType是excel类型,那么就只保留原始的分行符,无需介入分行,由excel本身去处理分行,只需要保留足够的空间即可。
  481. // 根据最新需求,暂时不考虑excel类型输出,换回原来逻辑
  482. }
  483. }
  484. if (rst < maxAmt) rst = maxAmt; // 最后才设置最大结果
  485. return rst;
  486. };
  487. for (const tabField of tab_fields) {
  488. if (adHocAutoHeightStyleStr.indexOf(tabField[JV.PROP_STYLE]) < 0) {
  489. adHocAutoHeightStyleStr.push(tabField[JV.PROP_STYLE]);
  490. }
  491. }
  492. if (adHocAutoHeightStyleStr.length > 0) {
  493. if (!(rptTpl[JV.NODE_STYLE_COLLECTION])) {
  494. rptTpl[JV.NODE_STYLE_COLLECTION] = [];
  495. }
  496. for (const styleStr of adHocAutoHeightStyleStr) {
  497. rptTpl[JV.NODE_STYLE_COLLECTION].push({ ID: styleStr + '_AutoHeightMerge_Top' });
  498. rptTpl[JV.NODE_STYLE_COLLECTION].push({ ID: styleStr + '_AutoHeightMerge_Middle' });
  499. rptTpl[JV.NODE_STYLE_COLLECTION].push({ ID: styleStr + '_AutoHeightMerge_Bottom' });
  500. }
  501. }
  502. // 这里先记录下来每一Segment里的每一条record占用行的数量(普通是1行高度,超过1就表示需要调整行数了)
  503. const infoArr = [];
  504. me.auto_height_info.push(infoArr);
  505. const segArr = me.segments[segIdx];
  506. for (let i = 0; i < segArr.length; i++) {
  507. infoArr.push(private_get_max_lines_of_the_record(segArr[i]));
  508. }
  509. }
  510. };
  511. JpcFlowTabResult.getDftRowsPerPage = function(rptTpl, defProperties, $CURRENT_RPT) {
  512. const me = this;
  513. let rst = 1;
  514. const bands = JpcBand.createNew(rptTpl, defProperties);
  515. const pageStatus = [true, true, true, true, true, true, true, true];
  516. JpcBandHelper.setBandArea(bands, rptTpl, pageStatus, true, false);
  517. rst = JpcFlowTabHelper.getMaxRowsPerPage(bands, rptTpl, false);
  518. return rst;
  519. };
  520. JpcFlowTabResult.preSetupPages = function(rptTpl, dataObj, defProperties, option, $CURRENT_RPT, followTabEx, outputType) {
  521. // 换一种思路来整理流水式数据
  522. const me = this;
  523. let rst = 1;
  524. let counterRowRec = 0;
  525. let counterRowRecEx = 0;
  526. let maxRowRec = 1;
  527. let pageIdx = 0;
  528. let currentRecAmt = 0;
  529. me.paging_option = option || JV.PAGING_OPTION_NORMAL;
  530. const CURRENT_FLOW_INFO = (me.isEx) ? JV.NODE_FLOW_INFO_EX : JV.NODE_FLOW_INFO;
  531. JpcFieldHelper.findAndPutDataFieldIdx(rptTpl, rptTpl[CURRENT_FLOW_INFO][JV.NODE_FLOW_CONTENT][JV.PROP_FLOW_FIELDS], null, me.disp_fields_idx, me.isEx);
  532. if (followTabEx) {
  533. JpcFieldHelper.findAndPutDataFieldIdx(rptTpl, rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_CONTENT][JV.PROP_FLOW_FIELDS], null, me.disp_fields_ex_idx, true);
  534. }
  535. // 根据实际情况,统计前要先根据format整理好小数位数,否则会出现显示的数据的累计与最后统计的结果不一致
  536. me.setupGroupingData(rptTpl, dataObj, $CURRENT_RPT);
  537. if (followTabEx) {
  538. followTabEx.setupGroupingData(rptTpl, dataObj, $CURRENT_RPT);
  539. }
  540. me.sumSeg(dataObj, $CURRENT_RPT); // 考虑到实际会有离散指标的汇总,这些离散指标数据是通过计算式后得来的,这种情况下,不适宜在sorting阶段进行汇总统计,现统一挪到这里处理
  541. // const _chkHasBreakFlow = function(segIdx, pageIdx) {
  542. // if (rptTpl[JV.NODE_FLOW_INFO][JV.NODE_DISCRETE_INFO]) {
  543. // for (const discrete of rptTpl[JV.NODE_FLOW_INFO][JV.NODE_DISCRETE_INFO]) {
  544. // if (discrete[JV.PROP_DISCRETE_FIELDS] && discrete[JV.PROP_DISCRETE_FIELDS].length > 0) {
  545. // for (const df of discrete[JV.PROP_DISCRETE_FIELDS]) {
  546. // const map_data_field = JE.F(df[JV.PROP_FIELD_ID], $CURRENT_RPT);
  547. // if (map_data_field) {
  548. // const val = JE.getFieldValue(map_data_field, dataObj, segIdx, '');
  549. // if (typeof val === 'string') {
  550. // if (val.indexOf(SEG_PAGE_SPLIT_STR) >= 0) {
  551. // me.hasBreakFlowArr[pageIdx][0] = true;
  552. // break;
  553. // }
  554. // }
  555. // }
  556. // if (me.hasBreakFlowArr[pageIdx][0]) break;
  557. // }
  558. // }
  559. // if (me.hasBreakFlowArr[pageIdx][0]) break;
  560. // }
  561. // }
  562. // };
  563. const bands = JpcBand.createNew(rptTpl, defProperties);
  564. if (me.paging_option === JV.PAGING_OPTION_INFINITY) {
  565. rst = me.segments.length;
  566. const pageStatus = [true, true, false, true, true, true, true, true];
  567. const grpPageInfo = {};
  568. let pageIdx = 0;
  569. for (let segIdx = 0; segIdx < me.segments.length; segIdx++) {
  570. /*
  571. me.hasBreakFlowArr[pageIdx] = [];
  572. me.hasBreakFlowArr[pageIdx][0] = false;
  573. me.hasBreakFlowArr[pageIdx][1] = segIdx;
  574. _chkHasBreakFlow(segIdx, pageIdx);
  575. //*/
  576. // 备注:有break flow的情况下 连续输出 要考虑段(seg)的多页输出问题
  577. if (segIdx === me.segments.length - 1) {
  578. pageStatus[JV.STATUS_REPORT_END] = true;
  579. }
  580. if (segIdx > 0) {
  581. pageStatus[JV.STATUS_REPORT_START] = false;
  582. }
  583. const grpSeqInfo = (me.group_node_info) ? me.group_node_info[segIdx] : null;
  584. const grpRecAmt = (grpSeqInfo) ? (grpSeqInfo.length * me.group_lines_amt) : 0;
  585. grpPageInfo[JV.PROP_SEG_GRP_IDX] = 0;
  586. grpPageInfo[JV.PROP_INSERTED_GRP_REC] = 0;
  587. grpPageInfo[JV.PROP_PRE_ADD_GRP_REC_INFO] = [];
  588. grpPageInfo[JV.PROP_GRP_LINES] = me.group_lines_amt;
  589. JpcBandHelper.setBandArea(bands, rptTpl, pageStatus, !me.isEx, me.isEx);
  590. maxRowRec = JpcFlowTabHelper.getMaxRowsPerPage(bands, rptTpl, me.isEx);
  591. me.setupAutoHeightData(bands, segIdx, rptTpl, dataObj, $CURRENT_RPT, defProperties, outputType);
  592. let adHocAutoHeightAmt = 0;
  593. if (me.auto_height_info.length > 0) {
  594. for (let loop = 0; loop < me.auto_height_info[segIdx].length; loop++) {
  595. adHocAutoHeightAmt += (me.auto_height_info[segIdx][loop] - 1);
  596. }
  597. }
  598. me.pageStatusLst.push(pageStatus.slice(0));
  599. pageIdx++;
  600. const rowAmt = Math.max(maxRowRec, me.segments[segIdx].length + adHocAutoHeightAmt);
  601. /*
  602. if (me.hasBreakFlowArr[pageIdx][0]) {
  603. let accAmt = 0;
  604. rowAmt = maxRowRec;
  605. while (accAmt < me.segments[segIdx].length + adHocAutoHeightAmt) {
  606. me.hasBreakFlowArr[pageIdx][0] = true;
  607. me.hasBreakFlowArr[pageIdx][1] = segIdx;
  608. private_addPageValue(me.dispValueIdxLst, me.segments[segIdx], grpSeqInfo, 0, rowAmt, me.page_seg_map, segIdx, pageIdx, grpPageInfo, false, me.auto_height_info, 0);
  609. pageIdx++;
  610. accAmt += maxRowRec;
  611. // remark: 需要再细化
  612. }
  613. } else {
  614. private_addPageValue(me.dispValueIdxLst, me.segments[segIdx], grpSeqInfo, 0, rowAmt, me.page_seg_map, segIdx, pageIdx, grpPageInfo, false, me.auto_height_info, 0);
  615. pageIdx++;
  616. }
  617. //*/
  618. private_addPageValue(me.dispValueIdxLst, me.segments[segIdx], grpSeqInfo, 0, rowAmt, me.page_seg_map, segIdx, pageIdx, grpPageInfo, false, me.auto_height_info, 0);
  619. }
  620. // 目前不支持flowTabEx
  621. } else {
  622. const pageStatus = [true, true, false, true, false, false, false, false];
  623. if (me.isEx) {
  624. pageStatus[JV.STATUS_REPORT_START] = false;
  625. }
  626. if (rptTpl[CURRENT_FLOW_INFO][JV.PROP_MULTI_COLUMN]) {
  627. me.multiCols = 1 * rptTpl[CURRENT_FLOW_INFO][JV.PROP_MULTI_COLUMN];
  628. }
  629. const grpPageInfo = {};
  630. let prePageLeftAutoHeightRecAmt = 0; // 考虑自动行高的跨页情况
  631. const private_resetBandArea = function() {
  632. JpcBandHelper.setBandArea(bands, rptTpl, pageStatus, !me.isEx, me.isEx);
  633. maxRowRec = JpcFlowTabHelper.getMaxRowsPerPage(bands, rptTpl, me.isEx);
  634. };
  635. let handledRowAmt = 0; // handledRowAmt纪录的是真正处理过的显示行数,包含了空白行,主要是为分页用(自动行高)
  636. let segRestRecAmt = 0; // 一般情况下为0,只有在特殊情况下才需要,如09-x表中,正常流水一页显示不了的时候,就有大问题了
  637. const private_addPage = function(segIdx, grpSeqInfo, isFollow, isMix, mixSplitPoint) {
  638. private_resetBandArea();
  639. me.pageStatusLst.push(pageStatus.slice(0));
  640. currentRecAmt += maxRowRec; // 在自动行高的场景下,currentRecAmt在后面还需要调整
  641. handledRowAmt += maxRowRec;
  642. let redundantRecAmt = 0;
  643. pageIdx++;
  644. function private_chk_handle_rec_amt(dv, isEx) {
  645. if ((dv[1] === JV.DISPLAY_VAL_TYPE_NORMAL) || (dv[1] === JV.DISPLAY_VAL_TYPE_AUTO_HEIGHT && dv[3] === dv[4] - 1)) {
  646. if (isEx) { counterRowRecEx++; } else counterRowRec++;
  647. } else if (dv[1] === JV.DISPLAY_VAL_TYPE_AUTO_HEIGHT) {
  648. redundantRecAmt++;
  649. }
  650. }
  651. let restRecAmt = 0;
  652. if (isMix) {
  653. // 先处理上半部分
  654. prePageLeftAutoHeightRecAmt = private_addPageValue(me.dispValueIdxLst, me.segments[segIdx], grpSeqInfo, counterRowRec, mixSplitPoint, me.page_seg_map, segIdx, pageIdx, grpPageInfo, false, me.auto_height_info, prePageLeftAutoHeightRecAmt);
  655. for (const dv of me.dispValueIdxLst[me.dispValueIdxLst.length - 1]) {
  656. private_chk_handle_rec_amt(dv, false);
  657. }
  658. // 再处理下半部分
  659. restRecAmt = maxRowRec - me.dispValueIdxLst[me.dispValueIdxLst.length - 1].length; // 备注:在一些极端条件下,mixSplitPoint这个分割点不合适处理下半部分数据,以实际生成的value-index数量为准
  660. // private_addPageValue(me.dispValueIdxLst, followTabEx.segments[segIdx], null, counterRowRecEx, maxRowRec - mixSplitPoint, me.page_seg_map, segIdx, pageIdx, null, true, null, 0);
  661. private_addPageValue(me.dispValueIdxLst, followTabEx.segments[segIdx], null, counterRowRecEx, restRecAmt, me.page_seg_map, segIdx, pageIdx, null, true, null, 0);
  662. for (const dv of me.dispValueIdxLst[me.dispValueIdxLst.length - 1]) {
  663. private_chk_handle_rec_amt(dv, true);
  664. }
  665. // 合并到一页中
  666. me.page_seg_map.splice(me.page_seg_map.length - 1, 1);
  667. const vl = me.dispValueIdxLst[me.dispValueIdxLst.length - 2];
  668. for (const item of me.dispValueIdxLst[me.dispValueIdxLst.length - 1]) {
  669. vl.push(item);
  670. }
  671. me.dispValueIdxLst.splice(me.dispValueIdxLst.length - 1, 1);
  672. } else if (isFollow) {
  673. prePageLeftAutoHeightRecAmt = private_addPageValue(me.dispValueIdxLst, followTabEx.segments[segIdx], null, counterRowRecEx, maxRowRec, me.page_seg_map, segIdx, pageIdx, null, true, null, 0);
  674. for (const dv of me.dispValueIdxLst[me.dispValueIdxLst.length - 1]) {
  675. private_chk_handle_rec_amt(dv, true);
  676. }
  677. } else {
  678. prePageLeftAutoHeightRecAmt = private_addPageValue(me.dispValueIdxLst, me.segments[segIdx], grpSeqInfo, counterRowRec, maxRowRec, me.page_seg_map, segIdx, pageIdx, grpPageInfo, false, me.auto_height_info, prePageLeftAutoHeightRecAmt);
  679. for (const dv of me.dispValueIdxLst[me.dispValueIdxLst.length - 1]) {
  680. private_chk_handle_rec_amt(dv, false);
  681. }
  682. }
  683. currentRecAmt -= redundantRecAmt; // 在自动行高调整场景下,需要减去冗余的数量
  684. if (restRecAmt < 0) {
  685. currentRecAmt -= restRecAmt;
  686. segRestRecAmt = restRecAmt;
  687. }
  688. };
  689. for (let segIdx = 0; segIdx < me.segments.length; segIdx++) {
  690. const grpSeqInfo = (me.group_node_info) ? me.group_node_info[segIdx] : null;
  691. const grpRecAmt = (grpSeqInfo) ? (grpSeqInfo.length * me.group_lines_amt) : 0;
  692. let grpRecAmtEx = 0;
  693. let accAutoHeightAmt = 0; // 累计的自动行高数量
  694. handledRowAmt = 0; // 初始化每一段的已处理纪录行数
  695. segRestRecAmt = 0;
  696. if (followTabEx && followTabEx.group_node_info) {
  697. grpRecAmtEx = followTabEx.group_node_info.length * followTabEx.group_lines_amt;
  698. }
  699. grpPageInfo[JV.PROP_SEG_GRP_IDX] = 0;
  700. grpPageInfo[JV.PROP_INSERTED_GRP_REC] = 0;
  701. grpPageInfo[JV.PROP_PRE_ADD_GRP_REC_INFO] = [];
  702. grpPageInfo[JV.PROP_GRP_LINES] = me.group_lines_amt;
  703. pageStatus[JV.STATUS_SEGMENT_START] = true;
  704. private_resetBandArea();
  705. me.setupAutoHeightData(bands, segIdx, rptTpl, dataObj, $CURRENT_RPT, defProperties, outputType);
  706. let threshold = 0;
  707. currentRecAmt = 0;
  708. counterRowRec = 0;
  709. counterRowRecEx = 0;
  710. let ttlSegRecAmtNormal = me.segments[segIdx].length + grpRecAmt; // 正常的segment下的数据长度累计(含grouping data)
  711. let ttlSegRecAmt = (followTabEx) ? (me.segments[segIdx].length + grpRecAmt + followTabEx.segments[segIdx].length + grpRecAmtEx) : (me.segments[segIdx].length + grpRecAmt); // 所有的segment下的数据长度累计(包括ex部分)
  712. let adHocAutoHeightAmt = 0;
  713. let normalContentAmt = 0;
  714. let exBuffer = 0;
  715. let adHocAutoHeightGrpStartIdx = 0;
  716. if (me.auto_height_fields_idx.length > 0) {
  717. for (let loop = 0; loop < me.auto_height_info[segIdx].length; loop++) {
  718. adHocAutoHeightAmt += (me.auto_height_info[segIdx][loop] - 1);
  719. normalContentAmt++;
  720. if (me.group_node_info && me.group_node_info[segIdx]) {
  721. if (me.group_node_info[segIdx][adHocAutoHeightGrpStartIdx] === loop) {
  722. adHocAutoHeightGrpStartIdx++;
  723. }
  724. }
  725. }
  726. ttlSegRecAmtNormal += adHocAutoHeightAmt;
  727. ttlSegRecAmt += adHocAutoHeightAmt;
  728. if (adHocAutoHeightAmt > 0) exBuffer = grpRecAmt;
  729. }
  730. // 自动行高调整在多流水合并方式时,只支持前部分(后期需要再加)
  731. while (true) {
  732. if (currentRecAmt > 0) pageStatus[JV.STATUS_SEGMENT_START] = false;
  733. if (pageIdx > 0) pageStatus[JV.STATUS_REPORT_START] = false;
  734. private_resetBandArea(); // 这里得预先算maxRowRec(实际数据情况,会有章首页框,在章数据多的情况下,章第二页开始就得补上章首页框不显示遗留下来的row)
  735. // 开始判断各种scenarios
  736. adHocAutoHeightAmt = 0;
  737. if (me.auto_height_fields_idx.length > 0) {
  738. adHocAutoHeightAmt -= prePageLeftAutoHeightRecAmt;
  739. for (let loop = currentRecAmt; loop < currentRecAmt + maxRowRec; loop++) {
  740. if (me.auto_height_info[segIdx].length > loop) {
  741. adHocAutoHeightAmt += (me.auto_height_info[segIdx][loop] - 1);
  742. } else {
  743. break;
  744. }
  745. }
  746. }
  747. if ((ttlSegRecAmtNormal < ttlSegRecAmt) || (followTabEx !== null)) {
  748. // 有流水拓展,并且是follow mode
  749. if (currentRecAmt + accAutoHeightAmt + exBuffer + maxRowRec > ttlSegRecAmtNormal) {
  750. if (currentRecAmt + accAutoHeightAmt + adHocAutoHeightAmt >= ttlSegRecAmtNormal) {
  751. // 纯 followTabEx 数据
  752. if (currentRecAmt + accAutoHeightAmt + adHocAutoHeightAmt + maxRowRec >= ttlSegRecAmt) {
  753. pageStatus[JV.STATUS_SEGMENT_END] = true;
  754. private_resetBandArea();
  755. const hasAdHocRow = !JpcFlowTabHelper.chkSegEnd(bands, rptTpl, ttlSegRecAmt, currentRecAmt + adHocAutoHeightAmt, maxRowRec, me.isEx);
  756. if (hasAdHocRow) {
  757. // add page info(pre segment end)
  758. pageStatus[JV.STATUS_SEGMENT_END] = false;
  759. private_addPage(segIdx, null, true, false, -1);
  760. }
  761. // add page info
  762. pageStatus[JV.STATUS_SEGMENT_END] = true;
  763. private_addPage(segIdx, null, true, false, -1);
  764. } else {
  765. private_addPage(segIdx, null, true, false, -1);
  766. }
  767. } else {
  768. // 混合数据
  769. // if (currentRecAmt + adHocAutoHeightAmt + maxRowRec >= ttlSegRecAmt) {
  770. if (currentRecAmt + accAutoHeightAmt + adHocAutoHeightAmt + maxRowRec >= ttlSegRecAmt) {
  771. pageStatus[JV.STATUS_SEGMENT_END] = true;
  772. private_resetBandArea();
  773. const hasAdHocRow = !JpcFlowTabHelper.chkSegEnd(bands, rptTpl, ttlSegRecAmt, currentRecAmt + adHocAutoHeightAmt, maxRowRec, me.isEx);
  774. if (hasAdHocRow) {
  775. // add page info(pre segment end)
  776. pageStatus[JV.STATUS_SEGMENT_END] = false;
  777. private_addPage(segIdx, grpSeqInfo, false, true, ttlSegRecAmtNormal);
  778. }
  779. // add page info
  780. pageStatus[JV.STATUS_SEGMENT_END] = true;
  781. // if (currentRecAmt + adHocAutoHeightAmt >= ttlSegRecAmtNormal) {
  782. if (currentRecAmt + accAutoHeightAmt + adHocAutoHeightAmt >= ttlSegRecAmtNormal) {
  783. // 纯 followTabEx 数据啦
  784. private_addPage(segIdx, null, true, false, -1);
  785. } else {
  786. private_addPage(segIdx, grpSeqInfo, false, true, ttlSegRecAmtNormal);
  787. }
  788. } else {
  789. // 在这里要考虑如果有多页正常的流水数据情况,那么就得考虑这页有多少条普通流水记录,不应该一刀切地用ttlSegRecAmtNormal
  790. const splitPoint = ttlSegRecAmtNormal - handledRowAmt;
  791. private_addPage(segIdx, grpSeqInfo, false, true, splitPoint);
  792. }
  793. }
  794. } else {
  795. // 纯followTab数据
  796. private_addPage(segIdx, grpSeqInfo, false, false, -1);
  797. }
  798. } else {
  799. // 普通流水数据情况
  800. if (handledRowAmt + maxRowRec >= ttlSegRecAmt) {
  801. // 备注: 理论上自动行高是没有上限的,有可能正常一页的数据可以拓展到3页及以上,在此极端情况下,必须做一些限制判断,否则会出现缺页情况。
  802. // 2018-08-04 其实之前的判断逻辑完全是自找麻烦,而且还不够正确。其实只需要判断已经处理了多少行纪录(所有的都算,包括空白行),
  803. // 与总的seg纪录数想比较,就很容易得到结果,而且能处理极端边界的情况。
  804. pageStatus[JV.STATUS_SEGMENT_END] = true;
  805. // pageStatus[JV.STATUS_REPORT_END] = true;
  806. pageStatus[JV.STATUS_REPORT_END] = (segIdx === me.segments.length - 1);
  807. private_resetBandArea();
  808. const hasAdHocRow = ((adHocAutoHeightAmt > maxRowRec) || !JpcFlowTabHelper.chkSegEnd(bands, rptTpl, ttlSegRecAmt, handledRowAmt, maxRowRec, me.isEx));
  809. if (hasAdHocRow) {
  810. // add page info(pre segment end)
  811. pageStatus[JV.STATUS_SEGMENT_END] = false;
  812. pageStatus[JV.STATUS_REPORT_END] = false;
  813. private_addPage(segIdx, grpSeqInfo, false, false, -1);
  814. pageStatus[JV.STATUS_REPORT_START] = false;
  815. pageStatus[JV.STATUS_SEGMENT_START] = false;
  816. }
  817. // add page info
  818. pageStatus[JV.STATUS_SEGMENT_END] = true;
  819. pageStatus[JV.STATUS_REPORT_END] = (segIdx === me.segments.length - 1);
  820. private_addPage(segIdx, grpSeqInfo, false, false, -1);
  821. pageStatus[JV.STATUS_SEGMENT_END] = false; // 加完章统计页后,记得把章尾页设置为false
  822. } else {
  823. private_addPage(segIdx, grpSeqInfo, false, false, -1);
  824. }
  825. }
  826. // 检测是否可退出
  827. if (handledRowAmt >= (ttlSegRecAmt + segRestRecAmt) && (pageIdx % me.multiCols === 0)) {
  828. // 备注:这里必须得考虑多栏的情况,否则会造成pageStatus出界的问题
  829. break;
  830. }
  831. accAutoHeightAmt += adHocAutoHeightAmt;
  832. // 控制阈值,超过阈值则强制退出,防止死循环
  833. threshold++;
  834. if (threshold > PAGESIZE_THRESHOLD) {
  835. console.log('Hey! There may be a dead loop here!!!');
  836. break;
  837. }
  838. }
  839. }
  840. rst = Math.ceil(pageIdx / me.multiCols);
  841. }
  842. me.pagesAmt = rst;
  843. return rst;
  844. };
  845. JpcFlowTabResult.outputAsPreviewPage = function(rptTpl, bands, controls, $CURRENT_RPT) {
  846. const me = this;
  847. let rst = [];
  848. const vIdx = [];
  849. // 只预览第一页的数据
  850. const pageStatus = [true, true, true, true, true, true, true, true];
  851. me.pageStatusLst.push(pageStatus);
  852. JpcFieldHelper.findAndPutDataFieldIdx(rptTpl, rptTpl[JV.NODE_FLOW_INFO][JV.NODE_FLOW_CONTENT][JV.PROP_FLOW_FIELDS], null, me.disp_fields_idx, false);
  853. JpcBandHelper.setBandArea(bands, rptTpl, pageStatus, true, false);
  854. const maxRowRec = JpcFlowTabHelper.getMaxRowsPerPage(bands, rptTpl, false);
  855. for (let i = 0; i < maxRowRec; i++) {
  856. vIdx.push([-1, JV.DISPLAY_VAL_TYPE_NORMAL, JV.BLANK_VALUE_INDEX]);
  857. }
  858. const unitFactor = JpcCommonHelper.getUnitFactor(rptTpl);
  859. // 2.2 Column tab
  860. rst = rst.concat(me.outputColumn(rptTpl, null, 1, 0, 0, bands, unitFactor, 0, $CURRENT_RPT, null));
  861. // 2.1 Content-Tab
  862. rst = rst.concat(me.outputPreviewContent(rptTpl, bands, unitFactor, controls, pageStatus, maxRowRec));
  863. // 2.3 Sum Seg
  864. rst = rst.concat(me.outputPreviewSegSum(rptTpl, bands, unitFactor, controls, pageStatus));
  865. // 2.4 Sum Page
  866. rst = rst.concat(me.outputPreviewPageSum(rptTpl, bands, unitFactor, controls, pageStatus));
  867. // 2.5 Group
  868. // 2.6 Discrete
  869. me.interactRst = [];
  870. rst = rst.concat(JpcDiscreteHelper.outputPreviewDiscreteInfo(rptTpl[JV.NODE_FLOW_INFO][JV.NODE_DISCRETE_INFO], bands, unitFactor, pageStatus, $CURRENT_RPT, me.interactRst, me.signatureRst, me.signatureDateRst, me.signatureAuditRst));
  871. return rst;
  872. };
  873. JpcFlowTabResult.outputAsSimpleJSONPage = function(rptTpl, dataObj, page, bands, controls, fonts, adHocMergePos, $CURRENT_RPT, customizeCfg) {
  874. const me = this;
  875. let rst = [];
  876. const tabRstLst = [];
  877. const FLOW_NODE_STR = me.isEx ? JV.NODE_FLOW_INFO_EX : JV.NODE_FLOW_INFO;
  878. const unitFactor = JpcCommonHelper.getUnitFactor(rptTpl);
  879. // 电子签名内容需要先清空
  880. me.signatureRst = [];
  881. me.signatureDateRst = [];
  882. me.signatureAuditRst = [];
  883. me.interactRst = [];
  884. if (me.paging_option === JV.PAGING_OPTION_INFINITY) {
  885. const segIdx = page - 1;
  886. // 1 calculate the band position
  887. JpcBandHelper.setBandArea(bands, rptTpl, me.pageStatusLst[page - 1], !me.isEx, me.isEx);
  888. const maxRowRec = JpcFlowTabHelper.getMaxRowsPerPage(bands, rptTpl, me.isEx);
  889. // 2. then reset the band height
  890. const tab = rptTpl[JV.NODE_FLOW_INFO][JV.NODE_FLOW_CONTENT];
  891. const flowContentBand = bands[tab[JV.PROP_BAND_NAME]];
  892. let adHocAutoHeightAmt = 0;
  893. if (me.auto_height_info.length > 0) {
  894. for (let loop = 0; loop < me.auto_height_info[segIdx].length; loop++) {
  895. adHocAutoHeightAmt += (me.auto_height_info[segIdx][loop] - 1);
  896. }
  897. }
  898. const rowAmt = Math.max(maxRowRec, me.segments[segIdx].length + adHocAutoHeightAmt); // 如不满一页,则需要填充满一页
  899. // if (me.hasBreakFlowArr[segIdx]) {
  900. // rowAmt = maxRowRec;
  901. // }
  902. const actH = JpcFlowTabHelper.getActualContentAreaHeight(bands, rptTpl, me.segments, rowAmt, page, me.isEx);
  903. const offsetY = actH - (flowContentBand.Bottom - flowContentBand.Top);
  904. JpcBandHelper.resetBandPos(rptTpl[JV.NODE_BAND_COLLECTION], bands, flowContentBand, 0, offsetY);
  905. // 2.1 Content-Tab
  906. tabRstLst.push(me.outputContent(rptTpl, dataObj, page, bands, unitFactor, controls, fonts, 0, $CURRENT_RPT, customizeCfg));
  907. // 2.2 Column tab
  908. tabRstLst.push(me.outputColumn(rptTpl, dataObj, page, segIdx, 0, bands, unitFactor, 0, $CURRENT_RPT, customizeCfg));
  909. // 2.3 Sum Seg
  910. tabRstLst.push(me.outputSegSum(rptTpl, dataObj, page, segIdx, bands, unitFactor, controls, $CURRENT_RPT, customizeCfg));
  911. // 2.4 Sum Page
  912. tabRstLst.push(me.outputPageSum(rptTpl, dataObj, page, segIdx, bands, unitFactor, controls, $CURRENT_RPT, customizeCfg));
  913. // 2.5 Group
  914. // 2.6 Discrete
  915. tabRstLst.push(JpcDiscreteHelper.outputDiscreteInfo(rptTpl[FLOW_NODE_STR][JV.NODE_DISCRETE_INFO], bands, dataObj, unitFactor, me.pageStatusLst[page - 1], segIdx, 0, 1, 0, $CURRENT_RPT, customizeCfg, me.signatureRst, me.signatureDateRst, me.signatureAuditRst, me.interactRst));
  916. // 3. reset merge band position
  917. if (bands[JV.BAND_PROP_MERGE_BAND] && adHocMergePos) {
  918. const mergedBand = bands[JV.BAND_PROP_MERGE_BAND];
  919. let arr = [];
  920. arr.push(parseInt(mergedBand[JV.PROP_LEFT].toFixed(0)));
  921. adHocMergePos[JV.PROP_LEFT] = arr;
  922. arr = [];
  923. arr.push(parseInt(mergedBand[JV.PROP_RIGHT].toFixed(0)));
  924. adHocMergePos[JV.PROP_RIGHT] = arr;
  925. arr = [];
  926. arr.push(parseInt(mergedBand[JV.PROP_TOP].toFixed(0)));
  927. adHocMergePos[JV.PROP_TOP] = arr;
  928. arr = [];
  929. arr.push(parseInt((mergedBand[JV.PROP_BOTTOM]).toFixed(0)));
  930. adHocMergePos[JV.PROP_BOTTOM] = arr;
  931. }
  932. } else {
  933. const segIdx = JpcCommonHelper.getSegIdxByPageIdx(page, me.page_seg_map);
  934. const segPageIdx = JpcCommonHelper.getSegPageIdxByPage(page, me.page_seg_map);
  935. // 1 calculate the band position
  936. JpcBandHelper.setBandArea(bands, rptTpl, me.pageStatusLst[page - 1], !me.isEx, me.isEx);
  937. // 2. start to output detail-part
  938. for (let pi = 0; pi < me.multiCols; pi++) {
  939. const actualPage = (page - 1) * me.multiCols + pi + 1;
  940. // 2.1 Content-Tab
  941. tabRstLst.push(me.outputContent(rptTpl, dataObj, actualPage, bands, unitFactor, controls, fonts, pi, $CURRENT_RPT, customizeCfg));
  942. // 2.2 Column tab
  943. tabRstLst.push(me.outputColumn(rptTpl, dataObj, actualPage, segIdx, segPageIdx, bands, unitFactor, pi, $CURRENT_RPT, customizeCfg));
  944. // 2.3 Sum Seg
  945. tabRstLst.push(me.outputSegSum(rptTpl, dataObj, actualPage, segIdx, bands, unitFactor, controls, $CURRENT_RPT, customizeCfg));
  946. // 2.4 Sum Page
  947. tabRstLst.push(me.outputPageSum(rptTpl, dataObj, actualPage, segIdx, bands, unitFactor, controls, $CURRENT_RPT, customizeCfg));
  948. // 2.5 Group
  949. // 2.6 Discrete
  950. if (pi === 0) {
  951. tabRstLst.push(JpcDiscreteHelper.outputDiscreteInfo(rptTpl[FLOW_NODE_STR][JV.NODE_DISCRETE_INFO], bands, dataObj, unitFactor, me.pageStatusLst[actualPage - 1], segIdx, segPageIdx, 1, pi, $CURRENT_RPT, customizeCfg, me.signatureRst, me.signatureDateRst, me.signatureAuditRst, me.interactRst));
  952. }
  953. }
  954. }
  955. for (let i = 0; i < tabRstLst.length; i++) {
  956. rst = rst.concat(tabRstLst[i]);
  957. tabRstLst[i] = null;
  958. }
  959. return rst;
  960. };
  961. JpcFlowTabResult.combinePageCells = function(rstPageCells, verticalCombinePos, horizonCombinePos, controls, fonts) {
  962. // let me = this;
  963. // 备注:纵向合并要考虑以下因素:
  964. // 如果有多个column纵向合并,需要总体考虑分割,
  965. // 假如:第一列的前3个数据(1、2、3)是相同的,第二列中第2、3、4行数据相同,那么第二列只能合并2、3行的数据,不能合并到第四行
  966. // 同理如此类推第三列...n列
  967. // 另:要考虑紧密输出情况,需要重新拆分数据
  968. const _splitValues = function(oCell) {
  969. // JpcFieldHelper.setValue(data_field, theRecIdx, value);
  970. const values = (typeof oCell.Value === 'string') ? oCell.Value.split('|') : [oCell.Value];
  971. let font = oCell[JV.PROP_FONT];
  972. if (typeof oCell[JV.PROP_FONT] === 'string') {
  973. font = fonts[oCell[JV.PROP_FONT]];
  974. }
  975. // // if (values.length > rst) rst = values.length; // 考虑到紧凑输出,不能那么快设置rst
  976. // const font = private_get_font(tab_field[JV.PROP_FONT]);
  977. let chkFontName = '宋体';
  978. let chkFontHeight = 12;
  979. if (font) {
  980. chkFontName = font[JV.FONT_PROPS[0]];
  981. chkFontHeight = parseFloat(font[JV.FONT_PROPS[JV.FONT_PROP_IDX_HEIGHT]]);
  982. }
  983. let hasSplitStr = false;
  984. const splitStrArr = [];
  985. let accAmt = 0;
  986. const chnW = fontWidthMap.getFontWidth(chkFontName, chkFontHeight, '宽');
  987. const otherW = fontWidthMap.getFontWidth(chkFontName, chkFontHeight, '窄');
  988. for (let i = 0; i < values.length; i++) {
  989. const amt = JpcCommonHelper.getStringLinesInArea(oCell.area, values[i], chnW, otherW);
  990. accAmt += amt;
  991. if (amt > 1) {
  992. hasSplitStr = true;
  993. splitStrArr.push(i);
  994. }
  995. }
  996. if (hasSplitStr) {
  997. let newValArr = [];
  998. for (let i = 0; i < values.length; i++) {
  999. if (splitStrArr.indexOf(i) < 0) {
  1000. newValArr.push(values[i]);
  1001. } else {
  1002. newValArr = newValArr.concat(JpcCommonHelper.splitString(oCell.area, values[i], chnW, otherW));
  1003. }
  1004. }
  1005. oCell.Value = newValArr.join('|');
  1006. }
  1007. };
  1008. if (verticalCombinePos.length > 0 || horizonCombinePos.length > 1) {
  1009. const cacheObj = { vCache: {}, hCache: {}, hCacheStr: [] };
  1010. const removeCellIds = [];
  1011. const reservedCells = [];
  1012. for (const vPosArr of verticalCombinePos) {
  1013. const pStr = '_' + vPosArr[0] + '_' + vPosArr[1];
  1014. cacheObj.vCache[pStr] = [];
  1015. }
  1016. // horizonCombinePos不需要预记
  1017. for (let idx = 0; idx < rstPageCells.length; idx++) {
  1018. const cell = rstPageCells[idx];
  1019. for (const vPosArr of verticalCombinePos) {
  1020. if (cell[JV.PROP_AREA][JV.PROP_LEFT] === vPosArr[0] && cell[JV.PROP_AREA][JV.PROP_RIGHT] === vPosArr[1]) {
  1021. cacheObj.vCache['_' + vPosArr[0] + '_' + vPosArr[1]].push(idx);
  1022. }
  1023. }
  1024. for (const hPosArr of horizonCombinePos) {
  1025. if (cell[JV.PROP_AREA][JV.PROP_LEFT] === hPosArr[0] && cell[JV.PROP_AREA][JV.PROP_RIGHT] === hPosArr[1]) {
  1026. const hpStr = '_' + cell[JV.PROP_AREA][JV.PROP_TOP] + '_' + cell[JV.PROP_AREA][JV.PROP_BOTTOM];
  1027. if (cacheObj.hCacheStr.indexOf(hpStr) < 0) {
  1028. cacheObj.hCache[hpStr] = [];
  1029. cacheObj.hCacheStr.push(hpStr);
  1030. }
  1031. cacheObj.hCache[hpStr].push(idx);
  1032. }
  1033. }
  1034. }
  1035. if (verticalCombinePos.length > 0) {
  1036. const preColMergePosArr = []; // 见上面备注描述,纪录当前列的分割坐标集合情况
  1037. const private_chk_in_pre_merge = function(preIdx, newCell) {
  1038. let rst = true;
  1039. if (preIdx >= 0 && preIdx < preColMergePosArr.length) {
  1040. for (const mergeArea of preColMergePosArr[preIdx]) {
  1041. if (newCell[JV.PROP_AREA][JV.PROP_TOP] >= mergeArea[0] && newCell[JV.PROP_AREA][JV.PROP_TOP] < mergeArea[1]) {
  1042. rst = (newCell[JV.PROP_AREA][JV.PROP_BOTTOM] <= mergeArea[1]);
  1043. break;
  1044. }
  1045. }
  1046. }
  1047. return rst;
  1048. };
  1049. for (let vidx = 0; vidx < verticalCombinePos.length; vidx++) {
  1050. const vPosArr = verticalCombinePos[vidx];
  1051. const pStr = '_' + vPosArr[0] + '_' + vPosArr[1];
  1052. // rstPageCells的结果已经是按顺序排列了,这里不用再排序
  1053. if (cacheObj.vCache[pStr] && cacheObj.vCache[pStr].length > 0) {
  1054. let preCell = rstPageCells[cacheObj.vCache[pStr][0]];
  1055. if (vidx === 0) {
  1056. // 这里要处理下
  1057. let minY = 10000;
  1058. let maxY = 0;
  1059. for (let preCIdx = 0; preCIdx < cacheObj.vCache[pStr].length; preCIdx++) {
  1060. if (minY > rstPageCells[cacheObj.vCache[pStr][preCIdx]][JV.PROP_AREA][JV.PROP_TOP]) minY = rstPageCells[cacheObj.vCache[pStr][preCIdx]][JV.PROP_AREA][JV.PROP_TOP];
  1061. if (maxY < rstPageCells[cacheObj.vCache[pStr][preCIdx]][JV.PROP_AREA][JV.PROP_BOTTOM]) maxY = rstPageCells[cacheObj.vCache[pStr][preCIdx]][JV.PROP_AREA][JV.PROP_BOTTOM];
  1062. }
  1063. preColMergePosArr.push([[minY, maxY]]);
  1064. }
  1065. const dtlColMergePosArr = [];
  1066. preColMergePosArr.push(dtlColMergePosArr);
  1067. for (let cIdx = 1; cIdx < cacheObj.vCache[pStr].length; cIdx++) {
  1068. if (preCell.Value === '') {
  1069. dtlColMergePosArr.push([preCell[JV.PROP_AREA][JV.PROP_TOP], preCell[JV.PROP_AREA][JV.PROP_BOTTOM]]);
  1070. preCell = rstPageCells[cacheObj.vCache[pStr][cIdx]];
  1071. } else {
  1072. if (preCell.Value === rstPageCells[cacheObj.vCache[pStr][cIdx]].Value) {
  1073. const bkBottom = preCell[JV.PROP_AREA][JV.PROP_BOTTOM];
  1074. preCell[JV.PROP_AREA][JV.PROP_BOTTOM] = rstPageCells[cacheObj.vCache[pStr][cIdx]][JV.PROP_AREA][JV.PROP_BOTTOM];
  1075. if (reservedCells.indexOf(preCell) < 0) {
  1076. reservedCells.push(preCell);
  1077. }
  1078. if (private_chk_in_pre_merge(vidx, preCell)) {
  1079. removeCellIds.push(cacheObj.vCache[pStr][cIdx]);
  1080. if (cIdx === cacheObj.vCache[pStr].length - 1) {
  1081. dtlColMergePosArr.push([preCell[JV.PROP_AREA][JV.PROP_TOP], preCell[JV.PROP_AREA][JV.PROP_BOTTOM]]);
  1082. }
  1083. } else {
  1084. preCell[JV.PROP_AREA][JV.PROP_BOTTOM] = bkBottom;
  1085. dtlColMergePosArr.push([preCell[JV.PROP_AREA][JV.PROP_TOP], preCell[JV.PROP_AREA][JV.PROP_BOTTOM]]);
  1086. preCell = rstPageCells[cacheObj.vCache[pStr][cIdx]];
  1087. }
  1088. } else {
  1089. dtlColMergePosArr.push([preCell[JV.PROP_AREA][JV.PROP_TOP], preCell[JV.PROP_AREA][JV.PROP_BOTTOM]]);
  1090. preCell = rstPageCells[cacheObj.vCache[pStr][cIdx]];
  1091. }
  1092. }
  1093. }
  1094. }
  1095. }
  1096. }
  1097. if (horizonCombinePos.length > 1) {
  1098. if (cacheObj.hCacheStr.length > 0) {
  1099. for (const hStr of cacheObj.hCacheStr) {
  1100. let preCell = rstPageCells[cacheObj.hCache[hStr][0]];
  1101. for (let cIdx = 1; cIdx < cacheObj.hCache[hStr].length; cIdx++) {
  1102. if (preCell.Value === '') {
  1103. preCell = rstPageCells[cacheObj.hCache[hStr][cIdx]];
  1104. } else {
  1105. if (preCell.Value === rstPageCells[cacheObj.hCache[hStr][cIdx]].Value) {
  1106. if (preCell[JV.PROP_AREA][JV.PROP_RIGHT] < rstPageCells[cacheObj.hCache[hStr][cIdx]][JV.PROP_AREA][JV.PROP_RIGHT]) {
  1107. preCell[JV.PROP_AREA][JV.PROP_RIGHT] = rstPageCells[cacheObj.hCache[hStr][cIdx]][JV.PROP_AREA][JV.PROP_RIGHT];
  1108. } else {
  1109. preCell[JV.PROP_AREA][JV.PROP_LEFT] = rstPageCells[cacheObj.hCache[hStr][cIdx]][JV.PROP_AREA][JV.PROP_LEFT];
  1110. }
  1111. removeCellIds.push(cacheObj.hCache[hStr][cIdx]);
  1112. } else {
  1113. preCell = rstPageCells[cacheObj.hCache[hStr][cIdx]];
  1114. }
  1115. }
  1116. }
  1117. }
  1118. }
  1119. }
  1120. if (removeCellIds.length > 0) {
  1121. // 排序,保证一定的顺序,不能用默认的方式(默认方式是针对字符串的简单排序)
  1122. removeCellIds.sort(function(idx1, idx2) {
  1123. return idx1 - idx2;
  1124. });
  1125. for (let idx = removeCellIds.length - 1; idx >= 0; idx--) {
  1126. rstPageCells.splice(removeCellIds[idx], 1);
  1127. }
  1128. }
  1129. if (reservedCells.length > 0) {
  1130. for (const rCell of reservedCells) {
  1131. // 要拆分下数据
  1132. _splitValues(rCell);
  1133. setupControl(rCell, controls, true);
  1134. }
  1135. }
  1136. }
  1137. };
  1138. JpcFlowTabResult.outputPreviewContent = function(rptTpl, bands, unitFactor, controls, pageStatus, maxRec) {
  1139. const me = this;
  1140. const rst = [];
  1141. const tab = rptTpl[JV.NODE_FLOW_INFO][JV.NODE_FLOW_CONTENT];
  1142. const band = bands[tab[JV.PROP_BAND_NAME]];
  1143. if (band) {
  1144. if (pageStatus[band[JV.BAND_PROP_DISPLAY_TYPE]]) {
  1145. const tab_fields = tab[JV.PROP_FLOW_FIELDS];
  1146. for (let rowIdx = 0; rowIdx < maxRec; rowIdx++) {
  1147. for (let i = 0; i < tab_fields.length; i++) {
  1148. const tab_field = tab_fields[i];
  1149. if (!(tab_field[JV.PROP_HIDDEN])) {
  1150. rst.push(me.outputTabField(band, tab_field, null, -1, -1, maxRec, rowIdx, 1, 0, unitFactor, false, controls, 0));
  1151. }
  1152. }
  1153. }
  1154. }
  1155. }
  1156. return rst;
  1157. };
  1158. JpcFlowTabResult.outputContent = function(rptTpl, dataObj, page, bands, unitFactor, controls, fonts, multiColIdx, $CURRENT_RPT, customizeCfg) {
  1159. const me = this;
  1160. let rst = [];
  1161. const prepareObj = {};
  1162. const FLOW_NODE_STR = me.isEx ? JV.NODE_FLOW_INFO_EX : JV.NODE_FLOW_INFO;
  1163. const tab = rptTpl[FLOW_NODE_STR][JV.NODE_FLOW_CONTENT];
  1164. const tabEx = (rptTpl[JV.NODE_FLOW_INFO_EX]) ? rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_CONTENT] : null;
  1165. const verticalCombinePos = [];
  1166. const horizonCombinePos = []; // 合并特性用
  1167. const band = bands[tab[JV.PROP_BAND_NAME]];
  1168. if (band) {
  1169. const pageStatus = me.pageStatusLst[page - 1];
  1170. if (pageStatus[band[JV.BAND_PROP_DISPLAY_TYPE]]) {
  1171. const tab_fields = tab[JV.PROP_FLOW_FIELDS];
  1172. const tab_fields_ex = tabEx ? tabEx[JV.PROP_FLOW_FIELDS] : null;
  1173. const data_details = me.isEx ? dataObj[JV.DATA_DETAIL_DATA_EX] : dataObj[JV.DATA_DETAIL_DATA];
  1174. const data_details_ex = $CURRENT_RPT.isFollowMode ? dataObj[JV.DATA_DETAIL_DATA_EX] : null;
  1175. const contentValuesIdx = me.dispValueIdxLst[page - 1];
  1176. const page_sum_data_fields = [];
  1177. for (let i = 0; i < me.page_sum_fields_idx.length; i++) {
  1178. if (typeof (me.page_sum_fields_idx[i]) === 'object') {
  1179. const exField = JE.F(me.page_sum_fields_idx[i][JV.PROP_ID], $CURRENT_RPT);
  1180. if (exField) {
  1181. page_sum_data_fields.push(exField[JV.PROP_AD_HOC_DATA]);
  1182. } else {
  1183. page_sum_data_fields.push(null);
  1184. }
  1185. } else {
  1186. const data_field = data_details[me.page_sum_fields_idx[i]];
  1187. page_sum_data_fields.push(data_field);
  1188. }
  1189. }
  1190. const rowGrandTotal = [];
  1191. for (let di = 0; di < page_sum_data_fields.length; di++) {
  1192. rowGrandTotal.push(0.0);
  1193. }
  1194. // normal content
  1195. let flexiblePrecisionRefObj = null;
  1196. let flexibleRefField = null;
  1197. let precision_ref_data = null;
  1198. for (let rowIdx = 0; rowIdx < contentValuesIdx.length; rowIdx++) {
  1199. for (let fieldIdx = 0; fieldIdx < tab_fields.length; fieldIdx++) {
  1200. const tab_field = tab_fields[fieldIdx];
  1201. let data_field = null;
  1202. const map_data_field = JE.F(tab_field[JV.PROP_FIELD_ID], $CURRENT_RPT);
  1203. if (me.disp_fields_idx[fieldIdx] !== JV.BLANK_FIELD_INDEX && (typeof me.disp_fields_idx[fieldIdx] !== 'object')) {
  1204. data_field = data_details[me.disp_fields_idx[fieldIdx]];
  1205. } else {
  1206. if (map_data_field) {
  1207. data_field = map_data_field[JV.PROP_AD_HOC_DATA];
  1208. }
  1209. }
  1210. if (map_data_field && map_data_field[JV.PROP_PRECISION] && map_data_field.flexiblePrecisionRefObj) {
  1211. if (flexiblePrecisionRefObj === null) {
  1212. flexiblePrecisionRefObj = {};
  1213. flexibleRefField = JE.F(map_data_field[JV.PROP_PRECISION][JV.PROP_FLEXIBLE_REF_FILED_ID], $CURRENT_RPT);
  1214. precision_ref_data = dataObj[map_data_field.DataNodeName][flexibleRefField.DataSeq];
  1215. for (const decimalObj of map_data_field.flexiblePrecisionRefObj) {
  1216. flexiblePrecisionRefObj['refUnit_' + decimalObj.unit] = decimalObj.decimal;
  1217. }
  1218. }
  1219. JpcFieldHelper.resetFlexibleFormat(tab_field, precision_ref_data, flexiblePrecisionRefObj, contentValuesIdx[rowIdx][2], customizeCfg);
  1220. } else {
  1221. if (rowIdx === 0) JpcFieldHelper.resetFormat(tab_field, map_data_field, customizeCfg);
  1222. }
  1223. if (!(tab_field[JV.PROP_HIDDEN])) {
  1224. if (contentValuesIdx[rowIdx][0] !== JV.TYPE_FOLLOW_MODE && contentValuesIdx[rowIdx][1] === JV.DISPLAY_VAL_TYPE_NORMAL) {
  1225. rst.push(me.outputTabField(band, tab_field, data_field, contentValuesIdx[rowIdx][2], -1, contentValuesIdx.length, rowIdx, 1, 0, unitFactor, false, controls, multiColIdx));
  1226. } else if (contentValuesIdx[rowIdx][1] === JV.DISPLAY_VAL_TYPE_AUTO_HEIGHT) {
  1227. if (contentValuesIdx[rowIdx][4] === 1) {
  1228. // 等效于普通输出
  1229. rst.push(me.outputTabField(band, tab_field, data_field, contentValuesIdx[rowIdx][2], -1, contentValuesIdx.length, rowIdx, 1, 0, unitFactor, false, controls, multiColIdx));
  1230. } else {
  1231. // 这里需要做些style调整(中间的那些横杠线去掉)
  1232. const cellItem = me.outputAutoHeightTabField(band, tab_field, data_field, contentValuesIdx[rowIdx], contentValuesIdx.length, rowIdx, 1, 0, unitFactor, true, controls, multiColIdx);
  1233. rst.push(cellItem);
  1234. if (contentValuesIdx[rowIdx][3] === 0 || rowIdx === 0) {
  1235. cellItem[JV.PROP_STYLE] = cellItem[JV.PROP_STYLE] + '_AutoHeightMerge_Top';
  1236. } else if (contentValuesIdx[rowIdx][3] === contentValuesIdx[rowIdx][4] - 1) {
  1237. cellItem[JV.PROP_STYLE] = cellItem[JV.PROP_STYLE] + '_AutoHeightMerge_Bottom';
  1238. } else {
  1239. cellItem[JV.PROP_STYLE] = cellItem[JV.PROP_STYLE] + '_AutoHeightMerge_Middle';
  1240. }
  1241. prepareAutoHeightCells(prepareObj, cellItem, rst.length - 1, rst);
  1242. }
  1243. }
  1244. }
  1245. if (rowIdx === 0 && tab_field[JV.PROP_COMBINE_TYPE] !== undefined && tab_field[JV.PROP_COMBINE_TYPE] !== null) {
  1246. const rstCellItem = rst[rst.length - 1];
  1247. const cbfPos = [];
  1248. cbfPos.push(rstCellItem[JV.PROP_AREA][JV.PROP_LEFT]);
  1249. cbfPos.push(rstCellItem[JV.PROP_AREA][JV.PROP_RIGHT]);
  1250. if (tab_field[JV.PROP_COMBINE_TYPE] === 'vertical') {
  1251. verticalCombinePos.push(cbfPos);
  1252. } else if (tab_field[JV.PROP_COMBINE_TYPE] === 'horizon') {
  1253. horizonCombinePos.push(cbfPos);
  1254. }
  1255. }
  1256. }
  1257. if (contentValuesIdx[rowIdx][0] === JV.TYPE_FOLLOW_MODE) {
  1258. for (let idx_ex = 0; idx_ex < tab_fields_ex.length; idx_ex++) {
  1259. const tab_fieldex = tab_fields_ex[idx_ex];
  1260. let data_fieldex = null;
  1261. const map_data_fieldex = JE.F(tab_fieldex[JV.PROP_FIELD_ID], $CURRENT_RPT);
  1262. if (me.disp_fields_ex_idx[idx_ex] !== JV.BLANK_FIELD_INDEX && (typeof me.disp_fields_ex_idx[idx_ex] !== 'object')) {
  1263. data_fieldex = data_details_ex[me.disp_fields_ex_idx[idx_ex]];
  1264. } else {
  1265. if (map_data_fieldex) {
  1266. data_fieldex = map_data_fieldex[JV.PROP_AD_HOC_DATA];
  1267. }
  1268. }
  1269. if (map_data_fieldex && map_data_fieldex[JV.PROP_PRECISION] && map_data_fieldex.flexiblePrecisionRefObj) {
  1270. if (flexiblePrecisionRefObj === null) {
  1271. flexiblePrecisionRefObj = {};
  1272. flexibleRefField = JE.F(map_data_fieldex[JV.PROP_PRECISION][JV.PROP_FLEXIBLE_REF_FILED_ID], $CURRENT_RPT);
  1273. for (const decimalObj of map_data_fieldex.flexiblePrecisionRefObj) {
  1274. flexiblePrecisionRefObj['refUnit_' + decimalObj.unit] = decimalObj.decimal;
  1275. }
  1276. }
  1277. JpcFieldHelper.resetFlexibleFormat(tab_fieldex, flexibleRefField, flexiblePrecisionRefObj, contentValuesIdx[rowIdx][2], customizeCfg);
  1278. } else {
  1279. if (rowIdx === 0) JpcFieldHelper.resetFormat(tab_fieldex, map_data_fieldex, customizeCfg);
  1280. }
  1281. if (!(tab_fieldex[JV.PROP_HIDDEN])) {
  1282. if (contentValuesIdx[rowIdx][0] === JV.TYPE_FOLLOW_MODE && contentValuesIdx[rowIdx][1] === JV.DISPLAY_VAL_TYPE_NORMAL) {
  1283. rst.push(me.outputTabField(band, tab_fieldex, data_fieldex, contentValuesIdx[rowIdx][2], -1, contentValuesIdx.length, rowIdx, 1, 0, unitFactor, false, controls, multiColIdx));
  1284. }
  1285. }
  1286. }
  1287. }
  1288. // page sum content
  1289. for (let di = 0; di < page_sum_data_fields.length; di++) {
  1290. if (contentValuesIdx[rowIdx][1] === JV.DISPLAY_VAL_TYPE_NORMAL ||
  1291. contentValuesIdx[rowIdx][1] === JV.DISPLAY_VAL_TYPE_AUTO_HEIGHT && contentValuesIdx[rowIdx][3] === 0) {
  1292. let precisionAmt = 4;
  1293. const sum_field = JE.F(me.page_sum_tab_fields[di][JV.PROP_FIELD_ID], $CURRENT_RPT);
  1294. if (sum_field[JV.PROP_PRECISION] && sum_field[JV.PROP_PRECISION].type === 'fixed') {
  1295. precisionAmt = sum_field[JV.PROP_FIXED_PRECISION_AMT];
  1296. } else {
  1297. const flowF = me.page_sum_tab_fields[di];
  1298. if (flowF && !strUtil.isEmptyString(flowF[JV.PROP_FORMAT])) {
  1299. const idx = flowF[JV.PROP_FORMAT].indexOf('.');
  1300. if (idx >= 0) {
  1301. precisionAmt = flowF[JV.PROP_FORMAT].length - idx - 1;
  1302. }
  1303. }
  1304. }
  1305. // rowGrandTotal[di] = rowGrandTotal[di] + 1.0 * JpcFieldHelper.getValue(page_sum_data_fields[di], contentValuesIdx[rowIdx][2]);
  1306. if (contentValuesIdx[rowIdx][2] >= 0) {
  1307. const psv = JpcFieldHelper.getValue(page_sum_data_fields[di], contentValuesIdx[rowIdx][2]);
  1308. if (psv) {
  1309. rowGrandTotal[di] = bc.add(rowGrandTotal[di] ? rowGrandTotal[di] : 0, parseFloat(psv));
  1310. // rowGrandTotal[di] = rowGrandTotal[di] + parseFloat(parseFloat(psv).toFixed(precisionAmt));
  1311. }
  1312. }
  1313. }
  1314. }
  1315. }
  1316. me.pageSumValLst.push(rowGrandTotal);
  1317. // grouping content
  1318. let grpCntIdx = 0;
  1319. for (let rowIdx = 0; rowIdx < contentValuesIdx.length; rowIdx++) {
  1320. if (contentValuesIdx[rowIdx][1] === JV.DISPLAY_VAL_TYPE_GROUP) {
  1321. for (let grpIdx = 0; grpIdx < rptTpl[FLOW_NODE_STR][JV.NODE_FLOW_GROUP][JV.PROP_GROUP_LINES].length; grpIdx++) {
  1322. if (contentValuesIdx[rowIdx][3] === grpIdx) {
  1323. const grp_line = rptTpl[FLOW_NODE_STR][JV.NODE_FLOW_GROUP][JV.PROP_GROUP_LINES][grpIdx];
  1324. if (page === 1) {
  1325. if (grp_line[JV.PROP_GROUP_SUM_KEYS] && grp_line[JV.PROP_GROUP_SUM_KEYS].length > 0) {
  1326. for (const grp_sum_field of grp_line[JV.PROP_GROUP_SUM_KEYS]) {
  1327. if (grp_sum_field[JV.PROP_FIELD_ID]) {
  1328. const map_field = JE.F(grp_sum_field[JV.PROP_FIELD_ID], $CURRENT_RPT);
  1329. JpcFieldHelper.resetFormat(grp_sum_field, map_field, customizeCfg);
  1330. }
  1331. }
  1332. }
  1333. }
  1334. const lineRst = me.outputTabGrpLine(band, grp_line, page, contentValuesIdx[rowIdx], contentValuesIdx.length, rowIdx, 1, 0, unitFactor, true, controls, multiColIdx, grpCntIdx, $CURRENT_RPT, dataObj);
  1335. rst = rst.concat(lineRst);
  1336. }
  1337. }
  1338. grpCntIdx++;
  1339. }
  1340. }
  1341. }
  1342. }
  1343. const eliminateCells = combineAutoHeightCells(prepareObj, page, controls);
  1344. for (let idIdx = eliminateCells.length - 1; idIdx >= 0; idIdx--) {
  1345. rst.splice(eliminateCells[idIdx], 1);
  1346. }
  1347. me.checkCombineEvent(JV.RUN_TYPE_BEFORE_COMBINE, verticalCombinePos, horizonCombinePos, rst, $CURRENT_RPT, dataObj);
  1348. me.combinePageCells(rst, verticalCombinePos, horizonCombinePos, controls, fonts);
  1349. me.checkCombineEvent(JV.RUN_TYPE_AFTER_COMBINE, verticalCombinePos, horizonCombinePos, rst, $CURRENT_RPT, dataObj);
  1350. return rst;
  1351. };
  1352. JpcFlowTabResult.checkCombineEvent = function($RUN_TYPE, $VER_COMB_ARRAY, $HOR_COMB_ARRAY, $CURRENT_CELL_ITEMS, $CURRENT_RPT, $CURRENT_DATA) {
  1353. if ($CURRENT_RPT.formulas) {
  1354. const $JE = JE;
  1355. const $JV = JV;
  1356. for (let execFmlIdx = 0; execFmlIdx < $CURRENT_RPT.formulas.length; execFmlIdx++) {
  1357. if ($CURRENT_RPT.formulas[execFmlIdx][JV.PROP_RUN_TYPE] === $RUN_TYPE) {
  1358. const expression = $CURRENT_RPT.formulas[execFmlIdx][JV.PROP_EXPRESSION];
  1359. if (expression) {
  1360. const $ME = $CURRENT_RPT.formulas[execFmlIdx];
  1361. try {
  1362. eval(expression);
  1363. } catch (ex) {
  1364. console.log(ex);
  1365. }
  1366. }
  1367. }
  1368. }
  1369. }
  1370. };
  1371. JpcFlowTabResult.outputColumn = function(rptTpl, dataObj, page, segIdx, segPageIdx, bands, unitFactor, multiColIdx, $CURRENT_RPT, customizeCfg) {
  1372. const me = this;
  1373. let rst = [];
  1374. const FLOW_NODE_STR = me.isEx ? JV.NODE_FLOW_INFO_EX : JV.NODE_FLOW_INFO;
  1375. const tab = rptTpl[FLOW_NODE_STR][JV.NODE_FLOW_COLUMN];
  1376. const band = bands[tab[JV.PROP_BAND_NAME]];
  1377. if (band) {
  1378. const pageStatus = me.pageStatusLst[page - 1];
  1379. if (pageStatus[band[JV.BAND_PROP_DISPLAY_TYPE]]) {
  1380. rst = rst.concat(me.commonTabRestOutput(dataObj, page, segIdx, segPageIdx, bands, band, unitFactor, tab, multiColIdx, $CURRENT_RPT, customizeCfg));
  1381. }
  1382. }
  1383. return rst;
  1384. };
  1385. JpcFlowTabResult.outputPreviewSegSum = function(rptTpl, bands, unitFactor, controls, pageStatus) {
  1386. let rst = [];
  1387. const tab = rptTpl[JV.NODE_FLOW_INFO][JV.NODE_FLOW_SEG_SUM];
  1388. const band = bands[tab[JV.PROP_BAND_NAME]];
  1389. if (band) {
  1390. if (pageStatus[band[JV.BAND_PROP_DISPLAY_TYPE]]) {
  1391. rst = rst.concat(JpcDiscreteHelper.outputPreviewSumInfoOutput(band, unitFactor, tab));
  1392. }
  1393. }
  1394. return rst;
  1395. };
  1396. JpcFlowTabResult.outputPreviewPageSum = function(rptTpl, bands, unitFactor, controls, pageStatus) {
  1397. let rst = [];
  1398. const tab = rptTpl[JV.NODE_FLOW_INFO][JV.NODE_FLOW_PAGE_SUM];
  1399. const band = bands[tab[JV.PROP_BAND_NAME]];
  1400. if (band) {
  1401. if (pageStatus[band[JV.BAND_PROP_DISPLAY_TYPE]]) {
  1402. rst = rst.concat(JpcDiscreteHelper.outputPreviewSumInfoOutput(band, unitFactor, tab));
  1403. }
  1404. }
  1405. return rst;
  1406. };
  1407. JpcFlowTabResult.outputSegSum = function(rptTpl, dataObj, page, segIdx, bands, unitFactor, controls, $CURRENT_RPT, customizeCfg) {
  1408. const me = this;
  1409. let rst = [];
  1410. const FLOW_NODE_STR = me.isEx ? JV.NODE_FLOW_INFO_EX : JV.NODE_FLOW_INFO;
  1411. const tab = rptTpl[FLOW_NODE_STR][JV.NODE_FLOW_SEG_SUM];
  1412. const refTab = rptTpl[FLOW_NODE_STR][JV.NODE_FLOW_CONTENT];
  1413. const refTabEx = (rptTpl[JV.NODE_FLOW_INFO_EX]) ? rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_CONTENT] : null;
  1414. const band = bands[tab[JV.PROP_BAND_NAME]];
  1415. if (band) {
  1416. const pageStatus = me.pageStatusLst[page - 1];
  1417. if (pageStatus[band[JV.BAND_PROP_DISPLAY_TYPE]]) {
  1418. const ref_tab_fields = refTab[JV.PROP_FLOW_FIELDS];
  1419. const ref_tab_fields_ex = refTabEx ? refTabEx[JV.PROP_FLOW_FIELDS] : null;
  1420. const tab_fields = me.seg_sum_tab_fields;
  1421. for (let i = 0; i < tab_fields.length; i++) {
  1422. if (!JpcFieldHelper.resetSumFormat(ref_tab_fields, tab_fields[i])) {
  1423. if (!JpcFieldHelper.resetSumFormat(ref_tab_fields_ex, tab_fields[i])) {
  1424. const map_data_field = JE.F(tab_fields[i][JV.PROP_FIELD_ID], $CURRENT_RPT);
  1425. JpcFieldHelper.resetFormat(tab_fields[i], map_data_field, customizeCfg);
  1426. // 如果都找不到,就得靠自己的Format属性了
  1427. }
  1428. }
  1429. let sumVal = 0;
  1430. if (me.segSumValLst[segIdx] && me.segSumValLst[segIdx].length > i) {
  1431. sumVal = me.segSumValLst[segIdx][i];
  1432. }
  1433. // 备注:考虑到有时候会出现没有数据可合计的scenario,得有容错处理
  1434. const cellItem = JpcCommonOutputHelper.createCommonOutput(tab_fields[i], sumVal, controls);
  1435. cellItem[JV.PROP_AREA] = JpcAreaHelper.outputArea(tab_fields[i][JV.PROP_AREA], band, unitFactor, 1, 0, 1, 0, me.multiCols, 0, false, false);
  1436. rst.push(cellItem);
  1437. }
  1438. rst = rst.concat(me.commonTabRestOutput(dataObj, page, segIdx, 0, bands, band, unitFactor, tab, 0, $CURRENT_RPT, customizeCfg));
  1439. }
  1440. }
  1441. return rst;
  1442. };
  1443. JpcFlowTabResult.outputPageSum = function(rptTpl, dataObj, page, segIdx, bands, unitFactor, controls, $CURRENT_RPT, customizeCfg) {
  1444. const me = this;
  1445. let rst = [];
  1446. const FLOW_NODE_STR = me.isEx ? JV.NODE_FLOW_INFO_EX : JV.NODE_FLOW_INFO;
  1447. const tab = rptTpl[FLOW_NODE_STR][JV.NODE_FLOW_PAGE_SUM];
  1448. const refTab = rptTpl[FLOW_NODE_STR][JV.NODE_FLOW_CONTENT];
  1449. const refTabEx = (rptTpl[JV.NODE_FLOW_INFO_EX]) ? rptTpl[JV.NODE_FLOW_INFO_EX][JV.NODE_FLOW_CONTENT] : null;
  1450. const band = bands[tab[JV.PROP_BAND_NAME]];
  1451. if (band) {
  1452. const pageStatus = me.pageStatusLst[page - 1];
  1453. if (pageStatus[band[JV.BAND_PROP_DISPLAY_TYPE]]) {
  1454. const ref_tab_fields = refTab[JV.PROP_FLOW_FIELDS];
  1455. const ref_tab_fields_ex = refTabEx ? refTabEx[JV.PROP_FLOW_FIELDS] : null;
  1456. const tab_fields = me.page_sum_tab_fields;
  1457. for (let i = 0; i < tab_fields.length; i++) {
  1458. if (!JpcFieldHelper.resetSumFormat(ref_tab_fields, tab_fields[i])) {
  1459. if (!JpcFieldHelper.resetSumFormat(ref_tab_fields_ex, tab_fields[i])) {
  1460. const map_data_field = JE.F(tab_fields[i][JV.PROP_FIELD_ID], $CURRENT_RPT);
  1461. JpcFieldHelper.resetFormat(tab_fields[i], map_data_field, customizeCfg);
  1462. // 如果都找不到,就得靠自己的Format属性了
  1463. }
  1464. }
  1465. const cellItem = JpcCommonOutputHelper.createCommonOutput(tab_fields[i], me.pageSumValLst[page - 1][i], controls);
  1466. cellItem[JV.PROP_AREA] = JpcAreaHelper.outputArea(tab_fields[i][JV.PROP_AREA], band, unitFactor, 1, 0, 1, 0, me.multiCols, 0, false, false);
  1467. rst.push(cellItem);
  1468. }
  1469. rst = rst.concat(me.commonTabRestOutput(dataObj, page, segIdx, 0, bands, band, unitFactor, tab, 0, $CURRENT_RPT, customizeCfg));
  1470. }
  1471. }
  1472. return rst;
  1473. };
  1474. JpcFlowTabResult.outputTabField = function(band, tab_field, data_field, valueIdx, serialIdx, rows, rowIdx, cols, colIdx, unitFactor, isRow, controls, multiColIdx) {
  1475. const me = this;
  1476. const rst = JpcCommonOutputHelper.createCommonOutput(tab_field, JpcFieldHelper.getValue(data_field, valueIdx), controls);
  1477. rst[JV.PROP_AREA] = JpcAreaHelper.outputArea(tab_field[JV.PROP_AREA], band, unitFactor, rows, rowIdx, cols, colIdx, me.multiCols, multiColIdx, isRow, false);
  1478. return rst;
  1479. };
  1480. JpcFlowTabResult.outputAutoHeightTabField = function(band, tab_field, data_field, contentValInfo, rows, rowIdx, cols, colIdx, unitFactor, isRow, controls, multiColIdx) {
  1481. const me = this;
  1482. let rst = null;
  1483. let showText = JpcFieldHelper.getValue(data_field, contentValInfo[2]);
  1484. if (tab_field[JV.PROP_IS_AUTO_HEIGHT]) {
  1485. let textArr = [];
  1486. if (showText) {
  1487. textArr = textArr.concat(showText.split('|'));
  1488. }
  1489. /*
  1490. if (contentValInfo[3] < textArr.length && contentValInfo[3] >= 0) {
  1491. showText = textArr[contentValInfo[3]];
  1492. } else {
  1493. showText = '';
  1494. }
  1495. /*/
  1496. // 因新逻辑要优化自动行高,不再是一个折行占用1row,而是:
  1497. // a. 根据实际情况,设置了一个实际的行数值(比如共有10行,根据行高情况,可能只设置了6行的高度,在setupAutoHeightData方法里处理)
  1498. // b. 这里最大的难题在于跨页分配(预估会有来回调整,目前采用按比例分配原则)
  1499. // c. 还有个问题就是多个自动行高指标的问题
  1500. const ACT_ROWS = contentValInfo[4]; // 经实际计算,能容纳所有数据的实际行数
  1501. const CURRENT_ROW = contentValInfo[3]; // 从0开始
  1502. const QUOTA_Rate = textArr.length / ACT_ROWS; // 每行显示的加权系数(超过2的话,表示给的行高太多了,需要另外一些特殊处理,后期有需要再加)
  1503. if (textArr.length <= 3 || ACT_ROWS > textArr.length) {
  1504. // 表示这个一定是附属的autoheight指标,或者数据就只有3行(假如数据3行精简成2行,但刚好处于分页状态,那么无论是前一页或后一页,显示上都很纠结(多出来的一行放哪好?),所以新逻辑的起点要3行以上,少了就不折腾了,老老实实地一个萝卜一个坑)
  1505. if (CURRENT_ROW < textArr.length && CURRENT_ROW >= 0) {
  1506. showText = textArr[CURRENT_ROW];
  1507. } else {
  1508. showText = '';
  1509. }
  1510. } else {
  1511. // 这里不管是不是附属autoheight指标,有足够的条件单独处理
  1512. if (QUOTA_Rate >= 2) {
  1513. // 压缩超过一半空间的话,说明给的行高度太高了,需要另外一些特殊处理,后期有需要再加
  1514. console.log('压缩率异常!!!!!');
  1515. } else {
  1516. // 正常的压缩比例
  1517. let startIdx = 0,
  1518. endIdx = 0;
  1519. if (CURRENT_ROW > 0) {
  1520. endIdx = Math.round((CURRENT_ROW + 1) * QUOTA_Rate) - 1;
  1521. let preEndIdx = 0;
  1522. if (CURRENT_ROW > 1) {
  1523. // 重定位 preEndIdx
  1524. preEndIdx = Math.round(CURRENT_ROW * QUOTA_Rate) - 1;
  1525. }
  1526. startIdx = preEndIdx + 1;
  1527. }
  1528. // 按比例分配
  1529. showText = textArr[startIdx];
  1530. for (let idx = startIdx + 1; idx <= endIdx; idx++) {
  1531. showText += `|${textArr[idx]}`;
  1532. }
  1533. }
  1534. }
  1535. // */
  1536. rst = JpcCommonOutputHelper.createCommonOutput(tab_field, showText, controls);
  1537. rst[JV.PROP_AREA] = JpcAreaHelper.outputArea(tab_field[JV.PROP_AREA], band, unitFactor, rows, rowIdx, cols, colIdx, me.multiCols, multiColIdx, true, false);
  1538. rst[JV.PROP_IS_AUTO_HEIGHT] = true;
  1539. } else {
  1540. if (contentValInfo[3] > 0) showText = '';
  1541. rst = JpcCommonOutputHelper.createCommonOutput(tab_field, showText, controls);
  1542. rst[JV.PROP_AREA] = JpcAreaHelper.outputArea(tab_field[JV.PROP_AREA], band, unitFactor, rows, rowIdx, cols, colIdx, me.multiCols, multiColIdx, true, false);
  1543. rst[JV.PROP_IS_AUTO_HEIGHT] = false;
  1544. }
  1545. return rst;
  1546. };
  1547. JpcFlowTabResult.outputTabGrpLine = function(band, grp_line, page, grpValueIdx, rows, rowIdx, cols, colIdx, unitFactor, isRow, controls, multiColIdx, grpCntIdx, $CURRENT_RPT, $CURRENT_DATA) {
  1548. const me = this;
  1549. const rst = [];
  1550. if (grp_line[JV.PROP_GROUP_SUM_KEYS]) {
  1551. const segIdx = JpcCommonHelper.getSegIdxByPageIdx(page, me.page_seg_map);
  1552. const curSegGrpSum = me.group_sum_values[segIdx];
  1553. for (const sumFieldNode of grp_line[JV.PROP_GROUP_SUM_KEYS]) {
  1554. // let value = curSegGrpSum[sumFieldNode[JV.PROP_SUM_KEY]][grpValueIdx[2]];
  1555. const value = curSegGrpSum['grp_sum_key_' + sumFieldNode[JV.PROP_FIELD_ID]][grpValueIdx[2]];
  1556. const sumFldRst = JpcTextHelper.outputDirectValue(sumFieldNode, value, band, unitFactor, rows, rowIdx, cols, colIdx, me.multiCols, multiColIdx);
  1557. rst.push(sumFldRst);
  1558. }
  1559. }
  1560. if (grp_line[JV.PROP_TEXTS]) {
  1561. for (const txt of grp_line[JV.PROP_TEXTS]) {
  1562. me.checkGrpTxtOutEvent(JV.RUN_TYPE_BEFORE_GROUP_TEXT_OUT, txt, grpCntIdx, $CURRENT_RPT, $CURRENT_DATA);
  1563. rst.push(JpcTextHelper.outputText(txt, band, unitFactor, rows, rowIdx, cols, colIdx, me.multiCols, multiColIdx));
  1564. // me.combinePageCells(rst, verticalCombinePos, horizonCombinePos, controls);
  1565. // 可能会有一个After,但意义不大,用不着
  1566. }
  1567. }
  1568. if (grp_line[JV.PROP_DISCRETE_FIELDS]) {
  1569. // 暂时不支持
  1570. }
  1571. if (grp_line[JV.PROP_PARAMS]) {
  1572. // 暂时不支持
  1573. }
  1574. // console.log(rst);
  1575. return rst;
  1576. };
  1577. JpcFlowTabResult.checkGrpTxtOutEvent = function($RUN_TYPE, $TEXT, $TIMES, $CURRENT_RPT, $CURRENT_DATA) {
  1578. if ($CURRENT_RPT.formulas) {
  1579. for (let execFmlIdx = 0; execFmlIdx < $CURRENT_RPT.formulas.length; execFmlIdx++) {
  1580. if ($CURRENT_RPT.formulas[execFmlIdx][JV.PROP_RUN_TYPE] === $RUN_TYPE) {
  1581. const expression = $CURRENT_RPT.formulas[execFmlIdx][JV.PROP_EXPRESSION];
  1582. if (expression) {
  1583. const $ME = $CURRENT_RPT.formulas[execFmlIdx];
  1584. const $JE = JE;
  1585. try {
  1586. eval(expression);
  1587. } catch (ex) {
  1588. console.log(ex);
  1589. }
  1590. }
  1591. }
  1592. }
  1593. }
  1594. };
  1595. JpcFlowTabResult.commonTabRestOutput = function(dataObj, page, segIdx, segPageIdx, bands, band, unitFactor, tab, multiColIdx, $CURRENT_RPT, customizeCfg) {
  1596. const me = this;
  1597. let rst = [];
  1598. if (tab[JV.PROP_TEXT]) {
  1599. rst.push(JpcTextHelper.outputText(tab[JV.PROP_TEXT], band, unitFactor, 1, 0, 1, 0, me.multiCols, multiColIdx));
  1600. }
  1601. if (tab[JV.PROP_TEXTS]) {
  1602. for (let j = 0; j < tab[JV.PROP_TEXTS].length; j++) {
  1603. rst.push(JpcTextHelper.outputText(tab[JV.PROP_TEXTS][j], band, unitFactor, 1, 0, 1, 0, me.multiCols, multiColIdx));
  1604. }
  1605. }
  1606. if (tab[JV.NODE_DISCRETE_INFO]) {
  1607. rst = rst.concat(JpcDiscreteHelper.outputDiscreteInfo(tab[JV.NODE_DISCRETE_INFO], bands, dataObj, unitFactor, me.pageStatusLst[page - 1], segIdx, segPageIdx, 1, 0, $CURRENT_RPT, customizeCfg, me.signatureRst, me.signatureDateRst, me.signatureAuditRst, me.interactRst));
  1608. }
  1609. return rst;
  1610. };
  1611. return JpcFlowTabResult;
  1612. };
  1613. function push_cell(pageCellObj, cell, cellIdx) {
  1614. const key = cell[JV.PROP_AREA][JV.PROP_LEFT] + '_' + cell[JV.PROP_AREA][JV.PROP_RIGHT];
  1615. if (!pageCellObj[key]) {
  1616. pageCellObj[key] = [];
  1617. }
  1618. const cellArr = pageCellObj[key];
  1619. cellArr.push({ cellIdx, cell });
  1620. }
  1621. function prepareAutoHeightCells(prepareObj, cellItem, cellIdx, cellsArr) {
  1622. if (prepareObj) {
  1623. if (prepareObj.cellsArr === undefined) {
  1624. prepareObj.cellsArr = cellsArr;
  1625. prepareObj.pageCellObj = {};
  1626. }
  1627. push_cell(prepareObj.pageCellObj, cellItem, cellIdx);
  1628. }
  1629. }
  1630. function setupControl(mergeCell, controls, isCombine = false) {
  1631. let orgCtrl = null;
  1632. if (typeof mergeCell[JV.PROP_CONTROL] === 'string') {
  1633. orgCtrl = controls[mergeCell[JV.PROP_CONTROL]];
  1634. mergeCell[JV.PROP_CONTROL] = {
  1635. Shrink: 'T',
  1636. ShrinkFirst: orgCtrl.ShrinkFirst,
  1637. CloseOutput: orgCtrl.CloseOutput,
  1638. ShowZero: orgCtrl.ShowZero,
  1639. Horizon: orgCtrl.Horizon,
  1640. Vertical: orgCtrl.Vertical,
  1641. Wrap: (mergeCell[JV.PROP_IS_AUTO_HEIGHT]) ? 'T' : 'F',
  1642. VerticalForExcel: 'center',
  1643. };
  1644. } else {
  1645. mergeCell[JV.PROP_CONTROL][JV.CONTROL_PROPS[JV.CONTROL_PROP_IDX_SHRINK]] = 'T';
  1646. // mergeCell[JV.PROP_CONTROL][JV.CONTROL_PROPS[JV.CONTROL_PROP_IDX_VERTICAL]] = 'top';
  1647. mergeCell[JV.PROP_CONTROL][JV.CONTROL_PROPS[JV.CONTROL_PROP_IDX_WRAP]] = (mergeCell[JV.PROP_IS_AUTO_HEIGHT]) ? 'T' : 'F';
  1648. // mergeCell[JV.PROP_CONTROL][JV.CONTROL_PROPS[JV.CONTROL_PROP_IDX_VERTICAL_EXCEL]] = 'center';
  1649. mergeCell[JV.PROP_CONTROL][JV.CONTROL_PROPS[JV.CONTROL_PROP_IDX_VERTICAL_EXCEL]] = mergeCell[JV.PROP_CONTROL][JV.CONTROL_PROPS[JV.CONTROL_PROP_IDX_VERTICAL]];
  1650. orgCtrl = mergeCell[JV.PROP_CONTROL];
  1651. }
  1652. if (mergeCell[JV.PROP_IS_AUTO_HEIGHT]) {
  1653. mergeCell[JV.PROP_CONTROL][JV.CONTROL_PROPS[JV.CONTROL_PROP_IDX_VERTICAL_EXCEL]] = 'justify';
  1654. // mergeCell[JV.PROP_CONTROL]['Vertical'] = 'center';
  1655. } else if (isCombine && orgCtrl.CloseOutput === 'T') {
  1656. mergeCell[JV.PROP_CONTROL][JV.CONTROL_PROPS[JV.CONTROL_PROP_IDX_WRAP]] = 'T';
  1657. mergeCell[JV.PROP_CONTROL][JV.CONTROL_PROPS[JV.CONTROL_PROP_IDX_VERTICAL_EXCEL]] = 'justify';
  1658. } else {
  1659. mergeCell[JV.PROP_CONTROL][JV.CONTROL_PROPS[JV.CONTROL_PROP_IDX_VERTICAL_EXCEL]] = 'center';
  1660. // mergeCell[JV.PR OP_CONTROL]['Vertical'] = 'top';
  1661. }
  1662. return orgCtrl;
  1663. }
  1664. function combineAutoHeightCells(prepareObj, page, controls) {
  1665. const rst = [];
  1666. if (prepareObj.cellsArr) {
  1667. // merge cells' value and area
  1668. // 备注: 系统逻辑已经把Cell的顺序放好,无需再做排序。
  1669. for (const mergeKey in prepareObj.pageCellObj) {
  1670. const sameColCells = prepareObj.pageCellObj[mergeKey]; // 左右位置相同的Cell先放在一起,统一处理
  1671. if (sameColCells.length > 1) {
  1672. let firstMergeCell = sameColCells[0].cell;
  1673. firstMergeCell[JV.PROP_STYLE] = firstMergeCell[JV.PROP_STYLE].slice(0, firstMergeCell[JV.PROP_STYLE].indexOf('_AutoHeightMerge')); // 首先还原original style
  1674. let orgCtrl = setupControl(firstMergeCell, controls);
  1675. let validValueAmt = 0;
  1676. let fullValidValueAmt = 0;
  1677. for (let i = 1; i < sameColCells.length; i++) {
  1678. const mergeCell = sameColCells[i].cell;
  1679. if (mergeCell[JV.PROP_STYLE].indexOf('_AutoHeightMerge_Top') < 0) {
  1680. fullValidValueAmt++;
  1681. // merge into the firstMergeCell! position & value
  1682. firstMergeCell[JV.PROP_AREA][JV.PROP_BOTTOM] = mergeCell[JV.PROP_AREA][JV.PROP_BOTTOM];
  1683. if (mergeCell[JV.PROP_VALUE]) {
  1684. firstMergeCell[JV.PROP_VALUE] = firstMergeCell[JV.PROP_VALUE] + '|' + mergeCell[JV.PROP_VALUE];
  1685. validValueAmt++;
  1686. }
  1687. rst.push(sameColCells[i].cellIdx); // 记下Cell的位置,在函数外消除
  1688. // 如果到了最后一条数据,得判断firstMergeCell是否满格(即数据是满的,有可能有些格数据也有折行但不是自动行高判断指标)
  1689. // 不满格的cell的Vertical强制设置为 'center'
  1690. if (i === sameColCells.length - 1 && validValueAmt !== fullValidValueAmt && (fullValidValueAmt / validValueAmt > 2.5)) {
  1691. firstMergeCell[JV.PROP_CONTROL][JV.CONTROL_PROPS[JV.CONTROL_PROP_IDX_VERTICAL_EXCEL]] = 'center';
  1692. }
  1693. } else {
  1694. // 碰到新开始的自动行高行,判断原先的firstMergeCell是否满格(即数据是满的,有可能有些格数据也有折行但不是自动行高判断指标)
  1695. // 不满格的cell的Vertical强制设置为 'center'
  1696. if (validValueAmt !== fullValidValueAmt && (fullValidValueAmt / validValueAmt > 2.5)) {
  1697. firstMergeCell[JV.PROP_CONTROL][JV.CONTROL_PROPS[JV.CONTROL_PROP_IDX_VERTICAL_EXCEL]] = 'center';
  1698. }
  1699. firstMergeCell = sameColCells[i].cell;
  1700. firstMergeCell[JV.PROP_STYLE] = firstMergeCell[JV.PROP_STYLE].slice(0, firstMergeCell[JV.PROP_STYLE].indexOf('_AutoHeightMerge'));
  1701. orgCtrl = setupControl(firstMergeCell, controls);
  1702. validValueAmt = 0;
  1703. fullValidValueAmt = 0;
  1704. }
  1705. }
  1706. }
  1707. }
  1708. rst.sort(function(i1, i2) {
  1709. return (i1 > i2) ? 1 : -1;
  1710. });
  1711. }
  1712. return rst;
  1713. }
  1714. module.exports = new JpcFlowTabSrv();