@extends('admin.layout.app')

@section('title', 'Vendor Sales Report')

@section('content')
<div class="app-content">
    <div class="container-fluid">
        <div class="row mb-3">
            <div class="col-12 d-flex flex-wrap justify-content-between align-items-center">
                <h2 class="mb-0 fw-bold">Vendor Sales Report</h2>
            </div>
        </div>

        <form method="GET" action="{{ route('admin.vendor-reports.sales') }}" class="mb-4">
            <div class="card shadow-sm border-0">
                <div class="card-body">
                    <div class="row g-3 align-items-end">
                        <div class="col-md-3">
                            <label class="form-label">Start Date</label>
                            <input type="date" name="start_date" class="form-control" value="{{ $startDate }}" required>
                        </div>
                        <div class="col-md-3">
                            <label class="form-label">End Date</label>
                            <input type="date" name="end_date" class="form-control" value="{{ $endDate }}" required>
                        </div>
                        <div class="col-md-3">
                            <label class="form-label">Vendor</label>
                            <select name="vendor_id" class="form-select">
                                <option value="">All Vendors</option>
                                @foreach($vendors as $vendor)
                                    <option value="{{ $vendor->id }}" {{ (string)request('vendor_id') === (string)$vendor->id ? 'selected' : '' }}>
                                        {{ $vendor->business_name ?? $vendor->vendor_name ?? ('Vendor #' . $vendor->id) }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-3">
                            <label class="form-label">View Type</label>
                            <select name="view_type" class="form-select">
                                <option value="summary" {{ request('view_type', 'summary') === 'summary' ? 'selected' : '' }}>Summary</option>
                                <option value="daily" {{ request('view_type') === 'daily' ? 'selected' : '' }}>Daily</option>
                                <option value="monthly" {{ request('view_type') === 'monthly' ? 'selected' : '' }}>Monthly</option>
                            </select>
                        </div>
                        <div class="col-md-2">
                            <button type="submit" class="btn btn-primary w-100">
                                <i class="bi bi-search me-1"></i>Generate
                            </button>
                        </div>
                        <div class="col-12">
                            <a href="{{ route('admin.vendor-reports.sales') }}" class="btn btn-secondary btn-sm">
                                <i class="bi bi-x-circle me-1"></i>Reset
                            </a>
                            <small class="text-muted ms-2">
                                Attribution is inferred by matching `vendor_products.sp` to the sold item price.
                            </small>
                        </div>
                    </div>
                </div>
            </div>
        </form>

        <div class="row mb-4">
            <div class="col-12">
                <div class="card shadow-sm border-0">
                    <div class="card-header bg-info text-white">
                        <h5 class="mb-0 fw-bold">Summary</h5>
                    </div>
                    <div class="card-body">
                        <div class="row text-center g-3">
                            <div class="col-md-3">
                                <div class="p-2 bg-light rounded">
                                    <div class="fw-bold text-secondary">Vendors</div>
                                    <div class="fs-4 fw-bold text-primary">{{ $totals['vendors_count'] ?? 0 }}</div>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="p-2 bg-light rounded">
                                    <div class="fw-bold text-secondary">Orders</div>
                                    <div class="fs-4 fw-bold text-primary">{{ $totals['orders_count'] ?? 0 }}</div>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="p-2 bg-light rounded">
                                    <div class="fw-bold text-secondary">Qty Sold</div>
                                    <div class="fs-4 fw-bold text-primary">{{ $totals['qty_sold'] ?? 0 }}</div>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="p-2 bg-light rounded">
                                    <div class="fw-bold text-secondary">Revenue</div>
                                    <div class="fs-4 fw-bold text-dark">&#8377;{{ number_format($totals['revenue'] ?? 0, 2) }}</div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        @php
            // Group by vendor from productBreakdown to create vendor summary
            $vendorSummary = $productBreakdown->groupBy('vendor_id')->map(function ($items, $vendorId) {
                return (object) [
                    'vendor_id' => $vendorId,
                    'business_name' => $items->first()->business_name ?? null,
                    'vendor_name' => $items->first()->vendor_name ?? null,
                    'qty_sold' => $items->sum('qty_sold'),
                    'revenue' => $items->sum('revenue'),
                ];
            })->values();
        @endphp

        <div class="row mb-4">
            <div class="col-12">
                <div class="card shadow-sm border-0">
                    <div class="card-header bg-success text-white">
                        <h5 class="mb-0 fw-bold">Vendor-wise Sales</h5>
                    </div>
                    <div class="card-body">
                        <div class="table-responsive">
                            <table class="table table-bordered align-middle text-center mb-0">
                                <thead class="table-light">
                                    <tr>
                                        <th>Vendor</th>
                                        <th>Qty Sold</th>
                                        <th>Revenue (&#8377;)</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @forelse($vendorSummary as $row)
                                        <tr>
                                            <td class="text-start">
                                                <strong>{{ $row->business_name ?? $row->vendor_name ?? ('Vendor #' . $row->vendor_id) }}</strong>
                                            </td>
                                            <td>{{ $row->qty_sold }}</td>
                                            <td><strong>&#8377;{{ number_format($row->revenue, 2) }}</strong></td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="3" class="text-center text-muted py-4">
                                                <i class="bi bi-inbox"></i> No vendor sales found for this period.
                                            </td>
                                        </tr>
                                    @endforelse
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        @if($viewType === 'daily' && $dailyBreakdown)
        <div class="row mb-4">
            <div class="col-12">
                <div class="card shadow-sm border-0">
                    <div class="card-header bg-warning text-white">
                        <h5 class="mb-0 fw-bold">Daily Breakdown</h5>
                    </div>
                    <div class="card-body">
                        <div class="table-responsive">
                            <table class="table table-bordered align-middle text-center mb-0">
                                <thead class="table-light">
                                    <tr>
                                        <th>Date</th>
                                        <th>Orders</th>
                                        <th>Qty Sold</th>
                                        <th>Revenue (&#8377;)</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @forelse($dailyBreakdown as $row)
                                        <tr>
                                            <td>{{ \Carbon\Carbon::parse($row->date)->format('d M Y') }}</td>
                                            <td><span class="badge bg-secondary">{{ $row->orders_count }}</span></td>
                                            <td>{{ $row->qty_sold }}</td>
                                            <td><strong>&#8377;{{ number_format($row->revenue, 2) }}</strong></td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="4" class="text-center text-muted py-4">
                                                <i class="bi bi-inbox"></i> No daily sales found.
                                            </td>
                                        </tr>
                                    @endforelse
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        @endif

        @if($viewType === 'monthly' && $monthlyBreakdown)
        <div class="row mb-4">
            <div class="col-12">
                <div class="card shadow-sm border-0">
                    <div class="card-header bg-info text-white">
                        <h5 class="mb-0 fw-bold">Monthly Breakdown</h5>
                    </div>
                    <div class="card-body">
                        <div class="table-responsive">
                            <table class="table table-bordered align-middle text-center mb-0">
                                <thead class="table-light">
                                    <tr>
                                        <th>Month</th>
                                        <th>Orders</th>
                                        <th>Qty Sold</th>
                                        <th>Revenue (&#8377;)</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @forelse($monthlyBreakdown as $row)
                                        <tr>
                                            <td>{{ \Carbon\Carbon::create($row->year, $row->month)->format('M Y') }}</td>
                                            <td><span class="badge bg-secondary">{{ $row->orders_count }}</span></td>
                                            <td>{{ $row->qty_sold }}</td>
                                            <td><strong>&#8377;{{ number_format($row->revenue, 2) }}</strong></td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="4" class="text-center text-muted py-4">
                                                <i class="bi bi-inbox"></i> No monthly sales found.
                                            </td>
                                        </tr>
                                    @endforelse
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        @endif

        @if($viewType === 'summary')
        <div class="row">
            <div class="col-12">
                <div class="card shadow-sm border-0">
                    <div class="card-header bg-white border-bottom d-flex justify-content-between align-items-center">
                        <h5 class="mb-0 fw-bold">Product Breakdown (Attributed)</h5>
                        <small class="text-muted">{{ $productBreakdown->count() }} rows</small>
                    </div>
                    <div class="card-body">
                        <div class="table-responsive">
                            <table class="table table-bordered align-middle text-center mb-0">
                                <thead class="table-light">
                                    <tr>
                                        <th>Vendor</th>
                                        <th class="text-start">Product</th>
                                        <th>Qty Sold</th>
                                        <th>Revenue (&#8377;)</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @forelse($productBreakdown as $row)
                                        <tr>
                                            <td class="text-start">
                                                {{ $row->business_name ?? $row->vendor_name ?? ('Vendor #' . $row->vendor_id) }}
                                            </td>
                                            <td class="text-start">
                                                <strong>{{ $row->product_name ?? ('Product #' . $row->product_id) }}</strong>
                                            </td>
                                            <td>{{ $row->qty_sold }}</td>
                                            <td><strong>&#8377;{{ number_format($row->revenue, 2) }}</strong></td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="4" class="text-center text-muted py-4">
                                                <i class="bi bi-inbox"></i> No attributed product sales found.
                                            </td>
                                        </tr>
                                    @endforelse
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        @endif

    </div>
</div>
@endsection