Changeset 603 for trunk/Modules/Stock/Stock.php

Timestamp:

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

Author:

chronos

Message:

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

File:

• trunk/Modules/Stock/Stock.php (modified) (1 diff)

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č'),
       ),
     ));