Changeset 895 for trunk/Modules/System/System.php

Timestamp:

Jan 12, 2021, 10:29:50 PM (4 years ago)

Author:

chronos

Message:

• Modified: Setup is now AppModule and it is installed and stated as first module.
• Modified: Improved modular system.

File:

• trunk/Modules/System/System.php (modified) (6 diffs)

trunk/Modules/System/System.php

@@ -1 +1 @@
 <?php
+
+include_once(dirname(__FILE__).'/SystemModels.php');
 
 class PageModules extends Page
@@ -109 +111 @@
     $this->Description = 'Base system module';
     $this->Dependencies = array();
+    $this->SystemModule = true;
   }
 
@@ -115 +118 @@
     return array(UnitOfMeasure::GetClassName(), ActionIcon::GetClassName(), ActionGroup::GetClassName(),
       ActionType::GetClassName(), Action::GetClassName(), Language::GetClassName(), Country::GetClassName());
+  }
+
+  function DoBeforeInstall(): void
+  {
+    $this->Manager->OnInstallModel = array($this, 'InstallModel');
+    $this->Manager->OnUninstallModel = array($this, 'UninstallModel');
+  }
+
+  function DoAfterUninstall(): void
+  {
+    $this->Manager->OnInstallModel = null;
+    $this->Manager->OnUninstallModel = null;
   }
 
@@ -184 +199 @@
   function DoStart(): void
   {
+    $this->Manager->OnInstallModel = array($this, 'InstallModel');
+    $this->Manager->OnUninstallModel = array($this, 'UninstallModel');
+
     $this->System->RegisterPage(['module'], 'PageModules');
     $this->System->FormManager->RegisterClass('Action', array(
@@ -404 +422 @@
     //$this->Manager->OnModuleChange = array($this, 'ModuleChange');
     //$this->LoadFromDatabase();
+  }
+
+  function InstallModel(ModelDesc $ModelDesc)
+  {
+    $Query = "CREATE TABLE IF NOT EXISTS `".$ModelDesc->Name."` (\n";
+    $Query .= '  `'.$ModelDesc->PrimaryKey.'` int(11) NOT NULL AUTO_INCREMENT,'."\n";
+    foreach ($ModelDesc->Columns as $Column)
+    {
+      $Query .= "  `".$Column->Name."` ";
+      if ($Column->Type == ModelColumnType::Integer) $Query .= 'int(11)';
+      else if ($Column->Type == ModelColumnType::String) $Query .= 'varchar(255)';
+      else if ($Column->Type == ModelColumnType::Float) $Query .= 'varchar(255)';
+      else if ($Column->Type == ModelColumnType::Text) $Query .= 'text';
+      else if ($Column->Type == ModelColumnType::DateTime) $Query .= 'datetime';
+      else if ($Column->Type == ModelColumnType::Reference) $Query .= 'int(11)';
+      else if ($Column->Type == ModelColumnType::Boolean) $Query .= 'tinyint(1)';
+      else if ($Column->Type == ModelColumnType::Date) $Query .= 'date';
+      else if ($Column->Type == ModelColumnType::BigInt) $Query .= 'bigint(20)';
+      else if ($Column->Type == ModelColumnType::Enum)
+      {
+        $Query .= 'enum("'.implode('", "', $Column->States).'")';
+      }
+
+      if ($Column->Nullable) $Query .= '';
+        else $Query .= ' NOT NULL';
+
+      $Query .= ' COLLATE utf8_general_ci';
+
+      if ($Column->HasDefault)
+      {
+        if ($Column->Default == null)
+          $Query .= ' DEFAULT NULL';
+        else $Query .= ' DEFAULT '.$Column->GetDefault();
+      }
+      $Query .= ",\n";
+    }
+    $Query .= '  PRIMARY KEY (`'.$ModelDesc->PrimaryKey.'`)';
+    foreach ($ModelDesc->Columns as $Column)
+    {
+      if ($Column->Type == ModelColumnType::Reference)
+        $Query .= ','."\n".'  KEY `'.$Column->Name.'` (`'.$Column->Name.'`)';
+      else if ($Column->Unique)
+        $Query .= ','."\n".'  UNIQUE KEY `'.$Column->Name.'` (`'.$Column->Name.'`)';
+    }
+    $Query .= "\n";
+
+    if ($ModelDesc->Memory) $Engine = 'MEMORY';
+      else $Engine = 'InnoDB';
+    $Query .= ') ENGINE='.$Engine.' DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;';
+    $I = 1;
+    foreach ($ModelDesc->Columns as $Column)
+    {
+      if ($Column->Type == ModelColumnType::Reference)
+        $Query .= "ALTER TABLE `".$ModelDesc->Name."` ".
+        "ADD CONSTRAINT `".$ModelDesc->Name."_ibfk_".$I."` FOREIGN KEY (`".$Column->Name."`) REFERENCES `".$Column->RefTable."` (`Id`);";
+      $I++;
+    }
+    $this->Database->query($Query);
+  }
+
+  function UninstallModel(ModelDesc $ModelDesc)
+  {
+    $this->Database->query('DROP TABLE IF EXISTS `'.$ModelDesc->Name.'`');
   }
 
@@ -544 +625 @@
   }
 }
-
-class UnitOfMeasure extends Model
-{
-  static function GetDesc(): ModelDesc
-  {
-    $Desc = new ModelDesc(self::GetClassName());
-    $Desc->AddString('Name');
-    $Desc->AddString('Unit');
-    return $Desc;
-  }
-}
-
-class Action extends Model
-{
-  static function GetDesc(): ModelDesc
-  {
-    $Desc = new ModelDesc(self::GetClassName());
-    $Desc->AddString('Title');
-    $Desc->AddString('URL');
-    $Desc->AddReference('Icon', ActionIcon::GetClassName());
-    $Desc->AddReference('Type', ActionType::GetClassName());
-    $Desc->AddReference('Group', ActionGroup::GetClassName());
-    $Desc->AddReference('PermissionOperation', PermissionOperation::GetClassName());
-    $Desc->AddBoolean('Enable');
-    return $Desc;
-  }
-}
-
-class ActionIcon extends Model
-{
-  static function GetDesc(): ModelDesc
-  {
-    $Desc = new ModelDesc(self::GetClassName());
-    $Desc->AddString('Name');
-    return $Desc;
-  }
-}
-
-class ActionGroup extends Model
-{
-  static function GetDesc(): ModelDesc
-  {
-    $Desc = new ModelDesc(self::GetClassName());
-    $Desc->AddString('Name');
-    return $Desc;
-  }
-}
-
-class ActionType extends Model
-{
-  static function GetDesc(): ModelDesc
-  {
-    $Desc = new ModelDesc(self::GetClassName());
-    $Desc->AddString('Name');
-    return $Desc;
-  }
-}
-
-class Language extends Model
-{
-  static function GetDesc(): ModelDesc
-  {
-    $Desc = new ModelDesc(self::GetClassName());
-    $Desc->AddString('Name');
-    return $Desc;
-  }
-}
-
-class Country extends Model
-{
-  static function GetDesc(): ModelDesc
-  {
-    $Desc = new ModelDesc(self::GetClassName());
-    $Desc->AddString('Name');
-    return $Desc;
-  }
-}
-