property-management-network/app/(dashboard)/maintenance/page.tsx

import { redirect } from "next/navigation"
import { asc, desc, eq } from "drizzle-orm"
import { db } from "@/lib/db"
import { maintenance_requests, properties } from "@/lib/db/schema"
import { getSessionUser } from "@/lib/session"
import { getEffectiveOwnerId } from "@/lib/account"
import Link from "next/link"
import { Plus } from "lucide-react"
import { MaintenanceList } from "./maintenance-list"

export const metadata = { title: "Maintenance" }

export default async function MaintenancePage() {
  const user = await getSessionUser()
  if (!user) redirect("/login")

  const ownerId = await getEffectiveOwnerId(user.id)

  const [requests, propertyList] = await Promise.all([
    db.query.maintenance_requests.findMany({
      where: eq(maintenance_requests.user_id, ownerId),
      with: {
        property: { columns: { name: true } },
        unit: { columns: { unit_number: true } },
        tenant: { columns: { first_name: true, last_name: true } },
      },
      orderBy: desc(maintenance_requests.created_at),
    }),
    db
      .select({ id: properties.id, name: properties.name })
      .from(properties)
      .where(eq(properties.user_id, ownerId))
      .orderBy(asc(properties.name)),
  ])

  return (
    <div className="space-y-6">
      <div className="flex items-center justify-between">
        <div>
          <h2 className="text-lg font-semibold text-white">Maintenance</h2>
          <p className="text-sm text-white/40">{requests?.length ?? 0} total requests</p>
        </div>
        <Link href="/maintenance/new" className="flex items-center gap-2 rounded-lg bg-indigo-600 px-4 py-2 text-sm font-medium text-white hover:bg-indigo-500 transition">
          <Plus className="h-4 w-4" /> New Request
        </Link>
      </div>
      <MaintenanceList requests={requests ?? []} properties={propertyList ?? []} />
    </div>
  )
}