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

 
 @endphp
  


<table class="table table-striped  table-bordered scroll-table-container">
     <thead>
       <tr>
         <th scope="col" >codigo</th>
         <th scope="col">nombre</th> 
         <th scope="col">Unida_Medida</th>         
         <th scope="col">inventario</th>
         <th scope="col">Escaneado</th>
         <th scope="col">Diferencia</th>
         <th scope="col">Costo_Unitario</th>
         <th scope="col">Valor_Diferencia</th>
         <th scope="col">Bodega</th>
             
       </tr>
     </thead>
     <tbody>
      
                    
      
        
       
      
           @foreach ($productos as $item)

           @if ($item->factor>0)
               @php
                  $medida="FRCC"; 
                  $inventario =round($item->factor * $item->inventario);                        
                  $costo = $item->costofrcc;
                  $tcosto =$item->DifereCapturaInven * $costo;
               @endphp
          
            @else
                    @php
                        $medida="CAJA"; 
                        $inventario =$item->inventario;                        
                        $costo = $item->costocaja;
                        $tcosto = $item->DifereCapturaInven * $costo;
                   @endphp 
            



         
           

           @endif

                 <tr>
                     <th style="mso-number-format:'@';">{{$item->codigo}}</th>
                     <th style="">{{$item->nombre}}</th>
                     <th >{{$medida}}</th>
                     <th >{{$inventario}}</th>
                     <th >{{$item->Escaneado}}</th>
                     <th >{{$item->DifereCapturaInven}}</th>

                     <th >{{$costo}}</th>
                     
                     <th >{{ $tcosto}}</th>
                     <th >{{ $item->idbodega}}</th>
                     
                   
                        
                   
                     
                   </tr>
          
           
           
         @endforeach 
        
     
         
     
      
     </tbody>
   </table>