source: trunk/finance/zarizeni.php@ 438

<?php

include_once('../Common/Global.php');

class FinanceDeviceListPage extends Page
{
  var $FullTitle = 'Zařízení sítě';
  var $ShortTitle = 'Zařízení';

  function Show()
  {
    // Seznam segmentů a zařízení
    $Output = 'Seznam segmentů a zařízení:<br><table style="font-size: smaller;" class="WideTable"><tr><th>Název</th><th>Spotřeba<br>[W]</th><th>Datum<br>zakoupení</th><th>Cena [Kč]</th></tr>';
    $DbResult = $this->Database->query('SELECT * FROM NetworkSegment');    
    while($Segment = $DbResult->fetch_array())
    {
      $Output .= '<tr><td style="text-align: left" colspan="3"><strong>Segment: '.$Segment['Name'].' ('.$Segment['Users'].')</strong></td><td style="font-weight: Bold;" align="right">'.$Segment['Price'].'</td></tr>';
      $DbResult2 = $this->Database->query('SELECT * FROM Product WHERE Segment='.$Segment['Id'].' AND used=1');
      while($Row = $DbResult2->fetch_array())
      {
        $Output .= '<tr><td style="text-align: left; padding-left: 20px;">'.$Row['Name'].'</td><td align="right">'.$Row['Consumption'].'</td><td align="right">'.HumanDate($Row['Date']).'</td><td align="right">'.$Row['Price'].'</td></tr>';
      }
    }
    $DbResult = $this->Database->query('SELECT SUM(Price) FROM Product WHERE Used=1');
    $Row = $DbResult->fetch_array();
    $Output .= '<tr><td colspan="3"><strong>Celkem:</strong></td><td align="right"><strong>'.$Row[0].'</strong></td></tr>';
    $Output .= '</table>';
    return($Output);
  }
}

$System->AddModule(new FinanceDeviceListPage());
$System->Modules['FinanceDeviceListPage']->GetOutput()

?>