|
1 <?php |
|
2 |
|
3 /** |
|
4 * @author Bettina Schwarzer, Fritz-Haber-Institut |
|
5 * @copyright 07/2012 |
|
6 * |
|
7 * Form Recherche raum-arbeits-gruppen, gefahr-massnahmen-vorsorge |
|
8 * |
|
9 */ |
|
10 |
|
11 include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php"); |
|
12 if (!isset($dbc) || !$dbc) $dbc = new dbconnection(); |
|
13 $okn = true; |
|
14 |
|
15 ?> |
|
16 <div align="center"> |
|
17 <h3><font face="Verdana, Arial, Helvetica, sans-serif"></font></h3> |
|
18 <p>Bitte Kriterien für die Suche wählen</p> |
|
19 </div> |
|
20 <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" enctype="application/x-www-form-urlencoded" name="form_rag" target="_self"> |
|
21 <div align="center"> |
|
22 <table width="50%" border="0" cellspacing="3" cellpadding="3"> |
|
23 <tr> |
|
24 <td>Abteilung</td> |
|
25 <td> |
|
26 <select name="rag[abt]" size="1" onchange="this.form.submit();"> |
|
27 <?php |
|
28 if ($rag["abt"] == -1) $select = " selected "; else $select = ""; |
|
29 echo "<option $select value=\"-1\"></option>\n"; |
|
30 $sql = "SELECT abt_name, abt_long FROM Abteilung ORDER BY 1"; |
|
31 if ($result = $dbc->queryObjectArray($sql)) |
|
32 { |
|
33 foreach ($result as $row) |
|
34 { |
|
35 if ($row->abt_name == $rag['abt']) |
|
36 echo "<option selected value=\"$row->abt_name\">$row->abt_name - $row->abt_long</option>\n"; |
|
37 else |
|
38 echo "<option value=\"$row->abt_name\">$row->abt_name - $row->abt_long</option>\n"; |
|
39 } |
|
40 } |
|
41 ?> |
|
42 </select> |
|
43 </td> |
|
44 </tr> |
|
45 <tr> |
|
46 <td>Arbeitsgruppe</td> |
|
47 <td> |
|
48 <select name="rag[ag]" size="1"> |
|
49 <?php |
|
50 if (isset($rag["abt"]) && $rag["abt"] > '-1') $wherag = " WHERE abt_name = '". $rag["abt"] . "' "; else $wherag = ""; |
|
51 if ($rag["ag"] == -1) $select = " selected "; else $select = ""; |
|
52 echo "<option $select value=\"-1\"></option>\n"; |
|
53 $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"; |
|
54 if ($result = $dbc->queryObjectArray($sql)) |
|
55 { |
|
56 foreach ($result as $row) |
|
57 { |
|
58 if ($row->abt_name == $rag['ag']) |
|
59 echo "<option selected value=\"$row->rag_ID\">$row->rag_bez - $row->abt_name</option>\n"; |
|
60 else |
|
61 echo "<option value=\"$row->rag_ID\">$row->rag_bez - $row->abt_name</option>\n"; |
|
62 } |
|
63 } |
|
64 ?> |
|
65 </select> |
|
66 </td> |
|
67 </tr> |
|
68 <tr> |
|
69 <td>Mitarbeiter</td> |
|
70 <td> |
|
71 <input name="rag[ma]" size="20" maxlength="50" value="<?php echo $rag['ma']; ?>" /> |
|
72 </td> |
|
73 </tr> |
|
74 <tr> |
|
75 <td>Haus</td> |
|
76 <td> |
|
77 <select name="rag[geb]" size="1"> |
|
78 <?php |
|
79 if ($rag["geb"] == -1) $select = " selected "; else $select = ""; |
|
80 echo "<option $select value=\"-1\"></option>\n"; |
|
81 $sql = "SELECT geb_ID, geb_name FROM Haus ORDER BY 1"; |
|
82 if ($result = $dbc->queryObjectArray($sql)) |
|
83 { |
|
84 foreach ($result as $row) |
|
85 { |
|
86 if ($row->geb_ID == $rag['geb']) |
|
87 echo "<option selected value=\"$row->geb_ID\">$row->geb_ID - $row->geb_name</option>\n"; |
|
88 else |
|
89 echo "<option value=\"$row->geb_ID\">$row->geb_ID - $row->geb_name</option>\n"; |
|
90 } |
|
91 } |
|
92 ?> |
|
93 </select> |
|
94 </td> |
|
95 </tr> |
|
96 <tr> |
|
97 <td>Raum-Nummer</td> |
|
98 <td><input name="rag[rnum]" size="20" maxlength="20" value="<?php echo $rag['rnum']; ?>" /> |
|
99 </td> |
|
100 </tr> |
|
101 <tr> |
|
102 <td>Gefährdung</td> |
|
103 <td><select name="rag[gf]"> |
|
104 <?php |
|
105 if ($rag["gf"] == -1) $select = " selected "; else $select = ""; |
|
106 echo "<option $select value=\"-1\"></option>\n"; |
|
107 $sql = "SELECT gefahr_ID,gefahrgr_ID,gefahr_bez FROM fhiiqm.Gefahr |
|
108 ORDER BY CONVERT(substring(gefahr_ID,1,INSTR(gefahr_ID,'.')-1),DECIMAL),CONVERT(SUBSTRING(gefahr_ID,INSTR(gefahr_ID,'.')+1),DECIMAL);"; |
|
109 if ($result = $dbc->queryObjectArray($sql)) |
|
110 { |
|
111 foreach ($result as $row) |
|
112 { |
|
113 if ($row->gefahr_ID == $rag['gf']) |
|
114 echo "<option selected value=\"$row->gefahr_ID\">$row->gefahr_ID - $row->gefahr_bez</option>\n"; |
|
115 else |
|
116 echo "<option value=\"$row->gefahr_ID\">$row->gefahr_ID - $row->gefahr_bez</option>\n"; |
|
117 } |
|
118 } |
|
119 ?> |
|
120 </select> |
|
121 </td> |
|
122 </tr> |
|
123 <tr> |
|
124 <td>Vorsorge</td> |
|
125 <td><select name="rag[vs]"> |
|
126 <?php |
|
127 if ($rag["vs"] == -1) $select = " selected "; else $select = ""; |
|
128 echo "<option $select value=\"-1\"></option>\n"; |
|
129 $sql = "SELECT vs_ID,vs_bez FROM fhiiqm.Vorsorge |
|
130 ORDER BY 2"; |
|
131 if ($result = $dbc->queryObjectArray($sql)) |
|
132 { |
|
133 foreach ($result as $row) |
|
134 { |
|
135 if ($row->vs_ID == $rag['vs']) |
|
136 echo "<option selected value=\"$row->vs_ID\">$row->vs_ID - $row->vs_bez</option>\n"; |
|
137 else |
|
138 echo "<option value=\"$row->vs_ID\">$row->vs_ID - $row->vs_bez</option>\n"; |
|
139 } |
|
140 } |
|
141 ?> |
|
142 </select> |
|
143 </td> |
|
144 </tr> |
|
145 <tr> |
|
146 <td>Verknüpfung</td> |
|
147 <td>UND |
|
148 <input type="radio" name="rag[bind]" value="AND" <?php if (isset($rag["bind"]) && $rag["bind"]=="AND") echo "checked"; else echo "checked";?>> |
|
149 ODER |
|
150 <input type="radio" name="rag[bind]" value="OR" <?php if (isset($rag["bind"]) && $rag["bind"]=="OR") echo "checked"; ?>></td> |
|
151 </tr> |
|
152 <tr> |
|
153 <td>Sortierung nach<br />(in dieser Reihenfolge)</td><td> |
|
154 <?php |
|
155 $sort = array("-1"=>"","3,2"=>"Abteilung, AG","4"=>"Mitarbeiter","5"=>"Raum-Nr.","6"=>"Gefährdung","7"=>"Vorsorge"); |
|
156 for ($i=1; $i<3; $i++) |
|
157 { |
|
158 echo "$i. <select name='rag[sort$i]'>\n"; |
|
159 foreach ($sort as $key=>$val) |
|
160 { |
|
161 $rsort = "sort" . $i; |
|
162 if ($rag[$rsort] == $val) $select= " selected"; else $select = ""; |
|
163 echo "<option$select value='$key'>$val</option>\n"; |
|
164 } |
|
165 echo "</select> \n"; |
|
166 } |
|
167 echo "</td></tr>\n"; |
|
168 |
|
169 $azeil = array(1=>'1',10=>'10',20=>'20',25=>'25',50=>'50',100=>'100',9999=>'alle'); // Anzahl gezeigter rows |
|
170 echo "<tr><td>Zeilen/Seite?</td><td><select name='rag[z]'>\n"; |
|
171 if (!$rag['z']) $rag['z'] = 9999; |
|
172 foreach ($azeil as $key=>$val) |
|
173 { |
|
174 if ($key == $rag['z']) $select = "selected"; else $select = ""; |
|
175 echo "<option $select value='$key'>$val</option>\n"; |
|
176 } |
|
177 echo "</select></td></tr>\n"; |
|
178 |
|
179 ?> |
|
180 <tr> |
|
181 <td> </td> |
|
182 <td><input class="button" type="submit" name="search" value="Bericht erstellen"/></td> |
|
183 </tr> |
|
184 </table> |
|
185 </div> |
|
186 </form> |