jpc_flow_tab.ts 91 KB

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