X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=DataObjects%2FProjectDirectory.php;h=d2c5733b2945736dcf30535495e05e264327ecfa;hb=9480b120292c4042b39fad88d35c92f627fed3ab;hp=3660c28b56bbe698bf3ce485cf5de47b35cdcb87;hpb=aa4dfb112ccfab4b4844e69665ec02c901660729;p=Pman.Core diff --git a/DataObjects/ProjectDirectory.php b/DataObjects/ProjectDirectory.php index 3660c28b..d2c5733b 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,12 +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');
         return $c->fetchAll('person_id');