jpc_cross_tab.js 46 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801
  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 JpcCrossTabHelper = require('./helper/jpc_helper_cross_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 JpcCrossTabSrv = function(){};
  13. JpcCrossTabSrv.prototype.createNew = function(){
  14. function private_addTabValue(tabValuedIdxLst, sortedSequence, segIdx, preRec, nextRec, dispSerialIdxLst, sorted_sum_value_Lst, rst_sum_value_Lst) {
  15. if (tabValuedIdxLst) {
  16. let serial1stTier = null;
  17. if (dispSerialIdxLst) serial1stTier = [];
  18. let pgseg1stTier = [];
  19. let sumVal = [];
  20. let sumValL = 1;
  21. if (sortedSequence) {
  22. let arrDupVals = sortedSequence[segIdx];
  23. let arrDupSumVals = null;
  24. if (sorted_sum_value_Lst !== null) {
  25. arrDupSumVals = sorted_sum_value_Lst[segIdx];
  26. sumValL = arrDupSumVals[0].length;
  27. }
  28. for (let i = 0; i < nextRec; i++) {
  29. if (arrDupVals.length <= preRec + i) {
  30. pgseg1stTier[i] = JV.BLANK_VALUE_INDEX;
  31. sumVal[i] = [];
  32. for (let ei = 0; ei < sumValL; ei++) {
  33. sumVal[i][ei] = null;
  34. }
  35. if (serial1stTier !== null) {
  36. serial1stTier[i] = JV.BLANK_VALUE_INDEX;
  37. }
  38. continue;
  39. }
  40. let duplicateValueArr = arrDupVals[preRec + i];
  41. pgseg1stTier[i] = duplicateValueArr[0];
  42. if (arrDupSumVals !== null) sumVal[i] = arrDupSumVals[preRec + i];
  43. if (serial1stTier !== null) {
  44. serial1stTier[i] = preRec + i;
  45. }
  46. }
  47. tabValuedIdxLst.push(pgseg1stTier);
  48. if (dispSerialIdxLst !== null) {
  49. dispSerialIdxLst.push(serial1stTier);
  50. }
  51. if (sorted_sum_value_Lst !== null && rst_sum_value_Lst !== null) {
  52. rst_sum_value_Lst.push(sumVal);
  53. }
  54. } else {
  55. //should push blank value index rather than null
  56. for (let i = 0; i < nextRec; i++) {
  57. pgseg1stTier[i] = JV.BLANK_VALUE_INDEX;
  58. sumVal[i] = null;
  59. if (serial1stTier !== null) {
  60. serial1stTier[i] = JV.BLANK_VALUE_INDEX;
  61. }
  62. }
  63. tabValuedIdxLst.push(pgseg1stTier);
  64. if (dispSerialIdxLst !== null) {
  65. dispSerialIdxLst.push(serial1stTier);
  66. }
  67. if (sorted_sum_value_Lst !== null && rst_sum_value_Lst !== null) {
  68. rst_sum_value_Lst.push(sumVal);
  69. }
  70. }
  71. }
  72. }
  73. function private_addContentValue(dispValueIdxLst_Content, sortedContentSequence, segIdx, counterRowRec, maxRowRec, counterColRec, maxColRec, page_seg_map, pageIdx) {
  74. if (dispValueIdxLst_Content !== null) {
  75. page_seg_map.push([pageIdx,segIdx]);
  76. let arrContents = [];
  77. if (sortedContentSequence !== null) {
  78. let arrAllContent = sortedContentSequence[segIdx];
  79. for (let i = 0; i < maxRowRec; i++) {
  80. arrContents.push([]);
  81. for (let j = 0; j < maxColRec; j++) {
  82. if (arrAllContent.length <= counterRowRec + i || arrAllContent[counterRowRec + i].length <= counterColRec + j) {
  83. arrContents[i][j] = JV.BLANK_VALUE_INDEX;
  84. } else {
  85. arrContents[i][j] = arrAllContent[counterRowRec + i][counterColRec + j];
  86. }
  87. }
  88. }
  89. dispValueIdxLst_Content.push(arrContents);
  90. } else {
  91. //should push blank value index rather than null
  92. for (let i = 0; i < maxRowRec; i++) {
  93. arrContents.push([]);
  94. for (let j = 0; j < maxColRec; j++) {
  95. arrContents[i][j] = JV.BLANK_VALUE_INDEX;
  96. }
  97. }
  98. dispValueIdxLst_Content.push(arrContents);
  99. }
  100. }
  101. }
  102. function private_SortAndOptimize(rptTpl, dataObj, dataSeq, sortTab, rstFieldsIdx, $CURRENT_RPT) {
  103. let result = [];
  104. let tab = rptTpl[JV.NODE_CROSS_INFO][sortTab];
  105. if (tab) {
  106. let sIDX = 0;
  107. //1. prepare and sort by tab-field
  108. let fields = [];
  109. JpcFieldHelper.findAndPutDataFieldIdx(rptTpl, tab[JV.PROP_CROSS_FIELDS], fields, rstFieldsIdx);
  110. let data_details = dataObj[JV.DATA_DETAIL_DATA];
  111. JpcCrossTabHelper.sortTabFields(fields, rstFieldsIdx, data_details, dataSeq, $CURRENT_RPT);
  112. //2. distinguish sort tab fields value
  113. let b1 = false;
  114. for (let i = 0; i < dataSeq.length; i++) {
  115. sIDX = 0;
  116. let segArr = [];
  117. if (dataSeq[i].length === 1) {
  118. JpcCrossTabHelper.pushToSeg(segArr, dataSeq, i, 0, 1);
  119. } else {
  120. for (let j = 1; j < dataSeq[i].length; j++) {
  121. b1 = false;
  122. for (let k = 0; k < rstFieldsIdx.length; k++) {
  123. if (typeof(rstFieldsIdx[k]) === 'object') {
  124. let map_data_field = JE.F(rstFieldsIdx[k][JV.PROP_ID], $CURRENT_RPT);
  125. if (map_data_field[JV.PROP_AD_HOC_DATA][dataSeq[i][j - 1]] !== map_data_field[JV.PROP_AD_HOC_DATA][dataSeq[i][j]]) {
  126. b1 = true;
  127. break;
  128. }
  129. } else {
  130. if (data_details[rstFieldsIdx[k]][dataSeq[i][j - 1]] !== data_details[rstFieldsIdx[k]][dataSeq[i][j]]) {
  131. b1 = true;
  132. break;
  133. }
  134. }
  135. }
  136. if (b1) {
  137. JpcCrossTabHelper.pushToSeg(segArr, dataSeq, i, sIDX, j);
  138. sIDX = j;
  139. if (j === dataSeq[i].length - 1) {
  140. JpcCrossTabHelper.pushToSeg(segArr, dataSeq, i, j, dataSeq[i].length);
  141. }
  142. } else if (j === dataSeq[i].length - 1) {
  143. JpcCrossTabHelper.pushToSeg(segArr, dataSeq, i, sIDX, dataSeq[i].length);
  144. }
  145. }
  146. }
  147. if (segArr.length > 0) result.push(segArr);
  148. }
  149. }
  150. return result;
  151. }
  152. function private_SortForDisplayContent(rptTpl, rowSeq, colSeq, rstFieldsIdx){
  153. let result = [];
  154. let tab = rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_CONTENT];
  155. if (tab) {
  156. JpcFieldHelper.findAndPutDataFieldIdx(rptTpl, tab[JV.PROP_CROSS_FIELDS], null, rstFieldsIdx);
  157. }
  158. for (let i = 0; i < rowSeq.length; i++) {
  159. let rl = rowSeq[i], cl = colSeq[i];
  160. let ds = [];
  161. //1. initialize to blank value index
  162. for (let j = 0; j < rl.length; j++) {
  163. ds.push([]);
  164. for (let k = 0; k < cl.length; k++) {
  165. ds[j].push(JV.BLANK_VALUE_INDEX);
  166. }
  167. }
  168. //2. then fill up the right index
  169. for (let j = 0; j < rl.length; j++) {
  170. let ra = rl[j];
  171. for (let k = 0; k < ra.length; k++) {
  172. let colIdx = JpcCrossTabHelper.getColIDX(cl, ra[k]);
  173. if (colIdx >= 0) {
  174. ds[j][colIdx] = ra[k];
  175. }
  176. }
  177. }
  178. result.push(ds);
  179. }
  180. return result;
  181. }
  182. let JpcCrossTabResult = {};
  183. JpcCrossTabResult.initialize = function() {
  184. let me = this;
  185. me.dispValueIdxLst_Row = [];
  186. me.dispValueIdxLst_Col = [];
  187. me.dispValueIdxLst_Content = [];
  188. me.dispSerialIdxLst_Row = [];
  189. me.col_sum_fields_idx = [];
  190. me.col_sum_fields_value_total = [];
  191. me.dispSumValueLst_Col = [];
  192. me.page_seg_map = [];
  193. me.row_fields_idx = [];
  194. me.row_fields_adhoc_idx = [];
  195. me.col_fields_idx = [];
  196. me.content_fields_idx = [];
  197. me.row_extension_fields_idx = [];
  198. me.row_sum_extension_fields_idx = [];
  199. me.crsOrient = JV.PAGE_ORIENTATION_V_FIRST;
  200. me.pageStatusLst = [];
  201. me.paging_option = JV.PAGING_OPTION_NORMAL;
  202. };
  203. JpcCrossTabResult.sorting = function(rptTpl, dataObj, dataSeq, $CURRENT_RPT) {
  204. let me = this;
  205. //IMPORTANT: the data should be sorted in SQL/NoSQL level!
  206. me.sortedRowSequence = private_SortAndOptimize(rptTpl, dataObj, dataSeq, JV.NODE_CROSS_ROW, me.row_fields_idx, $CURRENT_RPT);
  207. private_SortAndOptimize(rptTpl, dataObj, dataSeq, JV.NODE_CROSS_ROW_AD_HOC, me.row_fields_adhoc_idx, $CURRENT_RPT);
  208. me.sortedColSequence = private_SortAndOptimize(rptTpl, dataObj, dataSeq, JV.NODE_CROSS_COL, me.col_fields_idx, $CURRENT_RPT);
  209. me.sortedContentSequence = private_SortForDisplayContent(rptTpl, me.sortedRowSequence, me.sortedColSequence, me.content_fields_idx);
  210. JpcFieldHelper.findAndPutDataFieldIdx(rptTpl, rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_COL_SUM][JV.PROP_CROSS_FIELDS], null, me.col_sum_fields_idx);
  211. //pre-sum the data(for col sum display)
  212. let data_details = dataObj[JV.DATA_DETAIL_DATA],
  213. data_fields = [];
  214. for (let i = 0; i < me.col_sum_fields_idx.length; i++) {
  215. let data_field = null;
  216. if (typeof me.col_sum_fields_idx[i] === 'object') {
  217. let exField = JE.F(me.col_sum_fields_idx[i][JV.PROP_ID], $CURRENT_RPT);
  218. if (exField) {
  219. data_field = exField[JV.PROP_AD_HOC_DATA];
  220. }
  221. } else {
  222. data_field = data_details[me.col_sum_fields_idx[i]];
  223. }
  224. data_fields.push(data_field);
  225. }
  226. for (let i = 0; i < me.sortedRowSequence.length; i++) { //seg level
  227. if (me.sortedRowSequence[i].length > 0) {
  228. me.col_sum_fields_value_total.push([]);
  229. for (let j = 0; j < me.sortedRowSequence[i].length; j++) {
  230. let rowGrandTotal = [];
  231. for (let di = 0; di < data_fields.length; di++) {
  232. rowGrandTotal.push(0.0);
  233. for (let k = 0; k < me.sortedRowSequence[i][j].length; k++) {
  234. //3. start to sum
  235. rowGrandTotal[di] = rowGrandTotal[di] + 1.0 * JpcFieldHelper.getValue(data_fields[di], me.sortedRowSequence[i][j][k]);
  236. }
  237. }
  238. me.col_sum_fields_value_total[i].push(rowGrandTotal);
  239. }
  240. }
  241. }
  242. };
  243. JpcCrossTabResult.preSetupPages = function(rptTpl, defProperties, option) {
  244. let me = this, rst = 0;
  245. me.paging_option = option||JV.PAGING_OPTION_NORMAL;
  246. //1. original initialize
  247. let maxRowRec = 1, maxColRec = 1, counterRowRec = 0, counterColRec = 0, pageIdx = 0, segCnt = me.sortedContentSequence.length;
  248. let pageStatus = [true, true, false, true, false, false, false, false];
  249. //2. calculate the page info one by one
  250. let bands = JpcBand.createNew(rptTpl, defProperties);
  251. function private_resetBandArea() {
  252. JpcBandHelper.setBandArea(bands, rptTpl, pageStatus);
  253. maxRowRec = JpcCrossTabHelper.getMaxRowsPerPage(bands, rptTpl);
  254. maxColRec = JpcCrossTabHelper.getMaxColsPerPage(bands, rptTpl);
  255. }
  256. JpcFieldHelper.findAndPutDataFieldIdx(rptTpl, rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW_EXT][JV.PROP_CROSS_FIELDS], null, me.row_extension_fields_idx);
  257. JpcFieldHelper.findAndPutDataFieldIdx(rptTpl, rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW_SUM_EXT][JV.PROP_CROSS_FIELDS], null, me.row_sum_extension_fields_idx);
  258. if (me.paging_option === JV.PAGING_OPTION_INFINITY) {
  259. /*
  260. rst = segCnt;
  261. pageStatus[JV.STATUS_SEGMENT_START] = true;
  262. pageStatus[JV.STATUS_SEGMENT_END] = true;
  263. pageStatus[JV.STATUS_CROSS_ROW_END] = true;
  264. pageStatus[JV.STATUS_CROSS_COL_END] = true;
  265. for (let segIdx = 0; segIdx < segCnt; segIdx++) {
  266. if (segIdx === segCnt - 1) {
  267. pageStatus[JV.STATUS_REPORT_END] = true;
  268. }
  269. if (segIdx > 0) {
  270. pageStatus[JV.STATUS_REPORT_START] = false;
  271. }
  272. me.pageStatusLst.push(pageStatus.slice(0));
  273. pageIdx++;
  274. private_addTabValue(me.dispValueIdxLst_Row, me.sortedRowSequence, segIdx, 0, me.sortedRowSequence[segIdx].length, me.dispSerialIdxLst_Row, me.col_sum_fields_value_total, me.dispSumValueLst_Col);
  275. private_addTabValue(me.dispValueIdxLst_Col, me.sortedColSequence, segIdx, 0, me.sortedColSequence[segIdx].length, null, null, null);
  276. private_addContentValue(me.dispValueIdxLst_Content, me.sortedContentSequence, segIdx, 0, me.sortedRowSequence[segIdx].length, 0, me.sortedColSequence[segIdx].length, me.page_seg_map, pageIdx);
  277. }
  278. //*/
  279. } else {
  280. for (let segIdx = 0; segIdx < segCnt; segIdx++) {
  281. //2.1. seg level initialize
  282. private_resetBandArea();
  283. let orgMaxRowRec = maxRowRec, orgMaxColRec = maxColRec;
  284. let rowSplitCnt = Math.ceil(1.0 * me.sortedRowSequence[segIdx].length / maxRowRec);
  285. let colSplitCnt = Math.ceil(1.0 * me.sortedColSequence[segIdx].length / maxColRec);
  286. pageStatus[JV.STATUS_CROSS_ROW_END] = true;
  287. private_resetBandArea();
  288. let hasAdHocRow = !JpcCrossTabHelper.chkTabEnd(JV.NODE_CROSS_ROW_SUM, rptTpl, bands, me.sortedRowSequence, segIdx, (rowSplitCnt - 1) * orgMaxRowRec, maxRowRec);
  289. if (hasAdHocRow) {
  290. hasAdHocRow = !JpcCrossTabHelper.chkTabEnd(JV.NODE_CROSS_ROW_EXT, rptTpl, bands, me.sortedRowSequence, segIdx, (rowSplitCnt - 1) * orgMaxRowRec, maxRowRec);
  291. }
  292. pageStatus[JV.STATUS_CROSS_ROW_END] = false;
  293. pageStatus[JV.STATUS_CROSS_COL_END] = true;
  294. private_resetBandArea();
  295. let hasAdHocCol = !JpcCrossTabHelper.chkTabEnd(JV.NODE_CROSS_COL_SUM, rptTpl, bands, me.sortedColSequence, segIdx, (colSplitCnt - 1) * orgMaxColRec, maxColRec);
  296. pageStatus[JV.STATUS_CROSS_COL_END] = false;
  297. private_resetBandArea();
  298. if (hasAdHocRow) rowSplitCnt++;
  299. if (hasAdHocCol) colSplitCnt++;
  300. //2.2
  301. for (let colIdx = 0; colIdx < colSplitCnt; colIdx++) {
  302. pageStatus[JV.STATUS_CROSS_COL_END] = (colIdx === (colSplitCnt - 1));
  303. private_resetBandArea();
  304. counterColRec = orgMaxColRec * colIdx;
  305. let currentSortedContentSequence = me.sortedContentSequence;
  306. let currentSortedColSequence = me.sortedColSequence;
  307. if (hasAdHocCol && colIdx === (colSplitCnt - 1)) {
  308. currentSortedColSequence = null;
  309. currentSortedContentSequence = null;
  310. counterColRec = 0;
  311. }
  312. for (let rowIdx = 0; rowIdx < rowSplitCnt; rowIdx++) {
  313. pageStatus[JV.STATUS_CROSS_ROW_END] = (rowIdx === (rowSplitCnt - 1));
  314. private_resetBandArea();
  315. me.pageStatusLst.push(pageStatus.slice(0));
  316. pageIdx++;
  317. counterRowRec = orgMaxRowRec * rowIdx;
  318. let currentSortedRowSequence = me.sortedRowSequence;
  319. if (hasAdHocRow && rowIdx === (rowSplitCnt - 1)) {
  320. currentSortedRowSequence = null;
  321. currentSortedContentSequence = null;
  322. counterRowRec = 0;
  323. }
  324. private_addTabValue(me.dispValueIdxLst_Row, currentSortedRowSequence, segIdx, counterRowRec, maxRowRec, me.dispSerialIdxLst_Row, me.col_sum_fields_value_total, me.dispSumValueLst_Col);
  325. private_addTabValue(me.dispValueIdxLst_Col, currentSortedColSequence, segIdx, counterColRec, maxColRec, null, null, null);
  326. private_addContentValue(me.dispValueIdxLst_Content, currentSortedContentSequence, segIdx, counterRowRec, maxRowRec, counterColRec, maxColRec, me.page_seg_map, pageIdx);
  327. }
  328. }
  329. JpcCrossTabHelper.initialPageStatus(pageStatus);
  330. }
  331. //3. set pageSeq and return the result
  332. rst = pageIdx;
  333. }
  334. bands = null;
  335. return rst;
  336. };
  337. JpcCrossTabResult.outputAsPreviewPage = function (rptTpl, bands, controls, $CURRENT_RPT, customizeCfg) {
  338. let me = this, rst = [];
  339. let pageStatus = [true, true, true, true, true, true, true, true];
  340. me.pageStatusLst.push(pageStatus);
  341. // JpcFieldHelper.findAndPutDataFieldIdx(rptTpl, rptTpl[JV.NODE_FLOW_INFO][JV.NODE_FLOW_CONTENT][JV.PROP_FLOW_FIELDS], null, me.disp_fields_idx, false);
  342. JpcBandHelper.setBandArea(bands, rptTpl, pageStatus, true, false);
  343. let maxRowRec = JpcCrossTabHelper.getMaxRowsPerPage(bands, rptTpl);
  344. let maxColRec = JpcCrossTabHelper.getMaxColsPerPage(bands, rptTpl);
  345. let unitFactor = JpcCommonHelper.getUnitFactor(rptTpl);
  346. //1. 交叉行
  347. rst = rst.concat(me.outputPreviewRowTab(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxRowRec, unitFactor));
  348. //2. 交叉列
  349. rst = rst.concat(me.outputPreviewColTab(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxColRec, unitFactor));
  350. //3. 交叉数据
  351. rst = rst.concat(me.outputPreviewContent(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxRowRec, maxColRec, unitFactor));
  352. //4. 交叉行拓展
  353. rst = rst.concat(me.outputPreviewTabExt(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxColRec, unitFactor));
  354. //5. 交叉行拓展合计
  355. rst = rst.concat(me.outputPreviewSumTabExt(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, unitFactor));
  356. //6. 交叉列合计
  357. rst = rst.concat(me.outputPreviewTabSum(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxRowRec, JV.NODE_CROSS_COL_SUM, unitFactor));
  358. //7. 离散
  359. rst = rst.concat(JpcDiscreteHelper.outputPreviewDiscreteInfo(rptTpl[JV.NODE_CROSS_INFO][JV.NODE_DISCRETE_INFO], bands, unitFactor, pageStatus));
  360. return rst;
  361. };
  362. JpcCrossTabResult.outputPreviewRowTab = function(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxRowRec, unitFactor) {
  363. let rst = this.private_OutputPreviewCommon(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxRowRec, 1, rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW], unitFactor);
  364. rst = rst.concat(this.private_OutputPreviewCommon(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxRowRec, 1, rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW_AD_HOC], unitFactor));
  365. return rst;
  366. };
  367. JpcCrossTabResult.outputPreviewColTab = function(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxColRec, unitFactor) {
  368. return this.private_OutputPreviewCommon(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, 1, maxColRec, rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_COL], unitFactor);
  369. };
  370. JpcCrossTabResult.outputPreviewContent = function(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxRowRec, maxColRec, unitFactor) {
  371. return this.private_OutputPreviewCommon(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxRowRec, maxColRec, rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_CONTENT], unitFactor);
  372. };
  373. JpcCrossTabResult.outputPreviewTabSum = function(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxRowRec, tabNodeName, unitFactor) {
  374. return this.private_OutputPreviewCommon(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxRowRec, 1, rptTpl[JV.NODE_CROSS_INFO][tabNodeName], unitFactor);
  375. };
  376. JpcCrossTabResult.outputPreviewTabExt = function(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxColRec, unitFactor) {
  377. //交叉行拓展
  378. return this.private_OutputPreviewCommon(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, 1, maxColRec, rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW_EXT], unitFactor);
  379. };
  380. JpcCrossTabResult.outputPreviewSumTabExt = function(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, unitFactor) {
  381. //交叉行拓展合计
  382. return this.private_OutputPreviewCommon(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, 1, 1, rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW_SUM_EXT], unitFactor);
  383. };
  384. JpcCrossTabResult.private_OutputPreviewCommon = function(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxRowRec, maxColRec, tab, unitFactor) {
  385. let me = this, rst = [];
  386. let band = (tab)?bands[tab[JV.PROP_BAND_NAME]]:null;
  387. if (band) {
  388. let tab_fields = tab[JV.PROP_CROSS_FIELDS];
  389. for (let rowIdx = 0; rowIdx < maxRowRec; rowIdx++) {
  390. for (let i = 0; i < tab_fields.length; i++) {
  391. let tab_field = tab_fields[i];
  392. if (!(tab_field[JV.PROP_HIDDEN])) {
  393. for (let colIdx = 0; colIdx < maxColRec; colIdx++) {
  394. if (tab_field[JV.PROP_IS_SERIAL]) {
  395. rst.push(me.outputTabField(band, tab_field, [rowIdx + 1], 0, -1, maxRowRec, rowIdx, maxColRec, colIdx, unitFactor, false, controls));
  396. } else {
  397. rst.push(me.outputTabField(band, tab_field, null, -1, -1, maxRowRec, rowIdx, maxColRec, colIdx, unitFactor, false, controls));
  398. }
  399. }
  400. }
  401. }
  402. if (tab[JV.PROP_TEXTS]) {
  403. for (let j = 0; j < tab[JV.PROP_TEXTS].length; j++) {
  404. for (let colIdx = 0; colIdx < maxColRec; colIdx++) {
  405. rst.push(JpcTextHelper.outputText(tab[JV.PROP_TEXTS][j], band, unitFactor, maxRowRec, rowIdx, maxColRec, colIdx, 1, 0));
  406. }
  407. }
  408. }
  409. }
  410. }
  411. return rst;
  412. };
  413. JpcCrossTabResult.outputAsSimpleJSONPage = function(rptTpl, dataObj, page, bands, controls, $CURRENT_RPT, customizeCfg) {
  414. let me = this, rst = [], tabRstLst = [];
  415. let unitFactor = JpcCommonHelper.getUnitFactor(rptTpl);
  416. if (me.paging_option === JV.PAGING_OPTION_INFINITY) {
  417. /*
  418. let segIdx = page - 1;
  419. //1 calculate the band position
  420. JpcBandHelper.setBandArea(bands, rptTpl, me.pageStatusLst[page - 1]);
  421. //2. then reset the band height
  422. let tab = rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_CONTENT];
  423. let crossContentBand = bands[tab[JV.PROP_BAND_NAME]];
  424. let actH = JpcCrossTabHelper.getActualRowsHeight(bands, rptTpl, me.sortedRowSequence, page);
  425. let actW = JpcCrossTabHelper.getActualColsWidth(bands, rptTpl, me.sortedColSequence, page);
  426. let offsetY = actH - (crossContentBand.Bottom - crossContentBand.Top);
  427. let offsetX = actW - (crossContentBand.Right - crossContentBand.Left);
  428. JpcBandHelper.resetBandPos(rptTpl[JV.NODE_BAND_COLLECTION], bands, crossContentBand, offsetX, offsetY);
  429. //2.1 Row-Tab
  430. tabRstLst.push(me.outputRowTab(rptTpl, dataObj, page, bands, unitFactor, controls));
  431. //2.2 Col-Tab
  432. tabRstLst.push(me.outputColTab(rptTpl, dataObj, page, bands, unitFactor, controls));
  433. //2.3 Content-Tab
  434. tabRstLst.push(me.outputContent(rptTpl, dataObj, page, bands, unitFactor, controls));
  435. //2.4 Sum-Tab Row
  436. //2.4 Sum-tab Col
  437. tabRstLst.push(me.outputTabSum(rptTpl, dataObj, page, bands, unitFactor, JV.NODE_CROSS_COL_SUM, controls));
  438. //2.x row tab ext
  439. tabRstLst.push(me.outputTabExt(rptTpl, dataObj, page, bands, unitFactor, controls));
  440. tabRstLst.push(me.outputSumTabExt(rptTpl, dataObj, page, bands, unitFactor, segIdx, controls));
  441. //2.5 Discrete
  442. tabRstLst.push(JpcDiscreteHelper.outputDiscreteInfo(rptTpl[JV.NODE_CROSS_INFO][JV.NODE_DISCRETE_INFO], bands, dataObj, unitFactor, me.pageStatusLst[page - 1], segIdx, 1, 0, $CURRENT_RPT, customizeCfg));
  443. //*/
  444. } else {
  445. let segIdx = JpcCommonHelper.getSegIdxByPageIdx(page, me.page_seg_map);
  446. //1 calculate the band position
  447. JpcBandHelper.setBandArea(bands, rptTpl, me.pageStatusLst[page - 1]);
  448. //2. start to output detail-part
  449. //2.1 Row-Tab
  450. //tabRstLst.push(me.outputRowTab(rptTpl, dataObj, page, bands, unitFactor, controls, $CURRENT_RPT, customizeCfg));
  451. tabRstLst.push(me.outputRowTabCommon(rptTpl, dataObj, page, bands, JV.NODE_CROSS_ROW, me.row_fields_idx, unitFactor, controls, $CURRENT_RPT, customizeCfg));
  452. tabRstLst.push(me.outputRowTabCommon(rptTpl, dataObj, page, bands, JV.NODE_CROSS_ROW_AD_HOC, me.row_fields_adhoc_idx, unitFactor, controls, $CURRENT_RPT, customizeCfg));
  453. //2.2 Col-Tab
  454. tabRstLst.push(me.outputColTab(rptTpl, dataObj, page, bands, unitFactor, controls, $CURRENT_RPT, customizeCfg));
  455. //2.3 Content-Tab
  456. tabRstLst.push(me.outputContent(rptTpl, dataObj, page, bands, unitFactor, controls, $CURRENT_RPT, customizeCfg));
  457. //2.4 Sum-Tab Row
  458. //2.4 Sum-tab Col
  459. tabRstLst.push(me.outputTabSum(rptTpl, dataObj, page, bands, unitFactor, JV.NODE_CROSS_COL_SUM, controls, $CURRENT_RPT, customizeCfg));
  460. //2.x row tab ext
  461. tabRstLst.push(me.outputTabExt(rptTpl, dataObj, page, bands, unitFactor, controls, $CURRENT_RPT, customizeCfg));
  462. tabRstLst.push(me.outputSumTabExt(rptTpl, dataObj, page, bands, unitFactor, segIdx, controls, $CURRENT_RPT, customizeCfg));
  463. //2.5 Discrete
  464. tabRstLst.push(JpcDiscreteHelper.outputDiscreteInfo(rptTpl[JV.NODE_CROSS_INFO][JV.NODE_DISCRETE_INFO], bands, dataObj, unitFactor, me.pageStatusLst[page - 1], segIdx, 1, 0, $CURRENT_RPT, customizeCfg));
  465. }
  466. for (let i = 0; i < tabRstLst.length; i++) {
  467. rst = rst.concat(tabRstLst[i]);
  468. tabRstLst[i] = null;
  469. }
  470. return rst;
  471. };
  472. JpcCrossTabResult.outputRowTabCommon = function(rptTpl, dataObj, page, bands, tabStr, rowFieldsIdxArr, unitFactor, controls, $CURRENT_RPT, customizeCfg) {
  473. let me = this, rst = [];
  474. let tab = rptTpl[JV.NODE_CROSS_INFO][tabStr];
  475. let band = (tab)?bands[tab[JV.PROP_BAND_NAME]]:null;
  476. if (band) {
  477. let pageStatus = me.pageStatusLst[page - 1];
  478. if (pageStatus[band[JV.BAND_PROP_DISPLAY_TYPE]] === true) {
  479. let tab_fields = tab[JV.PROP_CROSS_FIELDS];
  480. let data_details = dataObj[JV.DATA_DETAIL_DATA];
  481. let valuesIdx = me.dispValueIdxLst_Row[page - 1];
  482. let serialsIdx = me.dispSerialIdxLst_Row[page - 1];
  483. let flexiblePrecisionRefObj = null, flexibleRefField = null, precision_ref_data = null;
  484. for (let i = 0; i < rowFieldsIdxArr.length; i++) {
  485. let tab_field = tab_fields[i];
  486. if (!(tab_field[JV.PROP_HIDDEN])) {
  487. let data_field = null;
  488. let map_data_field = JE.F(tab_field[JV.PROP_FIELD_ID], $CURRENT_RPT);
  489. if (typeof rowFieldsIdxArr[i] !== 'object') {
  490. data_field = data_details[rowFieldsIdxArr[i]];
  491. } else {
  492. if (map_data_field) {
  493. data_field = map_data_field[JV.PROP_AD_HOC_DATA];
  494. }
  495. }
  496. let rows = valuesIdx.length;
  497. for (let rowIdx = 0; rowIdx < rows; rowIdx++) {
  498. if (map_data_field && map_data_field[JV.PROP_PRECISION] && map_data_field.flexiblePrecisionRefObj) {
  499. if (flexiblePrecisionRefObj === null) {
  500. flexiblePrecisionRefObj = {};
  501. flexibleRefField = JE.F(map_data_field[JV.PROP_PRECISION][JV.PROP_FLEXIBLE_REF_FILED_ID], $CURRENT_RPT);
  502. precision_ref_data = dataObj[map_data_field.DataNodeName][flexibleRefField.DataSeq];
  503. for (let decimalObj of map_data_field.flexiblePrecisionRefObj) {
  504. flexiblePrecisionRefObj["refUnit_" + decimalObj.unit] = decimalObj.decimal;
  505. }
  506. }
  507. JpcFieldHelper.resetFlexibleFormat(tab_field, precision_ref_data, flexiblePrecisionRefObj, valuesIdx[rowIdx], customizeCfg);
  508. } else {
  509. if (rowIdx === 0) JpcFieldHelper.resetFormat(tab_field, map_data_field, customizeCfg);
  510. }
  511. rst.push(me.outputTabField(band, tab_field, data_field, valuesIdx[rowIdx], serialsIdx[rowIdx], rows, rowIdx, 1, 0, unitFactor, true, controls));
  512. }
  513. }
  514. }
  515. }
  516. }
  517. return rst;
  518. };
  519. JpcCrossTabResult.outputColTab = function(rptTpl, dataObj, page, bands, unitFactor, controls, $CURRENT_RPT, customizeCfg) {
  520. let me = this, rst = [], firstTextOutput = true;
  521. let tab = rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_COL];
  522. let band = bands[tab[JV.PROP_BAND_NAME]];
  523. if (band) {
  524. let pageStatus = me.pageStatusLst[page - 1];
  525. if (pageStatus[band[JV.BAND_PROP_DISPLAY_TYPE]] === true) {
  526. let tab_fields = tab[JV.PROP_CROSS_FIELDS];
  527. let data_details = dataObj[JV.DATA_DETAIL_DATA];
  528. let valuesIdx = me.dispValueIdxLst_Col[page - 1];
  529. let flexiblePrecisionRefObj = null, flexibleRefField = null, precision_ref_data = null;
  530. for (let i = 0; i < me.col_fields_idx.length; i++) {
  531. let tab_field = tab_fields[i];
  532. if (!(tab_field[JV.PROP_HIDDEN])) {
  533. let data_field = null;
  534. let map_data_field = JE.F(tab_field[JV.PROP_FIELD_ID], $CURRENT_RPT);
  535. if (typeof me.col_fields_idx[i] !== 'object') {
  536. data_field = data_details[me.col_fields_idx[i]];
  537. } else {
  538. if (map_data_field) {
  539. data_field = map_data_field[JV.PROP_AD_HOC_DATA];
  540. }
  541. }
  542. let cols = valuesIdx.length;
  543. for (let colIdx = 0; colIdx < cols; colIdx++) {
  544. if (map_data_field && map_data_field[JV.PROP_PRECISION] && map_data_field.flexiblePrecisionRefObj) {
  545. if (flexiblePrecisionRefObj === null) {
  546. flexiblePrecisionRefObj = {};
  547. flexibleRefField = JE.F(map_data_field[JV.PROP_PRECISION][JV.PROP_FLEXIBLE_REF_FILED_ID], $CURRENT_RPT);
  548. precision_ref_data = dataObj[map_data_field.DataNodeName][flexibleRefField.DataSeq];
  549. for (let decimalObj of map_data_field.flexiblePrecisionRefObj) {
  550. flexiblePrecisionRefObj["refUnit_" + decimalObj.unit] = decimalObj.decimal;
  551. }
  552. }
  553. JpcFieldHelper.resetFlexibleFormat(tab_field, precision_ref_data, flexiblePrecisionRefObj, valuesIdx[colIdx], customizeCfg);
  554. } else {
  555. if (colIdx === 0) JpcFieldHelper.resetFormat(tab_field, map_data_field, customizeCfg);
  556. }
  557. rst.push(me.outputTabField(band, tab_field, data_field, valuesIdx[colIdx], -1, 1, 0, cols, colIdx, unitFactor, false, controls));
  558. //2. output texts
  559. if (firstTextOutput) {
  560. if (tab[JV.PROP_TEXT]) {
  561. rst.push(JpcTextHelper.outputText(tab[JV.PROP_TEXT], band, unitFactor, 1, 0, cols, colIdx, 1, 0));
  562. }
  563. if (tab[JV.PROP_TEXTS]) {
  564. for (let j = 0; j < tab[JV.PROP_TEXTS].length; j++) {
  565. rst.push(JpcTextHelper.outputText(tab[JV.PROP_TEXTS][j], band, unitFactor, 1, 0, cols, colIdx, 1, 0));
  566. }
  567. }
  568. }
  569. }
  570. firstTextOutput = false;
  571. }
  572. }
  573. }
  574. }
  575. return rst;
  576. };
  577. JpcCrossTabResult.outputContent = function (rptTpl, dataObj, page, bands, unitFactor, controls, $CURRENT_RPT, customizeCfg) {
  578. let me = this, rst = [];
  579. let tab = rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_CONTENT];
  580. let band = bands[tab[JV.PROP_BAND_NAME]];
  581. if (band) {
  582. let pageStatus = me.pageStatusLst[page - 1];
  583. if (pageStatus[band[JV.BAND_PROP_DISPLAY_TYPE]] === true) {
  584. let tab_fields = tab[JV.PROP_CROSS_FIELDS];
  585. let data_details = dataObj[JV.DATA_DETAIL_DATA];
  586. let contentValuesIdx = me.dispValueIdxLst_Content[page - 1];
  587. let flexiblePrecisionRefObj = null, flexibleRefField = null, precision_ref_data = null;
  588. for (let i = 0; i < tab_fields.length; i++) {
  589. let tab_field = tab_fields[i];
  590. let data_field = null;
  591. let map_data_field = JE.F(tab_field[JV.PROP_FIELD_ID], $CURRENT_RPT);
  592. if (typeof me.content_fields_idx[i] !== 'object') {
  593. data_field = data_details[me.content_fields_idx[i]];
  594. } else {
  595. if (map_data_field) {
  596. data_field = map_data_field[JV.PROP_AD_HOC_DATA];
  597. }
  598. }
  599. if (!(tab_field[JV.PROP_HIDDEN])) {
  600. let rows = contentValuesIdx.length;
  601. for (let rowIdx = 0; rowIdx < rows; rowIdx++) {
  602. let cols = contentValuesIdx[rowIdx].length;
  603. for (let colIdx = 0; colIdx < cols; colIdx++) {
  604. if (map_data_field && map_data_field[JV.PROP_PRECISION] && map_data_field.flexiblePrecisionRefObj) {
  605. if (flexiblePrecisionRefObj === null) {
  606. flexiblePrecisionRefObj = {};
  607. flexibleRefField = JE.F(map_data_field[JV.PROP_PRECISION][JV.PROP_FLEXIBLE_REF_FILED_ID], $CURRENT_RPT);
  608. precision_ref_data = dataObj[map_data_field.DataNodeName][flexibleRefField.DataSeq];
  609. for (let decimalObj of map_data_field.flexiblePrecisionRefObj) {
  610. flexiblePrecisionRefObj["refUnit_" + decimalObj.unit] = decimalObj.decimal;
  611. }
  612. }
  613. JpcFieldHelper.resetFlexibleFormat(tab_field, precision_ref_data, flexiblePrecisionRefObj, contentValuesIdx[rowIdx][colIdx], customizeCfg);
  614. } else {
  615. if (colIdx === 0) JpcFieldHelper.resetFormat(tab_field, map_data_field, customizeCfg);
  616. }
  617. rst.push(me.outputTabField(band, tab_field, data_field, contentValuesIdx[rowIdx][colIdx], -1, rows, rowIdx, cols, colIdx, unitFactor, true, controls));
  618. }
  619. }
  620. }
  621. }
  622. }
  623. }
  624. return rst;
  625. };
  626. JpcCrossTabResult.outputTabSum = function (rptTpl, dataObj, page, bands, unitFactor, tabNodeName, controls, $CURRENT_RPT, customizeCfg) {
  627. let me = this, rst = [],
  628. tab = rptTpl[JV.NODE_CROSS_INFO][tabNodeName],
  629. band = bands[tab[JV.PROP_BAND_NAME]];
  630. if (band) {
  631. let pageStatus = me.pageStatusLst[page - 1];
  632. if (pageStatus[band[JV.BAND_PROP_DISPLAY_TYPE]] === true) {
  633. let tab_fields = tab[JV.PROP_CROSS_FIELDS];
  634. for (let i = 0; i < me.dispSumValueLst_Col[page - 1].length; i++) {
  635. if (i === 0) {
  636. for (let tfIdx = 0; tfIdx < tab_fields.length; tfIdx++) {
  637. let map_data_field = JE.F(tab_fields[tfIdx][JV.PROP_FIELD_ID], $CURRENT_RPT);
  638. JpcFieldHelper.resetFormat(tab_fields[tfIdx], map_data_field, customizeCfg);
  639. }
  640. }
  641. if (me.dispSumValueLst_Col[page - 1][i] !== null) {
  642. for (let j = 0; j < me.dispSumValueLst_Col[page - 1][i].length; j++) {
  643. let tab_field = tab_fields[j];
  644. let val = me.dispSumValueLst_Col[page - 1][i][j];
  645. let cellItem = JpcCommonOutputHelper.createCommonOutput(tab_field, val, controls);
  646. cellItem[JV.PROP_AREA] = JpcAreaHelper.outputArea(tab_field[JV.PROP_AREA], band, unitFactor, me.dispSumValueLst_Col[page - 1].length, i, 1, 0, 1, 0, true, false);
  647. rst.push(cellItem);
  648. }
  649. } else {
  650. let sumL = 1;
  651. for (let si = 0; si < me.dispSumValueLst_Col.length; si++) {
  652. if (me.dispSumValueLst_Col[si][0] !== null) {
  653. sumL = me.dispSumValueLst_Col[si][0].length;
  654. break;
  655. }
  656. }
  657. for (let j = 0; j < sumL; j++) {
  658. let tab_field = tab_fields[j];
  659. let val = null;
  660. let cellItem = JpcCommonOutputHelper.createCommonOutput(tab_field, val, controls);
  661. cellItem[JV.PROP_AREA] = JpcAreaHelper.outputArea(tab_field[JV.PROP_AREA], band, unitFactor, me.dispSumValueLst_Col[page - 1].length, i, 1, 0, 1, 0, true, false);
  662. rst.push(cellItem);
  663. }
  664. }
  665. }
  666. }
  667. }
  668. return rst;
  669. };
  670. JpcCrossTabResult.outputTabExt = function (rptTpl, dataObj, page, bands, unitFactor, controls, $CURRENT_RPT, customizeCfg) {
  671. let me = this, rst = [], firstTextOutput = true,
  672. tab = rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW_EXT];
  673. let band = bands[tab[JV.PROP_BAND_NAME]];
  674. if (band) {
  675. let pageStatus = me.pageStatusLst[page - 1];
  676. if (pageStatus[band[JV.BAND_PROP_DISPLAY_TYPE]] === true) {
  677. let tab_fields = tab[JV.PROP_CROSS_FIELDS],
  678. data_details = dataObj[JV.DATA_DETAIL_DATA],
  679. valuesIdx = me.dispValueIdxLst_Col[page - 1];
  680. for (let i = 0; i < me.row_extension_fields_idx.length; i++) {
  681. let tab_field = tab_fields[i];
  682. let data_field = null;
  683. let map_data_field = JE.F(tab_field[JV.PROP_FIELD_ID], $CURRENT_RPT);
  684. if (typeof me.row_extension_fields_idx[i] !== 'object') {
  685. data_field = data_details[me.row_extension_fields_idx[i]];
  686. } else {
  687. if (map_data_field) {
  688. data_field = map_data_field[JV.PROP_AD_HOC_DATA];
  689. }
  690. }
  691. if (!(tab_field[JV.PROP_HIDDEN])) {
  692. let cols = valuesIdx.length;
  693. for (let colIdx = 0; colIdx < cols; colIdx++) {
  694. if (colIdx === 0) JpcFieldHelper.resetFormat(tab_field, map_data_field, customizeCfg);
  695. rst.push(me.outputTabField(band, tab_field, data_field, valuesIdx[colIdx], -1, 1, 0, cols, colIdx, unitFactor, false, controls));
  696. //2. output texts if has
  697. if (firstTextOutput) {
  698. if (tab[JV.PROP_TEXT]) {
  699. rst.push(JpcTextHelper.outputText(tab[JV.PROP_TEXT], band, unitFactor, 1, 0, cols, colIdx, 1, 0));
  700. }
  701. if (tab[JV.PROP_TEXTS]) {
  702. for (let j = 0; j < tab[JV.PROP_TEXTS].length; j++) {
  703. rst.push(JpcTextHelper.outputText(tab[JV.PROP_TEXTS][j], band, unitFactor, 1, 0, cols, colIdx, 1, 0));
  704. }
  705. }
  706. }
  707. }
  708. firstTextOutput = false;
  709. }
  710. }
  711. }
  712. }
  713. return rst;
  714. };
  715. JpcCrossTabResult.outputSumTabExt = function (rptTpl, dataObj, page, bands, unitFactor, segIdx, controls, $CURRENT_RPT, customizeCfg) {
  716. let me = this, rst = [],
  717. tab = rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW_SUM_EXT];
  718. let band = bands[tab[JV.PROP_BAND_NAME]];
  719. if (band) {
  720. let pageStatus = me.pageStatusLst[page - 1];
  721. if (pageStatus[band[JV.BAND_PROP_DISPLAY_TYPE]] === true && pageStatus[JV.STATUS_CROSS_ROW_END] === true) {
  722. let tab_fields = tab[JV.PROP_CROSS_FIELDS],
  723. data_details = dataObj[JV.DATA_DETAIL_DATA],
  724. data_fields = [];
  725. for (let i = 0; i < me.row_sum_extension_fields_idx.length; i++) {
  726. // let data_field = data_details[me.row_sum_extension_fields_idx[i]];
  727. let tab_field = tab_fields[i];
  728. let data_field = null;
  729. let map_data_field = JE.F(tab_field[JV.PROP_FIELD_ID], $CURRENT_RPT);
  730. if (typeof me.row_sum_extension_fields_idx[i] !== 'object') {
  731. data_field = data_details[me.row_sum_extension_fields_idx[i]];
  732. } else {
  733. if (map_data_field) {
  734. data_field = map_data_field[JV.PROP_AD_HOC_DATA];
  735. }
  736. }
  737. JpcFieldHelper.resetFormat(tab_field, map_data_field, customizeCfg);
  738. data_fields.push(data_field);
  739. }
  740. //2. initialize grand total value
  741. let rowGrandTotal = [];
  742. for (let di = 0; di < data_fields.length; di++) {
  743. rowGrandTotal[di] = 0.0;
  744. //3. start to sum
  745. for (let i = 0; i < me.sortedColSequence[segIdx].length; i++) {
  746. //me.sortedColSequence[segIdx][i][0] //this is the data field value index!
  747. rowGrandTotal[di] = rowGrandTotal[di] + 1.0 * JpcFieldHelper.getValue(data_fields[di], me.sortedColSequence[segIdx][i][0]);
  748. }
  749. }
  750. //4. output
  751. for (let di = 0; di < tab_fields.length; di++) {
  752. let tab_field = tab_fields[di];
  753. if (!tab_field[JV.PROP_HIDDEN]) {
  754. let val = rowGrandTotal[di];
  755. let cellItem = JpcCommonOutputHelper.createCommonOutput(tab_field, val, controls);
  756. cellItem[JV.PROP_AREA] = JpcAreaHelper.outputArea(tab_field[JV.PROP_AREA], band, unitFactor, 1, 0, 1, 0, 1, 0, false, false);
  757. rst.push(cellItem);
  758. }
  759. }
  760. //output texts if has
  761. if (tab[JV.PROP_TEXT]) {
  762. rst.push(JpcTextHelper.outputText(tab[JV.PROP_TEXT], band, unitFactor, 1, 0, 1, 0, 1, 0));
  763. }
  764. if (tab[JV.PROP_TEXTS]) {
  765. for (let j = 0; j < tab[JV.PROP_TEXTS].length; j++) {
  766. rst.push(JpcTextHelper.outputText(tab[JV.PROP_TEXTS][j], band, unitFactor, 1, 0, 1, 0, 1, 0));
  767. }
  768. }
  769. }
  770. }
  771. return rst;
  772. };
  773. JpcCrossTabResult.outputTabField = function (band, tab_field, data_field, valueIdx, serialIdx, rows, rowIdx, cols, colIdx, unitFactor, isRow, controls) {
  774. let rst = null;
  775. if (isRow === true && tab_field[JV.PROP_IS_SERIAL] && tab_field[JV.PROP_IS_SERIAL] === true) {
  776. if (serialIdx >= 0) {
  777. rst = JpcCommonOutputHelper.createCommonOutput(tab_field, serialIdx + 1)
  778. } else rst = JpcCommonOutputHelper.createCommonOutput(tab_field, "", controls);
  779. } else {
  780. rst = JpcCommonOutputHelper.createCommonOutput(tab_field, JpcFieldHelper.getValue(data_field, valueIdx), controls);
  781. }
  782. //position
  783. if (isRow === true) {
  784. rst[JV.PROP_AREA] = JpcAreaHelper.outputArea(tab_field[JV.PROP_AREA], band, unitFactor, rows, rowIdx, cols, colIdx, 1, 0, true, false);
  785. } else {
  786. rst[JV.PROP_AREA] = JpcAreaHelper.outputArea(tab_field[JV.PROP_AREA], band, unitFactor, rows, rowIdx, cols, colIdx, 1, 0, false, false);
  787. }
  788. return rst;
  789. };
  790. return JpcCrossTabResult;
  791. };
  792. module.exports = new JpcCrossTabSrv();