@extends('backoffice.layouts.app')

@section('content')
    <div class="d-flex justify-content-between flex-wrap flex-md-nowrap align-items-center py-4">
        <div>
            <h2 class="h4">Product Report</h2>
        </div>
    </div>

    <form action="{{ route('admin.report.products') }}" method="GET" class="row g-3 mb-4">
        <div class="col-md-3">
            <label for="product_id" class="form-label">Product</label>
            <select class="form-select" name="product_id" id="product_id">
                <option value="">-- All Products --</option>
                @foreach ($productList as $product)
                    <option value="{{ $product->product_id }}"
                        {{ request('product_id') == $product->product_id ? 'selected' : '' }}>
                        {{ $product->name }}
                    </option>
                @endforeach
            </select>
        </div>

        <div class="col-md-3">
            <label for="start_date" class="form-label">Start Date</label>
            <input type="date" name="start_date" id="start_date" class="form-control"
                value="{{ request('start_date') }}">
        </div>

        <div class="col-md-3">
            <label for="end_date" class="form-label">End Date</label>
            <input type="date" name="end_date" id="end_date" class="form-control" value="{{ request('end_date') }}">
        </div>

        <div class="col-md-3 align-self-end">
            <button type="submit" class="btn btn-primary">Search</button>
            <a href="{{ route('admin.report.products') }}" class="btn btn-secondary">Reset</a>
        </div>
    </form>



    <div class="card card-body border-0 shadow-sm mb-4">
        <h5 class="mb-3">Product Report Summary</h5>
        <div class="row">
            <div class="col-md-4">
                <div class="text-muted">Total Products</div>
                <h5 class="fw-bold">{{ $totals['total_products'] }}</h5>
            </div>
            <div class="col-md-4">
                <div class="text-muted">Total Quantity</div>
                <h5 class="fw-bold">{{ $totals['total_quantity'] }}</h5>
            </div>
            <div class="col-md-4">
                <div class="text-muted">Total Price</div>
                <h5 class="fw-bold">${{ number_format($totals['total_price'], 2) }}</h5>
            </div>
        </div>
    </div>

    <div class="card card-body border-0 shadow table-wrapper table-responsive">
        <table class="table table-hover">
            <thead>
                <tr>
                    <th>#</th>
                    <th>Product Name</th>
                    <th>Total Quantity</th>
                    <th>Total Price</th>
                </tr>
            </thead>
            <tbody>
                @forelse ($groupedItems as $index => $item)
                    <tr>
                        <td>{{ $index + $groupedItems->firstItem() }}</td>
                        <td>{{ $item->name }}</td>
                        <td>{{ $item->total_qty }}</td>
                        <td>${{ number_format($item->total_price, 2) }}</td>
                    </tr>
                @empty
                    <tr>
                        <td colspan="4" class="text-center">No products found.</td>
                    </tr>
                @endforelse
            </tbody>
        </table>

        <div class="card-footer px-3 border-0 d-flex flex-column flex-lg-row align-items-center justify-content-between">
            <nav aria-label="Page navigation example">
                <ul class="pagination mb-0">
                    <!-- Previous Page Link -->
                    @if ($groupedItems->onFirstPage())
                        <li class="page-item disabled">
                            <span class="page-link">Previous</span>
                        </li>
                    @else
                        <li class="page-item">
                            <a class="page-link" href="{{ $groupedItems->previousPageUrl() }}">Previous</a>
                        </li>
                    @endif

                    <!-- Page Numbers -->
                    @foreach ($groupedItems->getUrlRange(1, $groupedItems->lastPage()) as $page => $url)
                        <li class="page-item {{ $page == $groupedItems->currentPage() ? 'active' : '' }}">
                            <a class="page-link" href="{{ $url }}">{{ $page }}</a>
                        </li>
                    @endforeach

                    <!-- Next Page Link -->
                    @if ($groupedItems->hasMorePages())
                        <li class="page-item">
                            <a class="page-link" href="{{ $groupedItems->nextPageUrl() }}">Next</a>
                        </li>
                    @else
                        <li class="page-item disabled">
                            <span class="page-link">Next</span>
                        </li>
                    @endif
                </ul>
            </nav>

            <!-- Pagination Summary -->
            <div class="fw-normal small mt-4 mt-lg-0">
                Showing <b>{{ $groupedItems->firstItem() }}</b> to <b>{{ $groupedItems->lastItem() }}</b> of
                <b>{{ $groupedItems->total() }}</b> entries
            </div>
        </div>

    </div>
@endsection