t1
/
ZLPMS


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

<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">
                <input class="easyui-textbox" style="width:150px" id="Deal" label="处理人：" labelPosition="before" labelWidth="57px" />
            </div>
        <input class="easyui-checkbox" type="checkbox" id="IsInside" label="内部产品问题" labelPosition="after" labelWidth="85px">
        <input class="easyui-checkbox" type="checkbox" id="NoInside" label="非内部产品问题"  labelPosition="after" labelWidth="100px" style="margin-left:10px">
       
        
        <div style="margin-left:20px;display:inline-block">
            <a id="btnSelect" href="#" class="easyui-linkbutton c1" style="margin-left:0px"><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 Obj = {
            name: undefined,
            Count: 0,
            check: false
        }
        var Report = $('#Table');
        Report.datagrid({
            fit: true,
            width: '100%',
            toolbar: '#toolbar',
            pageSize: 20,
            rownumbers: true,
            pagination: true,
            remoteSort: true,
            singleSelect: true,      //单行选择
            loadMsg: "正在查询数据，请稍候...",
            url: '/Report/GetDevelopStatistics',
            method: 'post',
            columns: [[
            {
                field: '姓名', title: '姓名', width: 100, halign: 'center', align: 'center'
            },
            { field: '处理数', title: '处理数', width: 100, halign: 'center', align: '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 });
                }

            }
        });
        $('#NoInside').checkbox({
            onChange: function (checked) {
                Obj.NoInside = checked
            }
        });
        $('#IsInside').checkbox({
            onChange: function (checked) {
                Obj.IsInside = checked
            }
        });
        $("#btnRefresh").bind("click", function () {
            $('#Table').datagrid("reload")
        })
        $("#btnSelect").bind('click', function () {

            $('#Table').datagrid('load', {
                startDate: $('#StartDate').datebox('getValue'),
                endDate: $('#EndDate').datebox('getValue'),
                Deal: $('#Deal').textbox('getValue'),
                IsInside: Obj.IsInside,
                NoInside: Obj.NoInside
            });
        })
    })
    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'),
            DealPerson: $('#Deal').textbox('getValue')
        }
        var location = top.ZLPMS.Loading("导出中，请稍等...");
        $.post("/Report/GetDevelopStatistics", 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>';
            }
            str = name + str;
            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>