UniqueCodes::eventFromUniqueCode PHP Method

eventFromUniqueCode() public method

public eventFromUniqueCode ( $code ) : CActiveRecord
$code
return CActiveRecord
    public function eventFromUniqueCode($code)
    {
        $eventId = $this->dbConnection->createCommand()->select('event.id')->from('unique_codes')->join('unique_codes_mapping', 'unique_codes.id = unique_codes_mapping.unique_code_id')->join('event', 'unique_codes_mapping.event_id = event.id')->where('unique_codes.code = ? ', array($code))->queryRow();
        return Event::model()->findByPk($eventId['id']);
    }