DataTables

DataTables Examples

HTML

<link rel="stylesheet" href="//cdn.datatables.net/1.10.0/css/jquery.dataTables.css">
<script src="https://cdn.datatables.net/1.10.9/js/jquery.dataTables.js"></script>
<link rel="stylesheet" href="https://cdn.datatables.net/rowgroup/1.0.0/css/rowGroup.dataTables.min.css">
<script src="https://cdn.datatables.net/rowgroup/1.0.0/js/dataTables.rowGroup.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.colVis.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.bootstrap4.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.6/js/dataTables.buttons.min.js"></script>
<link rel="stylesheet" href="https://cdn.datatables.net/buttons/1.5.6/css/buttons.bootstrap4.min.css">
<table id="example" class="display" cellspacing="0" width="100%">
  <thead>
    <tr>
      <th>Name</th>
      <th>Position</th>
      <th>Office</th>
      <th>Age</th>
      <th>Start date</th>
      <th>Salary</th>
    </tr>
  </thead>
  <tfoot>
    <tr>
      <th>Name</th>
      <th>Position</th>
      <th>Office</th>
      <th>Age</th>
      <th>Start date</th>
      <th>Salary</th>
    </tr>
  </tfoot>
  <tbody>
    <tr>
      <td>Tiger Nixon</td>
      <td>System Architect</td>
      <td>Edinburgh</td>
      <td>61</td>
      <td>2011/04/25</td>
      <td>$320,800</td>
    </tr>
    <tr>
      <td>Garrett Winters</td>
      <td>Accountant</td>
      <td>Tokyo</td>
      <td>63</td>
      <td>2011/07/25</td>
      <td>$170,750</td>
    </tr>
    <tr>
      <td>Ashton Cox</td>
      <td>Junior Technical Author</td>
      <td>San Francisco</td>
      <td>66</td>
      <td>2009/01/12</td>
      <td>$86,000</td>
    </tr>
    <tr>
      <td>Cedric Kelly</td>
      <td>Senior Javascript Developer</td>
      <td>Edinburgh</td>
      <td>22</td>
      <td>2012/03/29</td>
      <td>$433,060</td>
    </tr>
    <tr>
      <td>Airi Satou</td>
      <td>Accountant</td>
      <td>Tokyo</td>
      <td>33</td>
      <td>2008/11/28</td>
 ...

JavaScript

$(document).ready(function() {
  $('#example').DataTable({
    orderFixed: [2, 'asc'],
    order: [
      [2, 'asc']
    ],
    dom: 'Bt',
    buttons: [{
        extend: 'colvisGroup',
        text: 'View All',
        show: [0, 1, 2, 3, 4, 5],
        hide: []
      },
      {
        extend: 'colvisGroup',
        text: 'Name',
        show: [0],
        hide: [1, 2, 3, 4, 5]
      },
      {
        extend: 'colvisGroup',
        text: 'Position',
        show: [1],
        hide: [0, 2, 3, 4, 5]
      },
      {
        extend: 'colvisGroup',
        text: 'Rest',
        show: [2, 3, 4, 5],
        hide: [0, 1]
      }
    ],
    rowGroup: {
      startRender: null,
      endRender: function(rows, group) {
        var salaryAvg = rows
          .data()
          .pluck(5)
          .reduce(function(a, b) {
            return a + b.replace(/[^\d]/g, '') * 1;
          }, 0) / rows.count();
        salaryAvg = $.fn.dataTable.render.number(',', '.', 0, '$').display(salaryAvg);

        var ageAvg = rows
          .data()
          .pluck(3)
          .reduce(function(a, b) {
            return a + b * 1;
          }, 0) / rows.count();

        return $('<tr/>')
          .append('<td>Averages for ' + group + '</td>')
          .append('<td/>')
          .append('<td/>')
          .append('<td>' + ageAvg.toFixed(0) + '</td>')
          .append('<td/>')
          .append('<td>' + salaryAvg + '</td>');
      },
      dataSrc: 2
    }
  });
});