--- a/fhiiqm/inc/info_dat_show.inc.php Thu Jul 12 13:29:11 2012 +0200
+++ b/fhiiqm/inc/info_dat_show.inc.php Thu Aug 23 10:17:50 2012 +0200
@@ -10,7 +10,7 @@
echo "<table>\n";
echo "<tr><td>Infotitel: </td><td>" . $inf["iname"] . "</td></tr>\n";
echo "<tr><td>Kurzinfo: </td><td>" . nl2br($inf["ilong"]) . "</td></tr>\n";
- echo "<tr><td>Kennzeichen: </td><td>" . $inf["sort"] . "</td></tr>\n";
+ if ($ityp != 8) echo "<tr><td>Kennzeichen: </td><td>" . $inf["sort"] . "</td></tr>\n";
// Infoyp
$sql = "SELECT infotyp_ID, infotyp_bez FROM Info_Typ
WHERE infotyp_ID = '" . $inf['ityp'] . "'";
@@ -19,6 +19,18 @@
foreach ($result as $row)
echo "<tr><td>Infoyp: </td><td>" . $row->infotyp_bez . "</td></tr>\n";
}
+ // Ort
+ if ($inf['geb'] > -1 && is_null($inf['raum']))
+ echo "<tr><td>Ort: </td><td>Haus " . $inf["geb"] . "</td></tr>\n";
+ elseif ($inf['raum'] > -1)
+ {
+ $sql = "SELECT geb_ID, raum_nr, raum_name FROM Raum WHERE raum_ID= ". $inf['raum'];
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ echo "<tr><td>Ort: </td><td>$row->geb_ID: $row->raum_nr, $row->raum_name</td></tr>\n";
+ }
+ }
// Datums
if (is_object($idat))
$sdat = $idat->format('d.m.Y');
@@ -38,6 +50,13 @@
{$sdat = new DateTime($inf["bdat"]); $sdat = $sdat->format("d.m.Y");}
else $sdat = " ";
echo "<tr><td>gültig bis: </td><td>$sdat</td></tr>\n";
+ // Freigabe
+ if ($inf["fg"])
+ {
+ $sql = "SELECT info_freigabe_bez FROM Info_Freigabe WHERE info_Freigabe_ID=".$inf["fg"];
+ $sfg = $dbc -> querySingleItem($sql);
+ echo "<tr><td>Status Freigabe: </td><td>$sfg</td></tr>\n";
+ }
// Autor
if ($inf["pers"])
{
@@ -71,54 +90,94 @@
}
}
}
- // Adressat
- if (is_array($inf['adr']))
+ if ($inf[ityp] != 7)
{
- $eins = true;
- foreach ($inf['adr'] as $adr)
+ // Adressat aus Adressat
+ if (is_array($inf['adr']))
{
- if ($adr != -1)
+ $eins = true;
+ foreach ($inf['adr'] as $adr)
+ {
+ if ($adr != -1)
+ {
+ $sql = "SELECT info_adr_name FROM Adressat WHERE info_adr_id = $adr";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($eins)
+ echo "<tr><td>Adressat: </td><td>$row->info_adr_name</td></tr>\n";
+ else
+ echo "<tr><td> </td><td>$row->info_adr_name</td></tr>\n";
+ }
+ }
+ $eins = false;
+ }
+ }
+ }
+ //Verantwortliche+Bemerkung(prio)
+ if (isset($inf["vpn"]) && $inf["vpn"])
+ {
+ $parr = explode(",",$inf["vpn"]);
+ $k = 0;
+ echo "<tr><td>Verantwortliche(r):</td>";
+ foreach ($parr as $pnr)
{
- $sql = "SELECT info_adr_name FROM Adressat WHERE info_adr_id = $adr";
- if ($result = $dbc->queryObjectArray($sql))
- {
- foreach ($result as $row)
- {
- if ($eins)
- echo "<tr><td>Adressat: </td><td>$row->info_adr_name</td></tr>\n";
- else
- echo "<tr><td> </td><td>$row->info_adr_name</td></tr>\n";
- }
- }
- $eins = false;
+ if ($k == 0) $leer = ""; else $leer = "<td> </td>";
+ $sql = "SELECT CONCAT (nachname, ', ',vorname) as pname FROM fhiiqm.Mitarbeiter WHERE persknr=$pnr";
+ $pname = $dbc -> querySingleItem($sql);
+ echo "$leer<td>".$pname." Bemerkung: ".$inf["prio"][$pnr]."</td></tr>";
+ $k=1;
+ }
+
+ }
+ elseif (isset($inf["vpers"])&& is_array($inf["vpers"]) )
+ {
+ echo "<tr><td>Verantwortliche(r):</td>";
+ for ($k=0; $k<count($inf["vpers"]); $k++)
+ {
+ if ($k == 0) $leer = ""; else $leer = "<td> </td>";
+ $sql = "SELECT CONCAT (nachname, ', ',vorname) as pname FROM fhiiqm.Mitarbeiter WHERE persknr=" . $inf["vpers"][$k];
+ $pname = $dbc -> querySingleItem($sql);
+ echo "$leer<td>".$pname." Bemerkung: ".$inf["prio"][$inf["vpers"][$k]]."</td></tr>";
}
}
}
- //Verantwortliche+Prioritaet
- if (isset($inf["vpn"]) && $inf["vpn"])
+ else
{
- $parr = explode(",",$inf["vpn"]);
- $k = 0;
- echo "<tr><td>Verantwortliche(r):</td>";
- foreach ($parr as $pnr)
- {
- if ($k == 0) $leer = ""; else $leer = "<td> </td>";
- $sql = "SELECT CONCAT (nachname, ', ',vorname) as pname FROM fhiiqm.Mitarbeiter WHERE persknr=$pnr";
- $pname = $dbc -> querySingleItem($sql);
- echo "$leer<td>".$pname." Bemerkung: ".$inf["prio"][$pnr]."</td></tr>";
- $k=1;
- }
+ // Adressat aus Funktion
+ if (is_array($inf['adr']))
+ {
+ $eins = true;
+ foreach ($inf['adr'] as $adr)
+ {
+ if ($adr != -1)
+ {
+ $sql = "SELECT fkt_bez FROM Funktion WHERE fkt_ID = '$adr'";
+ if ($result = $dbc->queryObjectArray($sql))
+ {
+ foreach ($result as $row)
+ {
+ if ($eins)
+ echo "<tr><td>Adressat: </td><td>$adr - $row->fkt_bez</td></tr>\n";
+ else
+ echo "<tr><td> </td><td>$adr - $row->fkt_bez</td></tr>\n";
+ }
+ }
+ $eins = false;
+ }
+ }
+ }
}
- elseif (isset($inf["vpers"])&& is_array($inf["vpers"]) )
+ if ($inf['ityp'] == 81 && $inf['anl'] > -1) // Betriebsanweisung Anlage
{
- echo "<tr><td>Verantwortliche(r):</td>";
- for ($k=0; $k<count($inf["vpers"]); $k++)
+ $sql = "SELECT al_bez,al_kat_bez FROM fhiiqm.Anlage a
+ LEFT JOIN A_Kategorie k ON a.al_kat_ID=k.al_kat_ID WHERE al_ID = " . $inf['anl'];
+ if ($result = $dbc->queryObjectArray($sql))
{
- if ($k == 0) $leer = ""; else $leer = "<td> </td>";
- $sql = "SELECT CONCAT (nachname, ', ',vorname) as pname FROM fhiiqm.Mitarbeiter WHERE persknr=" . $inf["vpers"][$k];
- $pname = $dbc -> querySingleItem($sql);
- echo "$leer<td>".$pname." Bemerkung: ".$inf["prio"][$inf["vpers"][$k]]."</td></tr>";
+ foreach ($result as $row)
+ echo "<tr><td>zu Anlage: </td><td>$row->al_bez ($row->al_kat_bez)</td></tr>\n";
}
}
// Bezug zu anderer Info