This package is created to handle server-side works of DataTables jQuery Plugin via AJAX option by using Eloquent ORM / Query Builder.
This package only tested on Laravel 5.6, 5.7 & 5.8 so if you have any problem or any question you can call me or open new issues
composer require bitstudio-id/bitdatatable
<link rel="stylesheet" href="//cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.1.3/css/bootstrap.css"/>
<link rel="stylesheet" href="//cdn.datatables.net/1.10.19/css/dataTables.bootstrap4.min.css"/>
<script src="//cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="//cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
<script src="//cdn.datatables.net/1.10.19/js/dataTables.bootstrap4.min.js"></script><table id="table" class="table table-bordered table-striped">
<thead>
<tr>
<th>#ID</th>
<th>Name</th>
<th>Role</th>
<th>Email</th>
<th>...</th>
</tr>
</thead>
<tbody></tbody>
</table><script>
$(document).ready(function () {
//hide error/warning on datatable
$.fn.dataTable.ext.errMode = 'none';
var table = $('#table').DataTable({
//enable filter
bFilter: true,
processing: true,
serverSide: true,
ajax: {
url: "/dummy/dtb-v2/get",
type: 'get',
},
columns: [
{data: "id", name: "id", searchable: false, orderable: false},
{data: "employee.code"},
{data: "name", name: "user_name"},
{data: "employee.role.name"},
{data: "email"},
{data: "action", searchable: false, orderable: false}, // use searchable: false, orderable: false for custom column
],
});
});
</script>
use BITStudio\BITDataTable\BITDataTable;
...
...
public function dtbGetV2(Request $request)
{
$dtb = new BITDataTable();
// Set request
$dtb->setRequest($request);
$user = User::query()->with('employee', 'employee.role');
$dtb->from($user);
$state = "admin";
$dtb->addCol(function ($user){
$user->action = "<a target='_blank' href='//lorem.com/{$user->id}' class='btn btn-danger'>action-{$item->id}</a>";
return $user;
});
return $dtb->generate();
}$state = "admin";
$dtb->addCol(function ($user) use ($state){
//use logic on addCol
//set as empty default
$user->admin_col = "";
if($state == $user->role->name) {
$user->admin_col .= "admin-col";
}
return $user;
});
use BITStudio\BITDataTable\BITDataTable;
...
...
public function dtbGetV2(Request $request)
$dtb = new BITDataTable();
$dtb->setRequest($request);
$q = DB::table("orders as o");
$q->select("o.*", "o.no_cs as customer_number", "e.employee_name as emp_name");
$q->leftJoin("employee as e", "e.id", "=", "o.employee_id");
$dtb->from($q);
//add custom column
$dtb->addCol(function ($user){
$user->action = "<a target='_blank' href='//google.com/{$item->id}' class='btn btn-danger'>action-{$item->id}</a>";
return $user;
});
return $dtb->generate();
}$dtb->addClass("text-danger");
//create custom from collection property
$dtb->setRowId("id");
//create custom from addCol or setRowId for custom id attribute
$dtb->setRowId(function($item) {
$item->DT_RowId = "id-".$item->id;
return $item;
});
The MIT License (MIT). Please see License File for more information.
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent