@extends('adminlte::page')

@section('title', 'Global Reports')

@include('partials.ui-polish')

@section('content_header')
    <div class="d-flex align-items-center justify-content-between flex-wrap">
        <div>
            <h1 class="m-0">Global Reports</h1>
            <span class="text-muted">Platform-only tenant, subscription, billing, security, usage, growth, and audit reports</span>
        </div>
        <div class="module-actions mt-2 mt-sm-0">
            <a href="{{ route('admin.platform.overview') }}" class="btn btn-outline-secondary btn-sm">
                <i class="fas fa-tachometer-alt mr-1"></i> Overview
            </a>
            <a href="{{ route('admin.platform.security') }}" class="btn btn-outline-primary btn-sm">
                <i class="fas fa-shield-alt mr-1"></i> Security
            </a>
            <button type="button" class="btn btn-primary btn-sm" onclick="window.print()">
                <i class="fas fa-print mr-1"></i> Print
            </button>
        </div>
    </div>
@stop

@section('content')
    <x-adminlte-card title="Report Filters" icon="fas fa-filter" theme="primary" class="no-print">
        <form method="GET" action="{{ route('admin.platform.reports') }}">
            <div class="row">
                <div class="col-md-4">
                    <x-adminlte-input name="date_from" label="From" type="date" value="{{ $dateFrom }}" required/>
                </div>
                <div class="col-md-4">
                    <x-adminlte-input name="date_to" label="To" type="date" value="{{ $dateTo }}" required/>
                </div>
                <div class="col-md-4 d-flex align-items-end">
                    <button type="submit" class="btn btn-primary btn-block mb-3">
                        <i class="fas fa-sync mr-1"></i> Refresh Reports
                    </button>
                </div>
            </div>
        </form>
    </x-adminlte-card>

    <x-adminlte-alert theme="info" title="Platform scope" class="no-print">
        These reports show platform administration data only. Employee records, timesheets, payroll, leave, and other NGO operations remain inside each organization's own workspace.
    </x-adminlte-alert>

    <div class="row">
        <div class="col-lg-3 col-6"><x-adminlte-info-box title="Organizations" text="{{ $organizationReport['total'] }}" icon="fas fa-building" theme="info"/></div>
        <div class="col-lg-3 col-6"><x-adminlte-info-box title="Active Subscriptions" text="{{ $subscriptionReport['active'] }}" icon="fas fa-check-circle" theme="success"/></div>
        <div class="col-lg-3 col-6"><x-adminlte-info-box title="Revenue Paid" text="{{ number_format($revenueReport['paid'], 2) }}" icon="fas fa-dollar-sign" theme="primary"/></div>
        <div class="col-lg-3 col-6"><x-adminlte-info-box title="New Users" text="{{ $userGrowthReport['new_users'] }}" icon="fas fa-user-plus" theme="warning"/></div>
    </div>

    <div class="row">
        <div class="col-lg-7">
            <x-adminlte-card title="Tenant Organization Summary" icon="fas fa-building" theme="primary">
                <div class="table-responsive">
                    <table class="table table-sm table-hover mb-0">
                        <thead><tr><th>Organization</th><th>Plan</th><th>Subscription</th><th>Billing</th><th class="text-right">Users</th></tr></thead>
                        <tbody>
                            @forelse($organizationReport['rows'] as $organization)
                                <tr>
                                    <td><strong>{{ $organization->name }}</strong><div class="text-muted small">{{ $organization->contact_email }}</div></td>
                                    <td><span class="badge badge-info">{{ $organization->plan }}</span></td>
                                    <td><span class="badge badge-{{ $organization->subscription_status === 'Active' ? 'success' : ($organization->subscription_status === 'Suspended' ? 'danger' : 'warning') }}">{{ $organization->subscription_status }}</span></td>
                                    <td><span class="badge badge-light">{{ $organization->billing_status }}</span></td>
                                    <td class="text-right">{{ $organization->users_count }}</td>
                                </tr>
                            @empty
                                <tr><td colspan="5" class="text-center text-muted py-4">No organizations found.</td></tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </x-adminlte-card>
        </div>
        <div class="col-lg-5">
            <x-adminlte-card title="Subscription Report" icon="fas fa-layer-group" theme="success">
                <table class="table table-sm table-hover mb-0">
                    <tbody>
                        <tr><td><span class="badge badge-success mr-2">&nbsp;</span>Active</td><td class="text-right">{{ $subscriptionReport['active'] }}</td></tr>
                        <tr><td><span class="badge badge-info mr-2">&nbsp;</span>Trial</td><td class="text-right">{{ $subscriptionReport['trial'] }}</td></tr>
                        <tr><td><span class="badge badge-danger mr-2">&nbsp;</span>Suspended</td><td class="text-right">{{ $subscriptionReport['suspended'] }}</td></tr>
                        <tr><td><span class="badge badge-secondary mr-2">&nbsp;</span>Cancelled</td><td class="text-right">{{ $subscriptionReport['cancelled'] }}</td></tr>
                        <tr><td><span class="badge badge-warning mr-2">&nbsp;</span>Expiring in 30 days</td><td class="text-right">{{ $subscriptionReport['expiring_soon'] }}</td></tr>
                    </tbody>
                </table>
                <hr>
                <h6 class="text-muted">Plans</h6>
                <table class="table table-sm mb-0">
                    @foreach($organizationReport['by_plan'] as $plan => $count)
                        <tr><td>{{ $plan }}</td><td class="text-right">{{ $count }}</td></tr>
                    @endforeach
                </table>
            </x-adminlte-card>
        </div>
    </div>

    <div class="row">
        <div class="col-lg-8">
            <x-adminlte-card title="Revenue Report" icon="fas fa-file-invoice-dollar" theme="success">
                <div class="row">
                    <div class="col-md-4"><x-adminlte-info-box title="Paid" text="{{ number_format($revenueReport['paid'], 2) }}" icon="fas fa-check" theme="success"/></div>
                    <div class="col-md-4"><x-adminlte-info-box title="Overdue" text="{{ number_format($revenueReport['overdue'], 2) }}" icon="fas fa-exclamation" theme="danger"/></div>
                    <div class="col-md-4"><x-adminlte-info-box title="Issued" text="{{ number_format($revenueReport['issued'], 2) }}" icon="fas fa-paper-plane" theme="info"/></div>
                </div>
                <div class="table-responsive">
                    <table class="table table-sm table-hover mb-0">
                        <thead><tr><th>Invoice</th><th>Organization</th><th>Status</th><th class="text-right">Amount</th><th>Due</th></tr></thead>
                        <tbody>
                            @forelse($revenueReport['rows'] as $invoice)
                                <tr>
                                    <td>{{ $invoice->invoice_number }}</td>
                                    <td>{{ $invoice->organization?->name }}</td>
                                    <td><span class="badge badge-{{ $invoice->status === 'Paid' ? 'success' : ($invoice->status === 'Overdue' ? 'danger' : 'info') }}">{{ $invoice->status }}</span></td>
                                    <td class="text-right">{{ $invoice->currency }} {{ number_format($invoice->amount, 2) }}</td>
                                    <td>{{ $invoice->due_date->format('M d, Y') }}</td>
                                </tr>
                            @empty
                                <tr><td colspan="5" class="text-center text-muted py-4">No invoices in range.</td></tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </x-adminlte-card>
        </div>
        <div class="col-lg-4">
            <x-adminlte-card title="User Growth Report" icon="fas fa-user-plus" theme="warning">
                <h6 class="text-muted">By Role</h6>
                <table class="table table-sm mb-3">
                    @forelse($userGrowthReport['by_role'] as $role => $count)
                        <tr><td>{{ $role }}</td><td class="text-right">{{ $count }}</td></tr>
                    @empty
                        <tr><td class="text-muted">No new users in range.</td></tr>
                    @endforelse
                </table>
                <h6 class="text-muted">By Month</h6>
                <table class="table table-sm mb-0">
                    @forelse($userGrowthReport['by_month'] as $month => $count)
                        <tr><td>{{ $month }}</td><td class="text-right">{{ $count }}</td></tr>
                    @empty
                        <tr><td class="text-muted">No monthly growth data.</td></tr>
                    @endforelse
                </table>
            </x-adminlte-card>
        </div>
    </div>

    <div class="row">
        <div class="col-lg-4">
            <x-adminlte-card title="System Usage Report" icon="fas fa-server" theme="info">
                <table class="table table-sm table-hover mb-0">
                    <tr><td>Organizations</td><td class="text-right">{{ $usageReport['organizations'] }}</td></tr>
                    <tr><td>Active Module Access</td><td class="text-right">{{ $usageReport['active_modules'] }}</td></tr>
                    <tr><td>Invoices in Range</td><td class="text-right">{{ $usageReport['invoices'] }}</td></tr>
                    <tr><td>Login Events</td><td class="text-right">{{ $usageReport['login_events'] }}</td></tr>
                    <tr><td>Storage Usage</td><td class="text-right">{{ number_format($usageReport['storage_gb'], 2) }} GB</td></tr>
                    <tr><td>Support Tickets</td><td class="text-right">{{ $usageReport['support_tickets'] }}</td></tr>
                </table>
            </x-adminlte-card>
        </div>
        <div class="col-lg-8">
            <x-adminlte-card title="Audit Report" icon="fas fa-clipboard-list" theme="danger">
                <div class="row">
                    <div class="col-md-5">
                        <h6 class="text-muted">Top Actions</h6>
                        <table class="table table-sm mb-3">
                            @forelse($auditReport['by_action'] as $action => $count)
                                <tr><td>{{ str_replace('.', ' ', $action) }}</td><td class="text-right">{{ $count }}</td></tr>
                            @empty
                                <tr><td class="text-muted">No audit activity.</td></tr>
                            @endforelse
                        </table>
                    </div>
                    <div class="col-md-7">
                        <h6 class="text-muted">Recent Events</h6>
                        <div class="table-responsive">
                            <table class="table table-sm table-hover mb-0">
                                <thead><tr><th>Action</th><th>Organization</th><th>Time</th></tr></thead>
                                <tbody>
                                    @forelse($auditReport['events'] as $event)
                                        <tr>
                                            <td>{{ str_replace('.', ' ', $event->action) }}</td>
                                            <td>{{ $event->organization?->name ?? 'Platform' }}</td>
                                            <td>{{ $event->created_at->format('M d, H:i') }}</td>
                                        </tr>
                                    @empty
                                        <tr><td colspan="3" class="text-center text-muted py-4">No audit events in range.</td></tr>
                                    @endforelse
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </x-adminlte-card>
        </div>
    </div>
@stop