jpc_helper_field.js 7.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158
  1. let JV = require('../jpc_value_define');
  2. let JpcFieldHelper = {
  3. getValue: function(dataField, valueIdx) {
  4. let rst = "";
  5. if (dataField && (dataField.length > valueIdx) && (valueIdx >= 0)) {
  6. rst = dataField[valueIdx];
  7. }
  8. return rst;
  9. },
  10. setValue: function(dataField, valueIdx, newValue) {
  11. if (dataField && (dataField.length > valueIdx) && (valueIdx >= 0)) {
  12. dataField[valueIdx] = newValue;
  13. }
  14. },
  15. resetSumFormat: function(ref_tab_fields, sum_tab_field) {
  16. let rst = false;
  17. if (ref_tab_fields && ref_tab_fields.length > 0) {
  18. for (let tab_field of ref_tab_fields) {
  19. if (tab_field[JV.PROP_FIELD_ID] === sum_tab_field[JV.PROP_FIELD_ID]) {
  20. rst = true;
  21. if (tab_field[JV.PROP_FORMAT]) {
  22. sum_tab_field[JV.PROP_FORMAT] = tab_field[JV.PROP_FORMAT];
  23. }
  24. break;
  25. }
  26. }
  27. }
  28. return rst;
  29. },
  30. resetFormat: function (tab_field, map_field, customizeCfg) {
  31. let rst = false;
  32. if (map_field && map_field[JV.PROP_PRECISION] && map_field[JV.PROP_PRECISION].type === "fixed") {
  33. let formatStrs = ["#"], ffStr = (customizeCfg && customizeCfg.fillZero)?"0":"#";
  34. for (let idx = 0; idx < parseInt(map_field[JV.PROP_FIXED_PRECISION_AMT]); idx++) {
  35. if (idx === 0) {
  36. formatStrs.push(".");
  37. }
  38. formatStrs.push(ffStr);
  39. }
  40. if (tab_field[JV.PROP_FORMAT] && tab_field[JV.PROP_FORMAT].indexOf(",") >= 0) {
  41. tab_field[JV.PROP_FORMAT] = "," + formatStrs.join("");
  42. } else {
  43. tab_field[JV.PROP_FORMAT] = formatStrs.join("");
  44. }
  45. map_field[JV.PROP_FORMAT] = tab_field[JV.PROP_FORMAT]; //这里顺手把format也赋给map_field,后期统计用得着
  46. rst = true;
  47. }
  48. return rst;
  49. },
  50. resetFlexibleFormat: function (tab_field, ref_field_data, flexiblePrecisionRefObj, valueIdx, customizeCfg) {
  51. let precisionAmt = 2;
  52. if (ref_field_data && flexiblePrecisionRefObj && valueIdx >= 0) {
  53. precisionAmt = flexiblePrecisionRefObj["refUnit_" + ref_field_data[valueIdx]];
  54. if (precisionAmt === null || precisionAmt === undefined) precisionAmt = flexiblePrecisionRefObj["refUnit_其他未列单位"];
  55. }
  56. let formatStrs = ["#."], ffStr = (customizeCfg && customizeCfg.fillZero)?"0":"#";
  57. for (let idx = 0; idx < precisionAmt; idx++) {
  58. formatStrs.push(ffStr);
  59. }
  60. if (tab_field[JV.PROP_FORMAT] && tab_field[JV.PROP_FORMAT].indexOf(",") >= 0) {
  61. tab_field[JV.PROP_FORMAT] = "," + formatStrs.join("");
  62. } else {
  63. tab_field[JV.PROP_FORMAT] = formatStrs.join("");
  64. }
  65. },
  66. decorateValue: function (cell, controls) {
  67. if (controls) {
  68. const showZero = controls[cell[JV.PROP_CONTROL]][JV.PROP_SHOW_ZERO];
  69. if (showZero && showZero === 'F') {
  70. const val = parseFloat(cell[JV.PROP_VALUE]);
  71. if (val === 0) {
  72. let chkRst = true;
  73. if (typeof cell[JV.PROP_VALUE] === 'string' && cell[JV.PROP_VALUE].length > 1) {
  74. for (let idx = 0; idx < cell[JV.PROP_VALUE].length; idx++) {
  75. if (cell[JV.PROP_VALUE][idx] !== '0' && cell[JV.PROP_VALUE][idx] !== '.') {
  76. chkRst = false;
  77. break;
  78. }
  79. }
  80. }
  81. if (chkRst) cell[JV.PROP_VALUE] = '';
  82. }
  83. }
  84. }
  85. },
  86. findAndPutDataFieldIdx: function (rptTpl, tab_fields, rstFields, rstFieldsIdx, isEx) {
  87. //通过FieldID找到相关映射指标的位置IDX并记录下来,方便后续引用
  88. if (tab_fields) {
  89. let DTL_STR = isEx?JV.NODE_DETAIL_FIELDS_EX:JV.NODE_DETAIL_FIELDS;
  90. let detail_fields = rptTpl[JV.NODE_FIELD_MAP][DTL_STR];
  91. for (let i = 0; i < tab_fields.length; i++) {
  92. let isFounded = false;
  93. for (let j = 0; j < detail_fields.length; j++) {
  94. if (tab_fields[i]["FieldID"] === detail_fields[j]["ID"]) {
  95. isFounded = true;
  96. if (rstFields) rstFields.push(tab_fields[i]);
  97. if (rstFieldsIdx) rstFieldsIdx.push(j);
  98. break;
  99. }
  100. }
  101. if (!isFounded) {
  102. if (rstFields) rstFields.push(tab_fields[i]);
  103. if (rstFieldsIdx) {
  104. if (rptTpl[JV.NODE_NO_MAPPING_FIELDS] && rptTpl[JV.NODE_NO_MAPPING_FIELDS].length > 0) {
  105. for (let discretField of rptTpl[JV.NODE_NO_MAPPING_FIELDS]) {
  106. if (discretField[JV.PROP_ID] === tab_fields[i]["FieldID"]) {
  107. rstFieldsIdx.push(discretField);
  108. isFounded = true;
  109. break;
  110. }
  111. }
  112. } else {
  113. rstFieldsIdx.push(JV.BLANK_FIELD_INDEX);
  114. }
  115. }
  116. }
  117. }
  118. }
  119. },
  120. findAutoHeightFieldIdx: function(rptTpl, tab_fields, rstFieldsIdx, isEx) {
  121. if (tab_fields) {
  122. let DTL_STR = isEx?JV.NODE_DETAIL_FIELDS_EX:JV.NODE_DETAIL_FIELDS;
  123. let detail_fields = rptTpl[JV.NODE_FIELD_MAP][DTL_STR];
  124. for (let i = 0; i < tab_fields.length; i++) {
  125. if (tab_fields[i][JV.PROP_IS_AUTO_HEIGHT]) {
  126. for (let j = 0; j < detail_fields.length; j++) {
  127. if (tab_fields[i]["FieldID"] === detail_fields[j]["ID"]) {
  128. let item = [];
  129. item[0] = j;
  130. item[1] = tab_fields[i];
  131. rstFieldsIdx.push(item);
  132. break;
  133. }
  134. }
  135. }
  136. }
  137. if (!isEx) {
  138. let dis_detail_fields = rptTpl[JV.NODE_NO_MAPPING_FIELDS];
  139. for (let i = 0; i < tab_fields.length; i++) {
  140. if (tab_fields[i][JV.PROP_IS_AUTO_HEIGHT]) {
  141. for (let j = 0; j < dis_detail_fields.length; j++) {
  142. if (tab_fields[i]["FieldID"] === dis_detail_fields[j]["ID"]) {
  143. let item = [];
  144. item[0] = JV.BLANK_FIELD_INDEX;
  145. item[1] = tab_fields[i];
  146. rstFieldsIdx.push(item);
  147. break;
  148. }
  149. }
  150. }
  151. }
  152. }
  153. }
  154. }
  155. };
  156. module.exports = JpcFieldHelper;