Changeset 152 for www

Timestamp:

Feb 16, 2009, 2:09:57 PM (16 years ago)

Author:

george

Message:

• Upraveno: Další soubory přepracované do nového systému zobrazování.

Location:

www

Files:

• finance/bill.php (added)
• finance/bills.php (modified) (12 diffs)
• finance/classes.php (deleted)
• finance/clenove.php (modified) (1 diff)
• finance/finance.php (modified) (1 diff)
• finance/include.php (modified) (1 diff)
• finance/index.php (modified) (2 diffs)
• finance/inventory.php (modified) (1 diff)
• finance/manage.php (modified) (2 diffs)
• finance/monthly_overall.php (modified) (1 diff)
• finance/spotreba.php (modified) (1 diff)
• finance/srovnani.php (deleted)
• finance/tarify.php (modified) (1 diff)
• finance/user_state.php (added)
• finance/zarizeni.php (modified) (1 diff)
• finance/zivnost.php (modified) (2 diffs)
• global.php (modified) (2 diffs)
• index.php (modified) (2 diffs)
• user.php (modified) (2 diffs)
• webcam/index.php (modified) (1 diff)

www/finance/bills.php

@@ -1 +1 @@
 <?php
 
-class InvoiceGenerator
+class Bill extends Module
 {
   var $SpecificSymbol = 1; // počítačová sít
@@ -9 +9 @@
   function GenerateBill($BillId)
   {
-    global $Database, $SpecificSymbol;
+    global $SpecificSymbol;
   
-    $DbResult = $Database->select('finance_bills', '*', 'id='.$BillId);
+    $DbResult = $this->Database->select('finance_bills', '*', 'id='.$BillId);
     $Bill = $DbResult->fetch_array();
  
-    $DbResult = $Database->select('users', '*', 'id='.$Bill['user_id']);
+    $DbResult = $this->Database->select('users', '*', 'id='.$Bill['user_id']);
     $User = $DbResult->fetch_array();
 
     $Dodavka = array();
-    $DbResult = $Database->select('finance_bills_items', '*', 'bill_id='.$BillId);
+    $DbResult = $this->Database->select('finance_bills_items', '*', 'bill_id='.$BillId);
     while($Item = $DbResult->fetch_array())
     {
@@ -122 +122 @@
   function CreateBill($UserId, $Items, $TimeFrom, $TimeTo, $BillCode, $Type)
   {
-    global $Database;
-  
-    $Database->insert('finance_bills', array('time_create' => TimeToMysqlDateTime(time()), 'user_id' => $UserId, 'time_from' => TimeToMysqlDateTime($TimeFrom), 'time_to' => TimeToMysqlDateTime($TimeTo), 'time_due' => TimeToMysqlDateTime($TimeFrom + 15*24*3600), 'BillCode' => $BillCode, 'Type' => 'invoice'));
-    $BillId = $Database->insert_id;
+    $this->Database->insert('finance_bills', array('time_create' => TimeToMysqlDateTime(time()), 'user_id' => $UserId, 'time_from' => TimeToMysqlDateTime($TimeFrom), 'time_to' => TimeToMysqlDateTime($TimeTo), 'time_due' => TimeToMysqlDateTime($TimeFrom + 15*24*3600), 'BillCode' => $BillCode, 'Type' => 'invoice'));
+    $BillId = $this->Database->insert_id;
     foreach($Items as $Item)
     {
-      $Database->insert('finance_bills_items', array('bill_id' => $BillId, 'description' => $Item['description'], 'price' => $Item['price'], 'quantity' => $Item['quantity']));
+      $this->Database->insert('finance_bills_items', array('bill_id' => $BillId, 'description' => $Item['description'], 'price' => $Item['price'], 'quantity' => $Item['quantity']));
     }
     //Header('Content-Type: application/pdf');
@@ -134 +132 @@
     //echo($PdfData);
     file_put_contents($this->FileFolder.'/'.$this->FileNamePrefix.$BillId.'.pdf', $PdfData);
-    //$Database->query('UPDATE finance_bills SET pdf = 0x'.bin2hex($PdfData).' WHERE id='.$BillId);
+    //$this->Database->query('UPDATE finance_bills SET pdf = 0x'.bin2hex($PdfData).' WHERE id='.$BillId);
     return($BillId);
   } 
@@ -140 +138 @@
   function CreateIncomeBill($UserId, $Description, $Price, $BillCode)
   {
-    global $Database;
-  
-    $Database->insert('finance_bills', array('time_create' => TimeToMysqlDateTime(time()), 'user_id' => $UserId, 'BillCode' => $BillCode, 'Type' => 'income'));
-    $BillId = $Database->insert_id;
-    $Database->insert('finance_bills_items', array('bill_id' => $BillId, 'description' => $Description, 'price' => $Price, 'quantity' => 1));
+    $this->Database->insert('finance_bills', array('time_create' => TimeToMysqlDateTime(time()), 'user_id' => $UserId, 'BillCode' => $BillCode, 'Type' => 'income'));
+    $BillId = $this->Database->insert_id;
+    $this->Database->insert('finance_bills_items', array('bill_id' => $BillId, 'description' => $Description, 'price' => $Price, 'quantity' => 1));
     //Header('Content-Type: application/pdf');
     $PdfData = $this->HtmlToPdf($this->GenerateBill($BillId));
     //echo($PdfData);
     file_put_contents($this->FileFolder.'/'.$this->FileNamePrefix.$BillId.'.pdf', $PdfData);
-    //$Database->query('UPDATE finance_bills SET pdf = 0x'.bin2hex($PdfData).' WHERE id='.$BillId);
+    //$this->Database->query('UPDATE finance_bills SET pdf = 0x'.bin2hex($PdfData).' WHERE id='.$BillId);
     return($BillId);
   } 
@@ -160 +156 @@
     //echo($this->FileFolder.'/'.$this->FileNamePrefix.$BillId.'.pdf');
     echo(file_put_contents($this->FileFolder.'/'.$this->FileNamePrefix.$BillId.'.pdf', $PdfData));
-    //$Database->query('UPDATE finance_bills SET pdf = 0x'.bin2hex($PdfData).' WHERE id='.$BillId);
+    //$this->Database->query('UPDATE finance_bills SET pdf = 0x'.bin2hex($PdfData).' WHERE id='.$BillId);
   }
 
@@ -167 +163 @@
     global $Database;
     
-    //$DbResult = $Database->select('finance_bills', 'pdf', 'id='.$BillId);
+    //$DbResult = $this->Database->select('finance_bills', 'pdf', 'id='.$BillId);
     //if($DbResult->num_rows == 1)
     //{
@@ -204 +200 @@
     global $Database;
     
-    $DbResult = $Database->select('finance_operations', '*', '(date="2008-02-01" AND comment="Poplatek za měsíc Únor") OR '.
+    $DbResult = $this->Database->select('finance_operations', '*', '(date="2008-02-01" AND comment="Poplatek za měsíc Únor") OR '.
     '(date="2008-01-01" AND comment="Poplatek za měsíc Leden") OR (date="2007-12-01" AND comment="Poplatek za měsíc Prosinec") AND (bill_id = 0)');
     while($Row = $DbResult->fetch_array())
@@ -211 +207 @@
       $Time = MysqlDateToTime($Row['date']);
       $BillId = $this->CreateBill($Row['user'], array(array('description' => 'Poplatek za připojení k síti', 'price' => (-$Row['money']), 'quantity' => 1)), $Time, $Time + (date("t", time()) - 1) * 24 * 3600);  
-     $Database->update('finance_operations', 'id='.$Row['id'], array('bill_id' => $BillId));
+     $this->Database->update('finance_operations', 'id='.$Row['id'], array('bill_id' => $BillId));
     }
   }
@@ -221 +217 @@
     {
   
-      $DbResult = $Database->select('finance_bills', '*', 'user_id='.$_GET['user']);
+      $DbResult = $this->Database->select('finance_bills', '*', 'user_id='.$_GET['user']);
       while($Item = $DbResult->fetch_array())
       {
@@ -250 +246 @@
       ShowHeader('Doklady', 'Doklady');
       echo('Faktury:<br>');
-      $DbResult = $Database->select('users', '*, CONCAT(second_name," ", first_name)  as fullname', '1 ORDER BY fullname');
+      $DbResult = $this->Database->select('users', '*, CONCAT(second_name," ", first_name)  as fullname', '1 ORDER BY fullname');
       while($User = $DbResult->fetch_array())
       {
@@ -260 +256 @@
 }
 
-$InvoiceGenerator = new InvoiceGenerator;
-
 ?>

www/finance/clenove.php

@@ -1 +1 @@
 <?php
-include('../style.php');
+include('../global.php');
 include('include.php');
-include('bills.php');
 RecalculateTariffs(1);
 
-if(array_key_exists('id',$_GET)) $UserID = $_GET['id'];
-if(!array_key_exists('show',$_GET)) $_GET['show'] = '';
-switch($_GET['show'])
+class FinanceUserList extends Page
 {
-  default:
-    ShowHeader('Finance účastníka', 'Finance účastníka');
-        $UserID = GetMemberByIP(GetRemoteAddress());
+  var $FullTitle = 'Seznam účastníků sítě';
+  var $ShortTitle = 'Seznam účastníků';
 
-    $DbResult = $Database->query("SELECT *,CONCAT(second_name, ' ', first_name) as fullname FROM users WHERE id=".$UserID);
-    $Row2 = $DbResult->fetch_array();
-    $TarifName = $Tarify[$Row2['inet_tarif_next']]['name'];
-    echo('<table width="100%" border="0" cellspacing="0" cellpadding="3"><tr><td valign="top">');
-  
-    // Tabulka operaci
-    echo('Výpis operací pro účastníka '.$Row2['fullname'].':<br>');
-    echo('<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3"><tr><th>Datum</th><th>Popis</th><th>Částka [Kč]</th><th>Doklad</th></tr>');
-    $Operations = array();
-    $DbResult = $Database->query('(SELECT Time, Value, Text, Bill FROM FinanceCashFlow WHERE Subject='.$UserID.') UNION ALL '.
-      '(SELECT TimeCreation as Time, (-Value) as Value, Text, Bill FROM FinanceClaimsLiabilities WHERE Subject='.$UserID.') ORDER BY Time DESC');
-    while($DbRow = $DbResult->fetch_array())
-      $Operations[] = $DbRow;
-    foreach($Operations as $Row)
+  function Show()
+  {
+    global $Tarify;
+
+    if($this->System->Modules['User']->CheckPermission('Finance', 'SubjectList'))
     {
-      if($Row['Value'] > 0) $Row['Value'] = '+'.$Row['Value'];
-      if($Row['Bill'] > 0) $Invoice = '<a href="?show=bill&amp;id='.$Row['Bill'].'">PDF</a>'; else $Invoice = '&nbsp;';
-      echo('<tr><td align="right">'.HumanDate($Row['Time']).'</td><td>'.$Row['Text'].'</td><td>'.$Row['Value'].'</td><td>'.$Invoice.'</td></tr>');
-    }
-    //echo('<tr><td>&nbsp;</td><td>-'.$Row2['network_device'].'</td><td>Proměnná cena za zařízení</td></tr>
-    echo('</table>');
-    $DbResult = $Database->query('SELECT ((SELECT COALESCE(SUM(Value), 0) FROM FinanceCashFlow WHERE Subject='.$UserID.') + '.
-      '(SELECT COALESCE(SUM(-Value), 0) FROM FinanceClaimsLiabilities WHERE Subject='.$UserID.')) as Total');
-    $DbRow = $DbResult->fetch_array();
-    $Total = $DbRow['Total'];
-    echo('<h3><strong>Stav účtu: </strong>'.$Total.' Kč</h3><br>');
-    echo('</td><td valign="top">');
+      // Seznam členů
+      $Output = 'Seznam účastníků:<br>'.
+      '<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">'.
+      '<tr><th>Jméno</th>';
+      //<th>Cena za zařízení [Kč]</th>
+      $Output .= '<th>Měsíční poplatek [Kč]</th><th>Stav účtu [Kč]</th><th>Běžící tarif</th><th>Příští tarif</th><th>Poznámky</th></tr>';
+      $TotalDevice = 0;
+      $TotalMonth = 0;
+      $TotalCash = 0;
+      $DbResult = $this->Database->query('SELECT *, CONCAT(users.second_name, " ", users.first_name) as Fullname, ((SELECT COALESCE(SUM(Value), 0) FROM FinanceCashFlow WHERE Subject=users.id) + (SELECT COALESCE(SUM(-Value), 0) FROM FinanceClaimsLiabilities WHERE Subject=users.id)) as Cash FROM users WHERE role=2 ORDER BY fullname');
 
-    if($Row2['role'] == 2)
-    {
-      echo('Variabilní symbol pro platby: <strong>'.$Row2['id'].'</strong><br><br>');  
-
-      // Měsíční bilance
-      if($Row2['inet'] == 1) $InternetPrice = round($Row2['monthly_inet']); else $InternetPrice = 0;
-      if($Row2['overheads'] == 0) 
-      {
-        $PoplatekSprava = 0;
-        $PoplatekSpotreba = 0;
-        $PrijemSpotreba = $Row2['plus'];
-      } else {
-        $PoplatekSprava = $Sprava;
-        $PoplatekSpotreba = $Row2['consumption'];
-        $PrijemSpotreba = $Row2['plus'];
-      }
-      echo('Rozpis měsíčního poplatku:<br><table border="1" cellspacing="0" cellpadding="3">'.
-      '<tr><th>Část</th><th>Cena [Kč]</th></tr>'.
-      '<tr><td>Internet - tarif '.$TarifName.'</td><td>'.$InternetPrice.'</td></tr>'.
-      //'<tr><td>Správa</td><td>'.$PoplatekSprava.'</td></tr>'.
-      //'<tr><td>Poplatek za spotřebu</td><td>'.$PoplatekSpotreba.'</td></tr>'.
-      '<tr><td>Příjem za spotřebu</td><td>'.(-1*$PrijemSpotreba)  .'</td></tr>'.
-      '<tr><td><strong>Celkem</strong></td><td><strong>'.($InternetPrice // + $PoplatekSprava + $PoplatekSpotreba
-        - $PrijemSpotreba).'</strong></td></tr></table>');
-      //echo('Tarif pro příští měsíc: '.$Tarify[$Row2['inet_tarif_next']]['name'].'<br><br>');
-      echo('<br>');
-    
-    /*
-
-    // Rozpis ceny za zařízení
-    echo('Výpis podílu na zařízení segmentů:');
-    echo('<table border="1" cellspacing="0" cellpadding="3"><tr><th>Název segmentu</th><th>Cena [Kč]</th><th>Uživatelů</th><th>Podíl [Kč]</th></tr>');
-    $ID = $Row2['network_segment'];
-    $Money = 0;
-    while($ID > 0)
-    {
-      $DbResult = $Database->query("SELECT * FROM network_segments WHERE id=".$ID);
-      $Row = $DbResult->fetch_array();
-      if(!(($Row2['inet_hw'] == 0) and ($ID == $InternetSegmentId)))
-      {     
-        $Money += $Row['price']/$Row['users'];
-        echo('<tr><td>'.$Row['name'].'</td><td>'.$Row['price'].'</td><td>'.$Row['users'].'&nbsp;</td><td>'.round($Row['price']/$Row['users']).'</td></tr>');
-      }
-      $ID = $Row['parent'];
-    }
-    echo('<tr><td><strong>Celkem</strong></td><td>&nbsp;</td><td>&nbsp;</td><td><strong>'.round($Money).'</strong></td></tr>');
-    echo('</table><br>');
-
-    // Rozpis platba spotřeby segmentů
-    echo('Výpis podílu na spotřebě segmentů:');
-    echo('<table border="1" cellspacing="0" cellpadding="3"><tr><th>Název segmentu</th><th>Cena [Kč]</th><th>Uživatelů</th><th>Podíl [Kč]</th></tr>');
-    $ID = $Row2['network_segment'];
-    $Money = 0;
-    while($ID>0)
-    {
-      $DbResult = $Database->query("SELECT * FROM network_segments WHERE id=".$ID);
-      $Row = $DbResult->fetch_array();
-      $Money += round(W2Kc($Row['consumption'])/$Row['users_overheads']);
-      echo('<tr><td>'.$Row['name'].'</td><td>'.W2Kc($Row['consumption']).'</td><td>'.$Row['users_overheads'].'&nbsp;</td><td>'.round(W2Kc($Row['consumption'])/$Row['users_overheads']).'</td></tr>');
-      $ID = $Row['parent'];
-    }
-    echo('<tr><td><strong>Celkem</strong></td><td>&nbsp;</td><td>&nbsp;</td><td><strong>'.round($Money).'</strong></td></tr>');
-    echo('</table><br>');
-    */
-
-      echo('Měsíční příjem za spotřebu zařízení umístěných u uživatele:<br>');
-      echo('<table border="1" cellspacing="0" cellpadding="3"><tr><th>Název zařízení</th><th>Spotřeba [W]</th><th>Příjem [Kč]</th></tr>');
-      $DbResult = $Database->query("SELECT * FROM network_devices WHERE user=".$UserID." AND used=1");
-      $TotalW = 0;
-      $TotalPrice = 0;
+      //$DbResult = $Database->query("SELECT *,CONCAT(second_name, ' ', first_name) as fullname FROM users WHERE role=2 ORDER BY fullname");
       while($Row = $DbResult->fetch_array())
       {
-        echo('<tr><td>'.$Row['name'].'</td><td>'.$Row['consumption'].'</td><td>'.W2Kc($Row['consumption']).'</td></tr>');
-        $TotalW += $Row['consumption'];
-        $TotalPrice += W2Kc($Row['consumption']);
+        $Monthly = $Row['monthly'] - $Row['plus'];
+        if($Row['hw'] == 0) $Monthly = '(trvale nepřipojen) '.(-$Row['plus']);
+        else 
+        {
+          if($Row['overheads'] == 0) $Monthly = '(dočasně nepřipojen) '.$Monthly;
+          else 
+          {
+            if($Row['inet'] == 0) $Monthly = '(bez internetu) '.$Monthly;
+            else $Monthly = $Monthly;
+          }
+        }
+        //$Row['cash'] = $Row['AdvancesIn'] - $Row['AdvancesOut'] + $Row['Liabilities'] - $Row['Claims'];
+        $TotalCash += $Row['Cash'];
+        if($Row['Cash'] < 0) $Row['Cash'] = '<span style="color: red;">'.$Row['Cash'].'</span>';
+        $Tarif = $Tarify[$Row['inet_tarif_now']]['name'];
+        $PristiTarif = $Tarify[$Row['inet_tarif_next']]['name'];
+        $Output .= '<tr><td><a href="user_state.php?id='.$Row['id'].'">'.$Row['Fullname'].'</a></td>';
+        //<td align="right">'.$Row['network_device'].'</td>
+        $Output .= '<td align="right">'.$Monthly.'</td><td align="right">'.$Row['Cash'].'</td><td align="center">'.$Tarif.'</td><td align="center">'.$PristiTarif.'</td><td>'.$Row['notice'].'&nbsp;</td></tr>';
+        $TotalDevice += $Row['network_device'];
+        $TotalMonth += ($Row['monthly'] - $Row['plus']);
       }
-      echo('<tr><td><strong>Celkem</strong></td><td><strong>'.$TotalW.'</strong></td><td><strong>'.$TotalPrice.'</strong></td></tr>');
-      echo('</table>');
-    }
-    echo('</td></tr></table>');
-    ShowFooter();
-    break;
-  case 'bill':
-    $InvoiceGenerator->ShowStoredBill($_GET['id']);
-    break;
-  case 'admin_user_list':
-    ShowHeader('Seznam účastníků sítě', 'Seznam účastníků');
-    // Seznam členů
-    echo('Seznam účastníků:<br>'.
-    '<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">'.
-    '<tr><th>Jméno</th>');
-    //<th>Cena za zařízení [Kč]</th>
-    echo('<th>Měsíční poplatek [Kč]</th><th>Stav účtu [Kč]</th><th>Běžící tarif</th><th>Příští tarif</th><th>Poznámky</th></tr>');
-    $TotalDevice = 0;
-    $TotalMonth = 0;
-    $TotalCash = 0;
-    $DbResult = $Database->query('SELECT *, CONCAT(users.second_name, " ", users.first_name) as Fullname, ((SELECT COALESCE(SUM(Value), 0) FROM FinanceCashFlow WHERE Subject=users.id) + '.
-      '(SELECT COALESCE(SUM(-Value), 0) FROM FinanceClaimsLiabilities WHERE Subject=users.id)) as Cash FROM users WHERE role=2 ORDER BY fullname');
+      $Output .= '<tr><td><strong>Celkem</strong></td>';
+      //<td align="right"><strong>'.$TotalDevice.'</strong></td>
+      $Output .= '<td align="right"><strong>'.$TotalMonth.'</strong></td><td align="right"><strong>'.$TotalCash.'</strong></td><td align="right">&nbsp;</td><td align="right">&nbsp;</td><td align="right">&nbsp;</td></tr>';
+      $Output .= '</table>';
+    } else $Output = 'Nemáte oprávnění';
+    return($Output);
+  }
+}
 
-    //$DbResult = $Database->query("SELECT *,CONCAT(second_name, ' ', first_name) as fullname FROM users WHERE role=2 ORDER BY fullname");
-    while($Row = $DbResult->fetch_array())
-    {
-      $Monthly = $Row['monthly'] - $Row['plus'];
-      if($Row['hw'] == 0) $Monthly = '(trvale nepřipojen) '.(-$Row['plus']);
-      else {     
-        if($Row['overheads'] == 0) $Monthly = '(dočasně nepřipojen) '.$Monthly;
-        else {
-          if($Row['inet'] == 0) $Monthly = '(bez internetu) '.$Monthly;
-          else $Monthly = $Monthly;
-        }
-      } 
-      //$Row['cash'] = $Row['AdvancesIn'] - $Row['AdvancesOut'] + $Row['Liabilities'] - $Row['Claims'];
-      $TotalCash += $Row['Cash'];
-      if($Row['Cash'] < 0) $Row['Cash'] = '<span style="color: red;">'.$Row['Cash'].'</span>';
-      $Tarif = $Tarify[$Row['inet_tarif_now']]['name'];
-      $PristiTarif = $Tarify[$Row['inet_tarif_next']]['name'];
-      echo('<tr><td><a href="?show=user&amp;id='.$Row['id'].'">'.$Row['Fullname'].'</a></td>');
-//<td align="right">'.$Row['network_device'].'</td>
-      echo('<td align="right">'.$Monthly.'</td><td align="right">'.$Row['Cash'].'</td><td align="center">'.$Tarif.'</td><td align="center">'.$PristiTarif.'</td><td>'.$Row['notice'].'&nbsp;</td></tr>');
-      $TotalDevice += $Row['network_device'];
-      $TotalMonth += ($Row['monthly'] - $Row['plus']);
-    }
-    echo('<tr><td><strong>Celkem</strong></td>');
-    //<td align="right"><strong>'.$TotalDevice.'</strong></td>
-    echo('<td align="right"><strong>'.$TotalMonth.'</strong></td><td align="right"><strong>'.$TotalCash.'</strong></td><td align="right">&nbsp;</td><td align="right">&nbsp;</td><td align="right">&nbsp;</td></tr>');
-    echo('</table>');
-    ShowFooter();
-  }
+$System->AddModule(new FinanceUserList());
+$System->Modules['FinanceUserList']->GetOutput();
 
 ?>

www/finance/finance.php

@@ -1 +1 @@
 <?php
 
-include('../global.php');
-include_once('classes.php');
+class Finance extends Module
+{
 
-function MakeLink($Target, $Title)
-{
-  return('<a href="'.$Target.'">'.$Title.'</a>'); 
-}
-
-function Table($Table)
-{
-  $Result = '<table cellspacing="0" border="1" cellpadding="3" class="BasicTable">';
-  $Result .= '<tr>';
-  foreach($Table['Header'] as $Item)
-    $Result .= '<th>'.$Item.'</th>';
-  $Result .= '</tr>';
-  foreach($Table['Rows'] as $Row)
-  {
-    $Result .= '<tr>';
-    foreach($Row as $Item)
-      $Result .= '<td>'.$Item.'</td>';
-    $Result .= '</tr>';
-  }
-  $Result .= '</table>';
-  return($Result);
-}
-
-function ShowEditTable($ClassName, $Values)
-{
-  global $Classes, $Types, $Database;
-
-  $Class = $Classes[$ClassName];
-  $Table = array(
-    'Header' => array('Položka', 'Hodnota'),
-    'Rows' => array(),
-  );
-  
-  foreach($Class['Items'] as $Index => $Item)
-  {
-    if(!array_key_exists($Index, $Values)) $Values[$Index] = $Item['Default']; 
-    switch($Item['Type'])
-    {
-      case 'Boolean':       
-        if($Values[$Index] == 0) $Checked = ''; else $Checked = ' CHECKED';
-        $Edit = '<input type="checkbox" name="'.$Index.'"'.$Checked.'>';
-        break;
-      case 'String': 
-        $Edit = '<input type="text" name="'.$Index.'" value="'.$Values[$Index].'">';
-        break;
-      case 'Integer': 
-        $Edit = '<input type="text" name="'.$Index.'" value="'.$Values[$Index].'">';
-        break;
-      case 'Float': 
-        $Edit = '<input type="text" name="'.$Index.'" value="'.$Values[$Index].'">';
-        break;
-      case 'Time': 
-        if($Values[$Index] == 'Now') $Values[$Index] = date('j.n.Y');
-        $Edit = '<input type="text" name="'.$Index.'" value="'.$Values[$Index].'">';
-        break;
-      case 'FinanceSubject': 
-        
-        $Edit = '<select name="'.$Index.'">';
-        $DbResult = $Database->select('users', 'id, CONCAT(second_name, " ", first_name) as fullname', 'role=2 ORDER BY fullname');
-        while($Row = $DbResult->fetch_array())
-          $Edit .= '<option value="'.$Row['id'].'">'.$Row['fullname'].'</option>';
-        $Edit .= '</select>';
-        break;
-      case 'Array': 
-        $Edit = ShowEditTable($Item['ItemClass'], array());
-        $Edit .= '<form action="?Operation=AddItem&dsd" method="post"><input type="submit" value="Přidat položku"></form>';
-        break;
-      default:
-        $Edit = 'Neznámý typ';      
-    }
-    array_push($Table['Rows'], array($Item['Caption'], $Edit));
-  }
-  $Output = '<h3>'.$Class['Title'].'</h3>'.Table($Table);
-  return($Output); 
-}
-
-function LoadSubmitedData($ClassName)
-{
-  global $Classes, $Types, $Database;
-
-  $Class = $Classes[$ClassName];
-  $Values = array();
-  
-  foreach($Class['Items'] as $Index => $Item)
-  {
-    switch($Item['Type'])
-    {
-      case 'Boolean':       
-        if(array_key_exists($Index, $_POST)) $Values[$Index] = 1; 
-        else $Values[$Index] = 0;
-        break;
-      case 'String': 
-        $Values[$Index] = $_POST[$Index];
-        break;
-      case 'Integer': 
-        $Values[$Index] = $_POST[$Index];
-        break;
-      case 'Float': 
-        $Values[$Index] = $_POST[$Index];
-        break;
-      case 'Time': 
-        $Values[$Index] = explode('.', $_POST[$Index]);
-        $Values[$Index] = mktime(0, 0, 0, $Values[$Index][1], $Values[$Index][0], $Values[$Index][2]);
-        break;
-      case 'FinanceSubject': 
-        $Values[$Index] = $_POST[$Index];
-        break;
-      default:
-    }
-  }
-  return($Values);   
 }
 

www/finance/include.php

@@ -131 +131 @@
 }
 
+
 ?>

www/finance/index.php

@@ -1 +1 @@
 <?php
-include_once('../style.php');
+include_once('../global.php');
 include_once('include.php');
 
-ShowHeader('Financování sítě', 'Finance');
+class FinanceOverview extends Page
+{
+  var $FullTitle = 'Přehled financování sítě';
+  var $ShortTitle = 'Přehled financí';
 
-echo('<table><tr><td valign="top">');
+  function Show()
+  {
+    global $Config, $RealMaxSpeed, $Internet, $InternetUsers, $kWh, $TotalInternetPaid, $SpravaUsers, $Sprava, $UserIdNetwork;
 
-echo('<table><tr><td width="30%">');
-if(GetMemberByIP(GetRemoteAddress()) > 0) echo('<a href="clenove.php">Vaše finanční operace</a><br /><br /><br />');
-echo('<a href="monthly_overall.php">Měsíční přehledy</a><br />'.
-'<a href="tarify.php">Tarify</a><br />'.
-'<a href="zarizeni.php">Výpis zařízení</a><br />'.
-//'<a href="spotreba.php">Spotřeba energie</a><br />'.
-'<a href="'.$Config['Web']['RootFolder'].'/aktuality/index.php?category=9">Investice v síti</a><br />'.
-//'<a href="faktury/">Faktury za internet</a><br />'.
-//'<a href="inventory.php">Výpis skladových zásob</a><br />'.
-//'<a href="srovnani.php">Porovnání tarifů s konkurencí</a><br />'.
-'</td><td width="50%">');
+    $Output = '<table><tr><td valign="top">';
 
+    $Output .= '<table><tr><td width="30%">';
+        if(GetMemberByIP(GetRemoteAddress()) > 0) $Output .= '<a href="user_state.php">Vaše finanční operace</a><br /><br /><br />';
+        
+    $Output .= '<a href="monthly_overall.php">Měsíční přehledy</a><br />';
+    $Output .= '<a href="tarify.php">Tarify</a><br />';
+    $Output .= '<a href="zarizeni.php">Výpis zařízení</a><br />';
+    if($this->System->Modules['User']->CheckPermission('Finance', 'SubjectList')) $Output .= '<a href="clenove.php">Seznam členů</a><br />';
+    $Output .= '<a href="spotreba.php">Spotřeba energie</a><br />';
+    $Output .= '<a href="'.$Config['Web']['RootFolder'].'/aktuality/index.php?category=9">Investice v síti</a><br />';
+    //$Output .= '<a href="faktury/">Faktury za internet</a><br />';
+    //$Output .= '<a href="inventory.php">Výpis skladových zásob</a><br />';
+    $Output .= '</td><td width="50%">';
 
-/*
-$CenaBezDPH = 11000;
-$JednorazoveBezDPH = 29800;
-DB_Query('SELECT COUNT(*) FROM users WHERE inet=1 AND role=0');
-$Row = DB_Row();
-echo('<table style="border-style: dotted; border-width: 1; border-color: red; font-size: small;"><tr><td>'.
-'Měsíční poplatek za internet při navýšení rychlosti na 1024/1024 kb/s: '.round($CenaBezDPH*1.19).' / '.$Row[0].' = <strong>'.round($CenaBezDPH*1.19/$Row[0]).' Kč</strong></td></tr></table>');
-*/
-/*
-DB_Query('SELECT COUNT(*) FROM users WHERE fast_inet=1 AND role=0');
-$Row = DB_Row();
-echo('Při <a href="clenove.php">'.$Row[0].'</a> zájemcích včetně DPH: jednorázově: <strong>'.round(29800*1.19/$Row[0]).' Kč</strong>'.
-' měsíčně: <strong>'.round(8900*1.19/$Row[0]).' Kč</strong>');
-*/
+    $Output .= '</td></tr></table><br />'; 
 
-echo('</td></tr></table><br />');    
+    $Output .= '<strong>Souhrn:</strong><br />';
 
-echo('<strong>Souhrn:</strong><br />');
+    $DbResult = $this->Database->query("SELECT * FROM finance_monthly_overall ORDER BY date DESC LIMIT 0,1");
+    $Row = $DbResult->fetch_array();
+    $Output .= 'Platba za internetovou linku ('.$RealMaxSpeed.'/'.$RealMaxSpeed.' kbit/s): <strong>'.$Internet.' Kč</strong><br />';
 
-$DbResult = $Database->query("SELECT * FROM finance_monthly_overall ORDER BY date DESC LIMIT 0,1");
-$Row = $DbResult->fetch_array();
-echo('Poplatek za hlavní internetovou linku ('.$RealMaxSpeed.'/'.$RealMaxSpeed.' kbit/s): <strong>'.$Internet.' Kč</strong><br />');
+    $DbResult = $this->Database->query("SELECT COUNT(*) FROM users WHERE role=2");
+    $Row2 = $DbResult->fetch_array();
+    $Output .= 'Počet účastníků: <strong>'.$Row2[0].'</strong><br />';
 
-$DbResult = $Database->query("SELECT COUNT(*) FROM users WHERE role=2");
-$Row2 = $DbResult->fetch_array();
-echo('Počet připojených účastníků: <strong>'.$Row2[0].'</strong><br />');
+    $DbResult = $this->Database->query("SELECT SUM(price) FROM network_devices WHERE used=1");
+    $Row4 = $DbResult->fetch_array();
+    $Output .= 'Celková cena zařízení sítě: <strong>'.$Row4[0].' Kč</strong><br />';
 
-//echo('Předpokládané rozmezí měsíčního poplateku za internet pro jednoho uživatele: <strong>300 - 500 Kč</strong><br />'); 
+    $DbResult = $this->Database->query('SELECT SUM((SELECT COALESCE(SUM(Value), 0) FROM FinanceCashFlow WHERE Subject=users.id) + (SELECT COALESCE(SUM(-Value), 0) FROM FinanceClaimsLiabilities WHERE Subject=users.id)) as Cash FROM users WHERE role=2');
+    $Row4 = $DbResult->fetch_array();
+    $Output .= 'Celkem peněz na účtech: <strong>'.$Row4[0].' Kč</strong><br />';
+    $Output .= 'Stanovená cena jedné kWh: <strong>'.$kWh.' Kč</strong><br />';
+    //echo('Komunitou stanovený poplatek za správu sítě pro jednoho uživatele: <strong>'.$Sprava.' Kč</strong><br />');
+    $DbResult = $this->Database->query("SELECT SUM(family) FROM users WHERE role=2");
+    $Row5 = $DbResult->fetch_array();
+    $TotalFamily = 600;
+    $Output .= 'V připojených domácnostech celkem <strong>'.$Row5[0].'</strong> občanů ze všech <strong>'.$TotalFamily.'</strong> ('.round($Row5[0] / $TotalFamily * 100).' %)<br />';
+    $Output .= 'IČ: <strong>75904535</strong><br />'.
+    'DIČ: <strong>CZ8303255884</strong><br />'.
+    'Bankovní účet: <strong>218098370 / 0300</strong><br />'.
+    '<br />';
 
-//echo('Aktuální poplatek za internet pro jednoho uživatele: <strong>'.round($Internet/$InternetUsers).' Kč</strong><br />');
+    $Output .= '</td><td valign="top">';
 
-$DbResult = $Database->query("SELECT SUM(price) FROM network_devices WHERE used=1");
-$Row4 = $DbResult->fetch_array();
-echo('Celková cena zařízení sítě: <strong>'.$Row4[0].' Kč</strong><br />');
-$DbResult = $Database->query("SELECT SUM(cash) FROM users");
-$Row4 = $DbResult->fetch_array();
-echo('Celkem peněz na účtech: <strong>'.$Row4[0].' Kč</strong><br />');
-echo('Stanovená cena jedné kWh: <strong>'.$kWh.' Kč</strong><br />');
-//echo('Komunitou stanovený poplatek za správu sítě pro jednoho uživatele: <strong>'.$Sprava.' Kč</strong><br />');
-$DbResult = $Database->query("SELECT SUM(family) FROM users WHERE role=2");
-$Row5 = $DbResult->fetch_array();
-$TotalFamily = 600;
-echo('V připojených domácnostech celkem <strong>'.$Row5[0].'</strong> občanů ze všech <strong>'.$TotalFamily.'</strong> ('.round($Row5[0] / $TotalFamily * 100).' %)<br />');
-echo('IČ: <strong>75904535</strong><br />'.
-'DIČ: <strong>CZ8303255884</strong><br />'.
-'Bankovní účet: <strong>218098370 / 0300</strong><br />'.
-'<br />');
+    $UsersPayment = $TotalInternetPaid;
+    $NetworkManagement = $Sprava * $SpravaUsers;
+    $TotalGain = 0;
+    $TotalExpense = 0;
+    $DbResult = $this->Database->query("SELECT SUM(consumption) FROM network_devices WHERE used=1");
+    $Row = $DbResult->fetch_array();
+    $TotalConsumption = W2Kc($Row[0]);
 
-echo('</td><td valign="top">');
+    $Output .= 'Měsíční vyúčtování:<br />
+    <table border="1" cellspacing="0" cellpadding="3">
+    <tr><th>Položka</th><th>Cena [Kč]</th></tr>
+    <tr><th colspan="2">Příjmy</th></tr>';
+    $Output .= '<tr><td>Poplatky účastníků za internet</td><td align="right">'.$UsersPayment.'</td></tr>';
+    $TotalGain += $UsersPayment;
+    $Output .= '<tr><td><strong>Celkem</strong></td><td align="right"><strong>'.$TotalGain.'</strong></td></tr>';
+    $Output .= '<tr><th colspan="2">Výdaje</th></tr><tr><td>Internet</td><td align="right">'.$Internet.'</td></tr>';
+    $TotalExpense += $Internet;
+    $Output .= '<tr><td>Správa sítě</td><td align="right">'.$NetworkManagement.'</td></tr>';
+    $TotalExpense += $NetworkManagement;
+    $Output .= '<tr><td>Spotřeba energie</td><td align="right">'.$TotalConsumption.'</td></tr>';
+    $TotalExpense += $TotalConsumption;
+    $Output .= '<tr><td><strong>Celkem</strong></td><td align="right"><strong>'.$TotalExpense.'</strong></td></tr>';
+    $Output .= '<tr><td colspan="2">&nbsp;</td></tr>';
+    $Output .= '<tr><td><strong>Rozdíl</strong></td><td align="right"><strong>'.($TotalGain - $TotalExpense).'</strong></td></tr>';
+    $Output .= '<tr><td>Převod do dalšího měsíce</td><td align="right">'.($TotalGain - $TotalExpense).'</td></tr>';
+    $Output .= '</table><br />';
+    $DbResult = $this->Database->select('users', 'cash', 'id='.$UserIdNetwork);
+    $Row = $DbResult->fetch_array();
+    $NetworkCash = $Row['cash'];
+    $Output .= 'Stav účtu sítě: '.$NetworkCash.' Kč<br /><a href="clenove.php?show=user&amp;id='.$UserIdNetwork.'">Výpis účtu</a><br />';
 
-$UsersPayment = $TotalInternetPaid;
-$NetworkManagement = $Sprava * $SpravaUsers;
-$TotalGain = 0;
-$TotalExpense = 0;
-$DbResult = $Database->query("SELECT SUM(consumption) FROM network_devices WHERE used=1");
-$Row = $DbResult->fetch_array();
-$TotalConsumption = W2Kc($Row[0]);
-//$Users
-
-echo('Měsíční vyúčtování:<br />
-<table border="1" cellspacing="0" cellpadding="3">
-<tr><th>Položka</th><th>Cena [Kč]</th></tr>
-<tr><th colspan="2">Příjmy</th></tr>');
-echo('<tr><td>Poplatky účastníků za internet</td><td align="right">'.$UsersPayment.'</td></tr>');
-$TotalGain += $UsersPayment;
-echo('<tr><td><strong>Celkem</strong></td><td align="right"><strong>'.$TotalGain.'</strong></td></tr>');
-echo('<tr><th colspan="2">Výdaje</th></tr>
-<tr><td>Internet</td><td align="right">'.$Internet.'</td></tr>');
-$TotalExpense += $Internet;
-echo('<tr><td>Správa sítě</td><td align="right">'.$NetworkManagement.'</td></tr>');
-$TotalExpense += $NetworkManagement;
-echo('<tr><td>Spotřeba energie</td><td align="right">'.$TotalConsumption.'</td></tr>');
-$TotalExpense += $TotalConsumption;
-echo('<tr><td><strong>Celkem</strong></td><td align="right"><strong>'.$TotalExpense.'</strong></td></tr>');
-echo('<tr><td colspan="2">&nbsp;</td></tr>');
-echo('<tr><td><strong>Rozdíl</strong></td><td align="right"><strong>'.($TotalGain - $TotalExpense).'</strong></td></tr>');
-echo('<tr><td>Převod do dalšího měsíce</td><td align="right">'.($TotalGain - $TotalExpense).'</td></tr>');
-echo('</table><br />');
-$DbResult = $Database->select('users', 'cash', 'id='.$UserIdNetwork);
-$Row = $DbResult->fetch_array();
-$NetworkCash = $Row['cash'];
-//echo('Stav účtu sítě: '.$NetworkCash.' Kč<br />');
-//<a href="clenove.php?show=user&amp;id='.$UserIdNetwork.'">Výpis účtu</a><br />');
-
-echo('</td></tr></table>');
+    $Output .= '</td></tr></table>';
 
 /*
@@ -110 +96 @@
 echo('<strong>Jak se rozpočítávají finance</strong><br />Internet i zařízení sítě se platí za domácnost. Systém výpočtu vychází z topologie sítě. Síť má stromovou topologii přičemž listy stromu jsou jednotliví uživatelé a kořen stromu je linka do internetu. Dosavadní systém je uzpůsoben tak, aby linky, které jsou nejvíce zatíženy, byly nejlépe zaplaceny a mohlo na nich tak být dražší a výkonější zařízení. Nejvytíženější linky se nazývají páteřní. Proto platí každý uživatel podílově zařízení, které vede od něj až ke kořenu stromu, což je v našem případě server Centrála s trvalým internetovým připojením. Pro jednoduchost je síť rozdělena na segmenty. Segment je část sítě, kterou využívá konstantní počet uživatelů. Každý segment je tvořen skupinou zařízení a má svoji celkovou cenu. Každý uživatel je přirozeně napojen na některý ze segmentů. Podíl klienta na zařízení sítě je vypočten jako součet podílů na jednotlivých segmentech směrem ke kořenu. Podíl na segmentu znamená celková cena segmentu podělená počtem uživatelů využívajících daný segment.<br />');
 */
-ShowFooter();
+    return($Output);
+  }
+}
+
+$System->AddModule(new FinanceOverview());
+$System->Modules['FinanceOverview']->GetOutput();
+
 ?>

www/finance/inventory.php

@@ -1 +1 @@
 <?php
-include('../global.php');
-include('../style.php');
+include_once('../global.php');
+include_once('include.php');
 
-ShowHeader('Zařízení sítě','Zařízení');
+class FinanceStoragePage extends Page
+{
+  var $FullTitle = 'Skladové zásoby';
+  var $ShortTitle = 'Sklad';
 
-// Seznam segmentů a zařízení
-$TotalPrice = 0;
-echo('Výpis skladových zásob:<br><table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">');
-echo('<tr><th>Název</th><th>Datum<br>zakoupení</th><th>Cena [Kč]</th><th>Počet</th><th>Cena<br> dohromady [Kč]</th></tr>');
-$DbResult = $Database->query("SELECT * FROM network_devices WHERE used=2");
-while($Row = $DbResult->fetch_array())
-{
-  echo('<tr><td>'.$Row['name'].'</td><td align="right">'.HumanDate($Row['date']).'</td><td align="right">'.$Row['price'].'</td><td align="right">'.$Row['count'].'</td><td align="right">'.$Row['count'] * $Row['price'].'</td></tr>');
-  $TotalPrice = $TotalPrice + $Row['count'] * $Row['price'];
+  function Show()
+  {
+    $TotalPrice = 0;
+    $Output = 'Výpis skladových zásob:<br><table class="WideTable">';
+    $Output .= '<tr><th>Název</th><th>Datum<br />zakoupení</th><th>Cena [Kč]</th><th>Počet</th><th>Cena<br /> dohromady [Kč]</th></tr>';
+    $DbResult = $this->Database->query("SELECT * FROM network_devices WHERE used=2");
+    while($Row = $DbResult->fetch_array())
+    {
+      $Output .= '<tr><td>'.$Row['name'].'</td><td align="right">'.HumanDate($Row['date']).'</td><td align="right">'.$Row['price'].'</td><td align="right">'.$Row['count'].'</td><td align="right">'.$Row['count'] * $Row['price'].'</td></tr>';
+      $TotalPrice = $TotalPrice + $Row['count'] * $Row['price'];
+    }
+
+    $Output .= '<tr><td colspan="4"><strong>Celkem:</strong></td><td align="right"><strong>'.$TotalPrice.'</strong></td></tr>';
+    $Output .= '</table>';
+    return($Output);
+  }
 }
 
-echo('<tr><td colspan="4"><strong>Celkem:</strong></td><td align="right"><strong>'.$TotalPrice.'</strong></td></tr>');
-echo('</table>');
+$System->AddModule(new FinanceStoragePage());
+$System->Modules['FinanceStoragePage']->GetOutput();
 
-ShowFooter();
 ?>

www/finance/manage.php

@@ -1 +1 @@
 <?php
-
-include('finance.php');
-include('bills.php');
-
-/*
-if(array_key_exists('Operation', $_GET)) $Operation = $_GET['Operation']; else $Operation = '';
-switch($Operation)
+include_once('../global.php');
+include_once('include.php');
+
+class FinanceManagePage extends Page
 {
-  case 'NewPaymentInsert':
-    $Output = ShowNewPaymentInsert();  
-    break;
-  case 'NewPaymentForm':
-    $Output = ShowNewPaymentForm();  
-    break;
-  case 'NewInvoiceForm':
-    $Output = ShowNewInvoiceForm();  
-    break;
-  default:
-    $Output = '<a href="?Operation=NewPaymentForm">Přidat novou platbu</a><br>';
-    $Output .= '<a href="?Operation=NewInvoiceForm">Přidat novou fakturu</a><br>';
-}
-echo(FormatOutput($Output));
-*/
-
-function CheckAdvancesAndLiabilities($Subject)
-{
-  global $Database, $LastInsertTime;
-  do {
-    $DbResult = $Database->select('FinanceAdvances', 'SUM(Value)', 'Subject='.$Subject.' AND Direction = "In"');
-    $DbRow = $DbResult->fetch_array();
-    $Advances = $DbRow[0];
-    $DbResult = $Database->select('FinanceClaimsLiabilities', '*', 'Subject='.$Subject.' AND TimePayment IS NULL AND Value > 0 ORDER BY TimeCreation LIMIT 1');
-    //echo($Database->error);
-    if($DbResult->num_rows > 0)
-    {
-      $OpenedClaim = $DbResult->fetch_array();
-      if($Advances > $OpenedClaim['Value'])
-      {
-        $Database->update('FinanceClaimsLiabilities', 'Id='.$OpenedClaim['Id'], array('TimePayment' => TimeToMysqlDateTime($LastInsertTime)));
-        $Database->insert('FinanceAdvances', array('Subject' => $OpenedClaim['Subject'], 'Value' => -$OpenedClaim['Value'], 'TimeCreation' => TimeToMysqlDateTime($LastInsertTime), 'CashFlowId' => $OpenedClaim['Id'], 'Direction' => 'In'));
-        //echo($Database->LastQuery);
+  var $FullTitle = 'Správa financí';
+  var $ShortTitle = 'Správa financí';
+
+  function Show()
+  {
+    //if(!$this->System->Modules['User']->CheckPermission('Finance', 'Manage')) return('Nemáte oprávnění');
+
+    if(array_key_exists('Operation', $_GET)) $Operation = $_GET['Operation']; else $Operation = '';
+    switch($Operation)
+    {
+      case 'Bills':
+        $Output = $this->BillManage();
+        break;
+      case 'ConvertPDFToFile':
+        $Output = $this->ConvertPDFDataToFiles();
+        break;
+      case 'ImportOldData':
+        $Output = $this->ImportOldData();
+        break;
+      case 'NewDeviceForm':
+        $Output = $this->ShowNewDeviceForm();
+        break;
+      case 'NewDeviceInsert':
+        $Output = $this->ShowNewDeviceInsert();
+        break;
+      case 'NewDeviceHistoryForm':
+        $Output = $this->ShowNewDeviceHistoryForm();
+        break;
+      case 'NewDeviceHistoryInsert':
+        $Output = $this->ShowNewDeviceHistoryInsert();
+        break;
+      case 'NewPaymentInsert':
+        $Output = $this->ShowNewPaymentInsert();
+        break;
+      case 'NewPaymentForm':
+        $Output = $this->ShowNewPaymentForm();
+        break;
+      case 'NewInvoiceInsert':
+        $Output = $this->ShowNewInvoiceInsert();
+        break;
+      case 'NewInvoiceForm':
+        $Output = $this->ShowNewInvoiceForm();
+        break;
+      default:
+        $Output = '<a href="?Operation=NewDeviceForm">Přidat nové zařízení</a><br>';
+        $Output .= '<a href="?Operation=NewDeviceHistoryForm">Přidat nový záznam historie zařízení</a><br>';
+        $Output .= '<a href="?Operation=NewPaymentForm">Přidat novou platbu</a><br>';
+        $Output .= '<a href="?Operation=NewInvoiceForm">Přidat novou fakturu</a><br>';
+        $Output .= '<a href="?Operation=ImportOldData">Importovat stará data</a><br>';
+        $Output .= '<a href="?Operation=ConvertPDFToFile">Převést data z databáze do souborů</a><br>';
+        $Output .= '<a href="?Operation=Bills">Správa dokladů</a><br>';
+    }
+    return($Output);
+  }
+
+  function BillManage()
+  {
+    $Output = '';
+    if(array_key_exists('user', $_GET))
+    {
+      $DbResult = $this->Database->select('finance_bills', '*', 'user_id='.$_GET['user']);
+      while($Item = $DbResult->fetch_array())
+      {
+        $Output .= '<a href="?Operation=Bills&amp;bill='.$Item['id'].'">faktura '.$Item['id'].'</a> <a href="?Operation=Bills&amp;billpdf='.$Item['id'].'">Uložené PDF</a> <a href="?Operation=Bills&amp;billpdf2='.$Item['id'].'">Generované PDF</a> <a href="?Operation=Bills&amp;regenerate='.$Item['id'].'">Přegenerovat</a><br />';
+      }
+    } else
+    if(array_key_exists('billpdf', $_GET))
+    {
+      $Output .= $this->System->Modules['Bill']->ShowStoredBill($_GET['billpdf']);
+    } else
+    if(array_key_exists('billpdf2', $_GET))
+    {
+      $Output .= $this->System->Modules['Bill']->ShowGeneratedBill($_GET['billpdf2']);
+    } else
+    if(array_key_exists('regenerate', $_GET))
+    {
+      $Output .= $this->System->Modules['Bill']->RegeneratePDF($_GET['regenerate']);
+    } else
+    if(array_key_exists('bill', $_GET))
+    {
+      $Output .= $this->System->Modules['Bill']->GenerateBill($_GET['bill']);
+    } else
+    if(array_key_exists('generate', $_GET))
+    {
+      $Output .= $this->System->Modules['Bill']->CreateBill(1, array(array('description' => 'Poplatek za připojení k síti', 'price' => 1000, 'quantity' => 1)), time(), time());
+    } else 
+    {
+      //ShowHeader('Faktury', 'Faktury');
+      $Output .= 'Faktury:<br />';
+      $DbResult = $this->Database->select('users', '*, CONCAT(second_name," ", first_name)  as fullname', '1 ORDER BY fullname');
+      while($User = $DbResult->fetch_array())
+      {
+        $Output .= '<a href="?Operation=Bills&amp;user='.$User['id'].'">'.$User['fullname'].'</a><br />';
+      }
+      //ShowFooter();
+    }
+    return($Output);
+  }
+
+  function CheckAdvancesAndLiabilities($Subject)
+  {
+    global $LastInsertTime;
+
+    do {
+      $DbResult = $this->Database->select('FinanceAdvances', 'SUM(Value)', 'Subject='.$Subject.' AND Direction = "In"');
+      $DbRow = $DbResult->fetch_array();
+      $Advances = $DbRow[0];
+      $DbResult = $this->Database->select('FinanceClaimsLiabilities', '*', 'Subject='.$Subject.' AND TimePayment IS NULL AND Value > 0 ORDER BY TimeCreation LIMIT 1');
+      //echo($Database->error);
+      if($DbResult->num_rows > 0)
+      {
+        $OpenedClaim = $DbResult->fetch_array();
+        if($Advances > $OpenedClaim['Value'])
+        {
+          $this->Database->update('FinanceClaimsLiabilities', 'Id='.$OpenedClaim['Id'], array('TimePayment' => TimeToMysqlDateTime($LastInsertTime)));
+          $this->Database->insert('FinanceAdvances', array('Subject' => $OpenedClaim['Subject'], 'Value' => -$OpenedClaim['Value'], 'TimeCreation' => TimeToMysqlDateTime($LastInsertTime), 'CashFlowId' => $OpenedClaim['Id'], 'Direction' => 'In'));
+          //echo($Database->LastQuery);
+        } else break;
       } else break;
-    } else break;
-  } while(($Advances > $OpenedClaim['Value']));
-}
-
-function InsertLiability($Subject, $Value, $Time, $BillId, $Text, $TimePayment = '')
-{
-  global $Database, $LastInsertTime;
-  if($TimePayment != '') $TimePayment = TimeToMysqlDateTime($TimePayment);
-  $Database->insert('FinanceClaimsLiabilities', array('Text' => $Text, 'Subject' => $Subject, 'TimeCreation' => TimeToMysqlDateTime($Time), 'TimeDue' => TimeToMysqlDateTime($Time + 3600*24*15), 'TimePayment' => $TimePayment, 'Value' => $Value, 'Bill' => $BillId));
-  echo($Database->LastQuery.'<br>');
-  $LastInsertTime = $Time;
-  CheckAdvancesAndLiabilities($Subject);
-}
-
-function InsertMoney($Subject, $Value, $Cash, $Taxable, $Time, $Text)
-{
-  global $Database, $LastInsertTime;
-  $Database->insert('FinanceCashFlow', array('Text' => $Text, 'Subject' => $Subject, 'Cash' => $Cash, 'Value' => $Value, 'Time' => TimeToMysqlDateTime($Time), 'Taxable' => $Taxable));
-  if($Value >= 0)
-  {
-    $Database->insert('FinanceAdvances', array('Subject' => $Subject, 'Value' => $Value, 'TimeCreation' => TimeToMysqlDateTime($Time), 'CashFlowId' => $Database->insert_id, 'Direction' => 'In'));
-  }
-  $LastInsertTime = $Time;
-  CheckAdvancesAndLiabilities($Subject);
-}
-
-function ShowNewPaymentForm()
-{ 
-  global $Database;
-  $Values = array();
-  $Output = '<form action="?Operation=NewPaymentInsert" method="post">'.ShowEditTable('NewPayment', $Values);
-  $Output .= '<input type="submit" value="Vložit"></form>';
-  return($Output); 
-}
-
-function ShowNewPaymentInsert()
-{
-  global $Database;
-  $Values = LoadSubmitedData('NewPayment');
-  InsertMoney($Values['Subject'], $Values['Value'], $Values['Cash'], $Value['Taxable'], $Values['Text'], time());
-  echo('Nová platba vložena');
-  //echo(phpinfo());
-}
-
-function ShowNewInvoiceForm()
-{ 
-  global $Database;
-  $Values = array();
-  $Output = '<form action="?Operation=NewInvoiceInsert" method="post">'.ShowEditTable('NewInvoice', $Values);
-  $Output .= '<input type="submit" value="Vložit"></form>';
-  return($Output); 
-}
-
-function ImportOldData()
-{
-  global $Database, $InvoiceGenerator;
-
-  $Database->query('TRUNCATE TABLE FinanceCashFlow');
-  $Database->query('TRUNCATE TABLE FinanceClaimsLiabilities');
-  $Database->query('TRUNCATE TABLE FinanceAdvances');
-  $Database->query('TRUNCATE TABLE FinanceSmallAssets');
-
-  // Move time of device price transformation 
-  $Database->query('UPDATE finance_operations SET date="2007-11-30" WHERE comment = "Jednorázový poplatek za společné zařízení"');
-
-  // Transfer finance before era
-  $DbResult = $Database->query('SELECT * FROM users WHERE role=2');
-  while($User = $DbResult->fetch_array())
-  {
-    $DbResult2 = $Database->query('SELECT SUM(money) FROM finance_operations WHERE user='.$User['id'].' AND date < "2007-12-01"');
-    $Row = $DbResult2->fetch_array();
-    $TotalAdvance = $Row[0];
-    //echo($User['second_name'].' '.$User['first_name'].' '.$TotalAdvance.'<br>');
-    // Záloha
-    if($TotalAdvance > 0) 
-    {
-      InsertMoney($User['id'], $TotalAdvance, 0, 1, mktime(0, 0, 0, 12, 1, 2007), 'Přijatá záloha (z období před daňovou evidencí)');
-    }
-    // Dluh
-    if($TotalAdvance < 0) 
-    {  
-      InsertLiability($User['id'], (-$Row[0]), mktime(0, 0, 0, 12, 1, 2007), 0, 'Připojení k síti (z období před daňovou evidencí)');
-      //echo($Database->LastQuery.'<br>');
-    }
-  }  
-
-  // Transfer finance after era
-//  $DbResult = $Database->query('SELECT * FROM users WHERE role=2');
-//  while($User = $DbResult->fetch_array())
-//  {
-    $DbResult2 = $Database->query('SELECT finance_operations.*, users.role as role FROM finance_operations JOIN users ON users.id = finance_operations.user WHERE finance_operations.date >= "2007-12-01"');
+    } while(($Advances > $OpenedClaim['Value']));
+  }
+
+  function InsertLiability($Subject, $Value, $Time, $BillId, $Text, $TimePayment = '')
+  {
+    global $LastInsertTime;
+
+    if($TimePayment != '') $TimePayment = TimeToMysqlDateTime($TimePayment);
+    $this->Database->insert('FinanceClaimsLiabilities', array('Text' => $Text, 'Subject' => $Subject, 'TimeCreation' => TimeToMysqlDateTime($Time), 'TimeDue' => TimeToMysqlDateTime($Time + 3600*24*15), 'TimePayment' => $TimePayment, 'Value' => $Value, 'Bill' => $BillId));
+    $Output = $this->Database->LastQuery.'<br />';
+    $LastInsertTime = $Time;
+    $this->CheckAdvancesAndLiabilities($Subject);
+    return($Output);
+  }
+
+  function InsertMoney($Subject, $Value, $Cash, $Taxable, $Time, $Text)
+  {
+    global $LastInsertTime;
+
+    $this->Database->insert('FinanceCashFlow', array('Text' => $Text, 'Subject' => $Subject, 'Cash' => $Cash, 'Value' => $Value, 'Time' => TimeToMysqlDateTime($Time), 'Taxable' => $Taxable));
+    if($Value >= 0)
+    {
+      $this->Database->insert('FinanceAdvances', array('Subject' => $Subject, 'Value' => $Value, 'TimeCreation' => TimeToMysqlDateTime($Time), 'CashFlowId' => $this->Database->insert_id, 'Direction' => 'In'));
+    }
+    $LastInsertTime = $Time;
+    $this->CheckAdvancesAndLiabilities($Subject);
+  }
+
+  function ShowNewDeviceForm()
+  {
+    $Form = new Form('NewNetworkDevice');
+    $Form->OnSubmit = '?Operation=NewDeviceInsert';
+    $Output = $Form->ShowEditForm();
+    return($Output);
+  }
+
+  function ShowNewDeviceInsert()
+  {
+    $Form = new Form('NewNetworkDevice');
+    $Form->LoadValuesFromForm();
+    $Form->SaveValuesToDatabase(0);
+    $Output = $this->SystemMessage('Finance', 'Zařízení vloženo.');
+    $this->System->Modules['Log']->NewRecord('Finance', 'NewDeviceInserted');
+    return($Output);
+  }
+
+  function ShowNewDeviceHistoryForm()
+  {
+    $Form = new Form('NewNetworkDeviceHistory');
+    $Form->OnSubmit = '?Operation=NewDeviceHistoryInsert';
+    $Output = $Form->ShowEditForm();
+    return($Output);
+  }
+
+  function ShowNewDeviceHistoryInsert()
+  {
+    $Form = new Form('NewNetworkDeviceHistory');
+    $Form->LoadValuesFromForm();
+    $Form->SaveValuesToDatabase(0);
+    $Output = $this->SystemMessage('Finance', 'Záznam historie zařízení vložen.');
+    $this->System->Modules['Log']->NewRecord('Finance', 'NewDeviceHistoryInserted');
+    return($Output);
+  }
+
+  function ShowNewPaymentForm()
+  {
+    $Form = new Form('NewPayment');
+    $Form->OnSubmit = '?Operation=NewPaymentInsert';
+    $Output = $Form->ShowEditForm();
+    return($Output);
+  }
+
+  function ShowNewPaymentInsert()
+  {
+    $Form = new Form('NewPayment');
+    $Form->LoadValuesFromForm();
+    $this->InsertMoney($Form->Values['Subject'], $Form->Values['Value'], $Form->Values['Cash'], $Form->Values['Taxable'], $Form->Values['Time'], $Form->Values['Text']);
+    $Output = $this->SystemMessage('Finance', 'Platba vložena.');
+    $this->System->Modules['Log']->NewRecord('Finance', 'NewPaymentInserted');
+    return($Output);
+  }
+
+  function ShowNewInvoiceForm()
+  {
+    $Form = new Form('NewInvoice');
+    $Form->OnSubmit = '?Operation=NewInvoiceInsert';
+    $Output = $Form->ShowEditForm();
+    return($Output);
+  }
+
+  function ShowNewInvoiceInsert()
+  {
+    $Form = new Form('NewInvoice');
+    $Form->LoadvaluesFromForm();
+    //print_r($Form->Values);
+    //$this->InsertLiability($Form->Values['Subject'], $Form->Values['Value'], $Form->Values['Time'], $BillId, $Text, $TimePayment = '')
+    $Output = $this->SystemMessage('Finance', 'Faktura vložena..');
+    $this->System->Modules['Log']->NewRecord('Finance', 'NewInvoiceInserted');
+    return($Output);
+  }
+
+  function ImportOldData()
+  {
+    global $InvoiceGenerator;
+
+    $Output = '';
+    $this->Database->query('TRUNCATE TABLE FinanceCashFlow');
+    $this->Database->query('TRUNCATE TABLE FinanceClaimsLiabilities');
+    $this->Database->query('TRUNCATE TABLE FinanceAdvances');
+    $this->Database->query('TRUNCATE TABLE FinanceSmallAssets');
+
+    // Move time of device price transformation 
+    $this->Database->query('UPDATE finance_operations SET date="2007-11-30" WHERE comment = "Jednorázový poplatek za společné zařízení"');
+
+    // Transfer finance before era
+    $DbResult = $this->Database->query('SELECT * FROM users WHERE role=2');
+    while($User = $DbResult->fetch_array())
+    {
+      $DbResult2 = $this->Database->query('SELECT SUM(money) FROM finance_operations WHERE user='.$User['id'].' AND date < "2007-12-01"');
+      $Row = $DbResult2->fetch_array();
+      $TotalAdvance = $Row[0];
+      //echo($User['second_name'].' '.$User['first_name'].' '.$TotalAdvance.'<br>');
+      // Záloha
+      if($TotalAdvance > 0) 
+      {
+        $this->InsertMoney($User['id'], $TotalAdvance, 0, 1, mktime(0, 0, 0, 12, 1, 2007), 'Přijatá záloha (z období před daňovou evidencí)');
+      }
+      // Dluh
+      if($TotalAdvance < 0) 
+      {
+        $this->InsertLiability($User['id'], (-$Row[0]), mktime(0, 0, 0, 12, 1, 2007), 0, 'Připojení k síti (z období před daňovou evidencí)');
+        //echo($Database->LastQuery.'<br>');
+      }
+    }
+
+    // Transfer finance after era
+    //  $DbResult = $Database->query('SELECT * FROM users WHERE role=2');
+    //  while($User = $DbResult->fetch_array())
+    //  {
+    $DbResult2 = $this->Database->query('SELECT finance_operations.*, users.role as role FROM finance_operations JOIN users ON users.id = finance_operations.user WHERE finance_operations.date >= "2007-12-01"');
     while($Operation = $DbResult2->fetch_array())
     {
@@ -138 +269 @@
       if(substr($Operation['comment'], 0, 19) == 'Poplatek za měsíc')
       {
-        InsertLiability($Operation['user'], -$Operation['money'], MysqlDateToTime($Operation['date']), $Operation['bill_id'], 'Připojení k síti');
-        echo($Operation['user'].' '.$Operation['money'].' Připojení k síti<br>');
+        $this->InsertLiability($Operation['user'], -$Operation['money'], MysqlDateToTime($Operation['date']), $Operation['bill_id'], 'Připojení k síti');
+        $Output .= $Operation['user'].' '.$Operation['money'].' Připojení k síti<br />';
       } else
       if($Operation['comment'] == 'Vklad')
       {
-        InsertMoney($Operation['user'], $Operation['money'], 0, 1, MysqlDateToTime($Operation['date']), 'Přijatá záloha');
+        $this->InsertMoney($Operation['user'], $Operation['money'], 0, 1, MysqlDateToTime($Operation['date']), 'Přijatá záloha');
         //echo($Operation['user'].' '.$Operation['money'].' Přijatá záloha<br>');
       } else
       if($Operation['comment'] == 'Internet')
       {
-        InsertLiability($Operation['user'], $Operation['money'], MysqlDateToTime($Operation['date']), $Operation['bill_id'], 'Měsíční paušál za Internet', MysqlDateToTime($Operation['date']));
-        InsertMoney($Operation['user'], $Operation['money'], 0, 1, MysqlDateToTime($Operation['date']), 'Měsíční paušál za Internet');
+        $this->InsertLiability($Operation['user'], $Operation['money'], MysqlDateToTime($Operation['date']), $Operation['bill_id'], 'Měsíční paušál za Internet', MysqlDateToTime($Operation['date']));
+        $this->InsertMoney($Operation['user'], $Operation['money'], 0, 1, MysqlDateToTime($Operation['date']), 'Měsíční paušál za Internet');
       } else
       if($Operation['comment'] == 'Sociální pojištění')
       {
-        InsertLiability($Operation['user'], $Operation['money'], MysqlDateToTime($Operation['date']), $Operation['bill_id'], $Operation['comment'], MysqlDateToTime($Operation['date']));
-        InsertMoney($Operation['user'], $Operation['money'], 0, 1, MysqlDateToTime($Operation['date']), $Operation['comment']);
+        $this->InsertLiability($Operation['user'], $Operation['money'], MysqlDateToTime($Operation['date']), $Operation['bill_id'], $Operation['comment'], MysqlDateToTime($Operation['date']));
+        $this->InsertMoney($Operation['user'], $Operation['money'], 0, 1, MysqlDateToTime($Operation['date']), $Operation['comment']);
       } else
       {
-        $DbResult = $Database->query('SELECT role FROM users WHERE id='.$Operation['user']);
+        $DbResult = $this->Database->query('SELECT role FROM users WHERE id='.$Operation['user']);
         while($User = $DbResult->fetch_array())
-       
-        InsertLiability($Operation['user'], -$Operation['money'], MysqlDateToTime($Operation['date']), $Operation['bill_id'], $Operation['comment'], MysqlDateToTime($Operation['date']));
-        echo($Operation['user'].' '.$Operation['comment'].' '.MysqlDateToTime($Operation['date']).'<br>');
+        $this->InsertLiability($Operation['user'], -$Operation['money'], MysqlDateToTime($Operation['date']), $Operation['bill_id'], $Operation['comment'], MysqlDateToTime($Operation['date']));
+        $Output .= $Operation['user'].' '.$Operation['comment'].' '.MysqlDateToTime($Operation['date']).'<br />';
 
         if(($Operation['role'] == 2))
-        { 
-          echo('A');
-          $Database->insert('FinanceAdvances', array('Subject' => $Operation['user'], 'Value' => $Operation['money'], 'TimeCreation' => MysqlDateToTime($Operation['date']), 'CashFlowId' => 0, 'Direction' => 'In'));
-          CheckAdvancesAndLiabilities($Operation['user']);
+        {
+          $Output .= 'A';
+          $this->Database->insert('FinanceAdvances', array('Subject' => $Operation['user'], 'Value' => $Operation['money'], 'TimeCreation' => MysqlDateToTime($Operation['date']), 'CashFlowId' => 0, 'Direction' => 'In'));
+          $this->CheckAdvancesAndLiabilities($Operation['user']);
         } else InsertMoney($Operation['user'], $Operation['money'], 0, 1, MysqlDateToTime($Operation['date']), $Operation['comment']);
       }
     }
-//  }
-
-  // Import small asset
-  $Subject = 1;
-
-  // Převod pro minulý rok
-  $Time = mktime(0, 0, 0, 12, 10, 2007);
-  $DbResult = $Database->query('SELECT * FROM network_devices WHERE used <> 0 AND date < "'.TimeToMysqlDateTime($Time).'" AND (id <> 73)');
-  $Items = array();
-  $TotalPrice = 0;
-  while($Device = $DbResult->fetch_array())
-  {
-    //$Database->insert('FinanceSmallAsset', array());
-    $Items[] = array('description' => $Device['name'], 'quantity' => $Device['count'], 'price' => 0); //$Device['price']); 
-    $LastId = $Device['id'];
-    $TotalPrice += $Device['price'] * $Device['count'];
-    if($TotalPrice > 55000) break;
-  }
-  //print_r($Items);
-  $BillId = $InvoiceGenerator->CreateBill($Subject, $Items, $Time, $Time);
-  $DbResult = $Database->query('UPDATE network_devices SET TimeEnlistment = "'.TimeToMysqlDateTime($Time).'" WHERE used <> 0 AND date < "'.TimeToMysqlDateTime($Time).'" AND (id <> 73) AND (id <= '.$LastId.')');
-  //echo($Database->error);
-  InsertLiability($Subject, 0, $Time, $BillId, 'Nákup infrastruktury', $Time);
-  //InsertMoney($Subject, 0, 0, 1, $Time, 'Nákup infrastruktury');
-
-  //echo($LastId);
-
-  // Převod tento rok
-  $Time = mktime(0, 0, 0, 1, 14, 2008);
-  $DbResult = $Database->query('SELECT * FROM network_devices WHERE (used <> 0) AND (id > '.$LastId.') AND date < "'.TimeToMysqlDateTime($Time).'"');
-  $Items = array();
-  $TotalPrice = 0;
-  while($Device = $DbResult->fetch_array())
-  {
-    //$Database->insert('FinanceSmallAsset', array());
-    $Items[] = array('description' => $Device['name'], 'quantity' => $Device['count'], 'price' => 0); //$Device['price']);
-    $TotalPrice += $Device['price'] * $Device['count'];
-  }
-  //print_r($Items);
-  $BillId = $InvoiceGenerator->CreateBill($Subject, $Items, $Time, $Time);
-  $DbResult = $Database->query('UPDATE network_devices SET TimeEnlistment = "'.TimeToMysqlDateTime($Time).'" WHERE used <> 0 AND date < "'.TimeToMysqlDateTime($Time).'" AND (id > '.$LastId.')');
-  InsertLiability($Subject, 0, $Time, $BillId, 'Nákup infrastruktury', $Time);
-  //InsertMoney($Subject, 0, 0, 1, $Time, 'Nákup infrastruktury');
-
-
-  // Make absolute value in monthly overall  
-  //$Database->query('UPDATE finance_monthly_overall SET total_paid = ABS(total_paid)');
-  //$Database->query('UPDATE finance_monthly_overall SET member_count = (SELECT COUNT(*) FROM users WHERE users.role=2 AND users.membership_date < finance_monthly_overall.date)');
+    //  }
+
+    // Import small asset
+    $Subject = 1;
+
+    // Převod pro minulý rok
+    $Time = mktime(0, 0, 0, 12, 10, 2007);
+    $DbResult = $this->Database->query('SELECT * FROM network_devices WHERE used <> 0 AND date < "'.TimeToMysqlDateTime($Time).'" AND (id <> 73)');
+    $Items = array();
+    $TotalPrice = 0;
+    while($Device = $DbResult->fetch_array())
+    {
+      //$Database->insert('FinanceSmallAsset', array());
+      $Items[] = array('description' => $Device['name'], 'quantity' => $Device['count'], 'price' => 0); //$Device['price']); 
+      $LastId = $Device['id'];
+      $TotalPrice += $Device['price'] * $Device['count'];
+      if($TotalPrice > 55000) break;
+    }
+    //print_r($Items);
+    $BillId = $InvoiceGenerator->CreateBill($Subject, $Items, $Time, $Time);
+    $DbResult = $this->Database->query('UPDATE network_devices SET TimeEnlistment = "'.TimeToMysqlDateTime($Time).'" WHERE used <> 0 AND date < "'.TimeToMysqlDateTime($Time).'" AND (id <> 73) AND (id <= '.$LastId.')');
+    //echo($Database->error);
+    $this->InsertLiability($Subject, 0, $Time, $BillId, 'Nákup infrastruktury', $Time);
+    //InsertMoney($Subject, 0, 0, 1, $Time, 'Nákup infrastruktury');
+
+    //echo($LastId);
+
+    // Převod tento rok
+    $Time = mktime(0, 0, 0, 1, 14, 2008);
+    $DbResult = $this->Database->query('SELECT * FROM network_devices WHERE (used <> 0) AND (id > '.$LastId.') AND date < "'.TimeToMysqlDateTime($Time).'"');
+    $Items = array();
+    $TotalPrice = 0;
+    while($Device = $DbResult->fetch_array())
+    {
+      // $Database->insert('FinanceSmallAsset', array());
+      $Items[] = array('description' => $Device['name'], 'quantity' => $Device['count'], 'price' => 0); //$Device['price']);
+      $TotalPrice += $Device['price'] * $Device['count'];
+    }
+    //print_r($Items);
+    $BillId = $InvoiceGenerator->CreateBill($Subject, $Items, $Time, $Time);
+    $DbResult = $this->Database->query('UPDATE network_devices SET TimeEnlistment = "'.TimeToMysqlDateTime($Time).'" WHERE used <> 0 AND date < "'.TimeToMysqlDateTime($Time).'" AND (id > '.$LastId.')');
+    $this->InsertLiability($Subject, 0, $Time, $BillId, 'Nákup infrastruktury', $Time);
+    //InsertMoney($Subject, 0, 0, 1, $Time, 'Nákup infrastruktury');
+
+
+    // Make absolute value in monthly overall  
+    //$Database->query('UPDATE finance_monthly_overall SET total_paid = ABS(total_paid)');
+    //$Database->query('UPDATE finance_monthly_overall SET member_count = (SELECT COUNT(*) FROM users WHERE users.role=2 AND users.membership_date < finance_monthly_overall.date)'); 
+    return($Output);
+  }
+
+  function ConvertPDFDataToFiles()
+  {
+    $DbResult = $this->Database->query('SELECT * FROM finance_bills');
+    while($Bill = $DbResult->fetch_array())
+    {
+      file_put_contents('doklady/doklad_'.$Bill['id'].'.pdf', $Bill['pdf']);
+      echo($Bill['id'].',');
+    }
+  }
+
+  function CheckPDFFiles()
+  {
+    global $Database, $InvoiceGenerator;
+
+    $DbResult = $this->Database->query('SELECT * FROM finance_bills');
+    while($Bill = $DbResult->fetch_array())
+    {
+      file_put_contents('doklady2/doklad-'.$Bill['id'].'.pdf', file_get_contents('doklady/doklad-'.$Bill['id'].'.pdf'));
+      //echo($InvoiceGenerator->HasPDFFile($Bill['id']).',');
+    }
+  }
+
 }
 
-function ConvertPDFDataToFiles()
-{
-  global $Database;
-  $DbResult = $Database->query('SELECT * FROM finance_bills');
-  while($Bill = $DbResult->fetch_array())
-  {
-    file_put_contents('doklady/doklad-'.$Bill['id'].'.pdf', $Bill['pdf']);
-    echo($Bill['id'].',');
-  }
-
-}
-
-function CheckPDFFiles()
-{
-  global $Database, $InvoiceGenerator;
-
-  $DbResult = $Database->query('SELECT * FROM finance_bills');
-  while($Bill = $DbResult->fetch_array())
-  {
-    file_put_contents('doklady2/doklad-'.$Bill['id'].'.pdf', file_get_contents('doklady/doklad-'.$Bill['id'].'.pdf'));
-    //echo($InvoiceGenerator->HasPDFFile($Bill['id']).',');
-  }
-
-}
-
-//ConvertPDFDataToFiles();
-
-//CheckPDFFiles();
-ImportOldData();
+$System->AddModule(new FinanceManagePage());
+$System->Modules['FinanceManagePage']->GetOutput();
 
 ?>

www/finance/monthly_overall.php

@@ -1 +1 @@
 <?php
-include('../global.php');
-include('../style.php');
-include('include.php');
-ShowHeader('Měsíční přehledy', 'Měsíční přehledy');
+include_once('../global.php');
+include_once('include.php');
 
-echo('<table cellspacing="0" cellpadding="2" border="1"><tr><th>Rok</th><th>Měsíc</th><th>Internet [Kč]</th><th>Účastníků</th><th>Správa [Kč/účastníka]</th><th>Správa [Kč]</th><th>Spotřeba [Kč/kWh]</th><th>Spotřeba [Kč]</th><th>Obrat [Kč]</th><th>Průměrná cena [Kč/účastníka]</th><th>Investice [Kč]</th></tr>');
-$Total = array('money' => 0, 'administration_total' => 0, 'consumption_total' => 0, 'total_paid' => 0, 'investment' => 0);
-$DbResult = $Database->select('finance_monthly_overall', '*', '1 ORDER BY date ASC');
-while($Month = $DbResult->fetch_array())
+class FinanceMonthlyOverallPage extends Page
 {
-  $DateParts = explode('-', $Month['date']);
-  echo('<tr><td>'.$DateParts[0].'</td><td align="center">'.$MonthNames[$DateParts[1]*1].'</td><td align="center">'.$Month['money'].'</td><td align="center">'.$Month['member_count'].'</td><td align="center">'.$Month['administration'].'</td><td align="center">'.$Month['administration_total'].'</td><td align="center">'.$Month['kWh'].'</td><td align="center">'.$Month['consumption_total'].'</td><td align="center">'.$Month['total_paid'].'</td><td align="center">'.round($Month['total_paid'] / $Month['member_count']).'</td><td align="center">'.$Month['investment'].'</td></tr>');
-//  echo('<tr><td>'.$Month['date'].'</td><td align="center">'.$MonthNames[$DateParts[1]*1].'</td><td align="center">'.$Month['money'].'</td><td align="center">'.$Month['member_count'].'</td><td align="center">'.$Month['administration'].'</td><td align="center">'.$Month['administration_total'].'</td><td align="center">'.$Month['kWh'].'</td><td align="center">'.$Month['consumption_total'].'</td><td align="center">'.$Month['total_paid'].'</td><td align="center">'.round($Month['total_paid'] / $Month['member_count']).'</td></tr>');
+  var $FullTitle = 'Měsíční přehledy';
+  var $ShortTitle = 'Měsíční přehledy';
 
-  $Total['money'] += $Month['money'];
-  $Total['administration_total'] += $Month['administration_total'];
-  $Total['consumption_total'] += $Month['consumption_total'];
-  $Total['total_paid'] += $Month['total_paid'];
-  $Total['investment'] += $Month['investment'];
-  //if($DateParts[1] == '01') echo('<tr><td style="font-size: 4;" colspan="10">&nbsp;</td></tr>');
+  function Show()
+  {
+    global $MonthNames;
+
+    $Output = '<table cellspacing="0" cellpadding="2" border="1"><tr><th>Rok</th><th>Měsíc</th><th>Internet [Kč]</th><th>Účastníků</th><th>Správa [Kč/účastníka]</th><th>Správa [Kč]</th><th>Spotřeba [Kč/kWh]</th><th>Spotřeba [Kč]</th><th>Obrat [Kč]</th><th>Průměrná cena [Kč/účastníka]</th><th align="center">Investice [Kč]</th></tr>';
+    $Total = array('money' => 0, 'administration_total' => 0, 'consumption_total' => 0, 'total_paid' => 0);
+    $DbResult = $this->Database->select('finance_monthly_overall', '*', '1 ORDER BY date DESC');
+    while($Month = $DbResult->fetch_array())
+    {
+      $DateParts = explode('-', $Month['date']);
+      $Output .= '<tr><td>'.$DateParts[0].'</td><td align="center">'.$MonthNames[$DateParts[1]*1].'</td><td align="center">'.$Month['money'].'</td><td align="center">'.$Month['member_count'].'</td><td align="center">'.$Month['administration'].'</td><td align="center">'.$Month['administration_total'].'</td><td align="center">'.$Month['kWh'].'</td><td align="center">'.$Month['consumption_total'].'</td><td align="center">'.$Month['total_paid'].'</td><td align="center">'.round($Month['total_paid'] / $Month['member_count']).'</td><td align="center">'.$Month['investment'].'</td></tr>';
+
+      $Total['money'] += $Month['money'];
+      $Total['administration_total'] += $Month['administration_total'];
+      $Total['consumption_total'] += $Month['consumption_total'];
+      $Total['total_paid'] += $Month['total_paid'];
+          $Total['investment'] += $Month['investment'];
+      //if($DateParts[1] == '01') echo('<tr><td style="font-size: 4;" colspan="10">&nbsp;</td></tr>');
+    }
+    $Output .= '<tr><th colspan="2">Celkem</th><th>'.$Total['money'].'</th><th>&nbsp;</th><th>&nbsp;</th><th>'.$Total['administration_total'].'</th><th>&nbsp;</th><th>'.$Total['consumption_total'].'</th><th>'.$Total['total_paid'].'</th><th>&nbsp;</th><th>'.$Total['investment'].'</th>';
+    $Output .= '</table>';
+    return($Output);
+  }
 }
-echo('<tr><th colspan="2">Celkem</th><th>'.$Total['money'].'</th><th>&nbsp;</th><th>&nbsp;</th><th>'.$Total['administration_total'].'</th><th>&nbsp;</th><th>'.$Total['consumption_total'].'</th><th>'.$Total['total_paid'].'</th><th>&nbsp;</th><th>'.$Total['investment'].'</tr>');
-echo('</table>');
 
-ShowFooter();
+$System->AddModule(new FinanceMonthlyOverallPage());
+$System->Modules['FinanceMonthlyOverallPage']->GetOutput();
+
 ?>

www/finance/spotreba.php

@@ -1 +1 @@
 <?php
 include_once('../global.php');
-include('../style.php');
-include('include.php');
+include_once('include.php');
 
-ShowHeader('Spotřeba energie','Spotřeba');
+class FinanceConsumption extends Page
+{
+  var $FullTitle = 'Spotřeba energie';
+  var $ShortTitle = 'Spotřeba';
 
-// Seznam segmentů a zařízení
-echo('Spotřeba zařízení jednotlivých segmentů:<br><table border="1" cellspacing="0" cellpadding="3"><tr><th>Jméno segmentu</th><th>Spotřeba [W]</th><th>Cena [Kč/měsíc]</th></tr>');
-$CelkovaSpotreba = 0;
-$DbResult = $Database->query("SELECT * FROM network_segments");    
-while($Row = $DbResult->fetch_array())
-{
-  $DbResult2 = $Database->query("SELECT SUM(consumption) FROM network_devices WHERE segment=".$Row['id']." AND used=1");
-  $Row2 = $DbResult2->fetch_array();
-  $CelkovaSpotreba = $CelkovaSpotreba + $Row2[0];
-  echo('<tr><td>'.$Row['name'].'</td><td align="right">'.$Row2[0].'</td><td align="right">'.W2Kc($Row2[0]).'</td></tr>');
+  function Show()
+  {
+    global $kWh;
+
+    // Seznam segmentů a zařízení
+    $Output = 'Spotřeba zařízení jednotlivých segmentů:<br /><table border="1" cellspacing="0" cellpadding="3"><tr><th>Jméno segmentu</th><th>Spotřeba [W]</th><th>Cena [Kč/měsíc]</th></tr>';
+    $CelkovaSpotreba = 0;
+    $DbResult = $this->Database->query("SELECT * FROM network_segments");
+    while($Row = $DbResult->fetch_array())
+    {
+      $DbResult2 = $this->Database->query("SELECT SUM(consumption) FROM network_devices WHERE segment=".$Row['id']." AND used=1");
+      $Row2 = $DbResult2->fetch_array();
+      $CelkovaSpotreba = $CelkovaSpotreba + $Row2[0];
+      $Output .= '<tr><td>'.$Row['name'].'</td><td align="right">'.$Row2[0].'</td><td align="right">'.W2Kc($Row2[0]).'</td></tr>';
+    }
+    $Output .= '<tr style="font-weight: Bold;"><td><strong>Celkem</strong></td><td align="right">'.$CelkovaSpotreba.'</td><td align="right">'.W2Kc($CelkovaSpotreba).'</td></tr>';
+    $Output .= '</table><br />';
+    $Output .= 'Dohodnutá cena za jednu kWh: <strong>'.$kWh.' Kč</strong><br />';
+    return($Output);
+  }
 }
-echo('<tr style="font-weight: Bold;"><td><strong>Celkem</strong></td><td align="right">'.$CelkovaSpotreba.'</td><td align="right">'.W2Kc($CelkovaSpotreba).'</td></tr>');
-echo('</table><br>');
-echo('Dohodnutá cena za jednu kWh: <strong>'.$kWh.' Kč</strong><br>');
 
-/*
-echo('<strong>Jak se rozpočítávají finance</strong><br>Internet i zařízení sítě se platí za domácnost. Systém výpočtu vychází z topologie sítě. Síť má stromovou topologii přičemž listy stromu jsou jednotliví uživatelé a kořen stromu je linka do internetu. Dosavadní systém je uzpůsoben tak, aby linky, které jsou nejvíce zatíženy, byly nejlépe zaplaceny a mohlo na nich tak být dražší a výkonější zařízení. Nejvytíženější linky se nazývají páteřní. Proto platí každý uživatel podílově zařízení, které vede od něj až ke kořenu stromu, což je v našem případě server Centrála s trvalým internetovým připojením. Pro jednoduchost je síť rozdělena na segmenty. Segment je část sítě, kterou využívá konstantní počet uživatelů. Každý segment je tvořen skupinou zařízení a má svoji celkovou cenu. Každý uživatel je přirozeně napojen na některý ze segmentů. Podíl klienta na zařízení sítě je vypočten jako součet podílů na jednotlivých segmentech směrem ke kořenu. Podíl na segmentu znamená celková cena segmentu podělená počtem uživatelů využívajících daný segment.<br>');
-  }
-*/
-ShowFooter();
+$System->AddModule(new FinanceConsumption());
+$System->Modules['FinanceConsumption']->GetOutput();
+
 ?>

www/finance/tarify.php

@@ -1 +1 @@
 <?php
-include('../style.php');
-include('include.php');
-ShowHeader('Aktuální stav tarifů', 'Tarify');
+include_once('../global.php');
+include_once('include.php');
 
-function TariffTable()
+class FinanceTarrifsPage extends Page
 {
-  global $Tarify, $Internet, $InternetUsers, $RealMaxSpeed, $SpeedReserve, $MaxSpeed;
+  var $FullTitle = 'Přehled tarifů';
+  var $ShortTitle = 'Tarify';
 
-  echo('Poplatek za společný internet: <strong>'.$Internet.' Kč</strong><br>');
-  echo('Rychlost společné linky: <strong>'.$RealMaxSpeed.' kbit/s</strong><br>');
-  echo('Rezerva (nevyužitá kapacita pro zlepšení odezvy sítě): <strong>'.$SpeedReserve.' kbit/s</strong><br>');
-  echo('Maximální dostupná kapacita pro použití: <strong>'.$MaxSpeed.' kbit/s</strong><br>');
-  echo('<br>');
-  
-  echo('<table width="50%" border="1" cellspacing="0" cellpadding="2" style="font-size: small;">');
-  echo('<tr><th>Název tarifu</th><th>Min. rychlost [kbit/s]</th><th>Max. rychlost [kbit/s]</th><th>Agregační poměr</th><th>Cenových jednotek</th><th>Počet podílníků</th><th>Celkem cenových jednotek</th><th>Cena [Kč]</th><th>Vybráno celkem [Kč]</th></tr>');
-  $TotalPrice = 0;
-  $TotalUnits = 0;
-  foreach($Tarify as $Index => $Tarif)
+  function TariffTable()
   {
-    echo('<tr><td style="color: blue;">'.$Tarif['name'].'</td><td align="center">'.round($Tarif['min_speed'] / 1024).'</td><td align="center" style="color: blue;">'.round($Tarif['max_speed'] / 1024).'</td><td align="center">'.$Tarif['aggregation'].'</td><td align="center">'.$Tarif['price_units'].'</td><td align="center">'.$Tarif['user_count'].'</td><td align="center">'.
-      $Tarif['total_units'].'</td><td align="center" style="color: blue;">'.$Tarif['price'].'</td><td align="center">'.$Tarif['user_count'] * $Tarif['price'].'</td></tr>');
-    $TotalPrice = $TotalPrice + $Tarif['price'] * $Tarif['user_count'];
-    $TotalUnits = $TotalUnits + $Tarif['total_units'];
+    global $Tarify, $Internet, $InternetUsers, $RealMaxSpeed, $SpeedReserve, $MaxSpeed;
+
+    $Output = 'Poplatek za společný internet: <strong>'.$Internet.' Kč</strong><br />';
+    $Output .= 'Rychlost společné linky: <strong>'.$RealMaxSpeed.' kbit/s</strong><br />';
+    $Output .= 'Rezerva (nevyužitá kapacita pro zlepšení odezvy sítě): <strong>'.$SpeedReserve.' kbit/s</strong><br />';
+    $Output .= 'Maximální dostupná kapacita pro použití: <strong>'.$MaxSpeed.' kbit/s</strong><br />';
+    $Output .= '<br />';
+
+    $Output .= '<table width="50%" border="1" cellspacing="0" cellpadding="2" style="font-size: small;">';
+    $Output .= '<tr><th>Název tarifu</th><th>Min. rychlost [kbit/s]</th><th>Max. rychlost [kbit/s]</th><th>Agregační poměr</th><th>Cenových jednotek</th><th>Počet podílníků</th><th>Celkem cenových jednotek</th><th>Cena [Kč]</th><th>Vybráno celkem [Kč]</th></tr>';
+    $TotalPrice = 0;
+    $TotalUnits = 0;
+    foreach($Tarify as $Index => $Tarif)
+    {
+      $Output .= '<tr><td style="color: blue;">'.$Tarif['name'].'</td><td align="center">'.round($Tarif['min_speed'] / 1024).'</td><td align="center" style="color: blue;">'.round($Tarif['max_speed'] / 1024).'</td><td align="center">'.$Tarif['aggregation'].'</td><td align="center">'.$Tarif['price_units'].'</td><td align="center">'.$Tarif['user_count'].'</td><td align="center">'.
+      $Tarif['total_units'].'</td><td align="center" style="color: blue;">'.$Tarif['price'].'</td><td align="center">'.$Tarif['user_count'] * $Tarif['price'].'</td></tr>';
+      $TotalPrice = $TotalPrice + $Tarif['price'] * $Tarif['user_count'];
+      $TotalUnits = $TotalUnits + $Tarif['total_units'];
+    }
+    $Output .= '<tr><td>Součty</td><td colspan="4">&nbsp;</td><td align="center">'.$InternetUsers.'</td><td align="center">'.$TotalUnits.'</td><td>&nbsp;</td><td align="center">'.$TotalPrice.'</td></tr>';
+    $Output .= '</table>';
+    return($Output);
   }
-  echo('<tr><td>Součty</td><td colspan="4">&nbsp;</td><td align="center">'.$InternetUsers.'</td><td align="center">'.$TotalUnits.'</td><td>&nbsp;</td><td align="center">'.$TotalPrice.'</td></tr>');
-  echo('</table>');
+
+  function Show()
+  {
+    global $Tarify, $Internet, $InternetUsers, $RealMaxSpeed, $SpeedReserve, $MaxSpeed;
+    $Output = 'Počet členů s internetovým připojením: <strong>'.$InternetUsers.'</strong><br /><br />';
+    $Output .= '<table><tr><td valign="top">';
+
+    NactiMesicniParametry(0);
+    $Output .= '<strong>Stav pro aktuální měsíc:</strong><br />';
+    $Output .= $this->TariffTable();
+
+    $Output .= '<br /></td></tr><tr><td valign="top">';
+
+    NactiMesicniParametry(1);
+    $Output .= '<strong>Stav pro další měsíc:</strong><br />';
+    $Output .= $this->TariffTable();
+
+    $Output .= '</td></tr></table>';
+
+    $Output .= '<br /><strong>Doplňující informace:</strong><br />';
+    $Output .= 'Minimální rychlostí se rozumí garantovaná rychlost, tedy zaručený podíl z celkové kapacity linky.<br />
+    Maximální rychlost je teoretická nejvyšší dostupná rychlost.<br />
+    Skutečná rychlost může mírně kolísat kolem těchto hodnot, jelikož řízení toku není dokonalé.<br />
+    Agregační pomněr je poměr mezi minimální garantovanou rychlostí a maximální dosažitelnou rychlostí. Ukazuje, jak moc je linka sdílena a jak hodně může rychlost kolísat. Při posuzování kvality linky je toto také důležitý ukazatel.<br />
+    Cenové jednotky vystihují jakým podílem se poplatek za tarif podílí na celkové placené sumě.<br />
+    Počet podílníků znamená počet uživatelů platících daný tarif.<br />
+    Údaj celkem cenových jednotek je součin počtu podílníků a cenových jednotek. Vystihuje podíl všech uživatelů v daném tarifu na celkové placené sumě.<br />
+    Cena udává rozpočtenou celkovou cenu na jednotlivé tarify podle cenových jednotek.<br />
+    Sloupec vybráno dává informaci, kolik se v kterém tarifu vybralo peněz na placení společné linky.<br /><br />';
+    $Output .= 'Tabulka Stav pro aktuální měsíc se aktualizuje první den v měsíci při odečtení peněz z účtů dle tabulky na příští měsíc.<br />';
+
+    $Output .= '<br />Změnu tarifu na další měsíc oznamujte prozatím na email robie@centrum.cz<br />';
+    $Output .= '<a href="http://centrala.zdechov.net/forum/viewtopic.php?t=50">Diskuse</a><br />';
+    return($Output);
+  }
 }
 
-echo('Počet členů s internetovým připojením: <strong>'.$InternetUsers.'</strong><br><br>');
-echo('<table><tr><td valign="top">');
+$System->AddModule(new FinanceTarrifsPage());
+$System->Modules['FinanceTarrifsPage']->GetOutput();
 
-NactiMesicniParametry(0);
-echo('<strong>Stav pro aktuální měsíc:</strong><br>');
-TariffTable();
-
-echo('<br></td></tr><tr><td valign="top">');
-
-NactiMesicniParametry(1);
-echo('<strong>Stav pro další měsíc:</strong><br>');
-TariffTable();
-
-echo('</td></tr></table>');
-
-echo('<br><strong>Doplňující informace:</strong><br>');
-echo('Minimální rychlostí se rozumí garantovaná rychlost, tedy zaručený podíl z celkové kapacity linky.<br>
-Maximální rychlost je teoretická nejvyšší dostupná rychlost.<br>
-Skutečná rychlost může mírně kolísat kolem těchto hodnot, jelikož řízení toku není dokonalé.<br>
-Agregační pomněr je poměr mezi minimální garantovanou rychlostí a maximální dosažitelnou rychlostí. Ukazuje, jak moc je linka sdílena a jak hodně může rychlost kolísat. Při posuzování kvality linky je toto také důležitý ukazatel.<br>
-Cenové jednotky vystihují jakým podílem se poplatek za tarif podílí na celkové placené sumě.<br>
-Počet podílníků znamená počet uživatelů platících daný tarif.<br>
-Údaj celkem cenových jednotek je součin počtu podílníků a cenových jednotek. Vystihuje podíl všech uživatelů v daném tarifu na celkové placené sumě.<br>
-Cena udává rozpočtenou celkovou cenu na jednotlivé tarify podle cenových jednotek.<br>
-Sloupec vybráno dává informaci, kolik se v kterém tarifu vybralo peněz na placení společné linky.<br><br>');
-echo('Tabulka Stav pro aktuální měsíc se aktualizuje první den v měsíci při odečtení peněz z účtů dle tabulky na příští měsíc.<br>');
-  
-echo('<br>Změnu tarifu na další měsíc oznamujte prozatím na email robie@centrum.cz<br>');
-echo('<a href="http://centrala.zdechov.net/forum/viewtopic.php?t=50">Diskuse</a><br>');
-
-ShowFooter();
 ?>

www/finance/zarizeni.php

@@ -1 +1 @@
 <?php
 include_once('../global.php');
-include('../style.php');
-ShowHeader('Zařízení sítě','Zařízení');
+include_once('include.php');
 
-// 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>');
-$DbResult = $Database->query("SELECT * FROM network_segments");    
-while($Row = $DbResult->fetch_array())
+class FinanceDeviceListPage extends Page
 {
-  echo('<tr><td colspan="3"><strong>Segment: '.$Row['name'].' ('.$Row['users'].')</strong></td><td style="font-weight: Bold;" align="right">'.$Row['price'].'</td></tr>');
-  $DbResult2 = $Database->query("SELECT * FROM network_devices WHERE segment=".$Row['id']." AND used=1");
-  while($Row = $DbResult2->fetch_array())
+  var $FullTitle = 'Zařízení sítě';
+  var $ShortTitle = 'Zařízení';
+
+  function Show()
   {
-    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>');
+    // Seznam segmentů a zařízení
+    $Output = '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>';
+    $DbResult = $this->Database->query("SELECT * FROM network_segments");    
+    while($Row = $DbResult->fetch_array())
+    {
+      $Output .= '<tr><td colspan="3"><strong>Segment: '.$Row['name'].' ('.$Row['users'].')</strong></td><td style="font-weight: Bold;" align="right">'.$Row['price'].'</td></tr>';
+      $DbResult2 = $this->Database->query("SELECT * FROM network_devices WHERE segment=".$Row['id']." AND used=1");
+      while($Row = $DbResult2->fetch_array())
+      {
+        $Output .= '<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>';
+      }
+    }
+    $DbResult = $this->Database->query("SELECT SUM(price) FROM network_devices 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);
   }
 }
-$DbResult = $Database->query("SELECT SUM(price) FROM network_devices WHERE used=1");
-$Row = $DbResult->fetch_array();
-echo('<tr><td colspan="3"><strong>Celkem:</strong></td><td align="right"><strong>'.$Row[0].'</strong></td></tr>');
-echo('</table>');
 
-ShowFooter();
+$System->AddModule(new FinanceDeviceListPage());
+$System->Modules['FinanceDeviceListPage']->GetOutput()
+
 ?>

www/finance/zivnost.php

@@ -1 +1 @@
 <?php
-
-include('../style.php');
-include('include.php');
-include('bills.php');
-RecalculateTariffs(1);
-
-ShowHeader('Daňová evidence', 'Daňová evidence');
-
-function TransformFinance()
+include_once('../global.php');
+include_once('include.php');
+
+class FinanceTaxFilingPage extends Page
 {
-  global $Database;
-  //$Database->Query('SELECT user as Subject, date as TimeCreation, date as TimeDue, date as TimePayment, -money as Value, bill_id as Bill, comment as Text FROM `finance_operations` WHERE Comment LIKE "Poplatek za měsíc%" AND date >= "2007-12-01"');
-  //'TRUNCATE TABLE FinanceCashFlow; INSERT INTO FinanceCashFlow (SELECT '' as Id, user as Subject, comment as Text, date as Time, 1 as Taxable, 0 as Cash, money as Value, bill_id as Bill FROM `finance_operations` WHERE comment NOT LIKE "Poplatek za měsíc%" AND date >= "2007-12-01")'
-  // 'UPDATE finance_operations SET date="2007-11-24" WHERE comment="Jednorázový poplatek za společné zařízení"'
-
-/*
-  $DbResult = $Database->query('SELECT * FROM users WHERE role=2');
-  while($User = $DbResult->fetch_array())
-  {
-    $DbResult2 = $Database->query('SELECT SUM(money) FROM finance_operations WHERE user='.$User['id'].' AND date < "2007-12-01"');
-    $Row = $DbResult2->fetch_array();
-    echo($User['second_name'].' '.$User['first_name'].' '.$Row[0].'<br>');
-//    if($Row[0] > 0) $Database->insert('FinanceCashFlow', array('Text' => 'Přijatá záloha (z období před účetnictvím)', 'Subject' => $User['id'], 'Time' => '2007-01-01', 'Taxable' => 1, 'Cash' => 0, 'Value' => $Row[0], 'Bill' => 0));
-    
-    if($Row[0] < 0) 
-    {  
-      $Database->insert('FinanceClaimsLiabilities', array('Text' => 'Připojení k síti (z období před účetnictvím)', 'Subject' => $User['id'], 'TimeCreation' => '2007-12-01', 'TimeDue' => '2007-12-14', 'TimePayment' => '', 'Value' => (-$Row[0]), 'Bill' => 0));
-  //echo($Database->LastQuery.'<br>');
+  var $FullTitle = 'Daňová evidence';
+  var $ShortTitle = 'Daňová evidence';
+
+  function TransformFinance()
+  {
+    //$Database->Query('SELECT user as Subject, date as TimeCreation, date as TimeDue, date as TimePayment, -money as Value, bill_id as Bill, comment as Text FROM `finance_operations` WHERE Comment LIKE "Poplatek za měsíc%" AND date >= "2007-12-01"');
+    //'TRUNCATE TABLE FinanceCashFlow; INSERT INTO FinanceCashFlow (SELECT '' as Id, user as Subject, comment as Text, date as Time, 1 as Taxable, 0 as Cash, money as Value, bill_id as Bill FROM `finance_operations` WHERE comment NOT LIKE "Poplatek za měsíc%" AND date >= "2007-12-01")'
+    // 'UPDATE finance_operations SET date="2007-11-24" WHERE comment="Jednorázový poplatek za společné zařízení"'
+
+    $DbResult = $this->Database->query('SELECT * FROM users WHERE role=2');
+    while($User = $DbResult->fetch_array())
+    {
+      $DbResult2 = $this->Database->query('SELECT SUM(money) FROM finance_operations WHERE user='.$User['id'].' AND date < "2007-12-01"');
+      $Row = $DbResult2->fetch_array();
+      echo($User['second_name'].' '.$User['first_name'].' '.$Row[0].'<br />');
+      //    if($Row[0] > 0) $Database->insert('FinanceCashFlow', array('Text' => 'Přijatá záloha (z období před účetnictvím)', 'Subject' => $User['id'], 'Time' => '2007-01-01', 'Taxable' => 1, 'Cash' => 0, 'Value' => $Row[0], 'Bill' => 0));
+      if($Row[0] < 0) 
+      {
+        $this->Database->insert('FinanceClaimsLiabilities', array('Text' => 'Připojení k síti (z období před účetnictvím)', 'Subject' => $User['id'], 'TimeCreation' => '2007-12-01', 'TimeDue' => '2007-12-14', 'TimePayment' => '', 'Value' => (-$Row[0]), 'Bill' => 0));
+        //echo($Database->LastQuery.'<br />');
+      }
     }
-  }  
-*/
-}
-
-TransformFinance();
-
-if(!array_key_exists('table', $_GET)) $_GET['table'] = '';
-switch($_GET['table'])
-{
-  case 'AnnualBalance':
-    echo('<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">');
-    echo('<tr><th colspan="3">Účetní období</th><th colspan="5">Na konci</th><th colspan="6">Během</th></tr>');
-    echo('<tr><th>Rok</th><th>Od</th><th>Do</th><th>Příjmy</th><th>Výdaje</th><th>Pohledávky</th><th>Závazky</th><th>Drobný majetek</th><th>Příjmy</th><th>Výdaje</th><th>Pohledávky</th><th>Závazky</th><th>Drobný majetek</th><th>Základ daně</th></tr>');
-
-    $StartEvidence = mktime(0, 0, 0, 12, 1, 2007);
-    $StartYear = date('Y', $StartEvidence);
-    $EndYear = date('Y', time());
-    for($Year = $StartYear; $Year <= $EndYear; $Year++)
-    {   
-      $EndTime = mktime(0, 0, 0, 12, 31, $Year);
-      $Year = date('Y', $EndTime);
-      $StartTime = mktime(0, 0, 0, 1, 1, $Year);
-      if($StartTime < $StartEvidence) $StartTime = $StartEvidence;
-
-      $Balance = array();
-
-      $DbResult = $Database->query('SELECT SUM(Value) FROM FinanceCashFlow WHERE Time < "'.TimeToMysqlDateTime($StartTime).'" AND Value > 0 AND Taxable = 1');
-      $Row = $DbResult->fetch_array();
-      $Balance['Income']['Start'] = $Row[0] + 0;
-      $DbResult = $Database->query('SELECT SUM(Value) FROM FinanceCashFlow WHERE Time <= "'.TimeToMysqlDateTime($EndTime).'" AND Value > 0 AND Taxable = 1');
-      //echo('SELECT SUM(Value) FROM FinanceCashFlow WHERE Time <= "'.TimeToMysqlDateTime($EndTime).'" AND Value > 0 AND Taxable = 1'.'<br>');
-      $Row = $DbResult->fetch_array();
-      $Balance['Income']['End'] = $Row[0] + 0;
-
-      $DbResult = $Database->query('SELECT -SUM(Value) FROM FinanceCashFlow WHERE Time < "'.TimeToMysqlDateTime($StartTime).'" AND Value < 0 AND Taxable = 1');
-      $Row = $DbResult->fetch_array();
-      $Balance['Spend']['Start'] = $Row[0] + 0;
-      $DbResult = $Database->query('SELECT -SUM(Value) FROM FinanceCashFlow WHERE Time <= "'.TimeToMysqlDateTime($EndTime).'" AND Value < 0 AND Taxable = 1');
-      //echo('SELECT -SUM(Value) FROM FinanceCashFlow WHERE Time <= "'.TimeToMysqlDateTime($EndTime).'" AND Value < 0 AND Taxable = 1'.'<br>');
-      $Row = $DbResult->fetch_array();
-      $Balance['Spend']['End'] = $Row[0] + 0;
-
-      $DbResult = $Database->query('SELECT SUM(Value) FROM FinanceClaimsLiabilities WHERE TimeCreation < "'.TimeToMysqlDateTime($StartTime).'" AND TimePayment = "0000-00-00 00:00:00" AND Value > 0');
-      $Row = $DbResult->fetch_array();
-      $Balance['Claims']['Start'] = $Row[0] + 0;
-      $DbResult = $Database->query('SELECT SUM(Value) FROM FinanceClaimsLiabilities WHERE TimeCreation <= "'.TimeToMysqlDateTime($EndTime).'" AND TimePayment = "0000-00-00 00:00:00" AND Value > 0');
-      $Row = $DbResult->fetch_array();
-      $Balance['Claims']['End'] = $Row[0] + 0;
-
-      $DbResult = $Database->query('SELECT -SUM(Value) FROM FinanceClaimsLiabilities WHERE TimeCreation < "'.TimeToMysqlDateTime($StartTime).'" AND TimePayment = "0000-00-00 00:00:00" AND Value < 0');
-      $Row = $DbResult->fetch_array();
-      $Balance['Liabilities']['Start'] = $Row[0] + 0;
-      $DbResult = $Database->query('SELECT -SUM(Value) FROM FinanceClaimsLiabilities WHERE TimeCreation <= "'.TimeToMysqlDateTime($EndTime).'" AND TimePayment = "0000-00-00 00:00:00" AND Value < 0');
-      $Row = $DbResult->fetch_array();
-      $Balance['Liabilities']['End'] = $Row[0] + 0;
-
-      // SmallAssets
-      $DbResult = $Database->query('SELECT SUM(price) FROM network_devices WHERE (TimeEnlistment < "'.TimeToMysqlDateTime($StartTime).'") AND (TimeEnlistment != 0) AND ((TimeElimination > "'.TimeToMysqlDateTime($StartTime).'") OR (TimeElimination = 0))');
-      echo($Database->error);
-      $Row = $DbResult->fetch_array();
-      $Balance['SmallAssets']['Start'] = $Row[0] + 0;
-      $DbResult = $Database->query('SELECT SUM(price) FROM network_devices WHERE (TimeEnlistment < "'.TimeToMysqlDateTime($EndTime).'") AND (TimeEnlistment != 0) AND ((TimeElimination > "'.TimeToMysqlDateTime($EndTime).'") OR (TimeElimination = 0))');
-      $Row = $DbResult->fetch_array();
-      $Balance['SmallAssets']['End'] = $Row[0] + 0;
-    
-
-      echo('<tr><td>'.$Year.'</td><td>'.date(HumanDate(TimeToMysqlDateTime($StartTime))).'</td><td>'.date(HumanDate(TimeToMysqlDateTime($EndTime))).'</td>');
-      echo('<td>'.$Balance['Income']['End'].'</td>');
-      echo('<td>'.$Balance['Spend']['End'].'</td>');
-      echo('<td>'.$Balance['Claims']['End'].'</td>');
-      echo('<td>'.$Balance['Liabilities']['End'].'</td>');
-      echo('<td>'.$Balance['SmallAssets']['End'].'</td>');
-
-      echo('<td>'.($Balance['Income']['End'] - $Balance['Income']['Start']).'</td>');
-      echo('<td>'.($Balance['Spend']['End'] - $Balance['Spend']['Start']).'</td>');
-      echo('<td>'.($Balance['Claims']['End'] - $Balance['Claims']['Start']).'</td>');
-      echo('<td>'.($Balance['Liabilities']['End'] - $Balance['Liabilities']['Start']).'</td>');
-      echo('<td>'.($Balance['SmallAssets']['End'] - $Balance['SmallAssets']['Start']).'</td>');
-      echo('<td>'.(($Balance['Income']['End'] - $Balance['Income']['Start']) - ($Balance['Spend']['End'] - $Balance['Spend']['Start'])).'</td></tr>');
-    }
-    echo('</table>');
-    
-//    echo('<tr><td colspan="2">Výkaz o majetku a závazcích</td><td>Ing. Jiří Hajda</td></tr>');
-/*
+  }
+
+  function Show()
+  {
+    RecalculateTariffs(1);
+    //TransformFinance();
+
+    $Output = '';
+    if(!array_key_exists('table', $_GET)) $_GET['table'] = '';
+    switch($_GET['table'])
+    {
+      case 'AnnualBalance':
+        $Output = '<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">';
+        $Output .= '<tr><th colspan="3">Účetní období</th><th colspan="5">Na konci</th><th colspan="6">Během</th></tr>';
+        $Output .= '<tr><th>Rok</th><th>Od</th><th>Do</th><th>Příjmy</th><th>Výdaje</th><th>Pohledávky</th><th>Závazky</th><th>Drobný majetek</th><th>Příjmy</th><th>Výdaje</th><th>Pohledávky</th><th>Závazky</th><th>Drobný majetek</th><th>Základ daně</th></tr>';
+
+        $StartEvidence = mktime(0, 0, 0, 12, 1, 2007);
+        $StartYear = date('Y', $StartEvidence);
+        $EndYear = date('Y', time());
+        for($Year = $StartYear; $Year <= $EndYear; $Year++)
+        {
+          $EndTime = mktime(0, 0, 0, 12, 31, $Year);
+          $Year = date('Y', $EndTime);
+          $StartTime = mktime(0, 0, 0, 1, 1, $Year);
+          if($StartTime < $StartEvidence) $StartTime = $StartEvidence;
+
+          $Balance = array();
+
+          $DbResult = $this->Database->query('SELECT SUM(Value) FROM FinanceCashFlow WHERE Time < "'.TimeToMysqlDateTime($StartTime).'" AND Value > 0 AND Taxable = 1');
+          $Row = $DbResult->fetch_array();
+          $Balance['Income']['Start'] = $Row[0] + 0;
+          $DbResult = $this->Database->query('SELECT SUM(Value) FROM FinanceCashFlow WHERE Time <= "'.TimeToMysqlDateTime($EndTime).'" AND Value > 0 AND Taxable = 1');
+          //echo('SELECT SUM(Value) FROM FinanceCashFlow WHERE Time <= "'.TimeToMysqlDateTime($EndTime).'" AND Value > 0 AND Taxable = 1'.'<br />');
+          $Row = $DbResult->fetch_array();
+          $Balance['Income']['End'] = $Row[0] + 0;
+
+          $DbResult = $this->Database->query('SELECT -SUM(Value) FROM FinanceCashFlow WHERE Time < "'.TimeToMysqlDateTime($StartTime).'" AND Value < 0 AND Taxable = 1');
+          $Row = $DbResult->fetch_array();
+          $Balance['Spend']['Start'] = $Row[0] + 0;
+          $DbResult = $this->Database->query('SELECT -SUM(Value) FROM FinanceCashFlow WHERE Time <= "'.TimeToMysqlDateTime($EndTime).'" AND Value < 0 AND Taxable = 1');
+          //echo('SELECT -SUM(Value) FROM FinanceCashFlow WHERE Time <= "'.TimeToMysqlDateTime($EndTime).'" AND Value < 0 AND Taxable = 1'.'<br />');
+          $Row = $DbResult->fetch_array();
+          $Balance['Spend']['End'] = $Row[0] + 0;
+
+          $DbResult = $this->Database->query('SELECT SUM(Value) FROM FinanceClaimsLiabilities WHERE TimeCreation < "'.TimeToMysqlDateTime($StartTime).'" AND TimePayment = "0000-00-00 00:00:00" AND Value > 0');
+          $Row = $DbResult->fetch_array();
+          $Balance['Claims']['Start'] = $Row[0] + 0;
+          $DbResult = $this->Database->query('SELECT SUM(Value) FROM FinanceClaimsLiabilities WHERE TimeCreation <= "'.TimeToMysqlDateTime($EndTime).'" AND TimePayment = "0000-00-00 00:00:00" AND Value > 0');
+          $Row = $DbResult->fetch_array();
+          $Balance['Claims']['End'] = $Row[0] + 0;
+
+          $DbResult = $this->Database->query('SELECT -SUM(Value) FROM FinanceClaimsLiabilities WHERE TimeCreation < "'.TimeToMysqlDateTime($StartTime).'" AND TimePayment = "0000-00-00 00:00:00" AND Value < 0');
+          $Row = $DbResult->fetch_array();
+          $Balance['Liabilities']['Start'] = $Row[0] + 0;
+          $DbResult = $this->Database->query('SELECT -SUM(Value) FROM FinanceClaimsLiabilities WHERE TimeCreation <= "'.TimeToMysqlDateTime($EndTime).'" AND TimePayment = "0000-00-00 00:00:00" AND Value < 0');
+          $Row = $DbResult->fetch_array();
+          $Balance['Liabilities']['End'] = $Row[0] + 0;
+
+          // SmallAssets
+          $DbResult = $this->Database->query('SELECT SUM(price) FROM network_devices WHERE (TimeEnlistment < "'.TimeToMysqlDateTime($StartTime).'") AND (TimeEnlistment != 0) AND ((TimeElimination > "'.TimeToMysqlDateTime($StartTime).'") OR (TimeElimination = 0))');
+          //$Output .= $Database->error;
+          $Row = $DbResult->fetch_array();
+          $Balance['SmallAssets']['Start'] = $Row[0] + 0;
+          $DbResult = $this->Database->query('SELECT SUM(price) FROM network_devices WHERE (TimeEnlistment < "'.TimeToMysqlDateTime($EndTime).'") AND (TimeEnlistment != 0) AND ((TimeElimination > "'.TimeToMysqlDateTime($EndTime).'") OR (TimeElimination = 0))');
+          $Row = $DbResult->fetch_array();
+          $Balance['SmallAssets']['End'] = $Row[0] + 0;
+
+          $Output .= '<tr><td>'.$Year.'</td><td>'.date(HumanDate(TimeToMysqlDateTime($StartTime))).'</td><td>'.date(HumanDate(TimeToMysqlDateTime($EndTime))).'</td>';
+          $Output .= '<td>'.$Balance['Income']['End'].'</td>';
+          $Output .= '<td>'.$Balance['Spend']['End'].'</td>';
+          $Output .= '<td>'.$Balance['Claims']['End'].'</td>';
+          $Output .= '<td>'.$Balance['Liabilities']['End'].'</td>';
+          $Output .= '<td>'.$Balance['SmallAssets']['End'].'</td>';
+
+          $Output .= '<td>'.($Balance['Income']['End'] - $Balance['Income']['Start']).'</td>';
+          $Output .= '<td>'.($Balance['Spend']['End'] - $Balance['Spend']['Start']).'</td>';
+          $Output .= '<td>'.($Balance['Claims']['End'] - $Balance['Claims']['Start']).'</td>';
+          $Output .= '<td>'.($Balance['Liabilities']['End'] - $Balance['Liabilities']['Start']).'</td>';
+          $Output .= '<td>'.($Balance['SmallAssets']['End'] - $Balance['SmallAssets']['Start']).'</td>';
+          $Output .= '<td>'.(($Balance['Income']['End'] - $Balance['Income']['Start']) - ($Balance['Spend']['End'] - $Balance['Spend']['Start'])).'</td></tr>';
+        }
+        $Output .= '</table>';
+
+        //    echo('<tr><td colspan="2">Výkaz o majetku a závazcích</td><td>Ing. Jiří Hajda</td></tr>');
+   /*
     echo('<tr><td>Dlouhodobý hmotný majetek</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
     echo('<tr><td>Dlouhodobý nehmotný majetek</td><td>&nbsp;</td><td>&nbsp;</td></tr>');
@@ -153 +152 @@
     echo('</table>');
 */
-    break;
-  case 'CashFlow':
-    $Table = array('Ne', 'Ano');
-    echo('<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">');
-    echo('<tr><th>Čas</th><th>Subjekt</th><th>Text</th><th>Hodnota [Kč]</th><th>Daňový</th><th>Hotovost</th></tr>');
-    $DbResult = $Database->query('SELECT *, CONCAT(users.second_name, " ", users.first_name) as Name FROM FinanceCashFlow JOIN users ON users.id = FinanceCashFlow.Subject ORDER BY Time');
-    while($Row = $DbResult->fetch_array())
-    {
-      echo('<tr><td>'.$Row['Time'].'</td><td>'.$Row['Name'].'</td><td>'.$Row['Text'].'</td><td>'.$Row['Value'].'</td><td>'.$Table[$Row['Taxable']].'</td><td>'.$Table[$Row['Cash']].'</td></tr>');
+        break;
+      case 'CashFlow':
+        $Table = array('Ne', 'Ano');
+        $Output .= '<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">';
+        $Output .= '<tr><th>Čas</th><th>Subjekt</th><th>Text</th><th>Hodnota [Kč]</th><th>Daňový</th><th>Hotovost</th></tr>';
+        $DbResult = $this->Database->query('SELECT *, CONCAT(users.second_name, " ", users.first_name) as Name FROM FinanceCashFlow JOIN users ON users.id = FinanceCashFlow.Subject ORDER BY Time');
+        while($Row = $DbResult->fetch_array())
+        {
+          $Output .= '<tr><td>'.$Row['Time'].'</td><td>'.$Row['Name'].'</td><td>'.$Row['Text'].'</td><td>'.$Row['Value'].'</td><td>'.$Table[$Row['Taxable']].'</td><td>'.$Table[$Row['Cash']].'</td></tr>';
+        }
+        $Output .= '</table>';
+        break;
+      case 'ClaimsLiabilities':
+        $Output .= '<table width="100%"><tr><td valign="top">';
+        $Output .= '<strong>Pohledávky</strong>';
+        $Output .= '<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">';
+        $Output .= '<tr><th>Subjekt</th><th>Text</th><th>Hodnota [Kč]</th><th>Čas vystavení</th><th>Čas splatnosti</th><th>Čas uhrazení</th></tr>';
+        $DbResult = $this->Database->query('SELECT *, CONCAT(users.second_name, " ", users.first_name) as Name FROM FinanceClaimsLiabilities JOIN users ON users.id = FinanceClaimsLiabilities.Subject WHERE Value > 0 ORDER BY TimeCreation');
+        while($Row = $DbResult->fetch_array())
+        {
+          if($Row['TimePayment'] == '0000-00-00 00:00:00') $Row['TimePayment'] = '&nbsp;';
+          $Output .= '<tr><td>'.$Row['Name'].'</td><td>'.$Row['Text'].'</td><td>'.$Row['Value'].'</td><td>'.$Row['TimeCreation'].'</td><td>'.$Row['TimeDue'].'</td><td>'.$Row['TimePayment'].'</td></tr>';
+        }
+        $Output .= '</table></td><td valign="top">';
+
+        $Output .= '<strong>Závazky</strong>';
+        $Output .= '<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">';
+        $Output .= '<tr><th>Subjekt</th><th>Text</th><th>Hodnota [Kč]</th><th>Čas vystavení</th><th>Čas splatnosti</th><th>Čas uhrazení</th></tr>';
+        $DbResult = $this->Database->query('SELECT *, CONCAT(users.second_name, " ", users.first_name) as Name FROM FinanceClaimsLiabilities JOIN users ON users.id = FinanceClaimsLiabilities.Subject WHERE Value < 0 ORDER BY TimeCreation');
+        while($Row = $DbResult->fetch_array())
+        {
+          if($Row['TimePayment'] == '0000-00-00 00:00:00') $Row['TimePayment'] = '&nbsp;';
+          $Output .= '<tr><td>'.$Row['Name'].'</td><td>'.$Row['Text'].'</td><td>'.$Row['Value'].'</td><td>'.$Row['TimeCreation'].'</td><td>'.$Row['TimeDue'].'</td><td>'.$Row['TimePayment'].'</td></tr>';
+        }
+        $Output .= '</table></td></tr></table>';
+        break;
+      case 'Advantages':
+        $Output .= '<table width="100%"><tr><td valign="top">';
+        $Output .= 'Přijaté zálohy';
+        $Output .= '<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">';
+        $Output .= '<tr><th>Subjekt</th><th>Hodnota [Kč]</th><th>Čas vystavení</th><th>Čas uzavření</th></tr>';
+        $DbResult = $this->Database->query('SELECT *, CONCAT(users.second_name, " ", users.first_name) as Name FROM FinanceAdvances JOIN users ON users.id = FinanceAdvances.Subject WHERE Direction = "In" ORDER BY TimeCreation');
+        while($Row = $DbResult->fetch_array())
+        {
+          if($Row['TimePass'] == '0000-00-00 00:00:00') $Row['TimePass'] = '&nbsp;';
+          $Output .= '<tr><td>'.$Row['Name'].'</td><td>'.$Row['Value'].'</td><td>'.$Row['TimeCreation'].'</td><td>'.$Row['TimePass'].'</td></tr>';
+        }
+        $Output .= '</table></td><td valign="top">';
+
+        $Output .= 'Vydané zálohy';
+        $Output .= '<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">';
+        $Output .= '<tr><th>Subjekt</th><th>Hodnota [Kč]</th><th>Čas vystavení</th><th>Čas uzavření</th></tr>';
+        $DbResult = $this->Database->query('SELECT *, CONCAT(users.second_name, " ", users.first_name) as Name FROM FinanceAdvances JOIN users ON users.id = FinanceAdvances.Subject WHERE Direction = "Out" ORDER BY TimeCreation');
+        while($Row = $DbResult->fetch_array())
+        {
+          if($Row['TimePass'] == '0000-00-00 00:00:00') $Row['TimePass'] = '&nbsp;';
+          $Output .= '<tr><td>'.$Row['Name'].'</td><td>'.$Row['Value'].'</td><td>'.$Row['TimeCreation'].'</td><td>'.$Row['TimePass'].'</td></tr>';
+        }
+        $Output .= '</table></td></tr></table>';
+        break;
+      case 'SubjectList':
+        $Output .= '<strong>Seznam subjektů</strong>';
+        $Output .= '<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">';
+        $Output .= '<tr><th>Jméno</th><th>Závazky [Kč]</th><th>Pohledávky [Kč]</th><th>Příjmy [Kč]</th><th>Výdaje [Kč]</th><th>Zálohy [Kč]</th><th>Stav účtu</th><th>Starý systém</th></tr>';
+        $DbResult = $this->Database->query('SELECT id, CONCAT(users.second_name, " ", users.first_name) as Fullname, cash, (SELECT SUM(FinanceClaimsLiabilities.Value) FROM FinanceClaimsLiabilities WHERE FinanceClaimsLiabilities.Subject = users.id AND FinanceClaimsLiabilities.Value > 0) as Claims, (SELECT SUM(FinanceClaimsLiabilities.Value) FROM FinanceClaimsLiabilities WHERE FinanceClaimsLiabilities.Subject = users.id AND FinanceClaimsLiabilities.Value > 0 AND TimePayment IS NULL) as OpenedClaims, (SELECT SUM(FinanceClaimsLiabilities.Value) FROM FinanceClaimsLiabilities WHERE FinanceClaimsLiabilities.Subject = users.id AND FinanceClaimsLiabilities.Value < 0) as Liabilities, (SELECT SUM(FinanceClaimsLiabilities.Value) FROM FinanceClaimsLiabilities WHERE FinanceClaimsLiabilities.Subject = users.id AND FinanceClaimsLiabilities.Value < 0 AND TimePayment IS NULL) as OpenedLiabilities, (SELECT SUM(FinanceCashFlow.Value) FROM FinanceCashFlow WHERE FinanceCashFlow.Subject = users.id AND FinanceCashFlow.Value > 0) as Gains, (SELECT SUM(FinanceCashFlow.Value) FROM FinanceCashFlow WHERE FinanceCashFlow.Subject = users.id AND FinanceCashFlow.Value < 0) as Spends, (SELECT SUM(FinanceAdvances.Value) FROM FinanceAdvances WHERE FinanceAdvances.Subject = users.id AND FinanceAdvances.Direction="In") as AdvancesIn, (SELECT SUM(FinanceAdvances.Value) FROM FinanceAdvances WHERE FinanceAdvances.Subject = users.id AND FinanceAdvances.Direction="Out") as AdvancesOut FROM users ORDER BY fullname');
+        while($Row = $DbResult->fetch_array())
+        {
+          $Advances = ($Row['AdvancesIn'] - $Row['AdvancesOut']);
+          $Output .= '<tr><td><a href="?table=SubjectAccount&Id='.$Row['id'].'">'.$Row['Fullname'].'</a></td><td>'.$Row['Liabilities'].'/'.$Row['OpenedLiabilities'].'</td><td>'.$Row['Claims'].'/'.$Row['OpenedClaims'].'</td><td>'.$Row['Gains'].'</td><td>'.$Row['Spends'].'</td><td>'.$Advances.'</td><td>'.($Advances - $Row['OpenedClaims'] + Abs($Row['OpenedLiabilities'])).'</td><td>'.$Row['cash'].'</td></tr>';
+        }
+        $Output .= '</table>';
+        break;
+      case 'SmallAssets':
+        $Output .= '<strong>Drobný majetek</strong>';
+        $Output .= '<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">';
+        $Output .= '<tr><th>Název</th><th>Hodnota [Kč]</th><th>Datum zakoupení</th><th>Datum vyřezení</th></tr>';
+        $DbResult = $this->Database->query('SELECT * FROM network_devices WHERE used != 0');
+        while($Row = $DbResult->fetch_array())
+        {
+          $Output .= '<tr><td>'.$Row['name'].'</td><td>'.$Row['price'].'</td><td>'.$Row['TimeEnlistment'].'</td><td>'.$Row['TimeElimination'].'</td></tr>';
+        }
+        $Output .= '</table>';
+        break;
+      case 'SubjectAccount':
+        $Output .= '<strong>Výpis příjmů/výdajů</strong>';
+        $Output .= '<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">';
+        $Output .= '<tr><th>Datum</th><th>Název</th><th>Hodnota [Kč]</th></tr>';
+        $DbResult = $this->Database->select('FinanceCashFlow', '*', 'Subject='.$_GET['Id']);
+        while($Row = $DbResult->fetch_array())
+        {
+          $Output .= '<tr><td>'.$Row['Time'].'</td><td>'.$Row['Text'].'</td><td>'.$Row['Value'].'</td><td>'.$Row['Bill'].'</td></tr>';
+        }
+        $Output .= '</table><br />';
+
+        $Output .= '<strong>Výpis závazků/pohledávek</strong>';
+        $Output .= '<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">';
+        $Output .= '<tr><th>Datum vytvoření</th><th>Datum zaplacení</th><th>Název</th><th>Hodnota [Kč]</th></tr>';
+        $DbResult = $this->Database->select('FinanceClaimsLiabilities', '*', 'Subject='.$_GET['Id']);
+        while($Row = $DbResult->fetch_array())
+        {
+          $Output .= '<tr><td>'.$Row['TimeCreation'].'</td><td>'.$Row['TimePayment'].'</td><td>'.$Row['Text'].'</td><td>'.(-$Row['Value']).'</td><td>'.$Row['Bill'].'</td></tr>';
+        }
+        $Output .= '</table><br />';
+
+        $Output .= '<strong>Výpis záloh</strong>';
+        $Output .= '<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">';
+        $Output .= '<tr><th>Datum vytvoření</th><th>Datum zaplacení</th><th>Název</th><th>Hodnota [Kč]</th></tr>';
+        $DbResult = $this->Database->select('FinanceAdvances', '*', 'Subject='.$_GET['Id']);
+        while($Row = $DbResult->fetch_array())
+        {
+          $Output .= '<tr><td>'.$Row['TimeCreation'].'</td><td>'.$Row['TimePass'].'</td><td>'.$Row['Direction'].'</td><td>'.($Row['Value']).'</td><td>'.$Row['CashFlowId'].'</td></tr>';
+        }
+        $Output .= '</table>';
+
+        $DbResult = $this->Database->query('SELECT id, CONCAT(users.second_name, " ", users.first_name) as Fullname, cash, (SELECT SUM(FinanceClaimsLiabilities.Value) FROM FinanceClaimsLiabilities WHERE FinanceClaimsLiabilities.Subject = users.id AND FinanceClaimsLiabilities.Value > 0) as Claims, (SELECT SUM(FinanceClaimsLiabilities.Value) FROM FinanceClaimsLiabilities WHERE FinanceClaimsLiabilities.Subject = users.id AND FinanceClaimsLiabilities.Value > 0 AND TimePayment IS NULL) as OpenedClaims, (SELECT SUM(FinanceClaimsLiabilities.Value) FROM FinanceClaimsLiabilities WHERE FinanceClaimsLiabilities.Subject = users.id AND FinanceClaimsLiabilities.Value < 0) as Liabilities, (SELECT SUM(FinanceClaimsLiabilities.Value) FROM FinanceClaimsLiabilities WHERE FinanceClaimsLiabilities.Subject = users.id AND FinanceClaimsLiabilities.Value < 0 AND TimePayment IS NULL) as OpenedLiabilities, (SELECT SUM(FinanceCashFlow.Value) FROM FinanceCashFlow WHERE FinanceCashFlow.Subject = users.id AND FinanceCashFlow.Value > 0) as Gains, (SELECT SUM(FinanceCashFlow.Value) FROM FinanceCashFlow WHERE FinanceCashFlow.Subject = users.id AND FinanceCashFlow.Value < 0) as Spends, (SELECT SUM(FinanceAdvances.Value) FROM FinanceAdvances WHERE FinanceAdvances.Subject = users.id AND FinanceAdvances.Direction="In") as AdvancesIn, (SELECT SUM(FinanceAdvances.Value) FROM FinanceAdvances WHERE FinanceAdvances.Subject = users.id AND FinanceAdvances.Direction="Out") as AdvancesOut FROM users WHERE id='.$_GET['Id']);
+        $Row = $DbResult->fetch_array();
+        $Output .= 'Stav placení: '.($Row['AdvancesIn'] - $Row['AdvancesOut'] - $Row['OpenedClaims'] + Abs($Row['OpenedLiabilities']));
+        break;
+      default:
+        $Output .= '<a href="?table=AnnualBalance">Účetní závěrka</a><br />';
+        $Output .= '<a href="?table=CashFlow">Příjmy a výdaje</a><br />';
+        $Output .= '<a href="?table=ClaimsLiabilities">Závazky a pohledávky</a><br />';
+        $Output .= '<a href="?table=Advantages">Zálohy</a><br />';
+        $Output .= '<a href="?table=SmallAssets">Drobný majetek</a><br />';
+        $Output .= '<a href="?table=SubjectList">Seznam subjektů</a><br />';
     }
-    echo('</table>');
-    break;
-  case 'ClaimsLiabilities':
-    echo('<table width="100%"><tr><td valign="top">');
-    echo('<strong>Pohledávky</strong>');
-    echo('<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">');
-    echo('<tr><th>Subjekt</th><th>Text</th><th>Hodnota [Kč]</th><th>Čas vystavení</th><th>Čas splatnosti</th><th>Čas uhrazení</th></tr>');
-    $DbResult = $Database->query('SELECT *, CONCAT(users.second_name, " ", users.first_name) as Name FROM FinanceClaimsLiabilities JOIN users ON users.id = FinanceClaimsLiabilities.Subject WHERE Value > 0 ORDER BY TimeCreation');
-    while($Row = $DbResult->fetch_array())
-    {
-      if($Row['TimePayment'] == '0000-00-00 00:00:00') $Row['TimePayment'] = '&nbsp;';
-      echo('<tr><td>'.$Row['Name'].'</td><td>'.$Row['Text'].'</td><td>'.$Row['Value'].'</td><td>'.$Row['TimeCreation'].'</td><td>'.$Row['TimeDue'].'</td><td>'.$Row['TimePayment'].'</td></tr>');
-    }
-    echo('</table></td><td valign="top">');
-
-    echo('<strong>Závazky</strong>');
-    echo('<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">');
-    echo('<tr><th>Subjekt</th><th>Text</th><th>Hodnota [Kč]</th><th>Čas vystavení</th><th>Čas splatnosti</th><th>Čas uhrazení</th></tr>');
-    $DbResult = $Database->query('SELECT *, CONCAT(users.second_name, " ", users.first_name) as Name FROM FinanceClaimsLiabilities JOIN users ON users.id = FinanceClaimsLiabilities.Subject WHERE Value < 0 ORDER BY TimeCreation');
-    while($Row = $DbResult->fetch_array())
-    {
-      if($Row['TimePayment'] == '0000-00-00 00:00:00') $Row['TimePayment'] = '&nbsp;';
-      echo('<tr><td>'.$Row['Name'].'</td><td>'.$Row['Text'].'</td><td>'.$Row['Value'].'</td><td>'.$Row['TimeCreation'].'</td><td>'.$Row['TimeDue'].'</td><td>'.$Row['TimePayment'].'</td></tr>');
-    }
-    echo('</table></td></tr></table>');
-    break;
-  case 'Advantages':
-    echo('<table width="100%"><tr><td valign="top">');
-    echo('Přijaté zálohy');
-    echo('<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">');
-    echo('<tr><th>Subjekt</th><th>Hodnota [Kč]</th><th>Čas vystavení</th><th>Čas uzavření</th></tr>');
-    $DbResult = $Database->query('SELECT *, CONCAT(users.second_name, " ", users.first_name) as Name FROM FinanceAdvances JOIN users ON users.id = FinanceAdvances.Subject WHERE Direction = "In" ORDER BY TimeCreation');
-    while($Row = $DbResult->fetch_array())
-    {
-      if($Row['TimePass'] == '0000-00-00 00:00:00') $Row['TimePass'] = '&nbsp;';
-      echo('<tr><td>'.$Row['Name'].'</td><td>'.$Row['Value'].'</td><td>'.$Row['TimeCreation'].'</td><td>'.$Row['TimePass'].'</td></tr>');
-    }
-    echo('</table></td><td valign="top">');
-
-    echo('Vydané zálohy');
-    echo('<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">');
-    echo('<tr><th>Subjekt</th><th>Hodnota [Kč]</th><th>Čas vystavení</th><th>Čas uzavření</th></tr>');
-    $DbResult = $Database->query('SELECT *, CONCAT(users.second_name, " ", users.first_name) as Name FROM FinanceAdvances JOIN users ON users.id = FinanceAdvances.Subject WHERE Direction = "Out" ORDER BY TimeCreation');
-    while($Row = $DbResult->fetch_array())
-    {
-      if($Row['TimePass'] == '0000-00-00 00:00:00') $Row['TimePass'] = '&nbsp;';
-      echo('<tr><td>'.$Row['Name'].'</td><td>'.$Row['Value'].'</td><td>'.$Row['TimeCreation'].'</td><td>'.$Row['TimePass'].'</td></tr>');
-    }
-    echo('</table></td></tr></table>');
-    break;
-  case 'SubjectList':
-    echo('<strong>Seznam subjektů</strong>');
-    echo('<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">');
-    echo('<tr><th>Jméno</th><th>Závazky [Kč]</th><th>Pohledávky [Kč]</th><th>Příjmy [Kč]</th><th>Výdaje [Kč]</th><th>Zálohy [Kč]</th><th>Stav účtu</th><th>Starý systém</th></tr>');
-    $DbResult = $Database->query('SELECT id, CONCAT(users.second_name, " ", users.first_name) as Fullname, cash, (SELECT SUM(FinanceClaimsLiabilities.Value) FROM FinanceClaimsLiabilities WHERE FinanceClaimsLiabilities.Subject = users.id AND FinanceClaimsLiabilities.Value > 0) as Claims, (SELECT SUM(FinanceClaimsLiabilities.Value) FROM FinanceClaimsLiabilities WHERE FinanceClaimsLiabilities.Subject = users.id AND FinanceClaimsLiabilities.Value > 0 AND TimePayment IS NULL) as OpenedClaims, (SELECT SUM(FinanceClaimsLiabilities.Value) FROM FinanceClaimsLiabilities WHERE FinanceClaimsLiabilities.Subject = users.id AND FinanceClaimsLiabilities.Value < 0) as Liabilities, (SELECT SUM(FinanceClaimsLiabilities.Value) FROM FinanceClaimsLiabilities WHERE FinanceClaimsLiabilities.Subject = users.id AND FinanceClaimsLiabilities.Value < 0 AND TimePayment IS NULL) as OpenedLiabilities, (SELECT SUM(FinanceCashFlow.Value) FROM FinanceCashFlow WHERE FinanceCashFlow.Subject = users.id AND FinanceCashFlow.Value > 0) as Gains, (SELECT SUM(FinanceCashFlow.Value) FROM FinanceCashFlow WHERE FinanceCashFlow.Subject = users.id AND FinanceCashFlow.Value < 0) as Spends, (SELECT SUM(FinanceAdvances.Value) FROM FinanceAdvances WHERE FinanceAdvances.Subject = users.id AND FinanceAdvances.Direction="In") as AdvancesIn, (SELECT SUM(FinanceAdvances.Value) FROM FinanceAdvances WHERE FinanceAdvances.Subject = users.id AND FinanceAdvances.Direction="Out") as AdvancesOut FROM users ORDER BY fullname');
-    while($Row = $DbResult->fetch_array())
-    {
-      $Advances = ($Row['AdvancesIn'] - $Row['AdvancesOut']);
-      echo('<tr><td><a href="?table=SubjectAccount&Id='.$Row['id'].'">'.$Row['Fullname'].'</a></td><td>'.$Row['Liabilities'].'/'.$Row['OpenedLiabilities'].'</td><td>'.$Row['Claims'].'/'.$Row['OpenedClaims'].'</td><td>'.$Row['Gains'].'</td><td>'.$Row['Spends'].'</td><td>'.$Advances.'</td><td>'.($Advances - $Row['OpenedClaims'] + Abs($Row['OpenedLiabilities'])).'</td><td>'.$Row['cash'].'</td></tr>');
-    }
-    echo('</table>');
-    break;
-  case 'SmallAssets':
-    echo('<strong>Drobný majetek</strong>');
-    echo('<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">');
-    echo('<tr><th>Název</th><th>Hodnota [Kč]</th><th>Datum zakoupení</th><th>Datum vyřezení</th></tr>');
-    $DbResult = $Database->query('SELECT * FROM network_devices WHERE used != 0');
-    while($Row = $DbResult->fetch_array())
-    {
-      echo('<tr><td>'.$Row['name'].'</td><td>'.$Row['price'].'</td><td>'.$Row['TimeEnlistment'].'</td><td>'.$Row['TimeElimination'].'</td></tr>');
-    }
-    echo('</table>');
-    break;
-  case 'SubjectAccount':
-    echo('<strong>Výpis příjmů/výdajů</strong>');
-    echo('<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">');
-    echo('<tr><th>Datum</th><th>Název</th><th>Hodnota [Kč]</th></tr>');
-    $DbResult = $Database->select('FinanceCashFlow', '*', 'Subject='.$_GET['Id']);
-    while($Row = $DbResult->fetch_array())
-    {
-      echo('<tr><td>'.$Row['Time'].'</td><td>'.$Row['Text'].'</td><td>'.$Row['Value'].'</td><td>'.$Row['Bill'].'</td></tr>');
-    }
-    echo('</table><br>');
-
-    echo('<strong>Výpis závazků/pohledávek</strong>');
-    echo('<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">');
-    echo('<tr><th>Datum vytvoření</th><th>Datum zaplacení</th><th>Název</th><th>Hodnota [Kč]</th></tr>');
-    $DbResult = $Database->select('FinanceClaimsLiabilities', '*', 'Subject='.$_GET['Id']);
-    while($Row = $DbResult->fetch_array())
-    {
-      echo('<tr><td>'.$Row['TimeCreation'].'</td><td>'.$Row['TimePayment'].'</td><td>'.$Row['Text'].'</td><td>'.(-$Row['Value']).'</td><td>'.$Row['Bill'].'</td></tr>');
-    }
-    echo('</table><br>');
-
-    echo('<strong>Výpis záloh</strong>');
-    echo('<table style="font-size: smaller;" border="1" cellspacing="0" cellpadding="3">');
-    echo('<tr><th>Datum vytvoření</th><th>Datum zaplacení</th><th>Název</th><th>Hodnota [Kč]</th></tr>');
-    $DbResult = $Database->select('FinanceAdvances', '*', 'Subject='.$_GET['Id']);
-    while($Row = $DbResult->fetch_array())
-    {
-      echo('<tr><td>'.$Row['TimeCreation'].'</td><td>'.$Row['TimePass'].'</td><td>'.$Row['Direction'].'</td><td>'.($Row['Value']).'</td><td>'.$Row['CashFlowId'].'</td></tr>');
-    }
-    echo('</table>');
-
-    $DbResult = $Database->query('SELECT id, CONCAT(users.second_name, " ", users.first_name) as Fullname, cash, (SELECT SUM(FinanceClaimsLiabilities.Value) FROM FinanceClaimsLiabilities WHERE FinanceClaimsLiabilities.Subject = users.id AND FinanceClaimsLiabilities.Value > 0) as Claims, (SELECT SUM(FinanceClaimsLiabilities.Value) FROM FinanceClaimsLiabilities WHERE FinanceClaimsLiabilities.Subject = users.id AND FinanceClaimsLiabilities.Value > 0 AND TimePayment IS NULL) as OpenedClaims, (SELECT SUM(FinanceClaimsLiabilities.Value) FROM FinanceClaimsLiabilities WHERE FinanceClaimsLiabilities.Subject = users.id AND FinanceClaimsLiabilities.Value < 0) as Liabilities, (SELECT SUM(FinanceClaimsLiabilities.Value) FROM FinanceClaimsLiabilities WHERE FinanceClaimsLiabilities.Subject = users.id AND FinanceClaimsLiabilities.Value < 0 AND TimePayment IS NULL) as OpenedLiabilities, (SELECT SUM(FinanceCashFlow.Value) FROM FinanceCashFlow WHERE FinanceCashFlow.Subject = users.id AND FinanceCashFlow.Value > 0) as Gains, (SELECT SUM(FinanceCashFlow.Value) FROM FinanceCashFlow WHERE FinanceCashFlow.Subject = users.id AND FinanceCashFlow.Value < 0) as Spends, (SELECT SUM(FinanceAdvances.Value) FROM FinanceAdvances WHERE FinanceAdvances.Subject = users.id AND FinanceAdvances.Direction="In") as AdvancesIn, (SELECT SUM(FinanceAdvances.Value) FROM FinanceAdvances WHERE FinanceAdvances.Subject = users.id AND FinanceAdvances.Direction="Out") as AdvancesOut FROM users WHERE id='.$_GET['Id']);
-    $Row = $DbResult->fetch_array();
-    echo('Stav placení: '.($Row['AdvancesIn'] - $Row['AdvancesOut'] - $Row['OpenedClaims'] + Abs($Row['OpenedLiabilities'])));
-    break;
-  default:
-    echo('<a href="?table=AnnualBalance">Účetní závěrka</a><br>');
-    echo('<a href="?table=CashFlow">Příjmy a výdaje</a><br>');
-    echo('<a href="?table=ClaimsLiabilities">Závazky a pohledávky</a><br>');
-    echo('<a href="?table=Advantages">Zálohy</a><br>');
-    echo('<a href="?table=SmallAssets">Drobný majetek</a><br>');
-    echo('<a href="?table=SubjectList">Seznam subjektů</a><br>');
+    return($Output);
+  }
+
+  function AddMoney($Subject, $Value, $Text, $Time)
+  {
+    $TimeDue = $Time + 15 * 24 * 3600; // 15 dnů
+
+  }
+
+  function AddInvoice($Subject, $Value, $Text, $Time)
+  {
+    $TimeDue = $Time + 15 * 24 * 3600; // 15 dnů
+
+  }
 }
 
-function AddMoney($Subject, $Value, $Text, $Time)
-{
-  $TimeDue = $Time + 15 * 24 * 3600; // 15 dnů
-  
-
-}
-
-function AddInvoice($Subject, $Value, $Text, $Time)
-{
-  $TimeDue = $Time + 15 * 24 * 3600; // 15 dnů
-  
-
-}
+$System->AddModule(new FinanceTaxFilingPage());
+$System->Modules['FinanceTaxFilingPage']->GetOutput();
 
 ?>

www/global.php

@@ -44 +44 @@
 $System->AddModule(new User());
 $System->Modules['User']->Check();
-/*
 include_once('aktuality/news.php');
 $System->AddModule(new News());
@@ -53 +52 @@
 include_once('finance/finance.php');
 $System->AddModule(new Finance());
-*/
 
 $MonthNames = array('', 'Leden', 'Únor', 'Březen', 'Duben', 'Květen', 'Červen', 'Červenec', 'Srpen', 'Září', 'Říjen', 'Listopad', 'Prosinec');

www/index.php

@@ -2 +2 @@
 
 include_once('global.php');
-include_once('style.php');
-ShowHeader('<strong>ZděchovNET</strong> - komunitní počítačová síť', 'Rozcestník');
-
-$Database->select_db('share');
-
-function CategoryItemCompare($Item1, $Item2) 
+
+class IndexPage extends Page
 {
-  if ($Item1['Index'] == $Item2['Index']) return(0);
-  return ($Item1['Index'] > $Item2['Index']) ? -1 : 1;
-}
-
-// Process cookies
-if(array_key_exists('Action', $_GET))
-{
-  if($_GET['Action'] == 'CustomizeNewsSave')
-  {
-    $Checkbox = array('' => 0, 'on' => 1);
-    // print_r($_POST);
-    $Setting = array();
-    for($I = 0; $I < $_POST['NewsCategoryCount']; $I++)
-    {
-      if(($_POST['NewsCategoryDaysAgo'.$I]*1) < 0) $_POST['NewsCategoryIndex'.$I] = 0;
-      if(($_POST['NewsCategoryCount'.$I]*1) < 0) $_POST['NewsCategoryCount'.$I] = 0;
-      if(!array_key_exists('NewsCategoryEnabled'.$I, $_POST)) $_POST['NewsCategoryEnabled'.$I] = '';
-      $Setting[] = array('CategoryId' => $_POST['NewsCategoryId'.$I], 'Enabled' => $Checkbox[$_POST['NewsCategoryEnabled'.$I]], 'ItemCount' => ($_POST['NewsCategoryCount'.$I]*1), 'DaysAgo' => ($_POST['NewsCategoryDaysAgo'.$I]*1), 'Index' => ($_POST['NewsCategoryIndex'.$I]*1));
-    }
-    // Sort indexes
-    usort($Setting, 'CategoryItemCompare');
-    $Setting = array_reverse($Setting);
-    // Normalize indexes
-    foreach($Setting as $Index => $Item)
-      $Setting[$Index]['Index'] = $Index + 1;
-    
-    // print_r($Setting);
-
-    // Store new cookie value
-    $_COOKIE['NewsSetting'] = serialize($Setting);
-    setcookie('NewsSetting', $_COOKIE['NewsSetting']);
-  } else
-  if($_GET['Action'] == 'LoginForm')
-  {
-    $Output = '
-   <form action="?Action=Login" method="post">
-   <table class="hidden">
-        <tr align="left"><td colspan="2">Jméno:</td></tr>
-        <tr align="left"><td colspan="2"><input type="text" name="Username" size="40" maxlength="16" /></td></tr>
-        <tr align="left"><td colspan="2">Heslo:</td></tr>
-        <tr align="left"><td colspan="2"><input type="password" name="Password" size="40" maxlength="16" /></td></tr>
-        <tr><td colspan="2">&nbsp;</td></tr>
-        <tr align="left">
-                <td><input type="checkbox" name="remember" value="1" checked="checked" /> Trvalé přihlášení</td>
+  var $Dependencies = array('News');
+  var $FullTitle = '<strong>ZděchovNET</strong> - komunitní počítačová síť';
+  var $ShortTitle = 'Rozcestník';
+  var $Links = array(
+    'main' => array('Důležité odkazy',
+      array('Finance', '/finance/', 'money.gif'),
+      array('Statistika', 'http://stat.zdechov.net/centrala/', 'chart.gif'),
+      array('Prohledat sdílení', '/share/', 'prohledavac_sdileni.gif', array('Share', 'Display')),
+      array('Seznam uživatelů', '/userlist.php', 'comp.gif'),
+      array('Seznam počítačů', '/hostlist.php', 'comp.gif'),
+      array('Historie chatu', '/chat/history.php', 'sunrisechat.gif', array('Chat', 'Display')),
+      array('Webový chat', 'http://embed.mibbit.com/?server=game.zdechov.net%3A6667&amp;channel=%23zdechov&amp;forcePrompt=true&amp;charset=utf-8', 'sunrisechat.gif'),
+      array('Diskusní fórum', '/forum/', 'discus.gif'),
+      array('WebMail', '/webmail/', 'openwebmail.gif'),
+      array('Jídelníček', '/jidelna/', 'apple.gif'),
+      array('Televize', 'http://tv.zdechov.net/', 'clear.gif'),
+      array('Herní server', 'http://game-server.zdechov.net/', 'cube.gif'),
+      array('Rozpis mší', 'http://farnost.zdechov.net/', 'cfix.gif'),
+      array('Telefonní seznam', '/telseznam.php', 'tel.gif'),
+      array('Mapa Zděchova', 'http://www.mapy.cz/#x=141560832@y=133134848@z=13@mm=FP@sa=s@st=s@ssq=zd%C4%9Bchov@sss=1@ssp=120738725_123701121_150360997_149800833', 'clear.gif'),
+      array('Otvírací doby', '/otevreno.php', 'otv_doby.gif'),
+      array('Topologie sítě', '/is/topologie.php', 'topologie.gif'),
+      array('Dostupnost sítě', '/network/dostupnost.php', 'satellite.gif'),
+      array('Technické informace', '/network.php', 'tech.gif'),
+      array('Fotbal Sokol Zděchov', 'http://fotbal.zdechov.net/', 'socer.gif'),
+      array('Webkamera', '/webcam/', 'clear.gif'),
+      array('Stránky naší sítě', 'http://www.zdechov.net/', 'clear.gif'),
+    ),
+    'other' => array('Další odkazy',
+      array('Kanály kabelovky', '/tkr.php', 'tv.gif'),
+      array('Historie sítě', '/history.php', 'clear.gif'),
+      array('Měřič spotřeby', '/merak.php', 'electric.gif'),
+      array('Plány do budoucna', '/ukoly.php', 'clear.gif'),
+    ),
+    'search' => array('Vyhledávání',
+      array('Google', 'http://www.google.cz/', 'www_google_com.gif'),
+      array('Morfeo', 'http://morfeo.centrum.cz/', 'morfeo.png'),
+      array('Centrum', 'http://www.centrum.cz/', 'www_centrum_cz.gif'),
+      array('Seznam', 'http://www.seznam.cz/', 'www_seznam_cz.gif'),
+      array('Atlas', 'http://www.atlas.cz/', 'www_atlas_cz.gif'),
+      array('Tiscali', 'http://www.tiscali.cz/', 'www_tiscali_cz.gif'),
+    ),
+    'usefull' => array('Užitečné',
+      array('Mapa ČR', 'http://www.mapy.cz/', 'clear.gif'),
+      array('Online TV', 'http://www.tvinfo.cz/live/televize/cz/', 'www_tvinfo_cz.gif'),
+      array('Jízdní řády', 'http://jizdnirady.idnes.cz/', 'www_idos_cz.gif'),
+      array('TV programy', 'http://tv.atlas.cz/', 'www_atlas_cz.gif'),
+      array('ICQ', 'javascript:openClient(\'flash\')', 'www_icq_com.gif'),
+      array('Slovníky', 'http://slovniky.centrum.cz/', 'www_centrum_cz.gif'),
+      array('Počasí', 'http://www.meteopress.cz/', 'pocasi.gif'),
+      array('T-Mobile SMS', 'http://www.tzones.cz/', 'www_tzones_cz.gif'),
+      array('Knihovna&nbsp;Vsetín', 'http://www.mvk.cz/', 'www_mvk_cz.png'),    
+    ),
+    'fun' => array('Zábava',
+          array('Youtube', 'http://www.youtube.com/', 'clear.gif'),
+      array('Last.fm', 'http://www.last.fm/', 'clear.gif'),    
+    ),
+    /*'computers' => array('Prodej počítačů',
+      array('SOFTCOM', 'http://www.softcom.cz/', 'www_computershop_cz.png'),
+      array('Alfacomp', 'http://www.alfacomp.cz/php/zbozi.php?akc=2', 'www_alfacomp_cz.gif'),
+      array('Petracomp', 'http://www.petracomp.cz/', 'www_petracomp_cz.png'),
+      array('TS Bohemia', 'http://interlink.tsbohemia.cz/', 'www_tsbohemia_cz.png'),
+    ),
+      */
+  );
+  
+  function ShowLinks($LinkGroup)
+  {
+    $Result = '';
+    //foreach($this->Links as $LinkGroup)
+    //{
+      $Title = array_shift($LinkGroup);
+      $Result .= '<div class="PanelTitle">'.$Title.':</div>';
+      foreach($LinkGroup as $Link)
+      {
+        if(substr($Link[1], 0, 4) != 'http') $Link[1] = $this->System->Config['Web']['RootFolder'].$Link[1];
+        if(!isset($Link[3]) or (isset($Link[3]) and $this->System->Modules['User']->CheckPermission($Link[3][0], $Link[3][1])))
+          $Result .= '<img alt="'.$Link[0].'" src="images/favicons/'.$Link[2].'" width="16" height="16" /> <a href="'.$Link[1].'">'.$Link[0].'</a><br />';
+      }
+    //}
+    return($Result);
+  }
+
+  function InfoBar()
+  {
+    $this->Database->select_db('is');
+
+    $Output2 = '';
+
+    $DbResult = $this->Database->select('hosts', 'COUNT(*)', 'show_online=1');
+    $DbRow = $DbResult->fetch_array();
+    $TotalComputers = $DbRow[0];
+
+    $DbResult = $this->Database->select('hosts', 'COUNT(*)', 'show_online=1 AND online=1');
+    $DbRow = $DbResult->fetch_array();
+    $OnlineComputers = $DbRow[0];
+
+    $Output = '<img alt="" src="images/favicons/comp.gif" width="16" height="16" /> '.$OnlineComputers.' / '.$TotalComputers.' &nbsp;  &nbsp; ';
+
+    $DbResult = $this->Database->select('users', 'COUNT(*)', 'role=2');
+    $DbRow = $DbResult->fetch_array();
+    $TotalUser = $DbRow[0];
+
+    $DbResult = $this->Database->select('hosts', 'COUNT(DISTINCT(user))', 'show_online=1 AND online=1');
+    $DbRow = $DbResult->fetch_array();
+    $OnlineUser = $DbRow[0];
+
+    $Output .= '<img alt="" src="images/favicons/house.gif" width="16" height="16" /> '.$OnlineUser.' / '.$TotalUser.' &nbsp;  &nbsp; ';
+
+    $NetworkUsage = 0;
+    $Output .= '<img alt="" src="images/favicons/usage.gif" width="16" height="16" /> '.$NetworkUsage.' % &nbsp;  &nbsp; ';
+
+    //$Output .= 'Server běží: '.$this->GetServerUptime().' &nbsp;  &nbsp; ';
+
+    if($this->System->Modules['User']->CheckPermission('Finance', 'DisplaySubjectState'))
+    {
+      $DbResult = $this->Database->select('users', 'cash', 'User='.$this->System->Modules['User']->User['Id']);
+      if($DbResult->num_rows > 0)
+      {
+        $DbRow = $DbResult->fetch_array();
+        $Finance = $DbRow[0];
+        $Output2 .= ' &nbsp;  &nbsp; <img alt="" src="images/favicons/money.gif" width="16" height="16" /> '.$Finance.' Kč';
+      }
+    }
+
+    $Output = '<div class="Navigation"><span class="MenuItem">'.$Output.'</span><div class="MenuItem2">&nbsp;'.$Output2.'</div></div>';
+    return($Output);
+  }
+
+  function UserPanel()
+  {
+    $Output = '<div class="PanelTitle">Nabídka uživatele:</div>'.
+    '<a href="'.$this->System->Config['Web']['RootFolder'].'/?Action=UserOptions">Nastavení účtu</a><br />'.
+    '<a href="'.$this->System->Config['Web']['RootFolder'].'/finance/user_state.php">Stav financí</a><br />'.
+   '<a href="'.$this->System->Config['Web']['RootFolder'].'/network/user_hosts.php">Registrované počítače</a><br />'.
+   '<a href="'.$this->System->Config['Web']['RootFolder'].'/aktuality/?action=add">Vložení aktuality</a><br />';
+   if($this->System->Modules['User']->CheckPermission('EatingPlace', 'Edit')) $Output .= '<a href="'.$this->System->Config['Web']['RootFolder'].'/jidelna/menuedit.php">Editace jídelníčků</a><br />';
+   if($this->System->Modules['User']->CheckPermission('Finance', 'Manage')) $Output .= '<a href="'.$this->System->Config['Web']['RootFolder'].'/finance/manage.php">Správa financí</a><br />';
+   if($this->System->Modules['User']->CheckPermission('Network', 'Administration')) $Output .= '<a href="'.$this->System->Config['Web']['RootFolder'].'/is/administration_page.php">Správa sítě</a><br />';
+    return($Output);
+  }
+
+  function WebcamPanel()
+  {
+    $Output = '<div class="PanelTitle">Webkamery:</div>';
+    $Output .= $this->System->Modules['Webcam']->ShowImage();
+    return($Output);
+  }
+
+  // Zobrazení seznamu online počítačů
+  function OnlineHostList()
+  {
+    global $Database;
+
+    $Output = '<div class="PanelTitle">Online počítače:</div><span style="font-size: smaller;">';
+    $DbResult = $Database->select('hosts', '*', 'online=1 AND show_online=1 ORDER BY name');
+    while($Row = $DbResult->fetch_array())
+    {
+      $Output .= $Row['name'].'<br />';
+    }
+    $Output .= '</span>';
+    return($Output);
+  }
+
+  /*
+  // Zobrazení seznamu neplaticich uzivatelu
+  function ShowBadPayerList()
+  {
+    $Output .= '<div class="PanelTitle">Dlužníci:</div><span style="font-size: smaller;">';
+    $DbResult = $Database->select('users', 'CONCAT(second_name, " ", first_name) as fullname', 'cash<0 AND role=2 ORDER BY cash');
+    while($Row = $DbResult->fetch_array())
+    {
+      $Output .= $Row['fullname'].'<br />';
+    }
+    echo('</span>');
+    return($Output);
+  }
+  */
+
+  // Zobrazení času běhu počítače
+  function GetServerUptime()
+  {
+    $Data = explode(' ',exec('uptime'));
+    $Data = array_slice($Data,3,-8);
+    $Uptime = '';
+    foreach($Data as $Item)
+    {
+      if(strpos($Item,':')) $Uptime .= substr($Item,0,-1).' hodin';
+      else $Uptime .= $Item.' ';
+    }
+    $Uptime = str_replace('2 days,','2 dny a',$Uptime);
+    $Uptime = str_replace('3 days,','3 dny a',$Uptime);
+    $Uptime = str_replace('4 days,','4 dny a',$Uptime);
+    $Uptime = str_replace('days,','dní a',$Uptime);
+    $Uptime = str_replace('day,','den a',$Uptime);
+    $Uptime = str_replace('min,','minut',$Uptime);
+    return($Uptime);
+  }
+
+  function Show()
+  {
+    global $Database, $Config, $User;
+
+    $Database->select_db('share');
+    //$Output = $this->InfoBar();
+
+    // Process cookies
+    if(array_key_exists('Action', $_GET))
+    {
+      if($_GET['Action'] == 'CustomizeNewsSave')
+      {
+        $Output .= $this->System->Modules['News']->CustomizeSave();
+      } else
+      if($_GET['Action'] == 'LoginForm')
+      {
+        $Output .= '<form action="?Action=Login" method="post"><center><fieldset style="width: 500px;"><legend>Přihlašovací údaje</legend>
+       <table class="hidden">
+            <tr align="left"><td colspan="2">Jméno:</td></tr>
+            <tr align="left"><td colspan="2"><input type="text" name="Username" size="40" maxlength="16" /></td></tr>
+            <tr align="left"><td colspan="2">Heslo:</td></tr>
+            <tr align="left"><td colspan="2"><input type="password" name="Password" size="40" maxlength="16" /></td></tr>
+            <tr><td colspan="2">&nbsp;</td></tr>
+            <tr align="left">
+                <td><input type="checkbox" name="remember" value="1" checked="checked" /> Trvalé přihlášení</td>
                 <td align="right"><input type="submit" value="Přihlásit" /></td>
         </tr>
@@ -59 +235 @@
                 <td><a href="?Action=PasswordRecovery">Obnova zapomenutého hesla</a></td>
         </tr>
-   </table>
-   </form>';
-    SystemMessage('Test', $Output);
-  } else
-  if($_GET['Action'] == 'Login')
-  {
-    SystemMessage('Přihlášení', $User->Login($_POST['Username'], $_POST['Password']));
-  } else 
-  if($_GET['Action'] == 'Logout')
-  {
-    SystemMessage('Odhlášení', $User->Logout());
-  } else
-  if($_GET['Action'] == 'UserOptions')
-  { 
-    
-    $Output = '<center><fieldset style="width: 500px;"><legend>Základní nastavení</legend>';
-    $Output .= '<form action="?Action=UserOptionsSave"><table>';
-    $Output .= '<tr><td>Přihlašovací jméno:</td><td><input type="text" name="Name"></td><td>';
-    $Output .= '<tr><td>Heslo:</td><td><input type="password" name="Password"></td><td>';
-    $Output .= '<tr><td>Křestní jméno:</td><td><input type="text" name="FirstName"></td><td>';
-    $Output .= '<tr><td>Příjmení:</td><td><input type="text" name="SecondName"></td><td>';
-    $Output .= '<tr><td>E-mail:</td><td><input type="text" name="Email"></td><td>';
-    $Output .= '<tr><td colspan="2" align="center"><input type="submit" value="Uložit" /></td></tr></table></form></fieldset></center>';
-    echo($Output);
+       </table>
+       </fieldset></center>
+       </form>';
+//        $Output .= $this->SystemMessage('Test', $Output);
+      } else
+      if($_GET['Action'] == 'Login')
+      {
+        $Output .= $this->SystemMessage('Přihlášení', $this->System->Modules['User']->Login($_POST['Username'], $_POST['Password']));
+      } else 
+      if($_GET['Action'] == 'Logout')
+      {
+        $Output .= $this->SystemMessage('Odhlášení', $this->System->Modules['User']->Logout());
+      } else
+      if($_GET['Action'] == 'UserOptions')
+      { 
+        $UserOptions = new Form('UserOptions');
+        $UserOptions->LoadValuesFromDatabase($this->System->Modules['User']->User['Id']);
+        $UserOptions->OnSubmit = '?Action=UserOptionsSave';
+        $Output .= $UserOptions->ShowEditForm();
+      } else
+      if($_GET['Action'] == 'UserOptionsSave')
+      {
+        $UserOptions = new Form('UserOptions', array());
+        $UserOptions->LoadValuesFromForm();
+        $UserOptions->SaveValuesToDatabase($this->System->Modules['User']->User['Id']);
+        $Output .= $this->SystemMessage('Nastavení', 'Nastavení uloženo.');
+        $this->System->Modules['Log']->NewRecord('User', 'Nastavení uživatele změněno', $UserOptions->Values['Name']);
+      }
+      if($_GET['Action'] == 'UserRegister')
+      {
+        $UserRegister = new Form('UserRegister');
+        $UserRegister->OnSubmit = '?Action=UserRegisterSave';
+        $Output .= $UserRegister->ShowEditForm();
+      } else
+      if($_GET['Action'] == 'UserRegisterConfirm')
+      {
+          $Output .= $this->SystemMessage('Potvrzení registrace', $this->System->Modules['User']->RegisterConfirm($_GET['User'], $_GET['H']));
+      } else
+      if($_GET['Action'] == 'PasswordRecovery')
+      {
+        $Form = new Form('PasswordRecovery');
+        $Form->OnSubmit = '?Action=PasswordRecovery2';
+        $Output .= $Form->ShowEditForm();
+      } else
+      if($_GET['Action'] == 'PasswordRecovery2')
+      {
+        $Form = new Form('PasswordRecovery');
+        $Form->LoadValuesFromForm();
+
+        $Output .= $this->SystemMessage('Obnova hesla', $this->System->Modules['User']->PasswordRecoveryRequest($Form->Values['Name'], $Form->Values['Email']));
+      } else
+      if($_GET['Action'] == 'PasswordRecoveryConfirm')
+      {
+        $Output .= $this->SystemMessage('Obnova hesla', $this->System->Modules['User']->PasswordRecoveryConfirm($_GET['User'], $_GET['H'], $_GET['P']));
+      } else
+      if($_GET['Action'] == 'UserRegisterSave')
+      {
+        $UserRegister = new Form('UserRegister', array());
+        $UserRegister->LoadValuesFromForm();
+        $Output .= $this->SystemMessage('Nastavení', $this->System->Modules['User']->Register($UserRegister->Values['Name'], $UserRegister->Values['Password'], $UserRegister->Values['Password2'], $UserRegister->Values['Email'], $UserRegister->Values['FirstName'], $UserRegister->Values['SecondName']));
+      }
+    }
+
+    $Database->select_db('is');
+
+    $Output .= '<table id="MainTable"><tr><td valign="top">';
+    $Output .= '<div class="Panel">'.$this->ShowLinks($this->Links['main']).'</div>';
+    $Output .= '<div class="Panel">'.$this->ShowLinks($this->Links['other']).'</div>';
+    $Output .= '</td><td valign="top">';
+    $Output .= '<div class="Panel">'.$this->ShowLinks($this->Links['search']).'</div>';
+    $Output .= '<div class="Panel">'.$this->ShowLinks($this->Links['usefull']).'</div>';
+    $Output .= '<div class="Panel">'.$this->ShowLinks($this->Links['fun']).'</div>';
+    $Output .= '</td><td id="NewsColumn" valign="top">';
+    $Output .= '<div class="Panel">'.$this->System->Modules['News']->Show().'</div>';
+    $Output .= '</td><td valign="top">';
+    if($this->System->Modules['User']->User['Id'] != $this->System->Modules['User']->AnonymousUserId) $Output .= '<div class="Panel">'.$this->UserPanel().'</div>';
+    $Output .= '<div class="Panel">'.$this->WebcamPanel().'</div>';
+    $Output .= '<div class="Panel">'.$this->OnlineHostList().'</div>';
+    $Output .= '<br />';
+    $Output .= '</td></tr></table>';
+    //if(IsInternetAddr()) echo('Internet'); else echo('LAN');
+    return($Output);
   }
 }
 
+$System->AddModule(new IndexPage());
+$System->Modules['IndexPage']->GetOutput();
+
 ?>
-
-<table width="100%"><tr><td valign="top">
-<?php
-$Database->select_db('is');
-?>
-
-<table width="100%">
-<tr><td valign="top">
-<strong>Důležité odkazy:</strong><br />
-<img alt="" src="images/favicons/money.gif" width="16" height="16" /> <a href="finance/">Finance</a><br />
-<img alt="" src="images/favicons/chart.gif" width="16" height="16" /> <a href="http://stat.zdechov.net/centrala/">Statistiky</a><br />
-<img alt="" src="images/favicons/prohledavac_sdileni.gif" width="15" height="15" /> <a href="share">Prohledat sdílení</a><br />
-<img alt="" src="images/favicons/comp.gif" width="16" height="16" /> <a href="userlist.php">Seznam uživatelů</a><br />
-<img alt="" src="images/favicons/comp.gif" width="16" height="16" /> <a href="hostlist.php">Seznam počítačů</a><br />
-<img alt="" src="images/favicons/clear.gif" width="16" height="16" /> <a href="http://embed.mibbit.com/?server=game.zdechov.net%3A6667&amp;channel=%23zdechov&amp;forcePrompt=true&amp;charset=utf-8">Webový chat</a><br />
-<img alt="" src="images/favicons/clear.gif" width="16" height="16" /> <a href="sunrisechat/history.php">Historie chatu</a><br />
-<img alt="" src="images/favicons/discus.gif" width="16" height="16" /> <a href="forum">Diskusní fórum</a><br />
-<img alt="" src="images/favicons/openwebmail.gif" width="16" height="16" /> <a href="https://centrala.zdechov.net/cgi-bin/openwebmail/openwebmail.pl">WebMail</a><br />
-<img alt="" src="images/favicons/apple.gif" width="16" height="16" /> <a href="jidelna">Jídelníček</a><br />
-<img alt="" src="images/favicons/clear.gif" width="16" height="16" /> <a href="http://tv.zdechov.net/">Televize</a><br />
-<img alt="" src="images/favicons/cube.gif" width="16" height="16" /> <a href="http://game.zdechov.net/">Herní server</a><br />
-<img alt="" src="images/favicons/cfix.gif" width="16" height="16" /> <a href="http://farnost.zdechov.net/">Rozpis mší</a><br />
-<img alt="" src="images/favicons/tel.gif" width="16" height="16" /> <a href="telseznam.php">Telefonní seznam</a><br />
-<img alt="" src="images/favicons/clear.gif" width="16" height="16" /> <a href="mapy/mapa.php">Mapa Zděchova</a><br />
-<img alt="" src="images/favicons/otv_doby.gif" width="16" height="16" /> <a href="otevreno.php">Otvírací doby</a><br />
-<img alt="" src="images/favicons/topologie.gif" width="16" height="16" /> <a href="is/topologie.php">Topologie sítě</a><br />
-<img alt="" src="images/favicons/satellite.gif" width="16" height="16" /> <a href="network/dostupnost.php">Dostupnost sítě</a><br />
-<img alt="" src="images/favicons/tech.gif" width="16" height="16" /> <a href="network.php">Technické informace</a><br />
-<img alt="" src="images/favicons/socer.gif" width="16" height="16" /> <a href="http://fotbal.zdechov.net/">Fotbal Sokol Zděchov</a><br />
-<img alt="" src="images/favicons/clear.gif" width="16" height="16" /> <a href="webcam/">Web kamera</a><br />
-<img alt="" src="images/favicons/clear.gif" width="16" height="16" /> <a href="http://www.zdechov.net">Stránky naší sítě</a><br />
-<br />
-<strong>Další odkazy:</strong><br />
-<img alt="" src="images/favicons/tv.gif" width="16" height="16" /> <a href="tkr.php">Kanály kabelovky</a><br />
-<img alt="" src="images/favicons/clear.gif" width="16" height="16" /> <a href="mapy/mapa_nabidka.php">Nabídka mapy</a><br />
-<img alt="" src="images/favicons/clear.gif" width="16" height="16" /> <a href="history.php">Historie sítě</a><br />
-<img alt="" src="images/favicons/electric.gif" width="16" height="16" /> <a href="merak.php">Měřič spotřeby</a><br />
-<img alt="" src="images/favicons/clear.gif" width="16" height="16" /> <a href="ukoly.php">Plány do budoucna</a><br />
-
-
-<?php
-//<a href="/cgi-bin/openwebmail/openwebmail.pl">Poątovní schránka</a><br />
-//<a href="/download/addfile.php">Stahování souborů</a><br />
-?>
-<br />
-</td><td valign="top">
-<strong>Vyhledávání:</strong><br />
-<img alt="" src="images/favicons/www_google_com.gif" width="16" height="16" /> <a href="http://www.google.cz/">Google</a><br />
-<img alt="" src="images/favicons/morfeo.png" width="16" height="16" /> <a href="http://morfeo.centrum.cz">Morfeo</a><br />
-<img alt="" src="images/favicons/www_centrum_cz.gif" width="16" height="16" /> <a href="http://www.centrum.cz">Centrum</a><br />
-<img alt="" src="images/favicons/www_seznam_cz.gif" width="16" height="16" /> <a href="http://www.seznam.cz">Seznam</a><br />
-<img alt="" src="images/favicons/www_atlas_cz.gif" width="16" height="16" /> <a href="http://www.atlas.cz">Atlas</a><br />
-<img alt="" src="images/favicons/www_tiscali_cz.gif" width="16" height="16" /> <a href="http://www.tiscali.cz">Tiscali</a><br />
-<br />
-<strong>Užitečné:</strong><br />
-<img alt="" src="images/favicons/clear.gif" width="16" height="16" /> <a href="http://www.mapy.cz/">Mapa ČR</a><br />
-<img alt="" src="images/favicons/www_tvinfo_cz.gif" width="16" height="16" /> <a href="http://www.tvinfo.cz/live/televize/cz">Online TV</a><br />
-<img alt="" src="images/favicons/www_idos_cz.gif" width="16" height="16" /> <a href="http://jizdnirady.idnes.cz/">Jízdní řády</a><br />
-<img alt="" src="images/favicons/www_atlas_cz.gif" width="16" height="16" /> <a href="http://tv.atlas.cz">TV programy</a><br />
-<img alt="" src="images/favicons/www_icq_com.gif" width="16" height="16" /> Web ICQ <a href="javascript:openClient('flash')">Flash</a>&nbsp;<a href="javascript:openClient('java')">Java</a><br />
-<img alt="" src="images/favicons/www_centrum_cz.gif" width="16" height="16" /> <a href="http://slovniky.centrum.cz">Slovníky</a><br />
-<img alt="" src="images/favicons/pocasi.gif" width="16" height="16" /> <a href="http://www.meteopress.cz/">Počasí</a><br />
-<img alt="" src="images/favicons/www_tzones_cz.gif" width="16" height="16" /> <a href="http://www.tzones.cz/">T-Mobile SMS</a><br />
-<img alt="" src="images/favicons/www_mvk_cz.png" width="16" height="16" /> <a href="http://www.mvk.cz/">Knihovna&nbsp;Vsetín</a><br />
-<br />
-<strong>Zábava:</strong><br />
-<img alt="" src="images/favicons/clear.gif" width="16" height="16" /> <a href="http://www.youtube.com/">YouTube</a><br />
-<img alt="" src="images/favicons/clear.gif" width="16" height="16" /> <a href="http://www.last.fm/">Last.fm</a><br />
-<br />
-<?php
-/*
-<strong>Osobní stránky:</strong><br />
-<img alt="" src="images/favicons/bomi.gif" width="16" height="16"> <a href="~mirek/">Miroslav Hajda</a><br />
-<img alt="" src="images/favicons/clear.gif" width="16" height="16"> <a href="~george/">Jiří Hajda</a><br />
-*/
-?>
-</td>
-<td valign="top">
-<?php
-// Zobrazení seznamu online počítačů
-echo('<strong>Online počítače:</strong><br /><span style="font-size: smaller;">');
-$DbResult = $Database->select('hosts', '*', 'online=1 AND show_online=1 ORDER BY name');
-while($Row = $DbResult->fetch_array())
-{
-  echo(strtoupper($Row['name']).'<br>');
-}
-echo('</span>');
-
-echo('<br />');
-
-// Zobrazení seznamu neplaticich uzivatelu
-/*
-echo('<strong>Dlužníci:</strong><br /><span style="font-size: smaller;">');
-$DbResult = $Database->select('users', 'CONCAT(second_name, " ", first_name) as fullname', 'cash<0 AND role=2 ORDER BY cash');
-while($Row = $DbResult->fetch_array())
-{
-  echo($Row['fullname'].'<br />');
-}
-echo('</span>');
-*/
-
-echo('</td></tr></table>');
-
-// Zobrazení času běhu počítače
-function GetServerUptime()
-{
-  $Data = explode(' ',exec('uptime'));
-  $Data = array_slice($Data,3,-8);
-  $Uptime = '';
-  foreach($Data as $Item)
-  {
-    if(strpos($Item,':')) $Uptime .= substr($Item,0,-1).' hodin';
-    else $Uptime .= $Item.' ';
-  }
-  $Uptime = str_replace('2 days,','2 dny a',$Uptime);
-  $Uptime = str_replace('3 days,','3 dny a',$Uptime);
-  $Uptime = str_replace('4 days,','4 dny a',$Uptime);
-  $Uptime = str_replace('days,','dní a',$Uptime);
-  $Uptime = str_replace('day,','den a',$Uptime);
-  $Uptime = str_replace('min,','minut',$Uptime);
-  return('Server běží '.$Uptime);
-}
-
-echo(GetServerUptime());
-
-echo('</td><td id="NewsColumn" valign="top">');
-
-/*
-$File = fopen('/tmp/temperature2','r');
-$Teplota = fgets($File);
-$Teplota = round($Teplota*10)/10;
-fclose($File);
-*/
-$Teplota = 0;
-
-echo('<table width="100%"><tr><td><strong>Aktuálně:</strong></td><td align="right">
-<a href="?Action=CustomizeNews">Upravit</a></td></tr></table>');
-//<img alt="Teplomer" width="10" height="18" src="images/teplomer3.png"><a href="statistic/trafficview2.php?type=temp">'.$Teplota.'°C (mimo provoz)</a></td></tr></table>');
-
-$UploadedFilesFolder = 'aktuality/uploads/';
-
-// Initialize default news setting
-$NewsSetting = array();
-$I = 1;
-$DbResult = $Database->select('news_category', '*');
-while($NewsCategory = $DbResult->fetch_array())
-{
-  $NewsSetting[] = array('CategoryId' => $NewsCategory['id'], 'Index' => $I, 'Enabled' => 1, 'ItemCount' => $Config['Web']['News']['Count'], 'DaysAgo' => $Config['Web']['News']['DaysAgo']);
-  $I++;
-}
-// Merge defaults with user setting
-if(array_key_exists('NewsSetting', $_COOKIE))
-{
-  $NewsSettingCookie = unserialize($_COOKIE['NewsSetting']);
-  foreach($NewsSetting as $Index => $NewSetting)
-  {
-    $NewsSetting[$Index] = array_merge($NewSetting, $NewsSettingCookie[$Index]);
-  }
-}
-
-if(array_key_exists('Action', $_GET))
-{
-  // Show news customize menu
-  if($_GET['Action'] == 'CustomizeNews')
-  {
-    echo('<form action="?Action=CustomizeNewsSave" method="post">');
-    echo('<table width="100%" cellspacing="0" border="1"><tr><td><table cellspacing="0" width="100%">');
-    echo('<tr><th>Kategorie</th><th>Pozice</th><th>Zobrazit</th><th>Max. počet</th><th>Posledních dnů</th></tr>');
-    $I = 0;
-    foreach($NewsSetting as $SettingItem)
-    {
-      $DbResult = $Database->select('news_category', '*', 'id='.$SettingItem['CategoryId']);
-      $NewsCategory = $DbResult->fetch_array();
-      echo('<tr><td>'.$NewsCategory['caption'].'</td><td align="center"><input type="text" size="1" name="NewsCategoryIndex'.$I.'" value="'.$SettingItem['Index'].'" /></td><td align="center"><input type="checkbox" name="NewsCategoryEnabled'.$I.'"');
-      if($SettingItem['Enabled'] == 1) echo(' checked="checked"'); 
-      echo(' /></td>'.
-      '<td align="center"><input type="text" size="1" name="NewsCategoryCount'.$I.'" value="'.$SettingItem['ItemCount'].'" />'.
-      '<input type="hidden" name="NewsCategoryId'.$I.'" value="'.$SettingItem['CategoryId'].'" /></td><td align="center"><input type="text" size="1" name="NewsCategoryDaysAgo'.$I.'" value="'.$SettingItem['DaysAgo'].'" /></td></tr>');
-      $I++;
-    }
-    echo('</table><input type="hidden" name="NewsCategoryCount" value="'.count($NewsSetting).'" /><input type="submit" value="Uložit" /></form></td></tr></table>');
-  }
-}
-
-echo('<div onmouseout="skryj(predchozi)">');
-
-function ShowNews($Category, $ItemCount, $DaysAgo)
-{
-  global $Database, $NewsCategoryNames, $NewsCountPerCategory, $UploadedFilesFolder;
-
-  $ItemCount = abs($ItemCount);
-  $DaysAgo = abs($DaysAgo);
-  $DbResult = $Database->select('news_category', '*', 'id='.$Category);
-  $Row = $DbResult->fetch_array();
-  echo('<table cellspacing="0" cellpadding="0" border="0" width="100%" style="font-size: small; padding-bottom: 5px;"><tr>');
-  echo('<td>'.$Row['caption'].'</td><td align="right">');
-  echo('<a href="aktuality/index.php?category='.$Category.'">Zobrazit všechny aktuality</a>&nbsp;');
-  if($Row['permission'] == 1) echo('<a href="aktuality/index.php?action=add&amp;category='.$Category.'">Přidat aktualitu</a>&nbsp;');
-  echo('</td></tr><tr><td colspan="2">');
-  $DbResult = $Database->query('SELECT * FROM `news` WHERE (`category`='.$Category.') AND (DATE_SUB(NOW(), INTERVAL '.$DaysAgo.' DAY) < `date`) ORDER BY `date` DESC LIMIT 0,'.$ItemCount);
-  //echo($Database->error.'<br />');
-  //echo($Database->LastQuery.'<br />');
-//echo('<table cellpadding="0" cellspacing="0" width="100%"><tr><td>');
-  $Index = 0;
-  $FontSize = 12;
-  if($DbResult->num_rows > 0)
-  {
-  echo('<table cellspacing="0" width="100%" class="NewsTable">');
-  while($Row = $DbResult->fetch_array())
-  {
-    echo('<tr><td onmouseover="zobraz('."'new".$Category.$Index."'".')" style="cursor: pointer; margin: 0px;"><table cellspacing="0" cellpadding="0" style="padding: 0px; margin: 0px; font-size: small; color: red;" width="100%">
-<tr><td style="font-size: '.$FontSize.'pt"><strong>'.$Row['title'].'</strong></td>
-<td align="right" style="font-size: '.$FontSize.'pt">'.$Row['author'].' ('.HumanDate($Row['date']).')</td></tr></table>');
-    echo('<div id="new'.$Category.$Index.'" class="NewsTableItem">'.$Row['content']);
-
-      if($Row['enclosure'] != '')
-      { 
-        echo('<br />Přílohy: ');
-        $Enclosures = explode(';', $Row['enclosure']);
-         foreach($Enclosures as $Enclosure)
-         {
-          if(file_exists($UploadedFilesFolder.$Enclosure)) echo(' <a href="'.$UploadedFilesFolder.$Enclosure.'">'.$Enclosure.'</a>');
-         }
-      }
-
-    echo('</div></td></tr>');
-    $Index = $Index + 1;    
-    $FontSize = $FontSize - 1;
-  }
-  echo('</table>');
-  }
-  echo('</td></tr></table>'."\n\n");
-}
-
-foreach($NewsSetting as $SettingItem)
-  if($SettingItem['Enabled'] == 1) ShowNews($SettingItem['CategoryId'], $SettingItem['ItemCount'], $SettingItem['DaysAgo']);
-
-echo('<a href="aktuality/subscription.php"><img class="RSSIcon" src="images/rss20.png" alt="Aktuality přes RSS" /></a>  <a href="aktuality/subscription.php">Automatické sledování novinek</a>');
-
-//echo('</td></tr></table>'
-echo('</div></td></tr></table>');
-//if(IsInternetAddr()) echo('Internet'); else echo('LAN');
-
-ShowFooter();
-
-?>

www/user.php

@@ -32 +32 @@
   var $User = array();
   var $DefaultRole = 2;
-  var $AnonymousUserId = 80;
+  var $AnonymousUserId = 72;
 
   function Check()
@@ -48 +48 @@
     // Zkontroluj přihlášení
     $Query = $this->Database->select('UserOnline', '*', 'SessionId="'.$SID.'"');
-    $Row = $Query->fetch_array();
+    $Row = $Query->fetch_assoc();
     if($Row['User'] != $this->AnonymousUserId) 
     {
       $Query = $this->Database->select('User', '*', "Id=".$Row['User']."");
-      $this->User = $Query->fetch_array();
+      $this->User = $Query->fetch_assoc();
       $Result = USER_LOGGED;
     } else 
     {
       $Query = $this->Database->select('User', '*', "Id=".$this->AnonymousUserId);
-      $this->User = $Query->fetch_array();
+      $this->User = $Query->fetch_assoc();
       $Result = USER_NOT_LOGGED;
     }
+
 
     // Odeber neaktivní uživatele

www/webcam/index.php

@@ -1 +1 @@
 <?php
 
-include('../style.php');
-ShowHeader('Kamera', 'Webová kamera');
+include('../global.php');
 
-$ReloadPeriod = $Config['Web']['WebcamRefresh'] * 1000; // ms
+class WebcamPage extends Page
+{
+  var $FullTitle = 'Webová kamera';
+  var $ShortTitle = 'Kamera';
+  
+  function Show()
+  {
+    global $Config;
 
-echo('
-<script language="JavaScript">
-// Set the BaseURL to the url of your camera
-// Note: Since this file is located inside the unit itself, no base url is specified here
-// Example:  var BaseURL = "http://172.21.1.122/";
-var BaseURL = "http://centrala.zdechov.net/";
+    if(file_exists($this->System->Modules['Webcam']->ImageFileName))
+    {
+      $Output = '<script language="JavaScript">
+      var ImageURL = "'.$Config['Web']['RootFolder'].'/webcam/'.$this->System->Modules['Webcam']->ImageFileName.'";
 
-// This is the filepath to the image generating file inside the camera itself
-var File = "webcam/webcam.jpg";
-   
-// Force an immediate image load
-var theTimer = setTimeout("reloadImage()", 1);
-        
-function reloadImage() 
-{
-  theDate = new Date();
-  var url = BaseURL;
-  url += File;
-  url += "?dummy=";
-  url += theDate.getTime().toString(10);
-  // The above dummy cgi-parameter enforce a bypass of the browser image cache.
-  // Here we actually load the image
-  document.theImage.src = url;
-                 
-  // Reload the image every 10 seconds (10000 ms)
-  theTimer = setTimeout("reloadImage()", '.$ReloadPeriod.');   
+      // Force an immediate image load
+      var theTimer = setTimeout("reloadImage()", 1);
+
+      function reloadImage() 
+      {
+        theDate = new Date();
+        var url = ImageURL;
+        url += "?dummy=";
+        url += theDate.getTime().toString(10);
+        // The above dummy cgi-parameter enforce a bypass of the browser image cache.
+        // Here we actually load the image
+        document.theImage.src = url;
+
+        // Reload the image every defined period
+        theTimer = setTimeout("reloadImage()", '.($Config['Web']['WebcamRefresh'] * 1000).');
+      }
+      </script>';
+
+      $Output .= '<br /><div align="center"><img name="theImage" src="" idth="640" height="480" alt="Webcam image"><br>Poslední aktualizace: '.date('j.n.Y G:i', filemtime($this->System->Modules['Webcam']->ImageFileName)).'<br>Obnovování po '.$Config['Web']['WebcamRefresh'].' sekundách</div><br />';
+    } else $Output = '<br />Obrázek nenalezen.<br /><br />';
+
+    $Output .= '<strong>Kamery v okolí:</strong><br />'.
+      '<a href="http://www.mestovsetin.cz/vismo/dokumenty2.asp?id_org=18676&id=480245">Webové kamery ve Vsetíně</a><br />';
+
+    return($Output);
+  }
 }
-                               
-</script>');
 
-echo('<br><div align="center"><img name="theImage" src="" idth="640" height="480" alt="Webcam image"><br>Poslední aktualizace: '.date('j.n.Y G:i', filemtime('webcam.jpg')).'<br>Obnovování po '.$Config['Web']['WebcamRefresh'].' sekundách</div><br>');
+$System->AddModule(new WebcamPage());
+$System->Modules['WebcamPage']->GetOutput();
 
-echo('<strong>Kamery v okolí:</strong><br><a href="http://www.inext.cz/webkamera_updated.htm">Ulice nádražní a Smetanova Vsetín</a><br>');
-ShowFooter();
 ?>