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

     

      @endphp

 
@endisset


   
<table class="table table-striped  table-bordered scroll-table-container " style="margin-top: 15px;" id="tablep">
    <thead>
      <tr>
     
        <th scope="col" >Numero</th>
        <th scope="col" >Codigo</th>
        <th scope="col">Nombre Producto</th>
        <th scope="col">Caja</th>
        <th scope="col">Frcc</th>
        <th scope="col">Saldo_F_Caja</th>
        <th scope="col">Saldo_F_Frcc</th>
        <th scope="col">Movimiento</th>
        <th scope="col">Detalle</th>
        <th scope="col">Nota</th>
        @if(session()->get("BloqValoresAdmin") != "hidden")
        <th scope="col" >Valor_Caja</th>  
        <th scope="col">Valor_Frcc</th> 
        <th scope="col">TotalMovimiento</th> 
        @endif
        <th scope="col">Fecha</th> 
        <th scope="col">Vinculado</th>    
        <th scope="col">Bodega</th> 
        <th scope="col">Usuario</th>
       

       
        
      
      </tr>
    </thead>

  @isset($datos) 
    <tbody id="tablaVencimeintos">
       @php $granTotal = 0; @endphp
       @foreach ($datos as $item)
        
      @php 
        $caja_num = is_numeric($item->caja) ? $item->caja : 0;
        $frcc_num = is_numeric($item->frcc) ? $item->frcc : 0;
        $valorCaja_num = is_numeric($item->valoUnitcaja) ? $item->valoUnitcaja : 0;
        $valorFrcc_num = is_numeric($item->valorUnifrcc) ? $item->valorUnifrcc : 0;

        $totalFila = ($caja_num * $valorCaja_num) + ($frcc_num * $valorFrcc_num);
        $granTotal += $totalFila;
      @endphp

      <tr>
        <th style="mso-number-format:'\@';">{{$item->numero}}</th>
        <th style="mso-number-format:'\@';">{{$item->producto}}</th>
        <td style="mso-number-format:'\@';">{{$item->nombre}}</td>
        <td >{{$item->caja}}</td>
        <td >{{$item->frcc}}</td>
        <td style="mso-number-format:'\@';">{{$item->inventarioo}}</td>
        <td style="mso-number-format:'\@';">{{round($item->inventFrcc)}}</td>
        
        
        <td  style="mso-number-format:'\@';">{{$item->tipo}}</td>
        <td style="mso-number-format:'\@';">{{$item->detalle}}</td>
        <td style="mso-number-format:'\@';">{{$item->NOTA ?? ''}}</td>
        @if(session()->get("BloqValoresAdmin") != "hidden")
        <td >{{$item->valoUnitcaja}}</td>
        <td >{{$item->valorUnifrcc}}</td>
        <td >${{number_format($totalFila, 0, ',', '.')}}</td>
        @endif

        <td >{{$item->fecha}}</td>
        <td style="mso-number-format:'\@';">{{$item->cliente}}</td>
        <td >{{$item->idbodegaK}}</td>
        <td >{{$item->usuariok}}</td>
       
        
            
        
      </tr>
          
    @endforeach
    
</tbody>

  @endisset

</table> 

@if(session()->get("BloqValoresAdmin") != "hidden")
@isset($datos)
<table>
  <tr>
    <td></td>
  </tr>
  <tr>
    <td colspan="12" style="text-align: right; font-weight: bold; font-size: 14px;">GRAN TOTAL MOVIMIENTOS:</td>
    <td style="font-weight: bold; font-size: 14px; background-color: #f2f2f2;">${{number_format($granTotal, 0, ',', '.')}}</td>
  </tr>
</table>
@endisset
@endif