Changeset 400 for trunk/temp/MakeOpenERP.php

Timestamp:

Mar 27, 2012, 4:11:51 PM (13 years ago)

Author:

chronos

Message:

• Upraveno: Vylepšeno generování modulu pro OpenERP.

File:

• trunk/temp/MakeOpenERP.php (modified) (4 diffs)

trunk/temp/MakeOpenERP.php

@@ -37 +37 @@
 
 $Database->select_db('information_schema');
+
+// Load all constraints
+$Constraints = array();
+$DbResult = $Database->query('SELECT * FROM `KEY_COLUMN_USAGE` WHERE `TABLE_SCHEMA` = "centrala" AND 
+    `REFERENCED_TABLE_NAME` IS NOT NULL');
+while($DbRow = $DbResult->fetch_assoc())
+{    
+  $Constraints[strtolower($DbRow['TABLE_NAME'].'.'.$DbRow['COLUMN_NAME'])] = 
+    strtolower($DbRow['REFERENCED_TABLE_NAME'].'.'.$DbRow['REFERENCED_COLUMN_NAME']);
+}
+
 $DbResult = $Database->query('SELECT * FROM `TABLES` WHERE `TABLE_SCHEMA` = "centrala"');
 while($DbRow = $DbResult->fetch_assoc())
@@ -53 +64 @@
     $Type = $DbRow2['DATA_TYPE'];
     $Name = $DbRow2['COLUMN_NAME'];
-  
-    $ColDef = "    '".$Name."': fields.";
+    if($Name != 'Id')
+    {
+    $ColDef = "    '".strtolower($Name)."': fields.";
     if($Type == 'varchar')
      $ColDef .= "char('".$Name."', size=".$DbRow2['CHARACTER_MAXIMUM_LENGTH'].", translate=True";
@@ -61 +73 @@
     else if($Type == 'date')
      $ColDef .= "date('".$DbRow2['COLUMN_NAME']."'";
-    else if($Type == 'int')
-     $ColDef .= "integer('".$DbRow2['COLUMN_NAME']."'";
-    else if($Type == 'tinyint')
-     $ColDef .= "integer('".$DbRow2['COLUMN_NAME']."'";
-    else if($Type == 'smallint')
-     $ColDef .= "integer('".$DbRow2['COLUMN_NAME']."'";
+    else if(($Type == 'int') or ($Type == 'tinyint') or ($Type == 'smallint'))
+    {
+      if(array_key_exists(strtolower($DbRow2['TABLE_NAME'].'.'.$DbRow2['COLUMN_NAME']), $Constraints))
+      {
+        $Constraint = $Constraints[strtolower($DbRow2['TABLE_NAME'].'.'.$DbRow2['COLUMN_NAME'])];
+        $SourceTable = substr($Constraint, 0, strpos($Constraint, '.'));
+        $SourceColumn = substr($Constraint, strpos($Constraint, '.') + 1);
+        $ColDef .= "many2one('centrala.".$SourceTable."', '".$DbRow2['COLUMN_NAME']."'";
+      } else
+       $ColDef .= "integer('".$DbRow2['COLUMN_NAME']."'";
+    }
     else if($Type == 'enum')
      $ColDef .= "integer('".$DbRow2['COLUMN_NAME']."'";
@@ -78 +95 @@
      $ColDef .= "float('".$DbRow2['COLUMN_NAME']."', digits=(12,6)";
     else echo('Neznamy typ '.$Type);
+    $ColDef .= "),\n";
+    $ModelColumns .= $ColDef;
+      $ViewTreeItems .= "\n".'          <field name="'.strtolower($Name).'" select="1"/>';
+      $ViewFormItems .= "\n".'          <field name="'.strtolower($Name).'" select="1"/>';
+    }
+  }
+  // Add one2many relations
+  foreach($Constraints as $Index => $Item)
+  {
+    //echo($Item.'='.strtolower($DbRow['TABLE_NAME']).'.Id ');
+    if($Item == strtolower($DbRow['TABLE_NAME']).'.id')     
+    {
+      $SourceTable = substr($Index, 0, strpos($Index, '.'));
+      $SourceColumn = substr($Index, strpos($Index, '.') + 1);
+      $ColDef = "    '".strtolower($SourceTable.'_ids')."': fields.";
+        $ColDef .= "one2many('centrala.".$SourceTable."', '".$SourceColumn."', '".$SourceTable."'";         
+      $ColDef .= "),\n";
+      $ModelColumns .= $ColDef;
+      $ViewFormItems .= "\n".'          <field name="'.strtolower($SourceTable.'_ids').'" select="1"/>';
+    }
+  }
     
-    $ColDef .= "),\n";
-    $ViewTreeItems .= "\n".'          <field name="'.$Name.'" select="1"/>';
-    $ViewFormItems .= "\n".'          <field name="'.$Name.'" select="1"/>';
-    $ModelColumns .= $ColDef;
-  }
   $ModuleView .= '
     <record model="ir.actions.act_window" id="action_'.$TableName.'_form">