76             // Raum-Arbeitsgruppen            

    77             if (is_array($pz["rag"]) && count($pz["rag"])>0)

    78             {

    79                 $arrag = $dbc -> queryObjectArray("SELECT rag_ID,CONCAT(abt_name,': ',rag_bez) AS rag 

    80                                                     FROM fhiiqm.RaumArb_Gruppe rag

    81                                                     LEFT OUTER JOIN Abteilung a ON rag.abt_ID=a.abt_ID

    82                                                     ORDER BY rag.abt_ID,rag_bez");

    83                 foreach ($arrag as $row)

    84                     $rag[$row->rag_ID] = $row->rag;

    85                 echo "<tr><td>betroffene Arbeitsgruppen: </td>";

    86                 $i=0;

    87                 $next = null;

    88                 foreach ($pz["rag"] as $ag)

    89                 { 

    90                     if ($next) $next ="<tr><td>&nbsp;</td>"; else $next =" ";

    91                     if ($pz["delag"][$i]) $stdel = "<span class='red'>&nbsp;GEL&Ouml;SCHT</span>"; else $stdel = "";

    92                     if ($ag > 0) echo "$next<td>".$rag[$pz["rag"][$i]]."$stdel</td></tr>\n";

    93                     $i++;

    94                 }

    95             }