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) {
                var list = data.list;
                // 道管中心排名
                ranking_method(list);
                for (i = 0; i < list.length; i++) {
                    $(".table-tbody").append(gethtml(list[i], i));
                }
                $(".table-tbody").append(getTotalHtml(data));
            }, function(error) {
                return "";
            });
        }


        function initQuerySituation() {
            //默认初始化前一周查所有
            var endD = new Date();
            var startD = new Date();
            // var startD = new Date(now.getTime() - 7 * 24 * 3600 * 1000);
            var start_time = startD.getFullYear() + "-" + (startD.getMonth()) + "-26";
            var end_time = endD.getFullYear() + "-" + (endD.getMonth() + 1) + "-25";
            //默认初始化时间页面回显
            $("#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) {
                var list = data.list;
                // 道管中心排名
                ranking_method(list);
                for (i = 0; i < list.length; i++) {
                    $(".table-tbody").append(gethtml(list[i], i));
                }
                $(".table-tbody").append(getTotalHtml(data));
            }, function(error) {
                return "";
            });

        }

        function getTotalHtml(data) {
            var html = "<tr><td>合计</td><td></td><td></td><td>" + data.totalMan + "</td><td>" + data.totalcheckedMan + "</td><td>" + data.totalcheckedCount + "</td><td>" + data.total0 + "</td><td>" + data.total15 + "</td><td>" + data.total50 + "</td><td>" + data.totalOver50 + "</td><td>" + data.totalAll + "</td><td>-</td><td>-</td></tr>";
            return html;
        }
        /**
         * 道管中心排名
         * @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 + " width='" + ($("#tb_th_1").width() + 4) + "px'>" + name + "</td>";
                strTbody += "<td width='" + ($("#tb_th_2").width() + 4) + "px'>" + ranking + "</td><td width='" + ($("#tb_th_3").width() + 4) + "px'>" + data.name + "</td><td width='" + ($("#tb_th_4").width() + 4) + "px'>" + filter(data.people_num, 0) +
                    "</td><td width='" + ($("#tb_th_5").width() + 4) + "px'>" + filter(data.checked_people_num, 0) + "</td><td width='" + ($("#tb_th_6").width() + 4) + "px'>" + filter(data.checked_num, 0) +
                    "</td><td width='" + ($("#tb_th_7_1").width() + 4) + "px'>" + (data.checked_people_num - (data.score_fifteen + data.score_fifty + data.score_over_fifty)) +
                    "</td><td width='" + ($("#tb_th_7_2").width() + 4) + "px'>" + data.score_fifteen + "</td><td width='" + ($("#tb_th_7_3").width() + 4) + "px'>" + data.score_fifty + "</td><td width='" + ($("#tb_th_7_4").width() + 4) + "px'>" +
                    data.score_over_fifty + "</td><td width='" + ($("#tb_th_7_5").width() + 4) + "px'>" + data.all_check_score + "</td><td width='" + ($("#tb_th_7_6").width() + 4) + "px'>" +
                    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);
        }