jpc_data.ts 6.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118
  1. 'use strict';
  2. import JV from './jpc_value_define';
  3. import jpc_common_helper from './helper/jpc_helper_common';
  4. import { IDataObj, IRptTpl } from '../interface/basic';
  5. import { IDataObjProps } from '../interface/enum';
  6. const JpcData = {
  7. createNew() {
  8. let JpcDataRst = {
  9. dataSeq: [],
  10. exDataSeq: [],
  11. analyzeData(rptTpl: IRptTpl, dataObj: IDataObj) {
  12. let me = this;
  13. let _analyse = function (MASTER_FIELD_STR: string, DETAIL_FIELD_STR: string, MASTER_DATA_STR: string, DETAIL_DATA_STR: string, dataSeqArr: any) {
  14. //1. get ID fields
  15. let masterIDs = [];
  16. if (rptTpl.指标_数据_映射[MASTER_FIELD_STR]) {
  17. for (let i = 0; i < rptTpl.指标_数据_映射[MASTER_FIELD_STR].length; i++) {
  18. let mstFieldObj = rptTpl.指标_数据_映射[MASTER_FIELD_STR][i];
  19. if (jpc_common_helper.getBoolean(mstFieldObj.isID)) {
  20. masterIDs.push({ "idx": i, "seq": mstFieldObj.IDSeq });
  21. }
  22. }
  23. }
  24. let detailIDs = [];
  25. if (rptTpl.指标_数据_映射[DETAIL_FIELD_STR]) {
  26. for (let i = 0; i < rptTpl.指标_数据_映射[DETAIL_FIELD_STR].length; i++) {
  27. let dtlFieldObj = rptTpl.指标_数据_映射[DETAIL_FIELD_STR][i];
  28. if (jpc_common_helper.getBoolean(dtlFieldObj.isID)) {
  29. detailIDs.push({ "idx": i, "seq": dtlFieldObj.IDSeq });
  30. }
  31. }
  32. }
  33. //2. sort the ID fields
  34. if (masterIDs.length > 1) {
  35. masterIDs.sort(function (a, b) {
  36. return 1 * a["seq"] - 1 * b["seq"];
  37. })
  38. }
  39. if (detailIDs.length > 1) {
  40. detailIDs.sort(function (a, b) {
  41. return 1 * a["seq"] - 1 * b["seq"];
  42. })
  43. }
  44. //3. prepare data sequence
  45. if (masterIDs.length > 0) {
  46. let mst_dt_len = 0, dtl_dt_len = 0, mst_fields = [];
  47. for (let i = 0; i < masterIDs.length; i++) {
  48. mst_fields.push(dataObj[MASTER_DATA_STR][masterIDs[i]["idx"]]);
  49. mst_dt_len = dataObj[MASTER_DATA_STR][masterIDs[i]["idx"]].length;
  50. }
  51. let dtl_fields = [];
  52. for (let i = 0; i < detailIDs.length; i++) {
  53. dtl_fields.push(dataObj[DETAIL_DATA_STR][detailIDs[i]["idx"]]);
  54. dtl_dt_len = dataObj[DETAIL_DATA_STR][detailIDs[i]["idx"]].length;
  55. }
  56. let sIdx = 0;
  57. let isEqual = true;
  58. for (let i = 0; i < mst_dt_len; i++) {
  59. dataSeqArr.push([]);
  60. //then compare the master/detail ID-field value
  61. for (let j = sIdx; j < dtl_dt_len; j++) {
  62. isEqual = true;
  63. for (let k = 0; k < mst_fields.length; k++) {
  64. if (!(mst_fields[k][i] === dtl_fields[k][j])) {
  65. isEqual = false;
  66. break;
  67. }
  68. }
  69. if (isEqual) {
  70. dataSeqArr[i].push(j);
  71. } else {
  72. sIdx = j;
  73. //below logic is for the data robustness purpose, to avoid those strange record(detail level) which could not match even one of the master record!
  74. if (i < mst_dt_len - 1 && j < dtl_dt_len - 1) {
  75. for (let j1 = j; j1 < dtl_dt_len; j1++) {
  76. isEqual = true;
  77. for (let k = 0; k < mst_fields.length; k++) {
  78. if (!(mst_fields[k][i + 1] === dtl_fields[k][j1])) {
  79. isEqual = false;
  80. break;
  81. }
  82. }
  83. if (isEqual) {
  84. sIdx = j1;
  85. break;
  86. }
  87. }
  88. }
  89. break;
  90. }
  91. }
  92. }
  93. } else { //if no master data
  94. if (dataObj && dataObj[DETAIL_DATA_STR] && dataObj[DETAIL_DATA_STR].length > 0) {
  95. //may be bill type report which may only have discrete fields!
  96. let field = dataObj[DETAIL_DATA_STR][0];
  97. dataSeqArr.push([]);
  98. for (let i = 0; i < field.length; i++) {
  99. dataSeqArr[0].push(i);
  100. }
  101. }
  102. }
  103. };
  104. if ((rptTpl) && (dataObj)) {
  105. _analyse('主数据指标_集合', '从数据指标_集合', IDataObjProps.master_data, IDataObjProps.detail_data, me.dataSeq);
  106. if (rptTpl.流水式表_拓展信息) {
  107. _analyse('主数据指标_拓展集合', '从数据指标_拓展集合', IDataObjProps.master_data_ex, IDataObjProps.detail_data_ex, me.exDataSeq);
  108. }
  109. }
  110. }
  111. };
  112. return JpcDataRst;
  113. }
  114. };
  115. export default JpcData;