/** * Process datatables ajax request. * * @return \Illuminate\Http\JsonResponse */ public function search() { $users = User::select('users.*', 'accounts.name as account_name')->leftJoin('accounts', 'accounts.id', '=', 'users.account_id'); return Datatables::of($users)->addColumn('actions', function ($user) { $actions = Form::open(['route' => ['admin.users.destroy', $user->id], 'method' => 'DELETE', 'class' => 'form-inline']); $actions .= ' <a href="users/' . $user->id . '" class="btn btn-xs btn-primary"><i class="glyphicon glyphicon-eye-open"></i> ' . trans('misc.button.show') . '</a> '; $actions .= ' <a href="users/' . $user->id . '/edit" class="btn btn-xs btn-primary"><i class="glyphicon glyphicon-edit"></i> ' . trans('misc.button.edit') . '</a> '; if ($user->disabled) { $actions .= ' <a href="users/' . $user->id . '/enable" class="btn btn-xs btn-success"><i class="glyphicon glyphicon-ok-circle"></i> ' . trans('misc.button.enable') . '</a> '; } else { $actions .= ' <a href="users/' . $user->id . '/disable" class="btn btn-xs btn-warning"><i class="glyphicon glyphicon-ban-circle"></i> ' . trans('misc.button.disable') . '</a> '; } $actions .= Form::button('<i class="glyphicon glyphicon-remove"></i> ' . trans('misc.button.delete'), ['type' => 'submit', 'class' => 'btn btn-danger btn-xs']); $actions .= Form::close(); return $actions; })->make(true); }