Function GET

web/src/app/api/admin/orgs/route.ts:14–126

(request: NextRequest)

export const dynamic = 'force-dynamic'

export async function GET(request: NextRequest): Promise<NextResponse> {
  try {
    // Check admin authentication
    const authResult = await checkAdminAuth()
    if (authResult instanceof NextResponse) {
      return authResult
    }

    // Get all organizations with their details
    const organizations = await db
      .select({
        id: schema.org.id,
        name: schema.org.name,
        slug: schema.org.slug,
        owner_id: schema.org.owner_id,
        created_at: schema.org.created_at,
        owner_name: schema.user.name,
      })
      .from(schema.org)
      .innerJoin(schema.user, eq(schema.org.owner_id, schema.user.id))
      .orderBy(desc(schema.org.created_at))

    // Get member counts for each organization
    const memberCounts = await db
      .select({
        org_id: schema.orgMember.org_id,
        count: sql<number>`COUNT(*)`,
      })
      .from(schema.orgMember)
      .groupBy(schema.orgMember.org_id)

    // Get repository counts for each organization
    const repoCounts = await db
      .select({
        org_id: schema.orgRepo.org_id,
        count: sql<number>`COUNT(*)`,
      })
      .from(schema.orgRepo)
      .where(eq(schema.orgRepo.is_active, true))
      .groupBy(schema.orgRepo.org_id)

    // Build the response with additional data
    const now = new Date()
    const currentMonthStart = new Date(now.getFullYear(), now.getMonth(), 1)

    const organizationSummaries = await Promise.all(
      organizations.map(async (org) => {
        const memberCount =
          memberCounts.find((m) => m.org_id === org.id)?.count || 0
        const repositoryCount =
          repoCounts.find((r) => r.org_id === org.id)?.count || 0

        // Get credit balance and usage
        let creditBalance = 0
        let usageThisCycle = 0
        let healthStatus: 'healthy' | 'warning' | 'critical' = 'healthy'

        try {