YH_Web_UI/WebUI/CallCenterWe.../accessManage.../js/generalStati...

/**
 * 报修平台
 * */

var zydata = [];
var mzdata = [];
var hzdata = [];
var showdatas = [];
var len = "";
var state = ""; // state tab页的 data-index（工单状态参数）；
var stateVal = ""; //默认为所有,”day”今天,”week”本周,”month”本月,”year”本年
$(document).ready(function () {
    $(".tool_bars").authorizeButton();
    //搜索
    $("#sc_btns").click(function () {
        getdatas();
        // initTable1();
    });
    $("#HY_seeMore").click(function () {
        $(".moreCondition").toggleClass("show");
    });
    $("#sc_statebtn")
        .find('input[type="radio"]')
        .on("change", function () {
            stateVal = $(this).val();
            initTable1();
        });
    //时间
    laydate.render({
        elem: "#startTime",
        theme: "#249fea",
        range: "~",
    });
    function getPreDatetime(pdate) {
        var start = new Date();
        start.setTime(start.getTime() - pdate);
        start.getYear(); // 获取当前年份(2位)
        var YY = start.getFullYear(); // 获取完整的年份(4位,1970-????)
        var MM = start.getMonth() + 1; // 获取当前月份(0-11,0代表1月)
        MM = MM > 9 ? MM : "0" + MM;
        var DD = start.getDate(); // 获取当前日(1-31)
        DD = DD > 9 ? DD : "0" + DD;
        var lastmonth = YY + "-" + MM + "-" + DD;
        return lastmonth;
    }

    if ($("#startTime").val() == "") {
        function p(s) {
            return s < 10 ? "0" + s : s;
        }
        var currentYear = new Date().getFullYear();
        var currentMonth = new Date().getMonth() + 1;
        var currentDate = new Date().getDate();
        var prevCurrentYear = 0;
        var prevCurrentMonth = 0;
        if (currentMonth == 1) {
            prevCurrentYear = currentYear - 1;
            prevCurrentMonth = 12;
        } else {
            prevCurrentYear = currentYear;
            prevCurrentMonth = currentMonth - 1;
        }

        var current =
            currentYear + "-" + p(currentMonth) + "-" + p(currentDate);
        // var lastmonth = prevCurrentYear + "-" + p(prevCurrentMonth) + "-" + p(currentDate)
        var a = getPreDatetime(3600 * 1000 * 24 * 30);
        $("#startTime").val(
            getPreDatetime(3600 * 1000 * 24 * 30) + " ~ " + current
        );
        getdatas();
        // initTable1();
    }
});
function getdatas() {
    $.ajax({
        type: "get",
        url:
            huayi.config.callcenter_url +
            "testusertypeapi/api/Test/getmzsfallbbinfolist", //获取数据的Servlet地址
        async: true,
        dataType: "json",
        data: {
            stime:
                $("#startTime").val() && $("#startTime").val().split(" ~ ")[0], //开始时间
            etime:
                $("#startTime").val() && $("#startTime").val().split(" ~ ")[1], //结束时间
        },
        success: function (data) {
            if (data.state.toLowerCase() == "success") {
                for (var i = 0; i < data.data.length; i++) {
                    delete data.data[i].sendlosecount;
                    delete data.data[i].hzallcount;
                }
                zydata = data.data;
                initTable1();
            }
        },
    });
}

