@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=Listado_claves.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" >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>
      </tr>
    </thead>
    <tbody>
     
        @isset($produc)
        
    @php

     $result =[];
                  
foreach($produc as $keyy=>$t) {  
  
  
  if(array_key_exists($t->codigo,$result)){
    $result[$t->codigo]["valor"]= $result[$t->codigo]["valor"]+$t->valor;
    $result[$t->codigo]["iva"]= $result[$t->codigo]["iva"]+$t->iva;  
    $result[$t->codigo]["CAJA"]= $result[$t->codigo]["CAJA"]+$t->CAJA;
    $result[$t->codigo]["FRCC"]=$result[$t->codigo]["FRCC"]+$t->FRCC;
    $result[$t->codigo]["base"]= $result[$t->codigo]["base"]+$t->base;
    $result[$t->codigo]["costoCaja"]= $result[$t->codigo]["costoCaja"]+$t->costoCaja;
    $result[$t->codigo]["costoFrcc"]= $result[$t->codigo]["costoFrcc"]+$t->costoFrcc;
    $result[$t->codigo]["Tota_costo_Caja_con_iva"]= $result[$t->codigo]["Tota_costo_Caja_con_iva"]+$t->Tota_costo_Caja_con_iva;
    $result[$t->codigo]["Tota_costo_Frcc_con_iva"]=$result[$t->codigo]["Tota_costo_Frcc_con_iva"]+$t->Tota_costo_Frcc_con_iva;
    $result[$t->codigo]["Tota_costo_Caja_sin_iva"]=$result[$t->codigo]["Tota_costo_Caja_sin_iva"]+$t->Tota_costo_Caja_sin_iva;
    $result[$t->codigo]["Tota_costo_Frcc_sin_iva"]=$result[$t->codigo]["Tota_costo_Frcc_sin_iva"]+$t->Tota_costo_Frcc_sin_iva;
    $result[$t->codigo]["utilidad_Con_Iva"]= $result[$t->codigo]["utilidad_Con_Iva"]+$t->utilidad_Con_Iva;
    $result[$t->codigo]["utilidad_sin_iva"]=  $result[$t->codigo]["utilidad_sin_iva"]+$t->utilidad_sin_iva;

  }else{
        $result[$t->codigo]["codigo"]=$t->codigo;
        $result[$t->codigo]["nombre"]=$t->nombre;
        $result[$t->codigo]["tipoiva"]=$t->tipoiva;
        $result[$t->codigo]["valor"]= $t->valor;
        $result[$t->codigo]["iva"]= $t->iva;  
        $result[$t->codigo]["CAJA"]=$t->CAJA;
        $result[$t->codigo]["FRCC"]=$t->FRCC;
        $result[$t->codigo]["base"]=$t->base;
        $result[$t->codigo]["costoCaja"]=$t->costoCaja;
        $result[$t->codigo]["costoFrcc"]=$t->costoFrcc;
        $result[$t->codigo]["Tota_costo_Caja_con_iva"]= $t->Tota_costo_Caja_con_iva;
        $result[$t->codigo]["Tota_costo_Frcc_con_iva"]= $t->Tota_costo_Frcc_con_iva;
        $result[$t->codigo]["Tota_costo_Caja_sin_iva"]=$t->Tota_costo_Caja_sin_iva;
        $result[$t->codigo]["Tota_costo_Frcc_sin_iva"]= $t->Tota_costo_Frcc_sin_iva;
        $result[$t->codigo]["utilidad_Con_Iva"]= $t->utilidad_Con_Iva;
        $result[$t->codigo]["utilidad_sin_iva"]= $t->utilidad_sin_iva;
  }


}

@endphp
       
 
     
          @foreach ($result as $item)
        <tr>
            <th>{{$item["codigo"]}}&nbsp;</th>
            <td>{{$item["nombre"]}}</td>
            <td>{{$item["tipoiva"]}}</td>
            <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["utilidad_Con_Iva"],0)}}</td>
            <td>{{round($item["utilidad_sin_iva"],0)}}</td>
            
          </tr>
       
        @endforeach 
       
        @endisset 
        
    
     
    </tbody>
  </table>