Changeset 152 for www/finance/clenove.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/clenove.php (modified) (1 diff)

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