VisualInspection/VisualInspection/js/statistics/assess_situation.js

        var lianyungang_Station = new Array;
        var yancheng_Station = new Array;
        var nantong_Station = new Array;
        var r1 = new Array();
        var r2 = new Array();
        var r3 = new Array();
        var rank = new Array();
function querySituationClick(){
    //每次点击前清空表格数据
    $(".table-tbody").empty('');
    var start_date = $("#start-time").val();
    var end_date = $("#end-time").val();
    if(start_date==null||start_date==''||start_date==undefined||end_date==null||end_date==''||end_date==undefined){
        tip("请选择起止日期");
                return ;
    }else{
        start_date += " 23:00:00";
        end_date += " 23:00:00";
    }
    var startStr = start_date.replace(/-/g, '/');
    var endStr = end_date.replace(/-/g, '/');
    var start = new Date(startStr);
    //开始日期取前一天的23:00
    start.setDate(start.getDate()-1);
    start_date = start.Format("yyyy-MM-dd HH:mm:ss");
    var end = new Date(endStr);
    if(start>end){
        tip("开始时间不能比结束时间大");
        return;
    }
    var param = {
        "dept_id": $("#fsList").val(),
        "start_date": start_date,
        "end_date": end_date,
    }
    var url = "statistics/score/info";
    var strTbody='';
    post_common_service( url,param,function(data){
        // 道管中心排名
        ranking_method(data);
            for(i=0;i<data.length;i++){
                $(".table-tbody").append(gethtml(data[i],i));
            }          
        },function(error){
                return "" ;
   });
}


function initQuerySituation(){
    //默认初始化前一周查所有
    var endD = new Date();
    var now = new Date();
    var startD = new Date(now.getTime() - 7 * 24 * 3600 * 1000);
    var start_time = startD.getFullYear()+"-"+(startD.getMonth()+1)+"-"+startD.getDate(); 
    var end_time = endD.getFullYear()+"-"+(endD.getMonth()+1)+"-"+endD.getDate(); 
    //默认初始化时间页面回显
    $("#start-time").val(start_time);
    $("#end-time").val(end_time);
    var start_date = start_time+" 23:00:00"; 
    var end_date = end_time+" 23:00:00"; 
    
    var start = new Date(start_date);
    //开始日期取前一天的23:00
    start.setDate(start.getDate()-1);
    start_date = start.Format("yyyy-MM-dd HH:mm:ss");
    var param = {
        "start_date": start_date,
        "end_date": end_date,
    }
    var url = "statistics/score/info";
    var strTbody='';
   
    post_common_service( url,param,function(data){
        // 道管中心排名
        ranking_method(data)
        for(i=0;i<data.length;i++){       
             $(".table-tbody").append(gethtml(data[i],i));
        }         
            },function(error){
                return "" ;
     });
    
}
/**
 * 道管中心排名
 * @param {*} data 
 */
function ranking_method(data){
        //清空数组
        lianyungang_Station.length=0;
        yancheng_Station.length=0;
        nantong_Station.length=0;
        r1.length=0;
        r2.length=0;
        r3.length=0;
        rank.length=0;
        // 把收费站得分分别添加到3个数组
        for(i=0;i<data.length;i++){
            if(i>=0 && i<=6)
            lianyungang_Station.push(filterByZeroHandle(filterJudge(data[i].all_check_score,data[i].checked_num),'0'));
            else if(i>6 && i<=12)
            yancheng_Station.push(filterByZeroHandle(filterJudge(data[i].all_check_score,data[i].checked_num),'0'));
            else
            nantong_Station.push(filterByZeroHandle(filterJudge(data[i].all_check_score,data[i].checked_num),'0'));
        }
        // 得分转化为3个排名数组
        for(var i=1;i<=3;i++){
            station_rank(i);
        }
        // 将3个排名数组合并成一个数组
        rank=r1.concat(r2).concat(r3);
}

