@extends('layouts.app')
@section('title', __('Billing'))

@section('content')
@php
    use Illuminate\Support\Carbon;
    use App\Models\FileAnalysis;
    use App\Models\TenantMonthlyInvoice;

    $tenantId = $tenant?->id ?? 0;

    // --- Period filter ---------------------------------------------------
    $monthParam = request('month');
    try {
        $period = $monthParam
            ? Carbon::createFromFormat('Y-m', $monthParam)->startOfMonth()
            : Carbon::now()->startOfMonth();
    } catch (\Throwable $e) {
        $period = Carbon::now()->startOfMonth();
    }
    $periodStart = $period->copy()->startOfMonth();
    $periodEnd   = $period->copy()->endOfMonth();

    // --- Approved analyses for this period (admin-reviewed, sent to client)
    $hasBillable = \Illuminate\Support\Facades\Schema::hasColumn('file_analyses', 'billable_amount');
    $hasReviewed = \Illuminate\Support\Facades\Schema::hasColumn('file_analyses', 'reviewed_at');
    $approvedCol = $hasReviewed ? 'reviewed_at' : 'finished_at';

    $analyses = FileAnalysis::query()
        ->with(['submission.uploader', 'reviewer'])
        ->where('tenant_id', $tenantId)
        ->where('status', FileAnalysis::STATUS_DONE)
        ->whereBetween($approvedCol, [$periodStart, $periodEnd])
        ->orderByDesc($approvedCol)
        ->paginate(25)
        ->withQueryString();

    // --- Period stats ----------------------------------------------------
    $totalApproved = FileAnalysis::query()
        ->where('tenant_id', $tenantId)
        ->where('status', FileAnalysis::STATUS_DONE)
        ->whereBetween($approvedCol, [$periodStart, $periodEnd])
        ->count();

    $billable = $hasBillable
        ? (float) FileAnalysis::query()
            ->where('tenant_id', $tenantId)
            ->where('status', FileAnalysis::STATUS_DONE)
            ->whereBetween($approvedCol, [$periodStart, $periodEnd])
            ->sum('billable_amount')
        : 0.0;

    $billedCount = $hasBillable
        ? FileAnalysis::query()
            ->where('tenant_id', $tenantId)
            ->where('status', FileAnalysis::STATUS_DONE)
            ->whereBetween($approvedCol, [$periodStart, $periodEnd])
            ->whereNotNull('billed_invoice_id')
            ->count()
        : 0;

    $unbilledCount = max(0, $totalApproved - $billedCount);

    $freeAllowance = \Illuminate\Support\Facades\Schema::hasColumn('tenants', 'free_analyses_per_month')
        ? (int) ($tenant?->free_analyses_per_month
            ?? config('subscriptions.usage.free_analyses_per_month', 0))
        : (int) config('subscriptions.usage.free_analyses_per_month', 0);
    $freeRemaining = max(0, $freeAllowance - $totalApproved);

    // --- Month picker options --------------------------------------------
    $monthOptions = [];
    $cursor = Carbon::now()->startOfMonth();
    for ($i = 0; $i < 12; $i++) {
        $monthOptions[$cursor->format('Y-m')] = $cursor->translatedFormat('F Y');
        $cursor->subMonthNoOverflow();
    }

    // --- Invoice for this period (if any) --------------------------------
    $invoice = TenantMonthlyInvoice::query()
        ->where('tenant_id', $tenantId)
        ->whereDate('period_start', $periodStart->toDateString())
        ->first();
@endphp

{{-- Header --}}
<div class="rounded-2xl border border-slate-200 dark:border-slate-700 bg-white dark:bg-slate-900 shadow-sm p-5 sm:p-6 mb-4 flex flex-col sm:flex-row sm:items-center sm:justify-between gap-4">
    <div class="min-w-0">
        <div class="inline-flex items-center gap-1.5 px-2 py-0.5 rounded-full bg-emerald-50 dark:bg-emerald-900/30 text-emerald-700 dark:text-emerald-300 text-[10px] uppercase tracking-wider font-semibold ring-1 ring-emerald-200/60 dark:ring-emerald-800/60 mb-2">
            <svg class="w-3 h-3" fill="none" stroke="currentColor" stroke-width="2.5" viewBox="0 0 24 24"><path stroke-linecap="round" stroke-linejoin="round" d="M5 13l4 4L19 7"/></svg>
            {{ __('Pay-per-analysis') }}
        </div>
        <h1 class="text-xl sm:text-2xl font-semibold text-slate-900 dark:text-white">{{ __('Billing') }}</h1>
        <p class="text-xs sm:text-sm text-slate-500 dark:text-slate-400 mt-1 max-w-2xl">
            {{ __('Every approved analysis adds a line to the monthly invoice.') }}
        </p>
    </div>

    <form method="GET" class="flex items-center gap-2 shrink-0">
        <label for="billing-month" class="text-[11px] uppercase tracking-wider text-slate-500 dark:text-slate-400 font-semibold whitespace-nowrap">{{ __('Period') }}</label>
        <select id="billing-month" name="month" onchange="this.form.submit()"
                class="rounded-lg border border-slate-300 dark:border-slate-700 bg-white dark:bg-slate-950 text-slate-900 dark:text-slate-100 text-sm font-medium px-3 py-1.5 focus:ring-2 focus:ring-indigo-500 focus:border-indigo-500 cursor-pointer">
            @foreach($monthOptions as $value => $label)
                <option value="{{ $value }}" @selected($value === $period->format('Y-m'))>{{ $label }}</option>
            @endforeach
        </select>
    </form>
