Calculator Results

<?php

//-----------------------------------------------------------------------------------------------------
// Contenidos dinámicos (2 iguales en EN y ES)
// Calculator-results y Resultados-de-la-calculadora
//-----------------------------------------------------------------------------------------------------
// Recoger parámetros del formulario POST
//-----------------------------------------------------------------------------------------------------
//var_dump($_POST);
$edit = $_POST['submitted'];
$parametros = str_replace(' ','',print_r($edit,TRUE));

$afp = $edit['afp'];
$maxd = $edit['maxd'];
$dfp = $edit['dfp'];
$energy = $edit['energy'];
$invd = $edit['invd'];

//print "<p> Todos los parametros=".$parametros."</p>";
//print "<p> Afp=".$afp."</p>";
//print "<p> Maxdemmand=".$maxd."</p>";
//print "<p> Dfp=".$dfp."</p>";
//print "<p> Energy=".$energy."</p>";
//print "<p> Invdemmand=".$invd."</p>";
//print "<p></p> ";

//-----------------------------------------------------------------------------------------------------
// Validar parámetros del formulario POST
//-----------------------------------------------------------------------------------------------------
if ($energy<1) {$energy = 0;}
if ($invd<1) {$invd = 0;}

if ($afp<10 or $maxd<1 or $dfp<90) {
print "<div class='atc-botonera-contacto-contenedor text-center'>";
print "<div class='botonera-wrapper'>";
print "<span><a class='btn btn-default btn-lg calculate-request' href='power-factor-correction-calculator'>Go to the calculator</a></span>";
print "</div>";
print "</div>";
} else {

//-----------------------------------------------------------------------------------------------------
// Calcular resultados
//-----------------------------------------------------------------------------------------------------
$inv = round($energy + $invd, 2);
$chargelow = round($inv*(3/5)*((0.9/($afp/100))-1), 2);
$kvar = round( $maxd*(tan(acos(($afp/100)))-tan(acos(($dfp/100)))), 0);
$bonuses = round($inv*(1/4)*(1-(0.9/($dfp/100))), 2);
$save = $chargelow + $bonuses;

$parametros = "lp=562&afp=".$afp."&maxd=".$maxd."&dfp=".$dfp."&energy=".$energy."&invd=".$invd."&save=".$save."&kvar=".$kvar ;

//-----------------------------------------------------------------------------------------------------
// Create table
//-----------------------------------------------------------------------------------------------------
//CREATE TABLE `Xcalculadora` (
//`uid` float(10,2) NOT NULL,
//`fecha` date NOT NULL,
//`fpactual` float(10,2) NOT NULL,
//`demandamax` float(10,2) NOT NULL,
//`fpdeseado` float(10,2) NOT NULL,
//`energia` float(10,2) NOT NULL,
//`demandafacturable` float(10,2) NOT NULL,
//`ahorro` float(10,2) NOT NULL,
//`kvar` float(10,2) NOT NULL
//);

//-----------------------------------------------------------------------------------------------------
// Guardar log de la calculadora para consultarlo en los listados
//-----------------------------------------------------------------------------------------------------
global $user;
global $language;
$idUser=$user->uid;
$idioma = $language->language;
$fecha = time();

$sqlIN = db_insert('Xcalculadora')
->fields(array(
'uid' => $idUser,
'fecha' => date("Y-m-d H:i:s", $fecha),
'fpactual' => $afp,
'demandamax' => $maxd,
'fpdeseado' => $dfp,
'energia' => $energy,
'demandafacturable' => $invd,
'ahorro' => $save,
'kvar' => $kvar
))
->execute();

//-----------------------------------------------------------------------------------------------------
// Formatear resultados con puntos y comas
//-----------------------------------------------------------------------------------------------------
$sdec='.';
$smil= ',';

$afp = number_format ( $afp, 2, $sdec, $smil) ;
$maxd = number_format ( $maxd, 0, $sdec, $smil);
$dfp = number_format ( $dfp, 2, $sdec, $smil);
$energy = number_format ( $energy, 0, $sdec, $smil);
$invd = number_format ( $invd, 0, $sdec, $smil);

$inv = number_format ( $inv, 0, $sdec, $smil);
$chargelow = number_format ( $chargelow, 0, $sdec, $smil);
$kvar = number_format ( $kvar, 0, $sdec, $smil);
$bonuses = number_format ( $bonuses, 0, $sdec, $smil);
$save = number_format ( $save, 0, $sdec, $smil);

//-----------------------------------------------------------------------------------------------------
// Pintar texto superior de presentación de la pantalla
//-----------------------------------------------------------------------------------------------------
print "<p>Thank you for using our calculator. With this information you already have a clear specification of the compensation that your installation needs. Contact us to obtain a non-binding quotation and delivery time to avoid penalties and enjoy the benefits of an optimal energy quality in your installation.
</p>";

//-----------------------------------------------------------------------------------------------------
// Pintar resultados - TOTALES
//-----------------------------------------------------------------------------------------------------
print "<p class='title-result-table'> Calculation results";
print "<p class='title-result-table grey'> Total saving (Monthly bonus) = <span class='total'>" .$save;
print " </span>";
print "<p class='title-result-table grey'> Required capacitor = <span class='total'>" .$kvar;
print " kVAR </span>";
print "<p> The values of Monthly Total savings (bonus) are approximate; electric utilities may apply other amounts or multipliers according your zone or tariff.";

//-----------------------------------------------------------------------------------------------------
// Pintar resultados - BOTONES
//-----------------------------------------------------------------------------------------------------
print "<div class='atc-botonera-contacto-contenedor text-center'>";
print "<div class='botonera-wrapper'>";

$url1="/en/commercial-contact-pq-lv-calculator";
if($idioma=="es") {$url1="/es/contacto-comercial-de-la-calculadora"; }

print "<span><a class='btn btn-default btn-lg calculate' href='javascript:history.back()'>Calculate again</a></span>";
print "<span><a class='btn btn-default btn-lg calculate-request' href='".$base_url."".$url1."?".$parametros."'>Request a quotation and delivery time</a></span>";

//print "<span><a class='btn btn-default btn-lg calculate' href='javascript:history.back()'>Volver a calcular</a></span>";
//print "<span><a class='btn btn-default btn-lg calculate-request' href='".$base_url."".$url1."?".$parametros."'>Solicitar cotización y plazo de entrega</a></span>";

print "</div>";
print "</div>";

//-----------------------------------------------------------------------------------------------------
// Pintar resultados - DETALLES DEL CALCULO
//-----------------------------------------------------------------------------------------------------
print "<p class='title-result-table'> Calculation details";
print "<p class='title-result-table grey'> Power Factor Charge Penalties";
print "<p> Power = " .$energy;
print "<p> Billable demand = " .$invd;
print "<p> Billing (without VAT or taxes) = " .$inv;
print "<p> Actual Power Factor (PF) = " .$afp;
print "<p><span class='total-result'>Power Factor Charge Penalties = " . $chargelow;
print "</span> Charge = Billing x 3/5 (0.90/PF - 1)</p> ";
//print "</span><img class='img-fp' src='/sites/default/files/cargo-bajo-fp.jpg' alt='Power Factor Charge Penalties'></p> ";
print "<p class='title-result-table grey'> KVAR required to compensate PF";
print "<p> Maximum Demand kW = " .$maxd;
print "<p> % PF = " .$afp;
print "<p> Desired PF = " .$dfp;
print "<p><span class='total-result'>KVAR required (Capacitor) = " .$kvar;
print "</span></p> ";
print "<p class='title-result-table grey'> PF > 90 bonus";
print "<p> Billing = " .$inv;
print "<p> PF Reached = " .$dfp;
print "<p><span class='total-result'>PF > 90 bonus = " .$bonuses;
print "</span> Bonus = Billing x 1/4 (1 - 0.90/PF) </p> ";
//print "</span><img class='img-bnif' src='/sites/default/files/bonificacion.jpg' alt='Power Factor Charge Penalties'></p> ";
print "<p class='title-result-table grey'> Total saving";
print "<p> Power Factor Charge Penalties = " .$chargelow;
print "<p> PF > 90 bonus = " .$bonuses;

//-----------------------------------------------------------------------------------------------------
// Fin de la validación de los parámetros
//-----------------------------------------------------------------------------------------------------
}

?>