@extends('layouts.app')

@section('title', 'Fees / Invoicing')

@section('content')
    @php
        $tabs = ['Voteheads', 'Govt Allocation', 'Set Fees & Invoice', 'Recurring', 'Invoice per Student', 'Fees Adjustment', 'Close Term'];
        $active = request()->input('tab', 'Voteheads');
    @endphp
    <div class="flex flex-col gap-6">
        <div>
            <h1 class="text-lg font-semibold">Fees / Invoicing</h1>
            <p class="text-xs text-muted-foreground">Configure voteheads, fee structures and student invoices</p>
        </div>

        <div class="flex flex-wrap gap-1 rounded-xl border border-border bg-card p-1">
            @foreach ($tabs as $tab)
                <a href="?tab={{ urlencode($tab) }}" class="rounded-lg px-3 py-1.5 text-sm transition-colors {{ $active === $tab ? 'bg-primary text-primary-foreground' : 'text-muted-foreground hover:bg-accent' }}">{{ $tab }}</a>
            @endforeach
        </div>

        {{-- Voteheads --}}
        <section class="rounded-xl border border-border bg-card p-4 {{ $active !== 'Voteheads' ? 'hidden' : '' }}">
            <div class="flex items-center justify-between">
                <h2 class="text-sm font-semibold">Tuition Voteheads</h2>
                <form method="post" action="{{ route('finance.voteheads.store') }}" class="flex gap-2">
                    @csrf
                    <input name="name" required placeholder="New votehead name" class="h-8 rounded-lg border border-input bg-transparent px-3 text-sm outline-none focus-visible:border-ring">
                    <button class="rounded-lg bg-primary px-3 py-1 text-sm text-primary-foreground">Add</button>
                </form>
            </div>
            <table class="mt-3 w-full text-sm">
                <thead>
                    <tr class="border-b text-xs uppercase text-muted-foreground">
                        <th class="px-3 py-2 text-left font-medium">#</th>
                        <th class="px-3 py-2 text-left font-medium">Votehead</th>
                        <th class="px-3 py-2 text-left font-medium">Priority</th>
                        <th class="px-3 py-2 text-left font-medium">Type</th>
                        <th class="px-3 py-2 text-right font-medium">Default Amount</th>
                        <th class="px-3 py-2 text-right font-medium"></th>
                    </tr>
                </thead>
                <tbody>
                    @foreach ($voteheads as $v)
                        <tr class="border-b">
                            <td class="px-3 py-2">{{ $v->id }}</td>
                            <td class="px-3 py-2 font-medium">{{ $v->name }}</td>
                            <td class="px-3 py-2">{{ $v->priority }}</td>
                            <td class="px-3 py-2">{{ $v->is_system ? 'System' : $v->category }}</td>
                            <td class="px-3 py-2 text-right tabular-nums">
                                @php $defaults = ['vh-2' => 15000, 'vh-3' => 12000, 'vh-4' => 3000, 'vh-5' => 2000, 'vh-6' => 1500, 'vh-7' => 2500, 'vh-8' => 3500, 'vh-9' => 2500]; @endphp
                                {{ isset($defaults['vh-'.$v->id]) ? 'KES '.number_format($defaults['vh-'.$v->id]) : '—' }}
                            </td>
                            <td class="px-3 py-2 text-right">
                                @unless ($v->is_system)
                                    <form method="post" action="{{ route('finance.voteheads.destroy', $v->id) }}">
                                        @csrf @method('DELETE')
                                        <button class="text-xs text-destructive hover:underline">Delete</button>
                                    </form>
                                @endunless
                            </td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        </section>

        {{-- Govt Allocation --}}
        <section class="rounded-xl border border-border bg-card p-4 {{ $active !== 'Govt Allocation' ? 'hidden' : '' }}">
            <h2 class="text-sm font-semibold">Government Allocation Voteheads</h2>
            <p class="text-xs text-muted-foreground">Layout the govt voteheads used when receiving institutional allocations. Save allocations on the Gov Allocations page.</p>
            <table class="mt-3 w-full text-sm">
                <thead>
                    <tr class="border-b text-xs uppercase text-muted-foreground">
                        <th class="px-3 py-2 text-left font-medium">#</th>
                        <th class="px-3 py-2 text-left font-medium">Votehead</th>
                        <th class="px-3 py-2 text-left font-medium">Priority</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach ($govtVoteheads as $v)
                        <tr class="border-b">
                            <td class="px-3 py-2">{{ $v->id }}</td>
                            <td class="px-3 py-2 font-medium">{{ $v->name }}</td>
                            <td class="px-3 py-2">{{ $v->priority }}</td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        </section>

        {{-- Set Fees & Invoice --}}
        <section class="rounded-xl border border-border bg-card p-4 {{ $active !== 'Set Fees & Invoice' ? 'hidden' : '' }}">
            @if (\App\Models\Student::FORMS)
                @php
                    $seedRows = \Illuminate\Support\Facades\DB::table('fee_structures')
                        ->where('year', '2026')->where('term', request('term', 'Term 1'))
                        ->where('class_name', request('class', \App\Models\Student::FORMS[0]))->first();
                    $items = $seedRows ? \Illuminate\Support\Facades\DB::table('fee_structure_items')
                        ->join('finance_voteheads', 'finance_voteheads.id', '=', 'fee_structure_items.votehead_id')
                        ->where('fee_structure_items.fee_structure_id', $seedRows->id)
                        ->select('fee_structure_items.id', 'finance_voteheads.name', 'fee_structure_items.amount')
                        ->orderBy('finance_voteheads.priority')->get() : collect();
                @endphp
                <h2 class="text-sm font-semibold">Set Fees & Generate Invoices</h2>
                <form method="get" class="mt-3 flex flex-wrap items-center gap-3 text-sm">
                    <label class="flex items-center gap-2 text-muted-foreground">Class
                        <select name="class" onchange="this.form.submit()" class="h-9 rounded-lg border border-input bg-transparent px-3">
                            @foreach (\App\Models\Student::FORMS as $f)
                                <option value="{{ $f }}" @selected(request('class', \App\Models\Student::FORMS[0]) === $f)>{{ $f }}</option>
                            @endforeach
                        </select>
                    </label>
                    <label class="flex items-center gap-2 text-muted-foreground">Term
                        <select name="term" onchange="this.form.submit()" class="h-9 rounded-lg border border-input bg-transparent px-3">
                            @foreach (['Term 1', 'Term 2', 'Term 3'] as $t)
                                <option value="{{ $t }}" @selected(request('term', 'Term 1') === $t)>{{ $t }}</option>
                            @endforeach
                        </select>
                    </label>
                    <span class="text-xs text-muted-foreground">{{ $studentInvoices }} invoices on file · {{ \App\Models\Student::FORMS[0] }} selected</span>
                </form>

                <form method="post" action="{{ route('finance.fee-structure.save') }}" class="mt-4">
                    @csrf
                    <input type="hidden" name="class" value="{{ request('class', \App\Models\Student::FORMS[0]) }}">
                    <input type="hidden" name="term" value="{{ request('term', 'Term 1') }}">
                    <input type="hidden" name="year" value="2026">
                    <table class="w-full text-sm">
                        <thead>
                            <tr class="border-b text-xs uppercase text-muted-foreground">
                                <th class="px-3 py-2 text-left font-medium">Votehead</th>
                                <th class="px-3 py-2 text-left font-medium">Amount</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($items as $it)
                                <tr class="border-b">
                                    <td class="px-3 py-2">{{ $it->name }}</td>
                                    <td class="px-3 py-2">
                                        <input type="number" name="amounts[{{ $it->id }}]" value="{{ $it->amount }}" min="0" class="h-8 w-32 rounded-lg border border-input bg-transparent px-3 text-sm tabular-nums outline-none focus-visible:border-ring">
                                    </td>
                                </tr>
                            @endforeach
                            <tr class="font-semibold">
                                <td class="px-3 py-2">Total per student</td>
                                <td class="px-3 py-2 tabular-nums">KES {{ number_format($items->sum('amount')) }}</td>
                            </tr>
                        </tbody>
                    </table>
                    <div class="mt-4 flex flex-wrap gap-2">
                        <button class="rounded-lg bg-primary px-3 py-2 text-sm font-medium text-primary-foreground hover:bg-primary/90">Save Fee Structure</button>
                        <button formaction="{{ route('finance.fees.generate') }}" formmethod="post" formnovalidate class="rounded-lg border border-border px-3 py-2 text-sm hover:bg-accent">Generate Invoices for Class</button>
                    </div>
                </form>
            @endif
        </section>

        {{-- Recurring --}}
        <section class="rounded-xl border border-border bg-card p-4 {{ $active !== 'Recurring' ? 'hidden' : '' }}">
            <h2 class="text-sm font-semibold">Recurring Fees Wizard</h2>
            <p class="text-xs text-muted-foreground">Copy a class fee structure across to another class or term.</p>
            <form method="post" action="{{ route('finance.fees.generate') }}" class="mt-3 max-w-md" onsubmit="return confirm('Generate invoices for the destination class using the source structure?')">
                @csrf
                <input type="hidden" name="year" value="2026">
                <label class="text-sm text-muted-foreground">Source structure
                    <select name="class" required class="mt-1 h-9 w-full rounded-lg border border-input bg-transparent px-3 text-sm">
                        @foreach (\App\Models\Student::FORMS as $f)
                            <option value="{{ $f }}">{{ $f }}</option>
                        @endforeach
                    </select>
                </label>
                <label class="mt-3 block text-sm text-muted-foreground">Destination term
                    <select name="term" class="mt-1 h-9 w-full rounded-lg border border-input bg-transparent px-3 text-sm">
                        @foreach (['Term 1', 'Term 2', 'Term 3'] as $t)
                            <option value="{{ $t }}">{{ $t }}</option>
                        @endforeach
                    </select>
                </label>
                <button class="mt-4 rounded-lg bg-primary px-3 py-2 text-sm font-medium text-primary-foreground hover:bg-primary/90">Carry Forward & Invoice</button>
            </form>
        </section>

        {{-- Invoice per Student --}}
        <section class="rounded-xl border border-border bg-card p-4 {{ $active !== 'Invoice per Student' ? 'hidden' : '' }}">
            <h2 class="text-sm font-semibold">Student Invoice</h2>
            <form method="get" class="mt-3 flex gap-2">
                <input type="hidden" name="tab" value="Invoice per Student">
                <input name="admission" value="{{ request('admission') }}" placeholder="Search admission no or name..." class="h-9 flex-1 rounded-lg border border-input bg-transparent px-3 text-sm outline-none focus-visible:border-ring">
                <button class="rounded-lg bg-primary px-3 py-2 text-sm text-primary-foreground">Load</button>
            </form>

            @if ($student)
                <div class="mt-4 rounded-lg border border-border p-3 text-sm">
                    <p class="font-semibold">{{ $student->full_name }} <span class="text-xs text-muted-foreground">· {{ $student->admission_no }} · {{ $student->class_name }} {{ $student->stream }}</span></p>
                    @if ($invoice)
                        <p class="text-xs text-muted-foreground">{{ $invoice->term }} {{ $invoice->year }} · Status: <span class="font-medium">{{ $invoice->status }}</span> · Balance: <strong class="tabular-nums">KES {{ number_format($invoice->total_balance, 2) }}</strong></p>
                        <form method="post" action="{{ route('finance.fees.adjust') }}" class="mt-3">
                            @csrf
                            <input type="hidden" name="invoice_id" value="{{ $invoice->id }}">
                            <table class="w-full text-sm">
                                <thead>
                                    <tr class="border-b text-xs uppercase text-muted-foreground">
                                        <th class="px-3 py-2 text-left font-medium">Votehead</th>
                                        <th class="px-3 py-2 text-right font-medium">Amount</th>
                                        <th class="px-3 py-2 text-right font-medium">Paid</th>
                                        <th class="px-3 py-2 text-right font-medium">Balance</th>
                                        <th class="px-3 py-2 text-right font-medium">Adjust</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach ($items as $it)
                                        <tr class="border-b">
                                            <td class="px-3 py-2">{{ $it->votehead_name }}</td>
                                            <td class="px-3 py-2 text-right tabular-nums">{{ number_format($it->amount, 2) }}</td>
                                            <td class="px-3 py-2 text-right tabular-nums">{{ number_format($it->paid, 2) }}</td>
                                            <td class="px-3 py-2 text-right tabular-nums">{{ number_format($it->balance, 2) }}</td>
                                            <td class="px-3 py-2 text-right">
                                                <input type="number" name="adjustments[{{ $it->id }}]" placeholder="± amount" class="h-8 w-24 rounded-lg border border-input bg-transparent px-2 text-right text-sm outline-none focus-visible:border-ring">
                                            </td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                            <button class="mt-3 rounded-lg bg-primary px-3 py-2 text-sm text-primary-foreground">Apply Adjustment</button>
                        </form>
                    @else
                        <p class="mt-2 text-xs text-muted-foreground">No invoice found for this student yet.</p>
                    @endif
                </div>
            @endif
        </section>

        {{-- Fees Adjustment --}}
        <section class="rounded-xl border border-border bg-card p-4 {{ $active !== 'Fees Adjustment' ? 'hidden' : '' }}">
            <h2 class="text-sm font-semibold">Class Negotiated Fees</h2>
            <p class="text-xs text-muted-foreground">Per-student negotiated adjustments, e.g. siblings or performance discounts.</p>
            <form method="get" class="mt-3 flex gap-2">
                <input type="hidden" name="tab" value="Fees Adjustment">
                <input name="admission" value="{{ request('admission') }}" placeholder="Admission no..." class="h-9 flex-1 max-w-sm rounded-lg border border-input bg-transparent px-3 text-sm outline-none focus-visible:border-ring">
                <button class="rounded-lg bg-primary px-3 py-2 text-sm text-primary-foreground">Load student</button>
            </form>
            @if ($student && $invoice)
                <p class="mt-3 text-sm">Applying adjustment to <strong>{{ $student->full_name }}</strong> ({{ $invoice->term }} {{ $invoice->year }}). Use the Invoice per Student tab above.</p>
            @else
                <p class="mt-3 text-xs text-muted-foreground">Load a student above, then adjust their line items in the Invoice per Student grid.</p>
            @endif
        </section>

        {{-- Close Term --}}
        <section class="rounded-xl border border-border bg-card p-4 {{ $active !== 'Close Term' ? 'hidden' : '' }}">
            @php $closeStats = \Illuminate\Support\Facades\DB::table('invoices')->groupBy('class_name')->selectRaw('class_name, COUNT(*) cnt, SUM(total_balance) balance')->orderBy('class_name')->get(); @endphp
            <h2 class="text-sm font-semibold">Close Term</h2>
            <p class="text-xs text-muted-foreground">Review outstanding balances before closing a term.</p>
            <table class="mt-3 w-full text-sm">
                <thead>
                    <tr class="border-b text-xs uppercase text-muted-foreground">
                        <th class="px-3 py-2 text-left font-medium">Class</th>
                        <th class="px-3 py-2 text-right font-medium">Students</th>
                        <th class="px-3 py-2 text-right font-medium">Outstanding</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach ($closeStats as $s)
                        <tr class="border-b">
                            <td class="px-3 py-2">{{ $s->class_name }}</td>
                            <td class="px-3 py-2 text-right tabular-nums">{{ $s->cnt }}</td>
                            <td class="px-3 py-2 text-right tabular-nums">KES {{ number_format($s->balance, 2) }}</td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
            <form method="post" action="{{ route('finance.invoice-item.update', [1, 1]) }}" onsubmit="return false" class="mt-4">
                @csrf @method('PUT')
                <button type="button" onclick="alert('Closing term will mark unpaid balances as carried forward in the next release.')" class="rounded-lg border border-destructive/40 px-3 py-2 text-sm text-destructive hover:bg-destructive/10">Close Current Term</button>
            </form>
        </section>
    </div>
@endsection