| changeset 44 | d652bbba2d43 |
| parent 41 | 9c668cd391fa |
| 43:70cea8f0e807 | 44:d652bbba2d43 |
|---|---|
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, depot_ID, |
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, IFNULL(CONCAT(', ',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 LEFT OUTER JOIN Abteilung a ON m.abt_tel=a.abt_ID |