ReportController::appendInjectionValues PHP Méthode

    protected function appendInjectionValues(&$record, $patient_id, $left_treatment_id = null, $right_treatment_id = null)
    {
        $last_columns = array('last_injection_site', 'last_injection_date', 'last_injection_number');
        if (@$_GET['last_injection']) {
            foreach (array('left', 'right') as $side) {
                #initialise columns
                foreach ($last_columns as $col) {
                    $record[$side . '_' . $col] = 'N/A';
                }
                if ($treatment_id = ${$side . '_treatment_id'}) {
                    $treatment = $this->getTreatment($treatment_id);
                    if (!$treatment || !$treatment->drug_id) {
                        continue;
                    }
                    $command = Yii::app()->db->createCommand()->select('treat.' . $side . '_number as last_injection_number, treat.created_date as last_injection_date, site.name as last_injection_site')->from('et_ophtrintravitinjection_treatment treat')->join('et_ophtrintravitinjection_site insite', 'insite.event_id = treat.event_id')->join('site', 'insite.site_id = site.id')->join('event e', 'e.id = treat.event_id')->join('episode ep', 'e.episode_id = ep.id')->where('e.deleted = 0 and ep.deleted = 0 and ep.patient_id = :patient_id and treat.' . $side . '_drug_id = :drug_id', array(':patient_id' => $patient_id, ':drug_id' => $treatment->drug_id))->order('treat.created_date desc')->limit(1);
                    $res = $command->queryRow();
                    if ($res) {
                        foreach ($last_columns as $col) {
                            $record[$side . '_' . $col] = Helper::convertMySQL2NHS($res[$col], $res[$col]);
                        }
                    }
                }
            }
        }
        if (@$_GET['last_injection']) {
            foreach (array('left', 'right') as $side) {
                $record[$side . '_first_injection_date'] = 'N/A';
                if ($treatment_id = ${$side . '_treatment_id'}) {
                    $treatment = $this->getTreatment($treatment_id);
                    if (!$treatment || !$treatment->drug_id) {
                        continue;
                    }
                    $command = Yii::app()->db->createCommand()->select('treat.created_date as first_injection_date')->from('et_ophtrintravitinjection_treatment treat')->join('event e', 'e.id = treat.event_id')->join('episode ep', 'e.episode_id = ep.id')->where('e.deleted = 0 and ep.deleted = 0 and ep.patient_id = :patient_id and treat.' . $side . '_drug_id = :drug_id', array(':patient_id' => $patient_id, ':drug_id' => $treatment->drug_id))->order('treat.created_date asc')->limit(1);
                    $res = $command->queryRow();
                    if ($res) {
                        $record[$side . '_first_injection_date'] = Helper::convertMySQL2NHS($res['first_injection_date']);
                    }
                }
            }
        }
    }