'use client';

import { useState, useEffect, useCallback } from 'react';
import {
  BarChart3,
  Calendar,
  DollarSign,
  ShoppingCart,
  TrendingUp,
  Users,
  Clock,
  Package,
  Layers,
  RefreshCw,
  FileSpreadsheet,
  FileText,
} from 'lucide-react';
import {
  AreaChart,
  Area,
  XAxis,
  YAxis,
  CartesianGrid,
  Tooltip,
  ResponsiveContainer,
  BarChart,
  Bar,
  Cell,
} from 'recharts';
import LoadingSpinner from '@/components/LoadingSpinner';
import { formatCurrency, cn } from '@/lib/utils';
import { reportApi, exportApi } from '@/lib/api';
import { useAuth } from '@/components/AuthContext';
import { canAccessFinancePages } from '@/lib/roles';
import { useRouter } from 'next/navigation';

type ReportTab = 'summary' | 'products' | 'categories' | 'cashiers' | 'hours';

// eslint-disable-next-line @typescript-eslint/no-explicit-any
type ReportData = Record<string, any>;

const TABS: { key: ReportTab; label: string; icon: typeof BarChart3 }[] = [
  { key: 'summary', label: 'Ringkasan', icon: BarChart3 },
  { key: 'products', label: 'Per Produk', icon: Package },
  { key: 'categories', label: 'Per Kategori', icon: Layers },
  { key: 'cashiers', label: 'Per Kasir', icon: Users },
  { key: 'hours', label: 'Per Jam', icon: Clock },
];

function getDefaultDateRange(): { from: string; to: string } {
  const today = new Date();
  const thirtyDaysAgo = new Date(today);
  thirtyDaysAgo.setDate(thirtyDaysAgo.getDate() - 30);
  return {
    from: thirtyDaysAgo.toISOString().split('T')[0],
    to: today.toISOString().split('T')[0],
  };
}

