Function createMyContentRouter

server/src/routes/content.ts:1382–1900

()

 * Returns a router to be mounted at /api/me/content
 */
export function createMyContentRouter(): Router {
  const router = Router();

  // GET /api/me/content - Get all content where user has a relationship
  router.get('/', requireAuth, async (req, res) => {
    try {
      const user = req.user!;
      const status = req.query.status as string | undefined;
      const collection = req.query.collection as string | undefined;
      const relationship = req.query.relationship as string | undefined;
      const limit = Math.min(parseInt(req.query.limit as string) || 50, 100);
      const pool = getPool();

      // Get committees user leads (for "owner" relationship)
      const leaderResult = await pool.query(
        `SELECT working_group_id FROM working_group_leaders WHERE user_id = $1`,
        [user.id]
      );
      const ledCommitteeIds = leaderResult.rows.map(r => r.working_group_id);

      // Admins can see every perspective here so they can edit anything
      // (including content that predates them, has no proposer, or belongs to a
      // committee they don't lead). Relationships are still computed so the UI
      // can still distinguish their own contributions.
      const userIsAdmin = await isWebUserAAOAdmin(user.id);

      // Build the query
      let query = `
        SELECT DISTINCT ON (p.id)
          p.id, p.slug, p.content_type, p.title, p.subtitle, p.category, p.excerpt,
          p.content, p.tags, p.featured_image_url,
          p.external_url, p.external_site_name, p.status, p.published_at,
          p.created_at, p.updated_at, p.working_group_id, p.proposer_user_id,
          wg.name as committee_name, wg.slug as committee_slug,
          -- Determine relationships
          CASE WHEN p.proposer_user_id = $1 THEN true ELSE false END as is_proposer,
          CASE WHEN EXISTS (SELECT 1 FROM content_authors ca WHERE ca.perspective_id = p.id AND ca.user_id = $1) THEN true ELSE false END as is_author,
          CASE WHEN p.working_group_id = ANY($2) THEN true ELSE false END as is_lead,
          -- Get authors
          (SELECT json_agg(json_build_object(
            'user_id', ca.user_id,
            'display_name', ca.display_name,
            'display_title', ca.display_title
          ) ORDER BY ca.display_order)
          FROM content_authors ca WHERE ca.perspective_id = p.id) as authors
        FROM perspectives p
        LEFT JOIN working_groups wg ON wg.id = p.working_group_id
        WHERE (
          $3::boolean = true
          OR p.proposer_user_id = $1
          OR EXISTS (SELECT 1 FROM content_authors ca WHERE ca.perspective_id = p.id AND ca.user_id = $1)
          OR p.working_group_id = ANY($2)
        )
      `;
      const params: (string | string[] | number | boolean)[] = [user.id, ledCommitteeIds, userIsAdmin];

      // Apply filters
      if (status && status !== 'all') {