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

Timestamp:

Jul 26, 2014, 11:15:46 AM (10 years ago)

Author:

chronos

Message:

• Přidáno: Oblíbené položky v nabídce.
• Přidáno: Popis a povolení příjmu zpráv u kontaktů.

File:

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

trunk/Common/Setup/Updates.php

@@ -848 +848 @@
 }
 
+function UpdateTo678($Manager)
+{
+  $Manager->Execute('ALTER TABLE `Contact` ADD `Description` VARCHAR( 255 ) NOT NULL ;');
+  $Manager->Execute('ALTER TABLE `Contact` ADD `Receive` BOOLEAN NOT NULL ;');
+
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `MenuItemFavorite` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `User` int(11) NOT NULL,
+  `MenuItem` int(11) NOT NULL,
+  PRIMARY KEY (`Id`),
+  KEY `User` (`User`),
+  KEY `MenuItem` (`MenuItem`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;');
+
+  $Manager->Execute('ALTER TABLE `MenuItemFavorite`
+  ADD CONSTRAINT `MenuItemFavorite_ibfk_2` FOREIGN KEY (`MenuItem`) REFERENCES `MenuItem` (`Id`),
+  ADD CONSTRAINT `MenuItemFavorite_ibfk_1` FOREIGN KEY (`User`) REFERENCES `User` (`Id`);');
+
+  $Manager->Execute('INSERT INTO `Action` (`Id` ,`Name` ,`Title` ,`Type` ,`URL` ,
+`Group` ,`Icon` ,`PermissionOperation` ,`Enable`) VALUES (
+NULL , "", "Oblíbené položky nabídky", "1", "/is/?t=MenuItemFavorite&a=list", NULL , NULL , NULL , "1");');
+  $ActionId = $Manager->Database->insert_id;
+  $DbResult = $Manager->Execute('SELECT `Id` FROM `MenuItem` WHERE `Name`="Nabídky"');
+  if($DbResult->num_rows > 0)
+  {
+        $DbRow = $DbResult->fetch_assoc();
+    $Manager->Execute("INSERT INTO `MenuItem` (`Id` ,`Name` ,`Parent` ,`Action` ,`Menu`) ".
+      "VALUES (NULL , 'Oblíbené položky nabídky', ".$DbRow['Id'].", '".$ActionId."', '1');");
+  }
+}
+
 class Updates
 {
@@ -894 +925 @@
       671 => array('Revision' => 674, 'Function' => 'UpdateTo674'),
       674 => array('Revision' => 676, 'Function' => 'UpdateTo676'),
+      676 => array('Revision' => 678, 'Function' => 'UpdateTo678'),
     ));
   }