<?php

/**

 * @author Bettina Schwarzer, Fritz-Haber-Institut

 * @copyright 08/2011

 * 

 * Anlisten Info - INSERT/UPDATE-Daten

 */

            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";

            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'] . "'";

            if ($result = $dbc->queryObjectArray($sql))

            {

                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');  

            elseif ($inf["cdat"])

                {$sdat = new DateTime($inf["cdat"]); $sdat = $sdat->format("d.m.Y");}

            else $sdat = " ";

            echo "<tr><td>Erstellungsdatum: </td><td>$sdat</td></tr>\n";

            if (is_object($bdat)) 

                $sdat = $bdat->format('d.m.Y');

            elseif ($inf["vdat"])

                {$sdat = new DateTime($inf["vdat"]); $sdat = $sdat->format("d.m.Y");}

            else $sdat = " ";

            echo "<tr><td>g&uuml;ltig ab: </td><td>$sdat</td></tr>\n";

            if (is_object($edat)) 

                $sdat = $edat->format('d.m.Y'); 

            elseif ($inf["bdat"])

                {$sdat = new DateTime($inf["bdat"]); $sdat = $sdat->format("d.m.Y");}

            else $sdat = " ";

            echo "<tr><td>g&uuml;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"])

            { 

                $sql = "SELECT CONCAT (nachname, ', ',vorname) as pname FROM fhiiqm.Mitarbeiter WHERE persknr=" . $inf["pers"] . " ORDER BY pname";

                if ($result = $dbc->queryObjectArray($sql))

                {

                    foreach ($result as $row)

                    echo "<tr><td>Autor: </td><td>" . $row->pname. "</td></tr>\n";

                }

            }

            // Produkt

            if (is_array($inf["prid"]) && count($inf["prid"])>0)

            {

                $eins = true;

                foreach ($inf["prid"] as $pid)

                {

                    if ($pid>0)

                    {

                        $sql = "SELECT prod_name FROM Produkt WHERE produkt_ID = $pid";

                        if ($result = $dbc -> queryObjectArray($sql))

                        {

                            foreach ($result as $row)

                            {

                                if ($eins)

                                    echo "<tr><td>zugeordnet zu: </td><td>" .  $row->prod_name. "</td></tr>\n";

                                else

                                    echo "<tr><td>&nbsp; </td><td>" .  $row->prod_name. "</td></tr>\n";

                            }    

                        }

                        $eins = false;                    

                    }

                }    

             }   

            if ($inf[ityp] != 7)

            {

                // Adressat aus Adressat

                if (is_array($inf['adr']))

                {

                    $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>&nbsp; </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)

                    { 

                        if ($k == 0) $leer = ""; else $leer = "<td>&nbsp;</td>";

                        $sql = "SELECT CONCAT (nachname, ', ',vorname) as pname FROM fhiiqm.Mitarbeiter WHERE persknr=$pnr";

                        $pname = $dbc -> querySingleItem($sql);                    

                        echo "$leer<td>".$pname."&nbsp;&nbsp;&nbsp;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>&nbsp;</td>";

                        $sql = "SELECT CONCAT (nachname, ', ',vorname) as pname FROM fhiiqm.Mitarbeiter WHERE persknr=" . $inf["vpers"][$k];

                        $pname = $dbc -> querySingleItem($sql);                    

                        echo "$leer<td>".$pname."&nbsp;&nbsp;&nbsp;Bemerkung: ".$inf["prio"][$inf["vpers"][$k]]."</td></tr>";    

                    }

                }

                if ($inf['ityp'] == 6 && strtolower(substr($inf['sort'],0,2)) == 'bk' && $inf['betr'])

                {

                    echo "<tr><td>KST: Obergrenze Bestellwert (&euro;):</td><td>".$inf['betr']."</td></tr>\n";   

                }            

            }

            else

            {

                // 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>&nbsp; </td><td>$adr - $row->fkt_bez</td></tr>\n";

                                }

                            }

                            $eins = false;                    

                        }

                    }

                }

            }

            if ($inf['ityp'] == 81 && $inf['anl'] > -1) // Betriebsanweisung Anlage

            {

                $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))

                {

                    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

            if ($inf["infrel"])

            {

                $sql = "SELECT info_name_s FROM Info WHERE info_ID = " . $inf["infrel"];

                if ($result = $dbc->queryObjectArray($sql))

                {

                    foreach ($result as $row)

                    echo "<tr><td>bezieht sich auf Info: </td><td>" . $row->info_name_s . "</td></tr>\n";

                }

            }

            echo "<tr><td>Sprache: </td><td>" . $inf["lang"] . "</td></tr>\n";

            // Infodokumente   

            if (is_array($inf['ifname']) && count($inf['ifname']) > 0)

            {

                echo "<tr><td>Dokumente, <em>Schlagworte</em>:</td><td>";

                foreach ($inf['ifname'] as $key => $value)

                {

                    if ($value)

                    {

                        if (substr($value,0,$len) != $infid . "_") $file = $infid . "_".$value; else $file = $value;

                        if (file_exists("infos/$file")) 

                            echo "<a href='infos/$file'>" . $value. "</a>, <em>". $inf['swort'][$key]. "</em><br />";

                        else 

                            echo "$value, <em>".$inf['swort'][$key]. "</em><br />";

                    }

                }

                echo "</td></tr>\n";

            }

            else

            {

                if (file_exists("infos/$ifile"))

                    echo "<tr><td>Dateibezeichnung Info: </td><td><a href='infos/$ifile'>" . $ifile. "</a></td></tr>\n";

                else

                    echo "<tr><td>Dateibezeichnung Info: </td><td>$ifile</td></tr>\n";

            }

            echo "</table>\n";

?>