Changeset 603

Timestamp:

Dec 8, 2013, 12:56:53 PM (11 years ago)

Author:

chronos

Message:

• Přidáno: Zobrazení souhrných informací o skladu.

Location:

trunk

Files:

• Application/Version.php (modified) (1 diff)
• Modules/Stock/Stock.php (modified) (1 diff)

trunk/Application/Version.php

@@ -1 +1 @@
 <?php
 
-$Revision = 602; // Subversion revision
+$Revision = 603; // Subversion revision
 $DatabaseRevision = 601; // SQL structure revision
 $ReleaseTime = '2013-12-07';

trunk/Modules/Stock/Stock.php

@@ -62 +62 @@
         'Location' => array('Type' => 'TMember', 'Caption' => 'Umístění', 'Default' => '', 'Null' => true),
         'Items' => array('Type' => 'TStockItemListStock', 'Caption' => 'Položky', 'Default' => ''),
+        'ItemsCount' => array('Type' => 'Integer', 'Caption' => 'Položek', 'Default' => '', 
+          'ReadOnly' => true, 'SQL' => '(SELECT COUNT(*) FROM `StockItem` WHERE '.
+          '(`StockItem`.`Stock`=#Id) AND (`StockItem`.`TimeElimination` IS NULL))'),
+        'TotalPrice' => array('Type' => 'Integer', 'Caption' => 'Celková cena', 'Default' => '', 
+          'ReadOnly' => true, 'SQL' => '(SELECT SUM(`SellPrice`) FROM `StockItem` WHERE '.
+          '(`StockItem`.`Stock`=#Id) AND (`StockItem`.`TimeElimination` IS NULL))', 'Suffix' => 'Kč'),
       ),
     ));