@extends('layouts.app')
@section('title', 'Reports')
@section('page-title', 'Reports & Analytics')

@section('content')
<div class="section-header mb-4">
    <div>
        <div class="section-title">Financial Reports</div>
        <div class="section-sub">Generate and export Credit Union reports</div>
    </div>
</div>

{{-- Summary stats --}}
<div class="row g-3 mb-4">
    <div class="col-md-3">
        <div class="stat-card gold">
            <div class="stat-icon gold"><i class="fa-solid fa-users"></i></div>
            <div class="stat-value">{{ $summary['total_members'] }}</div>
            <div class="stat-label">Active Members</div>
        </div>
    </div>
    <div class="col-md-3">
        <div class="stat-card green">
            <div class="stat-icon green"><i class="fa-solid fa-piggy-bank"></i></div>
            <div class="stat-value">${{ number_format($summary['total_savings'], 0) }}</div>
            <div class="stat-label">Total Savings</div>
        </div>
    </div>
    <div class="col-md-3">
        <div class="stat-card blue">
            <div class="stat-icon blue"><i class="fa-solid fa-hand-holding-dollar"></i></div>
            <div class="stat-value">${{ number_format($summary['total_loans'], 0) }}</div>
            <div class="stat-label">Total Loans Issued</div>
        </div>
    </div>
    <div class="col-md-3">
        <div class="stat-card red">
            <div class="stat-icon red"><i class="fa-solid fa-triangle-exclamation"></i></div>
            <div class="stat-value">{{ $summary['defaulters'] }}</div>
            <div class="stat-label">Defaulters</div>
        </div>
    </div>
</div>