function gethtml(data,i){
    var strTbody = "";
    if(i==0 || i==7 || i==13){
        var ranking;
        var name = "";
        var rowspan = 0;
        if(i==0){
            name = "连云港";
            rowspan = 7;
            ranking=rank[i];
        }else if(i==7){
            name = "盐城";
            rowspan = 6;
            ranking=rank[i];
        }else if(i==13){
            name = "南通";
            rowspan = 8;
            ranking=rank[i];
        }
                strTbody +="<tr><td rowspan="+rowspan+">"+name+"</td>";
                strTbody +="<td>"+ranking+"</td><td>"+data.name+"</td><td>"+filter(data.people_num,0)
                        +"</td><td>"+filter(data.checked_people_num,0)+"</td><td>"+filter(data.checked_num,0)
                        +"</td><td>"+(data.checked_people_num-(data.score_fifteen+data.score_fifty+data.score_over_fifty))
                        +"</td><td>"+data.score_fifteen+"</td><td>"+data.score_fifty+"</td><td>"
                        +data.score_over_fifty+"</td><td>"+data.all_check_score+"</td><td>"
                        +filterByZeroHandle(filterJudge(data.all_check_score,data.checked_num),'0')+"</td><td>"
                        +filterByZeroHandle((1000-filterJudge(data.all_check_score,data.checked_num)),'1000')+"</td>";
                strTbody += "</tr>";
       }else{
                strTbody +="<tr>"
                strTbody +="<td>"+rank[i]+"</td><td>"+data.name+"</td><td>"+filter(data.people_num,'0')
                        +"</td><td>"+filter(data.checked_people_num,0)+"</td><td>"+filter(data.checked_num,'0')
                        +"</td><td>"+(data.checked_people_num-(data.score_fifteen+data.score_fifty+data.score_over_fifty))
                        +"</td><td>"+data.score_fifteen+"</td><td>"+data.score_fifty+"</td><td>"
                        +data.score_over_fifty+"</td><td>"+data.all_check_score+"</td><td>"
                        +filterByZeroHandle(filterJudge(data.all_check_score,data.checked_num),'0')+"</td><td>"
                        +filterByZeroHandle((1000-filterJudge(data.all_check_score,data.checked_num)),'1000')+"</td>";
                strTbody+="</tr>";
            
      }
      return strTbody;
}

/**
 * 排名
 */
function station_rank_method(array,rank){
    rank[0] = 1 ;
    for(var i=1; i<array.length; i++){
        if(array[i-1] == array[i]  ){
            rank[i] = rank[i-1];
        }else{
            rank[i] = i +1;
        }				
    }
} 

/**
 * 得分转化为3个排名数组
 * @param {*} type 
 */
function station_rank(type){
    if(type==1){
        station_rank_method(lianyungang_Station, r1);
    }else if(type==2){
        station_rank_method(yancheng_Station, r2);
    }else if(type==3){
        station_rank_method(nantong_Station, r3);
    }
}

function filter(value , default_display_value){
    if(value!='' && value!=undefined ){
        return value ;
    }else if(default_display_value != undefined){
        return default_display_value ;
    }else{
        return "" ;
    }
}

/**
 * 过滤除数为0和保留二位小数时出现的0.00
 * @param {*} value 
 * @param {*} default_display_value 
 */
function filterByZeroHandle(value , default_display_value){
        if(isNaN(value)){
            return default_display_value ;
        }else{
            if((value+'').endsWith('.00')){
                return value.substring(0,value.length-3);
            }
            return value ;
        }
}

function filterJudge(num1,num2){
        if(num2==0){
            return 0;
        }else{
            return (num1/num2).toFixed(2);
        }
}

function exportExcel(){
    var start_date = $("#start-time").val();
    var end_date = $("#end-time").val();
    if( start_date=='' || end_date==''){
        tip("请选择起止日期");
        return ;
    }else{
        start_date += " 23:00:00";
        end_date += " 23:00:00";

        var start = new Date(start_date);
        //开始日期取前一天的23:00
        start.setDate(start.getDate()-1);
        start_date = start.Format("yyyy-MM-dd HH:mm:ss");
    }
    window.open( getserveraddr() + "/file/score/info?start_date="+start_date+"&end_date="+end_date);
}