@extends('admin.layouts.app')

@section('title', 'Order Report')

@section('content')
<div class="space-y-6">
    <!-- Page Header -->
    <div class="flex flex-col sm:flex-row sm:items-center sm:justify-between">
        <div>
            <h1 class="text-2xl font-bold text-slate-800 dark:text-white">Order Report</h1>
            <p class="mt-1 text-sm text-slate-500 dark:text-slate-400">Analyze your order performance and revenue</p>
        </div>
        <div class="mt-4 sm:mt-0 flex space-x-3">
            <button onclick="window.print()" class="px-4 py-2 bg-slate-100 dark:bg-slate-700 text-slate-700 dark:text-slate-300 rounded-xl text-sm font-medium hover:bg-slate-200 dark:hover:bg-slate-600 transition-colors flex items-center">
                <i data-lucide="printer" class="w-4 h-4 mr-2"></i>
                Print
            </button>
            <a href="{{ route('admin.reports.orders', ['export' => 'csv', 'start_date' => $startDate, 'end_date' => $endDate]) }}" class="px-4 py-2 bg-indigo-600 text-white rounded-xl text-sm font-medium hover:bg-indigo-700 transition-colors flex items-center">
                <i data-lucide="download" class="w-4 h-4 mr-2"></i>
                Export CSV
            </a>
        </div>
    </div>

    <!-- Date Filter -->
    <div class="bg-white dark:bg-slate-800 rounded-2xl shadow-sm border border-slate-200 dark:border-slate-700 p-4">
        <form action="{{ route('admin.reports.orders') }}" method="GET" class="flex flex-wrap gap-4 items-end">
            <div>
                <label class="block text-sm font-medium text-slate-700 dark:text-slate-300 mb-1">Start Date</label>
                <input type="date" name="start_date" value="{{ $startDate }}" 
                    class="px-4 py-2 bg-slate-50 dark:bg-slate-700 border border-slate-200 dark:border-slate-600 rounded-xl text-sm focus:ring-2 focus:ring-indigo-500">
            </div>
            <div>
                <label class="block text-sm font-medium text-slate-700 dark:text-slate-300 mb-1">End Date</label>
                <input type="date" name="end_date" value="{{ $endDate }}" 
                    class="px-4 py-2 bg-slate-50 dark:bg-slate-700 border border-slate-200 dark:border-slate-600 rounded-xl text-sm focus:ring-2 focus:ring-indigo-500">
            </div>
            <div>
                <label class="block text-sm font-medium text-slate-700 dark:text-slate-300 mb-1">Status</label>
                <select name="status" class="px-4 py-2 bg-slate-50 dark:bg-slate-700 border border-slate-200 dark:border-slate-600 rounded-xl text-sm focus:ring-2 focus:ring-indigo-500">
                    <option value="">All Status</option>
                    <option value="pending" {{ $status == 'pending' ? 'selected' : '' }}>Pending</option>
                    <option value="processing" {{ $status == 'processing' ? 'selected' : '' }}>Processing</option>
                    <option value="completed" {{ $status == 'completed' ? 'selected' : '' }}>Completed</option>
                    <option value="cancelled" {{ $status == 'cancelled' ? 'selected' : '' }}>Cancelled</option>
                    <option value="returned" {{ $status == 'returned' ? 'selected' : '' }}>Returned</option>
                </select>
            </div>
            <button type="submit" class="px-4 py-2 bg-indigo-600 text-white rounded-xl text-sm font-medium hover:bg-indigo-700 transition-colors">
                Apply Filter
            </button>
            <a href="{{ route('admin.reports.orders') }}" class="px-4 py-2 bg-slate-100 dark:bg-slate-700 text-slate-700 dark:text-slate-300 rounded-xl text-sm font-medium hover:bg-slate-200 dark:hover:bg-slate-600 transition-colors">
                Reset
            </a>
        </form>
    </div>

    <!-- Summary Cards -->
    <div class="grid grid-cols-1 sm:grid-cols-2 lg:grid-cols-4 gap-4 lg:gap-6">
        <!-- Total Orders -->
        <div class="bg-white dark:bg-slate-800 rounded-2xl shadow-sm border border-slate-200 dark:border-slate-700 p-6">
            <div class="flex items-center justify-between">
                <div>
                    <p class="text-sm font-medium text-slate-500 dark:text-slate-400">Total Orders</p>
                    <p class="text-3xl font-bold text-slate-800 dark:text-white mt-1">{{ number_format($summary['total_orders']) }}</p>
                </div>
                <div class="p-4 bg-indigo-50 dark:bg-indigo-900/30 rounded-2xl">
                    <i data-lucide="shopping-cart" class="w-8 h-8 text-indigo-600 dark:text-indigo-400"></i>
                </div>
            </div>
        </div>

        <!-- Total Revenue -->
        <div class="bg-white dark:bg-slate-800 rounded-2xl shadow-sm border border-slate-200 dark:border-slate-700 p-6">
            <div class="flex items-center justify-between">
                <div>
                    <p class="text-sm font-medium text-slate-500 dark:text-slate-400">Total Revenue</p>
                    <p class="text-3xl font-bold text-emerald-600 dark:text-emerald-400 mt-1">৳{{ number_format($summary['total_revenue']) }}</p>
                </div>
                <div class="p-4 bg-emerald-50 dark:bg-emerald-900/30 rounded-2xl">
                    <i data-lucide="banknote" class="w-8 h-8 text-emerald-600 dark:text-emerald-400"></i>
                </div>
            </div>
        </div>

        <!-- Average Order Value -->
        <div class="bg-white dark:bg-slate-800 rounded-2xl shadow-sm border border-slate-200 dark:border-slate-700 p-6">
            <div class="flex items-center justify-between">
                <div>
                    <p class="text-sm font-medium text-slate-500 dark:text-slate-400">Avg Order Value</p>
                    <p class="text-3xl font-bold text-blue-600 dark:text-blue-400 mt-1">৳{{ number_format($summary['avg_order_value']) }}</p>
                </div>
                <div class="p-4 bg-blue-50 dark:bg-blue-900/30 rounded-2xl">
                    <i data-lucide="trending-up" class="w-8 h-8 text-blue-600 dark:text-blue-400"></i>
                </div>
            </div>
        </div>

        <!-- Completed Orders -->
        <div class="bg-white dark:bg-slate-800 rounded-2xl shadow-sm border border-slate-200 dark:border-slate-700 p-6">
            <div class="flex items-center justify-between">
                <div>
                    <p class="text-sm font-medium text-slate-500 dark:text-slate-400">Completed</p>
                    <p class="text-3xl font-bold text-purple-600 dark:text-purple-400 mt-1">{{ $summary['by_status']['completed'] ?? 0 }}</p>
                </div>
                <div class="p-4 bg-purple-50 dark:bg-purple-900/30 rounded-2xl">
                    <i data-lucide="check-circle" class="w-8 h-8 text-purple-600 dark:text-purple-400"></i>
                </div>
            </div>
        </div>
    </div>

    <!-- Charts Row -->
    <div class="grid grid-cols-1 lg:grid-cols-2 gap-6">
        <!-- Sales Chart -->
        <div class="bg-white dark:bg-slate-800 rounded-2xl shadow-sm border border-slate-200 dark:border-slate-700 p-6">
            <h3 class="text-lg font-semibold text-slate-800 dark:text-white mb-4">Sales Trend (Last 7 Days)</h3>
            <div class="h-64">
                <canvas id="salesChart"></canvas>
            </div>
        </div>

        <!-- Order Status Distribution -->
        <div class="bg-white dark:bg-slate-800 rounded-2xl shadow-sm border border-slate-200 dark:border-slate-700 p-6">
            <h3 class="text-lg font-semibold text-slate-800 dark:text-white mb-4">Order Status Distribution</h3>
            <div class="h-64">
                <canvas id="statusChart"></canvas>
            </div>
        </div>
    </div>

    <!-- Status Breakdown -->
    <div class="grid grid-cols-2 sm:grid-cols-3 lg:grid-cols-5 gap-4">
        <div class="bg-amber-50 dark:bg-amber-900/20 rounded-xl p-4 border border-amber-200 dark:border-amber-800">
            <div class="flex items-center justify-between">
                <span class="text-amber-700 dark:text-amber-400 font-medium">Pending</span>
                <span class="text-2xl font-bold text-amber-700 dark:text-amber-400">{{ $summary['by_status']['pending'] ?? 0 }}</span>
            </div>
        </div>
        <div class="bg-blue-50 dark:bg-blue-900/20 rounded-xl p-4 border border-blue-200 dark:border-blue-800">
            <div class="flex items-center justify-between">
                <span class="text-blue-700 dark:text-blue-400 font-medium">Processing</span>
                <span class="text-2xl font-bold text-blue-700 dark:text-blue-400">{{ $summary['by_status']['processing'] ?? 0 }}</span>
            </div>
        </div>
        <div class="bg-emerald-50 dark:bg-emerald-900/20 rounded-xl p-4 border border-emerald-200 dark:border-emerald-800">
            <div class="flex items-center justify-between">
                <span class="text-emerald-700 dark:text-emerald-400 font-medium">Completed</span>
                <span class="text-2xl font-bold text-emerald-700 dark:text-emerald-400">{{ $summary['by_status']['completed'] ?? 0 }}</span>
            </div>
        </div>
        <div class="bg-red-50 dark:bg-red-900/20 rounded-xl p-4 border border-red-200 dark:border-red-800">
            <div class="flex items-center justify-between">
                <span class="text-red-700 dark:text-red-400 font-medium">Cancelled</span>
                <span class="text-2xl font-bold text-red-700 dark:text-red-400">{{ $summary['by_status']['cancelled'] ?? 0 }}</span>
            </div>
        </div>
        <div class="bg-purple-50 dark:bg-purple-900/20 rounded-xl p-4 border border-purple-200 dark:border-purple-800">
            <div class="flex items-center justify-between">
                <span class="text-purple-700 dark:text-purple-400 font-medium">Returned</span>
                <span class="text-2xl font-bold text-purple-700 dark:text-purple-400">{{ $summary['by_status']['returned'] ?? 0 }}</span>
            </div>
        </div>
    </div>

    <!-- Orders Table -->
    <div class="bg-white dark:bg-slate-800 rounded-2xl shadow-sm border border-slate-200 dark:border-slate-700 overflow-hidden">
        <div class="p-6 border-b border-slate-200 dark:border-slate-700">
            <h3 class="text-lg font-semibold text-slate-800 dark:text-white">Order Details</h3>
        </div>
        <div class="overflow-x-auto">
            <table class="w-full">
                <thead class="bg-slate-50 dark:bg-slate-700/50">
                    <tr class="text-left text-xs font-medium text-slate-500 dark:text-slate-400 uppercase tracking-wider">
                        <th class="px-6 py-4">Order ID</th>
                        <th class="px-6 py-4">Customer</th>
                        <th class="px-6 py-4">Items</th>
                        <th class="px-6 py-4">Total</th>
                        <th class="px-6 py-4">Payment</th>
                        <th class="px-6 py-4">Status</th>
                        <th class="px-6 py-4">Date</th>
                    </tr>
                </thead>
                <tbody class="divide-y divide-slate-200 dark:divide-slate-700">
                    @forelse($orders as $order)
                    <tr class="hover:bg-slate-50 dark:hover:bg-slate-700/50 transition-colors">
                        <td class="px-6 py-4">
                            <a href="{{ route('admin.orders.show', $order) }}" class="font-medium text-indigo-600 dark:text-indigo-400 hover:underline">#{{ $order->id }}</a>
                        </td>
                        <td class="px-6 py-4">
                            <p class="font-medium text-slate-800 dark:text-white">{{ $order->shipping_name }}</p>
                            <p class="text-sm text-slate-500">{{ $order->shipping_phone }}</p>
                        </td>
                        <td class="px-6 py-4 text-slate-600 dark:text-slate-300">{{ $order->items->count() }} items</td>
                        <td class="px-6 py-4 font-semibold text-slate-800 dark:text-white">৳{{ number_format($order->total) }}</td>
                        <td class="px-6 py-4">
                            <span class="text-sm text-slate-600 dark:text-slate-300">{{ strtoupper($order->payment_method ?? 'COD') }}</span>
                        </td>
                        <td class="px-6 py-4">
                            @php
                                $statusColors = [
                                    'pending' => 'bg-amber-100 dark:bg-amber-900/30 text-amber-700 dark:text-amber-400',
                                    'processing' => 'bg-blue-100 dark:bg-blue-900/30 text-blue-700 dark:text-blue-400',
                                    'completed' => 'bg-emerald-100 dark:bg-emerald-900/30 text-emerald-700 dark:text-emerald-400',
                                    'cancelled' => 'bg-red-100 dark:bg-red-900/30 text-red-700 dark:text-red-400',
                                    'returned' => 'bg-purple-100 dark:bg-purple-900/30 text-purple-700 dark:text-purple-400',
                                ];
                            @endphp
                            <span class="px-3 py-1 text-xs font-medium {{ $statusColors[$order->status] ?? 'bg-slate-100 text-slate-700' }} rounded-full">
                                {{ ucfirst($order->status) }}
                            </span>
                        </td>
                        <td class="px-6 py-4 text-sm text-slate-500 dark:text-slate-400">{{ $order->created_at->format('M d, Y') }}</td>
                    </tr>
                    @empty
                    <tr>
                        <td colspan="7" class="px-6 py-12 text-center">
                            <div class="flex flex-col items-center">
                                <i data-lucide="inbox" class="w-12 h-12 text-slate-300 dark:text-slate-600 mb-4"></i>
                                <p class="text-slate-500 dark:text-slate-400">No orders found for this period</p>
                            </div>
                        </td>
                    </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>
