3 concat('uid=',trim(userid),',ou=',categorycode,',dc=ffzg,dc=hr') as dn,
7 hrEduPerson' as objectClass,
10 firstname as givenName,
12 concat(firstname,' ',surname) as cn,
14 -- SAFEQ specific mappings from UMgr-LDAP.conf
15 b.borrowernumber as objectGUID,
16 surname as displayName,
19 when email regexp '@ffzg.hr' then email
20 when emailpro regexp '@ffzg.hr' then emailpro
24 categorycode as memberOf,
26 categorycode as department,
27 concat('/home/',b.borrowernumber) as homeDirectory
29 left join borrower_attributes a on b.borrowernumber = a.borrowernumber and code='RFID_SID'