{{-- Sweet Works ERP | app/Modules/Warehouse/Resources/Views/inventory/stock-overview.blade.php | v1.4 | 29/09/2026 --}}
{{-- v1.4 — Ventana Estructural VB-2 (Punto 3): modal de detalle de bin agrega enlace "Ver Lote" hacia
         la nueva pantalla warehouse.lots.show — antes no había forma de llegar a esa pantalla desde
         la UI. --}}
{{-- v1.3 — Ajustes de VB-1 (decisión de Israel, equivalente MMBE de SAP): la consulta muestra TODA la
         existencia desglosada por tipo por defecto (antes excluía no-disponibles por defecto) — el
         filtro de disponibilidad es para operaciones, no para consultar. Totales por tipo dinámicos
         ($summary['by_type'], uno por cada fila activa de warehouse_stock_types) en vez de las 2
         tarjetas fijas unrestricted/blocked. --}}
{{-- v1.2 — Ventana Estructural VB (Punto 2): filtro stock_type (texto, 5 opciones fijas) →
         stock_type_id (catálogo, @foreach($stockTypes)). Badges/colores ya no usan un mapa
         bootstrap-color duplicado — vienen de WarehouseStockType::color/name (catálogo). Badge
         "Reservado" del encabezado de producto reemplazado por "Calidad" (el stock_type reserved
         se elimina — ver CLAUDE.md). --}}
{{-- v1.1 — Fase 1E-E6 P2 (regla A.5 + header audit): header corregido de "New-Unity ERP" a
         "Sweet Works ERP". Badge FIFO "Next" usaba $zoneCode !== 'SV' (código hardcodeado) — ahora
         usa $zoneData['is_quality_hold'] (bandera real del catálogo). --}}
{{-- v1.0 — Stock Overview (MMBE equivalent). Vista jerarquica: Empresa > Almacen > Zona > Lote > Bin --}}

@extends('layouts.vertical', ['pageTitle' => __('warehouse.stock-overview')])

@section('page-title')
<div class="subheader">
    <h1 class="subheader-title">
        <i class="subheader-icon fal fa-layer-group"></i> {{ __('warehouse.stock-overview') }}
        <small>{{ __('warehouse.mmbe-sub') }}</small>
    </h1>
    <div class="subheader-block d-lg-flex align-items-center gap-2">
        <a href="{{ route('warehouse.inventory.index') }}" class="btn btn-secondary btn-sm">
            <i class="fal fa-arrow-left me-1"></i> {{ __('warehouse.back-to-inventory') }}
        </a>
    </div>
</div>
@endsection

@section('content')

{{-- Filtro por producto --}}
<div class="panel mb-3">
    <div class="panel-container show">
        <div class="panel-content py-2">
            <form method="GET" class="row g-2 align-items-end">
                <div class="col-md-4">
                    <label class="form-label fw-bold small">{{ __('warehouse.search-product') }}</label>
                    <input type="text" name="search" class="form-control form-control-sm"
                           value="{{ request('search') }}" placeholder="{{ __('warehouse.ph-name-sku-part') }}">
                </div>
                <div class="col-md-3">
                    <label class="form-label fw-bold small">{{ __('warehouse.warehouse') }}</label>
                    <select name="warehouse_id" class="form-select form-select-sm">
                        <option value="">{{ __('warehouse.all-warehouses') }}</option>
                        @foreach($warehouses as $wh)
                        <option value="{{ $wh->id }}" {{ request('warehouse_id') == $wh->id ? 'selected' : '' }}>
                            {{ $wh->code }} — {{ $wh->name }}
                        </option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-2">
                    <label class="form-label fw-bold small">{{ __('warehouse.stock-type') }}</label>
                    <select name="stock_type_id" class="form-select form-select-sm">
                        <option value="">{{ __('warehouse.all-types') }}</option>
                        @foreach($stockTypes as $st)
                        <option value="{{ $st->id }}" {{ request('stock_type_id') == $st->id ? 'selected' : '' }}>{{ $st->name }}</option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-2">
                    <button type="submit" class="btn btn-primary btn-sm w-100">
                        <i class="fal fa-search me-1"></i> {{ __('warehouse.search') }}
                    </button>
                </div>
                <div class="col-md-1">
                    <a href="{{ route('warehouse.inventory.stock-overview') }}" class="btn btn-secondary btn-sm w-100">
                        {{ __('warehouse.clear') }}
                    </a>
                </div>
            </form>
        </div>
    </div>
