Changeset 409 for trunk/finance/user_state.php

Timestamp:

Oct 4, 2012, 9:01:28 AM (12 years ago)

Author:

chronos

Message:

• Upraveno: Přejmenovaná tabulka network_device a hosts_topology.

File:

• trunk/finance/user_state.php (modified) (1 diff)

trunk/finance/user_state.php

@@ -115 +115 @@
       $Output .= 'Měsíční příjem za spotřebu zařízení umístěných u uživatele:<br>';
       $Output .= '<table class="WideTable"><tr><th>Název zařízení</th><th>Spotřeba [W]</th><th>Příjem [Kč]</th></tr>';
-      $DbResult = $this->Database->query('SELECT * FROM network_devices WHERE user='.$Member['Subject'].' AND used=1');
+      $DbResult = $this->Database->query('SELECT * FROM Product WHERE User='.$Member['Subject'].' AND Used=1');
       $TotalW = 0;
       $TotalPrice = 0;
       while($Row = $DbResult->fetch_assoc())
       {
-        $Output .= '<tr><td>'.$Row['name'].'</td><td>'.$Row['consumption'].'</td><td>'.$this->System->Modules['Finance']->W2Kc($Row['consumption']).'</td></tr>';
-        $TotalW += $Row['consumption'];
-        $TotalPrice += $this->System->Modules['Finance']->W2Kc($Row['consumption']);
+        $Output .= '<tr><td>'.$Row['Name'].'</td><td>'.$Row['Consumption'].'</td><td>'.$this->System->Modules['Finance']->W2Kc($Row['Consumption']).'</td></tr>';
+        $TotalW += $Row['Consumption'];
+        $TotalPrice += $this->System->Modules['Finance']->W2Kc($Row['Consumption']);
       }
       $Output .= '<tr><td><strong>Celkem</strong></td><td><strong>'.$TotalW.'</strong></td><td><strong>'.$TotalPrice.'</strong></td></tr>';