index.php
5.73 KB
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
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
<?php $this->load->view('common/header'); ?>
<body>
<div class="page-container">
<!--<form class="" onreset="resetHandler()">
<?php /*$this->load->view('work/search'); */?>
<div>
<button class="btn btn-primary radius" type="button" onclick="$('#table').DataTable().draw()">搜索</button>
<input class="btn btn-warning radius" type="reset" value="重置">
</div>
</form>-->
<form class="" onreset="resetHandler()">
<div class="row cl mb-20">
<div class="col-xs-2">
<span class="select-box">
<select class="select table_search" name="code" size="1">
<option value="" selected>选择字段</option>
<option value="0">姓名</option>
<option value="1">身份证号</option>
<option value="2">手机号</option>
</select>
</span>
</div>
<div class="col-xs-2">
<input type="text" class="input-text" placeholder="" id="keywork" name="keyword">
</div>
<div>
<button class="btn btn-primary radius" type="button" onclick="$('#table').DataTable().draw()">搜索</button>
<input class="btn btn-warning radius" type="reset" value="重置">
</div>
<!--<div>
<button class="btn btn-primary radius" onclick="layer_show('添加', '<?/*= site_url('/config/add') */?>')">添加</button>
</div>-->
</form>
<div class="body mt-20">
<table class="table table-border table-bordered table-bg" id="table" url="client/clients">
<thead class="text-c">
<tr>
<!-- <th width="68px">操作</th>-->
<th>客户编号</th>
<th>姓名</th>
<th>身份证</th>
<th>手机号</th>
<th>录入时间</th>
</tr>
</thead>
<tbody class="text-c">
</tbody>
</table>
</div>
</div>
<?php $this->load->view('common/footer'); ?>
<script>
var table = $('#table').dataTable({
/*aaSorting: [[1, "desc"]],
serverSide: true,
processing: true,
bSort: false,
searching: false,//是否显示搜索
iDisplayLength: 6,
bLengthChange: false,
ajax: {
url: apiBaseUrl + '/client/clients',
dataFilter: function (json) {
var ret = {}, json = jQuery.parseJSON(json);
ret.data = json.data || [];
var draw = getUrlParam('draw');
if(draw) {
ret.draw = draw;
}
ret.recordsTotal = 0;
ret.recordsFiltered = 0;
if (json.page) {
ret.recordsTotal = parseInt(json.page.totalNumber);
ret.recordsFiltered = parseInt(json.page.totalNumber);
}
return JSON.stringify(ret);
},
data: function (data) {
data.pageSize = data.length;
data.currentPage = parseFloat(data.start / data.length) + 1;
return data;
}
},*/
columns: [
//{
// data: "id", render: function (data, type, full) {
// var url = "<?//=site_url('/user/info')?>//";
// url += '/' + data;
// return '<span class="dropDown dropDown_hover">\
// <button class="btn radius size-M">请选择 <i class="Hui-iconfont"></i></button>\
// <ul class="dropDown-menu menu radius box-shadow">\
// <li><a href="javascript:;" onclick="creatIframe(\''+url+'\', \'查看详细\')">查看详细</a></li>\
// </ul></span>';
// }
//},
{data: "id"},//客户编号
{data: "userName"},//姓名
{data: "idCard"},//身份证
{data: "phoneNumber"},//手机号
{data: "createTime"}//录入时间
]
});
/*$.fn.dataTableExt.afnFiltering.push(
function (oSettings, aData, iDataIndex) {
var min = document.getElementById('min').value;
var max = document.getElementById('max').value;
var iDateCol = 12;
var dateMin = new Date(aData[iDateCol]);
var dateMax = new Date(aData[iDateCol]);
if (min === '' && max === '')
return true;
else if (new Date(min).getTime() <= dateMin.getTime() && max === '')
return true;
else if (new Date(min).getTime() <= dateMin.getTime() && new Date(max).getTime() >= dateMax.getTime())
return true;
return false;
}
);
$('.table_search').on('change', function () {
search = $(this).val();
column = $(this).attr('column');
$('#table').DataTable().column(column).search(search).draw();
});
$('#min, #max').on('keyup', function () {
$('#table').DataTable().draw();
});
function resetHandler() {
$('#table').DataTable().columns().search("").draw();
}*/
</script>
</body>
<html>