public function getMostRecentVAElementForPatient(\Patient $patient)
{
$event_type = $this->getEventType();
$criteria = new \CDbCriteria();
$criteria->select = '*';
$criteria->join = 'join episode on t.episode_id = episode.id and patient_id = :patient_id and event_type_id = :event_type_id';
$criteria->order = 't.event_date desc';
$criteria->condition = 't.deleted != 1';
$criteria->params = array(':patient_id' => $patient->id, ':event_type_id' => $event_type->id);
foreach (\Event::model()->findAll($criteria) as $event) {
$result_element = models\Element_OphCiExamination_VisualAcuity::model()->with('event')->find('event_id=?', array($event->id));
if ($result_element !== null) {
return array('element' => $result_element, 'event_date' => date($event->created_date));
}
}
return false;
}