jpc_helper_field.js 7.4 KB

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