import { db } from "@/lib/db";
import { posts, users } from "@/lib/db/schema";
import { desc, eq } from "drizzle-orm";
import DeleteButton from "@/components/admin/DeleteButton";

export const dynamic = "force-dynamic";

export default async function AdminPostsPage() {
  const rows = await db
    .select({ post: posts, user: users })
    .from(posts)
    .leftJoin(users, eq(posts.userId, users.id))
    .orderBy(desc(posts.createdAt));

  return (
    <div>
      <h2 className="text-lg font-semibold mb-4">Community Posts ({rows.length})</h2>
      <div className="space-y-3">
        {rows.map((r) => (
          <div key={r.post.id} className="card p-4 flex justify-between gap-4">
            <div>
              <p className="text-sm font-semibold">{r.user?.name || "Unknown"}</p>
              <p className="text-sm text-neutral-400 mt-1 line-clamp-2">{r.post.content}</p>
              <p className="text-xs text-neutral-600 mt-1">
                {r.post.prayedCount} prayed · {r.post.heartCount + r.post.sparkleCount + r.post.likeCount} reactions
              </p>
            </div>
            <DeleteButton url={`/api/admin/posts/${r.post.id}`} />
          </div>
        ))}
        {rows.length === 0 && <p className="text-neutral-500">No posts yet.</p>}
      </div>
    </div>
  );
}
