@push('title')
    Products
@endpush
<x-app-layout>
    @can('create_product_management')
        <div class="row">
            <div class="col-md-12">
                <ul class="nav nav-pills flex-column flex-sm-row mb-4">
                    <li class="nav-item mr-1">
                        <a class="btn btn-success" href="{{ route('products.create') }}">
                            <i class='bx bxs-add-to-queue'></i> Add Product
                        </a>
                    </li>
                    <li class="nav-item mr-1">
                        <button type="button" class="btn btn-secondary ms-2" data-bs-toggle="modal" data-bs-target="#importExcelModal">
                            <i class='bx bx-import'></i> Bulk Import
                        </button>
                    </li>
                    <li class="nav-item mr-1">
                        <a class="btn btn-outline-info ms-2" href="{{ route('products.import_logs') }}">
                            <i class='bx bx-history'></i> Import Logs
                        </a>
                    </li>
                </ul>
            </div>
        </div>
    @endcan

    <div class="card">
        <div class="card-header">
            <h5 class="card-title">Products</h5>
        </div>
        <div class="card-body">

            <div class="row mb-3">
                <div class="col-md-12">
                    <form action="{{ route('products') }}" method="GET">
                        <div class="row">
                            <div class="col-md-3">
                                <label for="name" class="form-label">Product Name</label>
                                <input type="text" class="form-control" id="name" name="name"
                                    value="{{ request('name') }}">
                            </div>
                            <div class="col-md-3">
                                <label for="code" class="form-label">Product Code</label>
                                <input type="text" class="form-control" id="code" name="code"
                                    value="{{ request('code') }}">
                            </div>
                            <div class="col-md-2">
                                <label for="brand_id" class="form-label">Brand</label>
                                <select class="form-control" id="brand_id" name="brand_id">
                                    <option value="">All</option>
                                    @foreach ($brands as $brand)
                                        <option value="{{ $brand->id }}" {{ request('brand_id') == $brand->id ? 'selected' : '' }}>{{ $brand->name }}</option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="col-md-2">
                                <label for="category_id" class="form-label">Category</label>
                                <select class="form-control" id="category_id" name="category_id">
                                    <option value="">All</option>
                                    @foreach ($categories as $category)
                                        <option value="{{ $category->id }}" {{ request('category_id') == $category->id ? 'selected' : '' }}>{{ $category->name }}</option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="col-md-2">
                                <label for="base_unit_id" class="form-label">Base Unit</label>
                                <select class="form-control" id="base_unit_id" name="base_unit_id">
                                    <option value="">All</option>
                                    @foreach ($baseUnits as $baseUnit)
                                        <option value="{{ $baseUnit->id }}" {{ request('base_unit_id') == $baseUnit->id ? 'selected' : '' }}>{{ $baseUnit->name }}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                        <div class="row mt-3">
                            <div class="col-md-3">
                                <label for="warehouse_id" class="form-label">Warehouse</label>
                                <select class="form-control" id="warehouse_id" name="warehouse_id">
                                    <option value="">All</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-3">
                                <label for="barcode" class="form-label">Barcode</label>
                                <input type="text" class="form-control" id="barcode" name="barcode"
                                    value="{{ request('barcode') }}" placeholder="Enter barcode...">
                            </div>
                            <div class="col-md-3">
                                <label for="supplier_id" class="form-label">Supplier</label>
                                <select class="form-control" id="supplier_id" name="supplier_id">
                                    <option value="">All</option>
                                    @foreach ($suppliers as $supplier)
                                        <option value="{{ $supplier->id }}" {{ request('supplier_id') == $supplier->id ? 'selected' : '' }}>{{ $supplier->name }}</option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="col-md-3 d-flex align-items-end justify-content-end sm-mt-2 mt-3">
                                <button type="submit" class="btn btn-primary">Apply Filters</button>
                                <a href="{{ route('products') }}" class="btn btn-secondary ms-2">Reset</a>
                            </div>
                        </div>

                    </form>
                </div>
            </div>
            <div class="table-responsive text-wrap">

                <table class="table table-striped table-borderless">
                    <thead class="table-dark">
                        <tr>
                            <th>Name</th>
                            <th>Code</th>
                            <th>Warehouse</th>
                            <th>Brand</th>
                            <th>Price ( Retail )</th>
                            <th>Price ( Wholesale )</th>
                            <th>Product Unit</th>
                            <th>In Stock</th>
                            <th>Created At</th>
                            <th class="text-end">Action</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($products as $product)
                            <tr>
                                <td>{{ $product->name }}</td>
                                <td>{{ $product->code }}</td>
                                <td>
                                    @if($product->product_type == \App\Models\Product::VARIATION)
                                        @foreach ($product->variations as $variation)
                                            @foreach($variation->batches->where('status', 'active') as $batch)
                                                <span class="badge bg-primary">{{ $batch->warehouse->name ?? 'N/A' }}</span><br>
                                            @endforeach
                                        @endforeach
                                    @else
                                        @foreach($product->batches->where('status', 'active') as $batch)
                                            <span class="badge bg-primary">{{ $batch->warehouse->name ?? 'N/A' }}</span><br>
                                        @endforeach
                                    @endif
                                </td>
                                <td>{{ $product->brand?->name ?? 'N/A' }}</td>
                                <td>
                                    @if($product->product_type == \App\Models\Product::VARIATION)
                                        @foreach ($product->variations as $variation)
                                            @foreach($variation->batches->where('status', 'active') as $batch)
                                                <span class="badge bg-primary">{{ $batch->batch_no }}
                                                    -{{ $variation?->variationType?->name ?? 'N/A' }} - {{ $batch->retail_price }} LKR</span><br>
                                            @endforeach
                                        @endforeach
                                    @else
                                        @foreach($product->batches->where('status', 'active') as $batch)
                                            <span class="badge bg-primary">{{ $batch->batch_no }} - {{ $batch->retail_price }}
                                                LKR</span><br>
                                        @endforeach
                                    @endif
                                </td>
                                <td>
                                    @if($product->product_type == \App\Models\Product::VARIATION)
                                        @foreach ($product->variations as $variation)
                                            @foreach($variation->batches->where('status', 'active') as $batch)
                                                <span class="badge bg-primary">{{ $batch->batch_no }}
                                                    -{{ $variation?->variationType?->name ?? 'N/A' }} - {{ $batch->wholesale_price }}
                                                    LKR</span><br>
                                            @endforeach
                                        @endforeach
                                    @else
                                        @foreach($product->batches->where('status', 'active') as $batch)
                                            <span class="badge bg-primary">{{ $batch->batch_no }} - {{ $batch->wholesale_price }}
                                                LKR</span><br>
                                        @endforeach
                                    @endif
                                </td>
                                <td>{{ $product->baseUnit?->name ?? 'N/A' }}</td>
                                <td>
                                    @if($product->product_type == \App\Models\Product::VARIATION)
                                        @foreach ($product->variations as $variation)
                                            @foreach($variation->batches->where('status', 'active') as $batch)
                                                <span class="badge bg-primary">{{ $batch->batch_no }}
                                                    -{{ $variation?->variationType?->name ?? 'N/A' }} - {{ $batch->current_stock }}</span><br>
                                            @endforeach
                                        @endforeach
                                    @else
                                        @foreach($product->batches->where('status', 'active') as $batch)
                                            <span class="badge bg-primary">{{ $batch->batch_no }} -
                                                {{ $batch->current_stock }}</span><br>
                                        @endforeach
                                    @endif
                                </td>
                                <td>{{ $product->created_at->format('Y-m-d') }}</td>
                                <td class="text-right text-nowrap justify-content-end pr-0"
                                    style="display: table-cell !important;text-align: right !important;">
                                    @can('view_product_management')
                                        <a href="{{ route('products.show', $product->id) }}"
                                            class="btn btn-icon btn-success mr-1 mb-1">
                                            <i class="bx bx-show"></i>
                                        </a>
                                    @endcan
                                    @can('update_product_management')
                                        <a href="{{ route('products.edit', ['id' => $product->id]) }}"
                                            class="btn btn-icon btn-info mr-1 mb-1">
                                            <i class="bx bx-pencil"></i>
                                        </a>
                                    @endcan
                                    @can('delete_product_management')
                                        <button type="button" class="btn btn-icon btn-danger mr-1 mb-1" data-bs-toggle="modal"
                                            data-bs-target="#productModel-{{ $product->id }}"><i
                                                class="bx bx-trash"></i></button>
                                    @endcan
                                </td>
                            </tr>
                            <div class="modal fade" id="productModel-{{ $product->id }}" tabindex="-1" aria-hidden="true">
                                <div class="modal-dialog modal-simple modal-enable-otp modal-dialog-centered">
                                    <div class="modal-content">
                                        <div class="modal-body text-center">
                                            <button type="button" class="btn-close" data-bs-dismiss="modal"
                                                aria-label="Close"></button>
                                            <h3>Warning</h3>
                                            <p class="mt-3">Are you sure you want to delete this product?</p>
                                            <p class="mt-2">Product Name :- {{ $product->name ?? 'N/A' }} </p>
                                            <p class="text-danger text-center"><strong>This action cannot be
                                                    undone!</strong></p>
                                            <form action="{{ route('products.destroy', ['id' => $product->id]) }}"
                                                method="POST">
                                                @csrf
                                                @method('DELETE')
                                                <button type="submit" class="btn btn-danger">Delete Product</button>
                                            </form>
                                            <button type="button" class="btn btn-secondary"
                                                data-bs-dismiss="modal">Cancel</button>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        @empty
                            <tr>
                                <td colspan="9" class="text-center">No products found</td>
                            </tr>
                        @endforelse
                    </tbody>
                </table>

                <div class="mt-4">
                    {{ $products->withQueryString()->links() }}
                </div>
            </div>
        </div>
    </div>

    <!-- Bulk Import Modal -->
    <div class="modal fade" id="importExcelModal" tabindex="-1" aria-hidden="true">
        <div class="modal-dialog modal-dialog-centered">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Bulk Import Products</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body">
                    <p><b>Step 1:</b> Download the latest template containing all active system lists.</p>
                    <a href="{{ route('products.template') }}" class="btn btn-outline-primary mb-4">
                        <i class='bx bx-download'></i> Download Template
                    </a>
                    
                    <hr>
                    
                    <p><b>Step 2:</b> Fill the template according to instructions and upload it.</p>
                    <form action="{{ route('products.import') }}" method="POST" enctype="multipart/form-data">
                        @csrf
                        <div class="mb-3 text-start">
                            <label for="import_file" class="form-label">Upload Filled Excel File</label>
                            <input class="form-control" type="file" id="import_file" name="import_file" accept=".xlsx, .xls" required>
                        </div>
                        <button type="submit" class="btn btn-primary w-100">Upload & Import</button>
                    </form>
                </div>
            </div>
        </div>
    </div>
</x-app-layout>