Changeset 408 for trunk/finance/spotreba.php

Timestamp:

Oct 4, 2012, 8:29:32 AM (12 years ago)

Author:

chronos

Message:

• Upraveno: Přejmenována sql tabulka network_segments na NetworkSegment.

File:

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

trunk/finance/spotreba.php

@@ -14 +14 @@
     $Output = 'Spotřeba zařízení jednotlivých segmentů:<div align="center"><table class="WideTable"><tr><th>Jméno segmentu</th><th>Spotřeba [W]</th><th>Cena [Kč/měsíc]</th></tr>';
     $CelkovaSpotreba = 0;
-    $DbResult = $this->Database->query("SELECT * FROM network_segments");
+    $DbResult = $this->Database->query("SELECT * FROM NetworkSegment");
     while($Row = $DbResult->fetch_array())
     {
-      $DbResult2 = $this->Database->query("SELECT SUM(consumption) FROM network_devices WHERE segment=".$Row['id']." AND used=1");
+      $DbResult2 = $this->Database->query("SELECT SUM(consumption) FROM network_devices WHERE Segment=".$Row['Id']." AND Used=1");
       $Row2 = $DbResult2->fetch_array();
       $CelkovaSpotreba = $CelkovaSpotreba + $Row2[0];
-      $Output .= '<tr><td>'.$Row['name'].'</td><td align="right">'.$Row2[0].'</td><td align="right">'.$this->System->Modules['Finance']->W2Kc($Row2[0]).'</td></tr>';
+      $Output .= '<tr><td>'.$Row['Name'].'</td><td align="right">'.$Row2[0].'</td><td align="right">'.$this->System->Modules['Finance']->W2Kc($Row2[0]).'</td></tr>';
     }
     $Output .= '<tr style="font-weight: Bold;"><td><strong>Celkem</strong></td><td align="right">'.$CelkovaSpotreba.'</td><td align="right">'.$this->System->Modules['Finance']->W2Kc($CelkovaSpotreba).'</td></tr>';