import { redirect } from "next/navigation"
import { and, eq } from "drizzle-orm"
import { db } from "@/lib/db"
import { tenants as tenantsTable, properties } from "@/lib/db/schema"
import { getSessionUser } from "@/lib/session"
import { getEffectiveOwnerId } from "@/lib/account"
import { BackButton } from "@/components/ui/back-button"
import { RentCsvImport } from "./rent-csv-import"

export const metadata = { title: "Import Rent Payments" }

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

  const ownerId = await getEffectiveOwnerId(user.id)

  const tenants = await db.query.tenants.findMany({
    where: and(eq(tenantsTable.user_id, ownerId), eq(tenantsTable.status, "active")),
    columns: { id: true, first_name: true, last_name: true },
    with: {
      unit: { columns: { unit_number: true } },
      property: { columns: { name: true } },
    },
  })

  const properties_ = await db
    .select({ id: properties.id, name: properties.name })
    .from(properties)
    .where(eq(properties.user_id, ownerId))

  return (
    <div className="mx-auto max-w-3xl space-y-6">
      <BackButton href="/rent" />
      <div>
        <h2 className="text-lg font-semibold text-white">Import Rent Payments</h2>
        <p className="text-sm text-white/40">Upload a CSV file to add multiple rent payments at once</p>
      </div>
      <RentCsvImport tenants={tenants ?? []} properties={properties_ ?? []} />
    </div>
  )
}
