@extends('layouts.app')

@section('title', 'Análisis ABC')

@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-chart-pie me-2"></i>Análisis ABC de Productos
                </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.abc-analysis', 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.abc-analysis') }}" class="row g-3">
                <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="{{ $dateFrom ?? '' }}">
                </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="{{ $dateTo ?? '' }}">
                </div>
                <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 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.abc-analysis') }}" class="btn btn-secondary">
                        <i class="fas fa-redo me-2"></i>Limpiar
                    </a>
                </div>
            </form>
        </div>
    </div>

    <!-- Resumen por Categoría -->
    <div class="row mb-4">
        <div class="col-md-4">
            <div class="card shadow-sm border-primary">
                <div class="card-header bg-primary text-white">
                    <h5 class="mb-0">
                        <i class="fas fa-star me-2"></i>Categoría A
                    </h5>
                </div>
                <div class="card-body">
                    @php
                        $categoryA = array_filter($products, fn($p) => $p['category'] == 'A');
                        $totalA = array_sum(array_column($categoryA, 'total_revenue'));
                        $percentageA = $totalRevenue > 0 ? ($totalA / $totalRevenue) * 100 : 0;
                    @endphp
                    <h3 class="text-primary mb-0">{{ count($categoryA) }}</h3>
                    <p class="text-muted mb-0">Productos (80% del valor)</p>
                    <hr>
                    <p class="mb-0">
                        <strong>Ingresos:</strong> ${{ number_format($totalA, 2) }}<br>
                        <strong>Porcentaje:</strong> {{ number_format($percentageA, 2) }}%
                    </p>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card shadow-sm border-warning">
                <div class="card-header bg-warning text-dark">
                    <h5 class="mb-0">
                        <i class="fas fa-star-half-alt me-2"></i>Categoría B
                    </h5>
                </div>
                <div class="card-body">
                    @php
                        $categoryB = array_filter($products, fn($p) => $p['category'] == 'B');
                        $totalB = array_sum(array_column($categoryB, 'total_revenue'));
                        $percentageB = $totalRevenue > 0 ? ($totalB / $totalRevenue) * 100 : 0;
                    @endphp
                    <h3 class="text-warning mb-0">{{ count($categoryB) }}</h3>
                    <p class="text-muted mb-0">Productos (15% del valor)</p>
                    <hr>
                    <p class="mb-0">
                        <strong>Ingresos:</strong> ${{ number_format($totalB, 2) }}<br>
                        <strong>Porcentaje:</strong> {{ number_format($percentageB, 2) }}%
                    </p>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card shadow-sm border-info">
                <div class="card-header bg-info text-white">
                    <h5 class="mb-0">
                        <i class="far fa-star me-2"></i>Categoría C
                    </h5>
                </div>
                <div class="card-body">
                    @php
                        $categoryC = array_filter($products, fn($p) => $p['category'] == 'C');
                        $totalC = array_sum(array_column($categoryC, 'total_revenue'));
                        $percentageC = $totalRevenue > 0 ? ($totalC / $totalRevenue) * 100 : 0;
                    @endphp
                    <h3 class="text-info mb-0">{{ count($categoryC) }}</h3>
                    <p class="text-muted mb-0">Productos (5% del valor)</p>
                    <hr>
                    <p class="mb-0">
                        <strong>Ingresos:</strong> ${{ number_format($totalC, 2) }}<br>
                        <strong>Porcentaje:</strong> {{ number_format($percentageC, 2) }}%
                    </p>
                </div>
            </div>
        </div>
    </div>

    <!-- Tabla de Análisis ABC -->
    <div class="card shadow-sm">
        <div class="card-header bg-light">
            <h5 class="mb-0">
                <i class="fas fa-list me-2"></i>Clasificación ABC de Productos
                <span class="badge bg-primary ms-2">{{ count($products) }} productos</span>
            </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>Categoría</th>
                            <th>Producto</th>
                            <th>SKU</th>
                            <th class="text-end">Ventas (Unidades)</th>
                            <th class="text-end">Ingresos</th>
                            <th class="text-end">% Individual</th>
                            <th class="text-end">% Acumulado</th>
                            <th class="text-end">Stock Actual</th>
                            <th class="text-end">Costo Promedio</th>
                            <th class="text-end">Valor Inventario</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($products as $index => $item)
                            <tr class="table-{{ $item['category'] == 'A' ? 'primary' : ($item['category'] == 'B' ? 'warning' : 'info') }}">
                                <td>{{ $index + 1 }}</td>
                                <td>
                                    <span class="badge bg-{{ $item['category'] == 'A' ? 'primary' : ($item['category'] == 'B' ? 'warning' : 'info') }} fs-6">
                                        {{ $item['category'] }}
                                    </span>
                                </td>
                                <td>
                                    <strong>{{ $item['product']->name }}</strong>
                                    @if($item['product']->category)
                                        <br><small class="text-muted">{{ $item['product']->category->name }}</small>
                                    @endif
                                </td>
                                <td>{{ $item['product']->sku ?? 'N/A' }}</td>
                                <td class="text-end">{{ number_format($item['total_sold'], 2) }}</td>
                                <td class="text-end">
                                    <strong>${{ number_format($item['total_revenue'], 2) }}</strong>
                                </td>
                                <td class="text-end">{{ number_format($item['percentage'], 2) }}%</td>
                                <td class="text-end">
                                    <strong>{{ number_format($item['cumulative_percentage'], 2) }}%</strong>
                                </td>
                                <td class="text-end">{{ number_format($item['current_stock'], 2) }}</td>
                                <td class="text-end">${{ number_format($item['avg_cost'], 2) }}</td>
                                <td class="text-end">${{ number_format($item['inventory_value'], 2) }}</td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="11" class="text-center py-4">
                                    <i class="fas fa-info-circle me-2"></i>No se encontraron productos con ventas en el período seleccionado.
                                </td>
                            </tr>
                        @endforelse
                    </tbody>
                    @if(count($products) > 0)
                    <tfoot class="table-light">
                        <tr>
                            <th colspan="4" class="text-end">Totales:</th>
                            <th class="text-end">{{ number_format(array_sum(array_column($products, 'total_sold')), 2) }}</th>
                            <th class="text-end">${{ number_format($totalRevenue, 2) }}</th>
                            <th class="text-end">100%</th>
                            <th class="text-end">-</th>
                            <th class="text-end">-</th>
                            <th class="text-end">-</th>
                            <th class="text-end">${{ number_format(array_sum(array_column($products, 'inventory_value')), 2) }}</th>
                        </tr>
                    </tfoot>
                    @endif
                </table>
            </div>
        </div>
    </div>

    <!-- Información -->
    <div class="card shadow-sm mt-4">
        <div class="card-header bg-info text-white">
            <h6 class="mb-0">
                <i class="fas fa-info-circle me-2"></i>Información sobre el Análisis ABC
            </h6>
        </div>
        <div class="card-body">
            <div class="row">
                <div class="col-md-4">
                    <strong>Categoría A:</strong>
                    <p class="mb-0">Productos de alto valor (80% de los ingresos). Requieren control estricto y atención prioritaria.</p>
                </div>
                <div class="col-md-4">
                    <strong>Categoría B:</strong>
                    <p class="mb-0">Productos de valor medio (15% de los ingresos). Requieren control moderado.</p>
                </div>
                <div class="col-md-4">
                    <strong>Categoría C:</strong>
                    <p class="mb-0">Productos de bajo valor (5% de los ingresos). Control básico y revisión periódica.</p>
                </div>
            </div>
        </div>
    </div>
</div>

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