datatables 初始全量加载数据

使用的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();
}