javascript - 数据表 PDF 导出自定义总和元素-6ren

javascript - 数据表 PDF 导出自定义总和元素

转载作者：行者123 更新时间：2023-11-27 22:56:38

使用 Datatables v1.10 我想导出我的表格，包括表格外部的 HTML 元素，其中包括工资列的总和 -这可能吗？此总和会动态变化，单击按钮时应导出实时结果。

我创建了一个表格，可以成功过滤、显示总数，并导出带有自定义消息的 PDF，但我不确定如何将我的 total 元素添加到 PDF。

我希望 PDF 布局如下；

PDF 标题
总薪资
表格内容

我创建了一个 fiddle here代码如下。

window.onload = function() {
  $(document).ready(function() {
    $('#example').DataTable({
      dom: 'Bfrtip',
      buttons: [{
        extend: 'pdfHtml5',
        messageTop: 'PDF created by PDFMake with Buttons for DataTables.'
      }],
      "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);
          }, 0);

        // 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)'
        );
        $('#total').text('£' + Number(pageTotal).toFixed(2));
      }
    });
  });
}

<script type="text/javascript" src="https://code.jquery.com/jquery-3.3.1.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/buttons/1.5.6/js/dataTables.buttons.min.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.html5.min.js"></script>
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css">

<p>Total Salary: <span id="total"></span></p>
<table id="example" class="display" style="width:100%">
  <thead>
    <tr>
      <th>First name</th>
      <th>Last name</th>
      <th>Position</th>
      <th>Office</th>
      <th>Salary</th>
    </tr>
  </thead>
  <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>
  <tfoot>
    <tr>
      <th colspan="4" style="text-align:right">Total:</th>
      <th></th>
    </tr>
  </tfoot>
</table>

最佳答案

您需要enable footer将其导出。

buttons: [{
   extend: 'pdfHtml5',
   messageTop: function(){
      return "Total Salary: " + $("#total").text();
    },
   footer: true
}],

window.onload = function() {

  $(document).ready(function() {
    $('#example').DataTable({
      dom: 'Bfrtip',
      buttons: [{
        extend: 'pdfHtml5',
        messageTop: function(){
          return "Total Salary: " + $("#total").text();
        },
        footer: true
      }],
      "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);
          }, 0);

        // 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)'
        );
        $('#total').text('£' + Number(pageTotal).toFixed(2));
      }
    });
  });
}

<link rel="stylesheet" type="text/css" href="/css/result-light.css">

<script type="text/javascript" src="https://code.jquery.com/jquery-3.3.1.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/buttons/1.5.6/js/dataTables.buttons.min.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.html5.min.js"></script>
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css">

<p>Total Salary: <span id="total"></span></p>
<table id="example" class="display" style="width:100%">
  
  <thead>
    <tr>
      <th>First name</th>
      <th>Last name</th>
      <th>Position</th>
      <th>Office</th>
      <th>Salary</th>
    </tr>
  </thead>
  <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>
  <tfoot>
    <tr>
      <th colspan="4" style="text-align:right">Total:</th>
      <th></th>
    </tr>
  </tfoot>
</table>

关于javascript - 数据表 PDF 导出自定义总和元素，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/55473862/

文章推荐： c++ - move 和转发案例使用

文章推荐： javascript - $http服务从服务器下载json文件时抛出异常

文章推荐： css - 在 css 中使用正则表达式？

文章推荐： c++ - C++ 中的稳定排序

