Kimai_Database_Mysql::user_get_membership_role PHP Method

user_get_membership_role() public method

Returns the membership roleID the user has in the given group.
public user_get_membership_role ( integer $userID, integer $groupID ) : integer | boolean
$userID integer the ID of the user
$groupID integer the ID of the group
return integer | boolean membership roleID or false if user is not in the group
    public function user_get_membership_role($userID, $groupID)
    {
        $filter['userID'] = MySQL::SQLValue($userID, MySQL::SQLVALUE_NUMBER);
        $filter['groupID'] = MySQL::SQLValue($groupID, MySQL::SQLVALUE_NUMBER);
        $columns[] = "membershipRoleID";
        $table = $this->kga['server_prefix'] . "groups_users";
        $result = $this->conn->SelectRows($table, $filter, $columns);
        if ($result === false) {
            return false;
        }
        $row = $this->conn->RowArray(0, MYSQLI_ASSOC);
        return $row['membershipRoleID'];
    }
Kimai_Database_Mysql