source: newwww/finance/zarizeni.php@ 3

<?
include('../style.php');
include('../db.php');
//include('../is/global.php');
DB_Init('localhost','root','','is');
DB_Query('SET CHARACTER SET latin2');
ShowHeader('Zaøízení sítì','Zaøízení');

// Seznam segmentù a zaøízení
echo('Seznam segmentù a zaøízení:<br><table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3"><tr><th>Název</th><th>Spotøeba<br>[W]</th><th>Datum<br>zakoupení</th><th>Cena [Kè]</th></tr>');
DB_Query("SELECT * FROM network_segments");    
while($Row = DB_Row())
{
  echo('<tr><td colspan="3"><strong>Segment: '.$Row['name'].' ('.$Row['users'].')</strong></td><td style="font-weight: Bold;" align="right">'.$Row['price'].'</td></tr>');
  DB_Save();
  DB_Query("SELECT * FROM network_devices WHERE segment=".$Row['id']." AND used=1");
  while($Row = DB_Row())
  {
    echo('<tr><td>'.$Row['name'].'</td><td align="right">'.$Row['consumption'].'</td><td align="right">'.HumanDate($Row['date']).'</td><td align="right">'.$Row['price'].'</td></tr>');
  }
  DB_Load();
}
DB_Query("SELECT SUM(price) FROM network_devices WHERE used=1");
$Row = DB_Row();
echo('<tr><td colspan="3"><strong>Celkem:</strong></td><td align="right"><strong>'.$Row[0].'</strong></td></tr>');
echo('</table>');

ShowFooter();
?>