diff -r 9c668cd391fa -r cfc409017ba8 fhiiqm/form/prozess_rag_form.inc.php
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/form/prozess_rag_form.inc.php	Fri Jan 17 08:50:55 2014 +0100
@@ -0,0 +1,381 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 03/2012
+ * 
+ * Form Prozess
+ * 
+ */
+
+	include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+	if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+    $okn = true;
+
+
+    echo "<div align=\"center\">";
+
+?>
+<h5>* - Felder sind erforderlich!</h5>
+</div>
+<!-- <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_svc"> -->	
+<form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="multipart/form-data" name="form_info" target="_self"> 	
+<div align="center">
+<table width="60%" border="0" cellspacing="3" cellpadding="3">
+    <tr>
+        <td>Projekt-Bezeichnung *</td>
+        <td><input name="pz[bez]" id="bez" type="text" size="50" maxlength="50" value="<?php echo $pz['bez']; ?>" />
+        <?php
+			if (isset($pz['bez']) && $pz['bez']<'!')
+			{
+					echo "<br><span class=\"red\">Projektbezeichnung ist erforderlich!</span>\n";
+					$okn = false;
+			}
+            if ($pzid)
+            { 
+                echo "&nbsp;&nbsp;&nbsp;Projekt-ID";
+                echo "&nbsp;&nbsp;&nbsp;<input class='read right' name='pz[pzid]' type='text' size='5' value='" .$pz['pzid']."' readonly='readonly' />"; 
+            }
+		?>
+		</td>
+    </tr>
+    <tr>
+        <td>Projekt-Beschreibung</td>
+        <td><textarea name="pz[bezl]" cols="80" rows="3"><?php echo $pz["bezl"]; ?></textarea>
+        </td>
+    </tr>
+    <tr>
+        <td>zugeordnet zu Produkt *</td>
+        <td>
+            <select name="pz[prid]" size="1">
+            <?php 
+                if (is_array($pz['prid'])) $select = in_array( "-1", $pz['prid'] ) ? ' selected' : null;
+                echo "<option $select value=\"-1\"></option>\n";
+/*                $sql = "SELECT DISTINCT ip.produkt_ID,prod_name
+                    	FROM Info i LEFT OUTER JOIN Info_Produkt ip 
+                    	ON i.info_ID=ip.info_ID LEFT OUTER JOIN Info_Verantwortlich v
+                    	ON i.info_ID=v.info_ID INNER JOIN Produkt p
+                    	ON ip.produkt_ID=p.produkt_ID INNER JOIN Mitarbeiter m
+                    	ON v.persknr=m.persknr
+                    	WHERE i.infotyp_ID=6 and v.persknr=$persknr
+                    	ORDER BY ip.produkt_ID";
+                if ($result = $dbc->queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                    {
+                        if (strlen($row->prod_name) > 70) 
+                            $prod=str_replace(" ","&nbsp;",htmlentities(substr($row->prod_name,0,70))) ."..."; 
+                        else 
+                            $prod=str_replace(" ","&nbsp;",htmlentities($row->prod_name));
+                        $select = ($row->produkt_ID == $pz['prid'] && $pz['prid']>0) ? ' selected' : null;
+                        echo "<option $select value=\"$row->produkt_ID\">$prod</option>\n";
+                    }
+                }
+*/
+                // Recht Produktgruppe beruecksichtigen
+                if (is_array($_SESSION["prodg"]))
+                {
+                        foreach ($_SESSION["prodg"] as $val)
+                            $listg .= "," .$val;
+                        $listg = substr($listg,1);
+                        echo "prodg = $listg<br />";
+                        $sql = "CALL fhiiqm.hier_prodgroup('$listg')";                
+                }
+                else
+                    $sql = "CALL fhiiqm.prod_hiera_all(0,0)";  
+                if ($result = $dbc->queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                    {
+                        if (strlen($row->bez) > 70) 
+                            $prod=str_replace(" ","&nbsp;",htmlentities(substr($row->bez,0,70))) ."..."; 
+                        else 
+                            $prod=str_replace(" ","&nbsp;",htmlentities($row->bez));
+                        if ($row->prid >0) $color=" class='green'"; else $color="";
+                        if ($row->prid == $pz['prid'])
+    					   echo "<option $color selected value=\"$row->prid\">$prod</option>\n";
+    				    else
+    					   echo "<option $color value=\"$row->prid\">$prod</option>\n";
+                    }
+                }
+            echo "
+            </select>\n";
+            echo "<br />bitte 1 <font color='green'>gr&uuml;nen</font> Eintrag w&auml;hlen";
+
+    			if (isset($pz) && $pz['prid']<1)
+    			{
+    					echo "<br><span class=\"red\">Produktzuordnung muss erfolgen!</span>\n";
+    					$okn = false;
+    			}
+            ?>
+        </td>
+    </tr>
+    <tr>
+        <td>Auftraggeber</td>
+        <td><input type="text" name="pz[persa]" id="persa" value="<?php echo $pz['persa']; ?>"/>
+        &nbsp;&nbsp;&nbsp;Eingabe von mind. 2 Zeichen -&gt; Namensliste
+        </td>
+    </tr>
+    <tr>
+        <td>Verantwortlicher</td>
+        <td><input type="text" name="pz[pers]" id="pers" value="<?php echo $pz['pers']; ?>"/>
+        &nbsp;&nbsp;&nbsp;Eingabe von mind. 2 Zeichen -&gt; Namensliste
+        </td>
+    </tr>
+    <tr><td>geh&ouml;rt zu Projekt</td>
+        <td><select name="pz[pzref]">
+            <?php
+                if ($pz['pzref'] == -1) $select = " selected "; else $select = "";
+                echo "<option $select value=\"-1\"></option>\n";
+                if (isset($pz["pzid"]) && $pz["pzid"]>0) $where = " WHERE proz_ID != " . $pz["pzid"]; else $where=""; 
+                $sql = "SELECT proz_ID, proz_bez FROM Prozess $where ORDER BY 2";
+                if ($result = $dbc -> queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                    {
+                        if ($row->proz_ID == $pz['pzref'])
+    					   echo "<option selected value=\"$row->proz_ID\">$row->proz_ID - $row->proz_bez</option>\n";
+    				    else
+    					   echo "<option value=\"$row->proz_ID\">$row->proz_ID - $row->proz_bez</option>\n";
+                    }
+                }
+            ?>
+        </select>
+        </td>
+    </tr>
+    <tr>
+        <td>Plan Start-Datum</td>
+        <td><input class="long10" name="pz[psdat]" id="psdat"  value="<?php echo $pz['psdat']; ?>" />
+        &nbsp;&nbsp;&nbsp;&nbsp;Plan Ende-Datum
+        &nbsp;&nbsp;<input class="long10" name="pz[pedat]" id="pedat"  value="<?php echo $pz['pedat']; ?>" />
+        &nbsp;&nbsp;&nbsp;&nbsp;Plan Kosten (&euro;)
+        &nbsp;&nbsp;<input class='right' name="pz[pkost]" type="text" value="<?php echo $pz["pkost"]; ?>" /></td>
+    </tr>
+    <tr>
+        <td>Start-Datum</td>
+        <td><input class="long10" name="pz[sdat]" id="sdat"  value="<?php echo $pz['sdat']; ?>" />
+        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Ende-Datum
+        &nbsp;&nbsp;<input class="long10" name="pz[edat]" id="edat"  value="<?php echo $pz['edat']; ?>" />
+        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Kosten (&euro;)
+        &nbsp;&nbsp;<input class='right' name="pz[kost]" type="text" value="<?php echo $pz["kost"]; ?>" /></td>
+    </tr>
+<!--    <tr>
+        <td>Prozess-Kategorie</td>
+        <td><select name="pz[kat]">
+        <?php
+/*                if ($pz['kat'] == -1) $select = " selected "; else $select = "";
+                echo "<option $select value=\"-1\"></option>\n";
+                $sql = "SELECT proz_kat_ID,proz_kat_bez FROM Proz_Kategorie ORDER BY 2";
+                if ($result = $dbc -> queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                    {
+                        if ($row->proz_kat_ID == $pz['kat'])
+    					   echo "<option selected value=\"$row->proz_kat_ID\">$row->proz_kat_bez</option>\n";
+    				    else
+    					   echo "<option value=\"$row->proz_kat_ID\">$row->proz_kat_bez</option>\n";
+                    }
+                }
+*/        ?>
+        </select>
+        </td>
+    </tr> -->
+    <tr>
+        <td>Arbeitschritte</td>
+        <td>
+        <div id="add">
+            <input name="pz[step][]" type="text" size="50" maxlength="50" value="<?php echo $pz['step'][0]; ?>" />
+        &nbsp;&nbsp;&nbsp;Status&nbsp;&nbsp;&nbsp;<select name="pz[ststat][]">
+        <?php
+            if (isset($pz['step'])) $anzstep = count($pz['step']); else $anzstep = 1;
+                if ($pz['ststat'][0] == -1) $select = " selected "; else $select = "";
+                echo "<option $select value=\"-1\"></option>\n";
+                $sql = "SELECT proz_stat_ID,proz_stat_bez FROM Proz_Status ORDER BY 1";
+                if ($result = $dbc -> queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                    {
+                        if ($row->proz_stat_ID == $pz['ststat'][0])
+    					   echo "<option selected value=\"$row->proz_stat_ID\">$row->proz_stat_bez</option>\n";
+    				    else
+    					   echo "<option value=\"$row->proz_stat_ID\">$row->proz_stat_bez</option>\n";
+                        $stat .= "'".$row->proz_stat_ID. "':'" . $row->proz_stat_bez . "',";
+                        $sta[$row->proz_stat_ID] = $row->proz_stat_bez;
+                    }
+                }
+                $stat = substr($stat,0,strlen($stat)-1);
+                echo "</select>";
+                echo "&nbsp;&nbsp;&nbsp;Sort&nbsp;&nbsp;&nbsp;<input type='text' name=\"pz[sort][]\" class='right' size=\"2\" maxlen=\"2\" value=\"". $pz['sort'][0]. "\" /><br />\n";
+                echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Bemerkung zu Schritt&nbsp;&nbsp;&nbsp;";
+                echo "<input name=\"pz[stbem][]\" maxlen=\"50\" size=\"50\" value='".$pz["stbem"][0]."' />";
+        ?>
+            <script type="text/javascript">
+            <!--
+                arr = {<?php echo ($stat); ?>}; // Ergebnis: {key:'value',key:'value',...} 
+            //-->
+            </script>
+        
+            
+            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
+            <a href="<?php echo "javascript:addInput('add',$anzstep);" ?>" id="badd"  title="Schritt hinzuf&uuml;gen"><img src="/fhiiqm/img/add.png" border="0" /></a>
+            &nbsp;&nbsp;&nbsp;<a href="<?php echo "javascript:markdelInput('add',$anzstep);" ?>" id="bdel" title="Schritt entfernen"><img src="/fhiiqm/img/delete.png" border="0" /></a>
+        <?php
+            if ($pzid || ($sub && isset($pz) && !$ok))
+            {
+                if (count($pz['step'])>1)
+                {
+                    $i=0;
+                    foreach ($pz['step'] as $akt)
+                    {
+                        if ($i>0)
+                        {
+                            echo "<span></span><br /><input name=\"pz[step][]\" type=\"text\" size=\"50\" maxlength=\"50\" value=\"" .$pz['step'][$i] . "\" />\n";
+                            echo "&nbsp;&nbsp;&nbsp;Status&nbsp;&nbsp;&nbsp;<select name='pz[ststat][]'>";
+                            if ($pz['ststat'][$i] == -1) $select = " selected "; else $select = "";
+                            echo "<option $select value=\"-1\"></option>\n";
+                            foreach ($sta as $key => $value)
+                            {
+                                $select = ($key == $pz['ststat'][$i])? " selected='selected'" : "";
+            					   echo "<option$select value=\"$key\">$value</option>\n";
+                            }
+                            echo "</select>";
+                            echo "&nbsp;&nbsp;&nbsp;Sort&nbsp;&nbsp;&nbsp;<input type='text' name='pz[sort][]' class='right' size='2' maxlen='2' value='".$pz['sort'][$i] ."' />";
+                            if (isset($pz['del'])) $cls = "dispil"; else $cls = "pr";
+                            if (isset($pz['del'][$i])) $chk = "checked = ' checked'"; else $chk ="";
+                            echo "<span id='cbl_$i'>&nbsp;&nbsp;&nbsp;<input class='$cls' type='checkbox' id='del_$i' name='pz[del][$i]' value='1'$chk /></span>
+                                <span id='lb_$i' class='$cls'>&nbsp;l&ouml;schen?</span>";    
+                            echo "<img src='/fhiiqm/img/nixt.gif' border='0' height='100%' />\n";
+                            echo "<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Bemerkung zu Schritt&nbsp;&nbsp;&nbsp;";
+                            echo "<input name=\"pz[stbem][]\" maxlen=\"50\" size=\"50\" value=\"".$pz["stbem"][$i]."\" />\n";
+                        }
+                        $i++;
+                    }
+                }
+            }
+        ?>
+        </div>
+        </td>
+    </tr>
+    <tr>
+        <td>Projekt-Dringlichkeit</td>
+        <td><select name="pz[urg]">
+        <?php
+                if ($pz['urg'] == -1) $select = " selected "; else $select = "";
+                echo "<option $select value=\"-1\"></option>\n";
+                $sql = "SELECT proz_urg_ID,proz_urg_bez FROM Proz_Dringlichkeit ORDER BY 1";
+                if ($result = $dbc -> queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                    {
+                        if ($row->proz_urg_ID == $pz['urg'])
+    					   echo "<option selected value=\"$row->proz_urg_ID\">$row->proz_urg_bez</option>\n";
+    				    else
+    					   echo "<option value=\"$row->proz_urg_ID\">$row->proz_urg_bez</option>\n";
+                    }
+                }
+        ?>
+        </select>
+        </td>
+    </tr>
+    <tr>
+        <td>Projekt-Status</td>
+        <td><select name="pz[stat]">
+        <?php
+                if ($pz['stat'] == -1) $select = " selected "; else $select = "";
+                echo "<option $select value=\"-1\"></option>\n";
+                $sql = "SELECT proz_stat_ID,proz_stat_bez FROM Proz_Status ORDER BY 1";
+                if ($result = $dbc -> queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                    {
+                        if ($row->proz_stat_ID == $pz['stat'])
+    					   echo "<option selected value=\"$row->proz_stat_ID\">$row->proz_stat_bez</option>\n";
+    				    else
+    					   echo "<option value=\"$row->proz_stat_ID\">$row->proz_stat_bez</option>\n";
+                    }
+                }
+        ?>
+        </select>
+        </td>
+    </tr>
+    <tr>
+        <td>betroffene AGs</td>
+        <td>
+        <div id="addrag">
+        <select name="pz[rag][]">
+        <?php
+            if (isset($pz['rag'])) $anzrag = count($pz['rag']); else $anzrag = 1;
+            if ($pz['rag'] == -1) $select = " selected "; else $select = "";
+            echo "<option $select value=\"-1\"></option>\n";
+            $sql = "SELECT rag_ID,rag_bez,rag_bezk,abt_name,rag.abt_ID 
+                    FROM fhiiqm.RaumArb_Gruppe rag
+                    LEFT OUTER JOIN Abteilung a ON rag.abt_ID=a.abt_ID
+                    ORDER BY rag.abt_ID,rag_bez";
+            if ($result = $dbc -> queryObjectArray($sql))
+            {
+                foreach ($result as $row)
+                {
+                    if ($row->rag_ID == $pz['rag'][0]) $select = " selected "; else $select = "";
+                    echo "<option$select value=\"$row->rag_ID\">$row->abt_name: $row->rag_bez</option>\n";
+                    $faktor = ($row->abt_ID*1000)+$row->rag_ID; // wegen sort nach Abt. fuer JS, z.B. 7047
+                    $rag .= "'".$faktor. "':'" . $row->abt_name.": ". $row->rag_bez . "',";
+                    $ag[$row->rag_ID] = $row->abt_name.": ". $row->rag_bez; 
+                }
+            }
+            $rag = substr($rag,0,strlen($rag)-1);
+        ?>
+        </select>
+            <script type="text/javascript">
+            <!--
+                arrag = {<?php echo ($rag); ?>}; // Ergebnis: {key:'value',key:'value',...} 
+            //-->
+            </script>
+        
+            &nbsp;&nbsp;&nbsp;
+            <a href="<?php echo "javascript:addInput('addrag',$anzrag);" ?>" id="badd"  title="AG hinzuf&uuml;gen"><img src="/fhiiqm/img/add.png" border="0" /></a>
+            &nbsp;&nbsp;&nbsp;<a href="<?php echo "javascript:markdelInput('addrag',$anzrag);" ?>" id="bdel" title="AG entfernen"><img src="/fhiiqm/img/delete.png" border="0" /></a>
+        <?php
+            if ($pzid || ($sub && isset($pz) && !$ok))
+            {
+                if (count($pz['rag'])>1)
+                {
+                    $i=0;
+                    foreach ($pz['rag'] as $akt)
+                    {
+                        if ($i>0)
+                        {
+                            echo "<span></span><br /><select name='pz[rag][]'>";
+                            if ($pz['rag'][$i] == -1) $select = " select='selected' "; else $select = "";
+                            echo "<option $select value=\"-1\"></option>\n";
+                            foreach ($ag as $key => $value)
+                            {
+                                $select = ($key == $pz['rag'][$i])? " selected='selected'" : "";
+            					   echo "<option$select value=\"$key\">$value</option>\n";
+                            }
+                            echo "</select>";
+                            if (isset($pz['delag'])) $cls = "dispil"; else $cls = "pr";
+                            if (isset($pz['delag'][$i])) $chk = "checked = ' checked'"; else $chk ="";
+                            echo "<span id='cblag_$i'>&nbsp;&nbsp;&nbsp;<input class='$cls' type='checkbox' id='delag_$i' name='pz[delag][$i]' value='1'$chk /></span>
+                                <span id='lbag_$i' class='$cls'>&nbsp;l&ouml;schen?</span>";
+                            echo "<img src='/fhiiqm/img/nixt.gif' border='0' height='100%' />\n";    
+                       }
+                        $i++;
+                    }
+                }
+            }
+        ?>
+        </div>
+        </td>
+    </tr>
+    <tr>
+        <td>Bemerkung</td>
+        <td><textarea name="pz[bem]" cols="80" rows="6"><?php echo $pz["bem"]; ?></textarea>
+        </td>
+    </tr>
+
+    <input type="hidden" name="pz[persknr]" id="pid" value="<?php echo $pz['persknr']; // Verantwortlicher?>"/> 
+    <input type="hidden" name="pz[persknra]" id="paid" value="<?php echo $pz['persknra']; // Auftraggeber?>"/> 
+    <input type="hidden" name="pz[okn]" value="<?php echo $okn; ?>"/>
+<!--  </table>
+ </div>   
+</form> -->
\ No newline at end of file