@extends('layouts.app')

@section('title', 'Kardex por Producto')

@section('content')
<div class="container-fluid">
    <div class="row mb-4">
        <div class="col-12">
            <div class="d-flex justify-content-between align-items-center">
                <h2 class="mb-0">
                    <i class="fas fa-book me-2"></i>Kardex por Producto
                </h2>
                <div>
                    <a href="{{ route('admin.inventory.reports') }}" class="btn btn-secondary">
                        <i class="fas fa-arrow-left me-2"></i>Volver a Reportes
                    </a>
                    <a href="{{ route('admin.inventory.reports.kardex', array_merge(request()->all(), ['export' => 'excel'])) }}" class="btn btn-success">
                        <i class="fas fa-file-excel me-2"></i>Exportar Excel
                    </a>
                    <button onclick="window.print()" class="btn btn-primary">
                        <i class="fas fa-print me-2"></i>Imprimir
                    </button>
                </div>
            </div>
        </div>
    </div>

    <!-- Filtros -->
    <div class="card shadow-sm mb-4">
        <div class="card-header bg-light">
            <h5 class="mb-0">
                <i class="fas fa-filter me-2"></i>Filtros
            </h5>
        </div>
        <div class="card-body">
            <form method="GET" action="{{ route('admin.inventory.reports.kardex') }}" class="row g-3">
                <div class="col-md-4">
                    <label for="product_search" class="form-label">Producto <span class="text-danger">*</span></label>
                    <div class="position-relative">
                        <input type="text" 
                               class="form-control" 
                               id="product_search" 
                               name="product_search" 
                               placeholder="Buscar producto por nombre, SKU o código..."
                               autocomplete="off"
                               value="{{ request('product_id') ? \App\Models\Product::find(request('product_id'))?->name . ' (' . (\App\Models\Product::find(request('product_id'))?->sku ?? 'N/A') . ')' : '' }}">
                        <input type="hidden" name="product_id" id="product_id" value="{{ request('product_id') }}" required>
                        <div id="product_search_results" class="list-group position-absolute w-100" style="z-index: 1000; max-height: 300px; overflow-y: auto; display: none;"></div>
                    </div>
                    <small class="text-muted">Escriba para buscar productos</small>
                </div>
                <div class="col-md-3">
                    <label for="date_from" class="form-label">Fecha Desde</label>
                    <input type="date" name="date_from" id="date_from" class="form-control" value="{{ request('date_from') }}">
                </div>
                <div class="col-md-3">
                    <label for="date_to" class="form-label">Fecha Hasta</label>
                    <input type="date" name="date_to" id="date_to" class="form-control" value="{{ request('date_to') }}">
                </div>
                <div class="col-md-2">
                    <label for="warehouse_name" class="form-label">Almacén</label>
                    <select name="warehouse_name" id="warehouse_name" class="form-select">
                        <option value="">Todos</option>
                        @foreach(\App\Models\Warehouse::all() as $w)
                            <option value="{{ $w->name }}" {{ request('warehouse_name') == $w->name ? 'selected' : '' }}>
                                {{ $w->name }}
                            </option>
                        @endforeach
                    </select>
                </div>
                <div class="col-12">
                    <button type="submit" class="btn btn-primary">
                        <i class="fas fa-search me-2"></i>Buscar
                    </button>
                    <a href="{{ route('admin.inventory.reports.kardex') }}" class="btn btn-secondary">
                        <i class="fas fa-redo me-2"></i>Limpiar
                    </a>
                </div>
            </form>
        </div>
    </div>

    @if(isset($product))
    <!-- Información del Producto -->
    <div class="card shadow-sm mb-4">
        <div class="card-header bg-primary text-white">
            <h5 class="mb-0">
                <i class="fas fa-box me-2"></i>Información del Producto
            </h5>
        </div>
        <div class="card-body">
            <div class="row">
                <div class="col-md-3">
                    <strong>Nombre:</strong> {{ $product->name }}
                </div>
                <div class="col-md-3">
                    <strong>SKU:</strong> {{ $product->sku ?? 'N/A' }}
                </div>
                <div class="col-md-3">
                    <strong>Categoría:</strong> {{ $product->category->name ?? 'N/A' }}
                </div>
                <div class="col-md-3">
                    <strong>Marca:</strong> {{ $product->brand->name ?? 'N/A' }}
                </div>
                <div class="col-md-3 mt-3">
                    <strong>Stock Actual:</strong> 
                    <span class="badge bg-{{ $currentStock > 0 ? 'success' : 'danger' }}">
                        {{ number_format($currentStock, 2) }}
                    </span>
                </div>
            </div>
        </div>
    </div>

    <!-- Tabla de Kardex -->
    <div class="card shadow-sm">
        <div class="card-header bg-light">
            <h5 class="mb-0">
                <i class="fas fa-list me-2"></i>Movimientos de Inventario
            </h5>
        </div>
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-bordered table-striped table-hover mb-0">
                    <thead class="table-dark">
                        <tr>
                            <th>Fecha</th>
                            <th>Tipo</th>
                            <th>Motivo</th>
                            <th>Referencia</th>
                            <th>Entrada</th>
                            <th>Salida</th>
                            <th>Saldo</th>
                            <th>Costo Unit.</th>
                            <th>Costo Total</th>
                            <th>Saldo Valor</th>
                            <th>Almacén</th>
                            <th>Usuario</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($kardex as $movement)
                            <tr>
                                <td>{{ $movement['date']->format('d/m/Y H:i') }}</td>
                                <td>
                                    <span class="badge bg-{{ $movement['type'] == 'entrada' ? 'success' : 'danger' }}">
                                        {{ ucfirst($movement['type']) }}
                                    </span>
                                </td>
                                <td>{{ $movement['reason'] ?? 'N/A' }}</td>
                                <td>{{ $movement['reference'] ?? 'N/A' }}</td>
                                <td class="text-end">{{ $movement['entry'] > 0 ? number_format($movement['entry'], 2) : '-' }}</td>
                                <td class="text-end">{{ $movement['exit'] > 0 ? number_format($movement['exit'], 2) : '-' }}</td>
                                <td class="text-end">
                                    <strong>{{ number_format($movement['balance'], 2) }}</strong>
                                </td>
                                <td class="text-end">${{ number_format($movement['unit_cost'], 2) }}</td>
                                <td class="text-end">${{ number_format($movement['total_cost'], 2) }}</td>
                                <td class="text-end">
                                    <strong>${{ number_format($movement['balance_value'], 2) }}</strong>
                                </td>
                                <td>{{ $movement['warehouse'] }}</td>
                                <td>{{ $movement['user'] }}</td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="12" class="text-center py-4">
                                    <i class="fas fa-info-circle me-2"></i>No se encontraron movimientos en el período seleccionado.
                                </td>
                            </tr>
                        @endforelse
                    </tbody>
                    @if(count($kardex) > 0)
                    <tfoot class="table-light">
                        <tr>
                            <th colspan="6" class="text-end">Totales:</th>
                            <th class="text-end">{{ number_format(array_sum(array_column($kardex, 'entry')) - array_sum(array_column($kardex, 'exit')), 2) }}</th>
                            <th colspan="2" class="text-end">Total Movimientos:</th>
                            <th class="text-end">${{ number_format(array_sum(array_column($kardex, 'total_cost')), 2) }}</th>
                            <th class="text-end">${{ number_format(end($kardex)['balance_value'] ?? 0, 2) }}</th>
                            <th colspan="2"></th>
                        </tr>
                    </tfoot>
                    @endif
                </table>
            </div>
        </div>
    </div>
    @endif
