public function adverts_ajax()
{
$adverts = Advertisement::select('a.id', 'a.title', 'c.uk_title', 'u.name', 'a.created_at')->from('advertisements as a')->leftJoin('categories as c', 'c.id', '=', 'a.category_id')->leftJoin('users as u', 'u.id', '=', 'a.user_id');
$action = '<a href="{{ URL::route( \'admin_adverts_update\', array("id"=>$id)) }}"><i class="fa fa-fw fa-edit"></i></a>
<a class="confirm-remove" href="{{ URL::route( \'admin_adverts_delete\', array("id"=>$id)) }}"><i class="fa fa-fw fa-remove"></i></a>
';
return Datatables::of($adverts)->addColumn('action', $action)->make();
}
