private $companyInstance = null;
// Constants for database tables
- const DB_TABLE_COMPANY_DATA = "company";
- const DB_TABLE_COMPANY_USER = "company_user";
+ const DB_TABLE_COMPANY_DATA = 'company';
+ const DB_TABLE_COMPANY_USER = 'company_user';
+
+ // Constants for database columns
+ const DB_COLUMN_PARTICIPANT_ID = 'participant_id';
/**
* Protected constructor
$participates = false;
// Get a search criteria class
- $criteriaInstance = ObjectFactory::createObjectByConfiguredName('search_criteria_class');
+ $searchInstance = ObjectFactory::createObjectByConfiguredName('search_criteria_class');
// Add the user primary key as a search criteria
- $criteriaInstance->addCriteria("participant_id", $userInstance->getPrimaryKey());
- $criteriaInstance->setLimit(1);
+ $searchInstance->addCriteria(self::DB_COLUMN_PARTICIPANT_ID, $userInstance->getPrimaryKey());
+ $searchInstance->setLimit(1);
// Set company->user table
$this->setTableName(self::DB_TABLE_COMPANY_USER);
// Get the result back
- $resultInstance = $this->doSelectByCriteria($criteriaInstance);
+ $resultInstance = $this->doSelectByCriteria($searchInstance);
// Is there a result?
if ($resultInstance->next()) {