import Navbar         from "@/components/Navbar";
import Footer         from "@/components/Footer";
import ProductsClient from "./ProductsClient";
import pool, { initDB } from "@/lib/db";
import type { Product } from "@/types/product";

export const dynamic = "force-dynamic";

export const metadata = {
  title: "Nos Produits",
  description:
    "Découvrez toute la gamme Asli Food : farines enrichies Njuumaan, farines fortifiées, pâtes Tiguigerté, biscuits Biscrotch, fruits séchés Tejmakhtt et paniers cadeaux — produits mauritaniens 100 % naturels.",
  openGraph: {
    title:       "Nos Produits — Asli Food",
    description: "Farines enrichies, pâtes, biscuits, fruits séchés — toute la gamme Asli Food.",
    url:         "https://asli-food.com/produits",
  },
};

async function getProducts(): Promise<Product[]> {
  await initDB();
  const { rows } = await pool.query(
    "SELECT * FROM products WHERE available = true ORDER BY sort_order ASC, created_at ASC"
  );
  return rows;
}

export default async function ProduitsPage() {
  const products = await getProducts();

  return (
    <>
      <Navbar />
      <ProductsClient products={products} />
      <Footer />
    </>
  );
}