public function getUnattachedForPatient(Patient $patient, $eye_id, Event $event = null)
{
$crit = array('join' => 'inner join patient_measurement pm on pm.id = t.patient_measurement_id ' . 'left join measurement_reference mr on mr.patient_measurement_id = pm.id', 'condition' => 'pm.patient_id = :patient_id and t.eye_id = :eye_id and ' . '(mr.id is null' . ($event ? ' or mr.event_id = :event_id' : '') . ')', 'params' => array(':patient_id' => $patient->id, ':eye_id' => $eye_id), 'order' => 't.study_datetime');
if ($event) {
$crit['params']['event_id'] = $event->id;
}
return $this->findAll($crit);
}