</div>

<style>
    @media print {
        .btn, .card-header, .navbar, .sidebar {
            display: none !important;
        }
        .card {
            border: none !important;
            box-shadow: none !important;
        }
    }
    
    #product_search_results {
        border: 1px solid #ddd;
        border-radius: 0.375rem;
        background: white;
        box-shadow: 0 0.5rem 1rem rgba(0, 0, 0, 0.15);
        margin-top: 2px;
    }
    
    #product_search_results .list-group-item {
        cursor: pointer;
        border: none;
        border-bottom: 1px solid #eee;
    }
    
    #product_search_results .list-group-item:hover {
        background-color: #f8f9fa;
    }
    
    #product_search_results .list-group-item:last-child {
        border-bottom: none;
    }
</style>

@push('scripts')
<script>
$(document).ready(function() {
    let searchTimer = null;
    const searchInput = $('#product_search');
    const productIdInput = $('#product_id');
    const resultsDiv = $('#product_search_results');
    
    // Obtener producto seleccionado si existe
    @if(request('product_id'))
        const selectedProduct = @json(\App\Models\Product::with('category', 'brand')->find(request('product_id')));
        if (selectedProduct) {
            searchInput.val(selectedProduct.name + ' (' + (selectedProduct.sku || 'N/A') + ')');
        }
    @endif
    
    // Búsqueda mientras escribe
    searchInput.on('input', function() {
        const query = $(this).val().trim();
        
        clearTimeout(searchTimer);
        
        if (query.length < 2) {
            resultsDiv.hide().empty();
            productIdInput.val('');
            return;
        }
        
        searchTimer = setTimeout(function() {
            searchProducts(query);
        }, 300);
    });
    
    // Ocultar resultados al hacer clic fuera
    $(document).on('click', function(e) {
        if (!$(e.target).closest('#product_search, #product_search_results').length) {
            resultsDiv.hide();
        }
    });
    
    // Función para buscar productos
    function searchProducts(query) {
        $.ajax({
            url: '{{ route("admin.inventory.products.search") }}',
            method: 'GET',
            data: { q: query },
            headers: {
                'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content'),
                'Accept': 'application/json'
            },
            success: function(products) {
                displayProducts(products);
            },
            error: function(xhr) {
                console.error('Error al buscar productos:', xhr);
                resultsDiv.html('<div class="list-group-item text-danger">Error al buscar productos</div>').show();
            }
        });
    }
    
    // Función para mostrar productos
    function displayProducts(products) {
        if (!products || products.length === 0) {
            resultsDiv.html('<div class="list-group-item text-muted">No se encontraron productos</div>').show();
            return;
        }
        
        let html = '';
        products.forEach(function(product) {
            const sku = product.sku || product.code || 'N/A';
            const category = product.category ? product.category.name : '';
            html += `
                <div class="list-group-item" data-id="${product.id}" data-name="${product.name}" data-sku="${sku}">
                    <div class="d-flex justify-content-between align-items-start">
                        <div>
                            <strong>${product.name}</strong>
                            <br>
                            <small class="text-muted">SKU: ${sku}</small>
                            ${category ? '<br><small class="text-muted">Categoría: ' + category + '</small>' : ''}
                        </div>
                    </div>
                </div>
            `;
        });
        
        resultsDiv.html(html).show();
        
        // Manejar clic en un producto
        resultsDiv.find('.list-group-item').on('click', function() {
            const productId = $(this).data('id');
            const productName = $(this).data('name');
            const productSku = $(this).data('sku');
            
            productIdInput.val(productId);
            searchInput.val(productName + ' (' + productSku + ')');
            resultsDiv.hide();
        });
    }
    
    // Limpiar búsqueda
    $('a[href="{{ route("admin.inventory.reports.kardex") }}"]').on('click', function(e) {
        searchInput.val('');
        productIdInput.val('');
        resultsDiv.hide().empty();
    });
});
</script>
@endpush
@endsection