<?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";
            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";
            }
            // 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 = "&nbsp;";
            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 = "&nbsp;";
            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 = "&nbsp;";
            echo "<tr><td>g&uuml;ltig bis: </td><td>$sdat</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;                    
                    }
                }    
             }   
            // 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+Prioritaet
            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>";    
                }
            }
            // 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";
            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";

?>