Firm::getList PHP Метод

    public function getList($subspecialty_id = null, $include_id = null)
    {
        $cmd = Yii::app()->db->createCommand()->select('f.id, f.name')->from('firm f')->where('f.active = 1' . ($include_id ? ' or f.id = :include_id' : ''));
        if ($subspecialty_id) {
            $cmd->join('service_subspecialty_assignment ssa', 'f.service_subspecialty_assignment_id = ssa.id')->andWhere('ssa.subspecialty_id = :subspecialty_id')->bindValue(':subspecialty_id', $subspecialty_id);
        }
        if ($include_id) {
            $cmd->bindValue(':include_id', $include_id);
        }
        $result = array();
        foreach ($cmd->queryAll() as $firm) {
            $result[$firm['id']] = $firm['name'];
        }
        natcasesort($result);
        return $result;
    }