jpc_flow_tab.js 87 KB

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