public function getUser($username)
{
$user = null;
if ($this->dbObj != null) {
$query = "SELECT * FROM users u LEFT JOIN roles r ON u.user_role = r.role_id WHERE user_name='{$username}'";
$results = $this->dbObj->ExecuteTableQuery($query);
if (!empty($results)) {
$user = $results[0];
}
} else {
if (isset($this->config['users'][$username])) {
$user = $this->config['users'][$username];
$user['user_name'] = $username;
}
}
return $user;
}
public function getUser($username)
{
$userData = null;
if ($this->dbObj == null) {
$users = $this->loadedConfig['users'];
if (isset($users[$username])) {
$userData = $users[$username];
$userData['user_name'] = $username;
}
} else {
$sql = "SELECT * FROM users WHERE user_name='{$username}'";
$results = $this->dbObj->ExecuteTableQuery($sql);
if (!empty($results)) {
$userData = $results[0];
}
}
return $userData;
}
/**
* Loads configuration from the DB.
*
* @param DB $dbObj Database connection object
* @return array Loaded configuration
*/
private function loadConfigurationFromDb($dbObj, $configPhpFileDir, $alreadyLoadedConfig, $configFileMapping)
{
$loadedConfig = $this->loadConfigurationFromPhpFile($configPhpFileDir, $alreadyLoadedConfig, $configFileMapping);
$getRolesQry = "SELECT * FROM roles";
$results = $dbObj->ExecuteTableQuery($getRolesQry);
foreach ($results as $row) {
$loadedConfig['roles'][] = $row['role_name'];
}
return $loadedConfig;
}
