--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fhiiqm/form/rag_gv_search_form.inc.php Thu Aug 23 10:17:50 2012 +0200
@@ -0,0 +1,186 @@
+<?php
+
+/**
+ * @author Bettina Schwarzer, Fritz-Haber-Institut
+ * @copyright 07/2012
+ *
+ * Form Recherche raum-arbeits-gruppen, gefahr-massnahmen-vorsorge
+ *
+ */
+
+ 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ür die Suche wä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>Abteilung</td>
+ <td>
+ <select name="rag[abt]" size="1" onchange="this.form.submit();">
+ <?php
+ if ($rag["abt"] == -1) $select = " selected "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT abt_name, abt_long FROM Abteilung ORDER BY 1";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->abt_name == $rag['abt'])
+ echo "<option selected value=\"$row->abt_name\">$row->abt_name - $row->abt_long</option>\n";
+ else
+ echo "<option value=\"$row->abt_name\">$row->abt_name - $row->abt_long</option>\n";
+ }
+ }
+ ?>
+ </select>
+ </td>
+ </tr>
+ <tr>
+ <td>Arbeitsgruppe</td>
+ <td>
+ <select name="rag[ag]" size="1">
+ <?php
+ if (isset($rag["abt"]) && $rag["abt"] > '-1') $wherag = " WHERE abt_name = '". $rag["abt"] . "' "; else $wherag = "";
+ if ($rag["ag"] == -1) $select = " selected "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT rag_ID,rag_bez,abt_name FROM fhiiqm.RaumArb_Gruppe ag LEFT OUTER JOIN Abteilung a ON ag.abt_ID=a.abt_ID $wherag ORDER BY 3,2";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->abt_name == $rag['ag'])
+ echo "<option selected value=\"$row->rag_ID\">$row->rag_bez - $row->abt_name</option>\n";
+ else
+ echo "<option value=\"$row->rag_ID\">$row->rag_bez - $row->abt_name</option>\n";
+ }
+ }
+ ?>
+ </select>
+ </td>
+ </tr>
+ <tr>
+ <td>Mitarbeiter</td>
+ <td>
+ <input name="rag[ma]" size="20" maxlength="50" value="<?php echo $rag['ma']; ?>" />
+ </td>
+ </tr>
+ <tr>
+ <td>Haus</td>
+ <td>
+ <select name="rag[geb]" size="1">
+ <?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><input name="rag[rnum]" size="20" maxlength="20" value="<?php echo $rag['rnum']; ?>" />
+ </td>
+ </tr>
+ <tr>
+ <td>Gefährdung</td>
+ <td><select name="rag[gf]">
+ <?php
+ if ($rag["gf"] == -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['gf'])
+ 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>Vorsorge</td>
+ <td><select name="rag[vs]">
+ <?php
+ if ($rag["vs"] == -1) $select = " selected "; else $select = "";
+ echo "<option $select value=\"-1\"></option>\n";
+ $sql = "SELECT vs_ID,vs_bez FROM fhiiqm.Vorsorge
+ ORDER BY 2";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($row->vs_ID == $rag['vs'])
+ echo "<option selected value=\"$row->vs_ID\">$row->vs_ID - $row->vs_bez</option>\n";
+ else
+ echo "<option value=\"$row->vs_ID\">$row->vs_ID - $row->vs_bez</option>\n";
+ }
+ }
+ ?>
+ </select>
+ </td>
+ </tr>
+ <tr>
+ <td>Verknüpfung</td>
+ <td>UND
+ <input type="radio" name="rag[bind]" value="AND" <?php if (isset($rag["bind"]) && $rag["bind"]=="AND") echo "checked"; else echo "checked";?>>
+ ODER
+ <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"=>"","3,2"=>"Abteilung, AG","4"=>"Mitarbeiter","5"=>"Raum-Nr.","6"=>"Gefährdung","7"=>"Vorsorge");
+ for ($i=1; $i<3; $i++)
+ {
+ echo "$i. <select name='rag[sort$i]'>\n";
+ foreach ($sort as $key=>$val)
+ {
+ $rsort = "sort" . $i;
+ if ($rag[$rsort] == $val) $select= " selected"; else $select = "";
+ echo "<option$select value='$key'>$val</option>\n";
+ }
+ echo "</select> \n";
+ }
+ echo "</td></tr>\n";
+
+ $azeil = array(1=>'1',10=>'10',20=>'20',25=>'25',50=>'50',100=>'100',9999=>'alle'); // Anzahl gezeigter rows
+ echo "<tr><td>Zeilen/Seite?</td><td><select name='rag[z]'>\n";
+ if (!$rag['z']) $rag['z'] = 9999;
+ foreach ($azeil as $key=>$val)
+ {
+ if ($key == $rag['z']) $select = "selected"; else $select = "";
+ echo "<option $select value='$key'>$val</option>\n";
+ }
+ echo "</select></td></tr>\n";
+
+ ?>
+ <tr>
+ <td> </td>
+ <td><input class="button" type="submit" name="search" value="Bericht erstellen"/></td>
+ </tr>
+</table>
+</div>
+</form>
\ No newline at end of file