import { db } from "@/lib/db";
import { blogPosts, categories, blogPostCategories } from "@/lib/db/schema";
import { eq, desc, and, inArray } from "drizzle-orm";
import Link from "next/link";
import type { Metadata } from "next";
import { getSetting } from "@/lib/settings";
import { cookies } from "next/headers";
import { getCategoriesForPosts } from "@/lib/blogCategories";
import BlogSearchBar from "@/components/BlogSearchBar";
import BlogSidebar from "@/components/BlogSidebar";
import BlogPostGrid from "@/components/BlogPostGrid";

export const dynamic = "force-dynamic";

const PAGE_SIZE = 10;

export async function generateMetadata(): Promise<Metadata> {
  const siteName = await getSetting("siteName", "GraceMembership");
  return {
    title: `Blog — ${siteName}`,
    description: `Stories, teaching, and updates from ${siteName}.`,
  };
}

export default async function BlogPage({
  searchParams,
}: {
  searchParams: Promise<{ category?: string }>;
}) {
  const { category } = await searchParams;
  const siteName = await getSetting("siteName", "GraceMembership");
  const blessQuote = await getSetting("blessQuote", "");

  // "Continue reading" banner — reads the cookie set by TrackLastRead on
  // the post page, then confirms the post still exists and is published
  // before showing it (handles deleted/unpublished posts gracefully).
  const cookieStore = await cookies();
  const lastSlug = cookieStore.get("last_blog_post")?.value;
  const lastPost = lastSlug
    ? (await db.select().from(blogPosts).where(eq(blogPosts.slug, lastSlug)))[0]
    : null;
  const showContinue = lastPost && lastPost.status === "published";

  let rows: (typeof blogPosts.$inferSelect)[];
  if (category) {
    // Filtered listing — get post IDs in the category first, then the posts themselves.
    const cat = (await db.select().from(categories).where(eq(categories.slug, category)))[0];
    if (cat) {
      const idRows = await db.select({ postId: blogPostCategories.postId }).from(blogPostCategories).where(eq(blogPostCategories.categoryId, cat.id));
      const ids = idRows.map((r) => r.postId);
      rows = ids.length
        ? await db.select().from(blogPosts).where(and(eq(blogPosts.status, "published"), inArray(blogPosts.id, ids))).orderBy(desc(blogPosts.publishedAt)).limit(PAGE_SIZE + 1)
        : [];
    } else {
      rows = [];
    }
  } else {
    rows = await db.select().from(blogPosts).where(eq(blogPosts.status, "published")).orderBy(desc(blogPosts.publishedAt)).limit(PAGE_SIZE + 1);
  }

  const hasMore = rows.length > PAGE_SIZE;
  const page = rows.slice(0, PAGE_SIZE);
  const categoriesByPost = await getCategoriesForPosts(page.map((p) => p.id));
  const posts = page.map((p) => ({
    slug: p.slug,
    title: p.title,
    excerpt: p.excerpt,
    featuredImageUrl: p.featuredImageUrl,
    viewCount: p.viewCount,
    publishedAt: p.publishedAt,
    categories: categoriesByPost[p.id] || [],
  }));

  return (
    <div className="max-w-6xl mx-auto">
      <div className="mb-5">
        <BlogSearchBar />
      </div>

      {blessQuote && (
        <div className="card p-4 mb-5 border-red-900/30 bg-gradient-to-r from-red-950/20 to-transparent">
          <p className="text-sm text-neutral-300 italic text-center leading-relaxed">✨ {blessQuote}</p>
        </div>
      )}

      {showContinue && lastPost && (
        <Link href={`/blog/${lastPost.slug}`} className="block card p-5 mb-6 hover:border-red-800/60 transition-colors group">
          <p className="text-xs text-neutral-500 uppercase tracking-wide font-medium mb-1">Continue to your last reading post</p>
          <h2 className="text-lg font-bold group-hover:text-red-400 transition-colors line-clamp-2">{lastPost.title}</h2>
          <p className="text-xs text-red-500 mt-1">Pick up where you left off →</p>
        </Link>
      )}

      {category && (
        <div className="flex items-center gap-2 mb-4">
          <span className="text-sm text-neutral-400">Filtered by category</span>
          <Link href="/blog" className="text-xs bg-neutral-800 hover:bg-neutral-700 px-2.5 py-1 rounded-full transition-colors">✕ Clear</Link>
        </div>
      )}

      <div className="grid md:grid-cols-[1fr_280px] gap-6 items-start">
        <BlogPostGrid initialPosts={posts} initialHasMore={hasMore} category={category} />
        <div className="md:sticky md:top-20">
          <BlogSidebar />
        </div>
      </div>
    </div>
  );
}
