Changeset 507 for trunk/admin/Updates.php

Timestamp:

Apr 1, 2013, 7:14:59 PM (11 years ago)

Author:

chronos

Message:

• Opraveno: Generování nastavení sítě. Generování front Queue nyní pracuje s přiřazením služeb k zařízením a podsítím.
• Opraveno: Zjišťování adresáře souborů na disku dle id adresáře.

File:

• trunk/admin/Updates.php (modified) (2 diffs)

trunk/admin/Updates.php

@@ -183 +183 @@
   `Message` varchar(255) NOT NULL DEFAULT '',
   PRIMARY KEY (`Id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
-  
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;"); 
+}
+
+function UpdateTo507($Manager)
+{
+  $Manager->Execute("INSERT INTO `ISMenuItem` (`Id` ,`Name` ,`Parent` ,`Table` ,`IconName`) ".
+    "VALUES (NULL , 'Aktuality', NULL, '', '');");
+  $Id = $Manager->Database->insert_id;
+  $Manager->Execute("INSERT INTO `ISMenuItem` (`Id` ,`Name` ,`Parent` ,`Table` ,`IconName`) ".
+    "VALUES (NULL , 'Aktuality', '".$Id."', 'News', '');");
+  $Manager->Execute("INSERT INTO `ISMenuItem` (`Id` ,`Name` ,`Parent` ,`Table` ,`IconName`) ".
+    "VALUES (NULL , 'Kategorie aktualit', '".$Id."', 'NewsCategory', '');");
+  $Manager->Execute("INSERT INTO `FileDirectory` (`Id` ,`Name` ,`Parent`".
+    ") VALUES (NULL , 'news', NULL);");
+  $Manager->Execute("ALTER TABLE `File` ADD `Time` DATETIME NOT NULL ");
+  // Convert Hire column to Service item
+  $Manager->Execute("INSERT INTO `ServiceCategory` (
+`Id` ,`Name`) VALUES (NULL , 'Pevný nájem');");
+  $ServiceCategoryHire = $Manager->Database->insert_id;  
+  $DbResult = $Manager->Execute("SELECT * FROM Member WHERE Hire>0");
+  while($Member = $DbResult->fetch_assoc())
+  {
+    $Manager->Execute("INSERT INTO `Service` (
+`Id` ,`Name` ,`Category` ,`Price` ,`VAT` ,`CustomerCount` ,`Action` ,`ReplaceId` ,
+`Public` ,`InternetSpeedMin` ,`InternetSpeedMax` ,`UploadAsymmetry` ,`Memory` ,`MemorySwap` ,`Storage` ,`CPUCount`)
+VALUES (
+NULL , 'Nájem', '".$ServiceCategoryHire."', '-".$Member['Hire']."', '2', '', NULL , NULL , '', '', '', '', '', '', '', ''
+);");
+    $ServiceHire = $Manager->Database->insert_id;  
+    $Manager->Execute("INSERT INTO `ServiceCustomerRel` (`Service`, `Customer`) VALUES ". 
+      "(".$ServiceHire.",".$Member['Id'].")");
+  }
+  $Manager->Execute("ALTER TABLE `Member` DROP `Hire`");
+  // Each device and subnet have to be assigned to payed service to determine service parameters
+  $Manager->Execute("ALTER TABLE `NetworkDevice` ADD `Service` INT NULL AFTER `Location` ,
+ADD INDEX ( `Service` )");
+  $Manager->Execute("ALTER TABLE `NetworkDevice` ADD FOREIGN KEY ( `Service` ) REFERENCES `ServiceCustomerRel` (
+`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;");
+  $Manager->Execute("UPDATE `NetworkDevice` SET `Service` = (SELECT `Id` FROM `ServiceCustomerRel` WHERE `ServiceCustomerRel`.`Customer` = `NetworkDevice`.`Member` LIMIT 1)");
+  $Manager->Execute("ALTER TABLE `NetworkSubnet` ADD `Service` INT NULL AFTER `Member` ,
+ADD INDEX ( `Service` ) ");
+  $Manager->Execute("ALTER TABLE `NetworkSubnet` ADD FOREIGN KEY ( `Service` ) REFERENCES `ServiceCustomerRel` (
+`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;");
+  $Manager->Execute("UPDATE `NetworkSubnet` SET `Service` = (SELECT `Id` FROM `ServiceCustomerRel` WHERE `ServiceCustomerRel`.`Customer` = `NetworkSubnet`.`Member` LIMIT 1)"); 
 }
 
@@ -197 +239 @@
   500 => array('Revision' => 502, 'Function' => 'UpdateTo502'),
   502 => array('Revision' => 505, 'Function' => 'UpdateTo505'),
+  505 => array('Revision' => 507, 'Function' => 'UpdateTo507'),
 );