AI Internal Tools Builder: Generate Custom Back-Office Portals Grounded in Live Databases

import { verifySessionRole } from '@/lib/auth'
import { sql } from '@/lib/db'
import { CustomerManagementTable } from '@/components/CustomerManagementTable'

export default async function AdminCustomerPortal() {
  // Enforce server-side role-based access control
  const session = await verifySessionRole(['ADMIN', 'SUPPORT_LEAD'])

  // Fetch live customer records grounded in PostgreSQL schema
  const customers = await sql`
    SELECT id, email, plan_tier, created_at, status 
    FROM users 
    WHERE organization_id = ${session.orgId}
    ORDER BY created_at DESC 
    LIMIT 50;
  `

  return (
    <div className="p-8 max-w-7xl mx-auto space-y-6">
      <div className="flex justify-between items-center">
        <h1 className="text-2xl font-bold text-white">Customer Support Console</h1>
        <span className="font-mono text-xs bg-white/10 px-3 py-1 rounded">RBAC: {session.role}</span>
      </div>
      <CustomerManagementTable data={customers} />
    </div>
  )
}