@if(isset($esExcel) && $esExcel)
    @php    
        header("Cache-Control: maxage=1");
        header("Pragma: public");
        header('Content-type: application/vnd.ms-excel');
        header("Content-Disposition: attachment; filename=Sugerido_Matriz_V2.xls");
        header("Pragma: no-cache");
        header("Expires: 0"); 
    @endphp

    <table border="1">
        <thead>
            <tr style="background-color: #000; color: #fff;">
                <th>Código</th>
                <th>Barras</th>
                <th>Producto</th>
                <th>Marca</th>
                <th>Categoría</th>
                <th>Rot. Total</th>
                <th>Inv. Total</th>
                <th>Prov. Sugerido</th>
                <th>Costo Compra Sug.</th>
                @foreach($bodegas as $b)
                    <th>{{$b->nombreBodega}} (Inv)</th>
                    <th>{{$b->nombreBodega}} (Pedir)</th>
                @endforeach
                <th>Total Sugerido</th>
            </tr>
        </thead>
        <tbody>
            @foreach($matriz as $p)
                <tr>
                    <td>{{$p['codigo']}}</td>
                    <td>{{$p['barras']}}</td>
                    <td>{{$p['nombre']}}</td>
                    <td>{{$p['nommarca']}}</td>
                    <td>{{$p['nomcategoria']}}</td>
                    <td>{{$p['ventaTotalEmpresa']}}</td>
                    <td>{{$p['inventarioTotalEmpresa']}}</td>
                    <td>{{$p['provSugerido'] ?? 'Sin compras'}}</td>
                    <td>{{isset($p['provCosto']) && $p['provCosto'] > 0 ? $p['provCosto'] : 'N/A'}}</td>
                    @foreach($bodegas as $b)
                        @php $data = $p['dataBodegas'][$b->id] ?? ['stock' => 0, 'pedir' => 0]; @endphp
                        <td>{{$data['stock']}}</td>
                        <td>{{$data['pedir']}}</td>
                    @endforeach
                    <td style="font-weight: bold;">{{$p['sugeridoTotalEmpresa']}}</td>
                </tr>
            @endforeach
        </tbody>
    </table>

@else
    @php
        $filecontent = "";
        foreach($matriz as $p) {
            if($consolidado) {
                if($p['sugeridoTotalEmpresa'] > 0) {
                    // Formato Consolidado: Prefijo 12345 + Codigo + Nombre + Total
                    $filecontent .= "12345\t".$p['codigo']."\t".$p['nombre']."\t".$p['sugeridoTotalEmpresa']."\n";
                }
            } else {
                foreach($p['dataBodegas'] as $bodId => $data) {
                    if($data['pedir'] > 0) {
                        // Formato Detallado: ID Bodega + Codigo + Nombre + Pedir
                        $filecontent .= $bodId."\t".$p['codigo']."\t".$p['nombre']."\t".$data['pedir']."\n";
                    }
                }
            }
        }

        $filename = $consolidado ? "sugerido_consolidado.txt" : "sugerido_por_bodegas.txt";
        
        header("Content-disposition: attachment; filename=$filename");
        header("Content-Type: application/force-download");
        header("Content-Transfer-Encoding: binary");
        header("Content-Length: ".strlen($filecontent));
        header("Pragma: no-cache");
        header("Expires: 0");
        
        echo $filecontent;
    @endphp
@endif