c3media asked 5 years ago
Hello,
I created a invoice based in tcpdf library filtered export from here demos/export/export-detail.php
How to show total sum of filtered export in footer?
c3media answered 5 years ago
Abu Ghufran Staff answered 5 years ago
You can refer this demo and code:
http://phpgrid.org/demo/demos/appearance/footer-row.php (click pdf button in toolbar)
Code: http://phpgrid.org/demo/demos/appearance/footer-row.phps
It uses html based pdf generation using tcpdf.
C3media answered 5 years ago
I need it for pos paper size so:
$grid[“export”] = array(“filename”=>”my-file”, “format”=>”pdf”, “heading”=>”Invoice Details”, “orientation”=>”portrait”, “paper”=>”A7”);
Then total hide from footer.
How to solve it?
Thank you
Abu Ghufran Staff answered 5 years ago
Hello,
I tested your github code. In custom html pdf code, you need to have a new TR that will hold footer data. e.g.
line 129:
$total = “1232.00”;
$html .= “<tr bgcolor=\”lightgrey\”><td></td><td></td><td align=’right’><strong>Total: $total</strong></td><td></td><td></td></tr>”;
$html .= ‘</table>’;
return $html;
…….
For that $total value should be fetched from database manually.
