1var datatables_i18n_cn = {
  2    "processing": "处理中...",
  3    "lengthMenu": "显示 _MENU_ 项结果",
  4    "zeroRecords": "没有匹配结果",
  5    "info": "显示第 _START_ 至 _END_ 项结果，共 _TOTAL_ 项",
  6    "infoEmpty": "显示第 0 至 0 项结果，共 0 项",
  7    "infoFiltered": "(由 _MAX_ 项结果过滤)",
  8    "infoPostFix": "",
  9    "search": "搜索:",
 10    "searchPlaceholder": "搜索...",
 11    "url": "",
 12    "emptyTable": "表中数据为空",
 13    "loadingRecords": "载入中...",
 14    "infoThousands": ",",
 15    "paginate": {
 16        "first": "首页",
 17        "previous": "上页",
 18        "next": "下页",
 19        "last": "末页"
 20    },
 21    "aria": {
 22        "paginate": {
 23            first: '首页',
 24            previous: '上页',
 25            next: '下页',
 26            last: '末页'
 27        },
 28        "sortAscending": ": 以升序排列此列",
 29        "sortDescending": ": 以降序排列此列"
 30    },
 31    "decimal": "-",
 32    "thousands": "."
 33};
 34
 35
 36window.DEP_TABLE = $('#responsived-atatable')
 37.on('xhr.dt', function( e, settings, json, xhr ){
 38    console.log(json, xhr)
 39    json.draw = window.DATATABLESDROW;
 40    json.recordsTotal = json.total;
 41    json.recordsFiltered = json.total;
 42    //json.error = "null"
 43})
 44.on('init.dt' function(e)){
 45    $(e.currentTarget).find("tbody").on("click", ".action-buttons", function(e){
 46        var btn = e.currentTarget.dataset.turn_status,
 47            rowData = table.row($(e.currentTarget).parents("tr").get()).data();
 48        console.log(btn, rowData);
 49    })
 50}
 51.DataTable({
 52    "ordering": false,
 53    "searching": false,
 54    /*
 55        ajax加载数据
 56        1.后端接收的是page和rows两个参数来分页的，所以要添加附加的上传的信息
 57        2.后端返回的结果在result里，所以要设置dataSrc
 58        3.后端返回的总记录数在total里，所以要处理返回的json（上面的on xhr.dt）
 59        http://www.datatables.club/reference/option/ajax.data.html
 60    */
 61    "serverSide": true,
 62    "ajax":{
 63            url: "<?=site_url('back/database1/selectPage')?>",
 64            type:"POST",
 65            // 添加附加的上传的信息
 66            data: function(d){
 67                window.DATATABLESDROW = d.draw;
 68                d.rows = d.length;
 69                d.page = d.start;
 70            },
 71            dataSrc: "result"
 72    },
 73    //每一列填充
 74    "columns": [
 75        {"data":"file_name" },
 76        {"data":"file_path" },
 77        //修改（"data": null,获取这一列"ajax"得到的全部数据）
 78        { 
 79            "data": null,
 80            "render": function(data) {
 81                var data = encodeURI(JSON.stringify(data));
 82                var editdiv = '<a class="edit green"><i class="fa fa-pencil bigger-130"></i>修改</a>';
 83                return '<div class="action-buttons">'+ editdiv +'</div>';
 84            }
 85        },
 86        //删除
 87        { 
 88            "data": "qat_id",
 89            "render": function(data) {
 90                var deldiv = '<a class="del red"><i class="fa fa-trash bigger-130"></i>删除</a>';
 91                return '<div class="action-buttons">'+ deldiv +'</div>';
 92            }
 93        }
 94    ],
 95
 96    "language": datatables_i18n_cn,
 97    //设置第一列自增长
 98    "fnDrawCallback" : function(){
 99        console.log(this);
100        this.api().column(0).nodes().each(function(cell, i) {
101            cell.innerHTML =  i + 1;
102        });
103    },
104});
105
106
107// 刷新表格数据，分页信息不会重置
108DEP_TABLE.ajax.reload( null, false );