X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=DataObjects%2FProjectDirectory.php;h=eeb4668322d58057f9520913c7aa132ec66edf54;hb=1f540122de2c9fab4bd2d42775dd3831fe383192;hp=1b66c92e85e99f52d4b8464c15a3c0e687b34be6;hpb=264526c8ebfeeb5afe9661000b73c717ec4c36ca;p=Pman.Core diff --git a/DataObjects/ProjectDirectory.php b/DataObjects/ProjectDirectory.php index 1b66c92e..eeb46683 100644 --- a/DataObjects/ProjectDirectory.php +++ b/DataObjects/ProjectDirectory.php @@ -83,7 +83,7 @@ class Pman_Core_DataObjects_ProjectDirectory extends DB_DataObject } $c->selectAdd(); // people may have multiple roles for a project.. - $c->selectAdd('distinct(project_id) as project_id'); + $c->selectAdd("distinct({$this->tableName()}.project_id) as project_id"); return $c->fetchAll('project_id'); } /** @@ -94,14 +94,15 @@ class Pman_Core_DataObjects_ProjectDirectory extends DB_DataObject function people($pr) { $c = clone ($this); - $c->autoJoin(); + //echo '
';print_R($this);exit;
+        
         if (is_array($pr)) {
             $c->whereAddIn('project_id', $pr, 'int');
         } else {
             $c->project_id = $pr->id;
         }
         $c->selectAdd();
-        $c->selectAdd('person_id)';
+        $c->selectAdd("{$this->tableName()}.person_id as person_id");
         return $c->fetchAll('person_id');