jpc_helper_cross_tab.js 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256
  1. let JV = require('../jpc_value_define');
  2. let JE = require('../jpc_rte');
  3. let JpcCommonHelper = require('./jpc_helper_common');
  4. let JpcCrossTabHelper = {
  5. getColIDX: function(cl, val) {
  6. let rst = -1;
  7. for (let i = 0; i < cl.length; i++) {
  8. let ca = cl[i];
  9. for (let j = 0; j < ca.length; j++) {
  10. if (ca[j] == val) {
  11. rst = i;
  12. break;
  13. }
  14. }
  15. if (rst != -1) {
  16. break;
  17. }
  18. }
  19. return rst;
  20. },
  21. pushToSeg: function(segArr, dataSeq, segIdx, sIdx, eIdx) {
  22. let arrIdx = [];
  23. for (let k = sIdx; k < eIdx; k++) {
  24. arrIdx.push(dataSeq[segIdx][k]);
  25. }
  26. segArr.push(arrIdx);
  27. },
  28. sortFieldValue: function(sIDX, eIDX, sortOrder, dataField, dataValSeq) {
  29. let tmpSeq = [];
  30. if ((sortOrder) && (sortOrder !== JV.TAB_FIELD_PROP_SORT_VAL_NOSORT)) {
  31. if (sIDX >= 0 && eIDX >= sIDX && dataValSeq.length > eIDX) {
  32. let reversed = 1;
  33. if (sortOrder === JV.TAB_FIELD_PROP_SORT_VAL_DESC) {
  34. reversed = -1;
  35. }
  36. for (let i = sIDX; i <= eIDX; i++) {
  37. tmpSeq.push(dataValSeq[i]);
  38. }
  39. tmpSeq.sort(function(idx1, idx2) {
  40. let rst = 0;
  41. // if (isNaN(parseFloat(dataField[idx1])) || isNaN(parseFloat(dataField[idx1]))) {
  42. if (typeof (dataField[idx1]) === 'string' || typeof (dataField[idx1]) === 'string' ) {
  43. if (dataField[idx1] > dataField[idx2]) {
  44. rst = reversed;
  45. } else if (dataField[idx1] < dataField[idx2]) {
  46. rst = -reversed;
  47. }
  48. } else {
  49. if ((1.0 * dataField[idx1]) > (1.0 * dataField[idx2])) {
  50. rst = reversed;
  51. } else if ((1.0 * dataField[idx1]) < (1.0 * dataField[idx2])) {
  52. rst = -reversed;
  53. }
  54. }
  55. return rst;
  56. });
  57. }
  58. }
  59. if (tmpSeq.length > 0) {
  60. for (let i = sIDX; i <= eIDX; i++) {
  61. dataValSeq[i] = tmpSeq[i - sIDX];
  62. }
  63. }
  64. return tmpSeq;
  65. },
  66. checkIfEqual: function(dataFields, seq1, seq2) {
  67. let rst = true;
  68. for (let i = 0; i < dataFields.length; i++) {
  69. if ((dataFields[i][seq1] !== dataFields[i][seq2])) {
  70. rst = false;
  71. break;
  72. }
  73. }
  74. return rst;
  75. },
  76. sortTabFields: function(tabFields, fieldSeqs, data_details, dataSeq, $CURRENT_RPT) {
  77. let me = this;
  78. let sIDX = 0, eIDX = -1, isFirstSort = true;
  79. for (let i = 0; i < tabFields.length; i++) {
  80. let tabField = tabFields[i];
  81. if (tabField[JV.TAB_FIELD_PROP_SORT] !== JV.TAB_FIELD_PROP_SORT_VAL_NOSORT) {
  82. if (isFirstSort) {
  83. isFirstSort = false;
  84. //first field, should sort all data items
  85. for (let j = 0; j < dataSeq.length; j++) {
  86. sIDX = 0;
  87. eIDX = dataSeq[j].length - 1;
  88. //sort the field value here
  89. if (typeof(fieldSeqs[i]) === "object") {
  90. let exFirstField = JE.F(fieldSeqs[i][JV.PROP_ID], $CURRENT_RPT);
  91. if (exFirstField) {
  92. me.sortFieldValue(sIDX, eIDX, tabField[JV.TAB_FIELD_PROP_SORT], exFirstField[JV.PROP_AD_HOC_DATA], dataSeq[j]);
  93. } else {
  94. //不排序(健壮性)
  95. }
  96. } else {
  97. me.sortFieldValue(sIDX, eIDX, tabField[JV.TAB_FIELD_PROP_SORT],data_details[fieldSeqs[i]], dataSeq[j]);
  98. }
  99. // me.sortFieldValue(sIDX, eIDX, tabField[JV.TAB_FIELD_PROP_SORT],data_details[fieldSeqs[i]], dataSeq[j]);
  100. }
  101. } else {
  102. //then sort the rest fields one by one
  103. for (let j = 0; j < dataSeq.length; j++) {
  104. let chkFields = [];
  105. for (let k = 0; k < i; k++) {
  106. if (typeof(fieldSeqs[k]) === "object") {
  107. let exField = JE.F(fieldSeqs[k][JV.PROP_ID], $CURRENT_RPT);
  108. if (exField) {
  109. chkFields.push(exField[JV.PROP_AD_HOC_DATA]);
  110. } else {
  111. chkFields.push(null);
  112. }
  113. } else {
  114. chkFields.push(data_details[fieldSeqs[k]]);
  115. }
  116. // chkFields.push(data_details[fieldSeqs[k]]);
  117. }
  118. sIDX = 0, eIDX = -1;
  119. for (let m = 1; m < dataSeq[j].length; m++) {
  120. if (!(me.checkIfEqual(chkFields, dataSeq[j][m - 1], dataSeq[j][m]))) {
  121. eIDX = m - 1;
  122. } else if (m == dataSeq[j].length - 1) {
  123. eIDX = m;
  124. };
  125. if (eIDX >= sIDX) {
  126. if (eIDX != sIDX) {
  127. if (typeof(fieldSeqs[i]) === "object") {
  128. let exOtherField = JE.F(fieldSeqs[i][JV.PROP_ID], $CURRENT_RPT);
  129. if (exOtherField) {
  130. me.sortFieldValue(sIDX, eIDX, tabField[JV.TAB_FIELD_PROP_SORT], exOtherField[JV.PROP_AD_HOC_DATA], dataSeq[j]);
  131. } else {
  132. //不排序(健壮性)
  133. }
  134. } else {
  135. me.sortFieldValue(sIDX, eIDX, tabField[JV.TAB_FIELD_PROP_SORT],data_details[fieldSeqs[i]], dataSeq[j]);
  136. }
  137. // me.sortFieldValue(sIDX, eIDX, tabField[JV.TAB_FIELD_PROP_SORT],data_details[fieldSeqs[i]], dataSeq[j]);
  138. }
  139. sIDX = m;
  140. eIDX = m - 1; //for protection purpose
  141. }
  142. }
  143. }
  144. }
  145. }
  146. }
  147. },
  148. getMaxRowsPerPage: function(bands, rptTpl) {
  149. let rst = 1;
  150. let band = bands[rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW][JV.PROP_BAND_NAME]];
  151. if (band) {
  152. rst = getMaxTabCntPerPage(rptTpl, JV.NODE_CROSS_ROW, JV.PROP_CMN_HEIGHT, band.Bottom - band.Top);
  153. }
  154. return rst;
  155. },
  156. getMaxColsPerPage: function(bands, rptTpl) {
  157. let rst = 1;
  158. let band = bands[rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_COL][JV.PROP_BAND_NAME]];
  159. if (band) {
  160. rst = getMaxTabCntPerPage(rptTpl, JV.NODE_CROSS_COL, JV.PROP_CMN_WIDTH, band.Right - band.Left);
  161. }
  162. return rst;
  163. },
  164. getActualRowsHeight: function(bands, rptTpl, segments, page) {
  165. let rst = 1;
  166. let band = bands[rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW][JV.PROP_BAND_NAME]];
  167. if (band) {
  168. rst = getActualContentAreaMeasurement(rptTpl, JV.NODE_CROSS_ROW, JV.PROP_CMN_HEIGHT, band.Bottom - band.Top, segments, page);
  169. }
  170. return rst;
  171. },
  172. getActualColsWidth: function(bands, rptTpl, segments, page) {
  173. let rst = 1;
  174. let band = bands[rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_COL][JV.PROP_BAND_NAME]];
  175. if (band) {
  176. rst = getActualContentAreaMeasurement(rptTpl, JV.NODE_CROSS_COL, JV.PROP_CMN_WIDTH, band.Right - band.Left, segments, page);
  177. }
  178. return rst;
  179. },
  180. chkTabEnd: function(tabType, rptTpl, bands, sortedSequence, segIdx, preRec, nextRec) {
  181. let me = this, rst = true;
  182. let remainAmt = preRec + nextRec - sortedSequence[segIdx].length;
  183. rst = me.hasEnoughSpace(tabType, rptTpl, bands, remainAmt);
  184. return rst;
  185. },
  186. hasEnoughSpace: function (tabType, rptTpl, bands, remainAmt) {
  187. if (remainAmt < 0) return false;
  188. let rst = true, measurement = 1.0, douDiffForCompare = 0.00001;
  189. let unitFactor = JpcCommonHelper.getUnitFactor(rptTpl);
  190. let band = null;
  191. if (rptTpl[JV.NODE_CROSS_INFO][tabType]) {
  192. band = bands[rptTpl[JV.NODE_CROSS_INFO][tabType][JV.PROP_BAND_NAME]];
  193. }
  194. if (band != null && band != undefined) {
  195. if (tabType === JV.NODE_CROSS_ROW_SUM || tabType === JV.NODE_CROSS_ROW_EXT) {
  196. measurement = 1.0 * rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_ROW][JV.PROP_CMN_HEIGHT] * unitFactor;
  197. let spareHeight = measurement * remainAmt;
  198. let douH = 1.0 * (band.Bottom - band.Top);
  199. rst = (spareHeight >= douH) || (spareHeight - douH <= douDiffForCompare);
  200. } else if (tabType === JV.NODE_CROSS_COL_SUM) {
  201. measurement = 1.0 * rptTpl[JV.NODE_CROSS_INFO][JV.NODE_CROSS_COL][JV.PROP_CMN_WIDTH] * unitFactor;
  202. let spareWidth = measurement * remainAmt;
  203. let douW = 1.0 * (band.Right - band.Left);
  204. rst = (spareWidth >= douW) || (spareWidth - douW <= douDiffForCompare);
  205. }
  206. }
  207. return rst;
  208. },
  209. initialPageStatus: function (pageStatus) {
  210. pageStatus[JV.STATUS_NORMAL] = true;
  211. pageStatus[JV.STATUS_REPORT_START] = false;
  212. pageStatus[JV.STATUS_REPORT_END] = false;
  213. pageStatus[JV.STATUS_SEGMENT_START] = false;
  214. pageStatus[JV.STATUS_SEGMENT_END] = false;
  215. pageStatus[JV.STATUS_GROUP] = false;
  216. pageStatus[JV.STATUS_CROSS_ROW_END] = false;
  217. pageStatus[JV.STATUS_CROSS_COL_END] = false;
  218. }
  219. };
  220. function getMaxTabCntPerPage(rptTpl, tabNodeName, tabMeasurePropName, measureForCal) {
  221. let rst = 1;
  222. if (rptTpl[JV.NODE_CROSS_INFO][tabNodeName]) {
  223. let tab = rptTpl[JV.NODE_CROSS_INFO][tabNodeName];
  224. let maxFieldMeasure = 1.0;
  225. if (JV.CAL_TYPE_ABSTRACT === JpcCommonHelper.getPosCalculationType(tab[JV.PROP_CALCULATION])) {
  226. let unitFactor = JpcCommonHelper.getUnitFactor(rptTpl);
  227. maxFieldMeasure = 1.0 * rptTpl[JV.NODE_CROSS_INFO][tabNodeName][tabMeasurePropName] * unitFactor;
  228. } else {
  229. maxFieldMeasure = measureForCal * rptTpl[JV.NODE_CROSS_INFO][tabNodeName][tabMeasurePropName] / JV.HUNDRED_PERCENT;
  230. }
  231. rst = Math.floor(measureForCal / maxFieldMeasure);
  232. }
  233. return rst;
  234. };
  235. function getActualContentAreaMeasurement(rptTpl, tabNodeName, tabMeasurePropName, measureForCal, segments, page) {
  236. let rst = 1;
  237. if (rptTpl[JV.NODE_CROSS_INFO][tabNodeName]) {
  238. let tab = rptTpl[JV.NODE_CROSS_INFO][tabNodeName];
  239. let maxFieldMeasure = 1.0;
  240. if (JV.CAL_TYPE_ABSTRACT === JpcCommonHelper.getPosCalculationType(tab[JV.PROP_CALCULATION])) {
  241. let unitFactor = JpcCommonHelper.getUnitFactor(rptTpl);
  242. maxFieldMeasure = 1.0 * rptTpl[JV.NODE_CROSS_INFO][tabNodeName][tabMeasurePropName] * unitFactor;
  243. } else {
  244. maxFieldMeasure = measureForCal * rptTpl[JV.NODE_CROSS_INFO][tabNodeName][tabMeasurePropName] / JV.HUNDRED_PERCENT;
  245. }
  246. if (segments.length >= page) {
  247. rst = segments[page - 1].length * maxFieldMeasure;
  248. }
  249. }
  250. return rst;
  251. };
  252. module.exports = JpcCrossTabHelper;