Datatables - JackHu88/Comm GitHub Wiki

$.fn.dataTableExt.afnFiltering.push(
  function (oSettings, aData, iDataIndex) {
      var keywords = $(".dataTables_filter input").val().toLowerCase();
      var matches = 0;

      for (var col = 0; col < aData.length; col++) {
          if (aData[col].toLowerCase().indexOf(keywords) > -1) {
              matches++;
              break;
          }
      }

      return matches > 0;
  }
);

var buttonCommon = {
    `exportOptions: {
        format: {
            body: function (data, row, column, node) {
                return data.replace(/<br\s*\/?>/ig, "\n").replace(/<("[^"]*"|'[^']*'|[^'">])*>/gi, "");
            }
        }
    }
};

var options = {
    dom: 'fBrtip',
    buttons: [
        /*{
            extend: 'excel',
            text: 'Export',
            title: "Case-"+new Date().format("yyyyMMdd")
        }*/
        $.extend(true, {}, buttonCommon, {
            extend: 'excel',
            text: 'Export',
            /*exportOptions: {
		columns: [ 0, 1, 2, 3,4,5,6 ]
	    },*/
            title: "Case-" + new Date().format("yyyyMMdd")
        }),
    ],
    //order: [[ 0, "desc" ]],
    columnDefs:[{ 
	"targets": [7,8,9,10,11,12,13], 
	"visible": false 
    }],
    displayLength: 20
};

$('#onGoingLicense').DataTable(options);
layer.closeAll('loading');

$(".dataTables_filter").append('<span class="fa fa-search"></span>');
var search = $(".dataTables_filter input[type='Search']");
search.attr("placeholder", "Search Case");
search.appendTo(search.parent().parent());

$(".dataTables_filter label").hide();
//更新数据
/*setTimeout(function(){
    var table = $('#onGoingLicense').DataTable();
    table.rows().every( function () {
        var d = this.data();				 
        d.counter++;				 
        this.invalidate();`
    } );
    table.draw();
},1000);*/

//update row
var table = $('#onGoingLicense').dataTable();
table.fnUpdate(epr_tmpl , $("tr[data-id='123'")[0], 9);

//Update row
var myDataTable = $('#onGoingLicense').DataTable();
var row = myDataTable.row("tr[data-id='" + id + "']");
myDataTable.cell(row, 9).data("text").draw();