export default function LaporanPage() {
  const { user, loading: authLoading } = useAuth();
  const router = useRouter();
  const [activeTab, setActiveTab] = useState<ReportTab>('summary');
  const [dateFrom, setDateFrom] = useState(getDefaultDateRange().from);
  const [dateTo, setDateTo] = useState(getDefaultDateRange().to);
  const [loading, setLoading] = useState(true);
  const [exporting, setExporting] = useState(false);
  const [data, setData] = useState<ReportData>({});

  useEffect(() => {
    if (authLoading) return;
    if (!canAccessFinancePages(user)) {
      router.replace('/');
    }
  }, [user, authLoading, router]);

  const loadReport = useCallback(async () => {
    if (!canAccessFinancePages(user)) return;
    setLoading(true);
    try {
      let result;
      switch (activeTab) {
        case 'summary': {
          const [summary, trend] = await Promise.all([
            reportApi.salesSummary(dateFrom, dateTo),
            reportApi.dailyTrend(dateFrom, dateTo),
          ]);
          result = { summary, trend };
          break;
        }
        case 'products':
          result = { items: await reportApi.salesByProduct(dateFrom, dateTo) };
          break;
        case 'categories':
          result = { items: await reportApi.salesByCategory(dateFrom, dateTo) };
          break;
        case 'cashiers':
          result = { items: await reportApi.salesByCashier(dateFrom, dateTo) };
          break;
        case 'hours':
          result = { items: await reportApi.salesByHour(dateFrom, dateTo) };
          break;
      }
      setData(result || {});
    } catch (error) {
      console.error('Failed to load report:', error);
    } finally {
      setLoading(false);
    }
  }, [activeTab, dateFrom, dateTo, user]);

  const tabToExportType: Record<ReportTab, string> = {
    summary: 'sales_summary',
    products: 'sales_by_product',
    categories: 'sales_by_category',
    cashiers: 'sales_by_cashier',
    hours: 'sales_by_hour',
  };

  const handleExport = async (format: 'xlsx' | 'pdf') => {
    setExporting(true);
    try {
      const blob = await exportApi.downloadReport({
        type: tabToExportType[activeTab],
        format,
        date_from: dateFrom,
        date_to: dateTo,
      });
      const url = window.URL.createObjectURL(blob);
      const a = document.createElement('a');
      a.href = url;
      a.download = `laporan-${tabToExportType[activeTab]}-${new Date().toISOString().slice(0, 10)}.${format}`;
      document.body.appendChild(a);
      a.click();
      window.URL.revokeObjectURL(url);
      document.body.removeChild(a);
    } catch (error) {
      console.error('Export failed:', error);
    } finally {
      setExporting(false);
    }
  };

  useEffect(() => {
    loadReport();
  }, [loadReport]);

  return (
    <div className="p-4 lg:p-8 space-y-5 lg:space-y-6 animate-fade-in">
      {/* ── Page Header ── */}
      <div className="flex flex-col sm:flex-row sm:items-end sm:justify-between gap-3 sm:gap-4">
        <div>
          <h1 className="text-2xl lg:text-3xl font-bold text-brand-700 font-heading">Laporan Penjualan</h1>
          <p className="mt-1 text-xs lg:text-sm text-brand-500">Analisis performa penjualan toko</p>
        </div>
        <div className="flex items-center gap-2">
          {/* Export Buttons */}
          <button
            onClick={() => handleExport('xlsx')}
            disabled={exporting || loading}
            className="flex items-center gap-1.5 rounded-xl bg-emerald-50 border border-emerald-200/60 px-3.5 py-2.5 text-xs font-semibold text-emerald-700 hover:bg-emerald-100 active:scale-95 transition-all cursor-pointer disabled:opacity-50"
            title="Export ke Excel"
          >
            <FileSpreadsheet className="h-3.5 w-3.5" />
            <span className="hidden sm:inline">Excel</span>
          </button>
          <button
            onClick={() => handleExport('pdf')}
            disabled={exporting || loading}
            className="flex items-center gap-1.5 rounded-xl bg-red-50 border border-red-200/60 px-3.5 py-2.5 text-xs font-semibold text-red-600 hover:bg-red-100 active:scale-95 transition-all cursor-pointer disabled:opacity-50"
            title="Export ke PDF"
          >
            <FileText className="h-3.5 w-3.5" />
            <span className="hidden sm:inline">PDF</span>
          </button>
          {/* Refresh */}
          <button
            onClick={loadReport}
            disabled={loading}
            className="flex items-center gap-1.5 rounded-xl bg-brand-50 border border-brand-200/60 px-3.5 py-2.5 text-xs font-semibold text-brand-600 hover:bg-brand-100 active:scale-95 transition-all cursor-pointer"
          >
            <RefreshCw className={cn('h-3.5 w-3.5', loading && 'animate-spin')} />
            <span className="hidden sm:inline">Refresh</span>
          </button>
        </div>
      </div>

      {/* ── Date Range + Tabs ── */}
      <div className="glass-card rounded-2xl p-3 lg:p-4 space-y-3 lg:space-y-0 lg:flex lg:items-center lg:justify-between lg:gap-4">
        {/* Tabs */}
        <div className="flex gap-1.5 overflow-x-auto scrollbar-hide -mx-3 lg:mx-0 px-3 lg:px-0">
          {TABS.map((tab) => (
            <button
              key={tab.key}
              onClick={() => setActiveTab(tab.key)}
              className={cn(
                'shrink-0 flex items-center gap-1.5 rounded-xl px-3.5 py-2 text-xs font-semibold transition-all cursor-pointer',
                activeTab === tab.key
                  ? 'bg-brand-700 text-white shadow-sm'
                  : 'bg-white text-brand-600 border border-brand-100 hover:bg-brand-50 active:scale-95'
              )}
            >
              <tab.icon className="h-3.5 w-3.5" />
              {tab.label}
            </button>
          ))}
        </div>

        {/* Date Range */}
        <div className="flex flex-wrap items-center gap-2 shrink-0">
          <div className="relative flex-1 min-w-0 sm:flex-none">
            <Calendar className="absolute left-3 top-1/2 h-4 w-4 -translate-y-1/2 text-brand-400" />
            <input
              type="date"
              value={dateFrom}
              onChange={(e) => setDateFrom(e.target.value)}
              className="w-full sm:w-auto rounded-xl border border-brand-100 bg-white/80 py-2.5 pl-10 pr-3 text-sm text-brand-700 focus:border-accent focus:ring-2 focus:ring-accent/20 outline-none"
            />
          </div>
          <span className="text-brand-300 text-sm font-medium shrink-0">s/d</span>
          <div className="relative flex-1 min-w-0 sm:flex-none">
            <input
              type="date"
              value={dateTo}
              onChange={(e) => setDateTo(e.target.value)}
              className="w-full sm:w-auto rounded-xl border border-brand-100 bg-white/80 py-2.5 px-3 text-sm text-brand-700 focus:border-accent focus:ring-2 focus:ring-accent/20 outline-none"
            />
          </div>
        </div>
      </div>

      {/* ── Content ── */}
      {loading ? (
        <div className="flex items-center justify-center py-20">
          <LoadingSpinner size="lg" />
        </div>
      ) : (
        <>
          {/* Summary Tab */}
          {activeTab === 'summary' && data.summary && (
            <div className="space-y-5">
              {/* Summary Cards */}
              <div className="grid grid-cols-2 lg:grid-cols-4 gap-3">
                <SummaryCard label="Total Pendapatan" value={formatCurrency(data.summary.total_revenue)} icon={DollarSign} color="amber" />
                <SummaryCard label="Total Pesanan" value={`${data.summary.order_count} pesanan`} icon={ShoppingCart} color="green" />
                <SummaryCard label="Laba Kotor" value={formatCurrency(data.summary.gross_profit)} icon={TrendingUp} color={data.summary.gross_profit >= 0 ? 'green' : 'red'} />
                <SummaryCard label="Rata-rata Order" value={formatCurrency(data.summary.avg_order_value)} icon={BarChart3} color="blue" />
              </div>

              {/* Detail Cards */}
              <div className="grid grid-cols-2 lg:grid-cols-4 gap-3">
                <MiniCard label="Total Modal" value={formatCurrency(data.summary.total_cost)} />
                <MiniCard label="Total Diskon" value={formatCurrency(data.summary.total_discount)} />
                <MiniCard label="Void" value={`${data.summary.voided_count} pesanan`} danger={data.summary.voided_count > 0} />
                <MiniCard label="Refund" value={`${data.summary.refunded_count} (${formatCurrency(data.summary.refunded_amount)})`} danger={data.summary.refunded_count > 0} />
              </div>

              {/* Daily Trend Chart */}
              {data.trend && data.trend.length > 0 && (
                <div className="rounded-2xl border border-border bg-white p-4 lg:p-6" style={{ boxShadow: 'var(--shadow-card)' }}>
                  <h3 className="text-sm font-semibold text-brand-700 mb-4">Tren Harian</h3>
                  <div className="h-[200px] sm:h-[250px] lg:h-[280px]">
                    <ResponsiveContainer width="100%" height="100%" minWidth={0} minHeight={0}>
                      <AreaChart data={data.trend} margin={{ top: 5, right: 5, left: -20, bottom: 0 }}>
                        <defs>
                          <linearGradient id="colorRev" x1="0" y1="0" x2="0" y2="1">
                            <stop offset="5%" stopColor="#78350F" stopOpacity={0.15} />
                            <stop offset="95%" stopColor="#78350F" stopOpacity={0} />
                          </linearGradient>
                        </defs>
                        <CartesianGrid strokeDasharray="3 3" stroke="#F3E8D0" vertical={false} />
                        <XAxis
                          dataKey="date"
                          tickFormatter={(d) => new Date(d).toLocaleDateString('id-ID', { day: 'numeric', month: 'short' })}
                          tick={{ fontSize: 10, fill: '#92400E' }}
                          tickLine={false}
                          axisLine={{ stroke: '#F3E8D0' }}
                          interval="preserveStartEnd"
                          minTickGap={40}
                        />
                        <YAxis
                          tickFormatter={(v) => v >= 1000000 ? `${(v / 1000000).toFixed(1)}jt` : v >= 1000 ? `${(v / 1000).toFixed(0)}rb` : String(v)}
                          tick={{ fontSize: 10, fill: '#92400E' }}
                          tickLine={false}
                          axisLine={false}
                        />
                        <Tooltip
                          contentStyle={{ borderRadius: '0.75rem', border: '1px solid #F3E8D0', fontSize: '0.75rem' }}
                          labelFormatter={(d) => new Date(d).toLocaleDateString('id-ID', { weekday: 'long', day: 'numeric', month: 'long' })}
                          formatter={(value, name) => [
                            formatCurrency(Number(value)),
                            name === 'revenue' ? 'Pendapatan' : name === 'profit' ? 'Laba' : 'Modal',
                          ]}
                        />
                        <Area type="monotone" dataKey="revenue" stroke="#78350F" strokeWidth={2} fill="url(#colorRev)" dot={false} />
                        <Area type="monotone" dataKey="profit" stroke="#059669" strokeWidth={1.5} fill="none" dot={false} strokeDasharray="4 2" />
                      </AreaChart>
                    </ResponsiveContainer>
                  </div>
                  <div className="flex items-center gap-4 mt-3 justify-center">
                    <span className="flex items-center gap-1.5 text-[11px] text-brand-500"><span className="h-0.5 w-4 bg-brand-700 rounded" /> Pendapatan</span>
                    <span className="flex items-center gap-1.5 text-[11px] text-brand-500"><span className="h-0.5 w-4 bg-emerald-600 rounded border-dashed" style={{ borderTop: '2px dashed #059669', height: 0 }} /> Laba</span>
                  </div>
                </div>
              )}
            </div>
          )}

          {/* Products Tab */}
          {activeTab === 'products' && data.items && (
            <ReportTable
              columns={[
                { key: 'product_name', label: 'Produk', align: 'left' },
                { key: 'total_qty', label: 'Qty', align: 'center', format: 'number' },
                { key: 'total_revenue', label: 'Pendapatan', align: 'right', format: 'currency' },
                { key: 'total_cost', label: 'Modal', align: 'right', format: 'currency' },
                { key: 'profit', label: 'Laba', align: 'right', format: 'currency', colorProfit: true },
                { key: 'order_count', label: 'Order', align: 'center', format: 'number' },
              ]}
              data={data.items}
              emptyMessage="Tidak ada data penjualan produk"
            />
          )}

          {/* Categories Tab */}
          {activeTab === 'categories' && data.items && (
            <ReportTable
              columns={[
                { key: 'category_name', label: 'Kategori', align: 'left' },
                { key: 'total_qty', label: 'Qty', align: 'center', format: 'number' },
                { key: 'total_revenue', label: 'Pendapatan', align: 'right', format: 'currency' },
                { key: 'total_cost', label: 'Modal', align: 'right', format: 'currency' },
                { key: 'profit', label: 'Laba', align: 'right', format: 'currency', colorProfit: true },
                { key: 'order_count', label: 'Order', align: 'center', format: 'number' },
              ]}
              data={data.items}
              emptyMessage="Tidak ada data penjualan kategori"
            />
          )}

          {/* Cashiers Tab */}
          {activeTab === 'cashiers' && data.items && (
            <ReportTable
              columns={[
                { key: 'cashier_name', label: 'Kasir', align: 'left' },
                { key: 'order_count', label: 'Pesanan', align: 'center', format: 'number' },
                { key: 'total_revenue', label: 'Total Penjualan', align: 'right', format: 'currency' },
                { key: 'avg_order_value', label: 'Rata-rata', align: 'right', format: 'currency' },
              ]}
              data={data.items}
              emptyMessage="Tidak ada data penjualan kasir"
            />
          )}

          {/* Hours Tab */}
          {activeTab === 'hours' && data.items && (
            <div className="space-y-4">
              {/* Chart */}
              <div className="rounded-2xl border border-border bg-white p-4 lg:p-6" style={{ boxShadow: 'var(--shadow-card)' }}>
                <h3 className="text-sm font-semibold text-brand-700 mb-4">Distribusi Pesanan per Jam</h3>
                <div className="h-[200px] sm:h-[250px] lg:h-[280px]">
                  <ResponsiveContainer width="100%" height="100%" minWidth={0} minHeight={0}>
                    <BarChart data={data.items.filter((h: ReportData) => h.hour >= 6 && h.hour <= 23)} margin={{ top: 5, right: 5, left: -25, bottom: 0 }}>
                      <CartesianGrid strokeDasharray="3 3" stroke="#F3E8D0" vertical={false} />
                      <XAxis dataKey="label" tick={{ fontSize: 9, fill: '#92400E' }} tickLine={false} axisLine={{ stroke: '#F3E8D0' }} interval={1} />
                      <YAxis tick={{ fontSize: 10, fill: '#92400E' }} tickLine={false} axisLine={false} allowDecimals={false} />
                      <Tooltip
                        contentStyle={{ borderRadius: '0.75rem', border: '1px solid #F3E8D0', fontSize: '0.75rem' }}
                        formatter={(value, name) => [
                          name === 'order_count' ? `${value} pesanan` : formatCurrency(Number(value)),
                          name === 'order_count' ? 'Pesanan' : 'Pendapatan',
                        ]}
                        labelFormatter={(label) => `Jam ${label}`}
                      />
                      <Bar dataKey="order_count" radius={[4, 4, 0, 0]} maxBarSize={24}>
                        {data.items.filter((h: ReportData) => h.hour >= 6 && h.hour <= 23).map((_: ReportData, index: number) => (
                          <Cell key={`cell-${index}`} fill="#78350F" fillOpacity={0.7} />
                        ))}
                      </Bar>
                    </BarChart>
                  </ResponsiveContainer>
                </div>
              </div>

              {/* Table */}
              <ReportTable
                columns={[
                  { key: 'label', label: 'Jam', align: 'left' },
                  { key: 'order_count', label: 'Pesanan', align: 'center', format: 'number' },
                  { key: 'revenue', label: 'Pendapatan', align: 'right', format: 'currency' },
                ]}
                data={data.items.filter((h: ReportData) => h.order_count > 0)}
                emptyMessage="Tidak ada data penjualan per jam"
              />
            </div>
          )}
        </>
      )}
    </div>
  );
}

