-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdatatable1.php
116 lines (113 loc) · 4.31 KB
/
datatable1.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
<!DOCTYPE html>
<!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->
<html lang="zh-CN">
<head>
<title>查询数据结果</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<script src="plugin/jquery-1.12.1.min.js"></script>
<script src="plugin/jquery.dataTables.js"></script>
<script src="plugin/DataTables/Buttons-1.1.2/js/dataTables.buttons.min.js" type="text/javascript"></script>
<script src="plugin/DataTables/Buttons-1.1.2/js/buttons.flash.min.js" type="text/javascript"></script>
<script src="plugin/DataTables/Buttons-1.1.2/js/buttons.html5.min.js" type="text/javascript"></script>
<!-- <script src="plugin/DataTables/Buttons-1.1.2/js/buttons.print.min.js" type="text/javascript"></script> -->
<script src="plugin/DataTables/JSZip-2.5.0/jszip.min.js" type="text/javascript"></script>
<!-- <script src="plugin/DataTables/pdfmake-0.1.18/build/pdfmake.min.js" type="text/javascript"></script>
<script src="plugin/DataTables/pdfmake-0.1.18/build/vfs_fonts.js" type="text/javascript"></script>
-->
<link rel="stylesheet" href="plugin/bootstrap.css">
<link rel="stylesheet" href="plugin/bootstrap-theme.css">
<link rel="stylesheet" href="plugin/jquery.dataTables.css">
<link href="plugin/DataTables/Buttons-1.1.2/css/buttons.dataTables.min.css" rel="stylesheet" type="text/css"/>
</head>
<body>
<div class="col-sm-2"></div>
<div class="col-sm-8 ">
<h2 style="text-align: center">查询结果表</h2>
<hr/>
<table id="example" class="display" cellspacing="0" width="100%">
<thead>
<tr>
<th>电话号码</th>
<th>状态</th>
<th>已拨打次数</th>
<th>最后拨打时间</th>
<th>号码分发状态</th>
</tr>
</thead>
<tfoot>
<tr>
<th>电话号码</th>
<th>状态</th>
<th>已拨打次数</th>
<th>最后拨打时间</th>
<th>号码分发状态</th>
</tr>
</tfoot>
</table>
</div>
<div class="col-sm-2"></div>
<script>
var $aa='#example';
$(document).ready(function() {
$($aa).DataTable( {
"autoWidth":false,
"lengthMenu": [[10, 30, 50, 1000], [10, 30,50, 1000]],
"processing": true,
"serverSide": true,
"ajax": "server_processing1.php",
"deferRender": true,
"dom": 'B<"clear">lfrtip',
"buttons": [
'copy', 'excel'
],
language: {
"sProcessing": "处理中...",
"sLengthMenu": "显示 _MENU_ 项结果",
"sZeroRecords": "没有匹配结果",
"sInfo": "显示第 _START_ 至 _END_ 项结果，共 _TOTAL_ 项",
"sInfoEmpty": "显示第 0 至 0 项结果，共 0 项",
"sInfoFiltered": "(由 _MAX_ 项结果过滤)",
"sInfoPostFix": "",
"sSearch": "搜索:",
"sUrl": "",
"sEmptyTable": "表中数据为空",
"sLoadingRecords": "载入中...",
"sInfoThousands": ",",
"oPaginate": {
"sFirst": "首页",
"sPrevious": "上页",
"sNext": "下页",
"sLast": "末页"
},
"oAria": {
"sSortAscending": ": 以升序排列此列",
"sSortDescending": ": 以降序排列此列"
}
}
} );
$('#example tfoot th').each( function () {
var title = $(this).text();
$(this).html( '<input style="width: 100%;padding: 3px;box-sizing: border-box;" type="text" placeholder="查询 '+title+'" />' );
} );
// DataTable
var table = $('#example').DataTable();
// Apply the search
table.columns().every( function () {
var that = this;
$( 'input', this.footer() ).on( 'keyup change', function () {
if ( that.search() !== this.value ) {
that
.search( this.value )
.draw();
}
} );
} );
} );
</script>
</body>
</html>