Mercurial Mercurial > IQM / comparison
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | file | latest | revisions | annotate | diff | comparison | raw | help
Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
fhiiqm/vertrag_flist1.php
changeset 22 aae5b0ecc47b
parent 21 97dba0fe820c
child 26 3c1e3ac7089f
equal deleted inserted replaced
21:97dba0fe820c 22:aae5b0ecc47b 
   102     if ($result)
 
   102     if ($result)
 
   103     {
 
   103     {
 
   104 		$bg1 = "#F8F8F8";
 
   104 		$bg1 = "#F8F8F8";
 
   105 		$bg2 = "#DEDFE1";
 
   105 		$bg2 = "#DEDFE1";
 
   106 		$bg = "#FFFFFF";
 
   106 		$bg = "#FFFFFF";
 
       
   107         
       
   108         $heute = new DateTime();
 
   107         
   109         
   108         $vanz = $dbc -> querySingleItem("SELECT @anz");
 
   110         $vanz = $dbc -> querySingleItem("SELECT @anz");
 
   109         
   111         
   110         echo "<p><b>Vertr&auml;ge - &Uuml;bersicht</b></p>\n";
 
   112         echo "<p><b>Vertr&auml;ge - &Uuml;bersicht</b></p>\n";
 
   111         echo "<table border='0' cellspacing='0'>\n";
 
   113         echo "<table border='0' cellspacing='0'>\n";
 
   162         tab_column(5,"Dokument",$sort,$dir,0,$fnum,$filter,$start,$zeil);
 
   164         tab_column(5,"Dokument",$sort,$dir,0,$fnum,$filter,$start,$zeil);
 
   163         echo "<th>&nbsp;</th></tr>\n";
 
   165         echo "<th>&nbsp;</th></tr>\n";
 
   164         foreach ($result as $row)
 
   166         foreach ($result as $row)
 
   165         {
 
   167         {
 
   166 			if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
 
   168 			if ($bg == $bg1) $bg = $bg2; else $bg = $bg1;
 
   167             echo "<tr bgcolor='" . $bg . "'><td width='17%'><b>$row->cname</b></td>";    
   169             echo "<tr bgcolor='" . $bg . "'>";
 
       
   170             if ($row->cend)
 
       
   171             {
 
       
   172                 $ce = new DateTime($row->cend);
 
       
   173                 if ((!$row->cauto || is_null($row->cauto)) && $heute > $ce) $class="class='red'"; else $class="";
 
       
   174             }
 
       
   175             else $class="";
 
       
   176             echo "<td width='17%' $class><b>$row->cname<br /></b></td>";    
   168 //            echo "<td>$row->contract_s</td>";    
   177 //            echo "<td>$row->contract_s</td>";    
   169             echo "<td width='22%'>" . nl2br($row->clong) . "</td>";    
   178             echo "<td width='22%'>" . nl2br($row->clong) . "</td>";    
   170             echo "<td>$row->typ</td>";    
   179             echo "<td>$row->typ</td>";    
   171             echo "<td>$row->prod</td>";
 
   180             echo "<td>$row->prod</td>";
 
   172             echo "<td>$row->partfirma</td>";
 
   181             echo "<td>$row->partfirma</td>";
IQM