@extends('layouts.app')

@section('title', 'Inventario Valorado')

@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-dollar-sign me-2"></i>Inventario Valorado
                </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.valued-inventory', 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 d-flex justify-content-between align-items-center">
            <h5 class="mb-0">
                <i class="fas fa-filter me-2"></i>Filtros
            </h5>
            <div>
                @if(auth()->check())
                    <select id="savedFilters" class="form-select form-select-sm d-inline-block" style="width: auto;">
                        <option value="">Filtros Guardados</option>
                    </select>
                    <button type="button" class="btn btn-sm btn-info" data-bs-toggle="modal" data-bs-target="#saveFilterModal">
                        <i class="fas fa-save me-1"></i>Guardar Filtros
                    </button>
                @endif
            </div>
        </div>
        <div class="card-body">
            <form method="GET" action="{{ route('admin.inventory.reports.valued-inventory') }}" id="filterForm" class="row g-3">
                <div class="col-md-3">
                    <label for="warehouse_name" class="form-label">Almacén</label>
                    <select name="warehouse_name" id="warehouse_name" class="form-select">
                        <option value="">Todos los Almacenes</option>
                        @foreach($warehouses as $w)
                            <option value="{{ $w->name }}" {{ request('warehouse_name') == $w->name ? 'selected' : '' }}>
                                {{ $w->name }}
                            </option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-3">
                    <label for="category_id" class="form-label">Categoría</label>
                    <select name="category_id" id="category_id" class="form-select">
                        <option value="">Todas las Categorías</option>
                        @foreach($categories as $c)
                            <option value="{{ $c->id }}" {{ request('category_id') == $c->id ? 'selected' : '' }}>
                                {{ $c->name }}
                            </option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-4">
                    <label for="search" class="form-label">Búsqueda Avanzada</label>
                    <input type="text" class="form-control" id="search" name="search" 
                           value="{{ request('search') }}" 
                           placeholder="Buscar por producto, SKU, código, categoría, marca...">
                    <small class="text-muted">Busca en nombre, SKU, código, categoría o marca del producto</small>
                </div>
                <div class="col-md-2 d-flex align-items-end">
                    <button type="submit" class="btn btn-primary me-2 w-100">
                        <i class="fas fa-search me-2"></i>Buscar
                    </button>
                </div>
                <div class="col-12">
                    <a href="{{ route('admin.inventory.reports.valued-inventory') }}" class="btn btn-secondary btn-sm">
                        <i class="fas fa-redo me-2"></i>Limpiar Filtros
                    </a>
                </div>
            </form>
        </div>
    </div>

    <!-- Modal para guardar filtros -->
    @if(auth()->check())
    <div class="modal fade" id="saveFilterModal" tabindex="-1">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Guardar Filtros</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>
                <form id="saveFilterForm">
                    @csrf
                    <div class="modal-body">
                        <input type="hidden" name="report_type" value="valued-inventory">
                        <div class="mb-3">
                            <label for="filter_name" class="form-label">Nombre del Filtro</label>
                            <input type="text" class="form-control" id="filter_name" name="name" required>
                        </div>
                        <div class="mb-3">
                            <label for="filter_description" class="form-label">Descripción (opcional)</label>
                            <textarea class="form-control" id="filter_description" name="description" rows="2"></textarea>
                        </div>
                        <div class="form-check">
                            <input class="form-check-input" type="checkbox" id="is_default" name="is_default" value="1">
                            <label class="form-check-label" for="is_default">
                                Establecer como predeterminado
                            </label>
                        </div>
                        <div class="form-check">
                            <input class="form-check-input" type="checkbox" id="is_shared" name="is_shared" value="1">
                            <label class="form-check-label" for="is_shared">
                                Compartir con otros usuarios
                            </label>
                        </div>
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancelar</button>
                        <button type="submit" class="btn btn-primary">Guardar</button>
                    </div>
                </form>
            </div>
        </div>
    </div>
    @endif

    <!-- Resumen -->
    <div class="card shadow-sm mb-4">
        <div class="card-header bg-success text-white">
            <h5 class="mb-0">
                <i class="fas fa-chart-pie me-2"></i>Resumen del Inventario
            </h5>
        </div>
        <div class="card-body">
            <div class="row text-center">
                <div class="col-md-4">
                    <h3 class="text-success mb-0">${{ number_format($totalValue, 2) }}</h3>
                    <p class="text-muted mb-0">Valor Total del Inventario</p>
                </div>
                <div class="col-md-4">
                    <h3 class="text-primary mb-0">{{ count($inventory) }}</h3>
                    <p class="text-muted mb-0">Productos con Stock</p>
                </div>
                <div class="col-md-4">
                    <h3 class="text-info mb-0">{{ number_format(array_sum(array_column($inventory, 'quantity')), 2) }}</h3>
                    <p class="text-muted mb-0">Unidades Totales</p>
                </div>
            </div>
        </div>
    </div>

    <!-- Tabla de Inventario -->
    <div class="card shadow-sm">
        <div class="card-header bg-light">
            <h5 class="mb-0">
                <i class="fas fa-list me-2"></i>Detalle del Inventario Valorado
            </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>#</th>
                            <th>Producto</th>
                            <th>SKU</th>
                            <th>Categoría</th>
                            <th>Almacén</th>
                            <th>Ubicación</th>
                            <th class="text-end">Cantidad</th>
                            <th class="text-end">Costo Unitario</th>
                            <th class="text-end">Valor Total</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($inventory as $index => $item)
                            <tr>
                                <td>{{ $index + 1 }}</td>
                                <td>
                                    <strong>{{ $item['product']->name }}</strong>
                                    @if($item['product']->brand)
                                        <br><small class="text-muted">{{ $item['product']->brand->name }}</small>
                                    @endif
                                </td>
                                <td>{{ $item['product']->sku ?? 'N/A' }}</td>
                                <td>{{ $item['product']->category->name ?? 'N/A' }}</td>
                                <td>{{ $item['warehouse'] }}</td>
                                <td>{{ $item['location'] ?? 'N/A' }}</td>
                                <td class="text-end">{{ number_format($item['quantity'], 2) }}</td>
                                <td class="text-end">${{ number_format($item['unit_cost'], 2) }}</td>
                                <td class="text-end">
                                    <strong>${{ number_format($item['total_value'], 2) }}</strong>
                                </td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="9" class="text-center py-4">
                                    <i class="fas fa-info-circle me-2"></i>No se encontraron productos con stock en el inventario.
                                </td>
                            </tr>
                        @endforelse
                    </tbody>
                    @if(count($inventory) > 0)
                    <tfoot class="table-light">
                        <tr>
                            <th colspan="6" class="text-end">Totales:</th>
                            <th class="text-end">{{ number_format(array_sum(array_column($inventory, 'quantity')), 2) }}</th>
                            <th class="text-end">-</th>
                            <th class="text-end">${{ number_format($totalValue, 2) }}</th>
                        </tr>
                    </tfoot>
                    @endif
                </table>
            </div>
        </div>
    </div>
