public function ventasExport($fechai,$fechaf){

$fechaIi=$fechai." 00:00:00";  
$fechaff=$fechaf." 23:59:59";   

$totalCostoiva=0;
$totalCostosiniva=0;
$rentabilidadConIva=0;
$rentabilidadSinIva=0;

$ventaTotaliva=0;
$ventaTotalsiniva=0;

$ventas=ventas::whereRaw("(fecha >='$fechaIi' AND fecha <='$fechaff' and devolucion=0)")->join('productos', 'codigoProducto', '=', 'productos.codigo')                    
->select("codigo","nombre","tipoiva",DB::raw('SUM(valor) as valor'),DB::raw('SUM(iva) as iva'),DB::raw('SUM(cantCaja) as CAJA'),DB::raw('SUM(cantfrcc) as FRCC'),DB::raw('SUM(base) as base'),"ventas.costoCaja","ventas.costoFrcc")->groupBy('codigo',"nombre","tipoiva","ventas.costoCaja","ventas.costoFrcc")->get();



foreach ($ventas as $key => $value) {

 $TCostoCaja=$value->costoCaja * $value->CAJA;      
 $TCostoFrcc=$value->costoFrcc * $value->FRCC;

  

 $ventas[$key]["Tota_costo_Caja_con_iva"]=$TCostoCaja;
 $ventas[$key]["Tota_costo_Frcc_con_iva"]=$TCostoFrcc;

  if($value->tipoiva==19){

   $TCostoCajaSinIva=($value->costoCaja / 1.19)* $value->CAJA;
   $TCostoFrccSinIva=($value->costoFrcc / 1.19)* $value->FRCC;

   $ventas[$key]["Tota_costo_Caja_sin_iva"]= $TCostoCajaSinIva;
   $ventas[$key]["Tota_costo_Frcc_sin_iva"]= $TCostoFrccSinIva;

  }else{
     if($value->tipoiva==5){
       
       $TCostoCajaSinIva=($value->costoCaja / 1.05)* $value->CAJA;
       $TCostoFrccSinIva=($value->costoFrcc / 1.05)* $value->FRCC;

       $ventas[$key]["Tota_costo_Caja_sin_iva"]= $TCostoCajaSinIva;
       $$ventas[$key]["Tota_costo_Frcc_sin_iva"]= $TCostoFrccSinIva;

     }else{
       $TCostoCajaSinIva=($value->costoCaja)* $value->CAJA;
       $TCostoFrccSinIva=($value->costoFrcc)* $value->FRCC;

       $ventas[$key]["Tota_costo_Caja_sin_iva"]= $TCostoCajaSinIva;
       $ventas[$key]["Tota_costo_Frcc_sin_iva"]= $TCostoFrccSinIva;
     }
  }

  
  $totalCostoiva=$totalCostoiva+$TCostoCaja+ $TCostoFrcc;
  $totalCostosiniva= $totalCostosiniva+ $TCostoCajaSinIva+$TCostoFrccSinIva;


  $ventaTotaliva= $ventaTotaliva+$value->valor;
  $ventaTotalsiniva=$ventaTotalsiniva+$value->valor-$value->iva;

  

  $rentabilidadConIva=$value->valor- $TCostoCaja+ $TCostoFrcc;
  $rentabilidadSinIva=$value->valor-$TCostoCajaSinIva+$TCostoFrccSinIva-$value->iva;
  $ventas[$key]["utilidad_Con_Iva"]= $rentabilidadConIva;
  $ventas[$key]["utilidad_sin_iva"]=  $rentabilidadSinIva;

 
}

$TotalrentabilidadConIva=$ventaTotaliva-$totalCostoiva;
$TotalrentabilidadSinIva= $ventaTotalsiniva- $totalCostosiniva;

$this->Venta_Total_Con_Iva=$ventaTotaliva;
$this->Venta_Total_Sin_Iva=$ventaTotalsiniva;

$this->Total_utilidad_Con_iva=$TotalrentabilidadConIva;
$this->Total_utilidad_Sin_iva=$TotalrentabilidadSinIva;

                      

// $this->productos=$this->agrupar($ventas);

// GARUPACION DE PRODUCTOS REPETIDOS

                          


return view("menu.exportar",["produc"=> $ventas,"activo"=>1]);
}