@extends('layouts.app')
@section('title', 'WHMCS Admin - Reports & Analytics')
@section('page-title', 'Reports & Analytics')

@section('breadcrumb')
    <a href="{{ route('dashboard') }}" class="breadcrumb-item">Dashboard</a>
    <span class="breadcrumb-item active">Reports</span>
@endsection



@section('content')
    <!-- Main Content -->

    <!-- Quick Stats -->
    <div class="row mb-4">
        <!-- Monthly Revenue -->
        <div class="col-xl-3 col-md-6 mb-4">
            <div class="stats-card">
                <div class="d-flex align-items-center">
                    <div class="stats-card-icon primary">
                        <i class="fas fa-dollar-sign"></i>
                    </div>
                    <div class="flex-grow-1">
                        <div class="stats-card-value">{{ number_format($monthlyRevenue, 2) }}</div>
                        <div class="stats-card-label">Monthly Revenue</div>
                        <div class="stats-card-change {{ $revenueChange >= 0 ? 'positive text-success' : 'text-danger' }}">
                            <i class="fas fa-arrow-{{ $revenueChange >= 0 ? 'up' : 'down' }}"></i>
                            {{ $revenueChange >= 0 ? '+' : '' }}{{ $revenueChange }}% from last month
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <!-- New Orders -->
        <div class="col-xl-3 col-md-6 mb-4">
            <div class="stats-card">
                <div class="d-flex align-items-center">
                    <div class="stats-card-icon primary">
                        <i class="fas fa-shopping-cart"></i>
                    </div>
                    <div class="flex-grow-1">
                        <div class="stats-card-value">{{ $newOrders }}</div>
                        <div class="stats-card-label">New Orders</div>
                        <div class="stats-card-change {{ $orderChange >= 0 ? 'positive text-success' : 'text-danger' }}">
                            <i class="fas fa-arrow-{{ $orderChange >= 0 ? 'up' : 'down' }}"></i>
                            {{ $orderChange >= 0 ? '+' : '' }}{{ $orderChange }}% from last month
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <!-- New Customers -->
        <div class="col-xl-3 col-md-6 mb-4">
            <div class="stats-card">
                <div class="d-flex align-items-center">
                    <div class="stats-card-icon primary">
                        <i class="fas fa-user-plus"></i>
                    </div>
                    <div class="flex-grow-1">
                        <div class="stats-card-value">{{ $newCustomers }}</div>
                        <div class="stats-card-label">New Customers</div>
                        <div
                            class="stats-card-change {{ $customerChange >= 0 ? 'positive text-success' : 'text-danger' }}">
                            <i class="fas fa-arrow-{{ $customerChange >= 0 ? 'up' : 'down' }}"></i>
                            {{ $customerChange >= 0 ? '+' : '' }}{{ $customerChange }}% from last month
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <!-- Open Tickets -->
        <div class="col-xl-3 col-md-6 mb-4">
            <div class="stats-card">
                <div class="d-flex align-items-center">
                    <div class="stats-card-icon primary">
                        <i class="fas fa-ticket-alt"></i>
                    </div>
                    <div class="flex-grow-1">
                        <div class="stats-card-value">{{ $openTickets }}</div>
                        <div class="stats-card-label">Open Tickets</div>
                        <div class="stats-card-change {{ $ticketChange >= 0 ? 'positive text-success' : 'text-danger' }}">
                            <i class="fas fa-arrow-{{ $ticketChange >= 0 ? 'up' : 'down' }}"></i>
                            {{ $ticketChange >= 0 ? '+' : '' }}{{ $ticketChange }}% from last month
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>



    <!-- Report Filters -->
    <div class="row mb-4">
        <div class="col-12">
            <div class="whmcs-card">
                <div class="whmcs-card-header d-flex justify-content-between align-items-center">
                    <h6 class="mb-0"><i class="fas fa-filter me-2"></i>Report Filters</h6>
                    <button class="whmcs-btn whmcs-btn-sm whmcs-btn-primary">
                        <i class="fas fa-download me-2"></i>Export
                    </button>
                </div>
                <div class="whmcs-card-body">
                    <div class="row g-3">
                        <div class="col-md-3">
                            <label class="whmcs-form-label">Report Type</label>
                            <select class="whmcs-form-control whmcs-form-select">
                                <option>Sales Overview</option>
                                <option>Revenue Report</option>
                                <option>Customer Acquisition</option>
                                <option>Ticket Analysis</option>
                                <option>Product Performance</option>
                            </select>
                        </div>
                        <div class="col-md-3">
                            <label class="whmcs-form-label">Date Range</label>
                            <select class="whmcs-form-control whmcs-form-select">
                                <option>Last 7 Days</option>
                                <option>Last 30 Days</option>
                                <option>This Month</option>
                                <option>Last Month</option>
                                <option>This Quarter</option>
                                <option>Custom Range</option>
                            </select>
                        </div>
                        <div class="col-md-3">
                            <label class="whmcs-form-label">Product/Service</label>
                            <select class="whmcs-form-control whmcs-form-select">
                                <option>All Products</option>
                                <option>Web Hosting</option>
                                <option>VPS</option>
                                <option>Dedicated Server</option>
                                <option>SSL Certificates</option>
                            </select>
                        </div>
                        <div class="col-md-3 d-flex align-items-end">
                            <button class="whmcs-btn whmcs-btn-primary w-100">
                                <i class="fas fa-chart-line me-2"></i>Generate Report
                            </button>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Charts Section -->
    <div class="row mb-4">
        <!-- Monthly Revenue Bar Chart -->
        <div class="col-lg-8 mb-3">
            <div class="whmcs-card h-100">
                <div class="whmcs-card-header">
                    <h6 class="mb-0">
                        <i class="fas fa-chart-bar me-2" aria-hidden="true"></i>
                        Monthly Revenue
                    </h6>
                </div>
                <div class="whmcs-card-body">
                    <div class="whmcs-chart-container" style="height: 300px;">
                        <canvas id="monthlyRevenueChart" role="img" aria-label="Monthly revenue bar chart"></canvas>
                    </div>
                </div>
            </div>
        </div>

        <!-- Revenue by Product Pie Chart -->
        <div class="col-lg-4 mb-3">
            <div class="whmcs-card h-100">
                <div class="whmcs-card-header">
                    <h6 class="mb-0">
                        <i class="fas fa-chart-pie me-2" aria-hidden="true"></i>
                        Revenue by Product
                    </h6>
                </div>
                <div class="whmcs-card-body">
                    <div class="whmcs-chart-container" style="height: 300px;">
                        <canvas id="revenueByProductChart" role="img"
                            aria-label="Revenue by product pie chart"></canvas>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <!-- Invoice Management -->
    <div class="whmcs-card">
        <div class="whmcs-card-header">
            <div class="d-flex justify-content-between align-items-center">
                <h6><i class="fas fa-table me-2"></i>Recent Orders</h6>
                <div class="d-flex align-items-center gap-2">
                    <select class="form-select form-select-sm">
                        <option>Last 30 Days</option>
                        <option>Last 90 Days</option>
                        <option>This Year</option>
                    </select>
                </div>
            </div>
        </div>

        <div class="whmcs-card-body">
            <!-- Report Table -->
            <div class="table-responsive">
                <table class="whmcs-table">
                    <thead>
                        <tr>
                            <th>Order #</th>
                            <th>Customer</th>
                            <th>Product</th>
                            <th>Date</th>
                            <th>Amount</th>
                            <th>Status</th>
                            <th>Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($recentOrders as $order)
                            <tr>
                                <td><strong>#ORD-{{ $order->id }}</strong></td>
                                <td>{{ $order->customer->name ?? 'N/A' }}</td>
                                <td>{{ $order->product->name ?? 'N/A' }}</td>
                                <td>{{ $order->created_at->format('Y-m-d') }}</td>
                                <td>{{ number_format($order->amount, 2) }}</td>
                                <td>
                                    <span
                                        class="whmcs-status-badge {{ $order->status === 'pending' ? 'suspended' : 'active' }}">
                                        {{ ucfirst($order->status) }}
                                    </span>
                                </td>
                                <td>
                                    <a href="{{ route('orders.show', $order->id) }}"
                                        class="whmcs-btn whmcs-btn-sm whmcs-btn-outline-secondary">
                                        <i class="fas fa-eye"></i>
                                    </a>
                                </td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="7" class="text-center">No recent orders found.</td>
                            </tr>
                        @endforelse
                    </tbody>

                </table>
            </div>

        </div>

    </div>


