83 { |
83 { |
84 $bg1 = "#F8F8F8"; |
84 $bg1 = "#F8F8F8"; |
85 $bg2 = "#DEDFE1"; |
85 $bg2 = "#DEDFE1"; |
86 $bg = "#FFFFFF"; |
86 $bg = "#FFFFFF"; |
87 |
87 |
|
88 $heute = new DateTime(); |
|
89 |
88 $vanz = $dbc -> querySingleItem("SELECT @anz"); |
90 $vanz = $dbc -> querySingleItem("SELECT @anz"); |
89 $ganz = $dbc -> querySingleItem("SELECT @ganz"); |
91 $ganz = $dbc -> querySingleItem("SELECT @ganz"); |
90 |
92 |
91 echo "<div align='center'>\n"; |
93 echo "<div align='center'>\n"; |
92 echo "<p><b>Verträge Teil 2</b></p>\n"; |
94 echo "<p><b>Verträge Teil 2</b></p>\n"; |
121 echo "<td><a href='vertrag_upd.php?uid=$cid'><img src=\"img/edit.gif\" alt='edit' title='edit' border='0'/></a></td></tr>\n"; |
123 echo "<td><a href='vertrag_upd.php?uid=$cid'><img src=\"img/edit.gif\" alt='edit' title='edit' border='0'/></a></td></tr>\n"; |
122 } |
124 } |
123 if ($row->contract_ID != $cid) |
125 if ($row->contract_ID != $cid) |
124 { // Anzeigen der nur einmal relevanten Daten |
126 { // Anzeigen der nur einmal relevanten Daten |
125 if ($bg == $bg1) $bg = $bg2; else $bg = $bg1; |
127 if ($bg == $bg1) $bg = $bg2; else $bg = $bg1; |
126 echo "<tr bgcolor='" . $bg . "'><td><b>$row->cname</b></td>"; |
128 if ($row->cend) |
|
129 { |
|
130 $ce = new DateTime($row->cend); |
|
131 if ((!$row->cautoend || is_null($row->cautoend)) && $heute > $ce) $class="class='red'"; else $class=""; |
|
132 } |
|
133 else $class=""; |
|
134 echo "<tr bgcolor='" . $bg . "'><td $class><b>$row->cname</b></td>"; |
127 // echo "<td>$row->contract_s</td>"; |
135 // echo "<td>$row->contract_s</td>"; |
128 if ($row->cbegin) |
136 if ($row->cbegin) |
129 { |
137 { |
130 $cb = new DateTime($row->cbegin); |
138 $cb = new DateTime($row->cbegin); |
131 echo "<td>" . $cb->format('d.m.Y')."</td>"; |
139 echo "<td>" . $cb->format('d.m.Y')."</td>"; |
132 } |
140 } |
133 else echo "<td> </td>"; |
141 else echo "<td> </td>"; |
134 if ($row->cend) |
142 if ($row->cend) |
135 { |
|
136 $ce = new DateTime($row->cend); |
|
137 echo "<td>" . $ce->format('d.m.Y')."</td>"; |
143 echo "<td>" . $ce->format('d.m.Y')."</td>"; |
138 } |
|
139 else echo "<td> </td>"; |
144 else echo "<td> </td>"; |
140 if ($row->cautoend) echo "<td>automatisch</td>"; else echo "<td> </td>"; |
145 if ($row->cautoend) echo "<td>automatisch</td>"; else echo "<td> </td>"; |
141 echo "<td class='center'>$row->kmon</td>"; |
146 echo "<td class='center'>$row->kmon</td>"; |
142 // echo "<td>$row->partfirma</td>"; |
147 // echo "<td>$row->partfirma</td>"; |
143 echo "<td>"; |
148 echo "<td>"; |