@extends('layouts.app')

@section('content')
<div class="container-fluid py-4">
    <!-- Header -->
    <div class="row mb-4">
        <div class="col-12">
            <div class="d-flex justify-content-between align-items-center">
                <div>
                    <h1 class="h3 mb-0">
                        <i class="bi bi-graph-up me-2"></i>Global Sales Report
                    </h1>
                    <p class="text-muted">Detailed sales analytics across all companies and websites</p>
                </div>
                <div>
                    <a href="{{ route('global.reporting.export.sales', request()->query()) }}" class="btn btn-success">
                        <i class="bi bi-download"></i> Export Report
                    </a>
                    <a href="{{ route('global.reporting.index') }}" class="btn btn-outline-secondary">
                        <i class="bi bi-arrow-left"></i> Back to Dashboard
                    </a>
                </div>
            </div>
        </div>
    </div>

    <!-- Date Range Filter -->
    <div class="card mb-4">
        <div class="card-body">
            <form method="GET" class="row g-3 align-items-center">
                <div class="col-md-3">
                    <label class="form-label">Date From</label>
                    <input type="date" name="date_from" class="form-control" 
                           value="{{ request('date_from', $dateRange['start']->format('Y-m-d')) }}">
                </div>
                <div class="col-md-3">
                    <label class="form-label">Date To</label>
                    <input type="date" name="date_to" class="form-control" 
                           value="{{ request('date_to', $dateRange['end']->format('Y-m-d')) }}">
                </div>
                <div class="col-md-4">
                    <label class="form-label">Company Filter</label>
                    <select name="company_id" class="form-select">
                        <option value="">All Companies</option>
                        @foreach($companies as $company)
                            <option value="{{ $company->id }}" {{ request('company_id') == $company->id ? 'selected' : '' }}>
                                {{ $company->name }}
                            </option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-2 d-flex align-items-end">
                    <button type="submit" class="btn btn-primary">
                        <i class="bi bi-search"></i> Filter
                    </button>
                </div>
            </form>
        </div>
    </div>

    <!-- Sales Charts Row -->
    <div class="row mb-4">
        <!-- Revenue Trends Chart -->
        <div class="col-lg-8 mb-4">
            <div class="card h-100">
                <div class="card-header">
                    <h5 class="mb-0">
                        <i class="bi bi-graph-up-arrow me-2"></i>Revenue & Order Trends
                    </h5>
                </div>
                <div class="card-body">
                    <canvas id="salesTrendsChart" height="300"></canvas>
                </div>
            </div>
        </div>

        <!-- Revenue by Channel -->
        <div class="col-lg-4 mb-4">
            <div class="card h-100">
                <div class="card-header">
                    <h5 class="mb-0">
                        <i class="bi bi-pie-chart-fill me-2"></i>Revenue by Channel
                    </h5>
                </div>
                <div class="card-body">
                    <canvas id="revenueChannelChart" height="300"></canvas>
                </div>
            </div>
        </div>
    </div>

    <!-- Company Performance Charts -->
    <div class="row mb-4">
        <!-- Top Companies Bar Chart -->
        <div class="col-lg-6 mb-4">
            <div class="card h-100">
                <div class="card-header">
                    <h5 class="mb-0">
                        <i class="bi bi-bar-chart me-2"></i>Top Companies by Revenue
                    </h5>
                </div>
                <div class="card-body">
                    <canvas id="topCompaniesChart" height="300"></canvas>
                </div>
            </div>
        </div>

        <!-- Website Performance Chart -->
        <div class="col-lg-6 mb-4">
            <div class="card h-100">
                <div class="card-header">
                    <h5 class="mb-0">
                        <i class="bi bi-globe me-2"></i>Top Websites by Revenue
                    </h5>
                </div>
                <div class="card-body">
                    <canvas id="topWebsitesChart" height="300"></canvas>
                </div>
            </div>
        </div>
    </div>

    <!-- Revenue by Month -->
    @if($salesData['revenue_by_month']->count() > 0)
        <div class="card mb-4">
            <div class="card-header">
                <h5 class="mb-0">Monthly Revenue Summary</h5>
            </div>
            <div class="card-body">
                <div class="row">
                    @foreach($salesData['revenue_by_month'] as $monthData)
                        <div class="col-md-4 mb-3">
                            <div class="border rounded p-3">
                                <h6 class="text-muted">{{ \Carbon\Carbon::createFromFormat('Y-m', $monthData->month)->format('F Y') }}</h6>
                                <h4 class="text-success">RM {{ number_format($monthData->revenue, 2) }}</h4>
                            </div>
                        </div>
                    @endforeach
                </div>
            </div>
        </div>
    @endif

    <!-- Revenue by Company -->
    <div class="card mb-4">
        <div class="card-header">
            <h5 class="mb-0">Revenue by Company</h5>
        </div>
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-hover mb-0">
                    <thead class="table-light">
                        <tr>
                            <th>Company</th>
                            <th>Total Revenue</th>
                            <th>Order Count</th>
                            <th>Average Order Value</th>
                            <th>Performance</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($salesData['revenue_by_company'] as $company)
                            <tr>
                                <td>
                                    <div class="d-flex align-items-center">
                                        <div class="bg-primary rounded-circle me-2" style="width: 30px; height: 30px; display: flex; align-items: center; justify-content: center;">
                                            <span class="text-white fw-bold" style="font-size: 12px;">
                                                {{ strtoupper(substr($company->name, 0, 1)) }}
                                            </span>
                                        </div>
                                        <span class="fw-bold">{{ $company->name }}</span>
                                    </div>
                                </td>
                                <td>
                                    <span class="fw-bold text-success">RM {{ number_format($company->total_revenue, 2) }}</span>
                                </td>
                                <td>
                                    <span class="badge bg-primary">{{ number_format($company->order_count) }}</span>
                                </td>
                                <td>
                                    <span class="fw-bold">RM {{ number_format($company->avg_order_value, 2) }}</span>
                                </td>
                                <td>
                                    <div class="progress" style="height: 20px;">
                                        <div class="progress-bar bg-success" 
                                             style="width: {{ ($company->total_revenue / $salesData['revenue_by_company']->max('total_revenue')) * 100 }}%">
                                            {{ number_format(($company->total_revenue / $salesData['revenue_by_company']->sum('total_revenue')) * 100, 1) }}%
                                        </div>
                                    </div>
                                </td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    <!-- Revenue by Channel -->
    <div class="row">
        <div class="col-lg-6 mb-4">
            <div class="card h-100">
                <div class="card-header">
                    <h5 class="mb-0">Revenue by Channel</h5>
                </div>
                <div class="card-body">
                    @foreach($salesData['revenue_by_channel'] as $channel)
                        <div class="mb-3">
                            <div class="d-flex justify-content-between mb-1">
                                <span class="fw-bold">{{ ucfirst($channel->channel ?: 'E-commerce') }}</span>
                                <span>RM {{ number_format($channel->revenue, 2) }}</span>
                            </div>
                            <div class="d-flex justify-content-between mb-2">
                                <small class="text-muted">{{ number_format($channel->order_count) }} orders</small>
                                <small class="text-muted">{{ number_format($channel->percentage, 1) }}%</small>
                            </div>
                            <div class="progress mb-2">
                                <div class="progress-bar bg-{{ 
                                    $channel->channel == 'booking' ? 'success' : 
                                    ($channel->channel == 'payment_form' ? 'info' : 'primary') 
                                }}" style="width: {{ $channel->percentage }}%"></div>
                            </div>
                        </div>
                    @endforeach
                </div>
            </div>
        </div>

        <!-- Top Performing Websites -->
        <div class="col-lg-6 mb-4">
            <div class="card h-100">
                <div class="card-header">
                    <h5 class="mb-0">Top Performing Websites</h5>
                </div>
                <div class="card-body">
                    @foreach($salesData['top_performing_websites'] as $website)
                        <div class="d-flex justify-content-between align-items-center mb-3">
                            <div>
                                <div class="fw-bold">{{ $website->website_name }}</div>
                                <small class="text-muted">{{ $website->company_name }}</small>
                            </div>
                            <div class="text-end">
                                <div class="fw-bold text-success">RM {{ number_format($website->total_revenue, 0) }}</div>
                                <small class="text-muted">{{ number_format($website->order_count) }} orders</small>
                            </div>
                        </div>
                    @endforeach
                </div>
            </div>
        </div>
    </div>

    <!-- Order Trends -->
    @if($salesData['order_trends']->count() > 0)
        <div class="card mb-4">
            <div class="card-header">
                <h5 class="mb-0">Order Trends</h5>
            </div>
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table table-striped">
                        <thead>
                            <tr>
                                <th>Period</th>
                                <th>Orders</th>
                                <th>Revenue</th>
                                <th>Average Order Value</th>
                                <th>Growth</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php $previousRevenue = 0; @endphp
                            @foreach($salesData['order_trends'] as $index => $trend)
                                @php
                                    $growth = $previousRevenue > 0 ? (($trend->revenue - $previousRevenue) / $previousRevenue) * 100 : 0;
                                    $avgOrderValue = $trend->orders > 0 ? $trend->revenue / $trend->orders : 0;
                                @endphp
                                <tr>
                                    <td>{{ \Carbon\Carbon::createFromFormat('Y-m', $trend->month)->format('F Y') }}</td>
                                    <td>{{ number_format($trend->orders) }}</td>
                                    <td class="fw-bold text-success">RM {{ number_format($trend->revenue, 2) }}</td>
                                    <td>RM {{ number_format($avgOrderValue, 2) }}</td>
                                    <td>
                                        @if($index > 0)
                                            <span class="badge bg-{{ $growth >= 0 ? 'success' : 'danger' }}">
                                                {{ $growth >= 0 ? '+' : '' }}{{ number_format($growth, 1) }}%
                                            </span>
                                        @else
                                            <span class="text-muted">-</span>
                                        @endif
                                    </td>
                                </tr>
                                @php $previousRevenue = $trend->revenue; @endphp
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    @endif

    <!-- Customer Analytics -->
    @if(isset($salesData['customer_analytics']))
        <div class="card">
            <div class="card-header">
                <h5 class="mb-0">Customer Analytics</h5>
            </div>
            <div class="card-body">
                <div class="row">
                    <div class="col-md-3">
                        <div class="text-center">
                            <h4 class="text-primary">{{ number_format($salesData['customer_analytics']['total_customers'] ?? 0) }}</h4>
                            <small class="text-muted">Total Customers</small>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="text-center">
                            <h4 class="text-success">{{ number_format($salesData['customer_analytics']['repeat_customers'] ?? 0) }}</h4>
                            <small class="text-muted">Repeat Customers</small>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="text-center">
                            <h4 class="text-info">RM {{ number_format($salesData['customer_analytics']['avg_customer_value'] ?? 0, 2) }}</h4>
                            <small class="text-muted">Avg Customer Value</small>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="text-center">
                            <h4 class="text-warning">{{ number_format(($salesData['customer_analytics']['repeat_rate'] ?? 0) * 100, 1) }}%</h4>
                            <small class="text-muted">Repeat Rate</small>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    @endif
