Changeset 737 for trunk/Common/Form/Form.php

Timestamp:

Apr 14, 2015, 10:16:16 PM (9 years ago)

Author:

chronos

Message:

• Added: Experimental models internal database structure regeneration.

File:

• trunk/Common/Form/Form.php (modified) (4 diffs)

trunk/Common/Form/Form.php

@@ -49 +49 @@
     ($this->FormManager->FormTypes[$Item['Type']]['Type'] != 'ManyToOne')))
     {
-      if(!array_key_exists($Index, $this->Values) and isset($Item['Default'])) 
+      if(!array_key_exists($Index, $this->Values) and isset($Item['Default']))
         $this->Values[$Index] = $Item['Default'];
     }
@@ -85 +85 @@
     );
     foreach($this->Definition['Items'] as $Index => $Item)
-    if(!array_key_exists('Hidden', $Item) or ($Item['Hidden'] == false)) 
+    if(!array_key_exists('Hidden', $Item) or ($Item['Hidden'] == false))
     if(!array_key_exists($Item['Type'], $this->FormManager->FormTypes) or
     (array_key_exists($Item['Type'], $this->FormManager->FormTypes) and
@@ -302 +302 @@
           $Parameters);
     }
-    } else 
+    } else
     {
       if(isset($Item['Default'])) {
@@ -418 +418 @@
     unset($this->FormTypes[$Name]);
   }
+
+  function UpdateSQLMeta()
+  {
+    $this->Database->query('DELETE FROM ModelField');
+    $this->Database->query('DELETE FROM Model');
+    $this->Database->query('DELETE FROM DataType WHERE Parent IS NOT NULL');
+    $this->Database->query('DELETE FROM DataType');
+
+    foreach($this->Type->TypeDefinitionList as $Name => $Type)
+    {
+      $DbResult = $this->Database->select('DataType', 'Id', 'Name="'.$Name.'"');
+      if($DbResult->num_rows == 0)
+      {
+        $this->Database->insert('DataType', array('Name' => $Name,
+          'Title' => $Type['Class']));
+      } else
+      {
+        $DbRow = $DbResult->fetch_assoc();
+        $this->Database->update('DataType', 'Id='.$DbRow['Id'], array('Name' => $Name,
+          'Title' => $Type['Class']));
+      }
+    }
+
+    foreach($this->Classes as $Class)
+    if(!array_key_exists('SQL', $Class) and ($Class['Table'] != ''))
+    {
+      $DbResult = $this->Database->query('SELECT * FROM information_schema.tables  WHERE table_schema = "centrala_big"
+          AND table_name = "'.$Class['Table'].'" LIMIT 1');
+      if($DbResult->num_rows == 0) continue;
+
+      echo($Class['Table'].'<br>');
+      $Module = 1;
+      $DbResult = $this->Database->select('Model', 'Id', 'Name="'.$Class['Table'].'"');
+      if($DbResult->num_rows == 0)
+      {
+        $this->Database->insert('Model', array('Name' => $Class['Table'], 'Title' => $Class['Title'], 'Module' => $Module));
+        $Model = $this->Database->insert_id;
+      } else
+      {
+        $DbRow = $DbResult->fetch_assoc();
+        $Model = $DbRow['Id'];
+        $this->Database->update('Model', 'Id='.$DbRow['Id'], array('Name' => $Class['Table'],
+          'Title' => $Class['Title'], 'Module' => $Module));
+      }
+
+      foreach($Class['Items'] as $Name => $Field)
+      {
+        echo($Name.', ');
+        $DbResult = $this->Database->select('DataType', 'Id', 'Name="'.$Field['Type'].'"');
+        if($DbResult->num_rows > 0)
+        {
+          $DbRow = $DbResult->fetch_assoc();
+          $Type = $DbRow['Id'];
+        } else {
+          $Type = $this->FormTypes[$Field['Type']];
+
+          // Search parent type
+          $DbResult = $this->Database->select('DataType', 'Id', 'Name="'.$Type['Type'].'"');
+          if($DbResult->num_rows > 0)
+          {
+            $DbRow = $DbResult->fetch_assoc();
+            $ParentType = $DbRow['Id'];
+          } else $ParentType = null;
+
+          $this->Database->insert('DataType', array('Name' => $Field['Type'],
+            'Title' => '', 'Parent' => $ParentType));
+          $Type = $this->Database->insert_id;
+        }
+
+        $DbResult = $this->Database->select('ModelField', 'Id', '(Name="'.$Name.'") AND (Model='.$Model.')');
+        if($DbResult->num_rows == 0)
+        {
+          $this->Database->insert('ModelField', array('Name' => $Name,
+            'Title' => $Field['Caption'], 'Model' => $Model, 'Type' => $Type));
+        } else
+        {
+          $DbRow = $DbResult->fetch_assoc();
+          $this->Database->update('ModelField', 'Id='.$DbRow['Id'], array('Name' => $Name,
+            'Title' => $Field['Caption'], 'Model' => $Model, 'Type' => $Type));
+        }
+      }
+      echo('<br>');
+    }
+  }
 }