</div>

{{-- Totales empresa — equivalente MMBE: un total por tipo de existencia + total general --}}
<div class="row g-3 mb-3">
    <div class="col-md-2">
        <div class="panel text-center py-3 mb-0">
            <div style="font-size:10px;font-weight:600;color:#6c757d;letter-spacing:.5px;">{{ __('warehouse.total-products-caps') }}</div>
            <div class="h3 mb-0 text-primary">{{ $summary['total_products'] }}</div>
        </div>
    </div>
    @foreach($summary['by_type'] as $typeSummary)
    <div class="col-md-2">
        <div class="panel text-center py-3 mb-0">
            <div style="font-size:10px;font-weight:600;color:#6c757d;letter-spacing:.5px;">{{ strtoupper($typeSummary['name']) }}</div>
            <div class="h3 mb-0" style="color:{{ $typeSummary['color'] }};">{{ number_format($typeSummary['qty'], 2) }}</div>
        </div>
    </div>
    @endforeach
    <div class="col-md-2">
        <div class="panel text-center py-3 mb-0" style="border-top:3px solid #185FA5;">
            <div style="font-size:10px;font-weight:600;color:#6c757d;letter-spacing:.5px;">{{ __('warehouse.total-value-caps') }}</div>
            <div class="h3 mb-0 text-primary">${{ number_format($summary['total_value'], 2) }}</div>
        </div>
    </div>
</div>

