@extends('backEnd.layouts.master')
@section('title', 'Analytics Overview')

@push('styles')
@include('backEnd.reports.partials.report-styles')
<style>
.rp-granularity { display: flex; gap: 6px; flex-wrap: wrap; }
.rp-gran-btn {
    border: 1px solid #d1d5db; background: #fff; color: #374151;
    font-size: 12px; font-weight: 600; padding: 6px 14px; border-radius: 999px; text-decoration: none;
}
.rp-gran-btn.is-active, .rp-gran-btn:hover { background: #2563eb; border-color: #2563eb; color: #fff; }
.rp-chart-card { background: #fff; border: 1px solid #e5e7eb; border-radius: 4px; }
.rp-chart-card .card-header { background: #fff; font-weight: 700; border-bottom: 1px solid #e5e7eb; }
</style>
@endpush

@section('content')
@php
    $exportParams = request()->only(['from_date','to_date','granularity']);
    $todayStr = now()->format('Y-m-d');
    $last7From = now()->copy()->subDays(6)->format('Y-m-d');
    $thisMonthFrom = now()->startOfMonth()->format('Y-m-d');
    $last30From = now()->copy()->subDays(29)->format('Y-m-d');
@endphp

<div class="container-fluid py-3">
    <div class="d-flex justify-content-between align-items-center mb-3 flex-wrap gap-2">
        <div>
            <h4 class="rp-page-title mb-0">Analytics Overview</h4>
            <small class="text-muted">Revenue chart · Best sellers · CLV · UTM attribution</small>
        </div>
        <div class="d-flex gap-2 flex-wrap">
            <a href="{{ route('admin.reports.analytics', array_merge($exportParams, ['export' => 'overview_excel'])) }}"
               class="btn btn-success btn-sm rp-export-btn"><i class="fas fa-file-excel me-1"></i> Full Excel</a>
            <a href="{{ route('admin.reports.analytics', ['export' => 'clv_excel']) }}"
               class="btn btn-outline-success btn-sm rp-export-btn"><i class="fas fa-users me-1"></i> CLV Excel</a>
            <a href="{{ route('admin.reports.analytics', array_merge($exportParams, ['export' => 'utm_excel'])) }}"
               class="btn btn-outline-success btn-sm rp-export-btn"><i class="fas fa-link me-1"></i> UTM Excel</a>
        </div>
    </div>

    <div class="rp-filter-card mb-3">
        <form method="GET" action="{{ route('admin.reports.analytics') }}" class="row g-2 align-items-end">
            <div class="col-12 mb-1">
                <div class="rp-date-presets">
                    <span class="rp-date-presets-label"><i class="fas fa-calendar-alt me-1"></i>Quick:</span>
                    <a href="{{ route('admin.reports.analytics', ['from_date' => $todayStr, 'to_date' => $todayStr, 'granularity' => 'daily']) }}" class="rp-preset-btn">Today</a>
                    <a href="{{ route('admin.reports.analytics', ['from_date' => $last7From, 'to_date' => $todayStr, 'granularity' => 'daily']) }}" class="rp-preset-btn">Last 7 Days</a>
                    <a href="{{ route('admin.reports.analytics', ['from_date' => $last30From, 'to_date' => $todayStr, 'granularity' => 'daily']) }}" class="rp-preset-btn">Last 30 Days</a>
                    <a href="{{ route('admin.reports.analytics', ['from_date' => $thisMonthFrom, 'to_date' => $todayStr, 'granularity' => 'daily']) }}" class="rp-preset-btn">This Month</a>
                </div>
            </div>
            <div class="col-md-3">
                <label class="form-label small fw-semibold mb-1">From</label>
                <input type="date" name="from_date" class="form-control form-control-sm" value="{{ $from }}">
            </div>
            <div class="col-md-3">
                <label class="form-label small fw-semibold mb-1">To</label>
                <input type="date" name="to_date" class="form-control form-control-sm" value="{{ $to }}">
            </div>
            <div class="col-md-4">
                <label class="form-label small fw-semibold mb-1">Revenue Chart</label>
                <div class="rp-granularity">
                    @foreach(['daily' => 'Daily', 'weekly' => 'Weekly', 'monthly' => 'Monthly'] as $g => $label)
                    <button type="submit" name="granularity" value="{{ $g }}"
                            class="rp-gran-btn {{ $granularity === $g ? 'is-active' : '' }}">{{ $label }}</button>
                    @endforeach
                </div>
            </div>
            <div class="col-md-2">
                <button type="submit" class="btn btn-primary btn-sm w-100">Apply</button>
            </div>
        </form>
    </div>

    {{-- Summary --}}
    <div class="row g-3 mb-3">
        <div class="col-6 col-md-2"><div class="rp-stat-card rp-stat-green"><div class="label">Revenue</div><div class="value">৳{{ number_format($summary['revenue'], 0) }}</div></div></div>
        <div class="col-6 col-md-2"><div class="rp-stat-card rp-stat-blue"><div class="label">Orders</div><div class="value">{{ number_format($summary['orders']) }}</div></div></div>
        <div class="col-6 col-md-2"><div class="rp-stat-card rp-stat-teal"><div class="label">Delivered</div><div class="value">{{ number_format($summary['delivered']) }}</div></div></div>
        <div class="col-6 col-md-2"><div class="rp-stat-card rp-stat-yellow"><div class="label">Avg CLV</div><div class="value">৳{{ number_format($summary['avg_clv'], 0) }}</div></div></div>
        <div class="col-6 col-md-2"><div class="rp-stat-card rp-stat-dark"><div class="label">Customers</div><div class="value">{{ number_format($summary['customers']) }}</div></div></div>
        <div class="col-6 col-md-2"><div class="rp-stat-card rp-stat-red"><div class="label">Top Source</div><div class="value" style="font-size:14px;">{{ Str::limit($summary['top_utm_source'], 12) }}</div></div></div>
    </div>

    {{-- Charts --}}
    <div class="row g-3 mb-3">
        <div class="col-lg-7">
            <div class="rp-chart-card">
                <div class="card-header py-2 px-3">
                    <i class="fas fa-chart-line me-2 text-primary"></i>
                    Revenue Chart ({{ ucfirst($granularity) }}) — Delivered Sales
                </div>
                <div class="card-body"><canvas id="revenueChart" height="110"></canvas></div>
            </div>
        </div>
        <div class="col-lg-5">
            <div class="rp-chart-card">
                <div class="card-header py-2 px-3">
                    <i class="fas fa-fire me-2 text-danger"></i>Best Selling Products
                </div>
                <div class="card-body"><canvas id="bestSellersChart" height="110"></canvas></div>
            </div>
        </div>
    </div>

    {{-- CLV Table --}}
    <div class="rp-panel mb-3">
        <div class="d-flex justify-content-between align-items-center px-3 py-2 border-bottom bg-white">
            <strong><i class="fas fa-gem me-2 text-warning"></i>Customer Lifetime Value (Top 50)</strong>
            <span class="small text-muted">Avg CLV: <strong>৳{{ number_format($clv['avg_clv'], 0) }}</strong> · {{ number_format($clv['customer_count']) }} customers</span>
        </div>
        <div class="table-responsive">
            <table class="rp-table">
                <thead>
                    <tr>
                        <th>#</th>
                        <th>Customer</th>
                        <th>Phone</th>
                        <th class="text-center">Orders</th>
                        <th class="text-end">Lifetime Value</th>
                        <th class="text-end">Avg Order</th>
                        <th>First Order</th>
                        <th>Last Order</th>
                    </tr>
                </thead>
                <tbody>
                @forelse($clv['rows'] as $i => $row)
                <tr>
                    <td>{{ $i + 1 }}</td>
                    <td>{{ $row['name'] }}</td>
                    <td>{{ $row['phone'] }}</td>
                    <td class="text-center">{{ $row['order_count'] }}</td>
                    <td class="text-end fw-bold text-success">৳{{ number_format($row['lifetime_value'], 0) }}</td>
                    <td class="text-end">৳{{ number_format($row['avg_order_value'], 0) }}</td>
                    <td><small>{{ $row['first_order_at'] ? \Carbon\Carbon::parse($row['first_order_at'])->format('d M Y') : '—' }}</small></td>
                    <td><small>{{ $row['last_order_at'] ? \Carbon\Carbon::parse($row['last_order_at'])->format('d M Y') : '—' }}</small></td>
                </tr>
                @empty
                <tr><td colspan="8" class="text-center text-muted py-4">No delivered orders yet</td></tr>
                @endforelse
                </tbody>
            </table>
        </div>
    </div>

    {{-- UTM Attribution --}}
    <div class="rp-panel">
        <div class="px-3 py-2 border-bottom bg-white fw-bold">
            <i class="fas fa-bullhorn me-2 text-primary"></i>Traffic Source → Sale Attribution
            <span class="text-muted fw-normal small ms-2">Visitors (VisitorLog) vs Orders/Revenue</span>
        </div>
        <div class="table-responsive">
            <table class="rp-table">
                <thead>
                    <tr>
                        <th>UTM Source</th>
                        <th class="text-end">Visitors</th>
                        <th class="text-end">Orders</th>
                        <th class="text-end">Delivered</th>
                        <th class="text-end">Revenue</th>
                        <th class="text-end">Conv. Rate</th>
                    </tr>
                </thead>
                <tbody>
                @forelse($utm['rows'] as $row)
                <tr>
                    <td><code>{{ $row['source'] }}</code></td>
                    <td class="text-end">{{ number_format($row['visitors']) }}</td>
                    <td class="text-end">{{ number_format($row['orders']) }}</td>
                    <td class="text-end">{{ number_format($row['delivered']) }}</td>
                    <td class="text-end fw-bold">৳{{ number_format($row['revenue'], 0) }}</td>
                    <td class="text-end">{{ number_format($row['conversion_rate'], 1) }}%</td>
                </tr>
                @empty
                <tr><td colspan="6" class="text-center text-muted py-4">No UTM data — ads URL-এ utm_source=facebook&utm_campaign=... ব্যবহার করুন</td></tr>
                @endforelse
                </tbody>
            </table>
        </div>
    </div>
</div>
@endsection

@push('scripts')
<script src="https://cdn.jsdelivr.net/npm/chart.js@4.4.0/dist/chart.umd.min.js"></script>
<script>
new Chart(document.getElementById('revenueChart'), {
    type: 'bar',
    data: {
        labels: @json($revenue_chart['labels']),
        datasets: [
            {
                label: 'Revenue (৳)',
                data: @json($revenue_chart['revenue']),
                backgroundColor: 'rgba(37, 99, 235, 0.75)',
                borderRadius: 4,
                yAxisID: 'y',
            },
            {
                label: 'Orders',
                data: @json($revenue_chart['orders']),
                type: 'line',
                borderColor: '#16a34a',
                backgroundColor: 'transparent',
                tension: 0.3,
                yAxisID: 'y1',
            }
        ]
    },
    options: {
        responsive: true,
        interaction: { mode: 'index', intersect: false },
        plugins: { legend: { position: 'bottom' } },
        scales: {
            y: { beginAtZero: true, position: 'left', title: { display: true, text: '৳ Revenue' } },
            y1: { beginAtZero: true, position: 'right', grid: { drawOnChartArea: false }, title: { display: true, text: 'Orders' } }
        }
    }
});

new Chart(document.getElementById('bestSellersChart'), {
    type: 'bar',
    data: {
        labels: @json($best_sellers['labels']),
        datasets: [{
            label: 'Sold Qty',
            data: @json($best_sellers['sold_qty']),
            backgroundColor: 'rgba(220, 38, 38, 0.75)',
            borderRadius: 4,
        }]
    },
    options: {
        indexAxis: 'y',
        responsive: true,
        plugins: { legend: { display: false } },
        scales: { x: { beginAtZero: true } }
    }
});
</script>
@endpush