@isset($activo)
    

       
   
      
    @php    
      // header('Content-type:application/xls');
      // header('Content-Disposition: attachment; filename=nombre_archivo.xls');

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




 
      @endphp




 
@endisset



 <table class="table table-striped  table-bordered scroll-table-container" id="tablep">
    <thead>
      <tr>
        <th scope="col" class="texto" >codigo</th>
        <th scope="col">nombre</th>
        <th scope="col">tipoiva</th>
        <th scope="col">iva</th>
        <th scope="col">base</th>
        <th scope="col">Valor</th>
        <th scope="col">Valor_Sin_Iva</th>
        <th scope="col">CAJA</th>                
        <th scope="col">FRCC</th>
        <th scope="col">Total_Costo_Con_Iva</th>
        <th scope="col">Total_Costo_SIn_Iva</th>
        <th scope="col">Utilidad_Con_Iva</th>
        <th scope="col">Utilidad_Sin_Iva</th>
        <th scope="col">bodega</th>
        <th scope="col">Categoria</th>
        
        @isset($vendedor)
        <th scope="col">Vendedor</th>
        @endisset
        
        
      </tr>
    </thead>
    <tbody>
     
        @isset($produc)
        

       

       
 
     
          @foreach ($produc as $item)
        <tr>

            <th  style="mso-number-format:'@';">{{$item["codigo"]}}</th>
            <td>{{$item["nombre"]}}</td>
            <td>{{$item["tipoiva"]}}</td>
           @if($dtoVenta>0)


                <td>{{$item["iva"]-(($item["iva"]/100)*$dtoVenta)}}</td>
                <td>{{$item["base"] -(($item["base"]/100)*$dtoVenta)}}</td>
                <td>{{$item["valor"] -(($item["valor"]/100)*$dtoVenta)}}</td>

                @php
                $valorsiniva=$item["valor"]-$item["iva"];
                $tcostoConiva=round($item["Tota_costo_Caja_con_iva"]+$item["Tota_costo_Frcc_con_iva"],0);
                $tcostoSiniva=round($item["Tota_costo_Caja_sin_iva"]+$item["Tota_costo_Frcc_sin_iva"],0);
                $utilidaConiva=round($item["valor"]-$item["Tota_costo_Caja_con_iva"]-$item["Tota_costo_Frcc_con_iva"],0);
                $utilidaSiniva=round($item["valor"]-$item["iva"]-$item["Tota_costo_Caja_sin_iva"]-$item["Tota_costo_Frcc_sin_iva"],0);

                @endphp
                <td>{{$valorsiniva-(($valorsiniva/100)*$dtoVenta)}}</td>
                <td>{{$item["CAJA"]}}</td>
                <td>{{$item["FRCC"]}}</td>
                <td>{{$tcostoConiva-(($tcostoConiva/100)*$dtoVenta)}}</td>
                <td>{{$tcostoSiniva-(($tcostoSiniva/100)*$dtoVenta)}}</td>
                <td>{{$utilidaConiva-(($utilidaConiva/100)*$dtoVenta)}}</td>
                <td>{{$utilidaSiniva-(($utilidaSiniva/100)*$dtoVenta)}}</td>
                <td>{{$item["bodegaVenta"]}}</td>
                <td>{{$item["nomcategoria"]}}</td>



           @else
                <td>{{$item["iva"]}}</td>
                <td>{{$item["base"]}}</td>
                <td>{{$item["valor"]}}</td>
                <td>{{$item["valor"]-$item["iva"]}}</td>
                <td>{{$item["CAJA"]}}</td>
                <td>{{$item["FRCC"]}}</td>
                <td>{{round($item["Tota_costo_Caja_con_iva"]+$item["Tota_costo_Frcc_con_iva"],0)}}</td>
                <td>{{round($item["Tota_costo_Caja_sin_iva"]+$item["Tota_costo_Frcc_sin_iva"],0)}}</td>
                <td>{{round($item["valor"]-$item["Tota_costo_Caja_con_iva"]-$item["Tota_costo_Frcc_con_iva"],0)}}</td>
                <td>{{round($item["valor"]-$item["iva"]-$item["Tota_costo_Caja_sin_iva"]-$item["Tota_costo_Frcc_sin_iva"],0)}}</td>
                <td>{{$item["bodegaVenta"]}}</td>
                <td>{{$item["nomcategoria"]}}</td>
            @endif

            @isset($vendedor)
            <td>{{$item["vendedor"]}}</td>            
            @endisset
            
          </tr>
       
        @endforeach 
       
        @endisset 
        
    
     
    </tbody>
  </table>