<!DOCTYPE html>
<!--[if IE 8]>
<html lang="en" class="ie8 no-js"> <![endif]-->
<!--[if IE 9]>
<html lang="en" class="ie9 no-js"> <![endif]-->
<!--[if !IE]><!-->
<html>
<!--<![endif]-->
<!-- BEGIN HEAD -->
<head>
    <base href="#springUrl('/assets/adminlte/')"/>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title>工作台</title>
    <!-- Tell the browser to be responsive to screen width -->
    <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
    <!-- Bootstrap 3.3.5 -->
    <link rel="stylesheet" href="bootstrap/css/bootstrap.min.css">
    <!-- Font Awesome -->
    <link rel="stylesheet" href="plugins/font-awesome/css/font-awesome.min.css">
    <!-- Ionicons -->
    <link rel="stylesheet" href="plugins/ionicons/css/ionicons.min.css">

    <!-- DataTables -->
    <link rel="stylesheet" href="plugins/datatables/dataTables.bootstrap.css">

    <!-- Theme style -->
    <link rel="stylesheet" href="dist/css/AdminLTE.min.css">
    <!-- AdminLTE Skins. Choose a skin from the css/skins
         folder instead of downloading all of them to reduce the load. -->
    <link rel="stylesheet" href="dist/css/skins/_all-skins.min.css">
    <!-- iCheck -->
    <link rel="stylesheet" href="plugins/iCheck/flat/blue.css">
    <!-- Morris chart -->
    <link rel="stylesheet" href="plugins/morris/morris.css">
    <!-- jvectormap -->
    <link rel="stylesheet" href="plugins/jvectormap/jquery-jvectormap-1.2.2.css">
    <!-- Date Picker -->
    <link rel="stylesheet" href="plugins/datepicker/datepicker3.css">
    <!-- Daterange picker -->
    <link rel="stylesheet" href="plugins/daterangepicker/daterangepicker-bs3.css">
    <link rel="stylesheet"
          href="plugins\bootstrap-fileinput\fileinput.min.css">
    <!-- bootstrap wysihtml5 - text editor -->
    <link rel="stylesheet" href="plugins/bootstrap-wysihtml5/bootstrap3-wysihtml5.min.css">

    <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
    <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
    <!--[if lt IE 9]>
    <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
    <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->
</head>
<body class="hold-transition skin-blue sidebar-mini">


