By Hardik Savani July 4, 2020 Category : LaravelPlayUnmuteLoaded: 0.26%FullscreenHi Dev,
In this quick example, let's see laravel datatables export pdf. you'll learn how to add export pdf button in yajra datatable. This article goes in detailed on laravel yajra datatable pdf export button. step by step explain laravel yajra datatable export buttons pdf.
Here, Creating a basic example of datatables pdf with button in laravel 6, laravel 7, laravel 8 and laravel 9.
In this post, i will show you step by step how to add pdf buttons in Laravel Yajra Datatables. we will use yajra/laravel-datatables-buttons package to adding export button in your datatables. you can easily export table data into pdf file so it can help you to export it.
we need to use snappy for generate pdf file with laravel yajra datatable.
So, let's follow few step to done how to export pdf file from datatable in laravel application.
So let's follow this tutorial and you will get layout as like bellow:
Preview:
Step 1: Install Laravel
In this step, if you haven't laravel application setup then we have to get fresh laravel 7 application. So run bellow command and get clean fresh laravel 7 application.
composer create-project --prefer-dist laravel/laravel blog
Step 2 : Install Yajra Datatable
We need to install yajra datatable composer package for datatable and yajra/laravel-datatables-buttons export buttons, so you can install using following command:
Here, we need to create User DataTable class using Yajra Datatable command. so let's run bellow command:
php artisan datatables:make Users
app/DataTables/UsersDataTable.php
<?php namespace App\DataTables; use App\User;use Yajra\DataTables\Html\Button;use Yajra\DataTables\Html\Column;use Yajra\DataTables\Html\Editor\Editor;use Yajra\DataTables\Html\Editor\Fields;use Yajra\DataTables\Services\DataTable; class UsersDataTable extends DataTable{ /** * Build DataTable class. * * @param mixed $query Results from query() method. * @return \Yajra\DataTables\DataTableAbstract */ public function dataTable($query) { return datatables() ->eloquent($query); } /** * Get query source of dataTable. * * @param \App\User $model * @return \Illuminate\Database\Eloquent\Builder */ public function query(User $model) { return $model->newQuery(); } /** * Optional method if you want to use html builder. * * @return \Yajra\DataTables\Html\Builder */ public function html() { return $this->builder() ->setTableId('users-table') ->columns($this->getColumns()) ->minifiedAjax() ->orderBy(1) ->parameters([ 'dom' => 'Bfrtip', 'buttons' => ['pdf'], ]); } /** * Get columns. * * @return array */ protected function getColumns() { return [ Column::make('id'), Column::make('name'), Column::make('email'), ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'Users_' . date('YmdHis'); }}
Step 6: Add Route
In this is step we need to create route for datatables layout file and another one for getting data. so open your routes/web.php file and add following route.
routes/web.php
Route::get('users', 'UserController@index');
Step 7: Create Controller
In this point, now we should create new controller as UserController. this controller will manage layout and getting data request and return response, so put bellow content in controller file:
app/Http/Controllers/UserController.php
<?php namespace App\Http\Controllers; use Illuminate\Http\Request;use App\DataTables\UsersDataTable; class UserController extends Controller{ /** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(UsersDataTable $dataTable) { return $dataTable->render('users'); }}
Step 8: Create View
In Last step, let's create users.blade.php(resources/views/users.blade.php) for layout and we will write design code here and put following code:
PlayUnmuteLoaded: 0.26%Fullscreen
Hi Dev,
