Changeset 424 for branches/Modular/Modules/System/System.php

Timestamp:

Oct 10, 2012, 9:29:20 AM (12 years ago)

Author:

chronos

Message:

• Upraveno: Modulární systém přepracován tak, že základní modul System je zodpovědný za udržování stavu instalování modulů v databázi a je instalován samostatně jako první modul. Následně lze instalovat moduly dle závislostí.

File:

• branches/Modular/Modules/System/System.php (modified) (3 diffs)

branches/Modular/Modules/System/System.php

@@ -109 +109 @@
   function Install()
   {
-    // Do nothing, already installed by ModuleManager
   }
   
   function UnInstall()
   {
-    // Do nothing, managed by ModuleManager
-  }  
+  }   
 }
 
@@ -135 +133 @@
   function Install()
   {
+    if($this->IsInstalled()) return;
     parent::Install();
+    $this->Database->query('CREATE TABLE IF NOT EXISTS `SystemVersion` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Version` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `Description` datetime NOT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1;');
+    $this->Database->query('CREATE TABLE IF NOT EXISTS `SystemModule` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `Creator` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `Version` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `License` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `Installed` int(11) NOT NULL,
+  `Description` text COLLATE utf8_czech_ci NOT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1;');
+    
+    $this->Database->query('CREATE TABLE IF NOT EXISTS `SystemModuleDependency` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Module` int(11) NOT NULL,
+  `DependencyModule` int(11) NOT NULL,
+  PRIMARY KEY (`Id`),
+  KEY (`Module`),
+  KEY (`DependencyModule`),
+  UNIQUE (`Module` , `DependencyModule`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1;');
+    $this->Database->query('ALTER TABLE `SystemModuleDependency` ADD CONSTRAINT `SystemModuleDependency_ibfk_1` FOREIGN KEY ( `Module` ) REFERENCES `SystemModule` (`Id`)');
+    $this->Database->query('ALTER TABLE `SystemModuleDependency` ADD CONSTRAINT `SystemModuleDependency_ibfk_2` FOREIGN KEY ( `DependencyModule` ) REFERENCES `SystemModule` (`Id`)');
+    
+    $this->Database->query('CREATE TABLE IF NOT EXISTS `SystemModel` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `Module` int(11) NOT NULL,
+  KEY (`Module`),
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1;');
+    $this->Database->query('ALTER TABLE `SystemModel` ADD CONSTRAINT `SystemModel_ibfk_1` FOREIGN KEY ( `Module` ) REFERENCES `SystemModule` (`Id`)');
+    
+    $this->Database->query('CREATE TABLE IF NOT EXISTS `SystemModelProperty` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `Type` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `Model` int(11) NOT NULL,
+  KEY (`Model`),
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1;');
+    $this->Database->query('ALTER TABLE `SystemModelProperty` ADD CONSTRAINT `SystemModelProperty_ibfk_1` FOREIGN KEY ( `Model` ) REFERENCES `SystemModel` (`Id`)');
   }
   
@@ -141 +187 @@
   {
     parent::UnInstall();
-  }
-
-  function Init()
-  {
-    $this->System->Pages['modules'] = 'PageModules';
-  }
+    if(!$this->IsInstalled()) return;
+    
+    // Delete tables with reverse order
+    $this->Database->query('ALTER TABLE `SystemModelProperty` DROP FOREIGN KEY `SystemModelProperty_ibfk_1`');
+    $this->Database->query('DROP TABLE IF EXISTS `SystemModelProperty`');
+    $this->Database->query('ALTER TABLE `SystemModel` DROP FOREIGN KEY `SystemModel_ibfk_1`');
+    $this->Database->query('DROP TABLE IF EXISTS `SystemModel`');
+    $this->Database->query('ALTER TABLE `SystemModuleDependency` DROP FOREIGN KEY `SystemModuleDependency_ibfk_1`');
+    $this->Database->query('ALTER TABLE `SystemModuleDependency` DROP FOREIGN KEY `SystemModuleDependency_ibfk_2`');
+    $this->Database->query('DROP TABLE IF EXISTS `SystemModuleDependency`');
+    $this->Database->query('DROP TABLE IF EXISTS `SystemModule`');
+    $this->Database->query('DROP TABLE IF EXISTS `SystemVersion`');
+  }
+
+  function Start()
+  {
+    parent::Start();
+    $this->System->Pages['module'] = 'PageModules';
+    $this->ModularSystem->OnModuleChange = array($this, 'ModuleChange');
+    $this->LoadFromDatabase();
+  }
+  
+  function Stop()
+  {
+    parent::Stop();
+  }
+  
+  function IsInstalled()
+  {
+    $DbResult = $this->Database->query('SELECT table_name FROM information_schema.tables
+WHERE table_schema = "'.$this->Database->Database.'" AND table_name = "SystemVersion";');    
+    if($DbResult->num_rows > 0) return(true); 
+      else return(false);
+  }
+  
+  function ModuleChange($Module)
+  {
+    if($this->IsInstalled())
+    {
+      if($Module->Installed) 
+      $this->Database->query('UPDATE `SystemModule` SET `Installed`=1 WHERE `Name`="'.$Module->Name.'"');
+        else $this->Database->query('UPDATE `SystemModule` SET `Installed`=0 WHERE `Name`="'.$Module->Name.'"');
+    }
+  }
+  
+  function LoadFromDatabase()
+  {
+    //DebugLog('Loading modules...');
+    $this->Modules = array();
+    $Query = 'SELECT `Id`, `Name`,`Installed` FROM `SystemModule`';
+    $DbResult = $this->Database->query($Query);
+    while($Module = $DbResult->fetch_array())
+    {
+      //echo($Module['Name'].',');
+      include_once('Modules/'.$Module['Name'].'/'.$Module['Name'].'.php');
+      $ModuleClassName = 'Module'.$Module['Name'];
+      $NewModule = new $ModuleClassName($this->Database, $this);      
+      $NewModule->Id = $Module['Id'];
+      $NewModule->Installed = $Module['Installed'];      
+      $this->ModularSystem->RegisterModule($NewModule);
+    }     
+  }
+ 
+  function SaveToDatabase()
+  {
+    $Modules = array();
+    $DbResult = $this->Database->query('SELECT * FROM `SystemModule`');
+    while($DbRow = $DbResult->fetch_assoc())
+      $Modules[$DbRow['Name']] = $DbRow;
+
+    // Add missing
+    foreach($this->ModularSystem->Modules as $Module)    
+    {      
+      if(!array_key_exists($Module->Name, $Modules))
+      $this->Database->insert('SystemModule', array('Name' => $Module->Name, 
+        'Version' => $Module->Version, 'Creator' => $Module->Creator, 
+        'Description' => $Module->Description, 'License' => $Module->License,
+        'Installed' => $Module->Installed));
+     else $this->Database->update('SystemModule', 'Name = "'.$Module->Name.'"', array(
+        'Version' => $Module->Version, 'Creator' => $Module->Creator, 
+        'Description' => $Module->Description, 'License' => $Module->License,
+        'Installed' => $Module->Installed));
+    }
+    
+    // Remove exceeding
+    foreach($Modules as $Module)    
+    if(!$this->ModularSystem->ModulePresent($Module['Name']))
+    {
+      DebugLog('Removing module '.$Module['Name'].' from list');
+      $this->Database->query('DELETE FROM `SystemModule` WHERE `Id` = '.$Module['Id']);
+    }   
+    
+    // Reload dependencies
+    $DbDependency = array();
+    $DbResult = $this->Database->query('SELECT * FROM `SystemModuleDependency`');
+    while($DbRow = $DbResult->fetch_assoc())
+      $DbDependency[$DbRow['Module']][] = $DbRow['DependencyModule'];
+    
+    foreach($this->ModularSystem->Modules as $Module)
+    {
+      // Add missing
+      foreach($Module->Dependencies as $Dependency)
+      {
+        if(!array_key_exists($Module->Id, $DbDependency) or
+        !in_array($this->ModularSystem->Modules[$Dependency]->Id, $DbDependency[$Module->Id]))
+        $this->Database->insert('SystemModuleDependency', array('Module' => $Module->Id, 
+          'DependencyModule' => $this->ModularSystem->Modules[$Dependency]->Id));        
+      }
+      
+      // Remove exceeding
+      if(array_key_exists($Module->Id, $DbDependency))
+      foreach($DbDependency[$Module->Id] as $Dep)
+      {
+        $DepModName = $this->ModularSystem->SearchModuleById($Dep);
+        if(!in_array($DepModName, $Module->Dependencies))
+        $this->Database->query('DELETE FROM `SystemModuleDependency` WHERE `Module` = '.
+          $Module->Id.' AND DependencyModule='.$Dep);
+      }      
+    }    
+  } 
 }