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

Timestamp:

Feb 22, 2016, 11:17:22 PM (9 years ago)

Author:

chronos

Message:

• Modified: StockSerialNumber info transformed to separate table so multiple history items with different time can be added to track serial number history.

File:

• trunk/Modules/Stock/Stock.php (modified) (5 diffs)

trunk/Modules/Stock/Stock.php

@@ -31 +31 @@
         'UnitOfMeasure' => array('Type' => 'TUnitOfMeasure', 'Caption' => 'Měrná jednotka', 'Default' => '', 'Null' => true),
         'StockSerialNumbers' => array('Type' => 'TStockSerialNumberListProduct', 'Caption' => 'Položky na skladě', 'Default' => '', 'Suffix' => 'ks'),
+        'StockState' => array('Type' => 'Integer', 'Caption' => 'Síťová zařízení', 'Default' => '', 'ReadOnly' => true, 
+          'SQL' => 'SELECT SUM(`Amount`) FROM `StockMoveItem` WHERE `StockMoveItem`.`Product`=#Id'),
+        'StockMoves' => array('Type' => 'TStockMoveItemListProduct', 'Caption' => 'Pohyby na skladě', 'Default' => ''),
         'NetworkDevices' => array('Type' => 'TNetworkDeviceListProduct', 'Caption' => 'Síťová zařízení', 'Default' => ''),
       ),
@@ -49 +52 @@
         'RegNumber' => array('Type' => 'String', 'Caption' => 'Evidenční číslo', 'Default' => '', 'Null' => true),
         'Location' => array('Type' => 'TMember', 'Caption' => 'Umístění', 'Default' => '', 'Null' => true),
-        'Info' => array('Type' => 'Text', 'Caption' => 'Informace', 'Default' => ''),
         'Esemble' => array('Type' => 'TStockSerialNumber', 'Caption' => 'Celek', 'Default' => ''),
         'Parts' => array('Type' => 'TStockSerialNumberListStockSerialNumber', 'Caption' => 'Části', 'Default' => ''),
+        'History' => array('Type' => 'TStockItemHistoryListStockSerialNumber', 'Caption' => 'Historie', 'Default' => ''),
       ),
     ));
@@ -121 +124 @@
       ),
     ));
+    $this->System->FormManager->RegisterClass('StockItemHistory', array(
+      'Title' => 'Historie skladové položky',
+      'Table' => 'StockItemHistory',
+      'DefaultSortColumn' => 'Time',
+      'Items' => array(
+        'Time' => array('Type' => 'DateTime', 'Caption' => 'Čas', 'Default' => ''),
+        'StockSerialNumber' => array('Type' => 'TStockSerialNumber', 'Caption' => 'Sériové číslo', 'Default' => ''),
+        'Text' => array('Type' => 'Text', 'Caption' => 'Text', 'Default' => ''),
+      ),
+    ));
     $this->System->FormManager->RegisterFormType('TStockMoveItemListStockMove', array(
       'Type' => 'ManyToOne',
@@ -128 +141 @@
       'Filter' => '1',
     ));
+    $this->System->FormManager->RegisterFormType('TStockMoveItemListProduct', array(
+      'Type' => 'ManyToOne',
+      'Table' => 'StockMoveItem',
+      'Id' => 'Id',
+      'Ref' => 'Product',
+      'Filter' => '1',
+    ));
     $this->System->FormManager->RegisterFormType('TStockMoveStock', array(
       'Type' => 'ManyToOne',
@@ -161 +181 @@
       'Id' => 'Id',
       'Name' => 'RegNumber',
+      'Filter' => '1',
+    ));
+    $this->System->FormManager->RegisterFormType('TStockItemHistoryListStockSerialNumber', array(
+      'Type' => 'ManyToOne',
+      'Table' => 'StockItemHistory',
+      'Id' => 'Id',
+      'Ref' => 'StockSerialNumber',
       'Filter' => '1',
     ));