X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=DataObjects%2FProjectDirectory.php;h=471269a81a6342bba7632c871fee1ed002a5dcba;hb=5a4e5c1dc7b96c1d46cb0be649648c104ecb50a9;hp=05820a9faf536ea6b45410a70710e94c91ea25c3;hpb=bc9dbb3497007a4ca376f413780094a6d773fc0b;p=Pman.Core diff --git a/DataObjects/ProjectDirectory.php b/DataObjects/ProjectDirectory.php index 05820a9f..471269a8 100644 --- a/DataObjects/ProjectDirectory.php +++ b/DataObjects/ProjectDirectory.php @@ -81,6 +81,9 @@ class Pman_Core_DataObjects_ProjectDirectory extends DB_DataObject } else { $c->person_id = $au->id; } + $c->selectAdd(); + // people may have multiple roles for a project.. + $c->selectAdd('distinct(project_id) as project_id'); return $c->fetchAll('project_id'); } /** @@ -91,11 +94,15 @@ class Pman_Core_DataObjects_ProjectDirectory extends DB_DataObject function people($pr) { $c = clone ($this); + echo '
';print_R($this);exit;
+        $c->autoJoin();
         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');