DataObjects/core.sql

[Pman.Core] / DataObjects / Companies.php

diff --git a/DataObjects/Companies.php b/DataObjects/Companies.php
index 5c2efd9..163e131 100644 (file)
--- a/DataObjects/Companies.php
+++ b/DataObjects/Companies.php
@@ -86,7 +86,7 @@ class Pman_Core_DataObjects_Companies extends DB_DataObject
             
             
         }
-        
+        // ADD comptype_display name.. = for combos..
         $this->selectAdd("
             (SELECT display_name
                 FROM
@@ -95,11 +95,13 @@ class Pman_Core_DataObjects_Companies extends DB_DataObject
                     etype='comptype'
                     AND
                     name={$tn}.comptype
-            ) as comptype_display_name
+                LIMIT 1
+                ) as comptype_display_name
         ");
         
          
     }
+    
     function toEventString() {
         return $this->name;
     }
@@ -317,5 +319,19 @@ class Pman_Core_DataObjects_Companies extends DB_DataObject
         return $ret;
     }
     
+    function initCompanies($roo, $name, $type)
+    {
+        $companies = DB_DataObject::factory('companies');
+        $companies->setFrom(array(
+            'name' => $name,
+            'comptype' => $type,
+            'background_color' => '',
+            'created_dt' => $this->sqlValue('NOW()'),
+            'updated_dt' => $this->sqlValue('NOW()')
+        ));
+        
+        $companies->insert();
+        $companies->onInsert(array(), $roo);
+    }
     
 }