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

    public function actionLoadAllImages($id, $eventType, $mediaType)
    {
        $command = Yii::app()->db->createCommand()->select('md.id as fileid, eye_id, event_date, plot_values')->from('media_data md')->where('patient_id = :patient', array('patient' => $id))->andWhere('event_type_id = (SELECT id FROM event_type WHERE class_name= :eventType)', array('eventType' => $eventType))->andWhere('media_type_id = (SELECT id FROM media_type WHERE type_name =:mediaType)', array('mediaType' => $mediaType))->order('event_date');
        $allData = $command->queryAll();
        foreach ($allData as $row) {
            $output[strtotime($row['event_date'])][$row['eye_id']] = array($row['fileid'], $row['plot_values']);
        }
        echo json_encode($output);
    }