@isset($txt)
       @php
           $filecontent="";
       @endphp  
       

     @foreach ($product as $item)
        @if ($item["Pedir"]>0)
          @php
           $plano= "1234"."\t".$item["codigo"]."\t".$item["nombre"]."\t".$item["Pedir"]."\n";
            $filecontent= $filecontent.$plano;
          @endphp
            
        @endif
            
    @endforeach 

    @php 

  
    $downloadfile="plano.txt";
    
    header("Content-disposition: attachment; filename=$downloadfile");
    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 


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



      @endphp


    @endisset


    @isset($product)    
    <table class="table table-striped  table-bordered scroll-table-container " style="margin-top: 3%" id="tablep">
    <thead>
      <tr>
        <th scope="col" >codigo</th>
        <th scope="col" >barras</th>
        <th scope="col" >barras1</th>        

        <th scope="col">nombre</th>
        <th class="col">Pedir</th>
        <th scope="col">totalRotado</th>
        <th scope="col">Pendiente LLegar</th>
        <th scope="col">inventario</th>
        <th scope="col">Costo_Compra</th>
        <th scope="col">Marca</th>
        <th scope="col">Categoria</th>
        
        <th scope="col">Bodega</th>
      
      </tr>
    </thead>
    <tbody id="suger">
    @foreach ($product as $item)
        @if ($item["Pedir"]>0 || $item["P_llegar"]>0 )
        <tr>
            <td style="mso-number-format:'@';">{{$item["codigo"]}}</td>
            <td style="mso-number-format:'@';">{{$item["barras"]}}</td>
            <td style="mso-number-format:'@';">{{$item["barras2"]}}</td>
            <td style="mso-number-format:'@';">{{$item["nombre"]}}</td>
              <td class="venta"  >{{$item["Pedir"]}}</td>
                <td>{{round( $item["totalRotado"],2)}}</td>
                  <td>{{$item["P_llegar"]}}</td>
            
                    <td>{{$item["inventario"]}}</td>
                      <td>{{$item["Costo_Compra"]}}</td>
                        <td>{{$item["nommarca"]}}</td>
                          <td>{{$item["nomcategoria"]}}</td>
            
                            <td>{{$item["bodegaVenta"]}}</td>
        
        
            
          </tr>



            
        @endif
            
    @endforeach




    </tbody>
    </table> 
    @endisset 


@endisset