t1
/
ZLPMS


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141
							
@{
    ViewBag.Title = "RingStatistics";
    Layout = "~/Views/Shared/_MainLayoutPage.cshtml";
}


<!DOCTYPE html>

<html>
<head>
    <meta name="viewport" content="width=device-width" />
    <title>RingStatistics</title>
</head>
<body>
    <div id="toolbar" style="padding:3px;">
        <input class="easyui-checkbox" type="checkbox" id="Date" name="Date" label="登记日期" labelPosition="after" labelWidth="60px">
        <input disabled="disabled" id="StartDate" type="text" class="easyui-datetimebox" style="width:180px">-
        <input disabled="disabled" id="EndDate" type="text" class="easyui-datetimebox" style="width:180px">
        <div style="margin-left:20px;display:inline-block">
            <a id="btnSelect" href="#" class="easyui-linkbutton c1" style="margin-left:30px"><i class="fa fa-search"></i> 查询记录</a>
            <a id="btnRefresh" href="#" class="easyui-linkbutton c8" data-options="plain:true"><i class="fa fa-refresh"></i> 刷新</a>
            <a onclick="GetExcel()" id="btn_Class" href="#" class="easyui-linkbutton c2" data-options="plain:true"><i class="fa fa-file-text-o"> 导出excel</i></a>
        </div>
    </div>
    <table id="Table"> </table>
</body>
</html>
<script type="text/javascript">
    $(function () {
        var Report = $('#Table');
        Report.datagrid({
            fit: true,
            showFooter:true,
            width: '100%',
            toolbar: '#toolbar',
            pageSize: 20,
            rownumbers: true,
            pagination: true,
            remoteSort: true,
            singleSelect: true,      //单行选择
            loadMsg: "正在查询数据，请稍候...",
            url: '/Report/GetChannelStatistics',
            method: 'post',
            columns:[[
            { field: '名称', title: '渠道', width: 200, halign: 'center' },
            { field: '服务数量', title: '服务数量', width: 100, halign: 'center' },
            ]]
        })
        $('#Date').checkbox({
            onChange: function (checked) {
                if (checked) {
                    $('#StartDate').datebox({ disabled: false, required: true });
                    $('#EndDate').datebox({ disabled: false, required: true });
                } else {
                    $('#StartDate').datebox({ disabled: true });
                    $('#EndDate').datebox({ disabled: true });
                }

            }
        });
        $("#btnSelect").bind('click', function () {
            $('#Table').datagrid('load', {
                startDate: $('#StartDate').datebox('getValue'),
                endDate: $('#EndDate').datebox('getValue')
            });
        })
        $("#btnRefresh").bind('click', function () {
            $('#Table').datagrid('reload');
        })
    })
    function getPreMonth(date) {
        var arr = date.split('-');
        var year = arr[0]; //获取当前日期的年份  
        var month = arr[1]; //获取当前日期的月份  
        var day = arr[2]; //获取当前日期的日  
        var days = new Date(year, month, 0);
        days = days.getDate(); //获取当前日期中月的天数  
        var year2 = year;
        var month2 = parseInt(month) - 1;
        if (month2 == 0) {
            year2 = parseInt(year2) - 1;
            month2 = 12;
        }
        var day2 = day;
        var days2 = new Date(year2, month2, 0);
        days2 = days2.getDate();
        if (day2 > days2) {
            day2 = days2;
        }
        if (month2 < 10) {
            month2 = '0' + month2;
        }
        var t2 = year2 + '/' + month2;
        return t2;
    }
    function GetExcel() {
        //   var data = $('#Table').datagrid('getData');
        var params = {
            startDate: $('#StartDate').datebox('getValue'),
            endDate: $('#EndDate').datebox('getValue')
        }
        var location = top.ZLPMS.Loading("导出中，请稍等...");
        $.post("/Report/GetChannelStatistics", params, function (data) {
            top.ZLPMS.UnLoading(location);
           
            //获取标题
            var name = '<tr>';
            for (let Title in data.rows[0]) {
                //增加\t为了不让表格显示科学计数法或者其他格式           
                name += `<td>${Title}</td>`;
            }
            name += '</tr>';
            let str = '';
            //循环遍历，每行加入tr标签，每个单元格加td标签      
            for (let i = 0 ; i < data.rows.length ; i++) {
                str += '<tr>';
                for (let item in data.rows[i]) {
                    //增加\t为了不让表格显示科学计数法或者其他格式           
                    str += `<td>${data.rows[i][item] + '\t'}</td>`;
                }
                str += '</tr>';
            }
            //合计
            var Total = ' <tr><td colspan="1" align="center">合计</td><td colspan="1" align="center">' + data.footer[0].服务数量 + '</td></tr>';
            str =  name + str + Total;
            let worksheet = '渠道服务问题统计'
            let uri = 'data:application/vnd.ms-excel;base64,';
            //下载的表格模板数据     
            let template = `<html xmlns:o="urn:schemas-microsoft-com:office:office"       xmlns:x="urn:schemas-microsoft-com:office:excel"       xmlns="http://www.w3.org/TR/REC-html40">      <head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet>        <x:Name>${worksheet}</x:Name>        <x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet>        </x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]-->        </head><body><table>${str}</table></body></html>`;
            //下载模板      
            window.location.href = uri + base64(template)
        })


    }
    function base64(s) { return window.btoa(unescape(encodeURIComponent(s))) }
</script>