This package is created to handle server-side works of DataTables jQuery Plugin via AJAX option by using Eloquent ORM, Fluent Query Builder or Collection.
- Supports the following data source
- Eloquent ORM
- Fluent Query Builder
- Collection [available on v5.x and later]
- DataTable Service Implementation (v6.x).
- Adding or editing content of columns and removing columns
- Modify column values via Blade Template Engine or by using Closure
- Works with ALL the DATABASE supported by Laravel
- Works with Oracle Database using Laravel-OCI8 package
- Works with DataTables v1.10++.
- Note: DT Legacy code is not supported on v5.x
- Works with DataTables v1.9 and v1.10 legacy code.
- Extended column filtering via
filterColumn
API. - Extended column ordering via
orderColumn
API. - Extended Query Builder functionality allowing you to filter using Datatables class directly.
- Decorate your data output using
league\fractal
Transformer with Serializer support. - Works with Laravel Dependency Injection and IoC Container.
- Provides a DataTable Html Builder to help you use the package with less code.
- Provides XSS filtering function to optionally escape all or specified column values using
escapeColumns('*'\['column'])
method. - Provides Query Logging when application is in debug state. Important: Make sure that debug is set to false when your code is in production
- Easily attach a resource on json response via
->with()
method. - Built-in support for exporting to CSV, EXCEL and PDF using Laravel-Excel.
- Built-in printer friendly view or create your own by overriding
printPreview()
method. - Provides an artisan command for generating a DataTable service and scope.
- See change logs for more details.
- PHP 5.5.9 or later.
- Laravel 5.0 or later.
- DataTables jQuery Plugin v1.10.x
Most of the latest updates/features are not available on these versions. Please check L4 Branch and L5 DT1.9 for old documentations of its features.
- You will find user friendly and updated documentation in the wiki here: Laravel Datatables Wiki
- You will find the API Documentation here: Laravel Datatables API
- Demo Application is available for artisan's reference.
composer require yajra/laravel-datatables-oracle:~6.0
Yajra\Datatables\DatatablesServiceProvider::class
Datatables
facade are automatically registered as an alias for Yajra\Datatables\Datatables
class.
$ php artisan vendor:publish --tag=datatables
And that's it! Start building out some awesome DataTables!
- Change all occurrences of
yajra\Datatables
toYajra\Datatables
. (Use Sublime's find and replace all for faster update). - Remove
Datatables
facade registration. - Temporarily comment out
Yajra\Datatables\DatatablesServiceProvider
. - Update package version on your composer.json and use
yajra/laravel-datatables-oracle: ~6.0
- Uncomment the provider
Yajra\Datatables\DatatablesServiceProvider
.
Please see CONTRIBUTING for details.
If you discover any security related issues, please email [email protected] instead of using the issue tracker.
- This project is used to be a fork from bllim/laravel4-datatables-package.
- All Contributors
The MIT License (MIT). Please see License File for more information.