JS 二维数组排序输出HTML
1code
var shop_data=JSON.parse('php json_Data');	
function number_format(number,bit,sign,gapnum){
        //设置接收参数的默认值
        var bit    = arguments[1] ? arguments[1] : 2 ;
        var sign   = arguments[2] ? arguments[2] : ',' ;
        var gapnum = arguments[3] ? arguments[3] : 3 ;
        var str    = '' ;
		number=parseFloat(number);
        number     = number.toFixed(bit);//格式化
        realnum    = number.split('.')[0];//整数位(使用小数点分割整数和小数部分)
        decimal    = number.split('.')[1];//小数位
        realnumarr = realnum.split('');//将整数位逐位放进数组 ["1", "2", "3", "4", "5", "6"]
        
        //把整数部分从右往左拼接,每bit位添加一个sign符号
        for(var i=1;i<=realnumarr.length;i++){
            str = realnumarr[realnumarr.length-i] + str ;
            if(i%gapnum == 0){
                str = sign+str;//每隔gapnum位前面加指定符号
            }
        }      
        //当遇到 gapnum 的倍数的时候,会出现比如 ",123",这种情况,所以要去掉最前面的 sign
        str = (realnum.length%gapnum==0) ? str.substr(1) : str;
        //重新拼接实数部分和小数位
        realnum = str+'.'+decimal;
        return realnum;
}	
function sortNumber(a,b){return a - b}		

//二维数组按字段排序
function monxin_array_sort(arr, field){
	newa=new Array();
	newr=new Array();
	for(i in arr){
		if(newa.indexOf(arr[i][field])==-1){newa.push(arr[i][field]);}
	}
	newa.sort(sortNumber);
	for(ii in newa){
		for(i in arr){
			if(arr[i][field]==newa[ii]){newr.push(arr[i]);}			
		}
	}
	return newr;
}		
		
function shop_data_html(arr,order){
	list='';
	for(i in arr){
		
		v=arr[i];
		//console.log(v); 
		line='<tr><td><div class=shop_name>'+v['shop_name']+'</div>'+v['date']+'<div class=update_time>'+v['update_time']+'</div></td><td class=xh>'+number_format(v['xh'],2)+'</td><td class=zscs>'+number_format(v['zscs'])+'</td><td class=djcs>'+number_format(v['djcs'])+'</td><td class=djl>'+number_format(v['djl'],2)+'%</td><td class=qczsfy>'+number_format(v['qczsfy'],2)+'</td><td class=cjdds>'+number_format(v['cjdds'])+'</td><td class=cjddje>'+number_format(v['cjddje'],2)+'</td><td class=xddds>'+number_format(v['xddds'])+'</td><td class=xdddje>'+number_format(v['xdddje'],2)+'</td><td class=cjroi>'+number_format(v['cjroi'],2)+'</td><td class=xdroi>'+number_format(v['xdroi'],2)+'</td><td class=xzfss>'+number_format(v['xzfss'])+'</td></tr>';
		if(order=='desc'){
			list=line+list;
		}else{
			list+=line;
		}
		
	}
	//console.log(list);
	$("#<?php echo $module['module_name'];?>_table tbody").html(list);
	//console.log($("#<?php echo $module['module_name'];?>_table tbody").html());
}		
    $(document).ready(function(){
		
		new_shop_data = monxin_array_sort(shop_data, 'xh');
		shop_data_html(new_shop_data,'desc'); 
		$("thead td a[desc]:eq(0)").attr('class','sorting sorting_desc');
		 $("thead td a").unbind();
		$("thead td a[desc]").click(function(){
			//alert('125');return false;
			console.log($(this).attr('class'));
			if($(this).attr('class').indexOf('sorting_desc')==-1){
				tt=$(this).attr('desc');
				tt=tt.split('|');
				new_shop_data = monxin_array_sort(shop_data, tt[0]);
				shop_data_html(new_shop_data,'desc'); 	
				$("thead td a[desc]").removeClass('sorting_desc');
				$("thead td a[desc]").removeClass('sorting_asc');
				$(this).attr('class','sorting sorting_desc');
			}else{
				tt=$(this).attr('desc');
				tt=tt.split('|');
				new_shop_data = monxin_array_sort(shop_data, tt[0]);
				shop_data_html(new_shop_data,'asc'); 	
				$("thead td a[desc]").removeClass('sorting_desc');
				$("thead td a[desc]").removeClass('sorting_asc');
				$(this).attr('class','sorting sorting_asc');
			}
			
			return false;
		});
		
本页由《梦行文档》生成

 

name完成
30