MySQL 总和 + 总和
我基本上有三个表: hunt_c_usershunt_c_collected_eggshunt_c_achievements 我目前只使用 hunt_c_users 和 hunt_c_collecte
SQL 总和
我已经计算了不同表中计数的总和。这会执行两次，每个 performanceID 一次。现在我想得到两个总和的总和。下面是我目前做的两个总和的代码: SELECT SUM((COUNT (Bo
Jquery 总和
我有一个对 2 个值求和的脚本。我计划添加更多值(value)，但首先我需要让它发挥作用。人们告诉我给他们 NUMBER 值，所以我这样做了，但现在它甚至没有给出输出。 base = 0; $("#F
MongoDB - 总和
我正在尝试计算在我们的数据库中跟踪的花费总额。每个订单文档包含一个字段“total_price” 我正在尝试使用以下代码: db.orders.aggregate({ $group: {
基于在另一个表中查找代码和值的 Excel 总和
给定 Excel 2013(或更高版本)中的 2 个命名表: tbl发票 ID InvRef Total 1 I/123 45 2 I/234
特殊表格之间的 VBA 总和
希望你们一切都好。我来这里是因为我从今天早上开始就试图解决一个问题，我再也受不了了。这就是上下文:我有一个 excel 工作簿，其中有不同的工作表，其中包含不同国家/地区的不同商业计划。我的目标是制
sql - 在查询结果中插入行(总和)
我有一份报告显示客户订购的产品及其价格: CompanyA Product 7 14.99 CompanyA Product 3 45.95 CompanyA Prod
python - Redis时间序列-总和
我使用此python客户端: https://github.com/ryananguiano/python-redis-timeseries 如何汇总所有匹配？ ts = TimeSeries(cli
excel - 总和/计数公式自动调整插入的行
希望创建一个总和和计数公式，该公式将自动调整以适应范围内插入的新行。例如，如果我在单元格 D55 中有公式 =SUM(D17:D54)。每次我在该范围内插入新行时，我都需要更改公式的顶部范围来解释它
python - 聚合具有相同日期的列(总和)
所以，我需要聚合日期相同的行。到目前为止，我的代码返回以下内容: date value source 0 2018-04-08 15:52:26.1
javascript - 将表中的数值相加(总和)
我有数字输入数量约为 30 我需要将它们全部汇总到一个字段我拥有的在下面查看:
具有特定数量条目的列的 MYSQL 总和
您好，我正在尝试根据以下数据计算过去三个月中出现不止一次的不同帐户 ID 的数量；我想要 2 作为查询结果，因为 test1@gmail.com 和 test2@gmail.com 出现超过 1 次。
php - 如何从一个表中选择与另一表中的差异(总和)？
我有两个带有以下字段的表: ... orders.orderID orders.orderValue 和 payments.orderID payments.payVal 在 payments.pay
来自别名未知列的 MySQL 总和
我想按 image_gallery 和 video_gallery 两列的 DESC 进行排序。 SELECT b.*, c.title as category, (S
mysql - 如何从别名查找mysql中的总计(总和)？
实际上我的原始数据库为 SELECT sum(data1,data2) as database_value,sum(data3,data4) as database_not_value from t
javascript - JavaScript 总和
我试图获取三个分数中每一个的值并将它们相加并显示在“总计:”中。我的问题是，我不知道如何做到这一点，以便每次其中一个分数值发生变化时，相应的总分值也会随之变化。我可以在某处调用“onchange”来
按第一个分组的元组列表中元组的第二个和第三个元素的 Python 总和
如何获得按第一个值分组的元组列表中第二个和第三个值的总和？即: list_of_tuples = [(1, 3, 1), (1, 2, 4), (2, 1, 0), (2, 2, 0)] expec
python - 总和、平均和其他
我正在尝试将我的列表中的整数转换为列表的总和和平均值，并说明任何低于冰点 F<32 的温度。每当我尝试获取总和或平均值时，我都会收到错误提示“+: 'int' 和 'str' 不支持的操作数类型”。我
ios - NSDecimalNumber 总和
在我的 ios 项目中，我使用了两个实体 (CoreData):具有一对多关系的 Person 和 Gifts 我知道如何计算给一个人的礼物总和: NSDecimalNumber *orderSum=
SQLITE:显示每个类别的总计(总和)
我有两个表(输入和类别): CREATE TABLE categories ( iId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, sNam

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

javascript - 数据表 PDF 导出自定义总和元素