</div>

{{-- KPI cards --}}
<div class="grid grid-cols-2 lg:grid-cols-4 gap-3 mb-4">
    <div class="rounded-2xl border border-slate-200 dark:border-slate-700 bg-white dark:bg-slate-900 p-4 shadow-sm">
        <div class="text-[11px] uppercase tracking-wider text-slate-500 dark:text-slate-400 font-semibold truncate">{{ __('Approved') }}</div>
        <div class="text-2xl font-bold text-slate-900 dark:text-white mt-1 tabular-nums">{{ $totalApproved }}</div>
        @if($freeAllowance > 0)
            <div class="text-[11px] text-slate-500 dark:text-slate-400 mt-1 truncate">
                {{ __(':n free remaining', ['n' => $freeRemaining]) }} / {{ $freeAllowance }}
            </div>
        @endif
    </div>

    <div class="rounded-2xl border border-slate-200 dark:border-slate-700 bg-white dark:bg-slate-900 p-4 shadow-sm">
        <div class="text-[11px] uppercase tracking-wider text-emerald-600 dark:text-emerald-400 font-semibold truncate">{{ __('Billed') }}</div>
        <div class="text-2xl font-bold text-emerald-700 dark:text-emerald-300 mt-1 tabular-nums">{{ $billedCount }}</div>
        <div class="text-[11px] text-slate-500 dark:text-slate-400 mt-1 truncate">{{ __('On an invoice') }}</div>
    </div>

    <div class="rounded-2xl border border-slate-200 dark:border-slate-700 bg-white dark:bg-slate-900 p-4 shadow-sm">
        <div class="text-[11px] uppercase tracking-wider text-amber-600 dark:text-amber-400 font-semibold truncate">{{ __('Pending') }}</div>
        <div class="text-2xl font-bold text-amber-700 dark:text-amber-300 mt-1 tabular-nums">{{ $unbilledCount }}</div>
        <div class="text-[11px] text-slate-500 dark:text-slate-400 mt-1 truncate">{{ __('To be invoiced') }}</div>
    </div>

    <div class="rounded-2xl border border-slate-200 dark:border-slate-700 bg-white dark:bg-slate-900 p-4 shadow-sm">
        <div class="text-[11px] uppercase tracking-wider text-indigo-600 dark:text-indigo-400 font-semibold truncate">{{ __('Estimated') }}</div>
        <div class="text-2xl font-bold text-indigo-700 dark:text-indigo-300 mt-1 tabular-nums whitespace-nowrap">{{ number_format($billable, 2, ',', ' ') }} €</div>
        <div class="text-[11px] text-slate-500 dark:text-slate-400 mt-1 truncate">{{ __('Excl. VAT') }}</div>
    </div>
</div>

