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 href="https://cdn.datatables.net/1.13.5/css/jquery.dataTables.css" rel="stylesheet" type="text/css" />
    <script src="https://cdn.datatables.net/1.13.5/js/jquery.dataTables.js"></script>
    <link href="https://cdn.datatables.net/responsive/2.5.0/css/responsive.dataTables.css" rel="stylesheet" type="text/css" />
    <script src="https://cdn.datatables.net/responsive/2.5.0/js/dataTables.responsive.js"></script>
​
    <meta charset=utf-8 />
    <title>DataTables - JS Bin</title>
  </head>
  <body>
    <div class="container">
                <table id="quoteTable" class="display">
                    <thead>
                        <tr>
                            <th>ID</th>
                            <th>Stage</th>
                            <th>Item Name</th>
                            <th>Item Description</th>
                            <th>No Of Skilled Labours</th>
                            <th>No Of Un-Skilled Labours</th>
                            <th>Machineries</th>
                            <th>Quantity</th>
                            <th>Unit</th>
                            <th>Estimated Price</th>
                            <th>Estimated Amount</th>
                            <th>Item Type</th>
                            <th>Rate Offered</th>
                            <th>Rate Variation %</th>
                            <th>Amount</th>
                            <th>Days</th>
                        </tr>
                    </thead>
                    <tbody>
                        <!-- DataTable content will be loaded here -->
                    </tbody>
                    <tfoot class="tfoot">
                        <tr>
                            <th colspan="15" style="text-align:right">Total:</th>
                          <th></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
 
​
var table = new DataTable('#quoteTable', {
  responsive: true,
  processing: true,
  serverSide: true,
  ajax: {
    url: '/ssp/objects.php',
    type: 'post'
  },
  columns: [
    { data: 'first_name' },
    { data: 'last_name' },
    { data: 'position' },
    { data: 'office' },
    { data: 'start_date' },
    { data: 'salary' },
    { data: 'first_name' },
    { data: 'last_name' },
    { data: 'position' },
    { data: 'office' },
    { data: 'start_date' },
    { data: 'salary' },
    { data: 'first_name' },
    { data: 'last_name' },
    { data: 'start_date', className: 'all' },
    { data: 'salary', className: 'all' },
  ],
                footerCallback: function(row, data, start, end, display) {
                    var api = this.api();
 
                    // Remove the formatting to get the integer data for summation
                    var intVal = function(i) {
                        return typeof i === 'string' ?
                            i.replace(/[\$,]/g, '') * 1 :
                            typeof i === 'number' ?
                            i :
                            0;
                    };
 
                    // Total amount calculation
                    var totalAmount = api.column(15, {
                        search: 'applied'
                    }).data().reduce(function(a, b) {
                        return intVal(a) + intVal(b || 0);
                    }, 0);
 
                    // Set the value to the footer
                    $(api.column(15).footer()).html(totalAmount.toFixed(2));
                },
    });
​
Output

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

Dismiss x
public
Bin info
anonymouspro
0viewers