/* ── Summary Card ── */
function SummaryCard({ label, value, icon: Icon, color }: { label: string; value: string; icon: typeof DollarSign; color: string }) {
  const colorMap: Record<string, { bg: string; icon: string }> = {
    amber: { bg: 'bg-amber-50', icon: 'text-amber-600' },
    green: { bg: 'bg-emerald-50', icon: 'text-emerald-600' },
    blue: { bg: 'bg-sky-50', icon: 'text-sky-600' },
    red: { bg: 'bg-red-50', icon: 'text-red-600' },
  };
  const c = colorMap[color] || colorMap.amber;

  return (
    <div className="rounded-xl border border-border bg-white p-3 sm:p-4" style={{ boxShadow: 'var(--shadow-card)' }}>
      <div className="flex items-center gap-2 mb-1.5 sm:mb-2">
        <div className={cn('flex h-7 w-7 sm:h-8 sm:w-8 items-center justify-center rounded-lg', c.bg)}>
          <Icon className={cn('h-3.5 w-3.5 sm:h-4 sm:w-4', c.icon)} />
        </div>
        <p className="text-[10px] sm:text-[11px] text-brand-400 font-medium truncate">{label}</p>
      </div>
      <p className="text-sm sm:text-lg font-bold text-brand-700 tabular-nums truncate">{value}</p>
    </div>
  );
}

