此例子演示通过 footerCallback
回调函数统计本页工资总数
First name | Last name | Position | Office | Salary |
---|---|---|---|---|
Total: | ||||
Tiger | Nixon | System Architect | Edinburgh | $320,800 |
Garrett | Winters | Accountant | Tokyo | $170,750 |
Ashton | Cox | Junior Technical Author | San Francisco | $86,000 |
Cedric | Kelly | Senior Javascript Developer | Edinburgh | $433,060 |
Airi | Satou | Accountant | Tokyo | $162,700 |
Brielle | Williamson | Integration Specialist | New York | $372,000 |
Herrod | Chandler | Sales Assistant | San Francisco | $137,500 |
Rhona | Davidson | Integration Specialist | Tokyo | $327,900 |
Colleen | Hurst | Javascript Developer | San Francisco | $205,500 |
Sonya | Frost | Software Engineer | Edinburgh | $103,600 |
Jena | Gaines | Office Manager | London | $90,560 |
Quinn | Flynn | Support Lead | Edinburgh | $342,000 |
Charde | Marshall | Regional Director | San Francisco | $470,600 |
Haley | Kennedy | Senior Marketing Designer | London | $313,500 |
Tatyana | Fitzpatrick | Regional Director | London | $385,750 |
Michael | Silva | Marketing Designer | London | $198,500 |
Paul | Byrd | Chief Financial Officer (CFO) | New York | $725,000 |
Gloria | Little | Systems Administrator | New York | $237,500 |
Bradley | Greer | Software Engineer | London | $132,000 |
Dai | Rios | Personnel Lead | Edinburgh | $217,500 |
Jenette | Caldwell | Development Lead | New York | $345,000 |
Yuri | Berry | Chief Marketing Officer (CMO) | New York | $675,000 |
Caesar | Vance | Pre-Sales Support | New York | $106,450 |
Doris | Wilder | Sales Assistant | Sidney | $85,600 |
Angelica | Ramos | Chief Executive Officer (CEO) | London | $1,200,000 |
Gavin | Joyce | Developer | Edinburgh | $92,575 |
Jennifer | Chang | Regional Director | Singapore | $357,650 |
Brenden | Wagner | Software Engineer | San Francisco | $206,850 |
Fiona | Green | Chief Operating Officer (COO) | San Francisco | $850,000 |
Shou | Itou | Regional Marketing | Tokyo | $163,000 |
Michelle | House | Integration Specialist | Sidney | $95,400 |
Suki | Burks | Developer | London | $114,500 |
Prescott | Bartlett | Technical Author | London | $145,000 |
Gavin | Cortez | Team Leader | San Francisco | $235,500 |
Martena | Mccray | Post-Sales support | Edinburgh | $324,050 |
Unity | Butler | Marketing Designer | San Francisco | $85,675 |
Howard | Hatfield | Office Manager | San Francisco | $164,500 |
Hope | Fuentes | Secretary | San Francisco | $109,850 |
Vivian | Harrell | Financial Controller | San Francisco | $452,500 |
Timothy | Mooney | Office Manager | London | $136,200 |
Jackson | Bradshaw | Director | New York | $645,750 |
Olivia | Liang | Support Engineer | Singapore | $234,500 |
Bruno | Nash | Software Engineer | London | $163,500 |
Sakura | Yamamoto | Support Engineer | Tokyo | $139,575 |
Thor | Walton | Developer | New York | $98,540 |
Finn | Camacho | Support Engineer | San Francisco | $87,500 |
Serge | Baldwin | Data Coordinator | Singapore | $138,575 |
Zenaida | Frank | Software Engineer | New York | $125,250 |
Zorita | Serrano | Software Engineer | San Francisco | $115,000 |
Jennifer | Acosta | Junior Javascript Developer | Edinburgh | $75,650 |
Cara | Stevens | Sales Assistant | New York | $145,600 |
Hermione | Butler | Regional Director | London | $356,250 |
Lael | Greer | Systems Administrator | London | $103,500 |
Jonas | Alexander | Developer | San Francisco | $86,500 |
Shad | Decker | Regional Director | Edinburgh | $183,000 |
Michael | Bruce | Javascript Developer | Singapore | $183,000 |
Donna | Snider | Customer Support | New York | $112,000 |
$(document).ready(function() { $('#example').dataTable( { "footerCallback": function ( row, data, start, end, display ) { var api = this.api(), data; // Remove the formatting to get integer data for summation var intVal = function ( i ) { return typeof i === 'string' ? i.replace(/[\$,]/g, '')*1 : typeof i === 'number' ? i : 0; }; // Total over all pages total = api .column( 4 ) .data() .reduce( function (a, b) { return intVal(a) + intVal(b); } ); // Total over this page pageTotal = api .column( 4, { page: 'current'} ) .data() .reduce( function (a, b) { return intVal(a) + intVal(b); }, 0 ); // Update footer $( api.column( 4 ).footer() ).html( '$'+pageTotal +' ( $'+ total +' total)' ); } } ); } );
<table id="example" class="display" cellspacing="0" width="100%"> <thead> <tr> <th>First name</th> <th>Last name</th> <th>Position</th> <th>Office</th> <th>Salary</th> </tr> </thead> <tfoot> <tr> <th colspan="4" style="text-align:right">Total:</th> <th></th> </tr> </tfoot> <tbody> <tr> <td>Tiger</td> <td>Nixon</td> <td>System Architect</td> <td>Edinburgh</td> <td>$320,800</td> </tr> <tr> <td>Garrett</td> <td>Winters</td> <td>Accountant</td> <td>Tokyo</td> <td>$170,750</td> </tr> <tr> <td>Ashton</td> <td>Cox</td> <td>Junior Technical Author</td> <td>San Francisco</td> <td>$86,000</td> </tr> <tr> <td>Cedric</td> <td>Kelly</td> <td>Senior Javascript Developer</td> <td>Edinburgh</td> <td>$433,060</td> </tr> <tr> <td>Airi</td> <td>Satou</td> <td>Accountant</td> <td>Tokyo</td> <td>$162,700</td> </tr> <tr> <td>Brielle</td> <td>Williamson</td> <td>Integration Specialist</td> <td>New York</td> <td>$372,000</td> </tr> <tr> <td>Herrod</td> <td>Chandler</td> <td>Sales Assistant</td> <td>San Francisco</td> <td>$137,500</td> </tr> <tr> <td>Rhona</td> <td>Davidson</td> <td>Integration Specialist</td> <td>Tokyo</td> <td>$327,900</td> </tr> <tr> <td>Colleen</td> <td>Hurst</td> <td>Javascript Developer</td> <td>San Francisco</td> <td>$205,500</td> </tr> <tr> <td>Sonya</td> <td>Frost</td> <td>Software Engineer</td> <td>Edinburgh</td> <td>$103,600</td> </tr> <tr> <td>Jena</td> <td>Gaines</td> <td>Office Manager</td> <td>London</td> <td>$90,560</td> </tr> <tr> <td>Quinn</td> <td>Flynn</td> <td>Support Lead</td> <td>Edinburgh</td> <td>$342,000</td> </tr> <tr> <td>Charde</td> <td>Marshall</td> <td>Regional Director</td> <td>San Francisco</td> <td>$470,600</td> </tr> <tr> <td>Haley</td> <td>Kennedy</td> <td>Senior Marketing Designer</td> <td>London</td> <td>$313,500</td> </tr> <tr> <td>Tatyana</td> <td>Fitzpatrick</td> <td>Regional Director</td> <td>London</td> <td>$385,750</td> </tr> <tr> <td>Michael</td> <td>Silva</td> <td>Marketing Designer</td> <td>London</td> <td>$198,500</td> </tr> <tr> <td>Paul</td> <td>Byrd</td> <td>Chief Financial Officer (CFO)</td> <td>New York</td> <td>$725,000</td> </tr> <tr> <td>Gloria</td> <td>Little</td> <td>Systems Administrator</td> <td>New York</td> <td>$237,500</td> </tr> <tr> <td>Bradley</td> <td>Greer</td> <td>Software Engineer</td> <td>London</td> <td>$132,000</td> </tr> <tr> <td>Dai</td> <td>Rios</td> <td>Personnel Lead</td> <td>Edinburgh</td> <td>$217,500</td> </tr> <tr> <td>Jenette</td> <td>Caldwell</td> <td>Development Lead</td> <td>New York</td> <td>$345,000</td> </tr> <tr> <td>Yuri</td> <td>Berry</td> <td>Chief Marketing Officer (CMO)</td> <td>New York</td> <td>$675,000</td> </tr> <tr> <td>Caesar</td> <td>Vance</td> <td>Pre-Sales Support</td> <td>New York</td> <td>$106,450</td> </tr> <tr> <td>Doris</td> <td>Wilder</td> <td>Sales Assistant</td> <td>Sidney</td> <td>$85,600</td> </tr> <tr> <td>Angelica</td> <td>Ramos</td> <td>Chief Executive Officer (CEO)</td> <td>London</td> <td>$1,200,000</td> </tr> <tr> <td>Gavin</td> <td>Joyce</td> <td>Developer</td> <td>Edinburgh</td> <td>$92,575</td> </tr> <tr> <td>Jennifer</td> <td>Chang</td> <td>Regional Director</td> <td>Singapore</td> <td>$357,650</td> </tr> <tr> <td>Brenden</td> <td>Wagner</td> <td>Software Engineer</td> <td>San Francisco</td> <td>$206,850</td> </tr> <tr> <td>Fiona</td> <td>Green</td> <td>Chief Operating Officer (COO)</td> <td>San Francisco</td> <td>$850,000</td> </tr> <tr> <td>Shou</td> <td>Itou</td> <td>Regional Marketing</td> <td>Tokyo</td> <td>$163,000</td> </tr> <tr> <td>Michelle</td> <td>House</td> <td>Integration Specialist</td> <td>Sidney</td> <td>$95,400</td> </tr> <tr> <td>Suki</td> <td>Burks</td> <td>Developer</td> <td>London</td> <td>$114,500</td> </tr> <tr> <td>Prescott</td> <td>Bartlett</td> <td>Technical Author</td> <td>London</td> <td>$145,000</td> </tr> <tr> <td>Gavin</td> <td>Cortez</td> <td>Team Leader</td> <td>San Francisco</td> <td>$235,500</td> </tr> <tr> <td>Martena</td> <td>Mccray</td> <td>Post-Sales support</td> <td>Edinburgh</td> <td>$324,050</td> </tr> <tr> <td>Unity</td> <td>Butler</td> <td>Marketing Designer</td> <td>San Francisco</td> <td>$85,675</td> </tr> <tr> <td>Howard</td> <td>Hatfield</td> <td>Office Manager</td> <td>San Francisco</td> <td>$164,500</td> </tr> <tr> <td>Hope</td> <td>Fuentes</td> <td>Secretary</td> <td>San Francisco</td> <td>$109,850</td> </tr> <tr> <td>Vivian</td> <td>Harrell</td> <td>Financial Controller</td> <td>San Francisco</td> <td>$452,500</td> </tr> <tr> <td>Timothy</td> <td>Mooney</td> <td>Office Manager</td> <td>London</td> <td>$136,200</td> </tr> <tr> <td>Jackson</td> <td>Bradshaw</td> <td>Director</td> <td>New York</td> <td>$645,750</td> </tr> <tr> <td>Olivia</td> <td>Liang</td> <td>Support Engineer</td> <td>Singapore</td> <td>$234,500</td> </tr> <tr> <td>Bruno</td> <td>Nash</td> <td>Software Engineer</td> <td>London</td> <td>$163,500</td> </tr> <tr> <td>Sakura</td> <td>Yamamoto</td> <td>Support Engineer</td> <td>Tokyo</td> <td>$139,575</td> </tr> <tr> <td>Thor</td> <td>Walton</td> <td>Developer</td> <td>New York</td> <td>$98,540</td> </tr> <tr> <td>Finn</td> <td>Camacho</td> <td>Support Engineer</td> <td>San Francisco</td> <td>$87,500</td> </tr> <tr> <td>Serge</td> <td>Baldwin</td> <td>Data Coordinator</td> <td>Singapore</td> <td>$138,575</td> </tr> <tr> <td>Zenaida</td> <td>Frank</td> <td>Software Engineer</td> <td>New York</td> <td>$125,250</td> </tr> <tr> <td>Zorita</td> <td>Serrano</td> <td>Software Engineer</td> <td>San Francisco</td> <td>$115,000</td> </tr> <tr> <td>Jennifer</td> <td>Acosta</td> <td>Junior Javascript Developer</td> <td>Edinburgh</td> <td>$75,650</td> </tr> <tr> <td>Cara</td> <td>Stevens</td> <td>Sales Assistant</td> <td>New York</td> <td>$145,600</td> </tr> <tr> <td>Hermione</td> <td>Butler</td> <td>Regional Director</td> <td>London</td> <td>$356,250</td> </tr> <tr> <td>Lael</td> <td>Greer</td> <td>Systems Administrator</td> <td>London</td> <td>$103,500</td> </tr> <tr> <td>Jonas</td> <td>Alexander</td> <td>Developer</td> <td>San Francisco</td> <td>$86,500</td> </tr> <tr> <td>Shad</td> <td>Decker</td> <td>Regional Director</td> <td>Edinburgh</td> <td>$183,000</td> </tr> <tr> <td>Michael</td> <td>Bruce</td> <td>Javascript Developer</td> <td>Singapore</td> <td>$183,000</td> </tr> <tr> <td>Donna</td> <td>Snider</td> <td>Customer Support</td> <td>New York</td> <td>$112,000</td> </tr> </tbody> </table>
http://datatables.net/examples/advanced_init/footer_callback.html
Translation from DataTables.net, with permission