@extends('adminlte::page')

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

@section('content_header')
    <div class="d-flex justify-content-between align-items-center">
        <h1>Financial Reports</h1>
        <div>
            <form method="GET" class="d-inline">
                <input type="date" name="start_date" value="{{ $startDate->format('Y-m-d') }}" class="form-control d-inline-block" style="width: auto;">
                <span class="mx-2">to</span>
                <input type="date" name="end_date" value="{{ $endDate->format('Y-m-d') }}" class="form-control d-inline-block" style="width: auto;">
                <button type="submit" class="btn btn-primary">Update Range</button>
            </form>
            <a href="{{ route('reports.index') }}" class="btn btn-secondary ml-2">
                <i class="fas fa-arrow-left"></i> Back to Reports
            </a>
        </div>
    </div>
@stop

@section('content')
<!-- Key Financial Metrics -->
<div class="row">
    <div class="col-lg-3 col-6">
        <div class="small-box bg-success">
            <div class="inner">
                <h3>${{ number_format($revenueOverTime->sum('revenue'), 0) }}</h3>
                <p>Total Revenue</p>
                <small>{{ $startDate->format('M j') }} - {{ $endDate->format('M j, Y') }}</small>
            </div>
            <div class="icon">
                <i class="fas fa-dollar-sign"></i>
            </div>
        </div>
    </div>
    <div class="col-lg-3 col-6">
        <div class="small-box bg-warning">
            <div class="inner">
                <h3>${{ number_format($outstandingInvoices->sum('total_amount'), 0) }}</h3>
                <p>Outstanding</p>
                <small>{{ $outstandingInvoices->count() }} invoices</small>
            </div>
            <div class="icon">
                <i class="fas fa-exclamation-triangle"></i>
            </div>
        </div>
    </div>
    <div class="col-lg-3 col-6">
        <div class="small-box bg-info">
            <div class="inner">
                <h3>{{ $revenueByType->count() }}</h3>
                <p>Case Types</p>
                <small>Generating revenue</small>
            </div>
            <div class="icon">
                <i class="fas fa-chart-pie"></i>
            </div>
        </div>
    </div>
    <div class="col-lg-3 col-6">
        <div class="small-box bg-danger">
            <div class="inner">
                @php
                    $efficiency = $billingEfficiency && $billingEfficiency->time_value > 0 
                        ? round(($billingEfficiency->invoice_value / $billingEfficiency->time_value) * 100, 1) 
                        : 0;
                @endphp
                <h3>{{ $efficiency }}%</h3>
                <p>Billing Efficiency</p>
                <small>Invoice vs Time Value</small>
            </div>
            <div class="icon">
                <i class="fas fa-percentage"></i>
            </div>
        </div>
    </div>
</div>

<div class="row">
    <!-- Revenue Over Time -->
    <div class="col-md-8">
        <div class="card">
            <div class="card-header">
                <h3 class="card-title">Revenue Over Time</h3>
            </div>
            <div class="card-body">
                <canvas id="revenueChart" height="100"></canvas>
            </div>
        </div>
    </div>

    <!-- Revenue by Case Type -->
    <div class="col-md-4">
        <div class="card">
            <div class="card-header">
                <h3 class="card-title">Revenue by Case Type</h3>
            </div>
            <div class="card-body">
                <canvas id="revenueByTypeChart"></canvas>
            </div>
        </div>
    </div>
</div>