/* ── Mini Card ── */
function MiniCard({ label, value, danger }: { label: string; value: string; danger?: boolean }) {
  return (
    <div className={cn(
      'rounded-xl border p-3',
      danger ? 'border-red-200 bg-red-50/50' : 'border-border bg-white'
    )} style={{ boxShadow: 'var(--shadow-card)' }}>
      <p className="text-[11px] text-brand-400 mb-0.5">{label}</p>
      <p className={cn('text-sm font-bold tabular-nums', danger ? 'text-red-600' : 'text-brand-700')}>{value}</p>
    </div>
  );
}

/* ── Report Table ── */
interface Column {
  key: string;
  label: string;
  align: 'left' | 'center' | 'right';
  format?: 'currency' | 'number';
  colorProfit?: boolean;
}

function ReportTable({ columns, data, emptyMessage }: { columns: Column[]; data: ReportData[]; emptyMessage: string }) {
  if (data.length === 0) {
    return (
      <div className="rounded-2xl border border-border bg-white p-12 text-center" style={{ boxShadow: 'var(--shadow-card)' }}>
        <Package className="h-8 w-8 text-brand-200 mx-auto mb-2" />
        <p className="text-sm text-brand-400">{emptyMessage}</p>
      </div>
    );
  }

  // Calculate totals for numeric columns
  const totals: Record<string, number> = {};
  columns.forEach((col) => {
    if (col.format === 'currency' || col.format === 'number') {
      totals[col.key] = data.reduce((sum, row) => sum + (Number(row[col.key]) || 0), 0);
    }
  });

  // Find the "name" column (first non-numeric column) for mobile card title
  const nameCol = columns.find((c) => !c.format);
  const valueColumns = columns.filter((c) => c.format);

  return (
    <div className="rounded-2xl border border-border bg-white overflow-hidden" style={{ boxShadow: 'var(--shadow-card)' }}>
      {/* ── Mobile: Card View ── */}
      <div className="divide-y divide-brand-50/80 lg:hidden">
        {data.map((row, idx) => {
          const nameVal = nameCol ? String(row[nameCol.key] || '-') : `#${idx + 1}`;
          return (
            <div key={idx} className="p-4 space-y-2">
              {/* Card header: rank + name */}
              <div className="flex items-center gap-2">
                <span className="flex h-6 min-w-6 items-center justify-center rounded-md bg-brand-50 text-[11px] font-bold text-brand-500">
                  {idx + 1}
                </span>
                <span className="text-sm font-semibold text-brand-700 truncate">{nameVal}</span>
              </div>
              {/* Card body: value pairs in 2-col grid */}
              <div className="grid grid-cols-2 gap-x-4 gap-y-1.5 pl-8">
                {valueColumns.map((col) => {
                  const val = row[col.key];
                  let display: string;
                  let colorClass = 'text-brand-700';

                  if (col.format === 'currency') {
                    display = formatCurrency(Number(val) || 0);
                    if (col.colorProfit) {
                      colorClass = Number(val) >= 0 ? 'text-emerald-600' : 'text-red-500';
                    }
                  } else {
                    display = Number(val).toLocaleString('id-ID');
                  }

                  return (
                    <div key={col.key} className="flex flex-col">
                      <span className="text-[10px] uppercase tracking-wider text-brand-400 font-medium">{col.label}</span>
                      <span className={cn('text-xs font-semibold tabular-nums', colorClass)}>{display}</span>
                    </div>
                  );
                })}
              </div>
            </div>
          );
        })}
        {/* Mobile totals */}
        <div className="p-4 bg-brand-50/50 border-t-2 border-brand-200">
          <div className="flex items-center gap-2 mb-2">
            <span className="flex h-6 min-w-6 items-center justify-center rounded-md bg-brand-200/60 text-[11px] font-bold text-brand-600">
              &Sigma;
            </span>
            <span className="text-sm font-bold text-brand-700">Total</span>
          </div>
          <div className="grid grid-cols-2 gap-x-4 gap-y-1.5 pl-8">
            {valueColumns.map((col) => {
              if (totals[col.key] === undefined) return null;
              const val = totals[col.key];
              const display = col.format === 'currency' ? formatCurrency(val) : val.toLocaleString('id-ID');
              return (
                <div key={col.key} className="flex flex-col">
                  <span className="text-[10px] uppercase tracking-wider text-brand-400 font-medium">{col.label}</span>
                  <span className={cn('text-xs font-bold tabular-nums', col.colorProfit ? (val >= 0 ? 'text-emerald-600' : 'text-red-500') : 'text-brand-700')}>
                    {display}
                  </span>
                </div>
              );
            })}
          </div>
        </div>
      </div>

      {/* ── Desktop: Table View ── */}
      <div className="hidden lg:block overflow-x-auto">
        <table className="w-full text-sm">
          <thead>
            <tr className="border-b border-border bg-surface/60">
              <th className="px-4 py-3 text-left text-[11px] font-semibold uppercase tracking-wider text-brand-500 w-10">#</th>
              {columns.map((col) => (
                <th
                  key={col.key}
                  className={cn(
                    'px-4 py-3 text-[11px] font-semibold uppercase tracking-wider text-brand-500',
                    col.align === 'right' && 'text-right',
                    col.align === 'center' && 'text-center',
                    col.align === 'left' && 'text-left',
                  )}
                >
                  {col.label}
                </th>
              ))}
            </tr>
          </thead>
          <tbody className="divide-y divide-brand-50/80">
            {data.map((row, idx) => (
              <tr key={idx} className="transition-colors hover:bg-surface/30">
                <td className="px-4 py-3 text-xs text-brand-400">{idx + 1}</td>
                {columns.map((col) => {
                  const val = row[col.key];
                  let display: string;
                  let colorClass = 'text-brand-700';

                  if (col.format === 'currency') {
                    display = formatCurrency(Number(val) || 0);
                    if (col.colorProfit) {
                      colorClass = Number(val) >= 0 ? 'text-emerald-600' : 'text-red-500';
                    }
                  } else if (col.format === 'number') {
                    display = Number(val).toLocaleString('id-ID');
                  } else {
                    display = String(val || '-');
                  }

                  return (
                    <td
                      key={col.key}
                      className={cn(
                        'px-4 py-3 tabular-nums',
                        col.align === 'right' && 'text-right',
                        col.align === 'center' && 'text-center',
                        col.format === 'currency' ? 'font-semibold' : '',
                        colorClass,
                      )}
                    >
                      {display}
                    </td>
                  );
                })}
              </tr>
            ))}
          </tbody>
          {/* Totals row */}
          <tfoot>
            <tr className="border-t-2 border-brand-200 bg-brand-50/50">
              <td className="px-4 py-3 text-xs font-bold text-brand-700">Total</td>
              {columns.map((col) => {
                if (totals[col.key] !== undefined) {
                  const val = totals[col.key];
                  const display = col.format === 'currency' ? formatCurrency(val) : val.toLocaleString('id-ID');
                  return (
                    <td
                      key={col.key}
                      className={cn(
                        'px-4 py-3 font-bold tabular-nums text-brand-700',
                        col.align === 'right' && 'text-right',
                        col.align === 'center' && 'text-center',
                        col.colorProfit && (val >= 0 ? 'text-emerald-600' : 'text-red-500'),
                      )}
                    >
                      {display}
                    </td>
                  );
                }
                return <td key={col.key} className="px-4 py-3" />;
              })}
            </tr>
          </tfoot>
        </table>
      </div>
    </div>
  );
}
