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

Timestamp:

Feb 23, 2016, 7:18:38 PM (9 years ago)

Author:

chronos

Message:

• Added: Relation between StockMoveItem and StockSerialNumber so serial numbers can be associated with stock move items now.

File:

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

trunk/Modules/Stock/Stock.php

@@ -17 +17 @@
   {
     global $Config;
-   
+
     $this->System->FormManager->RegisterClass('Product', array(
       'Title' => 'Produkty',
@@ -57 +57 @@
         'Parts' => array('Type' => 'TStockSerialNumberListStockSerialNumber', 'Caption' => 'Části', 'Default' => ''),
         'History' => array('Type' => 'TStockItemHistoryListStockSerialNumber', 'Caption' => 'Historie', 'Default' => ''),
+        'Sériové čísla' => array('Type' => 'TStockMoveItemSerialListSerial', 'Caption' => 'Skladové pohyby', 'Default' => ''),
       ),
     ));
@@ -106 +107 @@
         'Total' => array('Type' => 'Integer', 'Caption' => 'Celkem', 'Default' => '', 'Suffix' => 'Kč',
           'ReadOnly' => true, 'SQL' => 'ROUND(`UnitPrice` * `Amount`, '.$Config['Finance']['Rounding'].')'),
+        'Položky pohybů' => array('Type' => 'TStockMoveItemSerialListItem', 'Caption' => 'Vztahy sériových čísel', 'Default' => ''),
+        'Sériové čísla' => array('Type' => 'String', 'Caption' => 'Sériové čísla', 'ReadOnly' => true,
+          'SQL' => 'SELECT GROUP_CONCAT(`StockSerialNumber`.`RegNumber` SEPARATOR ", ") FROM `StockMoveItemSerialRel` '.
+          'LEFT JOIN `StockSerialNumber` ON `StockSerialNumber`.`Id`=`StockMoveItemSerialRel`.`StockSerialNumber` '.
+          'WHERE `StockMoveItemSerialRel`.`StockMoveItem`=#Id'),
       ),
     ));
@@ -129 +135 @@
       ),
     ));
+    $this->System->FormManager->RegisterClass('StockMoveItemSerialRel', array(
+      'Title' => 'Vztah položky skladových pohybů a sériových čísel',
+      'Table' => 'StockMoveItemSerialRel',
+      'Items' => array(
+        'StockMoveItem' => array('Type' => 'TStockMoveItem', 'Caption' => 'Položky pohybu', 'Default' => ''),
+        'StockSerialNumber' => array('Type' => 'TStockSerialNumber', 'Caption' => 'Sériové číslo', 'Default' => ''),
+      ),
+    ));
     $this->System->FormManager->RegisterFormType('TStockMoveItemListStockMove', array(
       'Type' => 'ManyToOne',
@@ -157 +171 @@
       'Filter' => '1',
     ));
+    $this->System->FormManager->RegisterFormType('TStockMoveItemSerialListItem', array(
+      'Type' => 'ManyToOne',
+      'Table' => 'StockMoveItemSerialRel',
+      'Id' => 'Id',
+      'Ref' => 'StockMoveItem',
+      'Filter' => '1',
+    ));
+    $this->System->FormManager->RegisterFormType('TStockMoveItemSerialListSerial', array(
+      'Type' => 'ManyToOne',
+      'Table' => 'StockMoveItemSerialRel',
+      'Id' => 'Id',
+      'Ref' => 'StockSerialNumber',
+      'Filter' => '1',
+    ));
     $this->System->FormManager->RegisterFormType('TStockMove', array(
       'Type' => 'Reference',
@@ -162 +190 @@
       'Id' => 'Id',
       'Name' => '(SELECT `DocumentLineCode`.`Name` FROM `DocumentLineCode` WHERE `Id`=`StockMove`.`BillCode`)',
+      'Filter' => '1',
+    ));
+    $this->System->FormManager->RegisterFormType('TStockMoveItem', array(
+      'Type' => 'Reference',
+      'Table' => 'StockMoveItem',
+      'Id' => 'Id',
+      'Name' => '(SELECT `Name` FROM `Product` WHERE `Product`.`Id`=`StockMoveItem`.`Product`)',
       'Filter' => '1',
     ));