import type { Metadata } from 'next';
import { RowDataPacket } from 'mysql2';
import pool from '@/lib/db';
import AccessDenied from '@/components/admin/errors/AccessDenied';
import MarketingPageHeader from '@/components/admin/marketing/MarketingPageHeader';
import AdGenerateForm from '@/components/admin/marketing/ads/AdGenerateForm';
import { getMarketingPerms } from '@/lib/ads/pageAccess';
import { getActiveAdAccount } from '@/lib/facebook/client';
import { getAutopilotSettings } from '@/lib/ads/settings';

export const metadata: Metadata = { title: 'Generate Ad' };

export default async function MarketingGeneratePage({ searchParams }: { searchParams: Promise<{ inspire?: string | string[] }> }) {
  const perms = await getMarketingPerms();
  if (!perms.create) return <AccessDenied />;

  const [{ inspire }, [languages], account, settings] = await Promise.all([
    searchParams,
    pool.query<RowDataPacket[]>(
      `SELECT code, name, is_default FROM languages WHERE is_active = 1 AND deleted_at IS NULL ORDER BY is_default DESC, name ASC`,
    ),
    getActiveAdAccount(),
    getAutopilotSettings(),
  ]);
  const inspirationIds = (Array.isArray(inspire) ? inspire : inspire ? [inspire] : []).filter((id) => /^[\w-]{1,36}$/.test(id));

  return (
    <div className="sm:p-6">
      <MarketingPageHeader
        title="Generate Ad with AI"
        subtitle="Pick a product, optionally learn from competitor ads, and let AI write several ad variants. You review before anything goes live."
      />
      <AdGenerateForm
        languages={languages.map((l) => ({ code: l.code, name: l.name }))}
        defaultLanguage={languages.find((l) => l.is_default)?.code ?? 'en'}
        allowedCountries={settings.allowedCountries}
        maxDailyBudget={settings.maxDailyBudgetPerAd}
        adCurrency={account?.currency ?? null}
        connected={Boolean(account)}
        pageName={account?.pageName ?? null}
        initialInspirationIds={inspirationIds}
        canUseCompetitors={perms.competitors}
      />
    </div>
  );
}
