web/ticket.php
authorAlan Knowles <alan@akbkhome.com>
Wed, 26 Jan 2011 09:42:19 +0000 (17:42 +0800)
committerAlan Knowles <alan@akbkhome.com>
Wed, 26 Jan 2011 09:42:19 +0000 (17:42 +0800)
web/ticket.php

index 57d55c0..1878292 100644 (file)
@@ -932,12 +932,22 @@ function renderEditForm($issue, $params = array())
   $allowed['resolution'] = $R->enumerate();
 
   $r = array();
-  foreach (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 (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')
       ->fetchAll(PDO::FETCH_NUM) as $row) {
+          
     if (strlen($row[2])) {
       $row[1] .= " ($row[2])";
     }
     $r[$row[0]] = $row[1];
+    
   }
   $allowed['component'] = $r;