t1
/
ZLPMS


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244
							
@{
    ViewBag.Title = "NotYetStatistics";
    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">
            <input class="easyui-textbox" style="width:150px" id="Deal" label="受理人：" labelPosition="before" labelWidth="57px" />
        </div>
        <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,
            width: '100%',
            toolbar: '#toolbar',
            onLoadSuccess: onLoadSuccess,
            pageSize: 20,
            rownumbers: true,
            pagination: true,
            remoteSort: true,
            singleSelect: true,      //单行选择
            loadMsg: "正在查询数据，请稍候...",
            url: '/Report/GetNotYetStatistics',
            method: 'post',
            columns:[[
            { field: '环节', title: '环节', width: 100, halign: 'center',align: 'center' },
            { field: '受理人', title: '受理人', width: 100, halign: 'center', align: 'center' },
            { field: '编号', title: '编号', width: 100, halign: 'center', align: 'center' },
             {
                 field: '当前环节耗时', title: '当前环节耗时', width: 100, halign: 'center', align: 'center', formatter: function (value, row, index) {
                     var rd = value % 24;
                     if (value >= 24) {
                         return parseInt(value / 24) + '天' + rd.toFixed(1) + '时';
                     } else {
                         return rd + '小时';
                     }
                 }
             },
              {
                  field: '总耗时', title: '总耗时', width: 100, halign: 'center', align: 'center', formatter: function (value, row, index) {
                      var rd = value % 24;
                      if (value >= 24) {
                          return parseInt(value / 24) + '天' + rd.toFixed(1) + '时';
                      } else {
                          return rd + '小时';
                      }
                  }
              },
            ]]
        })
        $('#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 });
                }

            }
        });
        $("#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')
            });
        })
    })
    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 onLoadSuccess(data) {
        //环节
        var dev = support = project = 0;
        for (var i = 0; i < data.rows.length; i++) {
            if (data.rows[i].环节 == "研发处理") {
                ++dev;
            }
            if (data.rows[i].环节 == "技术支持处理") {
                ++support;
            }
            if (data.rows[i].环节 == "项目处理") {
                ++project;
            }
        }

        var merges = [  //研发处理
                        {
                            index: 0,
                            rowspan: dev
                        },
                        //技术支持处理
                        {
                            index: dev,
                            rowspan: project
                        },
                        //项目处理
                        {
                            index: dev + project,
                            rowspan: support
                        }
        ];
        for (var i = 0; i < merges.length; i++) {
            $(this).datagrid('mergeCells', {
                index: merges[i].index,
                field: '环节',
                rowspan: merges[i].rowspan
            });
        }


        //姓名
        //var j = first = 0;
        //var Name = [];
        //var Count = [];
        //var arry = new Array();
        //for (let i = 0; i < data.rows.length; i++) {
        //    Name[i] = 0;
        //    Count[i] = 0;
        //}
        //Name[0] = data.rows[0].受理人
        //for (var i = 0; i < data.rows.length; i++) {
        //    if (Name[j] != data.rows[i].受理人) {
        //        Name[++j] = data.rows[i].受理人;
        //    }
        //}
        //for (var i = 0; i < Name.length; i++) {
        //    for (var j = 0; j < data.rows.length; j++) {
        //        if (Name[i] == data.rows[j].受理人) {
        //            Count[i] += 1;
        //        }
        //    }
        //}
        //for (var i = 0; i < Count.length; i++) {
        //    $(this).datagrid('mergeCells', {
        //        index: first,
        //        field: '受理人',
        //        rowspan: Count[i]
        //    })
        //    if (i == 0) {
        //        first = Count[i];
        //    }
        //    else {
        //        first = Count[i] + Count[i - 1];
        //    }
        //}
    }
    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/GetNotYetStatistics", 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>