PHPackages bllim/datatables - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Utility & Helpers](/categories/utility) 4. / 5. bllim/datatables ActiveLibrary[Utility & Helpers](/categories/utility) bllim/datatables ================ Server-side handler of DataTables Jquery Plugin for Laravel 4 v1.4.4(11y ago)261413.7k↓39.7%109[39 issues](https://github.com/bllim/laravel4-datatables-package/issues)[2 PRs](https://github.com/bllim/laravel4-datatables-package/pulls)4MITPHPPHP >=5.3.0 Since Aug 19Pushed 7y ago17 watchersCompare [ Source](https://github.com/bllim/laravel4-datatables-package)[ Packagist](https://packagist.org/packages/bllim/datatables)[ RSS](/packages/bllim-datatables/feed)WikiDiscussions master Synced 1mo ago READMEChangelog (10)Dependencies (7)Versions (13)Used By (4) ### Project is not being maintained actively. [](#project-is-not-being-maintained-actively) You will most likely find a better more actively maintained fork here If you have issues please try and fix them and we will pull the changes if we can verify they work. That being said this project lacks automatic testing so it has become a difficult project to maintain. Please let us know if you are interested in adopting and maintaining this project, it is still pretty useful. 60% of the time, it works every time. Datatables Bundle for Laravel 4 ------------------------------- [](#datatables-bundle-for-laravel-4) **About** This bundle is created to handle the server-side processing of the DataTables Jquery Plugin () by using Eloquent ORM or Fluent Query Builder. ### Feature Overview [](#feature-overview) - Supporting Eloquent ORM and Fluent Query Builder - Adding or editing the contents of columns and removing columns - Templating new or current columns via Blade Template Engine - Customizable search in columns ### Installation [](#installation) Require `bllim/datatables` in composer.json and run `composer update`. ``` { "require": { "laravel/framework": "4.0.*", ... "bllim/datatables": "*" } ... } ``` Composer will download the package. After the package is downloaded, open `app/config/app.php` and add the service provider and alias as below: ``` 'providers' => array( ... 'Bllim\Datatables\DatatablesServiceProvider', ), 'aliases' => array( ... 'Datatables' => 'Bllim\Datatables\Facade\Datatables', ), ``` Finally you need to publish a configuration file by running the following Artisan command. ``` $ php artisan config:publish bllim/datatables ``` ### Usage [](#usage) It is very simple to use this bundle. Just create your own fluent query object or eloquent object without getting results (that means don't use get(), all() or similar methods) and give it to Datatables. You are free to use all Eloquent ORM and Fluent Query Builder features. Some things you should know: - When you call the `select` method on Eloquent or Fluenty Query, you choose columns. - Modifying columns - You can easily edit columns by using `edit_column($column, $content)` - You can remove any column by using `remove_column($column)` - You can add columns by using `add\_column($column\_name, $content, $order) - You **can** use the Blade Template Engine in your `$content` values. - You may pass a function as the $content to the `add_column` or `edit_column` calls. The function receives a single parameter: the query row/model record. (see Example 2) - The column identifiers are set by the returned array. - That means, for `posts.id` the relevant identifier is `id`, and for `owner.name as ownername` it is `ownername` - You can set the "index" column () using `set_index_column($name)` - You can add class (DT\_RowClass) to each row using `set_row_class($content)` function. - You can add jquery's data (DT\_RowData) to each row using `set_row_data($name,$content)` function. - You can add customized search filters for each column to override the default search functionality - You can call `make(true)` to return an array of objects instead of an array of arrays. (see Example 4) ### Examples [](#examples) **Example 1: Simple use** ``` $posts = Post::select(array('posts.id','posts.name','posts.created_at','posts.status')); return Datatables::of($posts)->make(); ``` **Example 2: Adding and editing columns** ``` $place = Place::left_join('owner','places.author_id','=','owner.id') ->select(array('places.id','places.name','places.created_at','owner.name as ownername','places.status')); return Datatables::of($place) ->add_column('operations', 'edit delete ') ->edit_column('status', '{{ $status ? 'Active' : 'Passive' }}') ->edit_column('ownername', function($row) { return "The author of this post is {$row->ownername}"; }) ->remove_column('id') ->make(); ``` **Notice:** If you use double quotes while assigning the $content in an `add_column` or `edit_column` call, you should escape variables with a backslash (\\) to prevent an error. For example: ``` edit_column('id', "{{ \$id }}") . ``` **Example 3: Using filter\_column** ``` $clients = Client::select(array( 'Client.id', DB::raw('CONCAT(Client.firstname," ",Client.lastname) as ClientName'), 'Client.email', 'Client.code', 'Client.updated_at', 'Client.isActive', 'Language.name as LanguageName', )) ->leftJoin('Language', 'Client.Language_id', '=', 'Language.id') ->where('isDeleted', '!=', '1'); return Datatables::of($clients) ->filter_column('id', 'where', 'Client.id', '=', '$1') ->filter_column('code', 'where', 'Client.code', '=', DB::raw('UPPER($1)')) ->filter_column('LanguageName', 'whereIn', 'Language.name', function($value) { return explode(',',$value); }) ->filter_column('updated_at', 'whereBetween', 'Client.updated_at', function($value) { return explode(',',$value); }, 'and') ->edit_column('isActive', '@if($isActive) Active @else Inactive @endif') ->make(); ``` **Notes on filter\_column:** Usage: `filter_column ( $column_name, $method, $param_1, $param_2, ..., $param_n )` - `$column_name` - the column name that search filter is be applied to - `$method` - can be any of QueryBuilder methods (where, whereIn, whereBetween, having etc.). - Note: For global search these methods are automaticaly converted to their "or" equivalents (if applicable, if not applicable, the column is not searched). - If you do not want some column to be searchable in global search, set the last parameter to "and" (see line 17 in example above). Doing this, the filter cannot be switched into its "or" equivalent and therefore will not be searched in global search . - `$param_1 ... $param_n` - these are parameters that will be passed to the selected where function (`$method`). Possible types: - `string` - `DB::raw()` - The DB::raw() can output literaly everything into the query. For example, subqueries or branching if you need some really sophisticated wheres. - `function` - or any other callable - `array` of any of the above - The search value is passed to the query by the string `$1` placed anywhere in parameters. If a callable (function) is used the searched value is passed to callable as first parameter the first parameter (again see line 17). - The callable must return a value that will be passed to the QueryBuilder's function. **Example 4: Returning an array of objects** ``` $posts = Post::select(array('posts.id','posts.name','posts.created_at','posts.status')); return Datatables::of($posts)->make(true); ``` This returns a JSON array with data like below: ``` data: { { id: 12, name: 'Dummy Post', created_at: '1974-06-20 13:09:51' status: true } { id: 15, name: 'Test post please ignore', created_at: '1974-06-20 13:15:51', status: true } } ``` **Example 5: DT\_RowID, DT\_RowClass and DT\_RowData** ``` $todo = ToDoList::select(array('todo.id','todo.name','todo.created_at','todo.status')); return Datatables::of($todo) ->set_index_column('id') ->set_row_class('@if($status=="done") success @endif') ->set_row_data('created_at','{{$created_at}}') ->make(); ``` **Example 6: Advanced usage of dataFullSupport** To better utilize dataTables mData (1.9), now columns.data (1.10) feature you may enable dataFullSupport by either setting it to true in the config file, or passing true to the second initialization argument `Datatables::of($query, true)` Creating a table with a searchable and sortable joined table: ``` //html //script.js $("#users-list").dataTable({ "processing": true, "serverSide": true, "ajax": "/api/user/datatables", "order": [[1,'desc']], "columnDefs": [ { //this prevents errors if the data is null "targets": "_all", "defaultContent": "" } ], "columns": [ //title will auto-generate th columns { "data" : "id", "title" : "Id", "orderable": true, "searchable": false }, { "data" : "profile.last_name","title" : "Name", "orderable": true, "searchable": true }, { "data" : "username", "title" : "Username", "orderable": true, "searchable": true }, { "data" : "email", "title" : "Email", "orderable": true, "searchable": true }, { "data" : "created_date", "title" : "Created", "orderable": true, "searchable": true }, ] }); ``` ``` $users = Models\User::select()->ModelJoin('profile'); return $dataTables = Datatables::of($users) ->filter_column('profile.last_name','where',\DB::raw('CONCAT(profile.last_name,\' \',profile.first_name)'),'LIKE','$1') ->filter_column('created_at','where','users.created_at','LIKE','$1') //for the blade template only the array data results is provided, it is `extracted` into the template ->edit_column('profile.last_name', '{{ $profile["first_name"]." ".$profile["last_name"] }}') ->edit_column('created_at', function($result_obj) { //in a callback, the Eloquent object is returned so carbon may be used return $result_obj->created_at->format('d/m/Y - h:ia'); }) ->add_column('manage', 'Edit', 3) ->remove_column('profile.photo_id') ->set_index_column('row-{{ $id }}') ->make(); ``` ``` //helper scope method in base Model class public function scopeModelJoin($query, $relation_name, $operator = '=', $type = 'left', $where = false) { $relation = $this->$relation_name(); $table = $relation->getRelated()->getTable(); $one = $relation->getQualifiedParentKeyName(); $two = $relation->getForeignKey(); if (empty($query->columns)) { $query->select($this->getTable().".*"); } //$join_alias = $table; $prefix = $query->getQuery()->getGrammar()->getTablePrefix(); $join_alias = $relation_name; foreach (\Schema::getColumnListing($table) as $related_column) { $query->addSelect(\DB::raw("`$prefix$join_alias`.`$related_column` AS `$join_alias.$related_column`")); } $two = str_replace($table . ".", $join_alias . ".", $two); return $query->join("$table AS $prefix$relation_name", $one, $operator, $two, $type, $where); //->with($relation_name); } ``` **Notes on columns.data:** - When using the columns.data option the order the data is returned in doesn't matter. - You may return extra rows that you use in some tables, and ones you don't without needing to worry about ignoring them. - When the data is returned within enbeded arrays, datatables lets you access it using dot notation. This allows the columns.data element to address items in your table. The values of the data items are expected to match the columns (or aliases) of the table. For example, if you sort by "profile.last\_name" it will use that to sort by the last\_name column in the "profiles" table, so make sure that table is joined so the reference exists. - If you don't do a direct join you can't sort or search those columns so make sure to set those options to false in the columns array - If you eager load the data via Eloquent, you will still get those items back and they may be edit via edit\_column just the same without needing to alias the names. **License:** Licensed under the MIT License ### Health Score 46 — FairBetter than 93% of packages Maintenance17 Infrequent updates — may be unmaintained Popularity56 Moderate usage in the ecosystem Community37 Small or concentrated contributor base Maturity65 Established project with proven stability Bus Factor3 3 contributors hold 50%+ of commits How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~49 days Total 12 Last Release 4113d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/c051715d4855bb822e424c43e178349bcc018693a9c025da4042e1c37bed1758?d=identicon)[bgultekin](/maintainers/bgultekin) --- Top Contributors [![MarkVaughn](https://avatars.githubusercontent.com/u/39970?v=4)](https://github.com/MarkVaughn "MarkVaughn (33 commits)")[![tortuetorche](https://avatars.githubusercontent.com/u/5038872?v=4)](https://github.com/tortuetorche "tortuetorche (11 commits)")[![yajra](https://avatars.githubusercontent.com/u/2687997?v=4)](https://github.com/yajra "yajra (6 commits)")[![ceesco53](https://avatars.githubusercontent.com/u/2687998?v=4)](https://github.com/ceesco53 "ceesco53 (5 commits)")[![prateem](https://avatars.githubusercontent.com/u/5553562?v=4)](https://github.com/prateem "prateem (3 commits)")[![phazei](https://avatars.githubusercontent.com/u/431395?v=4)](https://github.com/phazei "phazei (3 commits)")[![Jacq](https://avatars.githubusercontent.com/u/494120?v=4)](https://github.com/Jacq "Jacq (2 commits)")[![antonioribeiro](https://avatars.githubusercontent.com/u/3182864?v=4)](https://github.com/antonioribeiro "antonioribeiro (2 commits)")[![JoshKoberstein](https://avatars.githubusercontent.com/u/1995321?v=4)](https://github.com/JoshKoberstein "JoshKoberstein (2 commits)")[![langabi](https://avatars.githubusercontent.com/u/790661?v=4)](https://github.com/langabi "langabi (2 commits)")[![nightowl77](https://avatars.githubusercontent.com/u/414532?v=4)](https://github.com/nightowl77 "nightowl77 (2 commits)")[![apizzini](https://avatars.githubusercontent.com/u/5413702?v=4)](https://github.com/apizzini "apizzini (2 commits)")[![ChrisReid](https://avatars.githubusercontent.com/u/2385373?v=4)](https://github.com/ChrisReid "ChrisReid (2 commits)")[![anhskohbo](https://avatars.githubusercontent.com/u/1529454?v=4)](https://github.com/anhskohbo "anhskohbo (2 commits)")[![maddhatter](https://avatars.githubusercontent.com/u/4449339?v=4)](https://github.com/maddhatter "maddhatter (1 commits)")[![BasMulders](https://avatars.githubusercontent.com/u/179246666?v=4)](https://github.com/BasMulders "BasMulders (1 commits)")[![ethaizone](https://avatars.githubusercontent.com/u/1168777?v=4)](https://github.com/ethaizone "ethaizone (1 commits)")[![FrankPeters](https://avatars.githubusercontent.com/u/3206714?v=4)](https://github.com/FrankPeters "FrankPeters (1 commits)")[![ionutlepi](https://avatars.githubusercontent.com/u/15997961?v=4)](https://github.com/ionutlepi "ionutlepi (1 commits)")[![alessandropietrobelli](https://avatars.githubusercontent.com/u/2904793?v=4)](https://github.com/alessandropietrobelli "alessandropietrobelli (1 commits)") --- Tags laraveldatatablesdatatablelaravel4datatables jquery plugin ### Code Quality TestsPHPUnit ### Embed Badge ![Health badge](/badges/bllim-datatables/health.svg) ``` [![Health](https://phpackages.com/badges/bllim-datatables/health.svg)](https://phpackages.com/packages/bllim-datatables) ``` ### Alternatives [yajra/laravel-datatables-oracle jQuery DataTables API for Laravel 4.9k33.8M339](/packages/yajra-laravel-datatables-oracle)[barryvdh/laravel-ide-helper Laravel IDE Helper, generates correct PHPDocs for all Facade classes, to improve auto-completion. 14.9k123.0M687](/packages/barryvdh-laravel-ide-helper)[psalm/plugin-laravel Psalm plugin for Laravel 3274.9M308](/packages/psalm-plugin-laravel)[pragmarx/datatables Server-side handler of DataTables Jquery Plugin for Laravel 4 16307.7k14](/packages/pragmarx-datatables)[flarum/core Delightfully simple forum software. 211.3M1.9k](/packages/flarum-core)[tehwave/laravel-achievements Simple, elegant Achievements the Laravel way 7012.8k](/packages/tehwave-laravel-achievements) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)