</div>

@push('styles')
<style>
.progress {
    background-color: rgba(0, 0, 0, 0.1);
}

.card {
    box-shadow: 0 0.125rem 0.25rem rgba(0, 0, 0, 0.075);
    border: 1px solid rgba(0, 0, 0, 0.125);
}
</style>
@endpush

@push('scripts')
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<script>
document.addEventListener('DOMContentLoaded', function() {
    
    // Sales Trends Chart (Revenue & Orders)
    const salesTrendsCtx = document.getElementById('salesTrendsChart').getContext('2d');
    const salesTrendsChart = new Chart(salesTrendsCtx, {
        type: 'line',
        data: {
            labels: [
                @foreach($salesData['revenue_by_month'] as $trend)
                    '{{ \Carbon\Carbon::createFromFormat('Y-m', $trend->month)->format('M Y') }}',
                @endforeach
            ],
            datasets: [{
                label: 'Revenue (RM)',
                data: [
                    @foreach($salesData['revenue_by_month'] as $trend)
                        {{ $trend->revenue }},
                    @endforeach
                ],
                borderColor: '#0d6efd',
                backgroundColor: 'rgba(13, 110, 253, 0.1)',
                borderWidth: 3,
                fill: true,
                tension: 0.4
            }]
        },
        options: {
            responsive: true,
            maintainAspectRatio: false,
            plugins: {
                legend: {
                    display: true,
                    position: 'top'
                }
            },
            scales: {
                y: {
                    beginAtZero: true,
                    title: {
                        display: true,
                        text: 'Revenue (RM)'
                    }
                }
            }
        }
    });

    // Revenue by Channel Pie Chart
    const revenueChannelCtx = document.getElementById('revenueChannelChart').getContext('2d');
    const revenueChannelChart = new Chart(revenueChannelCtx, {
        type: 'pie',
        data: {
            labels: [
                @foreach($salesData['revenue_by_channel'] as $channel)
                    '{{ ucfirst($channel->channel) }}',
                @endforeach
            ],
            datasets: [{
                data: [
                    @foreach($salesData['revenue_by_channel'] as $channel)
                        {{ $channel->revenue }},
                    @endforeach
                ],
                backgroundColor: [
                    '#0d6efd',
                    '#198754', 
                    '#fd7e14',
                    '#dc3545',
                    '#6f42c1',
                    '#20c997'
                ],
                borderWidth: 2,
                borderColor: '#fff'
            }]
        },
        options: {
            responsive: true,
            maintainAspectRatio: false,
            plugins: {
                legend: {
                    display: true,
                    position: 'bottom'
                },
                tooltip: {
                    callbacks: {
                        label: function(context) {
                            return context.label + ': RM ' + context.parsed.toLocaleString();
                        }
                    }
                }
            }
        }
    });

    // Top Companies Bar Chart
    const topCompaniesCtx = document.getElementById('topCompaniesChart').getContext('2d');
    const topCompaniesChart = new Chart(topCompaniesCtx, {
        type: 'bar',
        data: {
            labels: [
                @foreach($salesData['revenue_by_company']->take(10) as $company)
                    '{{ $company->name }}',
                @endforeach
            ],
            datasets: [{
                label: 'Revenue (RM)',
                data: [
                    @foreach($salesData['revenue_by_company']->take(10) as $company)
                        {{ $company->total_revenue }},
                    @endforeach
                ],
                backgroundColor: '#198754',
                borderColor: '#146c43',
                borderWidth: 1
            }]
        },
        options: {
            responsive: true,
            maintainAspectRatio: false,
            indexAxis: 'y',
            plugins: {
                legend: {
                    display: false
                }
            },
            scales: {
                x: {
                    beginAtZero: true,
                    title: {
                        display: true,
                        text: 'Revenue (RM)'
                    }
                }
            }
        }
    });

    // Top Websites Chart
    const topWebsitesCtx = document.getElementById('topWebsitesChart').getContext('2d');
    const topWebsitesChart = new Chart(topWebsitesCtx, {
        type: 'bar',
        data: {
            labels: [
                @foreach($salesData['top_performing_websites']->take(10) as $website)
                    '{{ $website->website_name }}',
                @endforeach
            ],
            datasets: [{
                label: 'Revenue (RM)',
                data: [
                    @foreach($salesData['top_performing_websites']->take(10) as $website)
                        {{ $website->total_revenue }},
                    @endforeach
                ],
                backgroundColor: '#fd7e14',
                borderColor: '#fd7e14',
                borderWidth: 1
            }]
        },
        options: {
            responsive: true,
            maintainAspectRatio: false,
            indexAxis: 'y',
            plugins: {
                legend: {
                    display: false
                }
            },
            scales: {
                x: {
                    beginAtZero: true,
                    title: {
                        display: true,
                        text: 'Revenue (RM)'
                    }
                }
            }
        }
    });

});
</script>
@endpush
@endsection