Changeset 591

Timestamp:

Nov 2, 2013, 3:54:49 PM (11 years ago)

Author:

chronos

Message:

• Přidáno: Skladová položka nyní může mít nyní jako sestava podpoložky.

Location:

trunk

Files:

• Common/Version.php (modified) (1 diff)
• FormClasses.php (modified) (1 diff)
• Modules/Setup/Updates.php (modified) (2 diffs)
• Modules/Stock/Stock.php (modified) (1 diff)

trunk/Common/Version.php

@@ -1 +1 @@
 <?php
 
-$Revision = 589; // Subversion revision
-$DatabaseRevision = 584; // SQL structure revision
-$ReleaseTime = '2013-11-01';
+$Revision = 591; // Subversion revision
+$DatabaseRevision = 591; // SQL structure revision
+$ReleaseTime = '2013-11-02';

trunk/FormClasses.php

@@ -701 +701 @@
     'Filter' => '1',
   ),
+  'TStockItemListStockItem' => array(
+    'Type' => 'ManyToOne',
+    'Table' => 'StockItem',
+    'Id' => 'Id',
+    'Ref' => 'Esemble',
+    'Filter' => '1',
+  ),
 );
 }

trunk/Modules/Setup/Updates.php

@@ -441 +441 @@
 }
 
+function UpdateTo591($Manager)
+{
+  $Manager->Execute('ALTER TABLE `StockItem` ADD `Esemble` INT NULL ,
+ADD INDEX ( `Esemble` ) ;');
+  $Manager->Execute('ALTER TABLE `StockItem` ADD FOREIGN KEY ( `Esemble` ) REFERENCES StockItem` (
+`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;');
+}
+
 class Updates
 {
@@ -468 +476 @@
   571 => array('Revision' => 574, 'Function' => 'UpdateTo574'),
   574 => array('Revision' => 584, 'Function' => 'UpdateTo584'),
+  584 => array('Revision' => 591, 'Function' => 'UpdateTo591'),
 ));
     }

trunk/Modules/Stock/Stock.php

@@ -50 +50 @@
         'Segment' => array('Type' => 'TNetworkSegment', 'Caption' => 'Úsek sítě', 'Default' => '', 'Null' => true),
         'Info' => array('Type' => 'Text', 'Caption' => 'Informace', 'Default' => ''),
+        'Esemble' => array('Type' => 'TStockItem', 'Caption' => 'Celek', 'Default' => ''),
+        'Parts' => array('Type' => 'TStockItemListStockItem', 'Caption' => 'Části', 'Default' => ''),          
       ),
     ));