1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
|
function conso()
{
$params = JComponentHelper::getParams('com_batenergie');
$kwhx_fioul = $params->get('kwhx_fioul', 1);
$kwhx_gas = $params->get('kwhx_gas', 1);
$kwhx_gasp = $params->get('kwhx_gasp', 1);
$kwhx_elec = $params->get('kwhx_elec', 1);
$kwhx_boisp = $params->get('kwhx_boisp', 1);
$kwhx_boisg = $params->get('kwhx_boisg', 1);
$kwhx_boisb = $params->get('kwhx_boisb', 1);
$database =& JFactory::getDBO() ;
$database->setQuery( "SELECT SUM(dpe09_fioul * $kwhx_fioul)
+ (dpe09_gas * $kwhx_gas)
+ (dpe09_gasp * $kwhx_gasp)
+ (dpe09_elec * $kwhx_elec)
+ (dpe09_boisp * $kwhx_boisp)
+ (dpe09_boisg * $kwhx_boisg)
+ (dpe09_boisb * $kwhx_boisb)
FROM #__batenergie
WHERE id='$bat'
" );
if (!$database->query()) {
echo $database->stderr();
return false;
}
return $database->loadResult();
} |
Partager