141 } |
141 } |
142 } |
142 } |
143 else |
143 else |
144 { |
144 { |
145 $sql = "SELECT km.keytyp_ID, key_level, pers_anz AS anzahl,pers_date, pers_bem, |
145 $sql = "SELECT km.keytyp_ID, key_level, pers_anz AS anzahl,pers_date, pers_bem, |
146 CONCAT(TRIM(nachname), ', ',vorname,' (',CASE aktiv WHEN 0 THEN 'inaktiv' ELSE 'aktiv' END, ')') AS nvname, |
146 CONCAT (nachname, ', ',vorname, ', ' , IFNULL(abt_name,''),' (',CASE aktiv WHEN 0 THEN 'inaktiv' ELSE 'aktiv' END, ')') AS nvname, |
147 (CASE WHEN pers_action = 'get' THEN 'erhalten' WHEN pers_action = 'out' THEN 'zurück' ELSE 'verloren' END) AS status |
147 (CASE WHEN pers_action = 'get' THEN 'erhalten' WHEN pers_action = 'out' THEN 'zurück' ELSE 'verloren' END) AS status |
148 FROM fhiiqm.Mitarbeiter m |
148 FROM fhiiqm.Mitarbeiter m |
149 INNER JOIN Keytyp_MA km ON m.persknr=km.persknr |
149 INNER JOIN Keytyp_MA km ON m.persknr=km.persknr |
150 INNER JOIN Keytyp k ON km.keytyp_ID = k.keytyp_ID |
150 INNER JOIN Keytyp k ON km.keytyp_ID = k.keytyp_ID |
|
151 LEFT OUTER JOIN Abteilung a ON m.abt_tel=a.abt_ID |
151 WHERE m.aktiv<2 AND km.keytyp_ID = '".$ky["kt"]. |
152 WHERE m.aktiv<2 AND km.keytyp_ID = '".$ky["kt"]. |
152 "' ORDER BY nvname, pers_date"; |
153 "' ORDER BY nvname, pers_date"; |
153 if ($result = $dbc -> queryObjectArray($sql)) |
154 if ($result = $dbc -> queryObjectArray($sql)) |
154 { |
155 { |
155 $sql = "SELECT key_level FROM Keytyp WHERE keytyp_ID = '".$ky["kt"]."'"; |
156 $sql = "SELECT key_level FROM Keytyp WHERE keytyp_ID = '".$ky["kt"]."'"; |
157 echo "<p><b>'$keylevel' - '".$ky["kt"]."' -> Mitarbeiter</b></p>\n"; |
158 echo "<p><b>'$keylevel' - '".$ky["kt"]."' -> Mitarbeiter</b></p>\n"; |
158 $bg1 = "#F8F8F8"; |
159 $bg1 = "#F8F8F8"; |
159 $bg2 = "#DEDFE1"; |
160 $bg2 = "#DEDFE1"; |
160 $bg = "#FFFFFF"; |
161 $bg = "#FFFFFF"; |
161 echo "<table width='40%' border='0' cellspacing='2' cellpadding='2'>\n"; |
162 echo "<table width='40%' border='0' cellspacing='2' cellpadding='2'>\n"; |
162 echo "<tr bgcolor='#68ACBF'><th>Mitarbeiter</th><th>Anzahl</th><th>Status</th><th>Datum</th><th>Bemerkung</th></tr>\n"; |
163 echo "<tr bgcolor='#68ACBF'><th>Mitarbeiter, Abteilung</th><th>Anzahl</th><th>Status</th><th>Datum</th><th>Bemerkung</th></tr>\n"; |
163 foreach ($result as $row) |
164 foreach ($result as $row) |
164 { |
165 { |
165 if ($bg == $bg1) $bg = $bg2; else $bg = $bg1; |
166 if ($bg == $bg1) $bg = $bg2; else $bg = $bg1; |
166 $dat = new DateTime($row->pers_date); |
167 $dat = new DateTime($row->pers_date); |
167 echo "<tr bgcolor='" . $bg . "'><td>$row->nvname</td><td class='right'>$row->anzahl</td><td>$row->status</td><td>".$dat->format("d.m.Y")."</td> |
168 echo "<tr bgcolor='" . $bg . "'><td>$row->nvname</td><td class='right'>$row->anzahl</td><td>$row->status</td><td>".$dat->format("d.m.Y")."</td> |