@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="exportarProductos">
          <thead>
            <tr>
              <th scope="col" >Codigo_Producto</th>
              <th scope="col">Nombre_Producto</th>
              <th scope="col">Caja</th>
              <th scope="col">costcaja</th>
              <th scope="col">Frcc</th>     
              <th scope="col">costofrcc</th>   
              <th scope="col">base</th>
              <th scope="col">iva</th>             
              <th scope="col">Tipo_Iva</th>            
              <th scope="col">total </th>
              <th scope="col">fechacomp </th>
              <th scope="col">Numero Fact </th>
              <th scope="col">provedor </th> 

              <th scope="col">Marca </th> 
              <th scope="col">Categoria </th> 
              <th scope="col">Lote </th>
              <th scope="col">Vencimeinto </th>
              
              <th scope="col">bodega </th>
                        
             
            
            
            </tr>
          </thead>
      
        
          <tbody id="">
               @isset($productoCom)
                        @php
                        $totalComp=0;
                        @endphp
                  @foreach($productoCom as $item )
                        @php
                        $totalComp=$totalComp+$item->total;
                        @endphp
                        <tr>
                        <td style="mso-number-format:'@';">{{$item->cproducto}}</td>
                        <td style="mso-number-format:'@';">{{$item->nombre}}</td>
                        <td >{{$item->cantcaja}}</td>
                        
                        <td >{{$item->costcaja}}</td>
                        <td >{{$item->cantfrcc}}</td>
                        <td >{{$item->costofrcc}}</td>

                        <td >{{$item->base}}</td>
                        <td >{{$item->iva}}</td>
                        <td >{{$item->tipo}}</td>
                        <td >{{$item->total}}</td>
                        <td >{{$item->fechacomp}}</td>
                        <td >{{$item->numfactur}}</td>
                        <td >{{ !empty($item->nombre_proveedor) && $item->nombre_proveedor !== $item->provedor ? $item->nombre_proveedor . ' (' . $item->provedor . ')' : $item->provedor }}</td>

                        

                        <td >{{$item->nommarca}}</td>
                        <td >{{$item->nomcategoria}}</td>
                        <td >{{$item->lote}}</td>
                        <td >{{$item->fvencimi}}</td>

                        <td >{{$item->idbodegaCo}}</td>
                    
                        
                            
                        
                    </tr>

                  @endforeach
               
               @endisset
         
         </tbody>
      
     
      
      </table> 
     @if($exportar==0) 
      <label for="" class="col-md-3" >Total compra
         <input  type="text" disabled class="form-control bg-warning" value="{{ number_format((float)($totalComp ?? 0))}}"></input>         
    </label>
    <br>
    <br>
@endif