//表格正体
var oTable = table.dataTable({
"language": {
"aria": {
"sortAscending": ": activate to sort column ascending",
"sortDescending": ": activate to sort column descending"
},
"emptyTable": "表中没有数据",
"info": "显示 _START_ 到 _END_ 在 _TOTAL_ 条",
"infoEmpty": "没有发现记录",
"infoFiltered": "(总条数 _MAX_)",
"lengthMenu": "_MENU_ 条",
"search": "搜索:",
"zeroRecords": "没有相应信息..."
},
"searching":false,
"processing": true,
"destroy": true,//如果需要重新加载的时候请加上这个
"ajax": function (data, callback, settings) {
$.ajax({
url:"/beetravel/system/manager!queryPage.do",
type:"POST",
data:{
managerToken:"11111111111"
},
success : function(data) {
console.log(data);
var returnData = {};
returnData.data = data.data.data;//这里直接自行返回了draw计数器,应该由后台返回
returnData.total = data.data.totalCount;//返回数据全部记录
//调用DataTables提供的callback方法,代表数据已封装完成并传回DataTables进行渲染
//此时的数据需确保正确无误,异常判断应在执行此回调前自行处理完毕
callback(returnData);
}
});
},
//列表对应的字段的名称
"columns": [
{ "data": "systemUserId" },
{ "data": "userName" },
{ "data": "mobile" },
{ "render": function ( data, type, row, meta ) {
var roles = row.roles;
var roleName= "";
for(var i=0;i<roles.length;i++){
if(i==0){
roleName +=roles[i].roleName;
}else{
roleName +=","+roles[i].roleName;
}
}
return roleName;
}},
{ "data": "createTime" },
{ "data": "account" }
],
//表格中的按钮
"columnDefs":[{
targets: 6,
render: function (data, type, row, meta) {
return '<div>' +
'<a type="button" class="btn blue" href="#" οnclick=delFromID(' + row.id + ') >修改账号</a>' +
'<a type="button" class="btn btn-danger" href="#" οnclick=delFromID(' + row.id + ') >删除账号</a>';
}
}]
var oTable = table.dataTable({
"language": {
"aria": {
"sortAscending": ": activate to sort column ascending",
"sortDescending": ": activate to sort column descending"
},
"emptyTable": "表中没有数据",
"info": "显示 _START_ 到 _END_ 在 _TOTAL_ 条",
"infoEmpty": "没有发现记录",
"infoFiltered": "(总条数 _MAX_)",
"lengthMenu": "_MENU_ 条",
"search": "搜索:",
"zeroRecords": "没有相应信息..."
},
"searching":false,
"processing": true,
"destroy": true,//如果需要重新加载的时候请加上这个
"ajax": function (data, callback, settings) {
$.ajax({
url:"/beetravel/system/manager!queryPage.do",
type:"POST",
data:{
managerToken:"11111111111"
},
success : function(data) {
console.log(data);
var returnData = {};
returnData.data = data.data.data;//这里直接自行返回了draw计数器,应该由后台返回
returnData.total = data.data.totalCount;//返回数据全部记录
//调用DataTables提供的callback方法,代表数据已封装完成并传回DataTables进行渲染
//此时的数据需确保正确无误,异常判断应在执行此回调前自行处理完毕
callback(returnData);
}
});
},
//列表对应的字段的名称
"columns": [
{ "data": "systemUserId" },
{ "data": "userName" },
{ "data": "mobile" },
{ "render": function ( data, type, row, meta ) {
var roles = row.roles;
var roleName= "";
for(var i=0;i<roles.length;i++){
if(i==0){
roleName +=roles[i].roleName;
}else{
roleName +=","+roles[i].roleName;
}
}
return roleName;
}},
{ "data": "createTime" },
{ "data": "account" }
],
//表格中的按钮
"columnDefs":[{
targets: 6,
render: function (data, type, row, meta) {
return '<div>' +
'<a type="button" class="btn blue" href="#" οnclick=delFromID(' + row.id + ') >修改账号</a>' +
'<a type="button" class="btn btn-danger" href="#" οnclick=delFromID(' + row.id + ') >删除账号</a>';
}
}]
}).api(); //此处需调用api()方法,否则返回的是JQuery对象而不是DataTables的API对象
表格的主体以上
表格的刷新
oTable.ajax.reload( null, false );