feat(i18n): wire page translation editor and locale rendering

test(i18n): add translated page CRUD locale validation coverage
test(admin): cover pages and navigation form components
2026-02-12 20:57:42 +01:00 · 2026-02-12 20:53:06 +01:00 · 2026-02-12 20:48:51 +01:00
18 changed files with 673 additions and 195 deletions
--- a/TODO.md
+++ b/TODO.md
@@ -171,7 +171,7 @@ This file is the single source of truth for roadmap and delivery progress.
 - [ ] [P1] Media entity rendering with enrichment data
 - [ ] [P1] Portfolio views (gallery/album/category/tag) for artworks with filter and sort controls
 - [ ] [P1] Rendition-aware media delivery (thumbnail/card/full) per template slot
- [ ] [P1] Translation-ready content model for public entities (pages/news/navigation labels)
+- [~] [P1] Translation-ready content model for public entities (pages/news/navigation labels)
 - [ ] [P2] Artwork views and listing filters
 - [ ] [P1] Commission request submission flow
 - [x] [P1] Header banner render logic and fallbacks
@@ -187,10 +187,10 @@ This file is the single source of truth for roadmap and delivery progress.
 ### Testing

 - [x] [P1] Unit tests for content schemas and service logic
- [~] [P1] Component tests for admin forms (pages/media/navigation)
+- [x] [P1] Component tests for admin forms (pages/media/navigation)
 - [x] [P1] Integration tests for owner invariant and hidden support-user protection
 - [x] [P1] Integration tests for registration allow/deny behavior
- [ ] [P1] Integration tests for translated content CRUD and locale-specific validation
+- [x] [P1] Integration tests for translated content CRUD and locale-specific validation
 - [~] [P1] E2E happy paths: create page, publish, see on public app
 - [~] [P1] E2E happy paths: media upload + artwork refinement display
 - [~] [P1] E2E happy paths: commissions kanban transitions
@@ -320,6 +320,9 @@ This file is the single source of truth for roadmap and delivery progress.
 - [2026-02-12] Added owner/support invariant integration tests for auth guards (`apps/admin/src/lib/auth/server.test.ts`), covering protected-user deletion blocking and one-owner repair/promotion rules.
 - [2026-02-12] Started admin form component tests with media upload behavior coverage (`apps/admin/src/components/media/media-upload-form.test.tsx`).
 - [2026-02-12] Added code handover documentation baseline: architecture map, critical invariants, request lifecycles, and onboarding playbook under `docs/product-engineering/`.
+- [2026-02-12] Completed admin form component coverage for pages/navigation/media using isolated form components and tests.
+- [2026-02-12] Added page translation CRUD baseline (`PageTranslation`) with locale validation (`de/en/es/fr`) and integration coverage for localized read + fallback behavior.
+- [2026-02-12] Page editor now supports locale translations in `/pages/:id`; public page rendering uses locale-aware page lookup with base-content fallback.

 ## How We Use This File

--- a/apps/admin/src/app/navigation/page.tsx
+++ b/apps/admin/src/app/navigation/page.tsx
@@ -11,6 +11,8 @@ import { revalidatePath } from "next/cache"
 import { redirect } from "next/navigation"

 import { AdminShell } from "@/components/admin-shell"
+import { CreateMenuForm } from "@/components/navigation/create-menu-form"
+import { CreateNavigationItemForm } from "@/components/navigation/create-navigation-item-form"
 import { requirePermissionForRoute } from "@/lib/route-guards"

 export const dynamic = "force-dynamic"