function initTable1() {
    //先销毁表格
    $("#table1").bootstrapTable("destroy");
    //初始化表格,动态从服务器加载数据
    $("#table1").bootstrapTable({
        method: "get", //使用get请求到服务器获取数据
        url:huayi.config.callcenter_url + "testusertypeapi/api/Test/getzysfallbbinfolist", //获取数据的Servlet地址 getzysfallbbinfolist
        //url:"./js/jsonFollData.js",
        contentType: "application/x-www-form-urlencoded",
        striped: true, //表格显示条纹
        smartDisplay: false,
        // pagination: false, //启动分页
        // pageSize: 10, //每页显示的记录数
        // pageNumber: 1, //当前第几页
        // pageList: [10, 20, 50, 100], //记录数可选列表
        search: false, //是否启用查询
        showColumns: false, //显示下拉框勾选要显示的列
        showRefresh: false, //显示刷新按钮
        sidePagination: "server", //表示服务端请求
        //设置为undefined可以获取pageNumber，pageSize，searchText，sortName，sortOrder
        //设置为limit可以获取limit, offset, search, sort, order
        queryParamsType: "undefined",
        queryParams: function queryParams(params) {
            //设置查询参数
            var param = {
                stime:
                    $("#startTime").val() &&
                    $("#startTime").val().split(" ~ ")[0], //开始时间
                etime:
                    $("#startTime").val() &&
                    $("#startTime").val().split(" ~ ")[1], //结束时间
            };
            return param;
        },
        responseHandler: function (res) {
            var ddata = res
            console.log("ddata", ddata)
            for (var i = 0; i < ddata.data.length; i++) {
                delete ddata.data[i].sendlosecount;
                delete ddata.data[i].hzallcount;
                if (ddata.data[i].sfallcount == "") {
                    ddata.data[i].sfallcount = 0;
                }
                if (ddata.data[i].yhfcount == "") {
                    ddata.data[i].yhfcount = 0;
                }

                if (ddata.data[i].whfcount == "") {
                    ddata.data[i].whfcount = 0;
                }

                if (ddata.data[i].mycount == "") {
                    ddata.data[i].mycount = 0;
                }

                if (ddata.data[i].mycountbl == "") {
                    ddata.data[i].mycountbl = 0;
                }

                if (ddata.data[i].bycount == "") {
                    ddata.data[i].bycount = 0;
                }

                if (ddata.data[i].bycountbl == "") {
                    ddata.data[i].bycountbl = 0;
                }

                if (ddata.data[i].nomycount == "") {
                    ddata.data[i].nomycount = 0;
                }

                if (ddata.data[i].nomycountbl == "") {
                    ddata.data[i].nomycountbl = 0;
                }

                if (ddata.data[i].othercount == "") {
                    ddata.data[i].othercount = 0;
                }
                if (ddata.data[i].hfmydbl == "") {
                    ddata.data[i].hfmydbl = 0;
                }
                 if (ddata.data[i].sendsuccesscount == "") {
                    ddata.data[i].sendsuccesscount = 0;
                }
                  if (ddata.data[i].sendlv == "") {
                    ddata.data[i].sendlv = 0;
                }

                if (ddata.data[i].zhmydbfb == "") {
                    ddata.data[i].zhmydbfb = 0;
                }
            }
            mzdata = ddata.data;
            hzdata = zydata.concat(mzdata);
            len = hzdata.length;
            var sfallcount = hzdata.reduce(
                (sum, e) => sum + parseInt(e.sfallcount),
                0
            );
            var yhfcount = hzdata.reduce(
                (sum, e) => sum + parseInt(e.yhfcount),
                0
            );
            var whfcount = hzdata.reduce(
                (sum, e) => sum + parseInt(e.whfcount),
                0
            );
            var mycount = hzdata.reduce(
                (sum, e) => sum + parseInt(e.mycount),
                0
            );
            var mycountbl = hzdata.reduce(
                (sum, e) => sum + parseInt(e.mycountbl),
                0
            );
            var bycount = hzdata.reduce(
                (sum, e) => sum + parseInt(e.bycount),
                0
            );
            var bycountbl = hzdata.reduce(
                (sum, e) => sum + parseInt(e.bycountbl),
                0
            );
            var nomycount = hzdata.reduce(
                (sum, e) => sum + parseInt(e.nomycount),
                0
            );
            var nomycountbl = hzdata.reduce(
                (sum, e) => sum + parseInt(e.nomycountbl),
                0
            );
            var othercount = hzdata.reduce(
                (sum, e) => sum + parseInt(e.othercount),
                0
            );
            var hfmydbl = hzdata.reduce(
                (sum, e) => sum + parseFloat(e.hfmydbl),
                0
            );
             var sendsuccesscount = hzdata.reduce(
                (sum, e) => sum + parseFloat(e.sendsuccesscount),
                0
            );
             var sendlv = hzdata.reduce(
                (sum, e) => sum + parseFloat(e.sendlv),
                0
            );
            var zhmydbfb = hzdata.reduce(
                (sum, e) => sum + parseInt(e.zhmydbfb),
                0
            );
            var newhzdata = [
                {
                    deptname: "合计",
                    sfallcount: sfallcount,
                    yhfcount: yhfcount,
                    whfcount: whfcount,
                    mycount: mycount,
                    mycountbl: (mycountbl / len).toFixed(2) + "%",
                    bycount: bycount,
                    bycountbl: (bycountbl / len).toFixed(2) + "%",
                    nomycount: nomycount,
                    nomycountbl: (nomycountbl / len).toFixed(2) + "%",
                    othercount: othercount,
                    hfmydbl: (hfmydbl / len).toFixed(2) + "%",
                    sendsuccesscount: sendsuccesscount,
                    sendlv: ((sendsuccesscount/ sfallcount)*100).toFixed(2) + "%",
                    zhmydbfb: ((mycount+bycount)/(sendsuccesscount-othercount)*100).toFixed(2) + '%'
                    //zhmydbfb: (zhmydbfb / len).toFixed(2) + "%",
                },
            ];
            if (hzdata.length > 0) {
                showdatas = hzdata.concat(newhzdata);
            } else {
                showdatas = [];
            }
            //格式化数据
            return {
                rows: showdatas, //数据
            };
        },
        onLoadSuccess: function (res) {
            //加载成功时执行
        },
        onLoadError: function () {
            //加载失败时执行
            //layer.msg("加载数据失败", { time: 1500, icon: 2 });
        },
    });
}

//导出
function btn_export() {
    // var stime = $('#startTime').val() && $('#startTime').val().split(' ~ ')[0] //开始时间
    // var etime = $('#startTime').val() && $('#startTime').val().split(' ~ ')[1] //结束时间
    // window.location.href = huayi.config.callcenter_url + "testusertypeapi/api/Test/exportexcelsfallbb?stime=" + stime + "&etime=" + etime

    //要导出的json数据
    const jsonData = showdatas;
    //列标题，逗号隔开，每一个逗号就是隔开一个单元格
    var str = `科室,随访总数,已回复,未回复,满意,满意度,表扬,表扬度,不满意,不满意度,其他,回复满意度,成功数,成功率,综合满意度\n`;
    //增加\t为了不让表格显示科学计数法或者其他格式
    for (let i = 0; i < jsonData.length; i++) {
        for (let item in jsonData[i]) {
            str += `${jsonData[i][item] + "\t"},`;
        }
        str += "\n";
    }
    //encodeURIComponent解决中文乱码
    let uri =
        "data:text/csv/xls;charset=utf-8,\ufeff" + encodeURIComponent(str);
    //通过创建a标签实现
    let link = document.createElement("a");
    link.href = uri;
    //对下载的文件命名
    link.download = "总统计报表.xlsx";
    document.body.appendChild(link);
    link.click();
    document.body.removeChild(link);
}