File
Add library
Share
Login or Register
Help
HTMLSaved
 
<!DOCTYPE html>
<html>
  <head>
    <script src="https://code.jquery.com/jquery-1.11.3.min.js"></script>
​
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/v/bs4-4.1.1/jszip-2.5.0/dt-1.10.20/af-2.3.4/b-1.6.1/b-html5-1.6.1/b-print-1.6.1/fh-3.1.6/kt-2.5.1/rg-1.1.1/sp-1.0.1/sl-1.3.1/datatables.min.css"/>
 
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/pdfmake.min.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/vfs_fonts.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/v/bs4-4.1.1/jszip-2.5.0/dt-1.10.20/af-2.3.4/b-1.6.1/b-html5-1.6.1/b-print-1.6.1/fh-3.1.6/kt-2.5.1/rg-1.1.1/sp-1.0.1/sl-1.3.1/datatables.min.js"></script>
​
    
    <meta charset=utf-8 />
    <title>DataTables - JS Bin</title>
  </head>
  <body>
    <div class="container">
      <button>Load Table</button>
      <table id="example" class="table table-striped table-bordered" 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>Firstname</th>
            <th>Lastname</th>
            <th>Position</th>
            <th>Office</th>
            <th>Start date</th>
            <th>Salary</th>
          </tr>
        </tfoot>
​
​
      </table>
    </div>
  </body>
</html>
CSSSaved
 
body {
  font: 90%/1.45em "Helvetica Neue", HelveticaNeue, Verdana, Arial, Helvetica, sans-serif;
  margin: 0;
  padding: 0;
  color: #333;
  background-color: #fff;
}
​
JavaScriptSaved
 
​
function getDT() {
    $.ajax({
      url: "/ssp/objects.php",
      success: function (data) {
        data = JSON.parse(data);
        $('#example').DataTable().rows.add(data.data).draw();
        $('#example').DataTable().searchPanes.rebuildPane();
      }
    });
}
​
​
$(document).ready( function () {
  var table = $('#example').DataTable({
    //ajax: "/ssp/objects.php",
        "columns": [
            { "data": "first_name" },
            { "data": "last_name" },
            { "data": "position" },
            { "data": "office" },
            { "data": "start_date" },
            { "data": "salary" }
        ],
    searchPanes:{
            cascadePanes: true,
            targets: [0, 1],
            dataLength: 50,
        },
  });
  
            new $.fn.dataTable.Buttons( table, [
                {
                        extend: 'excel',
                        text: 'Export Filtered Results (0)',
                        title: 'CDR_Report',
                        exportOptions: {
                            columns: '.export',
                            orthogonal: 'export'
                        },
​
                },
                {
                        extend: 'copy',
                        text: 'Copy Filtered Called Numbers (0)',
                        title: null,
                        header: false,
                        exportOptions: {
                            columns: '.called-number',
                            orthogonal: 'export'
                        },
​
                }
            ] );
​
            table.buttons().container()
                .prependTo( $(table.table().container() ) );
            table.searchPanes.container().prependTo(table.table().container());
 
$('button').on('click', function () {
  getDT();
});
  
} );
​
Output

This bin was created anonymously and its free preview time has expired. Get a free unrestricted account

Dismiss x
public
Bin info
anonymouspro
0viewers