{{-- Vista jerarquica MMBE --}}
@forelse($stockData as $productId => $productData)
<div class="panel mb-3">
    {{-- Product Header --}}
    <div class="panel-hdr" style="cursor:pointer;" onclick="toggleProduct({{ $productId }})">
        <h2>
            <i class="fal fa-box me-2 text-primary"></i>
            <span class="fw-bold">{{ $productData['product_name'] }}</span>
            <small class="ms-2 text-muted">{{ $productData['sku'] }}</small>
        </h2>
        <div class="panel-toolbar d-flex gap-2 align-items-center">
            {{-- Stock type badges --}}
            @if($productData['unrestricted'] > 0)
            <span class="badge bg-success">{{ number_format($productData['unrestricted'], 2) }} {{ __('warehouse.available') }}</span>
            @endif
            @if($productData['blocked'] > 0)
            <span class="badge bg-danger">{{ number_format($productData['blocked'], 2) }} {{ __('warehouse.blocked-lower') }}</span>
            @endif
            @if($productData['quality'] > 0)
            <span class="badge bg-warning text-dark">{{ number_format($productData['quality'], 2) }} {{ __('warehouse.opt-quarantine') }}</span>
            @endif
            <span class="badge bg-primary">${{ number_format($productData['total_value'], 2) }}</span>
            <a href="{{ route('warehouse.inventory.kardex', $productId) }}" class="btn btn-xs btn-outline-primary" style="font-size:10px;padding:2px 8px;">
                <i class="fal fa-history me-1"></i>{{ __('warehouse.kardex') }}
            </a>
            <i class="fal fa-chevron-down" id="chevron-{{ $productId }}"></i>
        </div>
    </div>

    <div class="panel-container show" id="product-{{ $productId }}">
        <div class="panel-content p-0">

            {{-- Por almacen --}}
            @foreach($productData['warehouses'] as $whCode => $whData)
            <div style="border-left:4px solid #185FA5;margin:8px;border-radius:4px;">
                <div style="background:#E6F1FB;padding:6px 12px;border-radius:4px 4px 0 0;display:flex;justify-content:space-between;align-items:center;">
                    <div>
                        <i class="fal fa-warehouse me-2" style="color:#185FA5;"></i>
                        <strong style="color:#0C447C;">{{ $whCode }}</strong>
                        <span style="font-size:11px;color:#185FA5;margin-left:4px;">{{ $whData['name'] }}</span>
                    </div>
                    <div class="d-flex gap-2">
                        @if($whData['unrestricted'] > 0)
                        <span style="font-size:11px;background:#28a745;color:#fff;padding:1px 8px;border-radius:3px;">{{ number_format($whData['unrestricted'], 2) }} {{ __('warehouse.avail-lower') }}</span>
                        @endif
                        @if($whData['blocked'] > 0)
                        <span style="font-size:11px;background:#dc3545;color:#fff;padding:1px 8px;border-radius:3px;">{{ number_format($whData['blocked'], 2) }} {{ __('warehouse.blocked-lower') }}</span>
                        @endif
                        <span style="font-size:11px;color:#185FA5;font-weight:600;">${{ number_format($whData['value'], 2) }}</span>
                    </div>
                </div>

                {{-- Por zona --}}
                @foreach($whData['zones'] as $zoneCode => $zoneData)
                <div style="margin:4px 8px;">
                    <div style="background:#f8f9fa;padding:4px 10px;border-radius:4px;display:flex;justify-content:space-between;align-items:center;margin-bottom:2px;">
                        <div>
                            <span class="badge bg-{{ $zoneData['color'] }}" style="font-size:10px;">{{ $zoneCode }}</span>
                            <span style="font-size:11px;color:#6c757d;margin-left:4px;">{{ $zoneData['zone_name'] }}</span>
                        </div>
                        <span style="font-size:11px;color:#6c757d;">{{ number_format($zoneData['total_qty'], 2) }} {{ __('warehouse.units-lower') }}</span>
                    </div>

                    {{-- Lotes --}}
                    @foreach($zoneData['lots'] as $lot)
                    <div style="display:flex;align-items:center;gap:8px;padding:4px 10px;border-bottom:1px solid #f0f0f0;font-size:11px;"
                         onclick="showBinDetailModal({{ $lot['lot_id'] }}, '{{ $lot['lot_number'] }}', '{{ $lot['bin_id'] }}', '{{ $lot['bin_code'] }}', '{{ $productData['product_name'] }}', {{ $lot['quantity'] }}, '{{ $lot['stock_type_name'] }}', '{{ $lot['stock_type_color'] }}', '{{ $lot['unit_cost'] }}', '{{ $lot['entry_date'] }}', {{ $productId }})"
                         style="cursor:pointer;">
                        {{-- FIFO indicator --}}
                        @if($loop->first && !($zoneData['is_quality_hold'] ?? false))
                        <span style="background:#28a745;color:#fff;font-size:9px;padding:1px 5px;border-radius:2px;font-weight:600;white-space:nowrap;">{{ __('warehouse.next') }}</span>
                        @else
                        <span style="background:#dee2e6;color:#6c757d;font-size:9px;padding:1px 5px;border-radius:2px;">{{ $loop->iteration }}</span>
                        @endif

                        {{-- Lot number --}}
                        <code style="font-size:10px;color:#185FA5;min-width:130px;">{{ $lot['lot_number'] }}</code>

                        {{-- Stock type — color y nombre vienen del catálogo warehouse_stock_types (regla 6) --}}
                        <span class="badge" style="font-size:9px;background-color:{{ $lot['stock_type_color'] }};">{{ $lot['stock_type_name'] }}</span>

                        {{-- Bin --}}
                        @if($lot['bin_id'])
                        <span style="background:#E6F1FB;color:#0C447C;padding:1px 6px;border-radius:3px;font-family:monospace;font-size:10px;">{{ $lot['bin_id'] }}</span>
                        <span style="color:#6c757d;font-size:10px;">{{ $lot['bin_code'] }}</span>
                        @endif

                        {{-- Qty --}}
                        <span style="margin-left:auto;font-weight:600;color:{{ $lot['stock_type_available'] ? '#212529' : $lot['stock_type_color'] }};">
                            {{ number_format($lot['quantity'], 2) }}
                        </span>

                        {{-- Cost --}}
                        <span style="color:#6c757d;min-width:90px;text-align:right;">${{ number_format($lot['unit_cost'], 2) }}</span>

                        {{-- Entry date --}}
                        <span style="color:#6c757d;min-width:80px;text-align:right;">{{ $lot['entry_date'] }}</span>

                        {{-- Block reason --}}
                        @if($lot['block_reason'])
                        <span title="{{ $lot['block_reason'] }}" style="color:#dc3545;cursor:help;">
                            <i class="fal fa-info-circle"></i>
                        </span>
                        @endif
                    </div>
                    @endforeach

                </div>
                @endforeach
            </div>
            @endforeach

        </div>
    </div>