<div class="row g-3">
    {{-- Report generators --}}
    <div class="col-lg-4">
        <div class="card">
            <div class="card-header"><div class="card-header-title">Generate Reports</div></div>
            <div class="card-body">
                <div class="d-flex flex-column gap-3">
                    @foreach([
                        ['savings_summary', 'fa-piggy-bank', '#2e7d52', 'Savings Summary', 'Total deposits, withdrawals, net balances per member'],
                        ['loan_register', 'fa-hand-holding-dollar', '#1565c0', 'Loan Register', 'All loans with status, balance, and repayment info'],
                        ['defaulters', 'fa-triangle-exclamation', '#c0392b', 'Defaulters Report', 'Members with overdue repayments'],
                        ['monthly_statement', 'fa-calendar-days', '#c9a84c', 'Monthly Statement', 'All transactions for the selected month'],
                        ['member_ledger', 'fa-book-open', '#0d1b2a', 'Member Ledger', 'Individual member account statement'],
                    ] as [$type, $icon, $color, $title, $desc])
                    <div style="border:1.5px solid var(--border); border-radius:10px; padding:14px;">
                        <div class="d-flex align-items-start gap-3">
                            <div style="width:36px;height:36px;background:{{ $color }}1a;border-radius:8px;display:flex;align-items:center;justify-content:center;flex-shrink:0;">
                                <i class="fa-solid {{ $icon }}" style="color:{{ $color }};font-size:.85rem;"></i>
                            </div>
                            <div style="flex:1;">
                                <div style="font-weight:600;font-size:.88rem;">{{ $title }}</div>
                                <div style="font-size:.75rem;color:#6b7a8d;margin-bottom:8px;">{{ $desc }}</div>
                                <form method="GET" action="{{ route('admin.reports.generate') }}" target="_blank">
                                    <input type="hidden" name="type" value="{{ $type }}">
                                    @if($type === 'monthly_statement')
                                    <input type="month" name="month" class="form-control mb-2" value="{{ now()->format('Y-m') }}" style="font-size:.8rem;padding:5px 10px;">
                                    @endif
                                    @if($type === 'member_ledger')
                                    <select name="member_id" class="form-select mb-2" style="font-size:.8rem;padding:5px 10px;">
                                        <option value="">Select member...</option>
                                        @foreach($members as $m)
                                            <option value="{{ $m->id }}">{{ $m->name }}</option>
                                        @endforeach
                                    </select>
                                    @endif
                                    <div class="d-flex gap-1">
                                        <button type="submit" name="format" value="html" class="btn btn-sm btn-outline-navy" style="font-size:.75rem;padding:4px 10px;">
                                            <i class="fa-solid fa-eye me-1"></i> Preview
                                        </button>
                                        <button type="submit" name="format" value="pdf" class="btn btn-sm btn-gold" style="font-size:.75rem;padding:4px 10px;">
                                            <i class="fa-solid fa-file-pdf me-1"></i> PDF
                                        </button>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                    @endforeach
                </div>
            </div>
        </div>
    </div>

    {{-- Defaulters list --}}
    <div class="col-lg-8">
        <div class="card mb-3">
            <div class="card-header">
                <div class="card-header-title"><i class="fa-solid fa-triangle-exclamation me-2" style="color:#c0392b;"></i>Defaulters List</div>
            </div>
            <div class="table-responsive">
                <table class="table">
                    <thead>
                        <tr><th>Member</th><th>Loan #</th><th>Outstanding</th><th>Overdue Since</th><th>Days Overdue</th></tr>
                    </thead>
                    <tbody>
                        @forelse($defaulters as $d)
                        <tr>
                            <td>
                                <div class="d-flex align-items-center gap-2">
                                    <div class="member-avatar" style="width:28px;height:28px;font-size:.65rem;">{{ strtoupper(substr($d->member->name, 0, 2)) }}</div>
                                    <a href="{{ route('admin.members.show', $d->member) }}" style="text-decoration:none;color:var(--navy);font-size:.875rem;">{{ $d->member->name }}</a>
                                </div>
                            </td>
                            <td><code>{{ $d->loan_number }}</code></td>
                            <td><span class="amount" style="color:#c0392b;">${{ number_format($d->outstanding_balance, 2) }}</span></td>
                            <td style="font-size:.8rem;">{{ $d->overdue_since?->format('M d, Y') ?? '—' }}</td>
                            <td>
                                <span style="background:rgba(192,57,43,.12);color:#c0392b;font-size:.75rem;font-weight:600;padding:3px 9px;border-radius:20px;">
                                    {{ $d->days_overdue ?? 0 }} days
                                </span>
                            </td>
                        </tr>
                        @empty
                        <tr><td colspan="5" class="text-center py-4" style="color:#aaa;font-size:.875rem;">
                            <i class="fa-solid fa-circle-check" style="color:#2e7d52;font-size:1.5rem;display:block;margin-bottom:6px;"></i>
                            No defaulters — excellent!
                        </td></tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>

        {{-- Monthly Savings Chart placeholder --}}
        <div class="card">
            <div class="card-header">
                <div class="card-header-title">Monthly Savings vs Loans (Last 6 Months)</div>
            </div>
            <div class="card-body">
                <canvas id="financeChart" height="120"></canvas>
            </div>
        </div>
    </div>
</div>

@push('scripts')
<script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/4.4.1/chart.umd.min.js"></script>
<script>
const ctx = document.getElementById('financeChart').getContext('2d');
const labels = @json($chartData['labels']);
const savings = @json($chartData['savings']);
const loans = @json($chartData['loans']);

new Chart(ctx, {
    type: 'bar',
    data: {
        labels: labels,
        datasets: [
            {
                label: 'Savings',
                data: savings,
                backgroundColor: 'rgba(46,125,82,.7)',
                borderRadius: 6,
                borderSkipped: false,
            },
            {
                label: 'Loans Disbursed',
                data: loans,
                backgroundColor: 'rgba(201,168,76,.7)',
                borderRadius: 6,
                borderSkipped: false,
            }
        ]
    },
    options: {
        responsive: true,
        plugins: {
            legend: {
                labels: {
                    font: { family: 'DM Sans', size: 12 },
                    usePointStyle: true,
                    pointStyle: 'circle',
                }
            }
        },
        scales: {
            y: {
                grid: { color: 'rgba(0,0,0,.05)' },
                ticks: {
                    font: { family: 'DM Mono', size: 11 },
                    callback: v => '$' + v.toLocaleString()
                }
            },
            x: {
                grid: { display: false },
                ticks: { font: { family: 'DM Sans', size: 12 } }
            }
        }
    }
});
</script>
@endpush
@endsection