"use server";

import { supabaseServerClient } from "supabase/serverClient";
import { getPublicationURL } from "app/lish/createPub/getPublicationURL";
import type { Post } from "app/(home-pages)/reader/getReaderFeed";

export type Cursor = {
  indexed_at: string;
  uri: string;
};

export async function getProfilePosts(
  did: string,
  cursor?: Cursor | null,
): Promise<{ posts: Post[]; nextCursor: Cursor | null }> {
  const limit = 20;

  let query = supabaseServerClient
    .from("documents")
    .select(
      `*,
      comments_on_documents(count),
      document_mentions_in_bsky(count),
      documents_in_publications(publications(*))`,
    )
    .like("uri", `at://${did}/%`)
    .order("indexed_at", { ascending: false })
    .order("uri", { ascending: false })
    .limit(limit);

  if (cursor) {
    query = query.or(
      `indexed_at.lt.${cursor.indexed_at},and(indexed_at.eq.${cursor.indexed_at},uri.lt.${cursor.uri})`,
    );
  }

  let [{ data: docs }, { data: pubs }, { data: profile }] = await Promise.all([
    query,
    supabaseServerClient
      .from("publications")
      .select("*")
      .eq("identity_did", did),
    supabaseServerClient
      .from("bsky_profiles")
      .select("handle")
      .eq("did", did)
      .single(),
  ]);

  // Build a map of publications for quick lookup
  let pubMap = new Map<string, NonNullable<typeof pubs>[number]>();
  for (let pub of pubs || []) {
    pubMap.set(pub.uri, pub);
  }

  // Transform data to Post[] format
  let handle = profile?.handle ? `@${profile.handle}` : null;
  let posts: Post[] = [];

  for (let doc of docs || []) {
    let pubFromDoc = doc.documents_in_publications?.[0]?.publications;
    let pub = pubFromDoc ? pubMap.get(pubFromDoc.uri) || pubFromDoc : null;

    let post: Post = {
      author: handle,
      documents: {
        data: doc.data,
        uri: doc.uri,
        indexed_at: doc.indexed_at,
        comments_on_documents: doc.comments_on_documents,
        document_mentions_in_bsky: doc.document_mentions_in_bsky,
      },
    };

    if (pub) {
      post.publication = {
        href: getPublicationURL(pub),
        pubRecord: pub.record,
        uri: pub.uri,
      };
    }

    posts.push(post);
  }

  const nextCursor =
    posts.length === limit
      ? {
          indexed_at: posts[posts.length - 1].documents.indexed_at,
          uri: posts[posts.length - 1].documents.uri,
        }
      : null;

  return { posts, nextCursor };
}
