/laravel-datatables

jQuery DataTables API for Laravel 4|5

Primary LanguagePHPMIT LicenseMIT

Datatables Package for Laravel 4|5

Laravel 4.2|5.0|5.1|5.2 Latest Stable Version Build Status Scrutinizer Code Quality Total Downloads License

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.

Feature Overview

  • 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.
    • Note: Use v4.x for Laravel 5 and v3.x for Laravel 4
  • 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.

Requirements:

Laravel 4.2 & DataTables v1.9.x Users

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.

Buy me a beer

Click here to lend your support to: Laravel Datatables and make a donation at pledgie.com !

Documentations

Quick Installation

composer require yajra/laravel-datatables-oracle:~6.0

Service Provider

Yajra\Datatables\DatatablesServiceProvider::class

Facade

Datatables facade are automatically registered as an alias for Yajra\Datatables\Datatables class.

Configuration and Assets

$ php artisan vendor:publish --tag=datatables

And that's it! Start building out some awesome DataTables!

Upgrading from v5.x to v6.x

  • Change all occurrences of yajra\Datatables to Yajra\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.

Contributing

Please see CONTRIBUTING for details.

Security

If you discover any security related issues, please email aqangeles@gmail.com instead of using the issue tracker.

Credits

License

The MIT License (MIT). Please see License File for more information.