1 <?php

     2 

     3 /**

     4  * @author Bettina Schwarzer, Fritz-Haber-Institut

     5  * @copyright 08/2011

     6  * 

     7  * Anlisten Info - INSERT/UPDATE-Daten

     8  */

     9 

    10             echo "<table>\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";

    13             // Infoyp

    14             $sql = "SELECT infotyp_ID, infotyp_bez FROM Info_Typ

    15                         WHERE infotyp_ID = '" . $inf['ityp'] . "'";

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

    17             {

    18                 foreach ($result as $row)

    19                 echo "<tr><td>Infoyp: </td><td>" . $row->infotyp_bez . "</td></tr>\n";

    20             }

    21             if (is_object($idat)) $sdat = $idat->format('d.m.Y'); else $sdat = " ";

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

    23             if (is_object($bdat)) $sdat = $bdat->format('d.m.Y'); else $sdat = " ";

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

    25             if (is_object($edat)) $sdat = $edat->format('d.m.Y'); else $sdat = " ";

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

    27             // Autor

    28             if ($inf["pers"])

    29             { 

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

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

    32                 {

    33                     foreach ($result as $row)

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

    35                 }

    36             }

    37             // Produkt

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

    39             {

    40                 $eins = true;

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

    42                 {

    43                     if ($pid>0)

    44                     {

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

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

    47                         {

    48                             foreach ($result as $row)

    49                             {

    50                                 if ($eins)

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

    52                                 else

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

    54                             }    

    55                         }

    56                         $eins = false;                    

    57                     }

    58                 }    

    59              }   

    60             // Adressat

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

    62             {

    63                 $eins = true;

    64                 foreach ($inf['adr'] as $adr)

    65                 {

    66                     if ($adr != -1)

    67                     { 

    68                         $sql = "SELECT info_adr_name FROM Adressat WHERE info_adr_id = $adr";

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

    70                         {

    71                             foreach ($result as $row)

    72                             {

    73                                 if ($eins)

    74                                     echo "<tr><td>Adressat: </td><td>$row->info_adr_name</td></tr>\n";

    75                                 else

    76                                     echo "<tr><td>&nbsp; </td><td>$row->info_adr_name</td></tr>\n";

    77                             }

    78                         }

    79                         $eins = false;                    

    80                     }

    81                 }

    82             }

    83             // Bezug zu anderer Info

    84             if ($inf["infrel"])

    85             {

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

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

    88                 {

    89                     foreach ($result as $row)

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

    91                 }

    92             }

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

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

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

    96             else

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

    98             echo "</table>\n";

    99 

   100 ?>