protected function queryOperationData($patient)
{
$command = Yii::app()->db->createCommand()->select('event_date, eye.name as eye, term, eopp.eye_id as eye_id')->from('ophtroperationnote_procedurelist_procedure_assignment oppa')->join('et_ophtroperationnote_procedurelist eopp', 'oppa.procedurelist_id = eopp.id')->join('event e', 'eopp.event_id = e.id')->join('episode ep', 'e.episode_id = ep.id')->join('proc p', 'oppa.proc_id=p.id')->join('eye', 'eopp.eye_id=eye.id')->where('patient_id = :patient', array('patient' => $patient))->andWhere('e.deleted <> 1')->order('event_date');
return $command->queryAll();
}