| changeset 40 | 6f4b105daa24 |
| parent 39 | 4ce411ed28b6 |
| child 41 | 9c668cd391fa |
| 39:4ce411ed28b6 | 40:6f4b105daa24 |
|---|---|
105 else |
105 else |
106 { |
106 { |
107 echo "<div align='center'>\n"; |
107 echo "<div align='center'>\n"; |
108 if ($ky["persknr"]) |
108 if ($ky["persknr"]) |
109 { |
109 { |
110 $sql = "SELECT km.keytyp_ID, key_level, pers_anz AS anzahl,pers_date, pers_bem, |
110 $sql = "SELECT km.keytyp_ID, key_level, pers_anz AS anzahl,pers_date, pers_bem, depot_ID, |
111 (CASE WHEN pers_action = 'get' THEN 'erhalten' WHEN pers_action = 'out' THEN 'zurück' ELSE 'verloren' END) AS status |
111 (CASE WHEN pers_action = 'get' THEN 'erhalten' WHEN pers_action = 'out' THEN 'zurück' ELSE 'verloren' END) AS status |
112 FROM fhiiqm.Mitarbeiter m |
112 FROM fhiiqm.Mitarbeiter m |
113 INNER JOIN Keytyp_MA km ON m.persknr=km.persknr |
113 INNER JOIN Keytyp_MA km ON m.persknr=km.persknr |
114 INNER JOIN Keytyp k ON km.keytyp_ID = k.keytyp_ID |
114 INNER JOIN Keytyp k ON km.keytyp_ID = k.keytyp_ID |
115 WHERE m.aktiv<2 AND m.persknr = ".$ky["persknr"]. |
115 WHERE m.aktiv<2 AND m.persknr = ".$ky["persknr"]. |
119 { |
119 { |
120 echo "<p><b>".$ky["ma"]." -> Schlüssel</b></p>\n"; |
120 echo "<p><b>".$ky["ma"]." -> Schlüssel</b></p>\n"; |
121 $bg1 = "#F8F8F8"; |
121 $bg1 = "#F8F8F8"; |
122 $bg2 = "#DEDFE1"; |
122 $bg2 = "#DEDFE1"; |
123 $bg = "#FFFFFF"; |
123 $bg = "#FFFFFF"; |
124 echo "<table width='35%' border='0' cellspacing='2' cellpadding='2'>\n"; |
124 echo "<table width='40%' border='0' cellspacing='2' cellpadding='2'>\n"; |
125 echo "<tr bgcolor='#68ACBF'><th>Schlüssel</th><th>Anzahl</th><th>Status</th><th>Datum</th><th>Bemerkung</th></tr>\n"; |
125 echo "<tr bgcolor='#68ACBF'><th>Schlüssel</th><th>Anzahl</th><th>Status</th><th>Datum</th><th>von/an Depot</th><th>Bemerkung</th></tr>\n"; |
126 foreach ($result as $row) |
126 foreach ($result as $row) |
127 { |
127 { |
128 if ($bg == $bg1) $bg = $bg2; else $bg = $bg1; |
128 if ($bg == $bg1) $bg = $bg2; else $bg = $bg1; |
129 $dat = new DateTime($row->pers_date); |
129 $dat = new DateTime($row->pers_date); |
130 echo "<tr bgcolor='" . $bg . "'><td>$row->key_level - $row->keytyp_ID</td><td class='right'>$row->anzahl</td><td>$row->status</td><td>".$dat->format("d.m.Y")."</td> |
130 echo "<tr bgcolor='" . $bg . "'><td>$row->key_level - $row->keytyp_ID</td><td class='right'>$row->anzahl</td><td>$row->status</td><td>".$dat->format("d.m.Y")."</td> |
131 <td>".nl2br($row->pers_bem)."</td></tr>\n"; |
131 <td>$row->depot_ID</td><td>".nl2br($row->pers_bem)."</td></tr>\n"; |
132 } |
132 } |
133 echo "</table>\n"; |
133 echo "</table>\n"; |
134 echo "</div>\n"; |
134 echo "</div>\n"; |
135 } |
135 } |
136 else |
136 else |
140 echo "<br /> "; |
140 echo "<br /> "; |
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, depot_ID, |
146 CONCAT (nachname, ', ',vorname, ', ' , IFNULL(abt_name,''),' (',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 |
158 echo "<p><b>'$keylevel' - '".$ky["kt"]."' -> Mitarbeiter</b></p>\n"; |
158 echo "<p><b>'$keylevel' - '".$ky["kt"]."' -> Mitarbeiter</b></p>\n"; |
159 $bg1 = "#F8F8F8"; |
159 $bg1 = "#F8F8F8"; |
160 $bg2 = "#DEDFE1"; |
160 $bg2 = "#DEDFE1"; |
161 $bg = "#FFFFFF"; |
161 $bg = "#FFFFFF"; |
162 echo "<table width='40%' border='0' cellspacing='2' cellpadding='2'>\n"; |
162 echo "<table width='40%' border='0' cellspacing='2' cellpadding='2'>\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 echo "<tr bgcolor='#68ACBF'><th>Mitarbeiter, Abteilung</th><th>Anzahl</th><th>Status</th><th>Datum</th><th>von/an Depot</th><th>Bemerkung</th></tr>\n"; |
164 foreach ($result as $row) |
164 foreach ($result as $row) |
165 { |
165 { |
166 if ($bg == $bg1) $bg = $bg2; else $bg = $bg1; |
166 if ($bg == $bg1) $bg = $bg2; else $bg = $bg1; |
167 $dat = new DateTime($row->pers_date); |
167 $dat = new DateTime($row->pers_date); |
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> |
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> |
169 <td>".nl2br($row->pers_bem)."</td></tr>\n"; |
169 <td>$row->depot_ID</td><td>".nl2br($row->pers_bem)."</td></tr>\n"; |
170 } |
170 } |
171 echo "</table>\n"; |
171 echo "</table>\n"; |
172 echo "</div>\n"; |
172 echo "</div>\n"; |
173 } |
173 } |
174 else |
174 else |