}
- $d = DB_DataObject::factory('mtrack_project_components');
- $d->
-
- $r = array();
- $q = MTrackDB::q('
- select c.compid, c.name, p.name
- from components c
- left join components_by_project cbp on (c.compid = cbp.compid)
- left join projects p on (cbp.projid = p.projid)
- where
- deleted <> 1
- order by
- c.name');
-
- foreach ($q->fetchAll(PDO::FETCH_NUM) as $row) {
-
- $r[$row[0]] = strlen($row[2]) ? $row[1] . " ($row[2])" : $row[1];
-
+ if ($this->issue->project_id);
+ $d = DB_DataObject::factory('mtrack_project_components');
+ $d->project_id = $this->issue->project_id;
+ $d->orderBy('name');
+ $d->whereAdd('deleted != 1');
+ $this->elements['component[]'] = new HTML_Template_Flexy_Element('select');
+ $this->elements['component[]']->setOptions($d->fetchAll('id', 'name'));
+ $ar = $this->issue->components();
+ $this->elements['component[]']->setValue(array_keys($ar));
+
}
// print_r($r);