<div class="row">
    <!-- Outstanding Invoices -->
    <div class="col-md-6">
        <div class="card">
            <div class="card-header">
                <h3 class="card-title">Outstanding Invoices</h3>
                <div class="card-tools">
                    <span class="badge badge-warning">{{ $outstandingInvoices->count() }} invoices</span>
                </div>
            </div>
            <div class="card-body">
                @if($outstandingInvoices->count() > 0)
                    <div class="table-responsive">
                        <table class="table table-sm">
                            <thead>
                                <tr>
                                    <th>Invoice</th>
                                    <th>Client</th>
                                    <th>Amount</th>
                                    <th>Due Date</th>
                                    <th>Status</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach($outstandingInvoices->take(10) as $invoice)
                                    <tr class="{{ $invoice->due_date < now() ? 'table-danger' : '' }}">
                                        <td>
                                            <small><strong>{{ $invoice->invoice_number }}</strong></small>
                                        </td>
                                        <td>
                                            <small>{{ $invoice->client->display_name ?? 'N/A' }}</small>
                                        </td>
                                        <td>
                                            <strong>${{ number_format($invoice->total_amount, 0) }}</strong>
                                        </td>
                                        <td>
                                            <small>{{ $invoice->due_date->format('M j, Y') }}</small>
                                            @if($invoice->due_date < now())
                                                <br><small class="text-danger">{{ $invoice->due_date->diffForHumans() }}</small>
                                            @endif
                                        </td>
                                        <td>
                                            @php
                                                $statusColors = [
                                                    'sent' => 'warning',
                                                    'partial' => 'info',
                                                    'paid' => 'success'
                                                ];
                                            @endphp
                                            <span class="badge badge-{{ $statusColors[$invoice->status] ?? 'secondary' }}">
                                                {{ ucfirst($invoice->status) }}
                                            </span>
                                        </td>
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                    @if($outstandingInvoices->count() > 10)
                        <small class="text-muted">Showing top 10 of {{ $outstandingInvoices->count() }} outstanding invoices</small>
                    @endif
                @else
                    <p class="text-muted">No outstanding invoices found.</p>
                @endif
            </div>
        </div>
    </div>

    <!-- Top Clients by Revenue -->
    <div class="col-md-6">
        <div class="card">
            <div class="card-header">
                <h3 class="card-title">Top Clients by Revenue</h3>
            </div>
            <div class="card-body">
                @if($topClients->count() > 0)
                    <div class="table-responsive">
                        <table class="table table-sm">
                            <thead>
                                <tr>
                                    <th>Client</th>
                                    <th>Type</th>
                                    <th>Revenue</th>
                                    <th>Invoices</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach($topClients as $client)
                                    <tr>
                                        <td>
                                            <strong>
                                                @if($client->client_type === 'corporate')
                                                    {{ $client->company_name }}
                                                @else
                                                    {{ $client->first_name }} {{ $client->last_name }}
                                                @endif
                                            </strong>
                                        </td>
                                        <td>
                                            <span class="badge badge-{{ $client->client_type === 'corporate' ? 'primary' : 'info' }}">
                                                {{ ucfirst($client->client_type) }}
                                            </span>
                                        </td>
                                        <td>
                                            <strong>${{ number_format($client->total_revenue, 0) }}</strong>
                                        </td>
                                        <td>
                                            <span class="badge badge-secondary">{{ $client->invoice_count }}</span>
                                        </td>
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                @else
                    <p class="text-muted">No client revenue data available.</p>
                @endif
            </div>
        </div>
    </div>
</div>

<!-- Billing Efficiency Details -->
@if($billingEfficiency)
<div class="row">
    <div class="col-12">
        <div class="card">
            <div class="card-header">
                <h3 class="card-title">Billing Efficiency Analysis</h3>
            </div>
            <div class="card-body">
                <div class="row">
                    <div class="col-md-4">
                        <div class="description-block">
                            <h5 class="description-header">${{ number_format($billingEfficiency->time_value, 0) }}</h5>
                            <span class="description-text">TIME VALUE</span>
                            <small class="text-muted d-block">Based on billable hours × rates</small>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="description-block">
                            <h5 class="description-header">${{ number_format($billingEfficiency->invoice_value, 0) }}</h5>
                            <span class="description-text">INVOICE VALUE</span>
                            <small class="text-muted d-block">Actual invoiced amounts</small>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="description-block">
                            @php
                                $variance = $billingEfficiency->time_value > 0 
                                    ? $billingEfficiency->invoice_value - $billingEfficiency->time_value 
                                    : 0;
                            @endphp
                            <h5 class="description-header text-{{ $variance >= 0 ? 'success' : 'danger' }}">
                                ${{ number_format(abs($variance), 0) }}
                            </h5>
                            <span class="description-text">{{ $variance >= 0 ? 'MARKUP' : 'DISCOUNT' }}</span>
                            <small class="text-muted d-block">Difference from time value</small>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endif
@stop

@section('js')
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<script>
// Revenue Over Time Chart
const revenueCtx = document.getElementById('revenueChart').getContext('2d');
const revenueChart = new Chart(revenueCtx, {
    type: 'bar',
    data: {
        labels: [
            @foreach($revenueOverTime as $data)
                '{{ $data->month }}',
            @endforeach
        ],
        datasets: [{
            label: 'Revenue',
            data: [
                @foreach($revenueOverTime as $data)
                    {{ $data->revenue }},
                @endforeach
            ],
            backgroundColor: '#28a745',
            borderColor: '#1e7e34',
            borderWidth: 1
        }]
    },
    options: {
        responsive: true,
        maintainAspectRatio: false,
        scales: {
            y: {
                beginAtZero: true,
                ticks: {
                    callback: function(value) {
                        return '$' + value.toLocaleString();
                    }
                }
            }
        },
        plugins: {
            legend: {
                display: false
            }
        }
    }
});

// Revenue by Case Type Chart
const typeCtx = document.getElementById('revenueByTypeChart').getContext('2d');
const typeChart = new Chart(typeCtx, {
    type: 'doughnut',
    data: {
        labels: [
            @foreach($revenueByType as $type)
                '{{ ucfirst($type->case_type) }}',
            @endforeach
        ],
        datasets: [{
            data: [
                @foreach($revenueByType as $type)
                    {{ $type->revenue }},
                @endforeach
            ],
            backgroundColor: [
                '#FF6384',
                '#36A2EB', 
                '#FFCE56',
                '#4BC0C0',
                '#9966FF',
                '#FF9F40'
            ]
        }]
    },
    options: {
        responsive: true,
        maintainAspectRatio: false,
        plugins: {
            legend: {
                position: 'bottom'
            }
        }
    }
});
</script>
@stop