<!DOCTYPE html>
<html>
  <head>
    <!-- jQuery 3.6.0 -->
    <script src="https://code.jquery.com/jquery-3.6.0.js"></script>
    <!-- Bootstrap4 -->
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@4.6.2/dist/js/bootstrap.min.js" integrity="sha384-+sLIOodYLS7CIrQpBjl+C7nPvqq+FbNUBDunl/OZv93DB7Ln/533i8e/mZXLi/P+" crossorigin="anonymous"></script>
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.6.2/dist/css/bootstrap.min.css" integrity="sha384-xOolHFLEh07PJGoPkLv1IbcEPTNtaed2xpHsD9ESMhqIYd0nLMwNLD69Npy4HI+N" crossorigin="anonymous">
    <!-- DataTables 1.12.1 -->
    <script src="https://cdn.datatables.net/1.12.1/js/jquery.dataTables.min.js"></script>
    <!-- DataTables Bootstrap4 1.12.1 -->
    <script src="https://cdn.datatables.net/1.12.1/js/dataTables.bootstrap4.min.js"></script>
    <link href="https://cdn.datatables.net/1.12.1/css/dataTables.bootstrap4.min.css" rel="stylesheet" type="text/css" />
    <!-- SearchPanes 2.0.2 -->
    <script src="https://cdn.datatables.net/searchpanes/2.0.2/js/dataTables.searchPanes.min.js"></script>
    <!-- SearchPanes Bootstrap4 2.0.2 -->
    <script src="https://cdn.datatables.net/searchpanes/2.0.2/js/searchPanes.bootstrap4.min.js"></script>
    <link href="https://cdn.datatables.net/searchpanes/2.0.2/css/searchPanes.bootstrap4.min.css" rel="stylesheet" type="text/css" />
    <!-- Buttons 2.2.3 -->
    <script src="https://cdn.datatables.net/buttons/2.2.3/js/dataTables.buttons.min.js"></script>
    <!-- Buttons Bootstrap4 2.2.3 -->
    <script src="https://cdn.datatables.net/buttons/2.2.3/js/buttons.bootstrap4.min.js"></script>
    <link href="https://cdn.datatables.net/buttons/2.2.3/css/buttons.bootstrap4.min.css" rel="stylesheet" type="text/css" />
    <!-- Select 1.4.0 -->
    <script src="https://cdn.datatables.net/select/1.4.0/js/dataTables.select.min.js"></script>
    <!-- Select Bootstrap4 1.4.0 -->
    <link href="https://cdn.datatables.net/select/1.4.0/css/select.bootstrap4.min.css" rel="stylesheet" type="text/css" />
    <title>DataTables - JS Bin</title>
    <meta charset=utf-8 />
  </head>
  <body>
    <table id="outer" width="100%">
      <thead>
        <tr>
          <th>+</th>
          <th>First name</th>
          <th>Last name</th>
          <th>Email</th>
        </tr>
      </thead>
    </table>
  </body>
</html>
 
body {
  font: 90%/1.45em "Helvetica Neue", HelveticaNeue, Verdana, Arial, Helvetica, sans-serif;
  margin: 0;
  padding: 0;
  color: #333;
  background-color: #fff;
}
 
$(document).ready(function() {
  var outerTableElement = $('table#outer');
  outerTableElement.DataTable({
    dom: 'B<".searchPanes collapse mb-3 mt-3 border border-danger">t',
    ajax: 'http://datatables.showroom.efficient.it/data/?simple',
    buttons: [
      {
        extend: 'searchPanes',
        config: {
          layout: 'columns-1',
          initCollapsed: true,
          cascadePanes: true,
          viewTotal: true
        },
        action: function() {
          var DataTableApi = outerTableElement.dataTable().api();
          jQuery(DataTableApi.table().container()).children('div.searchPanes').collapse('toggle');
        }
      }
    ],
    columns: [
      {
        name: 'plus',
        searchPanes: {
          show: false
        },
        defaultContent: '<button class="plus">+</button>'
      },
      {
        data: 'first_name',
        searchPanes: {
          show: true
        }
      },
      {
        data: 'last_name',
        searchPanes: {
          show: true
        }
      },
      {
        data: 'email',
        searchPanes: {
          show: true
        }
      }
    ],
    stateSave: true,
    serverSide: true
  });
  outerTableElement.on('init.dt', function(event) {
    var DataTableApi = outerTableElement.dataTable().api();
    var SearchPanesContainer = jQuery(DataTableApi.table().container()).children('div.searchPanes');
    SearchPanesContainer.append(jQuery('<div class="card card-body pt-5">').append(jQuery('<button class="close position-absolute" style="right:10px;top:5px;"><span>&times;</span></button>').on('click', function(event) {
      SearchPanesContainer.collapse('hide');
      event.preventDefault();
    })));
    new jQuery.fn.dataTable.SearchPanes(DataTableApi, {});
    DataTableApi.searchPanes.container().appendTo(SearchPanesContainer.find('div.card'));
    DataTableApi.searchPanes.resizePanes();
    event.stopPropagation();
  });
  outerTableElement.on('draw.dt', function() {
    outerTableElement.find('button.plus').on('click', function() {
      if(!$(this).hasClass('open')) {
        $(this).addClass('open');
        $(this).parents('tr').after('<tr><td colspan="3"><table class="inner" width="100%"><thead><tr><th>First name</th><th>Last name</th><th>Email</th></tr></thead></table></td></tr>');
        var innerTableElement = $(this).parents('tr').next('tr').find('table.inner');
        innerTableElement.DataTable({
          dom: 'B<".searchPanes collapse mb-3 mt-3 border border-warning">t',
          ajax: 'http://datatables.showroom.efficient.it/data/?simple',
          buttons: [
            {
              extend: 'searchPanes',
              config: {
                layout: 'columns-1',
                initCollapsed: true,
                cascadePanes: true,
                viewTotal: true
              },
              action: function() {
                var DataTableApi = innerTableElement.dataTable().api();
                jQuery(DataTableApi.table().container()).children('div.searchPanes').collapse('toggle');
              }
            }
          ],
          columns: [
            {
              data: 'first_name',
              searchPanes: {
                show: true
              }
            },
            {
              data: 'last_name',
              searchPanes: {
                show: true
              }
            },
            {
              data: 'email',
              searchPanes: {
                show: true
              }
            }
          ],
// this breaks the inner table          
          stateSave: true,
          serverSide: true
        });
        innerTableElement.on('init.dt', function(event) {
          var DataTableApi = innerTableElement.dataTable().api();
          var SearchPanesContainer = jQuery(DataTableApi.table().container()).children('div.searchPanes');
          SearchPanesContainer.append(jQuery('<div class="card card-body pt-5">').append(jQuery('<button class="close position-absolute" style="right:10px;top:5px;"><span>&times;</span></button>').on('click', function(event) {
            SearchPanesContainer.collapse('hide');
            event.preventDefault();
          })));
          new jQuery.fn.dataTable.SearchPanes(DataTableApi, {});
          DataTableApi.searchPanes.container().appendTo(SearchPanesContainer.find('div.card'));
          DataTableApi.searchPanes.resizePanes();
          event.stopPropagation();
        });
      }
    });
  });
});
Output 300px

You can jump to the latest bin by adding /latest to your URL

Dismiss x
public
Bin info
anonymouspro
0viewers