@extends('vendor.layout.app')

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

@section('content')
<div class="content-wrapper">
    <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">My Sales Report</h2>
            </div>
        </div>

        <form method="GET" action="{{ route('vendor.products.salesreport') }}" 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-4">
                            <label class="form-label">Start Date</label>
                            <input type="date" name="start_date" class="form-control" value="{{ $startDate }}" required>
                        </div>
                        <div class="col-md-4">
                            <label class="form-label">End Date</label>
                            <input type="date" name="end_date" class="form-control" value="{{ $endDate }}" required>
                        </div>
                        <div class="col-md-4">
                            <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('vendor.products.salesreport') }}" class="btn btn-secondary btn-sm">
                                <i class="bi bi-x-circle me-1"></i>Reset
                            </a>
                        </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-4">
                                <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-4">
                                <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-4">
                                <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>

        @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 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">Product 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 class="text-start">Product</th>
                                        <th>SKU</th>
                                        <th>Qty Sold</th>
                                        <th>Revenue (&#8377;)</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @forelse($productBreakdown as $row)
                                        <tr>
                                            <td class="text-start">
                                                <strong>{{ $row->product_name ?? ('Product #' . $row->vendor_product_id) }}</strong>
                                            </td>
                                            <td>{{ $row->sku ?? '-' }}</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 product sales found.
                                            </td>
                                        </tr>
                                    @endforelse
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        @endif

        @if($orderLines->count() > 0)
        <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">Order Details</h5>
                        <small class="text-muted">Showing {{ $orderLines->count() }} of {{ $orderLines->total() }} orders</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>Order #</th>
                                        <th>Date</th>
                                        <th class="text-start">Product</th>
                                        <th>SKU</th>
                                        <th>Qty</th>
                                        <th>Price (&#8377;)</th>
                                        <th>Total (&#8377;)</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach($orderLines as $order)
                                        <tr>
                                            <td>{{ $order->order_number ?? ('Order #' . $order->order_id) }}</td>
                                            <td>{{ \Carbon\Carbon::parse($order->created_at)->format('d M Y') }}</td>
                                            <td class="text-start">
                                                <strong>{{ $order->product_name ?? ('Product #' . $order->vendor_product_id) }}</strong>
                                            </td>
                                            <td>{{ $order->sku ?? '-' }}</td>
                                            <td>{{ $order->quantity }}</td>
                                            <td>&#8377;{{ number_format($order->price, 2) }}</td>
                                            <td><strong>&#8377:{{ number_format($order->total, 2) }}</strong></td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                        <div class="mt-3">
                            {{ $orderLines->appends(request()->query())->links() }}
                        </div>
                    </div>
                </div>
            </div>
        </div>
        @endif

    </div>
</div>
@endsection