if (!isset($_SERVER['PHP_AUTH_USER'])) {
$this->h401();
}
- $u = DB_DataObject::factory('Person');
+ $u = DB_DataObject::factory('core_person');
//$u->active = 1;
$u->whereAdd('LENGTH(passwd) > 1');
//$u->company_id = $this->company->id;
if (!$this->projectPerm($r->project_id, 'MTrack.Issue', 'S')) {
$this->jerr("no perms");
}
- DB_DAtaObject::DebugLevel(1);
+ //DB_DAtaObject::DebugLevel(1);
$t = DB_DataObject::Factory('mtrack_ticket');
$t->autoJoin();
- $t->whereAdd("join_status_id.name = 'open'");
+ $t->whereAdd("join_status_id.name IN ( 'open', 'new')");
$t->project_id = $r->project_id;
// only need id / name / status?
//$ar = $t->fetchAll('id', ');
$t->selectAdd();
- $t->selectAdd('mtrack_ticket.id as id , mtrack_ticket.summary as summary');
- $ar = $t->fetchAll('id','summary');
+ $t->selectAdd('
+ mtrack_ticket.id as id ,
+ mtrack_ticket.summary as summary,
+ mtrack_ticket.description as description
+ ');
+
+ $t->find();
+ $ret = array();
+ while ($t->fetch()) {
+ $ret[] = $t->toArray('%s', 0);
+ }
+
// print_R($ar);
- $this->jok($ar);
+ $this->jok($ret);
$this->jok("WORKED!");
}