jpc_helper_common_output.js 3.7 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485
  1. let JV = require('../jpc_value_define');
  2. let JpcFieldHelper = require('./jpc_helper_field');
  3. const OFFSET_FLOAT = 0.0000000001;
  4. let JpcCommonOutputHelper = {
  5. createCommonOutputWithoutDecorate: function (node, value, forceCombine) {
  6. let me = this, rst = {};
  7. //1. font/style/control
  8. rst[JV.PROP_FONT] = node[[JV.PROP_FONT]];
  9. rst[JV.PROP_CONTROL] = node[[JV.PROP_CONTROL]];
  10. rst[JV.PROP_STYLE] = node[[JV.PROP_STYLE]];
  11. //2. value
  12. rst[JV.PROP_VALUE] = value;
  13. me.formatCell(node[JV.PROP_FORMAT], rst);
  14. // innerFormat(node[JV.PROP_FORMAT], rst);
  15. if (node[JV.PROP_PREFIX] && rst[JV.PROP_VALUE] !== null) {
  16. rst[JV.PROP_VALUE] = node[JV.PROP_PREFIX] + rst[JV.PROP_VALUE];
  17. } else if (node[JV.PROP_PREFIX] && forceCombine) {
  18. rst[JV.PROP_VALUE] = node[JV.PROP_PREFIX];
  19. }
  20. if (node[JV.PROP_SUFFIX] && rst[JV.PROP_VALUE] !== null) {
  21. rst[JV.PROP_VALUE] = rst[JV.PROP_VALUE] + node[JV.PROP_SUFFIX];
  22. } else if (node[JV.PROP_SUFFIX] && forceCombine) {
  23. rst[JV.PROP_VALUE] = node[JV.PROP_SUFFIX];
  24. }
  25. return rst;
  26. },
  27. createCommonOutput: function (node, value, controls) {
  28. let me = this, rst = {};
  29. //1. font/style/control
  30. rst[JV.PROP_FONT] = node[[JV.PROP_FONT]];
  31. rst[JV.PROP_CONTROL] = node[[JV.PROP_CONTROL]];
  32. rst[JV.PROP_STYLE] = node[[JV.PROP_STYLE]];
  33. //2. value
  34. rst[JV.PROP_VALUE] = value;
  35. JpcFieldHelper.decorateValue(rst, controls);
  36. me.formatCell(node[JV.PROP_FORMAT], rst);
  37. // innerFormat(node[JV.PROP_FORMAT], rst);
  38. if (node[JV.PROP_PREFIX] && rst[JV.PROP_VALUE] !== null && rst[JV.PROP_VALUE] !== "") {
  39. rst[JV.PROP_VALUE] = node[JV.PROP_PREFIX] + rst[JV.PROP_VALUE];
  40. }
  41. if (node[JV.PROP_SUFFIX] && rst[JV.PROP_VALUE] !== null && rst[JV.PROP_VALUE] !== "") {
  42. rst[JV.PROP_VALUE] = rst[JV.PROP_VALUE] + node[JV.PROP_SUFFIX];
  43. }
  44. return rst;
  45. },
  46. formatCell: function(formatStr, rstCell) {
  47. if (formatStr) {
  48. const rstCellFloatVal = parseFloat(rstCell[JV.PROP_VALUE]);
  49. if (!(isNaN(rstCellFloatVal))) {
  50. const dotIdx = formatStr.indexOf('.');
  51. if (dotIdx >= 0) {
  52. let tmpStr = (rstCellFloatVal + OFFSET_FLOAT).toFixed(formatStr.length - dotIdx - 1);
  53. const digStr = formatStr.substr(dotIdx + 1, formatStr.length - dotIdx);
  54. for (let sIdx = digStr.length - 1; sIdx >= 0; sIdx--) {
  55. if (digStr[sIdx] === '#') {
  56. if (tmpStr.length > 0 && tmpStr[tmpStr.length - 1] === '0') {
  57. tmpStr = tmpStr.substr(0, tmpStr.length - 1);
  58. } else {
  59. break;
  60. }
  61. } else {
  62. break;
  63. }
  64. }
  65. if (tmpStr[tmpStr.length - 1] === '.') tmpStr = tmpStr.substr(0, tmpStr.length - 1);
  66. rstCell[JV.PROP_VALUE] = tmpStr;
  67. } else {
  68. rstCell[JV.PROP_VALUE] = (rstCellFloatVal + OFFSET_FLOAT).toFixed(0);
  69. }
  70. const commaIdx = formatStr.indexOf(',');
  71. if (commaIdx >= 0) {
  72. rstCell[JV.PROP_VALUE] = comdify(rstCell[JV.PROP_VALUE].toString());
  73. }
  74. }
  75. }
  76. }
  77. };
  78. function comdify(numStr){
  79. let re = /\d{1,3}(?=(\d{3})+$)/g;
  80. return numStr.replace(/^(\d+)((\.\d+)?)$/,function(s,s1,s2){return s1.replace(re,"$&,")+s2;});
  81. }
  82. module.exports = JpcCommonOutputHelper;