Changeset 718 for trunk/Common/Setup/Updates.php

Timestamp:

Jan 1, 2015, 3:22:27 PM (10 years ago)

Author:

chronos

Message:

• Added: New table Company for representation of currecnt selected subject to work with.

File:

• trunk/Common/Setup/Updates.php (modified) (2 diffs)

trunk/Common/Setup/Updates.php

@@ -1001 +1001 @@
         $Manager->Execute('ALTER TABLE `Member` DROP `NetworkSegment`');
         $Manager->Execute('DROP TABLE `NetworkSegment`');
+        $Manager->Execute('DELETE FROM `MenuItem` WHERE `Name`="Úseky sítě"');
+        $Manager->Execute('DELETE FROM `Action` WHERE `Title`="Úseky sítě"');
+}
+
+function UpdateTo718($Manager)
+{       
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `Company` (
+`Id` int(11) NOT NULL,
+`Name` varchar(255) NOT NULL,
+`Subject` int(11) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;');
+  $Manager->Execute('ALTER TABLE `Company`
+ADD PRIMARY KEY (`Id`), ADD KEY `Subject` (`Subject`);');
+  $Manager->Execute('ALTER TABLE `Company`
+MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;');
+  $Manager->Execute('ALTER TABLE `Company`
+ADD CONSTRAINT `Company_ibfk_1` FOREIGN KEY (`Subject`) REFERENCES `Subject` (`Id`);');
+
+  // IS menu item
+  $Manager->Execute('INSERT INTO `Action` (`Id` ,`Name` ,`Title` ,`Type` ,`URL` ,
+`Group` ,`Icon` ,`PermissionOperation` ,`Enable`) VALUES (
+NULL , "", "Firmy", "1", "/is/?t=Company&a=list", NULL , NULL , NULL , "1");');
+  $ActionId = $Manager->Database->insert_id;
+  $DbResult = $Manager->Execute('SELECT `Id` FROM `MenuItem` WHERE `Name`="Finance"');
+  if($DbResult->num_rows > 0)
+  {
+        $DbRow = $DbResult->fetch_assoc();
+    $Manager->Execute("INSERT INTO `MenuItem` (`Id` ,`Name` ,`Parent` ,`Action` ,`Menu`) ".
+      "VALUES (NULL , 'Firmy', ".$DbRow['Id'].", '".$ActionId."', '1');");
+  }
 }
 
@@ -1057 +1087 @@
       697 => array('Revision' => 707, 'Function' => 'UpdateTo707'),
       710 => array('Revision' => 715, 'Function' => 'UpdateTo715'),
+      715 => array('Revision' => 718, 'Function' => 'UpdateTo718'),
     ));
   }