insertRowsIntoSpace

最新推荐文章于 2022-12-15 11:41:09 发布

Tane_1018

最新推荐文章于 2022-12-15 11:41:09 发布

阅读量350

点赞数

分类专栏： js

本文链接：https://blog.csdn.net/Tane_1018/article/details/75371184

版权

js 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

function insertRowsIntoSpace(colnames,data,num){
	var table = document.getElementById(tablename);
	var fpzs=0;
	var ylfy=0;
	var grfd=0;
	var zfze=0;
	var fhbz=0;
	var bzje=0;
	var bxje_ndlj=0;
    for(var m=0;m<Math.ceil(num);m++){
    	var tablename = "tbody"+m;
	    var table = document.getElementById(tablename);
	    if(m!=Math.ceil(num-1)){
	    for(var i=0;i<20;i+=1){
		    var row = document.createElement("tr");
		    for(var j=0;j<colnames.length;j+=1){
			    var cell = document.createElement("td");
			    var key = colnames[j];
			    if(key=="sfzh"){
			        var sfzh = data[20*m+i][key];    
			        if(sfzh.length==15)
			            var value=sfzh.substr(0,6)+"XXXXXX"+sfzh.substr(12,3);
			        else if(sfzh.leng==18)
			            var value=sfzh.substr(0,6)+"XXXXXXXX"+sfzh.substr(14,4);
			        else if(sfzh.length==10)
			            var value=sfzh.substr(0,6)+"XXXX";
			        else
			            var value=sfzh.substr(0,6)+"XXXXXXXX"+sfzh.substr(14,sfzh.length-8);	
			    }
			    else
				    var value = data[20*m+i][key];
			    if(key == 'qs'){
			    	//var value='-';
			    	cell.innerHTML=' ';
			    }else{
			    cell.appendChild(document.createTextNode(value));
			    }
				row.appendChild(cell);
		    }
		table.appendChild(row);
	    }	
	    }
		else{    
	    for(var i=(Math.ceil(num-1))*20;i<data.length;i++){
		    var row = document.createElement("tr");
		    for(var j=0;j<colnames.length;j+=1){
			    var cell = document.createElement("td");
			    var key = colnames[j];
                if(key=="sfzh"){
			        var sfzh = data[i][key];    
			        if(sfzh.length==15)
			            var value=sfzh.substr(0,6)+"XXXXXX"+sfzh.substr(12,3);
			        else if(sfzh.leng==18)
			            var value=sfzh.substr(0,6)+"XXXXXXXX"+sfzh.substr(14,4);
			        else if(sfzh.length==10)
			            var value=sfzh.substr(0,6)+"XXXX";
			        else
			            var value=sfzh.substr(0,6)+"XXXXXXXX"+sfzh.substr(14,sfzh.length-8);	
			    }
			    else
				    var value = data[i][key];	
                if(key == 'qs'){
			    	//var value='-';
			    	cell.innerHTML=' ';
			    }else{
			    cell.appendChild(document.createTextNode(value));
			    }
				row.appendChild(cell);
		    }	
		table.appendChild(row);	     	  
		}	
		}	
    }				    	 	    	

	for(var i=0;i<data.length;i+=1){
	    var value1 = data[i]["fpzs"];
	    var value2 = data[i]["ylfyze_hj"];
	    var value3 = data[i]["grfdze"];
	    var value4 = data[i]["zfze_hj"];
	    var value5 = data[i]["fhbxfy"];
	    var value6 = data[i]["bxje"];
	    var value7 = data[i]["bxje_ndlj"];
	    if(value1!="-"){
	        var value1_0=Number(value1);
	        fpzs+=value1_0; 
	    }
	    var value2_0=Number(value2);
	    var value3_0=Number(value3);
	    var value4_0=Number(value4);
	    var value5_0=Number(value5);
	    var value6_0=Number(value6);
	    var value7_0=Number(value7);
	    ylfy+=value2_0; 
	    grfd+=value3_0; 
	    zfze+=value4_0; 
	    fhbz+=value5_0; 
	    bzje+=value6_0;   
	    bxje_ndlj += value7_0;
	}
	$("#rszj").html("人数："+data.length+"人");
	$("#fpzj").html(fpzs);
	$("#ylfy").html(ylfy.toFixed(2));
	$("#grfd").html(grfd.toFixed(2));
	$("#zfze").html(zfze.toFixed(2));
	$("#fhbz").html(fhbz.toFixed(2));
	$("#bzje").html(bzje.toFixed(2));
	$("#lcbz").html(bxje_ndlj.toFixed(2));
}