jpc_helper_field.js 7.7 KB

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