DataTables

DataTables Examples

by mohammad408

HTML

<script src="https://cdn.datatables.net/1.10.11/js/jquery.dataTables.min.js"></script>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.11/css/jquery.dataTables.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/buttons/1.1.2/css/buttons.dataTables.min.css">
<script src="https://cdn.datatables.net/buttons/1.1.2/js/dataTables.buttons.min.js"></script>
<link rel="stylesheet" href="https://cdn.datatables.net/select/1.1.2/css/select.dataTables.min.css">
<script src="https://cdn.datatables.net/select/1.1.2/js/dataTables.select.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
<script src="//cdn.datatables.net/responsive/2.0.2/js/dataTables.responsive.min.js"></script>
<link rel="stylesheet" href="//cdn.datatables.net/responsive/2.0.2/css/responsive.dataTables.min.css">
<script src="http://kingkode.com/datatables.editor.lite/js/altEditor/dataTables.altEditor.free.js"></script>
<div class="container">
  <table cellpadding="0" cellspacing="0" border="0" class="dataTable table table-striped" id="example">

  </table>
</div>

CSS

table.dataTable tbody>tr.selected,
table.dataTable tbody>tr>.selected {
  background-color: #A2D3F6;
}

.red-color {
  background-color: red;
}

JavaScript

$(document).ready(function() {

  var dataSet = [
    ["Tiger Nixon", 1, "Edinburgh", "5421", "2011/04/25", "$320,800"],
    ["Garrett Winters", 12, "Tokyo", "8422", "2011/07/25", "$170,750"],
    ["Ashton Cox", 4, "San Francisco", "1562", "2009/01/12", "$86,000"],
    ["Cedric Kelly", 5, "Edinburgh", "6224", "2012/03/29", "$433,060"],
    ["Airi Satou", 23, "Tokyo", "5407", "2008/11/28", "$162,700"],
    ["Brielle Williamson", 54, "New York", "4804", "2012/12/02", "$372,000"],
    ["Herrod Chandler", 2, "San Francisco", "9608", "2012/08/06", "$137,500"]
  ];

  var columnDefs = [{
    title: "Name"
  }, {
    title: "Position"
  }, {
    title: "Office"
  }, {
    title: "Extn."
  }, {
    title: "Start date"
  }, {
    title: "Salary"
  }];

  var myTable;

  myTable = $('#example').DataTable({
    data: dataSet,
    columns: columnDefs,
    columnDefs: [{
      targets: 1,
      render: function(data, type, row, meta) {
        console.log(data);
        if (data > 10) {
          return '<div class="red-color">' + data + '</div>';
        } else {
          return data;
        }
      }
    },
    {
      targets: 3,
      render: function(data, type, row, meta) {
        console.log(data);
        return '<div class="red-color">' + data + '</div>';
      }
    }]
  });


});