getMemberRoleAssignments method

Implementation

Future<List<MemberRoleAssignmentModel>> getMemberRoleAssignments(
  String orgId,
) async {
  // Get members for this org, then their assignments
  final memberRows = await _client
      .from('org_members')
      .select('id')
      .eq('org_id', orgId);
  final memberIds = (memberRows as List<dynamic>)
      .map((r) => (r as Map<String, dynamic>)['id'] as String)
      .toList();
  if (memberIds.isEmpty) return [];

  final response = await _client
      .from('member_role_assignments')
      .select('*, role_profiles(name)')
      .inFilter('org_member_id', memberIds);
  return (response as List<dynamic>)
      .map(
        (r) => MemberRoleAssignmentModel.fromJson(r as Map<String, dynamic>),
      )
      .toList();
}