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

        
        @endphp
  @endif   
 
    
   
 
    
  

<table class="table table-striped  table-bordered scroll-table-container">
        <thead>
          <tr>
          <th scope="col" >Bodega</th>
            <th scope="col" >codigo</th>
            <th scope="col">nombre</th> 
            <th scope="col">Dto</th>         
            <th scope="col">inventario</th>
            <th scope="col">Equivalente_En_Fraccion </th>
            <th scope="col">Factor </th>       
            <th scope="col">nommarca</th>
            <th scope="col">Dto Marca</th>
            <th scope="col">Categoria</th>
            <th scope="col">Dto MCategoria</th>
            <th scope="col">Mensaje Prom</th>
            <th scope="col">Costo Caja</th>
            <th scope="col">Venta Caja</th>
            <th scope="col">Costo Frcc</th>
            <th scope="col">Venta Frcc</th>
            
            
           

        
          </tr>
        </thead>
        <tbody>
         
           
            
    
           
         
           
        @isset($productos)
         
              @foreach ($productos as $item)

              
               

                    <tr>
                    <th style="mso-number-format:'@';">{{$item->idbodega}}</th>
                        <th style="mso-number-format:'@';">{{$item->codigo}}</th>
                        <td style="mso-number-format:'@';">{{$item->nombre}}</td>
                        <td>{{$item->descuentoPor}}</td>
                        <td>{{$item->inventario}}</td>
                        <td style="mso-number-format:'@';">{{ round((float)($item->inventario ?? 0) * (float)($item->factor ?? 0)) }}</td>
                        <td>{{$item->factor}}</td>
                        <td>{{$item->nommarca}}</td>
                        <td>{{$item->dtomar}}</td>
                        <td>{{$item->nomcategoria}}</td>
                        <td>{{$item->dtocat}}</td>
                        <td>{{$item->MensajePromo}}</td>

                        <td>{{$item->costocaja}}</td>
                        <td>{{$item->VentaCaja}}</td>
                        <td>{{$item->costofrcc}}</td>
                        <td>{{$item->VentaFrcc}}</td>
                      
                        
                      </tr>
             
              
              
            @endforeach 
           
         @endisset
            
        
         
        </tbody>
      </table>