</div>
@endsection

@push('scripts')
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<script>
document.addEventListener('DOMContentLoaded', function() {
    const chartData = @json($chartData);
    const byStatus = @json($summary['by_status']);
    
    // Sales Chart
    const salesCtx = document.getElementById('salesChart').getContext('2d');
    new Chart(salesCtx, {
        type: 'line',
        data: {
            labels: chartData.map(d => d.date),
            datasets: [{
                label: 'Sales',
                data: chartData.map(d => d.sales),
                borderColor: '#6366f1',
                backgroundColor: 'rgba(99, 102, 241, 0.1)',
                fill: true,
                tension: 0.4
            }]
        },
        options: {
            responsive: true,
            maintainAspectRatio: false,
            plugins: {
                legend: { display: false }
            },
            scales: {
                y: {
                    beginAtZero: true,
                    grid: { color: 'rgba(0,0,0,0.05)' }
                },
                x: {
                    grid: { display: false }
                }
            }
        }
    });

    // Status Chart
    const statusCtx = document.getElementById('statusChart').getContext('2d');
    new Chart(statusCtx, {
        type: 'doughnut',
        data: {
            labels: ['Completed', 'Processing', 'Pending', 'Cancelled', 'Returned'],
            datasets: [{
                data: [
                    byStatus.completed || 0,
                    byStatus.processing || 0,
                    byStatus.pending || 0,
                    byStatus.cancelled || 0,
                    byStatus.returned || 0
                ],
                backgroundColor: ['#22c55e', '#3b82f6', '#f59e0b', '#ef4444', '#a855f7'],
                borderWidth: 0
            }]
        },
        options: {
            responsive: true,
            maintainAspectRatio: false,
            plugins: {
                legend: {
                    position: 'bottom',
                    labels: { padding: 20 }
                }
            },
            cutout: '70%'
        }
    });
});
</script>
@endpush