@extends('layouts.app')

@section('title', 'General Ledger')

@section('content')
    @php
        $tabs = ['Journal', 'Trial Balance', 'Deferred Schedule'];
        $active = request('tab', 'Journal');
    @endphp
    <div class="flex flex-col gap-6">
        <div class="flex flex-wrap items-end justify-between gap-3">
            <div>
                <h1 class="text-lg font-semibold">General Ledger</h1>
                <p class="text-xs text-muted-foreground">Double-entry journals for school fees with deferred-revenue recognition</p>
            </div>
            <form method="post" action="{{ route('finance.ledger.realise') }}" class="flex items-center gap-2 rounded-xl border border-border bg-card p-3">
                @csrf
                <div class="text-xs text-muted-foreground">
                    <p class="font-medium text-foreground">Monthly realisation</p>
                    <p>Term = {{ $termMonths }} month(s)</p>
                </div>
                <input type="month" name="period" value="{{ now()->format('Y-m') }}" class="h-8 rounded-md border border-input bg-transparent px-2 text-sm">
                <button class="rounded-lg border border-primary/40 px-3 py-1.5 text-xs text-primary hover:bg-primary/10">Realise period</button>
                <button name="due" value="1" class="rounded-lg bg-primary px-3 py-1.5 text-xs font-medium text-primary-foreground hover:opacity-90">Realise all due</button>
            </form>
        </div>

        <div class="grid gap-3 md:grid-cols-3 lg:grid-cols-6">
            <div class="rounded-xl border border-border bg-card p-3">
                <p class="text-xs text-muted-foreground">Accounts Receivable</p>
                <p class="text-base font-semibold tabular-nums">KES {{ number_format($balances['receivable'], 2) }}</p>
            </div>
            <div class="rounded-xl border border-border bg-card p-3">
                <p class="text-xs text-muted-foreground">Deferred Tuition (liability)</p>
                <p class="text-base font-semibold tabular-nums text-amber-600">KES {{ number_format($balances['deferred'], 2) }}</p>
            </div>
            <div class="rounded-xl border border-border bg-card p-3">
                <p class="text-xs text-muted-foreground">Tuition Revenue (earned)</p>
                <p class="text-base font-semibold tabular-nums text-primary">KES {{ number_format($balances['revenue'], 2) }}</p>
            </div>
            <div class="rounded-xl border border-border bg-card p-3">
                <p class="text-xs text-muted-foreground">Bank - Fees</p>
                <p class="text-base font-semibold tabular-nums">KES {{ number_format($balances['bank'], 2) }}</p>
            </div>
            <div class="rounded-xl border border-border bg-card p-3">
                <p class="text-xs text-muted-foreground">Cash in Hand</p>
                <p class="text-base font-semibold tabular-nums">KES {{ number_format($balances['cash'], 2) }}</p>
            </div>
            <div class="rounded-xl border border-border bg-card p-3">
                <p class="text-xs text-muted-foreground">Unrealised (schedule)</p>
                <p class="text-base font-semibold tabular-nums">KES {{ number_format($deferredOutstanding, 2) }}</p>
            </div>
        </div>

        <div class="flex flex-wrap items-center gap-3">
            <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) }}&from={{ urlencode($from) }}&to={{ urlencode($to) }}&type={{ urlencode($type) }}" 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>
            <form method="get" class="flex flex-wrap items-center gap-2 rounded-xl border border-border bg-card p-2 text-sm">
                <input type="hidden" name="tab" value="{{ $active }}">
                <input type="date" name="from" value="{{ $from }}" class="h-8 rounded-md border border-input bg-transparent px-2 text-sm">
                <span class="text-xs text-muted-foreground">to</span>
                <input type="date" name="to" value="{{ $to }}" class="h-8 rounded-md border border-input bg-transparent px-2 text-sm">
                <select name="type" class="h-8 rounded-md border border-input bg-transparent px-2 text-sm">
                    <option value="">All types</option>
                    @foreach ($types as $t)
                        <option value="{{ $t }}" @selected($type === $t)>{{ $t }}</option>
                    @endforeach
                </select>
                <button class="rounded-lg border border-border px-3 py-1.5 text-xs hover:bg-accent">Filter</button>
                <a href="?tab={{ urlencode($active) }}" class="rounded-lg border border-border px-3 py-1.5 text-xs hover:bg-accent">Reset</a>
            </form>
        </div>

        {{-- Journal --}}
        <section class="rounded-xl border border-border bg-card p-4 {{ $active !== 'Journal' ? 'hidden' : '' }}">
            <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">Entry</th>
                        <th class="px-3 py-2 text-left font-medium">Date</th>
                        <th class="px-3 py-2 text-left font-medium">Type</th>
                        <th class="px-3 py-2 text-left font-medium">Memo</th>
                        <th class="px-3 py-2 text-left font-medium">Term</th>
                        <th class="px-3 py-2 text-right font-medium">Debit</th>
                        <th class="px-3 py-2 text-right font-medium">Credit</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse ($journals as $j)
                        @php
                            $jLines = $lines->get($j->id, collect());
                            $jd = (int) $jLines->sum('debit');
                            $jc = (int) $jLines->sum('credit');
                        @endphp
                        <tr class="border-b align-top">
                            <td class="px-3 py-2 font-mono text-xs">{{ $j->entry_no }}</td>
                            <td class="px-3 py-2 whitespace-nowrap">{{ $j->date }}</td>
                            <td class="px-3 py-2">
                                <span class="rounded-md bg-accent px-1.5 py-0.5 text-[11px]">{{ $j->type }}</span>
                            </td>
                            <td class="px-3 py-2">{{ $j->memo }}</td>
                            <td class="px-3 py-2 text-xs text-muted-foreground">{{ $j->term }} {{ $j->year }}</td>
                            <td class="px-3 py-2 text-right tabular-nums">{{ number_format($jd, 2) }}</td>
                            <td class="px-3 py-2 text-right tabular-nums">{{ number_format($jc, 2) }}</td>
                        </tr>
                        @foreach ($jLines as $line)
                            <tr class="border-b bg-accent/30 text-xs text-muted-foreground">
                                <td class="px-3 py-1.5 pl-8" colspan="2">
                                    {{ $line->account_code }} · {{ $line->account_name }}
                                    <span class="ml-1 rounded bg-card px-1 py-0.5 text-[10px]">{{ $line->account_type }}</span>
                                </td>
                                <td class="px-3 py-1.5" colspan="2">
                                    {{ $line->votehead ?: '—' }}
                                    @if ($line->admission_no)
                                        <span class="font-mono text-[10px]">· {{ $line->admission_no }}</span>
                                    @endif
                                </td>
                                <td class="px-3 py-1.5">{{ $line->memo }}</td>
                                <td class="px-3 py-1.5 text-right tabular-nums">{{ $line->debit ? number_format($line->debit, 2) : '' }}</td>
                                <td class="px-3 py-1.5 text-right tabular-nums">{{ $line->credit ? number_format($line->credit, 2) : '' }}</td>
                            </tr>
                        @endforeach
                    @empty
                        <tr><td colspan="7" class="px-3 py-8 text-center text-sm text-muted-foreground">No journal entries yet. Generate invoices and record fee payments to populate the ledger.</td></tr>
                    @endforelse
                </tbody>
            </table>
            <div class="mt-3">{{ $journals->links() }}</div>
        </section>

        {{-- Trial Balance --}}
        <section class="rounded-xl border border-border bg-card p-4 {{ $active !== 'Trial Balance' ? 'hidden' : '' }}">
            <div class="flex items-center justify-between">
                <h2 class="text-sm font-semibold">Trial Balance</h2>
                @php $tbDr = $trial->sum('debit'); $tbCr = $trial->sum('credit'); @endphp
                <span class="text-xs {{ $tbDr === $tbCr ? 'text-primary' : 'text-destructive' }}">
                    {{ $tbDr === $tbCr ? 'In balance' : 'OUT OF BALANCE' }} — Dr {{ number_format($tbDr, 2) }} / Cr {{ number_format($tbCr, 2) }}
                </span>
            </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">Code</th>
                        <th class="px-3 py-2 text-left font-medium">Account</th>
                        <th class="px-3 py-2 text-left font-medium">Type</th>
                        <th class="px-3 py-2 text-right font-medium">Debit</th>
                        <th class="px-3 py-2 text-right font-medium">Credit</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse ($trial as $row)
                        <tr class="border-b">
                            <td class="px-3 py-2 font-mono text-xs">{{ $row->account_code }}</td>
                            <td class="px-3 py-2">{{ $row->account_name }}</td>
                            <td class="px-3 py-2 text-xs text-muted-foreground">{{ $row->account_type }}</td>
                            <td class="px-3 py-2 text-right tabular-nums">{{ number_format($row->debit, 2) }}</td>
                            <td class="px-3 py-2 text-right tabular-nums">{{ number_format($row->credit, 2) }}</td>
                        </tr>
                    @empty
                        <tr><td colspan="5" class="px-3 py-8 text-center text-sm text-muted-foreground">No postings yet.</td></tr>
                    @endforelse
                </tbody>
                @if ($trial->isNotEmpty())
                    <tfoot>
                        <tr class="border-t font-semibold">
                            <td class="px-3 py-2" colspan="3">Total</td>
                            <td class="px-3 py-2 text-right tabular-nums">{{ number_format($tbDr, 2) }}</td>
                            <td class="px-3 py-2 text-right tabular-nums">{{ number_format($tbCr, 2) }}</td>
                        </tr>
                    </tfoot>
                @endif
            </table>
        </section>

        {{-- Deferred Schedule --}}
        <section class="rounded-xl border border-border bg-card p-4 {{ $active !== 'Deferred Schedule' ? 'hidden' : '' }}">
            <h2 class="text-sm font-semibold">Deferred Tuition Schedule</h2>
            <p class="text-xs text-muted-foreground">Fees received less the monthly revenue recognised so far</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">Receipt</th>
                        <th class="px-3 py-2 text-left font-medium">Student</th>
                        <th class="px-3 py-2 text-left font-medium">Admission No</th>
                        <th class="px-3 py-2 text-left font-medium">Term</th>
                        <th class="px-3 py-2 text-right font-medium">Paid</th>
                        <th class="px-3 py-2 text-right font-medium">Realised</th>
                        <th class="px-3 py-2 text-right font-medium">Deferred</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse ($schedule as $row)
                        <tr class="border-b">
                            <td class="px-3 py-2 font-mono text-xs">{{ $row->receipt_no }}</td>
                            <td class="px-3 py-2">{{ $row->student_name }}</td>
                            <td class="px-3 py-2 font-mono text-xs">{{ $row->admission_no }}</td>
                            <td class="px-3 py-2 text-xs text-muted-foreground">{{ $row->term }} {{ $row->year }}</td>
                            <td class="px-3 py-2 text-right tabular-nums">{{ number_format($row->amount, 2) }}</td>
                            <td class="px-3 py-2 text-right tabular-nums">{{ number_format($row->realised, 2) }}</td>
                            <td class="px-3 py-2 text-right tabular-nums font-medium {{ $row->deferred > 0 ? 'text-amber-600' : 'text-primary' }}">{{ number_format($row->deferred, 2) }}</td>
                        </tr>
                    @empty
                        <tr><td colspan="7" class="px-3 py-8 text-center text-sm text-muted-foreground">No fee payments to schedule.</td></tr>
                    @endforelse
                </tbody>
                @if ($schedule->isNotEmpty())
                    <tfoot>
                        <tr class="border-t font-semibold">
                            <td class="px-3 py-2" colspan="4">Total</td>
                            <td class="px-3 py-2 text-right tabular-nums">{{ number_format($schedule->sum('amount'), 2) }}</td>
                            <td class="px-3 py-2 text-right tabular-nums">{{ number_format($schedule->sum('realised'), 2) }}</td>
                            <td class="px-3 py-2 text-right tabular-nums">{{ number_format($schedule->sum('deferred'), 2) }}</td>
                        </tr>
                    </tfoot>
                @endif
            </table>
        </section>
    </div>
@endsection