-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathphp.php
123 lines (113 loc) · 4.03 KB
/
php.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
117
118
119
<?php
function generateData($page,$pageSzie,$sortNameParamName,$sortOrderParamName,$filterMap=[]){
//做些你想做的搜索 通常搞搞SQL这里就不搞了,搞不动。
$list=[];
for($i = 0;$i < $pageSzie;$i++){
$item = [
'id'=>($page -1) *$pageSzie+$i,
'num'=>'BQ_'.date("YmdHi",time()),
'gender'=> rand(1,2),
'age'=> rand(20,35),
'email'=>'bigq517@qq.com',
'mobile'=>'139*****517',
'name'=> isset($filterMap['name'])?$filterMap['name'].($i+1):'老王_'.($i+1),
'datetime'=>time() - $i * 60 * 60 *24
];
array_push($list,$item);
}
return $list;
}
if($_SERVER['REQUEST_METHOD'] == 'POST'){
$page = isset($_POST["page"])?$_POST["page"]:1;
$pageSize = isset($_POST["pagesize"])?$_POST["pagesize"]:40;
$sortNameParamName=isset($_POST["sortname"])?$_POST["sortname"]:'';
$sortOrderParamName=isset($_POST["sortorder"])?$_POST["sortorder"]:'';
$name = isset($_POST["name"])?$_POST["name"]:'';
$num = isset($_POST["num"])?$_POST["num"]:'';
$map =[];
if($name!==''){
$map['name'] = $name;
}
if($num!==''){
$map['num'] = $num;
}
$rows = generateData($page,$pageSize,$sortNameParamName,$sortOrderParamName,$map);
$total = 9999;//搞搞 select count()
//
$resData=['total'=>$total,'rows'=>$rows];//注意 total rows
print(json_encode($resData));
exit(0);
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>BC Gird</title>
<link rel="stylesheet" href="../dist/css/font-awesome/4.7.0/css/font-awesome.min.css"/>
<link rel="stylesheet" href="../dist/css/bc.grid.min.css"/>
<script src="../lib/jquery-11.1.min.js"></script>
<script src="../dist/bc.grid.min.js"></script>
<style type="text/css">
.title{
margin: 20px;
}
.title h1{
text-align: center;
}
.title a{
text-decoration: none;
}
</style>
</head>
<body>
<div class="title"><a class="back" href="javascript:history.go(-1);"><Back</a><h1>BCGrid-Php Server</h1></div>
<div>
<form id="form1"><div>姓名:<input name="name" id="name" value=""/> 编号:<input name="num" id="num" value=""/> <button type="button" id="searchBtn">搜索</button></div></form>
<div id="dataTable" style="margin-top: 20px"></div>
</div>
<script>
$(function () {
grid=BCGrid.create("#dataTable",{
columns: [
{id: 'id', name: 'id', display: 'ID', align: 'center'},
{name: 'name', display: '姓名'},
{name: 'num', display: '编号',align: 'right'},
{name: 'datetime', display: '时间',type:'date',enableSort:true}
],
enablePager:true,
lang:'zh',
//url: 'php.php',//如果数据路径同展示页面路径可以省略此参数
showCheckbox: true,
onSelectedRow: function (rowIndex, rowData) { //选择行事件
console.log(rowData);
},
onCheckClick: function (rowIndex, isChecked, rowData) { //选择事件(复选框)
console.log(rowData);
},
});
///
$("#searchBtn").on('click',function () {
filterData();
});
});
function filterData() {
grid.filterData("#form1");
/** 或者
var paramsData = BCGrid.buildParams("#form1");
grid.filterData(paramsData);
*/
}
function filterData_other() {
var paramsData = BCGrid.buildParams("#form1");
/** 或者
var paramsData =[];
paramsData.push({"name": "name", "value": "" + $("#name").val() + ""});
paramsData.push({"name": "num", "value": "" + $("#num").val() + ""});
*/
grid.set({params:paramsData});
grid.reload();
}
</script>
</body>
</html>