'; $DbResult = $this->Database->query('SELECT * FROM network_segments'); while($Row = $DbResult->fetch_array()) { $Output .= ''; $DbResult2 = $this->Database->query('SELECT * FROM network_devices WHERE segment='.$Row['id'].' AND used=1'); while($Row = $DbResult2->fetch_array()) { $Output .= ''; } } $DbResult = $this->Database->query('SELECT SUM(price) FROM network_devices WHERE used=1'); $Row = $DbResult->fetch_array(); $Output .= ''; $Output .= '

Název	Spotřeba [W]	Datum zakoupení	Cena [Kč]
Segment: '.$Row['name'].' ('.$Row['users'].')			'.$Row['price'].'
'.$Row['name'].'	'.$Row['consumption'].'	'.HumanDate($Row['date']).'	'.$Row['price'].'
Celkem:			'.$Row[0].'

'; return($Output); } } $System->AddModule(new FinanceDeviceListPage()); $System->Modules['FinanceDeviceListPage']->GetOutput() ?>