ReportController::reportOperations PHP Method

    public function reportOperations($params = array())
    {
        $where = '';
        if (strtotime($params['date_from'])) {
            $where .= " and e.created_date >= '" . date('Y-m-d', strtotime($params['date_from'])) . " 00:00:00'";
        }
        if (strtotime($params['date_to'])) {
            $where .= " and e.created_date <= '" . date('Y-m-d', strtotime($params['date_to'])) . " 23:59:59'";
        }
        if ($user = User::model()->findByPk($params['surgeon_id'])) {
            $clause = '';
            if (@$params['match_surgeon']) {
                $clause .= "s.surgeon_id = {$user->id}";
            }
            if (@$params['match_assistant_surgeon']) {
                if ($clause) {
                    $clause .= ' or ';
                }
                $clause .= "s.assistant_id = {$user->id}";
            }
            if (@$params['match_supervising_surgeon']) {
                if ($clause) {
                    $clause .= ' or ';
                }
                $clause .= "s.supervising_surgeon_id = {$user->id}";
            }
            $where .= " and ({$clause})";
        }
        if (!($db = Yii::app()->params['report_db'])) {
            $db = 'db';
        }
        foreach (Yii::app()->{$db}->createCommand()->select('p.hos_num, c.first_name, c.last_name, e.created_date, s.surgeon_id, s.assistant_id, s.supervising_surgeon_id, pl.id as pl_id, e.id as event_id, cat.id as cat_id, eye.name as eye')->from('patient p')->join('contact c', "c.parent_class = 'Patient' and c.parent_id = p.id")->join('episode ep', 'ep.patient_id = p.id')->join('event e', 'e.episode_id = ep.id')->join('et_ophtroperationnote_procedurelist pl', 'pl.event_id = e.id')->join('eye', 'pl.eye_id = eye.id')->join('et_ophtroperationnote_surgeon s', 's.event_id = e.id')->leftJoin('et_ophtroperationnote_cataract cat', 'cat.event_id = e.id')->where("p.deleted = 0 and c.deleted = 0 and ep.deleted = 0 and e.deleted = 0 and pl.deleted = 0 and s.deleted = 0 and (cat.id is null or cat.deleted = 0) {$where}")->order('e.created_date asc')->queryAll() as $row) {
            $operations[] = array('date' => date('j M Y', strtotime($row['created_date'])), 'hos_num' => $row['hos_num'], 'first_name' => $row['first_name'], 'last_name' => $row['last_name'], 'procedures' => array(), 'complications' => array(), 'role' => $row['surgeon_id'] == $user->id ? 'Surgeon' : ($row['assistant_id'] == $user->id ? 'Assistant surgeon' : 'Supervising surgeon'));
            foreach (OphTrOperationnote_ProcedureListProcedureAssignment::model()->findAll('procedurelist_id=?', array($row['pl_id'])) as $i => $pa) {
                $operations[count($operations) - 1]['procedures'][] = array('eye' => $row['eye'], 'procedure' => $pa->procedure->term);
            }
            if ($row['cat_id']) {
                foreach (OphTrOperationnote_CataractComplication::model()->findAll('cataract_id=?', array($row['cat_id'])) as $complication) {
                    $operations[count($operations) - 1]['complications'][] = array('complication' => $complication->complication->name);
                }
            }
        }
        return array('operations' => $operations);
    }