163         if ($filter>'!') echo "<tr><td class='bigger' colspan=6>Filter: ". $fields["$fnum"] . " wie '$filter'</td><tr>\n";

   163         if ($filter>'!') echo "<tr><td class='bigger' colspan=6>Filter: ". $fields["$fnum"] . " wie '$filter'</td><tr>\n";

   164 //        echo "<tr bgcolor='#CFDEF0'><th>Bezeichnung</th><th>Titel</th><th>Beschreibung</th><th>Typ</th><th>Beginn</th><th>Ende</th><th>K&uuml;nd.frist(mon)</th>

   164 //        echo "<tr bgcolor='#CFDEF0'><th>Bezeichnung</th><th>Titel</th><th>Beschreibung</th><th>Typ</th><th>Beginn</th><th>Ende</th><th>K&uuml;nd.frist(mon)</th>

   165 //                <th>Dokument</th><th>Bemerkung</th><th>&nbsp;</th></tr>\n";

   165 //                <th>Dokument</th><th>Bemerkung</th><th>&nbsp;</th></tr>\n";

   166 

   166 

   167         echo "<tr bgcolor='#68ACBF'>";

   167         echo "<tr bgcolor='#68ACBF'>";

   168         tab_column(2,"Bezeichnung",$sort,$dir,2,$fnum,$filter,$start,$zeil);

   169         tab_column(2,"Bezeichnung",$sort,$dir,2,$fnum,$filter,$start,$zeil);

   169         tab_column(3,"Beschreibung",$sort,$dir,0,$fnum,$filter,$start,$zeil);

   170         tab_column(3,"Beschreibung",$sort,$dir,0,$fnum,$filter,$start,$zeil);

   170         tab_column(6,"Typ",$sort,$dir,6,$fnum,$filter,$start,$zeil);

   171         tab_column(6,"Typ",$sort,$dir,6,$fnum,$filter,$start,$zeil);

   171         tab_column(7,"zu Produkt",$sort,$dir,7,$fnum,$filter,$start,$zeil);

   172         tab_column(7,"zu Produkt",$sort,$dir,7,$fnum,$filter,$start,$zeil);

   173         tab_column(4,"Bearbeiter",$sort,$dir,4,$fnum,$filter,$start,$zeil);

   173         tab_column(4,"Bearbeiter",$sort,$dir,4,$fnum,$filter,$start,$zeil);

   174         tab_column(5,"Dokument",$sort,$dir,0,$fnum,$filter,$start,$zeil);

   174         tab_column(5,"Dokument",$sort,$dir,0,$fnum,$filter,$start,$zeil);

   175         echo "<th>&nbsp;</th></tr>\n";

   175         echo "<th>&nbsp;</th></tr>\n";

   176         foreach ($result as $row)

   176         foreach ($result as $row)

   177         {

   177         {

   178 			if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;

   178 			if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;

   179             echo "<tr bgcolor='" . $bg . "'>";

   179             echo "<tr bgcolor='" . $bg . "'>";

   180             if ($row->cend)

   181             if ($row->cend)

   181             {

   182             {

   182                 $ce = new DateTime($row->cend);

   183                 $ce = new DateTime($row->cend);

   183                 if ((!$row->cauto || is_null($row->cauto)) && $heute > $ce) $class="class='red'"; else $class="";

   184                 if ((!$row->cauto || is_null($row->cauto)) && $heute > $ce) $class="class='red'"; else $class="";

   184             }

   185             }

   186             echo "<td width='17%' $class><b>$row->cname<br /></b></td>";    

   187             echo "<td width='17%' $class><b>$row->cname<br /></b></td>";    

   187 //            echo "<td>$row->contract_s</td>";    

   188 //            echo "<td>$row->contract_s</td>";    

   188             echo "<td width='22%'>" . nl2br($row->clong) . "</td>";    

   189             echo "<td width='22%'>" . nl2br($row->clong) . "</td>";    

   189             echo "<td>$row->typ</td>";    

   190             echo "<td>$row->typ</td>";    

   190             echo "<td>$row->prod</td>";

   191             echo "<td>$row->prod</td>";

   192             echo "<td>$row->bearb</td>";

   192             echo "<td>$row->bearb</td>";

   193             if (file_exists("documents/".$row->doc))

   193             if (file_exists("documents/".$row->doc))

   194             {

   194             {

   195                 $doc = substr($row->doc,strpos($row->doc,"_")+1); 

   195                 $doc = substr($row->doc,strpos($row->doc,"_")+1); 

   196                 echo "<td><a href='documents/$row->doc'>$doc</a></td>";

   196                 echo "<td><a href='documents/$row->doc'>$doc</a></td>";