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

     

      @endphp

 
@endif



<table class="table table-striped  table-bordered scroll-table-container " style="margin-top: 3%" id="">
          <thead>
            <tr>
              <th scope="col" >Codigo</th>
              <th scope="col">NombreP</th>
              <th scope="col">factor</th>
              <th scope="col">CajaCompra</th>
              <th scope="col">FrccCompra</th>  

              <th scope="col">CajaEntrada</th> 
              <th scope="col">FrccEntrada</th>

              <th scope="col">CajaTraslado</th>  
              <th scope="col">FrccTraslado</th>  

             

                         
              <th scope="col">TotalIngresoCaja</th>            
              <th scope="col">TotalEquival_Frcc </th>

              <th scope="col">CostoIngreso</th>

              <th scope="col">SalidaCaja</th>
              <th scope="col">SalidaFrcc</th>

             <th scope="col">SalidaCajaTras</th>
              <th scope="col">SalidaFrccTras</th>

              <th scope="col">CajaVenta</th>
              <th scope="col">FrccVenta</th>
              <th scope="col">PrecioVenta</th>

              <th scope="col">TotalRotadoCaja</th>
              <th scope="col">TotalRTEquival_Frcc</th>
              <th scope="col">Inventario</th>
              <th scope="col">bodega</th>
                        
             
            
            
            </tr>
          </thead>
      
        
          <tbody id="">
               @isset($productos)
                     
                  @foreach($productos as $item )
                       
                        <tr>
                        <td style="mso-number-format:'@';">{{$item["codigo"]}}</td>
                        <td style="mso-number-format:'@';">{{$item["nombre"]}}</td>
                        <td >{{$item["factor"]}}</td>
                        
                        <td >{{$item["CajaCompra"]}}</td>
                        <td >{{$item["FrccCompra"]}}</td>
                      
                        <td >{{$item["CajaEntrada"]}}</td>
                        <td >{{$item["FrccEntrada"]}}</td>

                        <td >{{$item["CajaEntradaTraslado"]}}</td>
                        <td >{{$item["FrccEntradaTraslado"]}}</td>
                        

                        <td >{{$item["TotalRotadoIngresoCaja"]}}</td>
                        <td >{{round($item["TotalRotadoIngresoCaja"]*$item["factor"])}}</td>


                        <td >{{$item["CostoIngresoCaja"]+$item["CostoIngresoFrcc"]}}</td>

                        <td >{{$item["CajaSalida"]}}</td>
                        <td >{{$item["FrccSalida"]}}</td>
                        
                        <td >{{$item["CajaSalidaTraslado"]}}</td>
                        <td >{{$item["FrccSalidaTraslado"]}}</td>

                        <td >{{$item["CajaVenta"]}}</td>
                        <td >{{$item["FrccVenta"]}}</td>
                        <td >{{$item["valorVentaCaja"]+$item["valorVentaFrcc"]}}</td>
                        <td >{{round( $item["TotalRotadoVentaCaja"],3)}}</td>
                        <td >{{ round( $item["TotalRotadoVentaCaja"]*$item["factor"])}}</td>
                        
                        <td >{{$item["inventario"]}}</td>
                        <td >{{$item["bodega"]}}</td>
                        
                    </tr>

                  @endforeach
               
               @endisset
         
         </tbody>
      
     
      
      </table>