Changeset 373 for trunk/Common/Model.php

Timestamp:

Jan 19, 2012, 9:43:36 PM (13 years ago)

Author:

chronos

Message:

• Přidáno: Různé knihovny pro zpracování HTML kódu, tabulek, stránkování, zasílání emailů, aj.
• Přidáno: Kód zpracování fronty emailů přesunut z Global do modulu EmailQueue.

File:

• trunk/Common/Model.php (modified) (2 diffs)

trunk/Common/Model.php

@@ -147 +147 @@
   function Install()
   {
+    $this->Database->insert('SystemModel', array('Name' => $this->Name, 'Module' => $this->Module->Id));
+    $this->Id = $this->Database->insert_id;
+    
     $Query = 'CREATE TABLE IF NOT EXISTS `'.$this->Name.'` ('.
       '`Id` int(11) NOT NULL AUTO_INCREMENT,';
     foreach($this->Properties as $Property)
     {
+      $this->Database->insert('SystemModelProperty', array('Name' => $Property['Name'], 
+        'Model' => $this->Id, 'Type' => $Property['Type']));
       if($Property['Type'] == PropertyDateTime) 
         $Query .= '`'.$Property['Name'].'` DATETIME NOT NULL,';
@@ -159 +164 @@
       else if($Property['Type'] == PropertyString) 
         $Query .= '`'.$Property['Name'].'` VARCHAR(255) COLLATE utf8_general_ci NOT NULL,';
-      else if($Property['Type'] == PropertyText) 
+      else if($Property['Type'] == PropertyText8) 
+        $Query .= '`'.$Property['Name'].'` TINYTEXT COLLATE utf8_general_ci NOT NULL,';
+      else if($Property['Type'] == PropertyText16) 
         $Query .= '`'.$Property['Name'].'` TEXT COLLATE utf8_general_ci NOT NULL,';
-      else if($Property['Type'] == PropertyInteger) 
+      else if($Property['Type'] == PropertyText24) 
+        $Query .= '`'.$Property['Name'].'` MEDIUMTEXT COLLATE utf8_general_ci NOT NULL,';
+      else if($Property['Type'] == PropertyText32) 
+        $Query .= '`'.$Property['Name'].'` LONGTEXT COLLATE utf8_general_ci NOT NULL,';
+      else if($Property['Type'] == PropertyInteger8) 
+        $Query .= '`'.$Property['Name'].'` TINYINT(4) NOT NULL,';
+      else if($Property['Type'] == PropertyInteger16) 
+        $Query .= '`'.$Property['Name'].'` SMALLINT(6) NOT NULL,';
+      else if($Property['Type'] == PropertyInteger24) 
+        $Query .= '`'.$Property['Name'].'` MEDIUMINT(9) NOT NULL,';
+      else if($Property['Type'] == PropertyInteger32) 
         $Query .= '`'.$Property['Name'].'` INT(11) NOT NULL,';
+      else if($Property['Type'] == PropertyInteger64) 
+        $Query .= '`'.$Property['Name'].'` BIGINT(20) NOT NULL,';
       else if($Property['Type'] == PropertyBoolean) 
-        $Query .= '`'.$Property['Name'].'` INT(11) NOT NULL,';
+        $Query .= '`'.$Property['Name'].'` BOOLEAN NOT NULL,';
       else if($Property['Type'] == PropertyFloat) 
         $Query .= '`'.$Property['Name'].'` FLOAT NOT NULL,';
+      else if($Property['Type'] == PropertyDouble) 
+        $Query .= '`'.$Property['Name'].'` DOUBLE NOT NULL,';
       else if($Property['Type'] == PropertyOneToMany) 
         $Query .= '`'.$Property['Name'].'` INT(255) NOT NULL,'.