<div class="wrapper">
    <div class="content-wrapper" style="margin-left:0;">
        <div id="importExcelDiv"></div>

        <section class="content-header">
            <h1>
                报表信息管理
                <small>报表信息</small>
            </h1>
            <ol class="breadcrumb">
                <li><a><i class="fa fa-dashboard"></i>首页</a></li>
                <li><a class="active">报表信息管理列表</a></li>
            </ol>
        </section>


        <!-- Main content -->
        <section class="content">
            <div class="row">
                <div class="col-xs-12">
                    <div class="box">
                        <div class="box-header">
                            <form id="seachTableForm" action="#springUrl('/a/report/exportExcel')" method="get">


                                <div class="col-xs-2">
                                    <input type="text" class="form-control"
                                           name="region" placeholder="大区">
                                </div>

                                <div class="col-xs-2">
                                    <input type="text" class="form-control"
                                           name="province" placeholder="省份">
                                </div>

                                <div class="col-xs-2">
                                    <input type="text" class="form-control"
                                           name="city" placeholder="城市">
                                </div>

                                <div class="col-xs-2">
                                    <input type="text" class="form-control"
                                           name="hospital" placeholder="医院">
                                </div>

                                <div class="col-xs-2">
                                    <input type="text" class="form-control"
                                           name="doctorName" placeholder="医生姓名">
                                </div>

                                <div class="col-xs-2">
                                    <input type="text" class="form-control"
                                           name="phone" placeholder="用户手机号码">
                                </div>

                                <div class="col-xs-2">
                                    <input type="text" class="form-control"
                                           name="drugsNum" placeholder="购买数量">
                                </div>

                                <div class="col-xs-2">
                                    <div class="input-group date">
                                        <div class="input-group-addon">
                                            <i class="fa fa-calendar"></i>
                                        </div>
                                        <input type="text" class="form-control pull-right datepicker"
                                               name="startPayTime" placeholder="付款开始时间"
                                               readonly="readonly">
                                    </div>
                                </div>

                                <div class="col-xs-2">
                                    <div class="input-group date">
                                        <div class="input-group-addon">
                                            <i class="fa fa-calendar"></i>
                                        </div>
                                        <input type="text"
                                               class="form-control pull-right  datepicker"
                                               name="endPayTime" placeholder="付款结束时间"
                                               readonly="readonly">
                                    </div>
                                </div>


                                <div class="col-xs-5">
                                    <button type="button" class="search btn btn-primary">搜索</button>
                                    #if($shiro.hasPermission("qy:report:edit"))
                                    <button type="submit" class="btn btn-primary">导出</button>
                                    #end
                                </div>
                            </form>
                        </div><!-- /.box-header -->
                        <div class="box-body">
                            <table id="table" class="table table-bordered table-striped">
                                <thead>
                                <tr>
                                    <td hidden="true">Id</td>
                                    <th>大区</th>
                                    <th>省份</th>
                                    <th>城市</th>
                                    <th>销售代表</th>
                                    <th>医院</th>
                                    <th>科室</th>
                                    <th>医生姓名</th>
                                    <th>医生职称</th>
                                    <th>性别</th>
                                    <th>医生手机号码</th>
                                    <th>处方医院</th>
                                    <th>处方医生</th>
                                    <th>咨询单编码</th>
                                    <th>需求清单编码</th>
                                    <th>用户姓名</th>
                                    <th>用户手机号码</th>
                                    <th>产品名称</th>
                                    <th>购买数量</th>
                                    <th>付款时间</th>
                                    <th>发货时间</th>
                                    <th>收件时间</th>
                                </tr>
                                </thead>
                                <tbody id="tablebody">
                                </tbody>

                            </table>
                        </div><!-- /.box-body -->
                    </div><!-- /.box -->
                </div><!-- /.col -->
            </div><!-- /.row -->
        </section><!-- /.content -->
    </div><!-- /.content-wrapper -->


    <!-- Add the sidebar's background. This div must be placed
         immediately after the control sidebar -->
    <div class="control-sidebar-bg"></div>
</div><!-- ./wrapper -->
<!-- jQuery 2.1.4 -->
<script src="plugins/jQuery/jQuery-2.1.4.min.js"></script>
<!-- Bootstrap 3.3.5 -->
<script src="bootstrap/js/bootstrap.min.js"></script>
<!-- DataTables -->
<script src="plugins/datatables/jquery.dataTables.min.js"></script>
<script src="plugins/datatables/extensions/i18n/lanauage_ch.js"></script>
<script src="plugins/datatables/dataTables.bootstrap.min.js"></script>
<!-- SlimScroll -->
<script src="plugins/slimScroll/jquery.slimscroll.min.js"></script>
<script src="plugins/datepicker/bootstrap-datepicker.js"></script>
<script src="plugins/datepicker/locales/bootstrap-datepicker.zh-CN.js"></script>
<!-- FastClick -->
<script src="plugins/fastclick/fastclick.min.js"></script>
<!--fileinput js-->
<script src="plugins\bootstrap-fileinput\fileinput.js"></script>
<script src="plugins/bootstrap-fileinput/zh.js"></script>
<script src="plugins/bootstrap-fileinput/zh2.js"></script>
<!-- AdminLTE App -->
<script src="dist/js/app.min.js"></script>
<script type="text/javascript"
        src="plugins/jquery-validation/js/jquery.validate.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="common/js/cfapp.js"></script>
