使用的layui前端框架
//一次性全量加载
function initDataTable(){
$("#table_id").html("");
$(".spinner").show();
var d = ajax.ajaxFunc(ctx+"/index/qidian/getDataList",null,"json",null);
$('#table_id').DataTable({
"language": {
url:'//cdn.datatables.net/plug-ins/1.10.15/i18n/Chinese.json'
},
"scrollX":true,
//跟数组下标一样,第一列从0开始,这里表格初始化时,第四列默认降序
"order": [[ 7, "desc" ]],
data:d.data,
columns: [
{ data: 'ip_name' ,title:"名称",orderable: false},
{ data: 'q_author' ,title:"作者",orderable: false},
{ data: 'q_label1' ,title:"label1",orderable: false},
{ data: 'q_label2' ,title:"label2",orderable: false},
{ data: 'q_label3' ,title:"label3",orderable: false},
{ data: 'q_label4' ,title:"label4",orderable: false},
{ data: 'q_label5' ,title:"label5",orderable: false},
{ data: 'q_month_count' ,title:"月票"},
{ data: 'q_month_order_num' ,title:"月票排名" },
{ data: 'q_rec_count' ,title:"周推荐票数" },
{ data: 'q_rec_order_num' ,title:"周推荐票数排名" },
{ data: 'q_score' ,title:"分数" },
{ data: 'q_week_click_num' ,title:"周点击数" },
{ data: 'q_user_count' ,title:"评价人数" },
{ data: 'q_week_rec_num' ,title:"周推荐数" },
{ data: 'q_total_click_count' ,title:"总点击数" },
{ data: 'q_thread_cnt' ,title:"作品讨论数" },
{ data: 'q_month_order_num' ,title:"月票排名" },
{ data: 'source_url' ,title:"来源地址",orderable: false}
],
dom: 'Bfrtip',
buttons: [ {
extend: 'excelHtml5',
customize: function( xlsx ) {
var sheet = xlsx.xl.worksheets['sheet1.xml'];
//$('row c[r^="C"]', sheet).attr( 's', '2' );
}
} ],
bProcessing: true
});
$(".spinner").hide();
}