|
1 <?php |
|
2 |
|
3 /** |
|
4 * @author Bettina Schwarzer, Fritz-Haber-Institut |
|
5 * @copyright 10/2013 |
|
6 * |
|
7 * Form Recherche Laser |
|
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_las" 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="las[abt]" size="1"> |
|
27 <?php |
|
28 if ($las["abt"] == -1) $select = " selected "; else $select = ""; |
|
29 echo "<option $select value=\"-1\"></option>\n"; |
|
30 $sql = "SELECT abt_name, abt_long FROM Abteilung WHERE abt_ID < 6 ORDER BY abt_ID"; // nur wiss. Abt. |
|
31 if ($result = $dbc->queryObjectArray($sql)) |
|
32 { |
|
33 foreach ($result as $row) |
|
34 { |
|
35 if ($row->abt_name == $las['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>Haus</td> |
|
47 <td> |
|
48 <select name="las[geb]" size="1" onchange="this.form.submit();"> |
|
49 <?php |
|
50 if ($las["geb"] == -1) $select = " selected "; else $select = ""; |
|
51 echo "<option $select value=\"-1\"></option>\n"; |
|
52 $sql = "SELECT geb_ID, geb_name FROM Haus ORDER BY 1"; |
|
53 if ($result = $dbc->queryObjectArray($sql)) |
|
54 { |
|
55 foreach ($result as $row) |
|
56 { |
|
57 if ($row->geb_ID == $las['geb']) |
|
58 echo "<option selected value=\"$row->geb_ID\">$row->geb_ID - $row->geb_name</option>\n"; |
|
59 else |
|
60 echo "<option value=\"$row->geb_ID\">$row->geb_ID - $row->geb_name</option>\n"; |
|
61 } |
|
62 } |
|
63 ?> |
|
64 </select> |
|
65 </td> |
|
66 </tr> |
|
67 <tr> |
|
68 <td>Raum-Nummer</td> |
|
69 <td><select name="las[rnum]"> |
|
70 <?php |
|
71 if ($las["rnum"] == "0") $select = " selected "; else $select = ""; |
|
72 echo "<option $select value=\"0\"></option>\n"; |
|
73 if (isset($las["geb"]) && $las["geb"] > "") $where = " WHERE geb_ID = '".$las["geb"]."'"; else $where = ""; |
|
74 echo "Gebaeude: ".$las["geb"]."<br />\n"; |
|
75 $sql = "SELECT geb_ID, raum_ID,raum_nr,raum_name FROM fhiiqm.Raum $where ORDER BY 1,3"; |
|
76 if ($result = $dbc->queryObjectArray($sql)) |
|
77 { |
|
78 foreach ($result as $row) |
|
79 { |
|
80 if ($row->raum_ID == $las['rnum']) |
|
81 echo "<option selected value=\"$row->raum_ID\">$row->geb_ID - $row->raum_nr, $row->raum_name</option>\n"; |
|
82 else |
|
83 echo "<option value=\"$row->raum_ID\">$row->geb_ID - $row->raum_nr, $row->raum_name</option>\n"; |
|
84 } |
|
85 } |
|
86 ?> |
|
87 </select> |
|
88 </td> |
|
89 </tr> |
|
90 <tr> |
|
91 <td>Laser-Klasse</td> |
|
92 <td><select name="las[kl]"> |
|
93 <?php |
|
94 if ($las["kl"] == -1) $select = " selected "; else $select = ""; |
|
95 echo "<option $select value=\"-1\"></option>\n"; |
|
96 $sql = "SELECT las_klasse_ID,las_klasse_bez FROM fhiiqm.Laser_Klasse |
|
97 ORDER BY 1"; |
|
98 if ($result = $dbc->queryObjectArray($sql)) |
|
99 { |
|
100 foreach ($result as $row) |
|
101 { |
|
102 if ($row->las_klasse_ID == $las['kl']) |
|
103 echo "<option selected value=\"$row->las_klasse_ID\">$row->las_klasse_bez</option>\n"; |
|
104 else |
|
105 echo "<option value=\"$row->las_klasse_ID\">$row->las_klasse_bez</option>\n"; |
|
106 } |
|
107 } |
|
108 ?> |
|
109 </select> |
|
110 </td> |
|
111 </tr> |
|
112 <tr> |
|
113 <td>Verknüpfung</td> |
|
114 <td>UND |
|
115 <input type="radio" name="las[bind]" value="AND" <?php if (isset($las["bind"]) && $las["bind"]=="AND") echo "checked"; else echo "checked";?>> |
|
116 ODER |
|
117 <input type="radio" name="las[bind]" value="OR" <?php if (isset($las["bind"]) && $las["bind"]=="OR") echo "checked"; ?>></td> |
|
118 </tr> |
|
119 <tr> |
|
120 <td>Sortierung nach<br />(in dieser Reihenfolge)</td><td> |
|
121 <?php |
|
122 $sort = array("-1"=>"","4"=>"Abteilung","5"=>"Haus","7"=>"Raum-Nr.","3"=>"Klasse"); |
|
123 for ($i=1; $i<3; $i++) |
|
124 { |
|
125 echo "$i. <select name='las[sort$i]'>\n"; |
|
126 foreach ($sort as $key=>$val) |
|
127 { |
|
128 $rsort = "sort" . $i; |
|
129 if ($las[$rsort] == $val) $select= " selected"; else $select = ""; |
|
130 echo "<option$select value='$key'>$val</option>\n"; |
|
131 } |
|
132 echo "</select> \n"; |
|
133 } |
|
134 echo "</td></tr>\n"; |
|
135 |
|
136 $azeil = array(1=>'1',10=>'10',20=>'20',25=>'25',50=>'50',100=>'100',9999=>'alle'); // Anzahl gezeigter rows |
|
137 echo "<tr><td>Zeilen/Seite?</td><td><select name='las[z]'>\n"; |
|
138 if (!$las['z']) $las['z'] = 9999; |
|
139 foreach ($azeil as $key=>$val) |
|
140 { |
|
141 if ($key == $las['z']) $select = "selected"; else $select = ""; |
|
142 echo "<option $select value='$key'>$val</option>\n"; |
|
143 } |
|
144 echo "</select></td></tr>\n"; |
|
145 |
|
146 ?> |
|
147 <tr> |
|
148 <td> </td> |
|
149 <td><input class="button" type="submit" name="search" value="Bericht erstellen"/></td> |
|
150 </tr> |
|
151 </table> |
|
152 </div> |
|
153 </form> |