Changeset 409 for trunk/finance/index.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/index.php (modified) (2 diffs)

trunk/finance/index.php

@@ -35 +35 @@
     $Output .= 'Počet platících klientů: <strong>'.$Row2[0].'</strong><br />';
 
-    //$DbResult = $this->Database->query('SELECT SUM(price) FROM network_devices WHERE used=1');
+    //$DbResult = $this->Database->query('SELECT SUM(Price) FROM Product WHERE Used=1');
     //$Row4 = $DbResult->fetch_array();
     //$Output .= 'Celková cena zařízení sítě: <strong>'.$Row4[0].' Kč</strong><br />';
@@ -60 +60 @@
     $TotalGain = 0;
     $TotalExpense = 0;
-    $DbResult = $this->Database->query('SELECT SUM(consumption) FROM network_devices WHERE used=1');
+    $DbResult = $this->Database->query('SELECT SUM(Consumption) FROM Product WHERE Used=1');
     $Row = $DbResult->fetch_array();
     $TotalConsumption = $this->System->Modules['Finance']->W2Kc($Row[0]);