getManagedUsers method

Implementation

Future<List<OrgMemberModel>> getManagedUsers(String orgId) async {
  final maRows = await _client
      .from('manager_assignments')
      .select('managed_user_id')
      .eq('org_id', orgId)
      .eq('manager_user_id', _userId);
  final userIds = (maRows as List<dynamic>)
      .map(
        (row) => (row as Map<String, dynamic>)['managed_user_id'] as String,
      )
      .toList();
  if (userIds.isEmpty) return [];

  final response = await _client
      .from('org_members')
      .select('*, profiles(display_name, email, username)')
      .eq('org_id', orgId)
      .inFilter('user_id', userIds);
  return (response as List<dynamic>)
      .map((row) => OrgMemberModel.fromJson(row as Map<String, dynamic>))
      .toList();
}