Changeset 145 for www/finance/clenove.php

Timestamp:

Feb 15, 2009, 6:53:26 PM (16 years ago)

Author:

george

Message:

• Upraveno: Nezobrazovat seznam účastníků a jejich financí. Zobrazovat pouze informace vlastníka IP adresy.

File:

• www/finance/clenove.php (modified) (4 diffs)

www/finance/clenove.php

@@ -9 +9 @@
 switch($_GET['show'])
 {
-  case 'user':
-    ShowHeader('Seznam účastníků sítě', 'Seznam účastníků');
+  default:
+    ShowHeader('Finance účastníka', 'Finance účastníka');
+        $UserID = GetMemberByIP('192.168.1.7');
+
     $DbResult = $Database->query("SELECT *,CONCAT(second_name, ' ', first_name) as fullname FROM users WHERE id=".$UserID);
     $Row2 = $DbResult->fetch_array();
@@ -20 +22 @@
     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='.$_GET['id'].') UNION ALL '.
-      '(SELECT TimeCreation as Time, (-Value) as Value, Text, Bill FROM FinanceClaimsLiabilities WHERE Subject='.$_GET['id'].') ORDER BY Time DESC');
+    $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;
@@ -32 +34 @@
     //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='.$_GET['id'].') + '.
-      '(SELECT COALESCE(SUM(-Value), 0) FROM FinanceClaimsLiabilities WHERE Subject='.$_GET['id'].')) as Total');
+    $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'];
@@ -124 +126 @@
     $InvoiceGenerator->ShowStoredBill($_GET['id']);
     break;
-  default:
+  case 'admin_user_list':
     ShowHeader('Seznam účastníků sítě', 'Seznam účastníků');
     // Seznam členů