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

Timestamp:

Nov 6, 2015, 8:40:19 PM (9 years ago)

Author:

chronos

Message:

• Added: Customer support activity table.
• Added: Show operations for operation group.

File:

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

trunk/Common/Setup/Updates.php

@@ -1604 +1604 @@
 }
 
+function UpdateTo765($Manager)
+{
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `SupportActivity` (
+    `Id` int(11) NOT NULL AUTO_INCREMENT,
+    `Description` text NOT NULL,
+    `Customer` int(11) NOT NULL,
+    `User` int(11) NOT NULL,
+    `Time` datetime NOT NULL,
+    PRIMARY KEY (`Id`),
+    KEY `User` (`User`),
+    KEY `Customer` (`Customer`)
+   ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;');
+
+  $Manager->Execute('ALTER TABLE `SupportActivity`
+ADD CONSTRAINT `SupportActivity_ibfk_1` FOREIGN KEY (`Customer`) REFERENCES `Member` (`Id`),
+ADD CONSTRAINT `SupportActivity_ibfk_2` FOREIGN KEY (`User`) REFERENCES `User` (`Id`);');
+
+  // IS menu item
+  $Manager->Execute('INSERT INTO `Action` (`Id` ,`Name` ,`Title` ,`Type` ,`URL` ,
+`Group` ,`Icon` ,`PermissionOperation` ,`Enable`) VALUES (
+NULL , "", "Zákaznická podpora", "1", "/is/?t=SupportActivity&a=list", NULL , NULL , NULL , "1");');
+  $ActionId = $Manager->Database->insert_id;
+  $DbResult = $Manager->Execute('SELECT `Id` FROM `MenuItem` WHERE `Name`="Zákazníci"');
+  if($DbResult->num_rows > 0)
+  {
+    $DbRow = $DbResult->fetch_assoc();
+    $Manager->Execute("INSERT INTO `MenuItem` (`Id` ,`Name` ,`Parent` ,`Action` ,`Menu`) ".
+        "VALUES (NULL , 'Zákazická podpora', ".$DbRow['Id'].", '".$ActionId."', '1');");
+  }
+}
 
 class Updates
@@ -1682 +1712 @@
       759 => array('Revision' => 762, 'Function' => 'UpdateTo762'),
       762 => array('Revision' => 763, 'Function' => 'UpdateTo763'),
+      763 => array('Revision' => 765, 'Function' => 'UpdateTo765'),
     ));
   }