Changeset 227 for trunk/finance/user_state.php

Timestamp:

Jun 1, 2009, 11:07:05 AM (15 years ago)

Author:

george

Message:

• Opraveno: Stav účtu u měsíčních plateb byl posunut o poslední platbu.
• Upraveno: Zobrazovat stav účtu ve výpisu uživatele nahoře.

File:

• trunk/finance/user_state.php (modified) (2 diffs)

trunk/finance/user_state.php

@@ -42 +42 @@
     $Output = '<table width="100%" border="0" cellspacing="0" cellpadding="3"><tr><td valign="top">';
 
+    $UserOperationTableQuery = '((SELECT Text, Time, Value AS Value, Bill FROM FinanceOperation WHERE (Subject='.$Subject['Id'].')) UNION ALL '.
+      '(SELECT Text, TimeCreation as Time, -Value as Value, Bill FROM FinanceClaimsLiabilities WHERE (Subject='.$Subject['Id'].')) ORDER BY Time DESC) AS T1';
+    $DbResult = $this->Database->query('SELECT SUM(T1.Value) AS Total FROM '.$UserOperationTableQuery);
+    $DbRow = $DbResult->fetch_array();
+    $Total = $DbRow['Total'];
+    $Output .= 'Stav účtu: <strong>'.$Total.' Kč</strong<br /><br />';
+
     // Tabulka operaci
-    $Output .= 'Výpis operací pro subjekt '.$Subject['Name'].':<br>';
+    $Output .= 'Výpis operací pro subjekt '.$Subject['Name'].':<br />';
     $Output .= '<table style="font-size: smaller;" class="WideTable"><tr><th>Datum</th><th>Popis</th><th>Částka</th><th>Doklad</th></tr>';
     $Operations = array();
-    $UserOperationTableQuery = '((SELECT Text, Time, Value AS Value, Bill FROM FinanceOperation WHERE (Subject='.$Subject['Id'].')) UNION ALL '.
-      '(SELECT Text, TimeCreation as Time, -Value as Value, Bill FROM FinanceClaimsLiabilities WHERE (Subject='.$Subject['Id'].')) ORDER BY Time DESC) AS T1';
     $DbResult = $this->Database->query('SELECT T1.* FROM '.$UserOperationTableQuery);
     while($DbRow = $DbResult->fetch_array())
@@ -60 +65 @@
     //echo('<tr><td>&nbsp;</td><td>-'.$Row2['network_device'].'</td><td>Proměnná cena za zařízení</td></tr>
     $Output .= '</table>';
-    $DbResult = $this->Database->query('SELECT SUM(T1.Value) AS Total FROM '.$UserOperationTableQuery);
-    $DbRow = $DbResult->fetch_array();
-    $Total = $DbRow['Total'];
-    $Output .= '<h3><strong>Stav účtu: </strong>'.$Total.' Kč</h3><br>';
     $Output .= '</td><td valign="top">';