public static function query_one_object($sql, $args = NULL)
{
$sth = Dal::query($sql, $args);
$ret = Dal::row_object($sth);
return $ret;
}
/**
* Purpose: this function gets user role based on user id
* user id should be set
* @return array of the role 1 record
*/
public static function get_user_role($user_id)
{
Logger::log("Enter: function Roles::get_user_role");
if (empty($user_id)) {
throw new PAException(REQUIRED_PARAMETERS_MISSING, "User id is not set.");
}
$res = Dal::query(' SELECT role_id FROM {users_adminroles} WHERE user_id = ?', array($user_id));
$r = Dal::row_object($res);
Logger::log("Exit: function Roles:get_user_role");
return $r;
}
/**
* Purpose: this function returns role name based on $role_id argument
* @return string role name
*/
public static function get_role_name($role_id)
{
Logger::log("Enter: function Roles::get_role_name");
if (empty($role_id)) {
throw new CNException(REQUIRED_PARAMETERS_MISSING, "Role id is not set.");
}
$res = Dal::query(' SELECT name FROM {roles} WHERE id = ?', array($role_id));
$r = Dal::row_object($res);
$name = $r ? $r->name : null;
Logger::log("Exit: function Roles:get_role_name");
return $name;
}
