jpc_cross_tab.js 64 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082
  1. 'use strict';
  2. const JV = require('./jpc_value_define');
  3. const JE = require('./jpc_rte');
  4. const JpcFieldHelper = require('./helper/jpc_helper_field');
  5. const JpcBandHelper = require('./helper/jpc_helper_band');
  6. const JpcBand = require('./jpc_band');
  7. const JpcCrossTabHelper = require('./helper/jpc_helper_cross_tab');
  8. const JpcCommonHelper = require('./helper/jpc_helper_common');
  9. const JpcDiscreteHelper = require('./helper/jpc_helper_discrete');
  10. const JpcTextHelper = require('./helper/jpc_helper_text');
  11. const JpcCommonOutputHelper = require('./helper/jpc_helper_common_output');
  12. const JpcAreaHelper = require('./helper/jpc_helper_area');
  13. const $FS_UTIL = require('../../public/js/fsUtil');
  14. const bc = require('../../lib/base_calc.js');
  15. const JpcCrossTabSrv = function() {};
  16. JpcCrossTabSrv.prototype.createNew = function() {
  17. function private_addTabValue(tabValuedIdxLst, sortedSequence, segIdx, preRec, nextRec, dispSerialIdxLst, sorted_sum_value_Lst, rst_sum_value_Lst) {
  18. if (tabValuedIdxLst) {
  19. let serial1stTier = null;
  20. if (dispSerialIdxLst) serial1stTier = [];
  21. const pgseg1stTier = [];
  22. const sumVal = [];
  23. let sumValL = 1;
  24. if (sortedSequence) {
  25. const arrDupVals = sortedSequence[segIdx];
  26. let arrDupSumVals = null;
  27. if (sorted_sum_value_Lst !== null) {
  28. arrDupSumVals = sorted_sum_value_Lst[segIdx];
  29. sumValL = arrDupSumVals[0].length;
  30. }
  31. for (let i = 0; i < nextRec; i++) {
  32. if (arrDupVals.length <= preRec + i) {
  33. pgseg1stTier[i] = JV.BLANK_VALUE_INDEX;
  34. sumVal[i] = [];
  35. for (let ei = 0; ei < sumValL; ei++) {
  36. sumVal[i][ei] = null;
  37. }
  38. if (serial1stTier !== null) {
  39. serial1stTier[i] = JV.BLANK_VALUE_INDEX;
  40. }
  41. continue;
  42. }
  43. const duplicateValueArr = arrDupVals[preRec + i];
  44. pgseg1stTier[i] = duplicateValueArr[0];
  45. if (arrDupSumVals !== null) sumVal[i] = arrDupSumVals[preRec + i];
  46. if (serial1stTier !== null) {
  47. serial1stTier[i] = preRec + i;
  48. }
  49. }
  50. tabValuedIdxLst.push(pgseg1stTier);
  51. if (dispSerialIdxLst !== null) {
  52. dispSerialIdxLst.push(serial1stTier);
  53. }
  54. if (sorted_sum_value_Lst !== null && rst_sum_value_Lst !== null) {
  55. rst_sum_value_Lst.push(sumVal);
  56. }
  57. } else {
  58. // should push blank value index rather than null
  59. for (let i = 0; i < nextRec; i++) {
  60. pgseg1stTier[i] = JV.BLANK_VALUE_INDEX;
  61. sumVal[i] = null;
  62. if (serial1stTier !== null) {
  63. serial1stTier[i] = JV.BLANK_VALUE_INDEX;
  64. }
  65. }
  66. tabValuedIdxLst.push(pgseg1stTier);
  67. if (dispSerialIdxLst !== null) {
  68. dispSerialIdxLst.push(serial1stTier);
  69. }
  70. if (sorted_sum_value_Lst !== null && rst_sum_value_Lst !== null) {
  71. rst_sum_value_Lst.push(sumVal);
  72. }
  73. }
  74. }
  75. }
  76. function private_addContentValue(dispValueIdxLst_Content, sortedContentSequence, segIdx, counterRowRec, maxRowRec, counterColRec, maxColRec, page_seg_map, pageIdx) {
  77. if (dispValueIdxLst_Content !== null) {
  78. page_seg_map.push([pageIdx, segIdx]);
  79. const arrContents = [];
  80. if (sortedContentSequence !== null) {
  81. const arrAllContent = sortedContentSequence[segIdx];
  82. for (let i = 0; i < maxRowRec; i++) {
  83. arrContents.push([]);
  84. for (let j = 0; j < maxColRec; j++) {
  85. if (arrAllContent.length <= counterRowRec + i || arrAllContent[counterRowRec + i].length <= counterColRec + j) {
  86. arrContents[i][j] = JV.BLANK_VALUE_INDEX;
  87. } else {
  88. arrContents[i][j] = arrAllContent[counterRowRec + i][counterColRec + j];
  89. }
  90. }
  91. }
  92. dispValueIdxLst_Content.push(arrContents);
  93. } else {
  94. // should push blank value index rather than null
  95. for (let i = 0; i < maxRowRec; i++) {
  96. arrContents.push([]);
  97. for (let j = 0; j < maxColRec; j++) {
  98. arrContents[i][j] = JV.BLANK_VALUE_INDEX;
  99. }
  100. }
  101. dispValueIdxLst_Content.push(arrContents);
  102. }
  103. }
  104. }
  105. function _addRowSumValue() {
  106. // 此方法是专门为交叉行(拓展)合计用
  107. }
  108. function private_SortAndOptimize(rptTpl, dataObj, dataSeq, sortTab, rstFieldsIdx, $CURRENT_RPT) {
  109. const result = [];
  110. const tab = rptTpl[JV.NODE_CROSS_INFO][sortTab];
  111. if (tab) {
  112. let sIDX = 0;
  113. // 1. prepare and sort by tab-field
  114. const fields = [];
  115. JpcFieldHelper.findAndPutDataFieldIdx(rptTpl, tab[JV.PROP_CROSS_FIELDS], fields, rstFieldsIdx);
  116. const data_details = dataObj[JV.DATA_DETAIL_DATA];
  117. JpcCrossTabHelper.sortTabFields(fields, rstFieldsIdx, data_details, dataSeq, $CURRENT_RPT);
  118. // 2. distinguish sort tab fields value
  119. let b1 = false;
  120. for (let i = 0; i < dataSeq.length; i++) {
  121. sIDX = 0;
  122. const segArr = [];
  123. if (dataSeq[i].length === 1) {
  124. JpcCrossTabHelper.pushToSeg(segArr, dataSeq, i, 0, 1);
  125. } else {
  126. for (let j = 1; j < dataSeq[i].length; j++) {
  127. b1 = false;
  128. for (let k = 0; k < rstFieldsIdx.length; k++) {
  129. if (fields[k].hasOwnProperty(JV.TAB_FIELD_PROP_SORT)) {
  130. // 只有被选择了作为排序字段的才进入排序及优化
  131. if (typeof rstFieldsIdx[k] === 'object') {
  132. const map_data_field = JE.F(rstFieldsIdx[k][JV.PROP_ID], $CURRENT_RPT);
  133. if (map_data_field[JV.PROP_AD_HOC_DATA][dataSeq[i][j - 1]] !== map_data_field[JV.PROP_AD_HOC_DATA][dataSeq[i][j]]) {
  134. b1 = true;
  135. break;
  136. }
  137. } else {
  138. if (data_details[rstFieldsIdx[k]][dataSeq[i][j - 1]] !== data_details[rstFieldsIdx[k]][dataSeq[i][j]]) {
  139. b1 = true;
  140. break;
  141. }
  142. }
  143. }
  144. }
  145. if (b1) {
  146. JpcCrossTabHelper.pushToSeg(segArr, dataSeq, i, sIDX, j);
  147. sIDX = j;
  148. if (j === dataSeq[i].length - 1) {
  149. JpcCrossTabHelper.pushToSeg(segArr, dataSeq, i, j, dataSeq[i].length);
  150. }
  151. } else if (j === dataSeq[i].length - 1) {
  152. JpcCrossTabHelper.pushToSeg(segArr, dataSeq, i, sIDX, dataSeq[i].length);
  153. }
  154. }
  155. }
  156. if (segArr.length > 0) result.push(segArr);
  157. }
  158. }
  159. return result;
  160. }
  161. function private_SortForDisplayContent(rptTpl, rowSeq, colSeq, rstFieldsIdx) {
  162. const result = [];
  163. const tab = rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_CONTENT];
  164. if (tab) {
  165. JpcFieldHelper.findAndPutDataFieldIdx(rptTpl, tab[JV.PROP_CROSS_FIELDS], null, rstFieldsIdx);
  166. }
  167. for (let i = 0; i < rowSeq.length; i++) {
  168. const rl = rowSeq[i];
  169. const cl = colSeq[i];
  170. const ds = [];
  171. // 1. initialize to blank value index
  172. for (let j = 0; j < rl.length; j++) {
  173. ds.push([]);
  174. for (let k = 0; k < cl.length; k++) {
  175. ds[j].push(JV.BLANK_VALUE_INDEX);
  176. }
  177. }
  178. // 2. then fill up the right index
  179. for (let j = 0; j < rl.length; j++) {
  180. const ra = rl[j];
  181. for (let k = 0; k < ra.length; k++) {
  182. const colIdx = JpcCrossTabHelper.getColIDX(cl, ra[k]);
  183. if (colIdx >= 0) {
  184. ds[j][colIdx] = ra[k];
  185. }
  186. }
  187. }
  188. result.push(ds);
  189. }
  190. return result;
  191. }
  192. const JpcCrossTabResult = {};
  193. JpcCrossTabResult.initialize = function() {
  194. const me = this;
  195. me.dispValueIdxLst_Row = [];
  196. me.dispValueIdxLst_Col = [];
  197. me.dispValueIdxLst_Content = [];
  198. me.dispSerialIdxLst_Row = [];
  199. me.col_sum_fields_idx = [];
  200. me.col_sum_fields_value_total = [];
  201. me.row_sum_fields_value_total = [];
  202. me.dispSumValueLst_Col = []; // 这个是横向合计(一列列累加)
  203. me.dispSumValueLst_Row = []; // 这个是纵向合计(一行行累加)
  204. me.page_seg_map = [];
  205. me.row_fields_idx = [];
  206. me.row_fields_adhoc_idx = [];
  207. me.col_fields_idx = [];
  208. me.content_fields_idx = [];
  209. me.row_extension_fields_idx = [];
  210. me.row_sum_extension_fields_idx = []; // 类似col_sum_fields_idx,放在‘交叉行拓展合计’中
  211. me.crsOrient = JV.PAGE_ORIENTATION_V_FIRST;
  212. me.pageStatusLst = [];
  213. me.paging_option = JV.PAGING_OPTION_NORMAL;
  214. me.signatureRst = [];
  215. me.signatureDateRst = [];
  216. me.signatureAuditRst = [];
  217. };
  218. JpcCrossTabResult.sorting = function(rptTpl, dataObj, dataSeq, $CURRENT_RPT) {
  219. const me = this;
  220. // IMPORTANT: the data should be sorted in SQL/NoSQL level!
  221. // $FS_UTIL.writeObjToFile(dataSeq, 'D:/GitHome/temp/JL_cross_dataSeq' + (new Date()).getTime() + '.js');
  222. me.sortedRowSequence = private_SortAndOptimize(rptTpl, dataObj, dataSeq, JV.NODE_CROSS_ROW, me.row_fields_idx, $CURRENT_RPT);
  223. private_SortAndOptimize(rptTpl, dataObj, dataSeq, JV.NODE_CROSS_ROW_AD_HOC, me.row_fields_adhoc_idx, $CURRENT_RPT);
  224. me.sortedColSequence = private_SortAndOptimize(rptTpl, dataObj, dataSeq, JV.NODE_CROSS_COL, me.col_fields_idx, $CURRENT_RPT);
  225. me.sortedContentSequence = private_SortForDisplayContent(rptTpl, me.sortedRowSequence, me.sortedColSequence, me.content_fields_idx);
  226. // $FS_UTIL.writeObjToFile(me.sortedRowSequence, 'D:/GitHome/temp/JL_cross_sortedRowSequence' + (new Date()).getTime() + '.js');
  227. // $FS_UTIL.writeObjToFile(me.sortedColSequence, 'D:/GitHome/temp/JL_cross_sortedColSequence' + (new Date()).getTime() + '.js');
  228. // $FS_UTIL.writeObjToFile(me.sortedContentSequence, 'D:/GitHome/temp/JL_cross_sortedContentSequence' + (new Date()).getTime() + '.js');
  229. JpcFieldHelper.findAndPutDataFieldIdx(rptTpl, rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_COL_SUM][JV.PROP_CROSS_FIELDS], null, me.col_sum_fields_idx);
  230. // pre-sum the data(for col sum display)
  231. const data_details = dataObj[JV.DATA_DETAIL_DATA];
  232. const data_fields = [];
  233. for (let i = 0; i < me.col_sum_fields_idx.length; i++) {
  234. let data_field = null;
  235. if (typeof me.col_sum_fields_idx[i] === 'object') {
  236. const exField = JE.F(me.col_sum_fields_idx[i][JV.PROP_ID], $CURRENT_RPT);
  237. if (exField) {
  238. data_field = exField[JV.PROP_AD_HOC_DATA];
  239. }
  240. } else {
  241. data_field = data_details[me.col_sum_fields_idx[i]];
  242. }
  243. data_fields.push(data_field);
  244. }
  245. for (let i = 0; i < me.sortedRowSequence.length; i++) { // seg level
  246. if (me.sortedRowSequence[i].length > 0) {
  247. me.col_sum_fields_value_total.push([]);
  248. for (let j = 0; j < me.sortedRowSequence[i].length; j++) {
  249. const rowGrandTotal = [];
  250. for (let di = 0; di < data_fields.length; di++) {
  251. rowGrandTotal.push(0.0);
  252. for (let k = 0; k < me.sortedRowSequence[i][j].length; k++) {
  253. // 3. start to sum
  254. let vTtl = parseFloat(JpcFieldHelper.getValue(data_fields[di], me.sortedRowSequence[i][j][k]));
  255. if (isNaN(vTtl)) {
  256. vTtl = 0;
  257. }
  258. //rowGrandTotal[di] = rowGrandTotal[di] + 1.0 * vTtl;
  259. rowGrandTotal[di] = bc.add(rowGrandTotal[di], vTtl);
  260. }
  261. }
  262. me.col_sum_fields_value_total[i].push(rowGrandTotal);
  263. }
  264. }
  265. }
  266. const row_data_fields = [];
  267. for (let i = 0; i < me.col_sum_fields_idx.length; i++) {
  268. let data_field = null;
  269. if (typeof me.col_sum_fields_idx[i] === 'object') {
  270. const exField = JE.F(me.col_sum_fields_idx[i][JV.PROP_ID], $CURRENT_RPT);
  271. if (exField) {
  272. data_field = exField[JV.PROP_AD_HOC_DATA];
  273. }
  274. } else {
  275. data_field = data_details[me.col_sum_fields_idx[i]];
  276. }
  277. row_data_fields.push(data_field);
  278. }
  279. for (let i = 0; i < me.sortedColSequence.length; i++) {
  280. if (me.sortedColSequence[i].length > 0) {
  281. me.row_sum_fields_value_total.push([]);
  282. for (let j = 0; j < me.sortedColSequence[i].length; j++) {
  283. const rowGrandTotal = [];
  284. for (let di = 0; di < row_data_fields.length; di++) {
  285. rowGrandTotal.push(0.0);
  286. for (let k = 0; k < me.sortedColSequence[i][j].length; k++) {
  287. // 3. start to sum
  288. let vTtl = parseFloat(JpcFieldHelper.getValue(row_data_fields[di], me.sortedColSequence[i][j][k]));
  289. if (isNaN(vTtl)) {
  290. vTtl = 0;
  291. }
  292. // rowGrandTotal[di] = rowGrandTotal[di] + 1.0 * vTtl;
  293. rowGrandTotal[di] = bc.add(rowGrandTotal[di], vTtl);
  294. }
  295. }
  296. me.row_sum_fields_value_total[i].push(rowGrandTotal);
  297. }
  298. }
  299. }
  300. // console.log('me.row_sum_fields_value_total');
  301. // console.log(me.row_sum_fields_value_total);
  302. };
  303. JpcCrossTabResult.preSetupPages = function(rptTpl, defProperties, option) {
  304. const me = this;
  305. let rst = 0;
  306. me.paging_option = option || JV.PAGING_OPTION_NORMAL;
  307. // 1. original initialize
  308. let maxRowRec = 1;
  309. let maxColRec = 1;
  310. let counterRowRec = 0;
  311. let counterColRec = 0;
  312. let pageIdx = 0;
  313. const segCnt = me.sortedContentSequence.length;
  314. const pageStatus = [true, true, false, true, false, false, false, false];
  315. // 2. calculate the page info one by one
  316. let bands = JpcBand.createNew(rptTpl, defProperties);
  317. function private_resetBandArea() {
  318. JpcBandHelper.setBandArea(bands, rptTpl, pageStatus);
  319. maxRowRec = JpcCrossTabHelper.getMaxRowsPerPage(bands, rptTpl);
  320. maxColRec = JpcCrossTabHelper.getMaxColsPerPage(bands, rptTpl);
  321. }
  322. JpcFieldHelper.findAndPutDataFieldIdx(rptTpl, rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW_EXT][JV.PROP_CROSS_FIELDS], null, me.row_extension_fields_idx);
  323. 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);
  324. if (me.paging_option === JV.PAGING_OPTION_INFINITY) {
  325. /*
  326. rst = segCnt;
  327. pageStatus[JV.STATUS_SEGMENT_START] = true;
  328. pageStatus[JV.STATUS_SEGMENT_END] = true;
  329. pageStatus[JV.STATUS_CROSS_ROW_END] = true;
  330. pageStatus[JV.STATUS_CROSS_COL_END] = true;
  331. for (let segIdx = 0; segIdx < segCnt; segIdx++) {
  332. if (segIdx === segCnt - 1) {
  333. pageStatus[JV.STATUS_REPORT_END] = true;
  334. }
  335. if (segIdx > 0) {
  336. pageStatus[JV.STATUS_REPORT_START] = false;
  337. }
  338. me.pageStatusLst.push(pageStatus.slice(0));
  339. pageIdx++;
  340. 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);
  341. private_addTabValue(me.dispValueIdxLst_Col, me.sortedColSequence, segIdx, 0, me.sortedColSequence[segIdx].length, null, null, null);
  342. private_addContentValue(me.dispValueIdxLst_Content, me.sortedContentSequence, segIdx, 0, me.sortedRowSequence[segIdx].length, 0, me.sortedColSequence[segIdx].length, me.page_seg_map, pageIdx);
  343. }
  344. //*/
  345. } else {
  346. for (let segIdx = 0; segIdx < segCnt; segIdx++) {
  347. // 2.1. seg level initialize
  348. private_resetBandArea();
  349. const orgMaxRowRec = maxRowRec;
  350. const orgMaxColRec = maxColRec;
  351. let rowSplitCnt = Math.ceil(1.0 * me.sortedRowSequence[segIdx].length / maxRowRec);
  352. let colSplitCnt = Math.ceil(1.0 * me.sortedColSequence[segIdx].length / maxColRec);
  353. pageStatus[JV.STATUS_CROSS_ROW_END] = true;
  354. private_resetBandArea();
  355. let hasAdHocRow = !JpcCrossTabHelper.chkTabEnd(JV.NODE_CROSS_ROW_SUM, rptTpl, bands, me.sortedRowSequence, segIdx, (rowSplitCnt - 1) * orgMaxRowRec, maxRowRec);
  356. if (hasAdHocRow) {
  357. hasAdHocRow = !JpcCrossTabHelper.chkTabEnd(JV.NODE_CROSS_ROW_EXT, rptTpl, bands, me.sortedRowSequence, segIdx, (rowSplitCnt - 1) * orgMaxRowRec, maxRowRec);
  358. }
  359. pageStatus[JV.STATUS_CROSS_ROW_END] = false;
  360. pageStatus[JV.STATUS_CROSS_COL_END] = true;
  361. private_resetBandArea();
  362. const hasAdHocCol = !JpcCrossTabHelper.chkTabEnd(JV.NODE_CROSS_COL_SUM, rptTpl, bands, me.sortedColSequence, segIdx, (colSplitCnt - 1) * orgMaxColRec, maxColRec);
  363. pageStatus[JV.STATUS_CROSS_COL_END] = false;
  364. private_resetBandArea();
  365. if (hasAdHocRow) rowSplitCnt++;
  366. if (hasAdHocCol) colSplitCnt++;
  367. // 2.2
  368. if (rptTpl[JV.NODE_MAIN_INFO][JV.NODE_PAGE_INFO][JV.PROP_CROSS_DISPLAY_ORDER] === JV.PAGE_ORIENTATION_H_FIRST) {
  369. for (let rowIdx = 0; rowIdx < rowSplitCnt; rowIdx++) {
  370. pageStatus[JV.STATUS_CROSS_ROW_END] = (rowIdx === (rowSplitCnt - 1));
  371. private_resetBandArea();
  372. counterRowRec = orgMaxRowRec * rowIdx;
  373. let currentSortedRowSequence = me.sortedRowSequence;
  374. let currentSortedContentSequence = me.sortedContentSequence;
  375. if (hasAdHocRow && rowIdx === (rowSplitCnt - 1)) {
  376. currentSortedRowSequence = null;
  377. currentSortedContentSequence = null;
  378. counterRowRec = 0;
  379. }
  380. for (let colIdx = 0; colIdx < colSplitCnt; colIdx++) {
  381. pageStatus[JV.STATUS_CROSS_COL_END] = (colIdx === (colSplitCnt - 1));
  382. let needOneMoreRptEnd = false;
  383. if ((segIdx === segCnt - 1) && pageStatus[JV.STATUS_CROSS_ROW_END] && pageStatus[JV.STATUS_CROSS_COL_END]) {
  384. pageStatus[JV.STATUS_REPORT_END] = true;
  385. private_resetBandArea();
  386. let hasAdHocColEnd = !JpcCrossTabHelper.chkTabEnd(JV.NODE_CROSS_COL_SUM, rptTpl, bands, me.sortedColSequence, segIdx, (colSplitCnt - 1) * orgMaxColRec, maxColRec);
  387. let hasAdHocRowEnd = !JpcCrossTabHelper.chkTabEnd(JV.NODE_CROSS_ROW_SUM, rptTpl, bands, me.sortedRowSequence, segIdx, (rowSplitCnt - 1) * orgMaxRowRec, maxRowRec);
  388. if (hasAdHocColEnd || hasAdHocRowEnd) {
  389. needOneMoreRptEnd = true;
  390. pageStatus[JV.STATUS_REPORT_END] = false;
  391. }
  392. }
  393. private_resetBandArea();
  394. counterColRec = orgMaxColRec * colIdx;
  395. let currentSortedColSequence = me.sortedColSequence;
  396. if (hasAdHocCol && colIdx === (colSplitCnt - 1)) {
  397. currentSortedColSequence = null;
  398. currentSortedContentSequence = null;
  399. counterColRec = 0;
  400. }
  401. me.pageStatusLst.push(pageStatus.slice(0));
  402. pageIdx++;
  403. private_addTabValue(me.dispValueIdxLst_Row, currentSortedRowSequence, segIdx, counterRowRec, maxRowRec, me.dispSerialIdxLst_Row, me.col_sum_fields_value_total, me.dispSumValueLst_Col);
  404. private_addTabValue(me.dispValueIdxLst_Col, currentSortedColSequence, segIdx, counterColRec, maxColRec, null, me.row_sum_fields_value_total, me.dispSumValueLst_Row);
  405. private_addContentValue(me.dispValueIdxLst_Content, currentSortedContentSequence, segIdx, counterRowRec, maxRowRec, counterColRec, maxColRec, me.page_seg_map, pageIdx);
  406. // 处理report end情况
  407. if (needOneMoreRptEnd) {
  408. pageStatus[JV.STATUS_REPORT_END] = true;
  409. private_resetBandArea();
  410. currentSortedColSequence = null;
  411. currentSortedContentSequence = null;
  412. counterColRec = 0;
  413. me.pageStatusLst.push(pageStatus.slice(0));
  414. pageIdx++;
  415. private_addTabValue(me.dispValueIdxLst_Row, currentSortedRowSequence, segIdx, counterRowRec, maxRowRec, me.dispSerialIdxLst_Row, me.col_sum_fields_value_total, me.dispSumValueLst_Col);
  416. private_addTabValue(me.dispValueIdxLst_Col, currentSortedColSequence, segIdx, counterColRec, maxColRec, null, me.row_sum_fields_value_total, me.dispSumValueLst_Row);
  417. private_addContentValue(me.dispValueIdxLst_Content, currentSortedContentSequence, segIdx, counterRowRec, maxRowRec, counterColRec, maxColRec, me.page_seg_map, pageIdx);
  418. }
  419. }
  420. }
  421. } else {
  422. for (let colIdx = 0; colIdx < colSplitCnt; colIdx++) {
  423. pageStatus[JV.STATUS_CROSS_COL_END] = (colIdx === (colSplitCnt - 1));
  424. private_resetBandArea();
  425. counterColRec = orgMaxColRec * colIdx;
  426. let currentSortedContentSequence = me.sortedContentSequence;
  427. let currentSortedColSequence = me.sortedColSequence;
  428. if (hasAdHocCol && colIdx === (colSplitCnt - 1)) {
  429. currentSortedColSequence = null;
  430. currentSortedContentSequence = null;
  431. counterColRec = 0;
  432. }
  433. for (let rowIdx = 0; rowIdx < rowSplitCnt; rowIdx++) {
  434. pageStatus[JV.STATUS_CROSS_ROW_END] = (rowIdx === (rowSplitCnt - 1));
  435. let needOneMoreRptEnd = false;
  436. if ((segIdx === segCnt - 1) && pageStatus[JV.STATUS_CROSS_ROW_END] && pageStatus[JV.STATUS_CROSS_COL_END]) {
  437. pageStatus[JV.STATUS_REPORT_END] = true;
  438. private_resetBandArea();
  439. let hasAdHocColEnd = !JpcCrossTabHelper.chkTabEnd(JV.NODE_CROSS_COL_SUM, rptTpl, bands, me.sortedColSequence, segIdx, (colSplitCnt - 1) * orgMaxColRec, maxColRec);
  440. let hasAdHocRowEnd = !JpcCrossTabHelper.chkTabEnd(JV.NODE_CROSS_ROW_SUM, rptTpl, bands, me.sortedRowSequence, segIdx, (rowSplitCnt - 1) * orgMaxRowRec, maxRowRec);
  441. if (hasAdHocColEnd || hasAdHocRowEnd) {
  442. needOneMoreRptEnd = true;
  443. pageStatus[JV.STATUS_REPORT_END] = false;
  444. }
  445. }
  446. private_resetBandArea();
  447. me.pageStatusLst.push(pageStatus.slice(0));
  448. pageIdx++;
  449. counterRowRec = orgMaxRowRec * rowIdx;
  450. let currentSortedRowSequence = me.sortedRowSequence;
  451. if (hasAdHocRow && rowIdx === (rowSplitCnt - 1)) {
  452. currentSortedRowSequence = null;
  453. currentSortedContentSequence = null;
  454. counterRowRec = 0;
  455. }
  456. private_addTabValue(me.dispValueIdxLst_Row, currentSortedRowSequence, segIdx, counterRowRec, maxRowRec, me.dispSerialIdxLst_Row, me.col_sum_fields_value_total, me.dispSumValueLst_Col);
  457. private_addTabValue(me.dispValueIdxLst_Col, currentSortedColSequence, segIdx, counterColRec, maxColRec, null, me.row_sum_fields_value_total, me.dispSumValueLst_Row);
  458. private_addContentValue(me.dispValueIdxLst_Content, currentSortedContentSequence, segIdx, counterRowRec, maxRowRec, counterColRec, maxColRec, me.page_seg_map, pageIdx);
  459. // 处理report end情况
  460. if (needOneMoreRptEnd) {
  461. pageStatus[JV.STATUS_REPORT_END] = true;
  462. private_resetBandArea();
  463. currentSortedRowSequence = null;
  464. currentSortedContentSequence = null;
  465. counterRowRec = 0;
  466. me.pageStatusLst.push(pageStatus.slice(0));
  467. pageIdx++;
  468. private_addTabValue(me.dispValueIdxLst_Row, currentSortedRowSequence, segIdx, counterRowRec, maxRowRec, me.dispSerialIdxLst_Row, me.col_sum_fields_value_total, me.dispSumValueLst_Col);
  469. private_addTabValue(me.dispValueIdxLst_Col, currentSortedColSequence, segIdx, counterColRec, maxColRec, null, me.row_sum_fields_value_total, me.dispSumValueLst_Row);
  470. private_addContentValue(me.dispValueIdxLst_Content, currentSortedContentSequence, segIdx, counterRowRec, maxRowRec, counterColRec, maxColRec, me.page_seg_map, pageIdx);
  471. }
  472. }
  473. }
  474. }
  475. JpcCrossTabHelper.initialPageStatus(pageStatus);
  476. }
  477. // 3. set pageSeq and return the result
  478. rst = pageIdx;
  479. }
  480. bands = null;
  481. return rst;
  482. };
  483. JpcCrossTabResult.outputAsPreviewPage = function(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg) {
  484. const me = this;
  485. let rst = [];
  486. const pageStatus = [true, true, true, true, true, true, true, true];
  487. me.pageStatusLst.push(pageStatus);
  488. // JpcFieldHelper.findAndPutDataFieldIdx(rptTpl, rptTpl[JV.NODE_FLOW_INFO][JV.NODE_FLOW_CONTENT][JV.PROP_FLOW_FIELDS], null, me.disp_fields_idx, false);
  489. JpcBandHelper.setBandArea(bands, rptTpl, pageStatus, true, false);
  490. const maxRowRec = JpcCrossTabHelper.getMaxRowsPerPage(bands, rptTpl);
  491. const maxColRec = JpcCrossTabHelper.getMaxColsPerPage(bands, rptTpl);
  492. const unitFactor = JpcCommonHelper.getUnitFactor(rptTpl);
  493. // 1. 交叉行
  494. rst = rst.concat(me.outputPreviewRowTab(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxRowRec, unitFactor));
  495. // 2. 交叉列
  496. rst = rst.concat(me.outputPreviewColTab(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxColRec, unitFactor));
  497. // 3. 交叉数据
  498. rst = rst.concat(me.outputPreviewContent(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxRowRec, maxColRec, unitFactor));
  499. // 4. 交叉行拓展
  500. rst = rst.concat(me.outputPreviewTabExt(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxColRec, unitFactor));
  501. // 5. 交叉行拓展合计
  502. rst = rst.concat(me.outputPreviewSumTabExt(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, unitFactor));
  503. // 6. 交叉列合计
  504. rst = rst.concat(me.outputPreviewTabSumCol(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxRowRec, JV.NODE_CROSS_COL_SUM, unitFactor));
  505. // 6.1 交叉行合计
  506. rst = rst.concat(me.outputPreviewTabSumRow(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxColRec, JV.NODE_CROSS_ROW_SUM, unitFactor));
  507. // 7. 离散
  508. rst = rst.concat(JpcDiscreteHelper.outputPreviewDiscreteInfo(rptTpl[JV.NODE_CROSS_INFO][JV.NODE_DISCRETE_INFO], bands, unitFactor, pageStatus));
  509. return rst;
  510. };
  511. JpcCrossTabResult.outputPreviewRowTab = function(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxRowRec, unitFactor) {
  512. let rst = this.private_OutputPreviewCommon(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxRowRec, 1, rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW], unitFactor);
  513. 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));
  514. return rst;
  515. };
  516. JpcCrossTabResult.outputPreviewColTab = function(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxColRec, unitFactor) {
  517. return this.private_OutputPreviewCommon(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, 1, maxColRec, rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_COL], unitFactor);
  518. };
  519. JpcCrossTabResult.outputPreviewContent = function(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxRowRec, maxColRec, unitFactor) {
  520. return this.private_OutputPreviewCommon(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxRowRec, maxColRec, rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_CONTENT], unitFactor);
  521. };
  522. JpcCrossTabResult.outputPreviewTabSumCol = function(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxRowRec, tabNodeName, unitFactor) {
  523. return this.private_OutputPreviewCommon(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxRowRec, 1, rptTpl[JV.NODE_CROSS_INFO][tabNodeName], unitFactor);
  524. };
  525. JpcCrossTabResult.outputPreviewTabSumRow = function(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxColRec, tabNodeName, unitFactor) {
  526. return this.private_OutputPreviewCommon(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, 1, maxColRec, rptTpl[JV.NODE_CROSS_INFO][tabNodeName], unitFactor);
  527. };
  528. JpcCrossTabResult.outputPreviewTabExt = function(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxColRec, unitFactor) {
  529. // 交叉行拓展
  530. return this.private_OutputPreviewCommon(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, 1, maxColRec, rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW_EXT], unitFactor);
  531. };
  532. JpcCrossTabResult.outputPreviewSumTabExt = function(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, unitFactor) {
  533. // 交叉行拓展合计
  534. return this.private_OutputPreviewCommon(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, 1, 1, rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW_SUM_EXT], unitFactor);
  535. };
  536. JpcCrossTabResult.private_OutputPreviewCommon = function(rptTpl, bands, controls, $CURRENT_RPT, customizeCfg, maxRowRec, maxColRec, tab, unitFactor) {
  537. const me = this;
  538. const rst = [];
  539. const band = (tab) ? bands[tab[JV.PROP_BAND_NAME]] : null;
  540. if (band) {
  541. const tab_fields = tab[JV.PROP_CROSS_FIELDS];
  542. for (let rowIdx = 0; rowIdx < maxRowRec; rowIdx++) {
  543. for (let i = 0; i < tab_fields.length; i++) {
  544. const tab_field = tab_fields[i];
  545. if (!(tab_field[JV.PROP_HIDDEN])) {
  546. for (let colIdx = 0; colIdx < maxColRec; colIdx++) {
  547. if (tab_field[JV.PROP_IS_SERIAL]) {
  548. rst.push(me.outputTabField(band, tab_field, [rowIdx + 1], 0, -1, maxRowRec, rowIdx, maxColRec, colIdx, unitFactor, false, controls));
  549. } else {
  550. rst.push(me.outputTabField(band, tab_field, null, -1, -1, maxRowRec, rowIdx, maxColRec, colIdx, unitFactor, false, controls));
  551. }
  552. }
  553. }
  554. }
  555. if (tab[JV.PROP_TEXTS]) {
  556. for (let j = 0; j < tab[JV.PROP_TEXTS].length; j++) {
  557. for (let colIdx = 0; colIdx < maxColRec; colIdx++) {
  558. rst.push(JpcTextHelper.outputText(tab[JV.PROP_TEXTS][j], band, unitFactor, maxRowRec, rowIdx, maxColRec, colIdx, 1, 0));
  559. }
  560. }
  561. }
  562. }
  563. }
  564. return rst;
  565. };
  566. JpcCrossTabResult.outputAsSimpleJSONPage = function(rptTpl, dataObj, page, bands, controls, $CURRENT_RPT, customizeCfg) {
  567. const me = this;
  568. let rst = [];
  569. const tabRstLst = [];
  570. const unitFactor = JpcCommonHelper.getUnitFactor(rptTpl);
  571. if (me.paging_option === JV.PAGING_OPTION_INFINITY) {
  572. /*
  573. let segIdx = page - 1;
  574. //1 calculate the band position
  575. JpcBandHelper.setBandArea(bands, rptTpl, me.pageStatusLst[page - 1]);
  576. //2. then reset the band height
  577. let tab = rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_CONTENT];
  578. let crossContentBand = bands[tab[JV.PROP_BAND_NAME]];
  579. let actH = JpcCrossTabHelper.getActualRowsHeight(bands, rptTpl, me.sortedRowSequence, page);
  580. let actW = JpcCrossTabHelper.getActualColsWidth(bands, rptTpl, me.sortedColSequence, page);
  581. let offsetY = actH - (crossContentBand.Bottom - crossContentBand.Top);
  582. let offsetX = actW - (crossContentBand.Right - crossContentBand.Left);
  583. JpcBandHelper.resetBandPos(rptTpl[JV.NODE_BAND_COLLECTION], bands, crossContentBand, offsetX, offsetY);
  584. //2.1 Row-Tab
  585. tabRstLst.push(me.outputRowTab(rptTpl, dataObj, page, bands, unitFactor, controls));
  586. //2.2 Col-Tab
  587. tabRstLst.push(me.outputColTab(rptTpl, dataObj, page, bands, unitFactor, controls));
  588. //2.3 Content-Tab
  589. tabRstLst.push(me.outputContent(rptTpl, dataObj, page, bands, unitFactor, controls));
  590. //2.4 Sum-Tab Row
  591. //2.4 Sum-tab Col
  592. tabRstLst.push(me.outputTabSumCol(rptTpl, dataObj, page, bands, unitFactor, JV.NODE_CROSS_COL_SUM, controls));
  593. //2.x row tab ext
  594. tabRstLst.push(me.outputTabExt(rptTpl, dataObj, page, bands, unitFactor, controls));
  595. tabRstLst.push(me.outputSumTabExt(rptTpl, dataObj, page, bands, unitFactor, segIdx, controls));
  596. //2.5 Discrete
  597. 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));
  598. //*/
  599. } else {
  600. const segIdx = JpcCommonHelper.getSegIdxByPageIdx(page, me.page_seg_map);
  601. const segPageIdx = 0; // 暂时设置为0
  602. // 1 calculate the band position
  603. JpcBandHelper.setBandArea(bands, rptTpl, me.pageStatusLst[page - 1]);
  604. // 2. start to output detail-part
  605. // 2.1 Row-Tab
  606. // tabRstLst.push(me.outputRowTab(rptTpl, dataObj, page, bands, unitFactor, controls, $CURRENT_RPT, customizeCfg));
  607. tabRstLst.push(me.outputRowTabCommon(rptTpl, dataObj, page, bands, JV.NODE_CROSS_ROW, me.row_fields_idx, unitFactor, controls, $CURRENT_RPT, customizeCfg));
  608. tabRstLst.push(me.outputRowTabCommon(rptTpl, dataObj, page, bands, JV.NODE_CROSS_ROW_AD_HOC, me.row_fields_adhoc_idx, unitFactor, controls, $CURRENT_RPT, customizeCfg));
  609. // 2.2 Col-Tab
  610. tabRstLst.push(me.outputColTab(rptTpl, dataObj, page, bands, unitFactor, controls, $CURRENT_RPT, customizeCfg));
  611. // 2.3 Content-Tab
  612. tabRstLst.push(me.outputContent(rptTpl, dataObj, page, bands, unitFactor, controls, $CURRENT_RPT, customizeCfg));
  613. // 2.4 Sum-Tab Row
  614. // 现在要加咯,
  615. tabRstLst.push(me.outputTabSumRow(rptTpl, dataObj, page, bands, unitFactor, JV.NODE_CROSS_ROW_SUM, controls, $CURRENT_RPT, customizeCfg));
  616. // 2.4 Sum-tab Col
  617. tabRstLst.push(me.outputTabSumCol(rptTpl, dataObj, page, bands, unitFactor, JV.NODE_CROSS_COL_SUM, controls, $CURRENT_RPT, customizeCfg));
  618. // 2.x row tab ext
  619. tabRstLst.push(me.outputTabExt(rptTpl, dataObj, page, bands, unitFactor, controls, $CURRENT_RPT, customizeCfg));
  620. tabRstLst.push(me.outputSumTabExt(rptTpl, dataObj, page, bands, unitFactor, segIdx, controls, $CURRENT_RPT, customizeCfg));
  621. // 2.5 Discrete
  622. tabRstLst.push(JpcDiscreteHelper.outputDiscreteInfo(rptTpl[JV.NODE_CROSS_INFO][JV.NODE_DISCRETE_INFO], bands, dataObj, unitFactor, me.pageStatusLst[page - 1], segIdx, segPageIdx, 1, 0, $CURRENT_RPT, customizeCfg, me.signatureRst, me.signatureDateRst, me.signatureAuditRst));
  623. }
  624. for (let i = 0; i < tabRstLst.length; i++) {
  625. rst = rst.concat(tabRstLst[i]);
  626. tabRstLst[i] = null;
  627. }
  628. me.checkCombineEvent(JV.RUN_TYPE_AFTER_COMBINE, [], [], rst, $CURRENT_RPT, dataObj);
  629. return rst;
  630. };
  631. JpcCrossTabResult.checkCombineEvent = function($RUN_TYPE, $VER_COMB_ARRAY, $HOR_COMB_ARRAY, $CURRENT_CELL_ITEMS, $CURRENT_RPT, $CURRENT_DATA) {
  632. if ($CURRENT_RPT.formulas) {
  633. for (let execFmlIdx = 0; execFmlIdx < $CURRENT_RPT.formulas.length; execFmlIdx++) {
  634. if ($CURRENT_RPT.formulas[execFmlIdx][JV.PROP_RUN_TYPE] === $RUN_TYPE) {
  635. const expression = $CURRENT_RPT.formulas[execFmlIdx][JV.PROP_EXPRESSION];
  636. if (expression) {
  637. const $ME = $CURRENT_RPT.formulas[execFmlIdx];
  638. const $JE = JE;
  639. try {
  640. eval(expression);
  641. } catch (ex) {
  642. console.log(ex);
  643. }
  644. }
  645. }
  646. }
  647. }
  648. };
  649. JpcCrossTabResult.outputRowTabCommon = function(rptTpl, dataObj, page, bands, tabStr, rowFieldsIdxArr, unitFactor, controls, $CURRENT_RPT, customizeCfg) {
  650. const me = this;
  651. const rst = [];
  652. const tab = rptTpl[JV.NODE_CROSS_INFO][tabStr];
  653. const band = (tab) ? bands[tab[JV.PROP_BAND_NAME]] : null;
  654. if (band) {
  655. const pageStatus = me.pageStatusLst[page - 1];
  656. if (pageStatus[band[JV.BAND_PROP_DISPLAY_TYPE]] === true) {
  657. const tab_fields = tab[JV.PROP_CROSS_FIELDS];
  658. const data_details = dataObj[JV.DATA_DETAIL_DATA];
  659. const valuesIdx = me.dispValueIdxLst_Row[page - 1];
  660. const serialsIdx = me.dispSerialIdxLst_Row[page - 1];
  661. let flexiblePrecisionRefObj = null;
  662. let flexibleRefField = null;
  663. let precision_ref_data = null;
  664. for (let i = 0; i < rowFieldsIdxArr.length; i++) {
  665. const tab_field = tab_fields[i];
  666. if (!(tab_field[JV.PROP_HIDDEN])) {
  667. let data_field = null;
  668. const map_data_field = JE.F(tab_field[JV.PROP_FIELD_ID], $CURRENT_RPT);
  669. if (typeof rowFieldsIdxArr[i] !== 'object') {
  670. data_field = data_details[rowFieldsIdxArr[i]];
  671. } else {
  672. if (map_data_field) {
  673. data_field = map_data_field[JV.PROP_AD_HOC_DATA];
  674. }
  675. }
  676. const rows = valuesIdx.length;
  677. for (let rowIdx = 0; rowIdx < rows; rowIdx++) {
  678. if (map_data_field && map_data_field[JV.PROP_PRECISION] && map_data_field.flexiblePrecisionRefObj) {
  679. if (flexiblePrecisionRefObj === null) {
  680. flexiblePrecisionRefObj = {};
  681. flexibleRefField = JE.F(map_data_field[JV.PROP_PRECISION][JV.PROP_FLEXIBLE_REF_FILED_ID], $CURRENT_RPT);
  682. precision_ref_data = dataObj[map_data_field.DataNodeName][flexibleRefField.DataSeq];
  683. for (const decimalObj of map_data_field.flexiblePrecisionRefObj) {
  684. flexiblePrecisionRefObj['refUnit_' + decimalObj.unit] = decimalObj.decimal;
  685. }
  686. }
  687. JpcFieldHelper.resetFlexibleFormat(tab_field, precision_ref_data, flexiblePrecisionRefObj, valuesIdx[rowIdx], customizeCfg);
  688. } else {
  689. if (rowIdx === 0) JpcFieldHelper.resetFormat(tab_field, map_data_field, customizeCfg);
  690. }
  691. rst.push(me.outputTabField(band, tab_field, data_field, valuesIdx[rowIdx], serialsIdx[rowIdx], rows, rowIdx, 1, 0, unitFactor, true, controls));
  692. }
  693. }
  694. }
  695. }
  696. }
  697. return rst;
  698. };
  699. JpcCrossTabResult.outputColTab = function(rptTpl, dataObj, page, bands, unitFactor, controls, $CURRENT_RPT, customizeCfg) {
  700. const me = this;
  701. let rst = [];
  702. let firstTextOutput = true;
  703. const tab = rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_COL];
  704. const band = bands[tab[JV.PROP_BAND_NAME]];
  705. if (band) {
  706. const pageStatus = me.pageStatusLst[page - 1];
  707. if (pageStatus[band[JV.BAND_PROP_DISPLAY_TYPE]] === true) {
  708. const tab_fields = tab[JV.PROP_CROSS_FIELDS];
  709. const data_details = dataObj[JV.DATA_DETAIL_DATA];
  710. const valuesIdx = me.dispValueIdxLst_Col[page - 1];
  711. let flexiblePrecisionRefObj = null;
  712. let flexibleRefField = null;
  713. let precision_ref_data = null;
  714. for (let i = 0; i < me.col_fields_idx.length; i++) {
  715. const tab_field = tab_fields[i];
  716. if (!(tab_field[JV.PROP_HIDDEN])) {
  717. const mergedRst = [];
  718. let data_field = null;
  719. const map_data_field = JE.F(tab_field[JV.PROP_FIELD_ID], $CURRENT_RPT);
  720. if (typeof me.col_fields_idx[i] !== 'object') {
  721. data_field = data_details[me.col_fields_idx[i]];
  722. } else {
  723. if (map_data_field) {
  724. data_field = map_data_field[JV.PROP_AD_HOC_DATA];
  725. }
  726. }
  727. const cols = valuesIdx.length;
  728. for (let colIdx = 0; colIdx < cols; colIdx++) {
  729. if (map_data_field && map_data_field[JV.PROP_PRECISION] && map_data_field.flexiblePrecisionRefObj) {
  730. if (flexiblePrecisionRefObj === null) {
  731. flexiblePrecisionRefObj = {};
  732. flexibleRefField = JE.F(map_data_field[JV.PROP_PRECISION][JV.PROP_FLEXIBLE_REF_FILED_ID], $CURRENT_RPT);
  733. precision_ref_data = dataObj[map_data_field.DataNodeName][flexibleRefField.DataSeq];
  734. for (const decimalObj of map_data_field.flexiblePrecisionRefObj) {
  735. flexiblePrecisionRefObj['refUnit_' + decimalObj.unit] = decimalObj.decimal;
  736. }
  737. }
  738. JpcFieldHelper.resetFlexibleFormat(tab_field, precision_ref_data, flexiblePrecisionRefObj, valuesIdx[colIdx], customizeCfg);
  739. } else {
  740. if (colIdx === 0) JpcFieldHelper.resetFormat(tab_field, map_data_field, customizeCfg);
  741. }
  742. mergedRst.push(me.outputTabField(band, tab_field, data_field, valuesIdx[colIdx], -1, 1, 0, cols, colIdx, unitFactor, false, controls));
  743. // rst.push(me.outputTabField(band, tab_field, data_field, valuesIdx[colIdx], -1, 1, 0, cols, colIdx, unitFactor, false, controls));
  744. // 2. output texts
  745. if (firstTextOutput) {
  746. if (tab[JV.PROP_TEXT]) {
  747. // mergedRst.push(JpcTextHelper.outputText(tab[JV.PROP_TEXT], band, unitFactor, 1, 0, cols, colIdx, 1, 0));
  748. rst.push(JpcTextHelper.outputText(tab[JV.PROP_TEXT], band, unitFactor, 1, 0, cols, colIdx, 1, 0));
  749. }
  750. if (tab[JV.PROP_TEXTS]) {
  751. for (let j = 0; j < tab[JV.PROP_TEXTS].length; j++) {
  752. // mergedRst.push(JpcTextHelper.outputText(tab[JV.PROP_TEXTS][j], band, unitFactor, 1, 0, cols, colIdx, 1, 0));
  753. rst.push(JpcTextHelper.outputText(tab[JV.PROP_TEXTS][j], band, unitFactor, 1, 0, cols, colIdx, 1, 0));
  754. }
  755. }
  756. }
  757. }
  758. firstTextOutput = false;
  759. // 判断是否需要合并
  760. if (tab_field[JV.PROP_IS_MERGE] && mergedRst.length > 1) {
  761. let lastCell = mergedRst[mergedRst.length - 1];
  762. for (let mergeIdx = mergedRst.length - 2; mergeIdx >= 0; mergeIdx--) {
  763. if (lastCell[JV.PROP_VALUE] === mergedRst[mergeIdx][JV.PROP_VALUE]) {
  764. mergedRst[mergeIdx][JV.PROP_AREA][JV.PROP_RIGHT] = lastCell[JV.PROP_AREA][JV.PROP_RIGHT];
  765. mergedRst.splice(mergeIdx + 1, 1);
  766. }
  767. lastCell = mergedRst[mergeIdx];
  768. }
  769. }
  770. rst = rst.concat(mergedRst);
  771. }
  772. }
  773. }
  774. }
  775. return rst;
  776. };
  777. JpcCrossTabResult.outputContent = function(rptTpl, dataObj, page, bands, unitFactor, controls, $CURRENT_RPT, customizeCfg) {
  778. const me = this;
  779. const rst = [];
  780. const tab = rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_CONTENT];
  781. const band = bands[tab[JV.PROP_BAND_NAME]];
  782. if (band) {
  783. const pageStatus = me.pageStatusLst[page - 1];
  784. if (pageStatus[band[JV.BAND_PROP_DISPLAY_TYPE]] === true) {
  785. const tab_fields = tab[JV.PROP_CROSS_FIELDS];
  786. const data_details = dataObj[JV.DATA_DETAIL_DATA];
  787. const contentValuesIdx = me.dispValueIdxLst_Content[page - 1];
  788. let flexiblePrecisionRefObj = null;
  789. let flexibleRefField = null;
  790. let precision_ref_data = null;
  791. for (let i = 0; i < tab_fields.length; i++) {
  792. const tab_field = tab_fields[i];
  793. let data_field = null;
  794. const map_data_field = JE.F(tab_field[JV.PROP_FIELD_ID], $CURRENT_RPT);
  795. if (typeof me.content_fields_idx[i] !== 'object') {
  796. data_field = data_details[me.content_fields_idx[i]];
  797. } else {
  798. if (map_data_field) {
  799. data_field = map_data_field[JV.PROP_AD_HOC_DATA];
  800. }
  801. }
  802. if (!(tab_field[JV.PROP_HIDDEN])) {
  803. const rows = contentValuesIdx.length;
  804. for (let rowIdx = 0; rowIdx < rows; rowIdx++) {
  805. const cols = contentValuesIdx[rowIdx].length;
  806. for (let colIdx = 0; colIdx < cols; colIdx++) {
  807. if (map_data_field && map_data_field[JV.PROP_PRECISION] && map_data_field.flexiblePrecisionRefObj) {
  808. if (flexiblePrecisionRefObj === null) {
  809. flexiblePrecisionRefObj = {};
  810. flexibleRefField = JE.F(map_data_field[JV.PROP_PRECISION][JV.PROP_FLEXIBLE_REF_FILED_ID], $CURRENT_RPT);
  811. precision_ref_data = dataObj[map_data_field.DataNodeName][flexibleRefField.DataSeq];
  812. for (const decimalObj of map_data_field.flexiblePrecisionRefObj) {
  813. flexiblePrecisionRefObj['refUnit_' + decimalObj.unit] = decimalObj.decimal;
  814. }
  815. }
  816. JpcFieldHelper.resetFlexibleFormat(tab_field, precision_ref_data, flexiblePrecisionRefObj, contentValuesIdx[rowIdx][colIdx], customizeCfg);
  817. } else {
  818. if (colIdx === 0) JpcFieldHelper.resetFormat(tab_field, map_data_field, customizeCfg);
  819. }
  820. rst.push(me.outputTabField(band, tab_field, data_field, contentValuesIdx[rowIdx][colIdx], -1, rows, rowIdx, cols, colIdx, unitFactor, true, controls));
  821. }
  822. }
  823. }
  824. }
  825. }
  826. }
  827. return rst;
  828. };
  829. JpcCrossTabResult.outputTabSumRow = function(rptTpl, dataObj, page, bands, unitFactor, tabNodeName, controls, $CURRENT_RPT, customizeCfg) {
  830. const me = this;
  831. const rst = [];
  832. const tab = rptTpl[JV.NODE_CROSS_INFO][tabNodeName];
  833. const band = tab ? bands[tab[JV.PROP_BAND_NAME]] : null;
  834. if (band) {
  835. const pageStatus = me.pageStatusLst[page - 1];
  836. if (pageStatus[band[JV.BAND_PROP_DISPLAY_TYPE]] === true) {
  837. const tab_fields = tab[JV.PROP_CROSS_FIELDS];
  838. for (let i = 0; i < me.dispSumValueLst_Row[page - 1].length; i++) {
  839. if (i === 0) {
  840. for (let tfIdx = 0; tfIdx < tab_fields.length; tfIdx++) {
  841. const map_data_field = JE.F(tab_fields[tfIdx][JV.PROP_FIELD_ID], $CURRENT_RPT);
  842. JpcFieldHelper.resetFormat(tab_fields[tfIdx], map_data_field, customizeCfg);
  843. }
  844. }
  845. if (me.dispSumValueLst_Row[page - 1][i] !== null) {
  846. for (let j = 0; j < me.dispSumValueLst_Row[page - 1][i].length; j++) {
  847. const tab_field = tab_fields[j];
  848. const val = me.dispSumValueLst_Row[page - 1][i][j];
  849. const cellItem = JpcCommonOutputHelper.createCommonOutput(tab_field, val, controls);
  850. cellItem[JV.PROP_AREA] = JpcAreaHelper.outputArea(tab_field[JV.PROP_AREA], band, unitFactor, 1, 0, me.dispSumValueLst_Row[page - 1].length, i, 1, 0, true, false);
  851. // 方向不同,需要调整下
  852. rst.push(cellItem);
  853. }
  854. } else {
  855. let sumL = 1;
  856. for (let si = 0; si < me.dispSumValueLst_Row.length; si++) {
  857. if (me.dispSumValueLst_Row[si][0] !== null) {
  858. sumL = me.dispSumValueLst_Row[si][0].length;
  859. break;
  860. }
  861. }
  862. for (let j = 0; j < sumL; j++) {
  863. const tab_field = tab_fields[j];
  864. const val = null;
  865. const cellItem = JpcCommonOutputHelper.createCommonOutput(tab_field, val, controls);
  866. cellItem[JV.PROP_AREA] = JpcAreaHelper.outputArea(tab_field[JV.PROP_AREA], band, unitFactor, 1, 0, me.dispSumValueLst_Row[page - 1].length, i, 1, 0, true, false);
  867. rst.push(cellItem);
  868. }
  869. }
  870. }
  871. }
  872. }
  873. return rst;
  874. };
  875. JpcCrossTabResult.outputTabSumCol = function(rptTpl, dataObj, page, bands, unitFactor, tabNodeName, controls, $CURRENT_RPT, customizeCfg) {
  876. const me = this;
  877. const rst = [];
  878. const tab = rptTpl[JV.NODE_CROSS_INFO][tabNodeName];
  879. const band = bands[tab[JV.PROP_BAND_NAME]];
  880. if (band) {
  881. const pageStatus = me.pageStatusLst[page - 1];
  882. if (pageStatus[band[JV.BAND_PROP_DISPLAY_TYPE]] === true) {
  883. const tab_fields = tab[JV.PROP_CROSS_FIELDS];
  884. for (let i = 0; i < me.dispSumValueLst_Col[page - 1].length; i++) {
  885. if (i === 0) {
  886. for (let tfIdx = 0; tfIdx < tab_fields.length; tfIdx++) {
  887. const map_data_field = JE.F(tab_fields[tfIdx][JV.PROP_FIELD_ID], $CURRENT_RPT);
  888. JpcFieldHelper.resetFormat(tab_fields[tfIdx], map_data_field, customizeCfg);
  889. }
  890. }
  891. // console.log('当前页:' + page);
  892. // console.log(me.dispSumValueLst_Col[page - 1][i]);
  893. if (me.dispSumValueLst_Col[page - 1][i] !== null) {
  894. for (let j = 0; j < me.dispSumValueLst_Col[page - 1][i].length; j++) {
  895. const tab_field = tab_fields[j];
  896. const val = me.dispSumValueLst_Col[page - 1][i][j];
  897. const cellItem = JpcCommonOutputHelper.createCommonOutput(tab_field, val, controls);
  898. 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);
  899. rst.push(cellItem);
  900. }
  901. } else {
  902. let sumL = 1;
  903. for (let si = 0; si < me.dispSumValueLst_Col.length; si++) {
  904. if (me.dispSumValueLst_Col[si][0] !== null) {
  905. sumL = me.dispSumValueLst_Col[si][0].length;
  906. break;
  907. }
  908. }
  909. for (let j = 0; j < sumL; j++) {
  910. const tab_field = tab_fields[j];
  911. const val = null;
  912. const cellItem = JpcCommonOutputHelper.createCommonOutput(tab_field, val, controls);
  913. 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);
  914. rst.push(cellItem);
  915. }
  916. }
  917. }
  918. }
  919. }
  920. return rst;
  921. };
  922. JpcCrossTabResult.outputTabExt = function(rptTpl, dataObj, page, bands, unitFactor, controls, $CURRENT_RPT, customizeCfg) {
  923. const me = this;
  924. const rst = [];
  925. let firstTextOutput = true;
  926. const tab = rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW_EXT];
  927. const band = bands[tab[JV.PROP_BAND_NAME]];
  928. if (band) {
  929. const pageStatus = me.pageStatusLst[page - 1];
  930. if (pageStatus[band[JV.BAND_PROP_DISPLAY_TYPE]] === true) {
  931. const tab_fields = tab[JV.PROP_CROSS_FIELDS];
  932. const data_details = dataObj[JV.DATA_DETAIL_DATA];
  933. const valuesIdx = me.dispValueIdxLst_Col[page - 1];
  934. for (let i = 0; i < me.row_extension_fields_idx.length; i++) {
  935. const tab_field = tab_fields[i];
  936. let data_field = null;
  937. const map_data_field = JE.F(tab_field[JV.PROP_FIELD_ID], $CURRENT_RPT);
  938. if (typeof me.row_extension_fields_idx[i] !== 'object') {
  939. data_field = data_details[me.row_extension_fields_idx[i]];
  940. } else {
  941. if (map_data_field) {
  942. data_field = map_data_field[JV.PROP_AD_HOC_DATA];
  943. }
  944. }
  945. if (!(tab_field[JV.PROP_HIDDEN])) {
  946. const cols = valuesIdx.length;
  947. for (let colIdx = 0; colIdx < cols; colIdx++) {
  948. if (colIdx === 0) JpcFieldHelper.resetFormat(tab_field, map_data_field, customizeCfg);
  949. rst.push(me.outputTabField(band, tab_field, data_field, valuesIdx[colIdx], -1, 1, 0, cols, colIdx, unitFactor, false, controls));
  950. // 2. output texts if has
  951. if (firstTextOutput) {
  952. if (tab[JV.PROP_TEXT]) {
  953. rst.push(JpcTextHelper.outputText(tab[JV.PROP_TEXT], band, unitFactor, 1, 0, cols, colIdx, 1, 0));
  954. }
  955. if (tab[JV.PROP_TEXTS]) {
  956. for (let j = 0; j < tab[JV.PROP_TEXTS].length; j++) {
  957. rst.push(JpcTextHelper.outputText(tab[JV.PROP_TEXTS][j], band, unitFactor, 1, 0, cols, colIdx, 1, 0));
  958. }
  959. }
  960. }
  961. }
  962. firstTextOutput = false;
  963. }
  964. }
  965. if (me.row_extension_fields_idx.length === 0) {
  966. const cols = valuesIdx.length;
  967. for (let colIdx = 0; colIdx < cols; colIdx++) {
  968. if (tab[JV.PROP_TEXT]) {
  969. rst.push(JpcTextHelper.outputText(tab[JV.PROP_TEXT], band, unitFactor, 1, 0, cols, colIdx, 1, 0));
  970. }
  971. if (tab[JV.PROP_TEXTS]) {
  972. for (let j = 0; j < tab[JV.PROP_TEXTS].length; j++) {
  973. rst.push(JpcTextHelper.outputText(tab[JV.PROP_TEXTS][j], band, unitFactor, 1, 0, cols, colIdx, 1, 0));
  974. }
  975. }
  976. }
  977. }
  978. }
  979. }
  980. return rst;
  981. };
  982. JpcCrossTabResult.outputSumTabExt = function(rptTpl, dataObj, page, bands, unitFactor, segIdx, controls, $CURRENT_RPT, customizeCfg) {
  983. const me = this;
  984. const rst = [];
  985. const tab = rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW_SUM_EXT];
  986. const band = bands[tab[JV.PROP_BAND_NAME]];
  987. if (band) {
  988. const pageStatus = me.pageStatusLst[page - 1];
  989. if (pageStatus[band[JV.BAND_PROP_DISPLAY_TYPE]] === true && pageStatus[JV.STATUS_CROSS_ROW_END] === true) {
  990. const tab_fields = tab[JV.PROP_CROSS_FIELDS];
  991. const data_details = dataObj[JV.DATA_DETAIL_DATA];
  992. const data_fields = [];
  993. for (let i = 0; i < me.row_sum_extension_fields_idx.length; i++) {
  994. // let data_field = data_details[me.row_sum_extension_fields_idx[i]];
  995. const tab_field = tab_fields[i];
  996. let data_field = null;
  997. const map_data_field = JE.F(tab_field[JV.PROP_FIELD_ID], $CURRENT_RPT);
  998. if (typeof me.row_sum_extension_fields_idx[i] !== 'object') {
  999. data_field = data_details[me.row_sum_extension_fields_idx[i]];
  1000. } else {
  1001. if (map_data_field) {
  1002. data_field = map_data_field[JV.PROP_AD_HOC_DATA];
  1003. }
  1004. }
  1005. JpcFieldHelper.resetFormat(tab_field, map_data_field, customizeCfg);
  1006. data_fields.push(data_field);
  1007. }
  1008. // 2. initialize grand total value
  1009. const rowGrandTotal = [];
  1010. for (let di = 0; di < data_fields.length; di++) {
  1011. rowGrandTotal[di] = 0.0;
  1012. // 3. start to sum
  1013. // 这里的合计实际是章合计来的,需要seg level全部累加
  1014. for (let i = 0; i < me.sortedColSequence[segIdx].length; i++) {
  1015. for (let j = 0; j < me.sortedColSequence[segIdx][i].length; j++) {
  1016. // rowGrandTotal[di] = rowGrandTotal[di] + 1.0 * JpcFieldHelper.getValue(data_fields[di], me.sortedColSequence[segIdx][i][j]);
  1017. let vTtl = parseFloat(JpcFieldHelper.getValue(data_fields[di], me.sortedColSequence[segIdx][i][j]));
  1018. if (isNaN(vTtl)) {
  1019. vTtl = 0;
  1020. }
  1021. rowGrandTotal[di] = bc.add(rowGrandTotal[di], vTtl);
  1022. }
  1023. }
  1024. }
  1025. // 4. output
  1026. for (let di = 0; di < tab_fields.length; di++) {
  1027. const tab_field = tab_fields[di];
  1028. if (!tab_field[JV.PROP_HIDDEN]) {
  1029. const val = rowGrandTotal[di];
  1030. const cellItem = JpcCommonOutputHelper.createCommonOutput(tab_field, val, controls);
  1031. cellItem[JV.PROP_AREA] = JpcAreaHelper.outputArea(tab_field[JV.PROP_AREA], band, unitFactor, 1, 0, 1, 0, 1, 0, false, false);
  1032. rst.push(cellItem);
  1033. }
  1034. }
  1035. // output texts if has
  1036. if (tab[JV.PROP_TEXT]) {
  1037. rst.push(JpcTextHelper.outputText(tab[JV.PROP_TEXT], band, unitFactor, 1, 0, 1, 0, 1, 0));
  1038. }
  1039. if (tab[JV.PROP_TEXTS]) {
  1040. for (let j = 0; j < tab[JV.PROP_TEXTS].length; j++) {
  1041. rst.push(JpcTextHelper.outputText(tab[JV.PROP_TEXTS][j], band, unitFactor, 1, 0, 1, 0, 1, 0));
  1042. }
  1043. }
  1044. }
  1045. }
  1046. return rst;
  1047. };
  1048. JpcCrossTabResult.outputTabField = function(band, tab_field, data_field, valueIdx, serialIdx, rows, rowIdx, cols, colIdx, unitFactor, isRow, controls) {
  1049. let rst = null;
  1050. if (isRow === true && tab_field[JV.PROP_IS_SERIAL] && tab_field[JV.PROP_IS_SERIAL] === true) {
  1051. if (serialIdx >= 0) {
  1052. rst = JpcCommonOutputHelper.createCommonOutput(tab_field, serialIdx + 1);
  1053. } else {
  1054. rst = JpcCommonOutputHelper.createCommonOutput(tab_field, '', controls);
  1055. }
  1056. } else {
  1057. rst = JpcCommonOutputHelper.createCommonOutput(tab_field, JpcFieldHelper.getValue(data_field, valueIdx), controls);
  1058. }
  1059. // position
  1060. if (isRow === true) {
  1061. rst[JV.PROP_AREA] = JpcAreaHelper.outputArea(tab_field[JV.PROP_AREA], band, unitFactor, rows, rowIdx, cols, colIdx, 1, 0, true, false);
  1062. } else {
  1063. rst[JV.PROP_AREA] = JpcAreaHelper.outputArea(tab_field[JV.PROP_AREA], band, unitFactor, rows, rowIdx, cols, colIdx, 1, 0, false, false);
  1064. }
  1065. return rst;
  1066. };
  1067. return JpcCrossTabResult;
  1068. };
  1069. module.exports = new JpcCrossTabSrv();