diff -r 6f4b105daa24 -r 9c668cd391fa fhiiqm/inc/prozess_dat_show.inc.php
--- a/fhiiqm/inc/prozess_dat_show.inc.php	Thu Sep 12 09:04:56 2013 +0200
+++ b/fhiiqm/inc/prozess_dat_show.inc.php	Fri Dec 20 15:19:32 2013 +0100
@@ -1,81 +1,101 @@
-<?php
-
-/**
- * @author Bettina Schwarzer, Fritz-Haber-Institut
- * @copyright 03/2012
- * 
- * Anlisten Prozess - INDERT/UPDATE - Daten
- */
-
-
-            echo "<table>\n";
-            echo "<tr><td>Prozess-Bezeichnung: </td><td>" . $pz["bez"] . "<td></td></tr>\n";
-            echo "<tr><td>Prozess-Beschreibung: </td><td>" . nl2br($pz["bezl"]) . "<td></td></tr>\n";
-            // Produkt
-            $prod = $dbc->querySingleItem("SELECT prod_name FROM Produkt WHERE produkt_ID = ".$pz["prid"]);
-            echo "<tr><td>zu Produkt: </td><td>$prod<td></td></tr>\n";
-            // Auftraggeber
-            $aname = $dbc -> querySingleItem("SELECT CONCAT(nachname,', ',vorname) FROM Mitarbeiter WHERE persknr = " .$pz["persknra"]);
-            echo "<tr><td>Auftraggeber: </td><td>$aname<td></td></tr>\n";
-            // Verantwortlicherer
-            $vname = $dbc -> querySingleItem("SELECT CONCAT(nachname,', ',vorname) FROM Mitarbeiter WHERE persknr = " .$pz["persknr"]);
-            echo "<tr><td>Verantwortlicher: </td><td>$vname<td></td></tr>\n";
-            // zu Prozess
-            if ($pz['pzref'])
-            {
-                $prozref = $dbc -> querySingleItem("SELECT proz_bez FROM Prozess WHERE proz_ID = " .$pz['pzref']);
-                echo "<tr><td>geh&ouml;rt zu Prozess: </td><td>$prozref<td></td></tr>\n";
-            }
-            // Datums
-            if ($pz["psdat"])
-                {$sdat = new DateTime($pz["psdat"]); $sdat = $sdat->format("d.m.Y");}
-            else $sdat = "&nbsp;";
-            echo "<tr><td>Plan Startdatum: </td><td>$sdat</td></tr>\n";
-            if ($pz["pedat"])
-                {$sdat = new DateTime($pz["pedat"]); $sdat = $sdat->format("d.m.Y");}
-            else $sdat = "&nbsp;";
-            echo "<tr><td>Plan Enddatum: </td><td>$sdat</td></tr>\n";
-            echo "<tr><td>Plan Kosten: </td><td>".number_format($pz["pkost"],2,",",".")." &euro;</td></tr>\n";
-            if ($pz["sdat"])
-                {$sdat = new DateTime($pz["sdat"]); $sdat = $sdat->format("d.m.Y");}
-            else $sdat = "&nbsp;";
-            echo "<tr><td>Startdatum: </td><td>$sdat</td></tr>\n";
-            if ($pz["edat"])
-                {$sdat = new DateTime($pz["edat"]); $sdat = $sdat->format("d.m.Y");}
-            else $sdat = "&nbsp;";
-            echo "<tr><td>Enddatum: </td><td>$sdat</td></tr>\n";
-            echo "<tr><td>Kosten: </td><td>".number_format($pz["kost"],2,",",".")." &euro;</td></tr>\n";
-            // Arbeitsschritte
-            if (is_array($pz["step"]))
-            {
-                $arrstat = $dbc -> queryObjectArray("SELECT proz_stat_ID,proz_stat_bez FROM Proz_Status");
-                foreach ($arrstat as $row)
-                    $as[$row->proz_stat_ID] = $row->proz_stat_bez;
-                echo "<tr><td>Arbeitsschritte: </td>";
-                $i=0;
-                foreach ($pz["step"] as $step)
-                { 
-                    if ($next) $next ="<tr><td>&nbsp;</td>"; else $next =" ";
-                    if ($pz["del"][$i]) $stdel = "<span class='red'>&nbsp;GEL&Ouml;SCHT</span>"; else $stdel = "";
-                    if ($step) echo "$next<td>(".$pz["sort"][$i].")&nbsp;$step;&nbsp;<i>".$as[$pz["ststat"][$i]]."</i>;&nbsp;" .$pz["stbem"][$i]."$stdel</td></tr>\n";
-                    $i++;
-                }
-            }
-            // Dringlichkeit
-            if ($pz["urg"])
-            {
-                $urg = $dbc -> querySingleItem("SELECT proz_urg_bez FROM Proz_Dringlichkeit WHERE proz_urg_ID=".$pz["urg"]);
-                echo "<tr><td>Dringlichkeit: </td><td>$urg<td></td></tr>\n";                
-            }
-            // Status
-            if ($pz["stat"])
-            {
-                $stat = $dbc -> querySingleItem("SELECT proz_stat_bez FROM Proz_Status WHERE proz_stat_ID=".$pz["stat"]);
-                echo "<tr><td>Status: </td><td>$stat<td></td></tr>\n";                
-            }
-            // Bemerkung
-            if ($pz["bem"])
-                echo "<tr><td>Bemerkung: </td><td>" . nl2br($pz["bem"]) . "<td></td></tr>\n";
-            echo "</table>\n";
-
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 03/2012
+ * 
+ * Anlisten Prozess - INDERT/UPDATE - Daten
+ */
+
+
+            echo "<table>\n";
+            echo "<tr><td>Prozess-Bezeichnung: </td><td>" . $pz["bez"] . "<td></td></tr>\n";
+            echo "<tr><td>Prozess-Beschreibung: </td><td>" . nl2br($pz["bezl"]) . "<td></td></tr>\n";
+            // Produkt
+            $prod = $dbc->querySingleItem("SELECT prod_name FROM Produkt WHERE produkt_ID = ".$pz["prid"]);
+            echo "<tr><td>zu Produkt: </td><td>$prod<td></td></tr>\n";
+            // Auftraggeber
+            $aname = $dbc -> querySingleItem("SELECT CONCAT(nachname,', ',vorname) FROM Mitarbeiter WHERE persknr = " .$pz["persknra"]);
+            echo "<tr><td>Auftraggeber: </td><td>$aname<td></td></tr>\n";
+            // Verantwortlicherer
+            $vname = $dbc -> querySingleItem("SELECT CONCAT(nachname,', ',vorname) FROM Mitarbeiter WHERE persknr = " .$pz["persknr"]);
+            echo "<tr><td>Verantwortlicher: </td><td>$vname<td></td></tr>\n";
+            // zu Prozess
+            if ($pz['pzref'])
+            {
+                $prozref = $dbc -> querySingleItem("SELECT proz_bez FROM Prozess WHERE proz_ID = " .$pz['pzref']);
+                echo "<tr><td>geh&ouml;rt zu Prozess: </td><td>$prozref<td></td></tr>\n";
+            }
+            // Datums
+            if ($pz["psdat"])
+                {$sdat = new DateTime($pz["psdat"]); $sdat = $sdat->format("d.m.Y");}
+            else $sdat = "&nbsp;";
+            echo "<tr><td>Plan Startdatum: </td><td>$sdat</td></tr>\n";
+            if ($pz["pedat"])
+                {$sdat = new DateTime($pz["pedat"]); $sdat = $sdat->format("d.m.Y");}
+            else $sdat = "&nbsp;";
+            echo "<tr><td>Plan Enddatum: </td><td>$sdat</td></tr>\n";
+            echo "<tr><td>Plan Kosten: </td><td>".number_format($pz["pkost"],2,",",".")." &euro;</td></tr>\n";
+            if ($pz["sdat"])
+                {$sdat = new DateTime($pz["sdat"]); $sdat = $sdat->format("d.m.Y");}
+            else $sdat = "&nbsp;";
+            echo "<tr><td>Startdatum: </td><td>$sdat</td></tr>\n";
+            if ($pz["edat"])
+                {$sdat = new DateTime($pz["edat"]); $sdat = $sdat->format("d.m.Y");}
+            else $sdat = "&nbsp;";
+            echo "<tr><td>Enddatum: </td><td>$sdat</td></tr>\n";
+            echo "<tr><td>Kosten: </td><td>".number_format($pz["kost"],2,",",".")." &euro;</td></tr>\n";
+            // Arbeitsschritte
+            if (is_array($pz["step"]))
+            {
+                $arrstat = $dbc -> queryObjectArray("SELECT proz_stat_ID,proz_stat_bez FROM Proz_Status");
+                foreach ($arrstat as $row)
+                    $as[$row->proz_stat_ID] = $row->proz_stat_bez;
+                echo "<tr><td>Arbeitsschritte: </td>";
+                $i=0;
+                foreach ($pz["step"] as $step)
+                { 
+                    if ($next) $next ="<tr><td>&nbsp;</td>"; else $next =" ";
+                    if ($pz["del"][$i]) $stdel = "<span class='red'>&nbsp;GEL&Ouml;SCHT</span>"; else $stdel = "";
+                    if ($step) echo "$next<td>(".$pz["sort"][$i].")&nbsp;$step;&nbsp;<i>".$as[$pz["ststat"][$i]]."</i>;&nbsp;" .$pz["stbem"][$i]."$stdel</td></tr>\n";
+                    $i++;
+                }
+            }
+            // Dringlichkeit
+            if ($pz["urg"])
+            {
+                $urg = $dbc -> querySingleItem("SELECT proz_urg_bez FROM Proz_Dringlichkeit WHERE proz_urg_ID=".$pz["urg"]);
+                echo "<tr><td>Dringlichkeit: </td><td>$urg<td></td></tr>\n";                
+            }
+            // Status
+            if ($pz["stat"])
+            {
+                $stat = $dbc -> querySingleItem("SELECT proz_stat_bez FROM Proz_Status WHERE proz_stat_ID=".$pz["stat"]);
+                echo "<tr><td>Status: </td><td>$stat<td></td></tr>\n";                
+            }
+            // Raum-Arbeitsgruppen            
+            if (is_array($pz["rag"]) && count($pz["rag"])>0)
+            {
+                $arrag = $dbc -> queryObjectArray("SELECT rag_ID,CONCAT(abt_name,': ',rag_bez) AS rag 
+                                                    FROM fhiiqm.RaumArb_Gruppe rag
+                                                    LEFT OUTER JOIN Abteilung a ON rag.abt_ID=a.abt_ID
+                                                    ORDER BY rag.abt_ID,rag_bez");
+                foreach ($arrag as $row)
+                    $rag[$row->rag_ID] = $row->rag;
+                echo "<tr><td>betroffene Arbeitsgruppen: </td>";
+                $i=0;
+                $next = null;
+                foreach ($pz["rag"] as $ag)
+                { 
+                    if ($next) $next ="<tr><td>&nbsp;</td>"; else $next =" ";
+                    if ($pz["delag"][$i]) $stdel = "<span class='red'>&nbsp;GEL&Ouml;SCHT</span>"; else $stdel = "";
+                    if ($ag > 0) echo "$next<td>".$rag[$pz["rag"][$i]]."$stdel</td></tr>\n";
+                    $i++;
+                }
+            }
+            // Bemerkung
+            if ($pz["bem"])
+                echo "<tr><td>Bemerkung: </td><td>" . nl2br($pz["bem"]) . "<td></td></tr>\n";
+            echo "</table>\n";
+
 ?>
\ No newline at end of file