@push('title')
    Inventory Report
@endpush

<x-app-layout>
    <div class="row mb-4">
        <div class="col-12">
            <div class="card">
                <div class="card-header d-flex justify-content-between align-items-center">
                    <h5 class="mb-0">Inventory Report</h5>
                    <div class="dropdown">
                        <button class="btn btn-secondary dropdown-toggle" type="button" id="exportDropdown"
                            data-bs-toggle="dropdown" aria-expanded="false">
                            <i class="bx bx-export me-1"></i> Export
                        </button>
                        <ul class="dropdown-menu" aria-labelledby="exportDropdown">
                            <li><a class="dropdown-item"
                                    href="{{ request()->fullUrlWithQuery(['export' => 'csv']) }}"><i
                                        class="bx bx-file me-2"></i>Export as CSV</a></li>
                            <li><a class="dropdown-item"
                                    href="{{ request()->fullUrlWithQuery(['export' => 'excel']) }}"><i
                                        class="bx bx-spreadsheet me-2"></i>Export as Excel</a></li>
                        </ul>
                    </div>
                </div>
                <div class="card-body">
                    <form action="{{ route('reports.inventory') }}" method="GET" class="row g-3">
                        <div class="col-md-4">
                            <label class="form-label">Search Product</label>
                            <input type="text" name="search" class="form-control" placeholder="Name or Code..."
                                value="{{ request('search') }}">
                        </div>
                        <div class="col-md-3">
                            <label class="form-label">Warehouse</label>
                            <select name="warehouse_id" class="form-select">
                                <option value="">All Warehouses</option>
                                @foreach($warehouses as $warehouse)
                                    <option value="{{ $warehouse->id }}" {{ request('warehouse_id') == $warehouse->id ? 'selected' : '' }}>
                                        {{ $warehouse->name }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-2 d-flex align-items-center mt-4">
                            <div class="form-check">
                                <input class="form-check-input" type="checkbox" name="low_stock" id="lowStockCheck" {{ request()->has('low_stock') ? 'checked' : '' }}>
                                <label class="form-check-label" for="lowStockCheck"> Low Stock Only </label>
                            </div>
                        </div>
                        <div class="col-md-3 d-flex align-items-end">
                            <button type="submit" class="btn btn-primary me-2 w-100">Filter</button>
                            <a href="{{ route('reports.inventory') }}" class="btn btn-label-secondary w-100">Reset</a>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>

    <!-- Summary Stats -->
    <div class="row mb-4">
        <div class="col-md-4">
            <div class="card ">
                <div class="card-body text-center">
                    <div class="avatar mx-auto mb-2">
                        <span class="avatar-initial rounded bg-label-primary"><i class="bx bx-package"></i></span>
                    </div>
                    <h5 class="mb-1">{{ number_format($summary['total_items']) }}</h5>
                    <p class="mb-0 text-muted">Total Items in Stock</p>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card ">
                <div class="card-body text-center">
                    <div class="avatar mx-auto mb-2">
                        <span class="avatar-initial rounded bg-label-success"><i class="bx bx-dollar"></i></span>
                    </div>
                    <h5 class="mb-1">{{ number_format($summary['total_cost_value'], 2) }}</h5>
                    <p class="mb-0 text-muted">Stock Value (Cost)</p>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card ">
                <div class="card-body text-center">
                    <div class="avatar mx-auto mb-2">
                        <span class="avatar-initial rounded bg-label-info"><i class="bx bx-trending-up"></i></span>
                    </div>
                    <h5 class="mb-1">{{ number_format($summary['total_retail_value'], 2) }}</h5>
                    <p class="mb-0 text-muted">Stock Value (Retail)</p>
                </div>
            </div>
        </div>
    </div>

    <!-- Inventory Table -->
    <div class="card">
        <div class="table-responsive text-nowrap">
            <table class="table table-striped table-borderless">
                <thead class="table-dark">
                    <tr>
                        <th>Product</th>
                        <th>Warehouse</th>
                        <th>Batch</th>
                        <th class="text-center">Qty</th>
                        <th class="text-center">Alert Limit</th>
                        <th class="text-end">Cost</th>
                        <th class="text-end">Wholesale</th>
                        <th class="text-end">Retail</th>
                        <th class="text-end">Total Cost</th>
                    </tr>
                </thead>
                <tbody class="table-border-bottom-0">
                    @forelse($inventory as $batch)
                        <tr>
                            <td>
                                <div class="d-flex flex-column">
                                    <span class="fw-medium text-heading">{{ $batch->product->name }}</span>
                                    <small class="text-muted">{{ $batch->product->code }}
                                        @if($batch->productVariation->variationType)
                                            | {{ $batch->productVariation->variationType->name }}
                                        @endif
                                    </small>
                                </div>
                            </td>
                            <td>{{ $batch->warehouse->name ?? 'N/A' }}</td>
                            <td><span class="badge bg-label-secondary">{{ $batch->batch_no }}</span></td>
                            <td class="text-center">
                                <span class="fw-bold {{ $batch->current_stock <= $batch->productVariation->stock_alert ? 'text-danger' : 'text-success' }}">
                                    {{ $batch->current_stock }}
                                </span>
                            </td>
                            <td class="text-center">
                                <span class="badge bg-label-warning">{{ $batch->productVariation->stock_alert }}</span>
                            </td>
                            <td class="text-end">{{ number_format($batch->cost_price, 2) }}</td>
                            <td class="text-end text-primary">{{ number_format($batch->wholesale_price, 2) }}</td>
                            <td class="text-end">{{ number_format($batch->retail_price, 2) }}</td>
                            <td class="text-end fw-bold">{{ number_format($batch->current_stock * $batch->cost_price, 2) }}
                            </td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="7" class="text-center py-4 text-muted">No inventory records found.</td>
                        </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
        <div class="card-footer px-3">
            {{ $inventory->links() }}
        </div>
    </div>
</x-app-layout>