--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/form/gefahr_ap_search_form.inc.php	Wed Aug 31 14:22:19 2011 +0200
@@ -0,0 +1,140 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 08/2011
+ *
+ * Form Recherche Raum - Gefahr
+ */
+
+	include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
+	if (!isset($dbc) || !$dbc) $dbc = new dbconnection();
+    $okn = true;
+
+?>
+<div align="center">
+<h3><font face="Verdana, Arial, Helvetica, sans-serif"></font></h3>
+<p>Bitte Kriterien f&uuml;r die Suche w&auml;hlen</p>
+</div>
+<form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_rag" target="_self">	
+<div align="center">
+<table width="50%" border="0" cellspacing="3" cellpadding="3">
+    <tr>
+        <td>Haus</td>
+        <td>
+            <select name="rag[geb]" size="1" onchange="this.form.submit();">
+            <?php 
+                if ($rag["geb"] == -1) $select = " selected "; else $select = "";
+                echo "<option $select value=\"-1\"></option>\n";
+                $sql = "SELECT geb_ID, geb_name FROM Haus ORDER BY 1";
+                if ($result = $dbc->queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                    {
+                        if ($row->geb_ID == $rag['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-Nummer</td>
+        <td><select name="rag[rnum]">
+            <?php 
+                if ($rag["rnum"] == -1) $select = " selected "; else $select = "";
+                echo "<option $select value=\"-1\"></option>\n";
+                if (isset($rag["geb"]) && $rag["geb"] > -1) $where = " WHERE geb_ID = '".$rag["geb"]."'"; else $where = "";
+                echo "Gebaeude: ".$rag["geb"]."<br />\n";
+                $sql = "SELECT geb_ID, raum_ID,raum_nr,raum_name FROM fhiiqm.Raum $where ORDER BY 1,3";
+                if ($result = $dbc->queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                    {
+                        if ($row->raum_ID == $rag['rnum'])
+    					   echo "<option selected value=\"$row->raum_ID\">$row->geb_ID - $row->raum_nr, $row->raum_name</option>\n";
+    				    else
+    					   echo "<option value=\"$row->raum_ID\">$row->geb_ID - $row->raum_nr, $row->raum_name</option>\n";
+                    }
+                }
+            ?>
+            </select>
+        </td>
+    </tr>
+    <tr>
+        <td>Arbeitsplatz-Typ</td>
+        <td><select name="rag[aptyp]">
+            <?php 
+                if ($rag["atyp"] == -1) $select = " selected "; else $select = "";
+                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)
+                    {
+                        if ($row->arbplatz_typ == $rag['atyp'])
+    					   echo "<option selected value=\"$row->arbplatz_typ\">$row->arbplatz_typ - $row->arbplatz_typ_bez</option>\n";
+    				    else
+    					   echo "<option value=\"$row->arbplatz_typ\">$row->arbplatz_typ - $row->arbplatz_typ_bez</option>\n";
+                    }
+                }
+            ?>
+            </select>
+        </td>
+    </tr>
+    <tr>
+        <td>Gefahr</td>
+        <td><select name="rag[gef]">
+            <?php 
+                if ($rag["gef"] == -1) $select = " selected "; else $select = "";
+                echo "<option $select value=\"-1\"></option>\n";
+                $sql = "SELECT gefahr_ID,gefahrgr_ID,gefahr_bez FROM fhiiqm.Gefahr
+                        ORDER BY CONVERT(substring(gefahr_ID,1,INSTR(gefahr_ID,'.')-1),DECIMAL),CONVERT(SUBSTRING(gefahr_ID,INSTR(gefahr_ID,'.')+1),DECIMAL);";
+                if ($result = $dbc->queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                    {
+                        if ($row->gefahr_ID == $rag['gef'])
+    					   echo "<option selected value=\"$row->gefahr_ID\">$row->gefahr_ID - $row->gefahr_bez</option>\n";
+    				    else
+    					   echo "<option value=\"$row->gefahr_ID\">$row->gefahr_ID - $row->gefahr_bez</option>\n";
+                    }
+                }
+            ?>
+            </select>
+        </td>
+    </tr>
+    <tr> 
+          <td>Verkn&uuml;pfung</td>
+          <td>UND&nbsp;&nbsp;&nbsp;
+            <input type="radio" name="rag[bind]" value="AND" <?php if (isset($rag["bind"]) && $rag["bind"]=="AND") echo "checked"; else  echo "checked";?>>
+          &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ODER&nbsp;&nbsp;&nbsp;
+            <input type="radio" name="rag[bind]" value="OR" <?php if (isset($rag["bind"]) && $rag["bind"]=="OR") echo "checked"; ?>></td>
+    </tr>
+    <tr>
+        <td>Sortierung nach<br />(in dieser Reihenfolge)</td><td>
+    <?php
+        $sort = array("-1"=>"","1"=>"Geb&auml;ude","2"=>"Raum-Nr.","6"=>"Arbeitsplatztyp","8"=>"Gefahr");
+        for ($i=1; $i<5; $i++)
+        { 
+          echo "$i.&nbsp;&nbsp;<select name='rag[sort$i]'>\n";
+          foreach ($sort as $key=>$val)
+          {
+            $rsort = $sort . $i;
+            if ($rag[$rsort] == $i) $select= " selected"; else $select = "";
+            echo "<option$select value='$key'>$val</option>\n";
+          }
+          echo "</select>&nbsp;&nbsp;&nbsp;&nbsp;\n";
+        } 
+        echo "</td></tr>\n";
+    ?>
+    <tr> 
+        <td>&nbsp;</td>
+        <td><input class="button" type="submit" name="search" value="suchen"></td>
+    </tr> 
+</table>
+</div>
+</form>
\ No newline at end of file