Changeset 451 for trunk/finance/index.php

Timestamp:

Oct 24, 2012, 10:42:58 PM (12 years ago)

Author:

chronos

Message:

• Upraveno: Korekce tabulek Product a StockItem.

File:

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

trunk/finance/index.php

@@ -57 +57 @@
     $TotalGain = 0;
     $TotalExpense = 0;
-    $DbResult = $this->Database->query('SELECT SUM(Consumption) FROM Product WHERE Used=1');
+    $DbResult = $this->Database->query('SELECT SUM(Product.Consumption) * StockItem.Amount FROM StockItem '.
+      'JOIN Product ON Product.Id=StockItem.Product WHERE (StockItem.TimeElimination IS NULL)');
     $Row = $DbResult->fetch_array();
     $TotalConsumption = $this->System->Modules['Finance']->W2Kc($Row[0]);