<script>
    function formatDates(now) {
        var now = new Date(now);
        var year = now.getFullYear();
        var month = now.getMonth() + 1;
        var date = now.getDate();
        var hour = now.getHours();
        var minute = now.getMinutes();
        var second = now.getSeconds();
        return year + "-" + month + "-" + date + "   " + hour + ":"
            + minute + ":" + second;
    }

    function seachTable() {
        var sSource = "#springUrl('/a/report/listData')";
        var aoData = {
            iDisplayStart: 1,
            iDosplayLength: 10
        }
        var retrieveData = function (sSource, aoData, fnCallback) {

            $("#seachTableForm input").each(function () {
                var params = {
                    name: $(this).attr("name"),
                    value: $(this).val()
                };
                aoData.push(params);
            })

            $.ajax({
                "type": "GET",
                "url": sSource,
                "dataType": "json",
                "data": aoData, //以json格式传递
                "success": fnCallback
            });
        };

        $('#table').DataTable({
            "lengthChange": false,
            "searching": false,
            "ordering": false,
            "bFiltered": false,
            "bStateSave": true, // save datatable state(pagination, sort, etc) in cookie.
            "bProcessing": true,
            "bServerSide": true,
            "sAjaxSource": sSource,
            "fnServerData": retrieveData,
            "pagingType": "full_numbers",
            "aoColumns": [
                {
                    "mData": "id"
                },
                {
                    "mData":"region"
                },
                {
                    "mData":"province"
                },
                {
                    "mData":"city"
                },
                {
                    "mData":"salesRepresent"
                },
                {
                    "mData":"hospital"
                },
                {
                    "mData":"department"
                },
                {
                    "mData":"doctorName"
                },
                {
                    "mData":"doctorTitle"
                },
                {
                    "mData":"sex"
                },
                {
                    "mData":"doctorPhone"
                },
                {
                    "mData":"cfHospital"
                },
                {
                    "mData":"cfDoctor"
                },
                {
                    "mData":"consultNumber"
                },
                {
                    "mData":"orderNumber"
                },
                {
                    "mData":"userName"
                },
                {
                    "mData":"phone"
                },
                {
                    "mData":"productName"
                },
                {
                    "mData":"drugsNum"
                },
                {
                    "mData":"fkTime"
                },
                {
                    "mData":"fhTime"
                },
                {
                    "mData":"sjTime"
                }],
            "aoColumnDefs": [
                { // set default column settings
                    'visible': false,
                    'targets': [0]
                },

                {
                    "aTargets": [19],
                    "mData": "fkTime",
                    "mRender": function (a, b, c, d) {
                        if(a == '' || a == null){
                            return "";
                        }else {
                            return formatDates(a, "yyyy-MM-dd HH:mm:ss");
                        }
                    }
                },
                {
                    "aTargets": [20],
                    "mData": "fhTime",
                    "mRender": function (a, b, c, d) {
                        if(a == '' || a == null){
                            return "";
                        }else {
                            return formatDates(a, "yyyy-MM-dd HH:mm:ss");
                        }
                    }
                },
                {
                    "aTargets": [21],
                    "mData": "sjTime",
                    "mRender": function (a, b, c, d) {
                        if(a == '' || a == null){
                            return "";
                        }else {
                            return formatDates(a, "yyyy-MM-dd HH:mm:ss");
                        }
                    }
                },

            ]
        });
    }

    jQuery(document).ready(function () {
        seachTable();
        $('.datepicker').datepicker({
            show: true,
            format: 'yyyy-mm-dd',
            autoclose: true,
            language: 'zh-CN',
            todayBtn: 'linked',
            clearBtn: 'linked'

        });
        $('.search').click(function () {
            $("#table").dataTable().fnClearTable();
        });
    });

    Cfapp.init();

    function removeData(data) {
        Cfapp.confirm({
            message: "确定要删除吗",
            btnoktext: "确定",
            btncanceltext: "取消",
            success: function () {
                $.ajax({
                    type: "POST",
                    url: "#springUrl('/a/report/delete')",
                    data: {id: data},
                    dataType: "json",
                    success: function (data) {
                        if (data.errorNo == 0) {
                            Cfapp.alert({
                                message: "删除成功",
                                btntext: "确定",
                                success: function () {
                                    location.href = "#springUrl('/a/report/list')";
                                }
                            });
                        }
                    },
                    error: function () {
                    }
                })
            },
            cancel: function () {
                $(".modal-backdrop").fadeOut();
            }
        });
    }

    function importExcel() {
        var templateExcelUrl = "#springUrl('/a/report/templateExcel')";
        var importExcelUrl = "#springUrl('/a/report/importExcel')";
        Cfapp.importExcel({
            title: '报表信息导入',
            importurl: importExcelUrl,
            templateurl: templateExcelUrl,
            cancel: function () {

            },
            success: function () {

            }
        });
    }


</script>

</body>
</html>
