--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/form/raum_aptyp_form.inc.php	Mon May 07 16:21:00 2012 +0200
@@ -0,0 +1,121 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 4/2012
+ * 
+ * Form Raum - Arbeitsplatztyp
+ * 
+ */
+
+	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_info" target="_self">
+    <div align="center"> 	
+    <table width="45%" border="0" cellspacing="3" cellpadding="3">
+    <tr>
+        <td width="30%">Haus *</td>
+        <td><select name="ap[geb]" onchange="this.form.submit();">
+            <?php 
+                $sql = "SELECT geb_ID, geb_name FROM Haus ORDER BY 1";
+                if ($result = $dbc->queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                    {
+                        if ($row->geb_ID == $ap['geb'])
+    					   echo "<option selected value=\"$row->geb_ID\">$row->geb_ID - $row->geb_name</option>\n";
+    				    else
+    					   echo "<option value=\"$row->geb_ID\">$row->geb_ID - $row->geb_name</option>\n";
+                    }
+                }
+            ?>
+            </select>
+        </td>
+    </tr>
+    <tr>
+        <td>Raum *</td>
+        <td><select name="ap[raum]">
+            <?php 
+                if (!isset($ap) && !$ap['geb']) $ap['geb'] = "A";
+                $sql = "SELECT raum_ID, raum_nr, raum_name FROM Raum WHERE geb_ID = '". $ap['geb']."' ORDER BY 2";
+                if ($result = $dbc->queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                    {
+                        if ($row->raum_ID == $ap['raum'])
+    					   echo "<option selected value=\"$row->raum_ID\">$row->raum_nr - $row->raum_name</option>\n";
+    				    else
+    					   echo "<option value=\"$row->raum_ID\">$row->raum_nr - $row->raum_name</option>\n";
+                    }
+                }
+            ?>
+            </select>
+        </td>
+    </tr>
+    <tr>
+        <td>Arbeitsplatztyp *
+            <br />&nbsp;&nbsp;&nbsp;Hinzufügen weiterer<br />&nbsp;&nbsp;&nbsp;Typen mit '+'
+        </td>        
+        <td>
+        <div id="add">
+            <select name="ap[aptyp][]" size="1">
+            <?php
+                $select = null;
+                $select = ( "-1"==$ap['aptyp'][0] ) ? ' selected' : null;
+                echo "<option $select value=\"-1\"></option>\n";
+                $sql = "SELECT arbplatz_typ, arbplatz_typ_bez FROM fhiiqm.Arbplatz_Typ ORDER BY 1";
+                if ($result = $dbc->queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                    {
+                        $select = ( $row->arbplatz_typ==$ap['aptyp'][0] ) ? ' selected' : null;
+    					echo "<option $select value=\"$row->arbplatz_typ\">$row->arbplatz_typ - $row->arbplatz_typ_bez</option>\n";
+                        $apt .= "'".$row->arbplatz_typ."':'".$row->arbplatz_typ_bez."',";
+                    }
+                }
+                $apt = substr($apt,0,strlen($apt)-1);
+            ?>
+            </select>
+            <script type="text/javascript">
+            <!--
+                arr = {<?php echo ($apt); ?>}; // Ergebnis: {'key':'value','key':'value',...} 
+            //-->
+            </script>
+
+            &nbsp;&nbsp;&nbsp;<a href="<?php echo "javascript:addInput('add');" ?>" title="weiterer Arbeitsplatztyp"><img src="/fhiiqm/img/add.png" /></a>
+            &nbsp;&nbsp;&nbsp;<a href="<?php echo "javascript:delInput('add');" ?>" title="l&ouml;schen letzten Arbeitsplatztyp"><img src="/fhiiqm/img/delete.png" /></a>
+        <?php
+            if ($apid || ($sub && isset($ap) && !$ok))
+            {
+                if (count($ap['aptyp'])>1)
+                {
+                    $i=0;
+                    foreach ($ap['aptyp'] as $apte)
+                    {
+                        if ($i>0)
+                        {
+                            echo "<select name=\"ap[aptyp][]\" size=\"1\">";
+            
+                            $select = ( "-1" == $apte ) ? ' selected' : null;
+                            echo "<option $select value=\"-1\"></option>\n";
+                            foreach ($result as $row)
+                            {
+                                $select = ( $row->arbplatz_typ == $apte ) ? ' selected' : null;
+            					echo "<option $select value=\"$row->arbplatz_typ\">$row->arbplatz_typ - $row->arbplatz_typ_bez</option>\n";
+                            }
+                            echo "</select><br/>\n";
+                        }
+                        $i++;
+                    }
+                }
+            }
+        ?>
+        </div>
+        </td>   
+    </tr>
+<!--
+    </table>
+    </form>
+-->
\ No newline at end of file