public function search()
{
$criteria = new CDbCriteria();
$criteria->compare('occupation_id', $this->occupation_id);
$criteria->compare('driving_status_id', $this->driving_status_id);
$criteria->compare('smoking_status_id', $this->smoking_status_id);
$criteria->compare('accommodation_id', $this->accommodation_id);
$criteria->compare('comments', $this->comments);
$criteria->compare('type_of_job', $this->type_of_job);
$criteria->compare('carer_id', $this->carer_id);
$criteria->compare('alcohol_intake', $this->alcohol_intake);
$criteria->compare('substance_misuse_id', $this->substance_misuse_id);
return new CActiveDataProvider(get_class($this), array('criteria' => $criteria));
}