【jQwidgets】千分位

左手的ㄟ右手 2022-08-06 17:28 219阅读 0赞

/**
     * grid column cell 金额千分号格式化
     * @param row
     * @param columnfield
     * @param value
     * @param defaulthtml
     * @param columnproperties
     * @param rowdata
     * @returns {String}
     */
    function decimalcellsrenderer(row, columnfield, value, defaulthtml, columnproperties, rowdata) { 
            if(value!=""&&value!=null)
            {
                     var num = value + "";
                     num = num.toString().replace(/\$|\,/g,'');  
                    // 获取符号(正/负数)   
                    sign = (num == (num = Math.abs(num)));    
                    // 把指定的小数位先转换成整数.多余的小数位四舍五入  
                    num = Math.floor(num*Math.pow(10,2)+0.50000000001); 
                    // 求出小数位数值                   
                    cents = num%Math.pow(10,2);  
                    // 求出整数位数值                   
                    num = Math.floor(num/Math.pow(10,2)).toString();  
                    // 把小数位转换成字符串,以便求小数位长度                  
                    cents = cents.toString();               
                    // 补足小数位到指定的位数   
                    while(cents.length<2)  
                    cents = "0" + cents;  
                    // 对整数部分进行千分位格式化.   
                    for (var i = 0; i < Math.floor((num.length-(1+i))/3); i++)  
                    num = num.substring(0,num.length-(4*i+3))+','+ num.substring(num.length-(4*i+3));  
                    
                    return '<div class="cellclass">'+(((sign)?'':'-') + num + '.' + cents)+'</div>';  
            }
            else{
                    if(value=='0'){
                            return '<div class="cellclass">'+'0.00'+'</div>';
                    }else{
                        return '<div class="cellclass">'+value+'</div>';
                    }
            }
            
    };
    /**
     * 显示金额千分号格式化
     * @param value
     * @returns
     */
    function decimalcell(value) { 
            if(value!=""&&value!=null)
            {
                     var num = value + "";
                     num = num.toString().replace(/\$|\,/g,'');  
                    // 获取符号(正/负数)   
                    sign = (num == (num = Math.abs(num)));    
                    // 把指定的小数位先转换成整数.多余的小数位四舍五入  
                    num = Math.floor(num*Math.pow(10,2)+0.50000000001); 
                    // 求出小数位数值                   
                    cents = num%Math.pow(10,2);  
                    // 求出整数位数值                   
                    num = Math.floor(num/Math.pow(10,2)).toString();  
                    // 把小数位转换成字符串,以便求小数位长度                  
                    cents = cents.toString();               
                    // 补足小数位到指定的位数   
                    while(cents.length<2)  
                    cents = "0" + cents;  
                    // 对整数部分进行千分位格式化.   
                    for (var i = 0; i < Math.floor((num.length-(1+i))/3); i++)  
                    num = num.substring(0,num.length-(4*i+3))+','+ num.substring(num.length-(4*i+3));  
                    return (((sign)?'':'-') + num + '.' + cents);  
            }
            else{
                    if(value=='0'){
                            return '0.00';
                    }else{
                        return value;
                    }
            }
            
    };
    /**
     * grid column cell 金额千分号格式化,补足小数点后6位
     * @param row
     * @param columnfield
     * @param value
     * @param defaulthtml
     * @param columnproperties
     * @param rowdata
     * @returns {String}
     */
    function decimal6cell(value) { 
            if(value!=""&&value!=null)
            {  
                     var num = value + "";
                     num = num.toString().replace(/\$|\,/g,'');  
                    // 获取符号(正/负数)   
                    sign = (num == (num = Math.abs(num)));    
                    // 把指定的小数位先转换成整数.多余的小数位四舍五入  
                    num = Math.floor(num*Math.pow(10,6)+0.50000000001); 
                    // 求出小数位数值                   
                    cents = num%Math.pow(10,6);  
                    
                    // 求出整数位数值                   
                    num = Math.floor(num/Math.pow(10,6)).toString();  
                    // 把小数位转换成字符串,以便求小数位长度                  
                    cents = cents.toString();   
                    
                    // 补足小数位到指定的位数   
                    while(cents.length<6)  
                    cents = "0" + cents; 
                      // 对整数部分进行千分位格式化.   
                    for (var i = 0; i < Math.floor((num.length-(1+i))/3); i++)  
                    num = num.substring(0,num.length-(4*i+3))+','+ num.substring(num.length-(4*i+3));  
                    
                    return (((sign)?'':'-') + num + '.' + cents);  
            }
            else{
                    if(value=='0'){
                            return '0.000000';
                    }else{
                        return value;
                    }
            }
            
    };
    /**
     * 整数类型千分号格式化
     * @param value
     * @returns
     */
    function numbercell(value) { 
            if(value!=""&&value!=null)
            {
                     var num = value + "";
                     num = num.replace(new RegExp(",","g"),"");
                     // 正负号处理
                     var symble = "";
                     if(/^([-+]).*$/.test(num)) {
                             symble = num.replace(/^([-+]).*$/,"$1");
                             num = num.replace(/^([-+])(.*)$/,"$2");
                     }
                     if(/^[0-9]+(\.[0-9]+)?$/.test(num)) {
                             var num = num.replace(new RegExp("^[0]+","g"),"");
                             if(/^\./.test(num)) {
                             num = "0" + num;
                             }
                             var decimal = num.replace(/^[0-9]+(\.[0-9]+)?$/,"$1");
                             var integer= num.replace(/^([0-9]+)(\.[0-9]+)?$/,"$1");
                             var re=/(\d+)(\d{3})/;
                             while(re.test(integer)){
                                     integer = integer.replace(re,"$1,$2");
                             }
                             
                            return symble + integer+decimal;
                     } else {
                            return value;
                     }
            }
            else
                        return value;
            
            
    };

format: {
        // this.$Utils.format.formatMoney(num)
        formatMoney: function (num) {
          num = num.toString()
          if (isNaN(num)) {
            num = '0'
          }
          let sign = false
          if (num.indexOf('-') > -1) {
            sign = true
            num = num.replace(/-/g, '')
          } else {
            sign = false
          }
          num = Math.floor(num * Math.pow(10, 2) + 0.50000000001)
          let cents = num % Math.pow(10, 2)
          num = Math.floor(num / Math.pow(10, 2)).toString()
          cents = cents.toString()
          while (cents.length < 2) {
            cents = '0' + cents
          }
          for (var i = 0; i < Math.floor((num.length - (1 + i)) / 3); i++) {
            num = num.substring(0, num.length - (4 * i + 3)) + ',' + num.substring(num.length - (4 * i + 3))
          }
          return (((sign) ? '-' : '') + num + '.' + cents)
        }
      },