Changeset 409 for trunk/finance/spotreba.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/spotreba.php (modified) (1 diff)

trunk/finance/spotreba.php

@@ -15 +15 @@
     $CelkovaSpotreba = 0;
     $DbResult = $this->Database->query("SELECT * FROM NetworkSegment");
-    while($Row = $DbResult->fetch_array())
+    while($Segment = $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 Product WHERE Segment=".$Segment['Id']." AND Used=1");
       $Row2 = $DbResult2->fetch_array();
       $CelkovaSpotreba = $CelkovaSpotreba + $Row2[0];