*/
function projects($au)
{
- $c = clone ($this);
if (empty($au)) {
$p = DB_DataObject::Factory('Projects');
$p->get('code', '*PUBLIC');
return array($p->id);
}
+ $c = clone ($this);
if (is_array($au)) {
$c->whereAddIn('person_id', $au, 'int');
} 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');
}
/**
function people($pr)
{
$c = clone ($this);
+ echo '<PRE>';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');