class Apartment extends DataObject {
//db fields
static $db = array (
      'Type' => 'Text',
'Title' => 'Varchar(255)',
      'Price' => 'Text',
      'Rooms' => 'Text',
      'Bathrooms' => 'Text',
'Description' => 'Text',
      'URLSegment' => 'Varchar(255)',
      'OwnerName' => 'Varchar(255)',
      'isActive' => 'Boolean',
);

public function listAll ($filter = null){
   if(!isset($_REQUEST['start'])) $_REQUEST['start'] = 0;
      $filter = "isActive = '1'";
      if(!$filter){ return false; } else
      $limit = $_REQUEST['start'].",8";
      $sort = 'Created ASC';
   return DataObject::get('Apartment', $filter, $sort, null, $limit);
}

public function SearchForm() {
$context = singleton('Apartment')->getCustomSearchContext();      
$extraFields = $context->getSearchFields();
      $fields = new FieldSet(
                     
               new DropdownField(
                   'RoomsMin', 'Min Rooms', array( '' => 'Any', '1' => '1', '2' => '2', '3' => '3', '4' => '4', '5' => '5', '6' => '6', '7' => '7', '8' => '8', '9' => '9', '10' => '10')),
               new DropdownField(
                   'RoomsMax', 'Max Rooms', array( '' => 'Any', '1' => '1', '2' => '2', '3' => '3', '4' => '4', '5' => '5', '6' => '6', '7' => '7', '8' => '8', '9' => '9', '10' => '10')),
               new DropdownField(
                  'TownID',
                  'Choose a town',
                  Dataobject::get("Town")->toDropdownMap("ID", "Name", "Please Select")),
               new DropdownField(
                  'Amenity.ID',
                  'Choose amenities',
                  Dataobject::get("Amenity")->map("ID", "Name", "Please Select"))
         );
                     
$form = new Form($this, "SearchForm",

         $fields,
new FieldSet(
new FormAction('doSearch', 'Search')
)
);

return $form;
}
public function doSearch($data, $form) {
$context = singleton('Apartment')->getCustomSearchContext();
      //Add fields so that only published are shown.
      //$data['isActive'] = '1';
$results = $context->getResults($data);
return $this->customise(array(
'Results' => $results
))->renderWith(array('SearchPage_results', 'Page'));
}