{{-- Invoice banner --}}
@if($invoice)
    <div class="mb-4 rounded-2xl border border-slate-200 dark:border-slate-700 bg-white dark:bg-slate-900 p-4 shadow-sm flex flex-wrap items-center gap-3">
        <div class="w-9 h-9 rounded-lg bg-indigo-50 dark:bg-indigo-900/30 text-indigo-600 dark:text-indigo-300 flex items-center justify-center shrink-0">
            <svg class="w-4 h-4" fill="none" stroke="currentColor" stroke-width="2" viewBox="0 0 24 24"><path stroke-linecap="round" stroke-linejoin="round" d="M9 12h6m-6 4h6M5 7h14M5 7l1 13a2 2 0 002 2h8a2 2 0 002-2l1-13M5 7V5a2 2 0 012-2h10a2 2 0 012 2v2"/></svg>
        </div>
        <div class="flex-1 min-w-0">
            <div class="text-[11px] uppercase tracking-wider text-slate-500 dark:text-slate-400 font-semibold">{{ __('Invoice for this period') }}</div>
            <div class="font-mono text-sm font-semibold text-slate-900 dark:text-slate-100 truncate">{{ $invoice->number }}</div>
        </div>
        <div class="text-end shrink-0">
            <div class="font-mono text-sm font-semibold text-slate-900 dark:text-slate-100 whitespace-nowrap">
                {{ number_format((float) $invoice->total, 2, ',', ' ') }} {{ $invoice->currency }}
            </div>
            <span @class([
                'inline-block mt-1 px-1.5 py-0.5 rounded text-[10px] uppercase tracking-wider font-semibold',
                'bg-emerald-50 text-emerald-700 dark:bg-emerald-900/40 dark:text-emerald-300' => $invoice->status === 'paid',
                'bg-amber-50 text-amber-700 dark:bg-amber-900/40 dark:text-amber-300'         => $invoice->status === 'issued',
                'bg-slate-100 text-slate-600 dark:bg-slate-800 dark:text-slate-300'            => $invoice->status === 'draft',
                'bg-rose-50 text-rose-700 dark:bg-rose-900/40 dark:text-rose-300'              => $invoice->status === 'void',
            ])>{{ ucfirst($invoice->status) }}</span>
        </div>
    </div>
@endif

