Method ListProjectsByGroup

app/controlplane/pkg/data/group.go:690–793

ListProjectsByGroup retrieves a list of projects that a group is a member of with pagination.

(ctx context.Context, orgID uuid.UUID, groupID uuid.UUID, visibleProjectIDs []uuid.UUID, paginationOpts *pagination.OffsetPaginationOpts)

// ListProjectsByGroup retrieves a list of projects that a group is a member of with pagination.
func (g GroupRepo) ListProjectsByGroup(ctx context.Context, orgID uuid.UUID, groupID uuid.UUID, visibleProjectIDs []uuid.UUID, paginationOpts *pagination.OffsetPaginationOpts) ([]*biz.GroupProjectInfo, int, error) {
	ctx, span := otelx.Start(ctx, groupRepoTracer, "GroupRepo.ListProjectsByGroup")
	defer span.End()

	if paginationOpts == nil {
		paginationOpts = pagination.NewDefaultOffsetPaginationOpts()
	}

	// Get all memberships where this group is a member and the resource type is a project
	membershipQuery := g.data.DB.Membership.Query().
		Where(
			membership.MemberIDEQ(groupID),
			membership.MembershipTypeEQ(authz.MembershipTypeGroup),
			membership.ResourceTypeEQ(authz.ResourceTypeProject),
			membership.HasOrganizationWith(organization.IDEQ(orgID)),
		)

	// If visibleProjectIDs is provided, filter memberships to include only those projects
	if visibleProjectIDs != nil {
		membershipQuery = membershipQuery.Where(membership.ResourceIDIn(visibleProjectIDs...))
	}

	// Get total count first (after applying visibility filters)
	count, err := membershipQuery.Count(ctx)
	if err != nil {
		return nil, 0, fmt.Errorf("failed to count project memberships: %w", err)
	}

	// Apply pagination to the memberships query
	memberships, err := membershipQuery.
		Order(ent.Desc(membership.FieldCreatedAt)).
		Offset(paginationOpts.Offset()).
		Limit(paginationOpts.Limit()).
		All(ctx)
	if err != nil {
		return nil, 0, fmt.Errorf("failed to query memberships: %w", err)
	}

	// If no memberships found, return empty result
	if len(memberships) == 0 {
		return []*biz.GroupProjectInfo{}, count, nil
	}

	// Extract project IDs from memberships
	projectIDs := make([]uuid.UUID, 0, len(memberships))
	for _, m := range memberships {
		projectIDs = append(projectIDs, m.ResourceID)
	}

	// Query the projects
	entProjects, err := g.data.DB.Project.Query().
		Where(
			project.IDIn(projectIDs...),
			project.OrganizationID(orgID),
			project.DeletedAtIsNil(),
		).
		WithVersions(func(query *ent.ProjectVersionQuery) {
			query.Where(projectversion.Latest(true), projectversion.DeletedAtIsNil()).Select(projectversion.FieldID)