EXPORT PDF

lauromneto

Is there any way to export 2 datatables in a single pdf with a single button?

lauromneto

---- SOLVED ----

No HTML:
<button id="ExportPdf" type="button">Export All</button>

No JS:
$(document).ready(function(){
$('#ExportPdf').click(function(){
var config = {
className:"buttons-pdf buttons-html5",
customize:null,
download:"download",
exportOptions:{},
extension:".pdf",
filename:"",
footer:true,
header:true,
messageBottom:"",
messagetop:"",
namespace:".dt-button-2",
orientation:"portrait",
pageSize:"A4",
title:""
};

                var tables = ["table1","table2"];
                var tablesConverted = {};
                for(var k=0;k<tables.length;k++)
                {
                    var dt = $('#'+tables[k]).DataTable();
                    var data = dt.buttons.exportData( config.exportOptions );
                    var info = dt.buttons.exportInfo( config );

                    var rows = [];

                        if ( config.header ) {
                            rows.push( $.map( data.header, function ( d ) {
                                return {
                                    text: typeof d === 'string' ? d : d+'',
                                    style: 'tableHeader'
                                };
                            } ) );
                        }

                        for ( var i=0, ien=data.body.length ; i<ien ; i++ ) {
                            rows.push( $.map( data.body[i], function ( d ) {
                                return {
                                    text: typeof d === 'string' ? d : d+'',
                                    style: i % 2 ? 'tableBodyEven' : 'tableBodyOdd'
                                };
                            } ) );
                        }

                        if ( config.footer && data.footer) {
                            rows.push( $.map( data.footer, function ( d ) {
                                return {
                                    text: typeof d === 'string' ? d : d+'',
                                    style: 'tableFooter'
                                };
                            } ) );
                        }

                        tablesConverted[tables[k]]=rows;
                }


                    var doc = {
                        pageSize: config.pageSize,
                        pageOrientation: config.orientation,
                        content: [
                            "Data for "+tables[0],
                            {
                                table: {
                                    headerRows: 1,
                                    body: tablesConverted[tables[0]]
                                },
                                layout: 'noBorders'
                            },
                            " ",
                            "Data for "+tables[1],
                            " ",
                            {
                                table: {
                                    headerRows: 1,
                                    body: tablesConverted[tables[1]]
                                },
                                layout: 'noBorders'
                            },

                        ],
                        styles: {
                            tableHeader: {
                                bold: true,
                                fontSize: 11,
                                color: 'white',
                                fillColor: '#2d4154',
                                alignment: 'center'
                            },
                            tableBodyEven: {},
                            tableBodyOdd: {
                                fillColor: '#f3f3f3'
                            },
                            tableFooter: {
                                bold: true,
                                fontSize: 11,
                                color: 'white',
                                fillColor: '#2d4154'
                            },
                            title: {
                                alignment: 'center',
                                fontSize: 15
                            },
                            message: {}
                        },
                        defaultStyle: {
                            fontSize: 10
                        }
                    };

                    if ( info.messageTop ) {
                        doc.content.unshift( {
                            text: info.messageTop,
                            style: 'message',
                            margin: [ 0, 0, 0, 12 ]
                        } );
                    }

                    if ( info.messageBottom ) {
                        doc.content.push( {
                            text: info.messageBottom,
                            style: 'message',
                            margin: [ 0, 0, 0, 12 ]
                        } );
                    }

                    if ( info.title ) {
                        doc.content.unshift( {
                            text: info.title,
                            style: 'title',
                            margin: [ 0, 0, 0, 12 ]
                        } );
                    }

                    if ( config.customize ) {
                        config.customize( doc, config );
                    }


            pdfMake.createPdf(doc).download('optionalName.pdf');
        });
    });

lauromneto

Or you can put in action: (......) in the buttons' own extend PDF!