@endsection
@push('scripts')
    <script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
    <script>
        $(document).ready(function() {
            // Initialize empty charts first
            let monthlyRevenueChart;
            let revenueByProductChart;

            // Load Monthly Revenue Chart
            function loadMonthlyRevenue() {
                $.ajax({
                    url: '{{ route('api.monthly-revenue') }}',
                    method: 'GET',
                    dataType: 'json',
                    success: function(res) {
                        const ctx = document.getElementById('monthlyRevenueChart').getContext('2d');

                        if (monthlyRevenueChart) {
                            monthlyRevenueChart.destroy();
                        }

                        monthlyRevenueChart = new Chart(ctx, {
                            type: 'bar',
                            data: {
                                labels: res.labels,
                                datasets: [{
                                    label: 'Revenue (USD)',
                                    data: res.data,
                                    backgroundColor: 'rgba(121, 54, 245, 0.7)',
                                    borderColor: 'rgba(121, 54, 245, 1)',
                                    borderWidth: 1,
                                    borderRadius: 4,
                                }]
                            },
                            options: {
                                responsive: true,
                                scales: {
                                    y: {
                                        beginAtZero: true,
                                        ticks: {
                                            callback: function(value) {
                                                return '$' + value.toLocaleString();
                                            }
                                        }
                                    }
                                },
                                plugins: {
                                    legend: {
                                        display: false
                                    },
                                    tooltip: {
                                        callbacks: {
                                            label: function(context) {
                                                return '$' + context.parsed.y
                                                    .toLocaleString();
                                            }
                                        }
                                    }
                                }
                            }
                        });
                    },
                    error: function() {
                        console.error('Failed to load monthly revenue data.');
                    }
                });
            }

            // Load Revenue By Product Chart
            function loadRevenueByProduct() {
                $.ajax({
                    url: '{{ route('api.revenue-by-product') }}',
                    method: 'GET',
                    dataType: 'json',
                    success: function(res) {
                        const ctx = document.getElementById('revenueByProductChart').getContext('2d');

                        if (revenueByProductChart) {
                            revenueByProductChart.destroy();
                        }

                        revenueByProductChart = new Chart(ctx, {
                            type: 'pie',
                            data: {
                                labels: res.labels,
                                datasets: [{
                                    data: res.data,
                                    backgroundColor: [
                                        '#7936f5',
                                        '#6c63ff',
                                        '#9b59b6',
                                        '#8e44ad',
                                        '#5e35b1',
                                        '#4a148c',
                                        '#7b1fa2',
                                        '#9c27b0',
                                        '#ab47bc',
                                        '#ce93d8',
                                    ],
                                }]
                            },
                            options: {
                                responsive: true,
                                plugins: {
                                    legend: {
                                        position: 'right',
                                    },
                                    tooltip: {
                                        callbacks: {
                                            label: function(context) {
                                                const label = context.label || '';
                                                const value = context.parsed || 0;
                                                return `${label}: $${value.toLocaleString()}`;
                                            }
                                        }
                                    }
                                }
                            }
                        });
                    },
                    error: function() {
                        console.error('Failed to load revenue by product data.');
                    }
                });
            }

            // Call the functions to load charts on page load
            loadMonthlyRevenue();
            loadRevenueByProduct();
        });
    </script>
@endpush