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

trunk/finance/manage.php

@@ -69 +69 @@
         $Output .= '<a href="clenove.php">Seznam členů</a><br />';
         $Output .= '<a href="zivnost.php">Živnost</a><br />';
+        $Output .= '<a href="inventory.php">Stav skladu</a><br />';
         $Output .= '<a href="?Operation=GenerateBills">Generovat chybějící doklady</a><br />';
         $Output .= '<a href="import.php">Import plateb</a><br />';
@@ -294 +295 @@
 
     // Celkovy prehled
-    $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');
     $Row = $DbResult->fetch_row();
     $TotalDeviceCost = $Row[0];
@@ -314 +315 @@
     $Output .= 'Stav pokladny: Členové('.$TotalMemberCash.')';   
 
-    $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_row();
     $TotalConsumption = $Row[0];