Function getUserSeatType

server/src/db/organization-db.ts:492–505

(userId: string)

 *   - they are an active member of a working group
 */
export async function getUserSeatType(userId: string): Promise<SeatType | null> {
  const pool = getPool();
  const result = await pool.query<{ is_contributor: boolean }>(
    `SELECT (
       EXISTS (SELECT 1 FROM organization_memberships WHERE workos_user_id = $1 AND seat_type = 'contributor')
       OR EXISTS (SELECT 1 FROM slack_user_mappings WHERE workos_user_id = $1 AND mapping_status = 'mapped')
       OR EXISTS (SELECT 1 FROM working_group_memberships WHERE workos_user_id = $1 AND status = 'active')
     ) as is_contributor
     FROM organization_memberships WHERE workos_user_id = $1 LIMIT 1`,
    [userId]
  );
  if (result.rows.length === 0) return null;
  return result.rows[0]?.is_contributor ? 'contributor' : 'community_only';
}

// ==================== Seat Warning Threshold Management ====================