@extends('layouts.app')
@section('title', 'Revenue Report')

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

@section('content')
<div class="page-header d-flex justify-content-between align-items-center">
    <h1 class="page-title"><i class="bi bi-currency-rupee me-2 text-secondary"></i>Revenue Report</h1>
    <a href="{{ route('reports.revenue', ['format' => 'pdf']) }}" class="btn btn-sm btn-outline-danger">
        <i class="bi bi-filetype-pdf me-1"></i>PDF
    </a>
</div>

<!-- Filters -->
<div class="card table-card p-3 mb-3">
    <form method="GET" class="row g-2 align-items-end">
        <div class="col-md-3">
            <label class="form-label small">From Date</label>
            <input type="date" name="from" class="form-control form-control-sm" value="{{ request('from') }}">
        </div>
        <div class="col-md-3">
            <label class="form-label small">To Date</label>
            <input type="date" name="to" class="form-control form-control-sm" value="{{ request('to') }}">
        </div>
        <div class="col-md-auto">
            <button type="submit" class="btn btn-sm btn-primary mt-3"><i class="bi bi-filter me-1"></i>Filter</button>
        </div>
    </form>
</div>

<div class="row g-3 mb-4">
    <div class="col-md-4">
        <div class="card stat-card p-4 text-center">
            <div class="fs-1 fw-bold text-success">₹{{ number_format($total, 2) }}</div>
            <div class="text-muted">Total Revenue</div>
        </div>
    </div>
    <div class="col-md-4">
        <div class="card stat-card p-4 text-center">
            <div class="fs-1 fw-bold text-primary">{{ $renewals->count() }}</div>
            <div class="text-muted">Total Renewals</div>
        </div>
    </div>
    <div class="col-md-4">
        <div class="card stat-card p-4 text-center">
            <div class="fs-1 fw-bold text-info">₹{{ $renewals->count() ? number_format($total / $renewals->count(), 2) : '0.00' }}</div>
            <div class="text-muted">Avg. per Renewal</div>
        </div>
    </div>
</div>

<div class="card table-card">
    <div class="table-responsive">
        <table class="table table-hover mb-0 datatable">
            <thead class="table-light">
                <tr><th>License</th><th>Customer</th><th>Period</th><th>Previous Expiry</th><th>New Expiry</th><th>Amount</th><th>Date</th></tr>
            </thead>
            <tbody>
                @foreach($renewals as $renewal)
                <tr>
                    <td><code>{{ $renewal->license?->license_key }}</code></td>
                    <td>{{ $renewal->license?->customer?->company_name }}</td>
                    <td>{{ str_replace('_', ' ', ucfirst($renewal->renewal_period)) }}</td>
                    <td>{{ $renewal->previous_expiry->format('d M Y') }}</td>
                    <td>{{ $renewal->new_expiry->format('d M Y') }}</td>
                    <td class="fw-bold">₹{{ number_format($renewal->amount, 2) }}</td>
                    <td class="small text-muted">{{ $renewal->created_at?->format('d M Y') }}</td>
                </tr>
                @endforeach
            </tbody>
            <tfoot class="table-light fw-bold">
                <tr>
                    <td colspan="5" class="text-end">Total Revenue:</td>
                    <td>₹{{ number_format($total, 2) }}</td>
                    <td></td>
                </tr>
            </tfoot>
        </table>
    </div>
</div>
@endsection