UniqueCodes::examinationEventCheckFromUniqueCode PHP Method

    public function examinationEventCheckFromUniqueCode($code)
    {
        return $this->dbConnection->createCommand()->select('count(*) as count, automatic_examination_event_log.*')->from('automatic_examination_event_log')->join('event', 'event.id = automatic_examination_event_log.event_id and event.deleted !=1')->join('import_status', 'import_status.id = automatic_examination_event_log.import_success')->where('unique_code = ? ', array($code))->andWhere('import_status.status_value <> "Import Failure"')->queryRow();
    }