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; }