</div>
@empty
<div class="panel">
    <div class="panel-container show">
        <div class="panel-content text-center py-5 text-muted">
            <i class="fal fa-box-open fa-3x d-block mb-3 opacity-25"></i>
            {{ __('warehouse.no-stock-found') }}
        </div>
    </div>
</div>
@endforelse

{{-- Modal detalle del bin/lote --}}
<div class="modal fade" id="binDetailModal" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog modal-dialog-centered">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title"><i class="fal fa-map-marker-alt me-2"></i><span id="bdmBinId"></span></h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
            </div>
            <div class="modal-body">
                <table class="table table-sm table-borderless mb-0">
                    <tr><td class="text-muted small" style="width:120px;">{{ __('warehouse.bin-id') }}</td><td class="fw-bold"><code id="bdmBinIdVal"></code></td></tr>
                    <tr><td class="text-muted small">{{ __('warehouse.bin-code') }}</td><td id="bdmBinCode"></td></tr>
                    <tr><td class="text-muted small">{{ __('warehouse.lot-number') }}</td><td class="fw-bold text-primary" id="bdmLotNumber"></td></tr>
                    <tr><td class="text-muted small">{{ __('warehouse.product') }}</td><td class="fw-bold" id="bdmProduct"></td></tr>
                    <tr><td class="text-muted small">{{ __('warehouse.quantity') }}</td><td class="fw-bold text-success" id="bdmQty"></td></tr>
                    <tr><td class="text-muted small">{{ __('warehouse.unit-cost-lbl') }}</td><td id="bdmCost"></td></tr>
                    <tr><td class="text-muted small">{{ __('warehouse.entry-date') }}</td><td id="bdmDate"></td></tr>
                    <tr><td class="text-muted small">{{ __('warehouse.stock-type') }}</td><td id="bdmType"></td></tr>
                </table>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary btn-sm" data-bs-dismiss="modal">{{ __('warehouse.close') }}</button>
                <a href="#" id="bdmLotLink" class="btn btn-outline-primary btn-sm">
                    <i class="bi bi-box-seam me-1"></i> {{ __('warehouse.view-lot') }}
                </a>
                <a href="#" id="bdmKardexLink" class="btn btn-primary btn-sm">
                    <i class="fal fa-history me-1"></i> {{ __('warehouse.view-kardex') }}
                </a>
            </div>
        </div>
    </div>
</div>

@endsection

@section('scripts')
<script>
function toggleProduct(id) {
    var el  = document.getElementById('product-' + id);
    var chv = document.getElementById('chevron-' + id);
    if (el.style.display === 'none') {
        el.style.display = 'block';
        chv.className = 'fal fa-chevron-down';
    } else {
        el.style.display = 'none';
        chv.className = 'fal fa-chevron-right';
    }
}

function showBinDetailModal(lotId, lotNumber, binId, binCode, product, qty, stockTypeName, stockTypeColor, unitCost, entryDate, productId) {
    document.getElementById('bdmBinId').textContent     = binId || lotNumber;
    document.getElementById('bdmBinIdVal').textContent  = binId || '--';
    document.getElementById('bdmBinCode').textContent   = binCode || '--';
    document.getElementById('bdmLotNumber').textContent = lotNumber;
    document.getElementById('bdmProduct').textContent   = product;
    document.getElementById('bdmQty').textContent       = parseFloat(qty).toLocaleString('es-MX', {minimumFractionDigits:2}) + ' {{ __('warehouse.units-lower') }}';
    document.getElementById('bdmCost').textContent      = '$' + parseFloat(unitCost).toLocaleString('es-MX', {minimumFractionDigits:2});
    document.getElementById('bdmDate').textContent      = entryDate;
    document.getElementById('bdmType').innerHTML        = '<span class="badge" style="background-color:' + (stockTypeColor || '#6c757d') + ';">' + stockTypeName + '</span>';
    document.getElementById('bdmLotLink').href          = '/warehouse/lots/' + lotId;
    document.getElementById('bdmKardexLink').href       = '/warehouse/inventory/kardex/' + productId;
    new bootstrap.Modal(document.getElementById('binDetailModal')).show();
}
</script>
@endsection