@extends('patent::layouts.master')

@section('title', 'Patent Transaction Financial Report')

@section('content')
<div class="container-fluid">
    <div class="row">
        <div class="col-12">
            <div class="page-title-box">
                <div class="page-title-right">
                    <ol class="breadcrumb m-0">
                        <li class="breadcrumb-item"><a href="{{ route('patent.dashboard') }}">Dashboard</a></li>
                        <li class="breadcrumb-item"><a href="{{ route('patent.reports.index') }}">Reports</a></li>
                        <li class="breadcrumb-item active">Financial Report</li>
                    </ol>
                </div>
                <h4 class="page-title">Patent Transaction Financial Report</h4>
            </div>
        </div>
    </div>

    <!-- Filters -->
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header">
                    <h4 class="card-title">Filters</h4>
                </div>
                <div class="card-body">
                    <form method="GET" action="{{ route('patent.reports.financial') }}">
                        <div class="row">
                            <div class="col-md-3">
                                <label for="date_from" class="form-label">Date From</label>
                                <input type="date" name="date_from" id="date_from" class="form-control" value="{{ $filters['date_from'] }}">
                            </div>
                            <div class="col-md-3">
                                <label for="date_to" class="form-label">Date To</label>
                                <input type="date" name="date_to" id="date_to" class="form-control" value="{{ $filters['date_to'] }}">
                            </div>
                            <div class="col-md-3">
                                <label for="status" class="form-label">Status</label>
                                <select name="status" id="status" class="form-select">
                                    <option value="">All Statuses</option>
                                    <option value="pending" {{ $filters['status'] == 'pending' ? 'selected' : '' }}>Pending</option>
                                    <option value="approved" {{ $filters['status'] == 'approved' ? 'selected' : '' }}>Approved</option>
                                    <option value="paid" {{ $filters['status'] == 'paid' ? 'selected' : '' }}>Paid</option>
                                    <option value="rejected" {{ $filters['status'] == 'rejected' ? 'selected' : '' }}>Rejected</option>
                                    <option value="cancelled" {{ $filters['status'] == 'cancelled' ? 'selected' : '' }}>Cancelled</option>
                                </select>
                            </div>
                            <div class="col-md-3">
                                <label for="country" class="form-label">Country</label>
                                <input type="text" name="country" id="country" class="form-control" value="{{ $filters['country'] }}" placeholder="Enter country">
                            </div>
                        </div>
                        <div class="row mt-3">
                            <div class="col-12">
                                <button type="submit" class="btn btn-primary">
                                    <i class="mdi mdi-filter me-1"></i> Apply Filters
                                </button>
                                <a href="{{ route('patent.reports.financial') }}" class="btn btn-secondary">
                                    <i class="mdi mdi-refresh me-1"></i> Clear Filters
                                </a>
                                <a href="{{ route('patent.reports.export-pdf', ['financial']) }}?{{ http_build_query($filters) }}" class="btn btn-success">
                                    <i class="mdi mdi-file-pdf me-1"></i> Export PDF
                                </a>
                                <a href="{{ route('patent.reports.export-csv', ['financial']) }}?{{ http_build_query($filters) }}" class="btn btn-info">
                                    <i class="mdi mdi-file-excel me-1"></i> Export CSV
                                </a>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>

    <!-- Financial Overview -->
    <div class="row">
        <div class="col-lg-3 col-md-6">
            <div class="card widget-flat">
                <div class="card-body">
                    <div class="float-end">
                        <i class="mdi mdi-currency-usd widget-icon bg-success-lighten text-success"></i>
                    </div>
                    <h5 class="text-muted fw-normal mt-0" title="Total Revenue">Total Revenue</h5>
                    <h3 class="mt-3 mb-3">${{ number_format($financialStats['total_revenue'], 2) }}</h3>
                    <p class="mb-0 text-muted">
                        <span class="text-success me-2"><i class="mdi mdi-arrow-up-bold"></i></span>
                        Paid transactions
                    </p>
                </div>
            </div>
        </div>

        <div class="col-lg-3 col-md-6">
            <div class="card widget-flat">
                <div class="card-body">
                    <div class="float-end">
                        <i class="mdi mdi-clock-outline widget-icon bg-warning-lighten text-warning"></i>
                    </div>
                    <h5 class="text-muted fw-normal mt-0" title="Pending Revenue">Pending Revenue</h5>
                    <h3 class="mt-3 mb-3">${{ number_format($financialStats['pending_revenue'], 2) }}</h3>
                    <p class="mb-0 text-muted">
                        <span class="text-warning me-2"><i class="mdi mdi-arrow-up-bold"></i></span>
                        Awaiting payment
                    </p>
                </div>
            </div>
        </div>

        <div class="col-lg-3 col-md-6">
            <div class="card widget-flat">
                <div class="card-body">
                    <div class="float-end">
                        <i class="mdi mdi-check-circle widget-icon bg-info-lighten text-info"></i>
                    </div>
                    <h5 class="text-muted fw-normal mt-0" title="Approved Revenue">Approved Revenue</h5>
                    <h3 class="mt-3 mb-3">${{ number_format($financialStats['approved_revenue'], 2) }}</h3>
                    <p class="mb-0 text-muted">
                        <span class="text-info me-2"><i class="mdi mdi-arrow-up-bold"></i></span>
                        Ready for payment
                    </p>
                </div>
            </div>
        </div>

        <div class="col-lg-3 col-md-6">
            <div class="card widget-flat">
                <div class="card-body">
                    <div class="float-end">
                        <i class="mdi mdi-chart-line widget-icon bg-primary-lighten text-primary"></i>
                    </div>
                    <h5 class="text-muted fw-normal mt-0" title="Average Transaction">Average Transaction</h5>
                    <h3 class="mt-3 mb-3">${{ number_format($financialStats['average_transaction_value'], 2) }}</h3>
                    <p class="mb-0 text-muted">
                        <span class="text-primary me-2"><i class="mdi mdi-arrow-up-bold"></i></span>
                        Mean value
                    </p>
                </div>
            </div>
        </div>
    </div>

    <!-- Transaction Range -->
    <div class="row">
        <div class="col-lg-6">
            <div class="card">
                <div class="card-header">
                    <h4 class="card-title">Transaction Range</h4>
                </div>
                <div class="card-body">
                    <div class="row">
                        <div class="col-6">
                            <div class="text-center">
                                <h3 class="text-success">${{ number_format($financialStats['highest_transaction'], 2) }}</h3>
                                <p class="text-muted mb-0">Highest Transaction</p>
                            </div>
                        </div>
                        <div class="col-6">
                            <div class="text-center">
                                <h3 class="text-info">${{ number_format($financialStats['lowest_transaction'], 2) }}</h3>
                                <p class="text-muted mb-0">Lowest Transaction</p>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-lg-6">
            <div class="card">
                <div class="card-header">
                    <h4 class="card-title">Rejected Amount</h4>
                </div>
                <div class="card-body">
                    <div class="text-center">
                        <h3 class="text-danger">${{ number_format($financialStats['rejected_amount'], 2) }}</h3>
                        <p class="text-muted mb-0">Total Rejected Amount</p>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Monthly Revenue Chart -->
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header">
                    <h4 class="card-title">Monthly Revenue Trends</h4>
                </div>
                <div class="card-body">
                    <canvas id="revenueChart" height="100"></canvas>
                </div>
            </div>
        </div>
    </div>

    <!-- Currency Breakdown -->
    <div class="row">
        <div class="col-lg-6">
            <div class="card">
                <div class="card-header">
                    <h4 class="card-title">Currency Breakdown</h4>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-sm">
                            <thead>
                                <tr>
                                    <th>Currency</th>
                                    <th>Count</th>
                                    <th>Total (USD)</th>
                                    <th>Total (Original)</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach($currencyBreakdown as $currency)
                                <tr>
                                    <td><strong>{{ $currency->currency }}</strong></td>
                                    <td>{{ number_format($currency->count) }}</td>
                                    <td>${{ number_format($currency->total_amount_usd, 2) }}</td>
                                    <td>{{ number_format($currency->total_amount_original, 2) }}</td>
                                </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-lg-6">
            <div class="card">
                <div class="card-header">
                    <h4 class="card-title">Payment Methods</h4>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-sm">
                            <thead>
                                <tr>
                                    <th>Payment Method</th>
                                    <th>Count</th>
                                    <th>Total Amount</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach($paymentMethodStats as $method)
                                <tr>
                                    <td>{{ $method->payment_method ?? 'Not Specified' }}</td>
                                    <td>{{ number_format($method->count) }}</td>
                                    <td>${{ number_format($method->total_amount, 2) }}</td>
                                </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Top Earning Patents -->
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header">
                    <h4 class="card-title">Top Earning Patents</h4>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-striped table-hover">
                            <thead class="table-dark">
                                <tr>
                                    <th>Rank</th>
                                    <th>AIPT Reference</th>
                                    <th>Patent Title</th>
                                    <th>Transaction Count</th>
                                    <th>Total Amount (USD)</th>
                                    <th>Average per Transaction</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach($topEarningPatents as $index => $patent)
                                <tr>
                                    <td>
                                        <span class="badge bg-primary">{{ $index + 1 }}</span>
                                    </td>
                                    <td>
                                        <span class="badge bg-info">{{ $patent->patent->aipt_ref ?? 'N/A' }}</span>
                                    </td>
                                    <td>
                                        <div style="max-width: 300px; overflow: hidden; text-overflow: ellipsis; white-space: nowrap;" title="{{ $patent->patent->application_title ?? 'N/A' }}">
                                            {{ $patent->patent->application_title ?? 'N/A' }}
                                        </div>
                                    </td>
                                    <td>{{ number_format($patent->transaction_count) }}</td>
                                    <td><strong>${{ number_format($patent->total_amount, 2) }}</strong></td>
                                    <td>${{ number_format($patent->total_amount / $patent->transaction_count, 2) }}</td>
                                </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@push('scripts')
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<script>
document.addEventListener('DOMContentLoaded', function() {
    // Revenue Chart
    const revenueCtx = document.getElementById('revenueChart').getContext('2d');
    const revenueData = @json($monthlyRevenue);
    
    new Chart(revenueCtx, {
        type: 'bar',
        data: {
            labels: revenueData.map(item => item.month),
            datasets: [{
                label: 'Paid Amount',
                data: revenueData.map(item => item.paid_amount),
                backgroundColor: 'rgba(40, 167, 69, 0.8)',
                borderColor: 'rgba(40, 167, 69, 1)',
                borderWidth: 1
            }, {
                label: 'Pending Amount',
                data: revenueData.map(item => item.pending_amount),
                backgroundColor: 'rgba(255, 193, 7, 0.8)',
                borderColor: 'rgba(255, 193, 7, 1)',
                borderWidth: 1
            }, {
                label: 'Approved Amount',
                data: revenueData.map(item => item.approved_amount),
                backgroundColor: 'rgba(23, 162, 184, 0.8)',
                borderColor: 'rgba(23, 162, 184, 1)',
                borderWidth: 1
            }]
        },
        options: {
            responsive: true,
            scales: {
                y: {
                    beginAtZero: true,
                    ticks: {
                        callback: function(value) {
                            return '$' + value.toLocaleString();
                        }
                    }
                }
            },
            plugins: {
                tooltip: {
                    callbacks: {
                        label: function(context) {
                            return context.dataset.label + ': $' + context.parsed.y.toLocaleString();
                        }
                    }
                }
            }
        }
    });
});
</script>
@endpush

@push('styles')
<style>
.widget-flat {
    transition: transform 0.2s;
}

.widget-flat:hover {
    transform: translateY(-2px);
}

.widget-icon {
    width: 60px;
    height: 60px;
    border-radius: 50%;
    display: flex;
    align-items: center;
    justify-content: center;
    font-size: 24px;
}

.bg-primary-lighten {
    background-color: rgba(13, 110, 253, 0.1) !important;
}

.bg-success-lighten {
    background-color: rgba(40, 167, 69, 0.1) !important;
}

.bg-info-lighten {
    background-color: rgba(23, 162, 184, 0.1) !important;
}

.bg-warning-lighten {
    background-color: rgba(255, 193, 7, 0.1) !important;
}

.table td {
    vertical-align: middle;
}
</style>
@endpush