@extends('layouts.app')

@section('title', 'Productos Obsoletos')

@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-trash-alt me-2"></i>Productos Obsoletos
                </h2>
                <div>
                    {{-- Fixed route reference --}}
                    <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.obsolete-products', 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.obsolete-products') }}" class="row g-3">
                <div class="col-md-4">
                    <label for="days_threshold" class="form-label">Días sin Movimiento</label>
                    <input type="number" name="days_threshold" id="days_threshold" class="form-control" 
                           value="{{ $daysThreshold ?? 365 }}" min="1" required>
                    <small class="text-muted">Productos que no se han movido en los últimos X días</small>
                </div>
                <div class="col-md-8 d-flex align-items-end">
                    <button type="submit" class="btn btn-primary me-2">
                        <i class="fas fa-search me-2"></i>Buscar
                    </button>
                    <a href="{{ route('admin.inventory.reports.obsolete-products') }}" class="btn btn-secondary">
                        <i class="fas fa-redo me-2"></i>Limpiar
                    </a>
                </div>
            </form>
        </div>
    </div>

    <!-- Resumen -->
    <div class="card shadow-sm mb-4">
        <div class="card-header bg-danger text-white">
            <h5 class="mb-0">
                <i class="fas fa-exclamation-triangle me-2"></i>Resumen de Productos Obsoletos
            </h5>
        </div>
        <div class="card-body">
            <div class="row text-center">
                <div class="col-md-3">
                    <h3 class="text-danger mb-0">{{ count($obsoleteProducts) }}</h3>
                    <p class="text-muted mb-0">Productos Obsoletos</p>
                </div>
                <div class="col-md-3">
                    <h3 class="text-warning mb-0">{{ number_format($obsoleteProducts->sum('total_stock'), 2) }}</h3>
                    <p class="text-muted mb-0">Unidades en Stock</p>
                </div>
                <div class="col-md-3">
                    <h3 class="text-info mb-0">${{ number_format($obsoleteProducts->sum('total_value'), 2) }}</h3>
                    <p class="text-muted mb-0">Valor Total del Inventario</p>
                </div>
                <div class="col-md-3">
                    <h3 class="text-primary mb-0">{{ $daysThreshold }}</h3>
                    <p class="text-muted mb-0">Días sin Movimiento</p>
                </div>
            </div>
        </div>
    </div>

    <!-- Tabla de Productos Obsoletos -->
    <div class="card shadow-sm">
        <div class="card-header bg-light">
            <h5 class="mb-0">
                <i class="fas fa-list me-2"></i>Lista de Productos Obsoletos
            </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 class="text-end">Stock Total</th>
                            <th class="text-end">Costo Promedio</th>
                            <th class="text-end">Valor Total</th>
                            <th>Último Movimiento</th>
                            <th>Última Venta</th>
                            <th class="text-end">Días sin Movimiento</th>
                            <th class="text-end">Días sin Venta</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($obsoleteProducts as $index => $item)
                            <tr class="{{ ($item['days_without_movement'] ?? 0) > 365 ? 'table-danger' : (($item['days_without_movement'] ?? 0) > 180 ? 'table-warning' : '') }}">
                                <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 class="text-end">
                                    <span class="badge bg-{{ $item['total_stock'] > 0 ? 'warning' : 'secondary' }}">
                                        {{ number_format($item['total_stock'], 2) }}
                                    </span>
                                </td>
                                <td class="text-end">${{ number_format($item['avg_cost'], 2) }}</td>
                                <td class="text-end">
                                    <strong>${{ number_format($item['total_value'], 2) }}</strong>
                                </td>
                                <td>
                                    @if($item['last_movement'])
                                        {{ \Carbon\Carbon::parse($item['last_movement'])->format('d/m/Y') }}
                                    @else
                                        <span class="text-muted">N/A</span>
                                    @endif
                                </td>
                                <td>
                                    @if($item['last_sale'])
                                        {{ \Carbon\Carbon::parse($item['last_sale'])->format('d/m/Y') }}
                                    @else
                                        <span class="text-danger">Nunca</span>
                                    @endif
                                </td>
                                <td class="text-end">
                                    @if($item['days_without_movement'] !== null)
                                        <span class="badge bg-{{ $item['days_without_movement'] > 365 ? 'danger' : ($item['days_without_movement'] > 180 ? 'warning' : 'info') }}">
                                            {{ number_format($item['days_without_movement'], 0) }} días
                                        </span>
                                    @else
                                        <span class="text-muted">N/A</span>
                                    @endif
                                </td>
                                <td class="text-end">
                                    @if($item['days_without_sale'] !== null)
                                        <span class="badge bg-{{ $item['days_without_sale'] > 365 ? 'danger' : ($item['days_without_sale'] > 180 ? 'warning' : 'info') }}">
                                            {{ number_format($item['days_without_sale'], 0) }} días
                                        </span>
                                    @else
                                        <span class="badge bg-danger">Nunca</span>
                                    @endif
                                </td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="11" class="text-center py-4">
                                    <i class="fas fa-check-circle me-2 text-success"></i>
                                    No se encontraron productos obsoletos según los criterios seleccionados.
                                </td>
                            </tr>
                        @endforelse
                    </tbody>
                    @if(count($obsoleteProducts) > 0)
                    <tfoot class="table-light">
                        <tr>
                            <th colspan="4" class="text-end">Totales:</th>
                            <th class="text-end">{{ number_format($obsoleteProducts->sum('total_stock'), 2) }}</th>
                            <th class="text-end">-</th>
                            <th class="text-end">${{ number_format($obsoleteProducts->sum('total_value'), 2) }}</th>
                            <th colspan="4"></th>
                        </tr>
                    </tfoot>
                    @endif
                </table>
            </div>
        </div>
    </div>

    <!-- Recomendaciones -->
    @if(count($obsoleteProducts) > 0)
    <div class="card shadow-sm mt-4 border-warning">
        <div class="card-header bg-warning text-dark">
            <h6 class="mb-0">
                <i class="fas fa-lightbulb me-2"></i>Recomendaciones
            </h6>
        </div>
        <div class="card-body">
            <ul class="mb-0">
                <li>Revisar estrategias de promoción para productos obsoletos con alto valor de inventario.</li>
                <li>Considerar descuentos o liquidaciones para liberar capital inmovilizado.</li>
                <li>Evaluar la necesidad de mantener estos productos en el catálogo.</li>
                <li>Revisar políticas de compra para evitar acumulación de productos de baja rotación.</li>
                <li>Considerar donaciones o descartes para productos que no tengan probabilidad de venta.</li>
            </ul>
        </div>
    </div>
    @endif
</div>

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