layui 排序
排序重载
table.on('sort(test)', function(obj){
//执行重载
table.reload('testReload', {
url: '',
request: {
pageName: 'page' //页码的参数名称,默认:page
,limitName: 'pageSize' //每页数据量的参数名,默认:limit
},
page: {
curr: 1 //重新从第 1 页开始
}
,where: {
field:obj.field, //当前排序的字段名
type: obj.type//当前排序类型:desc(降序)、asc(升序)、null(空对象,默认排序)
}
}, 'data');
})
后端处理
public function get()
{
$field = $_GET['field']?$_GET['field']:'';
$type = $_GET['type']?$_GET['type']:'';
$page=$_GET['page']?$_GET['page']:1;
$limit=$_GET['pageSize']?$_GET['pageSize']:10;
$yema=($page-1)*$limit;
$member = new me();
$count=$member->order($field, $type)->limit($yema,$limit)->count();
$member = $member->order($field, $type)->limit($yema,$limit)->select();
foreach ($member as $v) {
if($v['settime']){
$v['settime'] = date("Y-m-d H:i:s", $v['settime']);
}
if($v['addtime']){
$v['addtime'] = date("Y-m-d H:i:s", $v['addtime']);
} }
$member[0]['count']=$count;
return json_encode($member);
}