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(); }