I am using Yajra Datatables to query a list of users on the server side. I added all dependencies but the button is not showing. Buttons are Copy, PDF, CSV, and even display custom buttons. I've tried using different versions of JQuery but still nothing. When I just initialize the datatable with the data array from the view, the buttons show up and work fine, but when I add the datasource from the route and server side, the buttons don't show up. Is something missing? Below is my server side processing code, the button is not shown. I also don't get console errors when debugging.
data source
public function index(Request $request) if ($request->ajax()) { $users = User::select( "users.id", "users.first_name", "users.last_name", "users.email", "users.created_at", "roles.name as role_name") ->join("roles", "roles.id", "=", "users.role_id") ->where("users.status", "=", 1) ->get(); return Datatables::of($users) ->addIndexColumn() ->make(true); } return view('users/index'); }
sheet
<table id="example1" class="table table-bordered table-striped"> <thead> <tr> <th>Email</th> <th>First Name</th> <th>Last Name</th> <th>Date Added</th> </tr> </thead> <tbody> </tbody> </table> <script> $(function () { $("#example1").DataTable({ processing: true, serverSide: true, ajax: { url: '{{ route('users.home') }}', }, columns: [ {data: 'email', name: 'email'}, {data: 'first_name', name: 'first_name'}, {data: 'last_name', name: 'last_name'}, { data: "created_at", "render": function (value) { if (value === null) return ""; return moment(value).format('DD/MM/YYYY'); } } ], "responsive": false, "lengthChange": false, "autoWidth": false, "buttons": ["copy", "csv", "excel", "pdf", "print", "colvis"] }).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)'); }); </script>
Here are my CSS and JS libraries
CSS
<link rel="stylesheet" href="{{ asset('plugins/datatables-bs4/css/dataTables.bootstrap4.min.css') }}"> <link rel="stylesheet" href="{{ asset('plugins/datatables-responsive/css/responsive.bootstrap4.min.css') }}"> <link rel="stylesheet" href="{{ asset('plugins/datatables-buttons/css/buttons.bootstrap4.min.css') }}">
JS
<script src="{{ asset('plugins/datatables/jquery.dataTables.min.js') }}"></script> <script src="{{ asset('plugins/datatables-buttons/js/dataTables.buttons.min.js') }}"></script> <script src="{{ asset('plugins/jszip/jszip.min.js') }}"></script> <script src="{{ asset('plugins/pdfmake/pdfmake.min.js') }}"></script> <script src="{{ asset('plugins/pdfmake/vfs_fonts.js') }}"></script> <script src="{{ asset('plugins/datatables-buttons/js/buttons.html5.min.js') }}"></script>
When I cycle through the table using php or blade the buttons will show:
<?php if(isset($users) && count($users)>0){ ?> <table id="example1" class="table table-bordered table-striped"> <thead> <tr> <th>Email</th> <th>First Name</th> <th>Last Name</th> </tr> </thead> <tbody> <?php foreach($users as $user){ ?> <tr> <td><?php echo $user['email']; ?></td> <td><?php echo $user['first_name']; ?></td> <td><?php echo $user['last_name']; ?></td> </tr> <?php } ?> </tbody> </table> <?php }else { echo "No Users Available"; } ?>
Table initialization
<script> $("#example1").DataTable({ "responsive": true, "lengthChange": false, "autoWidth": false, "buttons": ["copy", "csv", "excel", "pdf", "print", "colvis"] }).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)'); }); </script>
Try the code below. You are missing DOM element
for lBfrtip