@extends('layouts.app')
@section('title', 'Reportes Logística')
@section('page-title', 'Reportes — Logística')
@section('breadcrumb')
    <li class="breadcrumb-item"><a href="{{ route('logistica.dashboard') }}">Logística</a></li>
    <li class="breadcrumb-item active">Reportes</li>
@endsection
@section('content')

{{-- KPIs --}}
<div class="row">
    <div class="col-md-2 col-sm-4">
        <div class="info-box shadow-sm">
            <span class="info-box-icon bg-success elevation-1"><i class="fas fa-boxes"></i></span>
            <div class="info-box-content">
                <span class="info-box-text">Productos</span>
                <span class="info-box-number">{{ $resumen['total_productos'] }}</span>
            </div>
        </div>
    </div>
    <div class="col-md-2 col-sm-4">
        <div class="info-box shadow-sm">
            <span class="info-box-icon bg-info elevation-1"><i class="fas fa-layer-group"></i></span>
            <div class="info-box-content">
                <span class="info-box-text">Lotes Vigentes</span>
                <span class="info-box-number">{{ $resumen['lotes_vigentes'] }}</span>
            </div>
        </div>
    </div>
    <div class="col-md-2 col-sm-4">
        <div class="info-box shadow-sm">
            <span class="info-box-icon bg-warning elevation-1"><i class="fas fa-clock"></i></span>
            <div class="info-box-content">
                <span class="info-box-text">Por Vencer</span>
                <span class="info-box-number">{{ $resumen['lotes_por_vencer'] }}</span>
            </div>
        </div>
    </div>
    <div class="col-md-2 col-sm-4">
        <div class="info-box shadow-sm">
            <span class="info-box-icon bg-danger elevation-1"><i class="fas fa-ban"></i></span>
            <div class="info-box-content">
                <span class="info-box-text">Vencidos</span>
                <span class="info-box-number">{{ $resumen['lotes_vencidos'] }}</span>
            </div>
        </div>
    </div>
    <div class="col-md-2 col-sm-4">
        <div class="info-box shadow-sm">
            <span class="info-box-icon bg-primary elevation-1"><i class="fas fa-arrow-circle-down"></i></span>
            <div class="info-box-content">
                <span class="info-box-text">Ingresos mes (kg)</span>
                <span class="info-box-number">{{ number_format($resumen['ingresos_mes_kg'], 0) }}</span>
            </div>
        </div>
    </div>
    <div class="col-md-2 col-sm-4">
        <div class="info-box shadow-sm">
            <span class="info-box-icon bg-orange elevation-1"><i class="fas fa-arrow-circle-up"></i></span>
            <div class="info-box-content">
                <span class="info-box-text">Egresos mes (kg)</span>
                <span class="info-box-number">{{ number_format($resumen['egresos_mes_kg'], 0) }}</span>
            </div>
        </div>
    </div>
</div>

<div class="row">
    {{-- Alertas de vencimiento --}}
    <div class="col-md-6">
        <div class="card">
            <div class="card-header bg-warning">
                <h3 class="card-title text-dark">
                    <i class="fas fa-exclamation-triangle mr-2"></i>Lotes próximos a vencer (30 días)
                </h3>
            </div>
            <div class="card-body p-0">
                <div class="table-responsive">
                    <table class="table table-sm mb-0">
                        <thead class="thead-light">
                            <tr>
                                <th>Lote</th>
                                <th>Producto</th>
                                <th class="text-right">Stock</th>
                                <th>Vencimiento</th>
                                <th>Almacén</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($alertas as $lote)
                                <tr>
                                    <td><code>{{ $lote->numero }}</code></td>
                                    <td>{{ Str::limit($lote->producto->nombre, 25) }}</td>
                                    <td class="text-right">{{ number_format($lote->cantidad_actual, 2) }} {{ $lote->producto->unidadMedida->abreviatura }}</td>
                                    <td>
                                        <span class="{{ $lote->fecha_vencimiento <= now() ? 'text-danger font-weight-bold' : 'text-warning' }}">
                                            {{ \Carbon\Carbon::parse($lote->fecha_vencimiento)->format('d/m/Y') }}
                                        </span>
                                    </td>
                                    <td><small>{{ $lote->almacen->nombre }}</small></td>
                                </tr>
                            @empty
                                <tr><td colspan="5" class="text-center text-muted py-3">Sin alertas de vencimiento.</td></tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>

    {{-- Bajo stock --}}
    <div class="col-md-6">
        <div class="card">
            <div class="card-header bg-danger text-white">
                <h3 class="card-title">
                    <i class="fas fa-battery-quarter mr-2"></i>Productos con bajo stock
                </h3>
            </div>
            <div class="card-body p-0">
                <div class="table-responsive">
                    <table class="table table-sm mb-0">
                        <thead class="thead-light">
                            <tr>
                                <th>Producto</th>
                                <th>Categoría</th>
                                <th class="text-right">Stock Actual</th>
                                <th class="text-right">Stock Mínimo</th>
                                <th>U.M.</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($bajo_stock as $p)
                                <tr>
                                    <td>{{ Str::limit($p->nombre, 28) }}</td>
                                    <td><small>{{ $p->categoria->nombre }}</small></td>
                                    <td class="text-right text-danger font-weight-bold">
                                        {{ number_format($p->stock_actual ?? 0, 2) }}
                                    </td>
                                    <td class="text-right text-muted">
                                        {{ number_format($p->stock_minimo, 2) }}
                                    </td>
                                    <td>{{ $p->unidadMedida->abreviatura }}</td>
                                </tr>
                            @empty
                                <tr><td colspan="5" class="text-center text-muted py-3">Sin productos con bajo stock.</td></tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>

<div class="row">
    {{-- Kardex link --}}
    <div class="col-md-4">
        <div class="card card-outline card-success">
            <div class="card-body text-center py-4">
                <i class="fas fa-chart-bar fa-3x text-success mb-3"></i>
                <h5>Kardex de Inventario</h5>
                <p class="text-muted small">Historial completo de movimientos por producto con saldo acumulado.</p>
                <a href="{{ route('logistica.reportes.kardex') }}" class="btn btn-success">
                    <i class="fas fa-search mr-1"></i>Ver Kardex
                </a>
            </div>
        </div>
    </div>

    {{-- Movimientos recientes --}}
    <div class="col-md-8">
        <div class="card">
            <div class="card-header">
                <h3 class="card-title"><i class="fas fa-history mr-2"></i>Últimos movimientos</h3>
            </div>
            <div class="card-body p-0">
                <div class="table-responsive">
                    <table class="table table-sm mb-0">
                        <thead class="thead-light">
                            <tr>
                                <th>Fecha</th>
                                <th>Tipo</th>
                                <th>Producto</th>
                                <th class="text-right">Cantidad</th>
                                <th>Usuario</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($movimientos_recientes as $mov)
                                <tr>
                                    <td><small>{{ $mov->created_at->format('d/m/Y H:i') }}</small></td>
                                    <td>
                                        @if($mov->tipo === 'ingreso')
                                            <span class="badge badge-success">Ingreso</span>
                                        @else
                                            <span class="badge badge-danger">Egreso</span>
                                        @endif
                                    </td>
                                    <td>{{ Str::limit($mov->producto->nombre, 28) }}</td>
                                    <td class="text-right {{ $mov->tipo === 'ingreso' ? 'text-success' : 'text-danger' }}">
                                        {{ $mov->tipo === 'ingreso' ? '+' : '-' }}{{ number_format($mov->cantidad, 2) }}
                                    </td>
                                    <td><small>{{ $mov->usuario?->name ?? '—' }}</small></td>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>

@endsection