我使用了laravel 4.2 billam服务器端数据表,现在它可以工作了。但是我不能在这个数据表中添加编辑和删除按钮。
查看页面:
<script type="text/javascript">
var oTable;
$(document).ready(function() {
oTable = $('#tasks').dataTable( {
"sPaginationType": "bootstrap",
"bProcessing": true,
"bServerSide": true,
"sAjaxSource": "{{ URL::to('/task') }}"
});
});
路线:
Route::get('/task',function(){
$posts = Campaigns::select(array('title','created_at','status'));
return Datatables::of($posts)
->make();
});
现在我如何添加删除和编辑按钮?我从这里遵循那里的文件,不适用于我。
记录示例2:添加和编辑列
->add_column('operations', '<a href="{{ URL::route( ''admin.post'', array( ''edit'',$id )) }}">edit</a>
<a href="{{ URL::route( ''admin.post'', array( ''delete'',$id )) }}">delete</a>
')
->edit_column('status', '{{ $status ? 'Active' : 'Passive' }}')
->edit_column('ownername', function($row) {
return "The author of this post is {$row->ownername}";
})
但是,如何在路由或控制器中使用刀片结构代码?这没什么大不了的。。
要从控制器添加到数据表列的链接,可以执行以下操作:
->addColumn('actions', function ($data) {
return "<a class='btn btn-xs btn-success' href='/management/members/$data->id/view'>View</a>";
})
$data是datatables包装器之后的查询。因此,在控制器的方法中,这将类似于以下使用:
/**
* Members list data.
*
* @param Datatables $datatables
* @param MemberRepository $repository
*
* @return 'Illuminate'Http'JsonResponse
*/
public function getIndexData(Datatables $datatables, MemberRepository $repository)
{
$members = $repository->getMemberListForManagement();
return $datatables->usingQueryBuilder($members)
->editColumn('created_at', function ($data) {
return date('d F Y', strtotime($data->created_at));
})
->editColumn('is_banned',
'@if($is_banned)
Yes
@else
No
@endif')
->addColumn('actions', function ($data) {
return "<a class='btn btn-xs btn-success' href='/management/members/$data->id/view'>View</a>";
})
->removeColumn('id')
->make(true);
}