public function listAllClients()
{
$clients = Clients::select(array('clients.id', 'clients.firstname', 'clients.lastname', 'clients.surname', 'clients.identity', 'clients.address', 'clients.country', 'clients.city', 'clients.lastvisit', 'clients.created_by', 'clients.created_at'));
return Datatables::of($clients)->filter_column('id', 'where', 'clients.id', '=', '$1')->filter_column('name', 'whereIn', 'clients.firstname', function ($value) {
return explode(',', $value);
})->add_column('edit', '<a href="{{ URL::route(\'clients_edit\', array($id)) }}"><i class="icon-list-alt"></i>Edit</a>')->add_column('delete', '<a href="{{ URL::route(\'clients_delete\', array($id)) }}"><i class="icon-trash"></i>Delete</a>')->make();
}
