74 |
74 |
75 $subf = $_POST["subf"]; // submit |
75 $subf = $_POST["subf"]; // submit |
76 |
76 |
77 if (!isset($dbc) || !$dbc) $dbc = new dbconnection(); |
77 if (!isset($dbc) || !$dbc) $dbc = new dbconnection(); |
78 |
78 |
79 $sql = "SELECT 1, telefon_nr, telefon_typ, geb_ID, raum_nr FROM Telefon t LEFT OUTER JOIN Raum r ON t.raum_ID = r.raum_ID"; |
79 // $sql = "SELECT 1, telefon_nr, telefon_typ, geb_ID, raum_nr FROM Telefon t LEFT OUTER JOIN Raum r ON t.raum_ID = r.raum_ID"; |
|
80 $sql = "SELECT 1, telefon_nr, telefon_typ FROM Telefon"; |
80 if (strtoupper($filter) == "NULL") $wher = " WHERE ". $fieldf[$fnum] . " IS NULL "; |
81 if (strtoupper($filter) == "NULL") $wher = " WHERE ". $fieldf[$fnum] . " IS NULL "; |
81 elseif ($filter) $wher = " WHERE " . $fieldf[$fnum] . " LIKE " . "'%$filter%'"; |
82 elseif ($filter) $wher = " WHERE " . $fieldf[$fnum] . " LIKE " . "'%$filter%'"; |
82 else $wher = ""; |
83 else $wher = ""; |
83 if ($sort == 4) $sort = "4,5"; |
84 // if ($sort == 4) $sort = "4,5"; |
84 if ($sort) $ord = " ORDER BY $sort "; |
85 if ($sort) $ord = " ORDER BY $sort "; |
85 $sql .= $wher . $ord; |
86 $sql .= $wher . $ord; |
86 $ianz = $dbc -> numrows($sql); // Anzahl DS |
87 $ianz = $dbc -> numrows($sql); // Anzahl DS |
87 $sql .= "LIMIT $start,$zeil"; |
88 $sql .= "LIMIT $start,$zeil"; |
88 |
89 |
125 echo "</select></td>\n"; |
126 echo "</select></td>\n"; |
126 echo "<td><input class=\"button\" type=\"submit\" value=\"finden\" name=\"subf\" title=\"subf\" /></td></tr></table>\n"; |
127 echo "<td><input class=\"button\" type=\"submit\" value=\"finden\" name=\"subf\" title=\"subf\" /></td></tr></table>\n"; |
127 echo "</form>\n"; |
128 echo "</form>\n"; |
128 echo "<p> </p>\n"; |
129 echo "<p> </p>\n"; |
129 } |
130 } |
130 echo "<table width='30%'>\n"; |
131 echo "<table width='15%'>\n"; |
131 if ($filter>'!') echo "<tr><td class='bigger' colspan=6>Filter: ". $fields["$fnum"] . " wie '$filter'</td></tr>\n"; |
132 if ($filter>'!') echo "<tr><td class='bigger' colspan=6>Filter: ". $fields["$fnum"] . " wie '$filter'</td></tr>\n"; |
132 |
133 |
133 // Listenkopf generieren |
134 // Listenkopf generieren |
134 echo "<tr bgcolor='#68ACBF'>"; |
135 echo "<tr bgcolor='#68ACBF'>"; |
135 tab_column(2,"Nummer",$sort,$dir,2,$fnum,$filter,$start,$zeil); |
136 tab_column(2,"Nummer",$sort,$dir,2,$fnum,$filter,$start,$zeil); |
136 tab_column(3,"Typ",$sort,$dir,3,$fnum,$filter,$start,$zeil); |
137 tab_column(3,"Typ",$sort,$dir,3,$fnum,$filter,$start,$zeil); |
137 tab_column(4,"Haus",$sort,$dir,4,$fnum,$filter,$start,$zeil); |
138 // tab_column(4,"Haus",$sort,$dir,4,$fnum,$filter,$start,$zeil); |
138 tab_column(5,"Raum",$sort,$dir,5,$fnum,$filter,$start,$zeil); |
139 // tab_column(5,"Raum",$sort,$dir,5,$fnum,$filter,$start,$zeil); |
139 echo "<th> </th>"; |
140 echo "<th> </th>"; |
140 echo "</tr>\n"; |
141 echo "</tr>\n"; |
141 foreach ($result as $row) |
142 foreach ($result as $row) |
142 { |
143 { |
143 if ($bg == $bg1) $bg = $bg2; else $bg = $bg1; |
144 if ($bg == $bg1) $bg = $bg2; else $bg = $bg1; |
144 echo "<tr bgcolor='$bg'><td>$row->telefon_nr</td>"; |
145 echo "<tr bgcolor='$bg'><td>$row->telefon_nr</td>"; |
145 $tt = ($row->telefon_typ == "fax")? strtoupper($row->telefon_typ) : $row->telefon_typ; |
146 $tt = ($row->telefon_typ == "fax")? strtoupper($row->telefon_typ) : $row->telefon_typ; |
146 echo "<td>$tt</td>"; |
147 echo "<td>$tt</td>"; |
147 echo "<td>$row->geb_ID</td>"; |
148 // echo "<td>$row->geb_ID</td>"; |
148 echo "<td>$row->raum_nr</td>"; |
149 // echo "<td>$row->raum_nr</td>"; |
149 echo "<td><a href='/fhiiqm/tel_ed.php?i=".urlencode($row->telefon_nr).$getp."'><img src=\"/fhiiqm/img/edit.gif\" alt='edit' title='edit' border='0'/></a></td>"; |
150 echo "<td><a href='/fhiiqm/tel_ed.php?i=".urlencode($row->telefon_nr).$getp."'><img src=\"/fhiiqm/img/edit.gif\" alt='edit' title='edit' border='0'/></a></td>"; |
150 echo "</tr>\n"; |
151 echo "</tr>\n"; |
151 } |
152 } |
152 echo "</table></div>\n"; |
153 echo "</table></div>\n"; |
153 echo "<br /> "; |
154 echo "<br /> "; |