@extends('layout.main') @section('content')
{{-- Reportes → Reportes de inventario (InventoryReportController): existencias por local, un producto, inventario bajo,
     valor del inventario y Kardex. Solo lee; mismos principios visuales que Ventas por fechas. --}}
@php
    $money = function ($v) { return '$' . number_format((float) $v, 2); };
    $n = function ($v) { $v = (float) $v; return $v == floor($v) ? number_format($v, 0) : number_format($v, 2); };
    $keep = array_filter(['local' => $warehouse_id ?: null, 'categoria' => $category_id, 'q' => $text !== '' ? $text : null]);
    $tab = function ($key) use ($keep) { return route('report.inventory', ['vista' => $key] + $keep); };
    $short = function ($name) { return preg_replace('/\s*-\s*Entre Tu y Yo$/i', '', $name); };
    $needsProduct = in_array($vista, ['producto', 'kardex']);
@endphp
<style>
    .ir { --ir-brand: var(--brand, #4f46e5); --ir-border: var(--border, #e5e7eb); --ir-muted: var(--text-muted, #6b7280); max-width: 1280px; margin: 0 auto; padding: 8px 4px 40px; }
    .ir h1 { font-size: 26px; font-weight: 800; letter-spacing: -.02em; margin: 6px 0 2px; }
    .ir .sub { color: var(--ir-muted); margin-bottom: 14px; }
    .ir-tabs { display: flex; flex-wrap: wrap; gap: 6px; margin-bottom: 14px; }
    .ir-tabs a { padding: 8px 14px; border-radius: 999px; border: 1px solid var(--ir-border); font-weight: 600; font-size: 13px; color: var(--ir-muted); text-decoration: none; background: var(--surface, #fff); }
    .ir-tabs a:hover { border-color: var(--ir-brand); color: var(--ir-brand); }
    .ir-tabs a.on { background: var(--ir-brand); border-color: var(--ir-brand); color: var(--brand-contrast, #fff); }
    .ir-panel { background: var(--surface, #fff); border: 1px solid var(--ir-border); border-radius: 14px; padding: 16px; margin-bottom: 16px; }
    .ir-form { display: flex; flex-wrap: wrap; gap: 10px; align-items: flex-end; }
    .ir-form label { display: block; font-size: 11px; font-weight: 700; letter-spacing: .05em; text-transform: uppercase; color: var(--ir-muted); margin-bottom: 4px; }
    .ir-form input, .ir-form select { height: 40px; border-radius: 10px; }
    .ir-kpis { display: grid; grid-template-columns: repeat(auto-fit, minmax(200px, 1fr)); gap: 12px; margin-bottom: 16px; }
    .ir-kpi { background: var(--surface, #fff); border: 1px solid var(--ir-border); border-radius: 14px; padding: 14px 16px; }
    .ir-kpi small { display: block; font-size: 11px; font-weight: 700; letter-spacing: .06em; text-transform: uppercase; color: var(--ir-muted); }
    .ir-kpi b { display: block; font-size: 24px; font-weight: 750; margin-top: 4px; font-variant-numeric: tabular-nums; }
    .ir-kpi.main { background: var(--ir-brand); border-color: var(--ir-brand); color: var(--brand-contrast, #fff); }
    .ir-kpi.main small { color: inherit; opacity: .8; }
    .ir-table { width: 100%; }
    .ir-table th { font-size: 11.5px; text-transform: uppercase; letter-spacing: .04em; color: var(--ir-muted); border-top: 0 !important; white-space: nowrap; }
    .ir-table td, .ir-table th { padding: 10px 12px; vertical-align: middle; }
    .ir-table .num { text-align: right; font-variant-numeric: tabular-nums; }
    .ir-in { color: #16a34a; font-weight: 700; } .ir-out { color: #b91c1c; font-weight: 700; }
    .ir-pill { display: inline-block; padding: 3px 10px; border-radius: 999px; font-size: 12px; font-weight: 700; background: #f4f4f5; }
    .ir-pill.red { background: #fef2f2; color: #b91c1c; } .ir-pill.orange { background: #fff7ed; color: #9a3412; }
    .ir-empty { text-align: center; color: var(--ir-muted); padding: 34px 10px; }
    .ir-pick a { display: block; padding: 8px 12px; border: 1px solid var(--ir-border); border-radius: 10px; margin-bottom: 6px; text-decoration: none; color: inherit; }
    .ir-pick a:hover { border-color: var(--ir-brand); }
    @media (max-width: 767px) {
        .ir h1 { font-size: 21px; } .ir-kpi b { font-size: 19px; }
        .ir-form > div { flex: 1 1 100%; }
        .ir-table { font-size: 13px; }
    }
</style>
<section class="forms">
<div class="container-fluid"><div class="ir">
    <p class="sub">Qué hay, dónde está, cuánto vale y cómo se ha movido. Solo consulta: no cambia nada.</p>

    <nav class="ir-tabs" aria-label="Reportes de inventario">
        @foreach(\App\Http\Controllers\InventoryReportController::VISTAS as $key => $label)
        <a href="{{ $tab($key) }}" class="{{ $vista == $key ? 'on' : '' }}">{{ $label }}</a>
        @endforeach
    </nav>

    <form method="get" action="{{ route('report.inventory') }}" class="ir-panel ir-form">
        <input type="hidden" name="vista" value="{{ $vista }}">
        @if($vista == 'producto' || $vista == 'kardex')@if(request('producto'))<input type="hidden" name="producto" value="{{ request('producto') }}">@endif @endif
        @if(count($warehouses) > 1)
        <div><label>Local</label>
            <select name="local" class="form-control"><option value="">Todos los locales</option>
                @foreach($warehouses as $w)<option value="{{ $w->id }}" @if($w->id == $warehouse_id) selected @endif>{{ $short($w->name) }}</option>@endforeach
            </select></div>
        @endif
        @if(!$needsProduct)
        <div><label>Categoría</label>
            <select name="categoria" class="form-control"><option value="">Todas</option>
                @foreach($categories as $c)<option value="{{ $c->id }}" @if($c->id == $category_id) selected @endif>{{ $c->name }}</option>@endforeach
            </select></div>
        @endif
        <div style="flex:1 1 220px"><label>{{ $needsProduct ? 'Producto (nombre o código)' : 'Buscar producto' }}</label>
            <input type="search" name="q" value="{{ $text }}" class="form-control" placeholder="{{ $needsProduct ? 'Escribe y pulsa Ver' : 'Nombre o código…' }}" @if($needsProduct) autofocus @endif></div>
        @if($vista == 'kardex')
        <div><label>Desde</label><input type="date" name="desde" value="{{ $from->format('Y-m-d') }}" class="form-control"></div>
        <div><label>Hasta</label><input type="date" name="hasta" value="{{ $to->format('Y-m-d') }}" class="form-control"></div>
        @endif
        <div><button class="btn btn-primary" style="height:40px"><i class="fa fa-search"></i> Ver</button></div>
    </form>

    {{-- ============ INVENTARIO POR LOCAL ============ --}}
    @if($vista == 'actual')
    <div class="ir-panel p-0" style="overflow:hidden">
        @if($rows->isEmpty())
        <div class="ir-empty">No hay productos con existencia con ese filtro.</div>
        @else
        <div class="table-responsive"><table class="table ir-table mb-0">
            <thead><tr><th>Producto</th><th>Categoría</th>@foreach($cols as $w)<th class="num">{{ $short($w->name) }}</th>@endforeach @if($cols->count() > 1)<th class="num">Total</th>@endif</tr></thead>
            <tbody>
            @foreach($rows as $r)
            <tr><td><a href="{{ route('report.inventory', ['vista' => 'producto', 'producto' => $r->id]) }}"><strong>{{ $r->name }}</strong></a><div class="text-muted small">{{ $r->code }}</div></td>
                <td>{{ $r->category ?: '—' }}</td>
                @foreach($cols as $w)@php $v = $r->{'w' . $w->id}; @endphp<td class="num {{ $v < 0 ? 'ir-out' : ($v == 0 ? 'text-muted' : '') }}">{{ $n($v) }}</td>@endforeach
                @if($cols->count() > 1)<td class="num"><strong>{{ $n($r->total) }}</strong></td>@endif</tr>
            @endforeach
            </tbody>
        </table></div>
        @endif
    </div>
    <div>{{ $rows->links('pagination::bootstrap-4') }}</div>

    {{-- ============ UN PRODUCTO ============ --}}
    @elseif($vista == 'producto')
    @if(!isset($product))
    <div class="ir-panel">
        @if($matches->count() > 1)
        <p class="text-muted mb-2">Elige el producto:</p>
        <div class="ir-pick">@foreach($matches as $m)<a href="{{ route('report.inventory', ['vista' => 'producto', 'producto' => $m->id] + $keep) }}"><strong>{{ $m->name }}</strong> <span class="text-muted">{{ $m->code }}</span></a>@endforeach</div>
        @elseif($text !== '')<div class="ir-empty">No encontramos productos con «{{ $text }}».</div>
        @else<div class="ir-empty">Escribe el nombre o el código de un producto para ver cuánto hay en cada local.</div>@endif
    </div>
    @else
    @php $totalQty = $per->sum('qty'); @endphp
    <div class="ir-kpis">
        <div class="ir-kpi main"><small>Existencia total</small><b>{{ $n($totalQty) }}</b></div>
        <div class="ir-kpi"><small>Costo unitario</small><b>{{ $money($product->cost) }}</b></div>
        <div class="ir-kpi"><small>Valor al costo</small><b>{{ $money($totalQty * $product->cost) }}</b></div>
        <div class="ir-kpi"><small>Mínimo (alerta)</small><b>{{ $product->alert_quantity ? $n($product->alert_quantity) : '—' }}</b></div>
    </div>
    <div class="ir-panel p-0" style="overflow:hidden">
        <div class="p-3 pb-0"><h5 class="mb-0">{{ $product->name }}</h5><div class="text-muted small mb-2">{{ $product->code }} · {{ $category_name ?: 'Sin categoría' }}</div></div>
        <div class="table-responsive"><table class="table ir-table mb-0">
            <thead><tr><th>Local</th><th class="num">Existencia</th><th class="num">Valor al costo</th><th>Estado</th></tr></thead>
            <tbody>
            @foreach($per as $row)
            @php $low = $product->alert_quantity > 0 && $row->qty <= $product->alert_quantity; @endphp
            <tr><td>{{ $short($row->name) }}</td><td class="num"><strong>{{ $n($row->qty) }}</strong></td><td class="num">{{ $money($row->qty * $product->cost) }}</td>
                <td>@if($row->qty <= 0)<span class="ir-pill red">Agotado</span>@elseif($low)<span class="ir-pill orange">Bajo el mínimo</span>@else<span class="ir-pill">Normal</span>@endif</td></tr>
            @endforeach
            </tbody>
        </table></div>
    </div>
    @if($kardex_installed)
    <div class="ir-panel p-0" style="overflow:hidden">
        <div class="p-3 pb-0 d-flex justify-content-between align-items-center"><h5 class="mb-0">Últimos movimientos</h5>
            <a href="{{ route('report.inventory', ['vista' => 'kardex', 'producto' => $product->id] + array_filter(['local' => $warehouse_id ?: null])) }}">Ver Kardex completo →</a></div>
        @if($last->isEmpty())<div class="ir-empty">Todavía no hay movimientos anotados de este producto.</div>
        @else
        <div class="table-responsive"><table class="table ir-table mb-0">
            <thead><tr><th>Fecha</th><th>Local</th><th>Movimiento</th><th class="num">Entra</th><th class="num">Sale</th><th class="num">Saldo</th></tr></thead>
            <tbody>@foreach($last as $m)<tr><td>{{ \Carbon\Carbon::parse($m->created_at)->format('d/m/Y H:i') }}</td><td>{{ $short($m->warehouse) }}</td><td>{{ $m->type }}@if($m->reference)<div class="text-muted small">{{ $m->reference }}</div>@endif</td>
                <td class="num ir-in">{{ $m->qty_in > 0 ? '+' . $n($m->qty_in) : '' }}</td><td class="num ir-out">{{ $m->qty_out > 0 ? '−' . $n($m->qty_out) : '' }}</td><td class="num"><strong>{{ $n($m->balance) }}</strong></td></tr>@endforeach</tbody>
        </table></div>
        @endif
    </div>
    @endif
    @endif

    {{-- ============ INVENTARIO BAJO ============ --}}
    @elseif($vista == 'bajo')
    <p class="text-muted">Productos cuya existencia en un local está en su mínimo (cantidad de alerta del producto) o por debajo. Los más urgentes primero.</p>
    <div class="ir-panel p-0" style="overflow:hidden">
        @if($rows->isEmpty())
        <div class="ir-empty"><i class="fa fa-check-circle text-success"></i> Nada por debajo del mínimo con este filtro.</div>
        @else
        <div class="table-responsive"><table class="table ir-table mb-0">
            <thead><tr><th>Producto</th><th>Local</th><th>Categoría</th><th class="num">Existencia</th><th class="num">Mínimo</th><th class="num">Faltan</th><th></th></tr></thead>
            <tbody>
            @foreach($rows as $r)
            <tr><td><a href="{{ route('report.inventory', ['vista' => 'producto', 'producto' => $r->id]) }}"><strong>{{ $r->name }}</strong></a><div class="text-muted small">{{ $r->code }}</div></td>
                <td>{{ $short($r->warehouse) }}</td><td>{{ $r->category ?: '—' }}</td>
                <td class="num {{ $r->qty <= 0 ? 'ir-out' : '' }}">{{ $n($r->qty) }}</td><td class="num">{{ $n($r->alert_quantity) }}</td>
                <td class="num"><strong>{{ $n(max(0, $r->alert_quantity - $r->qty)) }}</strong></td>
                <td>@if($r->qty <= 0)<span class="ir-pill red">Agotado</span>@else<span class="ir-pill orange">Bajo</span>@endif</td></tr>
            @endforeach
            </tbody>
        </table></div>
        @endif
    </div>
    <div>{{ $rows->links('pagination::bootstrap-4') }}</div>

    {{-- ============ VALOR DEL INVENTARIO ============ --}}
    @elseif($vista == 'valor')
    <div class="ir-kpis">
        <div class="ir-kpi main"><small>Valor al costo</small><b>{{ $money($total->cost_value ?? 0) }}</b></div>
        <div class="ir-kpi"><small>Valor a precio de venta</small><b>{{ $money($total->sale_value ?? 0) }}</b></div>
        <div class="ir-kpi"><small>Unidades</small><b>{{ $n($total->units ?? 0) }}</b></div>
        <div class="ir-kpi"><small>Productos distintos</small><b>{{ $n($total->products ?? 0) }}</b></div>
    </div>
    <p class="text-muted">Costo = existencia × costo del producto. Precio de venta = existencia × precio del producto (tal como está guardado). Solo cuenta lo que hay en existencia.</p>
    @foreach(['by_warehouse' => ['Por local', 'Local'], 'by_category' => ['Por categoría', 'Categoría']] as $key => [$title, $col])
    <h5 class="mt-3">{{ $title }}</h5>
    <div class="ir-panel p-0" style="overflow:hidden">
        @if($$key->isEmpty())<div class="ir-empty">Sin datos con este filtro.</div>
        @else
        <div class="table-responsive"><table class="table ir-table mb-0">
            <thead><tr><th>{{ $col }}</th><th class="num">Productos</th><th class="num">Unidades</th><th class="num">Valor al costo</th><th class="num">A precio de venta</th></tr></thead>
            <tbody>@foreach($$key as $r)<tr><td><strong>{{ $key == 'by_warehouse' ? $short($r->name) : $r->name }}</strong></td><td class="num">{{ $n($r->products) }}</td><td class="num">{{ $n($r->units) }}</td><td class="num"><strong>{{ $money($r->cost_value) }}</strong></td><td class="num">{{ $money($r->sale_value) }}</td></tr>@endforeach</tbody>
        </table></div>
        @endif
    </div>
    @endforeach

    {{-- ============ KARDEX ============ --}}
    @else
    @if(!$kardex_installed)
    <div class="alert alert-warning">El Kardex necesita una tabla nueva: ejecuta <code>database/cambios/2026-10-21b_kardex.sql</code> en phpMyAdmin (base de pruebas). Desde entonces, cada movimiento de inventario queda anotado solo.</div>
    @elseif(!$product)
    <div class="ir-panel">
        @if($matches->count() > 1)
        <p class="text-muted mb-2">Elige el producto:</p>
        <div class="ir-pick">@foreach($matches as $m)<a href="{{ route('report.inventory', ['vista' => 'kardex', 'producto' => $m->id, 'desde' => $from->format('Y-m-d'), 'hasta' => $to->format('Y-m-d')] + array_filter(['local' => $warehouse_id ?: null])) }}"><strong>{{ $m->name }}</strong> <span class="text-muted">{{ $m->code }}</span></a>@endforeach</div>
        @elseif($text !== '')<div class="ir-empty">No encontramos productos con «{{ $text }}».</div>
        @else<div class="ir-empty">Escribe el nombre o el código de un producto para ver su historial de movimientos.</div>@endif
    </div>
    @else
    <div class="ir-kpis">
        <div class="ir-kpi main"><small>{{ $product->name }}</small><b style="font-size:16px">{{ $product->code }}</b></div>
        @if($opening !== null)<div class="ir-kpi"><small>Saldo inicial</small><b>{{ $n($opening) }}</b></div>@endif
        <div class="ir-kpi"><small>Entradas</small><b class="ir-in">{{ $n($sum_in) }}</b></div>
        <div class="ir-kpi"><small>Salidas</small><b class="ir-out">{{ $n($sum_out) }}</b></div>
        @if($rows->isNotEmpty() && $warehouse_id)<div class="ir-kpi"><small>Saldo final</small><b>{{ $n($rows->last()->balance) }}</b></div>@endif
    </div>
    <div class="ir-panel p-0" style="overflow:hidden">
        @if($rows->isEmpty())<div class="ir-empty">No hay movimientos anotados en estas fechas{{ $warehouse_id ? ' en este local' : '' }}. El Kardex se llena desde que se instaló.</div>
        @else
        <div class="table-responsive"><table class="table ir-table mb-0">
            <thead><tr><th>Fecha</th><th>Local</th><th>Movimiento</th><th>Referencia</th><th class="num">Entrada</th><th class="num">Salida</th><th class="num">Saldo</th><th>Usuario</th></tr></thead>
            <tbody>@foreach($rows as $m)<tr><td style="white-space:nowrap">{{ \Carbon\Carbon::parse($m->created_at)->format('d/m/Y H:i') }}</td><td>{{ $short($m->warehouse) }}</td><td>{{ $m->type }}</td><td class="text-muted">{{ $m->reference ?: '—' }}</td>
                <td class="num ir-in">{{ $m->qty_in > 0 ? '+' . $n($m->qty_in) : '' }}</td><td class="num ir-out">{{ $m->qty_out > 0 ? '−' . $n($m->qty_out) : '' }}</td><td class="num"><strong>{{ $n($m->balance) }}</strong></td><td>{{ $m->user ?: '—' }}</td></tr>@endforeach</tbody>
        </table></div>
        @if($truncated)<p class="text-muted small p-3 mb-0">Se muestran los primeros 1000 movimientos: acorta las fechas para ver el resto.</p>@endif
        @endif
    </div>
    @endif
    @endif
</div></div>
</section>
@endsection