@@ -206,123 +208,12 @@ export default async function NavigationManagementPage({
      <section className="grid gap-4 lg:grid-cols-2">
        <article className="rounded-xl border border-neutral-200 p-6">
          <h2 className="text-xl font-medium">Create Menu</h2>
-          <form action={createMenuAction} className="mt-4 space-y-3">
-            <label className="space-y-1">
-              <span className="text-xs text-neutral-600">Name</span>
-              <input
-                name="name"
-                required
-                className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
-              />
-            </label>
-            <label className="space-y-1">
-              <span className="text-xs text-neutral-600">Slug</span>
-              <input
-                name="slug"
-                required
-                className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
-              />
-            </label>
-            <label className="space-y-1">
-              <span className="text-xs text-neutral-600">Location</span>
-              <input
-                name="location"
-                defaultValue="primary"
-                className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
-              />
-            </label>
-            <label className="inline-flex items-center gap-2 text-sm text-neutral-700">
-              <input
-                name="isVisible"
-                type="checkbox"
-                value="true"
-                defaultChecked
-                className="size-4"
-              />
-              Visible
-            </label>
-            <Button type="submit">Create menu</Button>
-          </form>
+          <CreateMenuForm action={createMenuAction} />
        </article>

        <article className="rounded-xl border border-neutral-200 p-6">
          <h2 className="text-xl font-medium">Create Navigation Item</h2>
-          <form action={createItemAction} className="mt-4 space-y-3">
-            <label className="space-y-1">
-              <span className="text-xs text-neutral-600">Menu</span>
-              <select
-                name="menuId"
-                className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
-              >
-                {menus.map((menu) => (
-                  <option key={menu.id} value={menu.id}>
-                    {menu.name} ({menu.location})
-                  </option>
-                ))}
-              </select>
-            </label>
-            <label className="space-y-1">
-              <span className="text-xs text-neutral-600">Label</span>
-              <input
-                name="label"
-                required
-                className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
-              />
-            </label>
-            <div className="grid gap-3 md:grid-cols-2">
-              <label className="space-y-1">
-                <span className="text-xs text-neutral-600">Custom href</span>
-                <input
-                  name="href"
-                  className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
-                />
-              </label>
-              <label className="space-y-1">
-                <span className="text-xs text-neutral-600">Linked page</span>
-                <select
-                  name="pageId"
-                  className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
-                >
-                  <option value="">(none)</option>
-                  {pages.map((page) => (
-                    <option key={page.id} value={page.id}>
-                      {page.title} (/{page.slug})
-                    </option>
-                  ))}
-                </select>
-              </label>
-            </div>
-            <div className="grid gap-3 md:grid-cols-2">
-              <label className="space-y-1">
-                <span className="text-xs text-neutral-600">Parent item id</span>
-                <input
-                  name="parentId"
-                  className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
-                />
-              </label>
-              <label className="space-y-1">
-                <span className="text-xs text-neutral-600">Sort order</span>
-                <input
-                  name="sortOrder"
-                  defaultValue="0"
-                  type="number"
-                  min={0}
-                  className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
-                />
-              </label>
-            </div>
-            <label className="inline-flex items-center gap-2 text-sm text-neutral-700">
-              <input
-                name="isVisible"
-                type="checkbox"
-                value="true"
-                defaultChecked
-                className="size-4"
-              />
-              Visible
-            </label>
-            <Button type="submit">Create item</Button>
-          </form>
+          <CreateNavigationItemForm action={createItemAction} menus={menus} pages={pages} />
        </article>
      </section>

--- a/apps/admin/src/app/pages/[id]/page.tsx
+++ b/apps/admin/src/app/pages/[id]/page.tsx
@@ -1,4 +1,10 @@
-import { deletePage, getPageById, updatePage } from "@cms/db"
+import {
+  deletePage,
+  getPageById,
+  listPageTranslations,
+  updatePage,
+  upsertPageTranslation,
+} from "@cms/db"
 import { Button } from "@cms/ui/button"
 import Link from "next/link"
 import { redirect } from "next/navigation"
@@ -9,6 +15,8 @@ import { requirePermissionForRoute } from "@/lib/route-guards"
 export const dynamic = "force-dynamic"

 type SearchParamsInput = Record<string, string | string[] | undefined>
+const SUPPORTED_LOCALES = ["de", "en", "es", "fr"] as const
+type SupportedLocale = (typeof SUPPORTED_LOCALES)[number]

 type PageProps = {
  params: Promise<{ id: string }>
@@ -48,6 +56,14 @@ function redirectWithState(pageId: string, params: { notice?: string; error?: st
  redirect(value ? `/pages/${pageId}?${value}` : `/pages/${pageId}`)
 }

+function normalizeLocale(input: string | null): SupportedLocale {
+  if (input && SUPPORTED_LOCALES.includes(input as SupportedLocale)) {
+    return input as SupportedLocale
+  }
+
+  return "en"
+}
+
 export default async function PageEditorPage({ params, searchParams }: PageProps) {
  const role = await requirePermissionForRoute({
    nextPath: "/pages",
@@ -57,7 +73,11 @@ export default async function PageEditorPage({ params, searchParams }: PageProps
  const resolvedParams = await params
  const pageId = resolvedParams.id

-  const [resolvedSearchParams, pageRecord] = await Promise.all([searchParams, getPageById(pageId)])
+  const [resolvedSearchParams, pageRecord, translations] = await Promise.all([
+    searchParams,
+    getPageById(pageId),
+    listPageTranslations(pageId),
+  ])

  if (!pageRecord) {
    redirect("/pages?error=Page+not+found")
@@ -66,6 +86,8 @@ export default async function PageEditorPage({ params, searchParams }: PageProps
  const page = pageRecord
  const notice = readFirstValue(resolvedSearchParams.notice)
  const error = readFirstValue(resolvedSearchParams.error)
+  const selectedLocale = normalizeLocale(readFirstValue(resolvedSearchParams.locale))
+  const selectedTranslation = translations.find((entry) => entry.locale === selectedLocale)

  async function updatePageAction(formData: FormData) {
    "use server"
@@ -118,6 +140,34 @@ export default async function PageEditorPage({ params, searchParams }: PageProps
    redirect("/pages?notice=Page+deleted")
  }

+  async function upsertPageTranslationAction(formData: FormData) {
+    "use server"
+
+    await requirePermissionForRoute({
+      nextPath: "/pages",
+      permission: "pages:write",
+      scope: "team",
+    })
+
+    const locale = normalizeLocale(readInputString(formData, "locale"))
+
+    try {
+      await upsertPageTranslation({
+        pageId,
+        locale,
+        title: readInputString(formData, "title"),
+        summary: readNullableString(formData, "summary"),
+        content: readInputString(formData, "content"),
+        seoTitle: readNullableString(formData, "seoTitle"),
+        seoDescription: readNullableString(formData, "seoDescription"),
+      })
+    } catch {
+      redirect(`/pages/${pageId}?error=Failed+to+save+translation.&locale=${locale}`)
+    }
+
+    redirect(`/pages/${pageId}?notice=Translation+saved.&locale=${locale}`)
+  }
+
  return (
    <AdminShell
      role={role}
@@ -226,6 +276,132 @@ export default async function PageEditorPage({ params, searchParams }: PageProps
        </form>
      </section>

+      <section className="rounded-xl border border-neutral-200 p-6">
+        <div className="space-y-1">
+          <h3 className="text-xl font-medium">Translations</h3>
+          <p className="text-sm text-neutral-600">
+            Add locale-specific page content. Missing locales fall back to base page fields.
+          </p>
+        </div>
+
+        <div className="mt-4 flex flex-wrap gap-2">
+          {SUPPORTED_LOCALES.map((locale) => {
+            const isActive = locale === selectedLocale
+            const hasTranslation = translations.some((entry) => entry.locale === locale)
+
+            return (
+              <Link
+                key={locale}
+                href={`/pages/${pageId}?locale=${locale}`}
+                className={`inline-flex items-center gap-2 rounded border px-3 py-1.5 text-xs ${
+                  isActive
+                    ? "border-neutral-800 bg-neutral-900 text-white"
+                    : "border-neutral-300 text-neutral-700"
+                }`}
+              >
+                <span>{locale.toUpperCase()}</span>
+                <span className={isActive ? "text-neutral-200" : "text-neutral-500"}>
+                  {hasTranslation ? "saved" : "missing"}
+                </span>
+              </Link>
+            )
+          })}
+        </div>
+
+        {translations.length > 0 ? (
+          <div className="mt-4 rounded border border-neutral-200">
+            <table className="min-w-full text-left text-sm">
+              <thead className="text-xs uppercase tracking-wide text-neutral-500">
+                <tr>
+                  <th className="px-3 py-2">Locale</th>
+                  <th className="px-3 py-2">Title</th>
+                  <th className="px-3 py-2">Updated</th>
+                </tr>
+              </thead>
+              <tbody>
+                {translations.map((translation) => (
+                  <tr key={translation.id} className="border-t border-neutral-200">
+                    <td className="px-3 py-2">{translation.locale.toUpperCase()}</td>
+                    <td className="px-3 py-2">{translation.title}</td>
+                    <td className="px-3 py-2 text-neutral-600">
+                      {translation.updatedAt.toLocaleDateString("en-US")}
+                    </td>
+                  </tr>
+                ))}
+              </tbody>
+            </table>
+          </div>
+        ) : null}
+
+        <form action={upsertPageTranslationAction} className="mt-6 space-y-3">
+          <label className="space-y-1">
+            <span className="text-xs text-neutral-600">Locale</span>
+            <select
+              name="locale"
+              defaultValue={selectedLocale}
+              className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
+            >
+              {SUPPORTED_LOCALES.map((locale) => (
+                <option key={locale} value={locale}>
+                  {locale.toUpperCase()}
+                </option>
+              ))}
+            </select>
+          </label>
+
+          <label className="space-y-1">
+            <span className="text-xs text-neutral-600">Title</span>
+            <input
+              name="title"
+              defaultValue={selectedTranslation?.title ?? page.title}
+              required
+              className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
+            />
+          </label>
+
+          <label className="space-y-1">
+            <span className="text-xs text-neutral-600">Summary</span>
+            <input
+              name="summary"
+              defaultValue={selectedTranslation?.summary ?? page.summary ?? ""}
+              className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
+            />
+          </label>
+
+          <label className="space-y-1">
+            <span className="text-xs text-neutral-600">Content</span>
+            <textarea
+              name="content"
+              rows={8}
+              defaultValue={selectedTranslation?.content ?? page.content}
+              required
+              className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
+            />
+          </label>
+
+          <div className="grid gap-3 md:grid-cols-2">
+            <label className="space-y-1">
+              <span className="text-xs text-neutral-600">SEO title</span>
+              <input
+                name="seoTitle"
+                defaultValue={selectedTranslation?.seoTitle ?? page.seoTitle ?? ""}
+                className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
+              />
+            </label>
+            <label className="space-y-1">
+              <span className="text-xs text-neutral-600">SEO description</span>
+              <input
+                name="seoDescription"
+                defaultValue={selectedTranslation?.seoDescription ?? page.seoDescription ?? ""}
+                className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
+              />
+            </label>
+          </div>
+
+          <Button type="submit">Save translation</Button>
+        </form>
+      </section>
+
      <section className="rounded-xl border border-red-300 bg-red-50 p-6">
        <h3 className="text-lg font-medium text-red-800">Danger Zone</h3>
        <p className="mt-1 text-sm text-red-700">
--- a/apps/admin/src/app/pages/page.tsx
+++ b/apps/admin/src/app/pages/page.tsx
@@ -1,10 +1,10 @@
 import { createPage, listPages } from "@cms/db"
-import { Button } from "@cms/ui/button"
 import { revalidatePath } from "next/cache"
 import Link from "next/link"
 import { redirect } from "next/navigation"

 import { AdminShell } from "@/components/admin-shell"
+import { CreatePageForm } from "@/components/pages/create-page-form"
 import { requirePermissionForRoute } from "@/lib/route-guards"

 export const dynamic = "force-dynamic"
@@ -110,75 +110,7 @@ export default async function PagesManagementPage({

      <section className="rounded-xl border border-neutral-200 p-6">
        <h2 className="text-xl font-medium">Create Page</h2>
-        <form action={createPageAction} className="mt-4 space-y-3">
-          <div className="grid gap-3 md:grid-cols-3">
-            <label className="space-y-1 md:col-span-2">
-              <span className="text-xs text-neutral-600">Title</span>
-              <input
-                name="title"
-                required
-                className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
-              />
-            </label>
-            <label className="space-y-1">
-              <span className="text-xs text-neutral-600">Status</span>
-              <select
-                name="status"
-                defaultValue="draft"
-                className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
-              >
-                <option value="draft">draft</option>
-                <option value="published">published</option>
-              </select>
-            </label>
-          </div>
-
-          <label className="space-y-1">
-            <span className="text-xs text-neutral-600">Slug</span>
-            <input
-              name="slug"
-              required
-              className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
-            />
-          </label>
-
-          <label className="space-y-1">
-            <span className="text-xs text-neutral-600">Summary</span>
-            <input
-              name="summary"
-              className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
-            />
-          </label>
-
-          <label className="space-y-1">
-            <span className="text-xs text-neutral-600">Content</span>
-            <textarea
-              name="content"
-              rows={6}
-              required
-              className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
-            />
-          </label>
-
-          <div className="grid gap-3 md:grid-cols-2">
-            <label className="space-y-1">
-              <span className="text-xs text-neutral-600">SEO title</span>
-              <input
-                name="seoTitle"
-                className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
-              />
-            </label>
-            <label className="space-y-1">
-              <span className="text-xs text-neutral-600">SEO description</span>
-              <input
-                name="seoDescription"
-                className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
-              />
-            </label>
-          </div>
-
-          <Button type="submit">Create page</Button>
-        </form>
+        <CreatePageForm action={createPageAction} />
      </section>

      <section className="rounded-xl border border-neutral-200 p-6">
--- a/apps/admin/src/components/navigation/create-menu-form.test.tsx
+++ b/apps/admin/src/components/navigation/create-menu-form.test.tsx
@@ -0,0 +1,20 @@
+/* @vitest-environment jsdom */
+
+import { render, screen } from "@testing-library/react"
+import { describe, expect, it, vi } from "vitest"
+
+import { CreateMenuForm } from "./create-menu-form"
+
+describe("CreateMenuForm", () => {
+  it("renders defaults for location and visibility", () => {
+    render(<CreateMenuForm action={vi.fn()} />)
+
+    const location = screen.getByLabelText("Location") as HTMLInputElement
+    expect(location.value).toBe("primary")
+
+    const visible = screen.getByLabelText("Visible") as HTMLInputElement
+    expect(visible.checked).toBe(true)
+
+    expect(screen.getByRole("button", { name: "Create menu" })).not.toBeNull()
+  })
+})
--- a/apps/admin/src/components/navigation/create-menu-form.tsx
+++ b/apps/admin/src/components/navigation/create-menu-form.tsx
@@ -0,0 +1,41 @@
+import { Button } from "@cms/ui/button"
+
+type CreateMenuFormProps = {
+  action: (formData: FormData) => void | Promise<void>
+}
+
+export function CreateMenuForm({ action }: CreateMenuFormProps) {
+  return (
+    <form action={action} className="mt-4 space-y-3">
+      <label className="space-y-1">
+        <span className="text-xs text-neutral-600">Name</span>
+        <input
+          name="name"
+          required
+          className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
+        />
+      </label>
+      <label className="space-y-1">
+        <span className="text-xs text-neutral-600">Slug</span>
+        <input
+          name="slug"
+          required
+          className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
+        />
+      </label>
+      <label className="space-y-1">
+        <span className="text-xs text-neutral-600">Location</span>
+        <input
+          name="location"
+          defaultValue="primary"
+          className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
+        />
+      </label>
+      <label className="inline-flex items-center gap-2 text-sm text-neutral-700">
+        <input name="isVisible" type="checkbox" value="true" defaultChecked className="size-4" />
+        Visible
+      </label>
+      <Button type="submit">Create menu</Button>
+    </form>
+  )
+}
--- a/apps/admin/src/components/navigation/create-navigation-item-form.test.tsx
+++ b/apps/admin/src/components/navigation/create-navigation-item-form.test.tsx
@@ -0,0 +1,32 @@
+/* @vitest-environment jsdom */
+
+import { render, screen } from "@testing-library/react"
+import { describe, expect, it, vi } from "vitest"
+
+import { CreateNavigationItemForm } from "./create-navigation-item-form"
+
+describe("CreateNavigationItemForm", () => {
+  it("renders menu/page options and defaults", () => {
+    render(
+      <CreateNavigationItemForm
+        action={vi.fn()}
+        menus={[{ id: "menu-1", name: "Primary", location: "header" }]}
+        pages={[{ id: "page-1", title: "Home", slug: "home" }]}
+      />,
+    )
+
+    const menu = screen.getByLabelText("Menu") as HTMLSelectElement
+    expect(menu.options.length).toBe(1)
+    expect(menu.value).toBe("menu-1")
+
+    const page = screen.getByLabelText("Linked page") as HTMLSelectElement
+    expect(page.options.length).toBe(2)
+    expect(page.options[0]?.value).toBe("")
+
+    const sortOrder = screen.getByLabelText("Sort order") as HTMLInputElement
+    expect(sortOrder.value).toBe("0")
+
+    const visible = screen.getByLabelText("Visible") as HTMLInputElement
+    expect(visible.checked).toBe(true)
+  })
+})
--- a/apps/admin/src/components/navigation/create-navigation-item-form.tsx
+++ b/apps/admin/src/components/navigation/create-navigation-item-form.tsx
@@ -0,0 +1,94 @@
+import { Button } from "@cms/ui/button"
+
+type MenuOption = {
+  id: string
+  name: string
+  location: string
+}
+
+type PageOption = {
+  id: string
+  title: string
+  slug: string
+}
+
+type CreateNavigationItemFormProps = {
+  action: (formData: FormData) => void | Promise<void>
+  menus: MenuOption[]
+  pages: PageOption[]
+}
+
+export function CreateNavigationItemForm({ action, menus, pages }: CreateNavigationItemFormProps) {
+  return (
+    <form action={action} className="mt-4 space-y-3">
+      <label className="space-y-1">
+        <span className="text-xs text-neutral-600">Menu</span>
+        <select
+          name="menuId"
+          className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
+        >
+          {menus.map((menu) => (
+            <option key={menu.id} value={menu.id}>
+              {menu.name} ({menu.location})
+            </option>
+          ))}
+        </select>
+      </label>
+      <label className="space-y-1">
+        <span className="text-xs text-neutral-600">Label</span>
+        <input
+          name="label"
+          required
+          className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
+        />
+      </label>
+      <div className="grid gap-3 md:grid-cols-2">
+        <label className="space-y-1">
+          <span className="text-xs text-neutral-600">Custom href</span>
+          <input
+            name="href"
+            className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
+          />
+        </label>
+        <label className="space-y-1">
+          <span className="text-xs text-neutral-600">Linked page</span>
+          <select
+            name="pageId"
+            className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
+          >
+            <option value="">(none)</option>
+            {pages.map((page) => (
+              <option key={page.id} value={page.id}>
+                {page.title} (/{page.slug})
+              </option>
+            ))}
+          </select>
+        </label>
+      </div>
+      <div className="grid gap-3 md:grid-cols-2">
+        <label className="space-y-1">
+          <span className="text-xs text-neutral-600">Parent item id</span>
+          <input
+            name="parentId"
+            className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
+          />
+        </label>
+        <label className="space-y-1">
+          <span className="text-xs text-neutral-600">Sort order</span>
+          <input
+            name="sortOrder"
+            defaultValue="0"
+            type="number"
+            min={0}
+            className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
+          />
+        </label>
+      </div>
+      <label className="inline-flex items-center gap-2 text-sm text-neutral-700">
+        <input name="isVisible" type="checkbox" value="true" defaultChecked className="size-4" />
+        Visible
+      </label>
+      <Button type="submit">Create item</Button>
+    </form>
+  )
+}
--- a/apps/admin/src/components/pages/create-page-form.test.tsx
+++ b/apps/admin/src/components/pages/create-page-form.test.tsx
@@ -0,0 +1,21 @@
+/* @vitest-environment jsdom */
+
+import { render, screen } from "@testing-library/react"
+import { describe, expect, it, vi } from "vitest"
+
+import { CreatePageForm } from "./create-page-form"
+
+describe("CreatePageForm", () => {
+  it("renders required fields and draft default status", () => {
+    render(<CreatePageForm action={vi.fn()} />)
+
+    expect((screen.getByLabelText("Title") as HTMLInputElement).name).toBe("title")
+    expect((screen.getByLabelText("Slug") as HTMLInputElement).name).toBe("slug")
+    expect((screen.getByLabelText("Content") as HTMLTextAreaElement).name).toBe("content")
+
+    const status = screen.getByLabelText("Status") as HTMLSelectElement
+    expect(status.value).toBe("draft")
+
+    expect(screen.getByRole("button", { name: "Create page" })).not.toBeNull()
+  })
+})
--- a/apps/admin/src/components/pages/create-page-form.tsx
+++ b/apps/admin/src/components/pages/create-page-form.tsx
@@ -0,0 +1,79 @@
+import { Button } from "@cms/ui/button"
+
+type CreatePageFormProps = {
+  action: (formData: FormData) => void | Promise<void>
+}
+
+export function CreatePageForm({ action }: CreatePageFormProps) {
+  return (
+    <form action={action} className="mt-4 space-y-3">
+      <div className="grid gap-3 md:grid-cols-3">
+        <label className="space-y-1 md:col-span-2">
+          <span className="text-xs text-neutral-600">Title</span>
+          <input
+            name="title"
+            required
+            className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
+          />
+        </label>
+        <label className="space-y-1">
+          <span className="text-xs text-neutral-600">Status</span>
+          <select
+            name="status"
+            defaultValue="draft"
+            className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
+          >
+            <option value="draft">draft</option>
+            <option value="published">published</option>
+          </select>
+        </label>
+      </div>
+
+      <label className="space-y-1">
+        <span className="text-xs text-neutral-600">Slug</span>
+        <input
+          name="slug"
+          required
+          className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
+        />
+      </label>
+
+      <label className="space-y-1">
+        <span className="text-xs text-neutral-600">Summary</span>
+        <input
+          name="summary"
+          className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
+        />
+      </label>
+
+      <label className="space-y-1">
+        <span className="text-xs text-neutral-600">Content</span>
+        <textarea
+          name="content"
+          rows={6}
+          required
+          className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
+        />
+      </label>
+
+      <div className="grid gap-3 md:grid-cols-2">
+        <label className="space-y-1">
+          <span className="text-xs text-neutral-600">SEO title</span>
+          <input
+            name="seoTitle"
+            className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
+          />
+        </label>
+        <label className="space-y-1">
+          <span className="text-xs text-neutral-600">SEO description</span>
+          <input
+            name="seoDescription"
+            className="w-full rounded border border-neutral-300 px-3 py-2 text-sm"
+          />
+        </label>
+      </div>
+
+      <Button type="submit">Create page</Button>
+    </form>
+  )
+}
--- a/apps/web/src/app/[locale]/[slug]/page.tsx
+++ b/apps/web/src/app/[locale]/[slug]/page.tsx
@@ -1,4 +1,4 @@
-import { getPublishedPageBySlug } from "@cms/db"
+import { getPublishedPageBySlugForLocale } from "@cms/db"
 import { notFound } from "next/navigation"

 import { PublicPageView } from "@/components/public-page-view"
@@ -6,12 +6,12 @@ import { PublicPageView } from "@/components/public-page-view"
 export const dynamic = "force-dynamic"

 type PageProps = {
-  params: Promise<{ slug: string }>
+  params: Promise<{ locale: string; slug: string }>
 }

 export default async function CmsPageRoute({ params }: PageProps) {
-  const { slug } = await params
-  const page = await getPublishedPageBySlug(slug)
+  const { locale, slug } = await params
+  const page = await getPublishedPageBySlugForLocale(slug, locale)

  if (!page) {
    notFound()
--- a/apps/web/src/app/[locale]/page.tsx
+++ b/apps/web/src/app/[locale]/page.tsx
@@ -1,4 +1,4 @@
-import { getPublishedPageBySlug, listPosts } from "@cms/db"
+import { getPublishedPageBySlugForLocale, listPosts } from "@cms/db"
 import { Button } from "@cms/ui/button"
 import { getTranslations } from "next-intl/server"
 import { PublicAnnouncements } from "@/components/public-announcements"
@@ -6,9 +6,15 @@ import { PublicPageView } from "@/components/public-page-view"

 export const dynamic = "force-dynamic"

-export default async function HomePage() {
+type HomePageProps = {
+  params: Promise<{ locale: string }>
+}
+
+export default async function HomePage({ params }: HomePageProps) {
+  const { locale } = await params
+
  const [homePage, posts, t] = await Promise.all([
-    getPublishedPageBySlug("home"),
+    getPublishedPageBySlugForLocale("home", locale),
    listPosts(),
    getTranslations("Home"),
  ])
--- a/packages/content/src/pages-navigation.ts
+++ b/packages/content/src/pages-navigation.ts
@@ -1,6 +1,7 @@
 import { z } from "zod"

 export const pageStatusSchema = z.enum(["draft", "published"])
+export const pageLocaleSchema = z.enum(["de", "en", "es", "fr"])

 export const createPageInputSchema = z.object({
  title: z.string().min(1).max(180),
@@ -23,6 +24,16 @@ export const updatePageInputSchema = z.object({
  seoDescription: z.string().max(320).nullable().optional(),
 })

+export const upsertPageTranslationInputSchema = z.object({
+  pageId: z.string().uuid(),
+  locale: pageLocaleSchema,
+  title: z.string().min(1).max(180),
+  summary: z.string().max(500).nullable().optional(),
+  content: z.string().min(1),
+  seoTitle: z.string().max(180).nullable().optional(),
+  seoDescription: z.string().max(320).nullable().optional(),
+})
+
 export const createNavigationMenuInputSchema = z.object({
  name: z.string().min(1).max(180),
  slug: z.string().min(1).max(180),
@@ -52,6 +63,7 @@ export const updateNavigationItemInputSchema = z.object({

 export type CreatePageInput = z.infer<typeof createPageInputSchema>
 export type UpdatePageInput = z.infer<typeof updatePageInputSchema>
+export type UpsertPageTranslationInput = z.infer<typeof upsertPageTranslationInputSchema>
 export type CreateNavigationMenuInput = z.infer<typeof createNavigationMenuInputSchema>
 export type CreateNavigationItemInput = z.infer<typeof createNavigationItemInputSchema>
 export type UpdateNavigationItemInput = z.infer<typeof updateNavigationItemInputSchema>
--- a/packages/db/prisma/migrations/20260212220000_page_translations/migration.sql
+++ b/packages/db/prisma/migrations/20260212220000_page_translations/migration.sql
@@ -0,0 +1,24 @@
+-- CreateTable
+CREATE TABLE "PageTranslation" (
+    "id" TEXT NOT NULL,
+    "pageId" TEXT NOT NULL,
+    "locale" TEXT NOT NULL,
+    "title" TEXT NOT NULL,
+    "summary" TEXT,
+    "content" TEXT NOT NULL,
+    "seoTitle" TEXT,
+    "seoDescription" TEXT,
+    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "updatedAt" TIMESTAMP(3) NOT NULL,
+
+    CONSTRAINT "PageTranslation_pkey" PRIMARY KEY ("id")
+);
+
+-- CreateIndex
+CREATE INDEX "PageTranslation_locale_idx" ON "PageTranslation"("locale");
+
+-- CreateIndex
+CREATE UNIQUE INDEX "PageTranslation_pageId_locale_key" ON "PageTranslation"("pageId", "locale");
+
+-- AddForeignKey
+ALTER TABLE "PageTranslation" ADD CONSTRAINT "PageTranslation_pageId_fkey" FOREIGN KEY ("pageId") REFERENCES "Page"("id") ON DELETE CASCADE ON UPDATE CASCADE;
--- a/packages/db/prisma/schema.prisma
+++ b/packages/db/prisma/schema.prisma
@@ -267,10 +267,28 @@ model Page {
  createdAt      DateTime @default(now())
  updatedAt      DateTime @updatedAt
  navItems       NavigationItem[]
+  translations   PageTranslation[]

  @@index([status])
 }

+model PageTranslation {
+  id             String   @id @default(uuid())
+  pageId         String
+  locale         String
+  title          String
+  summary        String?
+  content        String
+  seoTitle       String?
+  seoDescription String?
+  createdAt      DateTime @default(now())
+  updatedAt      DateTime @updatedAt
+  page           Page     @relation(fields: [pageId], references: [id], onDelete: Cascade)
+
+  @@unique([pageId, locale])
+  @@index([locale])
+}
+
 model NavigationMenu {
  id        String           @id @default(uuid())
  name      String
--- a/packages/db/src/index.ts
+++ b/packages/db/src/index.ts
@@ -41,12 +41,15 @@ export {
  deletePage,
  getPageById,
  getPublishedPageBySlug,
+  getPublishedPageBySlugForLocale,
  listNavigationMenus,
  listPages,
+  listPageTranslations,
  listPublicNavigation,
  listPublishedPageSlugs,
  updateNavigationItem,
  updatePage,
+  upsertPageTranslation,
 } from "./pages-navigation"
 export {
  createPost,
--- a/packages/db/src/pages-navigation.test.ts
+++ b/packages/db/src/pages-navigation.test.ts
@@ -7,6 +7,11 @@ const { mockDb } = vi.hoisted(() => ({
      update: vi.fn(),
      delete: vi.fn(),
      findUnique: vi.fn(),
+      findFirst: vi.fn(),
+      findMany: vi.fn(),
+    },
+    pageTranslation: {
+      upsert: vi.fn(),
      findMany: vi.fn(),
    },
    navigationMenu: {
@@ -30,8 +35,10 @@ import {
  createNavigationItem,
  createNavigationMenu,
  createPage,
+  getPublishedPageBySlugForLocale,
  listPublicNavigation,
  updatePage,
+  upsertPageTranslation,
 } from "./pages-navigation"

 describe("pages-navigation service", () => {
@@ -120,4 +127,63 @@ describe("pages-navigation service", () => {
      },
    ])
  })
+
+  it("validates locale when upserting page translation", async () => {
+    await expect(() =>
+      upsertPageTranslation({
+        pageId: "550e8400-e29b-41d4-a716-446655440000",
+        locale: "it",
+        title: "Titolo",
+        content: "Contenuto",
+      }),
+    ).rejects.toThrow()
+  })
+
+  it("upserts page translation and reads localized page with fallback", async () => {
+    mockDb.pageTranslation.upsert.mockResolvedValue({ id: "pt-1" })
+    mockDb.page.findFirst
+      .mockResolvedValueOnce({
+        id: "page-1",
+        title: "About",
+        summary: "Base summary",
+        content: "Base content",
+        seoTitle: "Base SEO",
+        seoDescription: "Base description",
+        translations: [
+          {
+            locale: "de",
+            title: "Uber Uns",
+            summary: "Zusammenfassung",
+            content: "Inhalt",
+            seoTitle: "SEO DE",
+            seoDescription: "Beschreibung",
+          },
+        ],
+      })
+      .mockResolvedValueOnce({
+        id: "page-1",
+        title: "About",
+        summary: "Base summary",
+        content: "Base content",
+        seoTitle: "Base SEO",
+        seoDescription: "Base description",
+        translations: [],
+      })
+
+    await upsertPageTranslation({
+      pageId: "550e8400-e29b-41d4-a716-446655440000",
+      locale: "de",
+      title: "Uber Uns",
+      content: "Inhalt",
+    })
+
+    const translated = await getPublishedPageBySlugForLocale("about", "de")
+    const fallback = await getPublishedPageBySlugForLocale("about", "fr")
+
+    expect(mockDb.pageTranslation.upsert).toHaveBeenCalledTimes(1)
+    expect(translated?.title).toBe("Uber Uns")
+    expect(translated?.content).toBe("Inhalt")
+    expect(fallback?.title).toBe("About")
+    expect(fallback?.content).toBe("Base content")
+  })
 })
--- a/packages/db/src/pages-navigation.ts
+++ b/packages/db/src/pages-navigation.ts
@@ -4,6 +4,7 @@ import {
  createPageInputSchema,
  updateNavigationItemInputSchema,
  updatePageInputSchema,
+  upsertPageTranslationInputSchema,
 } from "@cms/content"

 import { db } from "./client"
@@ -54,6 +55,38 @@ export async function getPublishedPageBySlug(slug: string) {
  })
 }

+export async function getPublishedPageBySlugForLocale(slug: string, locale: string) {
+  const page = await db.page.findFirst({
+    where: {
+      slug,
+      status: "published",
+    },
+    include: {
+      translations: {
+        where: {
+          locale,
+        },
+        take: 1,
+      },
+    },
+  })
+
+  if (!page) {
+    return null
+  }
+
+  const translation = page.translations[0]
+
+  return {
+    ...page,
+    title: translation?.title ?? page.title,
+    summary: translation?.summary ?? page.summary,
+    content: translation?.content ?? page.content,
+    seoTitle: translation?.seoTitle ?? page.seoTitle,
+    seoDescription: translation?.seoDescription ?? page.seoDescription,
+  }
+}
+
 export async function createPage(input: unknown) {
  const payload = createPageInputSchema.parse(input)

@@ -85,6 +118,33 @@ export async function deletePage(id: string) {
  })
 }

+export async function upsertPageTranslation(input: unknown) {
+  const payload = upsertPageTranslationInputSchema.parse(input)
+  const { pageId, locale, ...data } = payload
+
+  return db.pageTranslation.upsert({
+    where: {
+      pageId_locale: {
+        pageId,
+        locale,
+      },
+    },
+    create: {
+      pageId,
+      locale,
+      ...data,
+    },
+    update: data,
+  })
+}
+
+export async function listPageTranslations(pageId: string) {
+  return db.pageTranslation.findMany({
+    where: { pageId },
+    orderBy: [{ locale: "asc" }],
+  })
+}
+
 export async function listNavigationMenus() {
  return db.navigationMenu.findMany({
    orderBy: [{ location: "asc" }, { name: "asc" }],
Author	SHA1	Message	Date
Citali	618319dbc2	feat(i18n): wire page translation editor and locale rendering	2026-02-12 20:57:42 +01:00
Citali	506e2feb10	test(i18n): add translated page CRUD locale validation coverage	2026-02-12 20:53:06 +01:00
Citali	749fb80083	test(admin): cover pages and navigation form components	2026-02-12 20:48:51 +01:00