Changeset 152 for www/finance/zivnost.php

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í.

File:

• www/finance/zivnost.php (modified) (2 diffs)

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();
 
 ?>