Eloquent DataTable with Belongs To
Id |
Title |
Author |
Created At |
Updated At |
Action |
HTML
<table id="posts-table" class="table table-bordered">
<thead>
<tr>
<th>Id</th>
<th>Title</th>
<th>Author</th>
<th>Created At</th>
<th>Updated At</th>
<th>Action</th>
</tr>
</thead>
</table>
Routes
<?php
Route::get('eloquent/belongs-to', 'Eloquent\BelongsToController@index');
Route::get('eloquent/belongs-to-data', 'Eloquent\BelongsToController@data');
Controller
<?php
namespace App\Http\Controllers\Eloquent;
use App\Http\Controllers\Controller;
use App\Post;
use App\User;
use Yajra\Datatables\Datatables;
class BelongsToController extends Controller
{
/**
* Display index page.
*
* @return \BladeView|bool|\Illuminate\Contracts\View\Factory|\Illuminate\View\View
*/
public function index()
{
return view('eloquent.belongs-to');
}
/**
* Process dataTable ajax response.
*
* @param \Yajra\Datatables\Datatables $datatables
* @return \Illuminate\Http\JsonResponse
*/
public function data(Datatables $datatables)
{
return $datatables->eloquent(Post::with('user')->select('posts.*'))
->addColumn('action', 'eloquent.tables.posts-action')
->make(true);
}
}