OEModule\OphCiExamination\controllers\OEScapeDataController::queryDataVA PHP Method

    protected function queryDataVA($patient, $side)
    {
        $command = Yii::app()->db->createCommand()->select('event_date, ovauv.value as value')->from('ophciexamination_visualacuity_reading ovr')->join('et_ophciexamination_visualacuity eov', 'eov.id=ovr.element_id')->join('event ev', 'ev.id=eov.event_id')->join('episode ep', 'ev.episode_id=ep.id')->join('ophciexamination_visual_acuity_unit_value ovauv', 'ovauv.unit_id=10 and ovr.value=ovauv.base_value')->where('patient_id = :patient', array('patient' => $patient))->andWhere('ovr.side = :side', array('side' => $side - 1))->andWhere('ev.deleted <> 1')->order('event_date');
        return $command->queryAll();
    }