@extends('layouts.finance')

@section('title', 'Reports')
@section('subtitle', 'Monthly closed reports and financial summaries')

@section('content')
    <section class="card mb">
        <div class="section-head"><h2>Monthly Closing Reports</h2></div>
        <table>
            <thead>
            <tr>
                <th>Month</th>
                <th>Covered Period</th>
                <th class="right">Sale</th>
                <th class="right">Net Profit</th>
                <th class="right">Net Worth</th>
                <th>Status</th>
                <th class="right">Open</th>
            </tr>
            </thead>
            <tbody>
            @forelse($closings as $closing)
                @php
                    $isFullyClosed = (int) $closing->accounts_required_count > 0
                        && (int) $closing->accounts_closed_count >= (int) $closing->accounts_required_count;
                @endphp
                <tr class="row-hover">
                    <td style="font-weight:700">{{ $closing->month->format('F Y') }}</td>
                    <td>
                        {{ $closing->period_start?->format('d M Y') ?? $closing->month->format('d M Y') }}
                        to
                        {{ $closing->period_end?->format('d M Y') ?? $closing->month->copy()->endOfMonth()->format('d M Y') }}
                    </td>
                    <td class="right">{{ $metrics->money($closing->total_sale, $closing->currency) }}</td>
                    <td class="right" style="color:{{ (float) $closing->net_profit >= 0 ? '#10b981' : '#ef4444' }}">{{ $metrics->money($closing->net_profit, $closing->currency) }}</td>
                    <td class="right">{{ $metrics->money($closing->net_worth, $closing->currency) }}</td>
                    <td><span class="pill {{ $isFullyClosed ? 'pill-green' : 'pill-amber' }}">{{ $closing->accounts_closed_count }}/{{ $closing->accounts_required_count }} closed</span></td>
                    <td class="right"><a class="btn btn-sm" href="{{ route('finance.reports.show', $closing) }}">View Report</a></td>
                </tr>
            @empty
                <tr>
                    <td colspan="7" class="muted text-center" style="padding:2rem 1rem">No monthly reports yet. Close a month first from Monthly Closing.</td>
                </tr>
            @endforelse
            </tbody>
        </table>
    </section>

    <div class="grid grid-2 mb">
        <section class="card">
            <div class="section-head"><h2>Profit & Loss Statement</h2></div>
            <table>
                <tbody>
                @foreach($reports['pl'] as $label => $amount)
                    <tr>
                        <td><strong>{{ $label }}</strong></td>
                        <td class="right" style="color:{{ $amount < 0 ? '#ef4444' : '#1f2937' }}">{{ $metrics->money($amount) }}</td>
                    </tr>
                @endforeach
                </tbody>
            </table>
        </section>
        <section class="card">
            <div class="section-head"><h2>Balance Sheet Snapshot</h2></div>
            <table>
                <tbody>
                @foreach($reports['balance'] as $label => $amount)
                    <tr>
                        <td><strong>{{ $label }}</strong></td>
                        <td class="right" style="color:{{ $amount < 0 ? '#ef4444' : '#1f2937' }}">{{ $metrics->money($amount) }}</td>
                    </tr>
                @endforeach
                </tbody>
            </table>
        </section>
    </div>
    <section class="card">
        <div class="section-head"><h2>6-Month Revenue vs Expenses</h2></div>
        <table>
            <thead><tr><th>Month</th><th class="right">Revenue</th><th class="right">Expenses</th><th class="right">Net</th></tr></thead>
            <tbody>
            @foreach($trend['labels'] as $i => $label)
                <tr>
                    <td>{{ $label }}</td>
                    <td class="right">{{ $metrics->money($trend['revenue'][$i]) }}</td>
                    <td class="right">{{ $metrics->money($trend['expenses'][$i]) }}</td>
                    <td class="right">{{ $metrics->money($trend['revenue'][$i] - $trend['expenses'][$i]) }}</td>
                </tr>
            @endforeach
            </tbody>
        </table>
    </section>
@endsection