8 */ |
8 */ |
9 |
9 |
10 echo "<table>\n"; |
10 echo "<table>\n"; |
11 echo "<tr><td>Infotitel: </td><td>" . $inf["iname"] . "<td></td></tr>\n"; |
11 echo "<tr><td>Infotitel: </td><td>" . $inf["iname"] . "<td></td></tr>\n"; |
12 echo "<tr><td>Kurzinfo: </td><td>" . nl2br($inf["ilong"]) . "<td></td></tr>\n"; |
12 echo "<tr><td>Kurzinfo: </td><td>" . nl2br($inf["ilong"]) . "<td></td></tr>\n"; |
|
13 echo "<tr><td>Kennzeichen: </td><td>" . $inf["sort"] . "<td></td></tr>\n"; |
13 // Infoyp |
14 // Infoyp |
14 $sql = "SELECT infotyp_ID, infotyp_bez FROM Info_Typ |
15 $sql = "SELECT infotyp_ID, infotyp_bez FROM Info_Typ |
15 WHERE infotyp_ID = '" . $inf['ityp'] . "'"; |
16 WHERE infotyp_ID = '" . $inf['ityp'] . "'"; |
16 if ($result = $dbc->queryObjectArray($sql)) |
17 if ($result = $dbc->queryObjectArray($sql)) |
17 { |
18 { |
18 foreach ($result as $row) |
19 foreach ($result as $row) |
19 echo "<tr><td>Infoyp: </td><td>" . $row->infotyp_bez . "</td></tr>\n"; |
20 echo "<tr><td>Infoyp: </td><td>" . $row->infotyp_bez . "</td></tr>\n"; |
20 } |
21 } |
21 if (is_object($idat)) $sdat = $idat->format('d.m.Y'); else $sdat = " "; |
22 // Datums |
|
23 if (is_object($idat)) |
|
24 $sdat = $idat->format('d.m.Y'); |
|
25 elseif ($inf["cdat"]) |
|
26 {$sdat = new DateTime($inf["cdat"]); $sdat = $sdat->format("d.m.Y");} |
|
27 else $sdat = " "; |
22 echo "<tr><td>Erstellungsdatum: </td><td>$sdat</td></tr>\n"; |
28 echo "<tr><td>Erstellungsdatum: </td><td>$sdat</td></tr>\n"; |
23 if (is_object($bdat)) $sdat = $bdat->format('d.m.Y'); else $sdat = " "; |
29 if (is_object($bdat)) |
|
30 $sdat = $bdat->format('d.m.Y'); |
|
31 elseif ($inf["vdat"]) |
|
32 {$sdat = new DateTime($inf["vdat"]); $sdat = $sdat->format("d.m.Y");} |
|
33 else $sdat = " "; |
24 echo "<tr><td>gültig ab: </td><td>$sdat</td></tr>\n"; |
34 echo "<tr><td>gültig ab: </td><td>$sdat</td></tr>\n"; |
25 if (is_object($edat)) $sdat = $edat->format('d.m.Y'); else $sdat = " "; |
35 if (is_object($edat)) |
|
36 $sdat = $edat->format('d.m.Y'); |
|
37 elseif ($inf["bdat"]) |
|
38 {$sdat = new DateTime($inf["bdat"]); $sdat = $sdat->format("d.m.Y");} |
|
39 else $sdat = " "; |
26 echo "<tr><td>gültig bis: </td><td>$sdat</td></tr>\n"; |
40 echo "<tr><td>gültig bis: </td><td>$sdat</td></tr>\n"; |
27 // Autor |
41 // Autor |
28 if ($inf["pers"]) |
42 if ($inf["pers"]) |
29 { |
43 { |
30 $sql = "SELECT CONCAT (nachname, ', ',vorname) as pname FROM fhiiqm.Mitarbeiter WHERE persknr=" . $inf["pers"] . " ORDER BY pname"; |
44 $sql = "SELECT CONCAT (nachname, ', ',vorname) as pname FROM fhiiqm.Mitarbeiter WHERE persknr=" . $inf["pers"] . " ORDER BY pname"; |
78 } |
92 } |
79 $eins = false; |
93 $eins = false; |
80 } |
94 } |
81 } |
95 } |
82 } |
96 } |
|
97 //Verantwortliche+Prioritaet |
|
98 if (isset($inf["vpers"])&& is_array($inf["vpers"])) |
|
99 { |
|
100 echo "<tr><td>Verantwortliche(r):</td>"; |
|
101 for ($k=0; $k<count($inf["vpers"]); $k++) |
|
102 { |
|
103 if ($k == 0) $leer = ""; else $leer = "<td> </td>"; |
|
104 $sql = "SELECT CONCAT (nachname, ', ',vorname) as pname FROM fhiiqm.Mitarbeiter WHERE persknr=" . $inf["vpers"][$k]; |
|
105 $pname = $dbc -> querySingleItem($sql); |
|
106 echo "$leer<td>".$pname." Bemerkung: ".$inf["prio"][$k]."</td></tr>"; |
|
107 } |
|
108 } |
83 // Bezug zu anderer Info |
109 // Bezug zu anderer Info |
84 if ($inf["infrel"]) |
110 if ($inf["infrel"]) |
85 { |
111 { |
86 $sql = "SELECT info_name_s FROM Info WHERE info_ID = " . $inf["infrel"]; |
112 $sql = "SELECT info_name_s FROM Info WHERE info_ID = " . $inf["infrel"]; |
87 if ($result = $dbc->queryObjectArray($sql)) |
113 if ($result = $dbc->queryObjectArray($sql)) |