Procedure::getProceduresByOpNote PHP Méthode

    public function getProceduresByOpNote($opNoteElementId)
    {
        $data = array();
        if (isset($this->operationNotes)) {
            $procedures = Yii::app()->db->createCommand()->select('proc.id, proc.term')->from('proc')->join('ophtroperationnote_procedure_element opnote', 'opnote.procedure_id = proc.id')->where('opnote.element_type_id = :id and proc.active = 1', array(':id' => $opNoteElementId))->order('display_order, proc.term ASC')->queryAll();
            foreach ($procedures as $procedure) {
                $data[$procedure['id']] = $procedure['term'];
            }
        }
        return $data;
    }

 /**
  * @return array
  */
 protected function cataractProcedures()
 {
     $cataractProcedures = array();
     $cataractElement = \ElementType::model()->findByAttributes(array('name' => 'Cataract'));
     if ($cataractElement) {
         $procedure = new \Procedure();
         $cataractProcedures = $procedure->getProceduresByOpNote($cataractElement['id']);
     }
     return $cataractProcedures;
 }