| author | schwarzer@hyperion.rz-berlin.mpg.de |
| Mon, 01 Jul 2013 14:36:18 +0200 | |
| changeset 38 | 45c139f74ea4 |
| permissions | -rw-r--r-- |
|
38
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
1 |
<?php |
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
2 |
|
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
3 |
/** |
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
4 |
* @author Bettina Schwarzer, Fritz-Haber-Institut |
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
5 |
* @copyright 05/2013 |
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
6 |
* |
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
7 |
* Anlisten INSERT/UPDATE Daten Keytyp |
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
8 |
*/ |
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
9 |
|
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
10 |
echo "<table>\n"; |
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
11 |
echo "<tr><td>Schlüsseltyp: </td><td>" . $ky["typ"] . "</td></tr>\n"; |
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
12 |
echo "<tr><td>Level: </td><td>" . $ky["level"] . "</td></tr>\n"; |
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
13 |
echo "<tr><td>Parent-Level: </td><td>" . $ky["parent"] . "</td></tr>\n"; |
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
14 |
if ($ky["hier"]) |
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
15 |
{
|
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
16 |
$sql = "SELECT key_hiertyp_bez FROM Key_Hiertyp WHERE key_hiertyp_ID ='" . $ky["hier"] ."'"; |
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
17 |
$hier = $dbc -> querySingleItem($sql); |
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
18 |
echo "<tr><td>Hierarchietyp: </td><td>" . $ky["hier"] . " - $hier</td></tr>\n"; |
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
19 |
} |
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
20 |
else echo "<tr><td>Hierarchietyp: </td><td> </td></tr>\n"; |
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
21 |
echo "<tr><td>Bezeichnung: </td><td>" . $ky["bez"] . "</td></tr>\n"; |
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
22 |
if ($ky["anl"]) |
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
23 |
{
|
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
24 |
$sql = "SELECT key_anl_bez FROM Key_Anlage WHERE key_anl_ID = ".$ky["anl"]; |
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
25 |
$anl = $dbc -> querySingleItem($sql); |
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
26 |
echo "<tr><td>Schließanlage: </td><td>$anl</td></tr>\n"; |
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
27 |
} |
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
28 |
else echo "<tr><td>Schließanlage: </td><td> </td></tr>\n"; |
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
29 |
echo "</table>\n"; |
|
45c139f74ea4
+ Laborinfo; Keytyp-Verwaltung
schwarzer@hyperion.rz-berlin.mpg.de
parents:
diff
changeset
|
30 |
?> |