@extends('layouts.app')
@section('title', 'Account Ledger')

@section('breadcrumb')
<li class="breadcrumb-item"><a href="{{ route('accounting.index') }}">Accounting</a></li>
<li class="breadcrumb-item active">Ledger</li>
@endsection

@section('content')

<div class="page-header d-flex justify-content-between align-items-center">
    <div>
        <h1 class="page-title"><i class="bi bi-journal-text me-2" style="color:#1d4ed8;"></i>Account Ledger</h1>
        <p class="page-subtitle">Transaction history for each account</p>
    </div>
    <a href="{{ route('accounting.index') }}" class="btn btn-outline-secondary btn-sm">
        <i class="bi bi-arrow-left me-1"></i>Accounts
    </a>
</div>

<div class="card mb-3">
    <div class="card-body py-2">
        <form method="GET" class="row g-2 align-items-end">
            <div class="col-12 col-sm-3">
                <label class="form-label fw-semibold mb-1" style="font-size:.8rem;">Account</label>
                <select name="account_id" class="form-select form-select-sm" onchange="this.form.submit()">
                    <option value="">— Select Account —</option>
                    @foreach($accounts as $acc)
                    <option value="{{ $acc->id }}" {{ ($account?->id == $acc->id) ? 'selected' : '' }}>
                        {{ $acc->name }} (৳{{ number_format($acc->current_balance,0) }})
                    </option>
                    @endforeach
                </select>
            </div>
            <div class="col-6 col-sm-2">
                <label class="form-label fw-semibold mb-1" style="font-size:.8rem;">From</label>
                <input type="date" name="from" class="form-control form-control-sm" value="{{ $from }}">
            </div>
            <div class="col-6 col-sm-2">
                <label class="form-label fw-semibold mb-1" style="font-size:.8rem;">To</label>
                <input type="date" name="to" class="form-control form-control-sm" value="{{ $to }}">
            </div>
            <div class="col-6 col-sm-2">
                <label class="form-label fw-semibold mb-1" style="font-size:.8rem;">Type</label>
                <select name="type" class="form-select form-select-sm">
                    <option value="">All Types</option>
                    @foreach($types as $k => $label)
                    <option value="{{ $k }}" {{ $type === $k ? 'selected':'' }}>{{ $label }}</option>
                    @endforeach
                </select>
            </div>
            <div class="col-6 col-sm-2">
                <button class="btn btn-outline-secondary btn-sm w-100 mt-3">
                    <i class="bi bi-funnel me-1"></i>Filter
                </button>
            </div>
            <div class="col-6 col-sm-1">
                <a href="{{ route('accounting.transactions') }}" class="btn btn-outline-danger btn-sm w-100 mt-3">
                    <i class="bi bi-x"></i>
                </a>
            </div>
        </form>
    </div>
</div>

@if($account)
<div class="row g-3 mb-3">
    <div class="col-6 col-xl-3">
        <div class="stat-card">
            <div class="stat-icon" style="background:#e0e7ff;"><i class="bi bi-wallet2" style="color:#4f46e5;"></i></div>
            <div>
                <div class="stat-value">৳{{ number_format($openingBalance, 2) }}</div>
                <div class="stat-label">Opening Balance</div>
            </div>
        </div>
    </div>
    <div class="col-6 col-xl-3">
        <div class="stat-card">
            <div class="stat-icon" style="background:#d1fae5;"><i class="bi bi-arrow-down-circle" style="color:#059669;"></i></div>
            <div>
                <div class="stat-value">৳{{ number_format($totalCredits, 2) }}</div>
                <div class="stat-label">Total Credits (In)</div>
            </div>
        </div>
    </div>
    <div class="col-6 col-xl-3">
        <div class="stat-card">
            <div class="stat-icon" style="background:#fee2e2;"><i class="bi bi-arrow-up-circle" style="color:#dc2626;"></i></div>
            <div>
                <div class="stat-value">৳{{ number_format($totalDebits, 2) }}</div>
                <div class="stat-label">Total Debits (Out)</div>
            </div>
        </div>
    </div>
    <div class="col-6 col-xl-3">
        <div class="stat-card">
            <div class="stat-icon" style="background:#fef9c3;"><i class="bi bi-bank" style="color:#ca8a04;"></i></div>
            <div>
                <div class="stat-value {{ $closingBalance < 0 ? 'text-danger' : 'text-success' }}">
                    ৳{{ number_format($closingBalance, 2) }}
                </div>
                <div class="stat-label">Closing Balance</div>
            </div>
        </div>
    </div>