</div>

<style>
    @media print {
        .btn, .card-header, .navbar, .sidebar {
            display: none !important;
        }
        .card {
            border: none !important;
            box-shadow: none !important;
        }
    }
</style>

@push('scripts')
<script>
    $(document).ready(function() {
        const reportType = 'valued-inventory';
        const filterForm = $('#filterForm');
        const savedFiltersSelect = $('#savedFilters');
        const currentUserId = {{ auth()->id() ?? 0 }};

        // Cargar filtros guardados
        function loadSavedFilters() {
            fetch(`{{ url('admin/saved-report-filters') }}?report_type=${reportType}`, {
                headers: {
                    'X-Requested-With': 'XMLHttpRequest',
                    'Accept': 'application/json',
                }
            })
            .then(response => response.json())
            .then(data => {
                savedFiltersSelect.empty();
                savedFiltersSelect.append('<option value="">Filtros Guardados</option>');
                
                if (data.filters && data.filters.length > 0) {
                    data.filters.forEach(filter => {
                        const isOwner = filter.user_id === currentUserId;
                        const option = $('<option>')
                            .val(filter.id)
                            .text(filter.name + (filter.is_default ? ' (Predeterminado)' : '') + (filter.is_shared ? ' [Compartido]' : ''));
                        savedFiltersSelect.append(option);
                    });
                } else {
                    savedFiltersSelect.append('<option value="">No hay filtros guardados</option>');
                }
            })
            .catch(error => {
                console.error('Error al cargar filtros:', error);
            });
        }

        // Aplicar filtro guardado
        savedFiltersSelect.on('change', function() {
            const filterId = $(this).val();
            if (filterId) {
                applyFilter(filterId);
            }
        });

        function applyFilter(filterId) {
            fetch(`{{ url('admin/saved-report-filters') }}/${filterId}/apply`, {
                headers: {
                    'X-Requested-With': 'XMLHttpRequest',
                    'Accept': 'application/json',
                }
            })
            .then(response => response.json())
            .then(data => {
                if (data.success && data.filters) {
                    Object.keys(data.filters).forEach(key => {
                        const field = filterForm.find(`[name="${key}"]`);
                        if (field.length) {
                            if (field.attr('type') === 'checkbox') {
                                field.prop('checked', data.filters[key]);
                            } else {
                                field.val(data.filters[key] || '');
                            }
                        }
                    });
                    filterForm.submit();
                }
            })
            .catch(error => {
                console.error('Error al aplicar filtro:', error);
                alert('Error al aplicar el filtro');
            });
        }

        // Guardar filtro
        $('#saveFilterForm').on('submit', function(e) {
            e.preventDefault();
            
            const formData = new FormData(this);
            const filters = {};
            
            // Recopilar todos los valores del formulario de filtros
            filterForm.find('input, select, textarea').each(function() {
                const field = $(this);
                const name = field.attr('name');
                if (name && name !== '_token') {
                    if (field.attr('type') === 'checkbox') {
                        if (field.is(':checked')) filters[name] = true;
                    } else if (field.val()) {
                        filters[name] = field.val();
                    }
                }
            });
            
            formData.append('filters', JSON.stringify(filters));
            formData.append('report_type', reportType);
            
            fetch('{{ route("admin.saved-report-filters.store") }}', {
                method: 'POST',
                headers: {
                    'X-Requested-With': 'XMLHttpRequest',
                    'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content'),
                    'Accept': 'application/json',
                },
                body: formData
            })
            .then(response => response.json())
            .then(data => {
                if (data.success) {
                    alert('Filtro guardado exitosamente');
                    $('#saveFilterModal').modal('hide');
                    $('#saveFilterForm')[0].reset();
                    loadSavedFilters();
                } else {
                    alert(data.message || 'Error al guardar el filtro');
                }
            })
            .catch(error => {
                console.error('Error al guardar filtro:', error);
                alert('Error al guardar el filtro');
            });
        });

        // Cargar filtros al iniciar
        loadSavedFilters();
    });
</script>
@endpush
@endsection