/**
* function for send ajax request to view
*
* @return Response
*/
public function listingJson()
{
//$query = Building::all();
$query = Bank::select('id', 'name', 'address', 'changed_by', 'created_at')->with('User')->get();
return Datatable::collection($query)->addColumn('name', function ($model) {
return ucfirst($model->name);
})->addColumn('address', function ($model) {
return $model->address;
})->addColumn('created_at', function ($model) {
return $model->created_at->format('d-m-Y');
})->addColumn('created_by', function ($model) {
return $model->user->name;
})->addColumn('show', function ($model) {
return '<a href="' . action('BanksController@detail', $model->id) . '" class="btn btn-small btn-primary btn-constant"><i class="fa fa-eye fa-fw"></i></a>';
})->addColumn('edit', function ($model) {
return '<a href="' . action('BanksController@edit', $model->id) . '" class="btn btn-small btn-success btn-constant"><i class="fa fa-edit fa-fw"></i></a>';
})->addColumn('delete', function ($model) {
return '<form action="' . action('BanksController@delete', $model->id) . '" method="POST"><button type="submit" class="btn btn-small btn-danger btn-constant" onclick = "return confirm(\'Are you sure?\')"><i class="fa fa-times fa-fw"></i></button></form>';
})->searchColumns('name', 'address', 'created_by')->orderColumns('id', 'name', 'address', 'created_at')->make();
}
