--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/form/raumarbgr_form.inc.php	Thu Jul 12 13:29:11 2012 +0200
@@ -0,0 +1,165 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 06/2012
+ * 
+ * Form RaumArb_Gruppe Raum, Mitarbeiter
+ * 
+ */
+
+	include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+	if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+
+?>
+    <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_rag" target="_self">
+    <div align="center"> 	
+    <table width="45%" border="0" cellspacing="3" cellpadding="3">
+    <tr>
+        <td width="20%">Raum-Arbeits-Gruppe *</td>        
+        <td>
+            <select name="rag[gr]" size="1">
+            <?php
+                $select = null;
+                $sql = "SELECT rag_ID, rag_bez, abt_name FROM fhiiqm.RaumArb_Gruppe r LEFT OUTER JOIN Abteilung a ON r.abt_ID=a.abt_ID ORDER BY 3,2";
+                if ($result = $dbc->queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                    {
+                        $select = ( $row->rag_ID==$rag['gr'] ) ? ' selected' : null;
+    					echo "<option $select value=\"$row->rag_ID\">$row->rag_bez ($row->abt_name)</option>\n";
+                    }
+                }
+            ?>
+            </select>
+        </td>   
+    </tr>
+    <tr>
+        <td>zugeh&ouml;rige R&auml;ume *
+            <br />&nbsp;&nbsp;&nbsp;leeres Feld = L&ouml;schen
+        </td>        
+        <td>
+        <div id="addr">
+            <select name="rag[ra][]" size="1">
+            <?php
+                $select = null;
+                $select = ( "-1"==$rag['ra'][0] ) ? ' selected' : null;
+                echo "<option $select value=\"-1\"></option>\n";
+                $sql = "SELECT raum_ID,raum_nr,raum_name,geb_ID FROM Raum ORDER BY geb_ID,raum_nr";
+                if ($result = $dbc->queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                    {
+                        $select = ( $row->raum_ID==$rag['ra'][0] ) ? ' selected' : null;
+    					echo "<option $select value=\"$row->raum_ID\">$row->geb_ID: $row->raum_nr - $row->raum_name</option>\n";
+                        $sra .= "'".$row->raum_ID."':'".$row->geb_ID.": ".$row->raum_nr. " - " .$row->raum_name."',";
+                    }
+                }
+                $sra = substr($sra,0,strlen($sra)-1);
+            ?>
+            ?>
+            </select>
+            <script type="text/javascript">
+            <!--
+                arr = {<?php echo ($sra); ?>}; // Ergebnis: {'key':'value','key':'value',...} 
+            //-->
+            </script>
+
+            &nbsp;&nbsp;&nbsp;<a href="<?php echo "javascript:addInput('addr',arr);" ?>" title="weiterer Raum"><img src="/fhiiqm/img/add.png" /></a>
+            &nbsp;&nbsp;&nbsp;<a href="<?php echo "javascript:delInput('addr');" ?>" title="l&ouml;schen letzten Raum"><img src="/fhiiqm/img/delete.png" /></a>
+        <?php
+            if ($ragid || ($sub && isset($rag) && !$ok))
+            {
+                if (count($rag['ra'])>1)
+                {
+                    $i=0;
+                    foreach ($rag['ra'] as $rae)
+                    {
+                        if ($i>0)
+                        {
+                            echo "<select name=\"rag[ra][]\" size=\"1\">";
+            
+                            $select = ( "-1" == $rae ) ? ' selected' : null;
+                            echo "<option $select value=\"-1\"></option>\n";
+                            foreach ($result as $row)
+                            {
+                                $select = ( $row->raum_ID == $rae ) ? ' selected' : null;
+            					echo "<option $select value=\"$row->raum_ID\">$row->geb_ID: $row->raum_nr - $row->raum_name</option>\n";
+                            }
+                            echo "</select><br/>\n";
+                        }
+                        $i++;
+                    }
+                }
+            }
+        ?>
+        </div>
+        </td>   
+    </tr>
+    <tr>
+        <td>zugeh&ouml;rige Mitarbeiter *
+            <br />&nbsp;&nbsp;&nbsp;leeres Feld = L&ouml;schen
+        </td>        
+        <td>
+        <div id="addm">
+            <select name="rag[ma][]" size="1">
+            <?php
+                $select = null;
+                $select = ( "-1"==$rag['ma'][0] ) ? ' selected' : null;
+                echo "<option $select value=\"-1\"></option>\n";
+                $sql = "SELECT persknr, CONCAT (nachname, ', ',vorname, ', ' , IFNULL(abt_name,''),' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') AS ma
+                 FROM fhiiqm.Mitarbeiter m LEFT OUTER JOIN fhiiqm.Abteilung a ON m.abt_tel=a.abt_ID ORDER BY 2";
+                if ($result = $dbc->queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                    {
+                        $select = ( $row->persknr==$rag['ma'][0] ) ? ' selected' : null;
+    					echo "<option $select value=\"$row->persknr\">$row->ma</option>\n";
+                        $sma .= "'".$row->persknr."':'".$row->ma."',";
+                    }
+                }
+                $sma = substr($sma,0,strlen($sma)-1);
+            ?>
+            ?>
+            </select>
+            <script type="text/javascript">
+            <!--
+                arm = {<?php echo ($sma); ?>}; // Ergebnis: {'key':'value','key':'value',...} 
+            //-->
+            </script>
+
+            &nbsp;&nbsp;&nbsp;<a href="<?php echo "javascript:addInput('addm',arm);" ?>" title="weiterer MA"><img src="/fhiiqm/img/add.png" /></a>
+            &nbsp;&nbsp;&nbsp;<a href="<?php echo "javascript:delInput('addm');" ?>" title="l&ouml;schen letzten MA"><img src="/fhiiqm/img/delete.png" /></a>
+        <?php
+            if ($ragid || ($sub && isset($rag) && !$ok))
+            {
+                if (count($rag['ma'])>1)
+                {
+                    $i=0;
+                    foreach ($rag['ma'] as $mae)
+                    {
+                        if ($i>0)
+                        {
+                            echo "<select name=\"rag[ma][]\" size=\"1\">";
+            
+                            $select = ( "-1" == $mae ) ? ' selected' : null;
+                            echo "<option $select value=\"-1\"></option>\n";
+                            foreach ($result as $row)
+                            {
+                                $select = ( $row->persknr == $mae ) ? ' selected' : null;
+            					echo "<option $select value=\"$row->persknr\">$row->ma</option>\n";
+                            }
+                            echo "</select><br/>\n";
+                        }
+                        $i++;
+                    }
+                }
+            }
+        ?>
+        </div>
+        </td>   
+    </tr>
+<!--
+    </table>
+    </form>
+-->
\ No newline at end of file