ZLPMS/PMS.WebUI/Views/Report/GuiyangProblems.cshtml


@{
    ViewBag.Title = "AfterSale";
    Layout = "~/Views/Shared/_MainLayoutPage.cshtml";
}
<style>
</style>
<div id="toolbar" style="padding:3px;">




    <form id="ff">
        <input class="easyui-radiobutton" type="radio" value="1" name="fruit" label="登记日期" labelPosition="after" data-options="onChange:readiochecked">
        <input class="easyui-radiobutton" type="radio" value="2" name="fruit" label="完成日期" labelPosition="after" data-options="onChange:readiochecked">

        <input disabled id="StartDate" type="text" class="easyui-datebox" style="width:180px">-
        <input disabled id="EndDate" type="text" class="easyui-datebox" 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" />
            <input class="easyui-textbox" style="width:150px" id="Acceptor" label="处理人：" labelPosition="before" labelWidth="57px" />
        </div>
        <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>
    </form>
</div>
<table id="Table">
    <thead>
        <tr>
            <th field="名称" width="150" align="center">项目名称</th>
            <th field="问题分值" width="80" align="center">问题分值</th>
            <th field="陈勇" width="80" align="center">陈勇</th>
            <th field="池显" width="80" align="center">池显</th>
            <th field="兰忠胜" width="80" align="center">兰忠胜</th>
            <th field="陈运良" width="80" align="center">陈运良</th>
            @*<th field="张晓厅" width="80" align="center">张晓厅</th>
            <th field="吴昊" width="80" align="center">吴昊</th>
            <th field="向成高" width="80" align="center">向成高</th>
            <th field="陈洪江" width="80" align="center">陈洪江</th>
            <th field="苏伟" width="80" align="center">苏伟</th>
            <th field="刘彦" width="80" align="center">刘彦</th>
            <th field="王转正" width="80" align="center">王转正</th>*@
        </tr>
    </thead>

</table>
<script>
    var type = "0";
    $(function () {
        var Report = $('#Table');
        Report.datagrid({
            fit: true,
            showFooter: true,
            toolbar: '#toolbar',
            width: '100%',
            pageSize: 20,
            pageList: [10, 20, 30, 40, 50, 1000],
            rownumbers: true,
            pagination: true,
            border: false,
            remoteSort: true,
            singleSelect: true,      //单行选择
            loadMsg: "正在查询数据，请稍候...",
            url: '/Report/GetGuiyangProblems',
            method: 'post'

        })

        $("#btnSelect").bind('click', function () {

            $('#Table').datagrid('load', {
                startDate: $('#StartDate').datebox('getValue'),
                endDate: $('#EndDate').datebox('getValue'),
                DealPerson: $('#Deal').textbox('getValue'),
                AcceptorPerson: $('#Acceptor').textbox('getValue'),
                timetype: type
            });
        })
        $("#btnRefresh").bind('click', function () {
            $('#Table').datagrid('reload');
        })
        //按钮单击事件
        //$("input[type=radio]").click(function () {
        //    $('#StartDate').datebox({ disabled: false});
        //    $('#EndDate').datebox({ disabled: false});
        //    var sex = $("input[type=radio]:checked").val();
        //    type = sex;
        //});
    })
    ///read选中事件
    function readiochecked() {
        var opt = $("input:radio[name='fruit']:checked").val();
        if (opt == "1" || opt == "2") {
            $('#StartDate').datebox({ disabled: false });
            $('#EndDate').datebox({ disabled: false });
            type = $("input[type=radio]:checked").val();
        }
    }

    function formatterSolve(val) {
        if (!val) return "";
        var arrEntities = {
            'lt': '<',
            'gt': '>',
            'nbsp': ' ',
            'amp': '&',
            'quot': '"'
        };
        return val.replace(/<[^>]+>/g, "").replace(/&(lt|gt|nbsp|amp|quot);/ig, function (all, t) {
            return arrEntities[t];
        });
    }
    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'),
            AcceptorPerson: $('#Acceptor').textbox('getValue'),
            timetype: $("input[type=radio]:checked").val(),
        }
        var location = top.ZLPMS.Loading("导出中，请稍等...");
        $.post("/Report/GetGuiyangProblems", params, function (data) {
            top.ZLPMS.UnLoading(location);
            //大标题
            var Tname = ' <tr><td colspan="1" align="center">项目名称</td><td colspan="12" align="center">人员分值情况</td></tr>';
            //获取标题
            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 = Tname + 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>