scMathUtil.js 7.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217
  1. /**
  2. * Created by jimiz on 2017/3/28.
  3. * 经验证:10000次四舍五入,用num.toFixed为15毫秒,用roundTo为47毫秒,速度低一些,但可以接受
  4. * 另:经手工验证,用num.toString(2)将十进制浮点数转换为二进制浮点数时,最后一位有错误的情况出现,例子(10.0311)
  5. *
  6. * zhangyin 2018-02-28
  7. * 采用重复一次四舍五入解决浮点精度误差后,10000次roundTo的时间为94毫秒。
  8. */
  9. let scMathUtil = {
  10. innerRoundTo: function(num, digit){
  11. let lFactor = Math.pow(10, digit);
  12. let fOffSet = 0.5;
  13. let sign = '';
  14. // 处理符号
  15. if (num < 0){
  16. sign = '-';
  17. num = Math.abs(num);
  18. }
  19. // 计算
  20. let result = Math.floor((num / lFactor) + fOffSet).toString();
  21. let iLength = result.length;
  22. // 因为数值被转为整数计算,当目标位数在小数点后,且数值小于0,需要补齐前面的位数
  23. if (iLength < -digit){
  24. result = this.zeroString(-digit) + result;
  25. }
  26. // 当目标位数在小数点前,需要补齐后面的位数
  27. else if ((digit > 0) && (iLength < digit)){
  28. result = result + this.zeroString(digit);
  29. }
  30. iLength = result.length;
  31. // 获得小数点前的数字
  32. let r1 = result.substring(0, iLength + digit);
  33. // 获得小数点后的数字
  34. let r2 = result.substring(iLength + digit, iLength);
  35. // 拼出完整结果
  36. return Number(sign + r1 + '.' + r2);
  37. },
  38. // 原来直接用num.toString(2),如果小数段最后位数是0,会被舍掉,导致进位计算bug
  39. // 改为自己计算二进制,固定为53位。
  40. // 经验证速度没有差别
  41. // 另:经手工验证,用num.toString(2)将十进制浮点数转换为二进制浮点数时,最后一位有错误的情况出现,例子(10.0311)
  42. floatToBin: function(num) {
  43. let sign = '';
  44. let dNum = num;
  45. // 符号位
  46. if (num < 0) {
  47. sign = '-';
  48. dNum = -num;
  49. };
  50. // 解析整数段
  51. let iNum = Math.floor(dNum);
  52. let iFactor;
  53. let sResult1 = '';
  54. // 计算二进制整数段
  55. while (iNum > 0){
  56. iFactor = iNum % 2;
  57. iNum = Math.floor(iNum / 2);
  58. sResult1 = iFactor + sResult1;
  59. }
  60. // 判断是否有整数段
  61. let bIntZero = sResult1 === '';
  62. if (bIntZero){
  63. sResult1 = '0';
  64. }
  65. // 解析小数段
  66. let fNum = dNum - Math.floor(dNum);
  67. let sResult2 = '';
  68. if (fNum > 0){
  69. // 双精度浮点数,尾数总长52位,因为第一位总是1,存储时已经被隐藏,所以有效位数为53位
  70. const floatLength = 53;
  71. let iLength;
  72. // js的bug,浮点数直接取小数可能不能获得精确值,只有转成字符串,截取字符串中的小数段
  73. let sNum = dNum.toString(10);
  74. let iDot = sNum.indexOf('.');
  75. sNum = '0' + sNum.substring(iDot, sNum.length);
  76. fNum = Number(sNum);
  77. // 有整数段,则小数位数为全部位数-整数位数
  78. if (!bIntZero){
  79. iLength = floatLength - sResult1.length;
  80. }
  81. else{
  82. iLength = floatLength;
  83. }
  84. // 计算二进制小数段
  85. while (iLength > 0){
  86. fNum = fNum * 2;
  87. iFactor = Math.floor(fNum);
  88. fNum = fNum % 1;
  89. sResult2 = sResult2 + iFactor;
  90. if (iFactor > 0){
  91. bIntZero = false;
  92. }
  93. if (bIntZero && (iFactor === 0)){
  94. continue;
  95. }
  96. iLength--;
  97. }
  98. }
  99. return sign + sResult1 + '.' + sResult2;
  100. },
  101. binToFloat: function(bin) {
  102. let result = 0;
  103. let iLength = bin.length;
  104. let sign = '';
  105. if (iLength > 0 && bin[0]==='-'){
  106. sign = '-';
  107. bin = bin.substring(1, iLength);
  108. }
  109. iLength = bin.length;
  110. let iDot = bin.indexOf('.');
  111. if (iDot >= 0) {
  112. for (let i = 0; i < iLength; i++) {
  113. let num = Number(bin[i]);
  114. let idx = iDot - i;
  115. if (idx === 0) {
  116. continue
  117. };
  118. if (idx > 0) {
  119. idx -= 1
  120. };
  121. let r = Math.pow(2, idx);
  122. result += num * r;
  123. }
  124. }
  125. else {
  126. result = parseInt(bin, 2);
  127. };
  128. return sign + result;
  129. },
  130. zeroString: function(length){
  131. let result = '';
  132. for (let i = 0; i < length; i++){
  133. result = result + '0';
  134. };
  135. return result;
  136. },
  137. incMantissa: function(bin){
  138. let result = bin;
  139. let iDot = bin.indexOf('.');
  140. if (iDot < 0){return result};
  141. let iLength = bin.length;
  142. iLength = bin.length;
  143. for (let i = iLength - 1; i > iDot; i--){
  144. let num = Number(bin[i]);
  145. if (num === 0){
  146. num = 1;
  147. let bin1 = bin.substring(0, i);
  148. let bin2 = this.zeroString(iLength - (i + 1));//bin.substring(i + 1, iLength);
  149. result = bin1 + num.toString() + bin2;
  150. break;
  151. }
  152. };
  153. return result;
  154. },
  155. reRoundTo: function(num, digit){
  156. let me = this;
  157. return me.innerRoundTo(me.binToFloat(me.incMantissa(me.floatToBin(num))), digit);
  158. },
  159. // zhangyin 2018-02-28
  160. // 经过运算后的浮点数,误差可能更大,加尾数也不能消除。目前采用笨办法,将有效位数加一位再四舍五入一次,以消除浮点误差。
  161. // 此办法效率较低,没有别的更好办法时暂时用着
  162. roundTo: function(num, digit){
  163. let me = this;
  164. return me.reRoundTo(me.reRoundTo(num, digit - 1), digit);
  165. },
  166. isNumber : function (obj) {
  167. return obj === +obj;
  168. },
  169. roundForObj:function(obj,decimal){
  170. let me = this;
  171. let value;
  172. if(me.isNumber(obj)){
  173. value = me.roundTo(obj,-decimal)
  174. }else {
  175. value = me.roundTo(Number(obj),-decimal);
  176. }
  177. return value
  178. },
  179. roundToString:function(obj,decimal){
  180. let me = this;
  181. let value;
  182. if(me.isNumber(obj)){
  183. value = me.roundTo(obj,-decimal)
  184. }else {
  185. value = me.roundTo(Number(obj),-decimal);
  186. }
  187. return value.toFixed(decimal);
  188. },
  189. isNumOrFormula:function (text) {
  190. let value = Number(text);
  191. if (!value) {
  192. try {
  193. let exp = new Expression('');
  194. exp.Expression(text);
  195. value = Number(exp.Evaluate());
  196. } catch (error) {
  197. value = null;
  198. }
  199. }
  200. if(text==null||text==""){
  201. value = null;
  202. }
  203. return value;
  204. }
  205. };
  206. Number.prototype.toDecimal = function (ADigit) {
  207. //return parseFloat(this.toFixed(ADigit));
  208. digit = ((ADigit!=null||ADigit!=undefined) && typeof(ADigit) === 'number' && Number.isInteger(ADigit) && ADigit >= 0) ? -ADigit : -2;
  209. // var s = scMathUtil.roundTo(this, digit);
  210. // console.log('Number: ' + this + ' Digit: ' + digit + ' Result: ' + s);
  211. // return parseFloat(s);
  212. return scMathUtil.roundTo(this, digit);
  213. };