<!-- DataTables & Plugins -->
<script src="{{ asset('AdminLte/plugins/datatables/jquery.dataTables.min.js') }}"></script>
<script src="{{ asset('AdminLte/plugins/datatables-bs4/js/dataTables.bootstrap4.min.js') }}"></script>
<script src="{{ asset('AdminLte/plugins/datatables-responsive/js/dataTables.responsive.min.js') }}"></script>
<script src="{{ asset('AdminLte/plugins/datatables-responsive/js/responsive.bootstrap4.min.js') }}"></script>
<script src="{{ asset('AdminLte/plugins/datatables-buttons/js/dataTables.buttons.min.js') }}"></script>
<script src="{{ asset('AdminLte/plugins/datatables-buttons/js/buttons.bootstrap4.min.js') }}"></script>
<script src="{{ asset('AdminLte/plugins/jszip/jszip.min.js') }}"></script>
<script src="{{ asset('AdminLte/plugins/pdfmake/pdfmake.min.js') }}"></script>
<script src="{{ asset('AdminLte/plugins/pdfmake/vfs_fonts.js') }}"></script>
<script src="{{ asset('AdminLte/plugins/datatables-buttons/js/buttons.html5.min.js') }}"></script>
<script src="{{ asset('AdminLte/plugins/datatables-buttons/js/buttons.print.min.js') }}"></script>
<script src="{{ asset('AdminLte/plugins/datatables-buttons/js/buttons.colVis.min.js') }}"></script>
<script>
$(function () {
$("#tabel-data").DataTable({
"responsive": true, "lengthChange": false, "autoWidth": false,
buttons: [
'pageLength', "colvis",
{
extend: 'print',
exportOptions: {
columns: ':not(.no-export)'
},
customize: function ( win ) {
$(win.document.body)
.css( 'font-size', '10pt' )
$(win.document.body).find( 'table' )
.addClass( 'compact' )
.css( 'font-size', 'inherit' );
},
messageTop: 'This print was produced using the Print button for DataTables'
},
{
extend: 'excel',
exportOptions: {
columns: ':not(.no-export)'
}
},
{
extend: "copy",
exportOptions: {
columns: ':not(.no-export)'
}
},
],
lengthMenu: [
[ 10, 25, 50, -1 ],
[ '10 rows', '25 rows', '50 rows', 'Show all' ]
],
columnDefs: [{
'targets': -1, // column index (start from 0)
'orderable': false, // set orderable false for selected columns
}],
}).buttons().container().appendTo('#tabel-data_wrapper .col-md-6:eq(0)');
});
</script>