</div>

<div class="card">
    <div class="card-header fw-600">
        <i class="bi bi-journal-text me-1"></i>
        Ledger: {{ $account->name }} — {{ \Carbon\Carbon::parse($from)->format('d M Y') }} to {{ \Carbon\Carbon::parse($to)->format('d M Y') }}
    </div>
    <div class="card-body p-0">
        @if($transactions->isEmpty())
        <div class="text-center py-5 text-muted">
            <i class="bi bi-journal" style="font-size:2.5rem;"></i>
            <p class="mt-2">No transactions in this period.</p>
        </div>
        @else
        <div class="table-responsive">
            <table class="table table-hover align-middle mb-0" style="font-size:.85rem;">
                <thead class="table-light">
                    <tr>
                        <th width="110">Date</th>
                        <th width="130">Reference</th>
                        <th width="120">Type</th>
                        <th>Description</th>
                        <th class="text-end" width="120">Credit (In)</th>
                        <th class="text-end" width="120">Debit (Out)</th>
                        <th class="text-end" width="130">Balance</th>
                        <th width="100">By</th>
                    </tr>
                </thead>
                <tbody>
                    @php $runningBalance = $openingBalance; @endphp
                    <tr class="table-secondary">
                        <td colspan="6" class="fw-semibold">Opening Balance</td>
                        <td class="text-end fw-bold">৳{{ number_format($openingBalance, 2) }}</td>
                        <td></td>
                    </tr>
                    @foreach($transactions as $txn)
                    @php
                        if ($txn->entry_type === 'credit') {
                            $runningBalance += $txn->amount;
                        } else {
                            $runningBalance -= $txn->amount;
                        }
                    @endphp
                    <tr>
                        <td>{{ $txn->trans_date->format('d M Y') }}</td>
                        <td>
                            <code style="font-size:.75rem;background:#f1f5f9;padding:2px 5px;border-radius:3px;">
                                {{ $txn->reference ?? '—' }}
                            </code>
                        </td>
                        <td>
                            @php
                                $badge = match($txn->type) {
                                    'income'           => 'success',
                                    'expense'          => 'danger',
                                    'transfer'         => 'info',
                                    'sale_payment'     => 'primary',
                                    'purchase_payment' => 'warning',
                                    default            => 'secondary',
                                };
                            @endphp
                            <span class="badge bg-{{ $badge }}" style="font-size:.72rem;">
                                {{ $types[$txn->type] ?? $txn->type }}
                            </span>
                        </td>
                        <td>{{ $txn->description ?? '—' }}</td>
                        <td class="text-end text-success">
                            @if($txn->entry_type === 'credit') ৳{{ number_format($txn->amount, 2) }} @endif
                        </td>
                        <td class="text-end text-danger">
                            @if($txn->entry_type === 'debit') ৳{{ number_format($txn->amount, 2) }} @endif
                        </td>
                        <td class="text-end fw-semibold {{ $runningBalance < 0 ? 'text-danger' : '' }}">
                            ৳{{ number_format($runningBalance, 2) }}
                        </td>
                        <td class="text-muted" style="font-size:.78rem;">{{ $txn->creator?->name ?? 'System' }}</td>
                    </tr>
                    @endforeach
                    <tr class="table-light fw-bold">
                        <td colspan="4" class="text-end">Closing Balance</td>
                        <td class="text-end text-success">৳{{ number_format($totalCredits, 2) }}</td>
                        <td class="text-end text-danger">৳{{ number_format($totalDebits, 2) }}</td>
                        <td class="text-end {{ $closingBalance < 0 ? 'text-danger' : 'text-success' }}">৳{{ number_format($closingBalance, 2) }}</td>
                        <td></td>
                    </tr>
                </tbody>
            </table>
        </div>
        @endif
    </div>
</div>

@else
<div class="card">
    <div class="card-body text-center py-5 text-muted">
        <i class="bi bi-bank" style="font-size:3rem;"></i>
        <p class="mt-2">Select an account above to view its ledger.</p>
    </div>
</div>
@endif

@endsection