fhiiqm/report/info_report_gvp.php
changeset 26 3c1e3ac7089f
parent 25 482252ff12fd
child 29 72f79dab938e
equal deleted inserted replaced
25:482252ff12fd 26:3c1e3ac7089f
     2 
     2 
     3 /**
     3 /**
     4  * @author Bettina Schwarzer, Fritz-Haber-Institut
     4  * @author Bettina Schwarzer, Fritz-Haber-Institut
     5  * @copyright 02/2012
     5  * @copyright 02/2012
     6  * 
     6  * 
     7  * Report Info
     7  * Report Info (GVP)
     8  * 
     8  * 
     9  */
     9  */
    10 
    10 
    11     error_reporting(E_ALL ^ E_NOTICE);
    11     error_reporting(E_ALL ^ E_NOTICE);
    12     
    12     
   198                 echo "<div class='pr' align='center'><h3>Gesch&auml;ftsverteilungsplan nach Kennzeichen</h3></div>\n"; // Anzeige nur im Ausdruck
   198                 echo "<div class='pr' align='center'><h3>Gesch&auml;ftsverteilungsplan nach Kennzeichen</h3></div>\n"; // Anzeige nur im Ausdruck
   199                 echo "<table border='1' cellspacing='0' cellpadding='2' width=99%>\n";
   199                 echo "<table border='1' cellspacing='0' cellpadding='2' width=99%>\n";
   200                 // Listenkopf
   200                 // Listenkopf
   201                 echo "<tr bgcolor='#68ACBF'>";
   201                 echo "<tr bgcolor='#68ACBF'>";
   202                 echo "<th width='5%'>Kennzeichen</th>";
   202                 echo "<th width='5%'>Kennzeichen</th>";
   203                 echo "<th width='10%'>Produktgruppe</th>";
   203 //                echo "<th width='10%'>Produktgruppe</th>";
   204                 echo "<th width='25%'>Aufgabe (prod)</th>";
   204                 echo "<th width='25%'>Aufgabe (prod)</th>";
   205                 echo "<th width='25%'>Teilgebiet (info)</th>";
   205                 echo "<th width='35%'>Teilgebiet (kurzinfo)</th>";
   206                 echo "<th>Zust&auml;ndigkeit</th>";
   206                 echo "<th>Zust&auml;ndigkeit</th>";
   207         		$bg1 = "#F8F8F8";
   207         		$bg1 = "#F8F8F8";
   208         		$bg2 = "#DEDFE1";
   208         		$bg2 = "#DEDFE1";
   209         		$bg = "#FFFFFF";
   209         		$bg = "#FFFFFF";
   210                 foreach ($result as $row)
   210                 foreach ($result as $row)
   219                         //$start = false;
   219                         //$start = false;
   220                     }
   220                     }
   221          			if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
   221          			if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
   222                     echo "<tr bgcolor='" . $bg . "'>";
   222                     echo "<tr bgcolor='" . $bg . "'>";
   223                     echo "<td>$row->infsort</td>";
   223                     echo "<td>$row->infsort</td>";
   224                     echo "<td>$pgb</td>";
   224 //                    echo "<td>$pgb</td>";
   225                     echo "<td>$prod</td>";
   225                     echo "<td>$prod</td>";
   226                     echo "<td>$row->iname</td>";
   226 //                    echo "<td>$row->iname</td>";
       
   227                     echo "<td>".nl2br($row->ilong)."</td>";
   227                     echo "<td>".str_replace(";","<br />",$row->verantw)."</td></tr>\n";
   228                     echo "<td>".str_replace(";","<br />",$row->verantw)."</td></tr>\n";
   228                     $pgv = $pg;
   229                     $pgv = $pg;
   229                 }
   230                 }
   230             }
   231             }
   231             else
   232             else
   276                         // Listenkopf
   277                         // Listenkopf
   277                         echo "<tr bgcolor='#68ACBF'>";
   278                         echo "<tr bgcolor='#68ACBF'>";
   278                         echo "<th width='5%'>Kennzeichen</th>";
   279                         echo "<th width='5%'>Kennzeichen</th>";
   279 //                        echo "<th>Infotyp</th>";
   280 //                        echo "<th>Infotyp</th>";
   280                         echo "<th width='30%'>Aufgabe (prod)</th>";
   281                         echo "<th width='30%'>Aufgabe (prod)</th>";
   281                         echo "<th width='30%'>Teilgebiet (info)</th>";
   282                         echo "<th width='30%'>Teilgebiet (kurzinfo)</th>";
   282 //                        echo "<th width='40%'>Kurzinfo</th>";
   283 //                        echo "<th width='40%'>Kurzinfo</th>";
   283                         echo "<th>Zust&auml;ndigkeit</th>";
   284                         echo "<th>Zust&auml;ndigkeit</th>";
   284                 		$bg1 = "#F8F8F8";
   285                 		$bg1 = "#F8F8F8";
   285                 		$bg2 = "#DEDFE1";
   286                 		$bg2 = "#DEDFE1";
   286                 		$bg = "#FFFFFF";
   287                 		$bg = "#FFFFFF";
   289         			if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
   290         			if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
   290                     echo "<tr bgcolor='" . $bg . "'>";
   291                     echo "<tr bgcolor='" . $bg . "'>";
   291                     echo "<td>$row->infsort</td>";
   292                     echo "<td>$row->infsort</td>";
   292 //                    echo "<td>$row->ityp</td>";
   293 //                    echo "<td>$row->ityp</td>";
   293                     echo "<td>".$prod."</td>";
   294                     echo "<td>".$prod."</td>";
   294                     echo "<td>$row->iname</td>";
   295 //                    echo "<td>$row->iname</td>";
   295 //                        echo "<td>".nl2br($row->ilong)."</td>";
   296                     echo "<td>".nl2br($row->ilong)."</td>";
   296                     echo "<td>".str_replace(";","<br />",$row->verantw)."</td></tr>\n";
   297                     echo "<td>".str_replace(";","<br />",$row->verantw)."</td></tr>\n";
   297 
   298 
   298                     $vprodid = $row->prodid;
   299                     $vprodid = $row->prodid;
   299                     $vpg = $pg;
   300                     $vpg = $pg;
   300                     $vpb = $pb;
   301                     $vpb = $pb;