OEModule\OphCiExamination\models\Element_OphCiExamination_PostOpComplications::getFullComplicationList PHP Method

    public function getFullComplicationList($eye_id)
    {
        /*$criteria = new \CDbCriteria;
          $criteria->select = "DISTINCT ophciexamination_postop_et_complications.complication_id";
          $criteria->join = "JOIN ophciexamination_postop_et_complications ON t.id = ophciexamination_postop_et_complications.complication_id";
          $criteria->addCondition("eye_id = :eye_id");
          $criteria->params['eye_id'] = $eye_id;*/
        $list = \Yii::app()->db->createCommand()->selectDistinct('c.name')->from('et_ophciexamination_postop_complications t')->join('ophciexamination_postop_et_complications etc', 't.id = etc.element_id')->join('ophciexamination_postop_complications c', 'etc.complication_id = c.id')->where('(etc.eye_id=:eye_id) AND t.event_id = :event_id', array(':eye_id' => $eye_id, ':event_id' => $this->event->id))->order('etc.created_date DESC')->queryAll();
        return $list;
    }