{{-- Approved analyses list --}}
<div class="rounded-2xl border border-slate-200 dark:border-slate-700 bg-white dark:bg-slate-900 shadow-sm overflow-hidden">
    <div class="flex items-center gap-3 px-4 sm:px-5 py-4 border-b border-slate-200 dark:border-slate-800">
        <div class="w-9 h-9 rounded-lg bg-emerald-50 dark:bg-emerald-900/30 text-emerald-600 dark:text-emerald-300 flex items-center justify-center shrink-0">
            <svg class="w-5 h-5" fill="none" stroke="currentColor" stroke-width="2" viewBox="0 0 24 24"><path stroke-linecap="round" stroke-linejoin="round" d="M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4"/></svg>
        </div>
        <div class="min-w-0 flex-1">
            <h2 class="font-semibold text-slate-900 dark:text-slate-100 truncate">{{ __('Approved analyses') }}</h2>
            <p class="text-xs text-slate-500 dark:text-slate-400 mt-0.5 truncate">{{ $period->translatedFormat('F Y') }} — {{ __('reviewed and sent to clients.') }}</p>
        </div>
    </div>

    @if($analyses->isEmpty())
        <div class="p-10 text-center">
            <div class="w-12 h-12 mx-auto rounded-full bg-slate-100 dark:bg-slate-800 flex items-center justify-center mb-3">
                <svg class="w-6 h-6 text-slate-400 dark:text-slate-500" fill="none" stroke="currentColor" stroke-width="1.5" viewBox="0 0 24 24"><path stroke-linecap="round" stroke-linejoin="round" d="M9 12h6m-6 4h6M5 7h14M5 7v13a2 2 0 002 2h10a2 2 0 002-2V7"/></svg>
            </div>
            <p class="text-sm text-slate-500 dark:text-slate-400">{{ __('No approved analyses in this period.') }}</p>
        </div>
    @else
        <div class="overflow-x-auto">
            <table class="w-full text-sm">
                <thead class="bg-slate-50 dark:bg-slate-800/60 text-[11px] uppercase tracking-wider text-slate-500 dark:text-slate-400 font-semibold">
                    <tr>
                        <th class="text-start px-4 py-3">{{ __('File') }}</th>
                        <th class="text-start px-4 py-3 hidden md:table-cell">{{ __('Type') }}</th>
                        <th class="text-start px-4 py-3 hidden lg:table-cell">{{ __('Reviewed by') }}</th>
                        <th class="text-start px-4 py-3 whitespace-nowrap">{{ __('Approved at') }}</th>
                        <th class="text-end px-4 py-3">{{ __('Amount') }}</th>
                        <th class="text-start px-4 py-3">{{ __('Status') }}</th>
                        <th class="text-end px-4 py-3"></th>
                    </tr>
                </thead>
                <tbody class="divide-y divide-slate-100 dark:divide-slate-800">
                    @foreach($analyses as $a)
                        @php
                            $approvedAt = $a->reviewed_at ?? $a->finished_at;
                            $billed     = $hasBillable && ! is_null($a->billed_invoice_id);
                            $amount     = $hasBillable ? (float) $a->billable_amount : null;
                            $currency   = $a->billable_currency ?? 'EUR';
                        @endphp
                        <tr class="hover:bg-slate-50 dark:hover:bg-slate-800/40 transition-colors">
                            <td class="px-4 py-3 align-top">
                                <div class="font-medium text-slate-900 dark:text-slate-100 truncate max-w-[280px]" title="{{ $a->submission?->original_name }}">
                                    {{ $a->submission?->original_name ?? '—' }}
                                </div>
                                <div class="text-[11px] text-slate-500 dark:text-slate-400 mt-0.5 truncate">
                                    {{ optional($a->submission?->uploader)->name ?? '—' }}
                                </div>
                            </td>
                            <td class="px-4 py-3 hidden md:table-cell align-top">
                                <span class="inline-block px-2 py-0.5 rounded-full text-[11px] font-medium bg-violet-50 text-violet-700 dark:bg-violet-900/30 dark:text-violet-300 whitespace-nowrap">
                                    {{ $a->typeLabel() }}
                                </span>
                            </td>
                            <td class="px-4 py-3 hidden lg:table-cell text-slate-600 dark:text-slate-300 align-top truncate max-w-[160px]">
                                {{ optional($a->reviewer)->name ?? '—' }}
                            </td>
                            <td class="px-4 py-3 text-slate-600 dark:text-slate-300 align-top whitespace-nowrap tabular-nums">
                                {{ $approvedAt?->format('Y-m-d H:i') ?? '—' }}
                            </td>
                            <td class="px-4 py-3 text-end font-mono tabular-nums text-slate-900 dark:text-slate-100 align-top whitespace-nowrap">
                                @if(! is_null($amount))
                                    {{ number_format($amount, 2, ',', ' ') }} <span class="text-slate-500 dark:text-slate-400 text-xs">{{ $currency }}</span>
                                @else
                                    <span class="text-slate-400">—</span>
                                @endif
                            </td>
                            <td class="px-4 py-3 align-top">
                                @if($billed)
                                    <span class="inline-flex items-center gap-1 px-2 py-0.5 rounded-full text-[11px] font-semibold bg-emerald-50 text-emerald-700 dark:bg-emerald-900/30 dark:text-emerald-300 ring-1 ring-emerald-200/60 dark:ring-emerald-800/60 whitespace-nowrap">
                                        <svg class="w-3 h-3" fill="none" stroke="currentColor" stroke-width="2.5" viewBox="0 0 24 24"><path stroke-linecap="round" stroke-linejoin="round" d="M5 13l4 4L19 7"/></svg>
                                        {{ __('Billed') }}
                                    </span>
                                @else
                                    <span class="inline-flex items-center gap-1 px-2 py-0.5 rounded-full text-[11px] font-semibold bg-amber-50 text-amber-700 dark:bg-amber-900/30 dark:text-amber-300 ring-1 ring-amber-200/60 dark:ring-amber-800/60 whitespace-nowrap">
                                        <svg class="w-3 h-3" fill="none" stroke="currentColor" stroke-width="2.5" viewBox="0 0 24 24"><path stroke-linecap="round" stroke-linejoin="round" d="M12 8v4l3 3m6-3a9 9 0 11-18 0 9 9 0 0118 0z"/></svg>
                                        {{ __('Pending') }}
                                    </span>
                                @endif
                            </td>
                            <td class="px-4 py-3 text-end align-top whitespace-nowrap">
                                @if($a->submission)
                                    <a href="{{ route('tenant.submissions.show', $a->submission) }}"
                                       class="text-xs font-medium text-indigo-600 hover:text-indigo-700 dark:text-indigo-400 dark:hover:text-indigo-300">
                                        {{ __('View') }} →
                                    </a>
                                @endif
                            </td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        </div>

        <div class="px-4 sm:px-5 py-4 border-t border-slate-200 dark:border-slate-800">
            {{ $analyses->links() }}
        </div>
    @endif
</div>

<p class="mt-4 text-[11px] text-slate-500 dark:text-slate-400 flex items-start gap-1.5 px-3 py-2 rounded-lg bg-slate-50 dark:bg-slate-800 border border-slate-200 dark:border-slate-700">
    <svg class="w-3.5 h-3.5 mt-0.5 text-slate-400 dark:text-slate-500 flex-shrink-0" fill="none" stroke="currentColor" stroke-width="2" viewBox="0 0 24 24"><path stroke-linecap="round" stroke-linejoin="round" d="M13 16h-1v-4h-1m1-4h.01M21 12a9 9 0 11-18 0 9 9 0 0118 0z"/></svg>
    {{ __('Only approved analyses sent to clients are billable. Failed runs and re-runs are excluded.') }}
</p>
@endsection