fhiiqm/report/info_allg_report.php
changeset 31 0a1eb975fbd9
parent 29 72f79dab938e
child 36 4411d3239444
equal deleted inserted replaced
30:d02d02efc55a 31:0a1eb975fbd9
   215     		$bg = "#FFFFFF";
   215     		$bg = "#FFFFFF";
   216             echo "<table border='1' cellspacing='0' cellpadding='2' width='99%'>\n";
   216             echo "<table border='1' cellspacing='0' cellpadding='2' width='99%'>\n";
   217             // Listenkopf
   217             // Listenkopf
   218             echo "<tr bgcolor='#68ACBF'>";
   218             echo "<tr bgcolor='#68ACBF'>";
   219             echo "<th>Kennzeichen</th>";
   219             echo "<th>Kennzeichen</th>";
   220             echo "<th>Infotitel</th>";
   220             echo "<th>ID: Infotitel</th>";
   221             echo "<th>zu Info</th>";
   221             echo "<th>zu Info</th>";
   222             echo "<th>Kurzinfo</th>";
   222             echo "<th>Kurzinfo</th>";
   223             if ($ityp == "''") echo "<th>Infotyp</th>";
   223             if ($ityp == "''") echo "<th>Infotyp</th>";
   224             echo "<th>Produkt</th>";
   224             echo "<th>Produkt</th>";
   225             if (substr($ityp,0,1) != 8) echo "<th>Adressat</th>";
   225             if (substr($ityp,0,1) != 8) echo "<th>Adressat</th>";
   249                     $adr = explode("; ",$row->adressat);
   249                     $adr = explode("; ",$row->adressat);
   250                     $adrs = "";
   250                     $adrs = "";
   251                     foreach ($adr as $val)
   251                     foreach ($adr as $val)
   252                         $adrs .= "; " . substr($val,0,strpos($val,"|")-1);
   252                         $adrs .= "; " . substr($val,0,strpos($val,"|")-1);
   253                     $adrs = substr($adrs,2);
   253                     $adrs = substr($adrs,2);
   254                     echo "<td>" . str_replace(";",";<br />",$adrs) . "</td>";
   254                     echo "<td>" . str_replace(";","<br />",$adrs) . "</td>";
   255                 }
   255                 }
   256                 if ($ityp == 7 || substr($ityp,0,1) == 8)   // 7 = Betriebsstörung, 8 = Betriebsanweisung
   256                 if ($ityp == 7 || substr($ityp,0,1) == 8)   // 7 = Betriebsstörung, 8 = Betriebsanweisung
   257                 {    if ($row->raum_ID)
   257                 {    if ($row->raum_ID)
   258                     {
   258                     {
   259                         $sql = "SELECT geb_ID, raum_nr FROM Raum WHERE raum_ID = $row->raum_ID";
   259                         $sql = "SELECT geb_ID, raum_nr FROM Raum WHERE raum_ID = $row->raum_ID";